Little bit of Excel help please.
In the Open Standard
Keith JamesMember for 18 years 10 months
- Created
- 3
- 3
0
Is there a way to plot one s-curve against percentage complete on one side and hours earned on the other in that it will automatically adjust the hourly scale to accomodate any added hours??
For example, in my line of work, we establish a baseline s-curve for the expected work against a calender. During the performance we are hit with added work and it adds to our total work scope. When we add the extra work in our schedule, obviously our budgeted man hours increase. I would like to be able to plot my earned manhours alongside my baseline expected manhours with the baseline staying at 100% and the earned climbing and falling as needed without having to go in and manually adjust the scale. Any help would be appreciated
For example, in my line of work, we establish a baseline s-curve for the expected work against a calender. During the performance we are hit with added work and it adds to our total work scope. When we add the extra work in our schedule, obviously our budgeted man hours increase. I would like to be able to plot my earned manhours alongside my baseline expected manhours with the baseline staying at 100% and the earned climbing and falling as needed without having to go in and manually adjust the scale. Any help would be appreciated
3 replies
Oldest first- 0John Lawson ·Hi Keith,
I don’t think you will be able to get excel to plot both hours and percentages on the same chart.
What I have tried to do over my planing years is to work in the unit of manhour /cost, with percentages being just an add on table to give an indication of the progress.I have found this is easy to understand from a managemnt point of view.
I always start with the "original manhours curve", this being what was "seen" at the start of the project.This curve will never changes and will remains unchanged through out the duration of the project.
When addition manhours of scope is added or even deducted I use a second curve called the "current manhour curve" which reflects the changes.
Against the original & current curves I then add the "actual curve" etc.
If the management need percentages I just set up the excel table and use the data from the curves to generate the percentage.
I have a few pdf examples lying about if you like to contact me, I could email over to you
Regards
John L.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?