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.

Progress Calculation

3 replies [Last post]
Wed, 2015-09-02 13:20
Kannan CP
User offline. Last seen 4 weeks 5 hours ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi All,

 

In MS Project is it possible to remove the link between percentage complete and remaining durations.

the concern is that based on the assigned emaining duration the achieved/inserted % progress is changing. MS Project is calculating the progress based on duration only.

Thanks

Kannan

Top

Replies

Thu, 2015-09-03 06:31
#1
Kannan CP
User offline. Last seen 4 weeks 5 hours ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

 

Tom and Jose,

Thanks a lot

Top
Wed, 2015-09-02 21:16
#2
Jose Frade
User offline. Last seen 3 years 7 weeks ago. Offline
Joined: 7 Jun 2005
Posts: 144
Groups: None

Another hint:

Change activty type to fixed work.

 

In field Work put your relative weight for all activities (Depending on project type: M/H, etc)

Input progress of activities in field % Work Progress (Don't use activity % )

 

Then your duration does not anymore depend on %

 

Hope it helps

JMFrade

Top
Wed, 2015-09-02 20:48
#3
Tom Boyle
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 28 Nov 2006
Posts: 304
Groups: None

I think you have understood correctly.  "MS Project is calculating the progress based on duration only."  In MSP,  "% Complete" is always the ratio (Actual Duration)/(Duration), where (Actual Duration) = (Duration - Remaining Duration).  You can't change this.

So if you work for 5 days on a task with Duration=10 days, %Complete = 50%.  But if you work another 2 days before realizing that you have underestimated the time required to do the work by a factor of 2, now you have worked 7 days and have 13 days remaining; your %Complete is therefore 7/20=35%.  Backward progress!

If you are serious about using MSP for earned value reporting, then you should be using Physical %Complete, not %Complete.  Or better yet, measure and report earned value progress using other tools.

Good luck, tom

Top