Spreadsheet: 703983d1605282217-remove-text-around-date-al
Sheet: Sheet2

Account | Job Name | Template - Date ↑ | Install - Date | Lead Time     Target 8 days
Home Depot 443 | Longbottom, [NAME] |  | Late 11/4/20 (conf)
Home Depot 414 | [NAME], [NAME] | 2020-08-17 00:00:00 | LateOverbooked 9/2/20 (conf)
Home Depot 481 | [NAME], [NAME] | 2020-10-07 00:00:00 | LateOverbooked 10/23/20 (conf)
Home Depot 443 | [NAME], [NAME] | Late 10/11/20 (conf) | 12/1/20 (conf)
Home Depot 410 | Stropka, Stacy | 2020-10-12 00:00:00 | LateOverbooked 10/30/20 (conf)
Home Depot 478 | Bohnet, [NAME] | 2020-10-13 00:00:00 | 11/17/20 (conf)
Home Depot 481 | [NAME], [NAME] | 2020-10-13 00:00:00 | LateOverbooked 10/30/20 (conf)
Home Depot 443 | Miner, [NAME] | 2020-10-13 00:00:00 | 2020-10-13 00:00:00
 |  |  | LateWarning 11/4/20 (conf)
Farrow Remodeling | [NAME] | 2020-10-14 00:00:00 | 2020-11-10 00:00:00
 |  | Today 11/13/20 (auto) | 11/24/20 (conf)
Home Depot 410 | Davies, [NAME] | 2020-10-21 00:00:00 | No Date
 |  |  | 2020-11-09 00:00:00
Home Depot 410 | Mazanek, [NAME] | 2020-10-21 00:00:00 | Late 11/12/20 (conf)
Home Depot 410 | Robb, Rose | 2020-10-21 00:00:00 | Late 11/12/20 (conf)
Home Depot 481 | Ravely, Marv | 2020-10-22 00:00:00 | Overbooked 11/23/20 (conf)
[NAME] | Felix, Tisha & Ernie | 2020-10-23 00:00:00 | LateOverbooked 11/6/20 (conf)
Home Depot 414 | Micena, [NAME] | 2020-10-23 00:00:00 | TodayWarningOverbooked 11/13/20 (conf)
Home Depot 478 | Cochran, [NAME] | 2020-10-27 00:00:00 | 11/17/20 (conf)
Home Depot 410 | Loya, Dyllon | 2020-10-27 00:00:00 | Late 11/12/20 (conf)
 |  | 2020-11-02 00:00:00
[NAME] | Quiroz | 2020-10-27 00:00:00 | LateWarning 11/4/20 (conf)
Home Depot 478 | Sexton, Stephen | 2020-10-27 00:00:00 | TodayOverbooked 11/13/20 (conf)
Millwork by Design | Oro Vista Clubhouse | 2020-10-28 00:00:00 | 11/17/20 (conf)
Home Depot 481 | Smith, [NAME] | 2020-10-28 00:00:00 | Warning 11/18/20 (conf)
Home Depot 410 | Springs, [NAME] | 2020-10-28 00:00:00 | Late 11/12/20 (conf)
Home Depot 467 | Brown, Maria | 2020-10-29 00:00:00 | 11/20/20 (conf)
Home Depot 478 | [NAME], [NAME] | 2020-10-29 00:00:00 | Late 11/12/20 (conf)
Home Depot 410 | Hubbard, [NAME] | 2020-10-29 00:00:00 | Today 11/13/20 (conf)
Home Depot 410 | Kaletsch, [NAME] | 2020-10-29 00:00:00 | Late 11/12/20 (auto)
 |  | Late 11/3/20 (auto) | 11/16/20 (conf)
 |  | 11/16/20 (conf) | 11/30/20 (conf)
Home Depot 443 | Martinez, Susanna | 2020-10-29 00:00:00 | TodayWarningOverbooked 11/13/20 (conf)
Millwork by Design | Suburu Reception | 2020-10-29 00:00:00 | LateOverbooked 11/11/20 (conf)
 |  |  | Overbooked 11/16/20 (conf)
 |  |  | Overbooked 11/17/20 (conf)
 |  |  | 11/18/20 (conf)
 |  |  | Overbooked 11/19/20 (conf)
Home Depot 443 | Ziemba, Francesca | 2020-10-29 00:00:00 | LateOverbooked 11/12/20 (conf)
Home Depot 486 | Black, [NAME] | 2020-10-30 00:00:00 | TodayOverbooked 11/13/20 (conf)
Home Depot 486 | Fish, [NAME] | 2020-10-30 00:00:00 | 11/24/20 (conf)
[NAME] | Jamieson, Joan & Mark | 2020-10-30 00:00:00 | TodayOverbooked 11/13/20 (conf)
Home Depot 410 | [NAME], [NAME] | 2020-10-30 00:00:00 | TodayOverbooked 11/13/20 (conf)
Home Depot 478 | [NAME], [NAME] | 2020-11-02 00:00:00 | Warning 11/16/20 (conf)
Home Depot 467 | Barden, [NAME] | 2020-11-02 00:00:00 | Warning 11/16/20 (conf)
Home Depot 467 | Beardsley, [NAME] | 2020-11-02 00:00:00 | 11/17/20 (conf)
Home Depot 478 | [NAME], Lydia | 2020-11-02 00:00:00 | Warning 11/17/20 (conf)
Home Depot 8488 | Munger, [NAME] | 2020-11-02 00:00:00 | Warning 11/16/20 (est)
Home Depot 467 | Thelin, [NAME] | 2020-11-02 00:00:00 | Warning 11/17/20 (conf)
Home Depot 481 | Carol, Vincent | 2020-11-03 00:00:00 | 11/23/20 (conf)
Home Depot 481 | Dinning, [NAME] | 2020-11-03 00:00:00 | 11/18/20 (conf)
[NAME] | [NAME], [NAME] | 2020-11-03 00:00:00 | 11/17/20 (conf)
Home Depot 478 | [NAME], [NAME] | 2020-11-03 00:00:00 | Warning 11/18/20 (conf)
[NAME] | McGuiness-vanities | 2020-11-03 00:00:00 | 11/17/20 (est)
Home Depot 481 | Ward, Eddie | 2020-11-03 00:00:00 | WarningOverbooked 11/17/20 (conf)
[NAME] | Windels, [NAME] | 2020-11-03 00:00:00 | 11/19/20 (conf)
Home Depot 478 | Alimena, [NAME] | 2020-11-04 00:00:00 | Warning 11/18/20 (conf)
Home Depot 478 | [NAME], [NAME] | 2020-11-04 00:00:00 | Overbooked 11/23/20 (conf)
Home Depot 410 | Cross, [NAME] | 2020-11-04 00:00:00 | Warning 11/18/20 (conf)
Home Depot 410 | Fahland, [NAME] | 2020-11-04 00:00:00 | Warning 11/18/20 (conf)
Home Depot 410 | [NAME], [NAME] | 2020-11-04 00:00:00 | Warning 11/17/20 (conf)
Home Depot 478 | Kuerston II, [NAME] | 2020-11-04 00:00:00 | Warning 11/18/20 (conf)
Home Depot 410 | Lillich, Jacob & Krista | Late 11/4/20 (conf) | Warning 11/19/20 (conf)
Kelch Custom Homes | [NAME], [NAME] | 2020-11-05 00:00:00 | Warning 11/16/20 (conf)
Home Depot 410 | Hall, Joe | 2020-11-05 00:00:00 | 11/20/20 (conf)
Home Depot 408 | Jordan, Darrell | 2020-11-05 00:00:00 | 11/30/20 (conf)
Home Depot 410 | Mosier, [NAME] | 2020-11-05 00:00:00 | 11/19/20 (conf)
Home Depot 414 | Saghafi, [NAME] | 2020-11-05 00:00:00 | Warning 11/19/20 (conf)
Home Depot 467 | Adams, [NAME] | 2020-11-06 00:00:00 | 11/23/20 (conf)
Home Depot 467 | Alelyunas, [NAME] | 2020-11-06 00:00:00 | 11/20/20 (conf)
Home Depot 467 | Huggins, [NAME] | 2020-11-06 00:00:00 | 11/20/20 (conf)
[NAME] | JR1 | 11/6/20 (NA) | 11/29/20 (conf)
 |  | 11/25/20 (auto) | 12/4/20 (conf)
 |  | 12/2/20 (auto) | 12/11/20 (conf)
Home Depot 486 | Krywonis, [NAME] | 2020-11-06 00:00:00 | Overbooked 11/23/20 (conf)
Home Depot 410 | [NAME], [NAME] | 2020-11-06 00:00:00 | 11/23/20 (conf)
Home Depot 467 | Unger, [NAME] | 2020-11-06 00:00:00 | 11/20/20 (conf)
 |  | Warning 11/20/20 (conf) | 11/24/20 (Tar)
House | Bennett, Greg & Ginger | 2020-11-09 00:00:00 | 11/19/20 (conf)
Home Depot 467 | Bernabucci, [NAME] | 2020-11-09 00:00:00 | 11/20/20 (conf)
Home Depot 410 | [NAME], [NAME] | 2020-11-09 00:00:00 | 11/30/20 (conf)
Home Depot 410 | Jacobs, [NAME] | 2020-11-09 00:00:00 | 12/1/20 (conf)
Home Depot 486 | Mather, [NAME] | 2020-11-09 00:00:00 | 12/2/20 (conf)
Home Depot 410 | Medvec, [NAME] | 2020-11-09 00:00:00 | 11/20/20 (conf)
Home Depot 410 | Newsham, [NAME] | 2020-11-09 00:00:00 | 12/1/20 (conf)
Home Depot 410 | Ostrom, Jonnae | 2020-11-09 00:00:00 | Warning 11/24/20 (conf)
House | [NAME], Fares-SPLASH | 11/10/20 (NA) | 11/15/20 (Tar)
Home Depot 410 | [NAME], [NAME] | 2020-11-10 00:00:00 | 12/1/20 (conf)
Home Depot 486 | Dunaway, Todd | 2020-11-10 00:00:00 | 12/2/20 (conf)
Home Depot 443 | Fitzpatrick, Lacy - Kitchen | 2020-11-10 00:00:00 | Warning 11/24/20 (conf)
Home Depot 410 | Price, [NAME] | 2020-11-10 00:00:00 | 11/30/20 (conf)
Thornhill Construction LLC | SGI-USA | No Date | 12/2/20 (est)
 |  | 2020-11-10 00:00:00
 |  | 2020-11-12 00:00:00
[NAME] | Standifer | Late 11/10/20 (conf) | 11/24/20 (conf)
Home Depot 414 | Bartzis, [NAME] | 2020-11-11 00:00:00 | Warning 11/25/20 (conf)
Home Depot 486 | [NAME], [NAME] | 2020-11-11 00:00:00 | 12/2/20 (conf)
Home Depot 478 | [NAME], [NAME] | 2020-11-11 00:00:00 | 11/30/20 (conf)
Home Depot 481 | [NAME], [NAME] | 2020-11-11 00:00:00 | 11/30/20 (conf)
Home Depot 481 | Redig, [NAME] | 2020-11-11 00:00:00 | 12/2/20 (conf)
Home Depot 478 | Rothbart, [NAME] | 2020-11-11 00:00:00 | Warning 11/25/20 (conf)
Home Depot 414 | Savage, [NAME] | 2020-11-11 00:00:00 | 12/3/20 (conf)
Pepper Viner | Ventana View Lot 7 | No Date | 12/1/20 (est)
 |  | 2020-11-11 00:00:00
House | Arturo | 2020-11-12 00:00:00 | 11/17/20 (NA)
Home Depot 414 | [NAME], [NAME] | LateOverbooked 11/12/20 (conf) | 11/25/20 (conf)
Home Depot 467 | Wollin, [NAME] | LateOverbooked 11/12/20 (conf) | 12/3/20 (conf)
House | Logan, [NAME] | Today 11/13/20 (conf) | 11/24/20 (conf)
[NAME] | Espino, [NAME] | Warning 11/16/20 (conf) | 11/23/20 (conf)
Home Depot 481 | Helling, [NAME] | 11/16/20 (conf) | 12/7/20 (conf)
Arizona Designs | Pershing | 11/17/20 (conf) | 12/7/20 (conf)
Home Depot 486 | Parrish, [NAME] | 11/18/20 (conf) | 12/9/20 (conf)
Home Depot 410 | Walker, [NAME] | 11/18/20 (conf) | 12/4/20 (conf)
[NAME] | Fisher, Judi & Ray | 11/20/20 (conf) | 12/8/20 (conf)
Home Depot 486 | [NAME], [NAME] | 11/20/20 (conf) | 12/1/20 (conf)
AF Sterling Homes | Agave in the Foothills Lot 5 | Overbooked 11/23/20 (conf) | 12/7/20 (conf)
Home Depot 486 | Ploetz, [NAME] | 2020-11-30 00:00:00 | Warning 11/16/20 (conf)