Timetable project of mine

[busdriver12]

Not too sure where this one belongs, so here is better than anywhere else.

Some of you may be aware that I have over the years, been compiling a complete break down of Transperth timetables in an MS Excel spreadsheet. This is an on-going project and I have been doing it for over 10 years now. I began collecting .pdf's of timetables not long after they became available in the early 2000's and found very quickly I needed a way of keeping track of what was going on, and a spreadsheet was an ideal tool for doing so. As I have dabbled in programming over the years it provided an ideal project to create which tied in nicely with an interest of mine. My interest in public transport is in the operations of it as opposed to what you need to operate it - the software of the system if you will. This is why I worked in the operations area at Path Transit whilst I was there.

Anyway, I hope you find it useful. If you have any comments please feel free to PM or email me but bear in mind I am sharing it so any comments about the colours used, style etc will generally be ignored as it is done for my consumption. Most of the cells in the workbook are commented which contains information such as who operates the service, route descriptions, history of timetable changes etc. The link to it I have included in my sig but the link for it is:

http://www.mediafire.com/?n3ylbelg4njaijv

[Mr OC Benz]

Good stuff, I generally have the interest in both parts although when I did first getting started into it, I mainly collected timetables etc... Back then we didn't have the internet at my house...

[busdriver12]

Amended to reflect changes week commencing 20/2/11

http://www.mediafire.com/?uss3taq0p3knpe6

[ADX666]

Its perfect Phil!

[busdriver12]

Its perfect Phil!

Tnx Joe.

Hope everyone who has downloaded it finds it as useful as I do. I'll keep posting updates here as they are uploaded.

[ADX666]

No worries Phil, this would be something I would love to have the talent to do...oh and the time!

[<smarTTrams>]

Your timetable project uses Microsoft Office Excel, busdriver12, and from what I've looked at so far, it does just that -- it excels!

I'm looking forward to exploring it more fully soon.

<smarTTrams> ... coming or going ... <smarTTrams>

[busdriver12]

Your timetable project uses Microsoft Office Excel, busdriver12, and from what I've looked at so far, it does just that -- it excels!

I'm looking forward to exploring it more fully soon.

Many thanks

I've done it in Excel 2010 but saved it in 2003/2007 format so that most people will be able to view it.

[<smarTTrams>]

Good thinking, busdriver12! I must admit that, with only the 2003 version of Excel, when I clicked on the link I was mentally preparing myself for an error message to come up: 'Computer says NO'!

<smarTTrams>

[busdriver12]

Latest update (WC 27/2/11) can be found here:

http://www.mediafire.com/?bc61w6gb49a11cm

[busdriver12]

Latest update (WC 29/5/11) can be found here:

http://www.mediafire.com/?1dh1i1m2pqbovmd

[ADX666]

Still a fantastic project Phil, thanks for the updates!

[busdriver12]

Still a fantastic project Phil, thanks for the updates!

Thanks Joe. It's been almost 10 years in the making as it's been slowly added to over that period of time. I've added a tab called Changes which documents what's changed since the last version. Saves you sifting through it to see where those changes are.

[busdriver12]

Latest update (WC 31/7/11) can be found here:

http://www.mediafire.com/?oq49xii7m1zr9ai

There's also a link to it in my sig. I don't think I've mentioned it previously, but I've added a tab entitled Changes which logs all the changes made so you don't have to trawl through the entire workbook to find them.

[busdriver12]

Latest update (14/8/11) can be found here:

http://www.mediafire.com/?gej1loi5nbdx2rp

All the changes made can be found in the changes tab.

[busdriver12]

Latest update (18/9/11) can be found here:

http://www.mediafire.com/?4ipaj1se3cy5pc1

All the changes made can be found in the changes tab.

[Q4004]

These are very interesting things you have done BD12

[Ade]

Would be nice to have a Android, Iphone, WP7 Transperth app which you can fire up to get latest info, live times, and timetable info.

[busdriver12]

Would be nice to have a Android, Iphone, WP7 Transperth app which you can fire up to get latest info, live times, and timetable info.

Have a look at http://www.transperth.wa.gov.au/Timetab ... ables.aspx or 136213.mobi on your mobile.

[jonwil]

Would be nice to have a Android, Iphone, WP7 Transperth app which you can fire up to get latest info, live times, and timetable info.

One of the things I would like to do if I ever get the time/skills/interest is to take the data from http://www.transperth.wa.gov.au/Timetab ... ccess.aspx and write a mapping/routing application on my Nokia N900.
Something that could provide mapping and routing and "buses comming to this stop" and other information.
So it could give me full directions from point A to point B by saying "follow this line from where you are to this bus stop, then wait for this bus, get off here, get on this other bus, get off here, then follow this other line to get to where you want to go"

[Ade]

I don't have an ipad

[busdriver12]

Latest update (13/11/11) can be found here:

http://www.mediafire.com/?55jl5jy55rkrhuw

All the changes made can be found in the changes tab. These include the northern suburbs changes from 6/11/11.

[busdriver12]

For those that are wondering, I had this thread moved here as I thought it a more appropriate place to live

[busdriver12]

The latest update (18/12/11) can be found here

A little late getting this one up as spare time has been of a premium of late.

A couple of things I noticed when trawling through these timetables is that the comment line number 131608 has been removed. Also, reference to Swan Transit (operator of Route 104) has been omitted from timetable W36

EDIT:

I've made a few minor amendments due to errors and omissions. The link above (and in my sig) has been updated. Thanks to Cat for bringing them to my attention.

[busdriver12]

Also, reference to Swan Transit (operator of Route 104) has been omitted from timetable W36

I did a little digging around before I went on holidays last week and found out the 104 is part of the Fremantle Contract. For some reason, Swan has been assigned this route (also it's predecessor 709[color=#0000FF]) in the past, but this has now reverted back to Veolia's hands.