Progress Calculation

K
Kannan CP 👤 Member for 18 years 1 month

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 1 month

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 7 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

Featured Partner

Top Posters

Alex Lyaschenko
27 posts
James Williams
75 posts
xerxes
0 posts
edwin
0 posts
jhalluk69
0 posts
wilmoahyi
0 posts
Peter Holroyd
51 posts
Robert Guers
1 posts
Jerry Robinson
2 posts
Elyar Safarov
1 posts

Our Partners