Turns a national forecourt price file into averages, cheapest and dearest sites, and a price map for unleaded and diesel.
Reporting Dashboards
Motor fuel retail
Dashboard feature
Productised
Local/private
2026
The problem
The raw price file is too large to read, so supermarket gaps, motorway premiums and out-of-date prices stay hidden. Rows with impossible pence figures also pull the averages off. And a table of every site does not show where the cheap fuel is.
What it does
The file is read in pieces, and pump prices outside a sensible range are dropped. The page counts sites, closures, motorway, supermarket and all-night sites, then averages each grade. It splits unleaded by brand group, country, supermarket against other, and motorway against other. An interactive map colours each site from cheap to dear.
Outcomes
The supermarket saving and the motorway premium show as figures on the page.
Bad rows no longer move the average.
The age of the prices is shown, so stale sites are visible.
A marker on the map shows a site and its pence per litre.
Simplified mockup
Interactive preview with sample data. Nothing is sent to a server.
Forecourt report
Submitted yesterday
national_forecourts.csv · 8,420 rows · band 90p to 250p · 37 bad rows already dropped
Open sites
7,964
419 closed
Motorway
286
Premium sites
Supermarket
1,482
Two groups
All-night
1,104
Fuel 24 hours
Supermarket saving vs other
6.5p
132.1p vs 138.6p · £3.25 on 50 litres
Motorway premium vs other
+23.7p
158.9p vs 135.2p · £11.85 on 50 litres
Grade averages pence per litre
Grade
Average
Cheapest
Dearest
Unleaded
136.4
129.9
168.2
Super unleaded
151.2
142.0
179.9
Diesel
144.8
136.1
176.4
Freshness Yesterday
Under 24 hours71%
1 to 3 days18%
Older than 3 days11%
Rebuild
File already loaded
Rows kept out of the average
0 dropped
Row
Grade
Pence
Reason
4412
Unleaded
940
Above 250p
4418
Diesel
12
Below 90p
5102
Unleaded
0
Empty price
34 further rows omitted. Averages use the 8,383 prices inside the band.
Unleaded splits
Pence per litre
Pence above 125p unleaded
Brand groups
Group
Kind
Sites
Unleaded
Diesel
Harbour Retail
Supermarket
640
131.4
139.8
Field & Fare
Supermarket
410
132.8
141.2
Northway
Major
1,120
137.9
146.2
Kiln
Major
980
138.4
147.0
Lantern
Major
540
139.1
147.6
Independents
Other
3,860
140.6
148.9
Price map
CheapTypicalDear
Unleaded clusters hover a marker
Schematic clusters coloured cheap to dear. Not a street map.
Marker Submitted yesterday
Site
Harbour Retail
Sittingbourne
Unleaded
129.9p
Diesel
138.4p
Supermarket48 sites in this cluster
Cheapest and dearest unleaded
Site
Pence
Harbour Retail, Sittingbourne
129.9
Harbour Retail, Kendal
130.4
Northway, Derby
139.6
Ridgeway Services, Maidstone
161.9
How it works
Read the forecourt file in pieces and drop prices outside the sensible range.
Count sites, closures, motorway, supermarket and all-night sites.
Average each grade.
Split unleaded by supermarket against other, and motorway against other.
Group prices by age, using the time each price was submitted.
Colour the map clusters from cheap to dear.
Pipeline
flowchart LR
File["Price file"] --> Clean["Drop bad rows"]
Clean --> Avg["Grade averages"]
Clean --> Split["Supermarket and motorway"]
Clean --> Fresh["Freshness"]
Avg --> Map["Price map"]
Split --> Tiles["KPI tiles"]