Microsoft Project

[Mark]

Is there a way to incorporate Cumulative Work as a Column to use for
calculations?

 

[Rod Gill]

No, it's only available in a usage view. Actual work is cumulative of
course, but only to last update.

What calculation do you want to do? It's probably possible using VBA.

 

[Mark]

Value of Work (Scheduled Performance Indicator (SPI)). Basically the
difference between Cumulative Work (BCWS) and the Earned Value of Worked
Accomplished (BCWP). It's a number which informs us if a contract is on the
projected schedule.

I already have the program calculating BCWP. I need the BCWS (the projected
cumulative hours to date) to complete the formula.

 

[Rod Gill]

That field is already calculated and available. Try clicking View, Table,
More tables and looking at the three Earned Value tables.

 

[Mark]

Already tried. They don't calculate to the values I need. This corporation
doese EVMS reporting a little different. Most of the values I had to
manually formulate.