Allocating manhours to a month-to-month from a construction schedule
Good day,
I need assistance with separating manhours by month from a construction schedule. The schedule includes a start date, a finish date, and the total man-hours for the duration of each activity. I want to divide these manhours among the specified months for each activity so that I can create a Bell Curve for manhours for each month of the year.
While this can be accomplished using the Excel Macros Developer program, I am unsure how to perform the extraction and separation correctly. Could someone please help me with this process?
Thank you!
PS: The full version has over 2,000 activities
Start | Finish | Manhours |
22 February 2026 | 17 May 2026 | 1871 |
11 March 2026 | 23 May 2026 | 250 |
17 December 2026 | 25 February 2027 | 5988 |
23 May 2026 | 08 August 2026 | 4790 |
08 August 2026 | 25 August 2026 | 250 |
25 August 2026 | 30 September 2026 | 1248 |
30 September 2026 | 10 October 2026 | 524 |
10 October 2026 | 14 November 2026 | 2994 |
21 July 2026 | 30 September 2026 | 5988 |
Good day, I need assistance with separating manhours by month from a construction schedule. The schedule includes a start date, a finish date, and the total man-hours for the duration of each activity. I want to divide these manhours among the specified months for each activity so that I can create a Bell Curve for manhours for each month of the year. While this can be accomplished using the Excel Macros Developer program, I am unsure how to perform the extraction and separation correctly. Could someone please help me with this process? Thank you! PS: The full version has over 2,000 activities StartFinishManhours22 February 202617 May 2026187111 March 202623 May 202625017 December 202625 February 2027598823 May 202608 August 2026479008 August 202625 August 202625025 August 202630 September 2026124830 September 202610 October 202652410 October 202614 November 2026299421 July 202630 September 20265988 Read More