{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Index","Notes & Assumptions","Inputs","Outputs | Models","LLE Costs >","Transformers","Reactors","Towers and Conductors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":139,"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":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Index and File Details"]
[]
[null,"Index",null,null,null,null,null,"File Details"]
[]
[null,"Inputs",null,"Inputs / Calculations",null,"Outputs",null,null,"Model","TransGrid | Humelink LLE Capex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","TransGrid"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs",null,null,"Revision","2023-05-19"]
[null,"Inputs",null,null,null,null,null,null,"Status","Proposal"]
[]
[]
[]
[null,null,null,null,null,null,null,"Instructions"]
[]
[null,null,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,null,null,null,null,null,null,null,"Historical"]
[null,null,null,null,null,null,null,null,"Cells not marked as inputs should not be modified."]

{"sheet":"Notes & Assumptions","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Assumptions & Notes"]
[]
[null,null,null,null,"User inputs in cells coloured like this"]
[null,null,"*",null,"1.     Inputs are in $. Outputs are $million."]
[null,null,"*",null,"2.     Financial years are recorded in the Capex Forecast Model as tax years (eg. 2017/18 is shown as 2018, 2018/19 is shown as 2019)"]
[null,null,"*",null,"3.     Escalation is treated as follows:"]
[null,null,null,null,"a.    CPI escalation and Labour escalation are treated separately. "]
[null,null,null,null,"b.    Escalation is applied to Expenditure Components (i.e. Labour)"]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2023-05-19","v1.1",null,null,"Initial model development"]

{"sheet":"Inputs","index":2,"n_rows":67,"n_cols":28,"rows_kept":67,"cut":false,"hidden":false,"merged":[[5,1,5,2],[17,0,17,2],[12,0,12,2],[12,11,12,20],[17,10,17,20],[49,22,49,26],[59,10,59,14],[59,16,59,20],[59,22,59,26],[59,0,59,2],[59,7,59,8],[49,0,49,2],[49,16,49,20]]}
["Inputs"]
[]
[]
["Output Reporting Fomat and Year"]
["Real"]
[2018]
[]
[{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2018"}]
[]
["Indexation"]
[]
[]
["Forecasts",null,null,null,null,null,null,null,null,null,null,"Rates"]
["Item","Source","Units",null,null,null,null,null,null,null,null,{"$f":"L19","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028]
["Actual / Forecast Inflation ","ABS June to June / RBA Forecast","%",null,null,null,null,null,null,null,null,{"$f":"114.8/113-1","v":1.5929203539823078E-2},{"$f":"114.4/114.8-1","v":-3.4843205574912606E-3},{"$f":"118.8/114.4-1","v":3.8461538461538325E-2},{"$f":"126.1/118.8-1","v":6.1447811447811418E-2},6.6999999999999948E-2,2.9193048507912156E-2,{"$f":"Q15","v":2.9193048507912156E-2},{"$f":"R15","v":2.9193048507912156E-2},{"$f":"S15","v":2.9193048507912156E-2},{"$f":"T15","v":2.9193048507912156E-2},null,"◄ Actual June year on year inflation used for 2019 to 2022. Forecast inflation for 2023 to 2028 as per the AER's Final Decision."]
[]
[]
["Cumulative Factors",null,null,null,null,null,null,null,null,null,"Cumulative factors"]
["Item","Source","Units",null,null,null,null,null,null,null,2018,{"$f":"K19+1","v":2019},2020,2021,2022,2023,2024,{"$f":"Q19+1","v":2025},{"$f":"R19+1","v":2026},{"$f":"S19+1","v":2027},{"$f":"T19+1","v":2028}]
["Real 2018 End Period to Nominal End Period","Calculated","Factor",null,null,null,null,null,null,null,1,{"$f":"K20*(1+L15)","v":1.0159292035398231},1.0123893805309736,1.0513274336283187,1.1159292035398232,1.1906964601769912,1.2254565196971374,1.2612313313209931,{"$f":"R20*(1+S15)","v":1.2980505187559455},{"$f":"S20*(1+T15)","v":1.3359445705157083},{"$f":"T20*(1+U15)","v":1.3749448651666552}]
["Real 2018 End Period to Real 2023 End Period","Calculated","Factor",null,null,null,null,null,null,null,null,{"$f":"$P$20/$K$20","v":1.1906964601769912},1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912]
["Real 2018 End Period to Nominal Mid Period","Calculated","Factor",null,null,null,null,null,null,null,null,{"$f":"IF(K22=\"\",$K$20,K$22)\n*(1+K$15)^0.5\n*(1+L$15)^0.5","v":1.0079331344587412},1.0141577476088255,1.0316747206683852,1.0831467978387854,1.1527067937958009,1.2079514642998679,1.2432152499923772,{"$f":"IF(R22=\"\",$K$20,R$22)\n*(1+R$15)^0.5\n*(1+S$15)^0.5","v":1.2795084930911806},{"$f":"IF(S22=\"\",$K$20,S$22)\n*(1+S$15)^0.5\n*(1+T$15)^0.5","v":1.3168612465962768},{"$f":"IF(T22=\"\",$K$20,T$22)\n*(1+T$15)^0.5\n*(1+U$15)^0.5","v":1.3553044408463513}]
[]
[]
["Asset Classes"]
[]
[]
["Asset Classes"]
["Description"]
["Transmission Lines"]
["Underground Cables"]
["Substations"]
["Secondary Systems"]
["Communications (short life)"]
["Business IT"]
["Minor Plant, Motor Vehicles & Mobile Plant"]
["Transmission Line Life Extension"]
["Land and Easements "]
["NSCAS Assets"]
["Synchronous Condensers (2018-23)"]
["Leasehold Land and Property"]
["Buildings - capital works"]
["In-house software"]
[]
[]
["Capital Expenditure | Long-Lead Equipment"]
[]
["Forecast Approved in CPA 1"]
[]
["Long-Lead Equipment",null,null,null,"Conversion",null,null,{"$f":"\"$\"&E52","v":"$2022"},"Asset Class",null,null,null,null,null,null,null,{"$f":"\"As Incurred Capex (June \"&$F$52&\" dollars)\"","v":"As Incurred Capex (June 2018 dollars)"},null,null,null,null,null,{"$f":"\"As Commissioned Capex (June \"&$F$52&\" dollars)\"","v":"As Commissioned Capex (June 2018 dollars)"},null,null,null,null,"◄ Inputs sourced from CPA 1 decision"]
["Category","Source","Units",null,"Dollar Year From","Dollar Year To",null,"Value","Asset Class",null,null,null,null,null,null,null,2023,2024,2025,2026,"Total",null,2023,2024,2025,2026,"Total"]
["Steel & Tower | Production Slot For Steel","Project Team Input","$Millions",null,2022,2018,null,"c-i-c","Transmission Lines",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Substation | Long Lead Equipment (Transformers And Reactors)","Project Team Input","$Millions",null,2022,2018,null,"c-i-c","Substations",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[]
[null,null,null,null,null,null,"Total",24.631688059999998,null,null,null,null,null,null,null,"Total",15.610960599506825,7.1911132679593983,0,0,22.80207386746622,null,0,22.80207386746622,0,0,22.80207386746622]
[]
[]
["Revised Forecast"]
[]
["Long-Lead Equipment",null,null,null,"Conversion",null,null,"Expenditure",null,null,"As Incurred Spend Profile",null,null,null,null,null,{"$f":"\"As Incurred Capex (June \"&$F$62&\" dollars)\"","v":"As Incurred Capex (June 2018 dollars)"},null,null,null,null,null,{"$f":"\"As Commissioned Capex (June \"&$F$62&\" dollars)\"","v":"As Commissioned Capex (June 2018 dollars)"},null,null,null,null,"◄ Assumed commissioning occurs in FY25"]
["Category","Source","Units",null,"Dollar Year From","Dollar Year To",null,"Value","Asset Class",null,{"$f":"Q51","v":2023},{"$f":"R51","v":2024},{"$f":"S51","v":2025},{"$f":"T51","v":2026},{"$f":"U51","v":"Total"},null,{"$f":"K61","v":2023},{"$f":"L61","v":2024},{"$f":"M61","v":2025},{"$f":"N61","v":2026},{"$f":"O61","v":"Total"},null,2023,2024,2025,2026,"Total"]
["Steel & Tower | Long Lead Equipmenp","Project Team Input","$Millions",null,2023,{"$f":"Report_Year","v":2018},null,"c-i-c","Transmission Lines",null,0,0.59299999999999997,0.40699999999999997,0,{"$f":"SUM(K62:N62)","v":1},null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
["Substation | Long Lead Equipment (Transformers And Reactors)","Project Team Input","$Millions",null,2023,{"$f":"F62","v":2018},null,"c-i-c","Substations",null,0.22046530552989449,9.0002349379174784E-2,0.68953234509093075,0,{"$f":"SUM(K63:N63)","v":1},null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[]
[null,null,null,null,null,null,"Total",253.89660378000002,null,null,null,null,null,null,null,"Total",15.610960599506825,92.920294758828732,105.61829368281357,0,213.23369328087153,null,0,0,213.23369328087153,0,213.23369328087153]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change",0,85.729181490869337,105.61829368281357,0,190.43161941340531,null,0,-22.80207386746622,213.23369328087153,0,190.43161941340531]

{"sheet":"Outputs | Models","index":3,"n_rows":139,"n_cols":18,"rows_kept":139,"cut":false,"hidden":false,"merged":[]}
["Outputs | Models"]
[]
[]
["As Incurred Capex By Asset Class"]
[]
[null,"Output Table for PTRM (2018-23)",null,null,null,"As Incurred",null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Underground Cables",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Substations",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Secondary Systems",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Communications (short life)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Business IT",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Transmission Line Life Extension",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Land and Easements ",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"NSCAS Assets",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Synchronous Condensers (2018-23)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Leasehold Land and Property",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Buildings - capital works",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"In-house software",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Total",null,"Real $2018","$Million",0,0,0,0,0,85.729181490869323,105.61829368281357,0,0,0,191.34747517368288]
[]
["As Commissioned Capex By Asset Class"]
[]
[null,"Output Table for PTRM (2018-23)",null,null,null,"As Incurred",null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2019,2020,2021,2022,2023,2024,2025,2026,2027,2028]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Underground Cables",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Substations",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Secondary Systems",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Communications (short life)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Business IT",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Transmission Line Life Extension",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Land and Easements ",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"NSCAS Assets",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Synchronous Condensers (2018-23)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Leasehold Land and Property",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Buildings - capital works",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"In-house software",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","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,"Total",null,"Real $2018","$Million",0,0,0,0,0,-22.80207386746622,213.23369328087153,0,0,0,190.43161941340531]
[]
["Input to PTRM for the 2018-23 period (if needed)"]
[]
[null,"Output Table for PTRM (2018-23)",null,null,null,"As Incurred",null,null,null,null,"Total",null,"As Commissioned",null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2019,2020,2021,2022,2023,null,null,2019,2020,2021,2022,2023]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Underground Cables",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Substations",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Secondary Systems",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Communications (short life)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Business IT",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Transmission Line Life Extension",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Land and Easements ",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"NSCAS Assets",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Synchronous Condensers (2018-23)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[]
[null,"Total",null,"Real $2018","$Million",0,0,0,0,0,0,null,0,0,0,0,0,0]
[]
[]
["Input to RFM for the 2018-23 period"]
[]
[null,"Real 2018 End Period to Nominal Mid Period",null,null,null,1.0079331344587412,1.0141577476088255,1.0316747206683852,1.0831467978387854,1.1527067937958009]
[]
[null,"Output Table for RFM (2018-23)",null,null,null,"As Incurred",null,null,null,null,"Total",null,"As Commissioned",null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2019,2020,2021,2022,2023,null,null,2019,2020,2021,2022,2023]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Underground Cables",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Substations",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Secondary Systems",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Communications (short life)",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Business IT",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Transmission Line Life Extension",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Land and Easements ",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"NSCAS Assets",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Synchronous Condensers (2018-23)",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Leasehold Land and Property",null,"$Nominal","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[]
[null,"Total",null,"$Nominal","$Million",0,0,0,0,0,0,null,0,0,0,0,0,0]
[]
[]
["Input to PTRM for the 2023-28 period"]
[]
[null,"Real 2018 End Period to Real 2023 End Period",null,null,null,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912,1.1906964601769912]
[]
[null,"Output Table for PTRM (2023-28)",null,null,null,"As Incurred",null,null,null,null,"Total",null,"As Commissioned",null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2024,2025,2026,2027,2028,null,null,2024,2025,2026,2027,2028]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Underground Cables",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Substations",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Secondary Systems",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Communications (short life)",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Business IT",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Transmission Line Life Extension",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Land and Easements ",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Synchronous Condensers",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Leasehold Land and Property",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Buildings - capital works",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"In-house software",null,"Real $2023","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[]
[null,"Total",null,"Real $2023","$Million",102.1,125.8,0,0,0,{"$f":"227.9","v":227.9},null,-27.150348638686303,253.89660377999996,0,0,0,226.74625514131367]
[]
["Input to PTRM for the 2018-23 period"]
[]
[null,"Output Table for PTRM (2018-23)",null,null,null,"As Incurred",null,null,null,null,"Total",null,"As Commissioned",null,null,null,null,"Total"]
[null,null,null,"Dollar basis","Units",2019,2020,2021,2022,2023,null,null,2019,2020,2021,2022,2023]
[]
[null,"Capex"]
[null,"Transmission Lines",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Underground Cables",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Substations",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Secondary Systems",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Communications (short life)",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Business IT",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Minor Plant, Motor Vehicles & Mobile Plant",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Transmission Line Life Extension",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Land and Easements ",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Synchronous Condensers",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Leasehold Land and Property",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"Buildings - capital works",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[null,"In-house software",null,"Real $2018","$Million","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,null,null,null,0,0]
[]
[null,"Total",null,"Real $2018","$Million",0,0,0,0,0,0,null,0,0,0,0,0,0]

{"sheet":"LLE Costs >","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Transformers","index":5,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,"CONFIDENTIAL"]

{"sheet":"Reactors","index":6,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,"CONFIDENTIAL"]

{"sheet":"Towers and Conductors","index":7,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,"CONFIDENTIAL"]