Spreadsheet: 755716d1637052877-formula-to-allocate-no-of-days-to-months-given-start-and-end-dates-resource-allocation3
Sheet: Resource

 | Months |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LabourDivision | NumDays | UoM | StartDate | EndDate | Duration
Labour Division | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | TOTAL |  | Labour Division | Qty of Units | UoM | Start | End | Duration
Bids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bids | 3.5 | mDay | 2021-08-04 00:00:00 | 2021-09-06 00:00:00
Collaboration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Management | 1 | mDay | 2021-08-04 00:00:00 | 2021-09-05 00:00:00
Eng |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 4 | mDay | 2021-08-05 00:00:00 | 2021-08-06 00:00:00
H&S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 0.5 | mDay | 2021-08-10 00:00:00 | 2021-08-11 00:00:00
HR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bids | 4 | mDay | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
IDE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Procurement | 0.5 | mDay | 2021-08-10 00:00:00 | 2021-10-10 00:00:00
Maint Field |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 14 | mDay | 2021-08-19 00:00:00 | 2022-04-27 00:00:00
Procurement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 0.5 | mDay | 2021-08-12 00:00:00 | 2021-10-13 00:00:00
Project Management |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 3 | mDay | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
Quality |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Lot | 2021-08-09 00:00:00 | 2021-08-10 00:00:00
Scheme Field |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IDE | 0.5 | mDay | 2022-08-11 00:00:00 | 2022-09-14 00:00:00
Security |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IDE | 0.5 | mDay | 2021-08-11 00:00:00 | 2021-08-11 00:00:00
Service Ops |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 1 | mDay | 2021-08-16 00:00:00 | 2021-08-16 00:00:00
Software |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 1 | mDay | 2021-08-16 00:00:00 | 2021-08-16 00:00:00
Transformation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Management | 1 | mDay | 2021-08-17 00:00:00 | 2022-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 1 | mDay | 2022-01-17 00:00:00 | 2022-01-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 0.5 | mDay | 2022-01-19 00:00:00 | 2022-01-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 1.5 | mDay | 2022-01-17 00:00:00 | 2022-12-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 0.5 | mDay | 2022-01-15 00:00:00 | 2022-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maint Field | 2 | mDay | 2022-01-15 00:00:00 | 2022-01-17 00:00:00
Labour Division | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | TOTAL |  | IDE | 0.5 | mDay | 2022-01-20 00:00:00 | 2022-01-20 00:00:00
Bids
Collaboration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DefaultStart | [NAME] | DefaultDuration
Eng |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | End | Duration
H&S |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-04 00:00:00 | 2022-02-04 00:00:00
HR
IDE
Maint Field
Procurement
Project Management
Quality
Scheme Field
Security
Service Ops
Software
Transformation