Printed from https://fyi.org.nz/request/2922-request-for-source-spreadsheet-used-in-at-calculations-of-pt-subsidy-per-passenger-kilometre-by-mode on December 27, 2024 00:31

Request for source spreadsheet used in AT Calculations of PT Subsidy per Passenger Kilometre by Mode

Tony Randle made this Official Information request to Auckland Transport

The request was refused by Auckland Transport.

From: Tony Randle

Dear Auckland Transport,

On the 21st of May I received the Auckland Transport substantive response to my "Request for AT Calculations of PT Subsidy per Passenger Kilometre by Mode" (CAS-581775-Z4G1T2).

While the requested spreadsheet does contain the source figures to the Charts used in the AT report referred to in my original request, it does not have any of the calculations. The source figures for the monthly per passenger subsidies are listed in the table A1:F39 but the calculations I seek to understand how these figures were calculated were not provided.

1) Can I please have a copy of the source spreadsheet from which the figures in the table A1:F39 on the "Subsidy" worksheet of the provided spreadsheet were calculated ?

2) I also note that the provided spreadsheet does refer to another spreadsheet called with the filename of "201504_PT Commercial Charts for Indicators Report - Hard Coded April.xlsx" that is located at Auckland Transport in the folder URL "teams.at.govt.nz/sites/PTCommercial/BusinessReportingLead/AT - Monthly Reporting/".

Could I please have a copy of the spreadhseet "201504_PT Commercial Charts for Indicators Report - Hard Coded April.xlsx" as outlined above ?

In both cases, I would prefer Auckland Transport provide a copy of the complete original, spreadsheet in its original electronic format. I wish to be informed on any editing of the provided information including the reason for this editing.

Can you please acknowldge your receipt of this information request ?

Yours faithfully,

Tony Randle

Link to this

From: CustomerLiaison (AT)

Attachment image001.jpg
7K Download

Attachment Case Acknowledgment CAS 41424 X2S7F2.pdf
43K Download View as HTML

Dear Tony

 

Thank you for your request for information regarding AT Calculations of PT
Subsidy per passenger kilometre by mode.

 

Please find attached an acknowledgement 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/

Link to this

From: CustomerLiaison (AT)

Attachment image001.jpg
7K Download

Attachment Final Response CAS 41424 X2S7F2.pdf
46K Download View as HTML

Dear Tony

 

Thank you for your request for information regarding AT Calculations of PT
Subsidy per passenger kilometre by mode.

 

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

 

 

                                                                                                                                                                                                                                                        

[3]Logo

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/
3. https://at.govt.nz/projects-roadworks/ci...

Link to this

Things to do with this request

Anyone:
Auckland Transport only: