Commercial Building Energy & Utility Cost Audit Dashboard

£79.00

Track electricity, gas and water costs for a commercial building in one self-calculating Excel and Google Sheets dashboard, with automated charts, kWh tracking, carbon reporting and peak-rate anomaly alerts.

Description

Know exactly where your building’s utility money goes, month by month. Enter each bill once and the workbook calculates unit costs, year-on-year change, energy use per square metre, budget variance and carbon emissions, then flags anything that needs attention.

  • Tracks 24 months of electricity (peak, day and night kWh), gas and water
  • Dashboard with 12 headline figures and four automated charts, switchable between years
  • Six alerts: high peak-time share, peak rate billed above contract, electricity and gas rises against last year, water leaks and high average electricity cost
  • Benchmarks against CIBSE TM46 typical values for 15 building types
  • Carbon reporting using the UK government’s 2026 conversion factors
  • Audit findings written automatically in plain English
  • Meter register that warns before contracts come up for renewal
  • Action log with owners, due dates and target vs verified savings
  • Includes a blank template, an example with two years of data and a Quick Start Guide. No macros or add-ins.