Phonetronics Marketplace
Product details
Show the difference your installs make, with numbers you can stand behind
Customers, lenders, councils and tenders increasingly ask what difference your work makes. This calculator turns your solar, heat pump and EV charger figures into an honest estimate of CO2e avoided, using the 2026 UK Government greenhouse gas conversion factors (DESNZ, published 11 June 2026), and the guide shows you how to report it without overclaiming.
What's inside
An Excel calculator: one row per job for solar PV (kWh generated), heat pumps (heat delivered, electricity used, old fuel and boiler efficiency) and EV chargers (kWh delivered, petrol or diesel replaced), with totals in kg and tonnes
A Factors 2026 tab with the 8 UK Government factors: the 7 used in the estimate plus the T&D losses factor for reference, where each sits in the 2026 file, and a note to replace them each June
Every input labelled Metered or Estimated, with input checks: the orange cells accept valid figures only (numbers of 0 or more, a boiler efficiency above 0 and up to 1.0, choices from the lists); an invalid figure shows a clear message instead of a number, a missing Metered or Estimated label is flagged in the Row check and counted under Rows needing attention so you fix it before using the totals, and formula cells are protected (no password)
A 1-page guide: how to use it, the method, a worked example and honest method notes
A one-page impact report template, with a pointer to the Well-being of Future Generations (Wales) Act goals for public-sector clients
A how-to-edit guide
Who it's for
Solar PV, battery, heat pump and EV charger installers and energy consultants in the UK who report impact to customers, lenders or public-sector clients.
Format
Excel (.xlsx) + 1-page guide in Word and PDF (2 pages with the report template), plus the how-to-edit guide. Tested in the free LibreOffice. Excel and Google Sheets compatibility is not verified. Instant download (ZIP).
£14.99. Download instantly.
Please note: Not legal advice: CO2e figures are estimates of avoided emissions, not a certified carbon footprint or a guaranteed saving; a qualified reviewer should check the EV and solar assumptions before any public claim. Not technical or financial advice; it helps you work towards good practice and does not by itself make any organisation compliant. This product was prepared with the help of AI tools. Licence: for use inside the buyer's own organisation. Questions: sales@phonetronics.uk
Similar products