Baseline Finish to Finish Variance

[Frank Cox, PMP]

Subject formula: IIf([Baseline Finish]>50000,"No Baseline",[Baseline
Finish]-[Finish])

Setting up a text field, Text1 for example, to calculate variance between
the Baseline Finish date and the Finish date with the formula above yields
useful measurement information. Unforturnately, an additional calculation is
required because weekend and other nonworking days get included in the result.

For example, apply the formula to Text1 and then, using Project's default
calendar and task type settings, enter a five-day task into the schedule that
starts on a Monday and ends on a Friday. (Do not resource load the task.)
Next, set the baseline for the task. Next, change the task's duration from
five to 11 days. The task should now span two weekends and finish on a
Monday. When calculated, the variance will be 10 days (actually -10 days
based on how the formula is structured), with six workdays and four weekend
days included. The variance of interest is the six workdays.

Making one of the workdays that is within the 11-day task's duration a
non-working day will cause the formula to calculate 11 (-11) days of
variance. The task's duration will not change, but the finish date will of
course be a day later and the total days of variance will increase by one.
Now five non-working days need to be subtracted from the total to reveal the
six workdays of variance.

Any MVPs or others out there know of a way to modify the formula, or is
there a replacement for it or a macro that may be shared to automate the
subtraction of weekend and other nonworking days so the result is workday
variance?

 

[Dale Howard [MVP]]

Frank --

I believe the Finish Variance field contains the exact information you seek,
expressed in working days only, and taking into account all nonworking days.
Hope this helps.

 

[Jan De Messemaeker]

Hi,

I think Dale's right about Finish Variance but as well, use the ProjDateDiff
function rathe rthan a simple minus.
HTH

 

[Frank Cox, PMP]

Okay, thanks Jan, and thanks also to Dale for his eariler reply.
--
Frank

Hi,

I think Dale's right about Finish Variance but as well, use the ProjDateDiff
function rathe rthan a simple minus.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

Subject formula: IIf([Baseline Finish]>50000,"No Baseline",[Baseline
Finish]-[Finish])

Setting up a text field, Text1 for example, to calculate variance between
the Baseline Finish date and the Finish date with the formula above yields
useful measurement information. Unforturnately, an additional calculation is
required because weekend and other nonworking days get included in the result.

For example, apply the formula to Text1 and then, using Project's default
calendar and task type settings, enter a five-day task into the schedule that
starts on a Monday and ends on a Friday. (Do not resource load the task.)
Next, set the baseline for the task. Next, change the task's duration from
five to 11 days. The task should now span two weekends and finish on a
Monday. When calculated, the variance will be 10 days (actually -10 days
based on how the formula is structured), with six workdays and four weekend
days included. The variance of interest is the six workdays.

Making one of the workdays that is within the 11-day task's duration a
non-working day will cause the formula to calculate 11 (-11) days of
variance. The task's duration will not change, but the finish date will of
course be a day later and the total days of variance will increase by one.
Now five non-working days need to be subtracted from the total to reveal the
six workdays of variance.

Any MVPs or others out there know of a way to modify the formula, or is
there a replacement for it or a macro that may be shared to automate the
subtraction of weekend and other nonworking days so the result is workday
variance?