Hello all,
My company is trying to create some rudimentary Earned Value Reporting tools, and as a first step I was hoping I might be able to create some graphs from existing Schedules in MPO (Project/Project Online).
I was thinking that as a starting point, I would like to create either a table or a graph of Planned Cumulative Project % Complete vs Time. For each task in my schedule, reporting progress as a % currently rolls up into an overall Project % complete, where %ages are based on task work as a %age of the total project work...I believe.
With this in mind, shouldn't it be possible to graph (or make a table) of what %age complete the project should be on each day of the project schedule? I had assumed this would be easy to do, but I can't seem to figure it out. Any guidance anyone could give would be much appreciated! Saving Changes...
Are you struggling to create the graph or struggling to get the data you need to create the graph? The reason I ask is that, unless things have changed since I last used MSP, you have to create a baseline to get the EV data.
I don't have access to MSP, currently, so I can't dig deeper into this on my end. You might have to extract the data, daily, if you want to have a graph of daily changes. Saving Changes...
I don't believe there is a "Baseline % complete" or "Baseline % Work complete" column provided by MSP, so once you have set a Status Date for the schedule and updated tasks based on progress to that status date, you could export the baseline dates and calculate (outside of MSP) what the expected % complete for each task is, aggregate that and compare it with the actual % complete.
Kiron Saving Changes...
Stéphane ParentSelf Employed / Semi-retired| Leader MakerPrince Edward Island, Canada
Community Champion
