Oracle Primavera P6: Automatically Calculating Physical % Complete


Often managers are uncomfortable with the “guesstimate” given for percent complete. The Oracles Primavera P6 steps feature becomes very useful when they are weighted to drive the percent complete in a way that is less subjective and more quantifiable.

Generally, steps are a way to track deliverables or any sub-activity without adding activities and complexity to your schedule. Any group of steps that is often repeated (a typical document workflow for example) can be made into a step template for use on all such activities, too.

How to Automatically Drive Physical Percent Complete in Oracle Primavera P6

To have each step automatically drive physical percent complete for the activity you need to:

1.    Open the columns within the step tab by right-clicking on the last column and selecting “Customize Column Headings”. Then select the Step Weight and Step Weight Percent columns and move them into the view by clicking the right arrow button on the middle frame. Click OK. The new columns appear on the steps tab.

2.     Now, define each step by importance or weight it carries toward overall completion of the activity. The cumulative physical percent complete is automatically calculated if the setting on the calculations tab at the project level is checked to “Activities with steps drive percent complete.” You may want to ensure the Physical Percent Complete column is viewable in the activity table or that this activity is set in the general tab to the Physical Percent Complete Activity Type. If you do not weigh them, then each step carries equal weight, so if you have ten steps then each one counts 10 % of the total physical percent complete.

Two examples: IT and Construction:

Test 2000 Code testing Activity Weightpercentage complete after sep is Completed
Step One: Unit Test One55
Step Two: Unit Test Two510
Step Three: Unit Test Three515
Step Four: Unit Test Four520
Step Five:  Integration Testing of One and Two1030
Step Six:  Integration Testing, Add Three1040
Step Seven:  Integration Testing, Add Four1050
Step Eight:  System Test1565
Step Nine:  Functionality Test2590
Step Ten:  Move to Production10100
CON2000 Pre-Bid Cycle Activity for Carpentry Vendor SelectionWeightPercent Complete After Step is Completed
 Step One:  Bid Statement of Work (SOW)Drafted55
 Step Two:  Vendor Selection Criteria Agreed Upon510
Step Three:  SOW Reviewed515
Step Four: SOW Approved520
Step Five:  Solicitation of Bids525
Step Six:  Bid Close, Vendor Selected3055
Step Seven:  Vendor Notified560
 Step Eight: Contract Drafted1575
Step Nine:  Contract Revisions2095
Step Ten:  Contract Approved 5100 

Being able to calculate percentage complete is a very important tool to know as a project manager. The concept of the Physical % Complete is straightforward.  It’s a way of entering manual progresses based on expert judgment or other external factors. These values can be dynamically determined in each control period or follow a predefined set of values (activity steps).

One way you can continue to improve your Primavera P6 project management skills is to read blogs such as this or to really increase your knowledge by taking a project management training course. It’s important to understand how to how to use the software but its even more important to understand what these numbers mean and to have the knowledge to act on these numbers. By taking an IMS project management training course, you will be learn about the core fundamentals to being a successful project manager.