LE Platform · Stage 2 wireframes
01 Data hub
02 Baselines
03 Tariffs
04 CSV drop
05 Column map
06 Validate
07 Meter bind
08 Operational
09 Pool data
10 Existing renewables
11 Climate & carbon
12 Sub-meters
13 Time-series view
14 Raw table
15 Data quality
← Stage 1
Polished dashboards →
Stage 2 — Data entry, upload, and raw-data viewing
Wireframes covering every input we identified for a fresh site analysis: annual baselines & tariffs (entered), half-hourly meter feeds (CSV upload + mapping + validation), operational data (entered), pool-specific data (entered), existing renewables, weather + carbon factors (looked-up), sub-meter management, and two raw-data viewers (chart + table) plus a quality dashboard.
Source-of-truth markers. Every numeric field carries a provenance pill — measured assumed missing to verify . This drives the auto-generated "based on assumed rather than measured variables" disclosure language LE include in every report.
Honest disclosure: the specific numbers shown are illustrative. Where a value would in reality come from a supplier portal CSV or the S24-1467 planning pack, I'm using a plausible number not a real extracted one. Real values get loaded by the import flows themselves.
measured assumed missing to verify
01
Data hub · per-site overview
— Stage 2 landing; one row per data source, completeness at a glance
Grantham Meres › Data Data readiness 58%
Inputs for fresh-site analysis
14 categories · last sync 12 min ago
Refresh portal feeds
+ Upload data
Category Cadence Coverage Source Status
Annual baselines gas + elec kWh, £, tCO₂ per fiscal year 2022, 2023 ✓ utility bills
complete Edit →
Tariffs & supply contracts per contract 2 active contracts supplier portal
complete Edit →
Half-hourly gas HH Jun 2023 → May 2024 ✓ AMR · t-mac
2 gaps View →
Half-hourly electricity HH Jun 2023 → May 2024 ✓ AMR · Stark
complete View →
Water consumption monthly 2023, partial 2024 bill scan
partial Edit →
Sub-meters HH 2 of 4 expected · pool plant + AHU BMS export
partial Manage →
Existing PV generation HH not yet installed (S24-1467 approved) —
future Edit →
Operational data opening hours · setpoints · closures per day-type pool hall only site interview
partial Edit →
Pool / wet-side data surface area, depth, covers, turnover static main pool only —
partial Edit →
Climate (HDD by year) annual 2018 → 2024 ✓ auto NG31 BizEE / CIBSE
auto View →
Carbon factors annual 2018 → 2024 ✓ DESNZ
auto View →
Plant nameplate data static 3 of 12 verified site visit (Stage 3)
awaiting visit Audit prep →
Lighting inventory static — site visit
awaiting visit Audit prep →
Fabric / U-values static year-band defaults applied archetype library
assumed Edit →
One screen, all sources
"Coverage" column gives the at-a-glance state — actual periods loaded, not a fake %.
Status pills tell the consultant what's safe to use for analysis vs. what's still placeholder.
Plant + lighting are explicitly tagged "awaiting visit" — they live in Stage 3, not here.
"Fabric assumed from archetype" is the worked-example of LE's "calculations based on assumed rather than measured variables" — surfaced in the UI so it's never silent.
02
Annual baselines · per fuel, per period
— the smallest dataset that lets LE export a site one-pager
Grantham Meres › Baselines + Add baseline period
Calendar 2023
Calendar 2022
Fiscal 23/24
★ marked baseline drives one-pager headlines
Total utilities (£)
£245,622
Carbon factors used
Elec 0.19338 · Gas 0.18254 · DESNZ 2022
Star this baseline
★ Active baseline
Smallest dataset that "works"
This is the bare minimum to produce LE's site one-pager headline (Current vs Estimated vs Saving per fuel).
Multiple periods supported; one is the active baseline for headline calcs.
Provenance pills make the assumed/measured split first-class — fed straight into the auto-generated disclosure paragraph in the report.
Carbon factors block here is a read-only summary; full editor on screen 11.
03
Tariffs & supply contracts
— per-fuel rate schedule incl. CCL, standing charge, capacity charges, contract dates
Grantham Meres › Tariffs + New contract
Natural gas · MPRN 974823100
Electricity · MPAN 1900 0000 ****
Water · SWE 22-9384
Gas · MPRN 974823100
Total Energies · contract 01 Apr 2023 → 31 Mar 2026 · LDZ EM
linked to meter tag
Component Value Unit Applies from Source
Commodity unit rate
5.89 p/kWh 01 Apr 2023 contract
Climate Change Levy (CCL)
0.775 p/kWh 01 Apr 2024 HMRC
Standing charge
248.00 p/day 01 Apr 2023 contract
Transportation (BSUoS-equiv.)
~0.6 p/kWh — estimated
Effective rate (weighted) 5.89 p/kWh 2023 avg computed
Annual Quantity (AQ)
2,799,021 kWh — Daily Read tier
CV source
Xoserve LDZ-EM daily (auto)
Contract review window
90 days before 31 Mar 2026
Historical rate trend (last 5 yrs)
2019
2020
2021
2022
2023
2024
2.04 → 5.89 p/kWh · 188% increase 2019–2024 · used in £-saving compounding projections
Tariffs ≠ a single number
Commodity + CCL + standing charge + transportation; all combine into the "effective" rate that drives £ savings.
Multi-fuel via the chip selector at top — one row per supply point.
Contract review window is the calendar reminder that triggers a re-tender campaign.
Historical trend feeds the "5% compounded increase" assumption LE include in long-term saving projections.
04
CSV upload · drop
— ingest half-hourly or daily meter data from supplier portal exports
Grantham Meres › Data › Upload Step 1 of 3 · drop
Drop CSV / XLSX here · or browse filesCommon formats auto-detected · max 50 MB per file
Any supplier (autodetect)
t-mac AMR
Stark
TMA Data
British Gas Lite
Total Energies portal
EDF MyMeter
Generic HH (timestamp, kWh)
Recent uploads
File Cadence Coverage Rows Status Bound to
tmac_gas_MPRN974823100_2023.csv HH
1 Jan 2023 → 31 Dec 2023 17,520
imported Gas MPRN (main)
stark_elec_MPAN_2023.csv HH
1 Jan 2023 → 31 Dec 2023 17,520
imported Elec MPAN (main)
bms_export_poolplant_2023.xlsx HH
1 Jun 2023 → 31 Dec 2023 10,272
imported · gap Pool plant sub-meter
water_bills_2023.pdf monthly
Apr 2023 → Nov 2023 8
parsed · 4 mo missing Water meter
Auto-detect, but show your working
Common UK AMR vendors are pre-templated (t-mac, Stark, TMA, supplier portals). Generic HH is the fallback for anything else.
XLSX is allowed because half the BMS exports we'll see come out of Excel.
PDF water bills route through a separate parser (OCR) — flagged here for transparency, even though the user just drops them.
Recent uploads table is the audit trail. Re-import is non-destructive; previous data is archived.
05
CSV column mapping & unit conversion
— pick which column is timestamp, which is reading; pick unit + cadence + timezone
tmac_gas_MPRN974823100_2024.csv Step 2 of 3 · mapping
49 rows detected · first 20 shown · likely gas · HH · m³
Auto-detection confidence 92%
Back
Continue to validation →
Timestamp column
Col A · "Time of read"
Reading column
Col C · "Consumption"
Unit in file
m³ (cubic metres)
Cadence
Half-hourly (48/day)
Timezone
Europe/London (handles DST)
Convert m³ → kWh using
Xoserve LDZ-EM daily CV (recommended) Assumed 39.5 MJ/m³ Manual CV per period
Volume correction factor
Bind to meter tag
Gas MPRN (main) · 974823100
Preview (first 20 rows · conversion applied)
Time of read (local) Consumption (m³) CV (MJ/m³) → kWh Notes
2024-01-01 00:00 14.221 39.34 158.93 2024-01-01 00:30 14.107 39.34 157.66 2024-01-01 01:00 13.992 39.34 156.38 2024-01-01 01:30 14.116 39.34 157.76 2024-01-01 02:00 14.045 39.34 156.97 2024-01-01 02:30 13.890 39.34 155.24 2024-01-01 03:00 13.812 39.34 154.37 2024-01-01 03:30 13.945 39.34 155.86 2024-01-01 04:00 14.612 39.34 163.31 2024-01-01 04:30 22.481 39.34 251.27 pre-open boiler ramp 2024-01-01 05:00 33.115 39.34 370.13 pre-open 2024-01-01 05:30 31.882 39.34 356.35 pre-open 2024-01-01 06:00 24.117 39.34 269.55 … … … …
m³ vs kWh is the trap
Many AMR exports give m³ , not kWh. Conversion uses Xoserve daily CV per LDZ × 1.02264 volume-correction.
Timezone defaults to Europe/London — the platform must handle the 23/25-hour DST days correctly or every Oct/Mar will look broken.
"Bind to meter tag" wires the imported series straight to the Stage 1 meter pin so the rest of the platform knows where this gas was consumed.
Confidence % is shown — manual override always available.
06
CSV validation & preview
— show what will be imported; flag gaps, duplicates, anomalies, DST
tmac_gas_MPRN974823100_2024.csv Step 3 of 3 · validate
17,470
rows ready to import
~363 days
coverage · 1 Jan → 30 Dec 2024
3 issues
requires consultant decision
Back
Import 17,470 rows
Issues to resolve
Gap · 2 days missing — 12 Aug → 14 Aug 2024 (96 half-hours)
Leave gap
Interpolate
Mark site closed
Negative readings · 4 found — likely meter rollover or correction. Rows: 2024-03-31 01:30, 02:00, 02:30, 03:00
Inspect
Set to 0
Drop rows
DST spring-forward — 31 Mar 2024 has 46 half-hours, not 48. Auto-handled.
acknowledged
Coverage map (each cell = 1 day)
Jan Mar May Jul Sep Nov
Never silent
Every issue surfaces with the consultant's options. "Leave gap" is always allowed; "interpolate" is opt-in (some analyses can't tolerate it).
DST is auto-handled but acknowledged so it's visible in the audit trail.
The coverage map is the at-a-glance "do I trust this dataset?" answer. Green = complete, amber = partial, red would be missing entirely.
All decisions made here are recorded on the import — re-import doesn't ask the same questions again.
07
Meter binding
— wire imported time-series to the Stage 1 meter pins; defines spatial allocation
Grantham Meres › Meter bindings 4 of 6 meters bound
Meter tag (from Stage 1) Identifier Bound data series Measures Last reading
Gas MPRN (main) in Plant room 974823100
tmac_gas_*.csv (HH)
whole site
30 Dec 2024 23:30
Unbind
Elec MPAN (main) in Plant room 1900 0000 ****
stark_elec_*.csv (HH)
whole site
30 Dec 2024 23:30
Unbind
Pool plant sub-meter elec · Plant room SUB-PP-01
bms_export_poolplant_*.xlsx
Pool circ pumps, AHU, Filtration
30 Dec 2024 23:30
Unbind
Water meter incoming · external SWE 22-9384
water_bills_2023.pdf (monthly)
whole site
Nov 2023
Unbind
Lighting sub-meter (expected) —
no data bound Lighting circuits
—
+ Bind a CSV
PV generation meter (future) —
post-install PV Roof 1, 2, 3
—
—
Spatial allocation preview
Gas · whole site 2,799,021 kWh · allocated by floor-area split
Elec · whole site 245,057 kWh · less pool plant sub-meter
Pool plant elec 87,300 kWh · directly attributed to Pool hall
Lighting elec no sub-meter — estimated from fitting inventory
One join key: tag.id
Each Stage 1 meter pin is a binding slot. Multiple CSVs can stack onto the same meter (e.g. 2023 + 2024 files).
"Measures" links back to the zone or asset list — drives spatial allocation in dashboards.
"Expected but not bound" rows are a checklist — every wet site expects pool plant + lighting sub-meters in an ideal world.
Sub-metered loads are subtracted from the main meter to avoid double-counting; the platform shows this as the spatial allocation preview.
08
Operational data · hours, setpoints, closures
— drives the operational schedule in every load/demand calc
Grantham Meres › Operational 4 of 7 zones complete
Whole site
Pool hall
Sports hall
Gym
Studio ×2
Changing
Reception/café
Opening hours · whole site
Setback hours (heating off / low)
From 23:00 to 04:30 daily · BEMS-controlled
Holiday closures
Bank holidays: closed
Christmas: 24 Dec PM → 27 Dec
Boilers turndown 60% during closures
+ Add closure period
Setpoints per zone (°C)
Zone Occupied air target Setback air Water target RH target Source
Pool hall 30 °C 28 °C 28.5 °C 55–65% BEMS
Learner pool
30 °C 28 °C 30.5 °C 55–65% BEMS
Sports hall
16 °C 10 °C — — verbal
Gym
19 °C 14 °C — — verbal
Studio ×2
20 °C 14 °C — — assumed
Changing village
22 °C 16 °C — — verbal
Reception / café
21 °C 15 °C — — verbal
Operational ≠ setpoints alone
Hours + setbacks + holiday closures + setpoints together define the operational schedule.
Per-day pattern matters — Friday early-close, weekend hours are common.
Source pills make obvious which setpoints are BEMS-confirmed vs verbal vs assumed.
Holiday closures with boiler turndown % go straight into the saving model (it's a real PSDS lever).
09
Pool & wet-side data
— pool by pool: dimensions, water, covers, filtration
Grantham Meres › Pool data 2 of 3 water bodies entered
25m Main pool
Learner pool
Spa / hot tub
tagged on Pool hall zone (Stage 1)
Where the big numbers come from
Pool surface area + RH + air-temp delta → evaporation rate → most of the gas load on a wet site.
Cover Y/N + deployment hours is the single highest-leverage number on this page — LE quote 430 MWh/yr saving from pool covers at a 50m site.
Filtration type unlocks the microfiltration ECM (their hero product) — captured here so applicability flags downstream.
"Computed" fields update live as inputs change; the formula is shown in a tooltip (not drawn).
10
Existing renewables · PV & solar thermal
— what's already on site producing energy; affects net-position dashboards
Grantham Meres › Renewables 3 PV arrays · 0 solar thermal · 0 battery
3 PV arrays — S24-1467 approved Oct 2024 · status: proposed (not yet commissioned)
data values pulled from S24-1467/StringDesignReport.pdf
+ Add renewable
Array kWp Panels Orientation Inverter Est. annual yield Status
Roof 1 · over Pool hall— — — — — extract from PDF
Roof 2 · over Sports hall— — — — — extract from PDF
Roof 3 · over Gym/Studios— — — — — extract from PDF
These are tagged in Stage 1 as generation pins. Values populate from S24-1467/StringDesignReport.pdf + Roof1/2/3_PanelLayout.pdf. Once commissioned, half-hourly generation can be bound here (screen 04 / 07).
PV generation data (post-commission)
Drop inverter export (.csv) here · or browse · supports SolarEdge, SMA Sunny Portal, Fronius, Enphase
Solar thermal
No solar thermal recorded · + Add array
Battery storage
No battery recorded · + Add system
EV charging
No EV chargers recorded · + Add
Honest about what we don't have
Rather than fake kWp / panel-count values, Stage 2 explicitly shows "extract from PDF" placeholders that link to S24-1467/StringDesignReport.pdf.
The platform should be able to attempt PDF text extraction on planning packs — fall back to manual entry where parsing fails.
Generation CSV importer drops in once panels are commissioned and inverters reporting.
Other renewables (solar thermal, battery, EV) modelled but empty by default — Grantham doesn't have any.
11
Climate & carbon factors
— HDD by year, postcode-driven; DESNZ carbon factors auto-loaded
Grantham Meres · NG31 · auto-lookups 2018 → 2024
Heating Degree Days (base 15.5 °C)
Source: BizEE · region East Midlands · auto-refreshed annually
Year HDD Δ vs 20-yr mean
2018 2,287 +4% 2019 2,201 +0% 2020 2,142 −3% 2021 2,213 +1% 2022 2,089 −5% 2023 2,194 −0.3% 2024 2,118 −4%
Used for
Weather-normalising before/after consumption · drives M&V comparability
DESNZ carbon factors
Source: gov.uk GHG conversion factors · annual
Year Elec kgCO₂/kWh Gas kgCO₂/kWh
2020 0.23314 0.18316 2021 0.21233 0.18293 2022 0.19338 0.18254 2023 0.20705 0.18290 2024 0.20705 0.18290
Override (per period)
+ Custom factor for a baseline year
Future grid trajectory (decarbonisation)
Linear from 0.207 (2024) → 0.030 (2050) · DESNZ central
Switch curve
Drives multi-year payback projections — ASHP economics improve materially with grid decarb.
Lookups + defaults + overrides
HDD + carbon factors are auto-fetched — the user shouldn't have to type these.
SCOP defaults are LE's published assumptions; visible so a consultant can argue with them.
Future grid trajectory is essential for ASHP business cases — the gap between current and 2050 factors is what makes a 60-year payback look acceptable to a council finance committee.
Manual override at every level so site-specific anomalies don't get hidden.
12
Sub-meter management
— inventory of existing + expected sub-meters; per-circuit data binding
Grantham Meres › Sub-meters 2 active · 2 expected · 4 recommended
Tag Fuel Circuit / use Location Data binding Status
SUB-PP-01 elec Pool plant — circ pumps + AHU + dosing Plant room
bms_export_poolplant.xlsx active
SUB-DHW-01 gas DHW calorifier Plant room
— no data
(expected) elec Lighting — all circuits MDB
— not installed
(expected) elec Gym + studios Sub-DB
— not installed
(expected) gas Pool hall AHU Plant room
— not installed
(expected) water Pool top-up + backwash Pool plant
— not installed
+ Add sub-meter
Mark all expected as recommendation
"Expected but not installed" appears as the AMR sub-metering ECM in Stage 4
Inferred attribution (without sub-metering)
Lighting · estimated 62,400 kWh · from inventory + hours assumption · assumed
Gym + studios 38,100 kWh · floor-area weighted of residual · assumed
Pool hall AHU gas ~840,000 kWh · 30% of pool zone gas demand · assumed
Sub-metering is both data & ECM
Every "expected but not installed" sub-meter is simultaneously a data gap and an ECM opportunity (AMR sub-metering is line item #5 on LE's canonical checklist).
Where sub-meter data is absent, inferred attribution kicks in — clearly flagged as assumed.
"Mark all expected as recommendation" promotes the gap straight into the Stage-4 ECM project list.
13
Raw data viewer · time-series chart
— pick a series, pick a period, see the data
Grantham Meres › Raw data Chart view
Source
Gas MPRN (main) Elec MPAN (main) Pool plant sub-meter Water meter Outdoor temp (postcode)
Period
1 Jan 2024 → 30 Dec 2024 Last 7 days Last 30 days Custom…
Resolution
Daily (sum) Hourly Half-hourly (raw) Weekly Monthly
Compare
vs prior year vs HDD-normalised vs CIBSE TM46 off
Switch to table →
12k
8k
4k
0
gas kWh / day
prior year
Jan
Mar
May
Jul
Sep
Nov
2,734,180 kWh
total · period
7,488 kWh/day
mean daily
462 kWh
peak HH · 06 Feb 05:30
−2.3%
vs prior year (HDD-adj.)
98.5%
data coverage
Brush a period to inspect / annotate
Selection: 12 May → 4 Jun 2024 · 568 HH readings · 168,200 kWh Annotate Export selection
One source, multiple lenses
Source × period × resolution × compare-mode = every standard analysis a consultant wants.
HDD-normalised comparison is the only honest before/after view — raw year-on-year is misleading.
Brush-to-select drives "tell me about this two-week period" inspection — feeds annotation + export of the slice.
5 headline stats in the strip below: total, mean daily, peak HH, vs-prior, coverage. Everything else lives in the table view.
14
Raw data viewer · table mode
— spreadsheet-style grid for verification, anomaly hunting, export
Gas MPRN (main) · 1 Feb 2024 · half-hourly Table view · 48 rows
Source
Gas MPRN (main)
Day
Show
kWh + m³ + CV + outdoor temp kWh only
← Switch to chart
Export CSV
Time (local) m³ CV (MJ/m³) kWh Outdoor °C Flags
2024-02-01 00:00 12.802 39.28 142.99 3.8 2024-02-01 00:30 12.701 39.28 141.87 3.6 2024-02-01 01:00 12.640 39.28 141.18 3.4 2024-02-01 01:30 12.611 39.28 140.86 3.2 2024-02-01 02:00 12.582 39.28 140.54 3.0 2024-02-01 02:30 12.553 39.28 140.21 2.8 2024-02-01 03:00 12.524 39.28 139.89 2.6 2024-02-01 03:30 12.495 39.28 139.57 2.5 2024-02-01 04:00 12.467 39.28 139.25 2.4 2024-02-01 04:30 22.118 39.28 247.04 2.4 pre-open ramp 2024-02-01 05:00 38.470 39.28 429.62 2.5 pre-open peak 2024-02-01 05:30 36.214 39.28 404.42 2.7 pre-open 2024-02-01 06:00 28.821 39.28 321.81 3.0 2024-02-01 06:30 22.430 39.28 250.49 3.3 opening 2024-02-01 07:00 21.180 39.28 236.53 3.6 2024-02-01 07:30 19.842 39.28 221.59 4.0 2024-02-01 08:00 18.602 39.28 207.74 4.5 2024-02-01 08:30 17.910 39.28 200.01 5.1 2024-02-01 09:00 17.220 39.28 192.31 5.6 2024-02-01 09:30 -2.140 39.28 -23.91 6.0 negative · suspect 2024-02-01 10:00 16.530 39.28 184.61 6.4 … … … … … 26 more rows 2024-02-01 19:00 25.420 39.28 283.92 5.2 evening peak 2024-02-01 19:30 27.880 39.28 311.40 4.9 evening peak 2024-02-01 20:00 22.140 39.28 247.27 4.7 2024-02-01 23:30 12.880 39.28 143.86 3.5 setback
Σ kWh · day = 7,134.6 kWh
· Σ m³ = 638.3 m³
· peak HH = 05:00 · 429.6 kWh
· min HH = 09:30 · −23.9 kWh (flagged)
Fix flagged rows
Spreadsheet-style for the suspicious
Consultants do not trust black boxes. The table view gives them the raw rows + the conversion working + flags inline.
Outdoor temp column joins the postcode weather feed — handy when investigating odd consumption patterns.
Per-row "Flags" column captures decisions and labels from the import (pre-open ramp, evening peak, setback, negative-suspect).
Bad rows (negative, missing) highlighted; "Fix flagged rows" opens screen 15 (data quality).
15
Data quality dashboard
— gaps, anomalies, suspect values across all bound sources
Grantham Meres › Data quality across all sources
96.4%
overall data coverage
14 gaps
across 4 sources
8 anomalies
requires review
3,124
assumptions logged
Issues by source
Source Coverage Gaps Anomalies Last reviewed
Gas MPRN (main) 98.5% 1 (2 days) 4 negative HH
never Review →
Elec MPAN (main) 100% — 2 suspected meter swaps
14 May Review →
Pool plant sub-meter 57% 6 (210 days · pre-Jun 2023) —
never Review →
Water meter 67% 4 months 1 outlier reading
never Review →
Outdoor temp (NG31) 100% — —
auto —
Assumptions log (excerpt)
Pool depth · 1.8 m — assumed mean from year-band + competition layout · would change pool volume + heat loss model · assumed
Wall U-value · 0.6 W/m²K — 1980s archetype default · would change fabric heat-loss in ASHP sizing · archetype
ASHP SCOP for pool · 2.8 — LE default · drives ASHP business case electricity input · platform default
Lighting hours · 4,200/yr — opening hours + 20% common-area overrun · drives lighting saving estimate · assumed
Pool cover deployment · 56 hrs/wk — verbal report from duty manager · drives evaporation + gas saving · verbal
CV for m³ → kWh · Xoserve LDZ-EM daily — auto-fetched per period · measured
Show all 3,124 assumptions…
Auto-generated disclosure paragraph (for reports)
"All energy saving calculations in this proposal are based on engineering calculations with assumed rather than measured variables. Key assumed values include: pool depth 1.8 m (year-band default), wall U-value 0.6 W/m²K (1980s archetype), ASHP SCOP 2.8 for pool heat (Leisure Energy default), pool cover deployment 56 hours/week (verbal report). It is suggested that Leisure Energy review these engineering calculations and specific variables with the operator prior to installation."
Copy to report Regenerate
The honesty engine
Every assumed value made anywhere in the platform logs here — the consultant can scroll and see all 3,124.
The disclosure paragraph at the bottom is auto-generated from the assumptions log — same wording LE use today, but with the specific values listed.
"Review" links per source open the validate-and-fix flow from screen 06 for that specific dataset.
This is the platform's defensibility layer — anyone challenging an analysis can be shown exactly what was measured vs assumed and where each number came from.
Stage 2 wireframes · 15 screens · low-fidelity · for review & markup