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.

Remaining duration

4 replies [Last post]
Wed, 2009-11-11 10:14
harzelli bouasria
User offline. Last seen 4 years 44 weeks ago. Offline
Joined: 15 Oct 2008
Posts: 42
Groups: Petro-Chem / Oil & Gas
Hi folks

how can you have remaining duration without having to give % complete, (task don’t have a resources)
example:
civil works: on data date: 10NOV09
early start: 10NOV09
early finish: 20NOV09
OD=10days RD=10days
civil works: on data date: 15NOV09
Actual start: 12NOV09
early finish: 24NOV09
OD=10days RD=10days

how can you explain this ????
Top

Replies

Tue, 2009-12-15 16:01
#1
Rafael Davila
User offline. Last seen 21 hours 9 min ago. Offline
Joined: 1 Mar 2004
Posts: 5233
Groups: Spider Project Team
Osama,

I no longer have P3 but check under Autocost Rules, it should be there.

You can do a search under P3 help for the keywords "auto cost", "link percent complete" and the like to find the way to the screen you are looking.

Best regards,
Rafael
Top
Tue, 2009-12-15 14:58
#2
Osama Warid
User offline. Last seen 9 years 47 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
Pls. how we can unlink the formula
Top
Wed, 2009-11-11 10:39
#3
Ronald Winter
User offline. Last seen 3 years 23 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
That is the way it is supposed to work. The software is not going to tell you how much work you accomplished (a reduction of remaining duration;) you have to tell the software. If you had 10 days remaining on 12NOV09 and do not change the status of your activity by indicating how may days of work remain on 15NOV09, the software has no other option that to assume that you meant to leave the status as having 10 days remaining.

CPM is more that a planning tool. It also allows you to track your progress and reassess you new situation based upon current progress. Just because you started an activity does not mean that you have continuously worked on that task, that you are making progress exactly as planned, or that you haven’t been delayed. At the end of the day on 14NOV09 (when you made you progress assessment,) you should have asked the responsible resource how many more days of work remained for that task. You should then enter the new estimate in the remaining duration slot.

By the way, just as a side observation; it is not 15NOV09 as yet. It is not even 14NOV09. If you are going to status your schedule a week early, you might as well save time and do the same for the next couple of years and hand them all in at the same time. Then you job will be complete and you can move on to your next assignment. Good luck!
Top
Wed, 2009-11-11 10:24
#4
Rafael Davila
User offline. Last seen 21 hours 9 min ago. Offline
Joined: 1 Mar 2004
Posts: 5233
Groups: Spider Project Team
MAYBE %COMPLETE AND REMAINING DURATION ARE NOT LINKED, BY THE WAY THIS IS HOW IT SHOULD BE.

If you have linked %complete and remaining duration then whenever you edit one the other is recomputed according to the following formulas.

If you enter %complete remaining duration will be recomputed as follows:
REMAINING = ORIGINAL (1 - %COMPLETE) when there is no actual, otherwise
REMAINING = (ACTUAL/%COMPLETE) – ACTUAL

If you enter remaining duration %complete will be recomputed as follows:
%COMPLETE = 1 – REMAINING/ORIGINAL when there is no actual, otherwise
%COMPLETE = ACTUAL / (ACTUAL + REMAINING)

This method might create confusion, especially after you have actual from previous updates. Let say you have an activity with original duration of 2 weeks but after 2 weeks is 50% done and you expect to finish the remaining 50% in one week for a total duration of 3 weeks. If you enter these values into the above formulas you will get:
REMAINING = 2 /.5 – 2 = 4 – 2 = 2 weeks
%COMPLETE = 2 / (2+1) = 2/3 = 0.667= 66.67%
This mean you should have entered 66.67% to get 1 week for remaining duration.
REMAINING = 2 / 0.6667 – 2 = 3 – 2 = 1 week

The automatic linking of the two is one of the most common pitfalls of scheduling software programs. Cost loaded schedules are particularly susceptible to this scheduling pitfall, because the percent complete is tied to the earned value and cost to complete for each activity. Thus the percent complete must be accurately reported otherwise the cost reports will be inaccurate.

You have two options:

1. Keep the formula link and in the activity details enter either and the software will recalculate the other as per your last entry. Here formulas might confuse you.
2. Unlink the formulas and set each individually. Keep it simple and avoid any pitfall.

My recommendation is go with option 2, and then ask at the site, what is the remaining duration in work days after the update data date.

You will enter remaining durations for your activity duration computations and no change in %complete will be done at this point. You will enter %complete for your cost and EV computations and no change in remaining duration will be done at this point.

KEEP THEM SEPARATE.

Best regards,
Rafael
Top