Dear Sami,

Those procedures are available in Primavera. It is only an example of how to weight your activities based on your resources. This was discussed in so many thread of PP. Excel is only an alternative tool that you can used for more exploration and analysis. In Primavera 5 activity steps are one of the function that you can used for deriving your productivity steps/ rules of credit or an external database and or excel spreadsheet for monitoring your activities and have an accurate progress. If you define your activities with resource loaded then you can used those to weight you activities per WBS or Activity Codes. You can export your resources budget and actual into excel if you prepare to do your analysis in excel spreadsheet.

Regards,
Rodel

In addition to all posts, u can measure the weightage of the activities by the means of duration via assigning a dummy resource (called activity days) to the activities, the budgeted unit (for each activity) for this resource will be equal to the OD of the activity.

U can generate after making the resource loading an actual vs. target s-curve to compare the progress.

HTH.
Regards,
Karim

Kumar,

I believed that you are using duration % as your basis for your activity % complete where the result is really disappointing. As per earlier comments and as Annon states there are lots of discussion on this topic on other thread that gave you an idea on how to manage your weight factor to attain the correct progress. Aside from that there are plenty of norms to use for weighting your activities. Cost, labour hours are some of the parameters that you can use. Meaning have your activities resource correctly will given you a better report and weight % are satisfying.

Example for getting a correct progress:
First is to have a production step or rules of credit say Equipment installation:
a)     05% survey foundation
b)     10% set packers/ base plate
c)     45% lift into position/install
d)     15% align/ bolted
e)     10% final alignment/ torque
f)     05% grouting
g)     05% QA/QC check
h)     05% punch list
------------
100%

Example for weighting you activities
Units     Desc     weight
2000     Activity 1      26%
3500     Activity 2      46%
1500     Activity 3 20%
500     Activity 4      07%
100     Activity 5      01%
--------            ----------
7600           100%

If you progress your 3 activities having set your resource correctly then your summary % complete will have a satisfying result.

HTH
Rodel

In P3e which is my only experience with Primavera, you just use physical % complete.

In my pinion if you are going to track good quality earned value the % complete should ALWAYS be a manual input as it is calculated by the person responsible for the task as "a subjective assumption of the amount of physical progress that has been acheived to date" (Status Reporting Point) on the activity in question.

P3e also has the activity stepas which you can assign a particular weighting too which rolls up to the activity level and eventually to the WBS level as you would have desired.

Not having used P3 I’m unaware if there is a manual % complete function.

Kumar,
This is always an interesting topic around the table as each person normally has a different perseption of the weight a particular portion of work/task should hold in the big scheme of things.

It is always very subjective, some people I know have, for better or worse based it on the number of days the activity takes;
e.g. out of you 5 activities if the total linear duration of the tasks was say, 100 days, the fist 3 (bulk of the work each took 80 days to complete the final 2 activites occupying the remaining 20 days, you could assume that on average the completeion of the first 3 activities accounted for 80% of the work, (bigger than your originally quoted 55%).

Other people have based thisdecision around the number of manhours in each task, or the complexity of each task, or the deliverables of each task.

I suppose what I’m trying to say is that there is no real hard and fast rule to how to apply weights to your activities - So long as each person in the project management team is aware of how you arrived at the decision to place the weighting on each task and that you document and get signoff on the method.

Then you can start creating some standards for your organisation based on how the exeute the work.

I’m sure that there are many other ways to do this but this has ben a snapshot of my experience.

Andy