Analyze Energy Consumption Data from Excel

Energy consumption exports from utility portals and building management systems arrive with interval meter readings, demand peaks, and rate schedules that need reconciliation. The data spans months or years with gaps, duplicate timestamps, and mixed units that make cost analysis difficult without cleaning first. Quadratic reads meter timestamps as dates rather than text, fills missing intervals with calculated values, and applies rate tables to each row so you can verify charges without rebuilding formulas for every billing period.

Drop your file in and ask a question — no account needed.

Upload your spreadsheet.xlsx .xls .csv — free to try, no account

Or start with

How do I analyze energy consumption data from Excel?How do I find missing intervals in my meter data?How do I calculate peak demand charges from interval readings?How do I apply time-of-use rates to hourly energy data?How do I aggregate multiple meters by building?

What this export contains

Meter ID

Read Date

Read Time

Interval End

kWh Usage

kW Demand

Power Factor

Rate Period

Temperature

Cost

Billing Period

Meter Type

Common questions

How do I analyze energy consumption data from Excel?

Import your utility export into Quadratic, then sort by meter ID and timestamp to check for missing intervals. Calculate daily and monthly totals, apply time-of-use rates using a lookup table for peak periods, and group by building or tenant to allocate costs. Use formulas to find peak demand and verify billed charges.

How do I find missing intervals in my meter data?

Sort by meter ID and timestamp, then calculate the time difference between consecutive rows. Any gap larger than your interval length—fifteen minutes, thirty minutes, one hour—is a missing reading. Flag those rows and decide whether to interpolate based on adjacent values or leave them blank for reporting.

How do I calculate peak demand charges from interval readings?

Group rows by meter ID and billing period, then find the maximum kW Demand value in each group. That maximum is your billing demand. Apply the tiered demand rate schedule for that month, which often increases per kW above certain thresholds, and sum the charges.

How do I apply time-of-use rates to hourly energy data?

Create a rate table with hour ranges and seasons that define on-peak, mid-peak, and off-peak periods. Join each row's timestamp to that table to assign a rate period, then multiply kWh Usage by the corresponding rate. Sum by period to verify the total matches your bill.

How do I aggregate multiple meters by building?

Maintain a lookup table that maps each Meter ID to a building or tenant name. Join that table to your energy data, then group by building and sum kWh Usage and Cost. If meter assignments change over time, include an effective date range in your lookup.

Try it with your own file

DataMimi reads the file you actually have — merged cells, headers below row one, totals pasted at the bottom — and shows which rows and columns every number came from.

Ask about your file

What DataMimi costs

Every plan does everything — slides, written reports, cleaned exports, dashboards. They differ in how much work they cover.

Free

40 credits a month

Starter

$24 /month

1,500 credits a month

Pro

$59 /month

5,000 credits a month

Start free — no card See every plan