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.

Planned % complete column

6 replies [Last post]
Wed, 2009-02-11 09:36
Christopher Paulraj
User offline. Last seen 15 years 6 weeks ago. Offline
Joined: 11 Feb 2009
Posts: 8
Groups: Civil Engineering
Can you please tell me how to get a Planned % complete column? Basically i wanted to have a progress programme showing % complete column, planned % complete column and planned and actual start dates?
Top

Replies

Thu, 2009-02-12 13:04
#1
Se de Leon
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 15 May 2001
Posts: 321
Groups: None
As long as you have a proper CPM in your schedule, you can always calculate delays in MPP.

Step 1: Update completely and accurately your project
Step 2: Use Tools Tracking Update Project, then click Reschedule uncompleted work to start, then assign a date.
Step 3: Review your updated Critical Path
Step 4: if you can do it, mitigate delays, if not, voila, you have your updated completion date.

I hope this helps.
Top
Thu, 2009-02-12 12:53
#2
Christopher Paulraj
User offline. Last seen 15 years 6 weeks ago. Offline
Joined: 11 Feb 2009
Posts: 8
Groups: Civil Engineering
Thanks

Is there any way to calculate potential days delay or Slip?

Rgds
Chris
Top
Thu, 2009-02-12 12:39
#3
Se de Leon
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 15 May 2001
Posts: 321
Groups: None
There’s another way to do this.

Saving a separate file of your baseline project, and name it as "as planned" file. Use the Tools Tracking as complete through, then assign a date. After MPP calculates the % complete, copy paste this field to your baseline or current project as a text field. This is similar to P3, the only difference is you have to cut and paste the calculated as planned %, not assign the "as planned" schedule as a target schedule.

what darren has explained is perfect if you really want a dynamic way of showing the as planned %. If you have not get the hung of the complicated formula, you may use the above as an alternative way to show as planned %.

Cheers,
Top
Thu, 2009-02-12 11:41
#4
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Chris,

Whichever field you’ve used to show Planned % Complete, should also have ‘calculation for task and group summary rows’ options. Check the ‘use formula’ radio button and it should then roll up to summary levels.

(Tools > Customize > Fields)

Regards,

Darren
Top
Thu, 2009-02-12 06:25
#5
Christopher Paulraj
User offline. Last seen 15 years 6 weeks ago. Offline
Joined: 11 Feb 2009
Posts: 8
Groups: Civil Engineering
Thanks Darren,

The formual perfectly works, but it doesn’t calaculate for summary bars. is there any solutions to calculate the baseline % complete for summary bars?

Rgds
Chris
Top
Thu, 2009-02-12 05:59
#6
Darren Kosa
User offline. Last seen 7 years 10 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None
Christopher,

This thread should suit your needs. Look at post #2 from Niek Zonneveld.

Display Baseline Percent complete in MS Project

By the way you need to set a baseline for it to work. ;o)

Regards,

Darren
Top