Parent operator comparison - operated vs lost mileage
Executive insights
Period trend
Worst non-deductible lost mileage operators
Fleet composition
Detailed operator league table
Selected operator scorecard
EWT / reliability executive summary
High-frequency EWT trend
Lost kilometres by cause
Passenger wait distribution
Low-frequency / Night bus reliability
Network performance raw rows: mileage, EWT, LF on-time, night, satisfaction
These rows come from the uploaded TfL network performance summary files. Use them as the network benchmark; route/operator EWT can be added later using the import template.
Bus speed executive summary
Network speed trend
Slowest AM boroughs
Slowest all-day routes
Speed intelligence notes
Bus speed records: network, borough and route
Route loading executive summary
Highest passenger routes
Highest passengers per km
Annual route usage and operated km
Route loadings from the uploaded annual bus stats file are route-level. Add route/operator contract mapping to filter these directly by operator.
Customer / passenger executive summary
Customer satisfaction trend
Bus User Survey key measures
Customer satisfaction raw metrics
TfL Bus User Survey benchmark metrics
Mechanical / MDBF readiness summary
Controllable loss proxy by group
Template rows vs MDBF-ready rows
Full embedded MDBF / mechanical template records
All rows from the uploaded MDBF CSV are now loaded into the app. Use the left filters for period, parent group, detailed operator and search.
Vehicle type mix
Fleet age distribution
Zero emission by group
Fleet raw records (filtered)
Relationship audit
Data model
National benchmark layer
Operator mapping table
Connector priority summary
Source priorities by layer
KPI build status
Executive KPI framework
Import schemas to add next
Public/open data source catalogue
This catalogue is the roadmap for connecting everything useful: TfL operator performance, route quality, passenger demand/loadings, DfT/GOV benchmarks, safety, traffic, council/LTA context and engineering/MDBF inputs.
Demand benchmark summary
Passenger / demand benchmarks
What to connect for passenger loadings
Passenger, mileage, fleet, finance and staff benchmarks
Council / external factor sources
Data explorer
Import new data
Drop file here or choose a file below.
CSV and JSON work fully offline. For XLSX/ODS, export the source sheet as CSV first, then import it here.
MDBF import template
MDBF cannot be calculated from the current base files because there is no mechanical failure/breakdown count. Import a file with operated miles and chargeable mechanical failures to calculate true MDBF.
Accepted column names include:
Parent Operator,Detailed Operator,Period,Operated Miles,Mechanical Failures,Mechanical Lost Mileage Arriva,Arriva London North,2025/26 Q4,1250000,42,1850 Go-Ahead,London Central,2025/26 Q4,980000,31,1210