Progress Calculation

K
Kannan CP 👤 Member for 17 years 11 months

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

J
Jose Frade 👤 Member for 21 years

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

T
Tom Boyle 👤 Member for 19 years 6 months

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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts