{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Index","Notes & Assumptions","Inputs","Calculations","Outputs"],"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":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Index and File Details"]
[]
[null,"Index",null,null,null,null,null,"File Details"]
[]
[null,"Inputs",null,"Calculations",null,"Outputs",null,null,"Model","Transgrid | CWOREZ Non-Contestable Opex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs",null,null,"Revision","2025-07-24"]
[null,{"$f":"Inputs!A1","v":"Inputs"},null,null,null,null,null,null,"Status","Revenue Proposal"]
[]
[]
[]
[null,"Model Checks",null,null,null,null,null,"Instructions"]
[]
[null,"Worksheet",null,null,null,null,null,null,"Input Sheets"]
[null,{"$f":"B7","v":"Notes & Assumptions"},null,"N/A",null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,{"$f":"B8","v":"Inputs"},null,"N/A",null,null,null,null,"Historical / Not applicable"]
[null,{"$f":"D7","v":"Calculations"},null,{"$f":"IF(SUM(Calculations!A2:A97)=0,0,1)","v":0},null,null,null,null,"Cells not marked as inputs should not be modified."]
[null,{"$f":"F7","v":"Outputs"},null,{"$f":"IF(SUM(Outputs!A3:A121)=0,0,1)","v":0},null,null,null,null,"Confidential information",null,"user input"]
[]
[null,"Total Error Check",null,{"$f":"IF(SUM(D15:D18)=0,0,1)","v":0}]
[]
[null,"End"]

{"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 and calculations are in $. Some outputs are $million."]
[null,null,"*",null,"2.     Financial years are recorded in the Opex Forecast Model as tax years (e.g. 2017/18 is shown as 2018, 2018/19 is shown as 2019)"]
[null,null,"*",null,"3.     Escalation is treated as follows:"]
[null,null,null,null,"a.    CPI escalation and Commodity escalation are treated separately. "]
[]
[]
["Modifications"]
["Date","Version",null,"Who","Notes"]
["2023-06-26","v1.1",null,null,"Initial model development"]

{"sheet":"Inputs","index":2,"n_rows":188,"n_cols":31,"rows_kept":188,"cut":false,"hidden":false,"merged":[[5,2,5,5],[32,16,32,21],[12,12,12,21],[18,12,18,21],[87,23,87,28],[87,5,87,7],[32,5,32,7],[182,16,182,21],[166,16,166,21],[156,16,156,21],[87,16,87,21],[32,23,32,25],[174,16,174,21]]}
["Inputs"]
[]
[]
[null,"Output Reporting Format and Year"]
[null,"Real"]
[null,2026,"The Financial Year that results are reported in."]
[]
[null,{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2026"}]
[]
[null,"Indexation and escalation"]
[]
[]
[null,"Forecasts",null,null,null,null,null,null,null,null,null,null,"Rates"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,2022,2023,{"$f":"N14+1","v":2024},2025,2026,2027,2028,2029,{"$f":"T14+1","v":2030},{"$f":"U14+1","v":2031}]
[null,"Actual / Forecast Inflation ","ABS / RBA / PTRM","%",null,null,null,null,null,null,null,null,6.1447811447811418E-2,6.0269627279936566E-2,3.8145100972326373E-2,2.4E-2,3.2000000000000001E-2,2.7798093009959057E-2,2.7798093009959057E-2,2.7798093009959057E-2,2.7798093009959057E-2,2.7798093009959057E-2,null,"Note: Currently set to June to June unlagged for actual/estimates and PTRM for forecasts"]
[null,"Real labour escalation","Transgrid AER FD","%",null,null,null,null,null,null,null,null,null,-3.4704503367676172E-2,3.9046564755527329E-3,1.3076482545953276E-2,1.1546438954636147E-2,4.3304575862308627E-3,3.00941333753012E-3,{"$f":"AVERAGE($R$16:$S$16)","v":3.6699354618804914E-3},{"$f":"AVERAGE($R$16:$S$16)","v":3.6699354618804914E-3},{"$f":"AVERAGE($R$16:$S$16)","v":3.6699354618804914E-3},null,"Note: Based on Final Decision values applied to both the opex and capex models"]
[]
[]
[null,"Cumulative factors",null,null,null,null,null,null,null,null,null,null,"Cumulative Factors"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,{"$f":"M$14","v":2022},{"$f":"N$14","v":2023},{"$f":"O$14","v":2024},2025,2026,2027,2028,2029,2030,2031]
[null,"Nominal (mid year) to Real 2026 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,{"$f":"N21*(1+N15)^0.5*(1+M15)^0.5","v":1.1984042938974993},{"$f":"O21*(1+O15)^0.5*(1+N15)^0.5","v":1.1296551150404281},{"$f":"P21*(1+P15)^0.5*(1+O15)^0.5","v":1.0767346356483898},{"$f":"Q21*(1+Q15)^0.5*(1+P15)^0.5","v":1.0443105744940056},{"$f":"(1+Q15)^0.5","v":1.0158740079360236},{"$f":"Q21/(1+Q15)^0.5/(1+R15)^0.5","v":0.98638417536075473},{"$f":"R21/(1+R15)^0.5/(1+S15)^0.5","v":0.95970617387708745},{"$f":"S21/(1+S15)^0.5/(1+T15)^0.5","v":0.93374971252042205},{"$f":"T21/(1+T15)^0.5/(1+U15)^0.5","v":0.90849527632989502},{"$f":"U21/(1+U15)^0.5/(1+V15)^0.5","v":0.88392387815132079},null,"Note: this index converts from nominal mid year dollars for each year between 2021-22 to 2030-31 to dollars as at the end of 2025-26 (i.e., Real 2026, 30 June 2026)."]
[null,"Nominal (end year) to Real 2026 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,{"$f":"N22*(1+N15)","v":1.1631990356859641},{"$f":"O22*(1+O15)","v":1.0970785220643235},{"$f":"P22*(1+P15)","v":1.0567680000000002},{"$f":"Q22*(1+Q15)","v":1.032},1,{"$f":"Q22/(1+R15)","v":0.97295374140211632},{"$f":"R22/(1+S15)","v":0.94663898290837623},{"$f":"S22/(1+T15)","v":0.92103594017779866},{"$f":"T22/(1+U15)","v":0.89612536396180498},{"$f":"U22/(1+V15)","v":0.87188852563197139}]
[null,"Labour escalation from 2024","Calculated","Factor",null,null,null,null,null,null,null,null,null,null,1,{"$f":"O23*(1+P16)","v":1.0130764825459533},1.0247739083080478,1.0292116482534519,1.032308971514847,1.0360974788170267,1.0398998896965024,1.0437162551785053]
[]
[]
[null,"Opex forecast sensitivities"]
[]
[null,"Apply real labour escalation?","Yes"]
[]
[]
[null,"Maintenance expenditure"]
[]
[null,"Maintenance plan requirements",null,null,null,"Conversion",null,null,null,null,null,"Defect",null,null,null,null,"Quantities ",null,null,null,null,null,null,{"$f":"\"Rates (Real $\"&F35&\")\"","v":"Rates (Real $2026)"},null,null,null,"Note: unit rates are assumed to be in mid-year dollars"]
[null,"Item","Plan Component","Maintenance Activity",null,"Dollar Year","Escalation Year","Timing","Asset class","Location",null,"Allowance (%)",null,null,null,null,{"$f":"Q$20","v":2026},2027,2028,2029,2030,2031,null,"Code","Labour","Materials"]
[null,"Substations",null,null,null,2026,2027,"End"]
[null,"Requirement 1","Automation","[C-i-C]",null,null,null,null,"Line Protection","Bayswater",null,1.22,null,null,null,null,null,0,0,2,2,2,null,"PARCL1",916.76086148644288,0]
[null,"Requirement 2","Automation","[C-i-C]",null,null,null,null,"Line Protection","Bayswater",null,1.22,null,null,null,null,null,0,0,0,0,0,null,"PDIFR1",3201.6164918427789,41.28]
[null,"Requirement 3","Substations","[C-i-C]",null,null,null,null,"330kV LHCB SF6","Bayswater",null,1.37,null,null,null,null,null,0,0,0,2,0,null,"S0160B",13038.277499732361,25.8]
[null,"Requirement 4","Substations","[C-i-C]",null,null,null,null,"330kV LHCB SF6","Bayswater",null,1.37,null,null,null,null,null,0,0,0,0,0,null,"S0160C",7444.96042910099,25.8]
[null,"Requirement 5","Substations","[C-i-C]",null,null,null,null,"Ancillary Bay Equipment","Bayswater",null,1.37,null,null,null,null,null,0,0,0,2,0,null,"S0900B",5359.879849005034,25.8]
[null,"Requirement 6","Substations","[C-i-C]",null,null,null,null,"CT","Bayswater",null,1.37,null,null,null,null,null,0,0,0,6,0,null,"S0955C",1979.4493536314299,22.704000000000001]
[null,"Requirement 7","Automation","[C-i-C]",null,null,null,null,"Line Protection","Barigan Creek",null,5.79,null,null,null,null,null,0,4,4,4,4,null,"PARCL1",916.76086148644288,0]
[null,"Requirement 8","Automation","[C-i-C]",null,null,null,null,"Line Protection","Barigan Creek",null,5.79,null,null,null,null,null,0,0,8,0,0,null,"PDIFR1",3201.6164918427789,41.28]
[null,"Requirement 9","Automation","[C-i-C]",null,null,null,null,"Disturbance and Fault","Barigan Creek",null,5.79,null,null,null,null,null,0,4,4,4,4,null,"P3454C",254.52610115549072,41.28]
[null,"Requirement 10","Communication","[C-i-C]",null,null,null,null,"Data","Barigan Creek",null,5.79,null,null,null,null,null,0,1,1,1,1,null,"CTG307",613.08065260185617,10.32]
[null,"Requirement 11","Communication","[C-i-C]",null,null,null,null,"Inspections","Barigan Creek",null,5.79,null,null,null,null,null,0,1.5,1.5,1.5,1.5,null,"CTG102",1141.1589501851929,0]
[null,"Requirement 12","Communication","[C-i-C]",null,null,null,null,"OPGW/UGFO","Barigan Creek",null,5.79,null,null,null,null,null,0,2,2,2,2,null,"CFOIN1",1255.12042433173,10.32]
[null,"Requirement 13","Metering","[C-i-C]",null,null,null,null,"CT","Barigan Creek",null,5.79,null,null,null,null,null,0,0,0,0,0,null,"MCTAC1",5207.0591570698725,0]
[null,"Requirement 14","Metering","[C-i-C]",null,null,null,null,"CT","Barigan Creek",null,5.79,null,null,null,null,null,0,0,0,0,0,null,"MCTBRD",588.436541617687,0]
[null,"Requirement 15","Metering","[C-i-C]",null,null,null,null,"Meter","Barigan Creek",null,5.79,null,null,null,null,null,0,0,0,0,0,null,"MCALC1",1420.4422262974244,0]
[null,"Requirement 16","Metering","[C-i-C]",null,null,null,null,"Meter","Barigan Creek",null,5.79,null,null,null,null,null,0,0,8,0,0,null,"MINDC1",1301.1461557774535,0]
[null,"Requirement 17","Metering","[C-i-C]",null,null,null,null,"Meter","Barigan Creek",null,5.79,null,null,null,null,null,0,0,8,0,0,null,"MINSP1",1574.7300405894359,41.28]
[null,"Requirement 18","Metering","[C-i-C]",null,null,null,null,"Meter","Barigan Creek",null,0,null,null,null,null,null,0,8,8,8,8,null,0,0,1403.52]
[null,"Requirement 19","Metering","[C-i-C]",null,null,null,null,0,"Barigan Creek",null,5.79,null,null,null,null,null,0,0,0,0,0,null,"MVTAC3",6720.6511429334878,20681.28]
[null,"Requirement 20","Metering","[C-i-C]",null,null,null,null,0,"Barigan Creek",null,5.79,null,null,null,null,null,0,0,0,0,0,null,"MVTBD1",879.5168236975702,41.28]
[null,"Requirement 21","Automation","[C-i-C]",null,null,null,null,"Software","Barigan Creek",null,0,null,null,null,null,null,0,1,1,1,1,null,0,0,17028]
[null,"Requirement 22","Automation","[C-i-C]",null,null,null,null,"Line Protection","Mount Piper 330kV and Wallerawang 330kV",null,1.22,null,null,null,null,null,0,0,2,2,2,null,"PARCL1",916.76086148644288,0]
[null,"Requirement 23","Automation","[C-i-C]",null,null,null,null,"Line Protection","Mount Piper 330kV and Wallerawang 330kV",null,1.22,null,null,null,null,null,0,0,0,0,0,null,"PDIFR1",3201.6164918427789,41.28]
[null,"Requirement 24","Communication","[C-i-C]",null,null,null,null,"OPGW/UGFO","Mount Piper 330kV and Wallerawang 330kV",null,1.22,null,null,null,null,null,0,0,2,2,2,null,"CFOIN1",1255.1204243317316,10.32]
[null,"Requirement 25","Substations","[C-i-C]",null,null,null,null,"330kV LHCB SF6","Mount Piper 330kV and Wallerawang 330kV",null,1.37,null,null,null,null,null,0,0,0,1,0,null,"S0160B",13038.277499732361,25.8]
[null,"Requirement 26","Substations","[C-i-C]",null,null,null,null,"330kV LHCB SF6","Mount Piper 330kV and Wallerawang 330kV",null,1.37,null,null,null,null,null,0,0,0,0,0,null,"S0160C",7444.96042910099,25.8]
[null,"Requirement 27","Substations","[C-i-C]",null,null,null,null,"Ancillary Bay Equipment","Mount Piper 330kV and Wallerawang 330kV",null,1.37,null,null,null,null,null,0,0,0,4,0,null,"S0900B",5359.879849005034,25.8]
[null,"Requirement 28","Substations","[C-i-C]",null,null,null,null,"CT","Mount Piper 330kV and Wallerawang 330kV",null,1.37,null,null,null,null,null,0,0,0,6,0,null,"S0955C",1979.4493536314299,22.704000000000001]
[null,"Requirement 29"]
[null,"Transmission Lines"]
[null,"Requirement 1","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,1,1,1,null,"TAERIM",1363.8539025018947,5799.84]
[null,"Requirement 2","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,2,0,null,"TCCT10",721.72397313984573,5113.5600000000004]
[null,"Requirement 3","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,2,0,null,"TCI001",235.99809786634631,167.184]
[null,"Requirement 4","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,1,0,null,"TEI025",1746.7482393317318,2064]
[null,"Requirement 5","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,0.4,0,null,"TEM025",5919.9420736423699,51600]
[null,"Requirement 6","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,1,1,1,null,"TLIDR",235.99809786634631,6398.4000000000005]
[null,"Requirement 7","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,0,0,null,"TETEST",1310.3450346647219,0]
[null,"Requirement 8","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Baywater to Liddell",null,1.68,null,null,null,null,null,0,0,0,1,0,null,"TTHERM",612.63557453844726,3096]
[null,"Requirement 9","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,1,1,1,null,"TAERIM",1363.8539025018947,5799.84]
[null,"Requirement 10","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,3,0,null,"TCCT10",721.72397313984573,5113.5600000000004]
[null,"Requirement 11","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,4,0,null,"TCI001",235.99809786634631,167.184]
[null,"Requirement 12","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,1.2,0,null,"TEI025",1746.7482393317318,2064]
[null,"Requirement 13","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,1,0,null,"TEM050",5919.9420736423699,61920]
[null,"Requirement 14","Easements & Access Tracks","[C-i-C]",null,null,null,null,"Easements & Access Tracks","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,1,1,1,null,"TLIDR",235.99809786634631,6398.4000000000005]
[null,"Requirement 15","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,0,0,null,"TETEST",1310.3450346647219,0]
[null,"Requirement 16","Transmission Lines","[C-i-C]",null,null,null,null,"Transmission Lines","Mount Piper 330kV to Wallerawang 330kV",null,1.68,null,null,null,null,null,0,0,0,1,0,null,"TTHERM",612.63557453844726,3096]
[null,"Requirement 17"]
[]
[]
[]
[null,"Operating costs"]
[]
[null,"Direct costs",null,null,null,"Conversion",null,null,"Material rate","Hourly rate",null,"Hours per year",null,null,null,null,"Headcount Forecast (FTEs)",null,null,null,null,null,null,"Material (Number)"]
[null,"Item","Resource Description","Units",null,"Dollar Year","Escalation Year","Timing",null,"$ per hour per FTE",null,"Hours",null,null,null,null,{"$f":"Q$14","v":2026},2027,2028,2029,2030,2031,null,{"$f":"Q89","v":2026},2027,2028,2029,2030,2031]
[null,"Commercial",null,null,null,null,null,null,null,"Note: Includes on-costs and support costs",null,{"$f":"(7*5*48)*0+1800","v":1800},"Operating Costs",null,null,null,null,null,"Note: salaries are assumed to be in mid-year dollars"]
[null,"Network Commercial","Group Manager (Emerging Major Projects)","Various",null,2026,{"$f":"F91+1","v":2027},"End",null,491.02,null,1800,"Other Costs",null,null,null,null,0,0,0.28401315789473686,0.28401315789473686,0.28401315789473686]
[null,"Network Commercial","Level 4 ID Manager (Emerging Projects)","Various",null,2026,{"$f":"F92+1","v":2027},"End",null,353.83,null,null,null,null,null,null,null,0,2.6836622807017544E-2,0.60789473684210527,0.60789473684210527,0.60789473684210527]
[null,"Network Commercial","Network Planning – Senior (Emerging Projects)","Various",null,2026,{"$f":"F93+1","v":2027},"End",null,353.83,null,null,null,null,null,null,null,0,8.162828947368421E-2,0.97953947368421057,0.97953947368421057,0.97953947368421057]
[null,"Network Commercial","Project Manager - Senior (Emerging Major Projects)","Various",null,2026,{"$f":"F94+1","v":2027},"End",null,307.27999999999997,null,null,null,null,null,null,null,0,0.13161282679920461,1.5527015399999999,1.5499359450000001,1.5471804600000001]
[null,"Network Commercial","Legal Gov & Risk - Senior (Legal Affairs)","Various",null,2026,{"$f":"F95+1","v":2027},"End",null,316.45,null,null,null,null,null,null,null,0,2.4046052631578947E-2,0.28855263157894739,0.28855263157894739,0.28855263157894739]
[null,"Asset Management"]
[null,"Asset Strategist - Asset creation and acceptance, manage interface with ACEREZ amd EnCo under project agreement, interface deed, and line crossing deed. Ongoing asset strategies, maintenance planning, monitoring and reporting.","Asset Manager - Senior (Substation Assets)","Various",null,2026,{"$f":"F97+1","v":2027},"End",null,300.33999999999997,null,null,null,null,null,null,null,0,0.5,1,1,1]
[null,null,null,"Various"]
[null,"Delivery"]
[null,"Delivery","Maintenance works management and planning","Various",null,2026,{"$f":"F100+1","v":2027},"End",null,344.43,null,null,null,null,null,null,null,0,0.15,0.3,0.3,0.3]
[null,"Delivery Maintenance","Travel for Barrigan creek - non standard","Various",null,2026,2027,"End",20640,0,null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,1,4,1,1]
[null,"Delivery Maintenance","Increase in cost for thermography","Various",null,2026,2027,"End",10320,0,null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,0,0,1,0]
[null,"Delivery Property","Property Maintenance","Various",null,2026,2027,"End",null,199.99,null,null,null,null,null,null,null,0,1.6664999999999999E-2,0.05,0.05,0.05]
[null,"Delivery Property","Property Maintenance","Various",null,2026,2027,"End",null,199.99,null,null,null,null,null,null,null,0,1.6664999999999999E-2,0.05,0.05,0.05]
[null,"Delivery Property","Property Maintenance",null,null,2026,2027,"End",null,293.18,null,null,null,null,null,null,null,0,1.6664999999999999E-2,0.05,0.05,0.05]
[null,"Delivery","Easements & Access Tracks","Various",null,2026,2027,"End",10320,0,null,null,null,null,null,null,null,0,0,0,0,0,null,0,0,1,1,1,1]
[null,"Network Planning"]
[null,"Network Planning","Team lead - REZ planning and intergration","Various",null,2026,{"$f":"F108+1","v":2027},"End",null,491.02,null,null,null,null,null,null,null,0,0.1,0.2,0.2,0.2]
[null,"Network Planning","System Planning","Various",null,2026,2027,"End",null,307.27999999999997,null,null,null,null,null,null,null,0,0.128,0.25600000000000001,0.25600000000000001,0.25600000000000001]
[null,"Network Planning","System Planning","Various",null,2026,2027,"End",null,232.19,null,null,null,null,null,null,null,0,7.1999999999999995E-2,0.14399999999999999,0.14399999999999999,0.14399999999999999]
[null,"Network Planning","Network Analysis (modelling and analysis)","Various",null,2026,2027,"End",null,307.27999999999997,null,null,null,null,null,null,null,0,0.2,0.4,0.4,0.4]
[null,"Network Planning","Network Connections","Various",null,2026,2027,"End",null,307.27999999999997,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"Network Planning","Network Strategy and Development","Various",null,2026,2027,"End",null,307.27999999999997,null,null,null,null,null,null,null,0,6.0000000000000001E-3,1.2E-2,1.2E-2,1.2E-2]
[null,"Network Operations"]
[null,"Network Operations","Operate - monitoring, ongoing managmenet of events and alarms, uplift in control room capacity","Various",null,2026,{"$f":"F115+1","v":2027},"End",null,344.43,null,null,null,null,null,null,null,0,0.19350000000000001,0.38700000000000001,0.38700000000000001,0.38700000000000001]
[null,"Network Operations","Ouage - customer and interface management, coordination, and change management","Various",null,2026,2027,"End",null,344.43,null,null,null,null,null,null,null,0,0.2145,0.42899999999999999,0.42899999999999999,0.42899999999999999]
[null,"Network Operations","Analysis - contraint verification, outage constraints, outage contingencies, operating information, manage electrical models for State Estimator","Various",null,2026,2027,"End",null,344.43,null,null,null,null,null,null,null,0,0.17099999999999999,0.34199999999999997,0.34199999999999997,0.34199999999999997]
[null,"Network Operations","Assets: monitoring, defects, emergency response, reporting","Various",null,2026,2027,"End",null,344.43,null,null,null,null,null,null,null,0,0.16200000000000001,0.32400000000000001,0.32400000000000001,0.32400000000000001]
[null,"Network Operations","SCADA: Additional SCADA data points for REZ, manage SCADA mapping and pictures, additional interfaces, and DTS/simulator modelling","Various",null,2026,2027,"End",null,195.19,null,null,null,null,null,null,null,0,0.26400000000000001,0.52800000000000002,0.52800000000000002,0.52800000000000002]
[null,"Network Operations","Leasing of new control room space","Various",null,2026,2027,"End",1878.24,0,null,null,null,null,null,null,null,0,0,0,0,0,null,{"$f":"Q120","v":0},0,0,0,0,0]
[null,"Finance & Audit"]
[null,"Finance and Audit","Exernal Audit fees","Various",null,2026,2027,"End",433440,0,null,null,null,null,null,null,null,0,0,0,0,0,null,null,0,1,1,1,1]
[null,"Finance and Audit","Annual reporting","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0.05,0.05,0.05,0.05]
[null,"Finance and Audit","Annual reporting","Various",null,2026,2027,"End",null,321.14999999999998,null,null,null,null,null,null,null,0,0.1,0.1,0.1,0.1]
[null,"Finance and Audit","SBP payment processing","Various",null,2026,2027,"End",null,185.15,null,null,null,null,null,null,null,0,0.05,0.05,0.05,0.05]
[null,"Regulatory submissions"]
[null,"Annual payments updates - Regulation","Group Manager (Reg Policy)","Various",null,2026,{"$f":"F127+1","v":2027},"End",null,491.02,null,null,null,null,null,null,null,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2]
[null,"Annual payments updates - Regulation","Legal Gov & Risk - Senior (Regulatory & Policy)","Various",null,2026,{"$f":"F128+1","v":2027},{"$f":"H127","v":"End"},null,316.45,null,null,null,null,null,null,null,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666,0.16666666666666666]
[null,"Annual payments updates - Network Commercial","Group Manager (Emerging Major Projects)","Various",null,2026,{"$f":"F129+1","v":2027},{"$f":"H128","v":"End"},null,491.02,null,null,null,null,null,null,null,9.2105263157894728E-3,9.2105263157894728E-3,9.2105263157894728E-3,9.2105263157894728E-3,9.2105263157894728E-3]
[null,"Annual payments updates - Network Commercial","Level 4 ID Manager (Emerging Projects)","Various",null,2026,{"$f":"F130+1","v":2027},"End",null,353.83,null,null,null,null,null,null,null,1.8421052631578946E-2,1.8421052631578946E-2,1.8421052631578946E-2,1.8421052631578946E-2,1.8421052631578946E-2]
[null,"Annual payments updates - Network Commercial","Network Planning – Senior (Emerging Projects)","Various",null,2026,{"$f":"F131+1","v":2027},"End",null,353.83,null,null,null,null,null,null,null,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2]
[null,"Annual payments updates - Network Commercial","Project Manager - Senior (Emerging Major Projects)","Various",null,2026,{"$f":"F132+1","v":2027},"End",null,307.27999999999997,null,null,null,null,null,null,null,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2,9.2105263157894732E-2]
[null,"Annual payments updates - Finance","Group Manager Corporate Finance and Strategy","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05]
[null,"Annual payments updates - Finance","Corporate Finance Director","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05]
[null,"Annual payments updates - Finance","Corporate Finance Senior Associate","Various",null,2026,2027,"End",null,321.14999999999998,null,null,null,null,null,null,null,0.1,0.1,0.1,0.1,0.1]
[null,"Annual payments updates - Finance","Group Manager Finance Network","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0.02,0.02,0.02,0.02,0.02]
[null,"Annual payments updates - Finance","Senior Finance Business Partner","Various",null,2026,2027,"End",null,321.14999999999998,null,null,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05]
[null,"RP2 For CWOREZ - Regulation","Group Manager (Reg Policy)","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0,0,0.33333333333333331,8.3333333333333329E-2]
[null,"RP2 For CWOREZ - Regulation","Legal Gov & Risk - Senior (Regulatory & Policy)","Various",null,2026,2027,"End",null,316.45,null,null,null,null,null,null,null,0,0,0,0.33333333333333331,0.16666666666666666]
[null,"RP2 For CWOREZ - Regulation","Legal Gov & Risk - Senior (Regulatory & Policy)","Various",null,2026,2027,"End",null,316.45,null,null,null,null,null,null,null,0,0,0,0.33333333333333331,0.16666666666666666]
[null,"RP2 For CWOREZ - Regulation","Corporate & Reg Affairs Officer (GovtStakeholder&Adv)","Various",null,2026,2027,"End",null,169.9,null,null,null,null,null,null,null,0,0,0,0.16666666666666666,8.3333333333333329E-2]
[null,"RP2 For CWOREZ - Network Commercial","Group Manager (Emerging Major Projects)","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0,0,2.763157894736842E-2,1.8421052631578946E-2]
[null,"RP2 For CWOREZ - Network Commercial","Level 4 ID Manager (Emerging Projects)","Various",null,2026,2027,"End",null,353.83,null,null,null,null,null,null,null,0,0,0,0.16578947368421051,0.11052631578947368]
[null,"RP2 For CWOREZ - Network Commercial","Network Planning – Senior (Emerging Projects)","Various",null,2026,2027,"End",null,353.83,null,null,null,null,null,null,null,0,0,0,0.27631578947368424,0.18421052631578946]
[null,"RP2 For CWOREZ - Network Commercial","Project Manager - Senior (Emerging Major Projects)","Various",null,2026,2027,"End",null,307.27999999999997,null,null,null,null,null,null,null,0,0,0,0.27631578947368424,0.18421052631578946]
[null,"RP2 For CWOREZ - Finance","Group Manager Corporate Finance and Strategy","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0,0,0.05,0.05]
[null,"RP2 For CWOREZ - Finance","Corporate Finance Director","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0,0,0.05,0.05]
[null,"RP2 For CWOREZ - Finance","Corporate Finance Senior Associate","Various",null,2026,2027,"End",null,321.14999999999998,null,null,null,null,null,null,null,0,0,0,0.1,0.1]
[null,"RP2 For CWOREZ - Finance","Group Manager Finance Network","Various",null,2026,2027,"End",null,491.02,null,null,null,null,null,null,null,0,0,0,0.02,0.02]
[null,"RP2 For CWOREZ - Finance","Senior Finance Business Partner","Various",null,2026,2027,"End",null,321.14999999999998,null,null,null,null,null,null,null,0,0,0,0.05,0.05]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour costs",null,null,{"$f":"SUMPRODUCT($J$90:$J$150,Q$90:Q$150)*$L$90","v":0},490836.75157894741,2004534.1589344731,5394438.2901327908,6769828.7905811723,6179048.2734373137,null,{"$f":"SUMPRODUCT($I$90:$I$150,X$90:X$150)","v":0},0,464400,526320,474720,464400,null,"Note: this is the total cost excluding labour escalation and inflation"]
[]
[null,"Insurance costs"]
[]
[]
[null,{"$f":"B154","v":"Insurance costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F159&\", \"&G159&\" year)\"","v":"Cost (As Incurred) (Real $2026, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year","Timing",null,null,null,null,null,null,null,null,null,{"$f":"Q$20","v":2026},2027,2028,2029,2030,2031]
[null,"Annual Insurance Premium - Original Scope of Works","Locktons","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,0,315270.52099999995,315270.52099999995,315270.52099999995,315270.52099999995,null,"Note: Premium is payable at commissioning, in 2026-27"]
[null,"Annual Insurance Premium - BCSS","Locktons","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,"Legal Gov & Risk - Senior (Legal Affairs)","TransGrid","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,0,0,0,47467.5,0]
[null,"Prepare insurance premium cost estimate","Locktons","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,0,0,0,10039.362500000001,0]
[]
[null,"Strategic Benefits Payments"]
[]
[]
[null,{"$f":"B164","v":"Strategic Benefits Payments"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $)\"","v":"Cost (As Incurred) (Real $)"}]
[null,"Item","Source","Units",null,"Dollar Year","Timing",null,null,null,null,null,null,null,null,null,{"$f":"Q$20","v":2026},2027,2028,2029,2030,2031]
[null,"Annual payments to landholders","TransGrid / Calculated","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,"[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,"Administering the payments","TransGrid / Calculated","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,"[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[]
[null,"Vegetation Integrity Rehabilitation Costs"]
[]
[]
[null,{"$f":"B172","v":"Vegetation Integrity Rehabilitation Costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $)\"","v":"Cost (As Incurred) (Real $)"}]
[null,"Item","Source","Units",null,"Dollar Year","Timing",null,null,null,null,null,null,null,null,null,{"$f":"Q$20","v":2026},2027,2028,2029,2030,2031]
[null,"Labour","TransGrid / Calculated","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,"[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,"Contracted Labour","TransGrid / Calculated","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,"[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[]
[null,"Debt raising costs"]
[]
[]
[null,{"$f":"B180","v":"Debt raising costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F185&\", \"&G185&\" year)\"","v":"Cost (As Incurred) (Real $2026, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year","Timing",null,null,null,null,null,null,null,null,null,{"$f":"Q$20","v":2026},2027,2028,2029,2030,2031]
[null,"Debt raising cost allowance","PTRM","$Dollars",null,2026,"End",null,null,null,null,null,null,null,null,null,null,83350.438479535063,156184.87166244979,210492.49951108251,208461.83577747064,202177.77148943901]
[]
[]
[null,"End"]

{"sheet":"Calculations","index":3,"n_rows":97,"n_cols":11,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Calculations"]
[]
[null,{"$f":"Inputs!$B$31","v":"Maintenance expenditure"},null,null,null,null,null,null,null,null,"Total"]
[null,"Activity","Dollar basis","Units",{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031}]
[]
[null,{"$f":"Inputs!B35","v":"Substations"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(Inputs!Q$36:Q$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!R$36:R$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!S$36:S$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":64642.210806582603},{"$f":"SUM(Inputs!T$36:T$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":408485.18476416427},{"$f":"SUM(Inputs!U$36:U$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":303570.96603384166},{"$f":"SUM(Inputs!V$36:V$64*Inputs!$Y$36:$Y$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":78355.781940615096},{"$f":"SUM(E7:J7)","v":855054.14354520361}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E7*(Inputs!Q$23-1)","v":0},{"$f":"F7*(Inputs!R$23-1)","v":0},{"$f":"G7*(Inputs!S$23-1)","v":2088.5233476066132},{"$f":"H7*(Inputs!T$23-1)","v":14745.285304093673},{"$f":"I7*(Inputs!U$23-1)","v":12112.448059810951},{"$f":"J7*(Inputs!V$23-1)","v":3425.4213580272472},{"$f":"SUM(E8:J8)","v":32371.678069538488}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(Inputs!Q$36:Q$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!R$36:R$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!S$36:S$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":29587.5432},{"$f":"SUM(Inputs!T$36:T$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":34118.023200000003},{"$f":"SUM(Inputs!U$36:U$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":30829.379760000003},{"$f":"SUM(Inputs!V$36:V$64*Inputs!$Z$36:$Z$64*(1+Inputs!$L$36:$L$64))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":29633.364000000001},{"$f":"SUM(E9:J9)","v":124168.31016000001}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E7:E9)","v":0},0,96318.277354189209,457348.49326825794,346512.79385365261,111414.56729864235,1011594.131774742]
[]
[null,{"$f":"Inputs!B65","v":"Transmission Lines"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(Inputs!Q$66:Q$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!R$66:R$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!S$66:S$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!T$66:T$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":8575.206721973771},{"$f":"SUM(Inputs!U$66:U$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":57835.334334670682},{"$f":"SUM(Inputs!V$66:V$82*Inputs!$Y$66:$Y$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":8575.206721973771},{"$f":"SUM(E13:J13)","v":74985.747778618213}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E13*(Inputs!Q$23-1)","v":0},{"$f":"F13*(Inputs!R$23-1)","v":0},{"$f":"G13*(Inputs!S$23-1)","v":0},{"$f":"H13*(Inputs!T$23-1)","v":309.54334299807351},{"$f":"I13*(Inputs!U$23-1)","v":2307.623460513697},{"$f":"J13*(Inputs!V$23-1)","v":374.87592526623934},{"$f":"SUM(E14:J14)","v":2992.0427287780099}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(Inputs!Q$66:Q$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!R$66:R$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!S$66:S$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(Inputs!T$66:T$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":65382.566399999996},{"$f":"SUM(Inputs!U$66:U$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":386617.29311999993},{"$f":"SUM(Inputs!V$66:V$82*Inputs!$Z$66:$Z$82*(1+Inputs!$L$66:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))","v":65382.566399999996},{"$f":"SUM(E15:J15)","v":517382.42591999995}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E13:E15)","v":0},0,0,74267.316464971838,446760.25091518433,74332.649047240004,595360.21642739617]
[]
[]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E7+E13","v":0},0,64642.210806582603,417060.39148613805,{"$f":"I7+I13","v":361406.30036851234},86930.988662588861,{"$f":"SUM(E19:J19)","v":930039.89132382185}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,0,2088.5233476066132,15054.828647091746,14420.071520324647,3800.2972832934865,{"$f":"SUM(E20:J20)","v":35363.720798316492}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,0,29587.5432,99500.589600000007,417446.67287999991,95015.930399999997,{"$f":"SUM(E21:J21)","v":641550.73607999983}]
[null,"Total maintenance costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E19:E21)","v":0},0,96318.277354189209,531615.80973322981,793273.04476883681,185747.21634588233,1606954.3482021382]
[]
[{"$f":"IF(SUM(E24:J24)=0,0,1)","v":0},"Check - Labour",null,null,{"$f":"IF(ROUND(SUMPRODUCT(Inputs!Q36:Q82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-E19,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!R36:R82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-F19,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!S36:S82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-G19,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!T36:T82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-H19,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!U36:U82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-I19,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!V36:V82,Inputs!$Y36:$Y82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-J19,3)=0,0,1)","v":0}]
[{"$f":"IF(SUM(E25:J25)=0,0,1)","v":0},"Check - Materials",null,null,{"$f":"IF(ROUND(SUMPRODUCT(Inputs!Q36:Q82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-E21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!R36:R82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-F21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!S36:S82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-G21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!T36:T82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-H21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!U36:U82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-I21,3)=0,0,1)","v":0},{"$f":"IF(ROUND(SUMPRODUCT(Inputs!V36:V82,Inputs!$Z36:$Z82,(1+Inputs!$L$36:$L$82))*INDEX(IF(Inputs!$H$35=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$35,Inputs!$N$20:$V$20,0))-J21,3)=0,0,1)","v":0}]
[]
[null,{"$f":"Inputs!$B$86","v":"Operating costs"},null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031}]
[]
[null,{"$f":"Inputs!B96","v":"Asset Management"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!Q$97:Q$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!R$97:R$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!S$97:S$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":270306},{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!T$97:T$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":540612},{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!U$97:U$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":540612},{"$f":"SUMPRODUCT(Inputs!$J$97:$J$98,Inputs!V$97:V$98)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":540612},{"$f":"SUM(E31:J31)","v":1892142}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E31*(Inputs!Q$23-1)","v":0},{"$f":"F31*(Inputs!R$23-1)","v":0},{"$f":"G31*(Inputs!S$23-1)","v":8733.3088542922378},{"$f":"H31*(Inputs!T$23-1)","v":19514.730218230459},{"$f":"I31*(Inputs!U$23-1)","v":21570.359168605544},{"$f":"J31*(Inputs!V$23-1)","v":23633.532144562108},{"$f":"SUM(E32:J32)","v":73451.930385690357}]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,0,0,0,0,0,{"$f":"SUM(E33:J33)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E31:E33)","v":0},0,279039.30885429226,{"$f":"SUM(H31:H33)","v":560126.73021823051},{"$f":"SUM(I31:I33)","v":562182.35916860553},{"$f":"SUM(J31:J33)","v":564245.53214456211},1965593.9303856904]
[]
[null,{"$f":"Inputs!B99","v":"Delivery"}]
[null,{"$f":"$B$31","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!Q$100:Q$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!R$100:R$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!S$100:S$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":113788.82051999999},{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!T$100:T$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":248376.59999999998},{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!U$100:U$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":248376.59999999998},{"$f":"SUMPRODUCT(Inputs!$J$100:$J$106,Inputs!V$100:V$106)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":248376.59999999998},{"$f":"SUM(E37:J37)","v":858918.62052}]
[null,{"$f":"$B$32","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E37*(Inputs!Q$23-1)","v":0},{"$f":"F37*(Inputs!R$23-1)","v":0},{"$f":"G37*(Inputs!S$23-1)","v":3676.3997608887198},{"$f":"H37*(Inputs!T$23-1)","v":8965.7690571451221},{"$f":"I37*(Inputs!U$23-1)","v":9910.1989431922921},{"$f":"J37*(Inputs!V$23-1)","v":10858.09482596954},{"$f":"SUM(E38:J38)","v":33410.462587195674}]
[null,{"$f":"$B$33","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!X$100:X$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!Y$100:Y$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!Z$100:Z$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":30960},{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!AA$100:AA$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":92880},{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!AB$100:AB$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":41280},{"$f":"SUMPRODUCT(Inputs!$I$100:$I$106,Inputs!AC$100:AC$106)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":30960},{"$f":"SUM(E39:J39)","v":196080}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E37:E39)","v":0},0,148425.22028088872,350222.36905714509,299566.79894319223,290194.69482596952,1088409.0831071958]
[]
[null,{"$f":"Inputs!B107","v":"Network Planning"}]
[null,{"$f":"$B$31","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!Q$108:Q$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!R$108:R$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!S$108:S$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":303212.15999999997},{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!T$108:T$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":606424.31999999995},{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!U$108:U$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":606424.31999999995},{"$f":"SUMPRODUCT(Inputs!$J$108:$J$113,Inputs!V$108:V$113)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":606424.31999999995},{"$f":"SUM(E43:J43)","v":2122485.1199999996}]
[null,{"$f":"$B$32","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E43*(Inputs!Q$23-1)","v":0},{"$f":"F43*(Inputs!R$23-1)","v":0},{"$f":"G43*(Inputs!S$23-1)","v":9796.4730403952362},{"$f":"H43*(Inputs!T$23-1)","v":21890.389045329845},{"$f":"I43*(Inputs!U$23-1)","v":24196.263477276458},{"$f":"J43*(Inputs!V$23-1)","v":26510.600319571557},{"$f":"SUM(E44:J44)","v":82393.725882573097}]
[null,{"$f":"$B$33","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,0,0,0,0,0,{"$f":"SUM(E45:J45)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E43:E45)","v":0},0,313008.63304039522,628314.70904532983,630620.58347727638,632934.92031957151,2204878.8458825727]
[]
[null,{"$f":"Inputs!B114","v":"Network Operations"}]
[null,{"$f":"$B$31","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!Q$115:Q$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!R$115:R$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!S$115:S$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":552155.022},{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!T$115:T$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":1104310.044},{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!U$115:U$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":1104310.044},{"$f":"SUMPRODUCT(Inputs!$J$115:$J$120,Inputs!V$115:V$120)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":1104310.044},{"$f":"SUM(E49:J49)","v":3865085.1540000001}]
[null,{"$f":"$B$32","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E49*(Inputs!Q$23-1)","v":0},{"$f":"F49*(Inputs!R$23-1)","v":0},{"$f":"G49*(Inputs!S$23-1)","v":17839.560877577729},{"$f":"H49*(Inputs!T$23-1)","v":39862.80842071987},{"$f":"I49*(Inputs!U$23-1)","v":44061.848946339684},{"$f":"J49*(Inputs!V$23-1)","v":48276.299679690419},{"$f":"SUM(E50:J50)","v":150040.51792432769}]
[null,{"$f":"$B$33","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!X$115:X$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!Y$115:Y$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!Z$115:Z$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!AA$115:AA$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!AB$115:AB$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$115:$I$120,Inputs!AC$115:AC$120)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUM(E51:J51)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E49:E51)","v":0},0,569994.58287757775,1144172.8524207198,1148371.8929463397,1152586.3436796905,4015125.671924328]
[]
[null,{"$f":"Inputs!B121","v":"Finance & Audit"}]
[null,{"$f":"$B$31","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!Q$122:Q$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!R$122:R$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!S$122:S$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":118662.3},{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!T$122:T$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":118662.3},{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!U$122:U$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":118662.3},{"$f":"SUMPRODUCT(Inputs!$J$122:$J$125,Inputs!V$122:V$125)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":118662.3},{"$f":"SUM(E55:J55)","v":474649.2}]
[null,{"$f":"$B$32","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E55*(Inputs!Q$23-1)","v":0},{"$f":"F55*(Inputs!R$23-1)","v":0},{"$f":"G55*(Inputs!S$23-1)","v":3833.8568705862313},{"$f":"H55*(Inputs!T$23-1)","v":4283.409860629672},{"$f":"I55*(Inputs!U$23-1)","v":4734.6126811332742},{"$f":"J55*(Inputs!V$23-1)","v":5187.4713868683502},{"$f":"SUM(E56:J56)","v":18039.350799217529}]
[null,{"$f":"$B$33","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!X$122:X$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!Y$122:Y$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!Z$122:Z$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":433440},{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!AA$122:AA$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":433440},{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!AB$122:AB$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":433440},{"$f":"SUMPRODUCT(Inputs!$I$122:$I$125,Inputs!AC$122:AC$125)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":433440},{"$f":"SUM(E57:J57)","v":1733760}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E55:E57)","v":0},0,555936.15687058622,556385.70986062963,556836.91268113325,557289.77138686832,2226448.5507992175]
[]
[null,"Commercial and Regulatory submissions"]
[null,"Labour - Commercial",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!Q$91:Q$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!R$91:R$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!S$91:S$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":155573.1048355262},{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!T$91:T$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":2285216.2745538438},{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!U$91:U$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":2283686.6128969644},{"$f":"SUMPRODUCT(Inputs!$J$91:$J$95,Inputs!V$91:V$95)*Inputs!$L$90*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$91,Inputs!$N$20:$T$20,0))","v":2282162.5431215242},{"$f":"SUM(E61:J61)","v":7006638.535407858}]
[null,"Labour - Regulatory Submissions",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!Q$127:Q$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!R$127:R$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":490836.75157894741},{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!S$127:S$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":490836.75157894741},{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!T$127:T$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":490836.75157894741},{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!U$127:U$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":1867756.9136842105},{"$f":"SUMPRODUCT(Inputs!$J$127:$J$150,Inputs!V$127:V$150)*Inputs!$L$91*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0))","v":1278500.4663157896},{"$f":"SUM(E62:J62)","v":4618767.6347368415}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E61:E62)*(Inputs!Q$23-1)","v":0},{"$f":"SUM(F61:F62)*(Inputs!R$23-1)","v":14338.150536991167},{"$f":"SUM(G61:G62)*(Inputs!S$23-1)","v":20884.837637811579},{"$f":"SUM(H61:H62)*(Inputs!T$23-1)","v":100208.51530577142},{"$f":"SUM(I61:I62)*(Inputs!U$23-1)","v":165642.13879184771},{"$f":"SUM(J61:J62)*(Inputs!V$23-1)","v":155658.85272522626},{"$f":"SUM(E63:J63)","v":456732.49499764811}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E61:E63)","v":0},505174.9021159386,667294.69405228517,2876261.5414385628,4317085.6653730227,3716321.8621625402,{"$f":"SUM(E64:J64)","v":12082138.66514235}]
[]
[null,{"$f":"$B$31","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E31+E37+E43+E49+E55+E61+E62","v":0},490836.75157894741,2004534.158934474,5394438.2901327908,6769828.7905811751,6179048.2734373137,{"$f":"SUM(E66:J66)","v":20838686.264664702}]
[null,{"$f":"$B$32","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E32+E38+E44+E50+E56+E63","v":0},14338.150536991167,64764.437041551741,194725.6219078264,270115.42200839496,270124.85108188825,{"$f":"SUM(E67:J67)","v":814068.48257665243}]
[null,{"$f":"$B$33","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E33+E39+E45+E51+E57","v":0},0,464400,526320,474720,464400,{"$f":"SUM(E68:J68)","v":1929840}]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E66:E68)","v":0},505174.9021159386,2533698.5959760258,{"$f":"SUM(H66:H68)","v":6115483.9120406173},{"$f":"SUM(I66:I68)","v":7514664.2125895703},{"$f":"SUM(J66:J68)","v":6913573.1245192019},23582594.747241355]
[]
[{"$f":"IF(SUM(E71:J71)=0,0,1)","v":0},"Check - Operating Costs",null,null,{"$f":"IF(ROUND(((Inputs!Q152+Inputs!X152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(E66+E68),3)=0,0,1)","v":0},{"$f":"IF(ROUND(((Inputs!R152+Inputs!Y152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(F66+F68),3)=0,0,1)","v":0},{"$f":"IF(ROUND(((Inputs!S152+Inputs!Z152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(G66+G68),3)=0,0,1)","v":0},{"$f":"IF(ROUND(((Inputs!T152+Inputs!AA152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(H66+H68),3)=0,0,1)","v":0},{"$f":"IF(ROUND(((Inputs!U152+Inputs!AB152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(I66+I68),3)=0,0,1)","v":0},{"$f":"IF(ROUND(((Inputs!V152+Inputs!AC152)*INDEX(IF(Inputs!$H$91=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$91,Inputs!$N$20:$V$20,0)))-(J66+J68),3)=0,0,1)","v":0}]
[]
[null,"Other Costs",null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031}]
[null,"Insurance costs"]
[null,{"$f":"Inputs!B159","v":"Annual Insurance Premium - Original Scope of Works"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"Inputs!Q159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!R159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!S159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":315270.52099999995},{"$f":"Inputs!T159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":315270.52099999995},{"$f":"Inputs!U159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":315270.52099999995},{"$f":"Inputs!V159*INDEX(IF(Inputs!$G159=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F159,Inputs!$M$20:$V$20,0))","v":315270.52099999995},{"$f":"SUM(E76:J76)","v":1261082.0839999998}]
[null,{"$f":"Inputs!B160","v":"Annual Insurance Premium - BCSS"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"Inputs!Q160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!R160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!S160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!T160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!U160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!V160*INDEX(IF(Inputs!$G160=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F160,Inputs!$M$20:$V$20,0))","v":0},{"$f":"SUM(E77:J77)","v":0}]
[null,{"$f":"Inputs!B161","v":"Legal Gov & Risk - Senior (Legal Affairs)"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"Inputs!Q161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!R161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!S161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!T161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!U161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":47467.5},{"$f":"Inputs!V161*INDEX(IF(Inputs!$G161=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F161,Inputs!$M$20:$V$20,0))","v":0},{"$f":"SUM(E78:J78)","v":47467.5}]
[null,{"$f":"Inputs!B162","v":"Prepare insurance premium cost estimate"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"Inputs!Q162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!R162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!S162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!T162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":0},{"$f":"Inputs!U162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":10039.362500000001},{"$f":"Inputs!V162*INDEX(IF(Inputs!$G162=\"Mid\",Inputs!$M$21:$V$21,Inputs!$M$22:$V$22),MATCH(Inputs!$F162,Inputs!$M$20:$V$20,0))","v":0},{"$f":"SUM(E79:J79)","v":10039.362500000001}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"SUM(E76:E79)","v":0},0,315270.52099999995,315270.52099999995,372777.38349999994,315270.52099999995,{"$f":"SUM(E80:J80)","v":1318588.9464999998}]
[null,"Strategic Benefits Payments"]
[null,{"$f":"Inputs!B169","v":"Annual payments to landholders"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,{"$f":"Inputs!B170","v":"Administering the payments"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,0,68233.673227507272,204707.41562252183,204707.41562252183,204707.41562252183,682355.92009507283]
[null,"Vegetation Integrity Rehabilitation Costs"]
[null,{"$f":"Inputs!B177","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,{"$f":"Inputs!B178","v":"Contracted Labour"},{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]","[C-i-C]"]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",0,142670.95317943569,142916.13295255514,143216.02588668547,143517.01940852954,143819.11755717322,716139.24898437911]
[]
[null,"Total costs (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E22+E69+E80+E84+E89","v":0},{"$f":"F22+F69+F80+F84+F89","v":647845.85529537429},3156437.2005102769,7310293.6842830544,9028939.0758894589,7763117.3950447794,27906633.211022943]
[]
[null,"Debt raising costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"Inputs!Q$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":0},{"$f":"Inputs!R$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":83350.438479535063},{"$f":"Inputs!S$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":156184.87166244979},{"$f":"Inputs!T$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":210492.49951108251},{"$f":"Inputs!U$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":208461.83577747064},{"$f":"Inputs!V$185*INDEX(IF(Inputs!$G$185=\"Mid\",Inputs!$N$21:$V$21,Inputs!$N$22:$V$22),MATCH(Inputs!$F$185,Inputs!$N$20:$V$20,0))","v":202177.77148943901},{"$f":"SUM(E93:J93)","v":860667.41691997694}]
[]
[null,"Total costs (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2026"},"Dollars",{"$f":"E91+E93","v":0},731196.29377490934,3312622.0721727265,7520786.1837941371,9237400.9116669297,7965295.166534218,{"$f":"SUM(E95:J95)","v":28767300.627942923}]
[]
[null,"End"]

{"sheet":"Outputs","index":4,"n_rows":121,"n_cols":18,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
["Outputs"]
[]
[null,"PTRM and Proposal"]
[]
[null,"Operating Costs",null,null,null,null,null,null,null,null,"Total","Total"]
[null,"Component","Dollar basis","Units",{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031},"Next period","All years"]
[]
[null,"Costs"]
[null,"Maintenance costs (excl labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E22-Calculations!E20)/10^6","v":0},{"$f":"(Calculations!F22-Calculations!F20)/10^6","v":0},{"$f":"(Calculations!G22-Calculations!G20)/10^6","v":9.4229754006582608E-2},{"$f":"(Calculations!H22-Calculations!H20)/10^6","v":0.51656098108613802},{"$f":"(Calculations!I22-Calculations!I20)/10^6","v":0.7788529732485121},{"$f":"(Calculations!J22-Calculations!J20)/10^6","v":0.18194691906258886},{"$f":"SUM(F9:J9)","v":1.5715906274038216},{"$f":"SUM(E9:J9)","v":1.5715906274038216}]
[null,"Operating Costs (excl labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E69-Calculations!E67)/10^6","v":0},{"$f":"(Calculations!F69-Calculations!F67)/10^6","v":0.49083675157894741},{"$f":"(Calculations!G69-Calculations!G67)/10^6","v":2.468934158934474},{"$f":"(Calculations!H69-Calculations!H67)/10^6","v":5.9207582901327909},{"$f":"(Calculations!I69-Calculations!I67)/10^6","v":7.2445487905811747},{"$f":"(Calculations!J69-Calculations!J67)/10^6","v":6.6434482734373139},{"$f":"SUM(F10:J10)","v":22.7685262646647},{"$f":"SUM(E10:J10)","v":22.7685262646647}]
[null,"Strategic Benefit Payments",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"Calculations!E84/10^6","v":0},{"$f":"Calculations!F84/10^6","v":0},{"$f":"Calculations!G84/10^6","v":6.8233673227507272E-2},{"$f":"Calculations!H84/10^6","v":0.20470741562252184},{"$f":"Calculations!I84/10^6","v":0.20470741562252184},{"$f":"Calculations!J84/10^6","v":0.20470741562252184},{"$f":"SUM(F11:J11)","v":0.68235592009507273},{"$f":"SUM(E11:J11)","v":0.68235592009507273}]
[null,"Insurance Costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"Calculations!E80/10^6","v":0},{"$f":"Calculations!F80/10^6","v":0},{"$f":"Calculations!G80/10^6","v":0.31527052099999997},{"$f":"Calculations!H80/10^6","v":0.31527052099999997},{"$f":"Calculations!I80/10^6","v":0.37277738349999995},{"$f":"Calculations!J80/10^6","v":0.31527052099999997},1.3185889464999998,1.3185889464999998]
[null,"Vegetation Integrity Rehabilitation Costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",0,0.14035859999999997,0.14035859999999997,0.14035859999999997,0.14035859999999997,0.14035859999999997,{"$f":"SUM(F13:J13)","v":0.70179299999999989},{"$f":"SUM(E13:J13)","v":0.70179299999999989}]
[null,"Real input cost escalation",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",0,1.6650503716426866E-2,6.9410493341713522E-2,0.21263787644160365,0.28769391293724911,0.27738566592235497,0.86377845235934814,0.86377845235934814]
[]
[null,"Total (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"SUM(E9:E14)","v":0},0.6478458552953742,3.1564372005102772,7.3102936842830548,9.0289390758894594,7.7631173950447803,27.906633211022946,27.906633211022946]
[]
[null,"Debt Raising Costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"Calculations!E93/10^6","v":0},{"$f":"Calculations!F93/10^6","v":8.3350438479535063E-2},{"$f":"Calculations!G93/10^6","v":0.15618487166244979},{"$f":"Calculations!H93/10^6","v":0.21049249951108251},{"$f":"Calculations!I93/10^6","v":0.20846183577747063},{"$f":"Calculations!J93/10^6","v":0.202177771489439},0.86066741691997706,0.86066741691997706]
[]
[null,"Total (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"E16+E18","v":0},0.73119629377490925,3.3126220721727271,7.5207861837941374,9.2374009116669296,7.9652951665342195,28.767300627942923,28.767300627942923]
[]
[{"$f":"IF(SUM(E22:J22)=0,0,1)","v":0},"Check - Calculations",null,null,{"$f":"IF(ROUND(E16-Calculations!E91/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F16-Calculations!F91/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G16-Calculations!G91/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H16-Calculations!H91/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I16-Calculations!I91/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J16-Calculations!J91/10^6,3)=0,0,1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total","Total"]
[null,"Maintenance costs (excl labour escalation)","Dollar basis","Units",{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031},"Next period","All years"]
[]
[null,"Transmission lines",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E16-Calculations!E14)/10^6","v":0},{"$f":"(Calculations!F16-Calculations!F14)/10^6","v":0},{"$f":"(Calculations!G16-Calculations!G14)/10^6","v":0},{"$f":"(Calculations!H16-Calculations!H14)/10^6","v":7.3957773121973755E-2},{"$f":"(Calculations!I16-Calculations!I14)/10^6","v":0.44445262745467062},{"$f":"(Calculations!J16-Calculations!J14)/10^6","v":7.3957773121973755E-2},{"$f":"SUM(F27:J27)","v":0.59236817369861805},{"$f":"SUM(E27:J27)","v":0.59236817369861805}]
[null,"Substations",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E10-Calculations!E8)/10^6","v":0},{"$f":"(Calculations!F10-Calculations!F8)/10^6","v":0},{"$f":"(Calculations!G10-Calculations!G8)/10^6","v":9.4229754006582608E-2},{"$f":"(Calculations!H10-Calculations!H8)/10^6","v":0.44260320796416425},{"$f":"(Calculations!I10-Calculations!I8)/10^6","v":0.33440034579384165},{"$f":"(Calculations!J10-Calculations!J8)/10^6","v":0.10798914594061509},{"$f":"SUM(F28:J28)","v":0.97922245370520344},{"$f":"SUM(E28:J28)","v":0.97922245370520344}]
[]
[null,"Total (excluding labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"SUM(E27:E28)","v":0},0,9.4229754006582608E-2,0.51656098108613802,0.77885297324851233,0.18194691906258886,{"$f":"SUM(F30:J30)","v":1.5715906274038218},{"$f":"SUM(E30:J30)","v":1.5715906274038218}]
[]
[{"$f":"IF(SUM(E32:J32)=0,0,1)","v":0},"Check - Reconciliation",null,null,{"$f":"IF(ROUND(E30-E9,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,"Total","Total"]
[null,"Operating costs (excl labour escalation)","Dollar basis","Units",{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},{"$f":"Inputs!U$20","v":2030},{"$f":"Inputs!V$20","v":2031},"Next period","All years"]
[]
[null,"Asset management",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E34-Calculations!E32)/10^6","v":0},{"$f":"(Calculations!F34-Calculations!F32)/10^6","v":0},{"$f":"(Calculations!G34-Calculations!G32)/10^6","v":0.27030599999999999},{"$f":"(Calculations!H34-Calculations!H32)/10^6","v":0.54061199999999998},{"$f":"(Calculations!I34-Calculations!I32)/10^6","v":0.54061199999999998},{"$f":"(Calculations!J34-Calculations!J32)/10^6","v":0.54061199999999998},{"$f":"SUM(F37:J37)","v":1.8921419999999998},{"$f":"SUM(E37:J37)","v":1.8921419999999998}]
[null,"Network planning",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E46-Calculations!E44)/10^6","v":0},{"$f":"(Calculations!F46-Calculations!F44)/10^6","v":0},{"$f":"(Calculations!G46-Calculations!G44)/10^6","v":0.30321215999999995},{"$f":"(Calculations!H46-Calculations!H44)/10^6","v":0.60642431999999991},{"$f":"(Calculations!I46-Calculations!I44)/10^6","v":0.60642431999999991},{"$f":"(Calculations!J46-Calculations!J44)/10^6","v":0.60642431999999991},2.1224851199999994,2.1224851199999994]
[null,"Network operations",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E52-Calculations!E50)/10^6","v":0},{"$f":"(Calculations!F52-Calculations!F50)/10^6","v":0},{"$f":"(Calculations!G52-Calculations!G50)/10^6","v":0.552155022},{"$f":"(Calculations!H52-Calculations!H50)/10^6","v":1.104310044},{"$f":"(Calculations!I52-Calculations!I50)/10^6","v":1.104310044},{"$f":"(Calculations!J52-Calculations!J50)/10^6","v":1.104310044},3.865085154,3.865085154]
[null,"Commercial contract management",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"Calculations!E61/10^6","v":0},{"$f":"Calculations!F61/10^6","v":0},{"$f":"Calculations!G61/10^6","v":0.15557310483552619},{"$f":"Calculations!H61/10^6","v":2.2852162745538438},{"$f":"Calculations!I61/10^6","v":2.2836866128969646},{"$f":"Calculations!J61/10^6","v":2.2821625431215242},7.0066385354078591,7.0066385354078591]
[null,"Regulatory submissions",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"Calculations!E62/10^6","v":0},{"$f":"Calculations!F62/10^6","v":0.49083675157894741},{"$f":"Calculations!G62/10^6","v":0.49083675157894741},{"$f":"Calculations!H62/10^6","v":0.49083675157894741},{"$f":"Calculations!I62/10^6","v":1.8677569136842105},{"$f":"Calculations!J62/10^6","v":1.2785004663157895},4.6187676347368427,4.6187676347368427]
[null,"Others",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"(Calculations!E40-Calculations!E38+Calculations!E58-Calculations!E56)/10^6","v":0},{"$f":"(Calculations!F40-Calculations!F38+Calculations!F58-Calculations!F56)/10^6","v":0},{"$f":"(Calculations!G40-Calculations!G38+Calculations!G58-Calculations!G56)/10^6","v":0.69685112051999987},{"$f":"(Calculations!H40-Calculations!H38+Calculations!H58-Calculations!H56)/10^6","v":0.89335889999999996},{"$f":"(Calculations!I40-Calculations!I38+Calculations!I58-Calculations!I56)/10^6","v":0.84175889999999975},{"$f":"(Calculations!J40-Calculations!J38+Calculations!J58-Calculations!J56)/10^6","v":0.83143889999999987},3.2634078205199994,3.2634078205199994,"Note: Delivery plus Finance and Audit cost categories"]
[]
[null,"Total (excluding labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"SUM(E37:E42)","v":0},0.49083675157894741,2.4689341589344735,5.9207582901327909,7.2445487905811747,6.6434482734373139,{"$f":"SUM(F44:J44)","v":22.7685262646647},{"$f":"SUM(E44:J44)","v":22.7685262646647}]
[]
[{"$f":"IF(SUM(E46:J46)=0,0,1)","v":0},"Check - Reconciliation",null,null,{"$f":"IF(ROUND(E44-E10,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[]
[null,"RIN Template"]
[]
[null,"Table 6.1: Non-network expenditure (real $m, Jun 2026)",null,null,"Pre-period (EnergyCo funded costs)",null,null,null,null,"2026-31 regulatory control period (excluding IPFs)",null,null,null,null,{"$f":"K$5","v":"Total"},{"$f":"L$5","v":"Total"}]
[null,null,null,null,{"$f":"LEFT(F52,2)&RIGHT(F52,2)-1","v":"2022"},{"$f":"LEFT(G52,2)&RIGHT(G52,2)-1","v":"2023"},{"$f":"LEFT(H52,2)&RIGHT(H52,2)-1","v":"2024"},{"$f":"LEFT(I52,2)&RIGHT(I52,2)-1","v":"2025"},{"$f":"E$6","v":2026},2027,2028,2029,2030,2031,"Next period","All years"]
[]
[null,"Costs"]
[null,"IT & Communications",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J55:N55)","v":0},{"$f":"SUM(E55:N55)","v":0}]
[null,"Motor Vehicles",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(E56:N56)","v":0}]
[null,"Buildings and Property",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(E57:N57)","v":0}]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"E62*E63","v":0},{"$f":"F62*F63","v":0},{"$f":"G62*G63","v":0},{"$f":"H62*H63","v":0},{"$f":"I62*I63","v":0},0.19435375658861229,0.68368363892483086,1.8493485474181599,2.2677862811660807,2.0051170584066771,7.0002892825043608,{"$f":"SUM(E58:N58)","v":7.0002892825043608},null,"Note: Includes opex support costs or overheads"]
[null,null,null,"$Million"]
[null,"Total non-network opex",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"SUM(E55:E58)","v":0},{"$f":"SUM(F55:F58)","v":0},{"$f":"SUM(G55:G58)","v":0},{"$f":"SUM(H55:H58)","v":0},{"$f":"SUM(I55:I58)","v":0},0.19435375658861229,0.68368363892483086,1.8493485474181599,2.2677862811660807,2.0051170584066771,7.0002892825043608,{"$f":"SUM(E60:N60)","v":7.0002892825043608}]
[]
[null,"Total labour costs","Real $2024","$Million",null,null,null,null,{"$f":"(Calculations!E7+Calculations!E8+Calculations!E13+Calculations!E14+Calculations!E31+Calculations!E32+Calculations!E37+Calculations!E38+Calculations!E43+Calculations!E44+Calculations!E49+Calculations!E50+Calculations!E55+Calculations!E56+Calculations!E64+Calculations!E89)/10^6","v":0},{"$f":"(Calculations!F7+Calculations!F8+Calculations!F13+Calculations!F14+Calculations!F31+Calculations!F32+Calculations!F37+Calculations!F38+Calculations!F43+Calculations!F44+Calculations!F49+Calculations!F50+Calculations!F55+Calculations!F56+Calculations!F64+Calculations!F89)/10^6","v":0.64784585529537431},{"$f":"(Calculations!G7+Calculations!G8+Calculations!G13+Calculations!G14+Calculations!G31+Calculations!G32+Calculations!G37+Calculations!G38+Calculations!G43+Calculations!G44+Calculations!G49+Calculations!G50+Calculations!G55+Calculations!G56+Calculations!G64+Calculations!G89)/10^6","v":2.2789454630827697},{"$f":"(Calculations!H7+Calculations!H8+Calculations!H13+Calculations!H14+Calculations!H31+Calculations!H32+Calculations!H37+Calculations!H38+Calculations!H43+Calculations!H44+Calculations!H49+Calculations!H50+Calculations!H55+Calculations!H56+Calculations!H64+Calculations!H89)/10^6","v":6.1644951580605332},{"$f":"(Calculations!I7+Calculations!I8+Calculations!I13+Calculations!I14+Calculations!I31+Calculations!I32+Calculations!I37+Calculations!I38+Calculations!I43+Calculations!I44+Calculations!I49+Calculations!I50+Calculations!I55+Calculations!I56+Calculations!I64+Calculations!I89)/10^6","v":7.5592876038869354},{"$f":"(Calculations!J7+Calculations!J8+Calculations!J13+Calculations!J14+Calculations!J31+Calculations!J32+Calculations!J37+Calculations!J38+Calculations!J43+Calculations!J44+Calculations!J49+Calculations!J50+Calculations!J55+Calculations!J56+Calculations!J64+Calculations!J89)/10^6","v":6.6837235280222576}]
[null,"Non network support cost share of total labour costs","N/A","Percent",null,null,null,null,0.3,0.3,0.3,0.3,0.3,0.3]
[]
[null,"9.1 Operating and maintenance costs by category (real $, Jun 2026)",null,null,"Pre-period (EnergyCo funded costs)",null,null,null,null,"2026-31 regulatory control period (excluding IPFs)",null,null,null,null,{"$f":"K$5","v":"Total"},{"$f":"L$5","v":"Total"}]
[null,null,null,null,{"$f":"LEFT(F66,2)&RIGHT(F66,2)-1","v":"2022"},{"$f":"LEFT(G66,2)&RIGHT(G66,2)-1","v":"2023"},{"$f":"LEFT(H66,2)&RIGHT(H66,2)-1","v":"2024"},{"$f":"LEFT(I66,2)&RIGHT(I66,2)-1","v":"2025"},{"$f":"E$6","v":2026},2027,2028,2029,2030,2031,"Next period","All years"]
[]
[null,"Costs"]
[null,"Maintenance costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E10+Calculations!E16","v":0},{"$f":"Calculations!F10+Calculations!F16","v":0},{"$f":"Calculations!G10+Calculations!G16","v":96318.277354189209},{"$f":"Calculations!H10+Calculations!H16","v":531615.80973322981},{"$f":"Calculations!I10+Calculations!I16","v":793273.04476883693},{"$f":"Calculations!J10+Calculations!J16","v":185747.21634588233},{"$f":"SUM(J69:N69)","v":1606954.3482021382},{"$f":"SUM(E69:N69)","v":1606954.3482021382}]
[null,"Operating Costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E34+Calculations!E40+Calculations!E46+Calculations!E52+Calculations!E58+Calculations!E64","v":0},{"$f":"Calculations!F34+Calculations!F40+Calculations!F46+Calculations!F52+Calculations!F58+Calculations!F64","v":505174.9021159386},{"$f":"Calculations!G34+Calculations!G40+Calculations!G46+Calculations!G52+Calculations!G58+Calculations!G64","v":2533698.5959760253},{"$f":"Calculations!H34+Calculations!H40+Calculations!H46+Calculations!H52+Calculations!H58+Calculations!H64","v":6115483.9120406173},{"$f":"Calculations!I34+Calculations!I40+Calculations!I46+Calculations!I52+Calculations!I58+Calculations!I64","v":7514664.2125895694},{"$f":"Calculations!J34+Calculations!J40+Calculations!J46+Calculations!J52+Calculations!J58+Calculations!J64","v":6913573.1245192029},23582594.747241355,{"$f":"SUM(E70:N70)","v":23582594.747241355},null,"Note: Includes the following operating cost categories 'Commercial contract management', 'Asset Management', 'Delivery', 'Network planning', 'Network operations', 'Finance and Audit' and 'Regulatory submissions' "]
[null,{"$f":"B11","v":"Strategic Benefit Payments"},{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E84","v":0},{"$f":"Calculations!F84","v":0},{"$f":"Calculations!G84","v":68233.673227507272},{"$f":"Calculations!H84","v":204707.41562252183},{"$f":"Calculations!I84","v":204707.41562252183},{"$f":"Calculations!J84","v":204707.41562252183},682355.92009507283,682355.92009507283]
[null,{"$f":"B12","v":"Insurance Costs"},{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E80","v":0},{"$f":"Calculations!F80","v":0},{"$f":"Calculations!G80","v":315270.52099999995},{"$f":"Calculations!H80","v":315270.52099999995},{"$f":"Calculations!I80","v":372777.38349999994},{"$f":"Calculations!J80","v":315270.52099999995},1318588.9464999998,1318588.9464999998]
[null,{"$f":"B13","v":"Vegetation Integrity Rehabilitation Costs"},{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E89","v":0},{"$f":"Calculations!F89","v":142670.95317943569},{"$f":"Calculations!G89","v":142916.13295255514},{"$f":"Calculations!H89","v":143216.02588668547},{"$f":"Calculations!I89","v":143517.01940852954},{"$f":"Calculations!J89","v":143819.11755717322},716139.24898437911,{"$f":"SUM(E73:N73)","v":716139.24898437911}]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E93","v":0},{"$f":"Calculations!F93","v":83350.438479535063},{"$f":"Calculations!G93","v":156184.87166244979},{"$f":"Calculations!H93","v":210492.49951108251},{"$f":"Calculations!I93","v":208461.83577747064},{"$f":"Calculations!J93","v":202177.77148943901},860667.41691997694,{"$f":"SUM(E74:N74)","v":860667.41691997694},null,"Note: Includes debt raising costs"]
[null,null,null,"$Dollars"]
[null,"Total opex (Including Debt Raising Costs)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",{"$f":"SUM(E69:E74)","v":0},{"$f":"SUM(F69:F74)","v":0},{"$f":"SUM(G69:G74)","v":0},{"$f":"SUM(H69:H74)","v":0},{"$f":"SUM(I69:I74)","v":0},731196.29377490934,3312622.0721727265,7520786.1837941371,9237400.9116669297,7965295.1665342189,{"$f":"SUM(J76:N76)","v":28767300.627942923},28767300.627942923,null,"Note: All operating expenditure tables reported in the RIN include debt raising costs"]
[]
[{"$f":"IF(SUM(E78:N78)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,null,null,null,null,{"$f":"IF(ROUND(I76/10^6-E$20,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"9.2 Operating and maintenance direct and indirect costs (real $, Jun 2026)",null,null,{"$f":"E$65","v":"Pre-period (EnergyCo funded costs)"},null,null,null,null,{"$f":"J$65","v":"2026-31 regulatory control period (excluding IPFs)"},null,null,null,null,{"$f":"K$5","v":"Total"},{"$f":"L$5","v":"Total"}]
[null,null,null,null,{"$f":"LEFT(F81,2)&RIGHT(F81,2)-1","v":"2022"},{"$f":"LEFT(G81,2)&RIGHT(G81,2)-1","v":"2023"},{"$f":"LEFT(H81,2)&RIGHT(H81,2)-1","v":"2024"},{"$f":"LEFT(I81,2)&RIGHT(I81,2)-1","v":"2025"},{"$f":"E$6","v":2026},2027,2028,2029,2030,2031,"Next period","All years"]
[]
[null,"Costs"]
[null,"Operating and maintenance direct costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E22+((Calculations!E69+Calculations!E64)*I$89)","v":0},{"$f":"Calculations!F22+((Calculations!F69+Calculations!F64)*J$89)","v":707244.86296231404},{"$f":"Calculations!G22+((Calculations!G69+Calculations!G64)*K$89)","v":2337013.5803740066},{"$f":"Calculations!H22+((Calculations!H69+Calculations!H64)*L$89)","v":6825837.6271686554},{"$f":"Calculations!I22+((Calculations!I69+Calculations!I64)*M$89)","v":9075497.9593426511},{"$f":"Calculations!J22+((Calculations!J69+Calculations!J64)*N$89)","v":7626673.7070231009},{"$f":"SUM(J84:N84)","v":26572267.736870728},{"$f":"SUM(E84:N84)","v":26572267.736870728},null,"Note: Includes 100% of the maintenance costs plus 70% of operating cost labour"]
[null,"Operating and maintenance indirect costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,{"$f":"Calculations!E95-I84","v":0},{"$f":"Calculations!F95-J84","v":23951.430812595296},{"$f":"Calculations!G95-K84","v":975608.49179871986},{"$f":"Calculations!H95-L84","v":694948.55662548169},{"$f":"Calculations!I95-M84","v":161902.95232427865},{"$f":"Calculations!J95-N84","v":338621.45951111708},{"$f":"SUM(J85:N85)","v":2195032.8910721927},{"$f":"SUM(E85:N85)","v":2195032.8910721927},null,"Note: Includes all other opex excluding the direct costs above"]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",{"$f":"SUM(E82:E85)","v":0},{"$f":"SUM(F82:F85)","v":0},{"$f":"SUM(G82:G85)","v":0},{"$f":"SUM(H82:H85)","v":0},{"$f":"SUM(I82:I85)","v":0},731196.29377490934,3312622.0721727265,7520786.1837941371,9237400.9116669297,7965295.166534218,{"$f":"SUM(J87:N87)","v":28767300.627942923},{"$f":"SUM(E87:N87)","v":28767300.627942923}]
[]
[null,"Direct share of total labour costs","N/A","Percent",null,null,null,null,0.7,0.7,0.7,0.7,0.7,0.7]
[{"$f":"IF(SUM(E90:N90)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,null,null,null,null,{"$f":"IF(ROUND(I87/10^6-E$20,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"9.3 Operating and maintenance direct and indirect costs (real $, June 2026)",null,null,{"$f":"E$65","v":"Pre-period (EnergyCo funded costs)"},null,null,null,null,{"$f":"J$65","v":"2026-31 regulatory control period (excluding IPFs)"},null,null,null,null,{"$f":"K$5","v":"Total"},{"$f":"L$5","v":"Total"}]
[null,null,null,null,{"$f":"LEFT(F93,2)&RIGHT(F93,2)-1","v":"2022"},{"$f":"LEFT(G93,2)&RIGHT(G93,2)-1","v":"2023"},{"$f":"LEFT(H93,2)&RIGHT(H93,2)-1","v":"2024"},{"$f":"LEFT(I93,2)&RIGHT(I93,2)-1","v":"2025"},{"$f":"E$6","v":2026},2027,2028,2029,2030,2031,"Next period","All years"]
[]
[null,"Costs"]
[null,"Transmission lines - new infrastructure",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,{"$f":"Calculations!E16","v":0},{"$f":"Calculations!F16","v":0},{"$f":"Calculations!G16","v":0},{"$f":"Calculations!H16","v":74267.316464971838},{"$f":"Calculations!I16","v":446760.25091518433},{"$f":"Calculations!J16","v":74332.649047240004},{"$f":"SUM(J96:N96)","v":595360.21642739617},{"$f":"SUM(E96:N96)","v":595360.21642739617},null,"Note: 100% of transmission line maintenance opex"]
[null,"Towers - new infrastructure",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J97:N97)","v":0},{"$f":"SUM(E97:N97)","v":0}]
[null,"Transmission lines - augmentation",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Towers - augmentation",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Switching station(s)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Ancillary equipment",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,null,null,null,null,null,null,0,0]
[null,"Substation(s)",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,{"$f":"Calculations!E10","v":0},{"$f":"Calculations!F10","v":0},{"$f":"Calculations!G10","v":96318.277354189209},{"$f":"Calculations!H10","v":457348.49326825794},{"$f":"Calculations!I10","v":346512.79385365261},{"$f":"Calculations!J10","v":111414.56729864235},1011594.1317747422,1011594.1317747422,null,"Note: 100% of substation maintenance opex"]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",null,null,null,null,{"$f":"Calculations!E95-SUM(I96:I102)","v":0},{"$f":"Calculations!F95-SUM(J96:J102)","v":731196.29377490934},{"$f":"Calculations!G95-SUM(K96:K102)","v":3216303.7948185373},{"$f":"Calculations!H95-SUM(L96:L102)","v":6989170.3740609074},{"$f":"Calculations!I95-SUM(M96:M102)","v":8444127.8668980934},{"$f":"Calculations!J95-SUM(N96:N102)","v":7779547.950188336},27160346.279740784,27160346.279740784,null,"Note: Contains remaining opex"]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Million",{"$f":"SUM(E96:E103)","v":0},{"$f":"SUM(F96:F103)","v":0},{"$f":"SUM(G96:G103)","v":0},{"$f":"SUM(H96:H103)","v":0},{"$f":"SUM(I96:I103)","v":0},731196.29377490934,3312622.0721727265,7520786.1837941371,9237400.9116669297,7965295.166534218,{"$f":"SUM(J105:N105)","v":28767300.627942923},{"$f":"SUM(E105:N105)","v":28767300.627942923}]
[]
[{"$f":"IF(SUM(E107:N107)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,null,null,null,null,{"$f":"IF(ROUND(I105/10^6-E$20,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"7.1 Regulatory requirements/contractual arrangement costs  (real $, Jun 2026)",null,null,{"$f":"E$65","v":"Pre-period (EnergyCo funded costs)"},null,null,null,null,{"$f":"J$65","v":"2026-31 regulatory control period (excluding IPFs)"},null,null,null,null,{"$f":"K$5","v":"Total"},{"$f":"L$5","v":"Total"}]
[null,null,null,null,{"$f":"LEFT(F110,2)&RIGHT(F110,2)-1","v":"2022"},{"$f":"LEFT(G110,2)&RIGHT(G110,2)-1","v":"2023"},{"$f":"LEFT(H110,2)&RIGHT(H110,2)-1","v":"2024"},{"$f":"LEFT(I110,2)&RIGHT(I110,2)-1","v":"2025"},{"$f":"E$6","v":2026},2027,2028,2029,2030,2031,"Next period","All years"]
[]
[null,"Costs"]
[null,"Opex - Strategic Benefits Payments",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,null,{"$f":"F11*10^6","v":0},{"$f":"G11*10^6","v":68233.673227507272},{"$f":"H11*10^6","v":204707.41562252183},{"$f":"I11*10^6","v":204707.41562252183},{"$f":"J11*10^6","v":204707.41562252183},{"$f":"SUM(J113:N113)","v":682355.92009507283},{"$f":"SUM(E113:N113)","v":682355.92009507283}]
[null,"Opex - Operations - Commercial",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,null,{"$f":"Calculations!F61+Calculations!F$63*(Calculations!F61/SUM(Calculations!F$61:F$62))","v":0},{"$f":"Calculations!G61+Calculations!G$63*(Calculations!G61/SUM(Calculations!G$61:G$62))","v":160599.51184813352},{"$f":"Calculations!H61+Calculations!H$63*(Calculations!H61/SUM(Calculations!H$61:H$62))","v":2367706.8206168758},{"$f":"Calculations!I61+Calculations!I$63*(Calculations!I61/SUM(Calculations!I$61:I$62))","v":2374805.4568529325},{"$f":"Calculations!J61+Calculations!J$63*(Calculations!J61/SUM(Calculations!J$61:J$62))","v":2381930.1432154514},{"$f":"SUM(J114:N114)","v":7285041.9325333927},{"$f":"SUM(E114:N114)","v":7285041.9325333927}]
[null,"Opex - Operations - Regulatory",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,null,{"$f":"Calculations!F62+Calculations!F$63*(Calculations!F62/SUM(Calculations!F$61:F$62))","v":505174.9021159386},{"$f":"Calculations!G62+Calculations!G$63*(Calculations!G62/SUM(Calculations!G$61:G$62))","v":506695.18220415164},{"$f":"Calculations!H62+Calculations!H$63*(Calculations!H62/SUM(Calculations!H$61:H$62))","v":508554.72082168667},{"$f":"Calculations!I62+Calculations!I$63*(Calculations!I62/SUM(Calculations!I$61:I$62))","v":1942280.2085200902},{"$f":"Calculations!J62+Calculations!J$63*(Calculations!J62/SUM(Calculations!J$61:J$62))","v":1334391.7189470888},{"$f":"SUM(J115:N115)","v":4797096.7326089554},{"$f":"SUM(E115:N115)","v":4797096.7326089554}]
[null,"Opex - Vegetation management",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,null,{"$f":"F13*10^6","v":140358.59999999998},{"$f":"G13*10^6","v":140358.59999999998},{"$f":"H13*10^6","v":140358.59999999998},{"$f":"I13*10^6","v":140358.59999999998},{"$f":"J13*10^6","v":140358.59999999998},{"$f":"SUM(J116:N116)","v":701792.99999999988},{"$f":"SUM(E116:N116)","v":701792.99999999988}]
[null,"Opex - Insurance",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",null,null,null,null,null,{"$f":"F12*10^6","v":0},{"$f":"G12*10^6","v":315270.52099999995},{"$f":"H12*10^6","v":315270.52099999995},{"$f":"I12*10^6","v":372777.38349999994},{"$f":"J12*10^6","v":315270.52099999995},{"$f":"SUM(J117:N117)","v":1318588.9464999998},{"$f":"SUM(E117:N117)","v":1318588.9464999998}]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2026"},"$Dollars",{"$f":"SUM(E111:E117)","v":0},{"$f":"SUM(F111:F117)","v":0},{"$f":"SUM(G111:G117)","v":0},{"$f":"SUM(H111:H117)","v":0},{"$f":"SUM(I111:I117)","v":0},645533.50211593858,1191157.4882797925,3536598.0780610843,5034929.0644955439,4376658.3987850621,{"$f":"SUM(J119:N119)","v":14784876.531737421},{"$f":"SUM(E119:N119)","v":14784876.531737421}]
[]
[null,"End"]