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.

Physical % And Duration %

6 replies [Last post]
Suresh Sankaranku...
User offline. Last seen 5 years 1 week ago. Offline
Joined: 30 Jul 2006
Posts: 77
I think this subject might been discussed earlier but i couldnt get the exact answer to clear my doubt.

Eg: Senario: Project Early start date is : 01.01.2007
Early finish date : 10.01.2007
Total Duration 10 Days
Data date is 05.01.2007

Now, in this senario, the duration % complete would be 50% on 5th Jan. But in reality the physical % completed (the real work done in the plant) would be 30 %. Now , i want to make comparison chart to show what duration is sofar completed and what physical progress we have acheived. In p3e i seen each day when you update the schedule with aplly actuals the project will show the duration % complete automatically. Now if you put the column of physical % complete that will be the same of the duraiton % complete. I really get confuse on those stuff. What i want to know is . The reality work completed would be entered in to a column manually and how can i see the total % of that. I can enter the real work % in to a user created column for each activity but i have to get the total % of that all i entered. Please let me clear my doubt. I would prefer to have discussion from simple theory.

Thank you
Suresh


Replies

Dieter Wambach
User offline. Last seen 7 years 17 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Suresh

I absolutely agree with Khuong. In addition I stumbled over a sentence of yours: "So that i can forcaste, howlong our duration is completed and howmuch % we completed so far in reality."
So I have the impression, you want to forecast something. From where do you get %-complete? In the past I had to learn that an estimation of %-complete is absolutely unreliable, but if the people estimate which date they’ll finish their work, it will be much more reliable.
Would it be an alternative, to use the expected finish date?

Maybe I understood you wrong.

Regards

Dieter
Khuong Do
User offline. Last seen 16 years 49 weeks ago. Offline
Joined: 1 Sep 2006
Posts: 38
Groups: None
Hi Suresh

We can not get activity % complete from UDF through Global change fuction.

I suggest that you should update progress directly to physical % complete field, instead of UDF.

But’Physical % complete’ is not rolled up, because it is a
discrete, user entered value assigned to an activity. Since
’Physical % Complete’ does not relate to the duration,
units or costs of the activity, there is no common
denominator to use for the summary.

However there is a workaround to roll-up physical % complete to WBS level.
Workaround:
It is possible to configure the Activity’s ’Performance %
complete’ to equal the ’Physical % complete’.
Performance % complete can be rolled up to the summary
bands. However, to achieve this, the following three
statements need to be true:
1) The ’% Complete type’ of the activities must be
set to ’Physical % complete’. This option is located
in the General tab in the Activities View (Note: this
will set the ’Activity % complete’ value to be equal
to ’Physical % complete’. This will also impact the
Earned Value calculation.)
2) The ’Technique for calculating performance %
Complete’ needs to be set to Activity % complete.
This option is located in the Earned Value tab in the
WBS View (Note: this will set the ’Performance %
complete’ value to be equal to Activity % complete,
which equals Physical % complete).
3) Finally, in order for the Performance %
Complete to be rolled up to the summary band(s),
costs need to be assigned to the activity. These
costs must also be present in the Primary baseline.
Please Note:
At the summary level, the Performance %
complete is calculated as follows:
Performance % Complete = (BCWP * 100) / BAC
(Where the BCWP is the Budgeted Cost of
Work Performed and the BAC is the Budget At
Completion)
BCWP is calculated as Activity % Complete *
Baseline Total Cost
By setting the 3 conditions above, the Activity %
complete will equal the Physical % complete thus
ensuring that the summary value for Performance %
complete is calculated with regard to the Physical %
complete, weighted by the activities’ cost.

Thanks & regard
Khuong
Suresh Sankaranku...
User offline. Last seen 5 years 1 week ago. Offline
Joined: 30 Jul 2006
Posts: 77
Dear Khuong
You are exactly right. But its simple question.
How can get the % completed on basis of the user_entered column for actual completion.

Eg: everyday i will put the progress % in a userdefined column. I want the total % for that in the top of the WBS. So that i can forcaste, howlong our duration is completed and howmuch % we completed so far in reality.

Activity % complete will only give you % on basis of the duration and it could be different from the reality. Isnt it ?

Thank you
Khuong Do
User offline. Last seen 16 years 49 weeks ago. Offline
Joined: 1 Sep 2006
Posts: 38
Groups: None
Dear Suresh!
Actvity have 3 percent complete type : duration, units, physical.
Depend on which type you choose for activity, the value will reflect in "Activity % complete" column.
The main factor you should focus when analyse updated schedule is "Activity % complete" column, not physical % or duration %.
Duration, unit, physical % column is just used for temporary store.
Calculation of Earned value will base on activity % complete.
So, there will be no confict if your duration and physical % are diferent. Because Primavera just look at Activity % complete for calculation.

Please feel free to contact me if you have problem

Thanks
Khuong
Dieter Wambach
User offline. Last seen 7 years 17 weeks ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Suresh,

% complete in P3e is worth a study.
In a recent thread "Level of Effort" it was discussed: http://planningplanet.com/forum/forum_post.asp?fid=1&Cat=8&Top=35365.
The best way to get informed on the meaning of attributes is to switch on the "hint help" e.g. under view. then e.g.: Move mouse into the table area --> right button --> "Columns" --> expand % complete --> (right)click onto the item you want to know --> a window appears with a good explanation.

Hope this will help

Dieter
Suresh Sankaranku...
User offline. Last seen 5 years 1 week ago. Offline
Joined: 30 Jul 2006
Posts: 77
Dieter, thank you very much. Let me study through.