{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Index","Notes & Assumptions","Inputs","Calculations","Outputs|Models","Outputs|Tables","Outputs|RIN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":143,"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":21,"n_cols":11,"rows_kept":21,"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 | Waratah Super Battery - Capex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid"]
[null,"Notes & Assumptions",null,"Calculations",null,{"$f":"'Outputs|Models'!$A$1","v":"Outputs | Models"},null,null,"Revision","2023-06-30"]
[null,"Inputs",null,null,null,{"$f":"'Outputs|Tables'!$A$1","v":"Outputs | Tables"},null,null,"Status","Regulatory proposal"]
[null,null,null,null,null,{"$f":"'Outputs|RIN'!$A$1","v":"Outputs | RIN"}]
[]
[]
[null,"Model Checks",null,null,null,null,null,"Instructions"]
[]
[null,"Worksheet",null,null,null,null,null,null,"Input Sheets"]
[null,null,null,null,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!A3:A209)","v":0},null,null,null,null,"Historical / Not applicable"]
[null,{"$f":"F7","v":"Outputs | Models"},null,{"$f":"SUM('Outputs|Models'!A2:A96)","v":0},null,null,null,null,"Cells not marked as inputs should not be modified."]
[null,{"$f":"F8","v":"Outputs | Tables"},null,{"$f":"SUM('Outputs|Tables'!A2:A101)","v":0}]
[null,{"$f":"F9","v":"Outputs | RIN"},null,{"$f":"SUM('Outputs|RIN'!A2:A113)","v":0}]
[]
[null,"Total Error Check",null,{"$f":"IF(SUM(D15:D19)=0,0,1)","v":0}]

{"sheet":"Notes & Assumptions","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Assumptions & Notes"]
[]
[null,null,null,null,"User inputs in cells coloured like this"]
[null,null,"*",null,"1.     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,"2.     Escalation is treated as follows:"]
[null,null,null,null,"a.    CPI escalation and Labour escalation are treated separately. "]
[]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2023-06-30","v1.1",null,null,"Initial model development"]

{"sheet":"Inputs","index":2,"n_rows":213,"n_cols":33,"rows_kept":213,"cut":false,"hidden":false,"merged":[[5,1,5,2],[18,0,18,2],[12,0,12,2],[35,0,35,2],[35,7,35,8],[24,0,24,2],[151,0,151,2],[61,0,61,2],[119,0,119,2],[88,4,88,5],[88,0,88,2]]}
["Inputs"]
["AER amendments"]
[]
["Output Reporting Format and Year"]
["Real"]
[2024]
[]
[{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2024"}]
[]
["Inflation and Labour Escalation"]
[]
[]
["Forecasts",null,null,null,null,null,null,null,null,null,"Rates"]
["Item","Source","Units",null,null,null,null,null,null,null,{"$f":"K20","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Actual / Forecast Inflation ","ABS June to June / RBA Forecast","%",null,null,null,null,null,null,null,-3.4843205574912606E-3,3.8461538461538325E-2,6.1447811447811418E-2,6.3E-2,3.5999999999999997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-2,"◄ Actual June year on year inflation used for 2019 to 2022. Forecast inflation for 2023 to 2029 as per Regulatory Proposal, updated for RBAs May 2023 MPS."]
["Real labour escalation","AER Final Determination / Transgrid proposal","%",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,{"$f":"AVERAGE(O16:S16)","v":7.1734897799806269E-3},"Note: Based on Final Decision values applied to both the opex and capex models with a placeholder value for 2028-29"]
[]
[]
["Cumulative Factors",null,null,null,null,null,null,null,null,null,"Cumulative factors"]
["Item","Source","Units",null,null,null,null,null,null,{"$f":"K20-1","v":2019},2020,{"$f":"K20+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Nominal"]
["Inflation based to 2019","Calculated","Factor",null,null,null,null,null,null,1,{"$f":"J21*(1+K15)","v":0.99651567944250874},1.0348432055749128,1.0984320557491287,1.1676332752613239,1.2096680731707317,1.2429321056600837,1.2771108484588121,1.3122294547094393,1.3483137692276574,1.385390347522288]
["Labour based to 2023","Calculated","Factor",null,null,null,null,null,null,1,{"$f":"J22*(1+K16)","v":1},1,1,1,1.0039046564755527,1.0170321981937565,1.0287752983851002,1.0332303661805189,1.0363397834252435,1.0437739562702317]
["Real 2023 to Real 2024","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"$O$21/$N$21","v":1.036},{"$f":"$O$21/$N$21","v":1.036},1.036,1.036,1.036,1.036,1.036,1.036,1.036,1.036]
[]
["Indexation",null,null,null,null,null,null,null,null,null,"Indexation"]
["Item","Source","Units",null,null,null,null,null,null,null,{"$f":"K20","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029]
["Real 2024 End Period to Nominal Mid Period","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"K21/$O$21/(1+K$15)^0.5","v":0.82523160001556595},0.83948535860435891,0.8813687684581063,0.93621072572939579,0.98247186486482418,1.0136559965373035,1.0415299949916583,1.0701704860159655,1.0995985469903056,1.1298358348906596]
["Real 2019 End Period to Nominal Mid Period","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"K27*$O$21","v":0.99825631951042959},{"$f":"L27*$O$21","v":1.0154986361979756},1.0661636598935782,1.1325042246748505,1.1884648477154873,1.2261872961892377,1.2599055821910812,1.2945510697831184,1.3301492555990992,1.3667263373914291]
[]
[]
["Capital Expenditure"]
[]
["Direct Non-Labour Costs"]
[]
[]
["Direct Non-Labour Costs | By Category",null,null,null,"Conversion",null,null,"Expenditure",null,null,"Spend Profile Assumption",null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"$ Spend Profile (June \"&$F$39&\" dollars)\"","v":"$ Spend Profile (June 2024 dollars)"}]
["Category","Source","Units",null,"Dollar Year From","Dollar Year To",null,"Value","Capex Category",null,{"$f":"$K$20","v":2020},{"$f":"K37+1","v":2021},2022,2023,2024,2025,2026,{"$f":"Q37+1","v":2027},{"$f":"R37+1","v":2028},{"$f":"S37+1","v":2029},"Total",null,{"$f":"K37","v":2020},{"$f":"L37","v":2021},{"$f":"M37","v":2022},2023,2024,2025,2026,2027,2028,2029,{"$f":"U37","v":"Total"}]
["Augmentation works - Design and Construction"]
["Transmission lines uprating - Lines 39, 3L/4 & 5 - Transmission Towers","Project Team Input","$Millions",null,"Nominal",{"$f":"Report_Year","v":2024},null,6.6159635799999998,"Transmission Lines - Transmission Towers",null,null,null,null,null,0.34458304318537375,0.65541695681462619,null,null,null,null,{"$f":"SUM(K39:T39)","v":1},null,{"$f":"IFERROR($H39*K39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*L39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*M39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*N39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*O39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":2.2736342652041057},{"$f":"IFERROR($H39*P39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":4.3245843940378386},{"$f":"IFERROR($H39*Q39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*R39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*S39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"IFERROR($H39*T39\n*INDEX($K$21:$T$21,,MATCH($F39,Years,0))\n/IF($E39=\"Nominal\",1/SUMPRODUCT($K39:$T39,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E39,Years,0))),0)","v":0},{"$f":"SUM(W39:AF39)","v":6.5982186592419438}]
["Transmission lines uprating - Lines 39, 3L/4 & 5 - Transmission tower support structures","Project Team Input","$Millions",null,"Nominal",{"$f":"$F$39","v":2024},null,63.32382922,"Transmission Lines - Transmission tower support structures",null,null,null,null,null,0.30793884413170047,0.69206115586829953,null,null,null,null,{"$f":"SUM(K40:T40)","v":1},null,{"$f":"IFERROR($H40*K40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*L40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*M40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*N40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*O40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":19.425190627923758},{"$f":"IFERROR($H40*P40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":43.656135414905435},{"$f":"IFERROR($H40*Q40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*R40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*S40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"IFERROR($H40*T40\n*INDEX($K$21:$T$21,,MATCH($F40,Years,0))\n/IF($E40=\"Nominal\",1/SUMPRODUCT($K40:$T40,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E40,Years,0))),0)","v":0},{"$f":"SUM(W40:AF40)","v":63.08132604282919}]
["Substation uprating - Substation switchbays","Project Team Input","$Millions",null,"Nominal",{"$f":"$F$39","v":2024},null,107.98204152999999,"Substations - Substation switchbays",null,null,null,null,null,0.32090588869236025,0.57739722287689921,0.10169688843074054,null,null,null,{"$f":"SUM(K41:T41)","v":1},null,{"$f":"IFERROR($H41*K41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*L41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*M41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*N41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*O41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":34.440399479539515},{"$f":"IFERROR($H41*P41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":61.967672501394453},{"$f":"IFERROR($H41*Q41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":10.9143570959477},{"$f":"IFERROR($H41*R41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*S41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"IFERROR($H41*T41\n*INDEX($K$21:$T$21,,MATCH($F41,Years,0))\n/IF($E41=\"Nominal\",1/SUMPRODUCT($K41:$T41,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E41,Years,0))),0)","v":0},{"$f":"SUM(W41:AF41)","v":107.32242907688166}]
["Secondary systems uprating","Project Team Input","$Millions",null,"Nominal",{"$f":"$F$39","v":2024},null,0,"Secondary Systems - Scada, network control and protection systems",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K42:T42)","v":0},null,{"$f":"IFERROR($H42*K42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*L42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*M42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*N42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*O42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*P42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*Q42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*R42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*S42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"IFERROR($H42*T42\n*INDEX($K$21:$T$21,,MATCH($F42,Years,0))\n/IF($E42=\"Nominal\",1/SUMPRODUCT($K42:$T42,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E42,Years,0))),0)","v":0},{"$f":"SUM(W42:AF42)","v":0}]
["Secondary systems uprating","Project Team Input","$Millions",null,"Nominal",{"$f":"$F$39","v":2024},null,0,"Communications (short life) - Scada, network control and protection systems",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K43:T43)","v":0},null,{"$f":"IFERROR($H43*K43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*L43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*M43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*N43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*O43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*P43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*Q43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*R43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*S43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"IFERROR($H43*T43\n*INDEX($K$21:$T$21,,MATCH($F43,Years,0))\n/IF($E43=\"Nominal\",1/SUMPRODUCT($K43:$T43,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E43,Years,0))),0)","v":0},{"$f":"SUM(W43:AF43)","v":0}]
[]
["SIPS - Design and Construction"]
["Design, equipment procurement and installation works for SIPS","Project Team Input","$Millions",null,2023,{"$f":"$F$39","v":2024},null,2.0212312000039998,"SIPS Control",null,null,null,null,0.19119883489985476,0.77812679197554813,3.0674373124597181E-2,null,null,null,null,{"$f":"SUM(K46:T46)","v":1},null,{"$f":"IFERROR($H46*K46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*L46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*M46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*N46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0.40036950432214413},{"$f":"IFERROR($H46*O46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":1.629394018882},{"$f":"IFERROR($H46*P46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":6.4231999999999997E-2},{"$f":"IFERROR($H46*Q46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*R46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*S46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"IFERROR($H46*T46\n*INDEX($K$21:$T$21,,MATCH($F46,Years,0))\n/IF($E46=\"Nominal\",1/SUMPRODUCT($K46:$T46,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E46,Years,0))),0)","v":0},{"$f":"SUM(W46:AF46)","v":2.0939955232041441}]
["Design, equipment procurement and installation works for SIPS","Project Team Input","$Millions",null,2023,{"$f":"$F$39","v":2024},null,1.6188522400000001,"SIPS Control",null,null,null,null,9.8780414943861708E-2,0.90121958505613831,0,null,null,null,null,{"$f":"SUM(K47:T47)","v":1},null,{"$f":"IFERROR($H47*K47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*L47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*M47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*N47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0.16566768825600003},{"$f":"IFERROR($H47*O47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":1.5114632323840003},{"$f":"IFERROR($H47*P47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*Q47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*R47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*S47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"IFERROR($H47*T47\n*INDEX($K$21:$T$21,,MATCH($F47,Years,0))\n/IF($E47=\"Nominal\",1/SUMPRODUCT($K47:$T47,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E47,Years,0))),0)","v":0},{"$f":"SUM(W47:AF47)","v":1.6771309206400002}]
[]
["SIPS | Future PG Rounds"]
[{"$f":"A46&\" - Future paired generation\"","v":"Design, equipment procurement and installation works for SIPS - Future paired generation"},"Project Team Input","$Millions",null,2023,{"$f":"$F$39","v":2024},null,0,"SIPS Control",null,null,null,null,null,0.4,0.6,null,null,null,null,{"$f":"SUM(K50:T50)","v":1},null,{"$f":"IFERROR($H50*K50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*L50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*M50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*N50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*O50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*P50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*Q50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*R50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*S50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"IFERROR($H50*T50\n*INDEX($K$21:$T$21,,MATCH($F50,Years,0))\n/IF($E50=\"Nominal\",1/SUMPRODUCT($K50:$T50,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E50,Years,0))),0)","v":0},{"$f":"SUM(W50:AF50)","v":0}]
[{"$f":"A47&\" - Future paired generation\"","v":"Design, equipment procurement and installation works for SIPS - Future paired generation"},"Project Team Input","$Millions",null,2023,{"$f":"$F$39","v":2024},null,0,"SIPS Control",null,null,null,null,null,0.4,0.6,null,null,null,null,{"$f":"SUM(K51:T51)","v":1},null,{"$f":"IFERROR($H51*K51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*L51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*M51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*N51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*O51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*P51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*Q51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*R51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*S51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"IFERROR($H51*T51\n*INDEX($K$21:$T$21,,MATCH($F51,Years,0))\n/IF($E51=\"Nominal\",1/SUMPRODUCT($K51:$T51,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E51,Years,0))),0)","v":0},{"$f":"SUM(W51:AF51)","v":0}]
[]
["Other construction costs"]
[{"$f":"A39","v":"Transmission lines uprating - Lines 39, 3L/4 & 5 - Transmission Towers"},"Project Team Input","$Millions",null,2023,{"$f":"$F$39","v":2024},null,0.01,{"$f":"I39","v":"Transmission Lines - Transmission Towers"},null,null,null,null,null,null,1,null,null,null,null,{"$f":"SUM(K54:T54)","v":1},null,{"$f":"IFERROR($H54*K54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*L54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*M54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*N54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*O54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*P54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":1.0360000000000001E-2},{"$f":"IFERROR($H54*Q54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*R54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*S54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"IFERROR($H54*T54\n*INDEX($K$21:$T$21,,MATCH($F54,Years,0))\n/IF($E54=\"Nominal\",1/SUMPRODUCT($K54:$T54,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E54,Years,0))),0)","v":0},{"$f":"SUM(W54:AF54)","v":1.0360000000000001E-2}]
[{"$f":"A40","v":"Transmission lines uprating - Lines 39, 3L/4 & 5 - Transmission tower support structures"},"Project Team Input","$Millions",null,{"$f":"E54","v":2023},{"$f":"$F$39","v":2024},null,6.8959000000000006E-2,{"$f":"I40","v":"Transmission Lines - Transmission tower support structures"},null,null,null,null,null,null,1,null,null,null,null,{"$f":"SUM(K55:T55)","v":1},null,{"$f":"IFERROR($H55*K55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*L55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*M55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*N55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*O55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*P55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":7.1441524000000006E-2},{"$f":"IFERROR($H55*Q55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*R55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*S55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"IFERROR($H55*T55\n*INDEX($K$21:$T$21,,MATCH($F55,Years,0))\n/IF($E55=\"Nominal\",1/SUMPRODUCT($K55:$T55,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E55,Years,0))),0)","v":0},{"$f":"SUM(W55:AF55)","v":7.1441524000000006E-2}]
[{"$f":"A41","v":"Substation uprating - Substation switchbays"},"Project Team Input","$Millions",null,{"$f":"E55","v":2023},{"$f":"$F$39","v":2024},null,1.0623100000000001,{"$f":"I41","v":"Substations - Substation switchbays"},null,null,null,null,null,null,0.47067240259434628,0.52932759740565372,null,null,null,{"$f":"SUM(K56:T56)","v":1},null,{"$f":"IFERROR($H56*K56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*L56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*M56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*N56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*O56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*P56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0.51800000000000002},{"$f":"IFERROR($H56*Q56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0.58255316000000024},{"$f":"IFERROR($H56*R56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*S56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"IFERROR($H56*T56\n*INDEX($K$21:$T$21,,MATCH($F56,Years,0))\n/IF($E56=\"Nominal\",1/SUMPRODUCT($K56:$T56,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E56,Years,0))),0)","v":0},{"$f":"SUM(W56:AF56)","v":1.1005531600000003}]
[{"$f":"A42","v":"Secondary systems uprating"},"Project Team Input","$Millions",null,{"$f":"E56","v":2023},{"$f":"$F$39","v":2024},null,1,"SIPS Control",null,null,null,null,null,null,1,null,null,null,null,{"$f":"SUM(K57:T57)","v":1},null,{"$f":"IFERROR($H57*K57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*L57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*M57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*N57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*O57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*P57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":1.036},{"$f":"IFERROR($H57*Q57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*R57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*S57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"IFERROR($H57*T57\n*INDEX($K$21:$T$21,,MATCH($F57,Years,0))\n/IF($E57=\"Nominal\",1/SUMPRODUCT($K57:$T57,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E57,Years,0))),0)","v":0},{"$f":"SUM(W57:AF57)","v":1.036}]
[{"$f":"A43","v":"Secondary systems uprating"},"Project Team Input","$Millions",null,{"$f":"E57","v":2023},{"$f":"$F$39","v":2024},null,0.22500000000000001,"SIPS Control",null,null,null,null,null,null,1,null,null,null,null,{"$f":"SUM(K58:T58)","v":1},null,{"$f":"IFERROR($H58*K58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*L58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*M58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*N58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*O58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*P58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0.23310000000000003},{"$f":"IFERROR($H58*Q58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*R58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*S58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"IFERROR($H58*T58\n*INDEX($K$21:$T$21,,MATCH($F58,Years,0))\n/IF($E58=\"Nominal\",1/SUMPRODUCT($K58:$T58,1/$K$28:$T$28),INDEX($K$21:$T$21,,MATCH($E58,Years,0))),0)","v":0},{"$f":"SUM(W58:AF58)","v":0.23310000000000003}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H39:H58)","v":183.92818677000398},"◄ Notional sum with various dollar basis for cross check only",null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W39:W58)","v":0},0,0,0.56603719257814422,59.280081623933384,111.88152583433774,11.4969102559477,0,0,0,183.22455490679693]
[]
["Direct Non-Labour Costs | By Capex Category",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Expenditure (June \"&F39&\" dollars)\"","v":"Expenditure (June 2024 dollars)"}]
["Category","Source","Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K$37","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[{"$f":"A160","v":"Transmission Lines - Transmission Towers"},"Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A64))","v":2.2736342652041057},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A64))","v":4.3349443940378389},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A64))","v":0},{"$f":"SUM(W64:AF64)","v":6.6085786592419442}]
["Transmission Lines - Transmission tower support structures","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A65))","v":19.425190627923758},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A65))","v":43.727576938905436},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A65))","v":0},{"$f":"SUM(W65:AF65)","v":63.152767566829198}]
["Transmission Lines - Conductors","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A66))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A66))","v":0},0]
["Transmission Lines - Transmission line life extension","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A67))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A67))","v":0},0]
["Underground cables - Transmission cables","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A68))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A68))","v":0},0]
["Substations - Substation switchbays","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A69))","v":34.440399479539515},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A69))","v":62.485672501394454},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A69))","v":11.4969102559477},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A69))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A69))","v":0},108.42298223688167]
["Substations - Substation power transformers","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A70))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A70))","v":0},0]
["Substations - Substation reactive plant","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A71))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A71))","v":0},0]
["Secondary Systems - Scada, network control and protection systems","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A72))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A72))","v":0},0]
["Communications (short life) - Scada, network control and protection systems","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A73))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A73))","v":0},0]
["SIPS Control","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A74))","v":0.56603719257814422},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A74))","v":3.1408572512660005},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A74))","v":1.3333320000000002},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A74))","v":0},{"$f":"SUM(W74:AF74)","v":5.0402264438441451}]
[{"$f":"A171","v":"Synchronous condensers"},"Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A75))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A75))","v":0},0]
["Other - Leasehold land and property","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A76))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A76))","v":0},0]
["Other - Land and Easements","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A77))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A77))","v":0},0]
["Other - Buildings capital works","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A78))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A78))","v":0},0]
["Non-network - Business IT","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A79))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A79))","v":0},0]
["Non-network - Minor Plant, Motor Vehicles & Mobile Plant","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A80))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A80))","v":0},0]
["Non-network - Buildings","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A81))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A81))","v":0},0]
["Non-network - In-house software","Calculated","$Millions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W$39:W$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(X$39:X$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(Y$39:Y$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(Z$39:Z$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AA$39:AA$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AB$39:AB$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AC$39:AC$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AD$39:AD$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AE$39:AE$58*($I$39:$I$58=$A82))","v":0},{"$f":"SUM(AF$39:AF$58*($I$39:$I$58=$A82))","v":0},0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(W64:W82)","v":0},0,0,0.56603719257814422,59.280081623933377,111.88152583433772,{"$f":"SUM(AC64:AC82)","v":11.4969102559477},{"$f":"SUM(AD64:AD82)","v":0},{"$f":"SUM(AE64:AE82)","v":0},{"$f":"SUM(AF64:AF82)","v":0},183.22455490679695]
[]
[]
["Labour Costs"]
[]
["Labour Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,{"$f":"\"Expenditure (June \"&E91&\" dollars, unescalated)\"","v":"Expenditure (June 2023 dollars, unescalated)"}]
["Component","Source","Units",null,"Dollar Yr","Escalation Yr",null,null,null,null,{"$f":"K20","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
["Actuals (to 31 March 2023)",null,null,null,2023,2023]
["Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - SIPS Control Implementation","Transgrid","$Millions",null,null,null,null,"SIPS Control Implementation",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Other Support & Corporate Roles","Transgrid","$Millions",null,null,null,null,"Other Support & Corporate Roles",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Transaction Procurement Support","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Regulatory Approvals","Transgrid","$Millions",null,null,null,null,"Regulatory Approvals",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Community and Stakeholder Engagement","Transgrid","$Millions",null,null,null,null,"Community and Stakeholder Engagement",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Environment","Transgrid","$Millions",null,null,null,null,"Environment",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Labour - Procurement","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Forecasts (from  1 April 2023)"]
[{"$f":"A92","v":"Labour - Project Management"},"Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Labour - SIPS Control Implementation","Transgrid","$Millions",null,null,null,null,"SIPS Control Implementation",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A94","v":"Labour - Other Support & Corporate Roles"},"Transgrid","$Millions",null,null,null,null,"Other Support & Corporate Roles",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A95","v":"Labour - Transaction Procurement Support"},"Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A96","v":"Labour - Regulatory Approvals"},"Transgrid","$Millions",null,null,null,null,"Regulatory Approvals",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A97","v":"Labour - Community and Stakeholder Engagement"},"Transgrid","$Millions",null,null,null,null,"Community and Stakeholder Engagement",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A98","v":"Labour - Environment"},"Transgrid","$Millions",null,null,null,null,"Environment",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Labour - Procurement","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Total"]
["Labour","Transgrid","$Millions",null,null,null,null,null,null,null,{"$f":"SUM(K92:K99,K101:K108)","v":0},{"$f":"SUM(L92:L99,L101:L108)","v":0},{"$f":"SUM(M92:M99,M101:M108)","v":0},4.7489826282025822,19.460410571250016,12.308247039458504,1.0909390977656426,0,0,0,37.60857933667674]
[]
["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,"Total",{"$f":"K110","v":0},0,0,4.7489826282025822,19.460410571250016,12.308247039458504,1.0909390977656426,0,0,0,{"$f":"SUM(K112:T112)","v":37.60857933667674}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Actuals (\"&$A$8&\")\"","v":"Actuals (Real $2024)"},{"$f":"SUM(K92:K99)*K$23","v":0},{"$f":"SUM(L92:L99)*L$23","v":0},{"$f":"SUM(M92:M99)*M$23","v":0},1.519620622828,0,0,0,0,0,0,1.519620622828]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Forecast (\"&$A$8&\")\"","v":"Forecast (Real $2024)"},{"$f":"SUM(K101:K108)*K$23","v":0},{"$f":"SUM(L101:L108)*L$23","v":0},{"$f":"SUM(M101:M108)*M$23","v":0},3.4003253799898756,20.160985351815018,12.75134393287901,1.1302129052852057,0,0,0,37.44286756996911]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Total (\"&$A$8&\")\"","v":"Total (Real $2024)"},{"$f":"K112*K$23","v":0},0,0,4.9199460028178752,20.160985351815018,12.75134393287901,1.1302129052852057,0,0,0,{"$f":"SUM(K115:T115)","v":38.96248819279711}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Total including escalation (\"&$A$8&\")\"","v":"Total including escalation (Real $2024)"},{"$f":"K115*K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"L115*L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"M115*M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"N115*N$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":4.9199460028178752},{"$f":"O115*O$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":20.239707073822505},{"$f":"P115*P$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":12.968527349980558},{"$f":"Q115*Q$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":1.1627351188734785},{"$f":"R115*R$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"S115*S$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"T115*T$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))","v":0},{"$f":"SUM(K116:T116)","v":39.290915545494421}]
[]
["Indirect Non-Labour Costs"]
[]
["Indirect Costs",null,null,null,"Conversion",null,null,"Mapping",null,null,{"$f":"\"Expenditure (June \"&E122&\" dollars, unescalated)\"","v":"Expenditure (June 2023 dollars, unescalated)"}]
["Component","Source","Units",null,"Dollar Year",null,null,null,null,null,{"$f":"K$20","v":2020},{"$f":"L$20","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[{"$f":"A91","v":"Actuals (to 31 March 2023)"},null,null,null,2023]
["Non Labour - Proportion of labour and labour-related costs","Transgrid","$Millions",null,null,null,null,"Other Support & Corporate Roles",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Project Management","Transgrid","$Millions",null,null,null,null,"Project Management",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - SIPS Control Implementation","Transgrid","$Millions",null,null,null,null,"SIPS Control Implementation",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Other Support & Corporate Roles","Transgrid","$Millions",null,null,null,null,"Other Support & Corporate Roles",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Regulatory Approvals and Other Support Costs","Transgrid","$Millions",null,null,null,null,"Regulatory Approvals",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Community and Stakeholder Engagement","Transgrid","$Millions",null,null,null,null,"Community and Stakeholder Engagement",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Land and Environment","Transgrid","$Millions",null,null,null,null,"Environment",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Procurement","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
["Non Labour - Transaction Procurement Support","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c",null,null,null,null,null,null,"c-i-c"]
[{"$f":"A100","v":"Forecasts (from  1 April 2023)"}]
[{"$f":"A123","v":"Non Labour - Proportion of labour and labour-related costs"},"Transgrid","$Millions",null,null,null,null,{"$f":"H123","v":"Other Support & Corporate Roles"},null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A124","v":"Non Labour - Project Management"},"Transgrid","$Millions",null,null,null,null,{"$f":"H124","v":"Project Management"},null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - SIPS Control Implementation","Transgrid","$Millions",null,null,null,null,"SIPS Control Implementation",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A126","v":"Non Labour - Other Support & Corporate Roles"},"Transgrid","$Millions",null,null,null,null,"Other Support & Corporate Roles",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - Regulatory Approvals and Other Support Costs","Transgrid","$Millions",null,null,null,null,"Regulatory Approvals",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - Community and Stakeholder Engagement","Transgrid","$Millions",null,null,null,null,"Community and Stakeholder Engagement",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - Land and Environment","Transgrid","$Millions",null,null,null,null,"Environment",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - Procurement","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
["Non Labour - Transaction Procurement Support","Transgrid","$Millions",null,null,null,null,"Transaction Procurement Support",null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,"c-i-c"]
[{"$f":"A109","v":"Total"}]
["Non-Labour","Transgrid","$Millions",null,null,null,null,null,null,null,{"$f":"SUM(K123:K131,K133:K141)","v":0},{"$f":"SUM(L123:L131,L133:L141)","v":0},{"$f":"SUM(M123:M131,M133:M141)","v":0},5.7395718392296793,12.608496639107152,6.1646144169107888,0.58609075761384699,0,0,0,25.098773652861464]
[]
["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,"Total",{"$f":"K143","v":0},{"$f":"L143","v":0},0,5.7395718392296793,12.608496639107152,6.1646144169107888,0.58609075761384699,0,0,0,{"$f":"SUM(K145:T145)","v":25.098773652861468}]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Actuals (\"&$A$8&\")\"","v":"Actuals (Real $2024)"},{"$f":"SUM(K123:K131)*K$23","v":0},{"$f":"SUM(L123:L131)*L$23","v":0},{"$f":"SUM(M123:M131)*M$23","v":0},2.8012405937320004,0,0,0,0,0,0,2.8012405937320004]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Forecast (\"&$A$8&\")\"","v":"Forecast (Real $2024)"},{"$f":"SUM(K133:K141)*K$23","v":0},{"$f":"SUM(L133:L141)*L$23","v":0},{"$f":"SUM(M133:M141)*M$23","v":0},3.1449558317099466,13.062402518115009,6.3865405359195773,0.60719002488794549,0,0,0,23.201088910632482]
[null,null,null,null,null,null,null,null,null,{"$f":"\"Total (\"&$A$8&\")\"","v":"Total (Real $2024)"},{"$f":"K145*K$23","v":0},{"$f":"L145*L$23","v":0},0,5.9461964254419479,13.062402518115009,6.3865405359195773,0.60719002488794549,0,0,0,{"$f":"SUM(K148:T148)","v":26.002329504364479}]
[]
["Equity Raising Costs (Used in Output|Tables and Charts)"]
[]
["Equity Raising Costs",null,null,null,"Conversion",null,null,null,null,null,{"$f":"\"Expenditure (June \"&E154&\" dollars, unescalated)\"","v":"Expenditure (June 2024 dollars, unescalated)"}]
["Component","Source","Units",null,"Dollar Year",null,null,null,null,null,{"$f":"K$20","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
["Equity Raising Cost Allowance From PTRM","Transgrid","$Millions",null,{"$f":"$O$20","v":2024},null,null,null,null,null,null,null,null,null,null,0.67652615713149145,0,0,0,0,{"$f":"SUM(K154:T154)","v":0.67652615713149145}]
[]
["Lookup tables and mapping"]
[]
["Capex input template",{"$f":"$A$180","v":"PTRM and RFM models"},"Regulatory Information Notice"]
["Categories",{"$f":"$A$181","v":"RAB Asset Classes"},"Network and Non Network Categories"]
["Transmission Lines - Transmission Towers",{"$f":"$A$182","v":"Transmission Lines "},{"$f":"A199","v":"Transmission Towers"}]
["Transmission Lines - Transmission tower support structures",{"$f":"$A$182","v":"Transmission Lines "},{"$f":"A200","v":"Transmission tower support structures"}]
["Transmission Lines - Conductors",{"$f":"$A$182","v":"Transmission Lines "},{"$f":"A201","v":"Conductors"}]
["Transmission Lines - Transmission line life extension",{"$f":"$A$190","v":"Transmission Line Life Extension "},{"$f":"A202","v":"Transmission cables"}]
["Underground cables - Transmission cables",{"$f":"$A$183","v":"Underground Cables "},{"$f":"A202","v":"Transmission cables"}]
["Substations - Substation switchbays",{"$f":"$A$184","v":"Substations  "},{"$f":"A203","v":"Substation switchbays"}]
["Substations - Substation power transformers",{"$f":"$A$184","v":"Substations  "},{"$f":"A204","v":"Substation power transformers"}]
["Substations - Substation reactive plant",{"$f":"$A$184","v":"Substations  "},{"$f":"A205","v":"Substation reactive plant"}]
["Secondary Systems - Scada, network control and protection systems",{"$f":"$A$185","v":"Secondary Systems "},{"$f":"A206","v":"Scada, network control and protection systems"}]
["Communications (short life) - Scada, network control and protection systems",{"$f":"$A$186","v":"Communications (short life) "},{"$f":"$A$206","v":"Scada, network control and protection systems"}]
["SIPS Control",{"$f":"$A$187","v":"SIPS Control"},{"$f":"$A$206","v":"Scada, network control and protection systems"}]
["Synchronous condensers",{"$f":"A192","v":"Synchronous Condensers "},{"$f":"$A$207","v":"Other network"}]
["Other - Leasehold land and property",{"$f":"A193","v":"Leasehold Land and Property "},{"$f":"A210","v":"Buildings and Property"}]
["Other - Land and Easements",{"$f":"A191","v":"Land and Easements  "},{"$f":"A211","v":"Other non network"}]
["Other - Buildings capital works",{"$f":"A194","v":"Buildings - capital works "},{"$f":"A210","v":"Buildings and Property"}]
["Non-network - Business IT",{"$f":"A188","v":"Business IT "},{"$f":"A208","v":"IT & Communications"}]
["Non-network - Minor Plant, Motor Vehicles & Mobile Plant",{"$f":"A189","v":"Minor Plant, Motor Vehicles & Mobile Plant "},{"$f":"A211","v":"Other non network"}]
["Non-network - Buildings",{"$f":"A194","v":"Buildings - capital works "},{"$f":"A210","v":"Buildings and Property"}]
["Non-network - In-house software",{"$f":"A195","v":"In-house software "},{"$f":"A208","v":"IT & Communications"}]
[]
["PTRM and RFM models"]
["RAB Asset Classes"]
["Transmission Lines "]
["Underground Cables "]
["Substations  "]
["Secondary Systems "]
["Communications (short life) "]
["SIPS Control"]
["Business IT "]
["Minor Plant, Motor Vehicles & Mobile Plant "]
["Transmission Line Life Extension "]
["Land and Easements  "]
["Synchronous Condensers "]
["Leasehold Land and Property "]
["Buildings - capital works "]
["In-house software "]
[]
["Regulatory Information Notice"]
["Network and Non Network Categories"]
["Transmission Towers"]
["Transmission tower support structures"]
["Conductors"]
["Transmission cables"]
["Substation switchbays"]
["Substation power transformers"]
["Substation reactive plant"]
["Scada, network control and protection systems"]
["Other network"]
["IT & Communications"]
["Motor Vehicles"]
["Buildings and Property"]
["Other non network"]
[]
["End"]

{"sheet":"Calculations","index":3,"n_rows":211,"n_cols":20,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
["Calculations",null,null,null,{"$f":"Inputs!$A$8","v":"Real $2024"}]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Capex Category",null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"Mapping","Mapping"]
[null,"Capex category","Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"Inputs!L$20","v":2021},{"$f":"Inputs!M$20","v":2022},{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},null,null,"RAB Asset Class","RIN Network and Non network"]
[]
[null,"Direct Non-Labour Costs"]
[null,{"$f":"Inputs!$A$160","v":"Transmission Lines - Transmission Towers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,2.2736342652041057,4.3349443940378389,0,0,0,0,{"$f":"SUM(E7:N7)","v":6.6085786592419442},null,{"$f":"Inputs!B160","v":"Transmission Lines "},{"$f":"Inputs!C160","v":"Transmission Towers"}]
[null,{"$f":"Inputs!$A$161","v":"Transmission Lines - Transmission tower support structures"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,19.425190627923758,43.727576938905436,0,0,0,0,{"$f":"SUM(E8:N8)","v":63.152767566829198},null,{"$f":"Inputs!B161","v":"Transmission Lines "},{"$f":"Inputs!C161","v":"Transmission tower support structures"}]
[null,{"$f":"Inputs!$A$162","v":"Transmission Lines - Conductors"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E9:N9)","v":0},null,{"$f":"Inputs!B162","v":"Transmission Lines "},{"$f":"Inputs!C162","v":"Conductors"}]
[null,{"$f":"Inputs!$A$163","v":"Transmission Lines - Transmission line life extension"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E10:N10)","v":0},null,{"$f":"Inputs!B163","v":"Transmission Line Life Extension "},{"$f":"Inputs!C163","v":"Transmission cables"}]
[null,{"$f":"Inputs!$A$164","v":"Underground cables - Transmission cables"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B164","v":"Underground Cables "},{"$f":"Inputs!C164","v":"Transmission cables"}]
[null,{"$f":"Inputs!$A$165","v":"Substations - Substation switchbays"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,34.440399479539515,62.485672501394454,11.4969102559477,0,0,0,108.42298223688167,null,{"$f":"Inputs!B165","v":"Substations  "},{"$f":"Inputs!C165","v":"Substation switchbays"}]
[null,{"$f":"Inputs!$A$166","v":"Substations - Substation power transformers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B166","v":"Substations  "},{"$f":"Inputs!C166","v":"Substation power transformers"}]
[null,{"$f":"Inputs!$A$167","v":"Substations - Substation reactive plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B167","v":"Substations  "},{"$f":"Inputs!C167","v":"Substation reactive plant"}]
[null,{"$f":"Inputs!$A$168","v":"Secondary Systems - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B168","v":"Secondary Systems "},{"$f":"Inputs!C168","v":"Scada, network control and protection systems"}]
[null,{"$f":"Inputs!$A$169","v":"Communications (short life) - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B169","v":"Communications (short life) "},{"$f":"Inputs!C169","v":"Scada, network control and protection systems"}]
[null,{"$f":"Inputs!$A$170","v":"SIPS Control"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.56603719257814422,3.1408572512660005,1.3333320000000002,0,0,0,0,{"$f":"SUM(E17:N17)","v":5.0402264438441451},null,{"$f":"Inputs!B170","v":"SIPS Control"},{"$f":"Inputs!C170","v":"Scada, network control and protection systems"}]
[null,{"$f":"Inputs!$A$171","v":"Synchronous condensers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B171","v":"Synchronous Condensers "},{"$f":"Inputs!C171","v":"Other network"}]
[null,{"$f":"Inputs!$A$172","v":"Other - Leasehold land and property"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B172","v":"Leasehold Land and Property "},{"$f":"Inputs!C172","v":"Buildings and Property"}]
[null,{"$f":"Inputs!$A$173","v":"Other - Land and Easements"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B173","v":"Land and Easements  "},{"$f":"Inputs!C173","v":"Other non network"}]
[null,{"$f":"Inputs!$A$174","v":"Other - Buildings capital works"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B174","v":"Buildings - capital works "},{"$f":"Inputs!C174","v":"Buildings and Property"}]
[null,{"$f":"Inputs!$A$175","v":"Non-network - Business IT"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B175","v":"Business IT "},{"$f":"Inputs!C175","v":"IT & Communications"}]
[null,{"$f":"Inputs!$A$176","v":"Non-network - Minor Plant, Motor Vehicles & Mobile Plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B176","v":"Minor Plant, Motor Vehicles & Mobile Plant "},{"$f":"Inputs!C176","v":"Other non network"}]
[null,{"$f":"Inputs!$A$177","v":"Non-network - Buildings"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B177","v":"Buildings - capital works "},{"$f":"Inputs!C177","v":"Buildings and Property"}]
[null,{"$f":"Inputs!$A$178","v":"Non-network - In-house software"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"Inputs!B178","v":"In-house software "},{"$f":"Inputs!C178","v":"IT & Communications"}]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E7:E25)","v":0},0,0,0.56603719257814422,59.280081623933377,111.88152583433772,11.4969102559477,0,0,0,183.22455490679695]
[]
[null,"Labour Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"← This value is pro-rated over the escalated capital forecast by year and asset class"]
[null,{"$f":"Inputs!$A$160","v":"Transmission Lines - Transmission Towers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.15228215052708097,0.59284818916423065,0.46468025064812785,0,0,0,0,{"$f":"SUM(E29:N29)","v":1.2098105903394394},null,{"$f":"Q7","v":"Transmission Lines "},"Transmission Towers"]
[null,{"$f":"Inputs!$A$161","v":"Transmission Lines - Transmission tower support structures"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,1.4552356494031335,5.0651018346175247,4.6873361144268708,0,0,0,0,{"$f":"SUM(E30:N30)","v":11.207673598447528},null,"Transmission Lines ","Transmission tower support structures"]
[null,{"$f":"Inputs!$A$162","v":"Transmission Lines - Conductors"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Lines ","Conductors"]
[null,{"$f":"Inputs!$A$163","v":"Transmission Lines - Transmission line life extension"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Line Life Extension ","Transmission cables"]
[null,{"$f":"Inputs!$A$164","v":"Underground cables - Transmission cables"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Underground Cables ","Transmission cables"]
[null,{"$f":"Inputs!$A$165","v":"Substations - Substation switchbays"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,2.4984018126956467,8.980304694565632,6.6980923676437243,1.1627351188734785,0,0,0,19.339533993778481,null,"Substations  ","Substation switchbays"]
[null,{"$f":"Inputs!$A$166","v":"Substations - Substation power transformers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation power transformers"]
[null,{"$f":"Inputs!$A$167","v":"Substations - Substation reactive plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation reactive plant"]
[null,{"$f":"Inputs!$A$168","v":"Secondary Systems - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Secondary Systems ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$169","v":"Communications (short life) - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Communications (short life) ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$170","v":"SIPS Control"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.81402639019201439,5.6014523554751188,1.1184186172618356,0,0,0,0,{"$f":"SUM(E39:N39)","v":7.5338973629289692},null,"SIPS Control","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$171","v":"Synchronous condensers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Synchronous Condensers ","Other network"]
[null,{"$f":"Inputs!$A$172","v":"Other - Leasehold land and property"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Leasehold Land and Property ","Buildings and Property"]
[null,{"$f":"Inputs!$A$173","v":"Other - Land and Easements"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Land and Easements  ","Other non network"]
[null,{"$f":"Inputs!$A$174","v":"Other - Buildings capital works"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$175","v":"Non-network - Business IT"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Business IT ","IT & Communications"]
[null,{"$f":"Inputs!$A$176","v":"Non-network - Minor Plant, Motor Vehicles & Mobile Plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Minor Plant, Motor Vehicles & Mobile Plant ","Other non network"]
[null,{"$f":"Inputs!$A$177","v":"Non-network - Buildings"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$178","v":"Non-network - In-house software"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"In-house software ","IT & Communications"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E29:E47)","v":0},{"$f":"SUM(F29:F47)","v":0},0,4.9199460028178752,20.239707073822505,12.968527349980558,{"$f":"SUM(K29:K47)","v":1.1627351188734785},{"$f":"SUM(L29:L47)","v":0},{"$f":"SUM(M29:M47)","v":0},{"$f":"SUM(N29:N47)","v":0},39.290915545494414]
[]
[null,"Indirect Non-Labour Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"← This value is pro-rated over the escalated capital forecast (including direct labour costs) by year and asset class"]
[null,{"$f":"Inputs!$A$160","v":"Transmission Lines - Transmission Towers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.20145467622091226,0.52902629637210219,0.25043645792140085,0,0,0,0,{"$f":"SUM(E51:N51)","v":0.98091743051441527},null,{"$f":"Q29","v":"Transmission Lines "},"Transmission Towers"]
[null,{"$f":"Inputs!$A$161","v":"Transmission Lines - Transmission tower support structures"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,1.9251371586291244,4.5198283697092565,2.5262099087422389,0,0,0,0,{"$f":"SUM(E52:N52)","v":8.9711754370806194},null,"Transmission Lines ","Transmission tower support structures"]
[null,{"$f":"Inputs!$A$162","v":"Transmission Lines - Conductors"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Lines ","Conductors"]
[null,{"$f":"Inputs!$A$163","v":"Transmission Lines - Transmission line life extension"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Line Life Extension ","Transmission cables"]
[null,{"$f":"Inputs!$A$164","v":"Underground cables - Transmission cables"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Underground Cables ","Transmission cables"]
[null,{"$f":"Inputs!$A$165","v":"Substations - Substation switchbays"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,3.3051459183119114,8.0135478520336498,3.6098941692559379,0.60719002488794549,0,0,0,15.535777964489444,null,"Substations  ","Substation switchbays"]
[null,{"$f":"Inputs!$A$166","v":"Substations - Substation power transformers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation power transformers"]
[null,{"$f":"Inputs!$A$167","v":"Substations - Substation reactive plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation reactive plant"]
[null,{"$f":"Inputs!$A$168","v":"Secondary Systems - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Secondary Systems ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$169","v":"Communications (short life) - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Communications (short life) ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$170","v":"SIPS Control"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.51445867228000008,0,0,0,0,0,0,{"$f":"SUM(E61:N61)","v":0.51445867228000008},null,"SIPS Control","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$171","v":"Synchronous condensers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Synchronous Condensers ","Other network"]
[null,{"$f":"Inputs!$A$172","v":"Other - Leasehold land and property"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Leasehold Land and Property ","Buildings and Property"]
[null,{"$f":"Inputs!$A$173","v":"Other - Land and Easements"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Land and Easements  ","Other non network"]
[null,{"$f":"Inputs!$A$174","v":"Other - Buildings capital works"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$175","v":"Non-network - Business IT"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Business IT ","IT & Communications"]
[null,{"$f":"Inputs!$A$176","v":"Non-network - Minor Plant, Motor Vehicles & Mobile Plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Minor Plant, Motor Vehicles & Mobile Plant ","Other non network"]
[null,{"$f":"Inputs!$A$177","v":"Non-network - Buildings"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$178","v":"Non-network - In-house software"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"In-house software ","IT & Communications"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E51:E69)","v":0},0,0,5.9461964254419479,13.062402518115007,6.3865405359195773,{"$f":"SUM(K51:K69)","v":0.60719002488794549},{"$f":"SUM(L51:L69)","v":0},{"$f":"SUM(M51:M69)","v":0},{"$f":"SUM(N51:N69)","v":0},{"$f":"SUM(O51:O69)","v":26.002329504364479}]
[]
[null,"Total"]
[null,{"$f":"Inputs!$A$160","v":"Transmission Lines - Transmission Towers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0.35373682674799323,3.3955087507404382,5.0500611026073674,0,0,0,0,{"$f":"SUM(E73:N73)","v":8.7993066800957997},null,{"$f":"Q51","v":"Transmission Lines "},"Transmission Towers"]
[null,{"$f":"Inputs!$A$161","v":"Transmission Lines - Transmission tower support structures"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,3.3803728080322579,29.010120832250539,50.941122962074544,0,0,0,0,{"$f":"SUM(E74:N74)","v":83.331616602357343},null,"Transmission Lines ","Transmission tower support structures"]
[null,{"$f":"Inputs!$A$162","v":"Transmission Lines - Conductors"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Lines ","Conductors"]
[null,{"$f":"Inputs!$A$163","v":"Transmission Lines - Transmission line life extension"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Transmission Line Life Extension ","Transmission cables"]
[null,{"$f":"Inputs!$A$164","v":"Underground cables - Transmission cables"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Underground Cables ","Transmission cables"]
[null,{"$f":"Inputs!$A$165","v":"Substations - Substation switchbays"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,5.8035477310075585,51.434252026138793,72.793659038294123,13.266835399709123,0,0,0,143.29829419514959,null,"Substations  ","Substation switchbays"]
[null,{"$f":"Inputs!$A$166","v":"Substations - Substation power transformers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation power transformers"]
[null,{"$f":"Inputs!$A$167","v":"Substations - Substation reactive plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Substations  ","Substation reactive plant"]
[null,{"$f":"Inputs!$A$168","v":"Secondary Systems - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Secondary Systems ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$169","v":"Communications (short life) - Scada, network control and protection systems"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Communications (short life) ","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$170","v":"SIPS Control"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,1.8945222550501586,8.7423096067411201,2.451750617261836,0,0,0,0,{"$f":"SUM(E83:N83)","v":13.088582479053116},null,"SIPS Control","Scada, network control and protection systems"]
[null,{"$f":"Inputs!$A$171","v":"Synchronous condensers"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Synchronous Condensers ","Other network"]
[null,{"$f":"Inputs!$A$172","v":"Other - Leasehold land and property"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Leasehold Land and Property ","Buildings and Property"]
[null,{"$f":"Inputs!$A$173","v":"Other - Land and Easements"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Land and Easements  ","Other non network"]
[null,{"$f":"Inputs!$A$174","v":"Other - Buildings capital works"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$175","v":"Non-network - Business IT"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Business IT ","IT & Communications"]
[null,{"$f":"Inputs!$A$176","v":"Non-network - Minor Plant, Motor Vehicles & Mobile Plant"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Minor Plant, Motor Vehicles & Mobile Plant ","Other non network"]
[null,{"$f":"Inputs!$A$177","v":"Non-network - Buildings"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"Buildings - capital works ","Buildings and Property"]
[null,{"$f":"Inputs!$A$178","v":"Non-network - In-house software"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,0,0,0,0,0,0,0,null,"In-house software ","IT & Communications"]
[null,"Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E73:E91)","v":0},0,0,11.432179620837969,92.582191215870893,131.23659372023786,{"$f":"SUM(K73:K91)","v":13.266835399709123},{"$f":"SUM(L73:L91)","v":0},{"$f":"SUM(M73:M91)","v":0},{"$f":"SUM(N73:N91)","v":0},248.51779995665584]
[]
[{"$f":"IF(SUM(E94:N94)=0,0,1)","v":0},{"$f":"\"Check \"&$B$101","v":"Check Direct Non-Labour"},null,null,{"$f":"IF(ROUND(E$26-Inputs!W84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$26-Inputs!X84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G$26-Inputs!Y84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H$26-Inputs!Z84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I$26-Inputs!AA84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J$26-Inputs!AB84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K$26-Inputs!AC84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L$26-Inputs!AD84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M$26-Inputs!AE84,3)=0,0,1)","v":0},{"$f":"IF(ROUND(N$26-Inputs!AF84,3)=0,0,1)","v":0}]
[{"$f":"IF(SUM(E95:N95)=0,0,1)","v":0},{"$f":"\"Check \"&$B$105","v":"Check Labour Costs"},null,null,{"$f":"IF(ROUND(E$48-Inputs!K116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$48-Inputs!L116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G$48-Inputs!M116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H$48-Inputs!N116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I$48-Inputs!O116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J$48-Inputs!P116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K$48-Inputs!Q116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L$48-Inputs!R116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M$48-Inputs!S116,3)=0,0,1)","v":0},{"$f":"IF(ROUND(N$48-Inputs!T116,3)=0,0,1)","v":0}]
[{"$f":"IF(SUM(E96:N96)=0,0,1)","v":0},{"$f":"\"Check \"&$B$110","v":"Check Indirect Non-Labour Costs"},null,null,{"$f":"IF(ROUND(E$70-Inputs!K148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$70-Inputs!L148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G$70-Inputs!M148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H$70-Inputs!N148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I$70-Inputs!O148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J$70-Inputs!P148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K$70-Inputs!Q148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L$70-Inputs!R148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M$70-Inputs!S148,3)=0,0,1)","v":0},{"$f":"IF(ROUND(N$70-Inputs!T148,3)=0,0,1)","v":0}]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Driver",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"Inputs!L$20","v":2021},{"$f":"Inputs!M$20","v":2022},{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029}]
[]
[null,"Direct Non-Labour"]
[null,"Non-Labour",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"Inputs!W84","v":0},{"$f":"Inputs!X84","v":0},{"$f":"Inputs!Y84","v":0},{"$f":"Inputs!Z84","v":0.56603719257814422},{"$f":"Inputs!AA84","v":59.280081623933377},{"$f":"Inputs!AB84","v":111.88152583433772},{"$f":"Inputs!AC84","v":11.4969102559477},{"$f":"Inputs!AD84","v":0},{"$f":"Inputs!AE84","v":0},{"$f":"Inputs!AF84","v":0},{"$f":"SUM(E102:N102)","v":183.22455490679695}]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E102:E102)","v":0},0,0,0.56603719257814422,59.280081623933377,111.88152583433772,{"$f":"SUM(K102:K102)","v":11.4969102559477},{"$f":"SUM(L102:L102)","v":0},{"$f":"SUM(M102:M102)","v":0},{"$f":"SUM(N102:N102)","v":0},183.22455490679695]
[]
[null,"Labour Costs"]
[null,"Labour",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"Inputs!K$115","v":0},{"$f":"Inputs!L$115","v":0},{"$f":"Inputs!M$115","v":0},{"$f":"Inputs!N$115","v":4.9199460028178752},{"$f":"Inputs!O$115","v":20.160985351815018},{"$f":"Inputs!P$115","v":12.75134393287901},{"$f":"Inputs!Q$115","v":1.1302129052852057},{"$f":"Inputs!R$115","v":0},{"$f":"Inputs!S$115","v":0},{"$f":"Inputs!T$115","v":0},{"$f":"SUM(E106:N106)","v":38.96248819279711}]
[null,"Labour Escalation",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"E106*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-E106","v":0},{"$f":"F106*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-F106","v":0},{"$f":"G106*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-G106","v":0},{"$f":"H106*Inputs!N$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-H106","v":0},{"$f":"I106*Inputs!O$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-I106","v":7.8721722007486505E-2},{"$f":"J106*Inputs!P$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-J106","v":0.21718341710154832},{"$f":"K106*Inputs!Q$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-K106","v":3.2522213588272786E-2},{"$f":"L106*Inputs!R$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-L106","v":0},{"$f":"M106*Inputs!S$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-M106","v":0},{"$f":"N106*Inputs!T$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-N106","v":0},{"$f":"SUM(E107:N107)","v":0.32842735269730761}]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E106:E107)","v":0},0,0,4.9199460028178752,20.239707073822505,12.968527349980558,{"$f":"SUM(K106:K107)","v":1.1627351188734785},{"$f":"SUM(L106:L107)","v":0},{"$f":"SUM(M106:M107)","v":0},{"$f":"SUM(N106:N107)","v":0},39.290915545494421]
[]
[null,"Indirect Non-Labour Costs"]
[null,"Non-Labour",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"Inputs!K$148","v":0},{"$f":"Inputs!L$148","v":0},{"$f":"Inputs!M$148","v":0},{"$f":"Inputs!N$148","v":5.9461964254419479},{"$f":"Inputs!O$148","v":13.062402518115009},{"$f":"Inputs!P$148","v":6.3865405359195773},{"$f":"Inputs!Q$148","v":0.60719002488794549},{"$f":"Inputs!R$148","v":0},{"$f":"Inputs!S$148","v":0},{"$f":"Inputs!T$148","v":0},{"$f":"SUM(E111:N111)","v":26.002329504364479}]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E111:E111)","v":0},0,0,5.9461964254419479,13.062402518115009,6.3865405359195773,{"$f":"SUM(K111:K111)","v":0.60719002488794549},{"$f":"SUM(L111:L111)","v":0},{"$f":"SUM(M111:M111)","v":0},{"$f":"SUM(N111:N111)","v":0},26.002329504364479]
[]
[null,"Total"]
[null,"Labour",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"E106","v":0},0,0,4.9199460028178752,20.160985351815018,12.75134393287901,{"$f":"K106","v":1.1302129052852057},0,0,0,{"$f":"SUM(E115:N115)","v":38.96248819279711}]
[null,"Labour Escalation",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,0,7.8721722007486505E-2,0.21718341710154832,3.2522213588272786E-2,0,0,0,{"$f":"SUM(E116:N116)","v":0.32842735269730761}]
[null,"Non-Labour",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"E102+E111","v":0},0,0,6.5122336180200922,72.342484142048392,118.2680663702573,12.104100280835645,0,0,0,{"$f":"SUM(E117:N117)","v":209.22688441116142}]
[null,"Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E115:E117)","v":0},0,0,11.432179620837967,92.582191215870893,131.23659372023786,{"$f":"SUM(K115:K117)","v":13.266835399709123},{"$f":"SUM(L115:L117)","v":0},{"$f":"SUM(M115:M117)","v":0},{"$f":"SUM(N115:N117)","v":0},{"$f":"SUM(O115:O117)","v":248.51779995665584}]
[]
[{"$f":"IF(SUM(E120:N120)=0,0,1)","v":0},{"$f":"\"Check \"&$B$101","v":"Check Direct Non-Labour"},null,null,{"$f":"IF(ROUND(E$26-E103,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$26-F103,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(E121:N121)=0,0,1)","v":0},{"$f":"\"Check \"&$B$105","v":"Check Labour Costs"},null,null,{"$f":"IF(ROUND(E$48-E108,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$48-F108,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(E122:N122)=0,0,1)","v":0},{"$f":"\"Check \"&$B$110","v":"Check Indirect Non-Labour Costs"},null,null,{"$f":"IF(ROUND(E$70-E112,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F$70-F112,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Incremental Capital Expenditure (Excluding Equity Raising Costs) by Component",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"Inputs!L$20","v":2021},{"$f":"Inputs!M$20","v":2022},{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029}]
[]
[null,"Direct Non-Labour Cost"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(E$103\n*IF((E$165+E$195)<>0,(E158+E188)/(E$165+E$195),($O158+$O188)/($O$165+$O$195)),0)","v":0},0,0,"c-i-c","c-i-c","c-i-c","c-i-c",{"$f":"IFERROR(L$103\n*IF((L$165+L$195)<>0,(L158+L188)/(L$165+L$195),($O158+$O188)/($O$165+$O$195)),0)","v":0},0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E128:E134)","v":0},{"$f":"SUM(F128:F134)","v":0},{"$f":"SUM(G128:G134)","v":0},0.56603719257814411,59.280081623933377,111.88152583433772,11.496910255947702,0,0,0,183.22455490679693]
[]
[null,"Labour Costs - Actual"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B138,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B138,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B138,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B139,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B139,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B139,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B140,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B140,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B140,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B141,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B141,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B141,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B142,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B142,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B142,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B143,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B143,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B143,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B144,Inputs!K$92:K$99)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B144,Inputs!L$92:L$99)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$92:$H$99,$B144,Inputs!M$92:M$99)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E138:E144)","v":0},{"$f":"SUM(F138:F144)","v":0},{"$f":"SUM(G138:G144)","v":0},1.5196206228279998,0,0,0,0,0,0,1.5196206228279998]
[]
[null,"Labour Costs - Forecast"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B148,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B148,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B148,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B149,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B149,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B149,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B150,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B150,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B150,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B151,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B151,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B151,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B152,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B152,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B152,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B153,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B153,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B153,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B154,Inputs!K$101:K$108)*Inputs!K$23*Inputs!K$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B154,Inputs!L$101:L$108)*Inputs!L$23*Inputs!L$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},{"$f":"IFERROR(SUMIF(Inputs!$H$101:$H$108,$B154,Inputs!M$101:M$108)*Inputs!M$23*Inputs!M$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0)),0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E148:E154)","v":0},{"$f":"SUM(F148:F154)","v":0},{"$f":"SUM(G148:G154)","v":0},3.4003253799898747,20.239707073822501,12.968527349980562,1.1627351188734785,0,0,0,37.771294922666407]
[]
[null,"Labour Costs - Total"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"E138+E148","v":0},0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E158:E164)","v":0},{"$f":"SUM(F158:F164)","v":0},{"$f":"SUM(G158:G164)","v":0},4.9199460028178752,20.239707073822501,12.968527349980562,1.1627351188734785,0,0,0,39.290915545494414]
[]
[null,"Indirect NL Costs - Actual"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B168,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B168,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B168,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B169,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B169,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B169,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B170,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B170,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B170,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B171,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B171,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B171,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B172,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B172,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B172,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B173,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B173,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B173,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B174,Inputs!K$123:K$131)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B174,Inputs!L$123:L$131)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$123:$H$131,$B174,Inputs!M$123:M$131)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E168:E174)","v":0},{"$f":"SUM(F168:F174)","v":0},{"$f":"SUM(G168:G174)","v":0},2.8012405937319995,0,0,0,0,0,0,2.8012405937319995]
[]
[null,"Indirect NL Costs - Forecast"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B178,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B178,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B178,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B179,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B179,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B179,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B180,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B180,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B180,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B181,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B181,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B181,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B182,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B182,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B182,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B183,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B183,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B183,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B184,Inputs!K$133:K$141)\n*Inputs!K$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B184,Inputs!L$133:L$141)\n*Inputs!L$23,0)","v":0},{"$f":"IFERROR(\nSUMIF(Inputs!$H$133:$H$141,$B184,Inputs!M$133:M$141)\n*Inputs!M$23,0)","v":0},"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E178:E184)","v":0},{"$f":"SUM(F178:F184)","v":0},{"$f":"SUM(G178:G184)","v":0},3.1449558317099462,13.062402518115007,6.3865405359195773,0.60719002488794538,0,0,0,23.201088910632478]
[]
[null,"Indirect NL Costs - Total"]
[null,{"$f":"$B$198","v":"Project Management"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"E168+E178","v":0},0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$199","v":"SIPS Control Implementation"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$200","v":"Other Support & Corporate Roles"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$201","v":"Transaction Procurement Support"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$202","v":"Regulatory Approvals"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$203","v":"Community and Stakeholder Engagement"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,{"$f":"$B$204","v":"Environment"},{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Sub-Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E188:E194)","v":0},{"$f":"SUM(F188:F194)","v":0},{"$f":"SUM(G188:G194)","v":0},5.9461964254419462,13.062402518115007,6.3865405359195773,0.60719002488794538,0,0,0,26.002329504364475]
[]
[null,"Total"]
[null,"Project Management",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF($B$186:$B$195,$B198,E$186:E$195)+SUMIF($B$156:$B$165,$B198,E$156:E$165)+SUMIF($B$126:$B$135,$B198,E$126:E$135)","v":0},0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"SIPS Control Implementation",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Other Support & Corporate Roles",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Transaction Procurement Support",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Regulatory Approvals",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Community and Stakeholder Engagement",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Environment",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,0,0,"c-i-c","c-i-c","c-i-c","c-i-c",0,0,0,"c-i-c"]
[null,"Total",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(E198:E204)","v":0},{"$f":"SUM(F198:F204)","v":0},{"$f":"SUM(G198:G204)","v":0},11.432179620837964,92.582191215870878,131.23659372023783,13.266835399709127,0,0,0,248.51779995665581]
[]
[{"$f":"IF(SUM(E207:N207)=0,0,1)","v":0},{"$f":"\"Check \"&$B$101","v":"Check Direct Non-Labour"},null,null,{"$f":"IF(ROUND(E$26-E135,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(E208:N208)=0,0,1)","v":0},{"$f":"\"Check \"&$B$105","v":"Check Labour Costs"},null,null,{"$f":"IF(ROUND(E$48-E165,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"IF(SUM(E209:N209)=0,0,1)","v":0},{"$f":"\"Check \"&$B$110","v":"Check Indirect Non-Labour Costs"},null,null,{"$f":"IF(ROUND(E$70-E195,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"End"]

{"sheet":"Outputs|Models","index":4,"n_rows":96,"n_cols":28,"rows_kept":96,"cut":false,"hidden":false,"merged":[[25,18,26,18],[25,19,26,19]]}
["Outputs | Models"]
[]
["Outputs | PTRM"]
[]
[null,"As Incurred",null,"Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"F5+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[null,"Capex"]
[null,{"$f":"Inputs!$A$182","v":"Transmission Lines "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,{"$f":"K72","v":55.99118406468191},0,0,0,0,{"$f":"SUM(F7:O7)","v":55.99118406468191}]
[null,{"$f":"Inputs!$A$183","v":"Underground Cables "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(F8:O8)","v":0}]
[null,{"$f":"Inputs!$A$184","v":"Substations  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,72.793659038294123,13.266835399709123,0,0,0,86.060494438003246]
[null,{"$f":"Inputs!$A$185","v":"Secondary Systems "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$186","v":"Communications (short life) "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$187","v":"SIPS Control"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,2.451750617261836,0,0,0,0,{"$f":"SUM(F12:O12)","v":2.451750617261836}]
[null,{"$f":"Inputs!$A$188","v":"Business IT "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,{"$f":"K78","v":0},0,0,0,0,0]
[null,{"$f":"Inputs!$A$189","v":"Minor Plant, Motor Vehicles & Mobile Plant "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$190","v":"Transmission Line Life Extension "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$191","v":"Land and Easements  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$192","v":"Synchronous Condensers "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$193","v":"Leasehold Land and Property "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$194","v":"Buildings - capital works "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,{"$f":"Inputs!$A$195","v":"In-house software "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0]
[null,"Total",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F7:F20)","v":0},0,0,0,0,131.23659372023786,13.266835399709123,0,0,0,144.50342911994699]
[]
[{"$f":"IF(SUM(F23:O23)=0,0,1)","v":0},"Check - As incurred",null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(K21-K$86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L21-L$86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M21-M$86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(N21-N$86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(O21-O$86,3)=0,0,1)","v":0}]
[]
[]
[null,"As Commissioned",null,"Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"F26+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Total",null,null,"Year of commission","Financing costs",null,null,null,null,2023,2024]
[null,"Capex",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nominal vanilla WACC",5.7547596226483401E-2,5.7676167388836401E-2]
[null,{"$f":"Inputs!$A$182","v":"Transmission Lines "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,{"$f":"IF(K$26=$S28,$P72+$T28,0)","v":92.536517872760072},0,0,0,0,{"$f":"SUM(F28:O28)","v":92.536517872760072},null,null,{"$f":"IF(P72=0,\"n/a\",_xlfn.MAXIFS($F$70:$O$70,$F72:$O72,\">0\"))","v":2025},{"$f":"SUMPRODUCT(I50:J50,$Y$28:$Z$28)-SUM(I72:J72)","v":0.4055945903069329},null,null,null,"Compound rate",{"$f":"Z28*(1+Y27)^0.5*(1+Z27)^0.5","v":1.0876838489522229},{"$f":"AA28*(1+Z27)^0.5","v":1.0284338420087296},1,"◄ Compound rate from mid-year to start of First Regulatory Period"]
[null,{"$f":"Inputs!$A$183","v":"Underground Cables "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,{"$f":"IF(P73=0,\"n/a\",_xlfn.MAXIFS($F$70:$O$70,$F73:$O73,\">0\"))","v":"n/a"},{"$f":"SUMPRODUCT(I51:J51,$Y$28:$Z$28)-SUM(I73:J73)","v":0}]
[null,{"$f":"Inputs!$A$184","v":"Substations  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,143.93979902416163,0,0,0,143.93979902416163,null,null,2026,0.64150482901202821]
[null,{"$f":"Inputs!$A$185","v":"Secondary Systems "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$186","v":"Communications (short life) "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$187","v":"SIPS Control"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,13.21423863873382,0,0,0,0,13.21423863873382,null,null,2025,0.12565615968070354]
[null,{"$f":"Inputs!$A$188","v":"Business IT "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,{"$f":"SUM(F34:O34)","v":0},null,null,"n/a",0]
[null,{"$f":"Inputs!$A$189","v":"Minor Plant, Motor Vehicles & Mobile Plant "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$190","v":"Transmission Line Life Extension "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$191","v":"Land and Easements  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$192","v":"Synchronous Condensers "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$193","v":"Leasehold Land and Property "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$194","v":"Buildings - capital works "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,{"$f":"Inputs!$A$195","v":"In-house software "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,null,null,null,null,0,0,0,0,0,0,null,null,"n/a",0]
[null,"Total",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F28:F41)","v":0},0,0,0,0,105.75075651149389,143.93979902416163,0,0,0,249.69055553565551,null,null,null,{"$f":"SUM(T28:T41)","v":1.1727555789996646}]
[]
[{"$f":"IF(SUM(P44)=0,0,1)","v":0},"Check - As commissioned",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROUND(P42-P$86-T42,3)=0,0,1)","v":0}]
[]
["Outputs | PTRM 'Pre-Period Costs'"]
[]
[null,"As Incurred",null,"Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"F48+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[null,"Capex"]
[null,{"$f":"Inputs!$A$182","v":"Transmission Lines "},null,"$Nominal","$Million",{"$f":"F72*F$94","v":0},0,0,3.4959134911307479,31.83761932851986,null,null,null,null,null,{"$f":"SUM(F50:O50)","v":35.333532819650607}]
[null,{"$f":"Inputs!$A$183","v":"Underground Cables "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$184","v":"Substations  "},null,"$Nominal","$Million",0,0,0,5.4333436330517744,50.53270550604794,null,null,null,null,null,55.966049139099717]
[null,{"$f":"Inputs!$A$185","v":"Secondary Systems "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$186","v":"Communications (short life) "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$187","v":"SIPS Control"},null,"$Nominal","$Million",0,0,0,1.7736720553110004,8.5890732225606161,null,null,null,null,null,{"$f":"SUM(F55:O55)","v":10.362745277871616}]
[null,{"$f":"Inputs!$A$188","v":"Business IT "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$189","v":"Minor Plant, Motor Vehicles & Mobile Plant "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$190","v":"Transmission Line Life Extension "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$191","v":"Land and Easements  "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$192","v":"Synchronous Condensers "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$193","v":"Leasehold Land and Property "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,{"$f":"Inputs!$A$194","v":"Buildings - capital works "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(F62:O62)","v":0}]
[null,{"$f":"Inputs!$A$195","v":"In-house software "},null,"$Nominal","$Million",0,0,0,0,0,null,null,null,null,null,0]
[null,"Total",null,"$Nominal","$Million",{"$f":"SUM(F50:F63)","v":0},{"$f":"SUM(G50:G63)","v":0},{"$f":"SUM(H50:H63)","v":0},{"$f":"SUM(I50:I63)","v":10.702929179493522},{"$f":"SUM(J50:J63)","v":90.959398057128411},{"$f":"SUM(K49:K63)","v":0},{"$f":"SUM(L49:L63)","v":0},{"$f":"SUM(M49:M63)","v":0},{"$f":"SUM(N49:N63)","v":0},{"$f":"SUM(O49:O63)","v":0},101.66232723662193]
[]
[{"$f":"IF(SUM(F66:O66)=0,0,1)","v":0},"Check - As incurred",null,null,null,{"$f":"IF(ROUND(F64-F$86*F$94,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G64-G$86*G$94,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H64-H$86*H$94,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I64-I$86*I$94,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J64-J$86*J$94,3)=0,0,1)","v":0}]
[]
["Output | As Incurred Capex by RAB Asset Class"]
[]
[null,"As Incurred",null,"Dollar basis","Units",{"$f":"Inputs!K$20","v":2020},{"$f":"F70+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029,"Total"]
[null,"Capex"]
[null,{"$f":"Inputs!$A$182","v":"Transmission Lines "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!H$73:H$91)","v":3.7341096347802512},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!I$73:I$91)","v":32.405629582990976},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!J$73:J$91)","v":55.99118406468191},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B72,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F72:O72)","v":92.130923282453139}]
[null,{"$f":"Inputs!$A$183","v":"Underground Cables "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B73,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F73:O73)","v":0}]
[null,{"$f":"Inputs!$A$184","v":"Substations  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!H$73:H$91)","v":5.8035477310075585},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!I$73:I$91)","v":51.434252026138793},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!J$73:J$91)","v":72.793659038294123},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!K$73:K$91)","v":13.266835399709123},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B74,Calculations!N$73:N$91)","v":0},143.29829419514959]
[null,{"$f":"Inputs!$A$185","v":"Secondary Systems "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B75,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$186","v":"Communications (short life) "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B76,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$187","v":"SIPS Control"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!H$73:H$91)","v":1.8945222550501586},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!I$73:I$91)","v":8.7423096067411201},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!J$73:J$91)","v":2.451750617261836},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B77,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F77:O77)","v":13.088582479053116}]
[null,{"$f":"Inputs!$A$188","v":"Business IT "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B78,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$189","v":"Minor Plant, Motor Vehicles & Mobile Plant "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B79,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$190","v":"Transmission Line Life Extension "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B80,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$191","v":"Land and Easements  "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B81,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$192","v":"Synchronous Condensers "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B82,Calculations!N$73:N$91)","v":0},0]
[null,{"$f":"Inputs!$A$193","v":"Leasehold Land and Property "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B83,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F83:O83)","v":0}]
[null,{"$f":"Inputs!$A$194","v":"Buildings - capital works "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B84,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F84:O84)","v":0}]
[null,{"$f":"Inputs!$A$195","v":"In-house software "},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!E$73:E$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!F$73:F$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!G$73:G$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$Q$73:$Q$91,$B85,Calculations!N$73:N$91)","v":0},{"$f":"SUM(F85:O85)","v":0}]
[null,"Total",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F72:F85)","v":0},0,0,11.432179620837969,92.582191215870893,131.23659372023786,13.266835399709123,0,0,0,248.51779995665584]
[]
[{"$f":"IF(SUM(F88:O88)=0,0,1)","v":0},"Check - As incurred",null,null,null,{"$f":"IF(ROUND(Calculations!E$92-F86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!F$92-G86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!G$92-H86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!H$92-I86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!I$92-J86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!J$92-K86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!K$92-L86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!L$92-M86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!M$92-N86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(Calculations!N$92-O86,3)=0,0,1)","v":0}]
[]
["Indexation factors"]
[]
[null,"Indexation"]
[null,"Factor",null,"Source","Unit",{"$f":"Inputs!K$20","v":2020},{"$f":"F93+1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,{"$f":"Inputs!A27","v":"Real 2024 End Period to Nominal Mid Period"},null,"Inputs","Factor",{"$f":"Inputs!K27","v":0.82523160001556595},{"$f":"Inputs!L27","v":0.83948535860435891},{"$f":"Inputs!M27","v":0.8813687684581063},{"$f":"Inputs!N27","v":0.93621072572939579},{"$f":"Inputs!O27","v":0.98247186486482418},{"$f":"Inputs!P27","v":1.0136559965373035},{"$f":"Inputs!Q27","v":1.0415299949916583},{"$f":"Inputs!R27","v":1.0701704860159655},{"$f":"Inputs!S27","v":1.0995985469903056},{"$f":"Inputs!T27","v":1.1298358348906596}]
[]
["End"]

{"sheet":"Outputs|Tables","index":5,"n_rows":101,"n_cols":27,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Outputs | Tables",null,null,null,null,{"$f":"Inputs!A8","v":"Real $2024"}]
[null,"AER amendments"]
["Table 5-2: Total forecast capex for WSB ($M, Real 2023-24)"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total"]
[null,"Capex nature",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years"]
[null,"Augmentation- Transmission lines",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"F42","v":0},{"$f":"G42","v":0},21.698824893127863,48.062521332943277,0,0,0,0,{"$f":"SUM(I7:M7)","v":48.062521332943277},{"$f":"SUM(F7:M7)","v":69.76134622607114}]
[null,"Augmentation- Substations",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"F53","v":0},{"$f":"G53","v":0},34.440399479539515,62.485672501394454,11.4969102559477,0,0,0,{"$f":"SUM(I8:M8)","v":73.982582757342158},{"$f":"SUM(F8:M8)","v":108.42298223688167}]
[null,"SIPS control","Includes future paired generation costs",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"F66","v":0.82476034281200006},{"$f":"G66","v":1.0697619122381585},8.7423096067411201,2.451750617261836,0,0,0,0,{"$f":"SUM(I9:M9)","v":2.451750617261836},{"$f":"SUM(F9:M9)","v":13.088582479053116}]
[null,"Labour and indirect costs","Excludes the 'SIPS Control Implementation' category mapped to SIPS control",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"Inputs!N113+Inputs!N146-F61","v":3.4961008737480008},{"$f":"Inputs!N114+Inputs!N147-G61","v":6.0415564920398079},{"$f":"Inputs!O114+Inputs!O147-H61","v":27.621935514454911},{"$f":"Inputs!P114+Inputs!P147-I61","v":18.019465851536754},{"$f":"Inputs!Q114+Inputs!Q147-J61","v":1.7374029301731513},{"$f":"Inputs!R114+Inputs!R147-K61","v":0},{"$f":"Inputs!S114+Inputs!S147-L61","v":0},{"$f":"Inputs!T114+Inputs!T147-M61","v":0},{"$f":"SUM(I10:M10)","v":19.756868781709905},{"$f":"SUM(F10:M10)","v":56.916461661952631}]
[null,"Real input costs",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"Inputs!N113*Inputs!N$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!N113","v":0},{"$f":"Inputs!N114*Inputs!N$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!N114","v":0},{"$f":"Inputs!O114*Inputs!O$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!O114","v":7.8721722007486505E-2},{"$f":"Inputs!P114*Inputs!P$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!P114","v":0.21718341710154832},{"$f":"Inputs!Q114*Inputs!Q$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!Q114","v":3.2522213588272786E-2},{"$f":"Inputs!R114*Inputs!R$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!R114","v":0},{"$f":"Inputs!S114*Inputs!S$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!S114","v":0},{"$f":"Inputs!T114*Inputs!T$22/INDEX(Inputs!$K$22:$T$22,MATCH(Inputs!$F$91,Years,0))-Inputs!T114","v":0},{"$f":"SUM(I11:M11)","v":0.2497056306898211},{"$f":"SUM(F11:M11)","v":0.32842735269730761}]
[null,"Total capex",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F7:F11)","v":4.3208612165600009},7.1113184042779665,92.582191215870893,131.23659372023786,13.266835399709123,0,0,0,144.50342911994699,248.51779995665586]
[]
[{"$f":"IF(SUM(F14:K14)=0,0,1)","v":0},"Check - As incurred",null,null,null,null,{"$f":"IF(ROUND(F12+G12-'Outputs|Models'!I86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H12-'Outputs|Models'!J86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I12-'Outputs|Models'!K86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J12-'Outputs|Models'!L86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K12-'Outputs|Models'!M86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L12-'Outputs|Models'!N86,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M12-'Outputs|Models'!O86,3)=0,0,1)","v":0}]
[]
["Table 5-4: Total forecast capex for WSB by category ($M, Real 2023-24)"]
[]
[null,"Capex nature","Forecasting method","Capex $M","% of total capex"]
[{"$f":"IF(ROUND(SUM(D19:D21)-O7,3)=0,0,1)","v":0},"Augmentation- Transmission lines","Competitive ECI Design & Construct contract",{"$f":"O39","v":68.252875614684342},{"$f":"IF($D$33=0,0,D19/$D$33)","v":0.27463978687477669}]
[null,null,"Rates from our procurement panels for key equipment",{"$f":"O40","v":1.4266690873867889},{"$f":"IF($D$33=0,0,D20/$D$33)","v":5.7407118831553118E-3}]
[null,null,"Other construction costs",{"$f":"O41","v":8.1801524000000014E-2},{"$f":"IF($D$33=0,0,D21/$D$33)","v":3.2915760566956198E-4}]
[{"$f":"IF(ROUND(SUM(D22:D24)-O8,3)=0,0,1)","v":0},"Augmentation- Substations","ECI Design & Construct contract",{"$f":"O50","v":97.69459254997912},{"$f":"IF($D$33=0,0,D22/$D$33)","v":0.39310903511546497}]
[null,null,"Rates from our procurement panels for key equipment",{"$f":"O51","v":9.6278365269025628},{"$f":"IF($D$33=0,0,D23/$D$33)","v":3.8741033956448033E-2}]
[null,null,"Other construction costs",{"$f":"O52","v":1.1005531600000003},4.4284681426921876E-3]
[{"$f":"IF(ROUND(SUM(D25:D29)-O9,3)=0,0,1)","v":0},"SIPS control","Forecast capex internal bottom-up build",{"$f":"O61","v":8.0483560352089683},3.238543088910608E-2]
[null,null,"Quotation from our communications service provider for new fibre optic link",{"$f":"O63","v":1.2629617000000002},5.0819768250816412E-3]
[null,null,"Rates from our procurement panels for key equipment",{"$f":"O62","v":2.5081647438441448},1.0092495363638321E-2]
[null,null,"Future paired generation",{"$f":"O64","v":0},0]
[null,null,"Other construction costs",{"$f":"O65","v":1.2691000000000001},5.1066764643069619E-3]
[{"$f":"IF(ROUND(SUM(D30:D31)-O10,3)=0,0,1)","v":0},"Labour and indirect costs","Actual capex reflects records in Ellipse.",{"$f":"F76","v":3.4961008737480004},1.4067808721780725E-2]
[null,null,"Forecast capex internal bottom-up build.",{"$f":"O76-D30-D32","v":53.420360788204619},0.21495587357332835]
[{"$f":"IF(ROUND(D32-O11,3)=0,0,1)","v":0},"Real input costs","Internal bottom-up build using AER’s forecast real labour cost escalators",{"$f":"O11","v":0.32842735269730761},{"$f":"IF($D$33=0,0,D32/$D$33)","v":1.3215445845512427E-3}]
[null,"Total capex",{"$f":"SUM(C19:C32)","v":0},{"$f":"SUM(D19:D32)","v":248.51779995665584},{"$f":"SUM(E19:E32)","v":0.99999999999999989}]
[]
["Table 5-7: Summary of transmission line capex"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total"]
[null,"Transmission line capex",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years",null,null,null,{"$f":"G38","v":"2022-23"},{"$f":"H38","v":"2023-24"},"2024-25","2025-26","2026-27","2027-28","2028-29","Total"]
[null,"Design & Construction",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"(SUM(Calculations!H$7:H$10)-G$41)*IF(SUM(S$39:S$40)=0,0,S39/SUM(S$39:S$40))","v":0},{"$f":"(SUM(Calculations!I$7:I$10)-H$41)*IF(SUM(T$39:T$40)=0,0,T39/SUM(T$39:T$40))","v":20.557485775404274},{"$f":"(SUM(Calculations!J$7:J$10)-I$41)*IF(SUM(U$39:U$40)=0,0,U39/SUM(U$39:U$40))","v":47.695389839280075},{"$f":"(SUM(Calculations!K$7:K$10)-J$41)*IF(SUM(V$39:V$40)=0,0,V39/SUM(V$39:V$40))","v":0},{"$f":"(SUM(Calculations!L$7:L$10)-K$41)*IF(SUM(W$39:W$40)=0,0,W39/SUM(W$39:W$40))","v":0},null,null,{"$f":"SUM(I39:M39)","v":47.695389839280075},{"$f":"SUM(F39:M39)","v":68.252875614684342},null,null,"Augmentation - Contractor",0,20.634027,47.873779999999996,0,0,0,0,{"$f":"SUM(S39:Y39)","v":68.507807}]
[null,"HV Equipment",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"(SUM(Calculations!H$7:H$10)-G41)*IF(SUM(S$39:S$40)=0,0,S40/SUM(S$39:S$40))","v":0},{"$f":"(SUM(Calculations!I$7:I$10)-H41)*IF(SUM(T$39:T$40)=0,0,T40/SUM(T$39:T$40))","v":1.1413391177235896},{"$f":"(SUM(Calculations!J$7:J$10)-I41)*IF(SUM(U$39:U$40)=0,0,U40/SUM(U$39:U$40))","v":0.28532996966319918},{"$f":"(SUM(Calculations!K$7:K$10)-J41)*IF(SUM(V$39:V$40)=0,0,V40/SUM(V$39:V$40))","v":0},{"$f":"(SUM(Calculations!L$7:L$10)-K41)*IF(SUM(W$39:W$40)=0,0,W40/SUM(W$39:W$40))","v":0},null,null,{"$f":"SUM(I40:M40)","v":0.28532996966319918},{"$f":"SUM(F40:M40)","v":1.4266690873867889},null,null,"Augmentation - Equipment",0,1.1455886399999999,0.28639715999999998,0,0,0,0,{"$f":"SUM(S40:Y40)","v":1.4319857999999999}]
[null,"Other construction costs",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"Inputs!Z54+Inputs!Z55","v":0},{"$f":"Inputs!AA54+Inputs!AA55","v":0},{"$f":"Inputs!AB54+Inputs!AB55","v":8.1801524000000014E-2},{"$f":"Inputs!AC54+Inputs!AC55","v":0},{"$f":"Inputs!AD54+Inputs!AD55","v":0},null,null,{"$f":"SUM(I41:M41)","v":8.1801524000000014E-2},{"$f":"SUM(F41:M41)","v":8.1801524000000014E-2},null,null,"Total",{"$f":"SUM(S39:S40)","v":0},21.779615639999999,48.160177159999996,0,0,0,0,69.939792800000006,0]
[null,{"$f":"\"Total \"&B38","v":"Total Transmission line capex"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F39:F41)","v":0},{"$f":"SUM(G39:G41)","v":0},21.698824893127863,48.062521332943277,0,0,0,0,48.062521332943277,69.761346226071126]
[]
[{"$f":"IF(SUM(F44:K44)=0,0,1)","v":0},"Check - Reconciliation",null,null,null,null,{"$f":"IF(ROUND(G42-SUM(Calculations!H7:H10),3)=0,0,1)","v":0},{"$f":"IF(ROUND(H42-SUM(Calculations!I7:I10),3)=0,0,1)","v":0},{"$f":"IF(ROUND(I42-SUM(Calculations!J7:J10),3)=0,0,1)","v":0},{"$f":"IF(ROUND(J42-SUM(Calculations!K7:K10),3)=0,0,1)","v":0},{"$f":"IF(ROUND(K42-SUM(Calculations!L7:L10),3)=0,0,1)","v":0}]
[]
["Table 5-10: Summary of substations capex"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total"]
[null,"Substation capex",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years",null,null,null,{"$f":"G49","v":"2022-23"},"2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Total"]
[null,"Design & Construction",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"(SUM(Calculations!H$12:H$14)-G$52)*IF(SUM(S$50:S$51)=0,0,S50/SUM(S$50:S$51))","v":0},{"$f":"(SUM(Calculations!I$12:I$14)-H$52)*IF(SUM(T$50:T$51)=0,0,T50/SUM(T$50:T$51))","v":26.738130258017463},{"$f":"(SUM(Calculations!J$12:J$14)-I$52)*IF(SUM(U$50:U$51)=0,0,U50/SUM(U$50:U$51))","v":60.042105196013942},{"$f":"(SUM(Calculations!K$12:K$14)-J$52)*IF(SUM(V$50:V$51)=0,0,V50/SUM(V$50:V$51))","v":10.9143570959477},{"$f":"(SUM(Calculations!L$12:L$14)-K$52)*IF(SUM(W$50:W$51)=0,0,W50/SUM(W$50:W$51))","v":0},null,null,{"$f":"SUM(I50:M50)","v":70.956462291961643},{"$f":"SUM(F50:M50)","v":97.69459254997912},null,null,"Augmentation - Contractor",0,26.902464999999999,60.411128899999994,10.98143763,0,0,0,{"$f":"SUM(S50:Y50)","v":98.295031530000003}]
[null,"HV Equipment",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"(SUM(Calculations!H$12:H$14)-G$52)*IF(SUM(S$50:S$51)=0,0,S51/SUM(S$50:S$51))","v":0},{"$f":"(SUM(Calculations!I$12:I$14)-H$52)*IF(SUM(T$50:T$51)=0,0,T51/SUM(T$50:T$51))","v":7.7022692215220507},{"$f":"(SUM(Calculations!J$12:J$14)-I$52)*IF(SUM(U$50:U$51)=0,0,U51/SUM(U$50:U$51))","v":1.9255673053805127},{"$f":"(SUM(Calculations!K$12:K$14)-J$52)*IF(SUM(V$50:V$51)=0,0,V51/SUM(V$50:V$51))","v":0},{"$f":"(SUM(Calculations!L$12:L$14)-K$52)*IF(SUM(W$50:W$51)=0,0,W51/SUM(W$50:W$51))","v":0},null,null,{"$f":"SUM(I51:M51)","v":1.9255673053805127},{"$f":"SUM(F51:M51)","v":9.6278365269025628},null,null,"Augmentation - Equipment",0,7.7496080000000003,1.9374020000000001,0,0,0,0,{"$f":"SUM(S51:Y51)","v":9.6870100000000008}]
[null,"Other construction costs",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,{"$f":"Inputs!Z56","v":0},{"$f":"Inputs!AA56","v":0},{"$f":"Inputs!AB56","v":0.51800000000000002},{"$f":"Inputs!AC56","v":0.58255316000000024},{"$f":"Inputs!AD56","v":0},null,null,{"$f":"SUM(I52:M52)","v":1.1005531600000003},{"$f":"SUM(F52:M52)","v":1.1005531600000003}]
[null,{"$f":"\"Total \"&B49","v":"Total Substation capex"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F50:F52)","v":0},{"$f":"SUM(G50:G52)","v":0},34.440399479539515,62.485672501394454,11.4969102559477,0,0,0,73.982582757342158,108.42298223688169,null,null,null,{"$f":"SUM(S50:S51)","v":0},34.652073000000001,62.348530899999993,10.98143763,0,0,0,{"$f":"SUM(Z50:Z51)","v":107.98204153},0]
[]
[{"$f":"IF(SUM(F55:K55)=0,0,1)","v":0},"Check - Reconciliation",null,null,null,null,{"$f":"IF(ROUND(G53-SUM(Calculations!H12:H14),3)=0,0,1)","v":0},{"$f":"IF(ROUND(H53-SUM(Calculations!I12:I14),3)=0,0,1)","v":0},{"$f":"IF(ROUND(I53-SUM(Calculations!J12:J14),3)=0,0,1)","v":0},{"$f":"IF(ROUND(J53-SUM(Calculations!K12:K14),3)=0,0,1)","v":0},{"$f":"IF(ROUND(K53-SUM(Calculations!L12:L14),3)=0,0,1)","v":0}]
[]
["Table 5-11: Summary of SIPS control capex"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total",null,null,null,null,{"$f":"G60","v":"2022-23"},"2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Total"]
[null,"SIPS Control Capex",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years",null,null,"SIPS - Contractor","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Design, Installation and Commissioning","Labour and Indirect costs for 'SIPS Control Implementation'",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0.82476034281200006,0.50372471966001431,5.6014523554751188,1.1184186172618356,0,0,null,null,{"$f":"SUM(I61:M61)","v":1.1184186172618356},{"$f":"SUM(F61:M61)","v":8.0483560352089683},null,null,"SIPS - Equipment","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Equipment","SIPS equipment costs",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,0.56603719257814422,1.8778955512660003,6.4232000000000067E-2,0,0,null,null,{"$f":"SUM(I62:M62)","v":6.4232000000000067E-2},{"$f":"SUM(F62:M62)","v":2.5081647438441448},null,null,"Total","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[null,"Communications link","SIPS contractor costs",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,0,1.2629617000000002,0,0,0,null,null,{"$f":"SUM(I63:M63)","v":0},{"$f":"SUM(F63:M63)","v":1.2629617000000002}]
[null,"Future paired generation costs","SIPS FPG contractor and equipment costs",{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,0,0,0,0,0,null,null,{"$f":"SUM(I64:M64)","v":0},{"$f":"SUM(F64:M64)","v":0},null,null,"SIPS FPG - Contractor","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Other construction costs",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",null,0,0,1.2691000000000001,0,0,null,null,{"$f":"SUM(I65:M65)","v":1.2691000000000001},{"$f":"SUM(F65:M65)","v":1.2691000000000001},null,null,"SIPS FPG - Equipment","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,{"$f":"\"Total \"&B60","v":"Total SIPS Control Capex"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F61:F65)","v":0.82476034281200006},{"$f":"SUM(G61:G65)","v":1.0697619122381585},8.7423096067411201,2.451750617261836,0,0,0,0,2.451750617261836,13.088582479053112,null,null,"Total","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",0]
[]
[{"$f":"IF(SUM(F68:K68)=0,0,1)","v":0},"Check - Reconciliation",null,null,null,{"$f":"IF(ROUND(F66-F$9,3)=0,0,1)","v":0},0,0,{"$f":"IF(ROUND(I66-Calculations!J$83,3)=0,0,1)","v":0},0,0]
[]
["Table 5-12: Summary of indirect and labour capex"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total"]
[null,"Indirect and labour capex",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years"]
[null,"Labour (internal & outsourced, direct)",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",1.178238952296,2.9276806603298615,14.638254718347387,11.850108732718724,1.1627351188734785,0,null,null,{"$f":"SUM(I74:M74)","v":13.012843851592201},{"$f":"SUM(F74:M74)","v":31.757018182565449}]
[null,"Indirect capex",null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",2.3178619214520002,3.1138758317099464,13.062402518115009,6.3865405359195773,0.60719002488794549,0,null,null,{"$f":"SUM(I75:M75)","v":6.9937305608075224},{"$f":"SUM(F75:M75)","v":25.487870832084479}]
[null,{"$f":"\"Total \"&B73","v":"Total Indirect and labour capex"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",{"$f":"SUM(F74:F75)","v":3.4961008737480004},6.0415564920398079,27.700657236462398,18.236649268638303,1.7699251437614238,0,0,0,20.006574412399722,57.244889014649928,null,"Note: Excludes the 'SIPS Control Implementation' category mapped to SIPS control"]
[]
[{"$f":"IF(SUM(F78:K78)=0,0,1)","v":0},"Check - Reconciliation",null,null,null,{"$f":"IF(ROUND(F76-F$10-F$11,3)=0,0,1)","v":0},0,0,0,0,0]
[]
["Table 5 13: Capex forecast for future paired generator rounds ($Million, Real 2022-24)"]
[]
[null,"Task ","Frequency","Qty","Unit Rate (Real 2024)","Total ",null,"Unit Rate (Real 2023)"]
[null,"Project Management","Per PG Tender Round","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Technical Specification",null,"c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Commercial",null,"c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Design & Development","Per Standard Site","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Delivery",null,"c-i-c","c-i-c","c-i-c",null,"c-i-c",null,"Note: Deliver includes delivery and equipment categories"]
[null,"Design & Development","Per Complex Site","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Delivery",null,"c-i-c","c-i-c","c-i-c",null,"c-i-c",null,"Note: Deliver includes delivery and equipment categories"]
[null,"Scheme Testing and Commissioning","Per PG Tender Round","c-i-c","c-i-c","c-i-c",null,"c-i-c"]
[null,"Total",null,null,null,0]
[]
[{"$f":"IF(SUM(F93:K93)=0,0,1)","v":0},"Check - Reconciliation",null,null,null,{"$f":"IF(ROUND(F91-O99,3)=0,0,1)","v":0}]
[]
["Table 5-14: Forecast capex for future paired generation ($M, Real 2023-24)"]
[]
[null,null,null,null,null,"Actuals","Estimates",null,"Forecast",null,null,null,null,"Total"]
[null,"Future paired generation",null,"Dollar basis","Units","2022-23","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29","Next Period","All years"]
[null,{"$f":"\"Total \"&B98","v":"Total Future paired generation"},null,{"$f":"Inputs!$A$8","v":"Real $2024"},"$Million",0,{"$f":"Inputs!Z50+Inputs!Z51","v":0},{"$f":"Inputs!AA50+Inputs!AA51","v":0},{"$f":"Inputs!AB50+Inputs!AB51","v":0},{"$f":"Inputs!AC50+Inputs!AC51","v":0},{"$f":"Inputs!AD50+Inputs!AD51","v":0},null,null,{"$f":"SUM(I99:M99)","v":0},{"$f":"SUM(F99:M99)","v":0}]
[]
["End"]

{"sheet":"Outputs|RIN","index":6,"n_rows":113,"n_cols":22,"rows_kept":113,"cut":false,"hidden":false,"merged":[[34,1,34,9]]}
["Outputs | RIN"]
[]
["4. Expenditure summary"]
[]
[null,"4.1 Capital costs (real $m, Jun 2024)"]
[null,null,"Total","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[]
[null,"Development and construction capital costs (as determined under the TET)"]
[null,"Capital expenditure",{"$f":"SUM(D9:J9)","v":231.65019126317139},{"$f":"Calculations!H92-D13","v":9.3236313339160226},{"$f":"Calculations!I92-E13","v":83.772369454235886},{"$f":"Calculations!J92-F13","v":125.77173203471828},{"$f":"Calculations!K92-G13","v":12.782458440301177},{"$f":"Calculations!L92-H13","v":0},{"$f":"Calculations!M92-I13","v":0},{"$f":"Calculations!N92-J13","v":0},"Note: TransGrid is defining this network expenditure excluding support costs"]
[null,"Asset disposals",{"$f":"SUM(D10:J10)","v":0},null,null,null,null,null,null,null,"Note: No asset disposals for this project"]
[null,"Depreciation",{"$f":"SUM(D11:J11)","v":0},null,null,null,null,null,null,null,"Note: Depreciation is calculated in the PTRM i.e. this row will be calculated elsewhere"]
[null,"Other capital costs"]
[null,{"$f":"B9","v":"Capital expenditure"},{"$f":"SUM(D13:J13)","v":16.867608693484478},{"$f":"D84+D90","v":2.1085482869219465},{"$f":"E84+E90","v":8.8098217616350087},5.4648616855195762,0.48437695940794545,0,0,0,"Note: This category includes network and non network support costs and labour related 'IT Hardware expenses'"]
[null,{"$f":"B10","v":"Asset disposals"},{"$f":"SUM(D14:J14)","v":0}]
[null,{"$f":"B11","v":"Depreciation"},{"$f":"SUM(D15:J15)","v":0}]
[null,"Total capital costs"]
[null,{"$f":"B9","v":"Capital expenditure"},{"$f":"C9+C13","v":248.51779995665586},11.432179620837969,92.582191215870893,131.23659372023786,13.266835399709123,0,0,0]
[null,{"$f":"B10","v":"Asset disposals"},0,0,0,0,0,0,0,0]
[null,{"$f":"B11","v":"Depreciation"},0,0,0,0,0,0,0,0]
[]
[]
[{"$f":"IF(SUM(D22:J22)=0,0,1)","v":0},"Check - Calculations",null,{"$f":"IF(ROUND(D17-Calculations!H92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(E17-Calculations!I92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F17-Calculations!J92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G17-Calculations!K92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H17-Calculations!L92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I17-Calculations!M92,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J17-Calculations!N92,3)=0,0,1)","v":0}]
[]
[null,"4.2 Capital direct and indirect costs (real $, Jun 2024)"]
[null,null,"Total","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[]
[null,"Capital direct costs",{"$f":"SUM(D27:J27)","v":205647861.75880688},{"$f":"Calculations!H92*10^6-D28","v":3377434.9084740747},{"$f":"Calculations!I92*10^6-E28","v":70709966.936120868},{"$f":"Calculations!J92*10^6-F28","v":119385191.49879871},{"$f":"Calculations!K92*10^6-G28","v":12175268.415413231},{"$f":"Calculations!L92*10^6-H28","v":0},{"$f":"Calculations!M92*10^6-I28","v":0},{"$f":"Calculations!N92*10^6-J28","v":0},"Note: Total capex excluding indirect non labour costs, non network expenditure and network support costs"]
[null,"Capital indirect costs",{"$f":"SUM(D28:J28)","v":42869938.197848953},{"$f":"(Calculations!H70+D84+D90)*10^6","v":8054744.712363895},{"$f":"(Calculations!I70+E84+E90)*10^6","v":21872224.279750016},{"$f":"(Calculations!J70+F84+F90)*10^6","v":11851402.221439155},{"$f":"(Calculations!K70+G84+G90)*10^6","v":1091566.9842958911},{"$f":"(Calculations!L70+H84+H90)*10^6","v":0},{"$f":"(Calculations!M70+I84+I90)*10^6","v":0},{"$f":"(Calculations!N70+J84+J90)*10^6","v":0},"Note: This category includes indirect non labour costs plus non network expenditure plus network support costs"]
[]
[null,"Total capital costs",{"$f":"SUM(C27:C28)","v":248517799.95665583},{"$f":"SUM(D27:D28)","v":11432179.62083797},92582191.215870887,131236593.72023787,13266835.399709122,0,0,0]
[]
[]
[{"$f":"IF(SUM(D33:J33)=0,0,1)","v":0},"Check - 4.1 Reconciliation",null,{"$f":"IF(ROUND(D30-D$17*10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(E30-E$17*10^6,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"4.3 Total capital costs broken down by cost component (real $m, Jun 2024)"]
[null,null,"Total","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[null,"Cost component"]
[null,"Transmission lines and substations",{"$f":"SUM(D38:J38)","v":235.42921747760272},{"$f":"'Outputs|Models'!I72+'Outputs|Models'!I74","v":9.5376573657878101},{"$f":"'Outputs|Models'!J72+'Outputs|Models'!J74","v":83.839881609129776},{"$f":"'Outputs|Models'!K72+'Outputs|Models'!K74","v":128.78484310297603},{"$f":"'Outputs|Models'!L72+'Outputs|Models'!L74","v":13.266835399709123},{"$f":"'Outputs|Models'!M72+'Outputs|Models'!M74","v":0},{"$f":"'Outputs|Models'!N72+'Outputs|Models'!N74","v":0},{"$f":"'Outputs|Models'!O72+'Outputs|Models'!O74","v":0},"Note: Transmission line and Substation RAB asset classes"]
[null,"SIPS control",{"$f":"SUM(D39:J39)","v":13.088582479053116},{"$f":"'Outputs|Models'!I77","v":1.8945222550501586},{"$f":"'Outputs|Models'!J77","v":8.7423096067411201},{"$f":"'Outputs|Models'!K77","v":2.451750617261836},{"$f":"'Outputs|Models'!L77","v":0},{"$f":"'Outputs|Models'!M77","v":0},{"$f":"'Outputs|Models'!N77","v":0},{"$f":"'Outputs|Models'!O77","v":0},"Note: 'SIPS control' RAB asset class"]
[null,"Other",{"$f":"SUM(D40:J40)","v":0},{"$f":"'Outputs|Models'!I86-SUM(D38:D39)","v":0},{"$f":"'Outputs|Models'!J86-SUM(E38:E39)","v":0},{"$f":"'Outputs|Models'!K86-SUM(F38:F39)","v":0},{"$f":"'Outputs|Models'!L86-SUM(G38:G39)","v":0},{"$f":"'Outputs|Models'!M86-SUM(H38:H39)","v":0},{"$f":"'Outputs|Models'!N86-SUM(I38:I39)","v":0},{"$f":"'Outputs|Models'!O86-SUM(J38:J39)","v":0},"Note: Total capex less items above"]
[]
[null,"Total",{"$f":"SUM(C38:C40)","v":248.51779995665584},{"$f":"SUM(D38:D40)","v":11.432179620837969},92.582191215870893,131.23659372023786,13.266835399709123,0,0,0]
[]
[]
["5. Network capital costs"]
[]
[null,"5.1 Network capital costs (real $m, Jun 2024)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Network capital costs - Including support costs (real $m, Jun 2024)"]
[null,null,{"$f":"C$6","v":"Total"},"2022-23","2023-24",{"$f":"F$6","v":"2024-25"},{"$f":"G$6","v":"2025-26"},{"$f":"H$6","v":"2026-27"},{"$f":"I$6","v":"2027-28"},{"$f":"J$6","v":"2028-29"},null,null,null,null,null,{"$f":"D48","v":"2022-23"},"2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[null,"Asset category"]
[null,{"$f":"Inputs!A199","v":"Transmission Towers"},{"$f":"SUM(D50:J50)","v":8.2006668407682763},{"$f":"IF(P$60=0,0,\n(D$17-(D$84+D$90))*(P50/P$60))","v":0.28849369684639931},{"$f":"IF(Q$60=0,0,\n(E$17-(E$84+E$90))*(Q50/Q$60))","v":3.0724031243641288},{"$f":"IF(R$60=0,0,\n(F$17-(F$84+F$90))*(R50/R$60))","v":4.839770019557748},{"$f":"IF(S$60=0,0,\n(G$17-(G$84+G$90))*(S50/S$60))","v":0},{"$f":"IF(T$60=0,0,\n(H$17-(H$84+H$90))*(T50/T$60))","v":0},{"$f":"IF(U$60=0,0,\n(I$17-(I$84+I$90))*(U50/U$60))","v":0},{"$f":"IF(V$60=0,0,\n(J$17-(J$84+J$90))*(V50/V$60))","v":0},null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!H$73:H$91)","v":0.35373682674799323},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!I$73:I$91)","v":3.3955087507404382},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!J$73:J$91)","v":5.0500611026073674},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B50,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A200","v":"Transmission tower support structures"},{"$f":"SUM(D51:J51)","v":77.826377953220231},{"$f":"IF(P$60=0,0,\n(D$17-(D$84+D$90))*(P51/P$60))","v":2.7568977114249589},26.249611597599696,48.819868644195573,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!H$73:H$91)","v":3.3803728080322579},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!I$73:I$91)","v":29.010120832250539},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!J$73:J$91)","v":50.941122962074544},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B51,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A201","v":"Conductors"},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B52,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A202","v":"Transmission cables"},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B53,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A203","v":"Substation switchbays"},133.8179731567372,4.7331428710296182,46.539935021513614,69.762436823892784,12.782458440301177,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!H$73:H$91)","v":5.8035477310075585},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!I$73:I$91)","v":51.434252026138793},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!J$73:J$91)","v":72.793659038294123},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!K$73:K$91)","v":13.266835399709123},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B54,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A204","v":"Substation power transformers"},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B55,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A205","v":"Substation reactive plant"},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B56,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A206","v":"Scada, network control and protection systems"},11.805173312445691,1.5450970546150462,7.9104197107584477,2.3496565470721964,0,0,0,0,null,null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!H$73:H$91)","v":1.8945222550501586},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!I$73:I$91)","v":8.7423096067411201},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!J$73:J$91)","v":2.451750617261836},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B57,Calculations!N$73:N$91)","v":0}]
[null,{"$f":"Inputs!A207","v":"Other network"},5.0094627676453438,{"$f":"IF(P$60=0,0,\n(D$17-(D$84+D$90))*(P58/P$60))+D90","v":0.63256448607658389},{"$f":"IF(Q$60=0,0,\n(E$17-(E$84+E$90))*(Q58/Q$60))+E90","v":2.5921266880905027},1.639458505655873,0.14531308782238364,0,0,0,"Note: This category includes support or overhead costs assuming 30% of support costs relate to network based on reported network and corporate overheads in the 2021-22 Annual CA RIN",null,null,null,null,{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!H$73:H$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!I$73:I$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!J$73:J$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!K$73:K$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!L$73:L$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!M$73:M$91)","v":0},{"$f":"SUMIF(Calculations!$R$73:$R$91,$B58,Calculations!N$73:N$91)","v":0}]
[]
[null,"Total",{"$f":"SUM(C50:C58)","v":236.65965403081677},9.9561958199926064,86.364496142326388,127.41119054037418,12.927771528123561,0,0,0,null,null,null,null,null,{"$f":"SUM(P50:P58)","v":11.432179620837969},92.582191215870893,131.23659372023786,13.266835399709123,0,0,0]
[]
[]
[null,"Network capex - Total less table 6.1",null,{"$f":"D17-D84","v":9.9561958199926064},{"$f":"E17-E84","v":86.364496142326388},127.41119054037416,12.927771528123561,0,0,0]
[{"$f":"IF(SUM(D64:J64)=0,0,1)","v":0},"Check - 4.1 Reconciliation",null,{"$f":"IF(ROUND(D60-D63,3)=0,0,1)","v":0},{"$f":"IF(ROUND(E60-E63,3)=0,0,1)","v":0},0,0,0,0,0]
[]
["6. Non-network"]
[]
[null,"6.1 Non-network expenditure (real $m, Jun 2024)"]
[null,null,{"$f":"C$6","v":"Total"},"2022-23","2023-24",{"$f":"F$6","v":"2024-25"},{"$f":"G$6","v":"2025-26"},{"$f":"H$6","v":"2026-27"},{"$f":"I$6","v":"2027-28"},{"$f":"J$6","v":"2028-29"}]
[]
[null,"Opex"]
[null,{"$f":"Inputs!A208","v":"IT & Communications"},{"$f":"SUM(D72:J72)","v":0}]
[null,{"$f":"Inputs!A209","v":"Motor Vehicles"},{"$f":"SUM(D73:J73)","v":0}]
[null,{"$f":"Inputs!A210","v":"Buildings and Property"},{"$f":"SUM(D74:J74)","v":0}]
[null,{"$f":"Inputs!A211","v":"Other non network"},{"$f":"SUM(D75:J75)","v":0}]
[]
[null,"Total non-network opex",{"$f":"SUM(D77:J77)","v":0},{"$f":"SUM(D72:D75)","v":0},0,0,0,0,0,0]
[null,"Capex"]
[null,{"$f":"B72","v":"IT & Communications"},{"$f":"SUM(D79:J79)","v":0.169399468},0,0.169399468,0,0,null,null,null,"Note: This category includes labour related 'IT Hardware expenses'"]
[null,{"$f":"B73","v":"Motor Vehicles"},{"$f":"SUM(D80:J80)","v":0},0,0,0,0,0,0,0]
[null,{"$f":"B74","v":"Buildings and Property"},{"$f":"SUM(D81:J81)","v":0},0,0,0,0,0,0,0]
[null,{"$f":"B75","v":"Other non network"},{"$f":"SUM(D82:J82)","v":11.688746457839134},{"$f":"D91","v":1.4759838008453625},6.0482956055445056,3.8254031798637036,0.33906387158556184,0,0,0,"Note: This category includes support or overhead costs assuming 70% of support costs relate to non network based on reported network and corporate overheads in the 2021-22 Annual CA RIN"]
[]
[null,"Total non-network capex",{"$f":"SUM(D84:J84)","v":11.858145925839134},{"$f":"SUM(D79:D82)","v":1.4759838008453625},6.2176950735445056,3.8254031798637036,0.33906387158556184,0,0,0]
[]
[]
[null,"Labour and overhead costs",null,{"$f":"D69","v":"2022-23"},{"$f":"E69","v":"2023-24"},"2024-25","2025-26","2026-27","2027-28","2028-29"]
[null,"Total capex support costs","Real 2024 Dollars",2.1085482869219465,8.6404222936350088,5.4648616855195771,0.48437695940794551,null,null,null,"Note: Equates to 30% labour costs"]
[null,"Network proportion of total capex support costs","Percent",0.3,0.3,0.3,0.3,null,null,null,"Note: based on reported network and corporate overheads in our 2021-22 Annual CA RIN"]
[null,"Network capex support costs","Real 2024 Dollars",{"$f":"D88*D89","v":0.63256448607658389},{"$f":"E88*E89","v":2.5921266880905027},{"$f":"F88*F89","v":1.639458505655873},{"$f":"G88*G89","v":0.14531308782238364}]
[null,"Non network capex support costs","Real 2024 Dollars",{"$f":"D88*(1-D89)","v":1.4759838008453625},{"$f":"E88*(1-E89)","v":6.0482956055445056},{"$f":"F88*(1-F89)","v":3.8254031798637036},{"$f":"G88*(1-G89)","v":0.33906387158556184}]
[null,"Labour-related (direct, 'IT Hardware expenses')","Real 2024 Dollars",0,0.169399468,0,0]
[]
["7.1 Regulatory requirements/contractual arrangement costs"]
[]
[null,"7.1 Regulatory requirements/contractual arrangement costs (real $)"]
[null,null,"Total","2022-23","2023-24","2024-25","2025-26","2026-27","2027-28","2028-29"]
[]
[null,"Network Operator Appointment Fee",{"$f":"SUM(D99:J99)","v":0}]
[null,"Regulatory submissions","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","Note: Based on the 'Regulatory Approvals' cost category"]
[null,"Environmental Approvals","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","Note: Based on the 'Environment' cost category"]
[null,"Independent Engineer","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"SIPS Contract Management, Operations, Annual Testing, and Defect Rectification",{"$f":"SUM(D103:J103)","v":0}]
[]
[null,"Regulatory requirements/contractual arrangement costs",4440353.9537742259,1248389.0908443977,3191964.862929828,0,0,0,0,0]
[]
[]
["Checks"]
[]
[{"$f":"IF(SUM(D110:H110)=0,0,1)","v":0},"Check - Table 4",null,{"$f":"IF(ROUND(F17-'Outputs|Models'!K$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G17-'Outputs|Models'!L$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H17-'Outputs|Models'!M$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I17-'Outputs|Models'!N$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J17-'Outputs|Models'!O$21,3)=0,0,1)","v":0}]
[{"$f":"IF(SUM(D111:H111)=0,0,1)","v":0},"Check - Table 5 and 6",null,{"$f":"IF(ROUND((F60+F84)-'Outputs|Models'!K$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND((G60+G84)-'Outputs|Models'!L$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND((H60+H84)-'Outputs|Models'!M$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND((I60+I84)-'Outputs|Models'!N$21,3)=0,0,1)","v":0},{"$f":"IF(ROUND((J60+J84)-'Outputs|Models'!O$21,3)=0,0,1)","v":0}]
[]
["End"]