MEP progress monitoring templates, and what replaces them

The grid exists because the question is real. A main contractor asks how far the second floor has got. A planner needs to know whether chilled water is ahead of or behind ductwork. A commercial manager wants a number to value. Storeys by systems is the smallest honest shape for all three questions at once, which is why the same template keeps being rebuilt on job after job.

Most versions add a tab per discipline, a weighting column so that a long pipe run counts for more than a short one, and a RAG colour so the bad cells stand out. Some go further and split each system into stages — installed, tested, insulated, signed off — which is closer to how the work really happens.

None of that is wrong. The template is a reporting format, and as a reporting format it does its job. What it cannot do is tell you where its own numbers came from.

A cell says 60%. Six things had to happen for that figure to exist: someone walked the floor, formed a view, wrote it on a sheet, carried it back, typed it into the grid, and rounded it. By the time it is read, the crew has moved on, and nobody can reconstruct which runs the 60% counted.

That matters most exactly when the number matters most. When an area slips, the first question is always "what is actually in?" — and a template cannot answer it, because it never held that detail. Someone goes back to site and counts again, which is the work the template was supposed to save.

The second failure is quieter. Two people fill the same grid differently. One counts a duct run installed when it is hung; the other waits until it is sealed and supported. Both are defensible. Neither is written down. The percentages get compared across floors and across trades as though they meant the same thing.

The third is drift. A revised drawing changes the quantity behind a cell, but the cell keeps its old percentage until someone remembers to rework it against the new revision.

The fix is not a better template. It is to let the percentages be calculated rather than judged, from marks made at the point of installation.

That is what tracking MEP install progress on the drawings does. Installers mark what they have finished on the drawings they already use, on a phone or tablet, with no BIM skills and nothing new to learn. The drawings carry quantitative data from the project's Revit model, so each mark becomes an installed quantity — length of pipe, area of duct, a counted item — and percent complete is that quantity over the modelled quantity.

The grid you wanted is still there. Storeys down one axis, systems across the other, every cell current to the last mark made on site. The difference is that each figure traces back to the marks behind it, so "what is actually in?" is a question the data already answers rather than one that starts another site walk.

Definitions stop drifting too, because the stages are set once for the project rather than per person. Cable and equipment run through stages you define on your own schedules — pulled, terminated, tested, energised — instead of collapsing into one percentage per area.

No weekly take-off, because the quantities come from the model. No re-typed redline, because the installer's mark is the record. No separate evidence pack, because every number carries its own backing.

Progress maps to the activities in the programme — Primavera P6, Asta Powerproject, Microsoft Project through MPX conversion — so the planner's update and the foreman's percent complete are the same data rather than two readings of it. The office sees it on live progress dashboards that move as the work is marked.

If you keep a template today, you already know the shape you want. The question worth asking is only whether its cells should keep being filled in by hand.