The Fire Safety Services KPI Dashboard in Excel is a formula-driven monthly reporting workbook for fire protection contractors, inspection teams, compliance managers and HSE leads. You type your own figures into three input sheets; the scorecard, the trend page and the analysis page recalculate on their own. No Power Query, no data model, no macros, no add-ins.
Read This Before Anything Else
This is a reporting template over data the buyer types in. It is important to be blunt about what that means in a fire safety context, because the consequences of a wrong impression here are not commercial. This workbook does not:
- certify, inspect, test or prove the condition of any fire alarm, extinguisher, sprinkler, suppression system, emergency light or fire door;
- establish compliance with NFPA 25, NFPA 72, BS 5839, BS 9999, the Regulatory Reform (Fire Safety) Order, OSHA, local fire codes, or any licensing or third-party certification scheme;
- constitute a fire risk assessment, a service or inspection certificate, a commissioning record, a defect notice, or a log book of any legal standing;
- replace the statutory duties of a competent person or a responsible person.
Every inspection-due, response-time, defect-rectification and compliance figure you see in the screenshots is a buyer-entered demo number, shipped as a worked example so you can see the workbook running before you replace anything. None of it must ever be presented as evidence that a system is safe or that a building is compliant. The dashboard reports what you type into it, and nothing more.
Which Template This Actually Is
Three NextGenTemplates families carry near-identical names, and they are different products rather than variations of one. This one is the KPI Dashboard:
- The KPI Dashboard line – this product. A month-picker scorecard. Every KPI sits on one row with MTD and YTD actual, target, achievement percentage, status, prior year and year-on-year movement, backed by a per-KPI trend page and a group analysis page.
- The Excel Dashboard line is the analytical one – slicers, pivot-driven charts and a free-form analysis canvas rather than a fixed scorecard.
- The KPI Scorecard line is the compact one – a shorter ten-KPI review on fewer pages.
A Fire Safety Services KPI Scorecard in Excel (product 94301) is being prepared as the compact companion to this workbook. It is not live yet, so it is named here rather than linked.
What Is Actually In The File
I opened the workbook and counted rather than trusting the marketing copy. It ships:
- 15 KPIs, numbered 1 to 15, across 6 KPI groups.
- Three input sheets – Actual, Target and Prior Year – each with 15 populated KPI rows and twelve months of MTD and YTD columns. That is 540 year-to-date cells in total.
- Eleven sheets: Home, KPI Dashboard, KPI Trend, KPI Analysis, the three inputs, KPI Definition, Support, Read Me and Get More Templates.
- Capacity wired for 22 KPI rows, so seven more can be added without touching a formula.
The groups break down as Service Delivery 3, Compliance 2, Service Quality 5, Workforce 2, Customer 2 and Finance 1 – which sums to the fifteen on the scorecard, and matches the group table and the bar chart on the analysis page.
The KPIs You Get
- Service Delivery – Fire Extinguisher Inspections Completed, Scheduled Maintenance Completion Rate, Emergency Callout Response Time.
- Compliance – Fire Risk Assessments Completed, Compliance Certification Rate.
- Service Quality – First-Time Inspection Pass Rate, Mean Time To Rectify Defects, Critical Defect Rectification within SLA, False Alarm Rate, Equipment Fault Rate.
- Workforce – Technician Utilisation, Total Recordable Incident Rate.
- Customer – Customer Satisfaction (CSAT), Contract Renewal Rate.
- Finance – Revenue per Service Visit.
Six of those are lower-is-better measures, which matters for how the workbook scores them – see the UTB/LTB note below.
How The Scoring Works
Each KPI is flagged UTB (Upper The Better) or LTB (Lower The Better). Achievement is actual divided by target for a UTB KPI, and target divided by actual for an LTB one. Beating a callout-response or defect-rate target therefore scores above 100%, exactly the way beating a revenue target does, instead of looking like a failure.
Status thresholds are On Target from 100%, At Risk from 95% to 99%, and Missed below 95%. They live in ordinary worksheet formulas, so you can move them to match your own governance.
The movement arrows are worth a mention because they are a common thing to get wrong. The glyph shows the raw direction – actual above or below the comparator – while the colour shows whether that direction is good for that KPI. So a falling equipment fault rate prints a green down-arrow, and a rising callout response time prints a red up-arrow. I checked the conditional formatting rules on this build and they are wired correctly in both directions.
The Three Pages Of The Fire Safety Services KPI Dashboard in Excel You Will Actually Use
KPI Dashboard
Pick a month from the dropdown and seven summary cards plus all fifteen KPI rows re-read. In the shipped demo month the cards show 15 KPIs tracked, 4 On Target, 8 At Risk, 3 Missed, 7 of 15 improving on prior year, and average achievement of 95.0% MTD and 97.9% YTD. Those are sample figures describing sample data.
KPI Trend
One KPI at a time, chosen from a dropdown. The attribute strip, the formula and definition, a twelve-month table and two combo charts all follow the selection. This page shows the full twelve months regardless of the month picked on the scorecard – it is deliberately a whole-year view of a single measure, driven by the KPI dropdown rather than the month dropdown.
KPI Analysis
Achievement rolled up by KPI group with an Average YTD Achievement by KPI Group bar chart, plus Top 5 and Bottom 5 KPIs on year-to-date achievement. Ranking on achievement rather than raw value means a lower-is-better KPI that beats its target ranks near the top, which is the correct behaviour.
Honest Notes On This Build
I read the workbook and recomputed its figures rather than describing the pictures. Here is what held and what did not.
The numbers reconcile. All 540 year-to-date cells across the three input sheets recompute correctly – counts accumulate through the year, while rates, ratios and indices run as averages, so nothing sums to an absurd 1,100% by December. The seven summary cards reconcile with the fifteen rows (4 + 8 + 3 = 15), the two average-achievement cards match the mean of the achievement columns to eight decimal places, and the analysis page’s group table agrees with both the scorecard and its own chart.
Two wording slips. The Home page and the Read Me both say the workbook has 14 KPIs. It has 15. Nothing calculates from that sentence – it is plain text on two cells and you can type over it – but it is wrong and it ships that way. Separately, the Read Me illustrates its cumulative-versus-average rule with “aircraft deliveries, non-conformance reports”, which are leftover examples from another template. The rule itself is right; only the examples are off-topic.
Minor clipping on two exported pages. On the KPI Trend page the long Definition text and the December prior-year column sit just past the print width, and a few Formula, Definition and Owner cells on the KPI Definition sheet are trimmed to their row height. Widen the column or the row in Excel and the full text is there; nothing is missing from the file itself.
I found no unit errors, no currency mis-grouping, no arrows coloured by raw movement, and no percentage rounding up to 100% while flagged At Risk – all of which are worth checking on any KPI template before you rely on it.
How To Put Your Own Data Into The Fire Safety Services KPI Dashboard in Excel
- Open the workbook and read the Read Me sheet first.
- On KPI Definition, rename the sample KPIs to your own terminology, or keep them.
- Set the first month of your reporting year in cell E3 of KPI Input – Actual. The target sheet, the prior-year sheet, the month dropdown and every sheet title re-base from that one cell.
- Replace the demo figures on the Actual, Target and Prior Year sheets with your own monthly numbers.
- Pick your reporting month on KPI Dashboard and review.
- Use KPI Trend for a single measure over twelve months, and KPI Analysis for the group roll-up and rankings.
A Sensible Review Cadence
The workbook earns its keep in a monthly operations review. One owner collects the source figures before the meeting, a second person sanity-checks the targets, and the manager works through exceptions group by group rather than reading fifteen rows aloud. Separating service delivery from compliance, service quality, workforce, customer and finance is most of the value: it stops a good month on inspection volume from masking a bad month on critical-defect SLA.
Because it is file based, it also gives a smaller contractor a simple audit trail of its own reporting – save a dated copy after each cycle and keep the source extracts beside it. That is a record of what you reported, not a record of any system’s condition, and the two should never be confused.
Frequently Asked Questions
Does this certify our fire safety systems or make a building compliant?
No. It is an Excel reporting template over figures you type in. It is not a fire risk assessment, an inspection or service certificate, a commissioning record or a log book, and it establishes compliance with nothing – not NFPA 25 or 72, not BS 5839 or BS 9999, not the Regulatory Reform (Fire Safety) Order, not OSHA, and not any local fire code or certification scheme. Only a competent person can do that work.
Are the figures in the screenshots real?
No. Everything shipped in the workbook and shown in the images is demo data, included so the template can be evaluated before purchase. It describes no real building, contract or system.
How many KPIs does it really have?
Fifteen, in six groups. The Home and Read Me pages say fourteen; that wording is wrong and the file is right.
Can I change the KPIs?
Yes. Edit the KPI Definition sheet and every other sheet follows automatically. There is room for 22 in total.
Does it use macros or Power Query?
Neither. Plain worksheet formulas – VLOOKUP, MATCH, INDEX and COUNTIF – opening in Excel 2013 and later, and in Excel for the web.
Does it import job or alarm data automatically?
No. You enter the monthly figures yourself, which is what keeps it portable and keeps you in control of each definition.
What is in the download?
One ZIP containing the .xlsx workbook and an Excel KPI Dashboard user manual PDF.
Where To Get The Fire Safety Services KPI Dashboard in Excel
The full product, with all ten page previews, is here: Fire Safety Services KPI Dashboard in Excel on NextGenTemplates.
The same fifteen-KPI scorecard is also published as a Power BI report and a Google Sheets version, and the compact layout exists as a Google Sheets KPI scorecard.
Related Reading On This Site
If you are comparing platforms, the write-up of the Fire Safety Services KPI Dashboard in Power BI covers the same KPI set as an interactive report. For the same workbook pattern applied to an adjacent trade, see the elevator maintenance KPI dashboard and the HVAC service dashboard in Excel. More reporting templates are collected in the Excel dashboard articles.
