Developing Progress Tracking Sheet/System for piping fabrication is one of the tracking system of Progress Measurement System for Petrochemical Plant Project Consruction.
The tracking sheet includes the list of drawings, the project area name, quantities (diameter-inches and man hour) and the production work steps to calculate fabrication progress. You may assign fabrication started date, finished date, and work packages for each Isometric drawing which will be useful to track and report the progress status grouped by work pack number, started date and finished date. The following are piping fabrication work steps and weight factor percentage;
- Weld map drawing preparation-4%
- Withdrew material-3%
- Welding preparation (marking/cutting/end preparation)-20%
- Spool Assemble and tack weld-25%
- Full welding execution-20%
- Non Destructive Examination-6%
- Surface preparation and coating (sand blasting and painting/hot dipped galvanizing)-15%
- Final Inspection-4%
- Deliver at site-3%
The following table is a sample tracking sheet for piping fabrication. The progress tracking sheet format shall be submitted to Owner’s Representative for approval prior to commencement of the work.
As shown in the above table, "weighting" column is inserted to calculate individual progress and overall progress. The individual progress is calculated by the sum of the product of weight step progress and weigh factor %. Overall progress is derived from an individual progress * individual weighting. Progress summary data by Project Area and Work Pack is calculated using SUMIF function. In this post, all the fabrication work steps for all drawings are updated as 100% completed. Get the free excel template to learn more.
WHat a neat technique! Thanks for sharing:)
ReplyDeleteHi Router Mill, You are welcome.
DeleteGood Stuff. God bless
DeleteThe third column in your table reads ' withdrew material' . Please can you clarify on this?
DeleteThanks
Yinka
Hi Yinka,
Delete“Withdrew Materials” work step progress is earned when the materials (i.e. pipe, flanges, fittings, etc.) from the store/laydown yard are taken to fabrication site in order to commence fabrication work.
can someone please provide me step by step tutorial for this sheet
ReplyDeletejohnyeng4@gmail.com
Hi Min Oo,
ReplyDeletedo you also have KPIs for piping & structural fabrication and welding by material class / diameter etc?
thanks
ADIL
akayiran@gmail.com
Please share that excel file to vijayasekaran80@gmail.com
ReplyDelete