Earned Value Analysis (EVA) graphing from Project Prof

[Nock]

Hi all,

Q. How can you generate EVA based graphs in Excel (2003) from Project 2003
data? I know you can use the 'Analyse Timescaled Data in Excel' from within
Project Professional but I can't get a generic 'time' vs 'cost' view
(with a predicted project finish point).

Also, if you can do this, is it possible to script or code the process?

Many thanks,

Nock

 

[Steve House [Project MVP]]

Exporting with the Analyse Timescaled Data... tool in Project will create an
Excel worksheet with the necessary data. Then in Excel use the graphing
tools to create your curves and use regression analysis to extend them to
predcit the finish date and finish actual cost.

 

[John Garay]

Nock -

If you want to get away from the whole process of creating project reports
and graphs in Exel, this add-on software for Microsoft Project has bundled
earned value graphs based on the AS-4817 standard:
http://www.decisionedge.com/landing_microsoft_earnedvalue.html

You can download a free trial to see your own project data in the charts.

Hope this helps!

Regards,
John Garay
DecisionEdge, Inc.
(e-mail address removed)