Prev: Project Summary Task
Next: Project Summary Task
From: EJ on 27 May 2010 16:31
Thanks Roland... I figured it out... Apparently in (Tools-->Options) ,
there is a place where you can set the baseline for calculating Earned Value.
Setting that baseline affected how Finish Variance is calculated... I tell
ya that was driving me NUTS!!!...

"Roland" wrote:

> Check to see if Calculations (Tools-->Options) are set to Automatic or
> Manual. If Manual, either change to Automatic or press F9 to recalculate
> your values. If you've rebaselined all the tasks then your finish variances
> should equal 0.
>
>
> "EJ" wrote:
>
> > I am using the following formula to show forcasting of task for 10% late:
> > [Finish Variance]>(ProjDateDiff([Project Start],[Project
> > Finish])*0.1),"Red"... I rebaselined my project however it seems that the
> > finish variance is not right...
> >
> > Finish: Mon 8/9/10 5:00 PM
> > Baseline Finish: Mon 8/9/10 5:00 PM
> > Finish Variance: 142 days
> >
> > Am I looking at the wrong columns? HELP ASAP...
> >
> >
> >
> >
From: Jim Aksel on 27 May 2010 17:17
Quick comment. Your formula says "If the finish variance of a task is
greater than 10% of the duration of the entire project, return "Red"

Might you want [Start] and [Finish] instead of [Project Start] and [Project
Finish]. Or, in effect: Iif([Finish Variance]>0.1*[Baseline Duration],
"Red","????")

This way, you are turning a single task "red" only if a single task finishes
late by more than 10% of its own baseline duration.
--
Jim Aksel, MVP

Check my blog for more info:
http://www.msprojectblog.com

This newsgroup is moving, try here too:
http://social.answers.microsoft.com/Forums/en-US/addbuz/threads




"EJ" wrote:

> I am using the following formula to show forcasting of task for 10% late:
> [Finish Variance]>(ProjDateDiff([Project Start],[Project
> Finish])*0.1),"Red"... I rebaselined my project however it seems that the
> finish variance is not right...
>
> Finish: Mon 8/9/10 5:00 PM
> Baseline Finish: Mon 8/9/10 5:00 PM
> Finish Variance: 142 days
>
> Am I looking at the wrong columns? HELP ASAP...
>
>
>
>
From: Roland on 27 May 2010 17:34
Check to see if Calculations (Tools-->Options) are set to Automatic or
Manual. If Manual, either change to Automatic or press F9 to recalculate
your values. If you've rebaselined all the tasks then your finish variances
should equal 0.


"EJ" wrote:

> I am using the following formula to show forcasting of task for 10% late:
> [Finish Variance]>(ProjDateDiff([Project Start],[Project
> Finish])*0.1),"Red"... I rebaselined my project however it seems that the
> finish variance is not right...
>
> Finish: Mon 8/9/10 5:00 PM
> Baseline Finish: Mon 8/9/10 5:00 PM
> Finish Variance: 142 days
>
> Am I looking at the wrong columns? HELP ASAP...
>
>
>
>
 | 
Pages: 1
Prev: Project Summary Task
Next: Project Summary Task