if you are ahead of schedule, and you want to show acutal before/on data date, and without changing the duration, it seems impossible. you must shorten the remaining duration.
another way is like Raj mentioned use resource contour, but that means you are just on schedule, not ahead of schedule.
I have noticed many questions on this site about how to do certain things in MSP.
The main problem I believe is that the product has "evolved" over the years from a DOS based bar chart program with no real fundamental change to its critcal path engine.
I have been using it for more than 20 years (mainly because my clients insist)
As a result people are believing the marketing propaganda and using this tool for important work and expecting it to give them accurate answers. Beware , there are no work arounds for some of the issues with MSP except to use another product.!
PS I am not associated with any software company, I am just a planner (long in the tooth) who has seen these problems for many years and Microsoft is not really interested in making their product into a professional planning package. It is not competing (so I have been told by its marketing people ) in that market !
Before I started here, they use to status there schedules by simply changing % complete or % work complete. This does not allow you to ever show improvement on a schedule if your performance is actually greater than your planned, since it assigns the actual work into the "actual work" field of future dates (i.e. after the status date) and therefore your finish date does not change until you enter the actual finish date. The only way I can find around this is to calculate the actual work or actual cost for the reporting time period and enter it as an actual in the task usage block for the time period reporting. This allows the finish date to shrink and show schedule performance improvement. This is a pain but we can not determine another way to do this.
As per rule if your actual is more than planned then progress will show beyond status date unless otherwise it will reduce the remaining period of that task. So you just update the actual % work and update the full shedule or just selected activity specifying your status date then your progress will not go beyond status date but certainly it will reduce the remaining duration, if you dont want to change the duration also so keep your task as fixed duration then it will adjust unit.
Member for
20 years 7 months
Member for20 years7 months
Submitted by Brent Hursey on Wed, 2005-03-23 15:34
We are having a problem with the same issue. I have just started at a company where they update work by changing the % Work Complete. They do not want actual work to be allowed to be after the status date. They ask me to research a way to prevent this. I know of none. It requires manual manipulation of the data after entering the % Work Complete. I suggest use % Work Complete to calculate actual hours for the reporting period. Still working on this one.
I cant believe there is no option in Project to prevent this from occurring. It is not logical.
If I understood correctly you mean, in your long duration activity, most of the work done early and you want to show it upto data date. Make resource contour and enter the most of the work early stage. Then while updating work put the actual work accordingly.
You are now facing one of the many challenges of using Microsoft Project to update a resourced schedule. Microsoft Project does not by default calculate the end date of an in-progress task from the Status Date using the Remaining Duration (as one would expect), but from the Actual Start Date and the Duration. Therefore your assumption is correct.
It has been my experience that it takes four time longer to update a resourced schedule in Microsoft Project than other products.
There are some functions designed to assist the scheduler in statusing a schedule but often these lead to more confusion, have a look at:
1. Tools, Tracking, Update Project, Reschedule uncompleted work to start after option, ensure that the option split in progress tasks is turned on and if you do not want to see the splits then select Format Layout to hide the splits.
2. You may wish to try the Tools, Options, “Updating task status updates resource status” which unlinks Percent Complete and Percent Work Complete.
3. If you had MSP 2002 or 2003 you may wish to try the four options listed directly under Tools, Options, “Updating task status updates resource status”, the first one described as “Move end of…….”
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
Member for
21 yearsRE: Actual Work Shown After Update Date
Tom,
What you say is perfectly true, MSP has it’s problems, but in general still works, just don’t try resourcing it.
Zhang,
Sometimes we get the durations wrong, that is what Erik was referring to, i.e. we create a little float this way.
Regards
Philip
Member for
20 years 6 monthsRE: Actual Work Shown After Update Date
Hi,
if you are ahead of schedule, and you want to show acutal before/on data date, and without changing the duration, it seems impossible. you must shorten the remaining duration.
another way is like Raj mentioned use resource contour, but that means you are just on schedule, not ahead of schedule.
Member for
21 years 8 monthsRE: Actual Work Shown After Update Date
I have noticed many questions on this site about how to do certain things in MSP.
The main problem I believe is that the product has "evolved" over the years from a DOS based bar chart program with no real fundamental change to its critcal path engine.
I have been using it for more than 20 years (mainly because my clients insist)
As a result people are believing the marketing propaganda and using this tool for important work and expecting it to give them accurate answers. Beware , there are no work arounds for some of the issues with MSP except to use another product.!
PS I am not associated with any software company, I am just a planner (long in the tooth) who has seen these problems for many years and Microsoft is not really interested in making their product into a professional planning package. It is not competing (so I have been told by its marketing people ) in that market !
Good luck
Tom
Member for
21 years 3 monthsRE: Actual Work Shown After Update Date
Erik,
See my post on the topic Remaining duration & % complete. I think that will be helpful of your this post.
Member for
22 years 6 monthsRE: Actual Work Shown After Update Date
Philip,
May I allow a long period for an activity and do it in a fraction of the time?
Member for
21 yearsRE: Actual Work Shown After Update Date
Erik,
You may progress instead of retrogressing.
Member for
20 years 7 monthsRE: Actual Work Shown After Update Date
Before I started here, they use to status there schedules by simply changing % complete or % work complete. This does not allow you to ever show improvement on a schedule if your performance is actually greater than your planned, since it assigns the actual work into the "actual work" field of future dates (i.e. after the status date) and therefore your finish date does not change until you enter the actual finish date. The only way I can find around this is to calculate the actual work or actual cost for the reporting time period and enter it as an actual in the task usage block for the time period reporting. This allows the finish date to shrink and show schedule performance improvement. This is a pain but we can not determine another way to do this.
Any thoughts?
Member for
21 years 3 monthsRE: Actual Work Shown After Update Date
Brent,
As per rule if your actual is more than planned then progress will show beyond status date unless otherwise it will reduce the remaining period of that task. So you just update the actual % work and update the full shedule or just selected activity specifying your status date then your progress will not go beyond status date but certainly it will reduce the remaining duration, if you dont want to change the duration also so keep your task as fixed duration then it will adjust unit.
Member for
20 years 7 monthsRE: Actual Work Shown After Update Date
We are having a problem with the same issue. I have just started at a company where they update work by changing the % Work Complete. They do not want actual work to be allowed to be after the status date. They ask me to research a way to prevent this. I know of none. It requires manual manipulation of the data after entering the % Work Complete. I suggest use % Work Complete to calculate actual hours for the reporting period. Still working on this one.
I cant believe there is no option in Project to prevent this from occurring. It is not logical.
Any other input would be appreciated.
Thanks,
Brent
Member for
21 years 3 monthsRE: Actual Work Shown After Update Date
Erik,
If I understood correctly you mean, in your long duration activity, most of the work done early and you want to show it upto data date. Make resource contour and enter the most of the work early stage. Then while updating work put the actual work accordingly.
Member for
24 years 6 monthsRE: Actual Work Shown After Update Date
You are now facing one of the many challenges of using Microsoft Project to update a resourced schedule. Microsoft Project does not by default calculate the end date of an in-progress task from the Status Date using the Remaining Duration (as one would expect), but from the Actual Start Date and the Duration. Therefore your assumption is correct.
It has been my experience that it takes four time longer to update a resourced schedule in Microsoft Project than other products.
There are some functions designed to assist the scheduler in statusing a schedule but often these lead to more confusion, have a look at:
1. Tools, Tracking, Update Project, Reschedule uncompleted work to start after option, ensure that the option split in progress tasks is turned on and if you do not want to see the splits then select Format Layout to hide the splits.
2. You may wish to try the Tools, Options, “Updating task status updates resource status” which unlinks Percent Complete and Percent Work Complete.
3. If you had MSP 2002 or 2003 you may wish to try the four options listed directly under Tools, Options, “Updating task status updates resource status”, the first one described as “Move end of…….”
Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Book Publishers, Training & Consulting
www.eh.com.au