Updating Microsoft Project

Member for

19 years 11 months

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.

Member for

17 years 9 months

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