Request for Variance Recommendation?

[Cree]

I currently have a baseline set, and will be setting a baseline 2. I would
like to show the variance of the 2 baselines, to show how many days longer it
will take. Do you recommend a formula to use for this?

Is there a formula that can show the variance from the actual finish from
the original baseline?

 

[Gérard Ducouret]

Hello Cree,

<<the variance from the actual finish from the original baseline?>>
You don't need any formula : look at the Table Variation :
Views / Table / Variation...

Gérard Ducouret

 

[Cree]

Hello Gerard,

How about if I wanted to show the variance of the original and the 2nd
baseline? What formula would I use for this?

 

[tonyzink]

Hi Cree --

Try this formula for calculating the difference between 2 baseline
finish dates (result is in days):

IIf(([Baseline Finish]=(ProjDateValue("NA"))) Or ([Baseline1
Finish]=(ProjDateValue("NA"))),"Missing Date",(ProjDateDiff([Baseline
Finish],[Baseline1 Finish])/480))

Replace [Baseline Finish] or [Baseline1 Finish] with any baseline you'd
like. Notice that this formula first checks for the existence of a
baseline finish and a baseline 1 finish before continuing with the
calculation.

....And if you'd like to show the difference between another date, such
as Actual Finish, and one of your baselines...

IIf(([Actual Finish]=(ProjDateValue("NA"))) Or ([Baseline1
Finish]=(ProjDateValue("NA"))),"Missing Date",(ProjDateDiff([Actual
Finish],[Baseline1 Finish])/480))

Good luck!

Tony Zink
========================================
http://www.msprojectreporter.com
http://www.pmreporter.com
http://www.sharepointreporter.com
http://www.msofficereporter.com
http://www.dotnetreporter.com
========================================