Excel vs scaffold software for take-offs

What does a spreadsheet do well?

A good take-off spreadsheet has real strengths, and it is worth naming them before looking at the weak spots.

• It is transparent. Every number sits in a cell you can click. Nothing is hidden behind a vendor's algorithm.
• It holds your own rates. Labour per square metre, hire per week, transport per load and your margin are yours, and you can change them in seconds.
• Everyone already has it. No training, no extra licence, no new login for the office manager.
• It is the common output format. Even the software vendors end in a spreadsheet. PERI's Scaffold Estimation Tool exports its material list with weights to Excel for building an offer (PERI), and ScaffPlan advertises automatic, Excel-ready gear lists from its SketchUp models (ScaffPlan).

That last point matters. The real choice is rarely Excel or software. It is whether the counting happens in the spreadsheet or before it.

Where does a spreadsheet break?

A spreadsheet works by rule: so many frames per bay, so many decks per lift. The rules are easy to write for a straight wall and get harder with every feature a real building adds.

Corners

Two walls meeting at a corner are not two separate walls. One run usually continues past the corner by the scaffold width, which can push it into an extra bay, and the end guard rails of the two runs are replaced by a joint. A sheet that sums walls one row at a time double-counts ends and misses that bay. Our guide to scaffold corners and returns shows the difference on a real house.

Mixed bay lengths

An 11.4 m wall can be three 3.07 m bays and a 2.57 m bay (11.78 m), three 3.07 m bays and a 2.07 m bay (11.28 m, slightly shorter than the wall, so the ends need a closer look), four 3.07 m bays (12.28 m), or a mix with a shorter bay where a downpipe sits. Each choice changes decks, guard rails, toe boards and braces by length. A formula that assumes one bay length per wall cannot show the mix, and a sheet that lets the user type it per bay quickly becomes a drawing in cell form.

Lifts on sloping ground and gables

When the ground falls along the wall or the wall ends in a gable, each frame line has its own height. Base jacks, the number of frames per line and the top guard rails all vary bay by bay. This is where spreadsheets usually fall back on an average height, and the average is wrong at both ends.

Ties and bracing

Tie and brace rules come from the manufacturer or the compliance sheet and change with cladding and brackets. Of two TG20:21 compliance sheets published with UK planning applications, the sheeted scaffold needs 5.7 kN standard-duty ties (2025 sheet), the one clad with debris netting 2.2 kN very-light-duty ties (2023 sheet). A spreadsheet can carry that rule, but only if somebody updates it when the sheet or manual changes, and only if the person filling it in ticks the cladding box.

How often are spreadsheets wrong?

The research is not about scaffolding, but it is clear. Ray Panko's summary of nine studies found that people building spreadsheets alone left errors in 1.1 % to 5.6 % of formula cells (Panko, development experiments). In the five core audits of real business spreadsheets, including commercial audits by Coopers & Lybrand (1997) and KPMG (1998), which counted only serious errors, 91 % of 55 spreadsheets had important errors, and people asked to find the errors in a spreadsheet caught only about 60 % of them (Panko, audits of operational spreadsheets).

The construction trade appears in the record too. The European Spreadsheet Risks Interest Group lists a 2019 case in which a contractor's bid for the next phase of a district's construction project was rescinded because a spreadsheet error had made it far too low (EuSpRIG horror stories, POB1902). A scaffold quote is smaller, but the mechanism is the same: one wrong cell, copied into every line that depends on it.

What about version control?

The second weakness is not the formulas but the copies. A take-off emailed to a client, edited by the estimator and reopened by the contracts manager quickly exists in three versions. Microsoft 365 keeps a version history, but only for files stored in OneDrive or SharePoint (Microsoft Support); a sheet saved to a desktop or sent as an attachment has none. Scaffold software usually keeps one project record with the drawing and the list together, so the list cannot drift away from the drawing.

How do the two compare?

The software column is not uniform. Avontus Designer generates bills of materials as you design and imports IFC, PDF and AutoCAD plans (Avontus); SMART Estimator builds the quote and the material list from one 3D model (SMART Scaffolder). Their rule sets are only as current as the vendor keeps them, which is the same caveat as for a spreadsheet, moved to someone else's desk.

Which should you use?

A fair conclusion depends on the work.

• Mostly straight facades with one system: a well-built spreadsheet is fine. Lock the formula cells, keep the inputs on one sheet, write the manual and edition next to every rule, and check one job a month against what came back from site.
• Houses with corners, gables and extensions: count in software and price in your spreadsheet. You keep your rates and gain the geometry.
• Large or engineered jobs: design software with the system's rule sets, and a structural check where the configuration leaves the manufacturer's standard cases.

ScaFix is one example of the middle route: it turns wall dimensions or a PDF drawing into a 3D scaffold and a parts list for many systems, and the list can then be priced wherever you price; it does no structural check. For the step from parts list to price, our guide to a scaffold quote from a parts list walks through it, and how much scaffolding do I need covers the first rough figure.

If you keep Excel, what makes it safer?

1. One row per bay, not per wall. It is more typing, but corners, short bays and stepped ground become visible.
2. Rules on their own tab. Bay lengths, tie spacing and bracing intervals live in one place with the manual's page number beside them.
3. A second person checks the inputs. The research above shows that a single checker misses many errors, so let someone else check the wall dimensions and the system before the list is priced.
4. One shared file. Keep the take-off in shared storage with version history, never as attachments.
5. Compare with reality. Note what went out and what came back on every job. Your own error rate is the best argument for or against changing tools.

Does either one make the scaffold safe?

Neither. A spreadsheet and a software list are both quantities. In Great Britain a scaffold has to follow a generally recognised standard configuration, such as TG20 for tube and fitting or the manufacturer's guidance for system scaffolds, or be designed by bespoke calculation by a competent person (HSE scaffolding guidance).

This is planning information, not structural approval. The manufacturer's instructions for assembly and use decide ties, bracing and loads; in Great Britain the Work at Height Regulations 2005 and HSE guidance apply, and a competent person must inspect the scaffold before use.

Frequently asked questions

Sources

Primary sources used for this article, with the date each was read.

• Ray Panko: Spreadsheet development error experiments (read 23 October 2026)
• Ray Panko: Audits of operational spreadsheets (read 23 October 2026)
• EuSpRIG: Horror stories (POB1902, 2019) (read 23 October 2026)
• Microsoft Support: View previous versions of Office files (read 23 October 2026)
• PERI: Scaffold Estimation Tool (read 23 October 2026)
• ScaffPlan: design software (read 23 October 2026)
• Avontus Designer (read 23 October 2026)
• SMART Scaffolder: SMART Estimator (read 23 October 2026)
• Scaffcalc (read 23 October 2026)
• TG20:21 compliance sheet, sheeted tied independent scaffold (planning application, 1 February 2025) (read 23 October 2026)
• TG20:21 compliance sheets, scaffold with debris netting (planning application, 14 July 2023) (read 23 October 2026)
• HSE: Scaffolding (read 23 October 2026)