{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Draft decision"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Draft decision","index":0,"n_rows":66,"n_cols":23,"rows_kept":66,"cut":false,"hidden":false,"merged":[[61,10,61,11],[62,10,62,11],[45,18,49,19],[55,12,55,16],[55,17,55,21],[58,10,58,11],[59,10,59,11],[60,10,60,11],[38,2,38,8],[38,10,38,16],[39,2,39,3],[39,4,39,8],[39,10,39,11],[39,12,39,16],[26,2,26,3],[26,4,26,8],[26,10,26,11],[26,12,26,16],[12,2,12,11],[12,12,12,13],[25,2,25,3],[25,4,25,8],[25,10,25,16]]}
[]
[]
[]
[null,null,null,"Transgrid revised proposal amendments to AER's draft decision"]
[]
[]
[]
[]
[]
[]
[]
[null,"Actual and estimated inflation"]
[null,null,"Actual",null,null,null,null,null,null,null,null,null,"Estimated"]
[null,null,"2011-12","2012-13","2013-14","2014-15","2015-16","2016-17","2017-18","2018-19","2019-20","2020-21","2021-22","2022-23"]
[null,"ABS CPI index - June",null,102.8,105.9,107.5,108.6,110.7,113,114.8,114.4,118.8,126.1,133.91820000000001]
[null,"Inflation rate (per cent) ",null,null,{"$f":"+E15/D15-1","v":3.0155642023346418E-2},{"$f":"+F15/E15-1","v":1.5108593012275628E-2},1.0232558139534831E-2,1.9337016574585641E-2,2.0776874435411097E-2,1.5929203539823078E-2,-3.4843205574912606E-3,{"$f":"+L15/K15-1","v":3.8461538461538325E-2},{"$f":"+M15/L15-1","v":6.1447811447811418E-2},{"$f":"+N15/M15-1","v":6.2000000000000055E-2}]
[null,"Reconstructed cumulative index (2022-23=1)",null,{"$f":"E17/(1+E16)","v":0.76763277881572456},{"$f":"F17/(1+F16)","v":0.79078123809907819},{"$f":"G17/(1+G16)","v":0.80272882998726058},0.81094279941038605,0.8266240137636256,0.84379867710288803,0.85723971797709342,0.85425282000504787,0.88710869769754963,0.94161958568738224,1]
[]
[]
[]
[null,"7.5.1 -  The carryover amounts that arise from applying the EBSS during the current regulatory control period"]
[]
[null,"Base year used to forecast opex for the current period (drop down menu)","2016-17"]
[null,"Non-recurrent efficiency adjustment made to 2016-17 opex, $m, real June 2018",2.1716401484221137]
[null,"7.5.1.1 - Opex allowance applicable to EBSS (EBSS target)"]
[null,null,"$m, real June 2014",null,"$m, real June 2018",null,null,null,null,null,"$m, real June 2023"]
[null,null,"Previous period",null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,null,{"$f":"$C$23","v":"2016-17"},{"$f":"I$14","v":"2017-18"},{"$f":"J$14","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23",null,{"$f":"$C$23","v":"2016-17"},{"$f":"I$14","v":"2017-18"},{"$f":"J$14","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23"]
[null,"Total opex allowance",173.49666812432898,166.98038427472488,175.5591915899046,178.72754515938772,183.03848501711565,191.73639071190954,184.57004469139272,null,{"$f":"+C29/$E$17","v":219.39906988864513},{"$f":"+D29/$E$17","v":211.15875823776645},{"$f":"+E29/$I$17","v":208.05814983340855},{"$f":"+F29/$I$17","v":211.8130189218046},{"$f":"+G29/$I$17","v":216.92198623202745},{"$f":"+H29/$I$17","v":227.23002051889955},{"$f":"+I29/$I$17","v":218.73706335390153}]
[null,"Approved excludable costs - allowance "]
[null,"Debt raising costs",-3.1757386188468977,-3.1627000924630839,-3.242894415523931,-3.2729407475171768,-3.3576990106466953,-3.560643448239579,-4.0861461554813996,null,{"$f":"+C31/$E$17","v":-4.0159508924123015},{"$f":"+D31/$E$17","v":-3.999462733923417},{"$f":"E31/$I$17","v":-3.843208698380681},{"$f":"F31/$I$17","v":-3.8788171116296892},{"$f":"G31/$I$17","v":-3.979265554403419},{"$f":"H31/$I$17","v":-4.2197784197348467},-4.8425605139733561]
[null,"Network support costs",null,null,-0.70193377945441993,-2.5523419739295581,-5.8342712906560781,-10.039451486705802,0,null,{"$f":"+C32/$E$17","v":0},0,-0.83187352445781337,-3.024823388788437,-6.9142930049233531,-11.89792276183155,0]
[null,"Contingent project VNI, QNI & PEC",null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Bushfire cost pass through",null,null,0,6.4044078787767091,8.0058389916448434,24.951519086284069,0,null,0,0,0,7.5899714618725245,9.4878544004503773,29.570464807971749,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0]
[null,"Forecast opex for EBSS purposes",{"$f":"SUM(C29:C35)","v":170.32092950548207},163.81768418226179,{"$f":"SUM(E29:E35)","v":171.61436339492627},{"$f":"SUM(F29:F35)","v":179.30667031671769},181.85235370745772,203.08781486324821,180.48389853591132,null,{"$f":"+SUM(K29:K35)","v":215.38311899623284},207.15929550384303,203.38306761057004,212.49934988325899,215.51628207315105,240.68278414530491,213.89450283992818]
[]
[null,"7.5.1.2 - Actual and estimated opex applicable to EBSS"]
[null,null,"$m, Actual ",null,null,null,null,null,null,null,"$m, real June 2023"]
[null,null,"Previous period",null,"Current regulatory control period",null,null,null,null,null,"Previous period",null,"Current regulatory control period"]
[null,null,{"$f":"$C$23","v":"2016-17"},{"$f":"I$14","v":"2017-18"},{"$f":"J$14","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23",null,{"$f":"$C$23","v":"2016-17"},{"$f":"I$14","v":"2017-18"},{"$f":"J$14","v":"2018-19"},"2019-20","2020-21","2021-22","2022-23"]
[null,"Total opex ",170.36670697000076,153.55669399000016,154.4478451599995,161.45185900000001,168.541965,186.58995322222222,null,null,{"$f":"+C42/LOOKUP($C$23,$D$14:$N$14,$D$17:$N$17)*(1+LOOKUP($C$23,$D$14:$N$14,$D$16:$N$16))^0.5","v":208.08252500729563},{"$f":"+D42/I$17*(1+I$16)^0.5","v":183.8634159543991},{"$f":"+E42/J$17*(1+J$16)^0.5","v":181.59809609600521},{"$f":"+F42/K$17*(1+K$16)^0.5","v":188.66819607631433},{"$f":"+G42/L$17*(1+L$16)^0.5","v":193.60939316564929},{"$f":"+H42/M$17*(1+M$16)^0.5","v":204.15597531015752}]
[null,"Approved excludable costs"]
[null,{"$f":"B31","v":"Debt raising costs"},null,null,0,0,0,0,null,null,{"$f":"+C44/LOOKUP($C$23,$D$14:$N$14,$D$17:$N$17)*(1+LOOKUP($C$23,$D$14:$N$14,$D$16:$N$16))^0.5","v":0},{"$f":"D44/I$17*(1+I$16)^0.5","v":0},{"$f":"E44/J$17*(1+J$16)^0.5","v":0},{"$f":"F44/K$17*(1+K$16)^0.5","v":0},0,0]
[null,{"$f":"B32","v":"Network support costs"},null,null,-1.0320737899999999,-1.233986,-1.1897211000000001,-1.1798749099999999,null,null,0,0,{"$f":"E45/J$17*(1+J$16)^0.5","v":-1.2135011343177284},-1.4420020558786306,{"$f":"G45/L$17*(1+L$16)^0.5","v":-1.3666696018844255},{"$f":"H45/M$17*(1+M$16)^0.5","v":-1.2909511409124814}]
[null,"Network capability projects",null,null,0,0,0,0,null,null,0,0,0,{"$f":"F46/K$17*(1+K$16)^0.5","v":0},0,{"$f":"H46/M$17*(1+M$16)^0.5","v":0},null,null,"Transgrid to nominate base year used to forecast opex \n(drop down menu)"]
[null,"Capitalised opex that has been excluded from the regulatory asset base",null,null,null,null,null,null,null,null,0,0,0,{"$f":"F47/K$17*(1+K$16)^0.5","v":0},0,0]
[null,"Movements in provisions related to opex",-2.9252144742630466,5.0625515359510107,-0.76777747798796137,-7.1622729999999999,-8.0988969999999991,0.76094150000000182,null,null,-3.5727990803961762,6.0617221865023936,-0.90274440594213334,-8.3696349802704457,-9.3034546825243041,0.83257834306575551]
[null,"Other adjustments or exclusions required by the EBSS ",null,null,0,0,0,0,null,null,0,0,0,0,0,0]
[null,"Actual opex for EBSS purposes",{"$f":"SUM(C42:C49)","v":167.44149249573772},158.61924552595116,152.64799389201156,153.05560000000003,159.2533469,186.17101981222223,null,null,{"$f":"K42+SUM(K44:K49)","v":204.50972592689945},189.92513814090148,179.48185055574535,178.85655904016525,182.93926888124057,203.69760251231079,{"$f":"Q36-(LOOKUP($R$50,M28:P28,M36:P36)-LOOKUP($R$50,M41:P41,M50:P50))+R51","v":191.46880687260253},"2021-22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.559485665668452,"Base year non-recurrent efficiency gain $m, real June 2023"]
[null,null,null,null,null,null,null,null,null,null,"Incremental gain $m, real June 2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(M36-M50)-((L36-L50)-(K36-K50))-C24/I17","v":14.966805507018101},{"$f":"(N36-N50)-(M36-M50)","v":9.7415737882690507},{"$f":"(O36-O50)-(N36-N50)","v":-1.0657776511832537},{"$f":"(P36-P50)-(O36-O50)","v":4.4081684410836317},{"$f":"(Q36-Q50)-(P36-P50)","v":-14.559485665668461}]
[]
[null,null,null,null,null,null,null,null,null,null,"Carryover"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Current regulatory control period",null,null,null,null,"Forthcoming regulatory control period"]
[null,null,null,null,null,null,null,null,null,null,null,null,"$m, real June 2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E41","v":"2018-19"},{"$f":"F41","v":"2019-20"},"2020-21","2021-22","2022-23",{"$f":"LEFT(Q58,4)+1&\"-\"&RIGHT(Q58,2)+1","v":"2023-24"},{"$f":"LEFT(R58,4)+1&\"-\"&RIGHT(R58,2)+1","v":"2024-25"},"2025-26","2026-27","2027-28","Total"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"M58","v":"2018-19"},null,null,{"$f":"$M$53","v":14.966805507018101},{"$f":"$M$53","v":14.966805507018101},{"$f":"$M$53","v":14.966805507018101},{"$f":"$M$53","v":14.966805507018101},{"$f":"$M$53","v":14.966805507018101}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"N58","v":"2019-20"},null,null,null,{"$f":"$N$53","v":9.7415737882690507},{"$f":"$N$53","v":9.7415737882690507},{"$f":"$N$53","v":9.7415737882690507},{"$f":"$N$53","v":9.7415737882690507},{"$f":"$N$53","v":9.7415737882690507}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"O58","v":"2020-21"},null,null,null,null,{"$f":"$O$53","v":-1.0657776511832537},{"$f":"$O$53","v":-1.0657776511832537},{"$f":"$O$53","v":-1.0657776511832537},{"$f":"$O$53","v":-1.0657776511832537},{"$f":"$O$53","v":-1.0657776511832537}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"P58","v":"2021-22"},null,null,null,null,null,{"$f":"$P$53","v":4.4081684410836317},{"$f":"$P$53","v":4.4081684410836317},{"$f":"$P$53","v":4.4081684410836317},{"$f":"$P$53","v":4.4081684410836317},{"$f":"$P$53","v":4.4081684410836317}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Q58","v":"2022-23"},null,null,null,null,null,null,{"$f":"+$Q$53","v":-14.559485665668461},{"$f":"+$Q$53","v":-14.559485665668461},{"$f":"+$Q$53","v":-14.559485665668461},{"$f":"+$Q$53","v":-14.559485665668461},{"$f":"+$Q$53","v":-14.559485665668461}]
[null,null,null,null,null,null,null,null,null,null,"Total Carryover Amount ($m, June 2023)",null,null,null,null,null,null,{"$f":"+SUM(R59:R63)","v":13.491284419519069},{"$f":"+SUM(S60:S63)","v":-1.4755210874990325},{"$f":"+SUM(T61:T63)","v":-11.217094875768083},{"$f":"+SUM(U62:U63)","v":-10.15131722458483},{"$f":"+SUM(V63)","v":-14.559485665668461},{"$f":"+SUM(R64:V64)","v":-23.912134434001338}]
[]
[null,null,null,null,null,null,null,null,null,null,"PTRM inputs ($m, June 2023)",null,null,null,null,null,null,{"$f":"R64","v":13.491284419519069},{"$f":"S64","v":-1.4755210874990325},{"$f":"T64","v":-11.217094875768083},{"$f":"U64","v":-10.15131722458483},{"$f":"V64","v":-14.559485665668461},{"$f":"+SUM(R66:V66)","v":-23.912134434001338}]