Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

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 Variance. Help me pls !

9 replies [Last post]
Thu, 2006-04-13 02:32
Rahmat Hidayat
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 30 Jul 2002
Posts: 82
Groups: Petro-Chem / Oil & Gas
Hello all,

I don’t assign any resources or costs in my schedule. I use progress line graphic at actual plan basis to know whether the schedule delay or not . And now my Boss ask me to show the value of percent variance. Can somebody help me pls?

Thank’s

Regards,
Top

Replies

Wed, 2011-08-31 20:53
#1
Darren Kosa
User offline. Last seen 7 years 40 weeks ago. Offline
Joined: 8 Feb 2008
Posts: 256
Groups: None

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

Top
Sat, 2011-08-06 09:11
#2
Rohit K
User offline. Last seen 4 years 20 weeks ago. Offline
Joined: 2 May 2008
Posts: 73
Groups: Civil Engineering

Ioannis,

The numerical 480 in your formula, what does it denote?

Rohit

 

Top
Fri, 2006-05-19 04:38
#3
Ioannis Leontiou
User offline. Last seen 6 years 29 weeks ago. Offline
Joined: 14 May 2006
Posts: 21
Groups: None
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)
Top
Tue, 2006-05-16 19:22
#4
Rahmat Hidayat
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 30 Jul 2002
Posts: 82
Groups: Petro-Chem / Oil & Gas
Yes you’re 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
Top
Mon, 2006-05-15 16:00
#5
Ioannis Leontiou
User offline. Last seen 6 years 29 weeks ago. Offline
Joined: 14 May 2006
Posts: 21
Groups: None
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
Top
Wed, 2006-04-19 00:11
#6
Rahmat Hidayat
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 30 Jul 2002
Posts: 82
Groups: Petro-Chem / Oil & Gas
Thanks alot Harris, it’s good idea. I will assign budget by using formula : Duration X Unit Price. Unit Price is $1. Then I’ll 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

Top
Tue, 2006-04-18 21:02
#7
Paul Harris
User offline. Last seen 1 year 35 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
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
Top
Tue, 2006-04-18 20:39
#8
Rahmat Hidayat
User offline. Last seen 2 weeks 6 days ago. Offline
Joined: 30 Jul 2002
Posts: 82
Groups: Petro-Chem / Oil & Gas
Thanks Harris for your response. You are right that progress variance is calculated based on duration if there is no costs assigned. I’m 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

Top
Tue, 2006-04-18 08:03
#9
Paul Harris
User offline. Last seen 1 year 35 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
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
Top