{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["readme","NZGP project list","assumptions","MCA - annual costs","MCA - costs split","Outputs - NEW","Calculations - NEW","Assumptions - with Mode added","Lines - BPE-TKU-A&B TTU","Lines - TKU-WKM TTU","Lines - TKU-WKM-AB Duplexing NZ","Lines - WRK-WKM-C TTU","Lines - EDG-KAW-3 TTU","Subs - BPE-TKU-WKM 1&2 Uprating","Subs - WRK-THI-WKM 1&1 Uprating","Subs - EDG-KAW Uprating","Subs - HVDC Capacity Stage 1"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"readme","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Yellow worksheets Inputs used"]
["Green worksheets Outputs tabulated for inclusion in MCA documents incl. those in Attachment E"]
["Black worksheets include the MCA calculations - cost phasing by year and calculation of IDC and Inflation.."]
["Red worksheets - for a selected individual project contain costing inputs and workings for the P50 cost calculations. "]
["Beige worksheets shows the TEES estimates for the projects costed at TEES level.  "]
[]
["The workbook uses the Macro CreateAllOutputs"]

{"sheet":"NZGP project list","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Adjusted",null,"Original",null,"Adjusted"]
[null,null,null,"Construction",null,"Construction",null,"Construction"]
[null,null,null,"Start","Finish","Start","Finish","Start","Finish"]
[null,"CNI","Lines - BPE-TKU-A&B TTU",{"$f":"IF($D$2=\"Original\",F5,H5)","v":"2024-09-02"},{"$f":"IF($D$2=\"Original\",G5,I5)","v":"2026-12-31"},"2024-09-02","2027-06-30","2024-09-02","2026-12-31"]
[null,"CNI","Lines - TKU-WKM TTU",{"$f":"IF($D$2=\"Original\",F6,H6)","v":"2022-11-01"},{"$f":"IF($D$2=\"Original\",G6,I6)","v":"2024-12-31"},"2022-11-01","2024-06-30","2022-11-01","2024-12-31"]
[null,"CNI","Lines - TKU-WKM-AB Duplexing NZ","2024-09-01","2028-06-30","2024-09-01","2028-06-30","2024-09-01","2028-06-30"]
[null,"CNI","Subs - BPE-TKU-WKM 1&2 Uprating","2023-09-01","2026-12-31","2023-09-01","2026-06-30","2023-09-01","2026-12-31"]
[null,"WRK Ring","Lines - WRK-WKM-C TTU","2022-09-01","2025-12-31","2022-09-01","2024-06-30","2022-09-01","2025-12-31"]
[null,"WRK Ring","Lines - EDG-KAW-3 TTU","2023-09-01","2025-06-30","2023-09-01","2024-06-30","2023-09-01","2025-06-30"]
[null,"WRK Ring","Subs - WRK-THI-WKM 1&1 Uprating","2023-09-01","2025-06-30","2023-09-01","2025-06-30","2023-09-01","2025-06-30"]
[null,"WRK Ring","Subs - EDG-KAW Uprating","2023-09-01","2025-06-30","2023-09-01","2025-09-30","2023-09-01","2025-06-30"]
[null,"HVDC","Subs - HVDC Capacity Stage 1","2024-07-01","2027-05-31","2024-07-01","2027-05-31","2024-07-01","2027-05-31"]

{"sheet":"assumptions","index":2,"n_rows":130,"n_cols":38,"rows_kept":130,"cut":false,"hidden":false,"merged":[]}
["Exchange rates (used in TEES - not used in this workbook)",null,null,null,null,null,null,null,null,null,null,null,"Interest Rates ",null,null,null,null,null,null,null,null,null,null,null,null,"CPI Updates (calculations use BYEFU2022 rates)"]
[]
["These rates are used in TEES but not this worksheet in which all costs have already been converted to NZD."]
["Currency ","Period Start ","Exchange Rate ",null,"NZD:USD rates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"actual Annual CPI to June 2022",7.2999999999999995E-2]
["AUD","2016-07-01",0.94569999999999999,null,"USD","2022-07-01",0.64119999999999999]
["AUD","2017-07-01",0.94974217532078198,null,"USD","2023-07-01",0.6391,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,2023,2024,2025,2026,2027,2028,2029,2030]
["AUD","2018-07-01",0.91410000000000002,null,"USD","2024-07-01",0.63649999999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BYEFU 19 May 2022",6.7000000000000004E-2,5.2000000000000005E-2,3.6000000000000004E-2,2.7000000000000003E-2,2.2000000000000002E-2,0.02,0.02,0.02,0.02]
["AUD","2019-07-01",0.92759999999999998,null,"USD","2025-07-01",0.64080000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RBNZ as August Monetary policy statement",6.3E-2,5.5E-2,3.4000000000000002E-2,2.1000000000000001E-2]
["AUD","2020-07-01",0.93469999999999998,null,"USD","2026-07-01",0.64080000000000004,null,null,null,null,null,"Forecast interest rates are",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BYEFU  May 2023",null,6.2E-2,3.3000000000000002E-2,2.5000000000000001E-2,2.3E-2,2.1999999999999999E-2,2.1000000000000001E-2,2.1000000000000001E-2,0.02]
["AUD","2021-07-01",0.9335,null,"USD","2027-07-01",0.64080000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RBNZ as May2022 Monetary policy statement",7.2999999999999995E-2,0.06,3.7000000000000005E-2,2.2000000000000002E-2,0.02]
["AUD","2022-07-01",0.93310000000000004,null,"USD","2028-07-01",0.64080000000000004,null,null,null,null,null,"2023/24 3.13%"]
["AUD","2023-07-01",0.92949999999999999,null,"USD","2029-07-01",0.64080000000000004,null,null,null,null,null,"2024/25 3.12% "]
["AUD","2024-07-01",0.9335,null,null,null,null,null,null,null,null,null,"RCP4 2025/26-2029/30 5.67%"]
["AUD","2025-07-01",0.93269999999999997,null,null,null,null,null,null,null,null,null,"RCP5 2030/31-2034/35 5.68%"]
["CAD","2016-07-01",0.9335]
["CAD","2017-07-01",0.93269999999999997]
["CAD","2018-07-01",0.89100000000000001]
["CAD","2019-07-01",0.93420000000000003]
["CAD","2020-07-01",0.87470000000000003]
["CAD","2021-07-01",0.87439999999999996]
["CAD","2022-07-01",0.875]
["CAD","2023-07-01",0.87549999999999994]
["CAD","2024-07-01",0.87509999999999999]
["CAD","2025-07-01",0.87490000000000001]
["CNY","2016-07-01",4.7840999999999996]
["CNY","2017-07-01",5.0458698750000002]
["CNY","2018-07-01",4.6695000000000002]
["CNY","2019-07-01",4.7055999999999996]
["CNY","2020-07-01",4.7862999999999998]
["CNY","2021-07-01",4.8205]
["CNY","2022-07-01",4.8490000000000002]
["CNY","2023-07-01",4.8773999999999997]
["EUR","2016-07-01",0.64359999999999995]
["EUR","2017-07-01",0.62006682678882596]
["EUR","2018-07-01",0.59889999999999999]
["EUR","2019-07-01",0.5696]
["EUR","2020-07-01",0.56859999999999999]
["EUR","2021-07-01",0.56230000000000002]
["EUR","2022-07-01",0.5554]
["EUR","2023-07-01",0.54790000000000005]
["EUR","2024-07-01",0.53939999999999999]
["EUR","2025-07-01",0.55469999999999997]
["GBP","2016-07-01",0.54602886911305204]
["GBP","2017-07-01",0.54602886911305204]
["GBP","2018-07-01",0.52800000000000002]
["GBP","2019-07-01",0.51529999999999998]
["GBP","2020-07-01",0.51870000000000005]
["GBP","2021-07-01",0.51649999999999996]
["GBP","2022-07-01",0.51400000000000001]
["GBP","2023-07-01",0.51100000000000001]
["GBP","2024-07-01",0.50690000000000002]
["GBP","2025-07-01",0.51339999999999997]
["HKD","2016-07-01",5.5808999999999997]
["HKD","2017-07-01",5.5855531740000002]
["HKD","2018-07-01",5.5888]
["HKD","2019-07-01",4.5717999999999996]
["HKD","2020-07-01",4.5561999999999996]
["HKD","2021-07-01",4.54]
["HKD","2022-07-01",4.5060000000000002]
["HKD","2023-07-01",4.4542000000000002]
["IDR","2016-07-01",9302.82]
["IDR","2017-07-01",9689.883812]
["IDR","2018-07-01",9637.6]
["IDR","2019-07-01",10030.0625]
["IDR","2020-07-01",10030.0625]
["IDR","2021-07-01",10030.0625]
["JPY","2016-07-01",73.575999999999993]
["JPY","2017-07-01",72.559157507888003]
["JPY","2018-07-01",80.533000000000001]
["JPY","2019-07-01",77.247]
["JPY","2020-07-01",69.58]
["JPY","2021-07-01",69.42]
["JPY","2022-07-01",69.209999999999994]
["JPY","2023-07-01",68.98]
["JPY","2024-07-01",68.69]
["JPY","2025-07-01",69.177999999999997]
["KRW","2016-07-01",799.98540000000003]
["KRW","2017-07-01",836.61146840000004]
["KRW","2018-07-01",765.59379999999999]
["KRW","2019-07-01",778.43719999999996]
["KRW","2020-07-01",778.92060000000004]
["KRW","2021-07-01",777.74400000000003]
["MYR","2016-07-01",2.8915999999999999]
["MYR","2017-07-01",3.1578973490000002]
["MYR","2018-07-01",2.8755000000000002]
["MYR","2019-07-01",2.8696999999999999]
["MYR","2020-07-01",2.8696999999999999]
["MYR","2021-07-01",2.8696999999999999]
["SEK","2016-07-01",6.1482000000000001]
["SEK","2017-07-01",6.0433706946510002]
["SEK","2018-07-01",5.8817000000000004]
["SEK","2019-07-01",5.8154000000000003]
["SEK","2020-07-01",5.9809999999999999]
["SEK","2021-07-01",5.944]
["SEK","2022-07-01",5.9039999999999999]
["SEK","2023-07-01",5.8650000000000002]
["SEK","2024-07-01",5.8140000000000001]
["SEK","2025-07-01",5.9013999999999998]
["SGD","2016-07-01"]
["SGD","2017-07-01"]
["SGD","2018-07-01",0.95450000000000002]
["SGD","2019-07-01",0.94940000000000002]
["SGD","2020-07-01",0.94940000000000002]
["SGD","2021-07-01",0.95660000000000001]
["SGD","2022-07-01",0.95179999999999998]
["SGD","2023-07-01",0.94450000000000001]
["THB","2016-07-01",25.002700000000001]
["THB","2017-07-01",24.657097050000001]
["THB","2018-07-01",23.057600000000001]
["THB","2019-07-01",22.818200000000001]
["THB","2020-07-01",22.832000000000001]
["THB","2021-07-01",22.832000000000001]
["TWD","2016-07-01",22.915600000000001]
["TWD","2017-07-01",22.722000000000001]
["TWD","2018-07-01",21.099799999999998]
["TWD","2019-07-01",21.309899999999999]
["TWD","2020-07-01",21.3231]
["TWD","2021-07-01",21.908999999999999]
["TWD","2022-07-01",21.185500000000001]
["TWD","2023-07-01",21.023099999999999]
["USD","2016-07-01",0.71970000000000001]
["USD","2017-07-01",0.71279099999999995]
["USD","2018-07-01",0.71460000000000001]
["USD","2019-07-01",0.72840000000000005]
["USD","2020-07-01",0.64439999999999997]
["USD","2021-07-01",0.64300000000000002]
["USD","2022-07-01",0.64119999999999999]
["USD","2023-07-01",0.6391]
["USD","2024-07-01",0.63649999999999995]
["USD","2025-07-01",0.64080000000000004]

{"sheet":"MCA - annual costs","index":3,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Record of initial MCA"]
[null,"calculated - table included in MCA documents",null,null,null,null,null,null,null,null,null,null,"calculated - table included in MCA documents"]
[null,"Major Capex Allowance, $000, P50",2022,2023,2024,2025,2026,2027,2028,2029,"Total",null,"Major Capex Allowance, $000, P50",2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[null,"Capex - total risk adjusted (real 2022)",{"$f":"SUMIF($B$17:$B$71,$B4,C$17:C$71)","v":3578963.3307498982},{"$f":"SUMIF($B$17:$B$71,$B4,D$17:D$71)","v":24759852.271420963},{"$f":"SUMIF($B$17:$B$71,$B4,E$17:E$71)","v":71207293.786039576},93805188.482232019,83977710.797391579,37656360.790578797,11797936.598328581,{"$f":"SUMIF($B$17:$B$71,$B4,J$17:J$61)","v":0},{"$f":"SUM(C4:J4)","v":326783306.05674142},null,"Capex - total risk adjusted (real 2022)",4767755.0652724132,31733877.04916602,65204288.619170494,86914789.587054521,77350414.875201628,49014244.262547739,11797936.598328581,0,326783306.05674142]
[null,"Inflation",{"$f":"SUMIF($B$17:$B$71,$B5,C$17:C$61)","v":54361.561752949579},1085366.1829974079,6588919.0642611431,11238786.503830388,12864772.881567784,6587651.6790838847,2297241.3829207504,0,{"$f":"SUM(C5:J5)","v":40717099.256414309},null,"Inflation",71333.672272768628,1465757.4166594611,5877082.0027788747,10386826.345032185,11831213.970702279,8533140.4430911522,2297241.3829207504,0,40462595.233457468]
[null,"Capex - total risk adjusted (nominal)",3633324.8925028481,25845218.454418376,77796212.850300714,105043974.98606242,96842483.67895937,44244012.469662681,14095177.981249332,0,{"$f":"SUM(C6:J6)","v":367500405.31315571},null,"Capex - total risk adjusted (nominal)",4839088.7375451811,33199634.465825483,71081370.62194939,97301615.932086706,89181628.845903903,57547384.705638893,14095177.981249332,0,367245901.29019892]
[null,"Interest during construction (IDC)",15848.638373278831,375299.28685579926,1540834.1392899472,3366725.2097536186,10641779.945437323,6736786.895494787,2707802.4254752798,0,{"$f":"SUM(C7:J7)","v":25385076.540680032},null,"Interest during construction (IDC)",21590.803934520547,500528.8216659262,1180757.8783767954,3046418.195447735,9648832.5367131624,8682921.6381974034,2707802.4254752798,0,25788852.299810823]
[null,"Major Capex Allowance",3649173.5308761266,26220517.741274174,79337046.98959066,108410700.19581605,107484263.62439668,50980799.36515747,16802980.406724613,0,{"$f":"SUM(C8:J8)","v":392885481.85383582},null,"Major Capex Allowance",4860679.5414797021,33700163.287491411,72262128.500326172,100348034.12753443,98830461.382617071,66230306.343836293,16802980.406724613,0,393034753.59000969]
[]
[]
[]
[]
[]
[]
["Macro dumped"]
["Project","Major Capex Allowance, $000, P50",2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
["Lines - BPE-TKU-A&B TTU","Capex - total risk adjusted (real 2022)",0,0,13629460.166362731,27258920.332725462,27258920.332725462,0,0,0,{"$f":"SUM(C17:J17)","v":68147300.831813648}]
["Lines - BPE-TKU-A&B TTU","Inflation",0,0,1401250.9985909471,3443231.7751513114,4175867.807629684,0,0,0,{"$f":"SUM(C18:J18)","v":9020350.5813719425}]
["Lines - BPE-TKU-A&B TTU","Capex - total risk adjusted (nominal)",0,0,15030711.164953679,30702152.107876774,31434788.140355147,0,0,0,77167651.413185596]
["Lines - BPE-TKU-A&B TTU","Interest during construction (IDC)",0,0,114595.9613521392,929563.64002328203,3368196.2351546115,0,0,0,4412355.8365300326]
["Lines - BPE-TKU-A&B TTU","Major Capex Allowance",0,0,15145307.126305819,31631715.747900058,34802984.375509761,0,0,0,81580007.249715626]
["Lines - TKU-WKM TTU","Capex - total risk adjusted (real 2022)",3107850.8866244201,12431403.54649768,12431403.54649768,0,0,0,0,0,27970657.979619779]
["Lines - TKU-WKM TTU","Inflation",50797.458342120051,611212.25863782223,1157927.4278041455,0,0,0,0,0,1819937.1447840878]
["Lines - TKU-WKM TTU","Capex - total risk adjusted (nominal)",3158648.3449665401,13042615.805135503,13589330.974301826,0,0,0,0,0,29790595.124403872]
["Lines - TKU-WKM TTU","Interest during construction (IDC)",11920.17820902136,290684.10151119489,693126.88012562692,0,0,0,0,0,995731.15984584321]
["Lines - TKU-WKM TTU","Major Capex Allowance",3170568.5231755613,13333299.906646699,14282457.854427453,0,0,0,0,0,30786326.284249716]
["Lines - TKU-WKM-AB Duplexing NZ","Capex - total risk adjusted (real 2022)",0,0,11797936.598328581,23595873.196657162,23595873.196657162,23595873.196657162,11797936.598328581,0,94383492.786628649]
["Lines - TKU-WKM-AB Duplexing NZ","Inflation",0,0,1212951.2275563916,2980531.1201424161,3614715.6993793147,4179234.5916970829,2297241.3829207504,0,14284674.021695957]
["Lines - TKU-WKM-AB Duplexing NZ","Capex - total risk adjusted (nominal)",0,0,13010887.825884972,26576404.316799577,27210588.896036476,27775107.788354244,14095177.981249332,0,108668166.80832461]
["Lines - TKU-WKM-AB Duplexing NZ","Interest during construction (IDC)",0,0,96371.309295819228,781731.43281684234,2832538.5756802638,4297999.7061194088,2707802.4254752798,0,10716443.449387614]
["Lines - TKU-WKM-AB Duplexing NZ","Major Capex Allowance",0,0,13107259.135180792,27358135.749616418,30043127.471716739,32073107.494473651,16802980.406724613,0,119384610.25771222]
["Subs - BPE-TKU-WKM 1&2 Uprating","Capex - total risk adjusted (real 2022)",0,2500971.0400828393,5001942.0801656786,5001942.0801656786,5001942.0801656786,0,0,0,17506797.280579872]
["Subs - BPE-TKU-WKM 1&2 Uprating","Inflation",0,156216.81695206254,465907.64311108855,631824.21378649306,766261.04971281136,0,0,0,2020209.7235624555]
["Subs - BPE-TKU-WKM 1&2 Uprating","Capex - total risk adjusted (nominal)",0,2657187.8570349021,5467849.7232767669,5633766.2939521717,5768203.1298784902,0,0,0,19527007.004142333]
["Subs - BPE-TKU-WKM 1&2 Uprating","Interest during construction (IDC)",0,20487.688376565748,166329.20471921083,339239.30100589525,923682.55201042234,0,0,0,1449738.7461120943]
["Subs - BPE-TKU-WKM 1&2 Uprating","Major Capex Allowance",0,2677675.545411468,5634178.9279959779,5973005.5949580669,6691885.6818889128,0,0,0,20976745.750254426]
["Lines - WRK-WKM-C TTU","Capex - total risk adjusted (real 2022)",471112.44412547821,802224.90225095639,802224.90225095639,802224.90225095639,0,0,0,0,2877787.1508783475]
["Lines - WRK-WKM-C TTU","Inflation",3564.103410829528,39442.826596877247,74723.518877768802,101333.66400913382,0,0,0,0,219064.1128946094]
["Lines - WRK-WKM-C TTU","Capex - total risk adjusted (nominal)",474676.54753630771,841667.72884783358,876948.42112872517,903558.56626009021,0,0,0,0,3096851.2637729566]
["Lines - WRK-WKM-C TTU","Interest during construction (IDC)",3928.4601642574708,27603.234399974754,54217.684528955506,82036.450594549795,0,0,0,0,167785.82968773751]
["Lines - WRK-WKM-C TTU","Major Capex Allowance",478605.00770056515,869270.96324780839,931166.10565768066,985595.01685463998,0,0,0,0,3264637.093460694]
["Lines - EDG-KAW-3 TTU","Capex - total risk adjusted (real 2022)",0,2416208.205744158,4832416.411488316,2416208.205744158,0,0,0,0,9664832.822976632]
["Lines - EDG-KAW-3 TTU","Inflation",0,150922.32134855282,450117.11545714061,287079.56425126502,0,0,0,0,888119.00105695846]
["Lines - EDG-KAW-3 TTU","Capex - total risk adjusted (nominal)",0,2567130.5270927111,5282533.5269454569,2703287.769995423,0,0,0,0,10552951.824033592]
["Lines - EDG-KAW-3 TTU","Interest during construction (IDC)",0,19793.320265934664,160691.98037740792,142755.08530061657,0,0,0,0,323240.38594395912]
["Lines - EDG-KAW-3 TTU","Major Capex Allowance",0,2586923.8473586459,5443225.5073228646,2846042.8552960395,0,0,0,0,10876192.20997755]
["Subs - WRK-THI-WKM 1&1 Uprating","Capex - total risk adjusted (real 2022)",0,1929786.1454459289,3859572.2908918578,1929786.1454459289,0,0,0,0,7719144.5817837156]
["Subs - WRK-THI-WKM 1&1 Uprating","Inflation",0,120539.20025789971,359501.20985941705,229285.77281365567,0,0,0,0,709326.18293097243]
["Subs - WRK-THI-WKM 1&1 Uprating","Capex - total risk adjusted (nominal)",0,2050325.3457038286,4219073.5007512746,2159071.9182595843,0,0,0,0,8428470.7647146881]
["Subs - WRK-THI-WKM 1&1 Uprating","Interest during construction (IDC)",0,15808.602557829137,128342.06782320075,114016.16183164796,0,0,0,0,258166.83221267787]
["Subs - WRK-THI-WKM 1&1 Uprating","Major Capex Allowance",0,2066133.9482616577,4347415.5685744751,2273088.0800912324,0,0,0,0,8686637.5969273653]
["Subs - EDG-KAW Uprating","Capex - total risk adjusted (real 2022)",0,112591.76473273447,225183.52946546895,112591.76473273447,0,0,0,0,450367.0589309379]
["Subs - EDG-KAW Uprating","Inflation",0,7032.7592041932148,20974.798548090723,13377.487370878036,0,0,0,0,41385.045123161974]
["Subs - EDG-KAW Uprating","Capex - total risk adjusted (nominal)",0,119624.5239369277,246158.32801355969,125969.25210361251,0,0,0,0,491752.10405409988]
["Subs - EDG-KAW Uprating","Interest during construction (IDC)",0,922.33974430006322,7488.0110108383788,6652.1779622953445,0,0,0,0,15062.528717433786]
["Subs - EDG-KAW Uprating","Major Capex Allowance",0,120546.86368122775,253646.33902439807,132621.43006590786,0,0,0,0,506814.63277153368]
["Subs - HVDC Capacity Stage 1","Capex - total risk adjusted (real 2022)",0,0,14060487.593921637,28120975.187843274,28120975.187843274,14060487.593921637,0,0,84362925.563529819]
["Subs - HVDC Capacity Stage 1","Inflation",0,0,1445565.1244561533,3552122.9063052339,4307928.3248459725,2408417.0873868018,0,0,11714033.442994162]
["Subs - HVDC Capacity Stage 1","Capex - total risk adjusted (nominal)",0,0,15506052.718377791,31673098.094148509,32428903.512689248,16468904.681308439,0,0,96076959.006523982]
["Subs - HVDC Capacity Stage 1","Interest during construction (IDC)",0,0,119671.0400567483,970730.96021848894,3517362.5825920254,2438787.1893753787,0,0,7046551.7722426411]
["Subs - HVDC Capacity Stage 1","Major Capex Allowance",0,0,15625723.75843454,32643829.054366998,35946266.095281273,18907691.870683819,0,0,103123510.77876663]
["CNI Supporting Projects","Capex - total risk adjusted (real 2022)",null,{"$f":"D64-D63","v":3400000},{"$f":"E64-E63","v":3400000},{"$f":"F64-F63","v":3400000},0,0,0,{"$f":"J64-J63","v":0},10200000]
["CNI Supporting Projects","Inflation",null,0,0,0,0,0,0,0,0]
["CNI Supporting Projects","Capex - total risk adjusted (nominal)",null,{"$f":"D66-D65","v":3400000},{"$f":"E66-E65","v":3400000},{"$f":"F66-F65","v":3400000},0,0,0,0,10200000]
["CNI Supporting Projects","Interest during construction (IDC)",null,0,0,0,0,0,0,0,0]
["CNI Supporting Projects","Major Capex Allowance",null,{"$f":"10200000/(2026-$D$16)","v":3400000},{"$f":"10200000/(2026-$D$16)","v":3400000},3400000,0,0,0,0,10200000]
["Preparedness Projects","Capex - total risk adjusted (real 2022)",null,{"$f":"D69-D68","v":1166666.6666666667},{"$f":"E69-E68","v":1166666.6666666667},{"$f":"F69-F68","v":1166666.6666666667},0,0,0,{"$f":"J69-J68","v":0},3500000]
["Preparedness Projects","Inflation",null,0,0,0,0,0,0,0,0]
["Preparedness Projects","Capex - total risk adjusted (nominal)",null,{"$f":"D71-D70","v":1166666.6666666667},{"$f":"E71-E70","v":1166666.6666666667},{"$f":"F71-F70","v":1166666.6666666667},0,0,0,0,3500000]
["Preparedness Projects","Interest during construction (IDC)",null,0,0,0,0,0,0,0,0]
["Preparedness Projects","Major Capex Allowance",null,{"$f":"3500000/(2026-$D$16)","v":1166666.6666666667},{"$f":"3500000/(2026-$D$16)","v":1166666.6666666667},1166666.6666666667,0,0,0,0,3500000]
[]
[]
[null,"Major Capex Allowance, $000, P50",2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[null,"Capex - total risk adjusted (real 2022)",{"$f":"C4/1000","v":3578.9633307498984},{"$f":"D4/1000","v":24759.852271420965},71207.293786039576,93805.188482232013,83977.710797391584,37656.360790578794,11797.936598328581,0,{"$f":"SUM(C75:J75)","v":326783.30605674145}]
[null,"Inflation",{"$f":"C5/1000","v":54.361561752949576},1085.3661829974078,6588.9190642611429,11238.786503830388,12864.772881567784,6587.651679083885,2297.2413829207503,0,{"$f":"SUM(C76:J76)","v":40717.099256414309}]
[null,"Capex - total risk adjusted (nominal)",{"$f":"C6/1000","v":3633.3248925028479},25845.218454418376,77796.212850300712,105043.97498606243,96842.483678959368,44244.012469662681,14095.177981249333,0,367500.40531315579]
[null,"Interest during construction (IDC)",{"$f":"C7/1000","v":15.848638373278831},375.29928685579927,1540.8341392899472,3366.7252097536184,10641.779945437323,6736.7868954947871,2707.80242547528,0,25385.076540680035]
[null,"Major Capex Allowance",{"$f":"C77+C78","v":3649.1735308761267},{"$f":"D77+D78","v":26220.517741274176},79337.046989590657,108410.70019581605,107484.2636243967,50980.799365157465,16802.980406724615,0,392885.48185383575]

{"sheet":"MCA - costs split","index":4,"n_rows":32,"n_cols":46,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,44,2,44],[1,45,2,45],[1,2,1,7],[1,33,2,33],[1,34,1,38],[1,39,1,42]]}
[null,null,"Macro dumped",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Macro dumped",null,null,null,null,null,null,null,null,null,null,null,"calculated - table included in MCA documents (includes support and preparedness projects $13.7M)"]
[null,null,"NZGP Projects Cost Estimates, P50, Inflation and IDC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Central North Island",null,null,null,null,"Wairakei Ring",null,null,null,"HVDC","Preparedness Projects","NZGP"]
[null,null,null,"Real 2022","Inflation","Nominal","IDC","Major Capex Allowance",null,"Low","P50","High",null,"Mode",null,"start","end",null,"mode input","diffference",null,null,0,0,0,0,69999.993000000002,0,0,0,0,"NZGP",null,null,"Lines - BPE-TKU-A&B TTU","Lines - TKU-WKM TTU","Lines - TKU-WKM-AB Duplexing NZ","Subs - BPE-TKU-WKM 1&2 Uprating","CNI Supporting Projects","Lines - WRK-WKM-C TTU","Lines - EDG-KAW-3 TTU","Subs - WRK-THI-WKM 1&1 Uprating","Subs - EDG-KAW Uprating","Subs - HVDC Capacity Stage 1",null,"NZGP"]
[null,null,"Lines - BPE-TKU-A&B TTU",68147300.831813648,9020350.5813719425,77167651.413185596,4412355.8365300326,81580007.249715626,null,60809695.239741698,68147300.831813648,78699507.422223061,null,66233851.649259359,null,"2024-09-02","2026-12-31",null,{"$f":"'Lines - BPE-TKU-A&B TTU'!C18","v":66233851.649259359},{"$f":"N4-S4","v":0},null,"Investigation",null,null,null,null,null,null,null,null,null,{"$f":"SUM(W4:AE4)","v":0},null,"Investigation",{"$f":"W4/1000","v":0},{"$f":"X4/1000","v":0},{"$f":"Y4/1000","v":0},{"$f":"Z4/1000","v":0},null,{"$f":"AA4/1000","v":0},{"$f":"AB4/1000","v":0},{"$f":"AC4/1000","v":0},{"$f":"AD4/1000","v":0},{"$f":"AE4/1000","v":0},null,{"$f":"SUM(AI4:AS4)","v":0}]
[null,null,"Lines - TKU-WKM TTU",27970657.979619779,1819937.1447840878,29790595.124403868,995731.15984584321,30786326.284249712,null,25809721.979895789,27970657.979619779,30629306.935287118,null,27690909.492345132,null,"2022-11-01","2024-12-31",null,{"$f":"'Lines - TKU-WKM TTU'!C24","v":27690909.492345136},0,null,null,0,0,0,0,0,0,0,0,10018671.218370307]
[null,null,"Lines - TKU-WKM-AB Duplexing NZ",94383492.786628649,14284674.021695957,108668166.80832461,10716443.449387614,119384610.25771222,null,81762530.788616747,94383492.786628649,112565919.93824723,null,90904459.41521351,null,"2024-09-01","2028-06-30",null,{"$f":"'Lines - TKU-WKM-AB Duplexing NZ'!C25","v":90904459.415213525},0,null,"Civil Works",0,0,0,0,0,0,0,0,36378807.015606456,36378807.015606456,null,"Civil Works",{"$f":"W6/1000","v":0},{"$f":"X6/1000","v":0},{"$f":"Y6/1000","v":0},{"$f":"Z6/1000","v":0},null,{"$f":"AA6/1000","v":0},{"$f":"AB6/1000","v":0},{"$f":"AC6/1000","v":0},{"$f":"AD6/1000","v":0},{"$f":"AE6/1000","v":36378.807015606457},null,{"$f":"SUM(AI6:AS6)","v":36378.807015606457}]
[null,null,"Subs - BPE-TKU-WKM 1&2 Uprating",17506797.280579872,2020209.7235624555,19527007.004142329,1449738.7461120943,20976745.750254422,null,13692402.277304828,17506797.280579872,20818478.169467166,null,17775886.50093263,null,"2023-09-01","2026-12-31",null,{"$f":"'Subs - BPE-TKU-WKM 1&2 Uprating'!C20","v":17775886.50093263},0,null,"Primary Plant 220 kV - Statcom",0,0,0,10139836.330579877,0,0,5123910.1923969164,191488.81251774466,8984483.1641097534,24439718.499604292,null,"Primary Plant 220 kV - Statcom",0,0,0,10139.836330579878,null,0,0,5123.9101923969165,191.48881251774466,8984.4831641097535,null,24439.718499604292]
[null,null,"Lines - WRK-WKM-C TTU",2877787.1508783475,219064.1128946094,3096851.263772957,167785.82968773751,3264637.0934606944,null,2477039.3189624031,2877787.1508783475,3416811.6664962289,null,2788541.1711666617,null,"2022-09-01","2025-12-31",null,{"$f":"'Lines - WRK-WKM-C TTU'!C27","v":2788541.1711666617},0,null,"Primary Plant 220 kV - other",0,0,0,0,0,0,0,0,368664.18757221347,368664.18757221347,null,"Primary Plant 220 kV - other",0,0,0,0,null,0,0,0,0,368.66418757221345,null,368.66418757221345]
[null,null,"Lines - EDG-KAW-3 TTU",9664832.822976632,888119.00105695846,10552951.82403359,323240.38594395912,10876192.209977549,null,8556434.9672506955,9664832.822976632,11440664.866714913,null,9235335.486527659,null,"2023-09-01","2025-06-30",null,{"$f":"'Lines - EDG-KAW-3 TTU'!C18","v":9235335.4865276571},0,null,"Cables",0,0,0,0,0,0,0,0,764095.07121802692,764095.07121802692,null,"Cables",0,0,0,0,null,0,0,0,0,764.09507121802687,null,764.09507121802687]
[null,null,"Subs - WRK-THI-WKM 1&1 Uprating",7719144.5817837156,709326.18293097243,8428470.7647146881,258166.83221267787,8686637.5969273653,null,6547473.5990257571,7719144.5817837156,9308182.0728674717,null,7478912.3966267258,null,"2023-09-01","2025-06-30",null,{"$f":"'Subs - WRK-THI-WKM 1&1 Uprating'!C20","v":7478912.3966267258},0,null,"Protection",0,0,0,62500,0,0,58125,0,317115.10305653018,437740.10305653018,null,"Protection",0,0,0,62.5,null,0,0,58.125,0,317.11510305653019,null,437.74010305653019]
[null,null,"Subs - EDG-KAW Uprating",450367.0589309379,41385.045123161974,491752.10405409988,15062.528717433786,506814.63277153368,null,427321.90869170142,450367.0589309379,480998.41211787087,null,446037.87116709125,null,"2023-09-01","2025-06-30",null,{"$f":"'Subs - EDG-KAW Uprating'!C20","v":446037.87116709119},0,null,"SCADA",0,0,0,0,0,0,0,0,4186033.1733722533,4186033.1733722533,null,"SCADA",0,0,0,0,null,0,0,0,0,4186.0331733722533,null,4186.0331733722533]
[null,null,"Subs - HVDC Capacity Stage 1",84362925.563529819,11714033.442994162,96076959.006523982,7046551.7722426411,103123510.77876662,null,80586773.687585592,84362925.563529819,93479362.636014938,null,80586773.687585592,null,"2024-07-01","2027-05-31",null,{"$f":"'Subs - HVDC Capacity Stage 1'!C28","v":80586773.687585622},0,null,"Secondary Equipment",0,0,0,0,0,0,0,0,102902.30728215167,102902.30728215167,null,"Secondary Equipment",0,0,0,0,null,0,0,0,0,102.90230728215167,null,102.90230728215167]
[null,null,"Total NZGP Stage 1 ",{"$f":"SUM(D4:D12)","v":313083306.05674136},{"$f":"SUM(E4:E12)","v":40717099.256414309},{"$f":"SUM(F4:F12)","v":353800405.31315571},{"$f":"SUM(G4:G12)","v":25385076.540680036},{"$f":"SUM(H4:H12)","v":379185481.85383576},null,{"$f":"SUM(J4:J12)","v":280669393.76707518},{"$f":"SUM(K4:K12)","v":313083306.05674136},{"$f":"SUM(L4:L12)","v":360839232.11943603},null,{"$f":"SUM(N4:N12)","v":303140707.67082441},null,null,null,null,null,{"$f":"IF(SUM(T4:T12)=0,\"OK\",\"ERROR\")","v":"OK"},null,"Communications",0,0,0,0,0,0,0,0,276668.82559307542,276668.82559307542,null,"Communications",0,0,0,0,null,0,0,0,0,276.66882559307544,null,276.66882559307544]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Miscellaneous works",0,0,0,0,0,0,0,0,65021.894556904474,65021.894556904474,null,"Miscellaneous works",0,0,0,0,null,0,0,0,0,65.021894556904471,null,65.021894556904471]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Switching",null,null,null,null,null,null,null,null,null,0,null,"Switching",0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45373889.36544919,17392169.075796258,55778159.057305634,0,1024230.4738268182,5380666.738360323,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Work ",5452393.9726521773,1608047.4578892023,6160048.3189990548,746638,443392.17238932662,1064141.1034106507,570110.80000000005,35970.030413193213,3493087.7678884207,{"$f":"SUM(W17:AE17)","v":19573829.623642024},null,"Construction Work ",{"$f":"W17/1000","v":5452.3939726521776},{"$f":"X17/1000","v":1608.0474578892022},{"$f":"Y17/1000","v":6160.0483189990546},{"$f":"Z17/1000","v":746.63800000000003},null,{"$f":"AA17/1000","v":443.39217238932662},{"$f":"AB17/1000","v":1064.1411034106507},{"$f":"AC17/1000","v":570.11080000000004},{"$f":"AD17/1000","v":35.970030413193214},{"$f":"AE17/1000","v":3493.0877678884208},null,19573.829623642028]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transpower overheads",0,0,0,0,0,0,0,0,1221374.0325248744,1221374.0325248744,null,"Transpower overheads",0,0,0,0,null,0,0,0,0,1221.3740325248743,null,1221.3740325248743]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consultant support ",8738226.892495675,3145244.4201745233,14762951.179923963,2272940,440499.47929172695,1409704.2845735063,1102510.5893867991,66767.255999999994,5353181.8396254275,37292025.941471621,null,"Consultant support ",8738.2268924956752,3145.2444201745234,14762.951179923963,2272.94,null,440.49947929172697,1409.7042845735064,1102.5105893867992,66.767255999999989,5353.1818396254275,null,37292.025941471613]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contractor overheads ",0,45528,561506.5,0,20000,0,0,0,177653.28291202418,804687.78291202418,null,"Contractor overheads ",0,45.527999999999999,561.50649999999996,0,null,20,0,0,0,177.65328291202417,null,804.6877829120242]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freight",0,1005649.1822852341,2999999.7,0,131715.71675253811,0,570000,60000,3534379.2214584197,8301743.8204961922,null,"Freight",0,1005.6491822852341,2999.9997000000003,0,null,131.7157167525381,0,570,60,3534.3792214584196,null,8301.7438204961927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design",154770.29226990804,0,300000,0,0,0,0,0,26313.85956287304,481084.15183278103,null,"Design",154.77029226990803,0,300,0,null,0,0,0,0,26.313859562873041,null,481.08415183278112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal",826289.32638985803,676776.69953927747,3800000.0303999996,0,0,0,0,0,0,5303066.0563291349,null,"Legal",826.28932638985805,676.7766995392775,3800.0000303999996,0,null,0,0,0,0,0,null,5303.0660563291349]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property",506534.68031185423,697000,500000,80000,343289.32188134524,200000,0,0,147357.61355208902,2474181.6157452883,null,"Property",506.53468031185423,697,500,80,null,343.28932188134524,200,0,0,147.35761355208902,null,2474.1816157452881]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Environmental costs",295333,69794.100000000006,379496,66632.95,10000,130897.4028955586,0,0,212615.98526801416,1164769.4381635727,null,"Environmental costs",295.33300000000003,69.7941,379.49599999999998,66.632949999999994,null,10,130.8974028955586,0,0,212.61598526801416,null,1164.7694381635727]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Community Care Fund",369413.30224498361,1151899.0439352882,390000,225000,159330.34373659253,159330.34373659253,0,0,0,2454973.0336534572,null,"Community Care Fund",369.41330224498364,1151.8990439352883,390,225,null,159.33034373659254,159.33034373659254,0,0,0,null,2454.9730336534572]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stakeholder costs",null,null,null,null,null,null,null,null,null,0,null,"Stakeholder costs",0,0,0,0,null,0,0,0,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61716850.831813641,25792107.979619786,85632160.786628649,13593547.280579876,2642457.500878348,8344739.8729766319,7424656.5817837156,354226.09893093788,75628425.563529819,null,null,"Uncategorised",0,0,0,0,3500,0,0,0,0,0,10200,13700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6430450,2178550,8751332,3913250,235329.65,1320092.95,294488,96140.96,8734500,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capex - sub-total (Stage I)",68147300.831813633,27970657.979619786,94383492.786628649,17506797.280579876,2877787.1508783479,9664832.822976632,7719144.5817837156,450367.0589309379,84362925.563529819,{"$f":"SUM(W30:AE30)","v":313083306.05674136},null,"Capex - sub-total (Stage I)",61716.850831813637,25792.107979619785,85632.16078662865,13593.547280579876,3500,2642.4575008783481,8344.7398729766319,7424.6565817837154,354.22609893093789,75628.425563529818,10200,294829.1724967414]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Risk adjustment ",6430450,2178550,8751332,3913250,235329.65,1320092.95,294488,96140.96,8734500,{"$f":"SUM(W31:AE31)","v":31954133.559999999},null,"Additional Risk adjustment ",6430.45,2178.5500000000002,8751.3320000000003,3913.25,0,235.32964999999999,1320.09295,294.488,96.140960000000007,8734.5,0,31954.133559999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capex - total risk adjusted (Stage I)",68147300.831813633,27970657.979619786,94383492.786628649,17506797.280579876,2877787.1508783479,9664832.822976632,7719144.5817837156,450367.0589309379,84362925.563529819,{"$f":"SUM(W32:AE32)","v":313083306.05674136},null,"Capex - total risk adjusted (Stage I)",68147.300831813627,27970.657979619788,94383.492786628645,17506.797280579874,3500,2877.7871508783478,9664.8328229766321,7719.1445817837157,450.3670589309379,84362.925563529818,10200,326783.30605674139]

{"sheet":"Outputs - NEW","index":5,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,5,47,7],[1,2,2,2],[47,4,48,4],[1,4,2,4],[3,2,3,5],[4,2,4,3],[4,4,4,5],[4,7,4,8]]}
[]
[null,null,"Capex, $000, P50","Lines","Capex, $000, P50","Substations"]
[null,null,null,"Real 2022",null,"Real 2022"]
[null,null,{"$f":"'Assumptions - with Mode added'!C3","v":"Subs - HVDC Capacity Stage 1"}]
[null,null,"Lines Project",null,"Substation Project",null,null,"Project Costs","Combined"]
[null,null,{"$f":"'Calculations - NEW'!B40","v":"Investigation "},{"$f":"'Calculations - NEW'!F40","v":0},"Investigation",{"$f":"'Calculations - NEW'!F57","v":0},null,"Investigation",{"$f":"D6+F6","v":0}]
[]
[null,null,null,null,"Civil Works",{"$f":"'Calculations - NEW'!F59","v":10018671.218370307},null,"Civil Works",{"$f":"D8+F8","v":10018671.218370307}]
[null,null,null,null,"Primary Plant 220 kV - Statcom",{"$f":"'Calculations - NEW'!F60","v":36378807.015606456},null,"Primary Plant 220 kV - Statcom",36378807.015606456]
[null,null,null,null,"Primary Plant 220 kV - other",{"$f":"'Calculations - NEW'!F61","v":8984483.1641097534},null,"Primary Plant 220 kV - other",8984483.1641097534]
[null,null,null,null,"Cables",{"$f":"'Calculations - NEW'!F62","v":368664.18757221347},null,"Cables",368664.18757221347]
[null,null,null,null,"Protection",{"$f":"'Calculations - NEW'!F63","v":764095.07121802692},null,"Protection",764095.07121802692]
[null,null,null,null,"SCADA",{"$f":"'Calculations - NEW'!F64","v":317115.10305653018},null,"SCADA",317115.10305653018]
[null,null,null,null,"Secondary Equipment",{"$f":"'Calculations - NEW'!F65","v":4186033.1733722533},null,"Secondary Equipment",4186033.1733722533]
[null,null,null,null,"Communications",{"$f":"'Calculations - NEW'!F66","v":102902.30728215167},null,"Communications",102902.30728215167]
[null,null,null,null,"Miscellaneous works",{"$f":"'Calculations - NEW'!F67","v":276668.82559307542},null,"Miscellaneous works",276668.82559307542]
[null,null,null,null,"Switching",{"$f":"'Calculations - NEW'!F68","v":65021.894556904474},null,"Switching",65021.894556904474]
[]
[null,null,{"$f":"'Calculations - NEW'!B42","v":"Construction work"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F42,\"\")","v":""},{"$f":"'Calculations - NEW'!B70","v":"Construction Work "},{"$f":"'Calculations - NEW'!F70","v":0},null,"Construction Work ",{"$f":"IF(D19<>\"\",D19,F19)","v":0}]
[null,null,{"$f":"'Calculations - NEW'!B43","v":"Transpower overheads"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F43,\"\")","v":""},{"$f":"'Calculations - NEW'!B71","v":"Transpower overheads"},{"$f":"'Calculations - NEW'!F71","v":3493087.7678884207},null,"Transpower overheads",{"$f":"IF(D20<>\"\",D20,F20)","v":3493087.7678884207}]
[null,null,{"$f":"'Calculations - NEW'!B44","v":"Consultant support "},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F44,\"\")","v":""},{"$f":"'Calculations - NEW'!B72","v":"Consultant support "},{"$f":"'Calculations - NEW'!F72","v":1221374.0325248744},null,"Consultant support ",1221374.0325248744]
[null,null,{"$f":"'Calculations - NEW'!B45","v":"Contractor overheads"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F45,\"\")","v":""},{"$f":"'Calculations - NEW'!B73","v":"Contractor overheads "},{"$f":"'Calculations - NEW'!F73","v":5353181.8396254275},null,"Contractor overheads ",5353181.8396254275]
[null,null,{"$f":"'Calculations - NEW'!B46","v":"Freight"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F46,\"\")","v":""},{"$f":"'Calculations - NEW'!B74","v":"Freight"},{"$f":"'Calculations - NEW'!F74","v":177653.28291202418},null,"Freight",177653.28291202418]
[null,null,{"$f":"'Calculations - NEW'!B47","v":"Design"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F47,\"\")","v":""},{"$f":"'Calculations - NEW'!B75","v":"Design"},{"$f":"'Calculations - NEW'!F75","v":3534379.2214584197},null,"Design",3534379.2214584197]
[null,null,{"$f":"'Calculations - NEW'!B48","v":"Legal"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F48,\"\")","v":""},{"$f":"'Calculations - NEW'!B76","v":"Legal"},{"$f":"'Calculations - NEW'!F76","v":26313.85956287304},null,"Legal",26313.85956287304]
[null,null,{"$f":"'Calculations - NEW'!B49","v":"Property"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F49,\"\")","v":""},{"$f":"'Calculations - NEW'!B77","v":"Property"},{"$f":"'Calculations - NEW'!F77","v":0},null,"Property",0]
[null,null,{"$f":"'Calculations - NEW'!B50","v":"Environmental costs"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F50,\"\")","v":""},{"$f":"'Calculations - NEW'!B78","v":"Environmental costs"},{"$f":"'Calculations - NEW'!F78","v":147357.61355208902},null,"Environmental costs",147357.61355208902]
[null,null,{"$f":"'Calculations - NEW'!B51","v":"Community Care Fund"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F51,\"\")","v":""},{"$f":"'Calculations - NEW'!B79","v":"Community Care Fund"},{"$f":"'Calculations - NEW'!F79","v":212615.98526801416},null,"Community Care Fund",212615.98526801416]
[null,null,{"$f":"'Calculations - NEW'!B52","v":"Stakeholder costs"},{"$f":"IF(Type=\"Lines\",'Calculations - NEW'!F52,\"\")","v":""},{"$f":"'Calculations - NEW'!B80","v":"Stakeholder costs"},{"$f":"'Calculations - NEW'!F80","v":0},null,"Stakeholder costs",0]
[]
[null,null,"Capex - sub-total (Stage I)",null,null,{"$f":"SUM(D6:D29,F6:F29)","v":75628425.563529819},null,"Capex - sub-total (Stage I)",{"$f":"SUM(G6:G29,I6:I29)","v":75628425.563529819}]
[null,null,"Additional Risk adjustment ",null,null,{"$f":"'Calculations - NEW'!F82+'Calculations - NEW'!F54","v":8734500},null,"Additional Risk adjustment ",{"$f":"F32","v":8734500}]
[null,null,"Capex - total risk adjusted (Stage I)",null,null,{"$f":"F31+F32","v":84362925.563529819},null,"Capex - total risk adjusted (Stage I)",{"$f":"I31+I32","v":84362925.563529819}]
[null,null,null,null,"check",{"$f":"'Calculations - NEW'!F86","v":84362925.563529819}]
[]
[null,null,null,null,null,"Total project"]
[null,null,null,null,null,"Real 2019","Inflation","Nominal","IDC","Major Capex Allowance"]
[null,null,null,null,{"$f":"C4","v":"Subs - HVDC Capacity Stage 1"},{"$f":"N42","v":84362925.563529819},{"$f":"N43","v":11714033.442994162},{"$f":"+F38+G38","v":96076959.006523982},{"$f":"'Calculations - NEW'!F117","v":7046551.7722426411},{"$f":"+I38+H38","v":103123510.77876662}]
[]
[null,null,null,null,"Major Capex Allowance, $000, P50","Total project"]
[null,null,null,null,null,{"$f":"'Calculations - NEW'!H4","v":2022},{"$f":"'Calculations - NEW'!I4","v":2023},{"$f":"'Calculations - NEW'!J4","v":2024},{"$f":"'Calculations - NEW'!K4","v":2025},{"$f":"'Calculations - NEW'!L4","v":2026},{"$f":"'Calculations - NEW'!M4","v":2027},{"$f":"'Calculations - NEW'!N4","v":2028},{"$f":"'Calculations - NEW'!O4","v":2029},"Total"]
[null,null,null,null,"Capex - total risk adjusted (real 2022)",{"$f":"'Calculations - NEW'!H115","v":0},{"$f":"'Calculations - NEW'!I115","v":0},{"$f":"'Calculations - NEW'!J115","v":14060487.593921637},{"$f":"'Calculations - NEW'!K115","v":28120975.187843274},{"$f":"'Calculations - NEW'!L115","v":28120975.187843274},{"$f":"'Calculations - NEW'!M115","v":14060487.593921637},{"$f":"'Calculations - NEW'!N115","v":0},{"$f":"'Calculations - NEW'!O115","v":0},{"$f":"+SUM(F42:M42)","v":84362925.563529819}]
[null,null,null,null,"Inflation",{"$f":"'Calculations - NEW'!H116","v":0},{"$f":"'Calculations - NEW'!I116","v":0},{"$f":"'Calculations - NEW'!J116","v":1445565.1244561533},{"$f":"'Calculations - NEW'!K116","v":3552122.9063052339},{"$f":"'Calculations - NEW'!L116","v":4307928.3248459725},{"$f":"'Calculations - NEW'!M116","v":2408417.0873868018},{"$f":"'Calculations - NEW'!N116","v":0},{"$f":"'Calculations - NEW'!O116","v":0},{"$f":"+SUM(F43:M43)","v":11714033.442994162}]
[null,null,null,null,"Capex - total risk adjusted (nominal)",{"$f":"+F42+F43","v":0},0,15506052.718377791,31673098.094148509,32428903.512689248,16468904.681308439,0,0,{"$f":"+SUM(F44:M44)","v":96076959.006523982}]
[null,null,null,null,"Interest during construction (IDC)",{"$f":"'Calculations - NEW'!H117","v":0},{"$f":"'Calculations - NEW'!I117","v":0},{"$f":"'Calculations - NEW'!J117","v":119671.0400567483},{"$f":"'Calculations - NEW'!K117","v":970730.96021848894},{"$f":"'Calculations - NEW'!L117","v":3517362.5825920254},{"$f":"'Calculations - NEW'!M117","v":2438787.1893753787},{"$f":"'Calculations - NEW'!N117","v":0},{"$f":"'Calculations - NEW'!O117","v":0},{"$f":"+SUM(F45:M45)","v":7046551.7722426411}]
[null,null,null,null,"Major Capex Allowance",{"$f":"+SUM(F44:F45)","v":0},0,15625723.75843454,32643829.054366998,35946266.095281273,18907691.870683819,0,0,{"$f":"+SUM(F46:M46)","v":103123510.77876663}]
[]
[null,null,null,null,"Major Capex Allowance, $000, P50","Cost range"]
[null,null,null,null,null,"Lower estimate","P50","Upper estimate",null,"mode"]
[null,null,null,null,"Capex - total risk adjusted (real 2019)",{"$f":"SUM('Assumptions - with Mode added'!M40:M83)","v":80586773.687585592},{"$f":"N42","v":84362925.563529819},{"$f":"SUM('Assumptions - with Mode added'!O40:O83)","v":93479362.636014938},null,{"$f":"SUM('Assumptions - with Mode added'!Q40:Q83)","v":80586773.687585592}]
[null,null,null,null,"Inflation",null,{"$f":"N43","v":11714033.442994162}]
[null,null,null,null,"Capex - total risk adjusted (nominal)",null,{"$f":"G50+G51","v":96076959.006523982}]
[null,null,null,null,"Interest during construction (IDC)",null,{"$f":"N45","v":7046551.7722426411}]
[null,null,null,null,"Major Capex Allowance",null,{"$f":"G52+G53","v":103123510.77876662}]

{"sheet":"Calculations - NEW","index":6,"n_rows":152,"n_cols":48,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
[null,null,"linked","calculated","blank","hardcoded"]
[null,null,null,null,null,"Total costs",null,"Annual costs (financial year ended 30 June) (summary)",null,null,null,null,null,null,null,null,"Quarterly costs (calculations)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-03-30",{"$f":"+EOMONTH(Q3,3)","v":"2022-06-30"},{"$f":"+EOMONTH(R3,3)","v":"2022-09-30"},{"$f":"+EOMONTH(S3,3)","v":"2022-12-31"},{"$f":"+EOMONTH(T3,3)","v":"2023-03-31"},"2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31",{"$f":"+EOMONTH(AN3,3)","v":"2028-03-31"},"2028-06-30","2028-09-30","2028-12-31","2029-03-31","2029-06-30","2029-09-30","2029-12-31"]
[null,null,null,null,null,null,null,2022,2023,2024,2025,2026,2027,2028,2029,null,2022,2022,2022,2022,{"$f":"+Q4+1","v":2023},{"$f":"+R4+1","v":2023},2023,2023,2024,2024,2024,2024,2025,2025,2025,2025,2026,2026,2026,2026,2027,2027,2027,2027,{"$f":"+AK4+1","v":2028},2028,2028,2028,2029,2029,2029,2029]
["Timing Flags",null,null,"Start","Finish"]
[]
[null,"Lines Component",null,null,null,null,"Subs Component"]
[null,"Investigation ",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D8,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E8,\"\")","v":""},null,"Investigation",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I8,\"\")","v":"2022-01-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J8,\"\")","v":"2022-12-01"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D8,P$3>=$E8),0,1),IF(OR(Q$3<$I8,P$3>=$J8),0,1))","v":1},1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(OR(Q$3<$D9,P$3>=$E9),0,1)","v":0},{"$f":"+IF(OR(R$3<$D9,Q$3>=$E9),0,1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+IF(OR(AH$3<$D9,AG$3>=$E9),0,1)","v":0},0,0,0,0,0]
[null,null,null,null,null,null,"Civil Works",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I10,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J10,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D10,P$3>=$E10),0,1),IF(OR(Q$3<$I10,P$3>=$J10),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Primary Plant 220 kV - Statcom",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I11,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J11,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D11,P$3>=$E11),0,1),IF(OR(Q$3<$I11,P$3>=$J11),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Primary Plant 220 kV - other",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I12,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J12,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D12,P$3>=$E12),0,1),IF(OR(Q$3<$I12,P$3>=$J12),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Cables",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I13,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J13,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D13,P$3>=$E13),0,1),IF(OR(Q$3<$I13,P$3>=$J13),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Protection",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I14,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J14,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D14,P$3>=$E14),0,1),IF(OR(Q$3<$I14,P$3>=$J14),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"SCADA",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I15,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J15,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D15,P$3>=$E15),0,1),IF(OR(Q$3<$I15,P$3>=$J15),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Secondary Equipment",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I16,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J16,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D16,P$3>=$E16),0,1),IF(OR(Q$3<$I16,P$3>=$J16),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Communications",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I17,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J17,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D17,P$3>=$E17),0,1),IF(OR(Q$3<$I17,P$3>=$J17),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Miscellaneous works",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I18,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J18,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D18,P$3>=$E18),0,1),IF(OR(Q$3<$I18,P$3>=$J18),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Switching",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I19,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J19,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D19,P$3>=$E19),0,1),IF(OR(Q$3<$I19,P$3>=$J19),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Construction work",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D21,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E21,\"\")","v":""},null,"Construction work",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I21,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J21,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D21,P$3>=$E21),0,1),IF(OR(Q$3<$I21,P$3>=$J21),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Transpower overheads",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D22,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E22,\"\")","v":""},null,"Transpower overheads",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I22,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J22,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D22,P$3>=$E22),0,1),IF(OR(Q$3<$I22,P$3>=$J22),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Consultant support ",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D23,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E23,\"\")","v":""},null,"Consultant support ",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I23,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J23,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D23,P$3>=$E23),0,1),IF(OR(Q$3<$I23,P$3>=$J23),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Contractor overheads",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D24,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E24,\"\")","v":""},null,"Contractor overheads ",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I24,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J24,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D24,P$3>=$E24),0,1),IF(OR(Q$3<$I24,P$3>=$J24),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Freight",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D25,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E25,\"\")","v":""},null,"Freight",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I25,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J25,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D25,P$3>=$E25),0,1),IF(OR(Q$3<$I25,P$3>=$J25),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Design",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D26,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E26,\"\")","v":""},null,"Design",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I26,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J26,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D26,P$3>=$E26),0,1),IF(OR(Q$3<$I26,P$3>=$J26),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Legal",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D27,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E27,\"\")","v":""},null,"Legal",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I27,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J27,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D27,P$3>=$E27),0,1),IF(OR(Q$3<$I27,P$3>=$J27),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Property",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D28,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E28,\"\")","v":""},null,"Property",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I28,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J28,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D28,P$3>=$E28),0,1),IF(OR(Q$3<$I28,P$3>=$J28),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Environmental costs",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D29,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E29,\"\")","v":""},null,"Environmental costs",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I29,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J29,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D29,P$3>=$E29),0,1),IF(OR(Q$3<$I29,P$3>=$J29),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Community Care Fund",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D30,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E30,\"\")","v":""},null,"Community Care Fund",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I30,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J30,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D30,P$3>=$E30),0,1),IF(OR(Q$3<$I30,P$3>=$J30),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Stakeholder costs",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D31,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E31,\"\")","v":""},null,"Stakeholder costs",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I31,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J31,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D31,P$3>=$E31),0,1),IF(OR(Q$3<$I31,P$3>=$J31),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Risk",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D33,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E33,\"\")","v":""},null,"Risk",null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I33,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J33,\"\")","v":"2027-05-31"},null,null,null,null,null,null,{"$f":"+IF(Type=\"Lines\",IF(OR(Q$3<$D33,P$3>=$E33),0,1),IF(OR(Q$3<$I33,P$3>=$J33),0,1))","v":0},0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Interest during construction (IDC)",null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!D35,\"\")","v":""},{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!E35,\"\")","v":""},null,null,null,{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!I34,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",'Assumptions - with Mode added'!J34,\"\")","v":"2027-05-31"},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0]
[]
["Real costs (P50 values, $000)",null,null,null,"Proportion paid in US$",null,null,{"$f":"'Assumptions - with Mode added'!G$86","v":2022},{"$f":"'Assumptions - with Mode added'!H$86","v":2023},{"$f":"'Assumptions - with Mode added'!I$86","v":2024},{"$f":"'Assumptions - with Mode added'!J$86","v":2025},{"$f":"'Assumptions - with Mode added'!K$86","v":2026},{"$f":"'Assumptions - with Mode added'!L$86","v":2027},{"$f":"'Assumptions - with Mode added'!M$86","v":2028},{"$f":"'Assumptions - with Mode added'!N$86","v":2029}]
[]
[null,"Lines Component"]
[null,"Investigation ",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F40,0)","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q40:$AV40)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",+$F40*(Q8/SUM($Q8:$AV8)),\"\")","v":""},{"$f":"IF(Type=\"Lines\",+$F40*(R8/SUM($Q8:$AV8)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Construction work",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F42,0)","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q42:$AV42)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F42*(Q21/SUM($Q21:$AV21)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Transpower overheads",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F43,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F43*(Q22/SUM($Q22:$AV22)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Consultant support ",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F44,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F44*(Q23/SUM($Q23:$AV23)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Contractor overheads",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F45,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F45*(Q24/SUM($Q24:$AV24)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Freight",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F46,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F46*(Q25/SUM($Q25:$AV25)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Design",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F47,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F47*(Q26/SUM($Q26:$AV26)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Legal",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F48,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F48*(Q27/SUM($Q27:$AV27)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Property",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F49,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F49*(Q28/SUM($Q28:$AV28)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Environmental costs",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F50,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F50*(Q29/SUM($Q29:$AV29)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Community Care Fund",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F51,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F51*(Q30/SUM($Q30:$AV30)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Stakeholder costs",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F52,0)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F52*(Q31/SUM($Q31:$AV31)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Risk",null,null,null,{"$f":"IF(Type=\"Lines\",'Assumptions - with Mode added'!F54,0)","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q54:$AV54)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Lines\",$F54*(Q33/SUM($Q33:$AV33)),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Subs Component"]
[null,"Investigation",null,null,null,{"$f":"'Assumptions - with Mode added'!F57","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q57:$AV57)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Subs\",$F57*(Q8/SUM($Q8:$AV8)),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Civil Works",null,null,null,{"$f":"'Assumptions - with Mode added'!F59","v":10018671.218370307},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q59:$AV59)","v":0},0,1669778.5363950511,3339557.0727901021,3339557.0727901021,1669778.5363950511,0,0,null,{"$f":"IF(Type=\"Subs\",$F59*(Q10/SUM($Q10:$AV10)),\"\")","v":0},0,0,0,0,0,0,0,0,0,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,834889.26819752553,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Plant 220 kV - Statcom",null,null,null,{"$f":"'Assumptions - with Mode added'!F60","v":36378807.015606456},null,0,0,6063134.5026010759,12126269.005202152,12126269.005202152,6063134.5026010759,0,0,null,{"$f":"IF(Type=\"Subs\",$F60*(Q11/SUM($Q11:$AV11)),\"\")","v":0},0,0,0,0,0,0,0,0,0,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,3031567.251300538,0,0,0,0,0,0,0,0,0,0]
[null,"Primary Plant 220 kV - other",null,null,null,{"$f":"'Assumptions - with Mode added'!F61","v":8984483.1641097534},null,0,0,1497413.8606849588,2994827.7213699175,2994827.7213699175,1497413.8606849588,0,0,null,0,0,0,0,0,0,0,0,0,0,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,748706.93034247938,0,0,0,0,0,0,0,0,0,0]
[null,"Cables",null,null,null,{"$f":"'Assumptions - with Mode added'!F62","v":368664.18757221347},null,0,0,61444.031262035576,122888.06252407115,122888.06252407115,61444.031262035576,0,0,null,{"$f":"IF(Type=\"Subs\",$F62*(Q13/SUM($Q13:$AV13)),\"\")","v":0},0,0,0,0,0,0,0,0,0,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,30722.015631017788,0,0,0,0,0,0,0,0,0,0]
[null,"Protection",null,null,null,{"$f":"'Assumptions - with Mode added'!F63","v":764095.07121802692},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Type=\"Subs\",$F63*(Q14/SUM($Q14:$AV14)),\"\")","v":0},0,0,0,0,0,0,0,0,0,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,63674.589268168907,0,0,0,0,0,0,0,0,0,0]
[null,"SCADA",null,null,null,{"$f":"'Assumptions - with Mode added'!F64","v":317115.10305653018},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q64:$AV64)","v":0},0,52852.51717608836,105705.03435217672,105705.03435217672,52852.51717608836,0,0,null,{"$f":"IF(Type=\"Subs\",$F64*(Q15/SUM($Q15:$AV15)),\"\")","v":0},0,0,0,0,0,0,0,0,0,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,26426.25858804418,0,0,0,0,0,0,0,0,0,0]
[null,"Secondary Equipment",null,null,null,{"$f":"'Assumptions - with Mode added'!F65","v":4186033.1733722533},null,0,0,697672.19556204218,1395344.3911240844,1395344.3911240844,697672.19556204218,0,0,null,{"$f":"IF(Type=\"Subs\",$F65*(Q16/SUM($Q16:$AV16)),\"\")","v":0},0,0,0,0,0,0,0,0,0,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,348836.09778102109,0,0,0,0,0,0,0,0,0,0]
[null,"Communications",null,null,null,{"$f":"'Assumptions - with Mode added'!F66","v":102902.30728215167},null,0,0,17150.384547025278,34300.769094050556,34300.769094050556,17150.384547025278,0,0,null,{"$f":"IF(Type=\"Subs\",$F66*(Q17/SUM($Q17:$AV17)),\"\")","v":0},0,{"$f":"IF(Type=\"Subs\",$F66*(S17/SUM($Q17:$AV17)),\"\")","v":0},0,0,0,0,0,0,0,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,8575.1922735126391,0,0,0,0,0,0,0,0,0,0]
[null,"Miscellaneous works",null,null,null,{"$f":"'Assumptions - with Mode added'!F67","v":276668.82559307542},null,0,0,46111.470932179232,92222.941864358465,92222.941864358465,46111.470932179232,0,0,null,{"$f":"IF(Type=\"Subs\",$F67*(Q18/SUM($Q18:$AV18)),\"\")","v":0},0,0,0,0,0,0,0,0,0,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,23055.735466089616,0,0,0,0,0,0,0,0,0,0]
[null,"Switching",null,null,null,{"$f":"'Assumptions - with Mode added'!F68","v":65021.894556904474},null,0,0,10836.982426150746,21673.964852301491,21673.964852301491,10836.982426150746,0,0,null,{"$f":"IF(Type=\"Subs\",$F68*(Q19/SUM($Q19:$AV19)),\"\")","v":0},0,0,0,0,0,0,0,0,0,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,5418.4912130753728,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Construction Work ",null,null,null,{"$f":"'Assumptions - with Mode added'!F71","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q70:$AV70)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Subs\",$F70*(Q21/SUM($Q21:$AV21)),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Transpower overheads",null,null,null,{"$f":"'Assumptions - with Mode added'!F72","v":3493087.7678884207},null,0,0,582181.29464807012,1164362.5892961402,1164362.5892961402,582181.29464807012,0,0,null,{"$f":"IF(Type=\"Subs\",$F71*(Q22/SUM($Q22:$AV22)),\"\")","v":0},0,0,0,0,0,0,0,0,0,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,291090.64732403506,0,0,0,0,0,0,0,0,0,0]
[null,"Consultant support ",null,null,null,{"$f":"'Assumptions - with Mode added'!F73","v":1221374.0325248744},null,0,0,203562.33875414572,407124.67750829144,407124.67750829144,203562.33875414572,0,0,null,{"$f":"IF(Type=\"Subs\",$F72*(Q23/SUM($Q23:$AV23)),\"\")","v":0},0,0,0,0,0,0,0,0,0,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,101781.16937707286,0,0,0,0,0,0,0,0,0,0]
[null,"Contractor overheads ",null,null,null,{"$f":"'Assumptions - with Mode added'!F74","v":5353181.8396254275},null,0,0,892196.97327090451,1784393.946541809,1784393.946541809,892196.97327090451,0,0,null,{"$f":"IF(Type=\"Subs\",$F73*(Q24/SUM($Q24:$AV24)),\"\")","v":0},0,0,0,0,0,0,0,0,0,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,446098.48663545225,0,0,0,0,0,0,0,0,0,0]
[null,"Freight",null,null,null,{"$f":"'Assumptions - with Mode added'!F75","v":177653.28291202418},null,0,0,29608.880485337362,59217.760970674724,59217.760970674724,29608.880485337362,0,0,null,{"$f":"IF(Type=\"Subs\",$F74*(Q25/SUM($Q25:$AV25)),\"\")","v":0},0,0,0,0,0,0,0,0,0,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,14804.440242668681,0,0,0,0,0,0,0,0,0,0]
[null,"Design",null,null,null,{"$f":"'Assumptions - with Mode added'!F76","v":3534379.2214584197},null,0,0,589063.2035764032,1178126.4071528064,1178126.4071528064,589063.2035764032,0,0,null,{"$f":"IF(Type=\"Subs\",$F75*(Q26/SUM($Q26:$AV26)),\"\")","v":0},0,0,0,0,0,0,0,0,0,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,294531.6017882016,0,0,0,0,0,0,0,0,0,0]
[null,"Legal",null,null,null,{"$f":"'Assumptions - with Mode added'!F77","v":26313.85956287304},null,0,0,4385.6432604788397,8771.2865209576794,8771.2865209576794,4385.6432604788397,0,0,null,{"$f":"IF(Type=\"Subs\",$F76*(Q27/SUM($Q27:$AV27)),\"\")","v":0},0,0,0,0,0,0,0,0,0,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,2192.8216302394198,0,0,0,0,0,0,0,0,0,0]
[null,"Property",null,null,null,{"$f":"'Assumptions - with Mode added'!F78","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Subs\",$F77*(Q28/SUM($Q28:$AV28)),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Environmental costs",null,null,null,{"$f":"'Assumptions - with Mode added'!F79","v":147357.61355208902},null,0,0,24559.602258681502,49119.204517363003,49119.204517363003,24559.602258681502,0,0,null,{"$f":"IF(Type=\"Subs\",$F78*(Q29/SUM($Q29:$AV29)),\"\")","v":0},0,0,0,0,0,0,0,0,0,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,12279.801129340751,0,0,0,0,0,0,0,0,0,0]
[null,"Community Care Fund",null,null,null,{"$f":"'Assumptions - with Mode added'!F80","v":212615.98526801416},null,0,0,35435.997544669022,70871.995089338045,70871.995089338045,35435.997544669022,0,0,null,{"$f":"IF(Type=\"Subs\",$F79*(Q30/SUM($Q30:$AV30)),\"\")","v":0},0,0,0,0,0,0,0,0,0,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,17717.998772334511,0,0,0,0,0,0,0,0,0,0]
[null,"Stakeholder costs",null,null,null,{"$f":"'Assumptions - with Mode added'!F81","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(Type=\"Subs\",$F80*(Q31/SUM($Q31:$AV31)),\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Risk",null,null,null,{"$f":"'Assumptions - with Mode added'!F83","v":8734500},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q82:$AV82)","v":0},0,1455750,2911500,2911500,1455750,0,0,null,{"$f":"IF(Type=\"Subs\",$F82*(Q33/SUM($Q33:$AV33)),\"\")","v":0},0,0,0,0,0,0,0,0,0,727875,727875,727875,727875,727875,727875,727875,727875,727875,727875,727875,727875,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Liners and Substations Total",null,null,null,{"$f":"SUM(F40:F82)","v":84362925.563529819},{"$f":"+IF(ROUND(F86,)=ROUND(SUM('Assumptions - with Mode added'!F40:F83),),\"ok\",\"error!\")","v":"ok"},{"$f":"SUM(H40:H82)","v":0},0,13933138.415385298,27866276.830770597,27866276.830770597,13933138.415385298,0,0,null,{"$f":"SUM(Q40:Q82)","v":0},0,0,0,0,0,0,0,0,0,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,0,0,0,0,0,0,0,0,0,0]
[]
["Macro assumptions",null,null,null,null,null,null,2022,2023,2024,2025,2026,2027,2028,2029]
[null,"Inflation",null,null,null,null,null,{"$f":"'Assumptions - with Mode added'!G87","v":6.7000000000000004E-2},{"$f":"'Assumptions - with Mode added'!H87","v":5.2000000000000005E-2},{"$f":"'Assumptions - with Mode added'!I87","v":3.6000000000000004E-2},{"$f":"'Assumptions - with Mode added'!J87","v":2.7000000000000003E-2},{"$f":"'Assumptions - with Mode added'!K87","v":2.2000000000000002E-2},{"$f":"'Assumptions - with Mode added'!L87","v":0.02},{"$f":"'Assumptions - with Mode added'!M87","v":0.02},{"$f":"'Assumptions - with Mode added'!N87","v":0.02},null,{"$f":"(1+SUMIF($H$4:$N4,Q$4,$H89:$N89))^0.25-1","v":1.6344882748635881E-2},{"$f":"(1+SUMIF($H$4:$N4,R$4,$H89:$N89))^0.25-1","v":1.6344882748635881E-2},{"$f":"(1+SUMIF($H$4:$N4,S$4,$H89:$N89))^0.25-1","v":1.6344882748635881E-2},{"$f":"(1+SUMIF($H$4:$N4,T$4,$H89:$N89))^0.25-1","v":1.6344882748635881E-2},{"$f":"(1+SUMIF($H$4:$N4,U$4,$H89:$N89))^0.25-1","v":1.27539248981694E-2},{"$f":"(1+SUMIF($H$4:$N4,V$4,$H89:$N89))^0.25-1","v":1.27539248981694E-2},{"$f":"(1+SUMIF($H$4:$N4,W$4,$H89:$N89))^0.25-1","v":1.27539248981694E-2},{"$f":"(1+SUMIF($H$4:$N4,X$4,$H89:$N89))^0.25-1","v":1.27539248981694E-2},{"$f":"(1+SUMIF($H$4:$N4,Y$4,$H89:$N89))^0.25-1","v":8.8809900082158499E-3},{"$f":"(1+SUMIF($H$4:$N4,Z$4,$H89:$N89))^0.25-1","v":8.8809900082158499E-3},{"$f":"(1+SUMIF($H$4:$N4,AA$4,$H89:$N89))^0.25-1","v":8.8809900082158499E-3},{"$f":"(1+SUMIF($H$4:$N4,AB$4,$H89:$N89))^0.25-1","v":8.8809900082158499E-3},{"$f":"(1+SUMIF($H$4:$N4,AC$4,$H89:$N89))^0.25-1","v":6.6827130792792566E-3},{"$f":"(1+SUMIF($H$4:$N4,AD$4,$H89:$N89))^0.25-1","v":6.6827130792792566E-3},{"$f":"(1+SUMIF($H$4:$N4,AE$4,$H89:$N89))^0.25-1","v":6.6827130792792566E-3},{"$f":"(1+SUMIF($H$4:$N4,AF$4,$H89:$N89))^0.25-1","v":6.6827130792792566E-3},{"$f":"(1+SUMIF($H$4:$N4,AG$4,$H89:$N89))^0.25-1","v":5.4551986478605929E-3},{"$f":"(1+SUMIF($H$4:$N4,AH$4,$H89:$N89))^0.25-1","v":5.4551986478605929E-3},{"$f":"(1+SUMIF($H$4:$N4,AI$4,$H89:$N89))^0.25-1","v":5.4551986478605929E-3},{"$f":"(1+SUMIF($H$4:$N4,AJ$4,$H89:$N89))^0.25-1","v":5.4551986478605929E-3},{"$f":"(1+SUMIF($H$4:$N4,AK$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AL$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AM$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AN$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AO$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AP$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AQ$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AR$4,$H89:$N89))^0.25-1","v":4.9629315732038215E-3},{"$f":"(1+SUMIF($H$4:$N4,AS$4,$H89:$N89))^0.25-1","v":0},{"$f":"(1+SUMIF($H$4:$N4,AT$4,$H89:$N89))^0.25-1","v":0},{"$f":"(1+SUMIF($H$4:$N4,AU$4,$H89:$N89))^0.25-1","v":0},{"$f":"(1+SUMIF($H$4:$N4,AV$4,$H89:$N89))^0.25-1","v":0}]
[null,"Inflation factor",null,"Start",{"$f":"'Assumptions - with Mode added'!E88","v":"2022-09-30"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q3<=$E$90,1,P90*(1+Q89))","v":1},1,1,1.0163448827486359,1.0293072690538507,1.0424349766605034,1.0557301140640565,1.0691948166515652,1.0786903251350839,1.0882701631345677,1.0979350795796052,1.1076858300510213,1.1150881766352356,1.1225399909777856,1.1300416036575067,1.1375933474623985,1.1437991451532905,1.1500387967033547,1.1563124867921182,1.1626204011065708,1.1683904066028736,1.1741890482416315,1.18001646814206,1.1858728091287027,1.1917582147349315,1.1976728292064645,1.2036167975049015,1.2095902653112771,1.2095902653112771,1.2095902653112771,1.2095902653112771,1.2095902653112771]
[null,"Discount rate (real, pre-tax)",null,null,{"$f":"'Assumptions - with Mode added'!E89","v":7.0000000000000007E-2},null,null,{"$f":"+$E$91","v":7.0000000000000007E-2},7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,null,{"$f":"(1+SUMIF($H$4:$O4,Q$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,R$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,S$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,T$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,U$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,V$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,W$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,X$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,Y$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,Z$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AA$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AB$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AC$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AD$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AE$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AF$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AG$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AH$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AI$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AJ$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AK$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AL$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AM$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AN$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AO$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AP$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AQ$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AR$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AS$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AT$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AU$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2},{"$f":"(1+SUMIF($H$4:$O4,AV$4,$H91:$O91))^0.25-1","v":1.7058525001811375E-2}]
[null,"PV discount factor (real, pre-tax)",null,"Start",{"$f":"'Assumptions - with Mode added'!E90","v":"2022-09-30"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q3<=$E$92,1,P92/(1+Q91))","v":1},1,1,0.98322758761421225,0.96673648904566345,0.95052198598300097,0.93457943925233611,0.9189042874899177,0.90349204583706832,0.88833830465701002,0.87343872827321112,0.8587890537288948,0.84438508956735336,0.83022271463271946,0.81629787689085131,0.80260659226999498,0.78914494352089082,0.77590907909599927,0.76289521204752442,0.75009961894392041,0.73751863880457069,0.72514867205233557,0.71298617948366749,0.70102768125600012,0.68926975589212192,0.67770903930124804,0.66634222381651154,0.65516605724859811,0.644177341955254,0.63337293392639993,0.62274974188459009,0.61230472640055889]
[null,"PV discount factor (nominal, pre-tax)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q3<=$E$92,1,P93/((1+Q91)*(1+Q89)))","v":1},1,1,0.96741529799917902,0.93921078584657913,0.91182856222653741,0.88524465372561156,0.85943578586331182,0.83758241339925277,0.81628471931851021,0.79552857406436739,0.7753002073605455,0.75723616056559284,0.7395929956219699,0.72236090622576321,0.70553031455427351,0.68993314679836604,0.67468078583103663,0.6597656090041667,0.64518016218361784,0.63122620199264201,0.61757403813147327,0.6042171433473863,0.59114913155911464,0.57836375480359348,0.56585490024873852,0.55361658727083218,0.54164296459512051,0.5325583054270705,0.52362601790897134,0.5148435464006742,0.50620837812628061]
[null,"Nominal interest rates",null,null,null,null,null,{"$f":"'Assumptions - with Mode added'!G91","v":3.1300000000000001E-2},{"$f":"'Assumptions - with Mode added'!H91","v":3.1300000000000001E-2},{"$f":"'Assumptions - with Mode added'!I91","v":3.1300000000000001E-2},{"$f":"'Assumptions - with Mode added'!J91","v":3.1399999999999997E-2},{"$f":"'Assumptions - with Mode added'!K91","v":5.67E-2},{"$f":"'Assumptions - with Mode added'!L91","v":5.67E-2},{"$f":"'Assumptions - with Mode added'!M91","v":5.67E-2},{"$f":"'Assumptions - with Mode added'!N91","v":5.67E-2},null,{"$f":"(1+SUMIF($H$4:$O4,Q$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,R$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,S$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,T$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,U$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,V$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,W$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,X$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,Y$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,Z$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,AA$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,AB$4,$H94:$O94))^0.25-1","v":7.7347957569464665E-3},{"$f":"(1+SUMIF($H$4:$O4,AC$4,$H94:$O94))^0.25-1","v":7.7592236187398189E-3},{"$f":"(1+SUMIF($H$4:$O4,AD$4,$H94:$O94))^0.25-1","v":7.7592236187398189E-3},{"$f":"(1+SUMIF($H$4:$O4,AE$4,$H94:$O94))^0.25-1","v":7.7592236187398189E-3},{"$f":"(1+SUMIF($H$4:$O4,AF$4,$H94:$O94))^0.25-1","v":7.7592236187398189E-3},{"$f":"(1+SUMIF($H$4:$O4,AG$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AH$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AI$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AJ$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AK$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AL$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AM$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AN$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AO$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AP$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AQ$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AR$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AS$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AT$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AU$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2},{"$f":"(1+SUMIF($H$4:$O4,AV$4,$H94:$O94))^0.25-1","v":1.3883199957945846E-2}]
[null,"NZD:USD FX rate ",null,"TEES rate",{"$f":"H95","v":0.64119999999999999},null,null,{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!H$88-'Calculations - NEW'!$H$88+1,0)","v":0.64119999999999999},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!I$88-'Calculations - NEW'!$H$88+1,0)","v":0.6391},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!J$88-'Calculations - NEW'!$H$88+1,0)","v":0.63649999999999995},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!K$88-'Calculations - NEW'!$H$88+1,0)","v":0.64080000000000004},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!L$88-'Calculations - NEW'!$H$88+1,0)","v":0.64080000000000004},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!M$88-'Calculations - NEW'!$H$88+1,0)","v":0.64080000000000004},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!N$88-'Calculations - NEW'!$H$88+1,0)","v":0.64080000000000004},{"$f":"OFFSET(assumptions!$G$4,'Calculations - NEW'!O$88-'Calculations - NEW'!$H$88+1,0)","v":0.64080000000000004},null,{"$f":"SUMIF($H$4:$O4,Q$4,$H95:$O95)","v":0.64119999999999999},{"$f":"SUMIF($H$4:$O4,R$4,$H95:$O95)","v":0.64119999999999999},{"$f":"SUMIF($H$4:$O4,S$4,$H95:$O95)","v":0.64119999999999999},{"$f":"SUMIF($H$4:$O4,T$4,$H95:$O95)","v":0.64119999999999999},{"$f":"SUMIF($H$4:$O4,U$4,$H95:$O95)","v":0.6391},{"$f":"SUMIF($H$4:$O4,V$4,$H95:$O95)","v":0.6391},{"$f":"SUMIF($H$4:$O4,W$4,$H95:$O95)","v":0.6391},{"$f":"SUMIF($H$4:$O4,X$4,$H95:$O95)","v":0.6391},{"$f":"SUMIF($H$4:$O4,Y$4,$H95:$O95)","v":0.63649999999999995},{"$f":"SUMIF($H$4:$O4,Z$4,$H95:$O95)","v":0.63649999999999995},{"$f":"SUMIF($H$4:$O4,AA$4,$H95:$O95)","v":0.63649999999999995},{"$f":"SUMIF($H$4:$O4,AB$4,$H95:$O95)","v":0.63649999999999995},{"$f":"SUMIF($H$4:$O4,AC$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AD$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AE$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AF$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AG$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AH$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AI$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AJ$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AK$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AL$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AM$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AN$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AO$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AP$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AQ$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AR$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AS$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AT$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AU$4,$H95:$O95)","v":0.64080000000000004},{"$f":"SUMIF($H$4:$O4,AV$4,$H95:$O95)","v":0.64080000000000004}]
[]
["Cost summary (P50 values, $000)"]
[null,"Real costs",null,null,null,{"$f":"+SUM(H98:O98)","v":84362925.563529819},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$98:$AV$98)","v":0},0,14060487.593921637,28120975.187843274,28120975.187843274,14060487.593921637,0,0,null,{"$f":"+Q86","v":0},{"$f":"+R86","v":0},0,0,0,0,0,0,0,0,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,0,0,{"$f":"+AO86","v":0},0,0,0,0,0,0,0]
[null,"Real costs (present value)",null,null,null,{"$f":"SUMPRODUCT(Q98:AV98,Q92:AV92)","v":67254519.498344913}]
[null,"Nominal costs",null,null,null,{"$f":"+SUM(H100:O100)","v":96076959.006523982},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$100:$AV$100)","v":0},0,15506052.718377791,31673098.094148505,32428903.512689248,16468904.681308439,0,0,null,{"$f":"+Q98*Q90","v":0},0,0,0,0,0,0,0,0,0,7718751.2826802023,7787301.4356975881,7839341.7368542152,7891729.8084120303,7944467.9744208427,7997558.5744614201,8041186.8451830074,8085053.1167880436,8129158.6876186272,8173504.8630995685,8214069.4084483813,8254835.2728600577,0,0,{"$f":"+AO98*AO90","v":0},0,0,0,0,0,0,0]
[null,"Nominal costs (present value)",null,null,null,{"$f":"SUMPRODUCT(Q100:AV100,Q93:AV93)","v":67254519.498344898},{"$f":"+IF(ROUND(F101,)=ROUND(F99,),\"ok\",\"check-are the inflation and pv start dates different?\")","v":"ok"}]
[null,"Nominal costs (cumulative)",null,null,null,null,null,{"$f":"+G102+H100","v":0},0,15506052.718377791,47179150.812526301,79608054.325215548,96076959.006523982,96076959.006523982,96076959.006523982,null,{"$f":"+P102+Q100","v":0},{"$f":"+Q102+R100","v":0},0,0,0,0,0,0,0,0,7718751.2826802023,15506052.718377791,23345394.455232006,31237124.263644036,39181592.238064878,47179150.812526301,55220337.657709308,63305390.774497353,71434549.462115973,79608054.325215548,87822123.733663931,96076959.006523997,96076959.006523997,96076959.006523997,{"$f":"+AN102+AO100","v":96076959.006523997},96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997]
[]
["IDC calculation (P50 values, $000)"]
[]
["Stage I"]
[null,"Real costs (excl. property)",null,null,null,{"$f":"+SUM(H107:O107)","v":84362925.563529819},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$107:$AV$107)","v":0},0,14060487.593921637,28120975.187843274,28120975.187843274,14060487.593921637,0,0,null,{"$f":"IF(Type=\"Lines\",Q86-'Calculations - NEW'!Q49,Q86-'Calculations - NEW'!Q77)","v":0},{"$f":"IF(Type=\"Lines\",R86-'Calculations - NEW'!R49,R86-'Calculations - NEW'!R77)","v":0},{"$f":"IF(Type=\"Lines\",S86-'Calculations - NEW'!S49,S86-'Calculations - NEW'!S77)","v":0},{"$f":"IF(Type=\"Lines\",T86-'Calculations - NEW'!T49,T86-'Calculations - NEW'!T77)","v":0},{"$f":"IF(Type=\"Lines\",U86-'Calculations - NEW'!U49,U86-'Calculations - NEW'!U77)","v":0},{"$f":"IF(Type=\"Lines\",V86-'Calculations - NEW'!V49,V86-'Calculations - NEW'!V77)","v":0},{"$f":"IF(Type=\"Lines\",W86-'Calculations - NEW'!W49,W86-'Calculations - NEW'!W77)","v":0},{"$f":"IF(Type=\"Lines\",X86-'Calculations - NEW'!X49,X86-'Calculations - NEW'!X77)","v":0},{"$f":"IF(Type=\"Lines\",Y86-'Calculations - NEW'!Y49,Y86-'Calculations - NEW'!Y77)","v":0},{"$f":"IF(Type=\"Lines\",Z86-'Calculations - NEW'!Z49,Z86-'Calculations - NEW'!Z77)","v":0},{"$f":"IF(Type=\"Lines\",AA86-'Calculations - NEW'!AA49,AA86-'Calculations - NEW'!AA77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AB86-'Calculations - NEW'!AB49,AB86-'Calculations - NEW'!AB77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AC86-'Calculations - NEW'!AC49,AC86-'Calculations - NEW'!AC77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AD86-'Calculations - NEW'!AD49,AD86-'Calculations - NEW'!AD77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AE86-'Calculations - NEW'!AE49,AE86-'Calculations - NEW'!AE77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AF86-'Calculations - NEW'!AF49,AF86-'Calculations - NEW'!AF77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AG86-'Calculations - NEW'!AG49,AG86-'Calculations - NEW'!AG77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AH86-'Calculations - NEW'!AH49,AH86-'Calculations - NEW'!AH77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AI86-'Calculations - NEW'!AI49,AI86-'Calculations - NEW'!AI77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AJ86-'Calculations - NEW'!AJ49,AJ86-'Calculations - NEW'!AJ77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AK86-'Calculations - NEW'!AK49,AK86-'Calculations - NEW'!AK77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AL86-'Calculations - NEW'!AL49,AL86-'Calculations - NEW'!AL77)","v":7030243.7969608186},{"$f":"IF(Type=\"Lines\",AM86-'Calculations - NEW'!AM49,AM86-'Calculations - NEW'!AM77)","v":0},{"$f":"IF(Type=\"Lines\",AN86-'Calculations - NEW'!AN49,AN86-'Calculations - NEW'!AN77)","v":0},{"$f":"IF(Type=\"Lines\",AO86-'Calculations - NEW'!AO49,AO86-'Calculations - NEW'!AO77)","v":0},{"$f":"IF(Type=\"Lines\",AP86-'Calculations - NEW'!AP49,AP86-'Calculations - NEW'!AP77)","v":0},{"$f":"IF(Type=\"Lines\",AQ86-'Calculations - NEW'!AQ49,AQ86-'Calculations - NEW'!AQ77)","v":0},{"$f":"IF(Type=\"Lines\",AR86-'Calculations - NEW'!AR49,AR86-'Calculations - NEW'!AR77)","v":0},{"$f":"IF(Type=\"Lines\",AS86-'Calculations - NEW'!AS49,AS86-'Calculations - NEW'!AS77)","v":0},{"$f":"IF(Type=\"Lines\",AT86-'Calculations - NEW'!AT49,AT86-'Calculations - NEW'!AT77)","v":0},{"$f":"IF(Type=\"Lines\",AU86-'Calculations - NEW'!AU49,AU86-'Calculations - NEW'!AU77)","v":0},{"$f":"IF(Type=\"Lines\",AV86-'Calculations - NEW'!AV49,AV86-'Calculations - NEW'!AV77)","v":0}]
[null,"Nominal costs (excluding property)",null,null,null,{"$f":"+SUM(H108:O108)","v":96076959.006523982},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$108:$AV$108)","v":0},0,15506052.718377791,31673098.094148505,32428903.512689248,16468904.681308439,0,0,null,{"$f":"Q107*Q90","v":0},{"$f":"R107*R90","v":0},0,0,0,0,0,0,0,0,7718751.2826802023,7787301.4356975881,7839341.7368542152,7891729.8084120303,7944467.9744208427,7997558.5744614201,8041186.8451830074,8085053.1167880436,8129158.6876186272,8173504.8630995685,8214069.4084483813,8254835.2728600577,0,0,{"$f":"AO107*AO90","v":0},0,0,0,0,0,0,0]
[null,"Nominal costs (cumulative) (excluding property)",null,null,null,null,null,{"$f":"+G109+H108","v":0},0,15506052.718377791,47179150.812526301,79608054.325215548,96076959.006523982,96076959.006523982,96076959.006523982,null,{"$f":"+P109+Q108","v":0},0,0,0,0,0,0,0,0,0,7718751.2826802023,15506052.718377791,23345394.455232006,31237124.263644036,39181592.238064878,47179150.812526301,55220337.657709308,63305390.774497353,71434549.462115973,79608054.325215548,87822123.733663931,96076959.006523997,96076959.006523997,96076959.006523997,{"$f":"+AN109+AO108","v":96076959.006523997},96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997,96076959.006523997]
[null,"Interest during construction (IDC)",null,null,null,{"$f":"+SUM(H110:O110)","v":7046551.7722426411},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$110:$AV$110)","v":0},0,119671.0400567483,970730.96021848894,3517362.5825920254,2438787.1893753787,0,0,null,{"$f":"(Q108/2*Q94+P109*Q94)*Q35","v":0},0,0,0,0,0,0,0,0,0,29851.482335099961,89819.557721648336,150728.53326584777,211758.98420690565,273197.28414070164,335046.15860503382,710816.2870118256,822758.19399275607,935310.76631328801,1048477.335274156,1162233.3204929505,1276553.8688824282,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Cost for approval (P50 values, $000)"]
[]
[null,"Real costs",null,null,null,{"$f":"+SUM(H115:O115)","v":84362925.563529819},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$115:$AV$115)","v":0},0,14060487.593921637,28120975.187843274,28120975.187843274,14060487.593921637,0,0,null,{"$f":"+Q86","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+AA86","v":7030243.7969608186},7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,7030243.7969608186,0,0,{"$f":"+AO86","v":0},0,0,0,0,0,0,0]
[null,"Inflation",null,null,null,{"$f":"+SUM(H116:O116)","v":11714033.442994162},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q116:$AV116)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,I$4,$Q116:$AV116)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,J$4,$Q116:$AV116)","v":1445565.1244561533},3552122.9063052339,4307928.3248459725,2408417.0873868018,0,0,null,{"$f":"+Q100-Q115","v":0},{"$f":"+R100-R115","v":0},0,0,0,0,0,0,0,0,{"$f":"+AA100-AA115","v":688507.48571938369},757057.63873676956,809097.93989339657,861486.01145121176,914224.17746002413,967314.77750060149,1010943.0482221888,1054809.3198272251,1098914.8906578086,1143261.0661387499,1183825.6114875628,1224591.4758992391,0,0,{"$f":"+AO100-AO115","v":0},0,0,0,0,0,0,0]
[null,"Interest during construction (IDC)",null,null,null,{"$f":"+SUM(H117:O117)","v":7046551.7722426411},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q117:$AV117)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,I$4,$Q117:$AV117)","v":0},119671.0400567483,970730.96021848894,3517362.5825920254,2438787.1893753787,0,0,null,{"$f":"Q110","v":0},0,0,0,0,0,0,0,0,0,29851.482335099961,89819.557721648336,{"$f":"AC110","v":150728.53326584777},{"$f":"AD110","v":211758.98420690565},273197.28414070164,335046.15860503382,710816.2870118256,822758.19399275607,935310.76631328801,1048477.335274156,1162233.3204929505,1276553.8688824282,0,0,{"$f":"AO110","v":0},0,0,0,0,0,0,0]
[null,"Nominal costs including IDC",null,null,null,{"$f":"+SUM(H118:O118)","v":103123510.77876663},{"$f":"+IF(ROUND(F118,)=ROUND(F100+F110,),\"ok\",\"error!\")","v":"ok"},{"$f":"+SUM(H115:H117)","v":0},0,15625723.75843454,32643829.054366998,35946266.095281273,18907691.870683819,0,0,null,{"$f":"+Q117+Q116+Q115","v":0},{"$f":"+R117+R116+R115","v":0},0,0,0,0,0,0,0,0,7748602.7650153022,7877120.9934192365,7990070.2701200629,8103488.7926189359,8217665.2585615441,8332604.7330664536,8752003.132194832,8907811.310780799,9064469.4539319146,9221982.1983737238,9376302.7289413325,9531389.1417424865,0,0,{"$f":"+AO117+AO116+AO115","v":0},0,0,0,0,0,0,0]
[]
["Value of commissioned assets (P50 values, $000)"]
[]
["Stage I"]
[null,"Value of commissioned assets",null,null,null,{"$f":"+SUM(H123:N123)","v":103123510.77876663},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q123:$AV123)","v":0},0,0,0,0,103123510.77876663,0,0,null,{"$f":"IF(AND(Q16=1,R16=0),Q109+$F$110,)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,103123510.77876663,0,0,0,0,0,0]
[null,"Value of commissioned assets (excluding property)",null,null,null,{"$f":"+SUM(H124:N124)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(AND(Q20=1,R20=0),Q123-Q50,)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Value of commissioned assets (property)",null,null,null,{"$f":"+SUM(H125:N125)","v":0},null,0,0,0,0,0,0,0,0,null,{"$f":"IF(AND(Q20=1,R20=0),Q123-Q124,)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Proportion paid in US$ (P50 values, $000)"]
[]
["Stage I"]
[null,"Value of commissioned assets",null,null,null,{"$f":"+SUM(H131:N131)","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,H$4,$Q$123:$AV$123)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,I$4,$Q$123:$AV$123)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,J$4,$Q$123:$AV$123)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,K$4,$Q$123:$AV$123)","v":0},{"$f":"+SUMIF($Q$4:$AV$4,L$4,$Q$123:$AV$123)","v":0},null,{"$f":"+SUMIF($Q$4:$AV$4,N$4,$Q$123:$AV$123)","v":0}]
[]
[]
[]
["Graph inputs (P50 values, $000)"]
[]
[null,"Investigation ",null,null,null,{"$f":"+SUM(Q137:AR137)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q40","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,{"$f":"+SUM(Q138:AR138)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"Q41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Construction work",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q42","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Contractor overheads",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q43","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Transpower overheads",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q44","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q45","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Community Care Fund",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q46","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Design",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q47","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Freight",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q48","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Legal",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q49","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Property",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q50","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Environmental costs",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q51","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Stakeholder costs",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q52","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,"Risk",null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"Q54","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,"Total capex (cumulative)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P152+SUM(Q137:Q146)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"+Z152+SUM(AA137:AA151)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Assumptions - with Mode added","index":7,"n_rows":97,"n_cols":21,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"input","calculated","linked"]
[]
[null,"Select Project","Subs - HVDC Capacity Stage 1",null,null,null,"Type: ",{"$f":"IF(LEFT(C3,1)=\"S\",\"Subs\",\"Lines\")","v":"Subs"},null,{"$f":"SUM(Q40:Q83)","v":80586773.687585592}]
[]
["Cost phasing",null,null,"Start","Finish"]
[null,null,null,{"$f":"IF('NZGP project list'!D2=\"Original\",OFFSET('NZGP project list'!$F$4,MATCH(C3,'NZGP project list'!$C$5:$C$13,0),0),OFFSET('NZGP project list'!$H$4,MATCH(C3,'NZGP project list'!$C$5:$C$13,0),0))","v":"2024-07-01"},{"$f":"IF('NZGP project list'!D2=\"Original\",OFFSET('NZGP project list'!$G$4,MATCH(C3,'NZGP project list'!$C$5:$C$13,0),0),OFFSET('NZGP project list'!$I$4,MATCH(C3,'NZGP project list'!$C$5:$C$13,0),0))","v":"2027-05-31"}]
[null,"Lines",null,null,null,null,"Subs"]
[null,"Investigation ",null,{"$f":"IF(Type=\"Lines\",DATEVALUE(\"Jan-22\"),\"\")","v":""},{"$f":"IF(Type=\"Lines\",DATEVALUE(\"Dec-22\"),\"\")","v":""},null,"Investigation",null,{"$f":"IF(Type=\"Subs\",DATEVALUE(\"Jan-22\"),\"\")","v":"2022-01-01"},{"$f":"IF(Type=\"Subs\",DATEVALUE(\"Dec-22\"),\"\")","v":"2022-12-01"}]
[]
[null,null,null,null,null,null,"Civil Works",null,{"$f":"IF(Type=\"Subs\",$D$6,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",$E$6,\"\")","v":"2027-05-31"}]
[null,null,null,null,null,null,"Primary Plant 220 kV - Statcom",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Primary Plant 220 kV - other",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Cables",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Protection",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"SCADA",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Secondary Equipment",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Communications",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Miscellaneous works",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,"Switching",null,"2024-07-01","2027-05-31"]
[]
[null,"Construction work",null,{"$f":"IF(Type=\"Lines\",$D$6,\"\")","v":""},{"$f":"IF(Type=\"Lines\",$E$6,\"\")","v":""},null,"Construction work",null,{"$f":"IF(Type=\"Subs\",$D$6,\"\")","v":"2024-07-01"},{"$f":"IF(Type=\"Subs\",$E$6,\"\")","v":"2027-05-31"}]
[null,"Transpower overheads",null,"","",null,"Transpower overheads",null,"2024-07-01","2027-05-31"]
[null,"Consultant support ",null,"","",null,"Consultant support ",null,"2024-07-01","2027-05-31"]
[null,"Contractor overheads",null,"","",null,"Contractor overheads ",null,"2024-07-01","2027-05-31"]
[null,"Freight",null,"","",null,"Freight",null,"2024-07-01","2027-05-31"]
[null,"Design",null,"","",null,"Design",null,"2024-07-01","2027-05-31"]
[null,"Legal",null,"","",null,"Legal",null,"2024-07-01","2027-05-31"]
[null,"Property",null,"","",null,"Property",null,"2024-07-01","2027-05-31"]
[null,"Environmental costs",null,"","",null,"Environmental costs",null,"2024-07-01","2027-05-31"]
[null,"Community Care Fund",null,"","",null,"Community Care Fund",null,"2024-07-01","2027-05-31"]
[null,"Stakeholder costs",null,"","",null,"Stakeholder costs",null,"2024-07-01","2027-05-31"]
[null,null,null,null,null,null,null,null,"2024-07-01","2027-05-31"]
[null,"Risk",null,{"$f":"IF(Type=\"Lines\",$D$6,\"\")","v":""},{"$f":"IF(Type=\"Lines\",$E$6,\"\")","v":""},null,"Risk",null,"2024-07-01","2027-05-31"]
[null,"Escalation / Inflation allowance",null,{"$f":"IF(Type=\"Lines\",$D$6,\"\")","v":""},{"$f":"IF(Type=\"Lines\",$E$6,\"\")","v":""},null,"Escalation / Inflation allowance",null,"2024-07-01","2027-05-31"]
[null,"IDC",null,{"$f":"IF(Type=\"Lines\",$D$6,\"\")","v":""},{"$f":"IF(Type=\"Lines\",$E$6,\"\")","v":""},null,"IDC",null,"2024-07-01","2027-05-31"]
[]
["Real costs ($000)",null,null,null,null,"Total costs @ risk percentile",null,null,"P50 estimate",null,"Risk percentile",null,"Lower estimate",null,"Upper estimate",null,"Mode (most often) estimate",null,"Multiplier",null,"Proportion paid in US$"]
[]
["Lines"]
[null,"Investigation",null,null,null,{"$f":"IF(K40<=IFERROR((Q40-M40)/(O40-M40),0),M40+SQRT(K40*(O40-M40)*(Q40-M40)),O40-SQRT((1-K40)*(O40-M40)*(-Q40+O40)))*S40","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B40,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B40,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B40,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1,null,0]
[]
[null,"Construction work",null,null,null,{"$f":"IF(K42<=IFERROR((Q42-M42)/(O42-M42),),M42+SQRT(K42*(O42-M42)*(Q42-M42)),O42-SQRT((1-K42)*(O42-M42)*(-Q42+O42)))*S42","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B42,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B42,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B42,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Transpower overheads",null,null,null,0,null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B43,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B43,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B43,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Consultant support ",null,null,null,{"$f":"IF(K44<=IFERROR((Q44-M44)/(O44-M44),),M44+SQRT(K44*(O44-M44)*(Q44-M44)),O44-SQRT((1-K44)*(O44-M44)*(-Q44+O44)))*S44","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B44,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B44,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B44,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Contractor overheads",null,null,null,0,null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B45,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B45,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B45,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Freight",null,null,null,{"$f":"IF(K46<=IFERROR((Q46-M46)/(O46-M46),),M46+SQRT(K46*(O46-M46)*(Q46-M46)),O46-SQRT((1-K46)*(O46-M46)*(-Q46+O46)))*S46","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B46,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B46,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B46,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Design",null,null,null,{"$f":"IF(K47<=IFERROR((Q47-M47)/(O47-M47),),M47+SQRT(K47*(O47-M47)*(Q47-M47)),O47-SQRT((1-K47)*(O47-M47)*(-Q47+O47)))*S47","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B47,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B47,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B47,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Legal",null,null,null,{"$f":"IF(K48<=IFERROR((Q48-M48)/(O48-M48),),M48+SQRT(K48*(O48-M48)*(Q48-M48)),O48-SQRT((1-K48)*(O48-M48)*(-Q48+O48)))*S48","v":0},null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[null,"Property",null,null,null,0,null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[null,"Environmental costs",null,null,null,0,null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[null,"Community Care Fund",null,null,null,{"$f":"IF(K51<=IFERROR((Q51-M51)/(O51-M51),),M51+SQRT(K51*(O51-M51)*(Q51-M51)),O51-SQRT((1-K51)*(O51-M51)*(-Q51+O51)))*S51","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B51,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B51,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B51,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[null,"Stakeholder costs",null,null,null,{"$f":"IF(K52<=IFERROR((Q52-M52)/(O52-M52),),M52+SQRT(K52*(O52-M52)*(Q52-M52)),O52-SQRT((1-K52)*(O52-M52)*(-Q52+O52)))*S52","v":0},null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[]
[null,"Risk",null,null,null,{"$f":"IF(K54<=IFERROR((Q54-M54)/(O54-M54),),M54+SQRT(K54*(O54-M54)*(Q54-M54)),O54-SQRT((1-K54)*(O54-M54)*(-Q54+O54)))*S54","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B54,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B54,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,5)=\"Lines\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B54,INDIRECT(\"'\"&$C$3&\"'!\"&\"$C$5:$C$25\")),0)","v":0},null,1]
[]
["Subs"]
[null,"Investigation",null,null,null,{"$f":"IF(K57<=IFERROR((Q57-M57)/(O57-M57),),M57+SQRT(K57*(O57-M57)*(Q57-M57)),O57-SQRT((1-K57)*(O57-M57)*(-Q57+O57)))*S57","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B57,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B57,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B57,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":0},null,1]
[]
[null,"Civil Works",null,null,null,{"$f":"IF(K59<=IFERROR((Q59-M59)/(O59-M59),),M59+SQRT(K59*(O59-M59)*(Q59-M59)),O59-SQRT((1-K59)*(O59-M59)*(-Q59+O59)))*S59","v":10018671.218370307},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B59,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":8643294.8469999991},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B59,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":13339123.507499998},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B59,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":8643294.8469999991},null,1]
[null,"Primary Plant 220 kV - Statcom",null,null,null,36378807.015606456,null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B60,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":36305770.649999999},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B60,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":36555132.399999999},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B60,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":36305770.649999999},null,1]
[null,"Primary Plant 220 kV - other",null,null,null,{"$f":"IF(K61<=IFERROR((Q61-M61)/(O61-M61),),M61+SQRT(K61*(O61-M61)*(Q61-M61)),O61-SQRT((1-K61)*(O61-M61)*(-Q61+O61)))*S61","v":8984483.1641097534},null,null,null,null,0.5,null,8586088.1750000007,null,9946293.75,null,8586088.1750000007,null,1]
[null,"Cables",null,null,null,368664.18757221347,null,null,null,null,0.5,null,340047.66901919997,null,437750.57477079995,null,340047.66901919997,null,1]
[null,"Protection",null,null,null,764095.07121802692,null,null,null,null,0.5,null,665766.6,null,1001481,null,665766.6,null,1]
[null,"SCADA",null,null,null,317115.10305653018,null,null,null,null,0.5,null,268580.5,null,434288,null,268580.5,null,1]
[null,"Secondary Equipment",null,null,null,4186033.1733722533,null,null,null,null,0.5,null,3683673.1065663998,null,5398837.659849599,null,3683673.1065663998,null,1]
[null,"Communications",null,null,null,102902.30728215167,null,null,null,null,0.5,null,87272.5,null,140636,null,87272.5,null,1]
[null,"Miscellaneous works",null,null,null,276668.82559307542,null,null,null,null,0.5,null,215124.72,null,425249.44,null,215124.72,null,1]
[null,"Switching",null,null,null,65021.894556904474,null,null,null,null,0.5,null,52192,null,95996,null,52192,null,1]
[]
[]
[null,"Construction work",null,null,null,{"$f":"IF(K71<=IFERROR((Q71-M71)/(O71-M71),),M71+SQRT(K71*(O71-M71)*(Q71-M71)),O71-SQRT((1-K71)*(O71-M71)*(-Q71+O71)))*S71","v":0},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B71,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B71,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":0},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B71,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":0},null,1]
[null,"Transpower overheads",null,null,null,{"$f":"IF(K72<=IFERROR((Q72-M72)/(O72-M72),),M72+SQRT(K72*(O72-M72)*(Q72-M72)),O72-SQRT((1-K72)*(O72-M72)*(-Q72+O72)))*S72","v":3493087.7678884207},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B72,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":3318676.76},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B72,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":3914153.1885598069},null,3318676.76,null,1]
[null,"Consultant support",null,null,null,{"$f":"IF(K73<=IFERROR((Q73-M73)/(O73-M73),),M73+SQRT(K73*(O73-M73)*(Q73-M73)),O73-SQRT((1-K73)*(O73-M73)*(-Q73+O73)))*S73","v":1221374.0325248744},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B73,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":1160390.43},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B73,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":1368601.4728227963},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B73,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":1160390.43},null,1]
[null,"Contractor overheads",null,null,null,{"$f":"IF(K74<=IFERROR((Q74-M74)/(O74-M74),),M74+SQRT(K74*(O74-M74)*(Q74-M74)),O74-SQRT((1-K74)*(O74-M74)*(-Q74+O74)))*S74","v":5353181.8396254275},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B74,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":5085895.7300000004},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B74,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":5998467.5905170739},null,5085895.7300000004,null,1]
[null,"Freight",null,null,null,177653.28291202418,null,null,null,null,0.5,null,151000,null,242000,null,151000,null,1]
[null,"Design",null,null,null,3534379.2214584197,null,null,null,null,0.5,null,2921500,null,5014000.55,null,2921500,null,1]
[null,"Legal",null,null,null,26313.85956287304,null,null,null,null,0.5,null,25000,null,29485.797138614722,null,25000,null,1]
[null,"Property",null,null,null,0,null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[null,"Environmental costs",null,null,null,147357.61355208902,null,null,null,null,0.5,null,140000,null,165120.46397624246,null,140000,null,1]
[null,"Community Care Fund",null,null,null,212615.98526801416,null,null,null,null,0.5,null,202000,null,238245.24088000695,null,202000,null,1]
[null,"Stakeholder costs",null,null,null,{"$f":"IF(K81<=IFERROR((Q81-M81)/(O81-M81),),M81+SQRT(K81*(O81-M81)*(Q81-M81)),O81-SQRT((1-K81)*(O81-M81)*(-Q81+O81)))*S81","v":0},null,null,null,null,0.5,null,0,null,0,null,0,null,1]
[]
[null,"Risk",null,null,null,{"$f":"IF(K83<=IFERROR((Q83-M83)/(O83-M83),),M83+SQRT(K83*(O83-M83)*(Q83-M83)),O83-SQRT((1-K83)*(O83-M83)*(-Q83+O83)))*S83","v":8734500},null,null,null,null,0.5,null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B83,INDIRECT(\"'\"&$C$3&\"'!\"&\"$D$5:$D$25\")),0)","v":8734500},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B83,INDIRECT(\"'\"&$C$3&\"'!\"&\"$E$5:$E$25\")),0)","v":8734500},null,{"$f":"IF(LEFT($C$3,4)=\"Subs\",SUMIF(INDIRECT(\"'\"&$C$3&\"'!\"&\"$A$5:$A$25\"),$B83,INDIRECT(\"'\"&$C$3&\"'!\"&\"$c$5:$c$25\")),0)","v":8734500},null,1]
[]
["Macro assumptions"]
[null,"Years (financial year ended 30 June)",null,null,null,null,2022,2023,2024,2025,2026,2027,2028,2029,2030]
[null,"Inflation",null,null,null,null,{"$f":"assumptions!AD7","v":6.7000000000000004E-2},{"$f":"assumptions!AE7","v":5.2000000000000005E-2},{"$f":"assumptions!AF7","v":3.6000000000000004E-2},{"$f":"assumptions!AG7","v":2.7000000000000003E-2},{"$f":"assumptions!AH7","v":2.2000000000000002E-2},{"$f":"assumptions!AI7","v":0.02},{"$f":"assumptions!AJ7","v":0.02},{"$f":"assumptions!AK7","v":0.02},{"$f":"assumptions!AL7","v":0.02}]
[null,"Inflation factor",null,"Start","2022-09-30"]
[null,"Discount rate (real, pre-tax)",null,null,7.0000000000000007E-2]
[null,"PV discount factor (real, pre-tax)",null,"Start","2022-09-30"]
[null,"Nominal interest rates",null,null,null,null,3.1300000000000001E-2,3.1300000000000001E-2,3.1300000000000001E-2,3.1399999999999997E-2,5.67E-2,5.67E-2,5.67E-2,5.67E-2,5.67E-2]
[null,"NZD:USD FX rate",null,"TEES rate",0.66,null,0.7,0.71,0.72,0.66,0.66,0.66,0.66,0.66,0.66]
[]
[]
[null,null,null,null,null,null,"historical factors for comparison "]
[null,null,null,null,null,null,2022,2023,2024,2025,2026,2027,2028]
[null,null,null,null,null,null,1.7399999999999999E-2,1.4999999999999999E-2,1.67E-2,1.6E-2,1.9E-2,2.1000000000000001E-2,2.1000000000000001E-2]

{"sheet":"Lines - BPE-TKU-A&B TTU","index":8,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Project Build start","2024-09-02",null,null,null,null,null,"1900-01-23"]
["Project Build end","2027-06-30",null,null,null,null,null,"2027-06-30"]
[]
[null,null,"Data",null,null,null,null,"Earlier version with different RISK cost"]
["MCA Category ","Category","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined",null,null,"MCA Category ","Sum of Low Cost Combined","Sum of High Cost Combined","Sum of Mode Cost"]
["Community Care Fund","Community Contribution",295333,295333,295333,null,null,"Community Care Fund",295333,295333,295333]
["Construction work","Construction Work",43555546.237027727,38745923.707011178,55063939.481423773,null,null,"Construction Work",38745923.707013384,55063939.481426083,43555546.237029932]
["Contractor overheads","Contractor overheads",8692343.1383999996,8431572.8442480005,9126960.2953200005,null,null,"Contractor overheads",8431572.8442480005,9126960.2953200005,8692343.1383999996]
["Environmental costs","Environmental Costs",500000,450000,575000,null,null,"Environmental Costs",450000,575000,500000]
["Legal","LEGAL Allowances/Court Costs",135000,135000,202500,null,null,"Legal",135000,202500,135000]
["Property","Property and/or Easements and Acquisition",797000.00637599989,797000.00637599989,897000,null,null,"Property",797000.00637599989,897000,797000.00637599989]
["Risk","Risk Allowance & Management Reserve",6430450,6430450,6430450,null,null,"Risk",6783700,6783700,6783700]
["Stakeholder costs","Stakeholder/ Iwi Liaison",390000,195000,507000,null,null,"Stakeholder costs",195000,507000,390000]
["Transpower overheads","Transpower overheads",5438179.2674556272,5329415.6821065145,5601324.6454792945,null,null,"Transpower overheads",5329415.6821065145,5601324.6454792945,5438179.2674556272]
["IDC","IDC",4674199,4674199,4674199,null,null,null,0,0]
["Escalation / Inflation allowance","Escalation / Inflation Allowance",6924356,6924356,6924356,null,null,null,61162945.239743896,79052757.422225371,66587101.649261557]
["Grand Total",null,77832406.649259359,72408250.239741683,90298062.422223061]
[null,null,{"$f":"C17-C15-C16","v":66233851.649259359},{"$f":"D17-D15-D16","v":60809695.239741683},78699507.422223061]
[]
[null,null,null,null,null,null,null,"Updated version (final)"]
[null,null,null,null,null,null,null,"Category","Sum of Low Cost Combined","Sum of High Cost Combined","Sum of Mode Cost"]
[null,null,null,null,null,null,null,"Community Contribution",295333,295333,295333]
[null,null,null,null,null,null,null,"Construction Work",38745923.707013384,55063939.481426083,43555546.237029932]
[null,null,null,null,null,null,null,"Contractor Overheads",8431572.8442480005,9126960.2953200005,8692343.1383999996]
[null,null,null,null,null,null,null,"Environmental Costs",450000,575000,500000]
[null,null,null,null,null,null,null,"LEGAL Allowances/Court Costs",135000,202500,135000]
[null,null,null,null,null,null,null,"Property and/or Easements and Acquisition",797000.00637599989,897000,797000.00637599989]
[null,null,null,null,null,null,null,"Risk Allowance & Management Reserve",6430450,6430450,6430450]
[null,null,null,null,null,null,null,"Stakeholder/ Iwi Liaison",195000,507000,390000]
[null,null,null,null,null,null,null,"Transpower Overheads",5329415.6821065145,5601324.6454792945,5438179.2674556272]
[null,null,null,null,null,null,null,"(blank)",0,0]
[null,null,null,null,null,null,null,"Grand Total",60809695.239743896,78699507.422225371,66233851.649261557]

{"sheet":"Lines - TKU-WKM TTU","index":9,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Project Build start","2022-11-01",null,null,null,null,null,null,"2022-11-01"]
["Project Build end","2024-06-30",null,null,null,null,null,null,"2024-06-30"]
[]
[null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined",null,null,null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined"]
["Community Care Fund","Community Care Fund",69794.100000000006,69794.100000000006,69794.100000000006,null,null,null,null,0,0,0]
["Transpower overheads","Consultants Support during Construction / Tendering",197500,181700,203425,null,null,"Community Care Fund","Community Care Fund",69794.100000000006,69794.100000000006,69794.100000000006,null,null,null,"2022-11-01"]
["Contractor overheads","Contractor Safety Compliance & QA Costs",150000,147000,156000,null,null,"Transpower overheads","Consultants Support during Construction / Tendering",197500,181700,203425,null,null,null,"2024-06-30"]
["Contractor overheads","Contractor's Establishment and Disestablishment",500000,490000,520000,null,null,"Contractor overheads","Contractor Safety Compliance & QA Costs",150000,147000,156000]
["Contractor overheads","Contractor's PM and Site Costs",1528478.952,1497909.3729599998,1589618.11008,null,null,"Contractor overheads","Contractor's Establishment and Disestablishment",500000,490000,520000]
["Contractor overheads","Contractor's Preliminary & General",500000,490000,520000,null,null,"Contractor overheads","Contractor's PM and Site Costs",1528478.952,1497909.3729599998,1589618.11008]
["Contractor overheads","Contractor's Travel and Accomodation",450000,441000,468000,null,null,"Contractor overheads","Contractor's Preliminary & General",500000,490000,520000]
["Design","Design Allowance",949999.5,949999.5,1139999.3999999999,null,null,"Contractor overheads","Contractor's Travel and Accomodation",450000,441000,468000]
["Freight","Freight on Materials",45528,45528,45528,null,null,"Design","Design Allowance",949999.5,949999.5,1139999.3999999999]
["Construction work","Lines",17136228.929705132,15828037.399895784,19410577.419207118,null,null,"Freight","Freight on Materials",45528,45528,45528]
["Risk","Risk Allowance - $",2178550,2178550,2178550,null,null,"Construction Work","Lines",17136228.929705132,15828037.399895784,19410577.419207118]
["Transpower overheads","Transpower Costs - Construction Phase",1432830,1318203.6000000001,1475814.9,null,null,"Risk","Risk Allowance - $",2178550,2178550,2178550]
["Escalation / Inflation allowance","Escalation / Inflation allowance",855870.28,855870.28,855870.28,null,null,"Transpower overheads","Transpower Costs - Construction Phase",1432830,1318203.6000000001,1475814.9]
["IDC","IDC",507161,507161,507161,null,null,null,"(blank)",null,0,0]
["Stakeholder costs","Communication and Iwi / Stakeholder Liasion",224999.99759999994,145000,375000,null,null,null,0,0,0,0]
["Stakeholder costs","Property group disturbance and liaision costs",880000.00703999994,880000.00703999994,980000,null,null,"Stakeholder costs","Escalation / Inflation allowance",855870.28,855870.28,855870.28]
["Property","Property and/or Easements and Acquisition",750000.00599999994,500000,750000.00599999994,null,null,null,"IDC",507161,507161,507161]
["Environmental costs","Environmental Costs",697000,647000,747000,null,null,"Stakeholder costs","Communication and Iwi / Stakeholder Liasion",224999.99759999994,145000,375000]
[null,"Grand Total",29053940.772345137,27172753.259895787,31992338.215287119,null,null,"Stakeholder costs","Property group disturbance and liaision costs",880000.00703999994,880000.00703999994,980000]
[null,null,{"$f":"C23-C17-C18","v":27690909.492345136},null,null,null,null,"Property","Property and/or Easements and Acquisition",750000.00599999994,500000,750000.00599999994]
[null,null,null,null,null,null,null,"Environmental Costs","Environmental Costs",697000,647000,747000]
[null,null,null,null,null,null,null,null,"Grand Total",29053940.772345137,27172753.259895787,31992338.215287119]
[null,null,null,null,null,null,null,null,"less IDC, Escalation",{"$f":"J26-J20-J21","v":27690909.492345136},{"$f":"K26-K20-K21","v":25809721.979895785},30629306.935287118]
[null,null,null,null,null,null,null,"Earlier view befiore asset transfer TTU to Duplexing",null,{"$f":"J27-J49","v":4860876.9099276178},{"$f":"K27-K49","v":4651049.7408396192},5892049.7408396117]
[]
[]
[null,null,null,null,null,null,null,null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined"]
[null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,"Community Care Fund","Community Care Fund",69794.100000000006,69794.100000000006,69794.100000000006]
[null,null,null,null,null,null,null,"Transpower overheads","Consultants Support during Construction / Tendering",197500,391700,500425]
[null,null,null,null,null,null,null,"Contractor overheads","Contractor Safety Compliance & QA Costs",150000,147000,156000]
[null,null,null,null,null,null,null,"Contractor overheads","Contractor's Establishment and Disestablishment",500000,490000,520000]
[null,null,null,null,null,null,null,"Contractor overheads","Contractor's PM and Site Costs",1528478.952,1497909.3729599998,1589618.11008]
[null,null,null,null,null,null,null,"Contractor overheads","Contractor's Preliminary & General",500000,490000,520000]
[null,null,null,null,null,null,null,"Contractor overheads","Contractor's Travel and Accomodation",450000,441000,468000]
[null,null,null,null,null,null,null,"Design","Design Allowance",949999.5,949999.5,1139999.3999999999]
[null,null,null,null,null,null,null,"Freight","Freight on Materials",45528,45528,45528]
[null,null,null,null,null,null,null,"Construction Work","Lines",13010537.019777514,11702172.659056164,13956712.678367505]
[null,null,null,null,null,null,null,"Risk","Risk Allowance - $",1443365,1443365,1443365]
[null,null,null,null,null,null,null,"Transpower overheads","Transpower Costs - Construction Phase",1432830,1318203.6000000001,1475814.9]
[null,null,null,null,null,null,null,"Property","Property and/or Easements and Acquisition",750000.00599999994,500000,750000.00599999994]
[null,null,null,null,null,null,null,"Environmental Costs","Environmental Costs",697000,647000,747000]
[null,null,null,null,null,null,null,"Stakeholder costs","Communication and Iwi / Stakeholder Liasion",224999.99759999994,145000,375000]
[null,null,null,null,null,null,null,"Stakeholder costs","Property group disturbance and liaision costs",880000.00703999994,880000.00703999994,980000]
[null,null,null,null,null,null,null,null,"Grand Total",22830032.582417518,21158672.239056166,24737257.194447506]

{"sheet":"Lines - TKU-WKM-AB Duplexing NZ","index":10,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,5,0,9],[1,5,1,12]]}
["Project Build start","2024-09-01",null,null,null,"2024-09-02"]
["Project Build end","2028-06-30",null,null,null,"2028-06-30"]
[]
[null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined",null,"MCA Category","TEES Category","Mode","Low","High"]
["Community Care Fund","Community Care Fund",379496,379496,379496,null,"Community Care Fund","Community Contribution",405103,405103,405103]
["Transpower overheads","Consultants Support during Construction / Tendering",497499.47875000001,482574.49438749999,517399.45789999998,null,"Design","Design Allowance",2999999.7,2999999.7,2999999.7]
["Contractor overheads","Contractor Safety Compliance & QA Costs",200000,160000,220000.00000000003,null,"Freight","Freight on Materials",561506.5,561506.5,561506.5]
["Contractor overheads","Contractor's Establishment and Disestablishment",2150000,1720000,2365000,null,"Construction work","Lines",56150745.53453505,49418810.041147374,77355179.911374047]
["Contractor overheads","Contractor's PM and Site Costs",7523731.6441154908,6018985.3152923929,8276104.8085270394,null,"Contractor overheads","Contractor Safety Compliance & QA Costs",2150000,1720000,2365000]
["Contractor overheads","Contractor's Preliminary & General",895682.77,716546.21600000001,985251.04700000014,null,"Contractor overheads","Contractor's Establishment and Disestablishment",200000,160000,220000.00000000003]
["Contractor overheads","Contractor's Travel and Accomodation",4400000,3520000,4840000,null,"Contractor overheads","Contractor's PM and Site Costs",7523731.6441154908,6018985.3152923929,8276104.8085270394]
["Design","Design Allowance",2999999.7,2999999.7,2999999.7,null,"Contractor overheads","Contractor's Preliminary & General",895682.77,716546.21600000001,985251.04700000014]
["Environmental costs","Environmental Costs",500000,500000,500000,null,"Contractor overheads","Contractors Training",0,0,0]
["Escalation / Inflation allowance","Escalation / Inflation allowance",13445136.5,13445136.5,13445136.5,null,"Contractor overheads","Contractor's Travel and Accomodation",4400000,3520000,4840000]
["Freight","Freight on Materials",561506.5,561506.5,561506.5,null,"Environmental Costs","Environmental Costs",500000,500000,500000]
["IDC","IDC",9506533,9506533,9506533,null,"Escalation / Inflation allowance","Escalation / Inflation allowance",10006706,10006706,10006706]
["Legal","LEGAL Allowances/Court Costs",300000,300000,300000,null,"IDC","IDC",9506533,9506533,9506533]
["Construction work","Lines",51914108.175689876,45987234.004816465,71795164.123811722,null,"Legal","LEGAL Allowances/Court Costs",300000,300000,300000]
["Property","Property Lump Sum - Disturbance and Liaison Costs",1800000.0144,1800000.0144,1800000.0144,null,"Property","Property Lump Sum - Disturbance and Liaison Costs",1800000.0144,1800000.0144,1800000.0144]
["Property","Property Lump Sum - Easement and Compensation Costs",2000000.0159999998,2000000.0159999998,2000000.0159999998,null,"Property","Property Lump Sum - Easement and Compensation Costs",2000000.0159999998,2000000.0159999998,2000000.0159999998]
["Risk","Risk Allowance - $",8751332,8751332,8751332,null,"Risk","Risk Allowance - $",9978132,9978132,9978132]
["Stakeholder costs","Stakeholder / Iwi Liason",390000,390000,390000,null,"Stakeholder costs","Stakeholder/ Iwi Liaison",390000,390000,390000]
["Transpower overheads","Transpower Costs - Construction Phase",5641103.1162581397,5474856.5277203964,5884666.2706084661,null,"Transpower overheads","Transpower Costs - Construction Phase",5641103.1162581397,5474856.5277203964,5884666.2706084661]
["Grand Total","Grand Total",113856128.91521353,104714200.28861675,135517589.43824723,null,"Transpower overheads","Consultants Support during Construction / Tendering",497499.47875000001,482574.49438749999,517399.45789999998]
[null,"less IDC, inflation",90904459.415213525,81762530.788616747,112565919.93824723,null,"Grand Total",null,{"$f":"SUM(I5:I24)","v":115906742.7740587},{"$f":"SUM(J5:J24)","v":105959752.82494769},{"$f":"SUM(K5:K24)","v":138891581.72580954}]
[null,null,null,null,null,null,null,"less IDC, Inflation",{"$f":"I25-I17-I16","v":96393503.7740587},{"$f":"J25-J17-J16","v":86446513.824947685},{"$f":"K25-K17-K16","v":119378342.72580954}]
[]
[null,null,null,null,null,null,null,"new total",113856128.915214]
[null,null,null,null,null,null,null,"IDC",9506533]
[null,null,null,null,null,null,null,"Inflation",13445136.5]
[null,null,null,null,null,null,null,null,{"$f":"I28-I29-I30","v":90904459.415214002}]
[null,null,null,null,null,null,null,null,{"$f":"I31-I26","v":-5489044.3588446975}]

{"sheet":"Lines - WRK-WKM-C TTU","index":11,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Project Build start","2022-09-01"]
["Project Build end","2024-06-30"]
[]
["MCA Category","Row Labels","Sum of Cost","Sum of Low Cost Combined","Sum of High Cost Combined",null,null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined"]
["Stakeholder costs","Community/Stakeholder  Engagement",50000,25000,75000,null,null,"Community Care Fund",405103,405103,405103]
["Transpower Overheads","Consultants Support during Construction / Tendering",72792.018617229158,72792.018617229158,72792.018617229158,null,null,"Consultants Support during Construction / Tendering",497499.47875000001,482574.49438749999,517399.45789999998]
["Contractor Overheads","Contractor Safety Compliance & QA Costs",62229.422805529379,49783.538244423507,93344.134208294068,null,null,"Contractor Safety Compliance & QA Costs",200000,160000,220000.00000000003]
["Contractor Overheads","Contractor's Establishment and Disestablishment",48538.949788312901,38831.159830650329,72808.424682469369,null,null,"Contractor's Establishment and Disestablishment",2150000,1720000,2365000]
["Contractor Overheads","Contractor's PM and Site Costs",182954.50304825633,146363.60243860507,274431.75457238447,null,null,"Contractor's PM and Site Costs",7523731.6441154908,6018985.3152923929,8276104.8085270394]
["Contractor Overheads","Contractor's Preliminary & General",53517.303612755262,42813.842890204207,80275.955419132893,null,null,"Contractor's Preliminary & General",895682.77,716546.21600000001,985251.04700000014]
["Contractor Overheads","Contractor's Travel and Accomodation",60000,48000,90000,null,null,"Contractors Training",0,0,0]
["Design","Design Allowance (DDR)",119999.98800000001,119999.98800000001,159999.98800000001,null,null,"Contractor's Travel and Accomodation",4400000,3520000,4840000]
["Investigation","Detail Investigation Report (DIR)",69999.993000000002,69999.993000000002,69999.993000000002,null,null,"Design Allowance",2999999.7,2999999.7,2999999.7]
["Escalation / Inflation allowance","Escalation / Inflation allowance",100158.66,100158.66,100158.66,null,null,"Environmental Costs",500000,500000,500000]
["Freight","Freight on Materials",20000,20000,20000,null,null,"Escalation / Inflation allowance",10006706,10006706,10006706]
["IDC","IDC",29612,29612,29612,null,null,"Freight on Materials",561506.5,561506.5,561506.5]
["Construction Work","Lines",992794.57046134956,897740.7541080619,1204244.97616349,null,null,"IDC",9506533,9506533,9506533]
["Stakeholder costs","Mana Whenua Engagement",120000,60000,140000,null,null,"LEGAL Allowances/Court Costs",300000,300000,300000]
["Risk","Risk Allowance - $",235329.65,235329.65,235329.65,null,null,"Lines",56150745.53453505,49418810.041147374,77355179.911374047]
["Transpower Overheads","Transpower Costs - Construction Phase",151384.77183322917,151384.77183322917,154584.77183322917,null,null,"Property Lump Sum - Disturbance and Liaison Costs",1800000.0144,1800000.0144,1800000.0144]
[null,"(blank)",0,0,0,null,null,"Property Lump Sum - Easement and Compensation Costs",2000000.0159999998,2000000.0159999998,2000000.0159999998]
["Environmental costs","Landowner Cost",314000,314000,414000,null,null,"Risk Allowance - $",9978132,9978132,9978132]
["Transpower Overheads","Vegetation",100000,75000,100000,null,null,"Stakeholder/ Iwi Liaison",390000,390000,390000]
["Transpower Overheads","Environmental Costs",125000,100000,150000,null,null,"Transpower Costs - Construction Phase",5641103.1162581397,5474856.5277203964,5884666.2706084661]
["Community Care Fund","Community Care Fund (CCF)",10000,10000,10000,null,null,"Grand Total",115906742.7740587,105959752.82494766,138891581.72580954]
[null,"Grand Total",{"$f":"SUM(C5:C25)","v":2918311.8311666618},{"$f":"SUM(D5:D25)","v":2606809.9789624033},{"$f":"SUM(E5:E25)","v":3546582.3264962295}]
[null,null,{"$f":"C26-C14-C16","v":2788541.1711666617},{"$f":"D26-D14-D16","v":2477039.3189624031},{"$f":"E26-E14-E16","v":3416811.6664962294}]

{"sheet":"Lines - EDG-KAW-3 TTU","index":12,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,8,0,12],[1,8,1,15]]}
["Project Build start","2023-09-01",null,null,null,null,null,null,"2023-09-01"]
["Project Build end","2024-06-30",null,null,null,null,null,null,"2024-06-30"]
[null,null,null,null,null,null,null,null,"Pivot Table dump from "]
["MCA Category","TEES Category","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined",null,null,null,"Row Labels","Sum of Mode Cost","Sum of Low Cost Combined","Sum of High Cost Combined"]
["Category","Category",null,0,0,null,null,null,"Category",null,0,0]
["Community Care Fund","Community Care Fund (CCF)",36000,36000,360000,null,null,null,"Community Care Fund (CCF)",36000,36000,36000]
["Stakeholder costs","Community Contribution",170000,85000,215000,null,null,null,"Community Contribution",170000,85000,215000]
["Construction Work","Construction Work",5101016.9121256387,4817769.6978056384,6013653.0299204858,null,null,null,"Construction Work",5101016.9121256387,4813809.6978056384,6054891.8047204856]
["Contractor overheads","Contractor Overheads",1303266.5247848167,1042613.2198278533,1954899.7871772246,null,null,null,"Contractor Overheads",1303266.5247848167,1042613.2198278533,1954899.7871772246]
["Environmental costs","Environmental",200000,150000,250000,null,null,null,"Environmental",200000,150000,250000]
["Escalation Allowance","Escalation Allowance",339365.38,339365.38,339365.38,null,null,null,"Escalation / Inflation allowance",339365.38,339365.38,339365.38]
["IDC","IDC",98150,98150,98150,null,null,null,"Escalation Allowance",0,0,0]
["Transpower overheads","Landowner Cost",393000,393000,593000,null,null,null,"IDC",98150,98150,98150]
["Risk","Risk Allowance",1320092.95,1320092.95,1320092.95,null,null,null,"Landowner Cost",393000,393000,593000]
["Transpower overheads","Transpower Overheads",611959.09961720451,611959.09961720451,614019.09961720451,null,null,null,"Risk Allowance",1320092.95,1320092.95,1320092.95]
["Construction Work","Vegetation",100000,100000,120000,null,null,null,"Transpower Overheads",611959.09961720463,611959.09961720463,614019.09961720463]
["Grand Total","Grand Total",9672850.866527658,8993950.3472506963,11878180.246714914,null,null,null,"Vegetation",100000,100000,120000]
[null,null,9235335.4865276571,null,null,null,null,null,"Grand Total",9672850.866527658,8989990.3472506963,11595419.021514915]
[]
[null,null,9672850.866527658,8989990.3472506963,11595419.021514915]

{"sheet":"Subs - BPE-TKU-WKM 1&2 Uprating","index":13,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,7,0,11],[1,7,1,14]]}
["Project Build start","2023-09-01",null,null,null,null,null,"2023-09-01"]
["Project Build end","2026-06-30",null,null,null,null,null,"2026-06-30"]
[]
[]
[null,"Sub-category","Total","Sum of Low Cost Combined","Sum of High Cost Combined"]
["Community Care Fund","Community Care Fund",66632.95,66632.95,66632.95]
["Contractor overheads","Consultants Support during Construction / Tendering",242500,242500,242500]
["Contractor overheads","Contractor Safety Compliance & QA Costs",50000,50000,50000]
["Contractor overheads","Contractor's Establishment and Disestablishment",205000,205000,205000]
["Contractor overheads","Contractor's PM and Site Costs",1471440,1471440,1471440]
["Contractor overheads","Contractor's Preliminary & General",200000,200000,200000]
["Contractor overheads","Contractor's Travel and Accomodation",104000,104000,104000]
["Risk","Risk Allowance - $",3913250,3913250,3913250]
["SCADA","RTS Group",62500,62500,62500,null,null,null,null,null,"Uncertainties"]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",5604892.7591925738,{"$f":"C15*(1-0.3)","v":3923424.9314348013},{"$f":"C15*(1+0.2)","v":6725871.3110310882},null,null,null,null,null,"TKA","-30%/+20%.",null,{"$f":"C15+C16","v":10408925.550932631}]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",4804032.7917400561,{"$f":"C16*(1-0.5)","v":2402016.3958700281},{"$f":"C16*(1+0.4)","v":6725645.9084360786},null,null,null,null,null,"WKM","-50%/+40%.",null,{"$f":"N15/C20","v":0.58556435710739463}]
["Transpower overheads","Transpower Costs - Construction Phase",746638,746638,746638]
["Environmental costs","Environmental Costs",80000,80000,80000]
["Stakeholder costs","Stakeholder costs",225000,225000,225000]
[null,"Grand Total",17775886.50093263]

{"sheet":"Subs - WRK-THI-WKM 1&1 Uprating","index":14,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,6,2,12],[0,7,0,11],[1,7,1,14]]}
["Project Build start","2023-09-01",null,null,null,null,"30612 - WRK-THI-WKM 1&1 Uprating A3","2023-09-01"]
["Project Build end","2025-06-30",null,null,null,null,null,"2025-06-30"]
[]
[]
[null,null,null,null,null,null,"include uncertainty range","Yes","Yes"]
[null,"Row Labels","Sum of Total","Sum of Low - Cost","Sum of High - Cost"]
["Design","Design Allowance",570000,570000,570000]
["Transpower Overheads","Consultants Support during Construction / Tendering",167710,167710,167710]
["Contractor Overheads","Contractor Safety Compliance & QA Costs",80000,80000,80000]
["Contractor Overheads","Contractor's Establishment and Disestablishment",270000,270000,270000]
["Contractor Overheads","Contractor's PM and Site Costs",549920,549920,549920]
["Contractor Overheads","Contractor's Preliminary & General",150000,150000,150000]
["Contractor Overheads","Contractor's Travel and Accomodation",52590.589386799213,52590.589386799213,52590.589386799213]
["Risk","Risk Allowance - $",294488,294488,294488]
["SCADA","RTS Group",58125,58125,58125,null,null,"lower","upper"]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",621007.63327611808,{"$f":"$C16*IF(H$5=\"Yes\",(1+H16),1)","v":558906.86994850624},{"$f":"$C16*IF(I$5=\"Yes\",(1+I16),1)","v":745209.15993134165},null,"TMH",-0.1,0.2]
["Transpower overheads","Transpower Costs - Construction Phase",402400.8,402400.8,402400.8]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",3154992.8817713684,{"$f":"$C18*IF(H$5=\"Yes\",(1+H18),1)","v":2839493.5935942316},{"$f":"$C18*IF(I$5=\"Yes\",(1+I18),1)","v":4416990.0344799152},null,"WRK",-0.1,0.4]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",1107677.49219244,553838.74609621998,1550748.489069416,null,"WKM",-0.5,0.4]
[null,"Grand Total",{"$f":"SUM(C7:C19)","v":7478912.3966267258},{"$f":"SUM(D7:D19)","v":6547473.5990257571},9308182.0728674717]

{"sheet":"Subs - EDG-KAW Uprating","index":15,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,3,0,9],[1,3,1,9]]}
["Project Build start","2023-09-01"]
["Project Build end","2025-09-30"]
[]
[]
["Reporting Level","Row Labels","Sum of Cost","Low","High",null,"include uncertainty range","Yes","Yes"]
["Transpower overheads","Consultants Support during Construction / Tendering",14675,14675,14675]
["Contractor overheads","Contractor Safety Compliance & QA Costs",3000,3000,3000]
["Contractor overheads","Contractor's Establishment and Disestablishment",18000,18000,18000]
["Contractor overheads","Contractor's PM and Site Costs",41108,41108,41108]
["Contractor overheads","Contractor's Preliminary & General",1593.9560000000001,1593.9560000000001,1593.9560000000001]
["Contractor overheads","Contractor's Travel and Accomodation",3065.2999999999993,3065.2999999999993,3065.2999999999993]
["Design","Design Allowance (Lump Sum - enter total $ as quantity)",60000,60000,60000,null,null,"lower","upper"]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",162445.78475389801,{"$f":"$C13*IF(H$5=\"Yes\",(1+H13),1)","v":146201.20627850821},{"$f":"$C13*IF(I$5=\"Yes\",(1+I13),1)","v":194934.94170467762},null,"EDG",-0.1,0.2]
["Escalation Allowance","Escalation / Inflation allowance",64700.26,64700.26,64700.26]
["Contingency and IDC","IDC",81435,81435,81435]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",24713.84,{"$f":"$C16*IF(H$5=\"Yes\",(1+H16),1)","v":22242.456000000002},{"$f":"$C16*IF(I$5=\"Yes\",(1+I16),1)","v":27185.224000000002},null,"KAW",-0.1,0.1]
["Risk","Risk Allowance based on R/W Schedule",96140.96,96140.96,96140.96]
["Transpower overheads","Transpower Costs - Construction Phase",21295.030413193213,21295.030413193213,21295.030413193213]
[null,null,{"$f":"SUM(C6:C18)","v":592173.1311670912},{"$f":"SUM(D6:D18)","v":573457.16869170137},{"$f":"SUM(E6:E18)","v":627133.67211787077}]
[null,null,{"$f":"C19-C15-C14","v":446037.87116709119}]

{"sheet":"Subs - HVDC Capacity Stage 1","index":16,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Project Build start","2024-07-01"]
["Project Build end","2027-05-31"]
[]
["MCA Category","TEES Category","Mode","Low","High",null,null,null,"Low","Mode","High",null,null,"Low","Mode","High"]
["Civil Works","Civil Works",8643294.8469999991,8643294.8469999991,13339123.507499998,null,null,"Civil Works",8643294.8469999991,8643294.8469999991,13339123.507499998,null,"Civil Works",8643294.8469999991,8643294.8469999991,13339123.507499998]
["Primary Plant 220 kV - Statcom","Primary Plant 220 kV - Statcom",36305770.649999999,36305770.649999999,36555132.399999999,null,null,"Primary Plant 220 kV - Statcom",36305770.649999999,36305770.649999999,36555132.399999999,null,"Primary Plant 220 kV - Statcom",36305770.649999999,36305770.649999999,36555132.399999999]
["Primary Plant 220 kV - Other","Primary Plant 220 kV - Other",8586088.1750000007,8586088.1750000007,9946293.75,null,null,"Primary Plant 220 kV - Other",8586088.1750000007,8586088.1750000007,9946293.75,null,"Primary Plant 220 kV - Other",8586088.1750000007,8586088.1750000007,9946293.75]
["Cables","Cables",340047.66901919997,340047.66901919997,437750.57477079995,null,null,"Cables",340047.66901919997,340047.66901919997,437750.57477079995,null,"Cables",340047.66901919997,340047.66901919997,437750.57477079995]
["Protection","Protection",665766.6,665766.6,1001481,null,null,"Protection",665766.6,665766.6,1001481,null,"Protection",665766.6,665766.6,1001481]
["SCADA","SCADA",268580.5,268580.5,434288,null,null,"SCADA",268580.5,268580.5,434288,null,"SCADA",268580.5,268580.5,434288]
["Secondary Equipment","Secondary Equipment",3683673.1065663998,3683673.1065663998,5398837.659849599,null,null,"Secondary Equipment",3683673.1065663998,3683673.1065663998,5398837.659849599,null,"Secondary Equipment",3683673.1065663998,3683673.1065663998,5398837.659849599]
["Communications","Communications",87272.5,87272.5,140636,null,null,"Communications",87272.5,87272.5,140636,null,"Communications",87272.5,87272.5,140636]
["Miscellaneous works","Misc",215124.72,215124.72,425249.44,null,null,"Misc",215124.72,215124.72,425249.44,null,"Misc",215124.72,215124.72,425249.44]
["Switching","Switching",52192,52192,95996,null,null,"Switching",52192,52192,95996,null,"Switching",52192,52192,95996]
["Freight","Freight",151000,151000,242000,null,null,"Freight",151000,151000,242000,null,"Freight",151000,151000,242000]
["Design","Design",2921500,2921500,5014000.55,null,null,"Design",2921500,2921500,5014000.55,null,"Design",2921500,2921500,5014000.55]
["Risk","Risk Allowance ",8734500,8734500,8734500,null,null,"Risk Allowance ",8734500,8734500,8734500,null,"Risk Allowance ",8734500,8734500,8734500]
["Transpower overheads","TP Overheads ",3318676.76,3318676.76,3914153.1885598069,null,null,"TP Overheads ",4511722,4511722,5321268.7855130034,null,"TP Overheads ",3318676.76,3318676.76,3914153.1885598069]
["Consultant Support","Consultant Support ",1160390.43,1160390.43,1368601.4728227963,null,null,"Consultant Support ",2776639,2776639,3274856.5712466422,null,"Consultant Support ",1160390.43,1160390.43,1368601.4728227963]
["Contractor overheads","Contractor Overheads ",5085895.7300000004,5085895.7300000004,5998467.5905170739,null,null,"Contractor Overheads ",14367767,14367767,16945802.523875322,null,"Contractor Overheads ",5085895.7300000004,5085895.7300000004,5998467.5905170739]
["Legal","Legal ",25000,25000,29485.797138614722,null,null,"Legal ",25000,25000,29485.797138614722,null,"Legal ",25000,25000,29485.797138614722]
["Property","Property/Easement ",0,0,0,null,null,"Property/Easement ",0,0,0,null,"Property/Easement ",0,0,0]
["Environmental costs","Environmental ",140000,140000,165120.46397624246,null,null,"Environmental ",140000,140000,165120.46397624246,null,"Environmental ",140000,140000,165120.46397624246]
["Community Care Fund","Community Contribution ",202000,202000,238245.24088000695,null,null,"Community Contribution ",500000,500000,589715.94277229451,null,"Community Contribution ",202000,202000,238245.24088000695]
["CPI ","CPI ",5908798.3200000003,5908798.3200000003,0,null,null,"CPI ",0,0,0,null,"CPI ",5908798.3200000003,5908798.3200000003,0]
["IDC ","IDC ",4601015,4601015,0,null,null,"IDC ",0,0,0,null,"IDC ",4601015,4601015,0]
[null,null,{"$f":"SUM(C5:C26)","v":91096587.007585615},{"$f":"SUM(D5:D26)","v":91096587.007585615},{"$f":"SUM(E5:E26)","v":93479362.636014938},null,null,null,null,null,null,null,null,91096587.007585615,91096587.007585615,93479362.636014938]
[null,null,{"$f":"C27-C25-C26","v":80586773.687585622},{"$f":"D27-D25-D26","v":80586773.687585622},{"$f":"E27-E25-E26","v":93479362.636014938}]