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
From: Official Correspondence
New Zealand Transport Agency
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]
-----Original Message-----
From: Darren Conway <[FOI #20066 email]>
Sent: Thursday, 28 July 2022 10:39 pm
To: Official Correspondence <[email address]>
Subject: Official Information request - Auckland Harbour Bridge Shared
Path : Economics Assessment Spreadsheet(s)
CAUTION: The sender of this email is from outside Waka Kotahi. Do not
click links, attachments, or reply unless you recognise the sender’s email
address and know the content is safe.
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
-------------------------------------------------------------------
This is an Official Information request made via the FYI website.
Please use this email address for all replies to this request:
[6][FOI #20066 email]
Is [7][NZTA request email] the wrong address for Official
Information requests to New Zealand Transport Agency? If so, please
contact us using this form:
[8]https://aus01.safelinks.protection.outlo...
Disclaimer: This message and any reply that you make will be published on
the internet. Our privacy and copyright policies:
[9]https://aus01.safelinks.protection.outlo...
If you find this service useful as an Official Information officer, please
ask your web manager to link to us from your organisation's OIA or LGOIMA
page.
-------------------------------------------------------------------
This message, together with any attachments, may contain information that
is classified and/or subject to legal privilege. Any classification
markings must be adhered to. If you are not the intended recipient, you
must not peruse, disclose, disseminate, copy or use the message in any
way. If you have received this message in error, please notify us
immediately by return email and then destroy the original message. This
communication may be accessed or retained by Waka Kotahi NZ Transport
Agency for information assurance purposes.
References
Visible links
1. mailto:[NZTA request email]
2. https://aus01.safelinks.protection.outlo...
3. https://aus01.safelinks.protection.outlo...
4. https://aus01.safelinks.protection.outlo...
5. https://aus01.safelinks.protection.outlo...
6. mailto:[FOI #20066 email]
7. mailto:[NZTA request email]
8. https://aus01.safelinks.protection.outlo...
9. https://aus01.safelinks.protection.outlo...
hide quoted sections
From: Official Correspondence
New Zealand Transport Agency
image001.png
12K
Download
OIA 10653 Response.pdf
119K
Download
View as HTML
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]
-----Original Message-----
From: Darren Conway <[5][FOI #20066 email]>
Sent: Thursday, 28 July 2022 10:39 PM
To: Official Correspondence <[6][email address]>
Subject: Official Information request - Auckland Harbour Bridge Shared
Path : Economics Assessment Spreadsheet(s)
CAUTION: The sender of this email is from outside Waka Kotahi. Do not
click links, attachments, or reply unless you recognise the sender’s email
address and know the content is safe.
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
-------------------------------------------------------------------
This is an Official Information request made via the FYI website.
Please use this email address for all replies to this request:
[7][FOI #20066 email]
Is [8][NZTA request email] the wrong address for Official
Information requests to New Zealand Transport Agency? If so, please
contact us using this form:
[9]https://aus01.safelinks.protection.outlo...
Disclaimer: This message and any reply that you make will be published on
the internet. Our privacy and copyright policies:
[10]https://aus01.safelinks.protection.outlo...
If you find this service useful as an Official Information officer, please
ask your web manager to link to us from your organisation's OIA or LGOIMA
page.
-------------------------------------------------------------------
This message, together with any attachments, may contain information that
is classified and/or subject to legal privilege. Any classification
markings must be adhered to. If you are not the intended recipient, you
must not peruse, disclose, disseminate, copy or use the message in any
way. If you have received this message in error, please notify us
immediately by return email and then destroy the original message. This
communication may be accessed or retained by Waka Kotahi NZ Transport
Agency for information assurance purposes.
References
Visible links
1. https://aus01.safelinks.protection.outlo...
2. https://aus01.safelinks.protection.outlo...
3. https://aus01.safelinks.protection.outlo...
4. https://aus01.safelinks.protection.outlo...
5. mailto:[FOI #20066 email]
6. mailto:[email address]
7. mailto:[FOI #20066 email]
8. mailto:[NZTA request email]
9. https://aus01.safelinks.protection.outlo...
10. https://aus01.safelinks.protection.outlo...
hide quoted sections
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
From: Official Correspondence
New Zealand Transport Agency
image001.png
12K
Download
OIA 10653 review of document response.pdf
121K
Download
View as HTML
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]
-----Original Message-----
From: Darren Conway <[5][FOI #20066 email]>
Sent: Friday, 26 August 2022 1:52 pm
To: Official Correspondence <[6][email address]>
Subject: Re: OIA-10653 RESPONSE
CAUTION: The sender of this email is from outside Waka Kotahi. Do not
click links, attachments, or reply unless you recognise the sender’s email
address and know the content is safe.
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
-----Original Message-----
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]
-------------------------------------------------------------------
Please use this email address for all replies to this request:
[7][FOI #20066 email]
Disclaimer: This message and any reply that you make will be published on
the internet. Our privacy and copyright policies:
[8]https://aus01.safelinks.protection.outlo...
If you find this service useful as an Official Information officer, please
ask your web manager to link to us from your organisation's OIA or LGOIMA
page.
-------------------------------------------------------------------
This message, together with any attachments, may contain information that
is classified and/or subject to legal privilege. Any classification
markings must be adhered to. If you are not the intended recipient, you
must not peruse, disclose, disseminate, copy or use the message in any
way. If you have received this message in error, please notify us
immediately by return email and then destroy the original message. This
communication may be accessed or retained by Waka Kotahi NZ Transport
Agency for information assurance purposes.
References
Visible links
1. https://aus01.safelinks.protection.outlo...
2. https://aus01.safelinks.protection.outlo...
3. https://aus01.safelinks.protection.outlo...
4. https://aus01.safelinks.protection.outlo...
5. mailto:[FOI #20066 email]
6. mailto:[email address]
7. mailto:[FOI #20066 email]
8. https://aus01.safelinks.protection.outlo...
hide quoted sections
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
From: Official Correspondence
New Zealand Transport Agency
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]
-----Original Message-----
From: Darren Conway <[5][FOI #20066 email]>
Sent: Saturday, 3 September 2022 8:19 pm
To: Official Correspondence <[6][email address]>
Subject: Re: OIA-10653 RESPONSE
CAUTION: The sender of this email is from outside Waka Kotahi. Do not
click links, attachments, or reply unless you recognise the sender’s email
address and know the content is safe.
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
-----Original Message-----
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]
-------------------------------------------------------------------
Please use this email address for all replies to this request:
[7][FOI #20066 email]
Disclaimer: This message and any reply that you make will be published on
the internet. Our privacy and copyright policies:
[8]https://aus01.safelinks.protection.outlo...
If you find this service useful as an Official Information officer, please
ask your web manager to link to us from your organisation's OIA or LGOIMA
page.
-------------------------------------------------------------------
This message, together with any attachments, may contain information that
is classified and/or subject to legal privilege. Any classification
markings must be adhered to. If you are not the intended recipient, you
must not peruse, disclose, disseminate, copy or use the message in any
way. If you have received this message in error, please notify us
immediately by return email and then destroy the original message. This
communication may be accessed or retained by Waka Kotahi NZ Transport
Agency for information assurance purposes.
References
Visible links
1. https://aus01.safelinks.protection.outlo...
2. https://aus01.safelinks.protection.outlo...
3. https://aus01.safelinks.protection.outlo...
4. https://aus01.safelinks.protection.outlo...
5. mailto:[FOI #20066 email]
6. mailto:[email address]
7. mailto:[FOI #20066 email]
8. https://aus01.safelinks.protection.outlo...
hide quoted sections
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
From: Official Correspondence
New Zealand Transport Agency
image001.png
12K
Download
OIA 10653 further review of documents 20 September.pdf
115K
Download
View as HTML
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]
-----Original Message-----
From: Darren Conway <[5][FOI #20066 email]>
Sent: Sunday, 11 September 2022 10:46 pm
To: Official Correspondence <[6][email address]>
Subject: Re: FW: OIA-10653 RESPONSE
CAUTION: The sender of this email is from outside Waka Kotahi. Do not
click links, attachments, or reply unless you recognise the sender’s email
address and know the content is safe.
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
-----Original Message-----
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]
-------------------------------------------------------------------
Please use this email address for all replies to this request:
[7][FOI #20066 email]
Disclaimer: This message and any reply that you make will be published on
the internet. Our privacy and copyright policies:
[8]https://aus01.safelinks.protection.outlo...
If you find this service useful as an Official Information officer, please
ask your web manager to link to us from your organisation's OIA or LGOIMA
page.
-------------------------------------------------------------------
This message, together with any attachments, may contain information that
is classified and/or subject to legal privilege. Any classification
markings must be adhered to. If you are not the intended recipient, you
must not peruse, disclose, disseminate, copy or use the message in any
way. If you have received this message in error, please notify us
immediately by return email and then destroy the original message. This
communication may be accessed or retained by Waka Kotahi NZ Transport
Agency for information assurance purposes.
References
Visible links
1. https://aus01.safelinks.protection.outlo...
2. https://aus01.safelinks.protection.outlo...
3. https://aus01.safelinks.protection.outlo...
4. https://aus01.safelinks.protection.outlo...
5. mailto:[FOI #20066 email]
6. mailto:[email address]
7. mailto:[FOI #20066 email]
8. https://aus01.safelinks.protection.outlo...
hide quoted sections
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
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