Description
Half-hourly meters record 17,520 readings a year, and this analyser turns them into decisions. Paste the data in and the workbook splits every kWh into tariff bands, separates opening hours from out-of-hours use, finds baseload and peak demand, and checks each day against the agreed supply capacity.
- Handles up to 366 days at 48 readings a day
- Tariff bands and opening hours can be set separately for weekdays and weekends
- Daily baseload, peak demand (kW and kVA), load factor, out-of-hours kWh and cost
- Capacity check that flags risky days and lists the ten highest-demand days
- Heatmap of average demand for every half hour of the week, plus average daily profiles
- Automatic insights that price out-of-hours waste, model moving load out of the peak period and test whether a lower agreed capacity would save money
- Converts supplier exports that have one row per half hour, and includes a CSV import layout
- Includes a blank analyser, an example with a full year of data and a Quick Start Guide
