• Welcome to RAIL - Back On Track Forum.
 

SEQ Patronage Data 12/13 to 16/17 - updated files

Started by ozbob, September 03, 2018, 01:50:55 AM

Previous topic - Next topic

ozbob

Thanks to FF for setting up this spreadsheet file.

SEQ Bus - Ferry ODS file - with % diff from 12/13 to 16/17

A % column has been added to all the bus & ferry data to show the difference from FY 12/13 to FY 16/17 when valid.

Spreadsheet > https://backontrack.org/docs/rti/PTdata/bus_ferry12_13to16_17.ods

Notes:

Green = Increase in patronage

Pink = Decrease in patronage

Only done the difference for columns for 2012/13 and 2016/17 for consistency, as some are started later or finished earlier.

Manual editing was done to remove false calculation if the 2016/17 column was blank (returns -100.00% pink).  These have been manually deleted but is possible some remain, if any still remain just ignore.
Half baked projects, have long term consequences ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

ozbob

#1
Thanks to FF for these updated files FY 12/13 to FY 16/17

Percentages is gain/loss in patronage from FY 12/13 to FY 16/17

Overall SEQ rail patronage increased +1.99% over the 5 years, not keeping up with population growth which is around 1.3% per year on average ( 5 years ~=6.5% ).

SEQ Patronage Data updated xlsx > https://backontrack.org/docs/rti/PTdata/SEQPatronageDataSEQupdated.xlsx

SEQ Patronage Data Station Entrys sorted > https://backontrack.org/docs/rti/PTdata/SEQPatronageData_railSORTED.pdf 0.5MB
Half baked projects, have long term consequences ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

ozbob

Half baked projects, have long term consequences ...
Ozbob's Gallery Forum   Facebook  X  Threads  Mastodon  BlueSky

­čí▒ ­čí│