• Home
  • About
  • Download
  • Tutorials

Creating Progress Tracking System for Steel Fabrication and Erection Work

The Detailed Progress Tracking System for Steel Fabrication

WBS element “Steel Fabrication” is the higher level of pipe rack fabrication and equipment access platform fabrication.
The general arrangement drawing list, project area name, work pack number, fabrication start and finish date shall be included in the progress tracking sheet. You should have an additional spread sheet/system known as steel tracker sheet/system which includes the fabrication status of each assembly member for each GA drawing.
The progress tracking sheet is linked with the steel tracker sheet to update the fabrication status of each GA drawing. 
The following hierarchical structure represents how steel fabrication progress is tracked and monitored. It shows the level of progress reporting.

I have developed a steel tracker sheet which includes progress updating section, progress calculation section and progress summary for each GA drawing. The progress updating section is used to update the fabrication status of each work step. It includes GA drawing description, drawing no, revision no, member type, weight of each member. For example, the steel fabrication of access platform for Air Cool Exchanger facilitates how the steel tracker sheet is developed. See table below.

The progress calculation section is made to calculate progress status by means of weight. Once the actual date is updated for the particular work step, the progress (steel weight) is derived by using IF function. The actual dates of fabrication work steps are updated to understand how the progress is calculated. See table below.

The table “Progress summary for each GA drawing” is linked to the table “Progress calculation section” to produce summary data using SUMIF function. This table will also be linked to “Progress Tracking Sheet-Steel Fabrication” to get high level progress status.

To develop Progress Tracking Sheet for overall GA drawings, let’s make assumption that the Pipe Rack scope includes Pipe Rack A and Pipe Rack B for project area A and B respectively. The compressor platform, miscellaneous platform, Air cool heat exchanger access platform are included in area-A’s scope. Valve access platform, access platform for drum/vessel are included in area-B. 

The following work steps and weight factor percentages are utilized to develop the progress tracking sheet.

1. Material Received at Fabrication Yard-5%
2. Welding preparation (marking/cutting/end preparation)-35%
3. Welding (tack/full weld/NDE)-35%
4. Surface preparation and coating (sand blasting and painting/hot dipped galvanizing)-15%
5. Final Inspection-5%
6. Delivery at Site-5%

Fabrication status of each work steps can be updated using summary data from steel tracker sheet. Calculation methods of the individual progress, overall progress, and progress summary data grouped by project area are the same as described in piping fabrication work. See table below.

Get the excel template to learn more

The Detailed Progress Tracking Sheet for Steel Erection

This tracking sheet is created using the same methodology as steel fabrication work. The work steps such as material at site, member assembly, final inspection and weight factors ( 5%, 85%,10%) are used respectively.
Download sample template.


  1. Hello !
    It is a very interesting and helpful job you are doing. I hope everybody will participate.
    I want just to know if it's possible to publish similar sample calculations for other disciplines like process, civil, electrical and instrumentation works progress tracking systems.
    Thank you very much in advance.

    1. You are welcome. It will be published in future.

  2. how can i create this tracking sheet with the inventor program? for example with Acorn you can export information into an Excel spred sheet such as spool taging line specs ect. how can this be done through inventor?

  3. Thanks you so a such very informative blog.
    I want just to know if it's possible to publish similar sample calculations for other disciplines like process, civil, electrical and instrumentation works progress tracking systems.please provide a excel file with sequence at

  4. This is very informative.

    Great blog very helpful.

  5. Its very helpful, but plz update latest posts frequently.

  6. It is a newsworthy blog post about the structural steel fabrication. Professionals from the structural steel industry would find it useful. Thanks for sharing this with us!

  7. The information you've provided during this post is extremely helpful because it contains some good knowledge. Thanks for sharing such a superb post. Keep Posting. Custom Plastic Extrusion

  8. The post you've shared here is informative because it contains some best knowledge that's extremely essential. Thanks for posting it. Keep it up. Downtime Tracking Software

  9. You've written a fantastic article. This article provided me with some useful knowledge. Thank you for providing this information. Glass Fabrication Equipment

  10. You've shared some extremely valuable knowledge. This is often an incredible way for us to expand our skills while still being useful to us. Many thanks for bringing this post to our attention.Custom Plastic Extrusion

  11. I am so grateful to find your particular post. I have bookmarked this website and I will keep visiting you for further such interesting posts.
    vented soffit panels

  12. The Detailed Progress Tracking System for Steel Fabrication facilitates recordkeeping for project managers and other personnel involved in a project to monitor and record all relevant material, tools, and materials as they are used on the job site. The Detailed Progress Tracking System for Steel Fabrication consists of a three-dimensional computer display that presents the entire project through digital images. The system also includes an automatic e-mail or text alerts when changes are made in the specified material locations.

    The Detailed Progress Tracking System for Steel Fabrication tracks material usage by the date and time stamp of each piece of steel fabrication work. Steel fabricators and suppliers can enter all information about a particular job on the computer, such as job name, description, supplier name and address, and material type, number of pieces, quantity order and payment method. The Detailed Progress Tracking System for Steel Fabrication uses a simple, easy-to-use interface that enables project managers to enter accurate information. The Detailed Progress Tracking System for Steel Fabrication allows the Fabricator to view job progress by date and time and by job function.


Related Posts Plugin for WordPress, Blogger...