{"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":141,"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 | System Operability Opex Forecast Model"]
[null,null,null,null,null,null,null,null,"Author","Transgrid"]
[null,"Notes & Assumptions",null,"Calculations",null,"Outputs",null,null,"Revision","2025-12-15"]
[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:A55)=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:A92)=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":63,"n_cols":36,"rows_kept":63,"cut":false,"hidden":false,"merged":[[20,23,20,33],[20,5,20,7],[58,11,58,21],[20,11,20,21]]}
["Inputs"]
[]
[null,"Output Reporting Format and Year"]
[null,"Real",2023,"The Financial Year that results are reported in.",null,null,null,{"$f":" IF(Real_or_Nom=\"Real\", \"Real $\" & Report_Year, \"$ Nominal\")","v":"Real $2023"}]
[]
[null,"Indexation and escalation"]
[]
[null,"Forecasts",null,null,null,null,null,null,null,null,null,"Rates"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,2023,{"$f":"L9+1","v":2024},2025,2026,2027,2028,{"$f":"Q9+1","v":2029},{"$f":"R9+1","v":2030},{"$f":"S9+1","v":2031},{"$f":"T9+1","v":2032},2033]
[null,"Actual / Forecast Inflation ","ABS / RBA / PTRM","%",null,null,null,null,null,null,null,6.0269627279936566E-2,3.8145100972326373E-2,2.0893371757924939E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-2,2.9193048507912156E-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,3.9046564755527329E-3,1.3076482545953276E-2,1.1546438954636147E-2,4.3304575862308627E-3,3.00941333753012E-3,7.1734897799806269E-3,7.1734897799806269E-3,7.1734897799806269E-3,7.1734897799806269E-3,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,"Cumulative Factors"]
[null,"Item","Source","Units",null,null,null,null,null,null,null,{"$f":"L$9","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[null,"Nominal (mid year) to Real 2023 (end year)","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"(1+L10)^0.5","v":1.0296939483554988},{"$f":"L15/(1+L10)^0.5/(1+M10)^0.5","v":0.98145630781500182},0.95334863498959577,0.93006464345756967,0.90368337097296259,0.87805040296676229,0.85314451379139133,0.82894507986451171,0.80543206259145184,0.78258599177203836,0.76038794947809263,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 2023 (end year)","Calculated","Factor",null,null,null,null,null,null,null,1,{"$f":"L16/(1+M10)","v":0.96325648414985565},0.9435426958362737,0.91677911855719263,0.89077468982743979,0.86550787640749571,0.84095775584792232,0.81710399916430965,0.79392685400364704,0.77140712828818092,0.74952617432321356]
[null,"Labour escalation from 2027","Calculated","Factor",null,null,null,null,null,null,null,{"$f":"M17","v":1},{"$f":"N17","v":1},{"$f":"O17","v":1},{"$f":"P17","v":1},1,{"$f":"P17*(1+Q11)","v":1.00300941333753},1.0102044911133312,1.0174511827060233,1.0247498583667942,1.0321008910028251,1.0395046561963428]
[]
[null,"Operating costs"]
[]
[null,"Direct costs",null,null,null,"Conversion",null,null,"Non labour rate","Labour rate",null,"Headcount Forecast (FTEs)",null,null,null,null,null,null,null,null,null,null,null,"Material (Number)",null,null,null,null,null,null,null,null,null,null,null,"Hours per year"]
[null,"Item","Resource Description","Units",null,"Dollar Year","Escalation Year","Timing","$ per Unit","$ per hour per FTE",null,{"$f":"L$9","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,null,{"$f":"L22","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,null,"Hours"]
[null,"Network Operations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(7*5*48)","v":1680}]
[null,"System Operator ( Control Room Operator)","2 new control room staff to maintain new forecasting capabilities ","Various",null,2025,2026,"End",0,145.96937142857143,null,null,null,0,0,0,0,0,0,0.66666666666666663,2,2,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SCADA Maintenance Engineer","1 role to maintain the training simulator software and configurations ","Various",null,2025,2026,"End",0,122.86834285714285,null,null,null,0,0,0,0,0.25,1,1,1,1,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"SCADA Maintenance Engineer","5 new roles :  5.5x maintain SCADA/EMS evergreen less 2 existing SCADA engineers redeployed to evergreen = 3.5 , 1 x test automation developer, 0.5 x SCADA Engineer (alarm business rules mgt and integration)","Various",null,2025,2026,"End",0,122.86834285714285,null,null,null,0,0,0,0,1.25,5,4.9999996124384323,4.9999996124384323,4.9999996124384323,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"System Data Analyst ( Network Model Management)","1 network model management role ","Various",null,2025,2026,"End",0,145.96937142857143,null,null,null,0,0,0,0,0.25,1,1,1,1,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Enhanced SCADA/EMS","c-i-c","Various",null,2025,2026,"End",1019400,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0.25,1,1,1,1]
[null,"Training LMS","c-i-c","Various",null,2025,2026,"End",12000,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0.25,1,1,1,1]
[null,"Wide Area Monitoring ","c-i-c","Various",null,2025,2026,"End",577300,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0,0,0.33333333333333337,1,1]
[null,"Alarm Management Technologies","c-i-c","Various",null,2025,2026,"End",820000,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0.25,1,1,1,1]
[null,"Hardware maintenance uplift ","c-i-c","Various",null,2025,2026,"End",1028031,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0.25,1,1,1,1]
[null,"Training attendence during the project","provision of training during the OT uplift program which cannot be capitalised. Split across the two major release dates","Various",null,2025,2026,"End",396328,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,1.3261868957025493,0,0.9154639591449506,0,0]
[null,"Transgrid scope - Hardware maintenance and software licensing uplift ","c-i-c","Various",null,2025,2026,"End",0,367.1875,null,null,null,0,0,0,0.18237082066869301,0.32016210739614998,0.34042553191489361,0.34042553191489361,0.34042553191489361,0.34042553191489361,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Network Planning"]
[null,"Engineer ( Operational Planner)","Engineer ( Operational Planner)","Various",null,2025,2026,"End",0,145.96937142857143,null,null,null,0,0,0,1.6666666666666667,2.5,4,4.666666666666667,6,6,null,null,null,0,0,0,0,0,0,0,0,0]
[null,"Data modelling and network management","c-i-c","Various",null,2025,2026,"End",643500,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0,0.25,1,1,1,1]
[null,"Operational planning system","c-i-c","Various",null,2025,2026,"End",346295,0,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,0,0,0,0.75903252044258995,0.91083902453110788,0.91083902453110788,0.91083902453110788,0.91083902453110788,0.91083902453110788]
[null,"Asset Management"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,"Commercial"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,"Delivery"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,"Finance & Audit"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,"Regulatory submissions"]
[null,null,null,"Various",null,2025,2026,"End"]
[null,null,null,"Various",null,2025,2026,"End"]
[]
[null,"Labour costs",null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($J$23:$J$53,L$23:L$53)*$AJ$23","v":0},0,0,0,0,521214.24,1181506.72,2674655.6159999999,3001626.9279999998,3655569.7119999994,3655569.7119999994,null,{"$f":"SUMPRODUCT($I$23:$I$53,X$23:X$53)","v":0},0,0,0,0,262849.16666666669,1721756.75,3838350,4393607.333333333,4415650,4415650,null,"Note: this is the total cost excluding labour escalation and inflation"]
[]
[null,"Debt raising costs"]
[]
[null,{"$f":"B57","v":"Debt raising costs"},null,null,null,"Conversion",null,null,null,null,null,{"$f":"\"Cost (As Incurred) (Real $\"&F61&\", \"&G61&\" year)\"","v":"Cost (As Incurred) (Real $2023, End year)"}]
[null,"Item","Source","Units",null,"Dollar Year","Timing",null,null,null,null,{"$f":"L$14","v":2023},2024,2025,2026,2027,2028,2029,2030,2031,2032,2033]
[null,"Debt raising cost allowance","PTRM","$Dollars",null,2023,"End",null,null,null,null,null,0,2312.0939057149803,4178.7954404232114,4643.3114701321047,14265.43274782172]
[]
[null,"End"]

{"sheet":"Calculations","index":3,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Calculations"]
[]
[null,{"$f":"Inputs!$B$19","v":"Operating costs"},null,null,null,"2023-28 Regulatory Period",null,null,null,null,"2023-28 Regulatory Period",null,null,null,null,"Total"]
[null,"Component","Dollar basis","Unit",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033}]
[null,{"$f":"Inputs!B23","v":"Network Operations"}]
[null,"Labour",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!L$24:L$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!M$24:M$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!N$24:N$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!O$24:O$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!P$24:P$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!Q$24:Q$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":106148.55328158078},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!R$24:R$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":536343.03198306274},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!S$24:S$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":1598117.3643472122},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!T$24:T$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":1752373.0231983061},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!U$24:U$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":2060884.491867325},{"$f":"SUMPRODUCT(Inputs!$J$24:$J$34,Inputs!V$24:V$34)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":2060884.491867325},{"$f":"SUM(E6:O6)","v":8114750.9565448118}]
[null,"Labour escalation",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E6*(Inputs!L$17-1)","v":0},{"$f":"F6*(Inputs!M$17-1)","v":0},{"$f":"G6*(Inputs!N$17-1)","v":0},{"$f":"H6*(Inputs!O$17-1)","v":0},{"$f":"I6*(Inputs!P$17-1)","v":0},{"$f":"J6*(Inputs!Q$17-1)","v":319.4448720051052},{"$f":"K6*(Inputs!R$17-1)","v":5473.1077035682838},{"$f":"L6*(Inputs!S$17-1)","v":27889.038110891615},{"$f":"M6*(Inputs!T$17-1)","v":43370.98412994908},{"$f":"N6*(Inputs!U$17-1)","v":66156.228442845575},{"$f":"O6*(Inputs!V$17-1)","v":81414.533311593303},{"$f":"SUM(E7:O7)","v":224623.33657085296}]
[null,"Non labour",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!X$24:X$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!Y$24:Y$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!Z$24:Z$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AA$24:AA$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AB$24:AB$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AC$24:AC$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AD$24:AD$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":1175147.2806986589},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AE$24:AE$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":2716866.0882145376},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AF$24:AF$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":3240775.089390731},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AG$24:AG$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":3261573.2865208182},{"$f":"SUMPRODUCT(Inputs!$I$24:$I$34,Inputs!AH$24:AH$34)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":3261573.2865208182},{"$f":"SUM(E8:O8)","v":13655935.031345563}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E6:E8)","v":0},0,0,0,0,106467.99815358588,1716963.4203852899,4342872.4906726414,5036519.0967189856,5388614.0068309885,5403872.3116997369,21995309.324461229]
[null,{"$f":"Inputs!B35","v":"Network Planning"}]
[null,{"$f":"$B$6","v":"Labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!L$36:L$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!M$36:M$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!N$36:N$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!O$36:O$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!P$36:P$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!Q$36:Q$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":385639.33583627379},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!R$36:R$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":578459.00375441066},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!S$36:S$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":925534.40600705717},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!T$36:T$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":1079790.1403415666},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!U$36:U$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":1388301.6090105856},{"$f":"SUMPRODUCT(Inputs!$J$36:$J$38,Inputs!V$36:V$38)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":1388301.6090105856},{"$f":"SUM(E11:O11)","v":5746026.1039604796}]
[null,{"$f":"$B$7","v":"Labour escalation"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E11*(Inputs!L$17-1)","v":0},{"$f":"F11*(Inputs!M$17-1)","v":0},{"$f":"G11*(Inputs!N$17-1)","v":0},{"$f":"H11*(Inputs!O$17-1)","v":0},{"$f":"I11*(Inputs!P$17-1)","v":0},{"$f":"J11*(Inputs!Q$17-1)","v":1160.548160741901},{"$f":"K11*(Inputs!R$17-1)","v":5902.8797632383121},{"$f":"L11*(Inputs!S$17-1)","v":16151.670019939907},{"$f":"M11*(Inputs!T$17-1)","v":26724.653039314628},{"$f":"N11*(Inputs!U$17-1)","v":44565.718629895506},{"$f":"O11*(Inputs!V$17-1)","v":54844.377760792711},{"$f":"SUM(E12:O12)","v":149349.84737392297}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!X$36:X$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!Y$36:Y$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!Z$36:Z$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AA$36:AA$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AB$36:AB$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AC$36:AC$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":248009.4113149847},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AD$36:AD$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":449403.72477064212},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AE$36:AE$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":904781.01834862377},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AF$36:AF$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":904781.01834862377},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AG$36:AG$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":904781.01834862377},{"$f":"SUMPRODUCT(Inputs!$I$36:$I$38,Inputs!AH$36:AH$38)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":904781.01834862377},{"$f":"SUM(E13:O13)","v":4316537.2094801227}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E11:E13)","v":0},0,0,0,0,634809.29531200044,1033765.6082882911,1846467.0943756208,2011295.811729505,2337648.3459891048,2347927.0051200017,10211913.160814526]
[null,{"$f":"Inputs!B39","v":"Asset Management"}]
[null,{"$f":"$B$6","v":"Labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!L$40:L$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!M$40:M$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!N$40:N$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!O$40:O$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!P$40:P$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!Q$40:Q$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!R$40:R$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!S$40:S$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!T$40:T$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!U$40:U$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$40:$J$41,Inputs!V$40:V$41)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E16:O16)","v":0}]
[null,{"$f":"$B$7","v":"Labour escalation"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E16*(Inputs!L$17-1)","v":0},{"$f":"F16*(Inputs!M$17-1)","v":0},{"$f":"G16*(Inputs!N$17-1)","v":0},{"$f":"H16*(Inputs!O$17-1)","v":0},{"$f":"I16*(Inputs!P$17-1)","v":0},{"$f":"J16*(Inputs!Q$17-1)","v":0},{"$f":"K16*(Inputs!R$17-1)","v":0},{"$f":"L16*(Inputs!S$17-1)","v":0},{"$f":"M16*(Inputs!T$17-1)","v":0},{"$f":"N16*(Inputs!U$17-1)","v":0},{"$f":"O16*(Inputs!V$17-1)","v":0},{"$f":"SUM(E17:O17)","v":0}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!X$40:X$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!Y$40:Y$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!Z$40:Z$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AA$40:AA$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AB$40:AB$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AC$40:AC$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AD$40:AD$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AE$40:AE$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AF$40:AF$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AG$40:AG$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$40:$I$41,Inputs!AH$40:AH$41)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E18:O18)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E16:E18)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Inputs!B42","v":"Commercial"}]
[null,{"$f":"$B$6","v":"Labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!L$43:L$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!M$43:M$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!N$43:N$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!O$43:O$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!P$43:P$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!Q$43:Q$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!R$43:R$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!S$43:S$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!T$43:T$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!U$43:U$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$43:$J$44,Inputs!V$43:V$44)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E21:O21)","v":0}]
[null,{"$f":"$B$7","v":"Labour escalation"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E21*(Inputs!L$17-1)","v":0},{"$f":"F21*(Inputs!M$17-1)","v":0},{"$f":"G21*(Inputs!N$17-1)","v":0},{"$f":"H21*(Inputs!O$17-1)","v":0},{"$f":"I21*(Inputs!P$17-1)","v":0},{"$f":"J21*(Inputs!Q$17-1)","v":0},{"$f":"K21*(Inputs!R$17-1)","v":0},{"$f":"L21*(Inputs!S$17-1)","v":0},{"$f":"M21*(Inputs!T$17-1)","v":0},{"$f":"N21*(Inputs!U$17-1)","v":0},{"$f":"O21*(Inputs!V$17-1)","v":0},{"$f":"SUM(E22:O22)","v":0}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!X$43:X$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!Y$43:Y$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!Z$43:Z$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AA$43:AA$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AB$43:AB$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AC$43:AC$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AD$43:AD$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AE$43:AE$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AF$43:AF$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AG$43:AG$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$43:$I$44,Inputs!AH$43:AH$44)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E23:O23)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E21:E23)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Inputs!B45","v":"Delivery"}]
[null,{"$f":"$B$6","v":"Labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!L$46:L$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!M$46:M$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!N$46:N$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!O$46:O$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!P$46:P$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!Q$46:Q$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!R$46:R$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!S$46:S$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!T$46:T$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!U$46:U$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$46:$J$47,Inputs!V$46:V$47)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E26:O26)","v":0}]
[null,{"$f":"$B$7","v":"Labour escalation"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E26*(Inputs!L$17-1)","v":0},{"$f":"F26*(Inputs!M$17-1)","v":0},{"$f":"G26*(Inputs!N$17-1)","v":0},{"$f":"H26*(Inputs!O$17-1)","v":0},{"$f":"I26*(Inputs!P$17-1)","v":0},{"$f":"J26*(Inputs!Q$17-1)","v":0},{"$f":"K26*(Inputs!R$17-1)","v":0},{"$f":"L26*(Inputs!S$17-1)","v":0},{"$f":"M26*(Inputs!T$17-1)","v":0},{"$f":"N26*(Inputs!U$17-1)","v":0},{"$f":"O26*(Inputs!V$17-1)","v":0},{"$f":"SUM(E27:O27)","v":0}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!X$46:X$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!Y$46:Y$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!Z$46:Z$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AA$46:AA$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AB$46:AB$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AC$46:AC$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AD$46:AD$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AE$46:AE$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AF$46:AF$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AG$46:AG$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$46:$I$47,Inputs!AH$46:AH$47)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E28:O28)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E26:E28)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Inputs!B48","v":"Finance & Audit"}]
[null,"Labour",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!L$49:L$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!M$49:M$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!N$49:N$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!O$49:O$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!P$49:P$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!Q$49:Q$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!R$49:R$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!S$49:S$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!T$49:T$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!U$49:U$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$49:$J$50,Inputs!V$49:V$50)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E31:O31)","v":0}]
[null,"Labour escalation",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E31*(Inputs!L$17-1)","v":0},{"$f":"F31*(Inputs!M$17-1)","v":0},{"$f":"G31*(Inputs!N$17-1)","v":0},{"$f":"H31*(Inputs!O$17-1)","v":0},{"$f":"I31*(Inputs!P$17-1)","v":0},{"$f":"J31*(Inputs!Q$17-1)","v":0},{"$f":"K31*(Inputs!R$17-1)","v":0},{"$f":"L31*(Inputs!S$17-1)","v":0},{"$f":"M31*(Inputs!T$17-1)","v":0},{"$f":"N31*(Inputs!U$17-1)","v":0},{"$f":"O31*(Inputs!V$17-1)","v":0},{"$f":"SUM(E32:O32)","v":0}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!X$49:X$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!Y$49:Y$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!Z$49:Z$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AA$49:AA$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AB$49:AB$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AC$49:AC$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AD$49:AD$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AE$49:AE$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AF$49:AF$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AG$49:AG$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$49:$I$50,Inputs!AH$49:AH$50)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E33:O33)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E31:E33)","v":0},0,0,0,0,0,{"$f":"SUM(K31:K33)","v":0},{"$f":"SUM(L31:L33)","v":0},{"$f":"SUM(M31:M33)","v":0},{"$f":"SUM(N31:N33)","v":0},0,{"$f":"SUM(E34:O34)","v":0}]
[null,{"$f":"Inputs!B51","v":"Regulatory submissions"}]
[null,"Labour - Regulatory Submissions",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!L$52:L$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!M$52:M$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!N$52:N$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!O$52:O$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!P$52:P$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!Q$52:Q$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!R$52:R$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!S$52:S$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!T$52:T$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!U$52:U$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$J$52:$J$53,Inputs!V$52:V$53)*Inputs!$AJ$23*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E36:O36)","v":0}]
[null,"Labour escalation",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E36*(Inputs!L$17-1)","v":0},{"$f":"F36*(Inputs!M$17-1)","v":0},{"$f":"G36*(Inputs!N$17-1)","v":0},{"$f":"H36*(Inputs!O$17-1)","v":0},{"$f":"I36*(Inputs!P$17-1)","v":0},{"$f":"J36*(Inputs!Q$17-1)","v":0},{"$f":"K36*(Inputs!R$17-1)","v":0},{"$f":"L36*(Inputs!S$17-1)","v":0},{"$f":"M36*(Inputs!T$17-1)","v":0},{"$f":"N36*(Inputs!U$17-1)","v":0},{"$f":"O36*(Inputs!V$17-1)","v":0},{"$f":"SUM(E37:O37)","v":0}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!X$52:X$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!Y$52:Y$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!Z$52:Z$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AA$52:AA$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AB$52:AB$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AC$52:AC$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AD$52:AD$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AE$52:AE$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AF$52:AF$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AG$52:AG$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUMPRODUCT(Inputs!$I$52:$I$53,Inputs!AH$52:AH$53)*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E38:O38)","v":0}]
[null,"Sub-Total",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E36:E38)","v":0},0,0,0,0,0,{"$f":"SUM(K36:K38)","v":0},{"$f":"SUM(L36:L38)","v":0},{"$f":"SUM(M36:M38)","v":0},{"$f":"SUM(N36:N38)","v":0},0,{"$f":"SUM(E39:O39)","v":0}]
[null,"Total"]
[null,{"$f":"$B$6","v":"Labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E6+E11+E16+E21+E26+E31+E36","v":0},0,0,0,0,491787.88911785459,{"$f":"K6+K11+K16+K21+K26+K31+K36","v":1114802.0357374735},2523651.7703542695,2832163.1635398725,3449186.1008779109,3449186.1008779109,{"$f":"SUM(E41:O41)","v":13860777.060505291}]
[null,{"$f":"$B$7","v":"Labour escalation"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",0,0,0,0,0,1479.9930327470063,11375.987466806597,44040.708130831525,70095.637169263704,110721.94707274108,136258.91107238602,{"$f":"P7+P12+P17+P22+P27+P32+P37","v":373973.18394477596}]
[null,{"$f":"$B$8","v":"Non labour"},{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E8+E13+E18+E23+E28+E33+E38","v":0},{"$f":"F8+F13+F18+F23+F28+F33+F38","v":0},0,0,0,248009.4113149847,1624551.005469301,3621647.1065631611,4145556.1077393545,4166354.3048694422,4166354.3048694422,{"$f":"SUM(E43:O43)","v":17972472.240825687}]
[null,"Total costs (excluding debt raising costs)",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"SUM(E41:E43)","v":0},0,0,0,0,741277.29346558626,2750729.0286735808,6189339.585048262,7047814.9084484912,7726262.3528200947,7751799.3168197386,32207222.485275753]
[]
[null,"Debt raising costs",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"Inputs!L$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!M$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!N$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":2312.0939057149803},{"$f":"Inputs!O$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":4178.7954404232114},{"$f":"Inputs!P$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":4643.3114701321047},{"$f":"Inputs!Q$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":14265.43274782172},{"$f":"Inputs!R$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!S$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!T$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!U$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"Inputs!V$61*INDEX(IF(Inputs!$G$61=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH(Inputs!$F$61,Inputs!$L$14:$V$14,0))","v":0},{"$f":"SUM(E46:O46)","v":25399.633564092015}]
[]
[null,"Total costs (including debt raising costs)",{"$f":"Inputs!$H$4","v":"Real $2023"},"Dollars",{"$f":"E44+E46","v":0},0,2312.0939057149803,4178.7954404232114,4643.3114701321047,755542.72621340794,{"$f":"K44+K46","v":2750729.0286735808},{"$f":"L44+L46","v":6189339.585048262},{"$f":"M44+M46","v":7047814.9084484912},{"$f":"N44+N46","v":7726262.3528200947},7751799.3168197386,32232622.118839845]
[]
[{"$f":"IF(SUM(E50:O50)=0,0,1)","v":0},"Check - Operating Costs",null,null,{"$f":"IF(ROUND((Inputs!L55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!X55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(E41+E43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!M55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!Y55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(F41+F43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!N55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!Z55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(G41+G43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!O55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AA55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(H41+H43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!P55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AB55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(I41+I43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!Q55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AC55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(J41+J43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!R55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AD55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(K41+K43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!S55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AE55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(L41+L43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!T55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AF55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(M41+M43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!U55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AG55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(N41+N43),3)=0,0,1)","v":0},{"$f":"IF(ROUND((Inputs!V55*INDEX(IF($D$52=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$52,Inputs!$L$14:$V$14,0)))+(Inputs!AH55*INDEX(IF($D$53=\"Mid\",Inputs!$L$15:$V$15,Inputs!$L$16:$V$16),MATCH($C$53,Inputs!$L$14:$V$14,0)))-(O41+O43),3)=0,0,1)","v":0}]
[]
[null,"Input Dollar Basis - Labour",{"$f":"Inputs!$F$24","v":2025},{"$f":"Inputs!$H$24","v":"End"}]
[null,"Input Dollar Basis - Non Labour",{"$f":"Inputs!F28","v":2025},{"$f":"Inputs!H28","v":"End"}]
[]
[null,"End"]

{"sheet":"Outputs","index":4,"n_rows":95,"n_cols":18,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["Outputs"]
[]
[null,"PTRM and CPA"]
[]
[null,"Operating Costs - by driver",null,null,null,"2023-28 Regulatory Period",null,null,null,null,"2028-33 Regulatory Period",null,null,null,null,"Total","Total"]
[null,"Item","Dollar basis","Units",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033},"2023-28","All years"]
[]
[null,"Costs"]
[null,"Labour costs (excl labour escalation)",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E41/10^6","v":0},{"$f":"Calculations!F41/10^6","v":0},{"$f":"Calculations!G41/10^6","v":0},{"$f":"Calculations!H41/10^6","v":0},{"$f":"Calculations!I41/10^6","v":0},{"$f":"Calculations!J41/10^6","v":0.49178788911785459},{"$f":"Calculations!K41/10^6","v":1.1148020357374735},{"$f":"Calculations!L41/10^6","v":2.5236517703542694},{"$f":"Calculations!M41/10^6","v":2.8321631635398723},{"$f":"Calculations!N41/10^6","v":3.449186100877911},{"$f":"Calculations!O41/10^6","v":3.449186100877911},{"$f":"SUM(F9:J9)","v":0.49178788911785459},{"$f":"SUM(E9:O9)","v":13.860777060505292}]
[null,"Non labour costs",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E43/10^6","v":0},{"$f":"Calculations!F43/10^6","v":0},{"$f":"Calculations!G43/10^6","v":0},{"$f":"Calculations!H43/10^6","v":0},{"$f":"Calculations!I43/10^6","v":0},{"$f":"Calculations!J43/10^6","v":0.24800941131498469},{"$f":"Calculations!K43/10^6","v":1.6245510054693011},{"$f":"Calculations!L43/10^6","v":3.6216471065631612},{"$f":"Calculations!M43/10^6","v":4.1455561077393543},{"$f":"Calculations!N43/10^6","v":4.1663543048694418},{"$f":"Calculations!O43/10^6","v":4.1663543048694418},{"$f":"SUM(F10:J10)","v":0.24800941131498469},{"$f":"SUM(E10:O10)","v":17.972472240825685}]
[null,"Real input cost escalation",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E42/10^6","v":0},{"$f":"Calculations!F42/10^6","v":0},{"$f":"Calculations!G42/10^6","v":0},{"$f":"Calculations!H42/10^6","v":0},{"$f":"Calculations!I42/10^6","v":0},{"$f":"Calculations!J42/10^6","v":1.4799930327470063E-3},{"$f":"Calculations!K42/10^6","v":1.1375987466806597E-2},{"$f":"Calculations!L42/10^6","v":4.4040708130831524E-2},{"$f":"Calculations!M42/10^6","v":7.0095637169263703E-2},{"$f":"Calculations!N42/10^6","v":0.11072194707274108},{"$f":"Calculations!O42/10^6","v":0.13625891107238602},{"$f":"SUM(F11:J11)","v":1.4799930327470063E-3},{"$f":"SUM(E11:O11)","v":0.37397318394477597}]
[]
[null,"Total (excluding debt raising costs)",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"SUM(E9:E11)","v":0},0,0,0,0,0.74127729346558635,2.750729028673581,6.1893395850482618,7.0478149084484905,7.7262623528200942,7.7517993168197394,{"$f":"SUM(F13:J13)","v":0.74127729346558635},{"$f":"SUM(E13:O13)","v":32.207222485275757}]
[]
[null,"Debt Raising Costs",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E46/10^6","v":0},{"$f":"Calculations!F46/10^6","v":0},{"$f":"Calculations!G46/10^6","v":2.3120939057149803E-3},{"$f":"Calculations!H46/10^6","v":4.1787954404232117E-3},{"$f":"Calculations!I46/10^6","v":4.6433114701321049E-3},{"$f":"Calculations!J46/10^6","v":1.4265432747821721E-2},{"$f":"Calculations!K46/10^6","v":0},{"$f":"Calculations!L46/10^6","v":0},{"$f":"Calculations!M46/10^6","v":0},{"$f":"Calculations!N46/10^6","v":0},{"$f":"Calculations!O46/10^6","v":0},{"$f":"SUM(F15:J15)","v":2.5399633564092021E-2},{"$f":"SUM(E15:O15)","v":2.5399633564092021E-2}]
[]
[null,"Total (including debt raising costs)",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"E13+E15","v":0},0,2.3120939057149803E-3,4.1787954404232117E-3,4.6433114701321049E-3,0.75554272621340812,{"$f":"K13+K15","v":2.750729028673581},{"$f":"L13+L15","v":6.1893395850482618},{"$f":"M13+M15","v":7.0478149084484905},{"$f":"N13+N15","v":7.7262623528200942},{"$f":"O13+O15","v":7.7517993168197394},0.76667692702967838,32.232622118839849]
[]
[{"$f":"IF(SUM(E19:O19)=0,0,1)","v":0},"Check - Calculations",null,null,{"$f":"IF(ROUND(E13-Calculations!E44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F13-Calculations!F44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(G13-Calculations!G44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(H13-Calculations!H44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(I13-Calculations!I44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(J13-Calculations!J44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(K13-Calculations!K44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(L13-Calculations!L44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(M13-Calculations!M44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(N13-Calculations!N44/10^6,3)=0,0,1)","v":0},{"$f":"IF(ROUND(O13-Calculations!O44/10^6,3)=0,0,1)","v":0}]
[]
[null,"Operating Costs - by workstream",null,null,null,{"$f":"F$5","v":"2023-28 Regulatory Period"},null,null,null,null,{"$f":"K$5","v":"2028-33 Regulatory Period"},null,null,null,null,{"$f":"$P$5","v":"Total"},{"$f":"$Q$5","v":"Total"}]
[null,"Item","Dollar basis","Units",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033},{"$f":"$P$6","v":"2023-28"},{"$f":"$Q$6","v":"All years"}]
[]
[null,{"$f":"Calculations!$B$5","v":"Network Operations"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E9/10^6","v":0},{"$f":"Calculations!F9/10^6","v":0},{"$f":"Calculations!G9/10^6","v":0},{"$f":"Calculations!H9/10^6","v":0},{"$f":"Calculations!I9/10^6","v":0},{"$f":"Calculations!J9/10^6","v":0.10646799815358589},{"$f":"Calculations!K9/10^6","v":1.7169634203852899},{"$f":"Calculations!L9/10^6","v":4.342872490672641},{"$f":"Calculations!M9/10^6","v":5.0365190967189859},{"$f":"Calculations!N9/10^6","v":5.3886140068309887},{"$f":"Calculations!O9/10^6","v":5.4038723116997369},{"$f":"SUM(F24:J24)","v":0.10646799815358589},{"$f":"SUM(E24:O24)","v":21.995309324461228}]
[null,{"$f":"Calculations!$B$10","v":"Network Planning"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E14/10^6","v":0},{"$f":"Calculations!F14/10^6","v":0},{"$f":"Calculations!G14/10^6","v":0},{"$f":"Calculations!H14/10^6","v":0},{"$f":"Calculations!I14/10^6","v":0},{"$f":"Calculations!J14/10^6","v":0.63480929531200048},{"$f":"Calculations!K14/10^6","v":1.0337656082882911},{"$f":"Calculations!L14/10^6","v":1.8464670943756207},{"$f":"Calculations!M14/10^6","v":2.011295811729505},{"$f":"Calculations!N14/10^6","v":2.3376483459891046},{"$f":"Calculations!O14/10^6","v":2.3479270051200016},0.63480929531200048,10.211913160814523]
[null,{"$f":"Calculations!$B$15","v":"Asset Management"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E19/10^6","v":0},{"$f":"Calculations!F19/10^6","v":0},{"$f":"Calculations!G19/10^6","v":0},{"$f":"Calculations!H19/10^6","v":0},{"$f":"Calculations!I19/10^6","v":0},{"$f":"Calculations!J19/10^6","v":0},{"$f":"Calculations!K19/10^6","v":0},{"$f":"Calculations!L19/10^6","v":0},{"$f":"Calculations!M19/10^6","v":0},{"$f":"Calculations!N19/10^6","v":0},{"$f":"Calculations!O19/10^6","v":0},0,0]
[null,{"$f":"Calculations!$B$20","v":"Commercial"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E24/10^6","v":0},{"$f":"Calculations!F24/10^6","v":0},{"$f":"Calculations!G24/10^6","v":0},{"$f":"Calculations!H24/10^6","v":0},{"$f":"Calculations!I24/10^6","v":0},{"$f":"Calculations!J24/10^6","v":0},{"$f":"Calculations!K24/10^6","v":0},{"$f":"Calculations!L24/10^6","v":0},{"$f":"Calculations!M24/10^6","v":0},{"$f":"Calculations!N24/10^6","v":0},{"$f":"Calculations!O24/10^6","v":0},0,0]
[null,{"$f":"Calculations!$B$25","v":"Delivery"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E29/10^6","v":0},{"$f":"Calculations!F29/10^6","v":0},{"$f":"Calculations!G29/10^6","v":0},{"$f":"Calculations!H29/10^6","v":0},{"$f":"Calculations!I29/10^6","v":0},{"$f":"Calculations!J29/10^6","v":0},{"$f":"Calculations!K29/10^6","v":0},{"$f":"Calculations!L29/10^6","v":0},{"$f":"Calculations!M29/10^6","v":0},{"$f":"Calculations!N29/10^6","v":0},{"$f":"Calculations!O29/10^6","v":0},0,0]
[null,{"$f":"Calculations!$B$30","v":"Finance & Audit"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E34/10^6","v":0},{"$f":"Calculations!F34/10^6","v":0},{"$f":"Calculations!G34/10^6","v":0},{"$f":"Calculations!H34/10^6","v":0},{"$f":"Calculations!I34/10^6","v":0},{"$f":"Calculations!J34/10^6","v":0},{"$f":"Calculations!K34/10^6","v":0},{"$f":"Calculations!L34/10^6","v":0},{"$f":"Calculations!M34/10^6","v":0},{"$f":"Calculations!N34/10^6","v":0},{"$f":"Calculations!O34/10^6","v":0},0,0]
[null,{"$f":"Calculations!$B$35","v":"Regulatory submissions"},{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"Calculations!E35/10^6","v":0},{"$f":"Calculations!F35/10^6","v":0},{"$f":"Calculations!G35/10^6","v":0},{"$f":"Calculations!H35/10^6","v":0},{"$f":"Calculations!I35/10^6","v":0},{"$f":"Calculations!J35/10^6","v":0},{"$f":"Calculations!K35/10^6","v":0},{"$f":"Calculations!L35/10^6","v":0},{"$f":"Calculations!M35/10^6","v":0},{"$f":"Calculations!N35/10^6","v":0},{"$f":"Calculations!O35/10^6","v":0},0,0]
[]
[null,"Total (excluding debt raising costs)",{"$f":"Inputs!$H$4","v":"Real $2023"},"$Million",{"$f":"SUM(E24:E30)","v":0},0,0,0,0,0.74127729346558635,2.750729028673581,6.1893395850482618,7.0478149084484905,7.7262623528200933,7.7517993168197386,0.74127729346558635,32.20722248527575]
[]
[{"$f":"IF(SUM(E34:O34)=0,0,1)","v":0},"Check - Reconciliation",null,null,{"$f":"IF(ROUND(E32-E13,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F32-F13,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Operating Costs - by Workstream",null,null,null,{"$f":"F$5","v":"2023-28 Regulatory Period"},null,null,null,null,{"$f":"K$5","v":"2028-33 Regulatory Period"},null,null,null,null,{"$f":"$P$5","v":"Total"},{"$f":"$Q$5","v":"Total"}]
[null,null,"Dollar basis","Units",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033},{"$f":"$P$6","v":"2023-28"},{"$f":"$Q$6","v":"All years"}]
[]
[null,{"$f":"Calculations!$B$5","v":"Network Operations"},"Real $2025","$Million",{"$f":"E24*E$49","v":0},{"$f":"F24*F$49","v":0},0,0,0,0.11283855900047213,1.8196987035796233,4.6027302313262028,5.3378814959243108,5.7110441643077881,5.727215456752826,{"$f":"SUM(F39:J39)","v":0.11283855900047213},{"$f":"SUM(E39:O39)","v":23.311408610891224}]
[null,{"$f":"Calculations!$B$10","v":"Network Planning"},"Real $2025","$Million",{"$f":"E25*E$49","v":0},0,0,0,0,0.67279339675176131,1.0956214412449579,1.9569512885043043,2.1316426067469774,2.4775225925703528,2.4884162799214979,0.67279339675176131,10.822947605739852]
[null,{"$f":"Calculations!$B$15","v":"Asset Management"},"Real $2025","$Million",{"$f":"E26*E$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Calculations!$B$20","v":"Commercial"},"Real $2025","$Million",{"$f":"E27*E$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Calculations!$B$25","v":"Delivery"},"Real $2025","$Million",{"$f":"E28*E$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Calculations!$B$30","v":"Finance & Audit"},"Real $2025","$Million",{"$f":"E29*E$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"Calculations!$B$35","v":"Regulatory submissions"},"Real $2025","$Million",{"$f":"E30*E$49","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total (excluding debt raising costs)","Real $2025","$Million",{"$f":"SUM(E39:E45)","v":0},{"$f":"SUM(F39:F45)","v":0},{"$f":"SUM(G39:G45)","v":0},0,0,0.78563195575223344,2.9153201448245811,6.559681519830507,7.4695241026712882,8.1885667568781404,8.2156317366743234,0.78563195575223344,34.134356216631076]
[]
[null,"Real 2023 to Real 2025",null,null,{"$f":"Inputs!L16/Inputs!N16","v":1.0598354525056097},{"$f":"E49","v":1.0598354525056097},1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,1.0598354525056097,null,{"$f":"(Q13-Q11)*O49*10^6","v":33738006.178000003}]
[]
[null,"Operating Costs - by item",null,null,null,{"$f":"F$5","v":"2023-28 Regulatory Period"},null,null,null,null,{"$f":"K$5","v":"2028-33 Regulatory Period"},null,null,null,null,{"$f":"$P$5","v":"Total"},{"$f":"$Q$5","v":"Total"}]
[null,null,"Dollar basis","Units",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033},{"$f":"$P$6","v":"2023-28"},{"$f":"$Q$6","v":"All years"}]
[]
[null,"Enhanced SCADA/EMS","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.25485000000000002},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":1.0194000000000001},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":1.0194000000000001},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":1.0194000000000001},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B54)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":1.0194000000000001},{"$f":"SUM(F54:J54)","v":0},{"$f":"SUM(E54:O54)","v":4.3324500000000006},"SCADA/AEMS system"]
[null,"Training LMS","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":3.0000000000000001E-3},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":1.2E-2},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":1.2E-2},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":1.2E-2},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B55)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":1.2E-2},0,5.1000000000000004E-2,"Operational planning system and training LMS"]
[null,"Wide Area Monitoring ","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":0.19243333333333335},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":0.57730000000000004},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B56)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":0.57730000000000004},0,1.3470333333333335,"Wide area monitoring"]
[null,"Alarm Management Technologies","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.20499999999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":0.82},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":0.82},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":0.82},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B57)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":0.82},0,3.4849999999999994,"Alarm management technologies – software/licensing"]
[null,"Hardware maintenance uplift ","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.25700774999999998},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":1.0280309999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":1.0280309999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":1.0280309999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B58)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":1.0280309999999999},0,4.3691317499999993,"Hardware support"]
[null,"Training attendence during the project","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.52560499999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":0.36282399999999998},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B59)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":0},0,0.88842899999999991,"Operational planning system and training LMS"]
[null,"Data modelling and network management","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.16087499999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":0.64349999999999996},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":0.64349999999999996},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":0.64349999999999996},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B60)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":0.64349999999999996},{"$f":"SUM(F60:J60)","v":0},{"$f":"SUM(E60:O60)","v":2.7348749999999997},"Data modelling and network management"]
[null,"Operational planning system","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!X$24:X$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!Y$24:Y$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!Z$24:Z$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AA$24:AA$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AB$24:AB$53))/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AC$24:AC$53))/10^6","v":0.26284916666666669},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AD$24:AD$53))/10^6","v":0.315419},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AE$24:AE$53))/10^6","v":0.315419},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AF$24:AF$53))/10^6","v":0.315419},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AG$24:AG$53))/10^6","v":0.315419},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B61)*(Inputs!$I$24:$I$53)*(Inputs!AH$24:AH$53))/10^6","v":0.315419},{"$f":"SUM(F61:J61)","v":0.26284916666666669},{"$f":"SUM(E61:O61)","v":1.8399441666666667},"Operational planning system and training LMS"]
[null,"System Operator ( Control Room Operator)","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!R$24:R$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!S$24:S$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!T$24:T$53))*Inputs!$AJ$23/10^6","v":0.16348569599999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!U$24:U$53))*Inputs!$AJ$23/10^6","v":0.49045708800000004},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B62)*(Inputs!$J$24:$J$53)*(Inputs!V$24:V$53))*Inputs!$AJ$23/10^6","v":0.49045708800000004},{"$f":"SUM(F62:J62)","v":0},{"$f":"SUM(E62:O62)","v":1.1443998720000002},"Internal staffing – control room/forecasting"]
[null,"Training Simulator Engineer","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B63)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"Inputs!R25*Inputs!$J25*Inputs!$AJ$23/10^6","v":5.1604704000000001E-2},{"$f":"Inputs!S25*Inputs!$J25*Inputs!$AJ$23/10^6","v":0.206418816},{"$f":"Inputs!T25*Inputs!$J25*Inputs!$AJ$23/10^6","v":0.206418816},{"$f":"Inputs!U25*Inputs!$J25*Inputs!$AJ$23/10^6","v":0.206418816},{"$f":"Inputs!V25*Inputs!$J25*Inputs!$AJ$23/10^6","v":0.206418816},{"$f":"SUM(F63:J63)","v":0},{"$f":"SUM(E63:O63)","v":0.87727996800000008},"Internal staffing – training simulator maintenance"]
[null,"SCADA Maintenance Engineer","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!R$24:R$53))*Inputs!$AJ$23/10^6-K63","v":0.25802352000000001},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!S$24:S$53))*Inputs!$AJ$23/10^6-L63","v":1.03209408},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!T$24:T$53))*Inputs!$AJ$23/10^6-M63","v":1.0320939999999998},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!U$24:U$53))*Inputs!$AJ$23/10^6-N63","v":1.0320939999999998},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B64)*(Inputs!$J$24:$J$53)*(Inputs!V$24:V$53))*Inputs!$AJ$23/10^6-O63","v":1.0320939999999998},0,4.3863995999999998,"Internal staffing – SCADA/AEMS system"]
[null,"System Data Analyst ( Network Model Management)","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!R$24:R$53))*Inputs!$AJ$23/10^6","v":6.1307136000000005E-2},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!S$24:S$53))*Inputs!$AJ$23/10^6","v":0.24522854400000002},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!T$24:T$53))*Inputs!$AJ$23/10^6","v":0.24522854400000002},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!U$24:U$53))*Inputs!$AJ$23/10^6","v":0.24522854400000002},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B65)*(Inputs!$J$24:$J$53)*(Inputs!V$24:V$53))*Inputs!$AJ$23/10^6","v":0.24522854400000002},0,1.0422213120000001,"Internal staffing – network model management"]
[null,"Transgrid scope - Hardware maintenance and software licensing uplift ","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0.11249999999999999},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!R$24:R$53))*Inputs!$AJ$23/10^6","v":0.19750000000000004},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!S$24:S$53))*Inputs!$AJ$23/10^6","v":0.21},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!T$24:T$53))*Inputs!$AJ$23/10^6","v":0.21},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!U$24:U$53))*Inputs!$AJ$23/10^6","v":0.21},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B66)*(Inputs!$J$24:$J$53)*(Inputs!V$24:V$53))*Inputs!$AJ$23/10^6","v":0.21},0.11249999999999999,1.1499999999999999,"Hardware support"]
[null,"Engineer ( Operational Planner)","Real $2025","$Million",{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!L$24:L$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!M$24:M$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!N$24:N$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!O$24:O$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!P$24:P$53))*Inputs!$AJ$23/10^6","v":0},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!Q$24:Q$53))*Inputs!$AJ$23/10^6","v":0.40871424000000006},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!R$24:R$53))*Inputs!$AJ$23/10^6","v":0.61307135999999995},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!S$24:S$53))*Inputs!$AJ$23/10^6","v":0.98091417600000008},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!T$24:T$53))*Inputs!$AJ$23/10^6","v":1.1443998720000002},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!U$24:U$53))*Inputs!$AJ$23/10^6","v":1.4713712640000001},{"$f":"SUMPRODUCT((Inputs!$B$24:$B$53=$B67)*(Inputs!$J$24:$J$53)*(Inputs!V$24:V$53))*Inputs!$AJ$23/10^6","v":1.4713712640000001},0.40871424000000006,6.0898421760000003,"Internal staffing – planning operations"]
[null,"Total (excluding labour escalation and debt raising costs)",null,null,{"$f":"SUM(E54:E67)","v":0},{"$f":"SUM(F54:F67)","v":0},0,0,0,0.78406340666666674,2.9032634699999997,6.5130056159999992,7.3952342613333339,8.0712197120000013,8.0712197120000013,0.78406340666666674,33.738006178000006]
[null,"Real input cost escalation","Real $2025","$Million",{"$f":"E11*E$49","v":0},{"$f":"F11*F$49","v":0},0,0,0,1.568549085566573E-3,1.2056674824581115E-2,4.6675903830507313E-2,7.4289841337955631E-2,0.11734704487814071,0.14441202467432387,1.568549085566573E-3,0.39635003863107521]
[null,"Debt raising costs","Real $2025","$Million",{"$f":"E15*E$49","v":0},{"$f":"F15*F$49","v":0},2.4504390907988988E-3,4.428835556529313E-3,4.9211461130719471E-3,1.5119011371475977E-2,0,0,0,0,0,2.6919432131876135E-2,2.6919432131876135E-2]
[null,"Total Operating Expenditure","Real $2025","$Million",{"$f":"SUM(E68:E70)","v":0},{"$f":"SUM(F68:F70)","v":0},2.4504390907988988E-3,4.428835556529313E-3,4.9211461130719471E-3,0.8007509671237093,2.9153201448245807,6.5596815198305061,7.46952410267129,8.1885667568781422,8.2156317366743252,0.81255138788410941,34.161275648762953]
[]
[{"$f":"IF(SUM(E73:O73)=0,0,1)","v":0},"Check - Reconciliation",null,null,{"$f":"IF(ROUND(E71-E70-E47,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F71-F70-F47,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Operating Costs - by item",null,null,null,{"$f":"F$5","v":"2023-28 Regulatory Period"},null,null,null,null,{"$f":"K$5","v":"2028-33 Regulatory Period"},null,null,null,null,{"$f":"$P$5","v":"Total"},{"$f":"$Q$5","v":"Total"}]
[null,null,"Dollar basis","Units",{"$f":"Inputs!L$14","v":2023},{"$f":"Inputs!M$14","v":2024},{"$f":"Inputs!N$14","v":2025},{"$f":"Inputs!O$14","v":2026},{"$f":"Inputs!P$14","v":2027},{"$f":"Inputs!Q$14","v":2028},{"$f":"Inputs!R$14","v":2029},{"$f":"Inputs!S$14","v":2030},{"$f":"Inputs!T$14","v":2031},{"$f":"Inputs!U$14","v":2032},{"$f":"Inputs!V$14","v":2033},{"$f":"$P$6","v":"2023-28"},{"$f":"$Q$6","v":"All years"}]
[]
[null,"SCADA/AEMS system","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B78,E$54:E$67)","v":0},{"$f":"SUMIF($R$54:$R$67,$B78,F$54:F$67)","v":0},0,0,0,0,0.25485000000000002,1.0194000000000001,1.0194000000000001,1.0194000000000001,1.0194000000000001,{"$f":"SUM(F78:J78)","v":0},{"$f":"SUM(E78:O78)","v":4.3324500000000006}]
[null,"Data modelling and network management","Real $2025","$Million",0,0,0,0,0,0,0.16087499999999999,0.64349999999999996,0.64349999999999996,0.64349999999999996,0.64349999999999996,{"$f":"SUM(F79:J79)","v":0},{"$f":"SUM(E79:O79)","v":2.7348749999999997}]
[null,"Operational planning system and training LMS","Real $2025","$Million",0,0,0,0,0,0.26284916666666669,0.844024,0.32741900000000002,0.69024299999999994,0.32741900000000002,0.32741900000000002,{"$f":"SUM(F80:J80)","v":0.26284916666666669},{"$f":"SUM(E80:O80)","v":2.7793731666666668}]
[null,"Hardware support","Real $2025","$Million",0,0,0,0,0,0.11249999999999999,0.45450774999999999,1.2380309999999999,1.2380309999999999,1.2380309999999999,1.2380309999999999,{"$f":"SUM(F81:J81)","v":0.11249999999999999},{"$f":"SUM(E81:O81)","v":5.5191317499999997}]
[null,"Wide area monitoring","Real $2025","$Million",0,0,0,0,0,0,0,0,0.19243333333333335,0.57730000000000004,0.57730000000000004,0,1.3470333333333335]
[null,"Alarm management technologies – software/licensing","Real $2025","$Million",0,0,0,0,0,0,0.20499999999999999,0.82,0.82,0.82,0.82,0,3.4849999999999994]
[null,"Internal staffing – SCADA/AEMS system","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B84,E$54:E$67)*Inputs!L$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,F$54:F$67)*Inputs!M$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,G$54:G$67)*Inputs!N$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,H$54:H$67)*Inputs!O$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,I$54:I$67)*Inputs!P$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,J$54:J$67)*Inputs!Q$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B84,K$54:K$67)*Inputs!R$17","v":0.26065651871687046},{"$f":"SUMIF($R$54:$R$67,$B84,L$54:L$67)*Inputs!S$17","v":1.050105342359885},{"$f":"SUMIF($R$54:$R$67,$B84,M$54:M$67)*Inputs!T$17","v":1.057638180321218},{"$f":"SUMIF($R$54:$R$67,$B84,N$54:N$67)*Inputs!U$17","v":1.0652251369986696},{"$f":"SUMIF($R$54:$R$67,$B84,O$54:O$67)*Inputs!V$17","v":1.0728665186323081},0,4.5064916970289506]
[null,"Internal staffing – training simulator maintenance","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B85,E$54:E$67)*Inputs!L$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,F$54:F$67)*Inputs!M$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,G$54:G$67)*Inputs!N$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,H$54:H$67)*Inputs!O$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,I$54:I$67)*Inputs!P$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,J$54:J$67)*Inputs!Q$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B85,K$54:K$67)*Inputs!R$17","v":5.2131303743374088E-2},{"$f":"SUMIF($R$54:$R$67,$B85,L$54:L$67)*Inputs!S$17","v":0.21002106847197702},{"$f":"SUMIF($R$54:$R$67,$B85,M$54:M$67)*Inputs!T$17","v":0.21152765246024136},{"$f":"SUMIF($R$54:$R$67,$B85,N$54:N$67)*Inputs!U$17","v":0.21304504391334822},{"$f":"SUMIF($R$54:$R$67,$B85,O$54:O$67)*Inputs!V$17","v":0.21457332035853616},0,0.90129838894747683]
[null,"Internal staffing – network model management","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B86,E$54:E$67)*Inputs!L$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,F$54:F$67)*Inputs!M$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,G$54:G$67)*Inputs!N$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,H$54:H$67)*Inputs!O$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,I$54:I$67)*Inputs!P$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,J$54:J$67)*Inputs!Q$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B86,K$54:K$67)*Inputs!R$17","v":6.1932744124495794E-2},{"$f":"SUMIF($R$54:$R$67,$B86,L$54:L$67)*Inputs!S$17","v":0.24950807212607609},{"$f":"SUMIF($R$54:$R$67,$B86,M$54:M$67)*Inputs!T$17","v":0.25129791573149518},{"$f":"SUMIF($R$54:$R$67,$B86,N$54:N$67)*Inputs!U$17","v":0.25310059876172553},{"$f":"SUMIF($R$54:$R$67,$B86,O$54:O$67)*Inputs!V$17","v":0.25491621332024972},0,1.0707555440640424]
[null,"Internal staffing – planning operations","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B87,E$54:E$67)*Inputs!L$17+(E66*Inputs!L$17-E66)","v":0},{"$f":"SUMIF($R$54:$R$67,$B87,F$54:F$67)*Inputs!M$17+(F66*Inputs!M$17-F66)","v":0},{"$f":"SUMIF($R$54:$R$67,$B87,G$54:G$67)*Inputs!N$17+(G66*Inputs!N$17-G66)","v":0},{"$f":"SUMIF($R$54:$R$67,$B87,H$54:H$67)*Inputs!O$17+(H66*Inputs!O$17-H66)","v":0},{"$f":"SUMIF($R$54:$R$67,$B87,I$54:I$67)*Inputs!P$17+(I66*Inputs!P$17-I66)","v":0},{"$f":"SUMIF($R$54:$R$67,$B87,J$54:J$67)*Inputs!Q$17+(J66*Inputs!Q$17-J66)","v":0.41028278908556665},{"$f":"SUMIF($R$54:$R$67,$B87,K$54:K$67)*Inputs!R$17+(K66*Inputs!R$17-K66)","v":0.62134282823984077},{"$f":"SUMIF($R$54:$R$67,$B87,L$54:L$67)*Inputs!S$17+(L66*Inputs!S$17-L66)","v":1.0016970368725693},{"$f":"SUMIF($R$54:$R$67,$B87,M$54:M$67)*Inputs!T$17+(M66*Inputs!T$17-M66)","v":1.1779210770040043},{"$f":"SUMIF($R$54:$R$67,$B87,N$54:N$67)*Inputs!U$17+(N66*Inputs!U$17-N66)","v":1.5253447796809465},{"$f":"SUMIF($R$54:$R$67,$B87,O$54:O$67)*Inputs!V$17+(O66*Inputs!V$17-O66)","v":1.5377932577227302},0.41028278908556665,6.2743817686056582]
[null,"Internal staffing – control room/forecasting","Real $2025","$Million",{"$f":"SUMIF($R$54:$R$67,$B88,E$54:E$67)*Inputs!L$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,F$54:F$67)*Inputs!M$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,G$54:G$67)*Inputs!N$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,H$54:H$67)*Inputs!O$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,I$54:I$67)*Inputs!P$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,J$54:J$67)*Inputs!Q$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,K$54:K$67)*Inputs!R$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,L$54:L$67)*Inputs!S$17","v":0},{"$f":"SUMIF($R$54:$R$67,$B88,M$54:M$67)*Inputs!T$17","v":0.16753194382099676},{"$f":"SUMIF($R$54:$R$67,$B88,N$54:N$67)*Inputs!U$17","v":0.50620119752345105},{"$f":"SUMIF($R$54:$R$67,$B88,O$54:O$67)*Inputs!V$17","v":0.50983242664049944},0,1.1835655679849473]
[null,"Total (excluding labour escalation and debt raising costs)",null,null,{"$f":"SUM(E78:E88)","v":0},{"$f":"SUM(F78:F88)","v":0},0,0,0,0.78563195575223332,2.9153201448245811,6.559681519830507,7.46952410267129,8.1885667568781422,8.2156317366743234,0.78563195575223332,34.134356216631076]
[null,"Debt raising costs","Real $2025","$Million",{"$f":"E70","v":0},{"$f":"F70","v":0},2.4504390907988988E-3,4.428835556529313E-3,4.9211461130719471E-3,1.5119011371475977E-2,0,0,0,0,0,2.6919432131876135E-2,2.6919432131876135E-2]
[null,"Total Operating Expenditure","Real $2025","$Million",{"$f":"SUM(E89:E90)","v":0},{"$f":"SUM(F89:F90)","v":0},2.4504390907988988E-3,4.428835556529313E-3,4.9211461130719471E-3,0.8007509671237093,2.9153201448245811,6.559681519830507,7.46952410267129,8.1885667568781422,8.2156317366743234,0.81255138788410941,34.161275648762953]
[]
[{"$f":"IF(SUM(E93:O93)=0,0,1)","v":0},"Check - Reconciliation",null,null,{"$f":"IF(ROUND(E91-E71,3)=0,0,1)","v":0},{"$f":"IF(ROUND(F91-F71,3)=0,0,1)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"End"]