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

  1. Drop in the CSV file, or press Try with sample data.
  2. Check the units. Most supplier files are kWh. If the peak looks half or double what you expect, switch to kW.
  3. Read the figures, the charts and the notes on what the data shows.
  4. 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.