Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
earned value reporting

Forum home » Delegate support and help forum » Microsoft Project Training and help » Earned Value Reporting

Earned Value Reporting

ResolvedVersion 2003

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

MS Project tip:

Use Autofill in MS Project

a. Complete 1st entry
b. Select cell with entry to be copied
c. Click & drag autofill handle over the lines to also contain the same information. (the autofill handle is the little black square in the bottom right hand corner of the heavy lack outline on the selected cell)

View all MS Project hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.