How do I export an "Earned Value" report to Excel?

[Dennis]

I need to export an Earned Value report to excel, but I can't figure out how
to do it. Does anyone know how to do do this?

br
Dennis

 

[Manmeet Chaudhari]

Hi Dennis
Kindly follow these steps
1. From tools menu select customize- toolbars- analysis
2. From the analysis toolbar select analyze timescale data in excel option
3. A new wizard comes up follow it step wise
4. In the available field option select all the earned value fields and add
it under fields to export
5. Select the date range and click on finish
6. Thus you will get all the required data in excel

Let me know if this works

Thanks



Manmeet Chaudhari
Technical Trainer
Maestros Mediline Systems Ltd
Mumbai

 

[JulieS]

Hi Dennis,

Manmeet has given you some information on exporting timephased earned
value information to Excel. You can also export non-timephased data
(similar to the Earned Valued table) to Excel.

1. File > Save As and choose Excel Workbook as the file type. Name the
file and select a location to save to.
2. In the Export Wizard, choose Next >.
3. Choose Selected Data and choose Next >
4. Choose Use existing map and choose Next >
5. Select either the "Earned value information" map. The Earned value
information map contains the fields found in the Earned Value table.
6. Follow the wizard through and you may add any additional fields you
like to the export.
--
I hope this helps. Let us know how you get along.

Julie

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