Tegwen has attended:
No courses
Earned Value Reporting
I am using MS Project 2007,but with excel 2003. I have done an earned value over time report and when I look the pivot table in Excel it does not show the same total as that of the project shown in MS Project? I have tried expanding the menus in the pivot table but this has not worked, what can I do to resolve this?
My projects budget is 1.5M but the pivot table shows 0.4M?
RE: Earned Value Reporting
Hi Tegwen
Thanks for your question!
Is it possible to send an example through for me to look at? You can email to info@stl-training.co.uk marking your message for my attention. In the meantime take a look at the built in earned value report by going to Report > Reports > Custom > Earned Value as well as using the built in tables to compare results.
Kind regards,
Andrew
RE: Earned Value Reporting
Tegwen,
I received your e-mail with attachments and I have forwarded the e-mail to Andrew.
Regards, Rich
RE: Earned Value Reporting
Hi Tegwen,
thanks for your question and for bearing with me. Some of the resources have no direct cost associated with them so would not directly generate earned value figures. As you pointed out their costs have been rolled up in costs elsewhere in the plan.
Do let us know if you have any further questions.
Kind regards,
Andrew