{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Index","Notes & Assumptions","Inputs","Calculations","Outputs|Models"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":140,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Index and File Details"]
[]
[null,"Index",null,null,null,null,null,"File Details"]
[]
[null,"Inputs",null,"Inputs / Calculations",null,"Outputs",null,null,"Model","Transgrid | Humelink (CPA 2) Capex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid (updated for AER determination)"]
[null,"Notes & Assumptions",null,"Calculations",null,{"$f":"'Outputs|Models'!$A$1","v":"Outputs | Models"},null,null,"Revision","2/8/24"]
[null,"Inputs",null,null,null,null,null,null,"Status","AER determination (finalised)"]
[]
[]
[]
[null,"Model Checks",null,null,null,null,null,"Instructions"]
[]
[null,"Worksheet",null,null,null,null,null,null,"Input Sheets"]
[null,"Inputs",null,{"$f":"Inputs!$B$2","v":0},null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,{"$f":"D7","v":"Calculations"},null,{"$f":"SUM(Calculations!A2:A190)","v":0},null,null,null,null,"Historical / Not applicable"]
[null,{"$f":"D7","v":"Calculations"},null,{"$f":"SUM(Calculations!A3:A193)","v":0},null,null,null,null,"Cells not marked as inputs should not be modified."]
[null,{"$f":"F7","v":"Outputs | Models"},null,{"$f":"SUM('Outputs|Models'!A2:A54)","v":0}]
[]
[null,"Total Error Check",null,{"$f":"IF(SUM(D15:D18)=0,0,1)","v":0}]

{"sheet":"Notes & Assumptions","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Assumptions & Notes"]
[]
[null,null,null,null,"User inputs in cells coloured like this"]
[null,null,"*",null,"1.     Inputs are in $. Outputs are $million."]
[null,null,"*",null,"2.     Financial years are recorded in the Capex Forecast Model as tax years (e.g. 2017/18 is shown as 2018, 2018/19 is shown as 2019)"]
[null,null,"*",null,"3.     Escalation is treated as follows:"]
[null,null,null,null,"a.    CPI escalation and Labour escalation are treated separately. "]
[null,null,null,null,"b.    Escalation is applied to Expenditure Components (i.e. Labour)"]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2023-11-29","1","Transgrid",null,"Initial model development to support draft Humelink Stage 2 CPA"]
["2024-01-22",2,"Transgrid",null,"Updated model to reflect as incurred depreciation for biodiversity offsets and as commissioned for all other asset classes"]
["2024-08-01",3,"AER",null,"Updated as per AER determination."]

{"sheet":"Inputs","index":2,"n_rows":192,"n_cols":34,"rows_kept":192,"cut":false,"hidden":false,"merged":[[5,1,5,2],[18,0,18,2],[12,0,12,2],[33,0,33,2],[33,7,33,8],[23,0,23,2],[55,10,55,15],[70,0,70,2],[122,0,122,2],[95,4,95,5],[95,0,95,2],[55,0,55,2]]}
["Inputs"]
["Worksheet check:",0]
[]
["Output Reporting Format and Year"]
["Real"]
[2023]
[]
["Real $2023"]
[]
["Inflation and Labour Escalation"]
[]
[]
["Forecasts",null,null,null,null,null,null,null,null,null,null,"Rates"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
["Actual / Forecast Inflation ","ABS June to June / RBA Forecast","%",null,null,null,null,null,null,null,null,2.0776874435411097E-2,1.5929203539823078E-2,-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,6.0269627279936566E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,"◄ Actual June year on year inflation used for 2019 to 2023. Forecast inflation for 2024 to 2029 as per the AER's final decision for the 2023-28 period."]
["Real labour escalation","AER Final Determination / Transgrid proposal","%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.9046564755527329E-3,1.3076482545953276E-2,1.1546438954636147E-2,4.3304575862308627E-3,3.00941333753012E-3,"◄ Labour escalation as per AER's final decision for the 2023-28 period."]
[]
[]
["Cumulative Factors",null,null,null,null,null,null,null,null,null,null,"Cumulative factors"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,"Nominal"]
["Real (end-year) inflation indexed from 2018","Calculated","Factor",null,null,null,null,null,null,null,null,1,1.0159292035398231,1.0123893805309736,1.0513274336283187,1.1159292035398232,1.1831858407079647,1.2177266423496271,1.2532757952891167,1.2898627363747841,1.3275177618063214,1.3662720522218483]
["Labour based to 2023","Calculated","Factor",null,null,null,null,null,null,null,null,1,1,1,1,1,1,1.0039046564755527,1.0170321981937565,1.0287752983851002,1.0332303661805189,1.0363397834252435]
[]
["Indexation",null,null,null,null,null,null,null,null,null,null,"Indexation"]
["Item","Source","Units",null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
["Real 2023 End Period to Nominal Mid Period","Calculated","Factor",null,null,null,null,null,null,null,null,0.83653020125746624,0.85188065963977389,0.85714155183094476,0.87194647296580097,0.91544942524893658,0.97116235518046667,1.0144915221468893,1.0441076223637888,1.0745883068309359,1.1059588153982864,1.1382451247439618]
["Nominal Mid Period to Real 2023 End Period","Calculated","Factor",null,null,null,null,null,null,null,null,1.1954141027984491,1.1738733456196315,1.1666684433439196,1.1468593898873669,1.0923596349717208,1.0296939483554988,0.98571548225832184,0.95775567439692455,0.93058894615101118,0.90419280182677708,0.87854538382050285]
[]
["Capital Expenditure"]
[]
["Direct Non-Labour Costs"]
[]
[]
["Base Direct Non-Labour Costs | By Category",null,null,null,"Conversion",null,null,"Expenditure",null,null,"Spend Profile Assumption",null,null,null,null,null,null,"$ Spend Profile (June 2023 dollars)",null,null,null,null,null,null,null,null,"Commissioning Profile Assumption"]
["Category","Source","Units",null,"Dollar Yr From","Dollar Yr To",null,"Value","Asset Class",null,2024,2025,2026,2027,2028,"Total",null,2024,2025,2026,2027,2028,"Total",null,null,null,2024,2025,2026,2027,2028,"Total"]
["UGL (West) Substations","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Substations",null,0,0.34342828967038647,0.60265761449150745,5.3914095838106142E-2,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,391.91622142408471,null,0,null,0,0,0.86643204116541861,0.13356795883458139,0,1]
["UGL (West) Transmission Lines","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Transmission Lines",null,0,0.44500042504246135,0.50214707118740032,5.2852503770138268E-2,0,0.99999999999999989,null,0,"c-i-c","c-i-c","c-i-c",0,938.18719815396514,null,0,null,0,0.24319986636342045,0.69110748447195769,6.5692649164621891E-2,0,1]
["UGL (West) Business IT","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Business IT",null,0,0.47845174763386361,0.36710677754369714,0.15444147482243917,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,12.467301087813773,null,0,null,0,0,0,1,0,1]
["AKG (East) Substations","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Substations",null,0,0.35851874817097906,0.63704622374782927,4.4350280811916937E-3,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,92.641388375702221,null,0,null,0,4.1451261587937584E-2,0.95411371033087078,4.4350280811916937E-3,0,1]
["AKG (East) Transmission Lines","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Transmission Lines",null,0,0.54023630629710606,0.45524636802155699,4.51732568133709E-3,0,1.0000000000000002,null,0,"c-i-c","c-i-c","c-i-c",0,1141.386709828661,null,0,null,0,0.36495158188991345,0.6305310924287495,4.51732568133709E-3,0,1]
["AKG (East) Business IT","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Business IT",null,0,0.5821736290099857,0.40457360453347135,1.3252766456542874E-2,0,0.99999999999999989,null,0,"c-i-c","c-i-c","c-i-c",0,14.029933439022255,null,0,null,0,0,0,1,0,1]
["LLE - Transformers","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Substations",null,0,0.46153846153846151,0.46153846153846151,7.6923076923076927E-2,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,13.707889439999999,null,0,null,0,0,0.67,0.33,0,1]
["LLE - Reactors","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Substations",null,0,0.46153846153846156,0.46153846153846156,7.6923076923076927E-2,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,8.0017005399999999,null,0,null,0,0,0.67,0.33,0,1]
["LLE - Steel Towers and Conductors","Project Team Input","$Millions",null,2023,2023,null,"c-i-c","Transmission Lines",null,0,1,0,0,0,1,null,0,"c-i-c","c-i-c","c-i-c",0,7.8820300000000003,null,0,null,0,0,1,0,0,1]
["Biodiversity Offsets","Project Team Input","$Millions",null,2023,2023,null,43.501362999999998,"Biodiversity Offsets",null,0,0.5,0.5,0,0,1,null,0,21.750681499999999,21.750681499999999,0,0,43.501362999999998,null,0,null,0,0.5,0.5,0,0,1]
["Biodiversity Offsets (depreciating)","Project Team Input","$Millions",null,2023,2023,null,310.09550999999999,"Biodiversity Offsets (depreciating)",null,0,3.9152465081464874E-2,0.39871915866519597,0.56212837625333911,0,1,null,0,12.141003627194042,123.64102085305485,174.31348551975108,0,310.09550999999999,null,0,null,0,3.9152465081464874E-2,0.39871915866519597,0.56212837625333911,0,1]
["Land and easements","Project Team Input","$Millions",null,2023,2023,null,197.288634,"Land and Easements",null,0,1,0,0,0,1,null,0,197.288634,0,0,0,197.288634,null,0,null,0,1,0,0,0,1]
[null,null,"$Millions",null,2023,2023,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,null,0,null,null,null,null,null,null,0]
[null,null,"$Millions",null,2023,2023,null,null,null,null,null,null,null,null,null,0,null,0,0,0,0,0,0,null,0,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,3184.6058792892495,"◄ Notional sum with various dollar basis for cross check only",null,null,null,null,null,null,null,"Sub-Total",0,1458.4471119614448,1457.9759950084879,254.68277231931637,0,3171.1058792892495]
[]
[]
[]
[]
["Risk Cost | By Category",null,null,null,"Conversion",null,null,"Risk",null,null,"By Asset Class",null,null,null,null,null,null,null,null,null,null,null,"Risk","◄ $ Spend Profile (June 2023 dollars)"]
["Risk","Source","Units",null,"Dollar Yr From","Dollar Yr To",null,"Value",null,null,"TL","SUB","TL&S","L&E","Bio","Total",null,null,null,null,null,null,"Value"]
["Reimbursable","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",10.07,null,null,null,null,null,null,"c-i-c"]
["Variation","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",110.8,null,null,null,null,null,null,"c-i-c"]
["Time","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",262.87,null,null,null,null,null,null,"c-i-c"]
["Land and Easement risk","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",-1.65,null,null,null,null,null,null,"c-i-c"]
["Biodiversity risk","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0,null,null,null,null,null,null,"c-i-c"]
["Inherent","Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0,null,null,null,null,null,null,"c-i-c"]
[null,"Project Team Input","$Millions",null,2023,2023,null,"c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0,null,null,null,null,null,null,"c-i-c"]
[]
[null,null,null,null,null,null,null,382.09000000000003,null,"Sub-Total","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",382.09000000000003,null,null,null,null,null,"Sub-Total",382.09000000000003]
[]
[]
[]
[]
["Direct Non-Labour Costs + Risk Costs | By RAB asset class",null,null,null,null,null,null,null,null,null,"Components",null,null,null,null,null,null,"As incurred expenditure (June 2023 dollars)",null,null,null,null,null,null,null,null,"As commissioned expenditure (June 2023 dollars)"]
["Category","Source","Units",null,null,null,null,null,null,null,"Base","Risk","Total","Markup",null,null,null,2024,2025,2026,2027,2028,"Total",null,null,null,2024,2025,2026,2027,2028,"Total"]
["Transmission Lines","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",1.1467609604619913,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Underground Cables","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Substations","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",1.1528500397680166,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Secondary Systems","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Communications (short life)","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Business IT","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",1,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Minor Plant, Motor Vehicles & Mobile Plant","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Transmission Line Life Extension","Calculated","$Millions",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Land and Easements","Calculated","$Millions",null,null,null,null,null,null,null,197.288634,"c-i-c","c-i-c",0.99163661906645872,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Synchronous Condensers (2018-23)","Calculated","$Millions",null,null,null,null,null,null,null,0,"c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Leasehold Land and Property","Calculated","$Millions",null,null,null,null,null,null,null,0,"c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Biodiversity Offsets","Calculated","$Millions",null,null,null,null,null,null,null,43.501362999999998,"c-i-c","c-i-c",1,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Biodiversity Offsets (depreciating)","Calculated","$Millions",null,null,null,null,null,null,null,310.09550999999999,"c-i-c","c-i-c",1,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["Buildings - capital works","Calculated","$Millions",null,null,null,null,null,null,null,0,"c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["In-house software","Calculated","$Millions",null,null,null,null,null,null,null,0,"c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
["[Spare]","Calculated","$Millions",null,null,null,null,null,null,null,0,"c-i-c","c-i-c",0,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
[]
[null,null,null,null,null,null,null,null,null,"Total",3171.1058792892495,382.09000000000003,3553.1958792892492,null,null,null,"Total",0,"c-i-c","c-i-c","c-i-c","c-i-c",3553.1958792892497,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c",3553.1958792892488,null,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,0]
[]
[]
["Labour Costs"]
[]
["Labour Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,null,null,null,null,null,null,null,"As incurred expenditure (June 2023 dollars, unescalated)"]
["Component","Source","Units",null,"Dollar Year","Escalation Year",null,null,null,null,null,null,null,null,null,null,null,2024,2025,2026,2027,2028,"Total"]
["Forecast (from 1 August 2023)",null,null,null,2023,2023]
["Labour - Commercial","Transgrid","$Millions",null,null,null,null,"Commercial",null,null,null,null,null,null,null,null,null,1.6115755864666665,5.1670590874933326,4.6167316804,2.1641755907838895,null,13.55954194514389]
["Labour - Environmental Offsets","Transgrid","$Millions",null,null,null,null,"Environmental Offsets",null,null,null,null,null,null,null,null,null,0.55163744449999996,0.84395179399999987,0.84395179399999987,0,null,2.2395410325]
["Labour - CSE","Transgrid","$Millions",null,null,null,null,"CSE",null,null,null,null,null,null,null,null,null,2.9309662907960781,5.4263005330470593,4.8728722122980388,2.3580307315730393,null,15.588169767714215]
["Labour - Enviro Approvals","Transgrid","$Millions",null,null,null,null,"Enviro Approvals",null,null,null,null,null,null,null,null,null,0,0.63735056579999994,1.1041377200000002E-2,8.2810329000000005E-3,null,0.65667297589999996]
["Labour - Land","Transgrid","$Millions",null,null,null,null,"Land",null,null,null,null,null,null,null,null,null,1.2593536672499999,2.8643895994117647,1.2768873224950981,0.236456947245098,null,5.6370875364019613]
["Labour - Controls","Transgrid","$Millions",null,null,null,null,"Controls",null,null,null,null,null,null,null,null,null,1.9754213749999989,5.7222383297333375,5.7941215696000041,2.4659675772666647,null,15.957748851600005]
["Labour - Construction","Transgrid","$Millions",null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null,4.788071415110509,14.700699800312023,18.60185062532317,8.6389300445697348,null,46.729551885315431]
["Labour - Design","Transgrid","$Millions",null,null,null,null,"Design",null,null,null,null,null,null,null,null,null,3.5879194781266679,5.029513885573337,5.412205239560004,2.5434884230023287,null,16.573127026262338]
["Labour - HSE","Transgrid","$Millions",null,null,null,null,"HSE",null,null,null,null,null,null,null,null,null,0.95943114833333332,2.6109662599999997,2.6109662599999997,1.3565406983333335,null,7.5379043666666661]
["Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,null,null,null,null,0.16164447599999995,0.95261387200000014,0.95397230600000005,0.50373041389999984,null,2.5719610679000002]
["Labour - Regulatory","Transgrid","$Millions",null,null,null,null,"Regulatory",null,null,null,null,null,null,null,null,null,0,0.49297499999999994,0.49297499999999994,0.26908218750000001,null,1.2550321874999999]
["Labour - Program","Transgrid","$Millions",null,null,null,null,"Program",null,null,null,null,null,null,null,null,null,3.5379724775450718,3.7414592390239729,4.223322748937937,1.9612087710037314,null,13.463963236510713]
["Labour - Legal","Transgrid","$Millions",null,null,null,null,"Legal",null,null,null,null,null,null,null,null,null,0.43371100500000004,0.43371100500000004,0.43371100500000004,0.19155569387499999,null,1.492688708875]
["Labour - Insurance","Transgrid","$Millions",null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,0,0,0,0,null,0]
["Labour - Indirect - Proportion of labour and labour-related costs","Transgrid","$Millions",null,null,null,null,"Indirect - Proportion of labour and labour-related costs",null,null,null,null,null,null,null,null,null,9.3418732989121409,20.838526702026357,21.490546774634684,9.7274777622654973,null,61.398424537838679]
["Total"]
["Labour","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.139577663040466,69.46175567342118,71.635155915448934,32.424925874218317,0,204.66141512612893]
[]
["Note: Direct labour costs for each year are pro-rated across escalated capex by asset class for that year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",31.139577663040466,69.46175567342118,71.635155915448934,32.424925874218317,0,204.66141512612893]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",31.139577663040463,69.46175567342118,71.635155915448934,32.424925874218317,0,204.66141512612887]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including escalation (Real $2023)",31.261167016608429,70.644842062937172,73.696478901779145,33.502418034394772,0,209.10490601571951]
[]
["Non-Labour Costs"]
[]
["Indirect Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,null,null,null,null,null,null,null,"As incurred expenditure (June 2023 dollars, unescalated)"]
["Component","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,null,null,null,2024,2025,2026,2027,2028,"Total"]
["Forecast (from 1 August 2023)",null,null,null,2023]
["Non Labour - Commercial","Transgrid","$Millions",null,null,null,null,"Commercial",null,null,null,null,null,null,null,null,null,0,7.2102762738461532,7.2102762738461532,1.2017127123076923,null,15.622265259999999]
["Non Labour - Environmental Offsets","Transgrid","$Millions",null,null,null,null,"Environmental Offsets",null,null,null,null,null,null,null,null,null,0,0,0,0,null,0]
["Non Labour - CSE","Transgrid","$Millions",null,null,null,null,"CSE",null,null,null,null,null,null,null,null,null,0,7.2071239339079645,7.2071239339079645,1.2011873223179934,null,15.615435190133923]
["Non Labour - Enviro Approvals","Transgrid","$Millions",null,null,null,null,"Enviro Approvals",null,null,null,null,null,null,null,null,null,0,4.994115230769232,4.994115230769232,0.83235253846153845,null,10.820583000000003]
["Non Labour - Land","Transgrid","$Millions",null,null,null,null,"Land",null,null,null,null,null,null,null,null,null,0,0,0,0,null,0]
["Non Labour - Controls","Transgrid","$Millions",null,null,null,null,"Controls",null,null,null,null,null,null,null,null,null,0,7.9594101459190956,7.9594101459190956,1.3265683576531824,null,17.245388649491375]
["Non Labour - Construction","Transgrid","$Millions",null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null,0,2.2832059117767134,2.2727409987496094,0.3770954871425532,null,4.9330423976688769]
["Non Labour - Design","Transgrid","$Millions",null,null,null,null,"Design",null,null,null,null,null,null,null,null,null,0,1.0930509230769232,1.0930509230769232,0.18217515384615385,null,2.3682770000000004]
["Non Labour - HSE","Transgrid","$Millions",null,null,null,null,"HSE",null,null,null,null,null,null,null,null,null,0,0.64979085647456003,0.64979085647456003,0.10829847607909332,null,1.4078801890282133]
["Non Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,null,null,null,null,0.36890818450664958,0.35768607564201316,0.44697160268333325,0.18896574037627911,null,1.362531603208275]
["Non Labour - Regulatory","Transgrid","$Millions",null,null,null,null,"Regulatory",null,null,null,null,null,null,null,null,null,0,0,0,0,null,0]
["Non Labour - Program","Transgrid","$Millions",null,null,null,null,"Program",null,null,null,null,null,null,null,null,null,11.158731903509461,6.2057680313958121,3.0490944425851207,1.5185719672107405,null,21.93216634470113]
["Non Labour - Legal","Transgrid","$Millions",null,null,null,null,"Legal",null,null,null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
["Non Labour - Insurance","Transgrid","$Millions",null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
["Non Labour - Indirect - Proportion of labour and labour-related costs","Transgrid","$Millions",null,null,null,null,"Indirect - Proportion of labour and labour-related costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total"]
["Non-Labour","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[]
["Note: Indirect costs for each year are pro-rated across escalated capex (including direct labour costs) by asset class for that year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[]
["Commissioning"]
[]
["Set as commissioned capex profile to match that for as incurred capex",null,null,null,"No","Note: if 'No' is selected, then as commissioned capex is determined using the direct non-labour capex commissioning profile assumptions input above"]
[]
[]
["Lookup tables and mapping"]
[]
["PTRM and RFM models",null,"Standard Life"]
["RAB Asset Classes",null,"Years"]
["Transmission Lines",null,50]
["Underground Cables",null,45]
["Substations",null,40]
["Secondary Systems",null,15]
["Communications (short life)",null,10]
["Business IT",null,4]
["Minor Plant, Motor Vehicles & Mobile Plant",null,8]
["Transmission Line Life Extension",null,35]
["Land and Easements",null,"n/a"]
["Synchronous Condensers (2018-23)",null,40]
["Leasehold Land and Property",null,5]
["Biodiversity Offsets"]
["Biodiversity Offsets (depreciating)"]
["Buildings - capital works",null,40]
["In-house software",null,15]
["[Spare]"]
[]
["Cost categories"]
[]
["Commercial"]
["Environmental Offsets"]
["CSE"]
["Enviro Approvals"]
["Land"]
["Controls"]
["Construction"]
["Design"]
["HSE"]
["Project Management"]
["Regulatory"]
["Program"]
["Legal"]
["Insurance"]
["Indirect - Proportion of labour and labour-related costs"]
["Contingency"]
[]
["End"]

{"sheet":"Calculations","index":3,"n_rows":205,"n_cols":21,"rows_kept":205,"cut":false,"hidden":false,"merged":[[115,18,115,20],[6,10,6,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[63,10,63,11],[64,10,64,11],[65,10,65,11],[66,10,66,11]]}
["Calculations",null,null,null,"Real $2023"]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by RAB asset class",null,null,"As incurred expenditure",null,null,null,null,"Total",null,null,"As commissioned expenditure",null,null,null,null,"Total"]
[null,"Capex category","Dollar basis","Units",2024,2025,2026,2027,2028,null,null,null,2024,2025,2026,2027,2028]
[]
[null,"Direct Non-Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Underground Cables","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Substations","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Secondary Systems","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Communications (short life)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Business IT","Real $2023","$Million",0,14.132859258706205,10.252971469804258,2.1114037983255627,0,26.497234526836024,null,null,0,0,0,26.497234526836028,0,26.497234526836028]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",0,195.638634,0,0,0,195.638634,null,null,0,195.638634,0,0,0,195.638634]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Biodiversity Offsets","Real $2023","$Million",0,21.750681499999999,21.750681499999999,0,0,43.501362999999998,null,null,0,21.750681499999999,21.750681499999999,0,0,43.501362999999998,null,null,"← Bio offsets commissioning profile set to match as incurred profile"]
[null,"Biodiversity Offsets (depreciating)","Real $2023","$Million",0,12.141003627194042,123.64102085305485,174.31348551975108,0,310.09550999999999,null,null,0,12.141003627194042,123.64102085305485,174.31348551975108,0,310.09550999999999]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",0,1635.920625688371,1650.9659477544394,266.30930584643852,0,3553.1958792892497,null,null,0,973.29468412573738,2233.4189482237507,346.48224693976073,0,3553.1958792892488]
[]
[null,"Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",21.06086740018922,51.269558823832583,51.041297508281659,7.9414215265118457,0,131.31314525881533,null,null,0,40.556512807029371,82.815210925274101,7.9414215265118457,0,131.31314525881533,null,null,"← c-i-c"]
[null,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Substations","Real $2023","$Million",5.1349787049808953,8.8530448839386668,15.707452134658334,3.3662768197384696,0,33.061752543316366,null,null,0,0.25077768443163639,28.897740387619972,3.913234471264758,0,33.061752543316366]
[null,"Secondary Systems","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Communications (short life)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Business IT","Real $2023","$Million",0.2331237855052779,0.61030687831134933,0.45767624500839205,0.26562020604605152,0,1.5667271148710709,null,null,0,0,0,1.5667271148710709,0,1.5667271148710709]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",1.7212369427824783,8.448368571991784,0,0,0,10.169605514774263,null,null,0,10.169605514774263,0,0,0,10.169605514774263]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Biodiversity Offsets","Real $2023","$Million",0.38272682407397518,0.93927140180299529,0.97091562817774513,0,0,2.2929138540547154,null,null,0.38272682407397518,0.93927140180299529,0.97091562817774513,0,0,2.2929138540547154,null,null,"← Bio offsets commissioning profile set to match as incurred profile"]
[null,"Biodiversity Offsets (depreciating)","Real $2023","$Million",2.7282333590765795,0.52429150305979133,5.5191373856530168,21.929099482098405,0,30.700761729887795,null,null,2.7282333590765795,0.52429150305979133,5.5191373856530168,21.929099482098405,0,30.700761729887795]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",31.261167016608429,70.644842062937158,73.696478901779145,33.502418034394772,0,209.10490601571956,null,null,3.1109601831505547,52.440458911098062,118.20300432672484,35.350482594746083,0,209.10490601571956]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",7.7662519509213341,65.074211296943631,59.524326977854201,3.6369189193281195,0,136.00170914504727,null,null,0,42.004591755437438,89.645751486689022,4.3513659029208043,0,136.00170914504727,null,null,"← c-i-c"]
[null,"Underground Cables","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Substations","Real $2023","$Million",1.8935373186547431,11.236783124627728,18.31802016202063,1.5416479042864808,0,32.98998850958958,null,null,0,0.25023334492090121,28.835014783068669,3.9047403816000106,0,32.98998850958958]
[null,"Secondary Systems","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Communications (short life)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Business IT","Real $2023","$Million",8.5965027915719416E-2,0.77463585929569645,0.53374173047728213,0.12164562093822473,0,1.5159882386269228,null,null,0,0,0,1.5159882386269228,0,1.5159882386269228]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Land and Easements","Real $2023","$Million",0.634710789013476,10.723145160217198,0,0,0,11.357855949230675,null,null,0,11.357855949230675,0,0,0,11.357855949230675]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Biodiversity Offsets","Real $2023","$Million",0.14113155396950702,1.1921761581005046,1.1322811554738328,0,0,2.4655888675438442,null,null,0.14113155396950702,1.1921761581005046,1.1322811554738328,0,0,2.4655888675438442,null,null,"← Bio offsets commissioning profile set to match as incurred profile"]
[null,"Biodiversity Offsets (depreciating)","Real $2023","$Million",1.0060434475413289,0.66546030108309406,6.4364143236367664,10.042831314773828,0,18.150749387035017,null,null,1.0060434475413289,0.66546030108309406,6.4364143236367664,10.042831314773828,0,18.150749387035017]
[null,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",11.527640088016106,89.666411900267875,85.944784349462722,15.343043759326653,0,202.48188009707332,null,null,1.147175001510836,55.470317508772609,126.0494617488683,19.814925837921564,0,202.48188009707332]
[]
[null,"Total"]
[0,"Transmission Lines","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
[0,"Underground Cables","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
[0,"Substations","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
[0,"Secondary Systems","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0]
[0,"Communications (short life)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Business IT","Real $2023","$Million",0.31908881342099732,15.517801996313249,11.244389445289931,2.498669625309839,0,29.579949880334013,null,null,0,0,0,29.57994988033402,0,29.57994988033402,null,0]
[0,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Transmission Line Life Extension","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Land and Easements","Real $2023","$Million",2.3559477317959541,214.81014773220897,0,0,0,217.16609546400494,null,null,0,217.16609546400494,0,0,0,217.16609546400494,null,0]
[0,"Synchronous Condensers (2018-23)","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Leasehold Land and Property","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Biodiversity Offsets","Real $2023","$Million",0.52385837804348223,23.882129059903498,23.853878283651579,0,0,48.259865721598558,null,null,0.52385837804348223,23.882129059903498,23.853878283651579,0,0,48.259865721598558,null,0]
[0,"Biodiversity Offsets (depreciating)","Real $2023","$Million",3.7342768066179084,13.330755431336927,135.59657256234465,206.2854163166233,0,358.94702111692277,null,null,3.7342768066179084,13.330755431336927,135.59657256234465,206.2854163166233,0,358.94702111692277,null,0]
[0,"Buildings - capital works","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"In-house software","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"[Spare]","Real $2023","$Million",0,0,0,0,0,0,null,null,0,0,0,0,0,0,null,0]
[0,"Total","Real $2023","$Million",42.788807104624532,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419,null,null,4.2581351846613904,1081.2054605456078,2477.6714142993442,401.64765537242835,0,3964.7826654020414,null,0]
[]
[0,"Check Direct Non-Labour",null,null,0,0,0,0,0]
[0,"Check Labour Costs",null,null,0,0,0,0,0]
[0,"Check Indirect Non-Labour Costs",null,null,0,0,0,0,0]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Component",null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",2024,2025,2026,2027,2028]
[]
[null,"Direct Non-Labour"]
[null,"Non-Labour","Real $2023","$Million",0,1635.920625688371,1650.9659477544394,266.30930584643852,0,3553.1958792892492]
[null,"Sub-Total","Real $2023","$Million",0,1635.920625688371,1650.9659477544394,266.30930584643852,0,3553.1958792892492]
[]
[null,"Labour Costs"]
[null,"Labour","Real $2023","$Million",31.139577663040463,69.46175567342118,71.635155915448934,32.424925874218317,0,204.66141512612887]
[null,"Labour Escalation","Real $2023","$Million",0.12158935356796619,1.1830863895159922,2.0613229863302109,1.0774921601764547,0,4.443490889590624]
[null,"Sub-Total","Real $2023","$Million",31.261167016608429,70.644842062937172,73.696478901779145,33.502418034394772,0,209.10490601571951]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Non-Labour","Real $2023","$Million",11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[null,"Sub-Total","Real $2023","$Million",11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[]
[null,"Total"]
[null,"Labour","Real $2023","$Million",31.139577663040463,69.46175567342118,71.635155915448934,32.424925874218317,0,204.66141512612887]
[null,"Labour Escalation","Real $2023","$Million",0.12158935356796619,1.1830863895159922,2.0613229863302109,1.0774921601764547,0,4.443490889590624]
[null,"Non-Labour","Real $2023","$Million",11.52764008801611,1725.5870375886389,1736.9107321039021,281.65234960576515,0,3755.6777593863226]
[null,"Total","Real $2023","$Million",42.788807104624539,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419]
[]
[0,"Check Direct Non-Labour",null,null,0,0,0,0,0]
[0,"Check Labour Costs",null,null,0,0,0,0,0]
[0,"Check Indirect Non-Labour Costs",null,null,0,0,0,0,0]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Component",null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",2024,2025,2026,2027,2028]
[]
[null,"Direct Non-Labour Cost"]
[null,"Commercial","Real $2023","$Million",0,127.20447970873022,123.68553242730415,18.743181791666121,0,269.63319392770052,null,null,"← c-i-c"]
[null,"Environmental Offsets","Real $2023","$Million",0,8.7589200054869529,8.9790652742342711,0,0,17.737985279721222]
[null,"CSE","Real $2023","$Million",0,129.86283816973108,126.37809047450884,19.832352446567178,0,276.07328109080714]
[null,"Enviro Approvals","Real $2023","$Million",0,57.577927480431335,51.765235990731284,4.5847007705352461,0,113.92786424169788]
[null,"Land","Real $2023","$Million",0,29.727953117896295,13.585200834972941,1.3320218917251625,0,44.645175844594398]
[null,"Controls","Real $2023","$Million",0,140.61103609334475,143.9594852100777,21.123975327281961,0,305.69449663070441]
[null,"Construction","Real $2023","$Million",0,175.86994879335529,221.41492772610871,50.721235974006163,0,448.00611249347014]
[null,"Design","Real $2023","$Million",0,63.352813842448889,68.886164019902822,15.321347986884867,0,147.56032584923656]
[null,"HSE","Real $2023","$Million",0,33.728698941800324,34.498838982880208,8.2321892656142328,0,76.459727190294771]
[null,"Project Management","Real $2023","$Million",0,13.536727121833927,14.772064805148551,3.867897148495326,0,32.176689075477803]
[null,"Regulatory","Real $2023","$Million",0,5.1163213591141803,5.2449141467973934,1.5158081358961866,0,11.877043641807759]
[null,"Program","Real $2023","$Million",0,102.15829112083314,76.466136923552767,19.327359893453401,0,197.95178793783933]
[null,"Legal","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Insurance","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Indirect - Proportion of labour and labour-related costs","Real $2023","$Million",0,216.27181755271292,228.64460226318283,54.797346754107508,0,499.71376657000326]
[null,"Contingency","Real $2023","$Million",null,null,null,null,null,0]
[null,"Sub-Total","Real $2023","$Million",0,1635.9206256883708,1650.9659477544394,266.30930584643852,0,3553.1958792892492]
[]
[null,"Labour Costs"]
[null,"Commercial","Real $2023","$Million",1.6178682355162062,5.2550654619503696,4.7495795120674549,2.236091938144579,0,13.85860514767861]
[null,"Environmental Offsets","Real $2023","$Million",0.55379139921982423,0.8583261482213842,0.86823675869499051,0,0,2.280354306136199]
[null,"CSE","Real $2023","$Million",2.9424107073030616,5.5187223591848031,5.0130905641993779,2.4363889562481282,0,15.91061258693537]
[null,"Enviro Approvals","Real $2023","$Million",0,0.64820604695560835,1.1359096123512444E-2,8.5562146556199242E-3,0,0.6681213577347408]
[null,"Land","Real $2023","$Million",1.2642710107018387,2.9131764507730806,1.3136301362040461,0.24431449818798023,0,5.7353920958669455]
[null,"Controls","Real $2023","$Million",1.983134716863838,5.8197006270772658,5.9608491466447893,2.547912582848523,0,16.311597073434417]
[null,"Construction","Real $2023","$Million",4.806767189166929,14.951085032897854,19.137124427581906,8.9260048533586733,0,47.82098150300537]
[null,"Design","Real $2023","$Million",3.601929071150697,5.1151775628906719,5.5679430602497453,2.6280094746746068,0,16.91305916896572]
[null,"HSE","Real $2023","$Million",0.96317739737951991,2.6554367548175306,2.6860975932049289,1.4016190424777268,0,7.7063307878797058]
[null,"Project Management","Real $2023","$Million",0.16227564214995069,0.96883898027002591,0.98142314375627204,0.5204695600101612,0,2.63300732618641]
[null,"Regulatory","Real $2023","$Million",0,0.501371447904567,0.50716050272139468,0.27802388712328008,0,1.2865558377492416]
[null,"Program","Real $2023","$Million",3.5517870446898456,3.8051845143168905,4.3448501212152077,2.0263804566206307,0,13.728202136842574]
[null,"Legal","Real $2023","$Million",0.43540449748419169,0.4410980567959733,0.44619116858177665,0.19792115972642962,0,1.5206148825883712]
[null,"Insurance","Real $2023","$Million",0,0,0,0,0,0]
[null,"Indirect - Proportion of labour and labour-related costs","Real $2023","$Million",9.3783501049825304,21.193452618881157,22.108943670533748,10.050725410318435,0,62.731471804715866]
[null,"Contingency","Real $2023","$Million",0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",31.261167016608432,70.644842062937187,73.696478901779159,33.502418034394779,0,209.10490601571956]
[]
[null,"Indirect Non-Labour Costs "]
[null,"Commercial","Real $2023","$Million",0,7.2102762738461532,7.2102762738461532,1.2017127123076923,0,15.622265259999999]
[null,"Environmental Offsets","Real $2023","$Million",0,0,0,0,0,0]
[null,"CSE","Real $2023","$Million",0,7.2071239339079645,7.2071239339079645,1.2011873223179934,0,15.615435190133923]
[null,"Enviro Approvals","Real $2023","$Million",0,4.994115230769232,4.994115230769232,0.83235253846153845,0,10.820583000000003]
[null,"Land","Real $2023","$Million",0,0,0,0,0,0]
[null,"Controls","Real $2023","$Million",0,7.9594101459190956,7.9594101459190956,1.3265683576531824,0,17.245388649491375]
[null,"Construction","Real $2023","$Million",0,2.2832059117767134,2.2727409987496094,0.3770954871425532,0,4.9330423976688769]
[null,"Design","Real $2023","$Million",0,1.0930509230769232,1.0930509230769232,0.18217515384615385,0,2.3682770000000004]
[null,"HSE","Real $2023","$Million",0,0.64979085647456003,0.64979085647456003,0.10829847607909332,0,1.4078801890282133]
[null,"Project Management","Real $2023","$Million",0.36890818450664958,0.35768607564201316,0.44697160268333319,0.18896574037627911,0,1.362531603208275]
[null,"Regulatory","Real $2023","$Million",0,0,0,0,0,0]
[null,"Program","Real $2023","$Million",11.158731903509461,6.2057680313958121,3.0490944425851207,1.5185719672107405,0,21.93216634470113]
[null,"Legal","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Insurance","Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Indirect - Proportion of labour and labour-related costs","Real $2023","$Million",0,0,0,0,0,0]
[null,"Contingency","Real $2023","$Million",0,0,0,0,0,0]
[null,"Sub-Total","Real $2023","$Million",11.52764008801611,89.66641190026786,85.944784349462708,15.343043759326655,0,202.48188009707334]
[]
[null,"Total"]
[null,"Commercial","Real $2023","$Million",1.6178682355162062,139.66982144452675,135.64538821321776,22.180986442118392,0,299.11406433537911]
[null,"Environmental Offsets","Real $2023","$Million",0.55379139921982423,9.6172461537083365,9.847302032929262,0,0,20.018339585857422]
[null,"CSE","Real $2023","$Million",2.9424107073030616,142.58868446282384,138.59830497261618,23.4699287251333,0,307.59932886787635]
[null,"Enviro Approvals","Real $2023","$Million",0,63.220248758156174,56.77071031762403,5.4256095236524047,0,125.41656859943262]
[null,"Land","Real $2023","$Million",1.2642710107018387,32.641129568669378,14.898830971176988,1.5763363899131426,0,50.380567940461354]
[null,"Controls","Real $2023","$Million",1.983134716863838,154.39014686634113,157.87974450264159,24.998456267783666,0,339.25148235363019]
[null,"Construction","Real $2023","$Million",4.806767189166929,193.10423973802986,242.82479315244024,60.024336314507387,0,500.76013639414435]
[null,"Design","Real $2023","$Million",3.601929071150697,69.561042328416477,75.547158003229484,18.131532615405629,0,166.8416620182023]
[null,"HSE","Real $2023","$Million",0.96317739737951991,37.033926553092414,37.834727432559696,9.7421067841710531,0,85.573938167202684]
[null,"Project Management","Real $2023","$Million",0.53118382665660024,14.863252177745967,16.200459551588157,4.5773324488817666,0,36.172228004872494]
[null,"Regulatory","Real $2023","$Million",0,5.6176928070187468,5.7520746495187884,1.7938320230194666,0,13.163599479557002]
[null,"Program","Real $2023","$Million",14.710518948199306,112.16924366654584,83.860081487353099,22.872312317284774,0,233.61215641938301]
[null,"Legal","Real $2023","$Million",0.43540449748419169,259.24425075616784,255.17196307009991,24.318247798317731,0,539.16986612206972]
[null,"Insurance","Real $2023","$Million",0,325.0456841987392,329.02212671496932,31.195677825545257,0,685.26348873925372]
[null,"Indirect - Proportion of labour and labour-related costs","Real $2023","$Million",9.3783501049825304,237.46527017159409,250.75354593371657,64.848072164425943,0,562.44523837471911]
[null,"Contingency","Real $2023","$Million",0,0,0,0,0,0]
[null,"Total","Real $2023","$Million",42.788807104624546,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419]
[]
[0,"Check Direct Non-Labour",null,null,0,0,0,0,0]
[0,"Check Labour Costs",null,null,0,0,0,0,0]
[0,"Check Indirect Non-Labour Costs",null,null,0,0,0,0,0]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Component",null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",2024,2025,2026,2027,2028]
[]
[null,"Total Capex"]
[null,"Actual","Real $2023","$Million",null,null,null,null,null,0]
[null,"Forecast","Real $2023","$Million",42.788807104624539,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419]
[null,"Sub-Total","Real $2023","$Million",42.788807104624539,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419]
[]
[0,"Check Total Capex",null,null,0,0,0,0,0]
[]
["End"]

{"sheet":"Outputs|Models","index":4,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Outputs | Models"]
[]
["Outputs | PTRM"]
[]
[null,"As Incurred",null,"Dollar basis","Units",2024,2025,2026,2027,2028,"Total",null,"Std Life"]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,50]
[null,"Underground Cables",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,45]
[null,"Substations",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,40]
[null,"Secondary Systems",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,15]
[null,"Communications (short life)",null,"Real $2023","$Million",0,0,0,0,0,0,null,10]
[null,"Business IT",null,"Real $2023","$Million",0.31908881342099732,15.517801996313249,11.244389445289931,2.498669625309839,0,29.579949880334013,null,4]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million",0,0,0,0,0,0,null,8]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million",0,0,0,0,0,0,null,35]
[null,"Land and Easements",null,"Real $2023","$Million",2.3559477317959541,214.81014773220897,0,0,0,217.16609546400494]
[null,"Synchronous Condensers (2018-23)",null,"Real $2023","$Million",0,0,0,0,0,0,null,40]
[null,"Leasehold Land and Property",null,"Real $2023","$Million",0,0,0,0,0,0,null,5]
[null,"Biodiversity Offsets",null,"Real $2023","$Million",0.52385837804348223,23.882129059903498,23.853878283651579,0,0,48.259865721598558,null,47.647684725986331,"◄ Calculated as the weighted average standard life of other depreciating assets"]
[null,"Biodiversity Offsets (depreciating)",null,"Real $2023","$Million",3.7342768066179084,13.330755431336927,135.59657256234465,206.2854163166233,0,358.94702111692277,null,47.647684725986331]
[null,"Buildings - capital works",null,"Real $2023","$Million",0,0,0,0,0,0,null,40]
[null,"In-house software",null,"Real $2023","$Million",0,0,0,0,0,0,null,15]
[null,"[Spare]",null,"Real $2023","$Million",0,0,0,0,0,0]
[null,"Total",null,"Real $2023","$Million",42.788807104624532,1796.231879651576,1810.6072110056812,315.15476764015995,0,3964.7826654020419]
[]
[null,"As Commissioned",null,"Dollar basis","Units",2024,2025,2026,2027,2028,"Total"]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[null,"Underground Cables",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[null,"Substations",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[null,"Secondary Systems",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[null,"Communications (short life)",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Business IT",null,"Real $2023","$Million",0,0,0,29.57994988033402,0,29.57994988033402,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Land and Easements",null,"Real $2023","$Million",0,217.16609546400494,0,0,0,217.16609546400494,0]
[null,"Synchronous Condensers (2018-23)",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Leasehold Land and Property",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Biodiversity Offsets",null,"Real $2023","$Million",0.52385837804348223,23.882129059903498,23.853878283651579,0,0,48.259865721598558,0]
[null,"Biodiversity Offsets (depreciating)",null,"Real $2023","$Million",3.7342768066179084,13.330755431336927,135.59657256234465,206.2854163166233,0,358.94702111692277,0]
[null,"Buildings - capital works",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"In-house software",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"[Spare]",null,"Real $2023","$Million",0,0,0,0,0,0,0]
[null,"Total",null,"Real $2023","$Million",4.2581351846613904,1081.2054605456078,2477.6714142993442,401.64765537242835,0,3964.7826654020414,0]
[]
[0,"Check - As incurred",null,null,null,0,0,0,0,0]
[0,"Check - As commissioned",null,null,null,null,null,null,null,null,null,0]
[]
["Indexation factors"]
[]
[null,"Indexation"]
[null,"Factor",null,"Source","Unit",2024,2025,2026,2027,2028]
[null,"Real 2023 End Period to Nominal Mid Period",null,"Inputs","Factor",1.0144915221468893,1.0441076223637888,1.0745883068309359,1.1059588153982864,1.1382451247439618]
[]
["End"]