johnsmith147
Member
Hello all,
I apologise if this has been done before, but I can’t find any other threads that attempt to do what I’ve been looking into. My aim has been to analyse all possible ticket combinations between UK stations, and see the effects that split ticketing has on the overall statistics. It’s been an interesting challenge, and I think the results should probably be published somewhere properly, if I can get around to it. A byproduct of it is a database of all optimal splits for walk-up fares from any station to another. I can make this publicly available (if I’m allowed) if people would like to use it.
I’ve done the analysis using the available static data from the National Rail Data Feeds, using Off-Peak and Anytime fares only and valid as of the 5th July. For this post I’ll just look at the cheapest standard-class fares between stations. I’ve done 1st class as well, but there are already a lot of numbers here! Distances quoted are as the crow flies, not along the railway.
Ideally, imminent fares reform under GBR will make all of this obsolete. I’m a firm believer that if a cheaper walk-up split ticket for a journey exists, it is essential that this can be bought as a through ticket. The "fair" fare is easy enough to calculate (I’ve done it!) and so there’s no excuse for not doing so officially... One caveat is that I’ve not used the official routeing guide at all here – it's just too complicated. But cheaper splits that contravene the guide shouldn’t exist, in an ideal world. Anyway, some stats:
Minimum/Maximum Fares Per Mile:
Min. price per mile, return: Wye-Ashurst New Forest, £21.20, 108.9 miles,19.5ppm
Max. price per mile, return: Forest Gate-Wanstead Park, £16.10, 0.139 miles, 11597.8ppm
Max. price per mile, split return: Dalston Kingsland-Dalston Junction, £14.00, 0.136 miles, 10290.0ppm
Min. price per mile, single: Appley Bridge-Glossop, £4.20, 33.1 miles, 12.7ppm
Max. price per mile, single: Forest Gate-Wanstead Park, £9.80, 0.139 miles, 7059.5ppm
Max. price per mile, split single: Forest Gate-Wanstead Park, £7.70, 0.139 miles, 5546.8ppm
Maximum Absolute Savings Using Splits:
Return: Bicester North-Severn Tunnel Junction/Caldicot: £490.80, with splits £71.90
Single: Lockerbie-Newquay (/some others nearby): £320.80, with splits £103.50
Maximum Percentage Savings Using Splits:
These are tricky. Technically it’s Camarthen-Aberystwyth, which is £91.20 single, but it can be split by using a bus to be £9. I’m not sure if this counts. If not, then it’s the same as the absolute ones.
Overall Savings as a Result of Splits:
Returns:
Unsplit mean pence per mile (ppm): 80.6
Single-split mean ppm: 65.3, 17.8% cheaper on average
Multi-split mean ppm: 53.7, 32.7% cheaper on average
92.1% of fares can be made cheaper by splitting
Singles:
Unsplit mean ppm: 61.3
Single-split mean ppm: 47.1, 19.7% cheaper on average
Multi-split mean ppm: 42.5, 27.6% cheaper on average
89.1% of fares can be made cheaper by splitting
Least/Most Expensive Stations (mean price per mile for all destinations):
Min. price per mile, returns: Thurso, 60.2ppm
Min. price per mile, split returns: Garelochhead, 40.5ppm
Min. price per mile, singles: Thurso, 39.3ppm
Min. price per mile, split singles: Thurso, 30.9ppm
Max. price per mile, returns: Heathrow T4, 138.7ppm
Max. price per mile, split returns: Harrow on the Hill, 114.5ppm
Max. price per mile, singles: Heathrow T4, 95.2ppm
Max. price per mile, split singles: Farringdon, 69.4ppm
Most splits needed to achieve the cheapest price (obviously there are multiple contenders here):
Return: Lelant Saltings-Dyce. £328.20 vs £238.80. 14 splits:
BAS-TAU-ASD-BMV-BTG-STA-SNE-BLK-ADL-EGY-INK-DEE-STN-ABD
Single: Kingham-Dalmally. £165.80 vs £132.30. 12 splits:
HYB-BMV-ALV-STA-BRT-SOT-MAN-WGN-PRE-GRL-GCH-ART
Some graphs are attached as well, which might be of even more interest (especially the average price as a function of origin station latitude, I like that one!). Hopefully they're self-explanatory, except for the tartan-looking colour maps, which are the price from every station to every other station, ordered by latitude on both axes.
Obviously the prevalence of Advance fares makes most of this not particularly useful for long-distance trip planning. But the algorithm I've used here would work perfectly well for Advance fares on a single journey -- I can't wait for the day when they just do the maths such that A-B-C never costs less than A-C for advances on a single train! This could be taken a step further by reducing any tickets using the route of said advance train by the same amount, to ensure completely fair system. One can hope.
As I said, if there's keenness to make these splits into a searchable database, then I can do so. Similarly, any requests for other statistics are welcome.
Hope this is of interest!
Oliver
I apologise if this has been done before, but I can’t find any other threads that attempt to do what I’ve been looking into. My aim has been to analyse all possible ticket combinations between UK stations, and see the effects that split ticketing has on the overall statistics. It’s been an interesting challenge, and I think the results should probably be published somewhere properly, if I can get around to it. A byproduct of it is a database of all optimal splits for walk-up fares from any station to another. I can make this publicly available (if I’m allowed) if people would like to use it.
I’ve done the analysis using the available static data from the National Rail Data Feeds, using Off-Peak and Anytime fares only and valid as of the 5th July. For this post I’ll just look at the cheapest standard-class fares between stations. I’ve done 1st class as well, but there are already a lot of numbers here! Distances quoted are as the crow flies, not along the railway.
Ideally, imminent fares reform under GBR will make all of this obsolete. I’m a firm believer that if a cheaper walk-up split ticket for a journey exists, it is essential that this can be bought as a through ticket. The "fair" fare is easy enough to calculate (I’ve done it!) and so there’s no excuse for not doing so officially... One caveat is that I’ve not used the official routeing guide at all here – it's just too complicated. But cheaper splits that contravene the guide shouldn’t exist, in an ideal world. Anyway, some stats:
Minimum/Maximum Fares Per Mile:
Min. price per mile, return: Wye-Ashurst New Forest, £21.20, 108.9 miles,19.5ppm
Max. price per mile, return: Forest Gate-Wanstead Park, £16.10, 0.139 miles, 11597.8ppm
Max. price per mile, split return: Dalston Kingsland-Dalston Junction, £14.00, 0.136 miles, 10290.0ppm
Min. price per mile, single: Appley Bridge-Glossop, £4.20, 33.1 miles, 12.7ppm
Max. price per mile, single: Forest Gate-Wanstead Park, £9.80, 0.139 miles, 7059.5ppm
Max. price per mile, split single: Forest Gate-Wanstead Park, £7.70, 0.139 miles, 5546.8ppm
Maximum Absolute Savings Using Splits:
Return: Bicester North-Severn Tunnel Junction/Caldicot: £490.80, with splits £71.90
Single: Lockerbie-Newquay (/some others nearby): £320.80, with splits £103.50
Maximum Percentage Savings Using Splits:
These are tricky. Technically it’s Camarthen-Aberystwyth, which is £91.20 single, but it can be split by using a bus to be £9. I’m not sure if this counts. If not, then it’s the same as the absolute ones.
Overall Savings as a Result of Splits:
Returns:
Unsplit mean pence per mile (ppm): 80.6
Single-split mean ppm: 65.3, 17.8% cheaper on average
Multi-split mean ppm: 53.7, 32.7% cheaper on average
92.1% of fares can be made cheaper by splitting
Singles:
Unsplit mean ppm: 61.3
Single-split mean ppm: 47.1, 19.7% cheaper on average
Multi-split mean ppm: 42.5, 27.6% cheaper on average
89.1% of fares can be made cheaper by splitting
Least/Most Expensive Stations (mean price per mile for all destinations):
Min. price per mile, returns: Thurso, 60.2ppm
Min. price per mile, split returns: Garelochhead, 40.5ppm
Min. price per mile, singles: Thurso, 39.3ppm
Min. price per mile, split singles: Thurso, 30.9ppm
Max. price per mile, returns: Heathrow T4, 138.7ppm
Max. price per mile, split returns: Harrow on the Hill, 114.5ppm
Max. price per mile, singles: Heathrow T4, 95.2ppm
Max. price per mile, split singles: Farringdon, 69.4ppm
Most splits needed to achieve the cheapest price (obviously there are multiple contenders here):
Return: Lelant Saltings-Dyce. £328.20 vs £238.80. 14 splits:
BAS-TAU-ASD-BMV-BTG-STA-SNE-BLK-ADL-EGY-INK-DEE-STN-ABD
Single: Kingham-Dalmally. £165.80 vs £132.30. 12 splits:
HYB-BMV-ALV-STA-BRT-SOT-MAN-WGN-PRE-GRL-GCH-ART
Some graphs are attached as well, which might be of even more interest (especially the average price as a function of origin station latitude, I like that one!). Hopefully they're self-explanatory, except for the tartan-looking colour maps, which are the price from every station to every other station, ordered by latitude on both axes.
Obviously the prevalence of Advance fares makes most of this not particularly useful for long-distance trip planning. But the algorithm I've used here would work perfectly well for Advance fares on a single journey -- I can't wait for the day when they just do the maths such that A-B-C never costs less than A-C for advances on a single train! This could be taken a step further by reducing any tickets using the route of said advance train by the same amount, to ensure completely fair system. One can hope.
As I said, if there's keenness to make these splits into a searchable database, then I can do so. Similarly, any requests for other statistics are welcome.
Hope this is of interest!
Oliver
Attachments
-
station_price_1_0_1.png91.8 KB · Views: 93 -
station_price_1_1_1.png96.1 KB · Views: 90 -
colormesh_1_0_1.png5.1 MB · Views: 87 -
colormesh_1_1_1.png5.6 MB · Views: 82 -
ppm_1_0_1.png49 KB · Views: 65 -
ppm_1_1_1.png47.2 KB · Views: 58 -
heatmap_1_0_1.png248.4 KB · Views: 61 -
heatmap_1_1_1.png283.6 KB · Views: 90