Spreadsheet: 184154d1349167005-help-required-to-work-out-calculation-please-drivereportscreen01
Sheet: RouteData

 | AndoverCoventry | Local→A303→A34→M40→A46→A45→Local
 | AndoverGlenfield | Local→A303→A34→M40→A43→M1→A46→Local |  |  |  |  |  |  |  |  | [NAME]
 | AndoverLeicester | Local→A303→A34→M40→A43→M1→A46→A563 |  |  |  |  |  |  |  |  | Andover
 | BilsthorpeLeicester | Local→A614→A6097→A46→A563 |  |  |  |  |  |  |  |  | Bilsthorpe
 | BilstonCoventry | Local→A463→A454→M6→A46→Local |  |  |  |  |  |  |  |  | Bilston
 | BilstonSkelmersdale | Local→A463→A454→M6→M58→Local |  |  |  |  |  |  |  |  | Birchwood
 | BilstonYate | Local→A463→A454→M6→M5→M4→A4174→A432→Local |  |  |  |  |  |  |  |  | Birtley
 | BirchwoodLeicester | A574→M62→M6→A500→A50→A6→A563 |  |  |  |  |  |  |  |  | [NAME]
 | BirchwoodSt [NAME] | A574→M62→A570→B5204 |  |  |  |  |  |  |  |  | Bristol
 | BirtleyLeicester | Local→A197→A693→A1(M)→M1→A6→A563 |  |  |  |  |  |  |  |  | Burton Latimer
 | [NAME] | Local→A197→A693→A1(M)→A688→A181→A19→Local |  |  |  |  |  |  |  |  | Chepstow
 | [NAME] | A38→J24→M5→A30→A394 |  |  |  |  |  |  |  |  | Chesterfield
 | Bridgwater SwitchLeicester | A38→J24→M5→A46→A45→A46→M69→M1→A46→A563 |  |  |  |  |  |  |  |  | Coventry
 | Bridgwater SwitchMarazion | A38→J24→M5→A30→Newtown Rd |  |  |  |  |  |  |  |  | [NAME]
 | BristolCoventry | Local→M5→A46→A45→Local |  |  |  |  |  |  |  |  | Deeside
 | BristolHayle | Local→M5→A30→B3074→B3311 |  |  |  |  |  |  |  |  | Ditton
 | BristolTollwell Road | Local→M5→A46→A45→A46→M69→M1→A46→A563→Local |  |  |  |  |  |  |  |  | Duncote
 | BristolTrevabyn | Local→M5→A30→A394→Local |  |  |  |  |  |  |  |  | Enfield
 | BristolYate | Local→M5→M4→A4174→A432→Local |  |  |  |  |  |  |  |  | [NAME]
 | [NAME] | Local→A14→M6→A46→Local |  |  |  |  |  |  |  |  | Goldsithney
 | Burton LatimerCrow [NAME] | Local→A14→A45→Local |  |  |  |  |  |  |  |  | [NAME]
 | Burton LatimerLeicester | Local→A14→A6→A563 |  |  |  |  |  |  |  |  | Hayle
 | Burton LatimerLeicester2 | Local→A14→M1→A46→A563 |  |  |  |  |  |  |  |  | Hickling
 | [NAME] | Local→A14→A605→A1(M)→A46→A1434 |  |  |  |  |  |  |  |  | Keenpac
 | ChepstowBristol | Local→M48→M4→M5→Local |  |  |  |  |  |  |  |  | Leicester
 | ChepstowCoventry | Local→M48→M4→M5→A46→A45→Local |  |  |  |  |  |  |  |  | Lichfield
 | ChepstowDitton | Local→M48→M4→A449→A40→A49→Local→B4521 |  |  |  |  |  |  |  |  | Lincoln
 | ChepstowGlenfield | Local→M48→M4→M5→A46→A45→A46→M69→M1→A46→Local |  |  |  |  |  |  |  |  | Liverpool
 | ChepstowYate | Local→M48→M4→A4174→A432→Local |  |  |  |  |  |  |  |  | Lutterworth
 | [NAME] | Local→A61→A617→M1→A50→A46→A563→Local |  |  |  |  |  |  |  |  | Magor
 | CoventryBirchwood | Local→A46→M6→M62→A574 |  |  |  |  |  |  |  |  | Marazion
 | CoventryCoventry | Cross Road |  |  |  |  |  |  |  |  | Merrose
 | CoventryLeicester | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | CoventryLeicesterDiv | Local→A46→M69→M1→A46→A6→A563 |  |  |  |  |  |  |  |  | Moulton Park
 | CoventryWiddowsons | Local→A46→M69→M1→A46→Local |  |  |  |  |  |  |  |  | North Scarle
 | [NAME] | Local→A45→M1→M45→A45→Local |  |  |  |  |  |  |  |  | Northampton
 | [NAME] | Local→A45→A43→Local |  |  |  |  |  |  |  |  | Nursling
 | DeesideLeicester | Local→A548→A494→M56→M6→A500→A50→A6→A563 |  |  |  |  |  |  |  |  | [NAME]
 | DeesideTollwell Road | Local→A548→A494→M56→M6→A500→A50→A6→A563→Local |  |  |  |  |  |  |  |  | Purfleet
 | DittonLeicester | B4521→Local→A49→A40→M50→M5→A46→A45→A46→M69→M1→A46→A563 |  |  |  |  |  |  |  |  | Scudamore Road
 | DuncoteLeicester | Local→B5061→M54→M6→M69→M1→A46→A563 |  |  |  |  |  |  |  |  | Scunthorpe
 | EnfieldCoventry | Local→A1055→A10→M25→M1→M45→A45→Local |  |  |  |  |  |  |  |  | Skelmersdale
 | EnfieldCoventry2 | Local→A1055→A10→M11→A14→M6→A46→Local |  |  |  |  |  |  |  |  | Southall
 | [NAME] | Local→A1055→A10→M25→M1→A45→Local |  |  |  |  |  |  |  |  | [NAME]
 | EnfieldLeicester | Local→A1055→A10→M25→M1→A46→A563 |  |  |  |  |  |  |  |  | Swindon
 | EnfieldMoulton Park | Local→A1055→A10→M25→M1→A45→A43→Local |  |  |  |  |  |  |  |  | Sywell
 | EnfieldSywell | Local→A1055→A10→M11→A14→A43→Local |  |  |  |  |  |  |  |  | Thornham
 | GlenfieldCoventry | Local→M1→M69→A46→Local |  |  |  |  |  |  |  |  | Thurrock
 | GlenfieldLeicester | Local→A46→A563 |  |  |  |  |  |  |  |  | Tollwell Road
 | GlenfieldLeicesterDiv | [NAME] |  |  |  |  |  |  |  |  | Trehebor
 | GlenfieldPeterlee | Local→A46→A1(M)→A168→A19→B1320 |  |  |  |  |  |  |  |  | Trevabyn
 | GlenfieldPeterlee2 | Local→A46→A50→M1→A1(M)→A168→A19→B1320 |  |  |  |  |  |  |  |  | Wakefield
 | GoldsithneyTrehebor | [NAME] |  |  |  |  |  |  |  |  | [NAME]
 | GoldsithneyTrevabyn | A394→Local |  |  |  |  |  |  |  |  | West Thurrock
 | HatfieldCoventry | Local→A1001→A414→A1 (M)→A14→M6→A46→Local |  |  |  |  |  |  |  |  | Westbrook
 | HatfieldLeicester | Local→A1001→A414→A1 (M)→A47→A563 |  |  |  |  |  |  |  |  | Widdowsons
 | [NAME] | B3311→B3074→A30→M5→J24→A38 |  |  |  |  |  |  |  |  | [NAME]
 | HayleLeicester | A3311→A3074→A30→M5→A46→A45→A46→M69→M1→A46→A563
 | HicklingLeicester | [NAME]
 | KeenpacEnfield | Local→A563→M1→M25→A10→A1055→Local
 | LeicesterAndover | A563→A46→M1→A43→M40→A34→A303→Local
 | LeicesterAndoverDiv | A563→A6→A46→M1→A43→M40→A34→A303→Local
 | LeicesterBilsthorpe | A563→A46→A6097→A614→Local
 | LeicesterBilston | A563→A46→M1→M69→M6→A454→A463→Local
 | LeicesterBirchwood | A563→A46→A50→M1→A50→A500→M6→M62→A574
 | LeicesterBirtley | A563→A46→A1(M)→A693→A167→Local
 | [NAME] | A563→A46→M1→M69→A46→A45→A46→M5→J24→A38
 | LeicesterBristol | A563→A46→M1→M69→A46→A45→A46→M5→Local
 | LeicesterBristol2 | A563→A46→M1→M69→A46→A45→A429→A40→M5→Local
 | LeicesterBristol2 | A563→A46→M1→M69→M6→M42→M5→Local
 | LeicesterBurton Latimer | A563→A46→M1→A14→Local
 | LeicesterChepstow | A563→A46→M1→M69→A46→A45→A46→M5→M4→M48→Local
 | LeicesterChepstowDiv | A563→A6→A46→M1→M69→A46→A45→A46→M5→M4→M48→Local
 | LeicesterChesterfield | A563→A46→A50→M1→A617→A61→Local
 | LeicesterCoventry | A563→A46→M1→M69→A46→Local
 | [NAME] | A563→A46→M1→A45→Local
 | LeicesterDuncote | A563→A46→M1→M69→M6→M54→B5061→Local
 | LeicesterEnfield | A563→A46→M1→M25→A10→A1055→Local
 | LeicesterEnfield2 | A563→A6→A46→M1→M25→A10→A1055→Local
 | LeicesterGlenfield | A563→A46→Local
 | LeicesterGlenfieldDiv | A563→A6→A46→Local
 | LeicesterHatfield | A563→A47→A1 (M)→A414→A1001→Local
 | LeicesterHickling | A563→A47→A1064→B1152→A149→Local
 | LeicesterKeenpac | A563→Local
 | LeicesterLichfield | A563→A46→A50→M1→A50→A38→Local
 | LeicesterLincoln | A563→A46→A1434
 | LeicesterLiverpool | A563→A46→A50→M1→A50→A500→M6→M56→A557→A562→A561→Local
 | LeicesterLiverpool2 | A563→A46→A50→M1→A50→A500→M6→M62→A5300→A561→Local
 | LeicesterLiverpool3 | A563→A46→A50→M1→A50→A500→M6→M62→M57→A580→Local
 | LeicesterLutterworth | A563→A46→M1→A4303→Local
 | LeicesterMagor | A563→A46→M1→M69→A46→A45→A46→M5→M4→Local
 | LeicesterMagor2 | A563→A46→M1→M69→A46→A45→A46→M5→M50→A449→M4→Local
 | [NAME] | A563→A6→A46→M1→M69→A46→A45→A46→M5→M4→Local
 | [NAME] | A563→A46→M1→A508→A5→A421→Local
 | LeicesterNorth Scarle | A563→A46→Local
 | LeicesterNorthampton | A563→A46→M1→Local (J15A)
 | LeicesterNursling | A563→A46→M1→A43→M40→A34→M3→M27→M271(S)→Local
 | [NAME] | A563→A46→A1(M)→A168→A19→B1320
 | LeicesterPeterlee2 | A563→A46→M1→A1(M)→A168→A19→B1320
 | LeicesterPeterlee3 | A563→A46→A616→B6325→A1(M)→A168→A19→B1320
 | LeicesterPurfleet | A563→A46→M1→M25→A13→A126→Local
 | LeicesterScudamore Road | A563→Local
 | LeicesterScunthorpe | A563→A46→A15→M180→M181→A1077→Local
 | LeicesterSwindon | A563→A46→M1→A43→M40→A34→A420→A419→A4311→Local
 | LeicesterSwindon2 | A563→A46→M1→M69→A46→A45→M40→A34→A420→A419→A4311→Local
 | LeicesterSwindonDiv | A563→A6→A46→M1→A43→M40→A34→A420→A419→A4311→Local
 | LeicesterSywell | A563→A46→M1→A14→A43→Local
 | LeicesterThornham | A563→A47→A149→Local
 | LeicesterThurrock | A563→A46→M1→M25→A1090→Local
 | LeicesterTollwell Road | Local
 | LeicesterTrevabyn | A563→A46→M1→M69→A46→A45→A46→A429→A40→M5→A30→A394→Local
 | LeicesterWakefield | A563→A46→A50→M1→A650→Local
 | [NAME] | A563→A47→A1 (M)→A414→A1001→Local
 | LeicesterWest Thurrock | A563→A46→M1→M25→A13→A126→Local
 | LeicesterWestbrook | A563→A46→A50→A511→A42→A444→Local
 | LeicesterWiddowsons | A563→A46→Local
 | LeicesterYate | A563→A46→M1→M69→A46→A45→A46→A429→A40→M5→M4→A4174→A432→Local
 | [NAME] | Local→A38→A50→A500→M6→A580→Local
 | [NAME] | A1434→A46→A563
 | LiverpoolBirchwood | Local→A561→A5300→M62→A574
 | LiverpoolDeeside | Local→A580→M57→A5300→A562→A533→A557→M56→A494→A548→Local
 | LiverpoolLeicester | Local→A561→A562→A5300→M62→M6→A500→A50→A6→A563
 | LiverpoolSkelmersdale | Local→A561→A5300→M57→M58→Local
 | [NAME] | Local→A4303→M1→A45→Local
 | LutterworthKeenpac | Local→A4303→M1→A563→Local
 | LutterworthScudamore Road | Local→A4303→M1→A563→Local
 | MagorCoventry | Local→M4→M5→A46→A45→Local
 | MagorLeicester | Local→M4→M5→A46→A45→A46→M69→M1→A46→A563
 | MagorLeicesterDiv | Local→M4→M5→A46→A45→A46→M69→M1→A46→A6→A563
 | MagorYate | Local→M4→A4174→A432→Local
 | MarazionMerrose | Newtown Rd→A30→A3047→Local→Illogan Downs
 | MerroseLeicester | Illogan Downs→Local→A3047→A30→M5→A46→A45→A46→M69→M1→A46→A563
 | [NAME] | Local→A5→A508→M1→A46→A563
 | [NAME] | Local→A5→A508→M1→A46→A563→Local
 | Moulton ParkSywell | Local→A43→Local
 | Moulton ParkTollwell Road | Local→A43→A14→A6→A563→Local
 | Moulton ParkTollwell Road2 | Local→A43→A45→M1→A46→A563→Local
 | North ScarleLeicester | Local→A46→A563
 | NorthamptonLeicester | Local (J15A)→M1→A46→A563
 | NorthamptonSywell | Local (J15A)→A45→A43→Local
 | NurslingCoventry | Local→M271(S)→M27→M3→A34→M40→A46→A45→Local
 | NurslingLeicester | Local→M271(S)→M27→M3→A34→M40→A43→M1→A46→A563
 | PeterleeLeicester | B1320→A19→A168→A1(M)→M1→A6→A563
 | PeterleeLeicester2 | B1320→A19→A168→A1(M)→M1→A50→A46→A563
 | PeterleeLeicester3 | B1320→A19→A168→A689→A1(M)→M18→M1→A50→A46→A563
 | PeterleeTollwell Road | B1320→A19→A168→A1(M)→M1→A6→A563→Local
 | PeterleeWiddowsons | B1320→A19→A168→A1(M)→M1→A6→A46→Local
 | PurfleetLeicester | Local→A126→A13→M25→A10→M11→A14→A1(M)→A46→A563
 | PurfleetLeicester2 | Local→A126→A13→M25→M1→A46→A563
 | Scudamore RoadGlenfield | Local
 | ScunthorpeLincoln | [NAME]
 | SkelmersdaleLeicester | Local→M58→M6→A500→A50→A6→A563
 | SkelmersdaleWiddowsons | Local→M58→M6→A500→A50→A6→A563→Local
 | St HelensLeicester | B5204→A570→M62→M6→A500→A50→M1→A50→A46→A563
 | [NAME] | Local→A580→M6→A500→A50→A6→A563→Local
 | SwindonHayle | B4006→A3102→M4→M5→A30→B3074→B3311
 | SwindonLeicester | Local→A4311→A419→A420→A34→M40→A43→M1→A46→A563
 | SwindonLeicesterDiv | Local→A4311→A419→A420→A34→M40→A43→M1→A46→A6→A563
 | SwindonTollwell Road | Local→A4311→A419→A420→A34→M40→A43→M1→A46→A563→Local
 | SwindonYate | Local→A4006→A3102→M4→A46→A432→B5098→Local
 | SywellCoventry | Local→A43→A14→M6→A46→Local
 | SywellCoventry2 | Local→A43→A45→M1→M45→A45→Local
 | SywellLeicester | Local→A14→M1→A46→A563
 | SywellTollwell Road | Local→A43→A14→A6→A563→Local
 | ThornhamLeicester | Local→A149→A47→A563
 | ThurrockGlenfieldTesco | Local→A1090→M25→M1→A46→Local
 | [NAME] | Local→A1090→M25→M1→A46→A563
 | Tollwell RoadAndover | Local→A563→A46→M1→A43→M40→A34→A303→Local
 | Tollwell RoadAndoverDiv | Local→A563→A6→A46→M1→A43→M40→A34→A303→Local
 | Tollwell RoadBilston | Local→A563→A46→M1→M69→M6→A454→A463→Local
 | Tollwell RoadBirchwood | Local→A563→A46→A50→M1→A50→A500→M6→M62→A574
 | Tollwell RoadBurton Latimer | Local→A563→A46→M1→A14→Local
 | Tollwell RoadChepstow | A563→A46→M1→M69→A46→A45→A46→M5→M4→M48→Local
 | Tollwell RoadCoventry | Local→A563→A46→M1→M69→A46→Local
 | Tollwell RoadEnfield | Local→A563→A46→M1→M25→A10→A1055→Local
 | Tollwell RoadGlenfield | Local→A563→A46→Local
 | Tollwell RoadLeicester | Local
 | Tollwell RoadLichfield | Local→A563→A46→A50→M1→A50→A38→Local
 | Tollwell RoadLiverpool | A563→A46→A50→M1→A50→A500→M6→M56→A557→A562→A561→Local
 | Tollwell RoadLiverpool2 | A563→A46→A50→M1→A50→A500→M6→M62→A5300→A561→Local
 | Tollwell RoadLiverpool3 | A563→A6→A50→A500→M6→M56→A557→A562→A561→Local
 | Tollwell RoadLiverpool4 | A563→A6→A50→A500→M6→M62→A5300→A561→Local
 | Tollwell RoadMagor | A563→A46→M1→M69→A46→A45→A46→M5→M4→Local
 | Tollwell RoadMilton Keynes | Local→A563→A46→M1→A508→A5→A421→Local
 | Tollwell RoadPeterlee | Local→A563→A46→A1(M)→A168→A19→B1320
 | Tollwell RoadWakefield | Local→A563→A46→A50→M1→A650→Local
 | Tollwell RoadWiddowsons | Local→A563→A46→Local
 | TreheborBridgwater Switch | B3315→A30→M5→J24→A38
 | TrevabynBridgwater Switch | Local→A394→A30→M5→J24→A38
 | [NAME] | Local→A394→A30→A3074→A3311
 | TrevabynLeicester | Local→A394→A30→M5→A46→A45→A46→M69→M1→A46→A563
 | WakefieldLeicester | Local→A650→M1→A6→A563
 | WakefieldPeterlee | Local→A650→M1→A1(M)→A168→A19→B1320
 | [NAME] | Local→A1001→A414→A1 (M)→A14→M6→A46→Local
 | West ThurrockLeicester | Local→A126→A13→M25→A10→M11→A14→A1(M)→A46→A563
 | WestbrookLeicester | Local→A444→A42→A511→A50→A46→A563
 | WiddowsonsBirchwood | Local→A46→A50→M1→A50→A500→M6→M62→A574
 | WiddowsonsCoventry | Local→M1→M69→A46→Local
 | WiddowsonsLeicester | Local→A46→A563
 | WiddowsonsSkelmersdale | Local→A46→A50→M1→A50→A500→M6→M58→Local
 | YateCoventry | Local→A432→A4174→M4→M5→A46→A45→Local
 | YateTollwell Road | Local→A432→A4174→M4→M5→A46→M69→M1→A46→563→Local
 | YateTollwell Road2 | Local→A432→A4174→M4→M5→A417→A436→A46→M69→M1→A46→563→Local
 | YateTollwell RoadDiv | Local→A432→A4174→M4→M5→A46→M69→M1→A46→A6→563→Local