{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MCA","Lists"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"MCA","index":0,"n_rows":37,"n_cols":11,"rows_kept":37,"merged":[[1,1,1,7],[2,4,2,8],[3,2,3,8],[4,6,4,7],[5,1,5,2],[5,3,7,3],[5,4,5,8],[5,10,7,10],[6,6,6,7],[7,1,7,2],[7,6,7,7],[8,1,8,2],[9,1,9,2],[9,6,9,7],[10,1,10,2],[10,6,10,7],[11,1,11,2],[11,6,11,7],[12,1,12,2],[12,6,12,7],[13,1,13,2],[13,6,13,7],[14,1,14,2],[14,6,14,7],[15,1,15,2],[15,6,15,7],[15,10,17,10],[16,1,16,2],[16,6,16,7],[17,1,17,2],[17,6,17,7],[18,1,18,2],[18,6,18,7],[19,1,19,2],[19,6,19,7],[20,1,20,2],[20,6,20,7],[21,1,21,2],[21,6,21,7],[22,1,22,2],[22,6,22,7],[23,1,23,2],[23,6,23,7],[24,1,24,2],[24,6,24,7],[25,1,25,2],[25,6,25,7],[26,1,26,2],[26,6,26,7],[27,1,27,2],[27,6,27,7],[28,1,28,2],[28,6,28,7],[29,1,29,2],[29,6,29,7],[30,1,30,2],[30,6,30,7],[31,1,31,2],[31,6,31,7],[32,1,32,2],[32,6,32,7],[33,1,33,2],[33,6,33,7],[34,1,34,2],[34,6,34,7],[35,1,35,2],[36,1,36,2]]}
[null,"Version of MCA:","User to enter…"]
[null,"Multi-criteria analysis template"]
[null,"Project name:","User to enter…","Problem/opportunity statement:","User to enter…"]
[null,"Do-minimum:","User to enter…"]
[]
[{"$nulls":3},"Do-minimum","Intervention types sourced from the intervention hierarchy (to be added or deleted as necessary)"]
[{"$nulls":4},"Integrated planning","Manage demand","Best use of existing system",null,"New infrastructure"]
[{"$nulls":4},"Name + identifier of alternative/option","Name + identifier of alternative/option","Name + identifier of alternative/option",null,"Name + identifier of alternative/option"]
[null,"Critical success factors: investment objectives"]
[null,"User to enter investment objectives…"]
[null,"User to enter investment objectives…"]
[null,"User to enter investment objectives…"]
[null,"User to enter investment objectives…"]
[null,"User to enter investment objectives…"]
[null,"Other critical success factors"]
[null,"Potential achievability ",{"$nulls":8},"Scoring system key\n(copy and paste cell)"]
[null,"    Technical "]
[null,"    Safety and design"]
[null,"    Consentability ",{"$nulls":8},"Add more points to the scale"]
[null,"Potential affordability ",{"$nulls":8},"Large positive (+ve)"]
[null,"Potential value for money",{"$nulls":8},"Moderate positive (+ve)"]
[null,"Supplier capacity and capability",{"$nulls":8},"Slight positive (+ve)"]
[null,"Scheduling/programming",{"$nulls":8},"Neutral"]
[null,"Opportunities and impacts (insert N/A if not relevant)",{"$nulls":8},"Slight negative (-ve)"]
[null,"Environmental effects",{"$nulls":8},"Moderate negative (-ve)"]
[null,"Social and cultural impacts",{"$nulls":8},"Large negative (-ve)"]
[null,"Climate change mitigation",{"$nulls":8},"Add more points to the scale"]
[null,"Climate change adaptation"]
[null,"Cumulative impacts"]
[null,"Impacts on te ao Māori"]
[null,"Property impacts"]
[null,"     Property acquisition"]
[null,"     Impact on properties"]
[null,"Project-specific impacts"]
[null,"Cost (not to be scored)"]
[null,"Comments/notes from discussion"]
[null,"Decision"]

{"sheet":"Lists","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"hidden":true}
["Healthy and safe people benefits",null,"Resilience and security benefits",null,"Economic Prosperity benefits",null,"Environmental sustainability benefits",null,"Inclusive access benefits"]
["1.1 Impact on social cost and incidents of crashes",null,"4.1 Impact on system vunerabilities and redundancies",null,"5.1 Impact on system reliability",null,"7.1 Impact on water",null,"10.1 Impact on user experience of the transport system"]
["1.2 Impact on a safe system",null,"Alternative benefit",null,"5.2 Impact on network productivity and utilisation",null,"7.2 Impact on land and biodiversity",null,"10.2 Impact on mode choice"]
["2.1 Impact on perceptions of safety and security",{"$nulls":3},"6.1 Wider economic benefit (productivity)",null,"8.1 Impact on greenhouse gas emissions",null,"10.3 Impact on access to opportunities"]
["3.1 Impact of mode on physical and mental health",{"$nulls":3},"6.2 Wider economic benefit (labour supply)",null,"9.1 Impact on resource efficiency",null,"10.4 Impact on community cohesion"]
["3.2 Impact of air emissions on health",{"$nulls":3},"6.3 Wider economic benefit (imperfect competition)",null,"Alternative benefit",null,"11.1 Impact on heritage and cultural values"]
["3.3 Impact of noises and vibration on health",{"$nulls":3},"6.4 Wider economic benefit (regional economic development)",{"$nulls":3},"11.2 Impact on landscape"]
["Alternative benefit",{"$nulls":3},"Alternative benefit",{"$nulls":3},"11.3 Impact on townscape"]
[{"$nulls":8},"12.1 Impact on Te Ao Maori"]
[{"$nulls":8},"Alternative benefit"]
[]
["Healthy and safe people measures",null,"Resilience and security benefits",null,"Economic Prosperity measures",null,"Environmental sustainability measures",null,"Inclusive access measures"]
["1.1.1 Collective risk (crash density)",null,"4.1.1 Availablity of a viable alternative to high-risk and high-impact route",null,"5.1.1 Punctuality - public transport",null,"7.1.1 Water quality",null,"10.1.1 People - throughput of pedestrians, cyclists and public transport boardings"]
["1.1.2 Crashes by severity",null,"4.1.2 Level of service and risk",null,"5.1.2 Travel time reliability - motor vehicles",null,"7.2.1 Biodiversity",null,"(Repeat) 2.1.1 Access - perception"]
["1.1.3 Deaths and serious injuries",{"$nulls":3},"5.1.3 Travel time delay",null,"7.2.2 Productive land",null,"10.1.2 Pedestrian delay"]
["1.1.4 Personal risk (crash rate)",{"$nulls":3},"5.1.4 Temporal availability - road",null,"8.1.1 CO2 emissions",null,"10.1.3 Ease of getting on/off public transport"]
["1.2.1 Road assessment rating - roads",{"$nulls":3},"5.2.1 Spatial coverage - freight",null,"8.1.2 Mode shift from single occupancy private vehicle",null,"10.1.4 Network condition - cycling"]
["1.2.2 Road assessment rating - state highways",{"$nulls":3},"5.2.2 Freight - mode share value",null,"9.1.1 Resource efficiency",null,"10.1.5 Network condition - road"]
["1.2.3 Travel speed gap",{"$nulls":3},"5.2.3 Freight - mode share weight",null,"9.1.2 Embodied carbon",null,"10.1.6 People - throughput"]
["2.1.1 Access - perception",{"$nulls":3},"5.2.4 Freight - throughput value",null,"9.1.3 Energy use",null,"10.1.7 People - throughput (UCP)"]
["3.1.1 Physical health benefits from active modes",{"$nulls":3},"5.2.5 Freight - throughput weight",{"$nulls":3},"10.1.8 Traffic - throughput"]
["3.2.1 Ambient air quality - NO2",{"$nulls":3},"5.2.6 Access to key economic destinations (all modes)",{"$nulls":3},"10.1.9 Travel time"]
["3.2.2 Ambient air quality - PM10",{"$nulls":7},"10.2.1 People - mode share"]
["3.3.1 Noise level",{"$nulls":7},"(Repeat) 8.1.2 Mode shift from single occupancy private vehicle"]
[{"$nulls":8},"10.2.2 Accessibility - public transport facilities"]
[{"$nulls":8},"10.2.3 Spatial coverage - cycle lanes and paths"]
[{"$nulls":8},"10.2.4 Spatial coverage - cycling facilities"]
[{"$nulls":8},"10.2.5 Spatial coverage - public transport - employees"]
[{"$nulls":8},"10.2.6 Spatial coverage - public transport - resident population"]
[{"$nulls":8},"10.2.6a Spatial coverage - public transport - new residential dwellings"]
[{"$nulls":8},"10.2.7 Temporal availability - public transport"]
[{"$nulls":8},"10.2.8 Cost of access to key destinations - all modes"]
[{"$nulls":8},"10.2.9 Pricing - more efficient"]
[{"$nulls":8},"10.2.10 Traffic - mode share (number)"]
[{"$nulls":8},"10.2.10b Traffic - mode share (distance)"]
[{"$nulls":8},"10.3.1 Access to key social destinations (all modes)"]
[{"$nulls":8},"10.4.1 Social connectedness"]
[{"$nulls":8},"10.4.2 Isolation"]
[{"$nulls":8},"10.4.3 Severance"]
[{"$nulls":8},"11.1.1 Amenity value - natural and built environment"]
[{"$nulls":8},"11.1.2 Heritage and cultural values"]
[{"$nulls":8},"11.2.1 Landscape"]
[{"$nulls":8},"11.3.1 Townscape"]