Office 2016 - myitlab:grader - Instructions Excel Project EX16_XL_CH04_GRADER_CAP_AS - Mountain View Realty 1.3 Project Description: You work at Mountain View Realty. A coworker developed a spreadsheet cataloging houses listed and sold during the past several months. She included addresses, location, list price, selling price, listing date, and date sold. You want to convert the data to a table. You will manage the large worksheet, prepare the worksheet for printing, sort and filter the table, include calculations, and then format the table. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Open the downloaded file exploring_e04_grader_a1.xlsx. 0.000 2 Freeze the first row on the Sales Data worksheet. 5.000 3 Convert the data to a table and apply the Table Style Medium 17. 6.000 4 Remove duplicate records. 2.000 5 Insert a new field to the right of the Selling Price field. Name the new field Percent of List Price. 2.000 6 Create a formula with structured references to calculate the percentage of the list price. 5.000 7 Format the field with Percent Style with one decimal place. 3.000 8 Insert a new field to the right of the Sale Date field. Name the new field Days on Market. 2.000 9 Create a formula with structured references to calculate the number of days on the market. Apply the General number format to the values. 6.000 10 Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row. 5.000 Updated: 08/28/2017 1 Current_Instruction.docx Office 2016 - myitlab:grader - Instructions Step Excel Project Points Possible Instructions 11 Sort the table by city in alphabetical order and add a second level to sort by days on market with the houses on the market the longest at the top within each city. 7.000 12 Adjust column widths so that all data is visible. Wrap the column labels. 5.000 13 Repeat the field names on all pages. 4.000 14 Add a page break at Row 36 so that city data does not span between pages, and change back to Normal view. 6.000 15 Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. 2.000 16 Display the Filtered Data worksheet. Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain. 5.000 17 Filter the data to display records for houses that were on the market 30 days or more. 5.000 18 Apply the conditional formatting 3 Arrows (Colored) icon set to the Days on Market values. 7.000 19 Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices. 7.000 20 Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column. 7.000 21 Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side. 5.000 22 Select Landscape orientation and set appropriate margins so that the data will print on one page. 4.000 23 Save and close the file. Submit the file as directed. 0.000 Total Points Updated: 08/28/2017 2 100.000 Current_Instruction.docx Office 2016 - myitlab:grader - Instructions Updated: 08/28/2017 Excel Project 3 Current_Instruction.docx Number 1 2 3 4 5 6 7 8 9 10 10 11 12 13 14 15 16 17 18 19 20 20 21 22 23 24 25 26 27 28 29 30 30 31 32 33 34 35 Address City 8687 Kenwood Road Cedar Hills 11 West Oak Circle American Fork 314 Timp View Drive American Fork 614 West Cedar Drive Lehi 750 South Apple Way American Fork 7 Kingston Court Alpine 618 West Cedar Drive Lehi 321 North Choctaw American Fork 1370 Pinellas Road Alpine 1971 Glenview Road Lehi 1971 Glenview Road Lehi 15 West Oak Circle American Fork 575 South Choctaw Alpine 10995 SW 88 Court Lehi 143 North Mountain View American Fork 29 East Oak Circle American Fork 8030 Steeplechase Drive Alpine 2006 Cutwater Court Alpine 9876 South Sunset AvenueEagle Mountain 321 West Walnut Grove American Fork 4081 Lybyer Avenue Alpine 4081 Lybyer Avenue Alpine 1900 Glenview Road Lehi 9000 South Sunset AvenueEagle Mountain 8432 South Sunset AvenueEagle Mountain 831 South Weber American Fork 714 Timp View Lane American Fork 240 East Jefferson Way Eagle Mountain 224 Rockaway Street Alpine 260 East Jefferson Way Eagle Mountain 290 East Jefferson Way Eagle Mountain 8307 S Indian River Drive Lehi 8307 S Indian River Drive Lehi 123 Ivy Lane Eagle Mountain 9408 Forest Hills Circle Cedar Hills 245 Ivy Lane Eagle Mountain 11971 SW 269 Terrace Cedar Hills 1857 Pine Drive Cedar Hills Selling Agent Hernandez Carey Goodrich Lugo Goodrich Carey Lugo Minkus Lugo Minkus Minkus Hernandez Goodrich Goodrich Carey Merkin Merkin Minkus Hernandez Goodrich Minkus Minkus Hernandez Lugo Minkus Lugo Goodrich Lugo Pijuan Hernandez Pijuan Hernandez Hernandez Pijuan Reuter Goodrich Carey Hernandez $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ List Price 725,000 350,000 418,000 215,800 385,900 500,000 300,000 565,000 219,000 165,000 165,000 325,000 750,250 110,000 314,250 555,000 450,000 345,000 300,000 425,000 325,000 325,000 325,000 325,000 285,750 425,815 250,000 515,000 400,000 450,000 310,000 250,000 250,000 375,500 185,500 395,000 410,000 560,700 Selling Price Listing Date Sale Date $ 645,250 4/1/2012 6/16/2012 $ 340,000 4/1/2012 5/15/2012 $ 400,000 4/1/2012 6/1/2012 $ 200,000 4/1/2012 5/25/2012 $ 385,900 4/1/2012 4/30/2012 $ 465,000 4/3/2012 6/10/2012 $ 290,000 4/3/2012 6/1/2012 $ 535,000 4/6/2012 9/30/2012 $ 215,000 4/8/2012 6/2/2012 $ 156,750 4/12/2012 6/12/2012 $ 156,750 4/12/2012 6/12/2012 $ 320,000 4/12/2012 5/30/2012 $ 700,000 4/12/2012 11/1/2012 $ 106,000 4/12/2012 7/3/2012 $ 304,000 4/13/2012 8/5/2012 $ 500,000 4/13/2012 10/15/2012 $ 382,500 4/15/2012 6/30/2012 $ 339,999 4/18/2012 6/23/2012 $ 300,000 4/18/2012 4/30/2012 $ 415,000 4/18/2012 6/30/2012 $ 308,750 4/19/2012 7/2/2012 $ 308,750 4/19/2012 7/2/2012 $ 302,250 4/28/2012 6/1/2012 $ 320,000 4/28/2012 5/28/2012 $ 300,000 4/28/2012 6/3/2012 $ 400,000 4/28/2012 9/15/2012 $ 232,000 4/29/2012 9/1/2012 $ 485,750 4/29/2012 8/25/2012 $ 375,000 4/30/2012 6/19/2012 $ 400,000 4/30/2012 10/1/2012 $ 300,000 4/30/2012 7/1/2012 $ 255,000 5/1/2012 6/18/2012 $ 255,000 5/1/2012 6/18/2012 $ 375,500 5/1/2012 5/5/2012 $ 179,000 5/1/2012 6/6/2012 $ 375,000 5/1/2012 7/16/2012 $ 397,700 5/1/2012 6/26/2012 $ 550,000 5/1/2012 5/30/2012 36 37 38 39 40 40 41 42 43 44 45 46 47 48 49 50 50 51 52 53 54 55 56 57 58 59 60 60 61 62 63 64 65 66 67 68 69 70 70 3461 East Lindon Way 16235 Orange Boulevard 614 Lincoln Drive 2448 Woodacres Road 401 Pinecone Circle 401 Pinecone Circle 421 Ivy Lane 765 East Sheridan Lane 61 East Walnut Grove 1414 N Sheridan Road 487 Blue Skies Drive 10700 Lake Shore Lane 73 East Oak Street 81 Island Drive South 3412 Kilmer Street 605 Reservoir Drive 605 Reservoir Drive 77 East Oak Street 400 Ivy Lane 1 Southampton Place 3418 North Sunset Lane 1892 North 250 West 1629 NW 43rd Street 3400 North Sunset Lane 876 South California Way 21 Compass Road 34 West Oakley Drive 34 West Oakley Drive 30 Kent Road 140 East 3rd Street 160 West 5th Street 240 West 5th Street 520 E Spring Street 678 Mountain Circle 3490 North Sunset Lane 4916 Rock Spring Road 8923 Harris Drive 876 West Hadley Way 876 West Hadley Way American Fork Cedar Hills Eagle Mountain Lehi Alpine Alpine Eagle Mountain Eagle Mountain American Fork Alpine American Fork Cedar Hills Eagle Mountain Alpine Lehi Alpine Alpine Eagle Mountain Eagle Mountain Lehi Eagle Mountain American Fork Cedar Hills Eagle Mountain American Fork Cedar Hills American Fork American Fork Lehi Eagle Mountain Eagle Mountain Eagle Mountain Alpine American Fork Eagle Mountain Cedar Hills Alpine American Fork American Fork Reuter Lugo Reuter Hernandez Goodrich Goodrich Pijuan Minkus Goodrich Pijuan Goodrich Carey Merkin Bethune Carey Reuter Reuter Bethune Bethune Goodrich Bethune Carey Carey Merkin Hen Merkin Carey Carey Bethune Hen Carey Reuter Minkus Goodrich Minkus Lugo Minkus Hernandez Hernandez $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 450,000 395,000 475,000 450,000 1,500,120 1,500,120 500,000 460,750 375,000 1,250,000 365,750 650,000 325,000 147,800 180,000 310,000 310,000 345,000 375,000 215,000 450,000 315,250 475,000 400,000 316,000 289,900 345,000 345,000 259,900 399,000 410,000 285,750 189,900 335,000 250,000 275,000 589,000 345,670 345,670 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 400,000 380,000 425,250 382,500 1,400,000 1,400,000 425,000 435,500 376,000 1,225,000 355,000 598,000 325,000 150,000 175,000 291,400 291,400 335,000 330,000 195,000 400,000 300,000 450,000 375,000 316,000 279,000 330,000 330,000 246,905 350,000 350,750 300,000 186,102 330,000 275,000 264,000 575,000 345,000 345,000 5/2/2012 9/30/2012 5/5/2012 7/16/2012 5/5/2012 9/23/2012 5/5/2012 6/16/2012 5/5/2012 9/30/2012 5/5/2012 9/30/2012 5/5/2012 11/15/2012 5/5/2012 11/1/2012 5/6/2012 5/15/2012 5/12/2012 6/6/2012 5/13/2012 8/15/2012 5/15/2012 6/9/2012 5/18/2012 5/31/2012 5/22/2012 6/16/2012 5/23/2012 7/15/2012 5/22/2012 6/29/2012 5/22/2012 6/29/2012 5/23/2012 6/23/2012 5/26/2012 8/30/2012 5/28/2012 6/18/2012 5/28/2012 8/15/2012 5/28/2012 8/1/2012 5/31/2012 8/19/2012 5/31/2012 7/15/2012 5/31/2012 6/30/2012 5/31/2012 6/1/2012 6/1/2012 8/15/2012 6/1/2012 8/15/2012 6/2/2012 9/2/2012 6/2/2012 11/30/2012 6/3/2012 10/15/2012 6/5/2012 7/1/2012 6/6/2012 7/26/2012 6/10/2012 9/15/2012 6/12/2012 6/25/2012 6/13/2012 7/21/2012 6/18/2012 7/8/2012 6/20/2012 9/30/2012 6/20/2012 9/30/2012 71 72 73 74 75 76 77 78 79 80 80 81 1132 SW 52nd Street 416 East Oak 10 Vestal Drive 425 East Oak 876 West Holiday 103 Jasper Drive 516 East Oak 123 Oak Avenue 600 Ivy Lane 144 Oak Avenue 144 Oak Avenue 1600 Reeves Street Cedar Hills Eagle Mountain Cedar Hills Eagle Mountain Alpine Lehi Eagle Mountain American Fork Eagle Mountain American Fork American Fork Cedar Hills Hernandez Merkin Carey Bethune Goodrich Bethune Pijuan Carey Pijuan Goodrich Goodrich Reuter $ $ $ $ $ $ $ $ $ $ $ $ 254,500 300,000 555,000 275,900 475,000 165,900 299,999 400,000 339,999 380,500 380,500 245,900 $ $ $ $ $ $ $ $ $ $ $ $ 236,685 250,000 565,000 250,000 455,000 159,264 280,000 400,000 310,000 365,000 365,000 233,605 6/23/2012 6/23/2012 6/24/2012 6/24/2012 6/24/2012 6/29/2012 6/29/2012 6/30/2012 6/30/2012 6/30/2012 6/30/2012 6/30/2012 9/21/2012 11/2/2012 6/30/2012 8/15/2012 9/18/2012 9/6/2012 9/30/2012 7/15/2012 10/1/2012 9/1/2012 9/1/2012 8/16/2012 Number 12 40 75 16 20 6 17 9 27 65 50 44 48 69 15 8 36 24 25 14 70 66 45 60 19 55 80 3 11 2 58 5 78 43 71 56 1 37 34 81 68 32 35 46 73 59 41 62 42 28 38 63 72 26 52 Address 575 South Choctaw 401 Pinecone Circle 876 West Holiday 8030 Steeplechase Drive 4081 Lybyer Avenue 7 Kingston Court 2006 Cutwater Court 1370 Pinellas Road 224 Rockaway Street 520 E Spring Street 605 Reservoir Drive 1414 N Sheridan Road 81 Island Drive South 8923 Harris Drive 29 East Oak Circle 321 North Choctaw 3461 East Lindon Way 831 South Weber 714 Timp View Lane 143 North Mountain View 876 West Hadley Way 678 Mountain Circle 487 Blue Skies Drive 34 West Oakley Drive 321 West Walnut Grove 1892 North 250 West 144 Oak Avenue 314 Timp View Drive 15 West Oak Circle 11 West Oak Circle 876 South California Way 750 South Apple Way 123 Oak Avenue 61 East Walnut Grove 1132 SW 52nd Street 1629 NW 43rd Street 8687 Kenwood Road 16235 Orange Boulevard 11971 SW 269 Terrace 1600 Reeves Street 4916 Rock Spring Road 9408 Forest Hills Circle 1857 Pine Drive 10700 Lake Shore Lane 10 Vestal Drive 21 Compass Road 421 Ivy Lane 140 East 3rd Street 765 East Sheridan Lane 260 East Jefferson Way 614 Lincoln Drive 160 West 5th Street 416 East Oak 240 East Jefferson Way 400 Ivy Lane City Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine Alpine American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork American Fork Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Cedar Hills Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Selling Agent Goodrich Goodrich Goodrich Merkin Minkus Carey Minkus Lugo Pijuan Minkus Reuter Pijuan Bethune Minkus Merkin Minkus Reuter Lugo Goodrich Carey Hernandez Goodrich Goodrich Carey Goodrich Carey Goodrich Goodrich Hernandez Carey Hen Goodrich Carey Goodrich Hernandez Carey Hernandez Lugo Carey Reuter Lugo Reuter Hernandez Carey Carey Merkin Pijuan Hen Minkus Hernandez Reuter Carey Merkin Lugo Bethune List Price Selling Price $ 750,250 $ 1,500,120 $ 475,000 $ 450,000 $ 325,000 $ 500,000 $ 345,000 $ 219,000 $ 400,000 $ 189,900 $ 310,000 $ 1,250,000 $ 147,800 $ 589,000 $ 555,000 $ 565,000 $ 450,000 $ 425,815 $ 250,000 $ 314,250 $ 345,670 $ 335,000 $ 365,750 $ 345,000 $ 425,000 $ 315,250 $ 380,500 $ 418,000 $ 325,000 $ 350,000 $ 316,000 $ 385,900 $ 400,000 $ 375,000 $ 254,500 $ 475,000 $ 725,000 $ 395,000 $ 410,000 $ 245,900 $ 275,000 $ 185,500 $ 560,700 $ 650,000 $ 555,000 $ 289,900 $ 500,000 $ 399,000 $ 460,750 $ 450,000 $ 475,000 $ 410,000 $ 300,000 $ 515,000 $ 375,000 $ 700,000 $ 1,400,000 $ 455,000 $ 382,500 $ 308,750 $ 465,000 $ 339,999 $ 215,000 $ 375,000 $ 186,102 $ 291,400 $ 1,225,000 $ 150,000 $ 575,000 $ 500,000 $ 535,000 $ 400,000 $ 400,000 $ 232,000 $ 304,000 $ 345,000 $ 330,000 $ 355,000 $ 330,000 $ 415,000 $ 300,000 $ 365,000 $ 400,000 $ 320,000 $ 340,000 $ 316,000 $ 385,900 $ 400,000 $ 376,000 $ 236,685 $ 450,000 $ 645,250 $ 380,000 $ 397,700 $ 233,605 $ 264,000 $ 179,000 $ 550,000 $ 598,000 $ 565,000 $ 279,000 $ 425,000 $ 350,000 $ 435,500 $ 400,000 $ 425,250 $ 350,750 $ 250,000 $ 485,750 $ 330,000 77 516 East Oak 79 600 Ivy Lane 54 3418 North Sunset Lane 33 245 Ivy Lane 29 290 East Jefferson Way 74 425 East Oak 57 3400 North Sunset Lane 23 8432 South Sunset Avenue 51 77 East Oak Street 22 9000 South Sunset Avenue 64 240 West 5th Street 47 73 East Oak Street 67 3490 North Sunset Lane 18 9876 South Sunset Avenue 31 123 Ivy Lane 61 30 Kent Road 13 10995 SW 88 Court 76 103 Jasper Drive 10 1971 Glenview Road 7 618 West Cedar Drive 4 614 West Cedar Drive 49 3412 Kilmer Street 30 8307 S Indian River Drive 39 2448 Woodacres Road 21 1900 Glenview Road 53 1 Southampton Place Averages Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Eagle Mountain Lehi Lehi Lehi Lehi Lehi Lehi Lehi Lehi Lehi Lehi Lehi Pijuan Pijuan Bethune Goodrich Pijuan Bethune Merkin Minkus Bethune Lugo Reuter Merkin Minkus Hernandez Pijuan Bethune Goodrich Bethune Minkus Lugo Lugo Carey Hernandez Hernandez Hernandez Goodrich $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 299,999 339,999 450,000 395,000 310,000 275,900 400,000 285,750 345,000 325,000 285,750 325,000 250,000 300,000 375,500 259,900 110,000 165,900 165,000 300,000 215,800 180,000 250,000 450,000 325,000 215,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 280,000 310,000 400,000 375,000 300,000 250,000 375,000 300,000 335,000 320,000 300,000 325,000 275,000 300,000 375,500 246,905 106,000 159,264 156,750 290,000 200,000 175,000 255,000 382,500 302,250 195,000 Percent of Listing Date List Price Err:509 4/12/2018 Err:509 5/5/2018 Err:509 6/24/2018 Err:509 4/15/2018 Err:509 4/19/2018 Err:509 4/3/2018 Err:509 4/18/2018 Err:509 4/8/2018 Err:509 4/30/2018 Err:509 6/6/2018 Err:509 5/22/2018 Err:509 5/12/2018 Err:509 5/22/2018 Err:509 6/18/2018 Err:509 4/13/2018 Err:509 4/6/2018 Err:509 5/2/2018 Err:509 4/28/2018 Err:509 4/29/2018 Err:509 4/13/2018 Err:509 6/20/2018 Err:509 6/10/2018 Err:509 5/13/2018 Err:509 6/1/2018 Err:509 4/18/2018 Err:509 5/28/2018 Err:509 6/30/2018 Err:509 4/1/2018 Err:509 4/12/2018 Err:509 4/1/2018 Err:509 5/31/2018 Err:509 4/1/2018 Err:509 6/30/2018 Err:509 5/6/2018 Err:509 6/23/2018 Err:509 5/31/2018 Err:509 4/1/2018 Err:509 5/5/2018 Err:509 5/1/2018 Err:509 6/30/2018 Err:509 6/13/2018 Err:509 5/1/2018 Err:509 5/1/2018 Err:509 5/15/2018 Err:509 6/24/2018 Err:509 5/31/2018 Err:509 5/5/2018 Err:509 6/2/2018 Err:509 5/5/2018 Err:509 4/30/2018 Err:509 5/5/2018 Err:509 6/3/2018 Err:509 6/23/2018 Err:509 4/29/2018 Err:509 5/26/2018 Sale Date 11/1/2018 9/30/2018 9/18/2018 6/30/2018 7/2/2018 6/10/2018 6/23/2018 6/2/2018 6/19/2018 7/26/2018 6/29/2018 6/6/2018 6/16/2018 7/8/2018 10/15/2018 9/30/2018 9/30/2018 9/15/2018 9/1/2018 8/5/2018 9/30/2018 9/15/2018 8/15/2018 8/15/2018 6/30/2018 8/1/2018 9/1/2018 6/1/2018 5/30/2018 5/15/2018 6/30/2018 4/30/2018 7/15/2018 5/15/2018 9/21/2018 8/19/2018 6/16/2018 7/16/2018 6/26/2018 8/16/2018 7/21/2018 6/6/2018 5/30/2018 6/9/2018 6/30/2018 6/1/2018 11/15/2018 11/30/2018 11/1/2018 10/1/2018 9/23/2018 10/15/2018 11/2/2018 8/25/2018 8/30/2018 Days on Market Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:508 6/29/2018 6/30/2018 5/28/2018 5/1/2018 4/30/2018 6/24/2018 5/31/2018 4/28/2018 5/23/2018 4/28/2018 6/5/2018 5/18/2018 6/12/2018 4/18/2018 5/1/2018 6/2/2018 4/12/2018 6/29/2018 4/12/2018 4/3/2018 4/1/2018 5/23/2018 5/1/2018 5/5/2018 4/28/2018 5/28/2018 9/30/2018 10/1/2018 8/15/2018 7/16/2018 7/1/2018 8/15/2018 7/15/2018 6/3/2018 6/23/2018 5/28/2018 7/1/2018 5/31/2018 6/25/2018 4/30/2018 5/5/2018 9/2/2018 7/3/2018 9/6/2018 6/12/2018 6/1/2018 5/25/2018 7/15/2018 6/18/2018 6/16/2018 6/1/2018 6/18/2018 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:509 Err:508