Progress Variance. Help me pls !
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
Hi Rohit,
It's how MS Project calculates Duration and Work in formulas. You basically have to convert it into minutes, so 1 day would equal 8 hours (if you use 8 hrs as a standard day), and as there are 60 minutes in each hour you end up with a value of 480.
Regards,
Darren Kosa
Ioannis,
The numerical 480 in your formula, what does it denote?
Rohit
Plsease try the formulas as shown below; may be what you would expect
Nunber 1
(Days of workload should have completed as per status date, measured on Baseline data
Nunber 1
IIf([% Complete]>0;IIf([% Complete]<100;([Baseline Duration])/480-((ProjDateDiff([Status Date];[Baseline Finish];"standard"))/480);0);0)
Number 5 (Per Task % delay) (only for active tasks)
IIf([Number1]<>0;(([Number1]/[Baseline Duration])*480*100)-[% Complete];0)
Yes youre right Ioannis. There is an overall progress information in the Statistic based on duration too. But I need progress variance per activities based on duration.
Regards,
RH
If I have understand correctly your question, you can have percent completion value on project duration provide you have already enter actual data,
For an overall view, go to Project>Project Information Statistics
Thanks alot Harris, its good idea. I will assign budget by using formula : Duration X Unit Price. Unit Price is $1. Then Ill get BCWS and BCWP in $. For the percent BCWS or BCWP just dividing them with the Budgetted Cost of each task then the delta of both percentage is the % variance.
Thank you very much.
Kind Regards,
RH
You could try a couple of options
1. Enter a dummy cost for the software for each activity which will calculate the BCWS. This could be using the Fixed Cost column. Then use a Custom column to calculate the Planned % Complete. The cost could be the same as the original duration if you are looking for Planned % Complete based on Duration, or you could enter some more realistic values.
2. Use a Custom Column to calculate the % Complete based on the Early Start, Early Finish and Status Date.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Thanks Harris for your response. You are right that progress variance is calculated based on duration if there is no costs assigned. Im sure MsP plot their zig zag progress line using this method. But my problem is still same how to show such percent variance if the progress calculated based on duration.
Thanks in advance.
regards
Unless there is a value in terms of cost, hours or deliverables etc assigned to activities and progress of these is measured then it is not possible to give a percentage variance except as a function of the durations of activities.
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au