Demolition Services KPI Scorecard in Google Sheets

The Demolition Services KPI Scorecard in Google Sheets puts 10 demolition KPIs from four groups on one page: two safety measures, three project execution measures, three financial measures and two environmental measures. Every KPI gets a traffic-light card with a 12-month mini chart, a second page trends one KPI at a time against Target and prior year, and the sample file carries 120 monthly records. Seven KPIs are upper-the-better and three are lower-the-better, and the lights respect that direction.

Demolition contractors juggle incident rates, takedown speed, plant availability, salvage income and dust complaints, often in separate spreadsheets that never meet at month end. This scorecard gives an owner or project manager one shared Google Sheets file where those numbers sit side by side, with a month picker and switches for MTD/YTD and Target/PY. It is a scorecard, not a job management or compliance system, and this guide explains exactly what it does, including the issues we found while testing the current build.

Key Features of the Demolition Services KPI Scorecard in Google Sheets

• Three selectors on the Scorecard: Month (Jan to Dec), MTD or YTD, and a comparison against Target or PY. All 10 cards recalculate from the Input Data sheet with SUMIFS formulas, without scripts or add-ons.
• Direction-aware traffic lights: for an upper-the-better (UTB) KPI, a result at or below the comparison value is red, up to 10% above is amber and more than 10% above is green. Lower-the-better (LTB) KPIs use the mirror rule.
• Complete cards: each card shows the value, the Target or PY value, the absolute change, the change %, an arrow and a 12-month mini column chart with the selected month highlighted.
• KPI Trend page: choose one KPI to see its group, unit, type, formula, definition and two charts of Actual vs Target vs PY by month, one for MTD and one for YTD.
• Documented metrics: the KPI Definition sheet lists a unit, formula, definition and UTB/LTB type for each KPI, so a new manager can read what every number means.
• Plain monthly input: Input Data stores MTD and YTD Actual, Target and PY for 12 months per KPI. YTD is typed, not calculated.

The 10 KPIs

• Safety & Compliance: Total Recordable Incident Rate (per 200k hrs, LTB), Safety Training Compliance (%)
• Project Execution: On-Time Project Completion (%), Structure Takedown Rate (sq ft/day), Equipment Uptime (%)
• Financial: Gross Margin per Project (%), Salvage Revenue Recovery ($/project), Cost Variance vs Budget (%, LTB)
• Environmental: Waste Diversion Rate (%), Dust and Noise Complaints (count/project, LTB)

Scorecard Pages Explanation

Page 1: Scorecard

The main page holds 10 cards in two rows of five under a header with the Month, MTD/YTD and Target/PY selectors. With December, MTD and Target selected, the sample reads 4 green, 3 amber and 3 red. Equipment Uptime shows 85.8 against a 73.8 target (green, up 16.3%), Gross Margin per Project shows 28.6 against 27.5 (amber, up 4.0%) and Dust and Noise Complaints shows 3.4 against 2.9 (red, because lower is better).

Page 2: KPI Trend

Select a KPI and the page fills in KPI Group, Unit, Type, Formula and Definition, then plots Actual vs Target vs PY (MTD) by Month and Actual vs Target vs PY (YTD) by Month for all 12 months. The sample shows Total Recordable Incident Rate, where the December MTD value of 2.1 sits just above its 2.0 target.

Page 3: KPI Definition

A table of the 10 KPIs with #, KPI Group, KPI Name, Unit, Formula, Definition and Type. For example, Salvage Revenue Recovery = Total Salvage and Scrap Income / Number of Projects, and Waste Diversion Rate = Debris Recycled or Reused / Total Debris Generated x 100.

Page 4: Input Data

Ten blocks labelled KPI-1 to KPI-10, each with 12 monthly rows and six figures per row: MTD Actual, Target and PY, then YTD Actual, Target and PY. This is the only sheet you update each month.

Behind these pages sit a Read Me tab, a Color Settings tab and two helper tabs, Support and Trend_Support, which do the lookups for the cards and charts.

Google Sheets Scorecard vs. Excel Workbook vs. Construction SaaS: Feature Comparison

For a demolition firm that wants a clear monthly KPI review without paying for a project platform, this Google Sheets scorecard sits in the sweet spot.

Who Should Use This Template

Perfect for:

• Owners and operations managers of demolition contractors who hold a monthly performance review
• Finance leads who track margin, salvage income and cost variance against budget
• Project managers who want safety, schedule, plant and environmental results on one shared page

Not a fit if:

• You need job-by-job, daily or crew-level logging, because the file works with monthly totals
• You want a safety management, asbestos, permit or compliance record; this file only reports numbers you enter
• You want several years in one file, because each copy covers one Jan to Dec year

Real-World Use Cases

Marcus runs a 25-person demolition contractor. At month end he flips the comparison switch from Target to PY to check whether Structure Takedown Rate and On-Time Project Completion beat last year, then shares the sheet link with his supervisors so everyone sees the same lights.

Priya is the finance lead at a regional wrecking and salvage firm. She keeps the Scorecard in YTD mode and watches Gross Margin per Project, Salvage Revenue Recovery and Cost Variance vs Budget. When Salvage Revenue turns red she opens KPI Trend to see which months dragged it down.

Tom manages projects for an interior strip-out company. Clients ask about dust and waste, so he reports Waste Diversion Rate and Dust and Noise Complaints next to Equipment Uptime, and uses the KPI Definition sheet to explain how each figure is calculated.

Advantages of the Demolition Scorecard

• One page for four areas of the business: safety, delivery, money and environment are reviewed together instead of in separate files.
• Correct colours for lower-the-better metrics: incident rate, cost variance and complaints turn green when they fall, not when they rise.
• Two comparison bases: switching between Target and PY answers both “are we on plan?” and “are we better than last year?”.
• No recurring cost: a one-time purchase that lives in your own Google Drive and can be shared with any number of viewers.
• Transparent formulas: the KPI Definition sheet and ordinary SUMIFS lookups make every card auditable by anyone who opens the file.

Opportunities for Improvement

We opened the live sheet behind this template and checked its formulas and drop-downs before writing this post. These are the issues a buyer should know about:

• June and July show zeros on the Scorecard. The Month drop-down in cell N1 offers “June” and “July”, but Input Data and the lookup formulas use “Jun” and “Jul”. Because the lookup matches the exact text, choosing either month makes all 10 cards read 0.0 and the lights lose their colour. The fix takes a minute: open Data > Data validation on N1 and change those two entries to Jun and Jul. The KPI Trend charts are not affected.
• The Read Me tab is empty. There are no in-file instructions yet, so use this post and the steps below.
• Color Settings is not connected. Nothing in the file reads the Color Settings tab. The red, amber and green bands are a small table in the Support tab (cells Z4:AE6), so edit those cells if you want different thresholds.
• One card colours its change figures wrongly. On the On-Time Project Completion card, the change and change % figures appear in red even when the result beats the target, because both of that card’s formatting rules use red.
• Design limits: YTD values are typed rather than calculated, the file holds monthly totals for a single year, KPI names must match exactly between KPI Definition and Input Data, and the supplied figures are fictional sample data.

Best Practices

1. Apply the June/July drop-down fix as soon as you make your copy.
2. Agree each KPI formula with your team using the KPI Definition sheet before entering real figures.
3. Set Targets for the whole year at the start, and load last year’s actuals as PY so the comparison switch is useful from month one.
4. Enter figures on the same working day each month and review the Scorecard in both MTD and YTD mode.
5. Share view-only links with site staff and keep edit rights for the person who maintains Input Data. Google explains the options in its guide to sharing files from Google Drive.
6. If you change thresholds, adjust the Support tab table and note the new bands for your team.

For more on how drop-down cells work, see Google’s help page on creating a drop-down list in Google Sheets.

Explore Relevant Templates

• Our walkthrough of the Scaffolding Services KPI Scorecard in Google Sheets covers the same scorecard layout for scaffolding firms.
• The Crane Rental KPI Scorecard in Google Sheets post shows it applied to lifting and hire operations.
• Read the Concrete Contractor KPI Scorecard in Google Sheets guide for another construction trade.
• For daily job records rather than monthly KPIs, see the Demolition Contractor Management System Web App.

Excel editions of this demolition scorecard and dashboard are in preparation.

Frequently Asked Questions

What does the demolition services scorecard measure?

It measures 10 KPIs: Total Recordable Incident Rate, Safety Training Compliance, On-Time Project Completion, Structure Takedown Rate, Equipment Uptime, Gross Margin per Project, Salvage Revenue Recovery, Cost Variance vs Budget, Waste Diversion Rate and Dust and Noise Complaints, each with a unit, formula and direction.

Is this the same as the Demolition Services KPI Dashboard?

No. This is the Google Sheets KPI Scorecard, built around 10 traffic-light cards, a month picker and a KPI Trend page. The KPI Dashboard is a separate product with a different layout, so choose the scorecard when you want a one-page monthly review.

How long does setup take?

Making a copy takes under a minute and the June/July drop-down fix takes about a minute more. The rest of setup is entering 12 months of MTD and YTD Actual, Target and PY figures for your 10 KPIs in the Input Data sheet.

How does it compare to Procore or Buildertrend?

Procore and Buildertrend are subscription platforms that capture field and project data. This scorecard costs $8.99 once and only reports monthly KPI totals you enter. It suits contractors who already have the numbers and want a shared monthly scorecard without per-seat fees.

Can I change the traffic-light thresholds?

Yes. Edit the RAG table in the Support tab, cells Z4:AE6. By default a KPI is red at or below its comparison value, amber up to 10% better and green beyond that, with the mirror rule for lower-the-better KPIs. The Color Settings tab is not linked in this build.

Does it prove safety or environmental compliance?

No. It displays figures you type in, such as incident rate or waste diversion. It does not log incidents, asbestos surveys, permits or inspections and is not evidence of regulatory compliance. Keep those records in the systems your business already uses.

About the Author

Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Conclusion

If your demolition business reviews safety, delivery, margin and environmental results once a month, this scorecard brings all 10 figures onto one colour-coded page in Google Sheets for a one-time price. Apply the one-minute June/July fix, load your own targets and actuals, and the cards and trend charts are ready for your next review.

👉 Click here to Purchase the Demolition Services KPI Scorecard in Google Sheets

✅ Instant download · One-time payment · No subscription

🎥 More tutorials: Youtube.com/@NeoTechNavigators

Last updated: September 2026