Pages

  • Home
  • About
  • Download
  • Tutorials

Develop Progress Tracking Sheet for Piping Fabrication Work

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;
  1. Weld map drawing preparation-4%
  2. Withdrew material-3%
  3. Welding preparation (marking/cutting/end preparation)-20%
  4. Spool Assemble and tack weld-25%
  5. Full welding execution-20%
  6. Non Destructive Examination-6%
  7. Surface preparation and coating (sand blasting and painting/hot dipped galvanizing)-15%
  8. Final Inspection-4%
  9. 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.

9 comments:

  1. WHat a neat technique! Thanks for sharing:)

    ReplyDelete
    Replies
    1. Hi Router Mill, You are welcome.

      Delete
    2. Good Stuff. God bless

      Delete
    3. The third column in your table reads ' withdrew material' . Please can you clarify on this?
      Thanks
      Yinka

      Delete
    4. Hi Yinka,

      “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.

      Delete
  2. can someone please provide me step by step tutorial for this sheet
    johnyeng4@gmail.com

    ReplyDelete
  3. Hi Min Oo,
    do you also have KPIs for piping & structural fabrication and welding by material class / diameter etc?
    thanks
    ADIL
    akayiran@gmail.com

    ReplyDelete
  4. I am in need a tracking chart to track my welders WPQ's and WPS and PQR's but I also need it to show when they have to requalify for each we are a small specialty chemical pipe fabrication company, besides the welding software do you have any suggestions as to how I can make a chart to track these?

    ReplyDelete
  5. With respect to lighting, most kitchens have a couple of principle method for lighting (or blend of these) instant pot quick release

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...