Lekker Sun

Guides

Using smart-meter data to build a load profile

Published 8 October 2026. About 6 minutes to read.

A monthly bill tells you how much electricity a building uses. Interval data from a smart meter tells you when. And once there's a battery involved, when is what decides the design.

What an export looks like

Most utilities and meter portals will export a CSV with one row per interval, holding a date and time and a reading. Intervals are usually 15, 30 or 60 minutes. A full year of 30-minute data comes to 17,520 rows.

Before you use the file, check three things.

1. Is it energy or power?

Some exports give energy in kWh for each interval. Others give the average power in kW over it. They look alike, but they're out by a factor that depends on the interval length.

kWh per interval = average kW × interval in minutes ÷ 60

Take a reading of 2.0 in a 30-minute file. If the file's in energy, that's 2.0 kWh. If it's in kW, it's only 1.0 kWh. Get this wrong and you've doubled or halved the household's consumption. The column header, or the portal's help page, usually says which it is. Still not sure? Add up a month and check it against the bill.

2. Which time does each row mean?

A row stamped 13:30 might cover 13:00 to 13:30, or 13:30 to 14:00. Some meters record local time and others UTC. In countries with daylight saving there may be an hour missing in spring and one doubled in autumn. A half-hour shift barely matters for a load profile. A whole time-zone offset does. It drags the evening peak into the afternoon and makes the battery look far more useful than it really is.

3. Is there already solar on the building?

An import meter only sees what comes in from the grid. If there are already panels on the building, the daytime readings show what was left after that system did its work, so the household really uses more than that during the day. For an upgrade or an added battery you'll need the existing system's production as well (usually from its inverter's monitoring portal), added back in.

Gaps and odd days

Exports often have gaps where the meter lost its connection. A year might also include holidays, or a month when nobody was home. Averaging a typical day for each month over all the days that do have data smooths most of that out. A month with no data at all can borrow the average shape from the others.

From profile to design

One typical day per month, at half-hour resolution, catches what matters for design. You get the evening peak and the overnight base load, and you see how both change from summer to winter. That's enough to simulate how solar covers daytime use and how a battery moves surplus into the evening.

Importing data into Lekker Sun

On the Finance page, choose whether the values are kWh per interval or average kW, then upload the CSV. Lekker Sun reads timestamped rows at 15, 30 or 60-minute intervals, in year-month-day or day/month/year format. It builds a typical day for each month and sets the monthly consumption from that. There are two templates to download on the same page. One's for meter intervals. The other is for a typical day per month, if hourly averages are all you've got.

No smart meter? The home load calculator builds a typical-day profile from the appliances in each room, and can send it straight to the Finance page.

Try it on a real roof

The designer's free and runs in your browser. You don't need an account.

Open the designer

This guide is general information to help you plan and compare options. It is not engineering, electrical or financial advice. Always follow the equipment manufacturer's instructions and your local wiring rules, and have a qualified installer check the design.