Forum Discussion
Allocating manhours to a month-to-month from a construction schedule
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.