Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

% Complete Confusion - here is the data...

4 replies [Last post]
John Reeves
User offline. Last seen 7 weeks 4 days ago. Offline
Joined: 10 May 2013
Posts: 343
Groups: None

April 29 Data Date
April 29 Actual start on activity
Orig Dur = 20
Actual Dur = 5
Rem. Dur = 20
Per. Complete Type = Dur.
Dur. Complete = 0%
Sched. % Complete = 45% - how is this possible.

float -39.

Should I tell the contractor it has to be wrong to have used 5 days because the actual is on the data dates so cold not have used 5 days but a bigger question is how can the Sched % complete show 45% -seems high to me, I do not understand it.

 

Replies

Mike Sallese
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 11 Nov 2008
Posts: 12

If the Schedule data date is April 29, you should not record any Actual Dates on or after April 29. Calculating the schedule with such Actual Dates generates erroneous dates for all activities on the successor string of that activity.

You can determine if you did record such Actual Dates within the Schedule Report - generated by choice when you calculate the new schedule dates.  There is a line in the early part of the report that states the number of Actual Dates > than the Data Date.  This tells you if such Actual Dates exist.  Then just run a filter for such dates and correct.

Mike Sallese
User offline. Last seen 2 years 28 weeks ago. Offline
Joined: 11 Nov 2008
Posts: 12

If the Schedule data date is April 29, you should not record any Actual Dates on or after April 29. Calculating the schedule with such Actual Dates generates erroneous dates for all activities on the successor string of that activity.

You can determine if you did record such Actual Dates within the Schedule Report - generated by choice when you calculate the new schedule dates.  There is a line in the early part of the report that states the number of Actual Dates > than the Data Date.  This tells you if such Actual Dates exist.  Then just run a filter for such dates and correct.

Ahmad AbdRabou
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 10 Jun 2015
Posts: 22
Groups: None

Hello,

Regarding to Data Date and Start Date:

if you are wroking from 8:00 AM to 5:00 PM, and showing time in hours in the schedule, then you can start the activity on 8:00 AM and put the Data Date to 5:00 PM on the same day (Assuming it's a Working Day). After scheduling the Actual Duration will show 1 day (not 5 days).

Regarding to Schedule % Complete:

Consider the above setup, and after scheduling, go to project tab and assign the Data Date to a later date (without scheduling) it will change the Schedule % Complete value.

Regarding to Actual Duration:

It's uneditable, you can't change it unless you start the Activity and schedule the Data Date.

Regards,

Ahmad.

Zoltan Palffy
User offline. Last seen 8 weeks 18 hours ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

1. you can not have ANY actuals on the data date

2. scheduled % complete is just that SCHEDULED how much SHOULD have been done SCHEDULED TO HAVE BEEN COMPLETED.

3. It this activity is on the critical path then the float is greater than -39 days negative so the negative value wil lbe greater than -39 meaning MORE negative. 

Rodel Marasigan
User offline. Last seen 5 weeks 2 days ago. Offline
Joined: 25 Oct 2006
Posts: 1699

P6 formula for :

Duration % Complete = The percent complete of the activity duration. Computed as (Original Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Original Duration is taken from the current plan, not from the baseline.

Schedule % Complete = The activity schedule percent complete specifies how much of the activity's baseline duration has been completed so far.  Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline Start, the Schedule % Complete is 0.  If the data date is later than the baseline Finish, the Schedule % Complete is 100.   The Schedule % Complete indicates how much of the activity duration should be currently completed, relative to the selected baseline.

Rafael Davila
User offline. Last seen 3 weeks 17 hours ago. Offline
Joined: 1 Mar 2004
Posts: 5241