Methodology verified 22 June 2026DfE SEMSPSDS Phase 4Ofgem Q3 2026 cap (gas 7.33p / elec 26.11p)
worksheet deep link

Per-school net zero ceiling estimator

Author: Oliver Wakefield-Smith, Founder Digital Signet. Reviewed against DfE Sustainability Strategy (Mar 2025) and Education Estates Strategy (Feb 2026). Verified 22 June 2026.

The worksheet below pre-loads a typical 1945-1976 secondary (7,500 m2, gas heating, South East region). The output panel reads as a governor paper: per-school ceiling, grant offset, net cost, Ofgem Q3 2026 payback, tCO2e abated per year.

GIA Ceiling Worksheet

Per-school net zero capital estimate

1
schools
2
3
m2
4
5
6
7
8
Per-measure capital ladder
ASHP
GBP 1,051,600
Fabric
GBP 1,980,000
Solar PV
GBP 96,800
LED
GBP 206,250
BMS controls
GBP 77,000
Per-school ceilingGBP 3,411,650

ASHP sized to 478 kW from heat-loss coefficient.

kWh and tCO2e flow (annual)
Energy in
675,000 kWh/yr
Residual
10,313 kWh/yr
Abated
124.2 tCO2e/yr
Per-school ceiling
GBP 3,411,650
Portfolio total
GBP 3,411,650
Grant offset
GBP 3,411,650
Net of grant
GBP 0
Payback at Ofgem Q3 2026
n/a
tCO2e abated / yr
124.2
Net per-school ceiling (after grants)
GBP 0
ex-VAT, 2026 prices, governor-paper figure

Worked example: 1976-era secondary, 7,500 m2, South East

Heat-loss coefficient 75 W/m2 multiplied by 7,500 m2 yields a 562.5 kW design heat-loss; multiplied by an 0.85 utilisation factor gives an installed ASHP capacity near 480 kW. At £2,000/kW and a 1.10 regional multiplier that is £1.05m of ASHP CAPEX. Fabric at £240/m2 multiplied by 7,500 m2 and 1.10 adds £1.98m. Solar PV at 80 kWp adds £96,800. LED at £25/m2 adds £206k. BMS adds £77k. Total per-school ceiling lands near £3.4m before any grant offset; with PSDS Phase 4 plus Salix CIF the net falls to the Salix per-project payback gateway.

How it should appear in a governor paper

Use the Print as board paper button to render an A4 portrait version with the Source-of-record banner, the Ceiling Headline, the leaf-vein ladder, the kWh / tCO2e Sankey strip and the BoardPaperFooter colophon. Pasted straight into a trustee pack the page reads as a Salix Annex B-style appendix.

Related
Sources cited on this page
  1. [S5]DfE Area Guidelines (BB103/BB104)
  2. [S6]DfE Condition Data Collection CDC1/CDC2
  3. [S2]Salix PSDS
Prepared by schoolnetzero.co.uk, 22 June 2026.Page: per-school-ceiling-estimatorAuthor: Oliver Wakefield-Smith, Founder Digital Signet.