Scaffolding is one of the few trades where the monthly management report and the safety file get confused for one another. They should not be. This article reviews the Scaffolding Services KPI Dashboard in Excel – a thirteen-KPI, formula-driven monthly scorecard for a scaffolding contractor – and is explicit about the line between the two: this workbook reports numbers you type in, and it proves nothing about any scaffold on any site.
What the Scaffolding Services KPI Dashboard in Excel Is – and What It Is Not
It is a plain .xlsx workbook of eleven sheets. Every number on every page is a worksheet formula reading from three input sheets you fill in yourself. There is no macro, no Power Query, no Power Pivot and no add-in.
It is not a safety system, and this matters more in scaffolding than in almost any other trade we build for. The workbook does not inspect, certify or prove the safety, stability or load capacity of any scaffold, tower, tie or component. It does not establish compliance with the Work at Height Regulations, NASC TG20 or SG4, OSHA 1926 subpart L, EN 12811, HSE requirements, any scaffold-inspection regime, or any licensing or CISRS-type competence scheme. It is not a scaffold design, a handover certificate, a statutory inspection record such as a seven-day or post-alteration inspection, a defect notice, or a tag with any legal standing, and it does not replace a competent person’s statutory duties.
Every inspection, incident, utilisation and defect figure in it is a number a human typed. A green traffic light in this file means a typed number beat a typed target. It is never evidence that a scaffold is safe to use or has been inspected. The figures the file ships with are demo data, generated so the formulas and charts are visibly working the moment you open it.
Key Features of the Scaffolding Services KPI Dashboard in Excel
- Thirteen KPIs across four groups – Safety & Compliance (6), Operations (4), Workforce (2) and Commercial (1).
- A single month dropdown that drives the scorecard, seven summary cards and the whole analysis page.
- Month-to-date and year-to-date blocks side by side: actual, target, achievement %, status, prior year and the year-on-year movement.
- Direction-aware scoring – ten Upper-The-Better KPIs and three Lower-The-Better, so beating a cycle-time, rework or incident-rate target scores above 100%.
- Arrow colours driven by meaning rather than movement: we read the conditional-formatting rules and confirmed a falling incident rate shows a green down-arrow.
- Editable thresholds – On Target 100%, At Risk 95-99%, Missed under 95%, all sitting in visible formulas.
- A trend page with a twelve-month table and MTD and YTD combo charts for any KPI you pick.
- An analysis page with group roll-ups, an Average YTD Achievement by KPI Group bar chart and the top and bottom five KPIs year to date.
- Twenty-two wired KPI rows, thirteen used – adding a KPI needs no formula work.
Dashboard Pages Explanation
Home is a navigation page with tiles for the three dashboard pages, the three input sheets and the three reference sheets.
KPI Dashboard is the scorecard. Seven cards across the top recount themselves whenever you change the month: KPIs tracked, On Target, At Risk, Missed, how many are improving against prior year, and average achievement for MTD and YTD. In the shipped demo month (September 2025) that reads 13 tracked, 6 On Target, 6 At Risk, 1 Missed, 10 of 13 improving, 101.4% average MTD achievement and 98.3% YTD. Below the cards sits one row per KPI, month-to-date on the left and year-to-date on the right.
KPI Trend takes one KPI at a time. Pick it from a dropdown and the attribute strip – group, unit, type, owner, priority, frequency – plus the formula, the definition, a twelve-month table and both charts all redraw. Each chart plots actual and prior-year columns with a target line over the top.
KPI Analysis rolls achievement up by KPI group, counts On Target, At Risk and Missed within each group, charts average YTD achievement by group, and lists the top five and bottom five KPIs for the year to date.
KPI Input – Actual, Target and Prior Year are the three sheets you type in, each holding an MTD and a YTD column for all twelve months. KPI Definition is the master list every other sheet follows. Support holds the helper calculations. Read Me documents the wiring.
The Thirteen KPIs
| KPI | Group | Unit | Direction |
|---|---|---|---|
| Scaffold Inspection Pass Rate | Safety & Compliance | % | Higher is better |
| TG20 / SG4 Compliance | Safety & Compliance | % | Higher is better |
| Scaffold Erect & Dismantle Cycle Time | Operations | Days | Lower is better |
| RIDDOR Incident Rate | Safety & Compliance | Per 100K hours | Lower is better |
| Near-Miss Reports Logged | Safety & Compliance | Count | Higher is better |
| Labour Utilisation | Workforce | % | Higher is better |
| On-Time Job Completion | Operations | % | Higher is better |
| Rework Rate | Operations | % | Lower is better |
| Equipment Availability | Operations | % | Higher is better |
| Average Revenue per Job | Commercial | USD | Higher is better |
| First-Time Inspection Sign-Off | Safety & Compliance | % | Higher is better |
| Man-Hours Worked | Workforce | Count | Higher is better |
| Tag Register Accuracy | Safety & Compliance | % | Higher is better |
Note the deliberate choice on Near-Miss Reports Logged: it is scored Upper-The-Better, because a rising near-miss count usually signals a reporting culture rather than a deteriorating site. If your governance disagrees, flip one cell.
Scaffolding Excel KPI Dashboard vs. Google Sheets vs. Paid Scaffold-Management SaaS – Feature Comparison
| What you need | This Excel workbook | A Google Sheets build | Scaffold-management SaaS |
|---|---|---|---|
| Cost | One-off, lifetime access | One-off, lifetime access | Typically 50-300+ per user per month |
| Installed software | Excel 2013+, Excel for Mac, or a browser | A browser and a Google account | A browser and a subscription |
| Setup | Type your numbers over the demo data | Copy the sheet, then type | Implementation, mapping, training |
| Offline | Yes | No | No |
| Multi-user editing | Via OneDrive or SharePoint | Native | Native |
| Captures inspections automatically | No | No | Yes – that is the point of paying |
| Is a statutory inspection record or issues tags | No, and must never be used as one | No | Sometimes – verify the vendor’s claims |
| Change a KPI or a threshold | Type it – every cell unlocked | Type it | Vendor roadmap or paid work |
Who Should Use This Template
Owners and contracts managers of scaffolding firms; operations directors tracking erect-and-dismantle cycle time and on-time handover; health and safety leads who already hold the statutory records elsewhere and want the headline rates in the monthly pack; yard and fleet managers watching serviceable tube, fitting and board stock; resourcing managers reporting labour utilisation against man-hours; and commercial managers watching revenue per job.
It is the wrong choice if you want a system of record for inspections, handovers or tags, if you need design or load calculations, or if you expect the numbers to arrive without anyone typing them.
Real-World Use Cases
- The monthly contracts review. One page, thirteen KPIs, MTD and YTD, colour-coded, instead of five spreadsheets and a verbal summary.
- Reporting to a principal contractor. Inspection pass rate, first-time sign-off and TG20 / SG4 audit results in a fixed monthly format, with prior-year context.
- Yard and stock planning. Equipment availability tracked against target to justify the next tube-and-fitting purchase.
- Crew productivity. Labour utilisation read alongside man-hours worked, so a dip is judged against the exposure base.
- Commercial drift. Average revenue per job trended over twelve months to spot a change in job mix early.
Advantages of This Scaffolding Excel KPI Dashboard
- It is auditable. Plain VLOOKUP, MATCH, INDEX and COUNTIF – you can trace any figure back to a cell you typed.
- The maths checks out. We recomputed the whole file from the input sheets before publishing this review. All thirteen dashboard rows reconcile exactly: MTD and YTD actual, target and prior year match the inputs; achievement is inverted correctly for the three Lower-The-Better KPIs; every status label follows the stated thresholds; the seven summary cards match a fresh count; all four group roll-ups match a fresh average; and the Top 5 and Bottom 5 tables match a fresh ranking.
- Nothing is locked. Rename KPIs, change targets, restyle it, add your logo.
- It runs anywhere. Excel 2013+, Excel for Mac, Microsoft 365 and Excel for the web behave identically.
- It is honest about its scope. Reporting, not certification.
Opportunities for Improvement
Four cosmetic defects ship with this build, and it is better to hear them here than to find them after downloading:
- The Home page and the Read Me both say “14 KPIs”. The file contains thirteen, and every formula-driven count inside the workbook correctly reports 13. Two lines of hard-typed copy are stale.
- One Read Me line carries an example from a different industry. The note on cumulative versus average year-to-date illustrates accumulating volumes with “aircraft deliveries, non-conformance reports”. The rule is correct; the example is a leftover from another template.
- Two cells on the KPI Definition page are clipped. “Technical Compliance Manager” renders as “Technical Compliance Man”, and KPI 11’s formula text loses its trailing “100”. Widening the columns fixes both.
- The three input-sheet page images stop in August. The workbook holds all twelve months; the screenshots were simply captured at too narrow a width.
One further formatting note rather than a defect: the two Count KPIs are formatted to two decimals, so a count of 42 reads “42.00”. Change the number format on those two rows if it irritates you. Digit grouping is standard Western thousands separators throughout.
Structurally, the biggest limitation is that both MTD and YTD are typed rather than derived. That is a deliberate design choice – it lets you define year-to-date as a running total for near-miss reports and man-hours and a running average for rates and per-job revenue – but it does mean two numbers per KPI per month.
Best Practices
- Set your reporting year in the single cell on the Actual input sheet before you type anything else; the other sheets and every title re-base from it.
- Delete the demo data before you circulate the file. Nothing embarrasses a management pack faster than shipping someone else’s sample numbers.
- Agree your thresholds first. On Target 100% / At Risk 95-99% / Missed below 95% are defaults, not gospel.
- Decide per KPI whether YTD accumulates or averages, and write that convention into the KPI Definition sheet so the next person inherits it.
- Keep the safety file separate. Use this for trend and governance; keep inspections, handover certificates and tags in whatever statutory record you already maintain.
- If you need a refresher on the functions involved, Microsoft’s Excel support pages cover them all – there is nothing exotic in this workbook.
Explore Relevant Templates
- Elevator Maintenance KPI Dashboard in Excel – the same engine on a regulated maintenance trade.
- Solar Panel Installation KPI Dashboard in Excel – another site-based install trade using the identical scorecard layout.
- Glass Installation KPI Scorecard in Excel – the lighter scorecard line, for comparison.
- A companion Scaffolding Services KPI Scorecard in Excel is being prepared and is not published yet, so it is named here rather than linked.
- More reviews on the PK An Excel Expert blog.
Frequently Asked Questions
Does this certify our scaffolds or make our sites compliant? No. It is a reporting spreadsheet over numbers you type in. It does not inspect, certify or prove the safety, stability or load capacity of any scaffold, tower, tie or component; it does not establish compliance with the Work at Height Regulations, TG20 or SG4, OSHA 1926 subpart L, EN 12811, HSE requirements, any inspection regime or any CISRS-type competence scheme; it is not a design, a handover certificate, a statutory inspection record, a defect notice or a tag with any legal standing; and it does not replace a competent person’s statutory duties.
Are the numbers in the file real? No. They are demo data so you can see every formula and chart working immediately. Replace them before you show the file to anybody.
Does it use macros? No. Plain worksheet formulas only – no VBA, no Power Query, no Power Pivot, no add-ins, no security prompt.
Which versions of Excel does it work in? Excel 2013 and later on Windows, Excel for Mac, Microsoft 365 and Excel for the web.
Can I add or rename KPIs? Yes. The KPI Definition sheet is the master list and every other sheet follows it. Twenty-two rows are wired and thirteen are used, so nine more need no formula work.
Why does a lower-is-better KPI show above 100%? Because achievement is inverted for those KPIs – target divided by actual – so beating a cycle-time or incident-rate target scores the same way beating a revenue target does.
What is in the download? A .zip containing the .xlsx workbook and the Excel KPI Dashboard User Manual PDF.
About the Author
Written by the team behind PK An Excel Expert and NextGenTemplates, who have spent more than a decade building Excel, Power BI and Google Sheets reporting for construction, field-service and industrial businesses. We review every template against its own source file before we write about it, and we publish the defects we find.
Conclusion
If you run a scaffolding business and your monthly review is currently assembled by hand from an inspection log, a timesheet summary, a yard stock check and a sales ledger, the Scaffolding Services KPI Dashboard in Excel gives you a governed one-page scorecard on top of those numbers for a one-off price, with every formula visible and every cell unlocked. Just keep the boundary clear in your own head and in your team’s: it reports what you measured, and the statutory duty to inspect, certify and tag a scaffold stays exactly where it was.
Get the Scaffolding Services KPI Dashboard in Excel on NextGenTemplates – instant download, lifetime access.
