Ask a solar installer how last month went and you will usually get a story rather than a number. The crews were busy. One job dragged because the utility sat on the interconnection paperwork. There were a couple of callbacks. Sales felt slower than usual. All of that is true, and none of it is measurable, so nobody can tell whether last month was better or worse than the one before it.
The fix is not a bigger system. It is one page, filled in the same way every month, that turns those stories into ten numbers you can put side by side. That is what a Solar Panel Installation KPI Scorecard does, and this article walks through a ready-made Excel version of exactly that page – what is on it, how the traffic lights decide, and how to load it with your own figures in about twenty minutes.
What a Solar Panel Installation KPI Scorecard in Excel Actually Is
It is a monthly management report, not an analytics dashboard. There is no transaction table underneath it, no Power Query, no data model. You type ten numbers a month on one input sheet and the workbook lays them out as tiles: the value, what you are comparing against, the change in absolute and percentage terms, a traffic-light ball, and a twelve-month sparkline so the shape of the year is visible at a glance.
Worth being precise here, because the naming around these products is confusing. A KPI dashboard is slicer-driven and sits on top of raw records. A scorecard is the one-page summary a manager reads in a meeting. This is the scorecard, and it is deliberately the smaller, simpler thing. It has no macros at all – it is a plain .xlsx built from formulas, conditional formatting, camera pictures and sparklines, so there is no security banner and nothing to enable when it opens.
The Ten KPIs, and Why These Ten
The workbook ships with ten KPIs across five groups. They were chosen so that each stage of an installation business – winning the job, delivering it, closing it out and keeping the customer – has at least one measure attached to it.
| Group | KPI | What it measures | Direction |
|---|---|---|---|
| Installation | On-Time Installation % | Installs completed on or before the promised date | Higher is better |
| Installation | Install-to-PTO Cycle Days | Average days from signed contract to Permission to Operate | Lower is better |
| Installation | kW Installed | Total capacity installed and energised in the month | Higher is better |
| Quality | First-Time Inspection Pass % | Jurisdiction inspections passed on the first submission | Higher is better |
| Quality | Callback / Rework Rate % | Completed installs that needed a return visit | Lower is better |
| Performance | Fleet Performance Ratio % | Monitored energy yield against the design model | Higher is better |
| Safety | Safety Incidents | Recordable safety incidents across install crews | Lower is better |
| Sales | Revenue per Install | Average contract revenue per completed install | Higher is better |
| Sales | Lead-to-Sale Conversion % | Qualified leads that became signed contracts | Higher is better |
| Sales | Customer Satisfaction % | Post-install survey respondents rating service satisfactory | Higher is better |
None of those ten names is fixed. Each one lives on a KPI Definition sheet alongside its group, unit, formula text, plain-English definition, direction and year-to-date basis, and every other page in the workbook looks a KPI up by name. Rename one and the tile, the trend charts and the analysis tables all follow. A Check column flags you if two KPIs end up with the same name, which is the one thing that would quietly break the lookups.
How the Traffic Lights Decide Green, Amber and Red
This is the part most home-made scorecards get wrong. Half of the useful measures in a trade business are better when they go down – cycle days, rework, incidents – so a scorecard that treats every increase as good will happily paint a rising callback rate green.
Here every KPI carries a direction flag: UTB for upper-the-better, LTB for lower-the-better. Eight of the ten are UTB and two are LTB. The bands themselves sit on a Color Settings sheet as ordinary cells:
- Upper-the-better: at or above the comparison value is green; within 10% below it is amber; more than 10% below is red.
- Lower-the-better: at or below the comparison value is green; within 10% above is amber; more than 10% above is red.
Both bands are yours to move. If 10% is too generous for your business, type 5% and every traffic light, arrow and status label in the workbook re-evaluates immediately. There is no rule hidden in conditional formatting that you have to hunt down.
Reading the Sample Month
The download arrives loaded with a full 2025 sample year, which is the fastest way to see whether the layout suits you. Leave it on Aug-2025 with MTD selected and Vs. Target, and the month reads 4 Green, 4 Amber and 2 Red.
The two reds are the interesting ones. Callback / Rework Rate sits at 6.5% against a 5.6% target – 16.1% worse, and red precisely because the metric is lower-the-better. Lead-to-Sale Conversion is 19.8% against 24.2%, an 18.2% shortfall. Meanwhile On-Time Installation is green at 95.2% against 93.3% and Revenue per Install is green at $13,633 against $13,236. So the crews are hitting dates and the jobs are worth more than planned, but a fifth of the pipeline is leaking and too much finished work is coming back. That is a specific, actionable read of a month, and it took about four seconds.
The KPI Analysis page does the same job one level up. It rolls achievement up by group – Installation 97.4%, Quality 91.1%, Performance 101.0%, Safety 150.0%, Sales 94.0% for that month – and prints automatic Top 5 and Bottom 5 tables. The Bottom 5 is effectively your meeting agenda, ranked for you.
The KPI Trend Page
One number in isolation is not worth much. The Trend page takes a single KPI and shows it four ways at once: month-to-date actual against target, month-to-date against the same period last year, then the same two comparisons on a year-to-date basis. Above the charts it prints that KPI’s unit, group, type, formula and definition, so anyone opening the file can see exactly what is being measured without asking.
This is where a red tile turns into a decision. A callback rate that is red for one month is noise; one that has climbed for four months in a row against a flat prior year is a training or a supplier problem.
Loading It With Your Own Numbers
- Color Settings first. Set the report title and the reporting year. The year feeds the month picker, so the dropdown reads Aug-2025 rather than a bare Aug.
- KPI Definition next. Rename the ten KPIs to your own wording and set each one’s group, unit, formula text, definition, UTB or LTB direction and YTD basis. Keep the names unique.
- Input Data last. Each KPI gets its own twelve-row block with six columns – MTD actual, target and prior year, then the same three for year-to-date. Replace the sample figures with yours.
- Adjust the bands if 10% is the wrong amber width for the way you run the business.
One deliberate design choice catches people out: the workbook does not calculate year-to-date for you. That is not laziness, it is correctness – the right roll-up differs by KPI. kW Installed sums across the year; On-Time Installation % has to be averaged; Revenue per Install may need weighting by volume. Rather than guess, the template asks you to type the finished YTD figure and to record the rule you used in the YTD Basis column, so whoever fills it in next month does it the same way. If you would rather automate that step, Microsoft’s Excel support and learning library covers the aggregation functions involved.
Excel or Google Sheets?
Both editions exist and the layout is identical. Choose Excel if your numbers already live in Excel, if you need the file to work with no connection on a site visit, or if the data should never leave your own machines. Choose the Google Sheets edition if two or three people update the numbers and you would rather not email a workbook around. There is nothing you can do in one that you cannot do in the other.
If you work further up the value chain – generation and asset performance rather than installation – the Solar Energy KPI Scorecard in Excel covers those measures instead, and the Solar Energy Dashboard in Excel is the analytics-style alternative if you have transaction-level records to slice.
Frequently Asked Questions
Does it connect to my monitoring platform or CRM?
No. You type ten numbers a month. That keeps the file portable, offline and free of connections that break six months later.
Do I need macros enabled?
No. It is a plain .xlsx and contains no VBA at all.
How many KPIs can it hold?
Twenty. The scorecard page shows ten at a time and a set picker switches between KPI 1-10 and KPI 11-20.
Can I compare against something other than target?
Yes. The header switches the whole page between Target, the same period last year, and the prior month.
Which Excel versions work?
Excel 2016 and later on Windows and Mac, plus Microsoft 365. It opens in Excel for the web too, though sparklines render better in the desktop app.
What is in the download?
A ZIP with the .xlsx workbook and a PDF user manual.
Get the Template
The Solar Panel Installation KPI Scorecard in Excel is available on NextGenTemplates, with the Google Sheets edition alongside it. Twenty minutes of setup buys you a page you can put in front of an owner, a lender or a crew lead every month, in the same shape every time – which is the whole point of a scorecard.
