Multiple SPI columns

[Brian Lukanic]

Is it possible to track a separate SPI to each of the 11 possible baselines?
Would that require custom programming or am I missing the multiple SPI fields
in Project?

 

[Rod Gill]

You can only calculate earned value fields based on one baseline. However,
you can write a VBA macro to set the calculation to use Baseline1,
recalculate and save the earned value fields you want to custom fields (EG
Text1) then set the earned value to use Baseline2 and so on.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Jack Dahlgren]

Only one of the baselines can be used for Earned Value calculations at a
time.
Conceiveably you could write a macro to iterate through the different
baselines and calculate SPI for each and store it in a particular field. Use

OptionsCalculation EVBaseline:=

to select the different baselines.

-Jack Dahlgren