Spreadsheet: 846819d1697978195-trying-to-create-a-forumla-that-will-sum-a-list-of-values-with-various-date-range-test-spreadsheet
Sheet: Sheet1

[NAME] |  | 120
Months per cell |  | 0.5
Month Start |  | Jan |  |  |  |  |  |  | Each section of hours will be applicable to a specific activity
Timeline start |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next step
Todays Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date range for specified task |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date on timeline
 |  | 1 |  |  |  |  |  |  | Logistics | Quantity Take-off | Rendering / Animation | Coordination (Precon) | 4D / 5D | Total VDC Precon Hours | Coordination (Ops) | Production Tracking | AR / VR | Laser Scanning | Total Ops VDC Precon Hours |  | Total VDC Hours |  | Precon Work Start | Precon Work Finish | VDC Precon Duration (Workdays) | VDC Completion |  | Precon Work Start | Precon Work Finish | VDC Precon Duration (Workdays) | VDC Completion |  | Ops Work Start | Ops Work Finish | VDC Operations Duration (Days) | VDC Completion |  | RFP / Kickoff | Award Date | Precon Duration (Days) | Mobilization | Substantial Completion | Ops Duration (Days) | Final Completion | Project Duration (Days) |  | Project Duration | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months Remaining | VDC Precon Months | VDC Precon Work Days | VDC Ops Months | VDC Ops Work Days
 |  |  |  |  |  |  |  |  | Precon |  |  |  |  |  | Operations
 |  |  | # | Status | Project | Building Type | Contact | Value | Task |  |  |  |  |  |  |  |  |  |  |  |  |  | VDC Precon Duration |  |  |  |  | VDC Quantity Take-off |  |  |  |  | VDC Ops Duration |  |  |  |  |  | Total Project Duration
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ops Duration
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Precon Duration
 |  |  |  |  |  |  |  |  | Include |  |  |  |  |  | Include
 |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True
 |  |  | 1 | Active | Project 1 | Fitout | [NAME] | $m | 20 | 40 |  |  |  |  |  | 80 |  |  |  |  |  |  | 2023-10-16 00:00:00 | 2023-10-27 00:00:00 |  |  |  | 2023-10-17 00:00:00 | 2023-10-30 00:00:00 |  |  |  | 2023-10-18 00:00:00 | 2023-10-26 00:00:00 |  |  |  | 2023-08-08 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-19 00:00:00 | 2024-01-18 00:00:00 |  | 2024-02-09 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours |  |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  | 2 | Wrap-Up | Project 2 | Life Science | [NAME] | $19.966m |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-17 00:00:00 | 2022-09-15 00:00:00 |  |  |  | 2022-04-17 00:00:00 | 2022-09-15 00:00:00 |  |  |  | 2022-10-01 00:00:00 | 2023-07-19 00:00:00 |  |  |  | 2022-04-10 00:00:00 | 2022-05-17 00:00:00 |  | 2022-07-27 00:00:00 | 2023-08-25 00:00:00 |  | 2023-10-25 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next step
 |  |  |  |  |  |  |  |  | Hours (20) in each section |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours (20) are divided networking days(10) to give hours per day (2) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If the date range for the specific task falls on the date on the timeline the value should be added in this field. If there are multiple tasks that fall within the same date then these values should be added into cell to give a total daily hours