• Our new ticketing site is now live! Using either this or the original site (both powered by TrainSplit) helps support the running of the forum with every ticket purchase! Find out more and ask any questions/give us feedback in this thread!

Mileage Competition 2015

Status
Not open for further replies.

507021

Established Member
Joined
19 Feb 2015
Messages
4,759
Location
Chester
This is really interesting. I'm planning to keep track of all of my railway mileage this year as I'm hoping to visit some new places further afield from Merseyside and Lancashire. I've got friends in South Yorkshire so I'm hoping to visit them a few times during the year and also explore the railway network in the area. Does anybody have any recommendations for any lines in South Yorkshire that are worth travelling on?

So far I've done 232 miles this year (started at the end of January). My target for this year is 2,500 miles and then hopefully more in 2016
 
Last edited:
Sponsor Post - registered members do not see these adverts; click here to register, or click here to log in
R

RailUK Forums

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
Is the first one via Stoke?

How you got via Stoke on a Stoke to Euston Journey I don't know...

From last year's spreadsheet:

- Avoiding Stone and Stafford (i.e. most VT services) = 145m71c
- Via Stone and Stafford (i.e. most LM services) = 149m58c

Can't help you with the others I'm afraid - I'm in the same situation as you. Occasionally RTT has the mileages in, might be worth checking there.

Thanks was a Virgin service!
 

bb21

Emeritus Moderator
Joined
4 Feb 2010
Messages
24,449
How you got via Stoke on a Stoke to Euston Journey I don't know...



Thanks was a Virgin service!

I meant Stafford.

I see someone has given you the mileage both ways anyway. Virgin normally avoid Stafford but you will need to look up the service details to be sure.

Lowestoft - Ipswich is 48m 75c
Liverpool St - Norwich is 115m 20c
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
I meant Stafford.

I see someone has given you the mileage both ways anyway. Virgin normally avoid Stafford but you will need to look up the service details to be sure.

Lowestoft - Ipswich is 48m 75c
Liverpool St - Norwich is 115m 20c

Thanks, and yes it avoided Stafford both ways I can assure you.
--- old post above --- --- new post below ---
Final bits for now. (is there another online resource for calculating rail miles?)

LUL Euston Square to Baker Street
Baker Street to Liverpool Street
Liverpool Street to Embankment (Circle Line)
Waterloo to Embankment (Bakerloo Line)
Embankment to Aldgate East
Aldgate East to Liverpool Street
Liverpool Street to Bethnal Green (Central Line)

(I presume there's rarely a difference between directions)
 
Last edited:

bb21

Emeritus Moderator
Joined
4 Feb 2010
Messages
24,449
Final bits for now. (is there another online resource for calculating rail miles?)

Sectional Appendices for National Rail and Working Timetables for LU, but the figures may differ from RMME slightly.

LUL Euston Square to Baker Street

Which line?

Baker Street to Liverpool Street

Which line?

Liverpool Street to Embankment (Circle Line)

2m 64ch

Waterloo to Embankment (Bakerloo Line)

24ch

Embankment to Aldgate East

2m 47ch

Aldgate East to Liverpool Street

46ch

Liverpool Street to Bethnal Green (Central Line)

(I presume there's rarely a difference between directions)

1m 33ch
 

CallySleeper

Established Member
Joined
27 Jun 2006
Messages
1,662
Location
trentbartonland
Sectional Appendices for National Rail and Working Timetables for LU, but the figures may differ from RMME slightly.

Case in point, the official measures:

LUL Euston Square to Baker Street H+C 76ch
Baker Street to Liverpool Street Circle 3m52ch
Liverpool Street to Embankment (Circle Line) 2m65ch
Waterloo to Embankment (Bakerloo Line) 35ch
Embankment to Aldgate East 2m49ch
Aldgate East to Liverpool Street 46ch
Liverpool Street to Bethnal Green (Central Line) 1m33ch
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
I have Aldgate East to Euston Square (H+C) down as 3m52ch is this correct?
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
Euston Square - Liverpool St is 2m56ch, plus the 46ch quoted above.

I got to having to take 31ch of and then only took 1ch off.
--- old post above --- --- new post below ---
Which now means I am up to a Grand Total of 663m 45ch
 

Crossforth

Established Member
Joined
20 Aug 2009
Messages
1,337
Location
Lancashire
I'm after:
Liverpool South Parkway (Low Level) to Moorfields
and
Liverpool South Parkway (High Level) to Mossley Hill
 

bb21

Emeritus Moderator
Joined
4 Feb 2010
Messages
24,449
South Parkway to Moorfields on Merseyrail is 6m 13ch
 

ainsworth74

Forum Staff
Staff Member
Global Moderator
Joined
16 Nov 2009
Messages
31,072
Location
Redcar
When RailMiles is back it's going to be so painful as I have so many journeys to check :(
 

Mojo

Forum Staff
Staff Member
Administrator
Joined
7 Aug 2005
Messages
21,170
Location
0035
Case in point, the official measures:

The "official measures" are all in km. Are these measures your translations into miles and chains from the official source, or do they come from another place?
 

Crossforth

Established Member
Joined
20 Aug 2009
Messages
1,337
Location
Lancashire
Mwhahahaha... I am top... well at least until RMME is up and running again and people can start calculating their mileages again properly :P
 

CallySleeper

Established Member
Joined
27 Jun 2006
Messages
1,662
Location
trentbartonland
The "official measures" are all in km. Are these measures your translations into miles and chains from the official source, or do they come from another place?

Taking the official source and using the standard m/ch conversion (x49.71).
 

crehld

Established Member
Joined
1 Nov 2014
Messages
1,994
Location
Norfolk
In the absence of RMME I've resorted to using milepost data from the Network Rail Sectional Appendix and a track atlas. On the one hand I've found this pretty interesting, but does present a challenge when trying to work out mileages of a journey. Mileposts can suddenly revert back to 0 (or something completely different). The fact miles and chains aren't decimal adds to the difficulties! So to help me work with this data I put together a spreadsheet. I'm sure there is an easier way to work this stuff out, but it does work.

Anyway, as there seem to be plenty of others in my situation asking for mileages here I thought it would be useful if I shared the spreadsheet to allow others to work with this data (if they so desire). I've included some very basic instructions and an example of how it works in practice.

Comments and suggestions (particularly if you spot a glaring error in the formulae) are welcome.
 

Attachments

  • MileageCalc.xlsx
    14.9 KB · Views: 18

CC 72100

Established Member
Joined
23 Jan 2012
Messages
3,850
Thanfully RealTimeTrains has the milages for the trains I used and from that I could work out a blank :)

1457 1/4 for me so far this year. Only slight issue is that over 600 of those miles were split across 3 voyagers :|
 

jnjkerbin

Member
Joined
25 Apr 2012
Messages
842
Location
Down south
After a February which turned out to be my best month for mileage ever (1371m 3ch, beating my previous record by about 4 1/2 miles) my yearly mileage has increased to at least 2304. (I say at least because some of the Brussels Metro Mileages are very big under approximations)
 

postye

Member
Joined
7 Feb 2013
Messages
898
Location
London
Just added up my February Mileage, a bumper 3047, largely down to having the time to take 2 Great Escapes, a Northern £10 rover, a couple of daytrips into Kent and a family trip to Liverpool.

I expect next month to drop very dramatically due to a severe lack of time for trips out.
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
Can I have the mileage for Stoke-on-Trent to Lowestoft via Derby, Nottingham, Ely and Norwich please
 

Techniquest

Veteran Member
Joined
19 Jun 2005
Messages
21,830
Location
Nowhere Heath
postye:2093279 said:
Just added up my February Mileage, a bumper 3047, largely down to having the time to take 2 Great Escapes, a Northern £10 rover, a couple of daytrips into Kent and a family trip to Liverpool.

I expect next month to drop very dramatically due to a severe lack of time for trips out.

Just means the rest of us have time to catch up now ;)
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
Can someone help me? My spreadsheet for calculating my rail miles seems to have broken, I used a template from the OP and made some changes to make it more suitable for me. I have attached it to this post, the problem is with the chains calculation. If anyone could help me fix this ASAP it would be greatly appreciated.
 

Attachments

  • Rail Mileage Spreadsheet 2015.xlsx
    58.6 KB · Views: 8

crehld

Established Member
Joined
1 Nov 2014
Messages
1,994
Location
Norfolk
Can someone help me? My spreadsheet for calculating my rail miles seems to have broken, I used a template from the OP and made some changes to make it more suitable for me. I have attached it to this post, the problem is with the chains calculation. If anyone could help me fix this ASAP it would be greatly appreciated.

Edit: Answered by bb21 below
 
Last edited:

bb21

Emeritus Moderator
Joined
4 Feb 2010
Messages
24,449
Assuming that you are using Excel. If you are using the OpenOffice package, it should be a similar process.

Right-click the cell, choose "Format Cells...", click on the "Number" tab, select "General", click on "OK".

Once done that, double-click the cell and press Enter again (ie. re-enter the formula). It should work now.

The problem is that you managed to somehow change the format of the cell to "Text", and that would show anything you entered as plain text rather than treating it as formula as appropriate.
 

Trainfan344

Established Member
Joined
13 Oct 2012
Messages
2,305
Assuming that you are using Excel. If you are using the OpenOffice package, it should be a similar process.

Right-click the cell, choose "Format Cells...", click on the "Number" tab, select "General", click on "OK".

Once done that, double-click the cell and press Enter again (ie. re-enter the formula). It should work now.

The problem is that you managed to somehow change the format of the cell to "Text", and that would show anything you entered as plain text rather than treating it as formula as appropriate.

Thanks, all sorted now!
--- old post above --- --- new post below ---
In need of the following Mileages:

Derby to Nottingham
Nottingham to Norwich via Ely
Norwich to Lowestoft
 
Status
Not open for further replies.

Top