Monthly ,Man hours in xcl format

Shazia,
AAhhhh, the cheap way out.

Why, Why, Why would you even try to do this and use it as a reference for anything?

Come on, let’s get real, were all supposed to be planners, so create a CPM schedule with all activities and resources assigned, then assign the resources required, balance the budgets and then dump the resource spread out into excel by a html report or the SDK.

If we want to have any professionalism and credibility in what we do then we should strive to do the best and most accurate job we can.
Doing this is so wrong, it will come back and bite you later, trust me, every project I’ve seen this method used on runs into trouble as soon as the PM realises how many resources are actually needed in each month.

IT MUST BE DONE WITH A TIME PHASED ALLOCATION OF RESOURCES IN A CPM TOOL. HECK!! EVEN USE MSP OVER EXCEL.

Andy

Dear Sir.

Thanks for your reply.

I know well being planner i have to use CPM,

i made a schedule in P6, wheereas 10 activities starting at the same time, with SS rel. with diffrent crew but same type work.

while i loaded resource , the S-curve like a staright line.
even i change activity S-curve and Bucket as well.

then i put this question accross the Expert like you,

i want to see it is possible in XCL.

Best Regards

Shazia,
You can assign a resource curve (i.e. front load, bell, back load..etc) to each resource assigned and it will change the S-Curve distribution.

S-W-K Shazia,


It is very much possible in excel. You might be getting the straight line s-curve due to the fact that you have 10 similar activities with similar resources.

Please provide more details.