Spreadsheet: 686889d1594852649-deduct-6-working-days-from-array-of-dates-manufacturing
Sheet: Sheet1

 |  |  |  | [NAME] | Birdcage
 | Contract Number | Planned Chassis Start | Planned offline | MFG2-BCA01 | MFG2-BCA02 | BCA02 Catchup | [NAME] | BCA03 Catchup | BCAWIP (2 CAGES) | WS001 | [NAME] | WS002 | WS002 Catchup | WS003 | WS003 Catchup | FRAME WIP (2 BUSES) | WS004 | WS005 | WS006 | WS007 | WS008 | WS009 | [NAME] | WS011 | PD |  | 6
Confirmed | [NAME] | 6/22/2020 | 7/31/2020 | [NAME] | [NAME] |  | [NAME] |  | [NAME] | Wed-24-Jun |  | [NAME] |  | Wed-01-Jul |  | Mon-06-Jul | Wed-08-Jul | Fri-10-Jul | Tue-14-Jul | [NAME] | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul
Confirmed | STK-002-END | 6/24/2020 | 2020-04-08 00:00:00 | [NAME] | [NAME] |  | Mon-29-Jun |  | Mon-29-Jun | [NAME] |  | [NAME] |  | [NAME] |  | Wed-08-Jul | Fri-10-Jul | Tue-14-Jul | [NAME] | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug
Confirmed | SHO-005-END | 6/26/2020 | 2020-06-08 00:00:00 | [NAME] | [NAME] |  | [NAME] |  | [NAME] | [NAME] |  | [NAME] |  | Mon-06-Jul | Fri-10-Jul | Fri-10-Jul | Tue-14-Jul | [NAME] | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug
Confirmed | DEN-001-END | 6/30/2020 | 2020-10-08 00:00:00 | [NAME] | [NAME] |  | Wed-08-Jul |  | Mon-06-Jul | [NAME] |  | Thu-09-Jul | Thu-09-Jul | [NAME] | Tue-14-Jul | Tue-14-Jul | [NAME] | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug
Confirmed | VOL-001-ADV | 2020-02-07 00:00:00 | 2020-12-08 00:00:00 | [NAME] | [NAME] |  | Thu-09-Jul |  | Tue-07-Jul | Mon-06-Jul |  | [NAME] | Fri-10-Jul | Wed-15-Jul | Wed-15-Jul | [NAME] | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug
Confirmed | VOL-002-ADV | 2020-06-07 00:00:00 | 8/14/2020 | Fri-03-Jul | Wed-08-Jul | Fri-10-Jul | [NAME] | Wed-15-Jul | Thu-09-Jul | Wed-08-Jul | Thu-09-Jul | Wed-15-Jul | Tue-14-Jul | Fri-17-Jul | Fri-17-Jul | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug
Confirmed | TUR-001-ADV | 2020-08-07 00:00:00 | 8/18/2020 | Wed-08-Jul | Thu-09-Jul | [NAME] | Wed-15-Jul | [NAME] | Mon-06-Jul | Fri-10-Jul | Fri-10-Jul | Fri-17-Jul | Wed-15-Jul | Mon-20-Jul | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug
Confirmed | DEN-001-ADV | 2020-10-07 00:00:00 | 8/20/2020 | Thu-09-Jul | [NAME] | Wed-15-Jul | Fri-17-Jul | Mon-20-Jul | Wed-08-Jul | Tue-14-Jul | Tue-14-Jul | [NAME] | Fri-17-Jul | Mon-20-Jul | Wed-22-Jul | Fri-24-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug
Confirmed | KEL-001-ADV | 7/14/2020 | 8/24/2020 | [NAME] | Tue-14-Jul | [NAME] | [NAME] | [NAME] | Fri-10-Jul | [NAME] |  | Mon-20-Jul | Mon-20-Jul | Wed-22-Jul | Thu-23-Jul | Tue-28-Jul | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug
Confirmed | DEN-002-ADV | 7/16/2020 | 8/26/2020 | Tue-14-Jul | Wed-15-Jul | Mon-20-Jul | [NAME] | Thu-23-Jul | Tue-14-Jul | Mon-20-Jul |  | Wed-22-Jul | Wed-22-Jul | Fri-24-Jul | [NAME] | Thu-30-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug
Confirmed | VOL-004-ADV | 7/20/2020 | 8/28/2020 | Wed-15-Jul | [NAME] | [NAME] | Fri-17-Jul | Fri-24-Jul | [NAME] | Wed-22-Jul |  | Fri-24-Jul |  | Tue-28-Jul | Tue-28-Jul | Mon-03-Aug | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug
Confirmed | BRI-001-END | 7/22/2020 | 2020-01-09 00:00:00 | [NAME] | Mon-20-Jul | Thu-23-Jul | Mon-20-Jul | Tue-28-Jul | Mon-20-Jul | Fri-24-Jul |  | Tue-28-Jul |  | Thu-30-Jul | Thu-30-Jul | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME]
Confirmed | TEL-001-ADV | 7/24/2020 | 2020-03-09 00:00:00 | Fri-17-Jul | Wed-22-Jul | Fri-24-Jul | [NAME] | Wed-29-Jul | Wed-22-Jul | Tue-28-Jul |  | Thu-30-Jul |  | Mon-03-Aug |  | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep
Confirmed | TEL-002-ADV | 7/28/2020 | 2020-07-09 00:00:00 | [NAME] | Mon-20-Jul | Tue-28-Jul | Thu-23-Jul | Fri-31-Jul | Fri-24-Jul | Thu-30-Jul |  | Mon-03-Aug |  | Wed-05-Aug |  | Tue-11-Aug | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep
Confirmed | TEL-003-ADV | 7/30/2020 | 2020-09-09 00:00:00 | Mon-20-Jul | Wed-22-Jul | Wed-29-Jul | Fri-24-Jul | Mon-03-Aug | Tue-28-Jul | Mon-03-Aug |  | Wed-05-Aug |  | Fri-07-Aug |  | Thu-13-Aug | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep
Confirmed | TEL-004-ADV | 2020-03-08 00:00:00 | 2020-11-09 00:00:00 | Wed-22-Jul | Fri-24-Jul | Fri-31-Jul | Tue-28-Jul | Wed-05-Aug | Thu-30-Jul | Wed-05-Aug |  | Fri-07-Aug |  | Tue-11-Aug |  | Mon-17-Aug | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep
Confirmed | BAL-001-ADV | 2020-05-08 00:00:00 | 9/15/2020 | Fri-24-Jul | Tue-28-Jul | Mon-03-Aug | Thu-30-Jul | Thu-06-Aug | Mon-03-Aug | Fri-07-Aug |  | Tue-11-Aug |  | Thu-13-Aug |  | Wed-19-Aug | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep
Confirmed | TEL-005-ADV | 2020-07-08 00:00:00 | 9/17/2020 | Tue-28-Jul | Thu-30-Jul | Wed-05-Aug | Mon-03-Aug | Mon-10-Aug | Wed-05-Aug | Tue-11-Aug |  | Thu-13-Aug |  | Mon-17-Aug |  | Fri-21-Aug | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep
Confirmed | PRE-001-END | 2020-11-08 00:00:00 | 9/21/2020 | Thu-30-Jul | Mon-03-Aug | Thu-06-Aug | Wed-05-Aug | Tue-11-Aug | Fri-07-Aug | Thu-13-Aug |  | Mon-17-Aug |  | Wed-19-Aug |  | Tue-25-Aug | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep
Confirmed | PRE-002-END | 8/13/2020 | 9/23/2020 | Mon-03-Aug | Wed-05-Aug | Mon-10-Aug | Fri-07-Aug | Thu-13-Aug | Tue-11-Aug | Mon-17-Aug |  | Wed-19-Aug |  | Fri-21-Aug |  | Thu-27-Aug | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME]
Confirmed | Edwards | 8/17/2020 | 9/25/2020 | Wed-05-Aug | Fri-07-Aug | Tue-11-Aug | Tue-11-Aug | Fri-14-Aug | Thu-13-Aug | Wed-19-Aug |  | Fri-21-Aug |  | Tue-25-Aug |  | [NAME] | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep
Allocated | DEN-002-END | 8/19/2020 | 9/29/2020 | Fri-07-Aug | Tue-11-Aug | Thu-13-Aug | Thu-13-Aug | Tue-18-Aug | Mon-17-Aug | Fri-21-Aug |  | Tue-25-Aug |  | Thu-27-Aug |  | Wed-02-Sep | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep | Mon-28-Sep
Available |  | 8/21/2020 | 2020-01-10 00:00:00 | Tue-11-Aug | Thu-13-Aug | Fri-14-Aug | Mon-17-Aug | Wed-19-Aug | Wed-19-Aug | Tue-25-Aug |  | Thu-27-Aug |  | [NAME] |  | Fri-04-Sep | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep | Mon-28-Sep | Wed-30-Sep
Available |  | 8/25/2020 | 2020-06-10 00:00:00 | Thu-13-Aug | Mon-17-Aug | Tue-18-Aug | Wed-19-Aug | Fri-21-Aug | Fri-21-Aug | Thu-27-Aug |  | [NAME] |  | Wed-02-Sep |  | Tue-08-Sep | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep | Mon-28-Sep | Wed-30-Sep | Fri-02-Oct
Confirmed | BRAI-001-ADV | 8/27/2020 | 2020-08-10 00:00:00 | Mon-17-Aug | Wed-19-Aug | Wed-19-Aug | Fri-21-Aug | Mon-24-Aug | Tue-25-Aug | [NAME] |  | Wed-02-Sep |  | Fri-04-Sep |  | Thu-10-Sep | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep | Mon-28-Sep | Wed-30-Sep | Fri-02-Oct | Wed-07-Oct
Confirmed | VOL-003-ADV | 8/31/2020 | 2020-12-10 00:00:00 | Wed-19-Aug | Fri-21-Aug |  | Tue-25-Aug | Wed-26-Aug | Thu-27-Aug | Wed-02-Sep |  | Fri-04-Sep |  | Tue-08-Sep |  | Mon-14-Sep | Wed-16-Sep | Fri-18-Sep | [NAME] | Thu-24-Sep | Mon-28-Sep | Wed-30-Sep | Fri-02-Oct | Wed-07-Oct | [NAME]