Creating Custom field for Schedule Variance Percentage (SVP)

[Harix]

Hi,

Using MSP 2003, I've created a field for Effort Variance Percentage
which allows the PMs to view an Effort Variance view in PWA based on
the data provided for each task scheduled in MSP 2003. Baselines are
saved by PMs in MSP 2003. For this I used the following formula in
custom number field named as Effort Variance Percentage:

([Work Variance]/[Baseline
Work])*100

[Work Variance] and [Baseline Work] both are calculated fields provided
in MSP 2003.

In a similar fashion, I want to define a field for Schedule Variance
Percentage. Which would tell the PM that if a task was scheduled
(Baselined) to Finish on 15th April but it finished on 19th of April
(actuals submitted in time sheets would give this value), then what was
the variance percentage.

I've tried a couple of ideas but since i'm a novice to EPM, haven't
been able to devise a formula for this using MSP 2003 custom/calculated
fields.
The formula for SVP, in my understanding, would be:

SVP = (([Actual Finish] - [Baseline Finish])/[Baseline
Finish])*100

But since all these are fields of type "Date" how can these
calculations be performed for this?
I did try using the fields of type "Duration" for this, but I guess
that makes it lose the concept of 'Schedule" Variance.
I would greatly appreciate if some one could guide me in this regard.
Looking forward,

Regards,
Haris

 

[Dale Howard [MVP]]

Haris --

I don't understand your concept of Schedule Variance Percentage. Percentage
of what? You can show Work Variance as a percentage and Cost Variance as a
percentage, but I can't think of a way to show schedule slippage as a
percentage, because there is no Baseline value against which you can create
a percentage of variance. My suggestions would be that you use a custom
Duration field, enter the formula [Finish Variance], and then display
stoplight indicators in that column to show the severity of slippage. Just
a thought. Hope this helps.