Retrieve the SPI of a previous status date using VBA/macro in MSP

[Anonymous]

Hi,

I want to retrieve the SPI of a previous status date using VBA/macro in MSP
2003 server.

e.g.

I have rebaselined my schedule this week. I believe if I just change status
date and take the SPI of the summary task it will not give me the correct SPI
as it was before rebaselining. Is there anyway to get the true SPI
programmatically.

Thanks for help!

 

[JackD]

SPI is calculated using baseline so you HAVE to have the baseline as it was
before.
Since you have re-baselined it will take either a time machine or a back-up
copy of the file to get the old SPI.
I hope you have at least one of these things handy.

 

[Brian K - Project MVP]

Hi,

I want to retrieve the SPI of a previous status date using VBA/macro
in MSP 2003 server.

e.g.

I have rebaselined my schedule this week. I believe if I just change
status date and take the SPI of the summary task it will not give me
the correct SPI as it was before rebaselining. Is there anyway to get
the true SPI programmatically.

Thanks for help!

Sadly, you have discovered reason number 243 NOT to rebaseline your
schedule. :-(

Next time you will want to use one of the 10 other baselines to resave.
That way you have the past ones for doing what you are asking.

In that case your macro would need to capture the current status date
in a variable

X = ActiveProject.StatusDate

Then set the status date to the old date

Activeproject.statusdate = "1/1/2000"

Then look at the SPI for the task and then set the Status date back to
the date in X.