Tuesday, February 28, 2012 10:14 AM
I am using MS Project 2010. I track project progress by plotting actual % completion vs expected % completion.
I currently use a linear "expected % completion" by taking the start and finish dates of the project and dividing by the number of weeks.
I would like to use the planned data instead of linear data.
How do I do it?
Tuesday, February 28, 2012 2:36 PMModerator
I'm not sure I follow exactly how you are calculating expected % completion but typically this sort of question is handled through earned value calculations. Built into Project 2010 are visual reports including the "Earned Value Over Time" report. Have you looked at that report?
Please be aware that in order to calculate Earned Value you need the following:
- Resources with standard cost rates assigned to tasks.
- Baseline data saved
- Tracking data
- Status date
Do you have this data?
Monday, May 21, 2012 10:55 AM
Sorry that I didn't answer this before.
My projects don't work with costs and, at the moment, we don't baseline.
Instead I use the % complete field in MS Project to show me the status of the project. I'll tell you what I have done to show the 'planned data'.
I use the resource useage view with a timescale of weeks and months. I copy and paste all the hours into MS Excel.
Once it is in Excel and do a total of all the hours per week and a grand total at the end. I then insert another row which shows the % complete of each week (cummulative) of the grand total.
I then plot actual progress agains the planned.
Monday, May 21, 2012 5:50 PMModerator
The result of your calculation in Excel seems to be wht Project calls % Wprk Complete. Try that!
Tuesday, May 22, 2012 12:10 PM
I want to draw a graph showing actual (in red) versus target (in blue) as shown in the picture. My challenge is how to do the target line? In other words, how do I know what the expected (i.e. target) % completion should be? Actual % complete is easy to find as I can take it every week from my MS Project file. The target, however, gets set at the start of the project.
This is what I was trying to describe in my reply above.
Tuesday, May 22, 2012 12:24 PMModerator
The "target" would be saved when you save a baseline. As you have said in an earlier reply that you don't baseline -- this information is unavailable to you.
The baseline is saved after you have the initial plan and without it, you have no method of showing the initial plan.
Tuesday, May 22, 2012 12:58 PM
You are 100% correct that I don't have the info if I don't save a baseline. That is why I do my copy and paste into MS Excel to calculate the target.
If I save a baseline would I be able to find the target % complete for each week from the start until the end of the project? If yes, where would I find it please?
Tuesday, May 22, 2012 1:12 PMModerator
Yes, what you are referring to is Earned Value calculation. There are visual reports which create pivot tables and charts in Excel available if you have the correct data saved.
for a primer on earned value analysis in MS Project.
for information on visual reports in Project.
- Marked As Answer by Mike GlenModerator Tuesday, July 17, 2012 8:23 PM
Wednesday, July 18, 2012 5:19 AM
Thanks for the input.
I don't baseline my projects (yet) so I have to rely on what is in the project plan at the start to show the weekly planned % completion. Each week I update the actual % complete and I plot my progress as per the above graph.
We can close this discussion.