{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Index","Input | General","Input | Inflation and Disc Rate","Input | Reported Capex","Calc | CESS Revenue Increments","Output | Models","Lookup | Tables"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"comments":2,"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":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"}]
[null,"Index"]
[]
[null,null,"Model index"]
[]
[null,null,"Sheet Name","Sheet Description"]
[null,null,"Input | General","Inputs NSP name, regulatory years for the prior and forecast regulatory control period etc."]
[null,null,"Input | Inflation and Disc Rate","Inputs the inflation and discount rate"]
[null,null,"Input | Reported Capex","Inputs the reported capital expenditure from the prior regulatory control period as well as the AER's forecast etc."]
[null,null,"Calc | CESS Revenue Increments","Calculates the CESS payments from the prior regulatory control period"]
[null,null,"Output | Models","Outputs the CESS revenue increments needed as a post tax revenue model input"]
[null,null,"Lookup | Tables","Includes the lookup tables used within the CESS model."]
[]
[null,null,"End"]

{"sheet":"Input | General","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"$D$6&\" \"&$D$8&\" \"&D7&\" - \"&\"Capital expenditure sharing scheme model\"","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,"Key:","Input","Internal Link"]
[null,"Input | General"]
[]
[null,"Input | General"]
[]
[null,null,"NSP Name","TransGrid"]
[null,null,"Determination stage","Final Decision"]
[null,null,"Determination years","2018-23"]
[]
[null,null,"Regulatory control period details"]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS applied in (regulatory years)","2014-15","2015-16","2016-17","2017-18","n/a"]
[null,null,"CESS to apply to this year's expenditure (Yes/No)","No","Yes","Yes","Yes","No"]
[null,null,"Actual or estimate year","Actual","Actual","Actual","Estimate","n/a"]
[]
[null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Regulatory control period CESS revenue increment applied in (regulatory years)","2018-19","2019-20","2020-21","2021-22","2022-23"]
[null,null,"Regulatory control period prior to CESS applied in (regulatory years)","2009-10","2010-11","2011-12","2012-13","2013-14"]
[]
[null,"End"]

{"sheet":"Input | Inflation and Disc Rate","index":2,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,"Key:","Input","Internal Link","AER amendments"]
[null,null,"Input | Inflation and Discount rate"]
[]
[null,null,"Input | Inflation"]
[]
[null,null,null,"Source","Unit"]
[null,null,null,null,null,{"$f":"'Lookup | Tables'!$E$27","v":"2013-14"},{"$f":"'Lookup | Tables'!$E$28","v":"2014-15"},{"$f":"'Lookup | Tables'!$E$29","v":"2015-16"},{"$f":"'Lookup | Tables'!$E$30","v":"2016-17"},{"$f":"'Lookup | Tables'!$E$31","v":"2017-18"},{"$f":"'Lookup | Tables'!$E$32","v":"2018-19"},{"$f":"'Lookup | Tables'!$E$33","v":"2019-20"},{"$f":"'Lookup | Tables'!$E$34","v":"2020-21"},{"$f":"'Lookup | Tables'!$E$35","v":"2021-22"},{"$f":"'Lookup | Tables'!$E$36","v":"2022-23"},{"$f":"'Lookup | Tables'!$E$37","v":"2023-24"}]
[null,null,"Actual CPI Inflation Rate","TNSP","Per cent",null,1.7175572519083901E-2,1.6885553470919398E-2,1.4760147601476E-2,0.02]
[null,null,"Forecast CPI Inflation Rate","TNSP","Per cent",null,null,null,null,null,2.473798145515536E-2,{"$f":"K9","v":2.473798145515536E-2},{"$f":"L9","v":2.473798145515536E-2},2.473798145515536E-2,2.473798145515536E-2,2.473798145515536E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2013-14)"},"TNSP","Index",1,{"$f":"IF(G7<>\"\",(F10*(1+G8)),\"\")","v":1.0171755725190839},{"$f":"IF(H7<>\"\",(G10*(1+H8)),\"\")","v":1.0343511450381679},{"$f":"IF(I7<>\"\",(H10*(1+I8)),\"\")","v":1.0496183206106871},{"$f":"IF(J7<>\"\",(I10*(1+J8)),\"\")","v":1.0706106870229009},{"$f":"IF(K7<>\"\",(J10*(1+K9)),\"\")","v":1.0970954343441646},1.1242353608535061,1.1520466743615301,1.1805459836273591,1.2097503082772909,1.2396770889688231]
[]
[]
[null,null,"Actual CPI Inflation Rate","AER","Per cent",null,1.7175572519083901E-2,1.6885553470919398E-2,1.4760147601476E-2,1.9090909090909047E-2]
[null,null,"Forecast CPI Inflation Rate","AER","Per cent",null,null,null,null,null,2.4499511480040148E-2,{"$f":"K14","v":2.4499511480040148E-2},{"$f":"L14","v":2.4499511480040148E-2},2.4499511480040148E-2,2.4499511480040148E-2,2.4499511480040148E-2]
[null,null,{"$f":"\"CPI Index (base year \"&F7&\")\"","v":"CPI Index (base year 2013-14)"},"AER","Index",1,{"$f":"IF(G7<>\"\",(F15*(1+G13)),\"\")","v":1.0171755725190839},{"$f":"IF(H7<>\"\",(G15*(1+H13)),\"\")","v":1.0343511450381679},{"$f":"IF(I7<>\"\",(H15*(1+I13)),\"\")","v":1.0496183206106871},{"$f":"IF(J7<>\"\",(I15*(1+J13)),\"\")","v":1.0696564885496183},{"$f":"IF(K7<>\"\",(J15*(1+K14)),\"\")","v":1.095862549970539},1.1227106470940882,1.150216509481333,1.1783962520599027,1.2072663845652807,1.2368438212134043]
[]
[null,null,"Input | Discount rate"]
[]
[null,null,null,"Source","Unit",null,{"$f":"'Lookup | Tables'!$E$28","v":"2014-15"},{"$f":"'Lookup | Tables'!$E$29","v":"2015-16"},{"$f":"'Lookup | Tables'!$E$30","v":"2016-17"},{"$f":"'Lookup | Tables'!$E$31","v":"2017-18"},{"$f":"'Lookup | Tables'!$E$32","v":"2018-19"},{"$f":"'Lookup | Tables'!$E$33","v":"2019-20"},{"$f":"'Lookup | Tables'!$E$34","v":"2020-21"},{"$f":"'Lookup | Tables'!$E$35","v":"2021-22"},{"$f":"'Lookup | Tables'!$E$36","v":"2022-23"}]
[null,null,"Real Vanilla WACC","AER","Per cent",null,null,4.2670876489658394E-2,4.1872840151219171E-2,4.0826204640587838E-2,3.993698958963017E-2,{"$f":"K20","v":3.993698958963017E-2},{"$f":"L20","v":3.993698958963017E-2},3.993698958963017E-2,3.993698958963017E-2]
[]
[null,null,"Nominal Vanilla WACC (fixed, real, time varying)","Calculated","Per cent",null,{"$f":"IF(AND('Input | Inflation and Disc Rate'!H8<>\"\",G20<>\"\"),((1+G20)*(1+'Input | Inflation and Disc Rate'!H8)-1),\"\")","v":""},{"$f":"IF(AND(H8<>\"\",H20<>\"\"),((1+H20)*(1+H8)-1),\"\")","v":6.0276951327194794E-2},{"$f":"IF(AND(I8<>\"\",I20<>\"\"),((1+I20)*(1+I8)-1),\"\")","v":5.7251037053820175E-2},{"$f":"IF(AND(J8<>\"\",J20<>\"\"),((1+J20)*(1+J8)-1),\"\")","v":6.1642728733399599E-2},{"$f":"IF(AND(K14<>\"\",K20<>\"\"),((1+K20)*(1+K14)-1),\"\")","v":6.5414937804599838E-2},{"$f":"IF(AND(L14<>\"\",L20<>\"\"),((1+L20)*(1+L14)-1),\"\")","v":6.5414937804599838E-2},{"$f":"IF(AND(M14<>\"\",M20<>\"\"),((1+M20)*(1+M14)-1),\"\")","v":6.5414937804599838E-2},{"$f":"IF(AND(N14<>\"\",N20<>\"\"),((1+N20)*(1+N14)-1),\"\")","v":6.5414937804599838E-2},{"$f":"IF(AND(O14<>\"\",O20<>\"\"),((1+O20)*(1+O14)-1),\"\")","v":6.5414937804599838E-2}]
[]
[null,"End"]

{"sheet":"Input | Reported Capex","index":3,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link","AER amendments"]
[null,"Input | Capex"]
[]
[null,"Input | Capex Allowance"]
[]
[null,null,null,"Source","Unit","Basis",null,"n/a","2015-16","2016-17","2017-18","n/a"]
[]
[null,null,"Total capex allowance","AER","$millions","2013-14",null,null,304.60562586047001,235.329574147042,219.78423032238899]
[null,null,"Total excludable capex","AER","$millions","2013-14",null,null,2.6572200605991099,2.6572200605991099,2.6572200605991099]
[]
[null,null,"Total capex allowance applicable to CESS","Calculated","$millions","2013-14",null,{"$f":"IF(H6=\"\", \"\", H8-H9)","v":0},{"$f":"IF(I6=\"\", \"\", I8-I9)","v":301.9484057998709},{"$f":"IF(J6=\"\", \"\", J8-J9)","v":232.67235408644288},217.12701026178988,0]
[]
[null,"Input | Actual / Estimate Capex"]
[]
[null,null,null,"Source","Unit","Basis",null,"n/a","2015-16","2016-17","2017-18","n/a"]
[]
[null,null,"Total capex","AER","$millions","nominal",null,null,247.26483301340801,184.75,227.48152321176545]
[null,null,"Asset Disposals","AER","$millions","nominal",null,null,2.8681799100000003,1.9167664099999999,3.8838265341818179]
[null,null,"NCIPAP","AER","$millions","nominal",null,null,7.1001515599999987,8.1106276900000012,3.16916597046239]
[null,null,"Total excludable capex","AER","$millions","nominal",null,null,{"$f":"I18+I19","v":9.968331469999999},{"$f":"J18+J19","v":10.0273941},7.0529925046442079]
[]
[null,null,"Total actual capex applicable to CESS","Calculated","$millions","nominal",null,{"$f":"IF(H15=\"\", \"\", H17-H20)","v":0},{"$f":"IF(I15=\"\", \"\", I17-I20)","v":237.296501543408},{"$f":"IF(J15=\"\", \"\", J17-J20)","v":174.72260589999999},{"$f":"IF(K15=\"\", \"\", K17-K20)","v":220.42853070712124},{"$f":"IF(L15=\"\", \"\", L17-L20)","v":0}]
[]
[null,"Input | Capex Deferred to following regulatory period"]
[]
[null,null,null,null,null,null,null,{"$f":"'Input | General'!D17","v":"2018-19"},{"$f":"'Input | General'!E17","v":"2019-20"},{"$f":"'Input | General'!F17","v":"2020-21"},{"$f":"'Input | General'!G17","v":"2021-22"},{"$f":"'Input | General'!H17","v":"2022-23"}]
[]
[null,null,"Capex deferred and re-proposed","TNSP","$millions","nominal",null,13.031505317655901,26.627304979359501,0,0,0]
[null,null,"Capex deferred and re-proposed","Calculated","$millions","2013-14",null,{"$f":"IF(H28<>\"\",H28/('Input | Inflation and Disc Rate'!J10*(1+'Input | Inflation and Disc Rate'!K9)^0.5),\"\")","v":12.024211165477547},{"$f":"IF(I28<>\"\",I28/('Input | Inflation and Disc Rate'!K10*(1+'Input | Inflation and Disc Rate'!L9)^0.5),\"\")","v":23.975981130082509},{"$f":"IF(J28<>\"\",J28/('Input | Inflation and Disc Rate'!L10*(1+'Input | Inflation and Disc Rate'!M9)^0.5),\"\")","v":0},{"$f":"IF(K28<>\"\",K28/('Input | Inflation and Disc Rate'!M10*(1+'Input | Inflation and Disc Rate'!N9)^0.5),\"\")","v":0},{"$f":"IF(L28<>\"\",L28/('Input | Inflation and Disc Rate'!N10*(1+'Input | Inflation and Disc Rate'!O9)^0.5),\"\")","v":0}]
[null,null,"Capex deferred and re-proposed","AER","$millions","nominal",null,{"$f":"IF(H28<>\"\",H29*'Input | Inflation and Disc Rate'!J15*(1+'Input | Inflation and Disc Rate'!K14)^0.5,\"\")","v":13.018375747422033},{"$f":"IF(I28<>\"\",I29*'Input | Inflation and Disc Rate'!K15*(1+'Input | Inflation and Disc Rate'!L14)^0.5,\"\")","v":26.594287017985444},{"$f":"IF(J28<>\"\",J29*'Input | Inflation and Disc Rate'!L15*(1+'Input | Inflation and Disc Rate'!M14)^0.5,\"\")","v":0},{"$f":"IF(K28<>\"\",K29*'Input | Inflation and Disc Rate'!M15*(1+'Input | Inflation and Disc Rate'!N14)^0.5,\"\")","v":0},{"$f":"IF(L28<>\"\",L29*'Input | Inflation and Disc Rate'!N15*(1+'Input | Inflation and Disc Rate'!O14)^0.5,\"\")","v":0}]
[]
[null,"End"]

{"sheet":"Calc | CESS Revenue Increments","index":4,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link","AER amendments"]
[null,"Input | CESS Payments"]
[]
[null,"Calc | NPV of CESS payments"]
[]
[null,null,"Regulatory period 1"]
[null,null,"Year","n/a","2015-16","2016-17","2017-18","n/a"]
[null,null,"Discount rate (Real WACC)",null,{"$f":"'Input | Inflation and Disc Rate'!H20","v":4.2670876489658394E-2},{"$f":"'Input | Inflation and Disc Rate'!I20","v":4.1872840151219171E-2},{"$f":"'Input | Inflation and Disc Rate'!J20","v":4.0826204640587838E-2}]
[null,null,"Discount rate (Nominal, fixed real WACC)",null,{"$f":"'Input | Inflation and Disc Rate'!H22","v":6.0276951327194794E-2},{"$f":"'Input | Inflation and Disc Rate'!I22","v":5.7251037053820175E-2},{"$f":"'Input | Inflation and Disc Rate'!J22","v":6.1642728733399599E-2}]
[null,null,"Capex allowance",null,{"$f":"'Input | Reported Capex'!I$11*'Input | Inflation and Disc Rate'!H$15*(1+'Input | Inflation and Disc Rate'!H$20)^0.5","v":318.91457085488815},{"$f":"'Input | Reported Capex'!J$11*'Input | Inflation and Disc Rate'!I$15*(1+'Input | Inflation and Disc Rate'!I$20)^0.5","v":249.2777665251393},{"$f":"'Input | Reported Capex'!K$11*'Input | Inflation and Disc Rate'!J$15*(1+'Input | Inflation and Disc Rate'!J$20)^0.5","v":236.94485954228477}]
[null,null,"Actual capex",null,{"$f":"'Input | Reported Capex'!I22*(1+E$9)^0.5","v":244.34361552962466},{"$f":"'Input | Reported Capex'!J22*(1+F$9)^0.5","v":179.65452413624101},{"$f":"'Input | Reported Capex'!K22*(1+G$9)^0.5","v":227.12084777342156}]
[null,null,"Underspend",null,{"$f":"(E10-E11)","v":74.570955325263498},{"$f":"(F10-F11)","v":69.623242388898291},9.8240117688632154]
[null,null,"Year 1 benefit",null,{"$f":"$D$12*$E$8","v":0},{"$f":"$D$12*$F$8*(1+'Input | Inflation and Disc Rate'!H13)","v":0},{"$f":"$D$12*$G$8*(1+'Input | Inflation and Disc Rate'!H13)*(1+'Input | Inflation and Disc Rate'!I13)","v":0}]
[null,null,"Year 2 benefit",null,null,{"$f":"$E$12*F$8","v":3.1224976922584644},{"$f":"$E$12*G$8*(1+'Input | Inflation and Disc Rate'!I13)","v":3.0893856001740545}]
[null,null,"Year 3 benefit",null,null,null,{"$f":"$F$12*G$8","v":2.8424527415104111}]
[null,null,"Year 4 benefit"]
[null,null,"Year 5 benefit"]
[null,null,"Total financing benefit",null,{"$f":"SUM(E13:E17)","v":0},{"$f":"SUM(F13:F17)","v":3.1224976922584644},5.9318383416844656]
[null,null,"Discount factor (end of year)",null,{"$f":"F19*(1+F$9)","v":1.1224228759340342},{"$f":"G19*(1+G$9)","v":1.0616427287333996},1]
[null,null,"NPV underspend",null,{"$f":"E12*E19","v":83.700146137330634},{"$f":"F12*F19","v":73.915009033016872},{"$f":"G12*G19","v":9.8240117688632154}]
[null,null,"NPV financing benefit",null,{"$f":"E18*E19","v":0},{"$f":"F18*F19","v":3.314976970473019},{"$f":"G18*G19","v":5.9318383416844656}]
[]
[null,null,"Regulatory period 2"]
[null,null,"Year",{"$f":"'Input | General'!$D$17","v":"2018-19"},{"$f":"'Input | General'!$E$17","v":"2019-20"},{"$f":"'Input | General'!$F$17","v":"2020-21"},{"$f":"'Input | General'!$G$17","v":"2021-22"},{"$f":"'Input | General'!$H$17","v":"2022-23"}]
[null,null,"Discount rate:",{"$f":"'Input | Inflation and Disc Rate'!$K$22","v":6.5414937804599838E-2},{"$f":"'Input | Inflation and Disc Rate'!$L$22","v":6.5414937804599838E-2},{"$f":"'Input | Inflation and Disc Rate'!$M$22","v":6.5414937804599838E-2},{"$f":"'Input | Inflation and Disc Rate'!$N$22","v":6.5414937804599838E-2},{"$f":"'Input | Inflation and Disc Rate'!$O$22","v":6.5414937804599838E-2}]
[null,null,"Increase in forecast capex in regulatory period 2 attributable to capex deferred in regulatory period 1",{"$f":"'Input | Reported Capex'!H30","v":13.018375747422033},{"$f":"'Input | Reported Capex'!I30","v":26.594287017985444},{"$f":"'Input | Reported Capex'!J30","v":0},{"$f":"'Input | Reported Capex'!K30","v":0},{"$f":"'Input | Reported Capex'!L30","v":0}]
[null,null,"Discount factor (middle of year 5)",{"$f":"1/(1+D25)^(0.5)","v":0.96881445326806703},{"$f":"1/((1+E25)^(0.5)*(1+D25))","v":0.90933064563972765},{"$f":"1/((1+F25)^(0.5)*(1+E25)*(1+D25))","v":0.85349905785392843},{"$f":"1/((1+G25)^(0.5)*(1+F25)*(1+E25)*(1+D25))","v":0.80109544888928774},{"$f":"1/((1+H25)^(0.5)*(1+G25)*(1+F25)*(1+E25)*(1+D25))","v":0.75190934579913971}]
[null,null,"NPV of increase in forecast capex from deferred capex",{"$f":"D26*D27","v":12.612390582176939},{"$f":"E26*E27","v":24.183000184392931},0,0,0]
[]
[null,null,"CESS calculation (post-adjustment)"]
[null,null,"Total underspend (NPV) adjusted for deferrals",{"$f":"SUM(D20:H20)-SUM(D28:H28)","v":130.64377617264086}]
[null,null,"Relevant sharing ratio",0.3]
[null,null,"Consumer share",{"$f":"(1-D32)*D31","v":91.450643320848599}]
[null,null,"NSP share",{"$f":"D32*D31","v":39.193132851792257}]
[null,null,"Total NSP financing benefit (NPV)",{"$f":"SUM(D21:H21)","v":9.2468153121574836}]
[null,null,"NPV of CESS payments (post-adjustment)",{"$f":"D34-D35","v":29.946317539634773}]
[]
[null,"Calc | Total CESS Payments"]
[]
[null,null,null,{"$f":"'Input | General'!D17","v":"2018-19"},{"$f":"'Input | General'!E17","v":"2019-20"},{"$f":"'Input | General'!F17","v":"2020-21"},{"$f":"'Input | General'!G17","v":"2021-22"},{"$f":"'Input | General'!H17","v":"2022-23"}]
[null,null,{"$f":"CONCATENATE(\"CESS Payment Per Year ($\", 'Output | Models'!F4,\" million)\")","v":"CESS Payment Per Year ($2017-18 million)"},{"$f":"-PMT('Input | Inflation and Disc Rate'!K20,5,'Calc | CESS Revenue Increments'!$D$36)","v":6.7255642007890835},{"$f":"D41","v":6.7255642007890835},{"$f":"E41","v":6.7255642007890835},6.7255642007890835,6.7255642007890835]
[]
[null,null,{"$f":"CONCATENATE(\"Total CESS Payment ($\", 'Output | Models'!$F$4,\" million)\")","v":"Total CESS Payment ($2017-18 million)"},{"$f":"SUM(D41:H41)","v":33.627821003945414}]
[]
[]
[null,"End"]

{"sheet":"Output | Models","index":5,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,9,2,11],[2,13,2,19]]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Output | Models"]
[]
[null,"Inputs for Post Tax Revenue Model",null,null,"$millions","2017-18",null,null,null,"Note. The dollar base should be consistent with the post tax revenue model"]
[]
[null,null,"Revenue Adjustments","Source","Unit","Basis",null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D40","v":"2018-19"},{"$f":"'Calc | CESS Revenue Increments'!E40","v":"2019-20"},{"$f":"'Calc | CESS Revenue Increments'!F40","v":"2020-21"},{"$f":"'Calc | CESS Revenue Increments'!G40","v":"2021-22"},{"$f":"'Calc | CESS Revenue Increments'!H40","v":"2022-23"},"Total"]
[]
[null,null,"CESS increments as per NER 6A.5.4(a)(5)","Calc | CESS Revenue Increments",{"$f":"$E$4","v":"$millions"},{"$f":"$F$4","v":"2017-18"},null,null,null,{"$f":"'Calc | CESS Revenue Increments'!D41","v":6.7255642007890835},{"$f":"'Calc | CESS Revenue Increments'!E41","v":6.7255642007890835},{"$f":"'Calc | CESS Revenue Increments'!F41","v":6.7255642007890835},{"$f":"'Calc | CESS Revenue Increments'!G41","v":6.7255642007890835},{"$f":"'Calc | CESS Revenue Increments'!H41","v":6.7255642007890835},{"$f":"SUM(J8:N8)","v":33.627821003945414}]
[]
[]
[null,"End"]

{"sheet":"Lookup | Tables","index":6,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Input | General'!$B$1","v":"TransGrid 2018-23 Final Decision - Capital expenditure sharing scheme model"},null,null,null,null,null,null,"Key:","Input","Internal Link"]
[null,"Lookup | Tables"]
[]
[null,"Unit Denominations"]
[]
[null,null,"Denominations",null,"Ref"]
[null,null,"Dollars",null,"$dollars"]
[null,null,"Thousands",null,"$000"]
[null,null,"Millions",null,"$millions"]
[]
[null,null,"Actual",null,"Actual"]
[null,null,"Estimate",null,"Estimate"]
[null,null,"not applicable",null,"n/a"]
[]
[]
[null,"Years"]
[]
[null,null,{"$f":"B16","v":"Years"},null,"Ref"]
[null,null,"not applicable",null,"n/a"]
[null,null,"nominal",null,"nominal"]
[null,null,"2007-08",null,"2007-08"]
[null,null,"2008-09",null,"2008-09"]
[null,null,"2009-10",null,"2009-10"]
[null,null,"2010-11",null,"2010-11"]
[null,null,"2011-12",null,"2011-12"]
[null,null,"2012-13",null,"2012-13"]
[null,null,"2013-14",null,"2013-14"]
[null,null,"2014-15",null,"2014-15"]
[null,null,"2015-16",null,"2015-16"]
[null,null,"2016-17",null,"2016-17"]
[null,null,"2017-18",null,"2017-18"]
[null,null,"2018-19",null,"2018-19"]
[null,null,"2019-20",null,"2019-20"]
[null,null,"2020-21",null,"2020-21"]
[null,null,"2021-22",null,"2021-22"]
[null,null,"2022-23",null,"2022-23"]
[null,null,"2023-24",null,"2023-24"]
[]
[null,"End"]