Earned Value for specified Periods?

[Chris B.]

Can one get Earned Value for different periods of time

Currently I can "Analyze Timescaled Data in Excel" ... then Output the requested EV Fields to Excel

Do I use Excel to for that functionality? or is there a way to see the information in Project

I've got a couple Ideas for macros that may be able to do that for me, but figured I should ask for fear of missing something fundamental

I appreciate any direction. We were doing all our EV calculations in Excel before Project... now I fear that we may need to keep the Excel for EV. To capture the level of detail we need

[Info: Project 2003 Std]

 

[JackD]

You can do this using the report function. Go to
View/reports/customize/earned value, click edit and set the period to
whatever period you want (weeks, months etc.) Of course the reports are only
printable and you can't paste the data into another application so I would
tend to use Excel instead.

If I am not mistaken the Analyze Timescaled data in excel allows you to set
a start and end date for the export.
That should give you what you need. If I am mistaken, then yes, use excel
for this. It should be fairly simple to do.

-Jack

Can one get Earned Value for different periods of time?

Currently I can "Analyze Timescaled Data in Excel" ... then Output the requested EV Fields to Excel.

Do I use Excel to for that functionality? or is there a way to see the information in Project?

I've got a couple Ideas for macros that may be able to do that for me, but

figured I should ask for fear of missing something fundamental.

I appreciate any direction. We were doing all our EV calculations in Excel

before Project... now I fear that we may need to keep the Excel for EV. To
capture the level of detail we need.

[Info: Project 2003 Std]

 

[John Beamish]

You wrote "Analyze Timescaled data in excel allows you to set a start and
end date for export."

Correct ... but there are two caveats.

First: a maximum of 256 columns means you can't do a daily extract for a
year when the selection criteria is days. (not usually a hardship)

Second: If you choose a date range, say Apr 1 to June 30 but select
"years" as the "units" (on step 3) you will actually get Jan 1 to Dec 31.

You can do this using the report function. Go to
View/reports/customize/earned value, click edit and set the period to
whatever period you want (weeks, months etc.) Of course the reports are
only
printable and you can't paste the data into another application so I
would
tend to use Excel instead.

If I am not mistaken the Analyze Timescaled data in excel allows you to
set
a start and end date for the export.
That should give you what you need. If I am mistaken, then yes, use excel
for this. It should be fairly simple to do.

-Jack

Can one get Earned Value for different periods of time?

Currently I can "Analyze Timescaled Data in Excel" ... then Output the requested EV Fields to Excel.

Do I use Excel to for that functionality? or is there a way to see the information in Project?

I've got a couple Ideas for macros that may be able to do that for me,
but

figured I should ask for fear of missing something fundamental.

I appreciate any direction. We were doing all our EV calculations in
Excel

before Project... now I fear that we may need to keep the Excel for EV.
To
capture the level of detail we need.

[Info: Project 2003 Std]

--