Solar · Excel workbook
Solar PV Performance and O&M Tracker
Record energy, irradiation, expected output and downtime without mixing performance definitions.
Download free XLSX ↗Version 1.0 · 25 September 2026 · No registration required
What you need
- DC capacity in kWp
- Monthly generated and expected kWh
- Plane-of-array irradiation in kWh/m²
- Eligible daylight hours and downtime
- Maintenance observations
What you get
- Specific yield in kWh/kWp
- Irradiation-based performance ratio
- Actual-to-expected energy ratio
- Time-based availability
How to use it
- Save a working copy and read the instructions in the file.
- Replace illustrative inputs or response fields with your site records.
- Check units, dates and boundaries before using the results.
- Keep the completed file with its supporting evidence.
Method
Specific yield = kWh ÷ kWp. PR = specific yield ÷ reference yield, using 1 kW/m² reference irradiance. Availability = (eligible hours − downtime) ÷ eligible hours.
Scope and limitations
Expected output must use an explained basis. Missing irradiation leaves PR unavailable. Availability is not capacity-weighted. Use matched monthly records and preserve raw meter data.
Reference: PV and energy storage O&M best practices
Read the related guide: Practical guidance for this tool.