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.

Updating Microsoft Project

2 replies [Last post]
gaurav singh
User offline. Last seen 10 years 42 weeks ago. Offline
Joined: 2 Sep 2011
Posts: 8

I am updating a microsoft project baseline only on the basis of % completed recieved from contractors for diffrent activities.My schedule is just a list of activities with no cost or resource linked to it. Is it the tright way to update the progress if yes How would you suggest to show the forecast finish dates do i need to manuaaly change it everytime or there is some other way e.g. if actual progress is not as per planned progress than how to show change of planned finish date?

Replies

Trevor Rabey
User offline. Last seen 1 year 22 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None

Some good advice there, but I would add a few points.

Yes, you care mainly about remaining duration, but to get to that you will have to ask some other questions first.

Make sure that you have set the status date in project information.
In any case where a task has an actual anything, such as actual start date, actual duration, actual finish, these must have occurred in the past relative to the status date.
In any case where someting is scheduled, ie scheduled start date, scheduled duration, scheduled finish date, then these must all always be in the future relative to the status date.

This is the date up to which progress is being reported, the date you conduct your inspection or the date that the subbies report (only one date, not separate dates for each subbie).

Mainly start with the facts, and proceed from there to the estimates, in this case the remaining duration.
If the task has started then there must be an actual start date.
If the task has finished then there must be an actual finish date.
If the task has started, and has an actual start date.

You care about the remaining duration for any task which is in progress.

You also care about tasks where the remaining duration = total duration (and therefore actual duration = 0).

You also care about tasks where remaining duration = 0, because these tasks maust have actually started and actually finished. If they did, then you need to know when they actually started and actually finished. This comes from accurate and reliable records kept on site.

Do not insert those various columns/fields into the Entry Table.
Use the Tracking Table instead.
Do not type % Complete.

Evgeny Z.
User offline. Last seen 39 weeks 4 days ago. Offline
Joined: 13 Jan 2008
Posts: 442
Groups: None

Gaurav,

In your situation I suggest, that contractors report you remaining duration, because this is the only thing you care about in reality. This will also help to avoid misunderstanding as if people report percentage complete, it is unclear whether this is percentage of initial estimation or of adjusted estimation.

 

So, you would update the progress of the tasks as follows:

Step 1 upon receiving a report on progress of a specific task you would progress this task till the current date (or the date, for which you have received report). If you do it for selected (not for all) tasks, then you could do it either by adjusting % complete or by manually pulling the progress line on the Gantt chart.  If you have received a progress report from all of the contractors on the same date, you can do it by going Tools =>Tracking=> Update project=>Update works as complete through (date of the progress update)

Step 2 adjust the value of Remaining duration to whatever your contractors have told you. If they are on progress, you would not have to adjust anything.

In this approach the progress of a task represents the date on which it has been updated and duration always reflects the last update on what it will take to finish work.

Example

Initial schedule

Photobucket

Progress updated with the report, received end of Tue 1 January. Note, that remaining (and therefore total) duration of both activities has been adjusted, based on the report from the contractors.

Photobucket

Regards.

Evgeny

 

P.S. I think it was more correct to post your question here: http://www.planningplanet.com/forums/microsoft-project