Progress Calculation for Engineering - Piping

Recently I prepared Engineering Progress Tracking Excel Sheet for an oil and gas company located in Singapore. In that training I guided the team into 2 phases. The 1st phase the teams are required to track their Engineering progress without Primavera P6.

 

The second phases is where they translate the excel sheet tracking into Primavera P6 by using 2 different methods.

 

1) By using "Step" function for Level 4 (Engineering progress for each document)

2) By using Activity method for level (Engineering progress for each document)

 

Let’s find out how a piping drawing progress is calculated. Suppose a tie-in drawing design has been completed 33% of “Approved For Construction” work step. See the details calculation and below figure for easy understanding.

 

Progress for Tie-In plan drawing at the cut-off =

Weight factor for “Study and Design Approval” work step (0.05) x progress for “Study and Design preparation” work step (100%) +

Weight factor for “IFR” (0.15) x progress for “IFR” work step (100%) +

Weight factor for “IFA” (0.20) x progress for “IFC” work step (100%) +

Weight factor for “IFC” (0.25) x progress for “IFR” work step (100%) +

Weight factor for “AFC” (0.35) x progress for “IFR” work step (33%) +

= 76.6%

 

Physical Progress of pump data sheet document = 0.05484 x 76.6% = 4.2%,

 

 

 Progress Calculation for Overall Engineering

Then, Overall Engineering phase/stage progress = the sum of the product of weight factor for each discipline and physical progress for each discipline,
= 0.1897 x 37.8% + 0.1040 x 50% + 0.1897 x 20% + 0.1110 x 30% + 0.1214 x 25% + 0.1387 x 15% + 0.1456 x 13% = 27%

To those who are interested, you can email me at jeshkhan81@gmail.com for the Engineering Progress Tracking Sheet in excel.

I will cover the topic on how to track the Engineering progress in my next post.