Request for AT Calculations of PT Subsidy per Passenger Kilometre by Mode
Tony Randle made this Official Information request to Auckland Transport
The request was partially successful.
From: Tony Randle
Dear Auckland Transport,
I note that Auckland Transport (AT) publishes a monthly "Transport Indicators Report" (URL for March 2015 Report: https://at.govt.nz/media/1070168/Item-11...).
The Transport Indicators Report includes a chart labelled "PT Subsidy per Passenger Kilometre" for ferry, rail, bus, total and SOI Target since June 2013 with the support note stating:
"PT Subsidy per Passenger Km - the net subsidy per passenger km is calculated by dividing the cost (less fare revenue) of providing PT services by the distance travelled by all passengers. Total PT subsidy per passenger km in February 2015 was $0.29.
Source: PT Ops"
Could I please have a copy of the detailed calculations used to create this chart for the most recently published report ?
I assume this information is calculated by electronic means (i.e. in a spreadsheet) and so I would prefer AT provided this information in its complete and original electronic format.
Finally, can you please acknowledge the receipt of this information request ?
Regards
Tony Randle
Yours faithfully,
Tony Randle
From: CustomerLiaison (AT)
image001.jpg
7K
Download
Final Response CAS 581775 Z4G1T2.pdf
53K
Download
View as HTML
Data PT Subsidy per Passenger km.pdf
98K
Download
View as HTML
Dear Tony
Thank you for your request for calculations used to create a chart
labelled PT Subsidy per Passenger Kilometre" for ferry, rail, bus, total
and SOI Target since June 2013.
Please find attached a response for information requested under the Local
Government Official Information and Meetings Act 1987.
Kind regards
Natasha Walker | Customer Liaison Advisor [2]Description: Description:
6 Henderson Valley Road, Henderson, Waitakere Description: Description:
0612 Description: Description:
Description: Description:
Private Bag 92250, Auckland 1142 Description: Description:
Description: Email-Signature
Phone 09 366 6400 F 09 355 3550
[1]www.aucklandtransport.govt.nz
WARNING This email may contain information which is CONFIDENTIAL and may
be subject to LEGAL PRIVILEGE. If you are not the intended recipient, you
must not peruse, use, disseminate, distribute or copy this email or
attachments. If you have received this in error, please notify us
immediately by return email, facsimile or telephone (call us collect) and
delete this email. Thank you. Phone: +64 9 355 3553 or Fax: +64 9 355
3550. AUCKLAND TRANSPORT ACCEPTS NO RESPONSIBILITY FOR CHANGES MADE TO
THIS EMAIL OR TO ANY ATTACHMENTS AFTER TRANSMISSION FROM AUCKLAND
TRANSPORT. Nothing in this email designates an information system for the
purposes of section 11(a) of the New Zealand Electronic Transaction Act
2002, unless expressly stated otherwise.
References
Visible links
1. http://www.aucklandtransport.govt.nz/
From: Tony Randle
Dear CustomerLiaison (AT),
Thank you for your reply to my information request (Your reference CAS-581775-Z4G1T2).
While provision of the data used to calculate the PT subsidy per passenger is useful, I also asked for a copy of the calculations so that I may understand how the data is processed. I would assume, at least, that AT utilises some form of expenditure divided by passenger numbers as the basis for it’s per passenger calculation. It is for this reason that my information request specifically stated:
"I assume this information is calculated by electronic means (i.e. in a spreadsheet) and so I would prefer AT provided this information in its complete and original electronic format."
The data provided in PDF format does not include the requested calculation information and it does not appear that AT has provided the "information in its complete and original electronic format" as originally requested.
Can AT please provide the requested information in the original electronic format as requested so that I may understand how the per passenger PT subsidy calculations were made ?
Yours sincerely,
Tony Randle
From: CustomerLiaison (AT)
Dear Tony
Thank you for your response.
Please find attached the excel spreadsheet in regards to the requested
calculation information.
Kind regards
Natasha Walker | Customer Liaison Advisor [2]Description: Description:
6 Henderson Valley Road, Henderson, Waitakere Description: Description:
0612 Description: Description:
Description: Description:
Private Bag 92250, Auckland 1142 Description: Description:
Description: Email-Signature
Phone 09 366 6400 F 09 355 3550
[1]www.aucklandtransport.govt.nz
WARNING This email may contain information which is CONFIDENTIAL and may
be subject to LEGAL PRIVILEGE. If you are not the intended recipient, you
must not peruse, use, disseminate, distribute or copy this email or
attachments. If you have received this in error, please notify us
immediately by return email, facsimile or telephone (call us collect) and
delete this email. Thank you. Phone: +64 9 355 3553 or Fax: +64 9 355
3550. AUCKLAND TRANSPORT ACCEPTS NO RESPONSIBILITY FOR CHANGES MADE TO
THIS EMAIL OR TO ANY ATTACHMENTS AFTER TRANSMISSION FROM AUCKLAND
TRANSPORT. Nothing in this email designates an information system for the
purposes of section 11(a) of the New Zealand Electronic Transaction Act
2002, unless expressly stated otherwise.
References
Visible links
1. http://www.aucklandtransport.govt.nz/
Things to do with this request
- Add an annotation (to help the requester or others)
- Download a zip file of all correspondence
Offensive? Unsuitable?
Requests for personal information and vexatious requests are not considered valid requests for Official Information (read more).
If you believe this request is not suitable, you can report it for attention by the site administrators
Report this request
Tony Randle left an annotation ()
Although Auckland Transport did provide an original Spreadsheet with the figures, it does not conatin any supporting source data and does not have any formula calculations which is unexpected.
It appears that they calculated the PT Subsidy per passenger km by mode figures in another spreadsheet and then saved/edited it to the spreadsheet provided. It is unclear whether this spreadsheet was also used to provide the charts.
I will raise another request.
Link to this