Earned Value Visual Report

A

Anna

Good morning,

I am currently working in Project 2007.

I have developed a schedule, added resources and costs, and saved the
baseline. The cost under view/tables /more tables/earned value all add up
nicely. When moving out the status date to 1 month out and then updating by %
Complete, the cumulative totals all work out as well.

When I go to Earned Value over Time report in visual reports, the totals all
add up in the assignment usage with/EV looks good.

The problem I have is I want to be able to see the planned value for the
entire length of the project, and than Earned value by % complete. The report
will show me earned and planned value and then it takes a nose dive when
values are 0. I'm guessing that is caused by the staus date. It's not showing
as a cumaltive total (level line until it's updated) Please let me know how I
can show the planned value for the entire project and be able to show both
planned and earned value all as cumulative totals so my chart won't take a
nose dive.

Respectfully,
Anna
 
J

Jim Aksel

Set the status date to time now, take %Complete.
Reset the status date to the last day of the program.
Now go for your EV Chart.

This will get your PV (BCWS) curve out through the program.
If your AC and EV (BCWP) curves still take a nose dive, you will need to go
to Excel and delete the zero values in those rows that are beyond the real
status date.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com
 
A

Anna

Wow!! It works! Thank you so much!!

Jim Aksel said:
Set the status date to time now, take %Complete.
Reset the status date to the last day of the program.
Now go for your EV Chart.

This will get your PV (BCWS) curve out through the program.
If your AC and EV (BCWP) curves still take a nose dive, you will need to go
to Excel and delete the zero values in those rows that are beyond the real
status date.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top