Spreadsheet: 754279d1636052246-formatting-data-of-an-auto-populating-calendar-workbook-ef1554c_calendar_date_range
Sheet: Events_data

Days | Cumulative |  | Row | Date | Ref | Displayed | Crew |  | PO | Name | Estimator | Location | SQ Count | Trade Type | Material Ready | Start Date | Crew | End Date | AL Updated | Notes | Completed |  | Formulae in columns A:B and D:H already copied down to row 1000 - copy further as required
 | 0 |  |  |  |  |  |  |  | 21-11845 | [NAME] | [NAME] | 18909 Saint Clare Dr, Baton Rouge, LA 70810 | n/a | Awning | Yes | 2021-10-18 00:00:00 | Walter | 2021-10-18 00:00:00 | Yes | Needs to remove old brackets; Use scrolls provided. | Y
 |  |  |  |  |  |  |  |  | 21-12040 | Gabince Cabinets | Efrain Florian | 9150 Greenwell Springs Rd, Baton Rouge, LA 70814 |  |  |  | 2021-10-19 00:00:00 | [NAME] | 2021-10-22 00:00:00 |  | Need Details | Y
 |  |  |  |  |  |  |  |  | 21-12040 | Grabince Cabinets | Efrain Florian | 9150 Greenwell Springs Rd, Baton Rouge, LA 70814 |  |  |  | 2021-10-19 00:00:00 | [NAME] | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-12419 | Brittany Gehring:19112 West Piney Point | [NAME] | 19112 West Piney Point Ave, Baton Rouge, LA 70817 |  |  |  | 2021-10-20 00:00:00 | Alonzo | 2021-10-21 00:00:00
 |  |  |  |  |  |  |  |  | 21-12104 | [NAME] | [NAME] | 26055 Louisiana 386, [NAME], LA 70740 |  | SS |  | 2021-10-20 00:00:00 | Walter | 2021-10-23 00:00:00 |  | [NAME] took over from Brett | Canceled
 |  |  |  |  |  |  |  |  | 21-12544 | [NAME] | [NAME] | 5352 Highland Ridge Dr, Baton Rouge, LA 70817 |  |  |  | 2021-10-21 00:00:00 | [NAME] | 2021-10-21 00:00:00
 |  |  |  |  |  |  |  |  | 21-12084 | Ryan Fallows Family Care Case Management Services | [NAME] | 9131 Interline Ave, Baton Rouge, LA 70809 |  | SS |  | 2021-10-21 00:00:00 | Merlin | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 20-8080 | Lewis Companies : Office | Efrain Florian | 9613/9643 Interline Ave, Baton Rouge, LA 70809 |  |  |  | 2021-10-21 00:00:00 | [NAME] | 2021-10-21 00:00:00
 |  |  |  |  |  |  |  |  | 21-12054 | [NAME] | [NAME] | 37517 Old La Highway 16, Denham Springs, LA 70706 |  | SS |  | 2021-10-21 00:00:00 | Walter | 2021-10-23 00:00:00
 |  |  |  |  |  |  |  |  | 21-11837 | [NAME] | [NAME] | 16222 Spanish Ct, Central, LA 70739 |  |  |  | 2021-10-22 00:00:00 | Chepe C | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-10112 | [NAME]. | [NAME] | 1215 Independence Blvd Bldg. 5, Zachary, LA 70791 |  |  |  | 2021-10-22 00:00:00 | Chepe C | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-12655 | Penny Blanchard Vertical | [NAME] | 3292 Hwy 966 small house, St. Francisville, LA 70775 |  | SS |  | 2021-10-22 00:00:00 | [NAME] | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-12345 | [NAME] | [NAME] | 17523 West Muirfield Dr, Baton Rouge, LA 70810 |  | Gutters |  | 2021-10-22 00:00:00 | [NAME] | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-10490 | [NAME] | [NAME] | 9758 Bank Street Extension, [NAME], LA 70722 |  |  |  | 2021-10-22 00:00:00 | [NAME] | 2021-10-22 00:00:00
 |  |  |  |  |  |  |  |  | 21-12105 | [NAME]:Repair | Isai Florian | 266 [NAME], Baton Rouge, LA 70808 |  | SS |  | 2021-10-25 00:00:00 | Alonzo | 2021-10-26 00:00:00
 |  |  |  |  |  |  |  |  | 21-12368 | [NAME] | [NAME] | 9075 Louisiana 19, Slaughter, LA 70777 |  | SS |  | 2021-10-25 00:00:00 | Chepe | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12305 | [NAME] | [NAME] | 12720 Magnolia [NAME], Baton Rouge, LA 70810 |  |  |  | 2021-10-25 00:00:00 | [NAME] | 2021-10-25 00:00:00
 |  |  |  |  |  |  |  |  | 21-12606 | [NAME] | [NAME] | 13901 Phillimore Ave, Baton Rouge, LA 70810 |  |  |  | 2021-10-25 00:00:00 | [NAME] | 2021-10-25 00:00:00
 |  |  |  |  |  |  |  |  | 20-7698 | [NAME] | [NAME] | 30349 Cane Market Rd Walker, LA 70785 |  |  |  | 2021-10-25 00:00:00 | Merlin | 2021-10-25 00:00:00
 |  |  |  |  |  |  |  |  | 21-12371 | [NAME] | [NAME] | 7154 Louisiana 44, [NAME], LA 70737 |  | SS |  | 2021-10-25 00:00:00 | Walter | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12730 | Rouse's #21 Storm damage | [NAME] | 3461 East Causeway Approach, Mandeville, LA 70448 |  |  |  | 2021-10-26 00:00:00 | [NAME] | 2021-10-26 00:00:00
 |  |  |  |  |  |  |  |  | 21-11715 | Berit [NAME] | [NAME] | 18613 Bay Ridge Ct, Baton Rouge, LA 70817 |  |  |  | 2021-10-26 00:00:00 | [NAME] | 2021-10-27 00:00:00
 |  |  |  |  |  |  |  |  | 21-12651 | [NAME] | [NAME] | 5103 Berryville Ct, Baton Rouge, LA 70817 |  |  |  | 2021-10-26 00:00:00 | Merlin | 2021-10-26 00:00:00
 |  |  |  |  |  |  |  |  | 21-12271 | Victoria Treme | [NAME] | 23759 Hwy 442, Independence, LA | 26 | R-Panel | Yes | 2021-10-26 00:00:00 | Rona | 2021-10-27 00:00:00
 |  |  |  |  |  |  |  |  | 21-12778 | [NAME] and [NAME] | [NAME] | 7245 Louisiana 44, [NAME], LA 70737 |  |  |  | 2021-10-27 00:00:00 | [NAME] | 2021-10-27 00:00:00 | Yes | They need to go back and fix
 |  |  |  |  |  |  |  |  | 21-12296 | Rouse's #36 Storm damage | [NAME] | 4001 General De Gaulle Dr, New Orleans, LA 70114 |  |  |  | 2021-10-27 00:00:00 | Merlin | 2021-10-27 00:00:00
 |  |  |  |  |  |  |  |  | 21-12685 | [NAME] | [NAME] | 11440 [NAME], Baton Rouge, LA 70815 |  |  |  | 2021-10-28 00:00:00 | [NAME] | 2021-10-28 00:00:00
 |  |  |  |  |  |  |  |  | 21-12652 | Rhodes Home Jason | [NAME] | 3292 Hwy 966, St. Francisville, LA 70775 |  |  |  | 2021-10-28 00:00:00 | [NAME] | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-13014 | [NAME] | [NAME] | 3446 Westervelt Ave, Baton Rouge, LA 70820 |  |  |  | 2021-10-28 00:00:00 | [NAME] | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12541 | [NAME]: [NAME] | [NAME] | 11877 Parkbrook Ave, Baton Rouge, LA 70816 |  |  |  | 2021-10-29 00:00:00 | [NAME] | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12721 | [NAME] | [NAME] | 8100 [NAME], Denham Springs, LA 70726 |  |  |  | 2021-10-29 00:00:00 | Merlin | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12729 | [NAME] | [NAME] | 1646 South Columbine St, Baton Rouge, LA 70808 |  |  |  | 2021-10-29 00:00:00 | [NAME] | 2021-10-29 00:00:00
 |  |  |  |  |  |  |  |  | 21-12453 | [NAME] | [NAME] | 107 [NAME], Des Allemands, LA 70030 |  |  |  | 2021-11-01 00:00:00 | ???? | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-12605 | [NAME]: | [NAME] | 45323 Penny Duplessis Rd, [NAME], LA 70774 |  |  |  | 2021-11-01 00:00:00 | Alonzo | 2021-11-02 00:00:00
 |  |  |  |  |  |  |  |  | 21-10255 | [NAME] | [NAME] | 10551 Louisiana 1033, Denham Springs, LA 70726 |  |  |  | 2021-11-01 00:00:00 | Chepe | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-11401 | [NAME] | [NAME] | 712 Lakeview Lane, Covington, LA 70435 |  |  |  | 2021-11-01 00:00:00 | [NAME] | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 21-12839 | [NAME] | [NAME] | 5235 Berryville Ct, Baton Rouge, LA 70817 |  |  |  | 2021-11-01 00:00:00 | [NAME] | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 21-12680 | John & Lynda Carbo | Isai Florian | 18817 Saint Clare Ct, Baton Rouge, LA 70810 |  |  |  | 2021-11-01 00:00:00 | [NAME] | 2021-11-02 00:00:00
 |  |  |  |  |  |  |  |  | 21-11479 | A & Q Maintenance | Efrain Florian | 7115 Exchequer [NAME], Baton Rouge, LA 70809 |  |  |  | 2021-11-01 00:00:00 | Merlin | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  | 21-13029 | Joles General Maintenance | [NAME] | 17742 Highland Rd, Baton Rouge, LA 70810 |  |  |  | 2021-11-02 00:00:00 | [NAME] | 2021-11-02 00:00:00
 |  |  |  |  |  |  |  |  | 21-12520 | Dr. [NAME]: Family Dollar | [NAME] | 2836 Louisiana 20, Vacherie, LA 70090 |  |  |  | 2021-11-02 00:00:00 | Merlin | 2021-11-02 00:00:00
 |  |  |  |  |  |  |  |  | 21-12710 | Chistopher [NAME] | Cesar Padilla | 19717 Southern Hills Ave, Baton Rouge, LA 70809 |  |  |  | 2021-11-03 00:00:00 | Alonzo | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-12732 | Rouse's #31 Storm Damage | [NAME] | 50 Park Place Dr, Covington, LA 70433 |  |  |  | 2021-11-03 00:00:00 | [NAME] | 2021-11-03 00:00:00
 |  |  |  |  |  |  |  |  | 21-13004 | Joles General Maintenance | [NAME] | 3617 South Sherwood Forest Blvd, Baton Rouge, LA 70816 |  |  |  | 2021-11-03 00:00:00 | [NAME] | 2021-11-03 00:00:00
 |  |  |  |  |  |  |  |  | 21-12788 | Fabricated Steel Products | Efrain Florian | 2487 North Flannery Rd, Baton Rouge, LA 70815 |  |  |  | 2021-11-03 00:00:00 | Merlin | 2021-11-03 00:00:00
 |  |  |  |  |  |  |  |  | 21-12524 | [NAME] | [NAME] | 5848 Trenton Ave, Baton Rouge, LA 70808 |  |  |  | 2021-11-04 00:00:00 | [NAME] | 2021-11-04 00:00:00
 |  |  |  |  |  |  |  |  | 21-12766 | [NAME]:Repair | Isai Florian | 27564 Louisiana 22, Springfield, LA 70462 |  |  |  | 2021-11-04 00:00:00 | [NAME] | 2021-11-04 00:00:00
 |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] |  |  |  |  | 2021-11-04 00:00:00 |  | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-11548 | Tyler Roussel | [NAME] | 7355 [NAME], Sorrento, LA 70778 |  |  |  | 2021-11-05 00:00:00 | [NAME] | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-12968 | [NAME]Repair | Isai Florian | 11050 [NAME], Central, LA 70739 |  |  |  | 2021-11-05 00:00:00 | [NAME] | 2021-11-05 00:00:00
 |  |  |  |  |  |  |  |  | 21-12227 | [NAME] | [NAME] | 45512 Summerfield Rd North, Prairieville, LA 70769 |  |  |  | 2021-11-08 00:00:00 | Alonzo | 2021-11-08 00:00:00
 |  |  |  |  |  |  |  |  | 21-11385 | [NAME] | Leif fjeldsjo | 1044 Cyril Ave, Baton Rouge, LA 70806 |  |  |  | 2021-11-08 00:00:00 | Chepe | 2021-11-08 00:00:00
 |  |  |  |  |  |  |  |  | 21-12899 | [NAME] | [NAME] | 10656 Rondo Ave, Baton Rouge, LA 70815 |  |  |  | 2021-11-08 00:00:00 | [NAME] | 2021-11-09 00:00:00
 |  |  |  |  |  |  |  |  | 21-12980 | [NAME] | [NAME] | 8925 Foxgate Dr, Baton Rouge, LA 70806 |  |  |  | 2021-11-08 00:00:00 | [NAME] | 2021-11-08 00:00:00
 |  |  |  |  |  |  |  |  | 21-9716 | [NAME] | Cesar Padilla | 14314 [NAME], Prairieville, LA 70769 |  |  |  | 2021-11-08 00:00:00 | Merlin | 2021-11-09 00:00:00
 |  |  |  |  |  |  |  |  | 21-10944 | Carlton May | [NAME] | 119 Riverdale Dr, Covington, LA 70433 |  |  |  | 2021-11-08 00:00:00 | Walter | 2021-11-09 00:00:00
 |  |  |  |  |  |  |  |  | 21-12969 | [NAME]:Repair | [NAME] | 17068 Hunters Trace West, Prairieville, LA 70769 |  |  |  | 2021-11-09 00:00:00 | Alonzo | 2021-11-09 00:00:00
 |  |  |  |  |  |  |  |  | 21-12567 | [NAME] | [NAME] | 21910 [NAME], Baton Rouge, LA 70817 |  |  |  | 2021-11-09 00:00:00 | [NAME] | 2021-11-09 00:00:00
 |  |  |  |  |  |  |  |  | 21-13084 | [NAME] | Cesar | 43457 Terrell Ave, [NAME], LA 70737 |  |  |  | 2021-11-10 00:00:00 | [NAME] | 2021-11-10 00:00:00
 |  |  |  |  |  |  |  |  | 21-12766 | [NAME]:Repair | Isai Florian | 27564 Louisiana 22, Springfield, LA 70462 |  |  |  | 2021-11-10 00:00:00 | [NAME] | 2021-11-10 00:00:00
 |  |  |  |  |  |  |  |  | 21-12629 | [NAME] | [NAME] | 36 [NAME], LA 70433 |  |  |  | 2021-11-10 00:00:00 | Merlin | 2021-11-10 00:00:00
 |  |  |  |  |  |  |  |  | 21-12581 | [NAME] | [NAME] | 7029 Moniteau Ct, Baton Rouge, LA 70809 |  |  |  | 2021-11-11 00:00:00 | Alonzo | 2021-11-12 00:00:00
 |  |  |  |  |  |  |  |  | 21-9892 | [NAME] | [NAME] | 102 Cherokee Ave, Thibodaux, LA 70301 |  |  |  | 2021-11-11 00:00:00 | Chepe | 2021-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 21-12906 | [NAME] | [NAME] | 3305 O'Neal Lane, Baton Rouge, LA 70816 |  |  |  | 2021-11-11 00:00:00 | [NAME] | 2021-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 21-12848 | [NAME] | Olman Peña | 18653 Saint Andrews Ct West, Prairieville, LA 70769 |  |  |  | 2021-11-11 00:00:00 | Merlin | 2021-11-12 00:00:00
 |  |  |  |  |  |  |  |  | 21-13037 | [NAME] | [NAME] | 10390 Timberline Dr, Baton Rouge, LA 70809 |  |  |  | 2021-11-12 00:00:00 | [NAME] | 2021-11-12 00:00:00
 |  |  |  |  |  |  |  |  | 21-12939 | [NAME] | [NAME] | 40020 [NAME], Franklinton, LA 70438 |  |  |  | 2021-11-12 00:00:00 | [NAME] | 2021-11-12 00:00:00
 |  |  |  |  |  |  |  |  | 21-12571 | [NAME] Callia | [NAME] | 1551 Tara Blvd, Baton Rouge, LA 70806 |  |  |  | 2021-11-15 00:00:00 | Alonzo | 2021-11-17 00:00:00
 |  |  |  |  |  |  |  |  | 21-12624 | [NAME] | Cesar Padilla | 19791 Louisiana 22, Maurepas, LA 70449 |  |  |  | 2021-11-15 00:00:00 | Chepe | 2021-11-17 00:00:00
 |  |  |  |  |  |  |  |  | 21-12630 | [NAME] | [NAME] | 18469 Plantation Ct Dr, Prairieville, LA 70769 |  |  |  | 2021-11-15 00:00:00 | [NAME] | 2021-11-15 00:00:00
 |  |  |  |  |  |  |  |  | 21-11432 | [NAME] | [NAME] | 237 Charter [NAME], Baton Rouge, LA 70810 |  |  |  | 2021-11-15 00:00:00 | Merlin | 2021-11-15 00:00:00
 |  |  |  |  |  |  |  |  | 21-11123 | [NAME] | [NAME] | 314 East [NAME], Hammond, LA 70401 |  |  |  | 2021-11-16 00:00:00 | [NAME] | 2021-11-16 00:00:00
 |  |  |  |  |  |  |  |  | 21-12831 | [NAME]:Repair | Isai Florian | 4532 Lake Point Ave, Baton Rouge, LA 70817 |  |  |  | 2021-11-18 00:00:00 | Alonzo | 2021-11-19 00:00:00
 |  |  |  |  |  |  |  |  |  | brienne house