Why BMS estimation is still done in spreadsheets in 2026

The industry has digitised design (BIM), procurement (tender portals) and project management (take your pick). But estimation, the step that decides whether you win the project and whether you make money on it, is still a senior person reading PDFs and typing into Excel.

Credit where due: the spreadsheet earned its place

Estimators did not keep spreadsheets out of nostalgia. The spreadsheet is flexible enough to hold any contractor's methodology, transparent enough that every formula can be inspected, and free of setup: no vendor, no onboarding, no permission. Every previous attempt to replace it failed on one of those three. Most "estimation software" was a rigid spreadsheet with a licence fee, and it still needed a human to read the documents, which was always the actual work.

Why the reading resisted automation

BMS estimation is not a counting exercise a script could do. The same equipment needs different points in different contexts: a pump with a variable speed drive needs a speed signal, a pump without one does not; a VRF system might be priced per outdoor unit, per indoor unit or as one integrated system depending on the contractor's delivery habits. The inputs are unstructured: a hundred pages of prose, tables drawn for humans, and drawings. Rules-based tools could not read any of it, so the senior person kept reading it instead.

What changed

Language and vision models can now genuinely read these documents: extract the schedule rows, interpret the specification clauses, pull tags off the drawings. The documents have not changed, and the methodology has not changed. What changed is that the reading, the part that consumed the days, can be done by a machine and then checked by a person, because every extracted item can carry a reference to the page it came from.

What a real replacement must do

The lesson of every failed attempt is a short checklist. It must read the actual documents, not demand structured input that nobody has. It must show its working, so a sceptical professional can verify any line in seconds. It must bend to the contractor's methodology, templates and rates rather than imposing its own. And it must hand back artefacts the rest of the process expects, including, yes, the spreadsheet.

What this means for BMS contractors

The spreadsheet does not go away; the days spent filling it in do. Your estimator still reviews every output, still makes the scope calls, still prices from experience of what delivery actually takes. They just start from a complete, checkable first draft instead of a blank sheet, which means you can answer more tenders without hiring senior people the market does not have.