I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!

Thanks,
David.

David FitzGerald wrote:

I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!

Thanks,
David.

This is also something I've wondered. I don't suppose it's published in
XML, CSV (anything!) anywhere?

It'd be quite nice to have this sort of thing available for unconnected
PDAs, smartphones etc.

I wonder who "owns" the information, the TOCs, National Rail etc?

"Dan Gravell" wrote in message
...


I wonder who "owns" the information, the TOCs, National Rail etc?

Try ATOC.

On 14 Apr 2004 06:20:32 -0700, David FitzGerald wrote:

I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!

Thanks,
David.

Have a look at:

http://persoenlicherfahrplan.bahn.de...ry-p2w.exe/en?

Won't do Excel, but will create PDF files, or files suitable to be read in
Palm Organisers. Don't be put off that it's a German site - works
beautifully for UK services & does connections, where needed too...


--


Adam

(Remove ".N*0*S*P*A*M" from email to reply!)...

Adam Jackson wrote:

Have a look at:

http://persoenlicherfahrplan.bahn.de...ry-p2w.exe/en?

Won't do Excel, but will create PDF files, or files suitable to be read in
Palm Organisers. Don't be put off that it's a German site - works
beautifully for UK services & does connections, where needed too...

This looks very promising. I used the J2ME version, specifying London to
Streatham. Unfortunately it assumed I meant Victoria rather than a
general query, which I suppose is unsurprising.

Will definitely play around with this when I have time later.

Dan

In message , David
FitzGerald writes

I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!

I don't know about the other TOCs, but SWT published its timetables in
PDF format:

http://www.swtrains.co.uk/traintimes/

--
Paul Terry

"David FitzGerald" wrote in message
om...
I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!


For those TOCs who publish timetables on their website in PDF format,
could you do a cut/paste from acrobat reader into Excel ?

Matt Wheeler wrote:
"David FitzGerald" wrote in message
om...
I've been asked to produce a series of Excel spreadsheets with
train timetable information for a number of National Rail (London
only) routes. Besides using the Network Rail journey planner and
manually typing/pasting them in, is there any way of getting this
information into Excel? It's getting a bit complicated and time
consuming!


For those TOCs who publish timetables on their website in PDF
format, could you do a cut/paste from acrobat reader into Excel ?

I tried with one of the SWT timetables. You can cut and paste, but the
content gets garbled extensively in the process. Even the Column Select
tool doesn't seem to be much use, as it ignores blank entries in the
column. Text Select does the same horizontally. Possibly a Visual Basic
program could be written to disentangle it, but it doesn't look at all
easy.
--
Richard J.
(to e-mail me, swap uk and yon in address)

I've been asked to produce a series of Excel spreadsheets with train
timetable information for a number of National Rail (London only)
routes. Besides using the Network Rail journey planner and manually
typing/pasting them in, is there any way of getting this information
into Excel? It's getting a bit complicated and time consuming!

Thanks,
David.

With trains which are at all regular there is the addition trick:

For a regular 15 minute interval, say, you could type something like:
=b2+(15/1440)
in cell c2, then cut and paste as required.

If a station is always, say, 3 minutes on from the previous one, you
could use:
=b2+(3/1440)
in cell b3, then cut and paste as required.

The important step is to set the number type in the cells to hh:mm,
then remember the colon as you enter each point!

With these things done, it's lighter work, but it's still a bit of a
challenge. If you like, e-mail me ) and I'll send you a
sample of a fantasy 2 hour period on the Midland Main Line I've
created for totally different purposes.

In message , Richard J.
writes

I tried with one of the SWT timetables. You can cut and paste, but the
content gets garbled extensively in the process. Even the Column Select
tool doesn't seem to be much use, as it ignores blank entries in the
column. Text Select does the same horizontally. Possibly a Visual Basic
program could be written to disentangle it, but it doesn't look at all
easy.

Surely it would be better to invest in one of the conversion utilities
available, given the extent of the job?

Able2Extract (A2E) is one of those that claims to convert from PDF to
Excel (I've not tried it myself):

http://www.investintech.com/able2extract.html

--
Paul Terry