About the Electricity Interval Data Analyzer
The Electricity Interval Data Analyzer is a browser-based tool for reading business electricity meter exports: CSV or XLSX files of half-hourly, hourly or finer interval readings. It runs without an account and without sending meter data to a server.
Why it exists
Electricity interval exports can be difficult to inspect directly: they may contain thousands of readings, different timestamp conventions and data-quality issues that affect the analysis. This analyzer turns those files into demand, energy, data-quality and what-if scenario views while keeping meter-file processing in the browser.
What it analyzes
The analyzer reads CSV and XLSX exports with a combined timestamp column or separate date and time columns, in kW or kWh, with start-of-interval or end-of-interval stamping and a chosen meter timezone. It detects reading intervals of 5, 10, 15, 30 and 60 minutes and reports data-quality problems explicitly: missing intervals, duplicate readings, unreadable rows, daylight-saving ambiguity and sustained changes in reading cadence.
From a valid file it produces the load profile, maximum interval demand, load factor, percentile demand, a load duration curve, monthly peaks, top intervals and weekday/time-of-day patterns, plus two what-if scenarios: a demand-limit exposure check and an additional-load scenario. The resolved data can be downloaded as a normalized CSV. The step-by-step workflow is described in how it works.
Design principles
- Usable without an account or sign-in.
- Meter-file processing stays in the browser, as described under privacy.
- Imperfect data is reported rather than silently guessed.
- Calculation rules are documented rather than implied by the interface.
- Important behaviours are covered by automated regression tests.
- The product's scope is stated explicitly, including what it does not do.
Documented and tested
The methodology documents how timestamps are interpreted, how units and metrics are calculated, how data-quality rules are applied and how the two scenarios are computed. The validation page summarizes the project's own regression cases — the behaviours the automated test suite checks every time the code changes. These are the project's own documentation and tests, not a third-party audit or certification.
What it does not do
The current product does not provide:
- Electricity-price comparison
- Supplier comparison
- Bill calculation
- Tariff optimization
- Solar sizing
- Battery sizing
- Demand forecasting
- Electrical-network or load-flow simulation
To use it, open the analyzer and choose a meter export.