In MSP 2007, charting EAC/SPI/CPI over time through status date

[Robin]

Using MSP 2007, how do you chart Estimate At Completion (EAC) from the start
of the project through the status date, over time (days, weeks, etc.)? Or,
how do you do the same for CPI or SPI?

 

[JulieS]

Hello Robin,

Estimate at Completion is not a time-phased field so although you
could use Visual Reports to view the data in Excel, it would not be
time-phased. For SPI and CPI, you could use the Earned Value Over
time Visual report to show Earned Value (BCWP) , Planned Value (BCWS )
and Actual Cost of Work Performed (ACWP) in a pivot table. You could
then calculate and chart both SPI and CPI in Excel.

SPI = BCWP/BCWS
CPI = BCWP/ACWP

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project