HI Invoicelu" Contract" InvoiceD Invoiceitem Invoiced: InvoiceF 1011 8111 2/2712021 Indoor alarm system 500.00 TRUE 1012 9111 5/10/2021 Indoor alarm system $ 1,500.00 TRUE 1021 9112 2/25/2021 Front door alarm system $ 830.00 TRUE 1031 9120 4/13/2021 Indoor alarm system | $ 1,000 00 TRUE 1032 9120 8/19/2021 Indoor alarm system 1,000.00 TRUE 1033 9120 9/20/2021 Indoor alarm system # 1,000.00 TRUE 1034 9120 10/20/2021 Indoor alarm sustem TRUE 1041 $ 50,000.00 8115 4/1/2021 Indoor alarm system $ 2.500.00 TRUE 1051 9117 4/1/2021 Indoor alarm system # 1,250.00 TRUE 1061 9126 3/11/2032 Indoor wireless system $ 500.00 TRUE 1062 9126 9/12/2032 Indoor wireless system 1063 $ 1,000 00 FALSE 9126 7/11/2023 Indoor wireless system FALSE 1084 $ 1.000.00 9126 4/4/2023 Indoor wireless system FALSE 1071 # 2500.00 9123 1072 11/22/2021 Indoor and outdoor alarm system,000.00 TRUE 9123 1073 7/22/2022 Indoor and outdoor alarm suste $ 3,000 00 TRUE 9123 9/21/2023 Indoor and outdoor alarm system,000.00 1081 FALSE 9125 1082 7/23/2021 Indoor and outdoor alarm system.00 TRUE 9125 1083 12/20/2021 Indoor and outdoor alarm system.000.00|TRUE 9125 1091 6/24/2023 Indoor and outdoor alarm sgate $ 2,000.00 TRUE 9127 1101 6/7/2021 First floor alarm system]] $ 1,250.00 TRUE 19122 F/14/2021 Indoor alarm system 1 1102 # 500.00 TRUE 9122 11/15/2021 Indoor alarm system $ 500.00 TRUE 1103 9122 7/14/2022 Indoor alarm system 1111 $ 1000.00 TRUE 9121 10/12/2021 Indoor and outdoor alarm system.00|TRUE 1112 9121 11/12/2021 Indoor and outdoor alarm system00.00 TRUE 1113 9121 1114 9/2/2022 Indoor and outdoor alarm system00 FALSE 9121 3/5/2023 Indoor and outdoor alarm system,000.00 FALSE 1121 9134 9/28/2021 Garage system with video $ 1,500.00 TRUE 1123 9134 12/26/2021 Garage system with video $ 1,000.00 TRUE 1131 9135 10/18/2021 Security plan 500.00 TRUE 1132 9135 3/23/2022 Security plan # 1000.60 TRUE 1141 8131 2/3/2022 Indoor and outdoor alarm system00.00 TRUE 1142 9131 6/3/2022 Indoor and outdoor alarm sgate $ 2 000.00 TRUE 1143 19131 10/3/2022 Indoor and outdoor alarm system.000.00 FALSE 1144 3131 8/3/2023 Indoor and outdoor alarm suste # 2.000 00| FALSE |1151 3130 8/11/2021 Indoor and outdoor alarm system 1.250.00 TRUE 1152 9130 10/15/2021 Indoor and outdoor alarm suste $ 2.000.00|TRUE 1 1153 8130 3/30/2022 Indoor and outdoor alarm system,000.00 TRUE 1161 9132 9/10/2021 Security plan 500 00 TRUE 1162 3132 10/12/2021 Security plan 500 00 TRUE 1163 9132 11/12/2021 Security plan $ 500.00 TRUE 1171 9137 2/22/2022 Indoor and outdoor system $ 2.000.00 TRUE 1172 8127 6/22/2022 Indoor and outdoor system 2,000.00 TRUE 1173 3137 2124/2023 Indoor and outdoor system $ 2,000 00 FALSE 1174 9137 3/20/2022 Indoor and outdoor system $ 2,000.00 FALSE 1131 10/22/2021 Indoor system $ 1,090.09 TRUE 1132 12/22/2021 Indoor system 1,000.00 TRUE 1123 3138 6/23/2022 Indoor system 1090.00 TRUE 1134 3132 4/27/2023 Indoor system $ 1,000.00 FALSE 1191 3/28/2021 Indoor wireless system $ 1,250,00 TRUE 1201 #140 1/12/2022 Indoor and outdoor system $ 2.500.00 TRUE 1202 3140 3/26/2022 Indoor and outdoor system # 2.000.00 FALSE 1203 3140 2/26/2022 Indoor and outdoor system # 4,000.00 FALSE 1211 3143 1711/2022 Indoor and outdoor system $ 5,000.00 TRUE 1212 3143 6/20/2022 Indoor and outdoor system $ 2,500.00 TRUE 1213 3143 3/30/2023 Indeer and outdoor system 2.500,00 FALSE 1221 3144 8/17/2022 Indoor and ourdeer system $ 2,500.00 TRUE 1222 9144 5/1/2023 Indoor and outdoor system 2.000.00 FALSE 1231 $145 2/22/2022 Indoor system # 2.500 00 FALSE 1232 9145 3/15/2023 Indoor system $ 2,000.09 FALSE 1241 3150 10/15/2021 Indoor and ourdoor system $ 11,000.go TRUE Documentation Home Page Customers Contracts Invoices eady 5 7 Accessibility: InvestigateHI B 62 1232 9145 $/15/2023 Indoor system $ 2.000 00|FALSE 63 1241 9150 10/13/2021 Indoor and outdoor system # 11000.00|TRUE 64 1251 9146 9/9/2021 Security plan $ 1,300.00 TRUE 65 1261 9153 3725/2021 Front door system 1375.00 TRUE 68 1271 9145 12/28/2021 Safe room 1,500.DO TRUE 87 1272 9148 2/23/2022 Safe room 1,000 00 TRUE 68 1273 9148 6/30/2022 Safe room 1.000.00 TRUE 69 1274 972672022 Safe room 1,000.00 FALSE 70 1281 9156 9/30/2022 Security plan 300.00 FALSE 71 1382 9156 3/14/2023 Security plan 650.00 FALSE 72 1291 8157 1/31/2022 Indoor and outdoor system $ 2,500.00 TRUE 76 1292 19157 6/30/2032 Indoor and outdoor system 2 500.00 TRUE 74 1293 19157 3/30/2023 Indoor and outdoor system 500.00 FALSE 75 1301 9151 3/7/2023 Indoor and outdoor system $ 3.000 00 TRUE 76 1302 9151 7/7/2022 Indoor and outdoor system $ 3,000.00 TRUE 77 1303 9151 5/3/3023 Indoor and outdoor system 2000.00 FALSE 78 1311 9160 12/21/2021 Outdoor system 1,000.00 TRUE 79 1312 9160 5/27/2022 Outdoor system $ 1000.00 TRUE SO 1321 9161 6/26/2022 Outdoor system 800.00 TRUE 81 1322 9161 10/26/2022 Outdoor system 1,000.00 FALSE 82 1323 9161 4/25/2023 Outdoor system $ 1,000.00 FALSE 83 1324 9161 6/27/2022 Outdoor system 1000.00 FALSE 84 1331 9162 6/10/2022 First floor system 500.00 TRUE 85 1362 9162 11/14/2022 First floor system $ 500.00 FALSE 86 1333 9162 5/11/2023 First floor system $ 1,000.00 FALSE 87 1341 9183 3/21/2022 Security plan $ 750 00 TRUE 89 1351 9165 6/3/2022 Indoor and outdoor system $ 2.000.00 TRUE 89| 1352 9165 12/5/2022 Indoor and outdoor system $ 2000.00 FALSE 90 1353 9165 8/3/2023 Indoor and outdoor system $ 2.000.00 FALSE 91 1354 9185 8/1/2022 Indoor and outdoor system 2,000.00 FALSE 92 1361 9168 4/21/2022 Indoor and outdoor system $ 2,000,00 TRUE 93 1862 9168 717/2022 First floor system $ 1,500.00 TRUE 94 1371 9169 6/9/2022 Outdoor system 1.750.00 TRUE 95 1372 9169 7/29/2022 Outdoor system 1,000.00 TRUE 96 |1373 9169 9/23/2022 Outdoor system $ 1,000.00 FALSE 97 1874 9169 10/24/2022 Outdoor system 2,000 00 FALSE 38 1381 9170 9/6/2022 | Indoor system 500.00 FALSE 99 1362 9170 1/8/2022 Indoor system $ 500.00 FALSE 100 1383 9170 11/5/2023 Indoor system $ 1,000.00 FALSE 101 1384 8170 7/8/2022 Indoor system $1,000:00 FALSE 102 1391 9171 12/9/2022 Indoor system $ 2,000.00 FALSE 103 1392 9171 3/12/2023 Indoor system $1000.00 FALSE 104 1393 9171 3/11/2023 Indoor system $ 1,000.00 FALSE 105 1394 3171 3/27/2023 Indoor system $ 3,000 00 FALSE 106 1401 9172 11/10/2022 Indoor system $ 2,000.00 FALSE 107 1402 9172 9/13/2023 Indoor system $ 2,000.00 FALSE 108 1403 9172 9/26/2022 Indoor system! $ 2,000.00 FALSE 109 1411 9175 7/8/2022 Indoor and outdoor system $ 5.500.00 TRUE 110 1412 9175 4/9/2023 Indoor and outdoor system $ 2.500.00 FALSE 111 1413 9175 9/27/2023 Indoor and outdoor system i$ 2,500.00 FALSE 112 1421 3176 6/8/2022 Security plan $ 2.000.00 TRUE 113 1431 3180 813/2022 Outdoor system $1,000.00 TRUE 114 1432 9180 9/14/2022 Outdoor system 500.00 FALSE 115 1423 9120 2/15/2023 Outdoor system 500.00 FALSE 116 1434 19180 8/15/2023 Outdoor system 800.00 FALSE 117 1441 9178 6/24/2022 Indoor system $ 1750.00 TRUE 118 1442 9178 10/24/2022 Indoor system $ 1,000.00 FALSE 119 1443 9173 8/25/2023 Indoor system 1,000 00 FALSE 120 1451 9173 3/5/2023 Indoor and outdoor system $ 1,500.00 FALSE 121 1452 9173 5/6/2022 Indoor and outdoor system $ 1,000.00 FALSE 122 1453 9173 5/5/2023 Indoor and outdoor system $ 1,000,00 FALSE 123 1454 9173 8/18/2023 Indoor and outdoor system 1,500.00 FALSE Documentation Home Page Customers Contracts InvoicesA B E F G H 122 1453 3173 5/5/2023 Indoor and outdoor system # 1,000.00 FALSE 123 1454 3173 3/18/2023 Indoor and outdoor system 1500 00 FALSE 124 1461 9181 10/11/2042 Front door system 300.00 FALSE 125 1462 9181 5/10/2023 Front door system 300,00 FALSE 126 1463 9181 10/18/2023 Front door system $ 200 00 FALSE 127 1471 9177 8/23/2022 Indoor system $ 3.500 00 TRUE 128 1481 9182 8/1/2022 Indoor system $ 2,500.00 TRUE 129 1482 9182 10/21/2022 Indoor system 2,500.00 FALSE 130 1491 9190 10/14/2022 Outdoor system 500.00 FALSE 131 1492 9190 2/16/2023 Outdoor system 500 00 FALSE 132 1493 9190 11/16/2023 Outdoor system 500.00 FALSE 133 1494 9130 9/9/2022 Outdoor system 1,000.00 FALSE 134 1501 9185 2/23/2023 Garage system 500.00 FALSE 135 1502 9185 10/23/2023 Garage system $ 1,000.00 FALSE 136 1503 9185 8/26/2022 Garage system $ 1,000.00 FALSE 137 1511 9195 8/25/2022 Indoor system * 1,500.00 TRUE 138 1512 9195 3/29/2023 Indoor system * 1,000.00 FALSE 139 1513 9195 4/30/2022 Indoor system $ 2.000.00 FALSE 140 1521 9186 10/11/2022 Indoor and outdoor system $ 5.250.00 FALSE 141 1522 9186 3/12/2026 Indoor and outdoor system 2.500.00 FALSE 142 1523 9186 10/4/2023 Indoor and outdoor system 2.500.00 FALSE 143 1531 9198 12715/2022 Indoor system 500,00 FALSE 144 1532 9198 3/15/2023 Indoor system $ 1,000.00 FALSE 145 |1533 9198 1/15/2022 Indoor system 1,000.00 FALSE 146 1534 9198 7/15/2022 Indoor system 500.00 FALSE 147 1541 919 8/25/2022 Outdoor system 1.500.00 TRUE 148 1542 9193 2/27/2023 Outdoor system $ 1,500.00 FALSE 149 1551 9139 12/23/2022 Security plan 1,500.00 FALSE 150 1561 9194 8/25/2022 Indoor system $ 2,000.00 TRUE 151 1562 9194 3/23/2023 Indoor system 300.00 FALSE 152 1571 9204 9/28/2022 Indoor system 1,500,00 FALSE 153 | 1572 9204 1/27/2023 Indoor system 1,000.00 FALSE 154 1581 9197 10/3/2022 Garage and outdoor system 1,500,00 FALSE 155 | 1582 9197 2/2/2022 Garage and outdoor system 500.00 FALSE 156 | 1583 9197 4/20/2023 Garage and outdoor system 500.00 FALSE 157 1591 9208 176/2023 Security plan 250,00 FALSE 158 1592 3208 1/13/2023 Security plan 250.00 FALSE 159 1593 3208 2/15/2022 Security plan 250.00 FALSE 160 1594 9208 3/31/2023 Security plan 250.00 FALSE 161 1601 9200 9/8/2023 Front door system $ 1500 00 FALSE 162 1611 9203 8/17/2023 Indoor and outdoor system $ 3,000.00 FALSE 163 1612 9203 8/16/2022 Indoor and outdoor system # 3,000 00 FALSE 164 1613 9203 12/17/2023 Indoor and outdoor system $ 3,000.00 FALSE 165 1614 9208 3/30/2023 Indoor and outdoor system $ 3,000.00 FALSE 166 1621 9209 4/18/2023| Indoor system $ 2,000.00 FALSE 167 1622 9209 10/18/2026 Indoor system 1,000,00 FALSE 168 1623 9209 9/23/2022 Indoor system 1,000.00 FALSE 163 1641 920 10/24/2022 Front door system 500.00 FALSE 170 1642 9205 5/25/2023 Front door system 500.00 FALSE 171 1651 9210 12/23/2022 Indoor system 4,000,00 FALSE 172 1652 9210 2/24/2023 Indoor system $ 1,000.00 FALSE 173 1853 9210 12/21/2023 Indoor system 1,000.00 FALSE 174 1654 9210 5/1/2023 Indoor system $ 1000.00 FALSE 175 176 177 173 173 120 121 182 123 Documentation Home Page Customers Contracts InvoicesCustomerIC - First Last - Phone ~ Address - City State Zip - Contracts by City C-001 Margaret Alexander 770-866-3901 211 N Paterson Newnan GA 30263 Atlanta 4 C-005 Jeff Jordan 770-392-0622 2611 S Sara Dr Peachtree City GA 30270 College Park 5 C -008 Chris Hackbart 404-985-1122 3478 Woodline Rd Atlanta GA LOTTE Dunwoody 6 C-012 Ramona Earley 770-454-9801 33 E Pine St Alpharetta GA 30004 7 6-014 Vernon Crowley 706-396-1972 566 Kent Rd Augusta GA 30917 8 C-015 Alberto Cruz 770-637-7783 456 Winchester St Canton GA 30114 9 C-020 Michelle McMurray 404-963-0808 815 Pulley Rd Decatur GA 30031 10 C-027 Karen Li 706-483-9244 402 5 Melody Rd Augusta GA 30918 11 C-030 Stephen Rosner 770-393-1228 111 E 78th Ave Dunwoody GA 30346 12 C-031 Daniel Plummer 404-842-4603 29 Graham Blud Atlanta GA 30347 13 C - 032 Laquan Richardson 404-857-1276 80 Cedar St Atlanta GA 30350 14 C-038 Clint Schmitt 706-482-1400 2268 N Jackson Columbus GA 31998 15 C -040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 30115 16 C-042 Michael Levander 404-337-9208 10 Lincoln Dr Atlanta GA 30336 17 C-043 Shana Liang 770-988-1320 40 Monroe St Alpharetta GA 30027 18 C-045 Jamal Kidd 404-343-7509 3047 Millbrook Ave Atlanta GA 31156 19 C -048 Joel Holtman 706-637-6591 7320 E Elmwood Augusta GA 30919 20 C-049 Frances Heller 404-983-2255 828 Turner St College Park GA 30337 21 C-053 Ahmad Greenwell 770-396-8401 614 Berman Rd Douglasville GA 30134 22 C -054 Jacquie Rollins 770-355-3989 258 Briar Ln Woolsey GA 30214 23 C -055 Steve Tomashek 404-979-2004 1440 Beadle Rd Decatur GA 30036 24 C-058 Andrea Vander 706-857-1771 77 Robin Rd Augusta GA 30907 25 C -059 Harry Fraser 770-392-0015 8045 Jefferson Ave Atlanta GA 30339 26 C-060 Anita Renteria 770-949-3862 75 Johnson St Atlanta GA 30341 27 C-064 Douglas Shoemaker 706-487-4700 5478 N Grove Baldwin GA 30511 28 C-065 Raymond Ringdahl 770-393-0403 24 Samuel St Alpharetta GA 3000 29 C-067 Beth Raferty 404-965-1992 612 E Carolina PI Atlanta GA 30318 30 C-068 Jason Grady 770-454-4002 5230 Fulton St Carrollton GA 30119 31 C-070 Gordon. Griffin 706-456-7093 912 Market St Augusta GA 30907 32 C-071 Mia Watanabe 404-857-4424 82 Cambridge St Briarcliff GA 30329 33 C -072 Barbara Callahan 404-337-8200 5049 Hwy 36 Sandy Springs GA 30342 34 C-OT3 Randy Dixon 770-983-1116 131 Pleasant St Marietta GA 30090 35 C-075 Jim Benning 706-482-9932 2167 S Macon St ALPosta GA 30168 36 C-079 Sarah Alvarez 770-940-3380 620 Pinewoody Alpharetta GA 30412 37 C-080 Timothy Jones 404-392-4629 249 W 11th St Atlanta GA 30327 38 C-083 Shanissa Hoffman 706-337-0990 1286 Jennifer Dr Athens GA 30604 39 C-084 Cathy Wilson 770-866-4382 78 Sandy Springs St Buford GA 30515 40 C-085 Richard Phillips 770-637-5408 39 Water St Canton GA 30714 41 C -087 Nancy Wanson 404-963-0190 1752 S Main St College Park GA 30337 42 C-088 Mickey Kerwin 706-454-3327 348 N Oak St Columbus GA 31998 43 44 45 46 Documentation Home Page Customers Contracts Invoices + stigateAssign the Add Invoice macro to the Add Invo Go to the Customers worksheet. Ravi wants to create PivotTables that include customer, B. contract, and invoice data. He already added the tables containing this data to the Data Model. Ravi wants to list and total each contract amount by city and signing date. Create a PivotTable that displays this information as follows: a Use Power Pivot to create a PivotTable on a new worksheet, using Contracts by City as the name of the worksheet. b. Display the City field values from the Query - Customer data source as row headings. C. Display the SigningDate field values from the Query - Contract data source as column headings. d. Add the ContractAmt field from the Query - Contract data source to the Values area to sum the field values. (Ignore the alert that states "Relationships between tables may be needed.", these relationships will be created in a later step.) e. Group the signing dates to display them as years and quarters only. (Hint: Expand the year headings to display the quarter headings, if necessary.) 9 . Ravi also wants to list the paid and unpaid invoices for each month and then filter them by contract type. Create a PivotTable that displays this information as follows; a Use Power Pivot to create a PivotTable on a new worksheet, using Invoices by Month as the name of the worksheet. Display the SigningDate field values from the Query - Contract data source as row headings. C. Display the InvoicePaid field values from the Query - Invoice data source as column headings. Sum the InvoiceAmt field values from the Query - Invoice data source. (Ignore the alert that states "Relationships between tables may be needed,", these relationships will be created in a later step. ) e . Use the ContractType field from the Query - Contract data source as a filter. F. Group the signing dates to display them as years and months only. (Hint: Expand the year headings to display the month headings, if necessary.) 10. To properly combine data from the Customer, Contract, and Invoice tables, create relationships between tables as follows: a. In the Power Pivot for Excel window, create a relationship between the Customer and Contract tables using the CustomerID column to relate the tables. b. Create a relationship between the Contract and Invoice tables using the ContractNum column to relate the tables.10: To properly combine data from the Customer, Contract, and Invoice tables, create relationships between tables as follows: "In the Power Pivot for Excel window, create a relationship between the Customer a. and Contract tables using the CustomerID column to relate the tables. Create a relationship between the Contract and Invoice tables using the b. ContractNum column to relate the tables. 11. Ravi wants to show invoices for security plans only and want to make the PivotTable easier to interpret. Modify the PivotTable as follows to meet Ravi's requests : a. Use Unpaid as the column heading in cell C4. b. Use Paid as the column heading in cell D4. C . Filter the PivotTable to display invoices for the Security plan and Security plan for apartment building contract types. 12. Return to the Customers worksheet. In the range 12:K5, Ravi wants to list the total contract amounts for three cities. Extract this information from the PivotTable on the Contracts by City worksheet as follows: In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet (cell 39). (Hint: Type an equal sign in cell K3 and then click the cell containing the value you want the GETPIVOTDATA function to get from the PivotTable.) b. In cell K4, use the GETPIVOTDATA function to display the total contract amount for College Park from the PivotTable on the Contracts by City worksheet (cell 316) C . In cell K5, use the GETPIVOTDATA function to display the total contract amount for Dunwoody from the PivotTable on the Contracts by City worksheet (cell 320) Save the workbook, making sure to save it as a macro-enabled workbook. Your workbook should look like the Final Figures on the following pages. Save your changes, completed project. close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your10: To properly combine data from the Customer, Contract, and Invoice tables, create relationships between tables as follows: "In the Power Pivot for Excel window, create a relationship between the Customer a. and Contract tables using the CustomerID column to relate the tables. Create a relationship between the Contract and Invoice tables using the b. ContractNum column to relate the tables. 11. Ravi wants to show invoices for security plans only and want to make the PivotTable easier to interpret. Modify the PivotTable as follows to meet Ravi's requests : a. Use Unpaid as the column heading in cell C4. b. Use Paid as the column heading in cell D4. C . Filter the PivotTable to display invoices for the Security plan and Security plan for apartment building contract types. 12. Return to the Customers worksheet. In the range 12:K5, Ravi wants to list the total contract amounts for three cities. Extract this information from the PivotTable on the Contracts by City worksheet as follows: In cell K3, use the GETPIVOTDATA function to display the total contract amount for Atlanta from the PivotTable on the Contracts by City worksheet (cell 39). (Hint: Type an equal sign in cell K3 and then click the cell containing the value you want the GETPIVOTDATA function to get from the PivotTable.) b. In cell K4, use the GETPIVOTDATA function to display the total contract amount for College Park from the PivotTable on the Contracts by City worksheet (cell 316) C . In cell K5, use the GETPIVOTDATA function to display the total contract amount for Dunwoody from the PivotTable on the Contracts by City worksheet (cell 320) Save the workbook, making sure to save it as a macro-enabled workbook. Your workbook should look like the Final Figures on the following pages. Save your changes, completed project. close the workbook, and then exit Excel. Follow the directions on the SAM website to submit yourContract 9111 CentreetNum -| Customerdia Contestants BaniaBeta ContestUps 46 9177 C-058 3.500.80 5/17/2028 Indoor sustem with video 47 9178 C-020 3 750 00 4125/2025 Indoor system 48 9180 C-001 1.800 00 411412022 Ourdoor system 49 9151 C-071 1.000 00 5/1012022 Front door system 50 9163 C-060 $ 5 000 00 6/1/2022 Indoor system with video 51 9185 C-068 2.500 00 6123/2024 Garage system 9186 C-054 10 250.00 F(11:2022 Indoor and outdoor system with video and backup 53 9190 C-079 2 500,00 6/24/2022 Outdoor system 54 9193 C-085 3.000 00 7/3512022 Outdoor evstem with video 35 9194 C-015 2.300 00 7/26/2022 Indoor system |9195 C-045 4.500 00 6/29/2023 Indoor system with video 9197 C-080 2 500,00 6/21/2022 Garage and outdoor system 3198 6-065 3.000.00 7/15/2022 Indoor system 59 1793 C-067 500 00 12512022 Security plan 60 |9200 C-031 1.500.00 BIG/2022 Front door system 61 9203 C-087 12 000 00 8/17/2022 Indoor end outdoor system for apartment building 9204 C-073 2.500.00 7/28/2022 Indoor system 19205 C-084 1,000,00 2 Front 9208 C-045 1.000 00 6/2212023 Security plan il 9209 C-059 4 000.00 8/18/2022 Indoor system with video 56 |9310 0-079 $ 3000 00 8125/2028 Indoor system 9136 C-068 2000 00 6/15/2021 Outdoor security system C-088 3.000.00 6/22/2021 Indoor security system 59 Documentation Home Page Customers Contracts InvoicesFinal Figure 2: Invoices by Month Worksheet A B C D E ContractType (Multiple Items) .T Sum of InvoiceAmt Column Labels Row Labels Unpaid Paid Grand Total 2021 May $1,500.00 $1,500.00 B Jun $1, 500.00 $1, 500.00 8 # Sep $950.00 $1,300.00 $2,250.00 9 #2022 10 8Jan $750.00 $750.00 Ap $2,000.00 $2,000.00 JuI $1,500.00 $1,500.00 BAug $1,000.00 $1,000.00 14 Grand Total $3,450.00 $7,050.00 $10,500.00 15 16 17 18 19 20 21 Invoices by Month Contracts by City Documentation Home PageFinal Figure 3: Contracts by City Worksheet B C DE G Sum of ContractAmt Column Labels 32021 Grand Total Qtrz atr3 Qtra How Labels Alpharetta $3,250.00 $2,080.00 Athens $5, 500.90 $10,000.00 Atlanta $18,509 00 $8,000 90 $13,090 90 $39,909 06 $39 509.08 10 Augusta $9,990.60 $10,060.60 $13.250.60 $40.540 00 Baldwin $5,900 80 12 Briarcliff 13 Buford 34 Canton $13,900 09 7.050.90 15 Caroliton $8, 500.00 $31,090.06 16 College Park $1,375 09 $14.975 90 37 Columbus $5 000.00 19,060.90 18 Decatur $3,500.00 $7.2 50 00 19 Douglasville 12090 00 20 Dunwoody $4,500 00 $5.750.00 $10 290106 Holly Springs $8,000.00 $5,009.00 Marietta 23 Newnan $7,090 00 $1,500 00 $3 500 90 24 Peachtree City $2,500.00 $1, 250 60 $2,600 90 $5 750 00 25 Sandy Springs $5090.00 26 Woolsey $10.250 00 1410,250 00 27 Grand Total $29,740.00 $47,500.00 $54, 875 60 $13, 800.00 $34,600.00 $42,050.00 $47,550.00 1269,515.60 Documentation Home Page Invoices by Month Contracts by City Customers Contracts - KFinal Figure 4: Customers Worksheet G FN Home Security Systems Phone Address City Margaret Alexander 270-866-3901 212 N Paterson Newnan GA Cross Jeff Jordan 770-392 6623 2631 S Sara Dr Peachtree City GA Hackbart 404-985-2123 3478 Woodline Rd Atlanta C-912 Ramona Eaday 770-454-9801 93 E Pine St Alpharetta C-814 Vernon Crowley 706-396-1972 566 Kent Rd Augusta Cruz 770-637-7783 456 Winchester St Canten Michelle McMurray 404-963-0808 815 Pulley Rd Decatur 10 C-027 Karen 746-483-9244 402 5 Melody Rd Augusta Stephen Rosner 770-393-1928 321 6 70th Ave Dunwoody GA Daniel Plummer 404-843-4663 29 Graham Blud Atlanta GA 30347 23 C-63a Laquan Richardson 404-857:2376 80 Cedar St Atlanta Clint Schmitt 706-482-1400 2368 N Jackson Columbus GA 31998 35 C-040 Victor Ramirez 770-988-0777 144 E Tower Ave Holly Springs GA 36 C-043 Michael Levander 404-337-9208 20 Lincoln Or Atlanta GA 30326 Shana Liang 770-980-2120 40 Monroe 5t Alpharetta GA HJamal Kidd 694-343-7509 3947 Millbrook Ave Atlanta 32156 Joel Holtman 706-637-6593 7320 E Elmwood Augusta GA Frances Heller 404-983-2255 828 Turner St College Park GA a Cosa Ahmad Greenwell 770-396-8401 634 Barman Rd Dough willa GA Jacquie Rolling 770-355-3989 258 Briar Ln Wooley SA GA 3.Cess Steve Tomashek 404-979-2004 2440 Beadle Rd Decatur Documentation Home Page Invoices by Month Contracts by City CustomersFinal Figure 5: Contracts Worksheet FN Home Security Systems ContractNum F CustomerD : CentralAnd IT SigningDate IF Contract Type GoingDate ( Year] SigningDate (Center) Signing Date (Month lealex) 7 Signing Date [Monthy Ejapan Inseer alarm system Villages Front door damsystem 2 Feb WWzott Indeed storm system 3 Mar 2 Fab C-955 short Indoor and outdoor slamm system with video 2021 5 May Otra 4 Agr Yea/bean Insect and ovideer alarmsystem with video 2021 S.sooge yes/coza Indeed and outdoor alarm system with backup 3 Mar 5 060 60 Wwages Indoor wireless alarm system oth 3 Mar WW1/2921 Insest and outdoor alarm system 2821 Swapan Indoorand outdoorsrates 12021 Citra 5/23/2021 Security plan for apartment bulksing otra 1.590 60 2023 2032 Otra S May waW/zona Gorese system with vices Cara 5 May 52 sauce, Indoes and outdoor system with video and backup 2071 Qtra 6 In 7/azzoat Insect and outdoor system for apartment building 2021 2021 Otra 8 Aug 22 Blazeat Indoor and pushger system for apartment bullang 8 Aug 23 9143 anplaces lossor and outdoor system with vista 2021 Qu3 8 Aug 24 9245 2021 9 Sea 9/2/2021 Security plan 2021 9 Sep 8 Aug 19148 appagas Inesor and putapers.stem with y see and safe room Contracts by Gay Customers Contracts Invoices Home Page Inspices by MonthFinal Figure 6: Invoices Worksheet C D FN Home Security Systems N InvoiceNum - ContractNum |InvoiceDate |Invoiceltem 1011 InvoiceAmt InvoicePaid 9111 2/27/2021 Indoor alarm system 500,00 4 1012 TRUE 9111 5/10/2021 Indoor alarm system 1,500.00 5 1021 TRUE 9112 2/25/2021 Front door alarm system 990.00 1031 TRUE 9120 4/19/2021 Indoor alarm system 1,000.00 TRUE 7 1032 9120 8/19/2021 Indoor alarm system $ 1,000.00 TRUE 8 1033 9120 9/20/2021 Indoor alarm system $ 1,000.00 TRUE 9 1034 9120 10/20/2021 Indoor alarm system $ 50,000.00 TRUE 10 1041 9115 4/1/2021 Indoor alarm system $ 2,500.00 TRUE 11 1051 9117 4/1/2021 Indoor alarm system $ 1, 250.00 TRUE 12 1061 9126 3/11/2022 Indoor wireless system 500,00 TRUE 13 1062 9126 9/12/2022 Indoor wireless system 1, 000.00 FALSE 14 1063 9126 7/11/2023 Indoor wireless system 1,000.00 FALSE 15 1064 9126 4/4/2023 Indoor wireless system 2,500.00 FALSE 16 1071 9123 11/22/2021 Indoor and outdoor alarm system $ 3,000.00 TRUE 17 1072 9123 7/22/2022 Indoor and outdoor alarm system $ 3,000.00 TRUE 18 1073 9123 9/21/2023 Indoor and outdoor alarm system $ 3,000.00 FALSE Documentation Home Page Invoices by Month Contracts by City Customers Contracts Invoices