{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["NLTP","Priorities","Explanatory notes","25% funding reduction - New","PotentialRisks profile impacts ","111 - rut fill ranking","222 - large signs ranking","WC241","Rehab - Sealed","Resurface - Chip Seal","Resurface TAC"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":7,"defined_names":109,"comments":1,"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":"NLTP","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":true,"merged":[[24,3,24,4]]}
[]
[]
[]
[]
[null,null,null,"TOTAL APPROVED  18-21 NLTP ($000)","TOTAL APPROVED  18-21 NLTP ($000)"]
[null,null,null,"NOC","non-NOC"]
[null,null,111,5255.1292320000002,60]
[null,null,112,0,0]
[null,null,113,1784.163564,30]
[null,null,114,564,705]
[null,null,121,5834.4146058400001,2953]
[null,null,122,2996.7701280000001,1358]
[null,null,123,30,25]
[null,null,124,3,0]
[null,null,131,0,0]
[null,null,151,6091.2984159999996,1254]
[null,null,211,0,0]
[null,null,212,11024.815219999999,0]
[null,null,213,1199.7015999999999,0]
[null,null,214,3198.2,0]
[null,null,215,60,2445]
[null,null,221,0,0]
[null,null,222,312,198]
[]
[null,null,null,{"$f":"SUM(D7:E23)","v":47381.492765839997}]
[]
[null,null,"Check:",{"$f":"D25-#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Priorities","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[null,null,"Priorities for 113 and renewal programme",null,null,null,null,null,"Priorities for all other activities"]
[null,null,"LS - Included in approved NLTP",null,null,null,null,null,"LS -  Included in approved NLTP"]
[null,null,"LS - Not included in approved NLTP",null,null,null,null,null,"LS - Not included in approved NLTP"]
[null,null,"LS - Increase from approved NLTP",null,null,null,null,null,"LS - Increase from approved NLTP"]
[null,null,"Critical - Included NLTP allocation",null,null,null,null,null,"High - Included NLTP allocation"]
[null,null,"Critical -  Not included in approved NLTP",null,null,null,null,null,"High -  Not included in approved NLTP"]
[null,null,"Critical - Increase from NLTP allocation",null,null,null,null,null,"High - Increase from NLTP allocation"]
[null,null,"High - Included NLTP allocation",null,null,null,null,null,"Medium - Included NLTP allocation"]
[null,null,"High -  Not included in approved NLTP",null,null,null,null,null,"Medium -  Not included in approved NLTP"]
[null,null,"High - Increase from NLTP allocation",null,null,null,null,null,"Medium - Increase from NLTP allocation"]
[null,null,"Medium - Included NLTP allocation",null,null,null,null,null,"Low"]
[null,null,"Medium -  Not included in approved NLTP"]
[null,null,"Medium - Increase from NLTP allocation"]
[null,null,"Low"]

{"sheet":"Explanatory notes","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Rut Filling & Large Signs Ranking example demonstrates: \n* Ranking the programme for different work types within each work category & assessing the risk for that specific activity.\n* Ability to move the bar within each work type to meet appetite for risk\n* Allows greater or lesser reduction in each activity dependant of risk tolerance to meet the bottom line 25% requirement."]
[]
[null,"The 25% funding reduction tab becomes a summary of each activity class along with a narrative on the risk and management strategy totalling the proposed savings.  \nOnce the budgets have been set following National moderation, Network Teams can then simply move the bar. \nThis will communicate what the reductions mean for regions resulting from the moderation.    "]
[]
[null,"Completing a Z44 Assessment for the 3-year plan detailing the risks and controls will enable the wider team to deliver risk management during the 3 year programme.  \nPerformance in each area would then define any reprioritisation during the NLTP period. "]

{"sheet":"25% funding reduction - New","index":3,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,4,3,7]]}
[]
[null,"Network Outcome Area:","Contract Name"]
[null,"Year:","21-24"]
[null,null,null,null,"NLTP Period 2021-24 (funding reduction)"]
[null,"Work Category"," Description",null,"2021/2022 ($000)"," 2022/2023 ($000)","Funding Request 2023/2024 ($000)","TOTAL 21-24 NLTP ($000)","Consequences of not funding the activity - Safety, Customer, Network condition and maintenance activities","Quantity to be removed\n(Unit)","Unit","Link to additional information if available","Risk to Budget\n (Potential Reactive Mtc $000)","Risk (with mitigation and risk $ allowance)"]
[]
[null,"WC111","Customer LOS rutting (from rutting programme)",null,188,150,150,{"$f":"E7+F7+G7","v":488},"Original application for $900k over the 3 year period has been reduced to $412k, a 54% reduction.  Sites would more likely be selected based on surfacing renewal programmed areas and accident prone areas along with the higher ranking sites due to other factors.  \n\nConsequence: The NC area will remain steady with similar lengths of rutting across the network with some deterioration in average rut depth increasing the lengths of rutting 10-19mm and >20mm.  No improvements in pavement performance will be achieved.  Risk levels will remain the same as existing.  Some contractual issues may exist as the >20mm increases which is Contractors risk under their LS's.  \n\nMitigation: Review annual programmes and target critical/interdependent sites.  May have to review the contractual issues for rutting quantities >20mm.  ",1640,"m","Link to Rutting Business Case",15,"Medium"]
[null,"WC222","Large Signs Renewals",null,60,60,60,{"$f":"E8+F8+G8","v":180},"Original application for $456k over the 3 year period has been reduced to  $275k a 40%  reduction.  This would mean all 'very poor' condition 5's and 75% of the condition 4's would be replaced.   A further $150k reduction could be achieved through only replacing the condition 5 (very Poor) signs.\n\nConsequence:  A backlog of deteriorated large signs will impact future funding needs.  Work is only deferred.  Potential for customer complaints as the network appears unmaintained and untidy.  Reputational risk only.\n\nMitigation: Will need to monitor reflectivity standards and customer complaints.  Annual review and reprioritisation of renewals to minimise risk.  A more responsive approach needed rather than a planned/condition based approach to renewals.  ",19,"No","Link to Signs Asset Information Summarry",20,"Low"]
[null,null,null,null,null,null,null,{"$f":"SUM(E9:G9)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[null,null,"TOTAL Saving",null,{"$f":"SUM(E7:E33)","v":248},{"$f":"SUM(F7:F33)","v":210},{"$f":"SUM(G7:G33)","v":210},{"$f":"SUM(H7:H33)","v":668},null,null,null,"Risk",{"$f":"SUM(M7:M32)","v":35},{"$f":"M34/H34","v":5.239520958083832E-2}]
[null,null,"Total Funding request",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"% Reduction",null,{"$f":"E34/E35","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"H34/H35","v":{"$error":"#REF!"}}]

{"sheet":"PotentialRisks profile impacts ","index":4,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":true,"merged":[[1,1,1,2],[2,1,2,2],[3,7,3,10]]}
[]
[null,"Network Outcome Area:"]
[null,"Year:",null,null,"20/21"]
[null,null,null,null,null,null,null,"NLTP Period 2021-24"]
[null,"Activity","Work Category",null," Description","2020/2021 ($000)",null,"2021/2022 ($000)"," 2022/2023 ($000)","Funding Request 2023/2024 ($000)","TOTAL 21-24NLTP ($000)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Escalation rate:"]
[null,"Coal Tar Testing","WC214","111 Detail","Coal Tar Policy and Procedures are still been developed. If we continue testing rehabs then initial screening for coal tar all rehab sites (10sites x 2tests x $500/test)",45,null,45,45,45,{"$f":"SUM(H7:J7)","v":135},null,null,null,null,null,null,null,null,null,null,null,"LS Pavement Maintenance ",0]
[null,"Coal Tar Disposal","WC213","111 Detail","Possible 2x rehab sites requiring excavation and disposal annually due to coal tar discovery",500,null,500,500,500,{"$f":"SUM(H8:J8)","v":1500},null,null,null,null,null,null,null,null,null,null,null,"Asset Growth",0]
[null,"Enhanced TTM","WC123","111 Detail","Enhanced incident response on RONS (CSM2 and CNC). This is yet to be confirmed. ",null,null,200,200,200,600,null,null,null,null,null,null,null,null,null,null,null,"Customer LOS roughness",0]
[null,"Route 70 support","WC111","111 Detail","HDC and KDC handback of route 70. Potential for future support (maintenance or renewal) or use of detour. There is the risk that agreement with the local councils may not be able to be met.",250,null,150,100,50,300,null,null,null,null,null,null,null,null,null,null,null," Customer LOS rutting",0]
[null,"Winter Services","WC121",null,"Extended or extreme winter and additional Winter Services and Winter Management. We are seeing more adverse weather events. ",300,null,300,300,300,900]
[null,"SH7 Maintenance","WC111","111 Detail","SH7 additional maintenance claims due to reduction in life",300,null,300,300,300,900,null,null,null,null,null,null,null,null,null,null,null,"T/10 treatments-Maint",0]
[null,"SH1S 90-185 Maintenance","WC111",null,"SH1 RS90-185. Currently this section is Principal Risk. We don’t believe that the tendered lump sums are going to be appropriate going forward. ",500,null,500,500,500,1500]
[null,"Cost Recovery","WC121",null,"Cost Recovery. Incident damage not recovered from 3rd parties by NZTA",150,null,150,150,150,450]
[null,"Culvert Renewals SH1S 90-185","WC213","111 Detail","50 culvert renewals in SH1 90-185 identified as potential EQ damage was removed from the NCTIR scope. Further CCTV is proposed for in the 20/21 year and these results could yield further renewals than projected. ",0,null,250,250,250,750,null,null,null,null,null,null,null,null,null,null,null,"DO SOME Maintenance (from renewals programme)",0]
[null,"COPTTM Variation","WC123",null,"COPTTM variation",500,null,500,500,500,1500]
[null,"Toilet Maintenance","WC121",null,"Addition of toilets throughout rest areas in North Canterbury is going to result in increased maintenance. North Canterbury NOC is applying for Rest Area Improvements (including the addition of toilets). This risk also applies to toilets in rest areas which NCTIR have recently constructed, funding for cleaning these may fall to NZTA. ",null,null,100,100,100,300]
[null,"ATP Renewal Quantities","WC222",null,"Additonal ATP delivered by SRA team and not yet accounted for in future renewals. Unknown quantities which will require replacement in future renewals.",50,null,75,100,120,295]
[null,"Asset Growth NCTIR","WC111",null,"Asset Growth in NCTIR area is unknown. Likely to impact Sealed Pavements, Drainage, Guardrails, Traffic Services",null,null,200,200,200,600]
[null,"Asset Growth NCTIR","WC113",null,"Asset Growth in NCTIR area is unknown. Likely to impact Sealed Pavements, Drainage, Guardrails, Traffic Services",null,null,50,50,50,150]
[null,"Asset Growth NCTIR","WC114",null,"Asset Growth in NCTIR area is unknown. Likely to impact Sealed Pavements, Drainage, Guardrails, Traffic Services",null,null,100,100,100,300]
[null,"Asset Growth NCTIR","WC122",null,"Asset Growth in NCTIR area is unknown. Likely to impact Sealed Pavements, Drainage, Guardrails, Traffic Services",null,null,50,50,50,150]
[null,"Asset Growth RONS","WC111",null,"Asset Growth in RONS for sealed pavement maintenance has been estimated only and $77k allowed for in Other Sealed Pavement Maintenance. Risk that actual cost will be higher. ",0,null,50,50,50,{"$f":"SUM(H23:J23)","v":150}]
[null,"Asset Growth RONS","WC113",null,"Asset Growth in RONS for drainage maintenance has been estimated only and $2.4k allowed for in Other Drainage Maintenance. Risk that actual cost will be higher. ",0,null,10,10,10,30]
[null,"Asset Growth RONS","WC121",null,"Asset Growth in RONS for environmental maintenance has been estimated only and $75k allowed for in Other Environmental Maintenance. Risk that actual cost will be higher. ",0,null,50,50,50,150]
[null,"Asset Growth RONS","WC122",null,"Asset Growth in RONS for Traffic Services maintenance has been estimated only and $9.2 allowed for in Other Traffic Services Maintenance. Risk that actual cost will be higher. ",0,null,10,10,10,30]
[null,"Culvert Repair","WC213",null,"110m long culvert under Christchurch Northern Motorway. Believed to be blocked 30m from upstream end. This places it under the motorway fill batter slope on western side. An allocation of $50k for further investigation and unblocking is requested under WC213. If excavation is required then serious cost due to sheet piling and underneath motorway fill batter. Allocation has been indicated in the Potential Risks Impacts Tab. ",200,null,50,0,0,50]
[null,"Heavy Maintenance","WC111",null,"Particular capital projects or sites outside of the NOC may become a future liability to NZTA. These include: SH73 Mingha, SH1S Main North Road with handover to TLA, SH76 Halswell Road South with handover to TLA, SH73 Craigieburn Foam Bitumen site by 3rd party ahead of NOC. ",150,null,150,150,150,450]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"111 - rut fill ranking","index":5,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,1,5,3],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16]]}
[]
[null,"Ranked Large Signs for Full 21-24 NLTP"]
[]
[null,"SH","RS","RP (Start)","RP (End)","Length","Cumulative","Left or Right","ONRC Classification","% > 15 mm","Next renewal (type/years)","Proposed Treatment","Rank","Unit\n(length, m2, m3, No.)","Quantity of Units","Cost","Cumulative Cost"]
[null,null,null,null,null,null,"Length"]
[null,"Total for  Rutting:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(O8:O28)","v":0},null,{"$f":"Q69","v":0}]
[]
[null,99,999,13200,13600,300,{"$f":"F8","v":300},"Right","National",5,"RS 2021/22","Microsurfacing Passing Lane B - HIGHEST PRIORITY SITE",null,null,null,5000,{"$f":"P8","v":5000}]
[null,99,999,13040,13520,280,{"$f":"G8+F9","v":580},"Right","National",8,"RS 2021/22","Microsurfacing Passing Lane B - HIGHEST PRIORITY SITE",null,null,null,5000,{"$f":"Q8+P9","v":10000}]
[null,99,999,12000,12080,80,{"$f":"G9+F10","v":660},"Left","National",0,"RS 2023/24","Microsurfacing Fake Rd Passing Lanes - HIGH PRIORITY",null,null,null,5000,{"$f":"Q9+P10","v":15000}]
[null,99,999,12260,12360,120,780,"Left","National",0,"RS 2023/24","Microsurfacing Fake Rd Passing Lanes - HIGH PRIORITY",null,null,null,5000,20000]
[null,99,999,11720,12320,400,1180,"Right","National",5,"RS 2023/24","Microsurfacing Fake Rd Passing Lanes - HIGH PRIORITY",null,null,null,5000,25000]
[null,99,999,8720,9220,460,1640,"Left","National",42,"RS 2026/27","Microsurfacing Fake Passing Lanes",null,null,null,5000,30000]
[null,99,999,5980,6680,460,2100,"Left","National",26,"RS 2028/29","Microsurfacing Fake Passing Lanes",null,null,null,5000,35000]
[null,99,999,8900,9660,680,2780,"Right","National",21,"RS 2026/27","Microsurfacing  Passing Lanes",null,null,null,5000,40000]
[null,99,999,5940,6720,480,3260,"Left","National",23,"RS 2028/29","Microsurfacing  Passing Lanes",null,null,null,5000,45000]
[null,99,999,6360,6640,200,3460,"Right","National",10,"RS 2028/29","Microsurfacing  Passing Lanes",null,null,null,5000,50000]
[null,99,999,6240,6980,200,3660,"Right","National",10,"RS 2028/29","Microsurfacing  Passing Lanes",null,null,null,5000,55000]
[null,99,999,6760,7240,500,4160,"Left","National",24,"RS 2027/28","Microsurfacing  Passing Lanes",null,null,null,5000,60000]
[null,99,999,6760,7240,420,4580,"Left","National",0,"RS 2027/28","Microsurfacing  Passing Lanes",null,null,null,5000,65000]
[null,99,999,6700,7240,400,4980,"Right","National",0,"RS 2027/28","Microsurfacing  Passing Lanes",null,null,null,5000,70000]
[null,99,999,7120,7240,140,5120,"Right","National",29,"RS 2027/28","Microsurfacing  Passing Lanes",null,null,null,5000,75000]
[null,99,999,9400,9900,200,5320,"Left","Secondary Collector",0,"RS 2031/32","Microsurfacing Fake Road",null,null,null,5000,80000]
[null,99,999,9400,9900,120,5440,"Right","Secondary Collector",33,"RS 2031/32","Microsurfacing Fake Road",null,null,null,5000,85000]
[null,99,999,14700,15200,200,5640,"Left","Secondary Collector",20,"RS 2022/23","Microsurfacing ",null,null,null,5000,90000]
[null,99,999,14700,15200,140,5780,"Right","Secondary Collector",13,"RS 2022/23","Microsurfacing ",null,null,null,5000,95000]
[null,99,999,6000,6700,320,6100,"Left","Secondary Collector",25,"RS 2030/31","Microsurfacing ",null,null,null,5000,100000]
[null,99,999,6000,6700,180,6280,"Left","Secondary Collector",22,"RS 2030/31","Microsurfacing ",null,null,null,5000,105000]
[null,99,999,5200,6000,220,6500,"Left","Secondary Collector",9,"RS 2031/32","Microsurfacing ",null,null,null,5000,110000]
[null,99,999,5200,6000,260,6760,"Right","Secondary Collector",46,"RS 2031/32","Microsurfacing ",null,null,null,5000,115000]

{"sheet":"222 - large signs ranking","index":6,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,11,4,11],[3,12,4,12],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,1,5,3],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10]]}
[]
[null,"Ranked Large Signs for Full 21-24 NLTP"]
[]
[null,"SH","RS","RP (Start)","RP (End)","Length"," Location Name ","Proposed Treatment","Rank","Unit\n(length, m2, m3, No.)","Quantity of Units","$ / Unit","Cumulative Cost"]
[]
[null,"Total for  Large Signs:",null,null,null,null,null,{"$f":"COUNTIF(H7:H27,\"*\")","v":21},null,null,{"$f":"COUNT(K7:K27)","v":21},null,{"$f":"M80","v":370000}]
[null,99,999,8098,null,null,"Left","PASSING LANE \"\"4\"\" km AHEAD",1,"No",1,5000,5000]
[null,99,999,15909,null,null,"Left","BEACH TURN LEFT 400M",2,"No",1,5000,{"$f":"M7+L8","v":10000}]
[null,99,999,14105,null,null,"Left","NEXT RIGHT",3,"No",1,5000,15000]
[null,99,999,3008,null,null,"Right"," 300M ON RIGHT",4,"No",1,5000,20000]
[null,99,999,2390,null,null,"Left"," 300M ON RIGHT",5,"No",1,5000,25000]
[null,99,999,15495,null,null,"Left"," 300M ON RIGHT",6,"No",1,5000,30000]
[null,99,999,9519,null,null,"Left"," 300M ON RIGHT",7,"No",1,5000,35000]
[null,99,999,14002,null,null,"Right"," 300M ON RIGHT",8,"No",1,5000,40000]
[null,99,999,5818,null,null,"Right"," 300M ON RIGHT",9,"No",1,5000,45000]
[null,99,999,5552,null,null,"Right"," 300M ON RIGHT",10,"No",1,5000,50000]
[null,99,999,7996,null,null,"Left"," 300M ON RIGHT",11,"No",1,5000,55000]
[null,99,999,8708,null,null,"Right"," 300M ON RIGHT",12,"No",1,5000,60000]
[null,99,999,15630,null,null,"Left"," 300M ON RIGHT",13,"No",1,5000,65000]
[null,99,999,297,null,null,"Left"," 300M ON RIGHT",14,"No",1,5000,70000]
[null,99,999,3324,null,null,"Right","PASSING LANE 2KM AHEAD",15,"No",1,5000,75000]
[null,99,999,9406,null,null,"Right","PASSING LANE 2KM AHEAD",16,"No",1,5000,80000]
[null,99,999,9985,null,null,"Left","PASSING LANE 2KM AHEAD",17,"No",1,5000,85000]
[null,99,999,15351,null,null,"Right","PASSING LANE 2KM AHEAD",18,"No",1,5000,90000]
[null,99,999,12009,null,null,"Right","PASSING LANE 2KM AHEAD",19,"No",1,5000,95000]
[null,99,999,205,null,null,"Left","ROAD INFORMATION",20,"No",1,5000,100000]
[null,99,999,1337,null,null,"Centre","ROAD INFORMATION",21,"No",1,5000,105000]
[null,99,999,6546,null,null,"Right","ROAD INFORMATION",22,"No",1,5000,110000]
[null,99,999,2340,null,null,"Left","ROAD INFORMATION",23,"No",1,5000,115000]
[null,99,999,2517,null,null,"Centre","ROAD INFORMATION",24,"No",1,5000,120000]
[null,99,999,2736,null,null,"Right","Passing Lane",25,"No",1,5000,125000]
[null,99,999,6918,null,null,"Left","Passing Lane",26,"No",1,5000,130000]
[null,99,999,307,null,null,"Left","Passing Lane",27,"No",1,5000,135000]
[null,99,999,2033,null,null,"Right","Passing Lane",28,"No",1,5000,140000]
[null,99,999,1446,null,null,"Left","Passing Lane",29,"No",1,5000,145000]
[null,99,999,8441,null,null,"Right","Passing Lane",30,"No",1,5000,150000]
[null,99,999,12315,null,null,"Right","Passing Lane",31,"No",1,5000,155000]
[null,99,999,10474,null,null,"Left","Turn Right 300m",32,"No",1,5000,160000]
[null,99,999,750,null,null,"Left","Turn Right 300m",33,"No",1,5000,165000]
[null,99,999,9328,null,null,"Left","Turn Right 300m",34,"No",1,5000,170000]
[null,99,999,9328,null,null,"Right","Turn Right 300m",35,"No",1,5000,175000]
[null,99,999,2551,null,null,"Left","Turn Right 300m",36,"No",1,5000,180000]
[null,99,999,4267,null,null,"Right","Turn Right 300m",37,"No",1,5000,185000]
[null,99,999,11601,null,null,"Right","Turn Right 300m",38,"No",1,5000,190000]
[null,99,999,13532,null,null,"Left","Turn Right 300m",39,"No",1,5000,195000]
[null,99,999,3417,null,null,"Left","Turn Right 300m",40,"No",1,5000,200000]
[null,99,999,3703,null,null,"Left","Turn Right 300m",41,"No",1,5000,205000]
[null,99,999,4620,null,null,"Left","PASSING LANE 4 km AHEAD",42,"No",1,5000,210000]
[null,99,999,6328,null,null,"Right","PASSING LANE 4 km AHEAD",43,"No",1,5000,215000]
[null,99,999,6609,null,null,"Left","PASSING LANE 4 km AHEAD",44,"No",1,5000,220000]
[null,99,999,18341,null,null,"Right","SH 99 Next Left",45,"No",1,5000,225000]
[null,99,999,141,null,null,"Centre","SH 99 Next Left",46,"No",1,5000,230000]
[null,99,999,1344,null,null,"Right","SH 99 Next Left",47,"No",1,5000,235000]
[null,99,999,16918,null,null,"Left","SH 99 Next Left",48,"No",1,5000,240000]
[null,99,999,2328,null,null,"Right","SH 99 Next Left",49,"No",1,5000,245000]
[null,99,999,7679,null,null,"Left","SH 99 Next Left",50,"No",1,5000,250000]
[null,99,999,139,null,null,"Right","SH 99 Next Left",51,"No",1,5000,255000]
[null,99,999,14120,null,null,"Right","SH 99 Next Left",52,"No",1,5000,260000]
[null,99,999,4407,null,null,"Left","SH 99 Next Left",53,"No",1,5000,265000]
[null,99,999,4019,null,null,"Left",80,54,"No",1,5000,270000]
[null,99,999,4019,null,null,"Right",80,55,"No",1,5000,275000]
[null,99,999,9489,null,null,"Left","PASSING LANE 4KM AHEAD",56,"No",1,5000,280000]
[null,99,999,7,null,null,"Right","PASSING LANE 4KM AHEAD",57,"No",1,5000,285000]
[null,99,999,2326,null,null,"Right","PASSING LANE 1KM AHEAD",58,"No",1,5000,290000]
[null,99,999,1319,null,null,"Right",70,59,"No",1,5000,295000]
[null,99,999,1319,null,null,"Left",70,60,"No",1,5000,300000]
[null,99,999,1319,null,null,"Left",100,61,"No",1,5000,305000]
[null,99,999,8568,null,null,"Left",100,62,"No",1,5000,310000]
[null,99,999,3511,null,null,"Right",100,63,"No",1,5000,315000]
[null,99,999,3891,null,null,"Centre",100,64,"No",1,5000,320000]
[null,99,999,7079,null,null,"Left",100,65,"No",1,5000,325000]
[null,99,999,7079,null,null,"Right",100,66,"No",1,5000,{"$f":"M71+L72","v":330000}]
[null,99,999,7079,null,null,"Right","FAKE ROAD TURN LEFT 150M",67,"No",1,5000,335000]
[null,99,999,909,null,null,"Right","FAKE ROAD TURN LEFT 150M",68,"No",1,5000,340000]
[null,99,999,8509,null,null,"Right","FAKE ROAD TURN LEFT 150M",69,"No",1,5000,345000]
[null,99,999,5870,null,null,"Left","FAKE ROAD TURN LEFT 150M",70,"No",1,5000,350000]
[null,99,999,6228,null,null,"Right","FAKE ROAD TURN LEFT 150M",71,"No",1,5000,355000]
[null,99,999,7709,null,null,"Left","FAKE ROAD TURN LEFT 150M",72,"No",1,5000,360000]
[null,99,999,7848,null,null,"Left","FAKE ROAD TURN LEFT 150M",73,"No",1,5000,365000]
[null,99,999,5920,null,null,"Left","FAKE ROAD TURN LEFT 150M",74,"No",1,5000,370000]

{"sheet":"WC241","index":7,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Current Version:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"WC 241 Preventative Maintenance"]
[]
[null,null,"Funding Request 2015/2016 ($000)"]
[null,"Scour",{"$f":"SUM(C6:C9)","v":0}]
[]
[]
[]
[]
[null,"Rockfall",{"$f":"SUM(C11:C14)","v":0}]
[]
[]
[]
[]
[null,"Resilience",{"$f":"SUM(C16:C19)","v":0}]
[]
[]
[]
[]
[null,"Preventative Maintenance",{"$f":"SUM(C21:C24)","v":0}]
[]
[]
[]
[]
[null,"Total Associated Improvements",{"$f":"C5+C10+C15+C20","v":0}]
[]
[null,"* Insert extra rows if required"]

{"sheet":"Rehab - Sealed","index":8,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":true,"merged":[[6,16,6,19],[7,19,8,19],[9,0,34,0],[7,18,8,18],[36,16,37,16],[36,17,37,17],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,7,14],[7,16,7,17],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[2,1,2,3],[2,4,2,6],[3,1,3,3],[3,4,3,6],[6,1,6,15]]}
[null,null,null,null,null,null,null,null,"Current Version:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"WC 214  PAVEMENT REHABILITATION -Sealed Pavement Rehab"]
[null,"Annual Plan",null,null,"2015/16"]
[null,"Network Outcome Area:"]
[]
[]
[null,"Project Schedule",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improvements "]
[null,"Project Ref","Year","SH","RS","RP (Start)","RP (End)","Treatment Length Name ","Failure Mode\n(Use NOMAD codes)","Proposed Treatment*","Length (km)","NPV","Economic Efficiency (New)","Prioritisation Assessment (New)",null,"Use $ at June 2014","See Associated Improvements Section of SM018 for guidance",null,"Seal Width (m)","Seal Length (km)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"% of Priority 1 rating","% of Priority 2 rating","2015/2016 Estimated Cost ($000)","Associated Improvements (WC 231) ($000)","Safety Justified Seal Widening \n(WC 341) ($000)"]
["ANNUAL PLAN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Length",{"$f":"SUM(K10:K35)","v":0},null,null,null,null,{"$f":"SUM(P10:P25)","v":0},{"$f":"SUM(Q10:Q35)","v":0},{"$f":"SUM(R10:R35)","v":0},{"$f":"SUM(S10:S35)","v":0}]
[null,null,null,null,null,null,null,null,null,"Base Preservation Levels"]
[null,null,null,null,null,null,null,null,null,"Variance",{"$f":"K37-K36","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Final Length:",{"$f":"SUM(K10:K35)","v":0},null,null,null,"Final dollars:",{"$f":"SUM(P10:P35)","v":0}]

{"sheet":"Resurface - Chip Seal","index":9,"n_rows":87,"n_cols":13,"rows_kept":87,"cut":false,"hidden":true,"merged":[[83,12,84,12],[2,1,2,3],[2,4,2,6],[3,1,3,3],[3,4,3,6],[11,0,81,0],[8,1,8,12],[9,10,10,10],[9,11,10,11],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9]]}
[null,null,null,null,null,null,null,null,"Current Version:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"WC 212 SEALED ROAD SURFACING - CHIP SEALS"]
[null,"Annual Plan",null,null,"2015/16"]
[null,"Network Outcome Area:"]
[]
[]
[]
[]
[null,"Project Schedule"]
[null,"Project Ref","Year","SH","RS","RP (Start)","RP (End)","Treatment Length Name ","Failure Mode\n(Use NOMAD codes)","Proposed Treatment\n(Use NOMAD codes)","Length (km)","$/m2","Use $ at June 2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2015/2016 Estimated Cost ($000)"]
["ANNUAL PLAN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Length",{"$f":"SUM(K12:K82)","v":0},null,{"$f":"SUM(M12:M82)","v":0}]
[null,null,null,null,null,null,null,null,null,"Base Preservation Levels"]
[null,null,null,null,null,null,null,null,null,"Variance",{"$f":"K84-K83","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Final Length:",{"$f":"SUM(K12:K82)","v":0},"Final dollars:",{"$f":"SUM(M12:M82)","v":0}]

{"sheet":"Resurface TAC","index":10,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":true,"merged":[[11,0,37,0],[39,12,40,12],[9,11,10,11],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[2,1,2,3],[2,4,2,6],[3,1,3,3],[3,4,3,6],[8,1,8,11]]}
[null,null,null,null,null,null,null,null,"Current Version:",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"WC 212 SEALED ROAD SURFACING - THIN ASPHALTIC CEMENT"]
[null,"Annual Plan",null,null,"2015/16"]
[null,"Network Outcome Area:"]
[]
[]
[]
[]
[null,"Project Schedule"]
[null,"Project Ref","Year","SH","RS","RP (Start)","RP (End)","Treatment Length Name ","Failure Mode\n(Use NOMAD codes)","Proposed Treatment\n(Use NOMAD codes)","Length (km)","$/m2","Use $ at June 2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,"2015/2016 Estimated Cost ($000)"]
["ANNUAL PLAN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Total Length",{"$f":"SUM(K12:K38)","v":0},null,{"$f":"SUM(M12:M38)","v":0}]
[null,null,null,null,null,null,null,null,null,"Base Preservation Levels"]
[null,null,null,null,null,null,null,null,null,"Variance",{"$f":"K40-K39","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Final Length:",{"$f":"SUM(K12:K38)","v":0},"Final dollars:",{"$f":"SUM(M12:M38)","v":0}]