{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Historic Data","Inputs","Calculation","Output","Graphs"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Historic Data","index":0,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,"Murraylink:  Access Arrangement"]
[null,null,"Operating Expenditure Forecast"]
["Sheet:","Historic Data",null,null,null,"As required in the RIN, nominal dollars for FY 2020 and FY 2021 to be converted into real FY 2023 dollars"]
[null,"Consistent with ARIN","FY21",null,null,"FY 21 (rather than FY 20)  is to be chosen as the base year. This is because FY 21 is more repsentative of future expenditures compared for FY 20."]
[null,null,null,null,null,"Notable change from FY 20 to FY 21:"]
[null,"Opex costs ","$'000",null,null,"* insurance cost has increased"]
[null,"NETWORK OPERATIONS & MAINTENANCE","",null,null,"* Commercial management fee - reduction revenue from other asset  - Murraylink contributing to a higher proportion of revenue - likely to be ongoing"]
[null,"Operating & Maintenance Costs",2677.5770509999993]
[null,"Commercial Management Fees",598.103836]
[null,0,""]
[null,"OTHER COSTS",""]
[null,"Insurance",473.21907599999997]
[null,"Connection fees ",283.85387800000001]
[null,"Staff Costs",0]
[null,"Tax on Property & Capital",79.415512000000007]
[null,"Travel Costs",0]
[null,"Accounting/Audit Fees",11.626218999999999]
[null,"Legal Fees",0]
[null,"Other",153.56736642078181]
[null,0,""]
[null,"Depreciation ",5145.3816210482364]
[null,"Impairment",0]
[null,"Amortisation",0]
[null,"Total",{"$f":"SUM(C7:C23)","v":9422.744559469018}]
[]
[null,"Regulatoy Account Total",9422.744559469018]
[null,"Difference",{"$f":"C24-C26","v":0}]
[]
[null,"Categorised for Forecast Purposes (FY 21)","Amount ($'000)","Perecentage"]
[]
[]
[null,{"$f":"B8","v":"Operating & Maintenance Costs"},{"$f":"INDEX($C$7:$C$23,MATCH($B32,$B$7:$B$23,0),0)","v":2677.5770509999993},{"$f":"C32/$C$43","v":0.62598780827061906}]
[null,{"$f":"B9","v":"Commercial Management Fees"},{"$f":"INDEX($C$7:$C$23,MATCH($B33,$B$7:$B$23,0),0)","v":598.103836},{"$f":"C33/$C$43","v":0.13983004122180531}]
[null,{"$f":"B12","v":"Insurance"},{"$f":"INDEX($C$7:$C$23,MATCH($B34,$B$7:$B$23,0),0)","v":473.21907599999997},0.1106333698619258]
[null,{"$f":"B13","v":"Connection fees "},{"$f":"INDEX($C$7:$C$23,MATCH($B35,$B$7:$B$23,0),0)","v":283.85387800000001},6.636188747284559E-2]
[null,"Staff Costs",{"$f":"INDEX($C$7:$C$23,MATCH($B36,$B$7:$B$23,0),0)","v":0},0]
[null,"Tax on Property & Capital",{"$f":"INDEX($C$7:$C$23,MATCH($B37,$B$7:$B$23,0),0)","v":79.415512000000007},1.8566465633921756E-2]
[null,"Travel Costs",{"$f":"INDEX($C$7:$C$23,MATCH($B38,$B$7:$B$23,0),0)","v":0},0]
[null,"Accounting/Audit Fees",{"$f":"INDEX($C$7:$C$23,MATCH($B39,$B$7:$B$23,0),0)","v":11.626218999999999},2.7180810156578494E-3]
[null,"Legal Fees",{"$f":"INDEX($C$7:$C$23,MATCH($B40,$B$7:$B$23,0),0)","v":0},0]
[null,"Other",{"$f":"INDEX($C$7:$C$23,MATCH($B41,$B$7:$B$23,0),0)","v":153.56736642078181},3.5902346523224771E-2]
[]
[null,"Total in forecast",{"$f":"SUM(C32:C41)","v":4277.3629384207807},{"$f":"SUM(D32:D41)","v":1}]
[]
[null,"Debt Rasing Cost",0]
[]
[]
[null,"Total",{"$f":"C43-SUM(C45:C46)","v":4277.3629384207807}]
[]
[null,{"$f":"B24","v":"Total"},4277.3629384207816]
[null,"Difference",{"$f":"C48-C50","v":0}]
[]
[]
[null,"Nominal","FY20 ($000)"]
[null,"Operating and maintenance costs",2661.6603420000001]
[null,"Management fees and expenses",532.84398199999998]
[null,"Insurance ",407.65533600000003]
[null,"Connection fees",276.71637400000003]
[null,"Tax on property ",81.522044999999991]
[null,"Accounting/audit fees ",12.428889]
[null,"Legal fees",0]
[null,"Other costs ",138.7718279213984]
[]
[null,"Total",4111.5987959213981]

{"sheet":"Inputs","index":1,"n_rows":25,"n_cols":24,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,17,7,20],[7,10,7,15]]}
[null,null,null,null,null,null,null,null,null,"Murraylink:  Access Arrangement"]
[null,null,null,null,null,null,null,null,null,"Operating Expenditure Forecast"]
[]
[null,null,null,null,null,null,null,null,null,null,"CPI",null,null,null,null,null,null,null,null,null,null,null,null,"CPI data source"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FY 2018  to FY 2022 - based in ABS CPI"]
[null,null,null,null,null,null,null,null,null,null,"FY 17/18","FY 18/19","FY 19/20","FY 20/21","FY 21/22","FY 22/23","FY 23/24","FY 24/25","FY 25/26","FY 26/27","FY 27/28",null,null,"FY 2023 - https://www.rba.gov.au/publications/smp/2021/aug/economic-outlook.html"]
[null,null,null,null,null,null,null,null,null,null,"2017-03-01",{"$f":"DATE(YEAR(K7)+1,MONTH(K7),DAY(K7))","v":"2018-03-01"},{"$f":"DATE(YEAR(L7)+1,MONTH(L7),DAY(L7))","v":"2019-03-01"},"2020-03-01","2021-03-01","2022-03-01",null,null,null,null,null,null,null,"FY 2024 to FY 2028 - PTRM"]
[null,null,null,null,null,null,null,null,null,null,"Actual",null,null,null,null,null,"RBA","PTRM"]
[null,null,null,null,null,null,null,null,null,"CPI",2.1256931608133023E-2,1.9004524886877761E-2,1.3321492007104752E-2,2.1910604732690686E-2,1.1149228130360234E-2,5.0890585241730291E-2,4.4999999999999998E-2,0.04,3.5000000000000003E-2,3.0000000000000002E-2,2.5000000000000001E-2]
[]
[null,null,null,null,null,null,null,null,null,"Index",{"$f":"L11/(1+L9)","v":0.89184826472962064},{"$f":"M11/(1+M9)","v":0.90879741727199348},{"$f":"N11/(1+N9)","v":0.92090395480225973},{"$f":"O11/(1+O9)","v":0.94108151735270373},{"$f":"P11/(1+P9)","v":0.95157384987893456},1,{"$f":"P11*(1+Q9)","v":1.0449999999999999},{"$f":"Q11*(1+R9)","v":1.0868},{"$f":"R11*(1+S9)","v":1.124838},{"$f":"S11*(1+T9)","v":1.15858314},{"$f":"T11*(1+U9)","v":1.1875477184999998}]
[]
[null,null,null,null,null,null,null,null,null,null,2.1256931608133023E-2,1.9004524886877761E-2,1.3321492007104752E-2,2.1910604732690686E-2,1.1149228130360234E-2,2.2499999999999999E-2,2.3749618436947673E-2,2.3749618436947673E-2,2.3749618436947673E-2,2.3749618436947673E-2,2.3749618436947673E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2020/21?","2021/22?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N6","v":"FY 20/21"},"FY 21/22","FY 22/23","FY 23/24","FY 24/25","FY 25/26","FY 26/27",{"$f":"U6","v":"FY 27/28"}]
[null,"WPI",null,null,null,null,null,null,null,null,null,null,null,1.6949152542372836E-2,9.8252646141938002E-3,3.7938524011807656E-3,5.1289409836666033E-3,8.5049899184493228E-3,1.1396303374195879E-2,6.830847002371368E-3,{"$f":"T16","v":6.830847002371368E-3}]
[null,"Source: Powerlink Transmission Determination Proposal"]
[null,"Source: Energex Revenue Determination Proposal"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"SOCI (Cyber)",null,null,null,null,null,210680.29994717613,127545.64992201104,91715.290877267122,90626.447476611895,82875.429999999993,82875.429999999993]
[null,null,null,null,null,null,null,null,null,"Insurance",null,null,null,473219.076,{"$f":"N25+(($Q25-$N25)/3)","v":563384.68432597537},{"$f":"O25+(($Q25-$N25)/3)","v":653550.29265195073},743715.9009779261,786068.87820370134,829155.03941355762,833779.27403186972,833344.39988013089]

{"sheet":"Calculation","index":2,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[null,"Murraylink:  Access Arrangement"]
[null,"Operating Expenditure Forecast"]
[null,null,"$'000","FY21","FY22","FY23","FY24","FY25","FY26","FY27","FY28"]
[]
[null,"Calculating Base Opex"]
[null,"Base Year Operating expenditure in RIN"]
[null,"Operating Expenditure Financial Year 2021","Nominal",{"$f":"TotalOpex","v":4277.3629384207807}]
[]
[null,"Removal of reported items subject to different calculation"]
[null,"Insurance","Nominal",{"$f":"INDEX('Historic Data'!$C$32:$C$41,MATCH(B10,'Historic Data'!$B$32:$B$41,0),0)","v":473.21907599999997}]
[null,"Subtotal","Nominal",{"$f":"D7-SUM(D10:D10)","v":3804.1438624207808}]
[]
[null,"Separation into categories relevant for forecasting"]
[]
[null,"Controllable Costs","Nominal",{"$f":"D20-D18","v":3520.2899844207809}]
[]
[null,{"$f":"'Historic Data'!B35","v":"Connection fees "},"Nominal",{"$f":"IFERROR(INDEX('Historic Data'!$C$32:$C$46,MATCH($B17,'Historic Data'!$B$32:$B$41,0),0),0)","v":283.85387800000001}]
[null,"Uncontrollable Costs","Nominal",{"$f":"SUM(D17:D17)","v":283.85387800000001}]
[]
[null,"Total",{"$f":"C18","v":"Nominal"},{"$f":"D11","v":3804.1438624207808}]
[]
[null,"Adjustment for PTRM $"]
[null,{"$f":"B15","v":"Controllable Costs"},"Nominal",{"$f":"D15","v":3520.2899844207809}]
[null,{"$f":"B18","v":"Uncontrollable Costs"},"Nominal",{"$f":"D18","v":283.85387800000001}]
[]
[null,"Total",{"$f":"C24","v":"Nominal"},{"$f":"SUM(D23:D24)","v":3804.1438624207808}]
[]
[null,"Adjustment Factor"]
[null,"FY22"]
[null,{"$f":"B23","v":"Controllable Costs"},"CPI Mar 2022",null,{"$f":"Inputs!O9","v":1.1149228130360234E-2}]
[null,{"$f":"B24","v":"Uncontrollable Costs"},"CPI Mar 2022",null,{"$f":"E30","v":1.1149228130360234E-2}]
[]
[null,{"$f":"B23","v":"Controllable Costs"},"$2022",null,{"$f":"D23*(1+E30)","v":3559.5385005421103}]
[null,{"$f":"B24","v":"Uncontrollable Costs"},"$2022",null,{"$f":"D24*(1+E31)","v":287.01862964150945}]
[]
[null,"Total",{"$f":"C34","v":"$2022"},null,{"$f":"SUM(E33:E34)","v":3846.5571301836198}]
[]
[null,"FY23"]
[null,{"$f":"B30","v":"Controllable Costs"},"CPI Forecast",null,null,{"$f":"Inputs!P9","v":5.0890585241730291E-2}]
[null,{"$f":"B31","v":"Uncontrollable Costs"},"CPI Forecast",null,null,{"$f":"F39","v":5.0890585241730291E-2}]
[]
[null,{"$f":"B33","v":"Controllable Costs"},"$2023",null,null,null,{"$f":"E33*(1+F39)","v":3740.6854980251696}]
[null,{"$f":"B34","v":"Uncontrollable Costs"},"$2023",null,null,null,{"$f":"E34*(1+F40)","v":301.62517567924527}]
[]
[null,"Total",{"$f":"C43","v":"$2023"},null,null,null,{"$f":"SUM(G42:G43)","v":4042.310673704415}]
[]
[null,"Forecast trend"]
[null,"Forecast WPI"]
[]
[null,{"$f":"B33","v":"Controllable Costs"},"$2023",{"$f":"G42","v":3740.6854980251696},{"$f":"D50","v":3740.6854980251696},{"$f":"E50","v":3740.6854980251696},3740.6854980251696,3740.6854980251696,3740.6854980251696,3740.6854980251696,3740.6854980251696]
[null,{"$f":"B34","v":"Uncontrollable Costs"},"$2023",{"$f":"G43","v":301.62517567924527},{"$f":"D51","v":301.62517567924527},{"$f":"E51","v":301.62517567924527},301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527]
[]
[null,"Total","$2023",{"$f":"SUM(D50:D52)","v":4042.310673704415},4042.310673704415,4042.310673704415,4042.310673704415,4042.310673704415,4042.310673704415,4042.310673704415,4042.310673704415]
[]
[]
[null,"Step Changes"]
[null,"SOCI (Cyber)","$2023",0,0,{"$f":"Inputs!P24/1000","v":210.68029994717614},{"$f":"Inputs!Q24/1000","v":127.54564992201104},{"$f":"Inputs!R24/1000","v":91.715290877267122},{"$f":"Inputs!S24/1000","v":90.626447476611901},{"$f":"Inputs!T24/1000","v":82.875429999999994},{"$f":"Inputs!U24/1000","v":82.875429999999994}]
[]
[]
[null,{"$f":"B50","v":"Controllable Costs"},"$2023",{"$f":"D50+D57","v":3740.6854980251696},{"$f":"E50+E57","v":3740.6854980251696},{"$f":"F50+F57","v":3951.3657979723457},3868.2311479471805,3832.4007889024369,3831.3119455017813,3823.5609280251697,3823.5609280251697]
[null,{"$f":"B51","v":"Uncontrollable Costs"},"$2023",{"$f":"D51","v":301.62517567924527},{"$f":"E51","v":301.62517567924527},301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527]
[]
[]
[null,"Total","$2023",{"$f":"SUM(D60:D61)","v":4042.310673704415},{"$f":"SUM(E60:E61)","v":4042.310673704415},{"$f":"SUM(F60:F61)","v":4252.990973651591},4169.8563236264254,4134.0259645816823,4132.9371211810267,4125.1861037044146,4125.1861037044146]
[]
[null,"Separate Line item forecast",null,null,"Display purposes only"]
[null,{"$f":"Inputs!J25","v":"Insurance"},"$2023",{"$f":"D10*(1+$E$30)*(1+$F$39)","v":502.84599928301884},{"$f":"Inputs!O25/1000","v":563.3846843259754},{"$f":"Inputs!P25/1000","v":653.55029265195071},{"$f":"Inputs!Q25/1000","v":743.71590097792614},{"$f":"Inputs!R25/1000","v":786.06887820370139},{"$f":"Inputs!S25/1000","v":829.15503941355757},{"$f":"Inputs!T25/1000","v":833.7792740318697},{"$f":"Inputs!U25/1000","v":833.34439988013094}]
[]
[null,{"$f":"B60","v":"Controllable Costs"},"$2023",{"$f":"D60+D67","v":4243.5314973081886},{"$f":"E60+E67","v":4304.0701823511454},4604.916090624296,4611.9470489251071,4618.4696671061383,4660.4669849153388,4657.3402020570393,4656.9053279053005]
[null,{"$f":"B61","v":"Uncontrollable Costs"},"$2023",{"$f":"D61","v":301.62517567924527},301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527]
[]
[]
[null,"Total","$2023",{"$f":"SUM(D69:D70)","v":4545.1566729874339},{"$f":"SUM(E69:E70)","v":4605.6953580303907},{"$f":"SUM(F69:F70)","v":4906.5412663035413},{"$f":"SUM(G69:G70)","v":4913.5722246043524},4920.0948427853837,4962.0921605945841,4958.9653777362846,4958.5305035845458]
[]
[null,"Total"]
[null,{"$f":"B69","v":"Controllable Costs"},"$2023",{"$f":"D69","v":4243.5314973081886},{"$f":"E69","v":4304.0701823511454},4604.916090624296,4611.9470489251071,4618.4696671061383,4660.4669849153388,4657.3402020570393,4656.9053279053005]
[null,{"$f":"B70","v":"Uncontrollable Costs"},"$2023",{"$f":"D70","v":301.62517567924527},301.62517567924527,301.62517567924527,{"$f":"G70","v":301.62517567924527},301.62517567924527,301.62517567924527,301.62517567924527,301.62517567924527]
[]
[]
[null,"Total","$2023",{"$f":"SUM(D76:D77)","v":4545.1566729874339},{"$f":"SUM(E76:E77)","v":4605.6953580303907},{"$f":"SUM(F76:F77)","v":4906.5412663035413},{"$f":"SUM(G76:G79)","v":4913.5722246043524},4920.0948427853837,4962.0921605945841,4958.9653777362846,4958.5305035845458]

{"sheet":"Output","index":3,"n_rows":91,"n_cols":15,"rows_kept":91,"cut":false,"hidden":false,"merged":[[8,4,8,5],[9,4,9,5],[10,4,10,5],[62,0,62,1],[55,0,55,1],[56,0,56,1],[58,0,58,1],[59,0,59,1],[60,0,60,1],[61,0,61,1],[57,0,57,1]]}
["Murraylink:  Access Arrangement"]
["Operating Expenditure Forecast"]
[]
[null,null,null,"FY21","FY22","FY23","FY24","FY25","FY26","FY27","FY28"]
[]
["PTRM input"]
[]
[null,null,null,null,"Cost ('$000)",null,{"$f":"G4","v":"FY24"},{"$f":"H4","v":"FY25"},"FY26","FY27","FY28",null,null,null,"Total"]
[null,null,null,null,{"$f":"Calculation!B76","v":"Controllable Costs"},null,{"$f":"Calculation!G76","v":4611.9470489251071},{"$f":"Calculation!H76","v":4618.4696671061383},{"$f":"Calculation!I76","v":4660.4669849153388},{"$f":"Calculation!J76","v":4657.3402020570393},{"$f":"Calculation!K76","v":4656.9053279053005},null,null,null,{"$f":"SUM(G9:K9)","v":23205.129230908926}]
[null,null,null,null,{"$f":"Calculation!B77","v":"Uncontrollable Costs"},null,{"$f":"Calculation!G77","v":301.62517567924527},{"$f":"Calculation!H77","v":301.62517567924527},{"$f":"Calculation!I77","v":301.62517567924527},{"$f":"Calculation!J77","v":301.62517567924527},{"$f":"Calculation!K77","v":301.62517567924527},null,null,null,{"$f":"SUM(G10:K10)","v":1508.1258783962264}]
[null,null,null,null,{"$f":"Calculation!B78","v":0},null,{"$f":"Calculation!G78/1000000","v":0},{"$f":"Calculation!H78/1000000","v":0},{"$f":"Calculation!I78/1000000","v":0},{"$f":"Calculation!J78/1000000","v":0},{"$f":"Calculation!K78/1000000","v":0},null,null,null,{"$f":"SUM(G11:K11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O9:O11)","v":24713.255109305152}]
["Graphs"]
["By cost type"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"E9","v":"Controllable Costs"},{"$f":"K9","v":4656.9053279053005}]
[null,null,null,null,null,null,null,null,null,{"$f":"E10","v":"Uncontrollable Costs"},{"$f":"K10","v":301.62517567924527}]
[]
[]
["RIN outputs (opex summary)",null,"($)",null,null,{"$f":"D4","v":"FY21"},"FY22","FY23","FY24","FY25","FY26","FY27","FY28"]
[]
[]
[]
[]
["Base Opex",null,null,null,null,{"$f":"Calculation!D20*(1+Inputs!$O$9)*(1+Inputs!$P$9)*1000","v":4042310.6737044151},{"$f":"Calculation!$E$64*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!F50:F51)*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!G50:G51)*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!H50:H51)*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!I50:I51)*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!J50:J51)*1000","v":4042310.6737044151},{"$f":"SUM(Calculation!K50:K51)*1000","v":4042310.6737044151}]
["Increment from base year to final year",null,null,null,null,null,null,0,0,0,0,0,0]
["Price Growth",null,null,null,null,null,null,null,{"$f":"I33-I30-I25","v":871134.00525001483},877692.45379009144,919690.86044269288,916571.82860186929,916136.95445013093]
["Output growth",null,null,null,null,null,null,null,0,0,0,0,0]
["Productivity growth",null,null,null,null,null,null,null,0,0,0,0,0]
["Step Change",null,null,null,null,null,null,null,{"$f":"Calculation!G57","v":127.54564992201104},{"$f":"Calculation!H57","v":91.715290877267122},{"$f":"Calculation!I57","v":90.626447476611901},{"$f":"Calculation!J57","v":82.875429999999994},{"$f":"Calculation!K57","v":82.875429999999994}]
["Category specific",null,null,null,null,0,0,0,0,0,0,0,0]
[]
["Total",null,null,null,null,{"$f":"Calculation!D80*1000","v":4545156.6729874341},{"$f":"Calculation!E80*1000","v":4605695.3580303909},{"$f":"Calculation!F80*1000","v":4906541.2663035411},{"$f":"Calculation!G80*1000","v":4913572.2246043524},{"$f":"Calculation!H80*1000","v":4920094.8427853836},{"$f":"Calculation!I80*1000","v":4962092.1605945844},{"$f":"Calculation!J80*1000","v":4958965.3777362844},{"$f":"Calculation!K80*1000","v":4958530.503584546}]
[]
["Destination: Workbool 1 Table 2.16.1"]
[]
[]
[]
["EBSS Table ($'m)",null,null,{"$f":"D4","v":"FY21"},{"$f":"E4","v":"FY22"},"FY23","FY24","FY25","FY26","FY27","FY28"]
[]
[{"$f":"Calculation!B76","v":"Controllable Costs"},null,"$FY23",{"$f":"(Calculation!D76)/1000","v":4.2435314973081883},{"$f":"(Calculation!E76)/1000","v":4.3040701823511451},{"$f":"(Calculation!F76)/1000","v":4.6049160906242959},{"$f":"(Calculation!G76)/1000","v":4.6119470489251073},{"$f":"(Calculation!H76)/1000","v":4.6184696671061385},{"$f":"(Calculation!I76)/1000","v":4.6604669849153391},{"$f":"(Calculation!J76)/1000","v":4.6573402020570391},{"$f":"(Calculation!K76)/1000","v":4.6569053279053003}]
[{"$f":"Calculation!B77","v":"Uncontrollable Costs"},null,"$FY23",{"$f":"(Calculation!D77)/1000","v":0.30162517567924529},{"$f":"(Calculation!E77)/1000","v":0.30162517567924529},{"$f":"(Calculation!F77)/1000","v":0.30162517567924529},{"$f":"(Calculation!G77)/1000","v":0.30162517567924529},{"$f":"(Calculation!H77)/1000","v":0.30162517567924529},{"$f":"(Calculation!I77)/1000","v":0.30162517567924529},{"$f":"(Calculation!J77)/1000","v":0.30162517567924529},{"$f":"(Calculation!K77)/1000","v":0.30162517567924529}]
["Total",null,"$FY23",{"$f":"SUM(D41:D42)","v":4.5451566729874333},{"$f":"SUM(E41:E42)","v":4.6056953580303901},4.9065412663035408,4.9135722246043523,4.9200948427853834,4.962092160594584,4.9589653777362841,4.9585305035845453]
[]
["Destination: Workbool 3 (EBSS) Table 7.5.1.2"]
[]
[]
["Commercial Services Fee"]
[]
["Commercial Services Fee",null,{"$f":"C41","v":"$FY23"},{"$f":"'Historic Data'!C9*(1+Calculation!E30)*(1+Calculation!F39)/1000","v":0.63554944494339627},{"$f":"D50","v":0.63554944494339627},{"$f":"E50","v":0.63554944494339627},0.63554944494339627,0.63554944494339627,0.63554944494339627,0.63554944494339627,0.63554944494339627]
[]
[]
[]
["RIN output (non-network)"]
[]
["Insurance",null,"$FY23",{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":502.84599928301895},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":509.54359801633098},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":542.82719465776142},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":543.60505326793884},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":544.32667249762903},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":548.97297729202319},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":548.627050767583},{"$f":"VLOOKUP($A56,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":548.57893917471029}]
["Connection fees ",null,"$FY23",{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":301.62517567924533},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":305.64263708382009},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":325.60733939530894},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":326.07392705889362},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":326.50678031265153},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":329.29380159126703},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":329.08630237907255},{"$f":"VLOOKUP($A57,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":329.05744330955002}]
["Tax on Property & Capital",null,"$FY23",{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":84.387495169811331},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":85.511484585184206},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":91.097129802243629},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":91.227669847909183},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":91.348771814210494},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":92.128513572031906},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":92.070460265548547},{"$f":"VLOOKUP($A58,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":92.062386189555212}]
["Accounting/Audit Fees",null,"$FY23",{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":12.354104066037737},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":12.518653116565886},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":13.33637666848148},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":13.355487382760797},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":13.373216387411043},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":13.48736849965678},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":13.478869650529552},{"$f":"VLOOKUP($A59,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":13.477687627353509}]
["Legal Fees",null,"$FY23",{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":0},{"$f":"VLOOKUP($A60,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":0}]
["Other",null,"$FY23",{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*D$63","v":163.18178987594226},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*E$63","v":165.35527072441485},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*F$63","v":176.15634477333182},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*G$63","v":176.40877267463787},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*H$63","v":176.64294997281195},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*I$63","v":178.15075222984385},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*J$63","v":178.03849338816232},{"$f":"VLOOKUP($A61,'Historic Data'!$B$32:$D$41,3,FALSE)*K$63","v":178.02288038567258}]
["Total misc  ($'000)",null,"$FY23",{"$f":"SUM(D56:D61)","v":1064.3945640740556},{"$f":"SUM(E56:E61)","v":1078.5716435263162},1149.0243852971273,1150.6709102321404,1152.198390984714,1162.0334131848228,1161.301176450896,1161.1993366868417]
["Total opex ($'000)",null,"$FY23",{"$f":"Calculation!D80","v":4545.1566729874339},{"$f":"Calculation!E80","v":4605.6953580303907},{"$f":"Calculation!F80","v":4906.5412663035413},{"$f":"Calculation!G80","v":4913.5722246043524},{"$f":"Calculation!H80","v":4920.0948427853837},{"$f":"Calculation!I80","v":4962.0921605945841},{"$f":"Calculation!J80","v":4958.9653777362846},{"$f":"Calculation!K80","v":4958.5305035845458}]
[]
[]
[]
["Forecast Opex"]
[]
[]
[{"$f":"Inputs!J25&\" (FY23 000)\"","v":"Insurance (FY23 000)"},"FY 24","FY 25","FY 26","FY 27","FY 28"]
["Base year (FY 2021)",{"$f":"Calculation!$D$67","v":502.84599928301884},{"$f":"Calculation!$D$67","v":502.84599928301884},{"$f":"Calculation!$D$67","v":502.84599928301884},{"$f":"Calculation!$D$67","v":502.84599928301884},{"$f":"Calculation!$D$67","v":502.84599928301884}]
["Forecast",{"$f":"Calculation!G67","v":743.71590097792614},{"$f":"Calculation!H67","v":786.06887820370139},{"$f":"Calculation!I67","v":829.15503941355757},{"$f":"Calculation!J67","v":833.7792740318697},{"$f":"Calculation!K67","v":833.34439988013094}]
["Incremental Costs",{"$f":"B72-B71","v":240.8699016949073},{"$f":"C72-C71","v":283.22287892068255},326.30904013053873,330.93327474885086,330.4984005971121]
[]
[{"$f":"Inputs!J26&\" (FY23 000)\"","v":" (FY23 000)"},{"$f":"B70","v":"FY 24"},{"$f":"C70","v":"FY 25"},"FY 26","FY 27","FY 28"]
[{"$f":"A71","v":"Base year (FY 2021)"},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"A72","v":"Forecast"},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}},{"$f":"Calculation!#REF!","v":{"$error":"#REF!"}}]
["Incremental Costs",{"$f":"B77-B76","v":{"$error":"#REF!"}},{"$f":"C77-C76","v":{"$error":"#REF!"}},{"$f":"D77-D76","v":{"$error":"#REF!"}},{"$f":"E77-E76","v":{"$error":"#REF!"}},{"$f":"F77-F76","v":{"$error":"#REF!"}}]
[]
[{"$f":"Calculation!B57&\" ($FY23 000)\"","v":"SOCI (Cyber) ($FY23 000)"},"2023-24","2024-25","2025-26","2026-27","2027-28"]
[{"$f":"A76","v":"Base year (FY 2021)"},0,0,0,0,0]
[{"$f":"A77","v":"Forecast"},{"$f":"Calculation!G57","v":127.54564992201104},{"$f":"Calculation!H57","v":91.715290877267122},{"$f":"Calculation!I57","v":90.626447476611901},{"$f":"Calculation!J57","v":82.875429999999994},{"$f":"Calculation!K57","v":82.875429999999994}]
["Incremental Costs",{"$f":"B82-B81","v":127.54564992201104},{"$f":"C82-C81","v":91.715290877267122},90.626447476611901,82.875429999999994,82.875429999999994]
[]
["Incremental Costs"]
[]
[]
["Incremental Opex","FY 24","FY 25","FY 26","FY 27","FY 28","Total"]
[{"$f":"Inputs!J24","v":"SOCI (Cyber)"},{"$f":"B83","v":127.54564992201104},{"$f":"C83","v":91.715290877267122},90.626447476611901,82.875429999999994,82.875429999999994,{"$f":"SUM(B89:F89)","v":475.63824827589008}]
[{"$f":"Inputs!J25","v":"Insurance"},{"$f":"B73","v":240.8699016949073},{"$f":"C73","v":283.22287892068255},326.30904013053873,330.93327474885086,330.4984005971121,{"$f":"SUM(B90:F90)","v":1511.8334960920915}]
["Total",{"$f":"SUM(B89:B90)","v":368.41555161691832},374.93816979794968,416.93548760715066,413.80870474885086,413.37383059711209,1987.4717443679815]

{"sheet":"Graphs","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Murraylink:  Access Arrangement"]
["Operating Expenditure Forecast"]