Spreadsheet: 884759d1734018781-creating-a-date-based-on-a-text-value-resource-plan-template
Sheet: Resource Plan

 | Project Start Date | 2025-01-01 00:00:00 |  | Display Week |  |  | 1
 | Project Lead |  |  | Installation |  | S&D
WBS | VENDOR | LEAD | INSTALL START | INSTALL END | DAYS | S&D START | S&D END | DAYS | WORK DAYS
 | Vendor 1 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5 |  |  |  |  | x |  |  |  | s
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 2 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 3 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 4 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 5 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 6 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 7 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 8 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 9 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 10 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 11 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 12 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 13 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 14 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | Vendor 15 |  |  |  |  |  |  | 2
 | Task 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Task 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Task 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Task 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Task 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Task 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Task 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Task 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Task 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Task 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Task 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Task 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Task 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Task 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Task 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Task 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Task 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7
 | PQP |  |  |  |  |  |  | 2
 | Vendor 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Vendor 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 6 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Vendor 7 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Vendor 8 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Vendor 9 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Vendor 10 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Ramp-Up |  |  |  |  |  |  | 2
 | Vendor 1 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 2 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 3 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 3
 | Vendor 4 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 5 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 8
 | Vendor 6 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 5
 | Vendor 7 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 6
 | Vendor 8 |  | 2020-07-28 00:00:00 |  | 4 | 2020-07-28 00:00:00 |  | 7
 | Vendor 9 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 8
 | Vendor 10 |  | 2020-07-28 00:00:00 |  | 6 | 2020-07-28 00:00:00 |  | 9
 | Vendor 11 |  | 2020-07-28 00:00:00 |  | 7 | 2020-07-28 00:00:00 |  | 10
 | Vendor 12 |  | 2020-07-28 00:00:00 |  | 8 | 2020-07-28 00:00:00 |  | 11
 | Vendor 13 |  | 2020-07-28 00:00:00 |  | 12 | 2020-07-28 00:00:00 |  | 7
 | Vendor 14 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 5
 | Vendor 15 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 7
 | Vendor 16 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 5
 | Vendor 17 |  | 2020-07-28 00:00:00 |  | 3 | 2020-07-28 00:00:00 |  | 7
 | Vendor 18 |  | 2020-07-28 00:00:00 |  | 5 | 2020-07-28 00:00:00 |  | 5
 | Vendor 19 |  | 2020-07-28 00:00:00 |  | 1 | 2020-07-28 00:00:00 |  | 7
 | Vendor 20 |  | 2020-07-28 00:00:00 |  | 2 | 2020-07-28 00:00:00 |  | 7