About this tool
What it does
The half-hourly data viewer reads the HH file that comes with a half-hourly electricity meter. It shows how much the site uses, when it uses it and how peaky it is: total kWh, peak demand, base load, load factor and the share used at night.
Charts set the average weekday against the weekend, and a heat map gives one row per day. A few plain sentences say what the shape shows. The file is read in your browser and never uploaded.
How to use it
- Drop in the CSV file, or press Try with sample data.
- Check the units. Most supplier files are kWh. If the peak looks half or double what you expect, switch to kW.
- Read the figures, the charts and the notes on what the data shows.
- Download the summary as a CSV if you need to pass it on.
Questions
- What file layouts does it read?
- One row per day with 48 half-hourly values, or one row per reading with a date and a time or settlement period. Dates can be dd/mm/yyyy, yyyy-mm-dd or dd-MMM-yy.
- What happens on clock-change days?
- They are handled. The March day has 46 half hours and the October day has 50.
- What about missing readings?
- They are left out of every figure and never filled in. If more than 5% are missing, the page says to treat the totals with care.
- Is the meter number shown or stored?
- No. Identifier columns are not read into the page, the file name is not shown, and nothing is stored or uploaded.