{"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":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Index and File Details"]
[]
[null,"Index",null,null,null,null,null,"File Details"]
[]
[null,"Inputs",null,"Calculations",null,"Outputs",null,null,"Model","Transgrid | WSB 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","2023-06-30"]
[null,{"$f":"Inputs!A1","v":"Inputs"},null,null,null,null,null,null,"Status","Revenue Proposal"]
[]
[]
[]
[null,null,null,null,null,null,null,"Instructions"]
[]
[null,null,null,null,null,null,null,null,"Input Sheets"]
[null,null,null,null,null,null,null,null,"Fill in any cells marked as input cells as seen on the right =>",null,"user input"]
[null,null,null,null,null,null,null,null,"Historical / Not applicable"]
[null,null,null,null,null,null,null,null,"Cells not marked as inputs should not be modified."]

{"sheet":"Notes & Assumptions","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Assumptions & Notes"]
[]
[null,null,null,null,"User inputs in cells coloured like this"]
[null,null,"*",null,"1.     Inputs 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":125,"n_cols":26,"rows_kept":125,"cut":false,"hidden":false,"merged":[[28,21,28,23],[109,14,109,19],[100,13,100,19],[118,15,118,19],[5,2,5,5],[28,15,28,19],[12,13,12,19],[18,13,18,19],[28,5,28,6],[49,5,49,6],[49,14,49,19]]}
["Inputs"]
[null,"AER amendments"]
[]
[null,"Output Reporting Format and Year"]
[null,"Real"]
[null,2024,"The Financial Year that results are reported in."]
[]
[null,{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2024"}]
[]
[null,"Indexation and escalation"]
[]
[]
[null,"Forecasts",null,null,null,null,null,null,null,null,null,null,null,"Rates"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,null,2023,{"$f":"N14+1","v":2024},2025,2026,2027,2028,2029]
[null,"Actual / Forecast Inflation ","ABS / RBA / PTRM","%",null,null,null,null,null,null,null,null,null,6.3E-2,3.5999999999999997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-2,2.7498479316033997E-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,null,3.9046564755527329E-3,1.3076482545953276E-2,1.1546438954636147E-2,4.3304575862308627E-3,3.00941333753012E-3,{"$f":"AVERAGE(O16:S16)","v":7.1734897799806269E-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,null,"Cumulative Factors"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,null,null,{"$f":"N$14","v":2023},{"$f":"O$14","v":2024},2025,2026,2027,2028,2029]
[null,"Nominal (mid year) to Real 2024 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,null,{"$f":"O21*(1+O15)^0.5*(1+N15)^0.5","v":1.0681355943886524},{"$f":"(1+O15)^0.5","v":1.0178408519999578},{"$f":"O21/(1+O15)^0.5/(1+P15)^0.5","v":0.98652797735725628},{"$f":"P21/(1+P15)^0.5/(1+Q15)^0.5","v":0.96012597314396986},{"$f":"Q21/(1+Q15)^0.5/(1+R15)^0.5","v":0.93443055388567453},{"$f":"R21/(1+R15)^0.5/(1+S15)^0.5","v":0.90942280956725985},{"$f":"S21/(1+S15)^0.5/(1+T15)^0.5","v":0.88508433625383798},null,"Note: this index converts from nominal mid year dollars for each year between 2022-23 to 2028-29 to dollars as at the end of 2023-24 (i.e., Real 2024, 30 June 2024)."]
[null,"Nominal (end year) to Real 2024 (end year)","Calculated","Factor",null,null,null,null,null,null,null,null,null,{"$f":"O22*(1+O15)","v":1.036},1,{"$f":"O22/(1+P15)","v":0.97323745010859897},{"$f":"P22/(1+Q15)","v":0.94719113429388768},{"$f":"Q22/(1+R15)","v":0.92184188430565484},{"$f":"R22/(1+S15)","v":0.8971710448849417},{"$f":"S22/(1+T15)","v":0.87316046003508807}]
[null,"Labour escalation from 2023","Calculated","Factor",null,null,null,null,null,null,null,null,null,1,{"$f":"N23*(1+O16)","v":1.0039046564755527},1.0170321981937565,1.0287752983851002,1.0332303661805189,1.0363397834252435,1.0437739562702317]
[]
[]
[]
[null,"Maintenance expenditure"]
[]
[null,"Maintenance plan requirements",null,null,null,"Conversion",null,null,null,null,null,"Defect",null,null,null,"Quantities ",null,null,null,null,null,"Rates (Real $2023)",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",null,"Asset class","Location",null,"Allowance (%)",null,null,null,{"$f":"P$20","v":2025},{"$f":"Q$20","v":2026},{"$f":"R$20","v":2027},{"$f":"S$20","v":2028},{"$f":"T$20","v":2029},null,"Code","Labour","Materials"]
[null,"Transmission lines",null,null,null,2023,2023]
[null,"Requirement 1","c-i-c","c-i-c",null,"Mid",null,null,"Transmission Lines","TL39, 3L/4, 5",null,0.8,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"TLELDC","c-i-c","c-i-c"]
[null,"Requirement 2","c-i-c","c-i-c",null,null,null,null,"Transmission Lines","TL39, 3L/4, 5",null,0.8,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"TLELDT","c-i-c","c-i-c"]
[null,"Requirement 3","c-i-c","c-i-c",null,null,null,null,"Transmission Lines","TL39, 3L/4, 5",null,0.8,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"TLELDC","c-i-c","c-i-c"]
[null,"Requirement 4","c-i-c","c-i-c",null,null,null,null,"Transmission Lines","TL39, 3L/4, 5",null,0.8,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"TLELDT","c-i-c","c-i-c"]
[null,"Substations"]
[null,"Requirement 1","c-i-c","c-i-c",null,null,null,null,"Substations","Liddell and Newcastle",null,2,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"S0160B","c-i-c","c-i-c"]
[null,"Requirement 2","c-i-c","c-i-c",null,null,null,null,"Substations","Northern & Southern Sites",null,2,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"S0955C","c-i-c","c-i-c"]
[null,"Requirement 3","c-i-c","c-i-c",null,null,null,null,"Substations","Northern & Southern Sites",null,2,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"S1SUBK","c-i-c","c-i-c"]
[null,"Requirement 4","c-i-c","c-i-c",null,null,null,null,"Substations","Northern & Southern Sites",null,2,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"S0830V","c-i-c","c-i-c"]
[null,"SIPS control"]
[null,"Requirement 1","c-i-c","c-i-c",null,null,null,null,"Secondary Systems","All SIPS sites",null,3,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0,"c-i-c","c-i-c"]
[null,"Requirement 2","c-i-c","c-i-c",null,null,null,null,"Secondary Systems","All monitored locations",null,3,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"PUFLR1","c-i-c","c-i-c"]
[null,"Requirement 3","c-i-c","c-i-c",null,null,null,null,"Communications (short life)","Only between WSB and connection site (Munmorah) duplicated paths",null,3,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,0,"c-i-c","c-i-c"]
[]
[]
[]
[null,"Operating costs"]
[]
[null,"Direct costs",null,null,null,"Conversion",null,null,"Hourly rate","◄ Includes on-costs and support costs",null,"Hours per year",null,null,"Headcount Forecast (FTEs)",null,null,null,null,null,null,"Note: salaries are assumed to be in mid-year dollars"]
[null,"Item","Resource Description","Units",null,"Dollar Year","Escalation Year",null,"$ per hour per FTE",null,null,"Hours",null,null,{"$f":"O$14","v":2024},2025,2026,2027,2028,2029]
[null,"Contract Management",null,null,null,2023,2023,null,null,null,null,1824.9]
[null,"Transgrid Representative","c-i-c","Various",null,"Mid",null,null,"c-i-c",null,null,null,null,null,0,0.15592635212888378,0.45262754123513615,0.45262754123513615,0.45262754123513615,0.45262754123513615]
[null,"Second Transgrid Representative","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.4466272124499972,1.1412406159241602,1.1412406159241602,1.1412406159241602,1.1412406159241602]
[null,"Administration Support","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.33748424571209379,0.96112115732368897,0.99947942353005637,0.99947942353005637,0.98413611704750947]
[null,"Technical Support","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.42118746232670279,0.84525179461888322,0.58112773302646714,0.58112773302646714,0.58112773302646714]
[null,"Contract Support","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.3004205709901912,0.86052660419749027,0.86052660419749027,0.86052660419749027,0.87586991068003717]
[null,"Legal Support","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,8.3621020329881099E-2,0.19198312236286921,0.19198312236286921,0.19198312236286921,0.19198312236286921]
[null,"Audit Support","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,8.8224012274645186E-2,0.26083621020329878,0.26083621020329878,0.26083621020329878,0.26083621020329878]
[null,"External Audit","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,0,0]
[null,"Annual Performance Testing with PG / WSB","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2]
[null,"Annual Performance Testing with PG / WSB","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2]
[null,"Annual Performance Testing with PG / WSB","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2,8.4388185654008435E-2]
[null,"Annual Defect Rectification","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,3.5481396240889911E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2]
[null,"Annual Defect Rectification","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,3.5481396240889911E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2]
[null,"Annual Defect Rectification","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,3.5481396240889911E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2,7.0962792481779821E-2]
[null,"Network Operator appointment fee ","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,0,0]
[null,"Network Planning"]
[null,"Manager","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,6.5757027782344232E-3,1.3151405556468846E-2,1.3151405556468846E-2,1.3151405556468846E-2,1.3151405556468846E-2]
[null,"Principal Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,1.3151405556468846E-2,2.6302811112937693E-2,2.6302811112937693E-2,2.6302811112937693E-2,2.6302811112937693E-2]
[null,"Senior Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,2.6302811112937693E-2,5.2605622225875386E-2,5.2605622225875386E-2,5.2605622225875386E-2,5.2605622225875386E-2]
[null,"Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,5.2605622225875386E-2,0.10521124445175077,0.10521124445175077,0.10521124445175077,0.10521124445175077]
[null,"Network Operations","c-i-c"]
[null,"Operations Analysis Manager","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,6.5757027782344232E-3,1.3151405556468846E-2,1.3151405556468846E-2,1.3151405556468846E-2,1.3151405556468846E-2]
[null,"OA Principal Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,1.150747986191024E-2,2.3014959723820481E-2,2.3014959723820481E-2,2.3014959723820481E-2,2.3014959723820481E-2]
[null,"OA Senior Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,2.3014959723820481E-2,4.6029919447640961E-2,4.6029919447640961E-2,4.6029919447640961E-2,4.6029919447640961E-2]
[null,"OA Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,4.6029919447640961E-2,9.2059838895281923E-2,9.2059838895281923E-2,9.2059838895281923E-2,9.2059838895281923E-2]
[null,"CC Network Control Manager","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,3.2878513891172116E-3,6.5757027782344232E-3,6.5757027782344232E-3,6.5757027782344232E-3,6.5757027782344232E-3]
[null,"CC System Operator","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,5.0139733684037478E-2,0.10027946736807496,0.10027946736807496,0.10027946736807496,0.10027946736807496]
[null,"CC Senior Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,2.3014959723820481E-2,4.6029919447640961E-2,4.6029919447640961E-2,4.6029919447640961E-2,4.6029919447640961E-2]
[null,"OT Senior Engineering  Officer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,4.6029919447640961E-2,9.2059838895281923E-2,9.2059838895281923E-2,9.2059838895281923E-2,9.2059838895281923E-2]
[null,"AMC Senior Engineer","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,3.2878513891172116E-3,6.5757027782344232E-3,6.5757027782344232E-3,6.5757027782344232E-3,6.5757027782344232E-3]
[null,"Regulatory submissions","c-i-c"]
[null,"SIPSA annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,2.1735350373848022E-2,2.1735350373848022E-2,2.1735350373848022E-2,2.1735350373848022E-2]
[null,"SIPSA annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,8.694140149539209E-2,8.694140149539209E-2,8.694140149539209E-2,8.694140149539209E-2]
[null,"Non Contestable annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,8.3333333333333329E-2,4.3470700747696043E-3,4.3470700747696043E-3,4.3470700747696043E-3,4.3470700747696043E-3]
[null,"Non Contestable annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.16662319596591893,2.1735350373848022E-2,2.1735350373848022E-2,2.1735350373848022E-2,2.1735350373848022E-2]
[null,"PGSA annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2,8.3333333333333329E-2]
[null,"PGSA annual adjustment","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0.16662319596591893,0.16662319596591893,0.16662319596591893,0.16662319596591893,0.16662319596591893]
[null,"2029-2034 revenue proposal","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,6.5206051121544067E-2,4.3470700747696045E-2]
[null,"2029-2034 revenue proposal","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,6.5206051121544067E-2,4.3470700747696045E-2]
[null,"2029-2034 revenue proposal","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,0.33328986263258564,8.694140149539209E-2]
[null,"2029-2034 revenue proposal","c-i-c","Various",null,null,null,null,"c-i-c",null,null,null,null,null,0,0,0,0,4.3470700747696045E-2,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Labour costs",0,1212257.8595178665,2637473.8381021125,2549007.2181021129,2746834.050075639,2628431.6803712836,null,"Note: this is the total cost excluding labour escalation and inflation"]
[]
[]
[null,"Other contract management costs"]
[]
[]
[null,{"$f":"B98","v":"Other contract management costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F103&\", \"&F104&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,{"$f":"N$20","v":2023},2024,2025,2026,2027,2028,2029]
[null,{"$f":"B67","v":"Network Operator appointment fee "},"Transgrid | Contact with EnergyCo","$Dollars",null,2023,null,null,null,null,null,null,null,3000000,0,0,0,0,0,0]
[null,{"$f":"B60","v":"External Audit"},"c-i-c","$Dollars",null,"End",null,null,null,null,null,null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[]
[]
[null,"Insurance costs"]
[]
[]
[null,{"$f":"B107","v":"Insurance costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F112&\", \"&F113&\" year)\"","v":"Cost (As Incurred) (Real $2023, Mid year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,{"$f":"O$20","v":2024},2025,2026,2027,2028,2029]
[null,"Annual insurance premium","c-i-c","$Dollars",null,2023,null,null,null,null,null,null,null,null,0,310571,310571,310571,310571,310571,null,"Note: Premium is payable at commissioning, which is Nov 2024 for the first stage"]
[null,null,null,null,null,"Mid"]
[]
[]
[null,"Debt raising costs"]
[]
[]
[null,{"$f":"B116","v":"Debt raising costs"},null,null,null,"Conversion",null,null,null,null,null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F121&\", \"&F122&\" year)\"","v":"Cost (As Incurred) (Real $2024, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year",null,null,null,null,null,null,null,null,null,{"$f":"P$20","v":2025},{"$f":"Q$20","v":2026},{"$f":"R$20","v":2027},{"$f":"S$20","v":2028},{"$f":"T$20","v":2029}]
[null,"Debt raising cost allowance","PTRM","$Dollars",null,2024,null,null,null,null,null,null,null,null,null,52264.505517869649,119090.08847758872,123646.63031465637,119661.75162812906,115676.87294160179]
[null,null,null,null,null,"End"]
[]
[]
[null,"End"]

{"sheet":"Calculations","index":3,"n_rows":78,"n_cols":15,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
["Calculations",null,null,null,{"$f":"Inputs!$B$8","v":"Real $2024"}]
[]
[null,{"$f":"Inputs!$B$27","v":"Maintenance expenditure"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Activity","Dollar basis","Units",{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029}]
[]
[null,{"$f":"Inputs!B31","v":"Transmission lines"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,61543.836677485371,73598.814995755703,0,{"$f":"SUM(E7:K7)","v":135142.65167324108}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,2045.1242289468878,2674.5649973003233,0,{"$f":"SUM(E8:K8)","v":4719.6892262472111}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,169711.79205003541,202954.30801859905,0,{"$f":"SUM(E9:K9)","v":372666.10006863449}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUM(G7:G9)","v":0},0,233300.75295646768,279227.68801165506,0,512528.4409681228]
[]
[null,{"$f":"Inputs!B36","v":"Substations"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,217169.95374262251,43465.727193304985,0,{"$f":"SUM(E13:K13)","v":260635.68093592749}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,7216.6370862736949,1579.5351126254186,0,{"$f":"SUM(E14:K14)","v":8796.1721988991139}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,25385.374624376378,2906.3969523315232,0,{"$f":"SUM(E15:K15)","v":28291.771576707903}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUM(G13:G15)","v":0},0,249771.9654532726,47951.659258261927,0,297723.62471153447]
[]
[null,{"$f":"Inputs!B41","v":"SIPS control"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,167299.94187790583,167299.94187790583,167299.94187790583,167299.94187790583,{"$f":"SUM(E19:K19)","v":669199.76751162333}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,4814.1057473466572,5559.4383305823376,6079.6436548989177,7323.3803397757601,{"$f":"SUM(E20:K20)","v":23776.568072603673}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,146975.45778787855,146975.45778787855,146975.45778787855,146975.45778787855,{"$f":"SUM(E21:K21)","v":587901.8311515142}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUM(G19:G21)","v":0},319089.50541313103,319834.83799636672,320355.0433206833,321598.78000556014,1280878.1667357413]
[]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"E7+E13+E19","v":0},0,{"$f":"G7+G13+G19","v":0},167299.94187790583,446013.73229801375,284364.48406696651,167299.94187790583,{"$f":"SUM(E24:K24)","v":1064978.1001207919}]
[null,"Labour escalation",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,0,4814.1057473466572,14821.199645802921,10333.74376482466,7323.3803397757601,{"$f":"SUM(E25:K25)","v":37292.429497749996}]
[null,"Materials",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,0,146975.45778787855,342072.62446229032,352836.16275880917,146975.45778787855,{"$f":"SUM(E26:K26)","v":988859.70279685664}]
[null,"Total maintenance costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0},{"$f":"SUM(G24:G26)","v":0},319089.50541313103,802907.55640610703,647534.39059060032,321598.78000556014,2091130.2324153986]
[]
[]
[null,{"$f":"Inputs!$B$48","v":"Operating costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029}]
[]
[null,{"$f":"Inputs!B52","v":"Contract Management"}]
[null,"Labour",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,"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 $2024"},"Dollars",null,null,"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"SUM(Inputs!N$103:N$104)*INDEX(IF(Inputs!$F$104=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$103,Inputs!$N$20:$T$20,0))","v":3108000},{"$f":"SUM(Inputs!O$103:O$104)*INDEX(IF(Inputs!$F$104=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$103,Inputs!$N$20:$T$20,0))","v":0},"c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,null,"Note: This includes network operator costs and external audit costs"]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"SUM(E34:E36)","v":3108000},{"$f":"SUM(F34:F36)","v":0},1760168.2700329472,3277402.7751364596,3190192.4639892494,3197174.1598768141,3216244.1955989669,17749181.864634436]
[]
[null,{"$f":"Inputs!B68","v":"Network Planning"}]
[null,{"$f":"$B$34","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUMPRODUCT(Inputs!$I$69:$I$72,Inputs!P$69:P$72)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$69:$I$72,Inputs!Q$69:Q$72)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$69:$I$72,Inputs!R$69:R$72)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$69:$I$72,Inputs!S$69:S$72)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$69:$I$72,Inputs!T$69:T$72)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUM(E40:K40)","v":0}]
[null,{"$f":"$B$35","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"G40*(Inputs!P$23-1)","v":0},{"$f":"H40*(Inputs!Q$23-1)","v":0},{"$f":"I40*(Inputs!R$23-1)","v":0},{"$f":"J40*(Inputs!S$23-1)","v":0},{"$f":"K40*(Inputs!T$23-1)","v":0},{"$f":"SUM(E41:K41)","v":0}]
[null,{"$f":"$B$36","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,0,0,0,{"$f":"SUM(E42:K42)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,39690.133912474877,80296.827241593215,80644.549246271839,80887.242028372653,81467.485832393999,362986.2382611066]
[]
[null,{"$f":"Inputs!B73","v":"Network Operations"}]
[null,{"$f":"$B$34","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUMPRODUCT(Inputs!$I$74:$I$82,Inputs!P$74:P$82)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$74:$I$82,Inputs!Q$74:Q$82)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$74:$I$82,Inputs!R$74:R$82)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$74:$I$82,Inputs!S$74:S$82)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$74:$I$82,Inputs!T$74:T$82)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUM(E46:K46)","v":0}]
[null,{"$f":"$B$35","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"G46*(Inputs!P$23-1)","v":0},{"$f":"H46*(Inputs!Q$23-1)","v":0},{"$f":"I46*(Inputs!R$23-1)","v":0},{"$f":"J46*(Inputs!S$23-1)","v":0},{"$f":"K46*(Inputs!T$23-1)","v":0},{"$f":"SUM(E47:K47)","v":0}]
[null,{"$f":"$B$36","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,0,0,0,{"$f":"SUM(E48:K48)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,92066.909324452194,186259.90854541803,187066.49917938921,187629.45959702469,188975.41760786722,841998.19425415131]
[]
[null,{"$f":"Inputs!B83","v":"Regulatory submissions"}]
[null,{"$f":"$B$34","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"SUMPRODUCT(Inputs!$I$84:$I$93,Inputs!P$84:P$93)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$84:$I$93,Inputs!Q$84:Q$93)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$84:$I$93,Inputs!R$84:R$93)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$84:$I$93,Inputs!S$84:S$93)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$84:$I$93,Inputs!T$84:T$93)*Inputs!$L$52*INDEX(IF(Inputs!$F$53=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$52,Inputs!$N$20:$T$20,0))","v":0},{"$f":"SUM(E52:K52)","v":0}]
[null,{"$f":"$B$35","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"G52*(Inputs!P$23-1)","v":0},{"$f":"H52*(Inputs!Q$23-1)","v":0},{"$f":"I52*(Inputs!R$23-1)","v":0},{"$f":"J52*(Inputs!S$23-1)","v":0},{"$f":"K52*(Inputs!T$23-1)","v":0},{"$f":"SUM(E53:K53)","v":0}]
[null,{"$f":"$B$36","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,0,0,0,0,0,{"$f":"SUM(E54:K54)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,295224.69615408842,224525.36088402499,225497.65843636644,445160.96479646902,313970.6567173216,1504379.3369882703]
[]
[null,{"$f":"$B$34","v":"Labour"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"E34+E40+E46+E52","v":0},0,1294855.7693284317,2817179.6857457203,2722685.3400084651,2933991.2207645318,2807521.4352233452,{"$f":"SUM(E57:K57)","v":12576233.451070495}]
[null,{"$f":"$B$35","v":"Labour escalation"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",0,0,22054.24009553084,81065.18606177585,90475.830842811876,106620.60553414877,122896.32053320491,{"$f":"SUM(E58:K58)","v":423112.18306747219}]
[null,{"$f":"$B$36","v":"Other"},{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",3108000,0,870240,870240,870240,870240,870240,{"$f":"SUM(E59:K59)","v":7459200}]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"SUM(E57:E59)","v":3108000},{"$f":"SUM(F57:F59)","v":0},{"$f":"SUM(G57:G59)","v":2187150.0094239628},3768484.8718074961,3683401.1708512772,3910851.8262986806,3800657.75575655,20458545.634137966]
[]
[]
[null,{"$f":"Inputs!$B$107","v":"Insurance costs"},null,null,null,null,null,null,null,null,null,"Total"]
[null,"Component","Dollar basis",null,{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029}]
[]
[null,"Insurance premium",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"Inputs!P$112*INDEX(IF(Inputs!$F$113=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$112,Inputs!$N$20:$T$20,0))","v":331731.93968487816},{"$f":"Inputs!Q$112*INDEX(IF(Inputs!$F$113=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$112,Inputs!$N$20:$T$20,0))","v":331731.93968487816},{"$f":"Inputs!R$112*INDEX(IF(Inputs!$F$113=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$112,Inputs!$N$20:$T$20,0))","v":331731.93968487816},{"$f":"Inputs!S$112*INDEX(IF(Inputs!$F$113=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$112,Inputs!$N$20:$T$20,0))","v":331731.93968487816},{"$f":"Inputs!T$112*INDEX(IF(Inputs!$F$113=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$112,Inputs!$N$20:$T$20,0))","v":331731.93968487816},{"$f":"SUM(E66:K66)","v":1658659.6984243908}]
[]
[null,"Total insurance costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"G66","v":331731.93968487816},{"$f":"H66","v":331731.93968487816},{"$f":"I66","v":331731.93968487816},{"$f":"J66","v":331731.93968487816},{"$f":"K66","v":331731.93968487816},{"$f":"SUM(E68:K68)","v":1658659.6984243908}]
[]
[]
[]
[null,"Total costs (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"E27+E60+E68","v":3108000},0,2518881.9491088409,4419306.316905505,4818040.6669422621,4890118.1565741589,4453988.4754469888,{"$f":"SUM(E72:K72)","v":24208335.564977754}]
[]
[null,"Debt raising costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",null,null,{"$f":"Inputs!P$121*INDEX(IF(Inputs!$F$122=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$121,Inputs!$N$20:$T$20,0))","v":52264.505517869649},{"$f":"Inputs!Q$121*INDEX(IF(Inputs!$F$122=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$121,Inputs!$N$20:$T$20,0))","v":119090.08847758872},{"$f":"Inputs!R$121*INDEX(IF(Inputs!$F$122=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$121,Inputs!$N$20:$T$20,0))","v":123646.63031465637},{"$f":"Inputs!S$121*INDEX(IF(Inputs!$F$122=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$121,Inputs!$N$20:$T$20,0))","v":119661.75162812906},{"$f":"Inputs!T$121*INDEX(IF(Inputs!$F$122=\"Mid\",Inputs!$N$21:$T$21,Inputs!$N$22:$T$22),MATCH(Inputs!$F$121,Inputs!$N$20:$T$20,0))","v":115676.87294160179},{"$f":"SUM(E74:K74)","v":530339.84887984558}]
[]
[null,"Total costs (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2024"},"Dollars",{"$f":"E72+E74","v":3108000},0,2571146.4546267106,4538396.4053830933,4941687.2972569186,5009779.9082022877,4569665.3483885908,{"$f":"SUM(E76:K76)","v":24738675.413857602}]
[]
[null,"End"]

{"sheet":"Outputs","index":4,"n_rows":86,"n_cols":15,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
["Outputs",null,null,null,{"$f":"Inputs!B8","v":"Real $2024"}]
[]
[null,"PTRM and Proposal"]
[]
[null,"Operating Costs",null,null,null,null,null,null,null,null,null,"Total","Total"]
[null,"Component","Dollar basis","Units",{"$f":"Inputs!N$20","v":2023},{"$f":"Inputs!O$20","v":2024},{"$f":"Inputs!P$20","v":2025},{"$f":"Inputs!Q$20","v":2026},{"$f":"Inputs!R$20","v":2027},{"$f":"Inputs!S$20","v":2028},{"$f":"Inputs!T$20","v":2029},"Next period","All years"]
[]
[null,"Costs"]
[null,"Maintenance costs (excl labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"(Calculations!E27-Calculations!E25)/10^6","v":0},{"$f":"(Calculations!F27-Calculations!F25)/10^6","v":0},{"$f":"(Calculations!G27-Calculations!G25)/10^6","v":0},{"$f":"(Calculations!H27-Calculations!H25)/10^6","v":0.31427539966578438},{"$f":"(Calculations!I27-Calculations!I25)/10^6","v":0.78808635676030403},{"$f":"(Calculations!J27-Calculations!J25)/10^6","v":0.6372006468257756},{"$f":"(Calculations!K27-Calculations!K25)/10^6","v":0.31427539966578438},{"$f":"SUM(G9:K9)","v":2.0538378029176485},{"$f":"SUM(E9:K9)","v":2.0538378029176485}]
[null,"Operating Costs (excl labour escalation)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"(Calculations!E60-Calculations!E58)/10^6","v":3.1080000000000001},{"$f":"(Calculations!F60-Calculations!F58)/10^6","v":0},{"$f":"(Calculations!G60-Calculations!G58)/10^6","v":2.1650957693284321},{"$f":"(Calculations!H60-Calculations!H58)/10^6","v":3.6874196857457204},{"$f":"(Calculations!I60-Calculations!I58)/10^6","v":3.5929253400084651},{"$f":"(Calculations!J60-Calculations!J58)/10^6","v":3.8042312207645317},{"$f":"(Calculations!K60-Calculations!K58)/10^6","v":3.6777614352233452},{"$f":"SUM(G10:K10)","v":16.927433451070495},{"$f":"SUM(E10:K10)","v":20.035433451070496}]
[null,"Insurance Costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"Calculations!E68/10^6","v":0},{"$f":"Calculations!F68/10^6","v":0},{"$f":"Calculations!G68/10^6","v":0.33173193968487819},{"$f":"Calculations!H68/10^6","v":0.33173193968487819},{"$f":"Calculations!I68/10^6","v":0.33173193968487819},{"$f":"Calculations!J68/10^6","v":0.33173193968487819},{"$f":"Calculations!K68/10^6","v":0.33173193968487819},{"$f":"SUM(G11:K11)","v":1.6586596984243909},1.6586596984243909]
[null,"Real input cost escalation",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"(Calculations!E25+Calculations!E58)/10^6","v":0},{"$f":"(Calculations!F25+Calculations!F58)/10^6","v":0},{"$f":"(Calculations!G25+Calculations!G58)/10^6","v":2.2054240095530839E-2},{"$f":"(Calculations!H25+Calculations!H58)/10^6","v":8.5879291809122515E-2},{"$f":"(Calculations!I25+Calculations!I58)/10^6","v":0.10529703048861479},{"$f":"(Calculations!J25+Calculations!J58)/10^6","v":0.11695434929897343},{"$f":"(Calculations!K25+Calculations!K58)/10^6","v":0.13021970087298068},{"$f":"SUM(G12:K12)","v":0.46040461256522225},0.46040461256522225]
[]
[null,"Total (excluding debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"SUM(E9:E12)","v":3.1080000000000001},0,2.5188819491088412,4.419306316905506,4.8180406669422613,4.8901181565741583,4.4539884754469883,{"$f":"SUM(G14:K14)","v":21.100335564977755},24.208335564977755]
[]
[null,"Debt Raising Costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"Calculations!E74/10^6","v":0},{"$f":"Calculations!F74/10^6","v":0},{"$f":"Calculations!G74/10^6","v":5.2264505517869653E-2},{"$f":"Calculations!H74/10^6","v":0.11909008847758873},{"$f":"Calculations!I74/10^6","v":0.12364663031465638},{"$f":"Calculations!J74/10^6","v":0.11966175162812906},{"$f":"Calculations!K74/10^6","v":0.11567687294160178},{"$f":"SUM(G16:K16)","v":0.53033984887984564},0.53033984887984564]
[]
[null,"Total (including debt raising costs)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"E14+E16","v":3.1080000000000001},0,2.5711464546267111,4.5383964053830947,4.9416872972569177,5.0097799082022876,4.5696653483885896,{"$f":"SUM(G18:K18)","v":21.630675413857599},24.738675413857599]
[]
[]
[null,"RIN Template"]
[]
[null,"Table 6.1: Non-network expenditure (real $m, Jun 2024)",null,null,null,null,null,null,null,null,null,{"$f":"L$5","v":"Total"},{"$f":"M$5","v":"Total"}]
[null,null,null,null,{"$f":"E$6","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L$6","v":"Next period"},{"$f":"M$6","v":"All years"}]
[]
[null,"Costs"]
[null,"IT & Communications",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",null,null,null,null,null,null,null,{"$f":"SUM(G27:K27)","v":0},{"$f":"SUM(E27:K27)","v":0}]
[null,"Motor Vehicles",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",null,null,null,null,null,null,null,{"$f":"SUM(G28:K28)","v":0},{"$f":"SUM(E28:K28)","v":0}]
[null,"Buildings and Property",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",null,null,null,null,null,null,null,{"$f":"SUM(G29:K29)","v":0},{"$f":"SUM(E29:K29)","v":0}]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"E34*E35","v":0},{"$f":"F34*F35","v":0},0.38845673079852949,0.89534388828708777,0.95060972169194358,0.96550671144944944,0.89244641313037532,{"$f":"SUM(G30:K30)","v":4.0923634653573853},{"$f":"SUM(E30:K30)","v":4.0923634653573853},null,"Note: Includes opex support costs or overheads"]
[null,null,null,"$Million"]
[null,"Total non-network opex",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"SUM(E27:E30)","v":0},0,0.38845673079852949,0.89534388828708777,0.95060972169194358,0.96550671144944944,0.89244641313037532,{"$f":"SUM(G32:K32)","v":4.0923634653573853},{"$f":"SUM(E32:K32)","v":4.0923634653573853}]
[]
[null,"Total labour costs","Real $2024","$Million",0,0,1.2948557693284317,2.9844796276236258,3.1686990723064787,3.2183557048314984,2.9748213771012511]
[null,"Support cost share of total labour costs","N/A","Percent",0.3,0.3,0.3,0.3,0.3,0.3,0.3]
[]
[null,"9.1 Operating and maintenance costs by category (real $, Jun 2024)",null,null,null,null,null,null,null,null,null,{"$f":"L$5","v":"Total"},{"$f":"M$5","v":"Total"}]
[null,null,null,null,{"$f":"E$6","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L$6","v":"Next period"},{"$f":"M$6","v":"All years"}]
[]
[null,"Costs"]
[null,"Maintenance (Lines and Cables, Substations, Communications and Secondary Systems)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E10+Calculations!E16+Calculations!E22","v":0},{"$f":"Calculations!F10+Calculations!F16+Calculations!F22","v":0},{"$f":"Calculations!G10+Calculations!G16+Calculations!G22","v":0},{"$f":"Calculations!H10+Calculations!H16+Calculations!H22","v":319089.50541313103},{"$f":"Calculations!I10+Calculations!I16+Calculations!I22","v":802907.55640610703},{"$f":"Calculations!J10+Calculations!J16+Calculations!J22","v":647534.3905906002},{"$f":"Calculations!K10+Calculations!K16+Calculations!K22","v":321598.78000556014},{"$f":"SUM(G41:K41)","v":2091130.2324153986},{"$f":"SUM(E41:K41)","v":2091130.2324153986},null,"Note: Includes maintenance costs"]
[null,"Operations/Control Room, Grid Planning, Customer Relations and Corporate Governance",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E37+Calculations!E43+Calculations!E49","v":3108000},{"$f":"Calculations!F37+Calculations!F43+Calculations!F49","v":0},{"$f":"Calculations!G37+Calculations!G43+Calculations!G49","v":1891925.3132698743},{"$f":"Calculations!H37+Calculations!H43+Calculations!H49","v":3543959.5109234708},{"$f":"Calculations!I37+Calculations!I43+Calculations!I49","v":3457903.5124149108},{"$f":"Calculations!J37+Calculations!J43+Calculations!J49","v":3465690.8615022115},{"$f":"Calculations!K37+Calculations!K43+Calculations!K49","v":3486687.0990392282},{"$f":"SUM(G42:K42)","v":15846166.297149697},{"$f":"SUM(E42:K42)","v":18954166.297149695},null,"Note: Includes the following operating cost categories 'Contract management', 'Network planning' and 'Network operations'"]
[null,"Regulatory",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E55","v":0},{"$f":"Calculations!F55","v":0},{"$f":"Calculations!G55","v":295224.69615408842},{"$f":"Calculations!H55","v":224525.36088402499},{"$f":"Calculations!I55","v":225497.65843636644},{"$f":"Calculations!J55","v":445160.96479646902},{"$f":"Calculations!K55","v":313970.6567173216},{"$f":"SUM(G43:K43)","v":1504379.3369882705},{"$f":"SUM(E43:K43)","v":1504379.3369882705},null,"Note: Includes the 'Regulatory Approvals' operating cost category"]
[null,"Insurance",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E68","v":0},{"$f":"Calculations!F68","v":0},{"$f":"Calculations!G68","v":331731.93968487816},{"$f":"Calculations!H68","v":331731.93968487816},{"$f":"Calculations!I68","v":331731.93968487816},{"$f":"Calculations!J68","v":331731.93968487816},{"$f":"Calculations!K68","v":331731.93968487816},{"$f":"SUM(G44:K44)","v":1658659.6984243908},{"$f":"SUM(E44:K44)","v":1658659.6984243908},null,"Note: Includes insurance premiums"]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E74","v":0},{"$f":"Calculations!F74","v":0},{"$f":"Calculations!G74","v":52264.505517869649},{"$f":"Calculations!H74","v":119090.08847758872},{"$f":"Calculations!I74","v":123646.63031465637},{"$f":"Calculations!J74","v":119661.75162812906},{"$f":"Calculations!K74","v":115676.87294160179},{"$f":"SUM(G45:K45)","v":530339.84887984558},{"$f":"SUM(E45:K45)","v":530339.84887984558},null,"Note: Includes debt raising costs"]
[null,null,null,"$Dollars"]
[null,"Total opex (Incl DRC)",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"SUM(E41:E45)","v":3108000},0,2571146.4546267106,4538396.4053830933,4941687.2972569186,5009779.9082022877,4569665.3483885899,{"$f":"SUM(G47:K47)","v":21630675.413857602},{"$f":"SUM(E47:K47)","v":24738675.413857602}]
[]
[{"$f":"IF(SUM(E49:K49)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,{"$f":"IF(ROUND(E47/10^6-E$18,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F47/10^6-F$18,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"9.2 Operating and maintenance direct and indirect costs (real $, Jun 2024)",null,null,null,null,null,null,null,null,null,{"$f":"L$5","v":"Total"},{"$f":"M$5","v":"Total"}]
[null,null,null,null,{"$f":"E$6","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L$6","v":"Next period"},{"$f":"M$6","v":"All years"}]
[]
[null,"Costs"]
[null,"Operating and maintenance direct costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E27+(Calculations!E57*(1-E$35))","v":0},{"$f":"Calculations!F27+(Calculations!F57*(1-F$35))","v":0},{"$f":"Calculations!G27+(Calculations!G57*(1-G$35))","v":906399.03852990211},{"$f":"Calculations!H27+(Calculations!H57*(1-H$35))","v":2291115.285435135},{"$f":"Calculations!I27+(Calculations!I57*(1-I$35))","v":2708787.2944120327},{"$f":"Calculations!J27+(Calculations!J57*(1-J$35))","v":2701328.2451257724},{"$f":"Calculations!K27+(Calculations!K57*(1-K$35))","v":2286863.7846619016},{"$f":"SUM(G55:K55)","v":10894493.648164744},{"$f":"SUM(E55:K55)","v":10894493.648164744},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 $2024"},"$Dollars",{"$f":"Calculations!E76-Outputs!E55","v":3108000},{"$f":"Calculations!F76-Outputs!F55","v":0},{"$f":"Calculations!G76-Outputs!G55","v":1664747.4160968084},{"$f":"Calculations!H76-Outputs!H55","v":2247281.1199479583},{"$f":"Calculations!I76-Outputs!I55","v":2232900.0028448859},{"$f":"Calculations!J76-Outputs!J55","v":2308451.6630765153},{"$f":"Calculations!K76-Outputs!K55","v":2282801.5637266892},{"$f":"SUM(G56:K56)","v":10736181.765692856},{"$f":"SUM(E56:K56)","v":13844181.76569286},null,"Note: Includes all other opex excluding the direct costs above"]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"SUM(E53:E56)","v":3108000},0,2571146.4546267106,4538396.4053830933,4941687.2972569186,5009779.9082022877,4569665.3483885908,{"$f":"SUM(G58:K58)","v":21630675.413857602},{"$f":"SUM(E58:K58)","v":24738675.413857602}]
[]
[{"$f":"IF(SUM(E60:K60)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,{"$f":"IF(ROUND(E58/10^6-E$18,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F58/10^6-F$18,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"9.3 Total capital operating and maintenance costs broken down by cost component (real $m, Jun 2024)",null,null,null,null,null,null,null,null,null,{"$f":"L$5","v":"Total"},{"$f":"M$5","v":"Total"}]
[null,null,null,null,{"$f":"E$6","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L$6","v":"Next period"},{"$f":"M$6","v":"All years"}]
[]
[null,"Costs"]
[null,"Transmission lines and substations",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"(Calculations!E10+Calculations!E16)/10^6","v":0},{"$f":"(Calculations!F10+Calculations!F16)/10^6","v":0},{"$f":"(Calculations!G10+Calculations!G16)/10^6","v":0},{"$f":"(Calculations!H10+Calculations!H16)/10^6","v":0},{"$f":"(Calculations!I10+Calculations!I16)/10^6","v":0.48307271840974025},{"$f":"(Calculations!J10+Calculations!J16)/10^6","v":0.32717934726991699},{"$f":"(Calculations!K10+Calculations!K16)/10^6","v":0},{"$f":"SUM(G66:K66)","v":0.81025206567965724},{"$f":"SUM(E66:K66)","v":0.81025206567965724},null,"Note: Transmission lines and substations maintenance expenditure"]
[null,"SIPS control",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"Calculations!E22/10^6","v":0},{"$f":"Calculations!F22/10^6","v":0},{"$f":"Calculations!G22/10^6","v":0},{"$f":"Calculations!H22/10^6","v":0.31908950541313102},{"$f":"Calculations!I22/10^6","v":0.31983483799636675},{"$f":"Calculations!J22/10^6","v":0.32035504332068332},{"$f":"Calculations!K22/10^6","v":0.32159878000556014},{"$f":"SUM(G67:K67)","v":1.2808781667357412},{"$f":"SUM(E67:K67)","v":1.2808781667357412},null,"Note: SIPS control maintenance expenditure"]
[null,"Other",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"Calculations!E76/10^6-SUM(E66:E67)","v":3.1080000000000001},{"$f":"Calculations!F76/10^6-SUM(F66:F67)","v":0},{"$f":"Calculations!G76/10^6-SUM(G66:G67)","v":2.5711464546267107},{"$f":"Calculations!H76/10^6-SUM(H66:H67)","v":4.2193068999699621},{"$f":"Calculations!I76/10^6-SUM(I66:I67)","v":4.1387797408508114},{"$f":"Calculations!J76/10^6-SUM(J66:J67)","v":4.3622455176116874},{"$f":"Calculations!K76/10^6-SUM(K66:K67)","v":4.2480665683830301},{"$f":"SUM(G68:K68)","v":19.539545181442204},{"$f":"SUM(E68:K68)","v":22.647545181442201},null,"Note: Includes all other opex excluding maintenance expenditure"]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Million",{"$f":"SUM(E66:E68)","v":3.1080000000000001},{"$f":"SUM(F66:F68)","v":0},2.5711464546267107,4.538396405383093,4.9416872972569186,5.0097799082022876,4.5696653483885905,21.630675413857603,24.738675413857599]
[]
[{"$f":"IF(SUM(E72:K72)=0,0,1)","v":0},"Check - Opex (incl DRC)",null,null,{"$f":"IF(ROUND(E70-E$18,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F70-F$18,3)=0,0,1)","v":0},0,0,0,0,0]
[]
[null,"7.1 Regulatory requirements/contractual arrangement costs  (real $, Jun 2024)",null,null,null,null,null,null,null,null,null,{"$f":"L$5","v":"Total"},{"$f":"M$5","v":"Total"}]
[null,null,null,null,{"$f":"E$6","v":2023},2024,2025,2026,2027,2028,2029,{"$f":"L$6","v":"Next period"},{"$f":"M$6","v":"All years"}]
[]
[null,"Costs"]
[null,"Network Operator Appointment Fee",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"E56","v":3108000},null,null,null,null,null,null,{"$f":"SUM(G78:K78)","v":0},{"$f":"SUM(E78:K78)","v":3108000}]
[null,"Regulatory submissions",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E55","v":0},{"$f":"Calculations!F55","v":0},{"$f":"Calculations!G55","v":295224.69615408842},{"$f":"Calculations!H55","v":224525.36088402499},{"$f":"Calculations!I55","v":225497.65843636644},{"$f":"Calculations!J55","v":445160.96479646902},{"$f":"Calculations!K55","v":313970.6567173216},{"$f":"SUM(G79:K79)","v":1504379.3369882705},{"$f":"SUM(E79:K79)","v":1504379.3369882705},null,"Note: Regulatory submission operating cost category"]
[null,"Environmental Approvals",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c"]
[null,"Independent Engineer",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c","c-i-c",null,"Note: SIPSA Technical Reviews including 8 Independent Engineers (NOD, SIPSA, PGSA)"]
[null,"SIPS Contract Management, Operations, Annual Testing, and Defect Rectification",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",{"$f":"Calculations!E22+Calculations!E37+Calculations!E43+Calculations!E49-E78","v":0},{"$f":"Calculations!F22+Calculations!F37+Calculations!F43+Calculations!F49-F78","v":0},{"$f":"Calculations!G22+Calculations!G37+Calculations!G43+Calculations!G49-G78","v":1891925.3132698743},{"$f":"Calculations!H22+Calculations!H37+Calculations!H43+Calculations!H49-H78","v":3863049.0163366017},{"$f":"Calculations!I22+Calculations!I37+Calculations!I43+Calculations!I49-I78","v":3777738.3504112773},{"$f":"Calculations!J22+Calculations!J37+Calculations!J43+Calculations!J49-J78","v":3786045.9048228948},{"$f":"Calculations!K22+Calculations!K37+Calculations!K43+Calculations!K49-K78","v":3808285.8790447884},{"$f":"SUM(G82:K82)","v":17127044.463885438},{"$f":"SUM(E82:K82)","v":17127044.463885438},null,"Note: Maintenance activity for SIPS control plus operating costs categories including contract management, network planning, network operations"]
[]
[null,"Total operating costs",{"$f":"Inputs!$B$8","v":"Real $2024"},"$Dollars",3232320,600880,2756950.0094239628,4139374.3772206269,4003236.0088476436,4231206.8696193639,4122256.5357621098,19253023.800873708,23086223.800873704]
[]
[null,"End"]