University of Idaho
Integrated Design Lab

โšก Meter Data Analysis

Turn Idaho Power hourly interval data into a building load profile ยท IDL Building Performance Tools

Load interval data

Idaho Power delivers hourly demand as a grid where each row is one day and each column is one hour. Drop that file below, or paste the table. This tool reshapes it into a continuous hourly profile and charts the building's load โ€” no slider, no waiting.

๐Ÿ“ˆ
Drop an Idaho Power file here
.xlsx, .csv, or .txt โ€” or click to browse
or paste the table
How dates are assigned: Idaho Power's day labels (e.g. 01/01-T) carry no year, so days are sequenced from the start date โ€” the first data row is the start date, each following row is the next day. If a "Date Range" line is present it's read automatically; otherwise set the start date above.

Annual load heatmap

Every hour of the year at a glance. Each column is a day, each row is an hour; color is demand in kW. Patterns of occupancy, weekends, seasons, and outages read instantly.

Lower
Higher demand (kW)

Average daily load profile

The building's typical day. The band shows the full hour-by-hour range; lines show averages.

Load duration curve

Every hour sorted from highest to lowest demand. A flat curve means steady use; a sharp left spike means brief, expensive peaks. The shaded floor is the base load that never goes away.

Monthly energy

Total energy use by month (kWh).

Daily energy

Total energy each day across the record (kWh).

Hourly profile viewer

Scrub through the year to inspect the raw hourly trace. This replaces the old spreadsheet slider โ€” drag freely, it won't stick.

Export reshaped data

Download the cleaned series for use in Excel, EnergyPlus calibration, or further analysis.