• Advertisement

Timetable project of mine

WA Timetable and Service Changes

Moderators: MTT384, perthbus

Timetable project of mine

Postby busdriver12 » Fri Feb 18, 2011 7:33 am

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
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby Mr OC Benz » Fri Feb 18, 2011 6:47 pm

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...
Worldwide Transport Spotters Rapid Response Unit
(Photographing transport for future historical reference)

WA Mercedes-Benz Omnibus Society
https://www.facebook.com/groups/WAMBOS/
User avatar
Mr OC Benz
Moderator
 
Posts: 4918
Joined: Sat Jun 06, 2009 12:18 pm
Location: Sydney, NSW
Has thanked: 383 times
Been thanked: 792 times
Favourite Vehicle: Anything German

Re: Timetable project of mine

Postby busdriver12 » Sun Feb 20, 2011 10:14 pm

Amended to reflect changes week commencing 20/2/11

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

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby Stig! » Mon Feb 21, 2011 11:10 am

Its perfect Phil!
Some say....he is a fat bastard

All we know is, he's called the Stig!
User avatar
Stig!
 
Posts: 4207
Joined: Fri Oct 13, 2006 3:43 pm
Location: Woodvale Western Australia
Has thanked: 765 times
Been thanked: 158 times

Re: Timetable project of mine

Postby busdriver12 » Mon Feb 21, 2011 11:04 pm

ADX666 wrote: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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby Stig! » Tue Feb 22, 2011 2:58 pm

No worries Phil, this would be something I would love to have the talent to do...oh and the time!
Some say....he is a fat bastard

All we know is, he's called the Stig!
User avatar
Stig!
 
Posts: 4207
Joined: Fri Oct 13, 2006 3:43 pm
Location: Woodvale Western Australia
Has thanked: 765 times
Been thanked: 158 times

Excel Timetable Spreadsheet

Postby <smarTTrams> » Wed Feb 23, 2011 7:40 pm

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>
User avatar
<smarTTrams>
 
Posts: 2148
Joined: Sat Mar 06, 2004 12:28 am
Location: Capital of Australia's Western Third Avatar: Train Pictogram
Has thanked: 0 time
Been thanked: 1 time

Re: Excel Timetable Spreadsheet

Postby busdriver12 » Wed Feb 23, 2011 10:20 pm

<smarTTrams> wrote: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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby <smarTTrams> » Thu Feb 24, 2011 9:36 am

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>
User avatar
<smarTTrams>
 
Posts: 2148
Joined: Sat Mar 06, 2004 12:28 am
Location: Capital of Australia's Western Third Avatar: Train Pictogram
Has thanked: 0 time
Been thanked: 1 time

Re: Timetable project of mine

Postby busdriver12 » Mon Feb 28, 2011 8:11 am

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

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

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Sun May 29, 2011 8:06 pm

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

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

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby Stig! » Sat Jun 11, 2011 8:02 pm

Still a fantastic project Phil, thanks for the updates!
Some say....he is a fat bastard

All we know is, he's called the Stig!
User avatar
Stig!
 
Posts: 4207
Joined: Fri Oct 13, 2006 3:43 pm
Location: Woodvale Western Australia
Has thanked: 765 times
Been thanked: 158 times

Re: Timetable project of mine

Postby busdriver12 » Sat Jun 11, 2011 8:19 pm

ADX666 wrote: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. :)
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Sun Jul 31, 2011 11:45 pm

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. :)
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Sat Aug 20, 2011 11:28 am

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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Mon Oct 03, 2011 7:08 pm

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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby Q4004 » Sat Oct 08, 2011 12:35 pm

These are very interesting things you have done BD12
Mercedes Diesel less again :(
User avatar
Q4004
 
Posts: 1562
Joined: Mon Jul 20, 2009 12:35 pm
Location: Swan Transit Beckenham/Canning Vale Contract Area (Thornlie) and Claisebrook Depot
Has thanked: 128 times
Been thanked: 78 times
Favourite Vehicle: TP's 1149 1511 1521 1559 1565

Re: Timetable project of mine

Postby Ade » Tue Oct 25, 2011 9:31 pm

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.
User avatar
Ade
 
Posts: 206
Joined: Fri Jan 27, 2006 6:06 pm
Location: Island Sentosa
Has thanked: 0 time
Been thanked: 1 time

Re: Timetable project of mine

Postby busdriver12 » Tue Oct 25, 2011 10:27 pm

Ade wrote: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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby jonwil » Tue Oct 25, 2011 11:54 pm

Ade wrote: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"
jonwil
 
Posts: 907
Joined: Mon Mar 23, 2009 11:54 am
Has thanked: 0 time
Been thanked: 25 times

Re: Timetable project of mine

Postby Ade » Wed Oct 26, 2011 7:43 pm

I don't have an ipad
User avatar
Ade
 
Posts: 206
Joined: Fri Jan 27, 2006 6:06 pm
Location: Island Sentosa
Has thanked: 0 time
Been thanked: 1 time

Timetable project of mine

Postby busdriver12 » Sun Nov 13, 2011 11:32 am

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.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Sun Nov 13, 2011 1:37 pm

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

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Fri Dec 30, 2011 7:00 pm

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. :)
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Re: Timetable project of mine

Postby busdriver12 » Thu Jan 19, 2012 6:43 pm

busdriver12 wrote: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) in the past, but this has now reverted back to Veolia's hands.
Last edited by busdriver12 on Sun Sep 08, 2013 10:27 pm, edited 3 times in total.
Phil

My timetable info can be found here. Current as at 2/3/14. Current route/contract info can be found here

All views expressed are strictly my own and do not represent my employer or anyone else.
User avatar
busdriver12
 
Posts: 1870
Joined: Sat Dec 31, 2005 3:32 pm
Location: Byford WA
Has thanked: 26 times
Been thanked: 86 times

Next

Return to WA Timetable News

Who is online

Users browsing this forum: No registered users and 1 guest