Physical Progress Calculator — Companion Article

What this tool does

The Physical Progress Calculator records how much of the piping engineering work is physically complete, activity by activity, and rolls that into one progress figure for the job. It is a project-control measure against the approved scope, the approved hours, and the control-level schedule.

It answers a different question from timesheets. Timesheets say how many hours have been spent. This page says how much of the work itself is done.

When to use it

Use it once three things are in place: an approved scope of work, an approved labour-hour estimate, and a control-level schedule. Those are the plan you are measuring against. Report on the rhythm the project uses, typically each week or at each progress meeting.

Use it through the job, not only at the end. The point of the remarks and the hours-used comparison is to see activities that are ahead or behind while you can still do something about them.

Inputs

For each piping activity on the schedule, bring:

• A status from 0% to 100% for how much of that activity is physically complete.
• A weight for the activity. The weights across the activities are meant to add up to 100%, so the individual statuses can roll into one overall figure.
• A short remark when an activity is ahead of or behind the schedule, saying why.
• The approved labour hours for the activity, from the estimate and the schedule, including approved change hours that now form part of the plan.
• The hours used on that activity as of the reporting date.

The activities should be the same ones named in the scope and on the schedule. Progress on work the scope does not include is a change, not a status update.

How it works

Prepare the report in this order.

• List the activities from the control-level schedule. Give each a weight. Set the weights so they total 100%. Heavier weights belong on the activities that represent more of the piping effort.
• Assess each activity from 0% to 100% on physical completion: drawings issued, model complete, isometrics issued, and so on, against what that activity was supposed to produce. Do not mark an activity complete because the hours have been spent.
• Roll the activity statuses into one overall physical percent complete, using the weights. Where the weights add to 100%, multiply each status by its weight and add the results.
• Set the approved hours next to the hours used as of the reporting date. The two columns are different facts. One is the plan. The other is consumption to date.
• Write a remark on any activity that is ahead of or behind the dates on the schedule.

This is physical progress for piping control. It becomes a financial earned-value measure only if the project has adopted earned value and told you to report it that way.

Understanding the result

The overall figure is the weighted physical percent complete. An activity at 50% with a large weight moves the overall number more than an activity at 50% with a small weight. Read the overall number together with the remarks, not instead of them.

Approved hours are what the estimate and the schedule allowed, including approved change. Hours used are what has been consumed by the reporting date. If hours used are running ahead of physical percent complete, the activity is consuming effort faster than it is finishing work. That is a prompt for the lead, not a rate the page calculates for you.

Engineering considerations

Set the weights at the start, from the approved hour split, and keep them stable. Changing the weights mid-job to make the overall percent look better destroys the trend you are trying to read.

Judge percent complete from the deliverable, not from the timesheet. A model that has used 80% of its hours and is half built is 50% physically complete.

Keep the activity list aligned with the scope and the schedule. New work that was not in the approved scope is recorded as a change first. Its hours join the approved hours only when the change is approved.

Calibrate what “done” means with the team before the first report, so 100% means issued, not “nearly issued”. The piping lead signs the physical picture. The project manager uses it in the progress meeting.

Example

Illustrative example. Figures are not benchmarks.

Four activities carry the approved 500 hours. Weights follow the hours, so they total 100%: plot and layout 20%, model 40%, isometrics 30%, material take-off 10%.

On the reporting date the physical status is plot 100%, model 50%, isometrics 0%, material take-off 0%. The overall physical percent complete for this illustration is (100 × 0.20) + (50 × 0.40) + 0 + 0 = 40%.

The model was planned to be further on by this week, so the remark says vendor equipment data arrived late. Model hours used are 140 against 200 approved. That is 70% of the model hours used for 50% of the model work, which is the signal the remark is there to explain.

Standards and references

Based on the project-controls methodology of James O. Pennock, Piping Engineering Leadership for Process Plant Projects, and on the physical percent complete practice in that method. It is a practical reporting aid for a piping engineering lead. It is not an ASME or API code, and it is not a substitute for your contract or your company progress procedure.

Limitations and disclaimer

This tool reports physical percent complete from activity status and weights that are meant to total 100%. It does not set a universal productivity rate, and it does not replace your company’s approved progress procedure. It is not financial earned value unless your project has adopted earned value. Percent complete and hours used both need the judgement of the piping lead.

Use the tool

Calculate now: Physical Progress Calculator

How this calculation works: Physical Progress Calculator

Related tools

• Scope of Work defines the work whose completion you are measuring.
• Piping Man-Hour Estimator is the source of the approved hours on the report.
• Piping Estimate Summary is the consolidated view of those approved hours.
• Control Level Schedule is the plan the ahead-or-behind remarks are written against.
• Design Change Notice approves the change hours before they join the approved-hours column.
• Historical Data Log records the final actual hours once the project is finished, which is a different figure from hours used mid-job.