{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PVEOL form p1","Sheet1"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PVEOL form p1","index":0,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":false,"merged":[[45,0,45,11],[50,2,50,4],[48,0,48,1],[49,0,49,1],[12,3,12,11],[65,0,65,11],[66,0,66,11],[67,0,67,11],[47,2,47,4],[47,0,47,1],[71,9,71,11],[68,2,68,3],[69,2,69,3],[68,5,68,7],[69,5,69,7],[51,0,51,4],[53,0,53,11],[55,0,55,1],[55,2,55,4],[56,0,56,1],[56,2,56,4],[47,8,47,11],[1,4,1,7],[2,8,2,9],[4,0,4,1],[1,10,1,11],[7,2,7,3],[7,0,7,1],[35,0,35,11],[43,0,43,11],[34,0,34,11],[2,4,2,7],[3,0,3,3],[8,4,8,7],[7,4,7,7],[6,4,6,7],[5,4,5,7],[4,4,4,7],[0,8,0,11],[73,0,73,1],[70,0,70,11],[68,0,68,1],[69,0,69,1],[71,0,71,1],[72,2,72,11],[72,0,72,1],[73,2,73,11],[68,9,68,11],[69,9,69,11],[71,2,71,3],[71,5,71,7],[0,0,0,3],[0,4,0,7],[1,8,1,9],[2,10,2,11],[3,9,3,11],[3,4,3,7],[4,9,10,11],[8,0,8,1],[8,2,8,3],[10,0,10,1],[10,2,10,3],[9,2,9,3],[9,0,9,1],[10,4,10,7],[9,4,9,7],[5,0,5,1],[6,0,6,1],[5,2,5,3],[6,2,6,3],[4,2,4,3],[27,2,27,6],[27,7,27,11],[28,0,33,1],[28,2,28,6],[28,7,33,11],[29,2,29,4],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[20,2,20,6],[22,2,22,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[20,7,20,11],[21,0,26,1],[21,2,21,6],[21,7,26,11],[11,3,11,6],[11,7,11,11],[14,2,14,6],[13,2,13,6],[13,7,13,11],[15,2,15,4],[14,0,19,1],[14,7,19,11],[16,2,16,4],[17,2,17,4],[18,2,18,4],[12,0,12,2],[19,2,19,4],[50,0,50,1],[48,2,48,4],[49,2,49,4],[57,0,57,1],[57,2,57,4],[62,0,62,1],[62,2,62,4],[63,0,63,4],[58,0,58,1],[58,2,58,4],[59,0,59,1],[59,2,59,4],[60,0,60,1],[60,2,60,4],[61,0,61,1],[61,2,61,4],[37,8,37,11],[37,0,37,3],[37,4,37,7],[38,0,38,1],[38,2,38,3],[38,4,41,7],[39,0,39,1],[39,2,39,3],[40,0,40,1],[40,2,40,3],[41,0,41,1],[41,2,41,3]]}
[null,null,null,null,"Preliminary\nPresent Value End of Life (PVEOL)\nAnalysis"]
["Network area:","Highway:","RP:","BSN:","Structure name: ",null,null,null,"Owner:",null,"NZ Transport Agency"]
["East Waikato",25,172,1720,"PEPE STREAM BRIDGE",null,null,null,"RCA:",null,"NZ Transport Agency"]
["General Structure Data",null,null,null,"PVEOL Questions:",null,null,null,"Yes/No","Brief explanation of restrictions"]
["Year constructed:",null,1942,null,"Is the bridge over 80 year old",null,null,null,"Yes","During the summer months the bridge has an active TTM stop/go system. Bridge has 30kph speed limit. "]
["One Network Road Classification (ONRC):",null,"Primary Collector",null,"Is there significant maintenance required in the next 3 years",null,null,null,"Yes",null,null,null,null,null,null,"Are there live load or speed restrictions across the bridge"]
["Vehicles per day:",null,4032,null,"Is the bridge inspected in accordance with NZTA-S6",null,null,null,"Yes"]
["% heavy vehicles:",null,0.13200000000000001,null,"Is the bridge on special inspections",null,null,null,"Yes"]
["Number of Spans",null,3,null,"Has a live load assessment been carried out based on the known condition",null,null,null,"Yes"]
["Total Length of Bridge",null,40.799999999999997,null,"Are there any brittle and/or vulnerable details on the bridge",null,null,null,"Yes"]
["Road width between Kerbs/rails ",null,3.66,null,"Are there live load or speed restrictions across the bridge",null,null,null,"Yes"]
["Structure description",null,null,"Photo from Road Level ",null,null,null,"Photo of Elevation"]
["The bridge is a three span single lane structure with a 3.66m (12’) lane width between kerbs. It is constructed as three 13.4m (44’) long simply supported spans. Each span comprises a two beam in-situ reinforced concrete T beam deck. The deck spans are supported on reinforced concrete piers and abutments, which are in turn supported on precast concrete piles. The original concrete balustrade panels remain."]
["Current Condition ",null,"Briefly explain the current defects",null,null,null,null,"Representative photo of condition"]
["Parapets / Barriers / Surfacing",null,"Parapets are in a very poor condition with questionable capacity. They will need replacing. The surfacing will need replacing according to the NOC"]
[null,null,"Maintenance Interventions Required",null,null,"Year","Cost ($k)"]
[null,null,"1.) Parapet replacement",null,null,2022,50]
[null,null,"2.) "]
[null,null,"3.)"]
[null,null,"4.)"]
["Current Condition ",null,"Briefly explain the current defects",null,null,null,null,"Representative photo of condition"]
["Superstructure",null,"There is a extensive chloride contamination of the reinforcement which has been confirmed through investigation. Major intervention is required to maintain the level of service"]
[null,null,"Maintenance Interventions Required",null,null,"Year","Cost ($k)"]
[null,null,"1.) Concrete repairs to beams",null,null,2021,600]
[null,null,"2.)"]
[null,null,"3.)"]
[null,null,"4.)"]
["Current Condition ",null,"Briefly explain the current defects",null,null,null,null,"Representative photo of condition"]
["Substructure ",null,"There is a extensive chloride contamination of the reinforcement which has been confirmed through investigation. Major intervention is required to maintain the level of service"]
[null,null,"Maintenance Interventions Required",null,null,"Year","Cost ($k)"]
[null,null,"1.) Concrete Repairs to piers and abutments",null,null,2023,200]
[null,null,"2.)"]
[null,null,"3.)"]
[null,null,"4.)"]
["Other general photos to represent current condition"]
[]
[]
["Hypothetical \"like for like\" bridge Replacement",null,null,null,"Brief discussion"]
["Total Length of Bridge",null,40.799999999999997,null,"‘like-for-like’ replacement bridge provides the same level of service (i.e. similar width, live load capacity, alignment, resilience etc) as the existing bridge"]
["Road width between Kerbs/rails ",null,3.66]
["NZTA replacement rate (m2)",null,6600,null,null,null,null,null,null,null,null,null,null,null,null,1,200,{"$f":"Q41*4%","v":8}]
["Replacement cost",null,1000000,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"Q41-R41","v":192},{"$f":"Q42*4%","v":7.68}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"Q42-R42","v":184.32},{"$f":"Q43*4%","v":7.3727999999999998}]
["Maintenance Scenarios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,176.94719999999998,7.0778879999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,169.86931199999998,6.7947724799999989]
["Scenario 1 - Minimal / Routine Maintenance and look to replace the bridge as early as possible (1-3 years)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,163.07453951999997,6.5229815807999989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,156.55155793919997,6.2620623175679988]
["Component ",null,"Maintenance Interventions Required",null,null,"Year","Cost ($k)","NPV ($k) \n4% discount",null,null,null,null,null,null,null,8,150.28949562163197,6.0115798248652794]
["All",null,"Minimum Maintenance / Inspections/ TTM for next 3 years",null,null,2023,50,46,null,null,null,null,null,null,null,9,144.27791579676671,5.7711166318706679]
["All",null,"Replace bridge ",null,null,2023,1000,922,null,null,null,null,null,null,null,10,138.50679916489605,5.5402719665958422]
[]
[null,null,null,null,null,"Totals",{"$f":"SUM(G49:G51)","v":1050},{"$f":"SUM(H49:H51)","v":968}]
[]
["Scenario 2 - Maintain the bridge in the medium term (3-10 years) followed by bridge replacement"]
[]
["Component ",null,"Maintenance Interventions Required",null,null,"Year","Cost ($k)","NPV ($k) \n4% discount"]
["All",null,"Minimum Maintenance / Inspections/ TTM for next 10 years",null,null,2030,200,140]
["All",null,"Replace bridge ",null,null,2030,1000,700]
["Parapets / Barriers / Surfacing",null,"Parapet replacement",null,null,2022,50,48]
["Superstructure",null,"Concrete repairs to beams",null,null,2021,600,580]
["Substructure",null,"Concrete Repairs to piers and abutments",null,null,2023,200,184]
[]
[]
[null,null,null,null,null,"Totals",{"$f":"SUM(G57:G63)","v":2050},{"$f":"SUM(H57:H63)","v":1652}]
[]
["Proposed Strategy"]
["Preliminary PVEOL is indicating that bridge replacement should be carried out as early as possible (1-3 years) , a detailed PVEOL should be progressed to justify any future business case/renewal"]
["Document preparation"]
["Prepared by:",null,null,null,"Title:",null,null,null,"Date:"]
["Approved by:",null,null,null,"Title:",null,null,null,"Date:"]
["Document review - Waka Kotahi response"]
["Reviewed by:",null,null,null,"Title:",null,null,null,"Date:"]
["Outcome:",null,"Comments:"]

{"sheet":"Sheet1","index":1,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
["Network Areas",null,"Work Category",null,"Life","Effectiveness"]
["Northland",null,"114A","Routine Bridge Maintenance","0-5 yrs","Not effective"]
["Auckland North",null,"114B","Structural Bridge Maintenance","5-10 yrs","Uncertain"]
["Auckland Harbour Bridge",null,"114C","Other Significant Highway Structures Maintenance (exc. Tunnels)","10-20 yrs","Effective"]
["Waterview Tunnel",null,"114D","Guardrail Maintenance - on Bridges",">20 yrs"]
["Auckland SM",null,"114E","Tunnel Maintenance"]
["West Waikato North",null,"114F","Highway Guardrail Maintenance - not on Bridges",null,"Priority",null,null,null,"Supplier Logo"]
["West Waikato South",null,151,"Network and Asset Management",null,"Urgent","Urgent",null,null,"Supplier","(Click cell to left to get supplier logo)"]
["Central Waikato",null,"215A","Routine Bridge Component Replacements",null,"High\n(year 1)","High",null,null,"Beca"]
["East Waikato",null,"215B","Structural Bridge Component Replacements",null,"Medium\n(years 2-4)","Medium",null,null,"WSP-Opus"]
["Bay of Plenty East",null,"215C","Other Significant Highway Structures Component Replacements (exc. Tunnels)",null,"Low\n(year 5+)","Low"]
["Bay of Plenty West",null,"215D","Guardrail Component Replacements - on Bridges"]
["Northern Gisborne",null,"215E","Professional Services for Component Replacements"]
["Western Gisborne",null,"215F","Highway Guardrail Component Replacement - not on Bridges"]
["Hawkes Bay",null,"215G","Tunnel Component Replacements"]
["Taranaki"]
["Manawatu-Whanganui",null,null,"ONRC"]
["Wellington",null,null,"National"]
["Marlborough",null,null,"National \n(high volume)"]
["Nelson-Tasman",null,null,"Regional"]
["North Canterbury",null,null,"Arterial"]
["South Canterbury",null,null,"Primary Collector"]
["West Coast",null,null,"Secondary Collector"]
["Central Otago",null,null,"Access"]
["Coastal Otago",null,null,"Access \n(low volume)"]
["Southland"]
["Milford Road",null,null,"Outcome"]
[null,null,null,"Approved"]
[null,null,null,"Rejected"]
[null,null,null,"Re-submit"]
[]
[null,null,null,"Yes"]
[null,null,null,"No"]