Hi all,
I am new to the forum,would like to request all of you to share your thoughts on the question.
I am a planning engineer working on construction projects in the Middle East,I have to deal with a lot of number crunching on a daily basis.
Right now I have a list of activities with their start and finish dates,and also the manpower needed for the same.The manpower shown is what is required on a daily basis.
For eg . if start and finish dates are Aug 2 and Aug 6 respectively and the no. of plumbers is 6,it means 6 plumbers are needed on Aug 2,3,4,5 and 6.
What I need is,I need to calculate the total manpower which will be needed on each day,trade-wise i.e how much will be the total required manpower on a specific date?
I have done this exercise manually,but I'm sure there will be a way to do it easily(using Pivot tables or similar).
Please can anyone shed some light on the problem?
( i'm attaching the excel sheet)
Thanks in advance
Bookmarks