HAUSE Energy Better business energy decisions. Start with your bill. Canada + United States +1 587-316-6194
CommercialElectricityRates.com byHAUSE

Tool

Interval data analyzer

Open the 15-minute data from your smart meter and see your peak demand, when it happens, how rarely you are near it, your load factor and what the building draws overnight. Your file stays on your computer.

  • ReadsGreen Button CSV and XML, most utility CSVs
  • Your fileNever leaves your browser
  • CostFree, no sign-up

An interval data analyzer reads a smart meter’s 15-minute or hourly readings and shows when a building’s demand peaks, how steady its load is and what runs overnight. In the modelled office below, demand peaked at 179.2 kW but stayed within 10% of that peak for only 143 hours of the year, with a 42% load factor.

Source: Interval analysis engine v1.0.0, modelled sample · 2026-11-11

Your file is not uploaded. This page reads it with your browser and does every calculation on your computer. Nothing is sent to this site or anyone else, and nothing is kept once you close the page.

Green Button CSV or XML, or a CSV with a date and time column and a kWh or kW column. You can also drop the file here.
From your bill or rate schedule. Used only to value the peak cuts below.
No file to hand?

Showing: Sample: a modelled office, not a real building. Choose a file to see your own.

The analysis

Sample: a modelled office, not a real building: 35,040 readings at 15 minutes, Wed Jan 1, 2025, 12:00 AM to Wed Dec 31, 2025, 11:45 PM (365.0 days), values from the “USAGE (kWh)” column.

Peak demand179.2 kWThu Jul 24, 2025, 2:00 PM
Energy used660,973 kWhover 365.0 days
Load factor42%moderate
Base load39.5 kW5th percentile of demand

The meter peaked at 179.2 kW on Thu Jul 24, 2025, 2:00 PM. Demand was within 10% of that peak for only 143.0 hours of the 8,760 hours in the file (1.6%), on 83 days.

Load factor is 42% (moderate): the meter averaged 75.5 kW against a 179.2 kW peak. Mixed profile. Both the supply rate and the demand structure matter.

Overnight (midnight to 5 AM) the meter averaged 41.2 kW, 29% of the weekday daytime average of 141.3 kW. A low base like this means little runs overnight.

A typical day

Average demand by hour of day, weekdays and weekends On an average weekday demand is highest around 1 PM, at 151.2 kW; the overnight average is 41.2 kW. 020406080100120140160 12 AM3 AM6 AM9 AM12 PM3 PM6 PM9 PM11 PM
WeekdaysWeekendsAverage kW in each hour of the day

Month by month

Peak demand in each month January 2025: 155.6 kW; February 2025: 155.6 kW; March 2025: 152.6 kW; April 2025: 150.6 kW; May 2025: 170.3 kW; June 2025: 175.8 kW; July 2025: 179.2 kW; August 2025: 177.8 kW; September 2025: 168.6 kW; October 2025: 155.1 kW; November 2025: 155.6 kW; December 2025: 154.4 kW 020406080100120140160180 JanFebMarAprMayJunJulAugSepOctNovDec
Highest kW in each month; the darker bar is the highest of all
Energy, peak demand and load factor by month
MonthkWhPeak kWPeak setLoad factor
January 202555,454155.6Wed Jan 15, 2025, 2:00 PM48%
February 202550,061155.6Thu Feb 6, 2025, 2:00 PM48%
March 202553,644152.6Tue Mar 4, 2025, 1:45 PM47%
April 202553,225150.6Tue Apr 29, 2025, 1:45 PM49%
May 202556,363170.3Thu May 29, 2025, 9:45 AM44%
June 202556,410175.8Tue Jun 24, 2025, 2:00 PM45%
July 202559,583179.2Thu Jul 24, 2025, 2:00 PM45%
August 202557,842177.8Tue Aug 5, 2025, 2:00 PM44%
September 202556,030168.6Thu Sep 4, 2025, 1:45 PM46%
October 202555,591155.1Wed Oct 1, 2025, 2:00 PM48%
November 202551,542155.6Fri Nov 28, 2025, 11:00 AM46%
December 202555,230154.4Mon Dec 29, 2025, 2:00 PM48%

How rare the peak is

Each row is a lower ceiling on demand. The hours column is how long the meter spent above it, which is the time a battery, a controller or a change of schedule would have to cover to hold demand there. The last column adds up how far each month’s peak would fall.

Peak reduction: hours above each ceiling
Cut from the peakCeilingHours above itDaysMonthly peaks fall by
5% (9.0 kW)170.3 kW39.8 h4922.0 kW
10% (17.9 kW)161.3 kW143.0 h8365.1 kW
15% (26.9 kW)152.3 kW302.0 h146124.8 kW
20% (35.8 kW)143.4 kW948.3 h258230.5 kW

Enter your demand charge in $ per kW above to see what each cut is worth at your own rate.

The ten highest intervals

The ten highest-demand intervals in the file
WhenkWkWh in the interval
Thu Jul 24, 2025, 2:00 PM179.244.8
Fri Jul 11, 2025, 2:00 PM178.844.7
Wed Jul 9, 2025, 2:00 PM178.744.7
Mon Jul 14, 2025, 1:45 PM178.644.7
Tue Aug 5, 2025, 2:00 PM177.844.4
Tue Jul 22, 2025, 2:15 PM177.544.4
Tue Jul 8, 2025, 2:00 PM177.044.3
Wed Jul 16, 2025, 2:00 PM176.744.2
Mon Jul 28, 2025, 1:30 PM176.644.2
Tue Jul 29, 2025, 1:15 PM176.644.1

The sample is a year of 15-minute readings generated from this site’s illustrative office load shape, with more cooling in summer, quiet weekends and a few short spikes. It is a model for showing what the tool does, not a measured building.

What interval data is

A monthly bill reports one number for energy and, on a demand-metered account, one number for the highest demand. The meter knows far more. A smart meter records how much electricity flowed in every short period, commonly 15 minutes, so a year of data holds about 35,000 readings. That record is what shows when a building uses power: the hour the peak is set, whether the load drops at night and at weekends, and whether one month’s demand charge came from a single unusual afternoon.

Most utilities let a customer download it from their online account. Many offer it in the Green Button format, built on the North American Energy Standards Board’s Energy Services Provider Interface standard, as a CSV spreadsheet or an XML file, often behind a button labelled “Green Button” or “Download My Data”. Pick the longest period on offer, ideally twelve months, so every season is in it. If there is no download, the utility’s business service team can usually supply interval data for the meter; our guide to getting interval data covers how to ask.

What the numbers mean

  • Peak demand is the highest rate of draw in any interval, in kW. On many commercial rate schedules it sets the demand charge for the month, which is why one bad 15 minutes can cost as much as days of energy. How demand charges work.
  • Hours near the peak is how long the meter spent within 10% of its highest reading. When that is a few dozen hours a year, the peak comes from a handful of moments, and staggering equipment start-ups, changing a schedule or a controller can trim it without changing how the building runs.
  • Load factor is average demand divided by peak demand. A low figure means a peaky account where demand charges matter most; a high one means steady use where the energy price carries the cost. The load factor calculator does the same sum from a bill.
  • Base load is the demand the building almost never drops below (the 5th percentile). Compared with the weekday daytime average, it shows how much runs when nobody is there.

What to do with the result

Look at the ten highest intervals first. If they fall on a few days, find out what happened then: a chiller and a kitchen starting together, a test of backup equipment, a charging schedule. Then check how your utility measures billed demand, because some schedules use only certain hours, carry a ratchet from earlier months or bill on the grid’s peak rather than yours. The demand charge and ratchet calculator models a ratchet once you know the rule.

The formulas

kW in an interval   = kWh in the interval × 60 ÷ interval minutes
peak demand         = the highest kW in any interval
average demand      = total kWh ÷ hours of readings
load factor         = average demand ÷ peak demand
base load           = 5th percentile of interval kW
hours above ceiling = intervals above (peak × (1 − cut)) × interval minutes ÷ 60
value of a cut      = Σ over months of (that month’s peak − ceiling, if above) × your $/kW

Limits

  • It reads; it does not bill. It never estimates a bill and quotes no prices. The only dollar figure is your own demand charge multiplied by kW.
  • It uses the meter’s clock. Times are the file’s own. Weekends are Saturday and Sunday; public holidays are not separated.
  • Files differ. If a file cannot be read, the page says why. Gaps, repeated times and readings of energy sent to the grid are reported, not hidden.

Common questions

What is interval data?
Interval data is the record a smart meter keeps of how much electricity flowed in each short period, usually every 15 minutes, sometimes every 5, 30 or 60. A month of 15-minute data has close to 3,000 readings, against one total on the bill, so it shows when the building uses power and not only how much.
How do I download my interval data?
Sign in to your utility account online and look for a usage page with a download option, often labelled Green Button or Download My Data. Choose the longest period offered, ideally 12 months, at the shortest interval, and save it as CSV or XML. If the account has no download, ask the utility’s business service team for interval data for the meter.
What is a good load factor for a business?
Load factor is average demand divided by peak demand. Below about 40 percent the account is peaky and demand charges tend to be a large share of the bill; above about 60 percent the load is steady and the energy price matters more. Neither is good or bad in itself; it says which part of the bill is worth working on.
Does my file get uploaded anywhere?
No. The page reads the file with your browser and does every calculation on your computer. Nothing is sent to this site or anyone else, and nothing is stored once you close the page.
Get a free bill check

Send a bill, with the interval file if you have it, and a person will check the rate schedule and demand structure against it. Nobody calls unless you ask.