Forum Discussion
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 activ...
How should the hours be allocated to the months? Based on the number of calendar days in each month? Or on the number of working (non-weekend) days in each month? Do we have to take public holidays into account?
HansVogelaar Hans, the schedule is based on 6 days a week, only Fridays are excluded, as this project is in the Middle East. The process is to extract the months-to-month between the start and finished dates and then allocate the manhours prorate to each month based on the months within each line activity and the respective days in the relevant months. I was informed that one must use Developer with Macros in Excel, and then insert a formula and the system will automatically do the extraction and manhour allocation. But I don't have the knowledge to do the formula/s.
