% complete in summary bar

R
richu rose 👤 Member for 19 years 5 months
D
Darren Kosa 👤 Member for 18 years 5 months

Hi Richu,



Sorry I’ll admit first up that I haven’t reviewed your file and I don’t wish to sound condescending, but are you really going down to such granularity with your project controls, that you have to account for a 0.54% delta between your planned and actual progress?



Obviously my comments won’t help you find a solution to your problem, but sometimes wasting a day or two trying to get your formula exact isn’t really an effective use of time in the grand scheme of things.



Just a thought.



Regards,



Darren

R
richu rose 👤 Member for 19 years 5 months

Rafel,



Number1 is the baseline duration in days. It should be 41 instead, i have corrected & still i get the actual progress (56.72%) less than planned progress (57.26%)in the summary bar.



Actual progress= (Actual dur/(Actual dur + Remaining dur))x100

=(35.17/(35.17+26.83))*100

=56.72%

Following is the link of the corrected file

http://rapidshare.com/files/272525538/Project1.mpp.html



Can someone review & let me know where exactly i have gone wrong.



Regards,

Richu

R
Rafael Davila 👤 Member for 22 years 4 months

What does number1 stands for? Maybe a value is wrong or transposed, like a 14 instead of a 41?



Best regards,

Rafael

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts