Spreadsheet: 807118d1669749377-scheduling-issue-shifting-date-dependent-data-schedule
Sheet: Sheet1

 | Input Template
 |  | Tbl_RawData
 | Helper | ID | Eng.Reqmts | 03-Dec-22 | 10-Dec-22 | 17-Dec-22 | 24-Dec-22 | 31-Dec-22 | 07-Jan-23 | 14-Jan-23 | 21-Jan-23 | 28-Jan-23 | 04-Feb-23 | 11-Feb-23 | 18-Feb-23 | 25-Feb-23 | 04-Mar-23 | 11-Mar-23 | 18-Mar-23 | 25-Mar-23 | 01-Apr-23 | 08-Apr-23 |  | LstEngReqmts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lead Engineer/CEM
T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telecoms Design (SDE/CRE)
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Telecoms Design Engineer
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Requirements Engineer
P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Engineer (PE/SPE)
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Engineer (PE/SDE)
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other SME (CRE)
T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMC Engineer
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical Design (CRE)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical Design Engineer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Civils Design (CRE)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Civils Design Engineer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test Engineer (TIC/PICOT)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test & Commissioning Engineer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quality/Assurance Engineer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Surveyor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Surveyor - Civils
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Surveyor - Electrical/Comms
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Keeper
 |  | S02008 |  | 10 | 10
 |  |  |  | 20 | 20
 |  |  |  | 30 | 30
 |  |  |  | 40 | 40
 |  |  |  | 50 | 50
 |  |  |  | 60 | 60
 |  |  |  | 70 | 70
 |  |  |  | 80 | 80
 | Schedule |  | No. wks to shift: | 2 | WksShift
 |  | TblSchedule
 | Helper | ID | Eng.Reqmts |  | 2022-12-10 00:00:00 | 2022-12-17 00:00:00 | 2022-12-24 00:00:00 | 2022-12-31 00:00:00 | 2023-01-07 00:00:00 | 2023-01-14 00:00:00 | 2023-01-21 00:00:00 | 2023-01-28 00:00:00 | 2023-02-04 00:00:00 | 2023-02-11 00:00:00 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | 2023-03-04 00:00:00 | 2023-03-11 00:00:00 | 2023-03-18 00:00:00 | 2023-03-25 00:00:00 | 2023-04-01 00:00:00 | 2023-04-08 00:00:00
 |  |  |  |  | 0 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Telecoms Design (SDE/CRE) | S02008 | Telecoms Design (SDE/CRE) | 0 | 0 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Telecoms Design Engineer | S02008 | Telecoms Design Engineer | 0 | 0 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Requirements Engineer | S02008 | Requirements Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Project Engineer (PE/SPE) | S02008 | Project Engineer (PE/SPE) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Project Engineer (PE/SDE) | S02008 | Project Engineer (PE/SDE) | 0 | 0 | 40 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Other SME (CRE) | S02008 | Other SME (CRE) | 0 | 0 | 50 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008EMC Engineer | S02008 | EMC Engineer | 0 | 0 | 60 | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Electrical Design (CRE) | S02008 | Electrical Design (CRE) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Electrical Design Engineer | S02008 | Electrical Design Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Civils Design (CRE) | S02008 | Civils Design (CRE) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Civils Design Engineer | S02008 | Civils Design Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Test Engineer (TIC/PICOT) | S02008 | Test Engineer (TIC/PICOT) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Test & Commissioning Engineer | S02008 | Test & Commissioning Engineer | 0 | 0 | 70 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Quality/Assurance Engineer | S02008 | Quality/Assurance Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Surveyor | S02008 | Surveyor | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Surveyor - Civils | S02008 | Surveyor - Civils | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Surveyor - Electrical/Comms | S02008 | Surveyor - Electrical/Comms | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S02008Site Keeper | S02008 | Site Keeper | 0 | 0 | 80 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0