Spreadsheet: 223ce522-f787-44f9-8063-2af6e1e3f690
Sheet: Sheet2

Area | GJT req | GJT (mins) | GJT Diff | Possible Options |  | intervals (mins) | interval penalty | Interchange(s) | Interchange(s) penalty | RAIL TIME (mins)
ABERDEEN | 688.3985085852208 | 499 | -189.3985085852208 |  |  | 60 | 27 | 1 | 90 | 382
BASILDON | 274.6038887420539 | 363.9 | 89.29611125794605 | 1 interchange |  | 30 | 21 | 2 | 125.2 | 215
BASINGSTOKE | 289.2718958198839 | 307.205 | 17.93310418011612 |  |  | 24 | 18.6 | 1.4 | 90.71999999999998 | 201
BATH | 296.3417366557633 | 312.1009375 | 15.75920084423666 |  |  | 30 | 21 | 1.5 | 94.80000000000001 | 196
BEDFORD | 165.0895982835166 | 179.2875 | 14.19790171648344 | 0.66 interchange |  | 40 | 23 | 1 | 49.3 | 111
BIRKENHEAD | 114.7259156586621 | 203.1 | 88.37408434133788 | 0 interchange | SH- Liverpool Lime Street - Birkenhead Central (min 1) | 60 | 27 | 1 | 35.4 | 137
BIRMINGHAM | 136.0826436193657 | 93.671625 | -42.41101861936571 |  |  | 20 | 17 | 0.17 | 6.3155 | 71
BLACKBURN | 95.15353679328209 | 224.05 | 128.8964632067179 | 0 interchange | SH - Manchester Piccadilly  - Bolton - Blackburn (min 2) | 30 | 21 | 2 | 58.6 | 131
BLACKPOOL | 113.7063981741335 | 214.24375 | 100.5373518258665 | 0 interchange | SH - Manchester Piccadilly - (Preston) - Blackpool (min 1) | 30 | 21 | 1.5 | 53.40000000000001 | 136
BOLTON | 83.9773235885512 | 135.84375 | 51.8664264114488 |  |  | 30 | 21 | 1 | 26.6 | 83
BOURNEMOUTH | 414.860699114821 | 420.1 | 5.239300885179034 |  |  | 24 | 18.6 | 1.6 | 116.48 | 282
BRADFORD | 53.48320151640073 | 121.34375 | 67.86054848359927 | 0 interchange | SH - Leeds - Bradford (min 1) | 30 | 21 | 1 | 25.3 | 76
BRIGHTON | 403.1741548598491 | 333.55 | -69.62415485984911 |  |  | 30 | 21 | 1 | 70.8 | 238
BRISTOL | 304.672950583681 | 206.86875 | -97.80420058368102 |  |  | 30 | 21 | 0.5 | 30.4 | 157
CAMBRIDGE/MILTON | 286.2140050750833 | 319.431 | 33.21699492491678 | 1.5 interchange |  | 20 | 17 | 2.33 | 115.568 | 161
CARDIFF | 356.845513454228 | 326.65625 | -30.18926345422796 |  |  | 30 | 21 | 1.5 | 99.30000000000001 | 209
CHATHAM | 296.8305439128909 | 274.8625 | -21.96804391289089 |  |  | 30 | 21 | 1 | 66.6 | 188
CHELMSFORD | 305.9147800886539 | 412.201875 | 106.2870949113461 | 2.33 interchange |  | 20 | 17 | 3 | 189 | 205
CHELTENHAM | 190.9448764868403 | 168.525 | -22.41987648684022 |  |  | 30 | 21 | 0.5 | 26.3 | 124
CHESTER | 94.40388146926456 | 200.340625 | 105.9367435307354 | 0 interchange | SH - Stockport - Chester (min 1) | 30 | 21 | 1.5 | 49.5 | 130
COLCHESTER | 326.7395139619566 | 399.1975 | 72.45798603804343 | 1 interchange |  | 24 | 18.6 | 2.2 | 150.04 | 228
COVENTRY | 145.8243468509278 | 180.9281875 | 35.1038406490722 | 0 interchange | SH - (Derby) - Birmingham New Street  - Coventry (min 1) | 20 | 17 | 1.33 | 49.875 | 112
CRAWLEY | 298.6700748509219 | 382.575 | 83.90492514907811 | 1.33-1.5 interchange |  | 30 | 21 | 2 | 132.8 | 231
DARLINGTON | 128.4439563021237 | 125 | -3.443956302123709 |  |  | 30 | 21 | 0 | 0 | 104
DERBY | 41.37355828924383 | 45.00000000000001 | 3.626441710756175 | Faster train |  | 15 | 14 | 0 | 0 | 31.00000000000001
[NAME] | 114.5290976292672 | 188.490625 | 73.9615273707328 | 0 interchange | SH - (Derby) - Birmingham New Street  - Dudley (min 1) | 30 | 21 | 1.5 | 60.90000000000001 | 115
DUNDEE | 545.7183271561111 | 454.7 | -91.01832715611107 |  |  | 40 | 23 | 1.33 | 119.7 | 312
DUNFERMLINE | 418.3297957923629 | 442.7265 | 24.39670420763713 |  |  | 40 | 23 | 1.66 | 135.124 | 279
EASTBOURNE | 403.569638924136 | 453.2 | 49.63036107586396 | 1.5 interchange |  | 30 | 21 | 2 | 149.6 | 277
EDINBURGH | 500.9865164293793 | 294.55625 | -206.4302664293793 |  |  | 30 | 21 | 0.5 | 38 | 235
EXETER | 501.124792661567 | 375.4 | -125.724792661567 |  |  | 60 | 27 | 1 | 75.4 | 273
FALKIRK | 436.461380807747 | 427.89575 | -8.56563080774697 |  |  | 40 | 23 | 1.66 | 130.476 | 270
GILLINGHAM | 308.6855975477634 | 279.175 | -29.51059754776338 |  |  | 30 | 21 | 1 | 66.4 | 192
GLASGOW | 571.9298098652096 | 446.48 | -125.4498098652095 |  |  | 24 | 18.6 | 1.6 | 121.92 | 301
GLOUCESTER | 195.3587618661706 | 240.584375 | 45.22561313382943 | 0.5 interchange |  | 30 | 21 | 1.5 | 81.15 | 146
[NAME] | 74.52718633525848 | 140 | 65.47281366474152 |  |  | 60 | 23 | 0 | 0 | 117
HALIFAX | 49.68340053696338 | 137.325 | 87.64159946303661 | 0 interchange | SH - Leeds - Halifax (min 1) | 30 | 21 | 1 | 25 | 92
HARLOW/SAWBRIDGEWORTH | 266.6142259399649 | 419.3 | 152.685774060035 | 1 interchange |  | 30 | 21 | 3 | 181.2 | 206
HARROGATE/KNARESBOROUGH | 62.52772573818614 | 158.9875 | 96.45977426181386 | 0 interchange | SH - Leeds - Harrogate (min 1) | 30 | 21 | 1 | 28.8 | 111
HARTLEPOOL | 159.4345058212178 | 317.015625 | 157.5811191787822 | 0 interchange |  | 60 | 23 | 2.5 | 109.75 | 183
HASTINGS | 406.7523234569512 | 453.5 | 46.74767654304884 | 1.5 interchange |  | 30 | 21 | 2 | 146.4 | 272
HIGH WYCOMBE | 240.0071170220002 | 317.734375 | 77.72725797799984 | 0.75 interchange |  | 30 | 21 | 1.75 | 100.1 | 196
HUDDERSFIELD | 37.59661145108478 | 103.938375 | 66.34176354891521 | 0 interchange | SH - (WakeField) -Huddersfield (min 0) | 20 | 17 | 0.66 | 13.596 | 73
IPSWICH | 258.7598805241204 | 345.075 | 86.31511947587961 | 1 interchange |  | 40 | 23 | 2 | 123.2 | 205
KINGSTON upon HULL | 78.31940561049306 | 127.445 | 49.12559438950693 | 0 interchange | SH - (Doncaster) - Hull (min 0) | 24 | 18.6 | 0.6 | 17.76 | 92
LEEDS | 46.0616645835519 | 52.6 | 6.538335416448099 | Faster train |  | 12 | 11.6 | 0 | 0 | 41
LEICESTER | 92.8851203702688 | 77 | -15.88512037026879 |  |  | 30 | 21 | 0 | 0 | 56
LINCOLN | 50.87306662871963 | 109 | 58.12693337128037 |  |  | 60 | 27 | 0 | 0 | 82
LIVERPOOL | 133.3044949853821 | 211.36875 | 78.06425501461791 | 0 interchange | SH - (Liverpool South Parkway) - LVP Central (min 0) | 60 | 27 | 1 | 33.25 | 146
LONDON | 391.0828948312243 | 203.481875 | -187.6010198312243 |  |  | 17.14 | 15.3 | 0.43 | 25.112 | 163
LUTON | 207.6521444107622 | 279.6625 | 72.0103555892378 | 1 interchange |  | 60 | 27 | 2 | 101 | 149
MAIDSTONE | 331.0189016910437 | 365.825 | 34.80609830895634 | 1.75 interchnage |  | 30 | 21 | 2 | 134.4 | 208
MANCHESTER | 64.36972149009028 | 71.6 | 7.230278509909709 | Faster train |  | 24 | 18.6 | 0 | 0 | 53
MIDDLESBROUGH | 165.6581639251158 | 200.6638125 | 35.00564857488425 | 0.75 interchange |  | 40 | 23 | 1.33 | 54.397 | 120
NEWCASTLE | 196.1448896608126 | 157 | -39.14488966081262 |  |  | 30 | 21 | 0 | 0 | 136
NEWPORT | 296.7916728940765 | 307.09375 | 10.3020771059235 | 0.75 interchange |  | 30 | 21 | 1.5 | 95.1 | 193
NORTHAMPTON | 192.7294305353857 | 225.375 | 32.64556946461425 | 0.5 interchange |  | 30 | 21 | 1.5 | 61.34999999999999 | 132
NORWICH | 295.9728915921698 | 276.075 | -19.8978915921698 |  |  | 30 | 21 | 1 | 56.8 | 192
NOTTINGHAM | 49.78888330192525 | 82.04124999999999 | 32.25236669807474 |  |  | 24 | 18.6 | 0.2 | 4.62 | 59
OLDBURY/SMETHWICK | 128.5112929342545 | 180.404875 | 51.89358206574551 | 0 interchange | SH - Birmingham New Street - (Dudley) - Smethwock (min 1) | 20 | 17 | 1.66 | 65.404 | 106
OXFORD | 246.9636177349235 | 169 | -77.96361773492347 |  |  | 60 | 27 | 0 | 0 | 142
PETERBOROUGH | 124.5889902855637 | 139.878125 | 15.28913471443633 | 0.33 interchange |  | 30 | 21 | 0.75 | 30 | 92
PLYMOUTH | 633.2202904251842 | 343 | -290.2202904251842 |  |  | 60 | 27 | 0 | 0 | 316
POOLE | 441.2929262733621 | 454.578125 | 13.28519872663787 |  |  | 30 | 21 | 1.75 | 129.5 | 295
PORTSMOUTH | 404.317424638306 | 443.15 | 38.83257536169396 | 1.75 interchnage |  | 30 | 21 | 2 | 142 | 275
PRESTON | 90.62650923275898 | 162.875 | 72.24849076724102 | 0 interchange | SH - Manchester Piccadilly - Preston (min 1) | 30 | 21 | 1 | 32.6 | 109
READING | 292.6656873017494 | 251.45 | -41.21568730174931 |  |  | 30 | 21 | 1 | 62.8 | 171
REDDITCH | 120.8862474556206 | 202.046875 | 81.16062754437945 | 0 interchange | SH - (Derby) - Birmingham New Street  - Redditch (min 1) | 30 | 21 | 1.5 | 62.25 | 124
ROCHDALE | 67.92198355931771 | 176.1065 | 108.1845164406823 | 0 interchange | SH - Leeds - Rochdale | SH - Manchester Piccadilly  - [NAME] (min 1) | 20 | 17 | 1.66 | 40.006 | 113
ROTHERHAM | 5.228105584449729 | 29 | 23.77189441555027 | more frequent and faster train |  | 20 | 17 | 0 | 0 | 12
SLOUGH | 292.3981996665719 | 337.5 | 45.10180033342812 | more frequent and faster train |  | 30 | 21 | 2 | 118 | 191
SOLIHULL | 117.5402722958412 | 170.0155 | 52.47522770415884 | 0.33 interchange |  | 20 | 17 | 1.33 | 49.609 | 106
SOUTHAMPTON | 374.0052697121138 | 354.0599999999999 | -19.94526971211388 |  |  | 24 | 18.6 | 1.4 | 94.63999999999999 | 239
SOUTHEND-on-SEA | 331.0210983339375 | 419.625 | 88.60390166606248 | 1.25 interchange |  | 30 | 21 | 2.5 | 162.5 | 233
SOUTHPORT | 113.251760724848 | 207.625 | 94.37323927515199 | 0 interchange | SH - Liverpool South Parkway - Southport (min 1) | 30 | 21 | 1 | 36 | 147
ST. ALBANS | 219.5885209802045 | 248.4875 | 28.89897901979549 | more frequent and faster train |  | 30 | 21 | 1.5 | 81.15 | 146
ST. HELENS | 131.7942226088642 | 242.86875 | 111.0745273911358 | 0 interchange | SH - Liverpool Lime Street  - St Helens Central  | SH - Manchester Piccadilly  -  Preston  - St Helens Central (min 1) | 30 | 21 | 1.5 | 47.25 | 150
STEVENAGE | 216.910327550688 | 241.0234375 | 24.11310994931199 |  |  | 30 | 21 | 1.25 | 66.875 | 152
STOCKPORT | 44.43047788098099 | 65 | 20.56952211901901 | more frequent and faster train |  | 30 | 21 | 0 | 0 | 44
STOCKTON-on-TEES | 147.4599535513855 | 298.890625 | 151.4306714486145 | 0 interchange | SH - York - (Northalerton) -Thronaby - Stockton (min 2) | 60 | 27 | 2.5 | 103.75 | 168
STOKE-on-TRENT | 90.42219365606077 | 146.7 | 56.27780634393925 | 0 interchange | SH - Stockport - Stoke-on-Trent (min 1) | 40 | 23 | 1 | 25 | 93.00000000000001
SUNDERLAND | 212.5143728316439 | 251.3125 | 38.7981271683561 | 0.33 interchange |  | 30 | 21 | 1 | 48.4 | 177
SUTTON COLDFIELD | 120.1275065607622 | 169.4394375 | 49.3119309392378 | 0 interchange | SH - (Derby) - Birmingham New Street  - Sutton (min 1) | 20 | 17 | 1.33 | 43.89 | 105
SWANSEA | 412.1041362258749 | 429.5 | 17.39586377412508 |  |  | 30 | 21 | 2 | 66 | 265
SWINDON | 273.6873842277338 | 332.1009375 | 58.41355327226614 | 0.75 interchange |  | 30 | 21 | 1.5 | 90 | 216
WAKEFIELD | 27.3653718028843 | 54.6 | 27.2346281971157 | more frequent and faster train |  | 12 | 11.6 | 0 | 0 | 43
WALSALL | 123.9219973576023 | 192.078125 | 68.15612764239768 | 0 interchange | SH - (Derby) - Birmingham New Street - Walsall (min 1) | 30 | 21 | 1.5 | 50.84999999999999 | 116
WARRINGTON | 66.09287138276437 | 109 | 42.90712861723563 | more frequent and faster train |  | 60 | 27 | 0 | 0 | 82
WESTON-SUPER-MARE | 284.9196656383826 | 337.125 | 52.20533436161736 | 0.75 interchange |  | 30 | 21 | 1.5 | 94.19999999999999 | 222
WIGAN | 78.60596023979372 | 163.88125 | 85.27528976020628 | 0 interchange |  | 30 | 21 | 1 | 28.8 | 111
WOLVERHAMPTON | 145.3806270302299 | 180.54375 | 35.16312296977014 | Faster train |  | 17.14 | 15.3 | 1.3 | 47.45 | 113
WORCESTER | 149.0146916387237 | 235.625 | 86.61030836127625 | 0.33 interchange |  | 30 | 21 | 2 | 93.8 | 132
WORTHING | 397.1749381345067 | 441.675 | 44.50006186549331 | more frequent and faster train |  | 30 | 21 | 2 | 144.8 | 267
YORK | 65.78582200506186 | 92.99999999999999 | 27.21417799493813 | more frequent and faster train |  | 30 | 21 | 0 | 0 | 71.99999999999999