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.

Total Planned % complete formula

3 replies [Last post]
Forum Guest
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Any one can send me sum of all activities Planned % complete formula (programme)...coz after updating the file instead of planned % of activities i get sum of planned % in total.

Replies

Paul Harris
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
When I am managing serious projects I calculate 4 percent completes:

1. The % of the original duration
2. The % of deliverables completed
3. The % of cost expended
4. The % of hours of labour or mobile equipment consumed

The comparison of the four percentage completes is very useful.

I normally use the P3 % complete for the % of duration, unlink % Complete and Remaining Duration and turn off all the Autocost Rules, I may enter the recorded cost and hours consumed and estimated to complete.

I use global changes to calculate the other three in custom data items.

There is an article titles The Practical Application of Earned Value which is on my web site which outlines some of these techniques.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au
Forum Guest
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
[(sum of OD’s - sum of RD’s)/(Sum of OD’s)]*100 <---you missed it.
cheers
MK TSE
User offline. Last seen 4 years 11 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
According to Primavera KnowledgeBase 1999492110554, the formula is: -
(sum of OD’s - sum of RD’s)/(Sum of OD’s)