Technical guide · Sizing

How half-hourly demand data changes commercial solar sizing

A working technical guide to sizing commercial solar against half-hourly demand profiles rather than headline annual consumption. Why annual consumption misleads, how to obtain half-hourly data, what the analysis looks like, and how the optimal size decision lands.

Why annual consumption is misleading

A commercial site consuming 800 MWh per year could be: a 24/7 logistics operation with flat overnight load (suggests 1.2–1.5 MWp solar with significant self-consumption), a daytime-heavy manufacturer (suggests 700 kWp at very high self-consumption), a school with summer shutdown (suggests 350 kWp because excess summer generation has nowhere to go), or a hotel with seasonal variation (suggests battery-storage-paired sizing). Same annual consumption, four different optimal answers.

The unhelpful default is sizing solar to "60% of annual consumption" or some similar rule-of-thumb. This works on average but is wrong on most specific sites. The right approach: model self-consumption percentage at a range of system sizes against half-hourly demand, and pick the size that maximises NPV.


Step 1: Obtain the half-hourly file

For sites on a half-hourly settled tariff (most commercial sites above ~100 kW peak demand), the supplier holds the data and is required to provide it on request. Standard request:

"To [supplier customer service]: please provide our half-hourly consumption data (HH data, sometimes called AMR data) for the past 12 months for our supply at MPAN [your MPAN]. CSV format with date, half-hour-period, and kWh consumption columns. This is for energy efficiency and renewable feasibility analysis."

We reply by email. No charge — they're required to provide this on request.

If your site is on a monthly-settled tariff (rare for above ~100 kW but possible), you have two workarounds: (a) install a temporary smart meter or current-transformer logger for 4–6 weeks across a representative season; (b) use industry-standard load profile estimates calibrated to monthly consumption (workable for offices and retail but inadequate for industrial or seasonal businesses).


Step 2: Profile the demand

A useful first pass on the data: load it into a spreadsheet or analysis tool and compute four summary statistics:

  • Mean demand (kW) — annual consumption ÷ 8,760 hours
  • Maximum demand (kW) — highest single half-hour reading
  • Minimum demand (kW) — lowest single half-hour reading (typically overnight or weekend)
  • Standard deviation of demand — measure of demand variability

Three useful ratios from these:

  • Min/mean ratio — if above 0.5, demand is fairly continuous; below 0.2, demand is highly variable
  • Max/mean ratio — if below 2, demand is fairly flat; above 3, demand has substantial peaks
  • Daytime/24h ratio — fraction of consumption during 8am–6pm. High (above 0.6) = daytime-heavy, suits solar without storage. Low (below 0.5) = continuous or evening-heavy, suits battery-paired sizing.

Step 3: Model self-consumption at multiple solar sizes

For each candidate solar size:

  1. Generate a synthetic solar profile

    For each half-hour interval across the year, compute solar generation as: kWp × yield(month, hour, latitude). Standard libraries like NASA POWER, PVGIS, or MCS Solar Yield provide hourly irradiance data; convert to half-hourly via interpolation.

  2. Compute self-consumption per interval

    For each half-hour: self-consumed kWh = min(solar generation, demand). Export = solar generation − self-consumed.

  3. Sum across the year

    Total self-consumed kWh / total solar generation = self-consumption percentage. Total export kWh × export tariff = export revenue.

  4. Compute economic value at each size

    Avoided cost = self-consumed kWh × tariff. Total annual benefit = avoided cost + export revenue. Use this in the standard 25-year cash-flow model.

  5. Plot value vs size

    Self-consumption percentage will fall as size increases (more export). Annual benefit will rise but at diminishing returns. The optimal size is where marginal £/kWp of avoided cost equals marginal £/kWp of capex.


Step 4: Land the size decision

The optimum typically sits where the marginal kWp delivers ~70% self-consumption — at higher self-consumption you're leaving capacity on the table; at lower, you're over-discounting capex against export value.

Two patterns to look for: (a) sites where overnight load is above 30% of summer-midday peak — these are typically under-sized by rule-of-thumb; (b) sites with strong summer/winter seasonality — these are typically over-sized in summer-light models. Half-hourly data is the only reliable way to identify which case applies.


Worked example: Yorkshire food production site

A site we analysed in 2026 demonstrates the impact:

SizeSelf-consumptionAvoided costSEG export revProject IRR
500 kWp94%£94k£2k15.2%
700 kWp (rule-of-thumb)86%£120k£6k12.8%
900 kWp78%£140k£13k14.4%
1,100 kWp (optimum)71%£156k£21k16.9%
1,300 kWp62%£161k£33k15.4%

The optimum landed at 1,100 kWp — 36% larger than the installer's rule-of-thumb 700 kWp proposal — with a project IRR of 16.9% versus the installer-proposed 12.8%. The continuous overnight refrigeration load (70–110 kW) created enough demand that even at 1,100 kWp, summer-midday generation didn't overwhelm the site's ability to consume.


Half-hourly sizing FAQs

How do I get half-hourly demand data from my supplier?
For sites on a half-hourly settled tariff (most commercial sites above ~100 kW peak demand), the supplier holds 12+ months of half-hourly consumption data and is required to provide it on request. Use the term "HH data" or "AMR data" in your request. The supplier issues a CSV file with consumption at 30-minute intervals — typically 17,520 rows per year. No charge.
What if I'm on a non-half-hourly tariff?
Smaller commercial sites (sub-100 kW peak demand) typically have monthly-billed rather than half-hourly-settled tariffs. Two workarounds: (a) install a temporary smart meter or current-transformer logger for 4–6 weeks across a representative period; (b) use industry-standard load profile estimates calibrated to monthly consumption — workable for offices and retail but inadequate for industrial or seasonal businesses.
How does half-hourly data change the optimal solar size?
Materially. In our reviews, the optimal system size has differed from the "60% of annual consumption" rule-of-thumb by an average of ±18% — sometimes considerably more on industrial sites with continuous overnight demand. Getting sizing wrong typically costs 3–6 percentage points of project IRR, which is large enough to matter materially.
What's a typical commercial demand profile shape?
Typical profiles fall into three patterns: (a) "office" — 9-5 weekday demand, evenings/weekends low; (b) "industrial" — flat 7-7 weekday demand with possibly limited overnight load; (c) "continuous" — 24/7 demand from refrigeration, cold storage, or process loads. Each demands different optimal sizing. The half-hourly data tells you which pattern applies and at what magnitude.
Can a calculator do this analysis or do I need full advisory?
A calculator gives you the framework with manually-entered self-consumption assumptions. Real half-hourly modelling needs the actual demand file. A self-consumption model processes the half-hourly file to compute self-consumption at each system size.

Finance route checker

Which finance route fits your solar project?

Answer six questions and see an indicative shortlist straight away: cash purchase, hire purchase, loan, lease or PPA, ranked for your tax position, premises and budget. If you want a reply, send your answers to us by email at the end.

Email me this shortlist

Send your answers to us and we reply by email. We do not pass your details to installers or lenders without your permission.

Your answers and contact details are used to reply to this enquiry. See our privacy notice.

Need this analysis on your specific site?

Process your half-hourly file to compute optimal size against your actual demand profile. That analysis is what determines whether your project IRR runs 12% or 17%.

Request a finance review