Solved

Tracking duration and progress in Microsoft Project

Posted on 2012-03-15
3
605 Views
Last Modified: 2013-06-09
Good day experts,

I have several projects running which are all scheduled using Microsoft Project 2010 Professional.

I want to confirm the best way to track progress against the schedule.  I currently have an Excel table listing each project with start date, end date and current date.  I use Excel to calculate the percentage of project duration completed.  For example, if the project lasts 20 days and we are 10 days passed the project start date, then 50% duration has passed.  I then feed into the Excel sheet the amount of work percentage completed from the project schedule.

This is not the best way to do it because 50% of time passed doesn't necessarily mean that 50% of the work must be completed.

The ideal solution for me would be to get two measures from the project schedule iteself:
- Percentage work that should have been completed on current date
- Percentage work that is atually completed on current date

Please advise on best way to achieve this

Many thanks
0
Comment
Question by:PantoffelSlippers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
GasperK earned 200 total points
ID: 37724322
Hi,

First you must update your tasks Status. In Project, you can update a task status in three ways,

1. On the Task tab in Schedule you have icons where you can say just by one click that the task is 0%, 25%, 50%, 75% or 100% done. Any other value can be entered by double clicking on the task and in the Task Information window on the General tab enter Percent Complete.
2. Another way is by the Mark On Track button which will automatically update percent done according to the Status date set. You can do this task by task or for entire Project if you choose Update Project on the Project tab, Status group...
3. The third way gives you most freedom (and is usually used when everything did no go as planed), but is the hardest to use since it's manual. You choose the Task tab, and in the DropDown menu next to the Mark on Track command mentioned before choose Update Tasks.

Either way, when you update the tasks, you then go to Project Tab, Project information and Choose Project Statistics. At the Bottom you will find Duration and Work both in percents...

Hope this helps...
0
 
LVL 18

Assisted Solution

by:xtermie
xtermie earned 150 total points
ID: 37783330
Gasper is quite right
For your case using (2) is probably the best.

Just a word of advise if you will...if you want to have 2 columns one for ACTUAL % completed and one for ESTIMATED % completed then you should display the % Completed column/field and the Physical % Complete and/or the % Work Complete (choose 2 of these) and have the two measures you want.
0
 

Author Closing Comment

by:PantoffelSlippers
ID: 39232799
Apologies, I didn't realize this question is still open.  My question isn't really answered but I'll investigate further.
0

Featured Post

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
IT project management 7 141
Excel Bar Chart Inverting My Task Names in the Y Axis 7 74
Verify person is in the US 6 211
Looking for an APP to manage tasks and time 3 41
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Read about why it is more lucrative for an IT company to participate in government projects.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question