Auckland Harbour Bridge Shared Path : Economics Assessment Spreadsheet(s)

Darren Conway made this Official Information request to New Zealand Transport Agency

The request was successful.

From: Darren Conway

Dear New Zealand Transport Agency,

This is a request for the economic assessment spreadsheet(s) used to support the Auckland Harbour Bridge Shared Path SSBC Ver 4, 6 Jan 2020. In the context of this request, the economic assessment calculates the benefits and costs of the project in accordance with the superseded NZTA EEM manual or/and the NZTA Monetized Benefits and Cost manual.

In requesting the spreadsheet(s), I am seeking:
-the values used in the calculations
-the equations and formula applied and
-any notes and annotations.

pdf versions of the spreadsheet files will not satisfy this request.

This request includes any spreadsheet(s) or other files directly linked in the economics assessment spreadsheet. The purpose of this part of the request is to gain full visibility of all values and formulae used in the calculations of benefits and costs.

All worksheets and cells are expected to be unlocked and un-hidden.

Yours faithfully,

Darren Conway

Link to this

From: Official Correspondence
New Zealand Transport Agency


Attachment image001.png
12K Download


Kia ora Darren

 

This email acknowledges your below request for information made under the
Official Information Act 1982.

 

Your request has been forwarded to the appropriate section of Waka Kotahi
NZ Transport Agency for response. They will contact you if they require
clarification of your request, more time to respond, or if your request
has been transferred to another organisation to respond to. Unless more
time is required, Waka Kotahi will send a response to you within 20
working days of receiving your request – in this instance on or before
26^th August 2022.

 

As you will be aware, New Zealand is currently responding to the COVID-19
Omicron outbreak. As a result, resourcing may be impacted due to staff
absences, and the response to your Official Information Act request could
be delayed. We will endeavour to provide a response to you within the 20
day timeframe, or as soon as possible. In the meantime, we will keep you
informed of any changing timeframes. We apologise for any inconvenience
and appreciate your understanding.

 

Lastly, the information you have requested may contain the names and
contact details of our staff. Please let us know whether you require these
names and contact details. We may need to consult our staff before
deciding whether we can release this information, and this may take a bit
more time. If we do not hear from you we will assume that you do not
require staff names and contact details.

 

If you would like to discuss your request with Waka Kotahi, please contact
us by email at [1][NZTA request email].

 

Ngâ mihi

 

Ministerial Services
Te Waka Kôtuia | Engagement & Partnerships
Waka Kotahi NZ Transport Agency

[2]twitter | [3]youtube | [4]facebook

 

[5][IMG]

 

 

show quoted sections

Link to this

From: Official Correspondence
New Zealand Transport Agency


Attachment image001.png
12K Download

Attachment OIA 10653 Response.pdf
119K Download View as HTML

Attachment OIA 10653 attachment 1 AHBSP SSBC Economics 5.11.19.xlsx
7.1M Download View as HTML


Kia ora Darren

 

Please find attached the response to your request of 28^th June 2022 for
information under the Official Information Act 1982.

 

Ngā mihi

 

Ministerial Services
Te Waka Kōtuia | Engagement & Partnerships
Waka Kotahi NZ Transport Agency

[1]twitter | [2]youtube | [3]facebook

 

[4][IMG]

 

 

show quoted sections

Link to this

From: Darren Conway

Dear Official Correspondence,
Thank you for the information provided in response to my request. The spreadsheet partially satisfies the request.

My request included the statement: "This request includes any spreadsheet(s) or other files directly linked in the economics assessment spreadsheet."
On review, the spreadsheet includes direct links to the following documents:

EEM Worksheet 2019-04-10.xlsx located at: S:\NZTA\158 Skypath\7.0 Assessment\AHB Assessment
and
Tourist User Growth.xlsx located at S:\NZTA\158 SkyPath\7.0 Assessment

Please provide these documents to fully satisfy this request for information.

Yours sincerely,

Darren Conway

Link to this

From: Official Correspondence
New Zealand Transport Agency


Attachment image001.png
12K Download

Attachment OIA 10653 review of document response.pdf
121K Download View as HTML

Attachment OIA 10653 Tourist User Growth.xlsx
10K Download View as HTML


Kia ora Darren

 

Please find attached the response to your request of 26 August 2022 for
information under the Official Information Act 1982.

 

Ngā mihi

 

Ministerial Services
Te Waka Kōtuia | Engagement & Partnerships
Waka Kotahi NZ Transport Agency

[1]twitter | [2]youtube | [3]facebook

 

[4][IMG]

 

 

show quoted sections

Link to this

From: Darren Conway

Dear Official Correspondence,

Thank you for the Tourist Growth document.

I look forward to your delivery of the EEM Worksheet document.

Yours sincerely,

Darren Conway

Link to this

From: Official Correspondence
New Zealand Transport Agency


Attachment image001.png
12K Download


Kia ora Darren

 

Thank you for your email of 3 September 2022.

 

The Auckland Harbour Bridge Single Stage Business Case economic
spreadsheet that you have requested has been provided to you in our
response of 22 August 2022.

 

Ngā mihi

 

Ministerial Services
Te Waka Kōtuia | Engagement & Partnerships
Waka Kotahi NZ Transport Agency

[1]twitter | [2]youtube | [3]facebook

 

[4][IMG]

 

show quoted sections

Link to this

From: Darren Conway

Dear Official Correspondence,

This information request was for an economics analysis prepared in accordance with an obsolete NZTA standard for a project that has been officially cancelled. There should be no impediment under the Official Information Act to deliver the requested documents in full and without delay.

I repeat, my original request included the statement: "This request includes any spreadsheet(s) or other files directly linked in the economics assessment spreadsheet." The two links in the delivered spreadsheet precisely identified files and their locations on the NZTA network. Only one of the two identified files has been delivered.

The original request has not been modified and no clarification has been sought. No notice of time extension has been received. Delivery of the documents requested has exceeded the 20day limit. The request for the identified undelivered linked file remains extant.

Yours sincerely,

Darren Conway

Link to this

From: Official Correspondence
New Zealand Transport Agency


Attachment image001.png
12K Download

Attachment OIA 10653 further review of documents 20 September.pdf
115K Download View as HTML

Attachment OIA 10653 EEM Worksheet 2019 04 10.xlsx
97K Download View as HTML


Kia ora Darren

 

Please find attached the response to your request of 11 September 2022 for
information under the Official Information Act 1982.

 

Ngā mihi

 

Ministerial Services
Te Waka Kōtuia | Engagement & Partnerships
Waka Kotahi NZ Transport Agency

[1]twitter | [2]youtube | [3]facebook

 

[4][IMG]

 

 

show quoted sections

Link to this

Darren Conway left an annotation ()

A request was made for the spreadsheet that was the economic assessment of the costs and benefits of the Auckland Harbour Bridge Shared Path. This document is critical because it informed the Business Case that explored the feasibility, options, benefits and costs.

To the credit of NZTA, the spreadsheet was provided in full and without redactions in response to this request. In contrast, much of the important economic information derived from the spreadsheet and included in the business case was redacted at the time. This information was not made public before the project was officially terminated. As a result, the public were unable to accurately make their own assessment of the project because they did not have access to all of the information held by the NZTA.

The foundation of a business case is the economic analysis of costs and benefits. In my experience a well written business case is able to withstand critical review if it is based on sound economics, technical analysis, and logic. The economic analysis is a very important document that should always be published in full to support the associated business case.

Link to this

Things to do with this request

Anyone:
New Zealand Transport Agency only: