Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

% complete compared to actual % complete

6 replies [Last post]
Richard Whittaker
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 8 Dec 2005
Posts: 8
Groups: None
Does anyone know if it is it possible to compare estimated % complete with actual % complete in MS?

Replies

Richard Whittaker
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 8 Dec 2005
Posts: 8
Groups: None
Trevor/Paul

Thanks for the advice. I will look into Earned value as the way forward. Trouble is MP is seen as a tool to produce a gant chart and thats it really. % complete does not tend to use denominators it is based on opinion ( so subjective).

That is probably good for the level the organisations I work with at the moment, but I intend to integrate MP and its benifits beyond a graphical interpretation of the programme into a true analysis tool on costs, progress, short term planning delivery schedules etc, etc,

Once again many thanks

Richard W
Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Richard,
MSP does not know that you are laying bricks or pouring concrete or shooting pigeons or whatever. There is nowhere in it (with the possible exception of "% Physical Complete which does not get used to calculate anything until later, maybe, at EV calculation) to say that you have laid 300 bricks out of 1000 bricks.
There is nothing to stop you using spare (number) fields to note the number of bricks (or m3 of concrete whatever) and the total planned bricks and then calculating with a formula the % of bricks laid in another field.
"% anything" is always best left to be a calculated number from raw data rather than raw data.
If someone (the junior engineer) tells me that "the roof is 50% complete" I want to know which numerator and denominator they used to calculate that, especially if it is a mixture of framing, tiling, guttering etc.
"the roof is 50% complete" is a very ambiguous phrase.
It could mean:
"% of m2 actually done compared to total m2 planned"
or "% of actual hours compared to total budget hours/as planned hours/estimated hours"
or "% of actual Cost compared to total budget cost/as planned cost/estimated cost".
One very popular calculation is done by eyeballing the work in progress, guessing at "% progress" (whatever that means without a numerator or denominator) and calculating a figure called "Earned Hours" by "Earned Hours" = "% progess" x Total budget Hours for the Task. And this is then used as a proxy for EV.
I don’t like it. I don’t recommend it. I don’t know why it is so popular but it is. I don’t see why it is necessary or useful or why it is used instead of Cost or why Cost isn’t used as well or instead of. I’ve got issues with it which I won’t go into here.
Similarly "% progress = such-and-such" is ambiguous, verging on meaningless and downright dangerous, if we don’t know what is being measured as a % of what.
"% Complete" is % of Duration elapsed, as a percent of total estimated duration for the Task.
% Complete is best left to be calculated by MSP rather than being put in by you.
It is a mistake to see 300 bricks out of 1000 laid and type in 30 at % Complete, even if it is also true that 30% of the planned Duration has elapsed, and therefore the % Complete does equal 30%.
When you have set a baseline set (Tools, Tracking, Baseline), and the Tracking Gantt View, with the Tracking Table and the Tracking Toolbar all displayed you can select the Task and upate it.
Before starting to update, make sure you have nominated the Status Date in Tools, Project Information and by right clicking in the Gantt Chart area, format the gridlines with a nice vertical red line straight down the Status Date.
Do not show progress Lines because they are a useless source of confusion.
The first thing to put in is the Actual Start Date.
However, if you know that it started on the scheduled start date (The ES for CPM and scheduling forward) you can skip this step because the Actual Start Date will be assumed to be the ES when you do the next step, but it is important to put in the Actual Start Date if it is different from the ES.
Next, with the Task still selected, and assuming that bricklaying has proceeded continuously since the start (not a bad assumption), click the "update as scheduled" button on the Tracking Toolbar. If it started and stopped this must be accounted for and can be, but let’s not just yet.
Try this with just one Task "Lay 1000 bricks" with Duration = 10 days, resource = bricklayer WORK $50/hour, + resource = 1000 bricks MATERIAL $1000 cost-per-use.
Then run through the update exercise described above.
Then try variations.
What happens if the Status Date is at end of Day 6, you hope to see 600 Bricks laid but only 300 are?
How do you put this in MSP (or do you?) and since our original duration estimate was way off and should have been total 20 days because observed production is half of what was estimated/hoped for, how and when do you re-estimate the Remaining Duration and when you do, what happens to that Task’s Successors?
Many people do not like to convert bricks or concrete or pigeons to Cost but it is the only way to reduce them all to common dollars in order to do EV which needs BCWS, BCWP, ACWP.
The C stands for Cost, and that’s dollars, not bricks/concrete/pigeons.
It doesn’t stand for (man) Hours of Work either, unless all hours cost the same dollars.

peace to all for xmas
Paul Harris
User offline. Last seen 1 year 4 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
The “estimated % complete” that you are referring to I believe is the term more commonly called Planned or BCWS (Budgeted Cost of Work Scheduled).

Microsoft Project does provide this data as a field titled BCWS.

You need to be aware of several features in MSP:
1. A Baseline should be set.
2. The Status Date should be set in Project, Project Information.
3. The earned value calculation option should be set in Tools, Options, Calculation, Earned Value should be chosen.
4. Progress the schedule
5. Then display the Earned Value Table to view the earned value fields.

There are reports of the Earned Value calculations in MSP not calculating correctly and in particular the rolled up values against the summary tasks. This is especially an issue when new tasks are added and/or detailed tasks are moved to another summary tasks and the baseline against the summary task is no longer valid. I have had experience of this myself but it would take too long to explain in this email the issues and functions available in MSP that address the issues. Also Earned Value is an area where different versions of MSP may calculate differently due to the development of additional functions and attempts to fix the calculation issues.

There are several other options that people use to get more accurate earned value information from Microsoft Project 2003, these are:
1. To customize some numerical fields within MSP to provide the necessary information, especially non financial data
2. To export to a spreadsheet and manipulate the data and
3. To export to Earned Value software.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Richard Whittaker
User offline. Last seen 12 years 48 weeks ago. Offline
Joined: 8 Dec 2005
Posts: 8
Groups: None
Hi Trevor

Thats exactly what I mean, same as being at week 5 on the programme but only completed programmed work up to week 3
Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
let me try.
actual % complete is like you look at the site and 300 bricks have been laid out of 1000?
estimated % complete is how many bricks your current plan says that you estimated or expected to have laid by now?
Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Rather than me assuming what I think you mean, can you define further what you mean by these terms?