Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Earned Value S Curve from Project 2010 visual informs

No replies
Angel Barragán
User offline. Last seen 10 years 16 weeks ago. Offline
Joined: 2 Dec 2013
Posts: 3
Groups: None

Hello everyone,

 

This is my first post over here, and I have a question about S Curve (PV, EV & AC). Everything works out good on project 2010 when exporting the data to Excel, I even managed to customize the spreadsheets to my convinience, but there is only one issue about the Earned Value graphic, and its about the way project distributes earned value costs throughout the duration of tasks.

It appears that project assumes the Earned Value cost at the start of the task, no matter how the resource payment method is (at beginning, prorate, at completion).

So whenever I try to graphic the S Curve, PV shows prorated (BLUE) but EV (GREEN) shows values at the start of tasks and keep the number constant.

 

1879
captura.png

 

This is the result of a sample project I made, the graph shows the completion of the task at (100%) in the first day of the project, and it does not prorate the efford made through the duration of the task. Is there a way to make project export data to excel that has the values of Earned Value prorated through the duration of the task?