Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Man Hours versus Time S Curve

5 replies [Last post]
Jenny Ingco
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 9 Jan 2012
Posts: 116

Dear Schedulers,

How I can do "Man Hours versus Time S Curve" from P6 data? I mean I don't know how to calulate the Man Hours? I appriciate any idea from you.

 

Thank you,

 

Hanson

Replies

Leo Man
User offline. Last seen 12 years 25 weeks ago. Offline
Joined: 11 Jun 2012
Posts: 7
Groups: None

Simple way to create Man-hour versus time.

in the gant chart shwo labour units instead of bars ,copy the total in the excel sheet and draw the s-curve.

Daniel Limson
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hanson,

Assuming that you already have a resource loaded programme and your scheduling mimimum time is a day, then probably the data in your P6 programme is in Mandays (Budgeted Labour). To calculate your manhours simply multiply mandays x working hours/day.

Hi Raphael,

Actually, I have seen some companies manage their projects successfully just based on time and experience, especially where labour is cheap and resources is unlimited.

Good to hear from you!

Daniel

Rafael Davila
User offline. Last seen 2 days 17 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5241

I believe Hanson made it very clear what he is looking for;

Man Hours versus Time S Curve = Cumulative Man Hours on the vertical axis plotted against time on the horizontal axis. The S refers to the shape and gives you the clue to the requirement for it to be a cumulative function of mh values as they accumulate with time.

I do not believe he is looking for a "Duration S", a meaningless curve of no real value at all.

Mike Testro
User offline. Last seen 12 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

Hi Hanson

You can simplify Daniel's excellent advice by creating just one resource called "Hours" and apply that to every task and modelling as advised.

You can allocate the relative trade to the task by using codes - then you can create individual S curves by filtering on the code.

Best regards

Mike Testro

Daniel Limson
User offline. Last seen 5 years 30 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None

Hanson,

Time S Curve is based on duration, whilst Manhours is based on Labour Resources. In order to develop a "progress curve' based on manhours, you need to resource load your programme, meaning you need to evaluate each activity task and assign resources against it. First you need to know the quantum and production rates involve for each task, then you need to identify resources required and how much resource you need to finish a task.  If you do not know how, you need to talk to your construction team and get an idea concerning the size of a team for each activity task.  Once you have all the data in your hand, you can start resource loading the programme. Whoever did the programme, must have assumed something in order to get the duration, if not, then you need to review the duration based on your production rates and resources and amend the duration if necessary.

Once you have finish resource loading, you can copy and paste the mandays or manhours distribution in P6 to your excel file and produce a progress chart.

Best of luck,

Daniel