{"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"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs | Models",null,null,"Revision","2023-11-28"]
[null,"Inputs",null,null,null,null,null,null,"Status","Draft CPA"]
[]
[]
[]
[null,"Model Checks",null,null,null,null,null,"Instructions"]
[]
[null,"Worksheet",null,null,null,null,null,null,"Input Sheets"]
[null,"Inputs",null,0,null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,"Calculations",null,0,null,null,null,null,"Historical / Not applicable"]
[null,"Calculations",null,0,null,null,null,null,"Cells not marked as inputs should not be modified."]
[null,"Outputs | Models",null,0]
[]
[null,"Total Error Check",null,0]

{"sheet":"Notes & Assumptions","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"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"]

{"sheet":"Inputs","index":2,"n_rows":190,"n_cols":32,"rows_kept":190,"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],[121,0,121,2],[94,4,94,5],[94,0,94,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","c-i-c","c-i-c",null,0,null,0,0.34342828967038647,0.60265761449150745,5.3914095838106142E-2,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","c-i-c","c-i-c",null,0,null,0,0.44500042504246135,0.50214707118740032,5.2852503770138268E-2,0,0.99999999999999989]
["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","c-i-c","c-i-c",null,0,null,0,0.47845174763386361,0.36710677754369714,0.15444147482243917,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","c-i-c","c-i-c",null,0,null,0,0.35851874817097906,0.63704622374782927,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","c-i-c","c-i-c",null,0,null,0,0.54023630629710606,0.45524636802155699,4.51732568133709E-3,0,1.0000000000000002]
["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","c-i-c","c-i-c",null,0,null,0,0.5821736290099857,0.40457360453347135,1.3252766456542874E-2,0,0.99999999999999989]
["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","c-i-c","c-i-c",null,0,null,0,0.46153846153846151,0.46153846153846151,7.6923076923076927E-2,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","c-i-c","c-i-c",null,0,null,0,0.46153846153846156,0.46153846153846156,7.6923076923076927E-2,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","c-i-c","c-i-c",null,0,null,0,1,0,0,0,1]
["Biodiversity Offsets","Project Team Input","$Millions",null,2023,2023,null,437.47,"Biodiversity Offsets",null,0,0.5,0.5,0,0,1,null,0,218.7,218.7," -   "," -   ",437.5,null,0,null,0,0.5,0.5,0,0,1]
["Land and easements","Project Team Input","$Millions",null,2023,2023,null,197.29,"Land and Easements",null,0,1,0,0,0,1,null,0,197.3," -   "," -   "," -   ",197.3,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," -   "," -   "," -   "," -   "," -   ",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," -   "," -   "," -   "," -   "," -   ",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," -   "," -   "," -   "," -   "," -   ",null,0,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,3268.5,"◄ Notional sum with various dollar basis for cross check only",null,null,null,null,null,null,null,"Sub-Total",0,1656.8,1531.3,80.400000000000006," -   ",3268.5]
[]
[]
[]
[]
["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","c-i-c",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","c-i-c",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","c-i-c",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","c-i-c",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","c-i-c",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","c-i-c",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","c-i-c",null,null,null,null,null,null,"c-i-c"]
[]
[null,null,null,null,null,null,null,599.07498448737692,null,"Sub-Total","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",599.1,null,null,null,null,null,"Sub-Total",599.1]
[]
[]
[]
[]
["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","c-i-c",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"]
["Underground Cables","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Substations","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Secondary Systems","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Communications (short life)","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Business IT","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Minor Plant, Motor Vehicles & Mobile Plant","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Transmission Line Life Extension","Calculated","$Millions",null,null,null,null,null,null,null,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Land and Easements","Calculated","$Millions",null,null,null,null,null,null,null,197.3,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Synchronous Condensers (2018-23)","Calculated","$Millions",null,null,null,null,null,null,null," -   ","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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Leasehold Land and Property","Calculated","$Millions",null,null,null,null,null,null,null," -   ","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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Biodiversity Offsets","Calculated","$Millions",null,null,null,null,null,null,null,437.5,"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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Buildings - capital works","Calculated","$Millions",null,null,null,null,null,null,null," -   ","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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["In-house software","Calculated","$Millions",null,null,null,null,null,null,null," -   ","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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["[Spare]","Calculated","$Millions",null,null,null,null,null,null,null," -   ","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,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[]
[null,null,null,null,null,null,null,null,null,"Total",3268.5,599.1,3867.6,null,null,null,"Total",0,"c-i-c","c-i-c","c-i-c","c-i-c",3867.6,null,null,null,0,"c-i-c","c-i-c","c-i-c","c-i-c",3867.6]
[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.61,5.17,4.62,2.16,null,13.56]
["Labour - Environmental Offsets","Transgrid","$Millions",null,null,null,null,"Environmental Offsets",null,null,null,null,null,null,null,null,null,0.55000000000000004,0.84,0.84," -   ",null,2.2400000000000002]
["Labour - CSE","Transgrid","$Millions",null,null,null,null,"CSE",null,null,null,null,null,null,null,null,null,2.93,5.43,4.87,2.36,null,15.59]
["Labour - Enviro Approvals","Transgrid","$Millions",null,null,null,null,"Enviro Approvals",null,null,null,null,null,null,null,null,null," -   ",0.64,0.01,0.01,null,0.66]
["Labour - Land","Transgrid","$Millions",null,null,null,null,"Land",null,null,null,null,null,null,null,null,null,1.26,2.86,1.28,0.24,null,5.64]
["Labour - Controls","Transgrid","$Millions",null,null,null,null,"Controls",null,null,null,null,null,null,null,null,null,1.98,5.72,5.79,2.4700000000000002,null,15.96]
["Labour - Construction","Transgrid","$Millions",null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null,4.79,14.7,18.600000000000001,8.64,null,46.73]
["Labour - Design","Transgrid","$Millions",null,null,null,null,"Design",null,null,null,null,null,null,null,null,null,3.59,5.03,5.41,2.54,null,16.57]
["Labour - HSE","Transgrid","$Millions",null,null,null,null,"HSE",null,null,null,null,null,null,null,null,null,0.96,2.61,2.61,1.36,null,7.54]
["Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,null,null,null,null,0.16,0.95,0.95,0.5,null,2.57]
["Labour - Regulatory","Transgrid","$Millions",null,null,null,null,"Regulatory",null,null,null,null,null,null,null,null,null," -   ",0.49,0.49,0.27,null,1.26]
["Labour - Program","Transgrid","$Millions",null,null,null,null,"Program",null,null,null,null,null,null,null,null,null,3.54,3.74,4.22,1.96,null,13.46]
["Labour - Legal",null,null,null,null,null,null,"Legal",null,null,null,null,null,null,null,null,null,0.43,0.43,0.43,0.19,null,1.49]
["Labour - Insurance",null,null,null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null," -   "," -   "," -   "," -   ",null," -   "]
["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.34,20.84,21.49,9.73,null,61.4]
["Total"]
["Labour","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,31.14,69.459999999999994,71.64,32.42," -   ",204.66]
[]
["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.14,69.459999999999994,71.64,32.42," -   ",204.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",31.14,69.459999999999994,71.64,32.42," -   ",204.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total including escalation (Real $2023)",31.26,70.64,73.7,33.5," -   ",209.1]
[]
["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,"-   ",7.21,7.21,1.2,null,15.62]
["Non Labour - Environmental Offsets","Transgrid","$Millions",null,null,null,null,"Environmental Offsets",null,null,null,null,null,null,null,null,null," -   "," -   "," -   "," -   ",null," -   "]
["Non Labour - CSE","Transgrid","$Millions",null,null,null,null,"CSE",null,null,null,null,null,null,null,null,null," -   ",7.21,7.21,1.2,null,15.62]
["Non Labour - Enviro Approvals","Transgrid","$Millions",null,null,null,null,"Enviro Approvals",null,null,null,null,null,null,null,null,null," -   ",4.99,4.99,0.83,null,10.82]
["Non Labour - Land","Transgrid","$Millions",null,null,null,null,"Land",null,null,null,null,null,null,null,null,null," -   "," -   "," -   "," -   ",null," -   "]
["Non Labour - Controls","Transgrid","$Millions",null,null,null,null,"Controls",null,null,null,null,null,null,null,null,null," -   ",7.96,7.96,1.33,null,17.25]
["Non Labour - Construction","Transgrid","$Millions",null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null," -   ",2.2799999999999998,2.27,0.38,null,4.93]
["Non Labour - Design","Transgrid","$Millions",null,null,null,null,"Design",null,null,null,null,null,null,null,null,null," -   ",1.0900000000000001,1.0900000000000001,0.18,null,2.37]
["Non Labour - HSE","Transgrid","$Millions",null,null,null,null,"HSE",null,null,null,null,null,null,null,null,null," -   ",0.65,0.65,0.11,null,1.41]
["Non Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,null,null,null,null,0.37,0.36,0.45,0.19,null,1.36]
["Non Labour - Regulatory","Transgrid","$Millions",null,null,null,null,"Regulatory",null,null,null,null,null,null,null,null,null," -   "," -   "," -   "," -   ",null," -   "]
["Non Labour - Program","Transgrid","$Millions",null,null,null,null,"Program",null,null,null,null,null,null,null,null,null,11.16,6.21,3.05,1.52,null,21.93]
["Non Labour - Legal",null,null,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",null,null,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," -   "]
["Total"]
["Non-Labour","Calculated","$Millions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.53,89.67,85.94,15.34," -   ",202.48]
["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"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total (Real $2023)",11.53,89.67,85.94,15.34," -   ",202.48]
[]
["Commissioning"]
[]
["Set as commissioned capex profile to match that for as incurred capex",null,null,null,"Yes","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"]
["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":203,"n_cols":21,"rows_kept":203,"cut":false,"hidden":false,"merged":[[2,0,2,1],[2,10,2,12],[2,18,2,20],[3,0,3,1],[3,10,3,12],[3,18,3,20],[0,0,0,1],[0,10,0,12],[0,18,0,20],[1,0,1,1],[1,10,1,12],[1,18,1,20],[6,10,6,11],[6,18,6,20],[7,10,7,11],[7,18,7,20],[8,10,8,11],[8,18,8,20],[4,4,4,8],[4,10,4,11],[4,12,4,16],[4,18,4,20],[5,10,5,11],[5,18,5,20],[12,10,12,11],[12,18,12,20],[13,10,13,11],[13,18,13,20],[14,10,14,11],[14,18,14,20],[9,10,9,11],[9,18,9,20],[10,10,10,11],[10,18,10,20],[11,10,11,11],[11,18,11,20],[18,10,18,11],[18,18,18,20],[19,10,19,11],[19,18,19,20],[20,10,20,11],[20,18,20,20],[15,10,15,11],[15,18,15,20],[16,10,16,11],[16,18,16,20],[17,10,17,11],[17,18,17,20],[24,10,24,11],[24,18,24,20],[25,10,25,11],[25,18,25,20],[26,10,26,11],[26,18,26,19],[21,10,21,11],[21,18,21,20],[22,10,22,11],[22,18,22,20],[23,10,23,11],[23,18,23,20],[30,10,30,11],[30,18,30,20],[31,10,31,11],[31,18,31,20],[32,10,32,11],[32,18,32,20],[27,10,27,11],[27,18,27,20],[28,10,28,11],[28,18,28,20],[29,10,29,11],[29,18,29,20],[36,10,36,11],[36,18,36,20],[37,10,37,11],[37,18,37,20],[38,10,38,11],[38,18,38,20],[33,10,33,11],[33,18,33,20],[34,10,34,11],[34,18,34,20],[35,10,35,11],[35,18,35,20],[42,10,42,11],[42,18,42,20],[43,10,43,11],[43,18,43,20],[44,10,44,11],[44,18,44,20],[39,10,39,11],[39,18,39,20],[40,10,40,11],[40,18,40,20],[41,10,41,11],[41,18,41,20],[48,10,48,11],[48,18,48,20],[49,10,49,11],[49,18,49,20],[50,10,50,11],[50,18,50,20],[45,10,45,11],[45,18,45,20],[46,10,46,11],[46,18,46,20],[47,10,47,11],[47,18,47,20],[54,10,54,11],[54,18,54,20],[55,10,55,11],[55,18,55,20],[56,10,56,11],[56,18,56,20],[51,10,51,11],[51,18,51,20],[52,10,52,11],[52,18,52,20],[53,10,53,11],[53,18,53,20],[60,10,60,11],[60,18,60,20],[61,10,61,11],[61,18,61,20],[62,10,62,11],[63,10,63,11],[57,10,57,11],[57,18,57,20],[58,10,58,11],[58,18,58,20],[59,10,59,11],[59,18,59,20],[70,10,70,11],[71,10,71,11],[72,10,72,11],[73,10,73,11],[74,10,74,11],[75,10,75,11],[64,10,64,11],[65,10,65,11],[66,10,66,11],[67,10,67,11],[68,10,68,11],[69,10,69,11],[82,0,82,1],[82,10,82,12],[82,18,82,20],[76,10,76,11],[77,10,77,11],[78,0,78,1],[78,10,78,12],[78,18,78,20],[79,10,79,12],[79,18,79,20],[83,10,83,12],[83,18,83,20],[84,10,84,12],[84,18,84,20],[85,10,85,12],[85,18,85,20],[80,10,80,12],[80,18,80,20],[81,10,81,12],[81,18,81,20],[89,10,89,12],[89,18,89,20],[90,10,90,12],[90,18,90,20],[91,10,91,12],[91,18,91,20],[86,10,86,12],[86,18,86,20],[87,10,87,12],[87,18,87,20],[88,10,88,12],[88,18,88,20],[95,10,95,12],[95,18,95,20],[96,10,96,12],[96,18,96,20],[97,10,97,12],[97,18,97,20],[92,10,92,12],[92,18,92,20],[93,10,93,12],[93,18,93,20],[94,10,94,12],[94,18,94,20],[101,10,101,12],[101,18,101,20],[102,10,102,12],[102,18,102,20],[103,10,103,12],[103,18,103,20],[98,10,98,12],[98,18,98,20],[99,10,99,12],[99,18,99,20],[100,10,100,12],[100,18,100,20],[107,10,107,12],[107,18,107,20],[108,0,108,1],[108,10,108,12],[108,18,108,20],[109,10,109,12],[109,18,109,20],[104,0,104,1],[104,10,104,12],[104,18,104,20],[105,10,105,12],[105,18,105,20],[106,10,106,12],[106,18,106,20],[113,10,113,11],[113,18,113,20],[114,10,114,12],[114,18,114,20],[115,10,115,12],[115,18,115,20],[110,10,110,12],[110,18,110,20],[111,10,111,12],[111,18,111,20],[112,10,112,12],[112,18,112,20],[119,10,119,12],[119,18,119,20],[120,10,120,12],[120,18,120,20],[121,10,121,12],[121,18,121,20],[116,10,116,12],[116,18,116,20],[117,10,117,12],[117,18,117,20],[118,10,118,12],[118,18,118,20],[125,10,125,12],[125,18,125,20],[126,10,126,12],[126,18,126,20],[127,10,127,12],[127,18,127,20],[122,10,122,12],[122,18,122,20],[123,10,123,12],[123,18,123,20],[124,10,124,12],[124,18,124,20],[131,10,131,12],[131,18,131,20],[132,10,132,12],[132,18,132,20],[133,10,133,12],[133,18,133,20],[128,10,128,12],[128,18,128,20],[129,10,129,12],[129,18,129,20],[130,10,130,12],[130,18,130,20],[137,10,137,12],[137,18,137,20],[138,10,138,12],[138,18,138,20],[139,10,139,12],[139,18,139,20],[134,10,134,12],[134,18,134,20],[135,10,135,12],[135,18,135,20],[136,10,136,12],[136,18,136,20],[143,10,143,12],[143,18,143,20],[144,10,144,12],[144,18,144,20],[145,10,145,12],[145,18,145,20],[140,10,140,12],[140,18,140,20],[141,10,141,12],[141,18,141,20],[142,10,142,12],[142,18,142,20],[149,10,149,12],[149,18,149,20],[150,10,150,12],[150,18,150,20],[151,10,151,12],[151,18,151,20],[146,10,146,12],[146,18,146,20],[147,10,147,12],[147,18,147,20],[148,10,148,12],[148,18,148,20],[155,10,155,12],[155,18,155,20],[156,10,156,12],[156,18,156,20],[157,10,157,12],[157,18,157,20],[152,10,152,12],[152,18,152,20],[153,10,153,12],[153,18,153,20],[154,10,154,12],[154,18,154,20],[161,10,161,12],[161,18,161,20],[162,10,162,12],[162,18,162,20],[163,10,163,12],[163,18,163,20],[158,10,158,12],[158,18,158,20],[159,10,159,12],[159,18,159,20],[160,10,160,12],[160,18,160,20],[167,10,167,12],[167,18,167,20],[168,10,168,12],[168,18,168,20],[169,10,169,12],[169,18,169,20],[164,10,164,12],[164,18,164,20],[165,10,165,12],[165,18,165,20],[166,10,166,12],[166,18,166,20],[173,10,173,12],[173,18,173,20],[174,10,174,12],[174,18,174,20],[175,10,175,12],[175,18,175,20],[170,10,170,12],[170,18,170,20],[171,10,171,12],[171,18,171,20],[172,10,172,12],[172,18,172,20],[179,10,179,12],[179,18,179,20],[180,10,180,12],[180,18,180,20],[181,10,181,12],[181,18,181,20],[176,10,176,12],[176,18,176,20],[177,10,177,12],[177,18,177,20],[178,10,178,12],[178,18,178,20],[187,0,187,1],[187,10,187,12],[187,18,187,20],[182,10,182,12],[182,18,182,20],[183,10,183,12],[183,18,183,20],[184,10,184,12],[184,18,184,20],[188,10,188,12],[188,18,188,20],[189,10,189,12],[189,18,189,20],[190,10,190,12],[190,18,190,20],[185,10,185,12],[185,18,185,20],[186,10,186,12],[186,18,186,20],[194,10,194,12],[194,18,194,20],[195,10,195,12],[195,18,195,20],[196,10,196,12],[196,18,196,20],[191,0,191,1],[191,10,191,12],[191,18,191,20],[192,10,192,12],[192,18,192,20],[193,10,193,12],[193,18,193,20],[200,10,200,12],[200,18,200,20],[201,0,201,1],[201,10,201,12],[201,18,201,20],[202,0,202,1],[197,10,197,12],[197,18,197,20],[198,10,198,12],[198,18,198,20],[199,0,199,1],[199,10,199,12],[199,18,199,20]]}
[]
[]
["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","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Business IT","Real $2023","$Million","-   ",14.1,10.3,2.1," -   ",26.5,null,null," -   ",14.1,10.3,2.1," -   ",26.5]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Transmission Line Life Extension","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Land and Easements","Real $2023","$Million","-   ",196.7," -   "," -   "," -   ",196.7,null,null," -   ",196.7," -   "," -   "," -   ",196.7]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Leasehold Land and Property","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Biodiversity Offsets","Real $2023","$Million","-   ",233.3,233.3," -   "," -   ",466.5,null,null," -   ",233.3,233.3," -   "," -   ",466.5]
[null,"Buildings - capital works","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"In-house software","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"[Spare]","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Sub-Total","Real $2023","$Million","-   ",1939.3,1830.8,97.5," -   ",3867.6,null,null," -   ",1939.3,1830.8,97.5," -   ",3867.6]
[]
[null,"Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",20.7,46.6,48.9,23.1," -   ",139.30000000000001,null,null," -   ",69.5,66.099999999999994,3.6," -   ",139.30000000000001,null,null,"← c-i-c"]
[null,"Underground Cables","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Substations","Real $2023","$Million",5,7.9,15,9.6999999999999993," -   ",37.5,null,null," -   ",13.2,22.6,1.7," -   ",37.5]
[null,"Secondary Systems","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Communications (short life)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Business IT","Real $2023","$Million",0.2,0.5,0.4,0.7," -   ",1.9,null,null," -   ",1,0.7,0.1," -   ",1.9]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Transmission Line Life Extension","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Land and Easements","Real $2023","$Million",1.6,7.2," -   "," -   "," -   ",8.8000000000000007,null,null," -   ",8.8000000000000007," -   "," -   "," -   ",8.8000000000000007]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Leasehold Land and Property","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Biodiversity Offsets","Real $2023","$Million",3.8,8.5,9.4," -   "," -   ",21.7,null,null," -   ",10.8,10.8," -   "," -   ",21.7]
[null,"Buildings - capital works","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"In-house software","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"[Spare]","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Sub-Total","Real $2023","$Million",31.3,70.599999999999994,73.7,33.5," -   ",209.1,null,null," -   ",103.3,100.3,5.5," -   ",209.1]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Transmission Lines","Real $2023","$Million",7.6,59.1,57.1,10.6," -   ",134.4,null,null," -   ",67.099999999999994,63.8,3.5," -   ",134.4]
[null,"Underground Cables","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Substations","Real $2023","$Million",1.8,10,17.399999999999999,4.4000000000000004," -   ",33.700000000000003,null,null," -   ",11.8,20.3,1.5," -   ",33.700000000000003]
[null,"Secondary Systems","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Communications (short life)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Business IT","Real $2023","$Million",0.1,0.7,0.5,0.3," -   ",1.5,null,null," -   ",0.8,0.6,0.1," -   ",1.5]
[null,"Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Transmission Line Life Extension","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Land and Easements","Real $2023","$Million",0.6,9.1," -   "," -   "," -   ",9.6999999999999993,null,null," -   ",9.6999999999999993," -   "," -   "," -   ",9.6999999999999993]
[null,"Synchronous Condensers (2018-23)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Leasehold Land and Property","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Biodiversity Offsets","Real $2023","$Million",1.4,10.8,11," -   "," -   ",23.1,null,null," -   ",11.6,11.6," -   "," -   ",23.1]
[null,"Buildings - capital works","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"In-house software","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"[Spare]","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Sub-Total","Real $2023","$Million",11.5,89.7,85.9,15.3," -   ",202.5,null,null," -   ",101,96.3,5.2," -   ",202.5]
[]
[null,"Total"]
["●","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," -   ",1415.4,1345.6,74.3," -   ",2835.2,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," -   "," -   "," -   "," -   "," -   "," -   ",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," -   ",241.5,414.5,31.5," -   ",687.5,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," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Communications (short life)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Business IT","Real $2023","$Million",0.3,15.3,11.1,3.2," -   ",29.9,null,null," -   ",16,11.6,2.4," -   ",29.9,null,"●"]
["●","Minor Plant, Motor Vehicles & Mobile Plant","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Transmission Line Life Extension","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Land and Easements","Real $2023","$Million",2.2000000000000002,212.9," -   "," -   "," -   ",215.1,null,null," -   ",215.1," -   "," -   "," -   ",215.1,null,"●"]
["●","Synchronous Condensers (2018-23)","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Leasehold Land and Property","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Biodiversity Offsets","Real $2023","$Million",5.2,252.6,253.6," -   "," -   ",511.3,null,null," -   ",255.7,255.7," -   "," -   ",511.3,null,"●"]
["●","Buildings - capital works","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","In-house software","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","[Spare]","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   ",null,null," -   "," -   "," -   "," -   "," -   "," -   ",null,"●"]
["●","Total","Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004,null,null," -   ",2143.6,2027.3,108.2," -   ",4279.1000000000004,null,"●"]
[]
["●","Check Direct Non-Labour",null,null,"●","●","●","●","●"]
["●","Check Labour Costs",null,null,"●","●","●","●","●"]
["●","Check Indirect Non-Labour Costs",null,null,"●","●","●","●","●"]
[]
[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","-   ",1939.3,1830.8,97.5," -   ",3867.6]
[null,"Sub-Total","Real $2023","$Million","-   ",1939.3,1830.8,97.5," -   ",3867.6]
[]
[null,"Labour Costs"]
[null,"Labour","Real $2023","$Million",31.1,69.5,71.599999999999994,32.4," -   ",204.7]
[null,"Labour Escalation","Real $2023","$Million",0.1,1.2,2.1,1.1000000000000001," -   ",4.4000000000000004]
[null,"Sub-Total","Real $2023","$Million",31.3,70.599999999999994,73.7,33.5," -   ",209.1]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Non-Labour","Real $2023","$Million",11.5,89.7,85.9,15.3," -   ",202.5]
[null,"Sub-Total","Real $2023","$Million",11.5,89.7,85.9,15.3," -   ",202.5]
[]
[null,"Total"]
[null,"Labour","Real $2023","$Million",31.1,69.5,71.599999999999994,32.4," -   ",204.7]
[null,"Labour Escalation","Real $2023","$Million",0.1,1.2,2.1,1.1000000000000001," -   ",4.4000000000000004]
[null,"Non-Labour","Real $2023","$Million",11.5,2029,1916.7,112.8," -   ",4070]
[null,"Total","Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004]
[]
["●","Check Direct Non-Labour",null,null,"●","●","●","●","●"]
["●","Check Labour Costs",null,null,"●","●","●","●","●"]
["●","Check Indirect Non-Labour Costs",null,null,"●","●","●","●","●"]
[]
[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","-   ",150.80000000000001,137.19999999999999,6.9," -   ",294.8,null,null,"← c-i-c"]
[null,"Environmental Offsets","Real $2023","$Million","-   ",10.4,10," -   "," -   ",20.3]
[null,"CSE","Real $2023","$Million","-   ",153.9,140.1,7.3," -   ",301.3]
[null,"Enviro Approvals","Real $2023","$Million","-   ",68.3,57.4,1.7," -   ",127.3]
[null,"Land","Real $2023","$Million","-   ",35.200000000000003,15.1,0.5," -   ",50.8]
[null,"Controls","Real $2023","$Million","-   ",166.7,159.6,7.7," -   ",334.1]
[null,"Construction","Real $2023","$Million","-   ",208.5,245.5,18.600000000000001," -   ",472.6]
[null,"Design","Real $2023","$Million","-   ",75.099999999999994,76.400000000000006,5.6," -   ",157.1]
[null,"HSE","Real $2023","$Million","-   ",40,38.299999999999997,3," -   ",81.3]
[null,"Project Management","Real $2023","$Million","-   ",16,16.399999999999999,1.4," -   ",33.799999999999997]
[null,"Regulatory","Real $2023","$Million","-   ",6.1,5.8,0.6," -   ",12.4]
[null,"Program","Real $2023","$Million","-   ",121.1,84.8,7.1," -   ",213]
[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","-   ",256.39999999999998,253.5,20.100000000000001," -   ",530]
[null,"Contingency","Real $2023","$Million",null,null,null,null,null,"-   "]
[null,"Sub-Total","Real $2023","$Million","-   ",1939.3,1830.8,97.5," -   ",3867.6]
[]
[null,"Labour Costs"]
[null,"Commercial","Real $2023","$Million",1.6,5.3,4.7,2.2000000000000002," -   ",13.9]
[null,"Environmental Offsets","Real $2023","$Million",0.6,0.9,0.9," -   "," -   ",2.2999999999999998]
[null,"CSE","Real $2023","$Million",2.9,5.5,5,2.4," -   ",15.9]
[null,"Enviro Approvals","Real $2023","$Million","-   ",0.6,0,0," -   ",0.7]
[null,"Land","Real $2023","$Million",1.3,2.9,1.3,0.2," -   ",5.7]
[null,"Controls","Real $2023","$Million",2,5.8,6,2.5," -   ",16.3]
[null,"Construction","Real $2023","$Million",4.8,15,19.100000000000001,8.9," -   ",47.8]
[null,"Design","Real $2023","$Million",3.6,5.0999999999999996,5.6,2.6," -   ",16.899999999999999]
[null,"HSE","Real $2023","$Million",1,2.7,2.7,1.4," -   ",7.7]
[null,"Project Management","Real $2023","$Million",0.2,1,1,0.5," -   ",2.6]
[null,"Regulatory","Real $2023","$Million","-   ",0.5,0.5,0.3," -   ",1.3]
[null,"Program","Real $2023","$Million",3.6,3.8,4.3,2," -   ",13.7]
[null,"Legal","Real $2023","$Million",0.4,0.4,0.4,0.2," -   ",1.5]
[null,"Insurance","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Indirect - Proportion of labour and labour-related costs","Real $2023","$Million",9.4,21.2,22.1,10.1," -   ",62.7]
[null,"Contingency","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Sub-Total","Real $2023","$Million",31.3,70.599999999999994,73.7,33.5," -   ",209.1]
[]
[null,"Indirect Non-Labour Costs "]
[null,"Commercial","Real $2023","$Million","-   ",7.2,7.2,1.2," -   ",15.6]
[null,"Environmental Offsets","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"CSE","Real $2023","$Million","-   ",7.2,7.2,1.2," -   ",15.6]
[null,"Enviro Approvals","Real $2023","$Million","-   ",5,5,0.8," -   ",10.8]
[null,"Land","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Controls","Real $2023","$Million","-   ",8,8,1.3," -   ",17.2]
[null,"Construction","Real $2023","$Million","-   ",2.2999999999999998,2.2999999999999998,0.4," -   ",4.9000000000000004]
[null,"Design","Real $2023","$Million","-   ",1.1000000000000001,1.1000000000000001,0.2," -   ",2.4]
[null,"HSE","Real $2023","$Million","-   ",0.6,0.6,0.1," -   ",1.4]
[null,"Project Management","Real $2023","$Million",0.4,0.4,0.4,0.2," -   ",1.4]
[null,"Regulatory","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Program","Real $2023","$Million",11.2,6.2,3,1.5," -   ",21.9]
[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","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Contingency","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Sub-Total","Real $2023","$Million",11.5,89.7,85.9,15.3," -   ",202.5]
[]
[null,"Total"]
[null,"Commercial","Real $2023","$Million",1.6,163.30000000000001,149.1,10.3," -   ",324.3]
[null,"Environmental Offsets","Real $2023","$Million",0.6,11.2,10.8," -   "," -   ",22.6]
[null,"CSE","Real $2023","$Million",2.9,166.7,152.4,10.9," -   ",332.9]
[null,"Enviro Approvals","Real $2023","$Million","-   ",73.900000000000006,62.4,2.5," -   ",138.80000000000001]
[null,"Land","Real $2023","$Million",1.3,38.200000000000003,16.399999999999999,0.7," -   ",56.5]
[null,"Controls","Real $2023","$Million",2,180.5,173.6,11.6," -   ",367.6]
[null,"Construction","Real $2023","$Million",4.8,225.7,266.89999999999998,27.9," -   ",525.29999999999995]
[null,"Design","Real $2023","$Million",3.6,81.3,83,8.4," -   ",176.4]
[null,"HSE","Real $2023","$Million",1,43.3,41.6,4.5," -   ",90.4]
[null,"Project Management","Real $2023","$Million",0.5,17.399999999999999,17.8,2.1," -   ",37.799999999999997]
[null,"Regulatory","Real $2023","$Million","-   ",6.6,6.3,0.8," -   ",13.7]
[null,"Program","Real $2023","$Million",14.7,131.1,92.2,10.6," -   ",248.6]
[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",9.4,277.60000000000002,275.7,30.1," -   ",592.70000000000005]
[null,"Contingency","Real $2023","$Million","-   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total","Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004]
[]
["●","Check Direct Non-Labour",null,null,"●","●","●","●","●"]
["●","Check Labour Costs",null,null,"●","●","●","●","●"]
["●","Check Indirect Non-Labour Costs",null,null,"●","●","●","●","●"]
[]
[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,"-   "]
[null,"Forecast","Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004]
[null,"Sub-Total","Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004]
[]
["●","Check Total Capex",null,null,"●","●","●","●","●"]
[]
["End"]

{"sheet":"Outputs|Models","index":4,"n_rows":52,"n_cols":14,"rows_kept":52,"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,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[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","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,10]
[null,"Business IT",null,"Real $2023","$Million",0.3,15.3,11.1,3.2," -   ",29.9,null,4]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,8]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,35]
[null,"Land and Easements",null,"Real $2023","$Million",2.2000000000000002,212.9," -   "," -   "," -   ",215.1]
[null,"Synchronous Condensers (2018-23)",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,40]
[null,"Leasehold Land and Property",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,5]
[null,"Biodiversity Offsets",null,"Real $2023","$Million",5.2,252.6,253.6," -   "," -   ",511.3,null,47.677476213839974,"◄ Calculated as the weighted average standard life of other depreciating assets"]
[null,"Buildings - capital works",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,40]
[null,"In-house software",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",null,15]
[null,"[Spare]",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   "]
[null,"Total",null,"Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004]
[]
[null,"As Commissioned",null,"Dollar basis","Units",2024,2025,2026,2027,2028,"Total"]
[null,"Capex",null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[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]
[null,"Business IT",null,"Real $2023","$Million",0.3,15.3,11.1,3.2," -   ",29.9,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"Land and Easements",null,"Real $2023","$Million",2.2000000000000002,212.9," -   "," -   "," -   ",215.1,0]
[null,"Synchronous Condensers (2018-23)",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"Leasehold Land and Property",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"Biodiversity Offsets",null,"Real $2023","$Million",5.2,252.6,253.6," -   "," -   ",511.3,0]
[null,"Buildings - capital works",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"In-house software",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"[Spare]",null,"Real $2023","$Million"," -   "," -   "," -   "," -   "," -   "," -   ",0]
[null,"Total",null,"Real $2023","$Million",42.8,2099.6,1990.4,146.30000000000001," -   ",4279.1000000000004,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"]