{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Index","Residuals","T1","T2","T3 & Fig 1","T4","T5","T6","T7","T8","T9","T10 & Fig 2","T11 & Fig 3","T12 & Fig 4","T13","T14","T15","T16","T17","T18","S1 - S2","S3","S4","S5","S6 - S7","S8 - S9","S10","S11 & Fig S1","S12 & Fig S2","S13 & Fig S3","S14","S15 & Fig S4","S16 & Fig S5","T19","T20","T21","T22","T23","T24","T25-28","T29"],"not_rendered":{"charts":14,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":41,"n_cols":1,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["INDEX - click the links below to navigate"]
[{"$f":"Residuals!A1","v":"Residuals and Averages"}]
[{"$f":"'T1'!A1","v":"Table 1 - Changes to Average Generation Tariffs"}]
[{"$f":"'T2'!A1","v":"Table 2 - Generation Wider Tariffs"}]
[{"$f":"'T3 & Fig 1'!A1","v":"Table 3 - Generation Tariff Changes"}]
[{"$f":"'T4'!A1","v":"Table 4 - Local Substation Tariffs"}]
[{"$f":"'T5'!A1:F1","v":"Table 5 - Onshore Local Circuit Tariffs"}]
[{"$f":"'T6'!A1","v":"Table 6 - CMP203: Circuits subject to one-off charges"}]
[{"$f":"'T7'!A1","v":"Table 7 - Offshore Local Tariffs"}]
[{"$f":"'T8'!A1","v":"Table 8 - Summary of Demand Tariffs"}]
[{"$f":"'T9'!A1","v":"Table 9 - Demand Tariffs"}]
[{"$f":"'T10 & Fig 2'!A1","v":"Table 10 - Change in HH Demand Tariffs"}]
[{"$f":"'T11 & Fig 3'!A1","v":"Table 11 - Embedded Export Tariff"}]
[{"$f":"'T12 & Fig 4'!A1","v":"Table 12 - NHH Demand Tariff Changes"}]
[{"$f":"'T13'!A1","v":"Table 13 - Contracted and Modelled TEC"}]
[{"$f":"'T14'!A1","v":"Table 14 - Interconnectors"}]
[{"$f":"'T15'!A1","v":"Table 15 - Allowed Revenues"}]
[{"$f":"'T16'!B1","v":"Table 16 - Generation and Demand Revenue Proportions"}]
[{"$f":"'T17'!A1","v":"Table 17 - Charging Bases"}]
[{"$f":"'T18'!B1","v":"Table 18 - Residual Calculation"}]
[{"$f":"'S1 - S2'!A1","v":"Table S1 & S2 – The effect of including CMP344"}]
[{"$f":"'S3'!A1:E1","v":"Table S3 – The effect of including congestion management"}]
[{"$f":"'S4'!A1","v":"Table S4 - Generation revenue breakdown and adjustment tariff under GOS sensitivity"}]
[{"$f":"'S5'!A1","v":"Table S5 - Generation revenue breakdown and adjustment tariff under GOS sensitivity"}]
["Tables S6 & S7- Impact of security factor at 2d.p."]
["Tables S8 & S9- Impact of security factor at 2d.p."]
["Table S10 - Summary of Demand Tariffs (Base Case vs RIIO-2 EC&F Update)"]
["Table S11 - Change in HH Demand Tariffs (Base Case vs RIIO-2 EC&F Update)"]
["Table S12 - Embedded Export Tariff (Base Case vs RIIO-2 EC&F Update)"]
["Table S13 - NHH Demand Tariff Changes (Base Case vs RIIO-2 EC&F Update)"]
["Table S14 - Changes to Average Tariffs (Base Case vs RIIO-2 EC&F Update)"]
["Table S15 - Generation Wider Tariffs (Base Case vs RIIO-2 EC&F Update)"]
["Table S16 - Generation Tariff Changes (Base Case vs RIIO-2 EC&F Update)"]
[{"$f":"'T19'!A1","v":"Table 19 - Summary of in flight CUSC modification proposals"}]
[{"$f":"'T20'!A1","v":"Table 20 - Demand Locational Tariffs"}]
[{"$f":"'T21'!A1","v":"Table 21 - Breakdown of the Embedded Export Tariff"}]
[{"$f":"'T22'!A1","v":"Table 22 - Demand Profiles"}]
[{"$f":"'T23'!A1","v":"Table 23 - Generic Annual Load Factors"}]
[{"$f":"'T24'!A1","v":"Table 24 - Connected Generation Changes"}]
[{"$f":"'T25-28'!A1","v":"Tables 25-28 - Revenue Breakdown"}]
[{"$f":"'T29'!A1","v":"Table 29 - Offshore Revenues"}]

{"sheet":"Residuals","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Residuals and Averages",null,null,"Return to Index"]
[]
["Residual",{"$f":"'T1'!B3","v":"2021/22 August"},{"$f":"'T1'!C3","v":"2021/22 Draft"},{"$f":"'T1'!D3","v":"Change since last forecast"}]
["Generation",{"$f":"'T1'!B4","v":-0.23275133955530214},{"$f":"'T1'!C4","v":-2.7640368812570482E-2},{"$f":"'T1'!D4","v":0.20511097074273166}]
["Demand",{"$f":"'T8'!C5","v":46.554084744110241},{"$f":"'T8'!D5","v":54.342511999999999},{"$f":"'T8'!E5","v":7.7884272558897578}]
[]
["Average Tariff",{"$f":"B3","v":"2021/22 August"},{"$f":"C3","v":"2021/22 Draft"},{"$f":"D3","v":"Change since last forecast"}]
["Generation (£/kW)",{"$f":"'T1'!B5","v":10.740460713124222},{"$f":"'T1'!C5","v":11.351149234259138},{"$f":"'T1'!D5","v":0.61068852113491623}," N.B. These generation average tariffs include local tariffs"]
["HH Demand (£/kW)",{"$f":"'T8'!C4","v":44.812728374050913},{"$f":"'T8'!D4","v":52.460811999999997},{"$f":"C9-B9","v":7.6480836259490843}]
["NHH Demand (p/kWh)",{"$f":"'T8'!C13","v":5.69019389256436},{"$f":"'T8'!D13","v":6.5636200000000002},{"$f":"C10-B10","v":0.8734261074356402}]
["Embedded Export (£/kW)",{"$f":"'T8'!C7","v":1.8591220043783883},{"$f":"'T8'!D7","v":2.272481},{"$f":"C11-B11","v":0.41335899562161171}]

{"sheet":"T1","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Changes to Average Generation Tariffs",null,null,null,null,"Return to Index"]
[]
["Generation Tariffs \n(£/kW)","2021/22 August","2021/22 Draft","Change since last forecast"]
["Residual",-0.23275133955530214,-2.7640368812570482E-2,{"$f":"C4-B4","v":0.20511097074273166}]
["Average Generation Tariff*",10.740460713124222,11.351149234259138,{"$f":"C5-B5","v":0.61068852113491623}]
["*N.B. These generation average tariffs include local tariffs"]

{"sheet":"T2","index":3,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,6,3,8],[2,2,2,8],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5]]}
["Table 2 - Generation Wider Tariffs",null,null,null,null,null,null,null,"Return to Index"]
[]
[null,null,"Tariffs (£/kW)"]
[null,null,null,null,null,null,"Example tariffs for a generator of each technology type"]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name",null,null,null,null,"Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",4.2335149999999997,20.365952,19.336158000000001,-2.7640000000000001E-2,35.967563000000006,39.834794600000002,27.454898799999999]
[2,"East Aberdeenshire",3.2339150000000001,10.749345999999999,19.336158000000001,-2.7640000000000001E-2,27.2746782,31.141909799999997,23.608256399999998]
[3,"Western Highlands",3.941805,18.596782000000001,18.609310000000001,-2.7640000000000001E-2,33.679038600000005,37.400900600000007,26.0203828]
[4,"Skye and Lochalsh",-0.61591700000000005,18.596782000000001,20.430374,-2.7640000000000001E-2,30.578167800000003,34.664242600000001,27.8414468]
[5,"Eastern Grampian and Tayside",4.7484279999999996,13.720708,15.692907,-2.7640000000000001E-2,28.25168,31.390261399999996,21.153550199999998]
[6,"Central Grampian",4.3828259999999997,14.674469,16.787796,-2.7640000000000001E-2,29.524998,32.882557200000001,22.629943600000001]
[7,"Argyll",2.7133850000000002,12.693899,25.645643,-2.7640000000000001E-2,33.357378600000004,38.486507200000005,30.695562599999999]
[8,"The Trossachs",3.8560940000000001,12.693899,14.471672999999999,-2.7640000000000001E-2,25.560911599999997,28.455246200000001,19.521592599999998]
[9,"Stirlingshire and Fife",2.7358060000000002,11.216771,13.214771000000001,-2.7640000000000001E-2,22.253399600000002,24.8963538,17.673839399999999]
[10,"South West Scotlands",3.0296219999999998,11.576869,13.492566999999999,-2.7640000000000001E-2,23.057530799999999,25.756044199999998,18.095674599999999]
[11,"Lothian and Borders",2.9962939999999998,11.576869,6.6802460000000004,-2.7640000000000001E-2,17.574345999999998,18.9103952,11.2833536]
[12,"Solway and Cheviot",2.5898850000000002,7.8033229999999998,7.4846199999999996,-2.7640000000000001E-2,14.7925994,16.289523399999997,10.5783092]
[13,"North East England",3.43228,6.0402009999999997,4.5202609999999996,-2.7640000000000001E-2,11.8530096,12.757061800000001,6.9087014]
[14,"North Lancashire and The Lakes",2.5494970000000001,6.0402009999999997,1.282715,-2.7640000000000001E-2,8.3801898000000001,8.6367328000000008,3.6711554000000004]
[15,"South Lancashire, Yorkshire and Humber",3.8898860000000002,2.4591620000000001,0.35705999999999999,-2.7640000000000001E-2,6.1152236000000002,6.1866355999999998,1.3130847999999999]
[16,"North Midlands and North Wales",3.250289,0.88713600000000004,0,-2.7640000000000001E-2,3.9323578000000001,3.9323578000000001,0.32721440000000002]
[17,"South Lincolnshire and North Norfolk",1.3454029999999999,1.591046,0,-2.7640000000000001E-2,2.5905998000000001,2.5905998000000001,0.60877840000000005]
[18,"Mid Wales and The Midlands",1.6672769999999999,1.8350249999999999,0,-2.7640000000000001E-2,3.1076570000000001,3.1076570000000001,0.70637000000000005]
[19,"Anglesey and Snowdon",4.9147410000000002,1.0336449999999999,0,-2.7640000000000001E-2,5.7140170000000001,5.7140170000000001,0.38581799999999999]
[20,"Pembrokeshire",7.6313230000000001,-6.4657609999999996,0,-2.7640000000000001E-2,2.4310742000000003,2.4310742000000003,-2.6139443999999998]
[21,"South Wales & Gloucester",3.5000070000000001,-6.8097950000000003,0,-2.7640000000000001E-2,-1.9754690000000006,-1.9754690000000006,-2.7515580000000002]
[22,"Cotswold",2.3340139999999998,3.6074769999999998,-8.6757439999999999,-2.7640000000000001E-2,-1.7482396000000009,-3.4833883999999999,-7.2603931999999993]
[23,"Central London",-3.7769170000000001,3.6074769999999998,-5.6553399999999998,-2.7640000000000001E-2,-5.4428473999999998,-6.5739153999999997,-4.2399892000000001]
[24,"Essex and Kent",-3.4190209999999999,3.6074769999999998,0,-2.7640000000000001E-2,-0.56067939999999983,-0.56067939999999983,1.4153507999999999]
[25,"Oxfordshire, Surrey and Sussex",-1.011088,-1.924661,0,-2.7640000000000001E-2,-2.5784567999999997,-2.5784567999999997,-0.7975044]
[26,"Somerset and Wessex",-2.3052619999999999,-3.3961039999999998,0,-2.7640000000000001E-2,-5.0497851999999996,-5.0497851999999996,-1.3860816]
[27,"West Devon and Cornwall",-2.5906419999999999,-8.5276739999999993,0,-2.7640000000000001E-2,-9.4404211999999994,-9.4404211999999994,-3.4387095999999997]

{"sheet":"T3 & Fig 1","index":4,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,8,4,10],[4,11,5,11],[0,0,0,10],[4,5,4,7],[3,2,3,11]]}
["Table 3 - Generation Tariff Changes",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
[]
[null,null,"Wider Generation Tariffs (£/kW)"]
[null,null,"Conventional Carbon 80%",null,null,"Conventional Low Carbon 80%",null,null,"Intermittent 40%",null,null,"Change in Residual"]
["Zone","Zone Name","2021/22 August","2021/22 Draft","Change","2021/22 August","2021/22 Draft","Change","2021/22 August","2021/22 Draft","Change"]
[1,"North Scotland",35.274427600000003,35.967563000000006,{"$f":"D7-C7","v":0.69313540000000273},39.047685800000004,39.834794600000002,{"$f":"G7-F7","v":0.78710879999999861},26.669580400000001,27.454898799999999,{"$f":"J7-I7","v":0.78531839999999775},0.20511097074273166]
[2,"East Aberdeenshire",26.632864200000004,27.2746782,{"$f":"D8-C8","v":0.64181399999999655},30.406122400000001,31.141909799999997,{"$f":"G8-F8","v":0.73578739999999598},22.893911200000002,23.608256399999998,{"$f":"J8-I8","v":0.71434519999999679},0.20511097074273166]
[3,"Western Highlands",32.942152999999998,33.679038600000005,0.73688560000000791,36.583199200000003,37.400900600000007,0.81770140000000424,25.287879600000004,26.0203828,0.73250319999999647,0.20511097074273166]
[4,"Skye and Lochalsh",26.389325200000002,30.578167800000003,4.188842600000001,30.0110052,34.664242600000001,4.6532374000000019,25.191048600000002,27.8414468,2.6503981999999979,0.20511097074273166]
[5,"Eastern Grampian and Tayside",27.341760000000001,28.25168,0.90991999999999962,30.446901,31.390261399999996,0.94336039999999599,20.644432000000002,21.153550199999998,0.50911819999999608,0.20511097074273166]
[6,"Central Grampian",29.0494132,29.524998,0.47558480000000003,32.378388199999996,32.882557200000001,0.50416900000000453,22.172201600000001,22.629943600000001,0.45774199999999965,0.20511097074273166]
[7,"Argyll",34.242806400000006,33.357378600000004,-0.88542780000000221,39.466307999999998,38.486507200000005,-0.97980079999999248,30.837804999999999,30.695562599999999,-0.14224240000000066,0.20511097074273166]
[8,"The Trossachs",25.013958199999998,25.560911599999997,0.54695339999999959,27.89218,28.455246200000001,0.56306620000000152,19.111405999999999,19.521592599999998,0.4101865999999994,0.20511097074273166]
[9,"Stirlingshire and Fife",21.593847199999999,22.253399600000002,0.65955240000000259,24.221320800000001,24.8963538,0.67503299999999911,17.238955400000002,17.673839399999999,0.43488399999999672,0.20511097074273166]
[10,"South West Scotlands",22.408011600000002,23.057530799999999,0.64951919999999674,25.0838128,25.756044199999998,0.67223139999999759,17.612373399999999,18.095674599999999,0.48330119999999965,0.20511097074273166]
[11,"Lothian and Borders",16.877376400000003,17.574345999999998,0.69696959999999564,18.195473799999998,18.9103952,0.71492140000000148,10.8238544,11.2833536,0.45949919999999977,0.20511097074273166]
[12,"Solway and Cheviot",13.963421800000003,14.7925994,0.82917759999999774,15.4439948,16.289523399999997,0.84552859999999619,10.0955324,10.5783092,0.48277679999999989,0.20511097074273166]
[13,"North East England",11.478353999999998,11.8530096,0.37465560000000231,12.388322599999999,12.757061800000001,0.36873920000000204,6.546960799999999,6.9087014,0.36174060000000097,0.20511097074273166]
[14,"North Lancashire and The Lakes",7.6850031999999997,8.3801898000000001,0.69518660000000043,7.9282405999999988,8.6367328000000008,0.70849220000000201,3.2133048,3.6711554000000004,0.45785060000000044,0.20511097074273166]
[15,"South Lancashire, Yorkshire and Humber",5.5759473999999996,6.1152236000000002,0.53927620000000065,5.6463577999999996,6.1866355999999998,0.54027780000000014,0.87337739999999997,1.3130847999999999,0.43970739999999997,0.20511097074273166]
[16,"North Midlands and North Wales",3.3680124,3.9323578000000001,0.56434540000000011,3.3680124,3.9323578000000001,0.56434540000000011,-0.12477980000000001,0.32721440000000002,0.45199420000000001,0.20511097074273166]
[17,"South Lincolnshire and North Norfolk",2.0000659999999999,2.5905998000000001,0.59053380000000022,2.0000659999999999,2.5905998000000001,0.59053380000000022,-2.1508999999999973E-2,0.60877840000000005,0.63028740000000005,0.20511097074273166]
[18,"Mid Wales and The Midlands",1.7236216,3.1076570000000001,1.3840354000000001,1.7236216,3.1076570000000001,1.3840354000000001,0.10847179999999998,0.70637000000000005,0.59789820000000005,0.20511097074273166]
[19,"Anglesey and Snowdon",5.3229255999999996,5.7140170000000001,0.39109140000000053,5.3229255999999996,5.7140170000000001,0.39109140000000053,-0.26008019999999998,0.38581799999999999,0.64589819999999998,0.20511097074273166]
[20,"Pembrokeshire",5.3147577999999989,2.4310742000000003,-2.8836835999999986,5.3147577999999989,2.4310742000000003,-2.8836835999999986,-2.1958405999999999,-2.6139443999999998,-0.41810379999999991,0.20511097074273166]
[21,"South Wales & Gloucester",1.7991537999999996,-1.9754690000000006,-3.7746228000000004,1.7991537999999996,-1.9754690000000006,-3.7746228000000004,-2.2420966,-2.7515580000000002,-0.50946140000000018,0.20511097074273166]
[22,"Cotswold",-1.6643160000000008,-1.7482396000000009,-8.3923600000000098E-2,-3.4407926000000013,-3.4833883999999999,-4.2595799999998629E-2,-7.5868948000000014,-7.2603931999999993,0.32650160000000206,0.20511097074273166]
[23,"Central London",-6.1607948000000006,-5.4428473999999998,0.71794740000000079,-7.3475046000000006,-6.5739153999999997,0.77358920000000087,-4.6380608000000008,-4.2399892000000001,0.39807160000000064,0.20511097074273166]
[24,"Essex and Kent",-1.2788496,-0.56067939999999983,0.7181702000000002,-1.2788496,-0.56067939999999983,0.7181702000000002,1.2954882000000001,1.4153507999999999,0.11986259999999982,0.20511097074273166]
[25,"Oxfordshire, Surrey and Sussex",-3.0834286,-2.5784567999999997,0.5049718000000003,-3.0834286,-2.5784567999999997,0.5049718000000003,-1.0957897999999999,-0.7975044,0.29828539999999992,0.20511097074273166]
[26,"Somerset and Wessex",-4.6851982000000003,-5.0497851999999996,-0.36458699999999933,-4.6851982000000003,-5.0497851999999996,-0.36458699999999933,-1.4933966000000001,-1.3860816,0.10731500000000005,0.20511097074273166]
[27,"West Devon and Cornwall",-5.2217578000000007,-9.4404211999999994,-4.2186633999999987,-5.2217578000000007,-9.4404211999999994,-4.2186633999999987,-2.5463274,-3.4387095999999997,-0.89238219999999968,0.20511097074273166]
[]
["Figure 4 - Variation in Generation Zonal Tariffs"]

{"sheet":"T4","index":5,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
["Table 4 - Local Substation Tariffs",null,null,null,"Return to Index"]
[]
["2021/22 Local Substation Tariff (£/kW)"]
["Substation\nRating","Connection\nType","132kV","275kV","400kV"]
["<1320 MW","No redundancy",0.167824,7.0749000000000006E-2,5.7144E-2]
["<1320 MW","Redundancy",0.37508999999999998,0.161831,0.13506199999999999]
[">=1320 MW","No redundancy","n/a",0.21971599999999999,0.18095900000000001]
[">=1320 MW","Redundancy","n/a",0.343997,0.29089799999999999]

{"sheet":"T5","index":6,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 5 - Onshore Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Aberarder",1.693169653805372,"Dunhill",1.4653767968361757,"Marchwood",0.39047017018748892]
["Aberdeen Bay",2.667514188754041,"Dunlaw Extension",1.5456437485587193,"Mark Hill",0.89577404656435511]
["Achruach",4.3932088012200206,"Edinbane",7.0025872756573566,"Middle Muir",2.3508443757031237]
["Aigas",0.66912114242164134,"Ewe Hill",2.4900338635214947,"Middleton",0.15550758817981489]
["An Suidhe",-0.98241177338466379,"Fallago",0.44820112324671679,"Millennium South",0.48293871200075744]
["Arecleoch",2.1248758288761804,"Farr",3.6476984014190377,"Millennium Wind ",1.8679425744775546]
["Baglan Bay",-0.14857934309764007,"Fernoch",4.4999878618576394,"Moffat",0.19485162147544041]
["Beinneun Wind Farm",1.5360782207949688,"Ffestiniogg",0.25883744557491051,"Mossford",2.9457413863797024]
["Bhlaraidh Wind Farm",0.66055236122865879,"Finlarig",0.32758946177681214,"Nant",-1.2562414950741561]
["Black Hill",1.5888334500494747,"Foyers",0.29967713557789416,"Necton",1.1496085921047805]
["Black Law",1.7877024914106017,"Galawhistle",3.5798568124663253,"New Deer",0.19469191433004698]
["BlackCraig Wind Farm",6.4403425323650465,"Glen Kyllachy",-0.46798494539544555,"Rhigos",0.10551020606666855]
["BlackLaw Extension",3.7910545349032119,"Glendoe",1.8818705141136089,"Rocksavage",1.8108394718886943E-2]
["Clyde (North)",0.11219796138785909,"Glenglass",4.9225791921820337,"Saltend",1.7751259967937718E-2]
["Clyde (South)",0.12975151341144373,"Gordonbush",7.1177421474538469E-2,"Sandy Knowe",2.3865712083108783]
["Corriegarth",2.9639046541711576,"Griffin Wind",9.9360062156427507,"South Humber Bank",-0.18968623582692726]
["Corriemoillie",1.7021351968266591,"Hadyard Hill",2.8317753844557827,"Spalding",0.28994598366854962]
["Coryton",5.1761516548738437E-2,"Harestanes",2.5862546924461678,"Strathbrora",-4.9415447803319912E-2]
["Cruachan",1.8667541455420515,"Hartlepool",9.1178641690473822E-2,"Strathy Wind",1.7843210041178024]
["Crystal Rig",0.14132693685922057,"Invergarry",0.37438795631635585,"Stronelairg",1.0932636293664648]
["Culligran",1.7731867229120335,"Kilgallioch",1.0767385004157404,"Wester Dod",0.48945588399324469]
["Deanie",2.9130924733554826,"Kilmorack",0.20205083108020833,"Whitelee",0.10857867231083144]
["Dersalloch",2.4644044829012559,"Kype Muir",1.517485154173946,"Whitelee Extension",0.30184870902411054]
["Dinorwig",2.4546557791777173,"Langage",-0.34494760668632929]
["Dorenell",2.1470722297964127,"Lochay",0.37438795631635652]
["Dumnaglass",1.1595629227847342,"Luichart",0.58672729506549415]

{"sheet":"T6","index":7,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 6 - CMP203: Circuits subject to one-off charges",null,null,null,"Return to Index"]
[]
["Node 1","Node 2","Actual Parameters","Amendment in Transport Model","Generator"]
["Dyce 132kV","Aberdeen Bay 132kV","9.5km of Cable","9.5km of OHL","Aberdeen Bay"]
["Crystal Rig 132kV","Wester Dod 132kV","3.9km of Cable","3.9km of OHL","Aikengall II"]
["Wishaw 132kV","Blacklaw 132kV","11.46km of Cable","11.46km of OHL","Blacklaw"]
["Farigaig 132kV","Corriegarth 132kV","4km Cable","4km OHL","Corriegarth"]
["Elvanfoot 275kV","Clyde North 275kV","6.2km of Cable","6.2km of OHL","Clyde North"]
["Elvanfoot 275kV","Clyde South 275kV","7.17km of Cable","7.17km of OHL","Clyde South"]
["Farigaig 132kV","Dunmaglass 132kV","4km Cable","4km OHL","Dunmaglass"]
["Coalburn 132kV","Galawhistle 132kV","9.7km cable","9.7km OHL","Galawhistle II"]
["Moffat 132kV","Harestanes 132kV","15.33km cable","15.33km OHL","Harestanes"]
["Coalburn 132kV","Kype Muir 132kV","17km cable","17km OHL","Kype Muir"]
["Coalburn 132kV","Middle Muir 132kV","13km cable","13km OHL","Middle Muir"]
["Melgarve 132kV","Stronelairg 132kV","10km cable","10km OHL","Stronelairg"]
["East Kilbride South 275kV","Whitelee 275kV","6km of Cable","6km of OHL","Whitelee"]
["East Kilbride South 275kV","Whitelee Extension 275kV","16.68km of Cable","16.68km of OHL","Whitelee Extension"]
["Sandy Knowe 132kV","Glen Glass 132kV","7km of cable","7km of OHL","Sandy Knowe "]

{"sheet":"T7","index":8,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3]]}
["Table 7 - Offshore Local Tariffs",null,null,"Return to Index"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",8.8473430000000004,46.675227,1.1590097556272403]
["Burbo Bank",11.057328,21.346582000000001,0]
["Dudgeon",16.213542,25.417361,0]
["Galloper",16.549489999999999,26.155193000000001,0]
["Greater Gabbard",16.455306,38.045116,0]
["Gunfleet",19.239007999999998,17.730506999999999,3.313933]
["Gwynt Y Mor",17.844372,17.71059,0]
["Humber Gateway",12.188326999999999,27.939146999999998,0]
["Lincs",16.957830000000001,66.640797000000006,0]
["London Array",11.475403,39.308601000000003,0]
["Ormonde",27.175447999999999,50.773899999999998,0.40462500000000001]
["Race Bank",9.7948330000000006,27.170573000000001,0]
["Robin Rigg",-0.58394430829689448,33.842703999999998,10.842987000000001]
["Robin Rigg West",-0.58394430829689448,33.842703999999998,10.842987000000001]
["Sheringham Shoal",25.429358000000001,29.93507,0.6507004236166013]
["Thanet",19.382584000000001,36.292361999999997,0.87368500476380317]
["Walney 1",23.476054000000001,46.909953000000002,0]
["Walney 2",21.842513,44.426566000000001,0]
["Walney 3",10.061698,20.359385,0]
["Walney 4",10.061698,20.359385,0]
["West of Duddon Sands",8.8964789999999994,44.318264999999997,0]
["Westermost Rough",18.286210000000001,31.099817999999999,0]

{"sheet":"T8","index":9,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table 8 - Summary of Demand Tariffs",null,null,null,"Return to Index"]
[]
[null,"HH Tariffs",{"$f":"'T1'!B3","v":"2021/22 August"},{"$f":"'T1'!C3","v":"2021/22 Draft"},"Change"]
[null,"Average Tariff (£/kW)",44.812728374050913,52.460811999999997,7.6480836259490843]
[null,"Residual (£/kW)",46.554084744110241,54.342511999999999,7.7884272558897578]
[null,"EET",{"$f":"C3","v":"2021/22 August"},{"$f":"D3","v":"2021/22 Draft"},"Change"]
[null,"Average Tariff (£/kW)",1.8591220043783883,2.272481,0.41335899562161171]
[null,"Phased residual (£/kW)",0,0,0]
[null,"AGIC (£/kW)",2.2878799999999999,2.2829519999999999,-4.9280000000000435E-3]
[null,"Embedded Export Volume (GW)",7.3129198243131484,6.6588893777316276,-0.65403044658152076]
[null,"Total Credit (£m)",13.595610161635511,15.132202369376667,1.5365922077411565]
[null,"NHH Tariffs",{"$f":"C6","v":"2021/22 August"},{"$f":"D6","v":"2021/22 Draft"},"Change"]
[null,"Average (p/kWh)",5.69019389256436,6.5636200000000002,0.8734261074356402]

{"sheet":"T9","index":10,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Table 9 - Demand Tariffs",null,null,null,"Return to Index"]
[]
["Zone","Zone Name","HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",20.631768999999998,2.7313830000000001,0]
[2,"Southern Scotland",29.787897999999998,3.7746430000000002,0]
[3,"Northern",42.247971,5.1687700000000003,0]
[4,"North West",49.012126000000002,6.1357679999999997,0]
[5,"Yorkshire",49.688949000000001,6.0356170000000002,0]
[6,"N Wales & Mersey",50.465170999999998,6.1227749999999999,0]
[7,"East Midlands",53.518073000000001,6.7118760000000002,1.4585129999999999]
[8,"Midlands",55.089779,7.0221239999999998,3.0302190000000002]
[9,"Eastern",55.422176999999998,7.388941,3.3626170000000002]
[10,"South Wales",57.425897999999997,6.5705239999999998,5.3663379999999998]
[11,"South East",57.975130999999998,7.8610290000000003,5.9155709999999999]
[12,"London",60.452238000000001,6.3408610000000003,8.3926780000000001]
[13,"Southern",60.122729999999997,7.6530659999999999,8.0631699999999995]
[14,"South Western",63.007528999999998,8.5962169999999993,10.947969000000001]
[]
["Residual charge for demand:",null,54.342511999999999]

{"sheet":"T10 & Fig 2","index":11,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 10 - Change in HH Demand Tariffs",null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name",{"$f":"CONCATENATE('T1'!B3, \" (£/kW)\")","v":"2021/22 August (£/kW)"},{"$f":"CONCATENATE('T1'!C3, \" (£/kW)\")","v":"2021/22 Draft (£/kW)"},"Change (£/kW)","Change in Residual (£/kW)",null,"Zone","Peak (£/kW)","Year Round (£/kW)","Residual £/kW","2021/22 March (£/kW)"]
[1,"Northern Scotland",15.045719,20.631768999999998,{"$f":"D4-C4","v":5.5860499999999984},7.7884275382548864,null,1,-2.0657647365347418,-31.644978263027937,54.342512282365128,{"$f":"ROUND(SUM(I4+J4+K4),6)","v":20.631768999999998}]
[2,"Southern Scotland",22.489331,29.787897999999998,{"$f":"D5-C5","v":7.2985669999999985},7.7884275382548864,null,2,-2.6806339784977111,-21.873980553217855,54.342512282365128,{"$f":"ROUND(SUM(I5+J5+K5),6)","v":29.787897999999998}]
[3,"Northern",35.064718999999997,42.247971,7.1832520000000031,7.7884275382548864,null,3,-3.2928516445446991,-8.8016899385291101,54.342512282365128,42.247971]
[4,"North West",41.194336,49.012126000000002,7.8177900000000022,7.7884275382548864,null,4,-2.3078450023227912,-3.0225409062198052,54.342512282365128,49.012126000000002]
[5,"Yorkshire",42.524945000000002,49.688949000000001,7.1640039999999985,7.7884275382548864,null,5,-2.5103501665641534,-2.1432132481838897,54.342512282365128,49.688949000000001]
[6,"N Wales & Mersey",43.295059000000002,50.465170999999998,7.170111999999996,7.7884275382548864,null,6,-2.3958440762689404,-1.4814974066934641,54.342512282365128,50.465170999999998]
[7,"East Midlands",46.211767000000002,53.518073000000001,7.3063059999999993,7.7884275382548864,null,7,-2.374726889191928,1.5502879018807589,54.342512282365128,53.518073000000001]
[8,"Midlands",47.467277000000003,55.089779,7.6225019999999972,7.7884275382548864,null,8,-1.9263708895977221,2.6736376405607198,54.342512282365128,55.089779]
[9,"Eastern",47.997633,55.422176999999998,7.4245439999999974,7.7884275382548864,null,9,1.3124616532073838,-0.23279674485518523,54.342512282365128,55.422176999999998]
[10,"South Wales",45.274603999999997,57.425897999999997,12.151294,7.7884275382548864,null,10,-3.9437700647471785,7.0271558705925026,54.342512282365128,57.425897999999997]
[11,"South East",51.174255000000002,57.975130999999998,6.8008759999999953,7.7884275382548864,null,11,3.7078074264388738,-7.518858219913567E-2,54.342512282365128,57.975130999999998]
[12,"London",53.255445999999999,60.452238000000001,7.1967920000000021,7.7884275382548864,null,12,5.1315436604641258,0.97818225165751371,54.342512282365128,60.452238000000001]
[13,"Southern",52.631157000000002,60.122729999999997,7.4915729999999954,7.7884275382548864,null,13,1.9857219620884903,3.7944957857401769,54.342512282365128,60.122729999999997]
[14,"South Western",51.929374000000003,63.007528999999998,11.078154999999995,7.7884275382548864,null,14,1.4864577095510296,7.178559369330312,54.342512282365128,63.007528999999998]

{"sheet":"T11 & Fig 3","index":12,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 11 - Embedded Export Tariff",null,null,null,"Return to Index"]
[]
[]
["Zone","Zone Name",{"$f":"'T10 & Fig 2'!C3","v":"2021/22 August (£/kW)"},{"$f":"'T10 & Fig 2'!D3","v":"2021/22 Draft (£/kW)"},"Change (£/kW)",null,"Zone","EET Locational £/kW","AGIC £/kW","2021/22 March Tariff £/kW","EET Revenue £m"]
[1,"Northern Scotland",0,0,{"$f":"D5-C5","v":0},null,1,-33.710742999562676,2.2829519999999999,0,0]
[2,"Southern Scotland",0,0,{"$f":"D6-C6","v":0},null,2,-24.554614531715565,2.2829519999999999,0,0]
[3,"Northern",0,0,0,null,3,-12.094541583073809,2.2829519999999999,0,0]
[4,"North West",0,0,0,null,4,-5.3303859085425964,2.2829519999999999,0,0]
[5,"Yorkshire",0,0,0,null,5,-4.6535634147480431,2.2829519999999999,0,0]
[6,"N Wales & Mersey",0,0,0,null,6,-3.8773414829624047,2.2829519999999999,0,0]
[7,"East Midlands",1.9455629999999999,1.4585129999999999,-0.48704999999999998,null,7,-0.82443898731116905,2.2829519999999999,1.4585129999999999,0.73509919051979444]
[8,"Midlands",3.2010719999999999,3.0302190000000002,-0.1708529999999997,null,8,0.74726675096299777,2.2829519999999999,3.0302190000000002,0.7924810888424465]
[9,"Eastern",3.7314280000000002,3.3626170000000002,-0.368811,null,9,1.0796649083521985,2.2829519999999999,3.3626170000000002,2.5964661966005944]
[10,"South Wales",1.0084,5.3663379999999998,4.3579379999999999,null,10,3.0833858058453241,2.2829519999999999,5.3663379999999998,1.9627091911922303]
[11,"South East",6.9080510000000004,5.9155709999999999,-0.99248000000000047,null,11,3.632618844239738,2.2829519999999999,5.9155709999999999,1.93072309774785]
[12,"London",8.9892420000000008,8.3926780000000001,-0.59656400000000076,null,12,6.1097259121216396,2.2829519999999999,8.3926780000000001,1.0896722921915925]
[13,"Southern",8.3649520000000006,8.0631699999999995,-0.3017820000000011,null,13,5.7802177478286669,2.2829519999999999,8.0631699999999995,3.3269781412896977]
[14,"South Western",7.66317,10.947969000000001,3.2847990000000005,null,14,8.6650170788813412,2.2829519999999999,10.947969000000001,2.6980731709924628]

{"sheet":"T12 & Fig 4","index":13,"n_rows":27,"n_cols":18,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Table 12 - NHH Demand Tariff Changes",null,null,"Return to Index"]
[]
["Zone","Zone Name",{"$f":"CONCATENATE('T1'!B3,\" (p/kWh)\")","v":"2021/22 August (p/kWh)"},{"$f":"CONCATENATE('T1'!C3,\" (p/kWh)\")","v":"2021/22 Draft (p/kWh)"},"Change (p/kWh)"]
[1,"Northern Scotland",2.0458539999999998,2.7313830000000001,{"$f":"D4-C4","v":0.68552900000000028}]
[2,"Southern Scotland",2.913497,3.7746430000000002,{"$f":"D5-C5","v":0.86114600000000019}]
[3,"Northern",4.3571299999999997,5.1687700000000003,0.81164000000000058]
[4,"North West",5.2078119999999997,6.1357679999999997,0.927956]
[5,"Yorkshire",5.2574209999999999,6.0356170000000002,0.77819600000000033]
[6,"N Wales & Mersey",5.3931789999999999,6.1227749999999999,0.72959599999999991]
[7,"East Midlands",5.897278,6.7118760000000002,0.81459800000000016]
[8,"Midlands",6.1318260000000002,7.0221239999999998,0.89029799999999959]
[9,"Eastern",6.5768019999999998,7.388941,0.81213900000000017]
[10,"South Wales",5.2596600000000002,6.5705239999999998,1.3108639999999996,null,null,null,null,null,null,null,null,null,null,null,null," "]
[11,"South East",7.0628780000000004,7.8610290000000003,0.79815099999999983]
[12,"London",5.5808010000000001,6.3408610000000003,0.76006000000000018]
[13,"Southern",6.7952849999999998,7.6530659999999999,0.85778100000000013]
[14,"South Western",7.1570689999999999,8.5962169999999993,1.4391479999999994]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null," - "]

{"sheet":"T13","index":14,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,2,2,5]]}
["Table 13 - Contracted and Modelled TEC",null,null,null,"Return to Index"]
[]
[null,"2020/21","2021/22 Tariffs"]
["Generation (GW)","Final","March","August","Draft ","Final"]
["Contracted TEC",84.9,93.6,92.7,89.9]
["Modelled Best View TEC",84.9,85.8,86.7,89.9]
["Chargeable TEC",70.7,76.8,76.900000000000006,71.7]

{"sheet":"T14","index":15,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,3,2,6],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6]]}
["Table 14 - Interconnectors",null,null,null,null,null,"Return to Index"]
[]
[null,null,null,"Generation MW"]
[null,null,null,"Generation\nZone","Transport Model  Peak","Transport Model  Year Round","Charging Base "]
["Interconnector","Site","Interconnected\nSystem"]
[]
["IFA Interconnector","Sellindge 400kV","France",24,0,2000,0]
["ElecLink","Sellindge 400kV","France",24,0,1000,0]
["BritNed","Grain 400kV","Netherlands",24,0,1200,0]
["Belgium Interconnector (Nemo)","Richborough 400kV","Belgium",24,0,1020,0]
["East - West","Connah's Quay 400kV","Republic of Ireland",16,0,505,0]
["IFA2 Interconnector","Chilling 400KV Substation","France",26,0,1100,0]
["Moyle","Auchencrosh 275kV","Northern Ireland",10,0,490,0]
["NS Link","Blyth","Norway",13,0,1400,0]

{"sheet":"T15","index":16,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
["Table 15 - Allowed Revenues",null,null,null,null,"Return to Index"]
[]
[null,"2021/22 TNUoS Revenue"]
["£m Nominal",{"$f":"'T25-28'!D5","v":"March Forecast"},{"$f":"'T25-28'!E5","v":"August Forecast"},{"$f":"'T25-28'!F5","v":"Nov Draft"},{"$f":"'T25-28'!G5","v":"Jan Final"}]
[]
["National Grid Electricity Transmission"]
["Price controlled revenue",1754.9134640049667,1753.7233390621977,{"$f":"'T25-28'!F23","v":1949.7227351110225}]
["Less income from connections",null,29.84753465,{"$f":"'T25-28'!F24+'T25-28'!F25","v":29.84753465}]
["NGET Income from TNUoS",1754.9134640049667,{"$f":"+C7-C8","v":1723.8758044121978},{"$f":"+D7-D8","v":1919.8752004610226}]
[]
["Scottish Power Transmission"]
["Price controlled revenue",389.48869265509313,384.2112304741367,{"$f":"'T25-28'!J23","v":410.05459261548589}]
["Less income from connections",12.745666933884667,12.745666933884667,{"$f":"'T25-28'!J24","v":19.457780063908615}]
["SPT Income from TNUoS",376.74302572120848,{"$f":"+C12-C13","v":371.46556354025205},{"$f":"+D12-D13","v":390.59681255157727}]
[]
["SHE Transmission"]
["Price controlled revenue",377.47614223401962,383.40223917239717,{"$f":"'T25-28'!N23","v":542.63908273215304}]
["Less income from connections",3.4418754871116639,3.4418754871116639,{"$f":"'T25-28'!N24","v":2.8999900233106253}]
["SHE Income from TNUoS",374.03426674690797,{"$f":"+C17-C18","v":379.96036368528553},{"$f":"+D17-D18","v":539.73909270884246}]
[]
["National Grid Electricity System Operator"]
["Other Pass-through from TNUoS",17.441133194505497,17.473101019314885,{"$f":"'T25-28'!U7+'T25-28'!U6","v":14.433283890494506}]
[]
["Offshore (plus interconnector contribution / allowance)",529.94027182490379,555.80507139240376,{"$f":"'T25-28'!U9","v":545.59171900067929}]
["Total to Collect from TNUoS",3053.0721614924923,{"$f":"+C24+C23+C22+C19+C14+C9","v":3048.5799040494539},{"$f":"+D24+D23+D22+D19+D14+D9","v":3410.2361086126166}]

{"sheet":"T16","index":17,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,3,2,6]]}
[null,"Table 16 - Generation and Demand Revenue Proportions",null,null,null,null,"Return to Index"]
[]
[null,null,null,"2021/22 Tariffs"]
[null,"Code","Revenue","March","August","Draft ","Final"]
[]
[null,"CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5]
[null,"y","Error Margin",0.15999999999999998,0.20800000000000002,{"$f":"E7","v":0.20800000000000002}]
[null,"ER","Exchange Rate (€/£)",1.1192171907836179,1.2107929999999998,{"$f":"E8","v":1.2107929999999998}]
[null,"MAR","Total Revenue (£m)",3053.1152059617539,3048.5823336778867,{"$f":"'T15'!D25","v":3410.2361086126166}]
[null,"GO","Generation Output (TWh)",199.82092902362245,222.84495349094996,222.84495349094996]
[null,null,"Wider locational generator Revenue (£m)",403.01739883285131,382.3251689772141,{"$f":"'T18'!F10","v":366.39795101656648}]
[null,null,"Charges on assets required for connection (£m)",445.6314611042506,461.98822224179389,{"$f":"'T18'!F11+'T18'!F12+'T18'!F13","v":449.29103683121326}]
[null,"G","% of revenue from generation",0.26876082212814728,0.27107838393769779,{"$f":"(MIN(F10*F6*(1-F7)/F8,F11)+F12)/F9","v":0.23860740458668003}]
[null,"D","% of revenue from demand",0.73123917787185277,{"$f":"1-E13","v":0.72892161606230221},{"$f":"1-F13","v":0.76139259541331994}]
[null,"G.R","Revenue recovered from generation (£m)",820.55775280622868,826.40477231441696,813.70758690383582]
[null,"D.R","Revenue recovered from demand (£m)",2232.5574531555253,{"$f":"E9-E15","v":2222.17756136347},{"$f":"F9-F15","v":2596.5285217087808}]

{"sheet":"T17","index":18,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
["Table 17 - Charging Bases",null,null,null,"Return to Index"]
[]
[null,"2021/22 Tariffs"]
["Charging Bases",{"$f":"'T13'!C4","v":"March"},{"$f":"'T13'!D4","v":"August"},{"$f":"'T13'!E4","v":"Draft "},{"$f":"'T13'!F4","v":"Final"}]
["Generation (GW)",70.7,76.900000000000006,71.7]
["NHH Demand (4pm-7pm TWh)",23.970719930411136,24.433532834278441,24.640713460650868]
["Net Charging"]
["Total Average Net Triad (GW)",43.207937356017204,42.842614115730115,43.32294130836668]
["HH  Demand Average Net Triad (GW)",12.610989142038234,11.553545332511668,12.295052366392193]
["Gross charging"]
["Total Average Gross Triad (GW)",50.027892072668919,50.155533940043263,49.981830686098306]
["HH Demand Average Gross Triad (GW)",19.43094385868995,18.866465156824816,18.953941744123821]
["Embedded Generation Export (GW)",6.8199547166517167,7.3129198243131484,6.6588893777316276]

{"sheet":"T18","index":19,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,5],[2,3,2,6],[3,1,3,2]]}
[null,"Table 18 - Residual Calculation",null,null,null,null,"Return to Index"]
[]
[null,null,null,"2021/22 Tariffs"]
[null,"Component",null,{"$f":"'T13'!C4","v":"March"},{"$f":"'T13'!D4","v":"August"},{"$f":"'T13'!E4","v":"Draft "},{"$f":"'T13'!F4","v":"Final"}]
[null,"G","Proportion of revenue recovered from generation (%)",0.26876082212814728,0.11953639763863005,{"$f":"'T16'!F13","v":0.23860740458668003}]
[null,"D","Proportion of revenue recovered from demand (%)",0.73123917787185277,{"$f":"1-E5","v":0.88046360236136989},{"$f":"'T16'!F14","v":0.76139259541331994}]
[null,"R","Total TNUoS revenue (£m)",3053.1152059617539,3048.5823336778867,3410.2372988772581]
[null,"Generation Residual"]
[null,"RG","Generator residual tariff (£/kW)",-0.36597057434887625,-0.23275133955530214,-2.7640368812570482E-2]
[null,"ZG","Revenue recovered from the wider locational element of generator tariffs (£m)",403.01739883285131,382.3251689772141,366.39795101656648]
[null,"O","Revenue recovered from offshore local tariffs (£m)",408.19967968236205,426.88210397610123,422.69404406302874]
[null,"LG","Revenue recovered from onshore local substation tariffs (£m)",19.52551825163,19.551591817039998,11.44562985228]
[null,"SG","Revenue recovered from onshore local circuit tariffs (£m)",17.906263170258569,15.554526448652663,15.151362915904533]
[null,"BG","Generator charging base (GW)",76.757830000000013,76.943140000000028,71.685040000000015]
[null,"Gross Demand Residual"]
[null,"RD","Demand residual tariff (£/kW)",46.816636174874496,46.554084744110241,54.342512282365121]
[null,"ZD","Revenue recovered from the locational element of demand tariffs (£m)",-92.417159380832118,-99.171805905765709,-104.47633361159272]
[null,"EE","Amount to be paid to Embedded Export Tariffs (£m)",17.16300922567136,13.595610161635511,15.132202369376667]
[null,"BD","Demand Gross charging base (GW)",50.027892072668919,50.155533940043263,49.981830686098313]

{"sheet":"S1 - S2","index":20,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[3,1,3,2],[17,1,18,1],[17,2,17,4],[17,5,17,7]]}
["Table S1 & S2 – The effect of including CMP344",null,null,null,null,null,null,null,null,"Return to Index"]
[]
[]
[null,null,null,"2021/22 \nBase Case","2021/22 CMP344 Sensitivity","Change"]
[null,"OFTO Local Revenue (£m)",null,422.69404406302874,422.26391194302886,{"$f":"E5-D5","v":-0.43013211999988243}]
[null,"Revenue from Generation (£m)",null,813.70758690383582,813.27745478383576,{"$f":"E6-D6","v":-0.43013212000005296}]
[null,"Revenue from Demand (£m)",null,2596.9598440934224,2599.7708440934225,{"$f":"E7-D7","v":2.8110000000001492}]
[null,"Generation Residual","£/kW ",-2.7640368812570482E-2,-2.7640368812572858E-2,{"$f":"E8-D8","v":-2.3765711620882257E-15}]
[null,"Average Generation Tariff*","£/kW ",11.351149234259138,11.345148929035062,{"$f":"E9-D9","v":-6.000305224075575E-3}]
[null,"Average HH demand tariff","£/kW ",52.460811999999997,52.525658249974953,6.4846249974955583E-2]
[null,"Demand Residual","£/kW ",54.342511999999999,54.407358488986802,6.4846488986802342E-2]
[null,"Average NHH demand tariff","p/kWh ",6.5636200000000002,6.5717852792978482,8.1652792978479383E-3]
[null,"Average EET tariff","£/kW ",2.272481,2.2724814170935366,4.1709353659769022E-7]
[null,"*N.B These generation tariffs include local tariffs"]
[]
[]
[]
[null,"Offshore Generator","Tariff Component (£/kW)",null,null,"Change from base case (£/kW)"]
[null,null,"Substation","Circuit","ETUoS","Substation","Circuit","ETUoS"]
[null,"Barrow",8.8473430000000004,46.675227,1.1590097556272403,0,0,0]
[null,"Burbo Bank",11.057328,21.346582000000001,0,0,0,0]
[null,"Dudgeon",16.213542,25.417361,0,0,0,0]
[null,"Galloper",16.549489999999999,26.155193000000001,0,0,0,0]
[null,"Greater Gabbard",16.455306,38.045116,0,0,0,0]
[null,"Gunfleet",19.239007999999998,17.730506999999999,3.313933,0,0,0]
[null,"Gwynt Y Mor",17.844372,17.71059,0,-0.19088199999999844,-0.1834479999999985,0]
[null,"Humber Gateway",12.188326999999999,27.939146999999998,0,-0.30697699999999983,-0.67150799999999933,0]
[null,"Lincs",16.957830000000001,66.640797000000006,0,0,0,0]
[null,"London Array",11.475403,39.308601000000003,0,0,0,0]
[null,"Ormonde",27.175447999999999,50.773899999999998,0.40462500000000001,0,0,0]
[null,"Race Bank",9.7948330000000006,27.170573000000001,0,0,0,0]
[null,"Robin Rigg",-0.58394430829689448,33.842703999999998,10.842987000000001,0,0,0]
[null,"Robin Rigg West",-0.58394430829689448,33.842703999999998,10.842987000000001,0,0,0]
[null,"Sheringham Shoal",25.429358000000001,29.93507,0.6507004236166013,0,0,0]
[null,"Thanet",19.382584000000001,36.292361999999997,0.87368500476380317,0,0,0]
[null,"Walney 1",23.476054000000001,46.909953000000002,0,0,0,0]
[null,"Walney 2",21.842513,44.426566000000001,0,0,0,0]
[null,"Walney 3",10.061698,20.359385,0,0,0,0]
[null,"Walney 4",10.061698,20.359385,0,0,0,0]
[null,"West of Duddon Sands",8.8964789999999994,44.318264999999997,0,0,0,0]
[null,"Westermost Rough",18.286210000000001,31.099817999999999,0,0,0,0]

{"sheet":"S3","index":21,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4],[3,1,3,2]]}
["Table S3 – The effect of including congestion management",null,null,null,null,"Return to Index"]
[]
[]
[null,null,null,"2021/22 \nBase Case","2021/22 Congestion Management Sensitivity","Change"]
[null,"Generation Residual","£/kW ",{"$f":"'T1'!C4","v":-2.7640368812570482E-2},-7.6665830031823043,{"$f":"E5-D5","v":-7.6389426343697338}]
[null,"Average Generation Tariff*","£/kW ",{"$f":"'T1'!C5","v":11.351149234259138},3.712206599889404,{"$f":"E6-D6","v":-7.6389426343697338}]
[null,"Average HH demand tariff","£/kW ",{"$f":"'T8'!D4","v":52.460811999999997},63.416751447445684,10.955939447445687]
[null,"Demand Residual","£/kW ",{"$f":"'T8'!D5","v":54.342511999999999},65.29845168645754,10.95593968645754]
[null,"Average NHH demand tariff","p/kWh ",{"$f":"'T8'!D13","v":6.5636200000000002},7.9432051074106091,1.3795851074106089]
[null,"Average EET tariff","£/kW ",{"$f":"'T8'!D7","v":2.272481},2.2724814170935366,4.1709353659769022E-7]
[null,"Revenue from Generation","£m ",813.70758690383582,266.10967860133599,-547.59790830249983]
[null,"Revenue from Demand ","£m ",2596.5297119734223,3144.1276202759223,547.59790830249995]
[null,"*N.B These generation tariffs include local tariffs"]

{"sheet":"S4","index":22,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[7,1,7,8],[11,1,11,8],[12,1,12,8],[14,1,14,8],[16,1,16,8],[13,1,13,8],[15,1,15,8]]}
["Table S4 - Generation revenue breakdown and adjustment tariff under GOS sensitivity",null,null,null,null,null,null,null,"Return to Index"]
[]
[]
[]
[]
[null,"NGET Base Revenue (£m)","Other NGET revenue items (£m)*","SPT Base Revenue (£m)","Other SPT revenue items (£m)*","SHETL Base Revenue (£m)","Other SHETL revenue items (£m)*","Other ESO revenue items (£m)**","Total (£m)"]
["Base case (£m)",1961.8054233853557,-41.930222924333066,378.16477893548591,12.432033616091381,541.73908273215307,-1.9999900233106254,560.02500289117381,{"$f":"SUM(B7:H7)","v":3410.2361086126161}]
["Assumption on financial parameters***","ESO assumes that onshore TOs based their revenue forecast on the same annuity and overhead factors as in RIIO-T1 (5.81%+ 1.8%). The sensitivity analysis uses an alternative annuity factor (4.79%) which is in line with CMA's decision on water utilities price control, and same overhead factor (1.8%) as in RIIO-T1"]
["Revenue Sensitivity (£m)",{"$f":"B7*(4.79+1.8)/(5.81+1.8)","v":1698.8564704480282},{"$f":"C7","v":-41.930222924333066},{"$f":"D7*(4.79+1.8)/(5.81+1.8)","v":327.47777834229333},{"$f":"E7","v":12.432033616091381},{"$f":"F7*(4.79+1.8)/(5.81+1.8)","v":469.12753682061617},{"$f":"G7","v":-1.9999900233106254},{"$f":"H7","v":560.02500289117381},{"$f":"SUM(B9:H9)","v":3023.9886091705589}]
["Variation (£m)",{"$f":"B9-B7","v":-262.94895293732748},0,-50.687000593192579,0,-72.611545911536894,0,0,-386.24749944205723]
[]
["Note","* Onshore TOs' other revenue items include pass-through (business rate, licence fee etc), output incentives and other miscellaneous items, minus pre-vesting charge"]
[null,"** ESO's other revenue items include OFTO revenue, interconnector adjustment, network innovation competition (NIC), and other miscellaneous items"]
[null,"*** The sensitivity analysis is based on the following assumptions -"]
[null,"1. Assuming \"other revenue items\" in onshore TOs' revenue breakdown, remain the same as in the August forecast."]
[null,"2. Assuming generic asset life of 50 years"]
[null,"3. Assuming onshore TOs' base revenue figures reflect regulated asset base only, and is proportional to the total of (annuity factor + overhead factor)."]

{"sheet":"S5","index":23,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Table S5 - Generation revenue breakdown and adjustment tariff under GOS sensitivity",null,null,null,null,null,null,null,"Return to Index"]
[]
[]
[]
[]
[null,"Peak Security (£m)","Year Round Shared (£m)","Year Round Not Shared (£m)","Residual (£m)","Onshore Local Circuit (£m)","Onshore Local Substation (£m)","Offshore Local (£m)","Total (£m)","Generation adjustment factor (residual) (£/kW)"]
["Base case",108.95938740345449,109.17757910615774,148.26098450695423,-1.9814009439438678,15.151362915904533,11.44562985228,422.69404406302874,813.70758690383582,-2.7640368812570482E-2]
["GOS sensitivity",108.95938740345449,109.17757910615774,148.26098450695423,-4.8093967210950836,12.748058080133413,11.0209389109,422.69404406302874,810.87959112668466,{"$f":"E8/(E7/J7)","v":-6.7090661051386488E-2}]
["Variation",0,0,0,-2.8279957771512159,-2.4033048357711202,-0.42469094137999974,0,-2.827995777151159,{"$f":"J8-J7","v":-3.9450292238816007E-2}]

{"sheet":"S6 - S7","index":24,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[21,6,22,8],[21,2,22,5]]}
["Table S6 - Demand tariffs under security factor at 2d.p.",null,null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",21.454042999999999,2.8402419999999999,0]
[2,"Southern Scotland",30.406701999999999,3.853056,0]
[3,"Northern",42.589883999999998,5.2106009999999996,0]
[4,"North West",49.203724999999999,6.1597540000000004,0]
[5,"Yorkshire",49.865507000000001,6.0570630000000003,0]
[6,"N Wales & Mersey",50.624479999999998,6.1421029999999996,0]
[7,"East Midlands",53.609540000000003,6.7233470000000004,1.476834]
[8,"Midlands",55.146318999999998,7.029331,3.0136129999999999]
[9,"Eastern",55.471330000000002,7.3954940000000002,3.3386239999999998]
[10,"South Wales",57.430523999999998,6.571053,5.2978180000000004]
[11,"South East",57.967551999999998,7.8600019999999997,5.8348459999999998]
[12,"London",60.389612,6.3342919999999996,8.2569060000000007]
[13,"Southern",60.067425999999998,7.6460270000000001,7.9347200000000004]
[14,"South Western",62.888119000000003,8.5799260000000004,10.755413000000001]
[]
[]
["Table S7 - Generation tariffs under security factor at 2d.p."]
[]
[null,null,"Tariffs (£/kW)",null,null,null,"Example tariffs for a generator of each technology type"]
[]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name",null,null,null,null,"Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",4.139437,19.913374999999998,18.906466000000002,0,35.195309799999997,38.976602999999997,26.871816000000003]
[2,"East Aberdeenshire",3.1620509999999999,10.510472,18.906466000000002,0,26.695601400000001,30.476894600000001,23.110654800000002]
[3,"Western Highlands",3.8542100000000001,18.183520000000001,18.19577,0,32.957642,36.596795999999998,25.469177999999999]
[4,"Skye and Lochalsh",-0.60223000000000004,18.183520000000001,19.976365999999999,0,29.925678800000004,33.920952,27.249773999999999]
[5,"Eastern Grampian and Tayside",4.6429080000000003,13.415803,15.344175999999999,0,27.650891200000004,30.719726399999999,20.710497199999999]
[6,"Central Grampian",4.2854299999999999,14.348369999999999,16.414733999999999,0,28.895913200000003,32.17886,22.154081999999999]
[7,"Argyll",2.6530870000000002,12.411813,25.07574,0,32.643129399999999,37.658277400000003,30.0404652]
[8,"The Trossachs",3.7704029999999999,12.411813,14.150080000000001,0,25.019917400000004,27.849933400000001,19.114805199999999]
[9,"Stirlingshire and Fife",2.675011,10.967509,12.921110000000001,0,21.785906199999999,24.3701282,17.308113599999999]
[10,"South West Scotlands",2.962297,11.319604999999999,13.192731999999999,0,22.572166599999999,25.210712999999998,17.720573999999999]
[11,"Lothian and Borders",2.9297089999999999,11.319604999999999,6.5317959999999999,0,17.210829799999999,18.517188999999998,11.059638]
[12,"Solway and Cheviot",2.5323319999999998,7.6299159999999997,7.318295,0,14.490900800000002,15.954559799999998,10.3702614]
[13,"North East England",3.356007,5.9059739999999996,4.4198110000000002,0,11.616635,12.500597199999998,6.7822005999999995]
[14,"North Lancashire and The Lakes",2.492842,5.9059739999999996,1.25421,0,8.2209892,8.4718312000000005,3.6165995999999998]
[15,"South Lancashire, Yorkshire and Humber",3.8034439999999998,2.4045139999999998,0.34912599999999999,0,6.0063560000000003,6.0761811999999997,1.3109316]
[16,"North Midlands and North Wales",3.1780599999999999,0.86742200000000003,0,0,3.8719975999999998,3.8719975999999998,0.34696880000000002]
[17,"South Lincolnshire and North Norfolk",1.3155049999999999,1.5556890000000001,0,0,2.5600562,2.5600562,0.62227560000000004]
[18,"Mid Wales and The Midlands",1.630226,1.794246,0,0,3.0656227999999999,3.0656227999999999,0.71769840000000007]
[19,"Anglesey and Snowdon",4.8055240000000001,1.010675,0,0,5.6140639999999999,5.6140639999999999,0.40427000000000002]
[20,"Pembrokeshire",7.4617380000000004,-6.3220780000000003,0,0,2.4040755999999996,2.4040755999999996,-2.5288312000000004]
[21,"South Wales & Gloucester",3.4222290000000002,-6.6584659999999998,0,0,-1.9045438000000003,-1.9045438000000003,-2.6633864000000003]
[22,"Cotswold",2.2821470000000001,3.5273110000000001,-8.4829500000000007,0,-1.6823642000000003,-3.3789542000000008,-7.0720256000000008]
[23,"Central London",-3.6929850000000002,3.5273110000000001,-5.5296659999999997,0,-5.2948690000000003,-6.4008021999999993,-4.1187415999999999]
[24,"Essex and Kent",-3.3430430000000002,3.5273110000000001,0,0,-0.52119420000000005,-0.52119420000000005,1.4109244000000001]
[25,"Oxfordshire, Surrey and Sussex",-0.98862000000000005,-1.881891,0,0,-2.4941328,-2.4941328,-0.75275639999999999]
[26,"Somerset and Wessex",-2.2540339999999999,-3.3206349999999998,0,0,-4.9105419999999995,-4.9105419999999995,-1.328254]
[27,"West Devon and Cornwall",-2.5330720000000002,-8.3381699999999999,0,0,-9.2036080000000009,-9.2036080000000009,-3.3352680000000001]

{"sheet":"S8 - S9","index":25,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[21,6,22,8],[21,2,22,5]]}
["Table S8 - Demand tariffs under security factor at 8d.p.",null,null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",21.551513,2.853145,0]
[2,"Southern Scotland",30.481162999999999,3.862492,0]
[3,"Northern",42.633032999999998,5.2158800000000003,0]
[4,"North West",49.229875,6.1630279999999997,0]
[5,"Yorkshire",49.889955999999998,6.0600329999999998,0]
[6,"N Wales & Mersey",50.646977999999997,6.1448330000000002,0]
[7,"East Midlands",53.624366000000002,6.7252070000000002,1.4789060000000001]
[8,"Midlands",55.157195999999999,7.0307180000000002,3.0117349999999998]
[9,"Eastern",55.481372,7.396833,3.3359109999999998]
[10,"South Wales",57.43553,6.5716260000000002,5.2900700000000001]
[11,"South East",57.971178000000002,7.860493,5.825717]
[12,"London",60.387013000000003,6.3340199999999998,8.2415520000000004]
[13,"Southern",60.065655,7.6458009999999996,7.9201949999999997]
[14,"South Western",62.879097999999999,8.5786949999999997,10.733637999999999]
[]
[]
["Table S9 - Generation tariffs under security factor at 8d.p."]
[]
[null,null,"Tariffs (£/kW)",null,null,null,"Example tariffs for a generator of each technology type"]
[]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name",null,null,null,null,"Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",4.1287979999999997,19.862195,18.857873000000001,0,35.104852399999999,38.876427000000007,26.802751000000001]
[2,"East Aberdeenshire",3.1539239999999999,10.483458000000001,18.857873000000001,0,26.626988800000003,30.3985634,23.051256200000001]
[3,"Western Highlands",3.8443040000000002,18.136786000000001,18.149004000000001,0,32.872936000000003,36.502736800000008,25.403718400000002]
[4,"Skye and Lochalsh",-0.60068200000000005,18.136786000000001,19.925024000000001,0,29.848766000000005,33.833770800000003,27.179738400000002]
[5,"Eastern Grampian and Tayside",4.6309750000000003,13.381323,15.304739,0,27.579824600000002,30.640772400000003,20.657268200000001]
[6,"Central Grampian",4.2744150000000003,14.311493,16.372544999999999,0,28.821645400000005,32.096154400000003,22.0971422]
[7,"Argyll",2.6462690000000002,12.379913,25.011292000000001,0,32.559233000000006,37.561491400000001,29.963257200000001]
[8,"The Trossachs",3.760713,12.379913,14.113713000000001,0,24.955613799999998,27.7783564,19.065678200000001]
[9,"Stirlingshire and Fife",2.6681349999999999,10.939321,12.887900999999999,0,21.729912599999999,24.307492799999999,17.263629399999999]
[10,"South West Scotlands",2.9546839999999999,11.290512,13.158825,0,22.5141536,25.145918600000002,17.675029800000001]
[11,"Lothian and Borders",2.92218,11.290512,6.5150090000000001,0,17.166596800000001,18.469598599999998,11.0312138]
[12,"Solway and Cheviot",2.5258229999999999,7.6103059999999996,7.2994859999999999,0,14.453656599999999,15.913553800000001,10.343608400000001]
[13,"North East England",3.3473820000000001,5.8907949999999998,4.4084510000000003,0,11.586778799999999,12.468468999999999,6.7647690000000003]
[14,"North Lancashire and The Lakes",2.4864350000000002,5.8907949999999998,1.2509859999999999,0,8.1998598000000005,8.4500569999999993,3.6073040000000001]
[15,"South Lancashire, Yorkshire and Humber",3.793669,2.3983340000000002,0.34822799999999998,0,5.9909186000000005,6.0605642,1.3075616000000001]
[16,"North Midlands and North Wales",3.1698919999999999,0.86519299999999999,0,0,3.8620464000000001,3.8620464000000001,0.34607720000000003]
[17,"South Lincolnshire and North Norfolk",1.3121240000000001,1.5516909999999999,0,0,2.5534768000000003,2.5534768000000003,0.62067640000000002]
[18,"Mid Wales and The Midlands",1.626037,1.7896350000000001,0,0,3.0577450000000002,3.0577450000000002,0.7158540000000001]
[19,"Anglesey and Snowdon",4.7931730000000003,1.008078,0,0,5.5996354000000004,5.5996354000000004,0.40323120000000001]
[20,"Pembrokeshire",7.4425600000000003,-6.3058290000000001,0,0,2.3978967999999998,2.3978967999999998,-2.5223316000000002]
[21,"South Wales & Gloucester",3.4134340000000001,-6.6413529999999996,0,0,-1.8996483999999998,-1.8996483999999998,-2.6565411999999999]
[22,"Cotswold",2.2762820000000001,3.5182449999999998,-8.4611479999999997,0,-1.6780403999999995,-3.3702699999999997,-7.0538499999999997]
[23,"Central London",-3.683494,3.5182449999999998,-5.5154540000000001,0,-5.2812612000000003,-6.3843519999999998,-4.1081560000000001]
[24,"Essex and Kent",-3.3344510000000001,3.5182449999999998,0,0,-0.51985500000000018,-0.51985500000000018,1.4072979999999999]
[25,"Oxfordshire, Surrey and Sussex",-0.98607900000000004,-1.877054,0,0,-2.4877222000000003,-2.4877222000000003,-0.75082160000000009]
[26,"Somerset and Wessex",-2.2482410000000002,-3.3121010000000002,0,0,-4.8979218000000007,-4.8979218000000007,-1.3248404000000003]
[27,"West Devon and Cornwall",-2.5265620000000002,-8.3167399999999994,0,0,-9.1799540000000004,-9.1799540000000004,-3.3266960000000001]

{"sheet":"S10","index":26,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table S10 - Summary of Demand Tariffs (Base Case vs RIIO-2 EC&F Update)"]
[]
[null,"HH Tariffs","2021/22 Draft (Base Case)","2021/22 Draft (EC&F RIIO-2 Update)","Change"]
[null,"Average Tariff (£/kW)",52.460811999999997,52.628548000000002,0.16773600000000499]
[null,"Residual (£/kW)",54.342511999999999,55.895626999999998,1.5531149999999982]
[null,"EET","2021/22 Draft (Base Case)","2021/22 Draft (EC&F RIIO-2 Update)","Change"]
[null,"Average Tariff (£/kW)",2.272481,3.215122,0.94264100000000006]
[null,"Phased residual (£/kW)",0,0,0]
[null,"AGIC (£/kW)",2.2829519999999999,2.2829519999999999,0]
[null,"Embedded Export Volume (GW)",6.6588893777316276,6.6588893777316276,0]
[null,"Total Credit (£m)",15.132202369376667,21.409142434116578,6.276940064739911]
[null,"NHH Tariffs","2021/22 Draft (Base Case)","2021/22 Draft (EC&F RIIO-2 Update)","Change"]
[null,"Average (p/kWh)",6.5636200000000002,6.5702100000000003,6.5900000000000958E-3]

{"sheet":"S11 & Fig S1","index":27,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table S11 - Change in HH Demand Tariffs (Base Case vs RIIO-2 EC&F Update)",null,null,null,null,null,null,"Figure S1 - HH Demand Tariffs (Base Case vs RIIO-2 EC&F Update)"]
[]
["Zone","Zone Name","2021/22 Draft (£/kW)","2021/22 Draft (£/kW) (EC&F RIIO-2 Update)","Change (£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",20.631768999999998,0,-20.631768999999998,1.5531149999999982]
[2,"Southern Scotland",29.787897999999998,13.589573,-16.198324999999997,1.5531149999999982]
[3,"Northern",42.247971,35.596862000000002,-6.6511089999999982,1.5531149999999982]
[4,"North West",49.012126000000002,47.339100000000002,-1.6730260000000001,1.5531149999999982]
[5,"Yorkshire",49.688949000000001,48.144849000000001,-1.5441000000000003,1.5531149999999982]
[6,"N Wales & Mersey",50.465170999999998,49.499243,-0.96592799999999812,1.5531149999999982]
[7,"East Midlands",53.518073000000001,54.851802999999997,1.3337299999999956,1.5531149999999982]
[8,"Midlands",55.089779,57.316240000000001,2.2264610000000005,1.5531149999999982]
[9,"Eastern",55.422176999999998,58.915562999999999,3.493386000000001,1.5531149999999982]
[10,"South Wales",57.425897999999997,60.788586000000002,3.3626880000000057,1.5531149999999982]
[11,"South East",57.975130999999998,61.881059,3.905928000000003,1.5531149999999982]
[12,"London",60.452238000000001,64.390360000000001,3.9381219999999999,1.5531149999999982]
[13,"Southern",60.122729999999997,65.280455000000003,5.1577250000000063,1.5531149999999982,null,"Table 14"]
[14,"South Western",63.007528999999998,70.592400999999995,7.5848719999999972,1.5531149999999982]
[]
[]
["Zone","Peak (£/kW)","Year Round (£/kW)","Residual £/kW","Small Gen Discount (£/kW)","2021/22 Draft (£/kW)"]
[1,-2.1186920556287601,-55.006264580741423,55.89562740236488,0,0]
[2,-4.1459368172582103,-38.160118078973071,55.89562740236488,0,13.589573]
[3,-5.2342408699399749,-15.064524952901902,55.89562740236488,0,35.596862000000002]
[4,-3.6431620592848555,-4.913365634926075,55.89562740236488,0,47.339100000000002]
[5,-4.0928338496658823,-3.6579445966725874,55.89562740236488,0,48.144849000000001]
[6,-3.7645323071407097,-2.631851805572341,55.89562740236488,0,49.499243]
[7,-3.5151347601416858,2.4713106217034841,55.89562740236488,0,54.851802999999997]
[8,-2.9709975944814833,4.3916103095705106,55.89562740236488,0,57.316240000000001]
[9,2.7548968583721294,0.26503827212527947,55.89562740236488,0,58.915562999999999]
[10,-6.2667137848595642,11.159672608057059,55.89562740236488,0,60.788586000000002]
[11,5.614988819183508,0.37044228629147719,55.89562740236488,0,61.881059]
[12,6.4408189149333577,2.0539135906596777,55.89562740236488,0,64.390360000000001]
[13,3.4653994756766768,5.919428042026242,55.89562740236488,0,65.280455000000003]
[14,2.6310657494215972,12.065708165300936,55.89562740236488,0,70.592400999999995]

{"sheet":"S12 & Fig S2","index":28,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table S12 - Embedded Export Tariff (Base Case vs RIIO-2 EC&F Update)",null,null,null,null,null,"Figure S2 - Embedded Export Tariff (Base Case vs RIIO-2 EC&F Update)"]
[]
[]
["Zone","Zone Name","2021/22 Draft (£/kW)","2021/22 Draft (£/kW) (EC&F RIIO-2 Update)","Change (£/kW)"]
[1,"Northern Scotland",0,0,0]
[2,"Southern Scotland",0,0,0]
[3,"Northern",0,0,0]
[4,"North West",0,0,0]
[5,"Yorkshire",0,0,0]
[6,"N Wales & Mersey",0,0,0]
[7,"East Midlands",1.4585129999999999,1.239128,-0.21938499999999994]
[8,"Midlands",3.0302190000000002,3.7035650000000002,0.673346]
[9,"Eastern",3.3626170000000002,5.3028870000000001,1.9402699999999999]
[10,"South Wales",5.3663379999999998,7.1759110000000002,1.8095730000000003]
[11,"South East",5.9155709999999999,8.268383,2.3528120000000001]
[12,"London",8.3926780000000001,10.777685,2.3850069999999999]
[13,"Southern",8.0631699999999995,11.66778,3.604610000000001]
[14,"South Western",10.947969000000001,16.979725999999999,6.0317569999999989]
[]
["Zone","EET Locational £/kW","AGIC £/kW","2021/22 Phased Residual £/kW ","Final Tariff £/kW","EET Revenue £m"]
[1,-57.124956636370186,2.2829519999999999,0,0,0]
[2,-42.306054896231281,2.2829519999999999,0,0,0]
[3,-20.298765822841876,2.2829519999999999,0,0,0]
[4,-8.5565276942109314,2.2829519999999999,0,0,0]
[5,-7.7507784463384697,2.2829519999999999,0,0,0]
[6,-6.3963841127130507,2.2829519999999999,0,0,0]
[7,-1.0438241384382017,2.2829519999999999,0,1.239128,0.62452777593348463]
[8,1.4206127150890273,2.2829519999999999,0,3.7035650000000002,0.96857858762819637]
[9,3.0199351304974087,2.2829519999999999,0,5.3028870000000001,4.0946582837091698]
[10,4.8929588231974952,2.2829519999999999,0,7.1759110000000002,2.6245507900237248]
[11,5.9854311054749854,2.2829519999999999,0,8.268383,2.698633599885544]
[12,8.4947325055930349,2.2829519999999999,0,10.777685,1.399332168194513]
[13,9.3848275177029183,2.2829519999999999,0,11.66778,4.8142912312169406]
[14,14.696773914722534,2.2829519999999999,0,16.979725999999999,4.1845699975250055]

{"sheet":"S13 & Fig S3","index":29,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table S13 - NHH Demand Tariff Changes (Base Case vs RIIO-2 EC&F Update)",null,null,null,null,null,"Figure S3 - NHH Demand Tariffs (Base Case vs RIIO-2 EC&F Update)"]
[]
["Zone","Zone Name","2018/19\nFeb Forecast\n(p/kWh)","2021/22 Draft (p/kWh)","2021/22 Draft (p/kWh) (EC&F RIIO-2 Update)","Change (p/kWh)"]
[1,"Northern Scotland",null,2.0458539999999998,-0.162748,-2.208602,null,0]
[2,"Southern Scotland",null,2.913497,1.7220340000000001,-1.1914629999999999]
[3,"Northern",null,4.3571299999999997,4.3550490000000002,-2.0809999999995554E-3]
[4,"North West",null,5.2078119999999997,5.9263240000000001,0.71851200000000048]
[5,"Yorkshire",null,5.2574209999999999,5.848058,0.59063700000000008]
[6,"N Wales & Mersey",null,5.3931789999999999,6.0055820000000004,0.61240300000000047]
[7,"East Midlands",null,5.897278,6.879143,0.98186499999999999]
[8,"Midlands",null,6.1318260000000002,7.3059240000000001,1.1740979999999999]
[9,"Eastern",null,6.5768019999999998,7.8546829999999996,1.2778809999999998]
[10,"South Wales",null,5.2596600000000002,6.9552740000000002,1.695614]
[11,"South East",null,7.0628780000000004,8.3906460000000003,1.3277679999999998]
[12,"London",null,5.5808010000000001,6.7539319999999998,1.1731309999999997]
[13,"Southern",null,6.7952849999999998,8.3095970000000001,1.5143120000000003]
[14,"South Western",null,7.1570689999999999,9.6310330000000004,2.4739640000000005]

{"sheet":"S14","index":30,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Table S14 - Changes to Average Tariffs (Base Case vs RIIO-2 EC&F Update)"]
[]
["Generation Tariffs (£/kW)","2021/22 Draft","2021/22 Draft  (EC&F RIIO-2 Update)","Change"]
["Residual",-2.7640368812570482E-2,-3.4088307419463213,-3.3811903731337507]
["Average Generation Tariff",11.351149234259138,11.371708427456401,2.055919319726307E-2,"N.B. These generation average tariffs include local tariffs"]

{"sheet":"S15 & Fig S4","index":31,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,6,1,8],[32,6,32,7]]}
["Table S15 - Generation Wider Tariffs (Base Case vs RIIO-2 EC&F Update)",null,null,null,null,null,null,null,null,null,null,"Figure S4 - Generation Wider Tariffs Profile (Base Case vs RIIO-2 EC&F Update)"]
[null,null,null,null,null,null,"Example tariffs for a generator of each technology type:"]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",7.0364440000000004,35.271265999999997,33.685495000000003,-3.4088310000000002,58.793021800000005,65.530120800000006,44.3851704]
[2,"East Aberdeenshire",4.6903110000000003,17.852516999999999,33.685495000000003,-3.4088310000000002,42.511889600000003,49.248988600000004,37.417670800000003]
[3,"Western Highlands",6.6478190000000001,32.370151,32.493597000000001,-3.4088310000000002,55.1299864,61.628705799999999,42.032826400000005]
[4,"Skye and Lochalsh",-9.7304080000000006,32.370151,39.208483999999999,-3.4088310000000002,44.123669,51.965365800000001,48.747713400000002]
[5,"Eastern Grampian and Tayside",9.8375330000000005,23.956783000000001,27.461521999999999,-3.4088310000000002,47.56334600000001,53.055650399999998,33.635404200000004]
[6,"Central Grampian",7.7458470000000004,27.076512000000001,31.042876,-3.4088310000000002,50.832526399999999,57.041101600000005,38.464649800000004]
[7,"Argyll",2.0509940000000002,22.281196000000001,46.743996000000003,-3.4088310000000002,53.862316600000007,63.211115800000009,52.247643400000008]
[8,"The Trossachs",6.2380599999999999,22.281196000000001,25.435127000000001,-3.4088310000000002,41.0022874,46.089312800000009,30.938774400000007]
[9,"Stirlingshire and Fife",4.2724010000000003,19.631385000000002,23.18038,-3.4088310000000002,35.112982000000002,39.749058000000005,27.624103000000002]
[10,"South West Scotlands",4.8457489999999996,20.145980000000002,23.577359999999999,-3.4088310000000002,36.415590000000002,41.131062,28.226921000000001]
[11,"Lothian and Borders",4.8456489999999999,20.145980000000002,11.679691,-3.4088310000000002,26.897354800000002,29.233293000000003,16.329252000000004]
[12,"Solway and Cheviot",3.7904390000000001,13.206041000000001,12.528128000000001,-3.4088310000000002,20.968943200000002,23.4745688,14.401713400000002]
[13,"North East England",5.4481310000000001,10.356779,7.737628,-3.4088310000000002,16.514825600000002,18.062351200000002,8.4715085999999999]
[14,"North Lancashire and The Lakes",4.0351369999999998,10.356779,1.456753,-3.4088310000000002,10.077131600000001,10.368482199999999,2.1906336]
[15,"South Lancashire, Yorkshire and Humber",6.1818720000000003,4.2364189999999997,0.62229500000000004,-3.4088310000000002,6.6600121999999997,6.7844711999999996,-1.0919683999999998]
[16,"North Midlands and North Wales",5.164898,1.4966470000000001,0,-3.4088310000000002,2.9533845999999997,2.9533845999999997,-2.8101722000000002]
[17,"South Lincolnshire and North Norfolk",1.8105640000000001,2.2694969999999999,0,-3.4088310000000002,0.21733059999999993,0.21733059999999993,-2.5010322]
[18,"Mid Wales and The Midlands",2.3624230000000002,2.533204,0,-3.4088310000000002,0.98015519999999956,0.98015519999999956,-2.3955494000000002]
[19,"Anglesey and Snowdon",7.7383860000000002,1.9503079999999999,0,-3.4088310000000002,5.8898014000000005,5.8898014000000005,-2.6287077999999999]
[20,"Pembrokeshire",12.627238,-10.449411,0,-3.4088310000000002,0.85887820000000037,0.85887820000000037,-7.5885954]
[21,"South Wales & Gloucester",5.5494380000000003,-10.740783,0,-3.4088310000000002,-6.4520194000000002,-6.4520194000000002,-7.7051442000000003]
[22,"Cotswold",3.8172709999999999,4.0785679999999997,-12.639286999999999,-3.4088310000000002,-6.4401351999999994,-8.9679925999999988,-14.416690799999998]
[23,"Central London",-5.5411440000000001,4.0785679999999997,-7.3585440000000002,-3.4088310000000002,-11.5739558,-13.045664599999999,-9.1359478000000003]
[24,"Essex and Kent",-5.1175439999999996,4.0785679999999997,0,-3.4088310000000002,-5.2635205999999997,-5.2635205999999997,-1.7774038000000001]
[25,"Oxfordshire, Surrey and Sussex",-2.1326999999999998,-3.436477,0,-3.4088310000000002,-8.2907125999999991,-8.2907125999999991,-4.7834218000000002]
[26,"Somerset and Wessex",-3.8458899999999998,-5.7531150000000002,0,-3.4088310000000002,-11.857213000000002,-11.857213000000002,-5.7100770000000001]
[27,"West Devon and Cornwall",-4.5047740000000003,-14.678882,0,-3.4088310000000002,-19.6567106,-19.6567106,-9.2803837999999992]
[]
[null,null,"Small Generation Discount (£/kW)",null,null,0]

{"sheet":"S16 & Fig S5","index":32,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,0,3,11],[4,2,4,4],[4,5,4,7],[4,8,4,10],[4,11,5,11]]}
["Table S16 - Generation Tariff Changes (Base Case vs RIIO-2 EC&F Update)",null,null,null,null,null,null,null,null,null,null,null,"Figure S5 - Variation in Generation Zonal Tariffs (Base Case vs RIIO-2 EC&F Update)"]
[]
[]
["Wider Generation Tariffs (£/kW)"]
[null,null,"Conventional Carbon 80%",null,null,"Conventional Low Carbon 80%",null,null,"Intermittent 40%",null,null,"Change in Residual (£/kW)"]
["Zone","Zone Name","2021/22 Draft (£/kW)","2021/22 Draft (£/kW) (EC&F RIIO-2 Update)","Change (£/kW)","2021/22 Draft (£/kW)","2021/22 Draft (£/kW) (EC&F RIIO-2 Update)","Change (£/kW)","2021/22 Draft (£/kW)","2021/22 Draft (£/kW) (EC&F RIIO-2 Update)","Change (£/kW)"]
[1,"North Scotland",35.274427600000003,58.793021800000005,23.518594200000003,39.047685800000004,65.530120800000006,26.482435000000002,26.669580400000001,44.3851704,17.715589999999999,-3.1760794023910193]
[2,"East Aberdeenshire",26.632864200000004,42.511889600000003,15.8790254,30.406122400000001,49.248988600000004,18.842866200000003,22.893911200000002,37.417670800000003,14.523759600000002,-3.1760794023910193]
[3,"Western Highlands",32.942152999999998,55.1299864,22.187833400000002,36.583199200000003,61.628705799999999,25.045506599999996,25.287879600000004,42.032826400000005,16.744946800000001,-3.1760794023910193]
[4,"Skye and Lochalsh",26.389325200000002,44.123669,17.734343799999998,30.0110052,51.965365800000001,21.954360600000001,25.191048600000002,48.747713400000002,23.5566648,-3.1760794023910193]
[5,"Eastern Grampian and Tayside",27.341760000000001,47.56334600000001,20.221586000000009,30.446901,53.055650399999998,22.608749399999997,20.644432000000002,33.635404200000004,12.990972200000002,-3.1760794023910193]
[6,"Central Grampian",29.0494132,50.832526399999999,21.783113199999999,32.378388199999996,57.041101600000005,24.662713400000008,22.172201600000001,38.464649800000004,16.292448200000003,-3.1760794023910193]
[7,"Argyll",34.242806400000006,53.862316600000007,19.619510200000001,39.466307999999998,63.211115800000009,23.744807800000011,30.837804999999999,52.247643400000008,21.409838400000009,-3.1760794023910193]
[8,"The Trossachs",25.013958199999998,41.0022874,15.988329200000003,27.89218,46.089312800000009,18.197132800000009,19.111405999999999,30.938774400000007,11.827368400000008,-3.1760794023910193]
[9,"Stirlingshire and Fife",21.593847199999999,35.112982000000002,13.519134800000003,24.221320800000001,39.749058000000005,15.527737200000004,17.238955400000002,27.624103000000002,10.3851476,-3.1760794023910193]
[10,"South West Scotlands",22.408011600000002,36.415590000000002,14.0075784,25.0838128,41.131062,16.0472492,17.612373399999999,28.226921000000001,10.614547600000002,-3.1760794023910193]
[11,"Lothian and Borders",16.877376400000003,26.897354800000002,10.019978399999999,18.195473799999998,29.233293000000003,11.037819200000005,10.8238544,16.329252000000004,5.5053976000000038,-3.1760794023910193]
[12,"Solway and Cheviot",13.963421800000003,20.968943200000002,7.0055213999999992,15.4439948,23.4745688,8.0305739999999997,10.0955324,14.401713400000002,4.3061810000000023,-3.1760794023910193]
[13,"North East England",11.478353999999998,16.514825600000002,5.036471600000004,12.388322599999999,18.062351200000002,5.6740286000000033,6.546960799999999,8.4715085999999999,1.9245478000000009,-3.1760794023910193]
[14,"North Lancashire and The Lakes",7.6850031999999997,10.077131600000001,2.3921284000000016,7.9282405999999988,10.368482199999999,2.4402416000000002,3.2133048,2.1906336,-1.0226712,-3.1760794023910193]
[15,"South Lancashire, Yorkshire and Humber",5.5759473999999996,6.6600121999999997,1.0840648000000002,5.6463577999999996,6.7844711999999996,1.1381133999999999,0.87337739999999997,-1.0919683999999998,-1.9653457999999997,-3.1760794023910193]
[16,"North Midlands and North Wales",3.3680124,2.9533845999999997,-0.41462780000000032,3.3680124,2.9533845999999997,-0.41462780000000032,-0.12477980000000001,-2.8101722000000002,-2.6853924,-3.1760794023910193]
[17,"South Lincolnshire and North Norfolk",2.0000659999999999,0.21733059999999993,-1.7827354,2.0000659999999999,0.21733059999999993,-1.7827354,-2.1508999999999973E-2,-2.5010322,-2.4795232,-3.1760794023910193]
[18,"Mid Wales and The Midlands",1.7236216,0.98015519999999956,-0.74346640000000042,1.7236216,0.98015519999999956,-0.74346640000000042,0.10847179999999998,-2.3955494000000002,-2.5040211999999999,-3.1760794023910193]
[19,"Anglesey and Snowdon",5.3229255999999996,5.8898014000000005,0.56687580000000093,5.3229255999999996,5.8898014000000005,0.56687580000000093,-0.26008019999999998,-2.6287077999999999,-2.3686275999999999,-3.1760794023910193]
[20,"Pembrokeshire",5.3147577999999989,0.85887820000000037,-4.4558795999999985,5.3147577999999989,0.85887820000000037,-4.4558795999999985,-2.1958405999999999,-7.5885954,-5.3927548000000005,-3.1760794023910193]
[21,"South Wales & Gloucester",1.7991537999999996,-6.4520194000000002,-8.2511732000000002,1.7991537999999996,-6.4520194000000002,-8.2511732000000002,-2.2420966,-7.7051442000000003,-5.4630476000000003,-3.1760794023910193]
[22,"Cotswold",-1.6643160000000008,-6.4401351999999994,-4.775819199999999,-3.4407926000000013,-8.9679925999999988,-5.527199999999997,-7.5868948000000014,-14.416690799999998,-6.8297959999999964,-3.1760794023910193]
[23,"Central London",-6.1607948000000006,-11.5739558,-5.4131609999999997,-7.3475046000000006,-13.045664599999999,-5.6981599999999979,-4.6380608000000008,-9.1359478000000003,-4.4978869999999995,-3.1760794023910193]
[24,"Essex and Kent",-1.2788496,-5.2635205999999997,-3.9846709999999996,-1.2788496,-5.2635205999999997,-3.9846709999999996,1.2954882000000001,-1.7774038000000001,-3.0728920000000004,-3.1760794023910193]
[25,"Oxfordshire, Surrey and Sussex",-3.0834286,-8.2907125999999991,-5.2072839999999996,-3.0834286,-8.2907125999999991,-5.2072839999999996,-1.0957897999999999,-4.7834218000000002,-3.6876320000000002,-3.1760794023910193]
[26,"Somerset and Wessex",-4.6851982000000003,-11.857213000000002,-7.1720148000000012,-4.6851982000000003,-11.857213000000002,-7.1720148000000012,-1.4933966000000001,-5.7100770000000001,-4.2166803999999996,-3.1760794023910193]
[27,"West Devon and Cornwall",-5.2217578000000007,-19.6567106,-14.4349528,-5.2217578000000007,-19.6567106,-14.4349528,-2.5463274,-9.2803837999999992,-6.7340563999999992,-3.1760794023910193]

{"sheet":"T19","index":33,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Table 19 - Summary of in flight CUSC modification proposals",null,null,null,"Return to Index"]
[]
[]
[null,"Name","Title","Effect of proposed change","Possible implementation"]
[null,"CMP280","‘Creation of a New Generator TNUoS Demand Tariff which Removes Liability for TNUoS Demand Residual Charges from Generation and Storage Users'","Change the structure of demand TNUoS charges applied to storage and, potentially other generators."," April 2021, if approved"]
[null,"CMP286","Improving TNUoS Predictability through Increased Notice of the Target Revenue used in the TNUoS Tariff Setting Process v1","Fixes target revenue to be recovered from the TNUoS setting process earlier, to provide more stability to future tariffs."," April 2021, if approved"]
[null,"CMP287","Improving TNUoS Predictability Through Increased Notice of Inputs Used in the TNUoS Tariff Setting Process.","Fixes parameters associated with the TNUoS setting process earlier, to provide more stability to future tariffs."," April 2021, if approved"]
[null,"CMP292","Introducing a Section 8 cut-off date for changes to the Charging Methodologies","Introduces a cut off for changes to the charging methodologies to bring more stability and predictability to following years’ charges","September 2020, If approved"]
[null,"CMP301","Clarification on the treatment of project costs associated with HVDC and subsea circuits","Clarification of the legal text to ensure that it is clear that AC substation costs are not included in the circuit expansion factor calculation for HVDC and subsea circuits. We already calculate in this manner.","Implemented, No impact on charges "]
[null,"CMP303","Improving local circuit charge cost-reflectivity","Remove some of the cost of the HVDC and subsea circuits from the calculation of the local circuit, reducing the local circuit tariffs for these circuits.","April 2020, no immediate impact on charges"]
[null,"CMP280","Creation of a New Generator TNUoS Demand Tariff which Removes Liability for TNUoS Demand Residual Charges from Generation and Storage Users","Remove demand residual charges from generation and storage","April 2022 or beyond, if approved"]
[null,"CMP316","TNUoS Arrangements for Co-located Generation Sites ","Develop a cost-reflective TNUoS arrangement for generation sites with multiple technology types","April 2022 or beyond, if approved"]
[null,"CMP317 & CMP327","Identification and exclusion of Assets Required for Connection when setting TNUoS charges ","Removal of revenue linked to “generator only spurs” from the calculation of generation revenue cap under the EU rules, and setting generation residual tariff to 0"," April 2021, if approved"]
[null,"CMP324 & CMP325","Generation Re-zoning","Revise TNUoS generation zoning methodology","Approved and implemented in this forecast"]
[null,"CMP344","Clarification of Transmission Licensee revenue recovery and the treatment of revenue adjustments in the Charging Methodology","Fixing the TNUoS revenue at each onshore price control period for onshore TOs, and at the point of asset transfer for OFTOs. ","April 2021, if approved"]
[null,"CMP353","Stabilising the Expansion Constant and non-specific Onshore Expansion Factors from 1st April 2021","To stabilise the locational signal at the start of the RIIO-2 period at the RIIO-1 value plus relevant inflation in each charging year until such time as the effect of any change in the locational signal can be better understood.","April 2021, if approved"]

{"sheet":"T20","index":34,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,0,5,1]]}
["Table 20 - Demand Locational Tariffs",null,null,null,null,null,"Return to Index"]
[]
[]
[]
["Demand Zone",null,"2021/22 August","2019/20 April","2021/22 Draft","2019/20 June (£/kW)","Changes"]
[null,null,"Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)"]
[1,"Northern Scotland",-1.5595011507915448,-29.948864307888321,-2.0657647365347418,-31.644978263027937,-0.50626358574319696,-1.6961139551396158]
[2,"Southern Scotland",-2.5641593849484448,-21.500594660785886,-2.6806339784977111,-21.873980553217855,-0.11647459354926637,-0.37338589243196907]
[3,"Northern",-3.2410218412225977,-8.2483440276801012,-3.2928516445446991,-8.8016899385291101,-5.1829803322101409E-2,-0.55334591084900886]
[4,"North West",-2.185331135434033,-3.1744172998080979,-2.3078450023227912,-3.0225409062198052,-0.1225138668887582,0.15187639358829275]
[5,"Yorkshire",-2.329009810188488,-1.7001302094634743,-2.5103501665641534,-2.1432132481838897,-0.18134035637566548,-0.44308303872041543]
[6,"N Wales & Mersey",-2.4767666037485854,-0.78225946441627792,-2.3958440762689404,-1.4814974066934641,8.0922527479645012E-2,-0.69923794227718616]
[7,"East Midlands",-2.2697413162680893,1.9274240404436804,-2.374726889191928,1.5502879018807589,-0.1049855729238387,-0.3771361385629215]
[8,"Midlands",-2.1606022784483687,3.0737940815717515,-1.9263708895977221,2.6736376405607198,0.23423138885064665,-0.40015644101103165]
[9,"Eastern",1.3759790911506937,6.7568756356930521E-2,1.3124616532073838,-0.23279674485518523,-6.3517437943309885E-2,-0.30036550121211575]
[10,"South Wales",-6.2701570847556525,4.9906766603371606,-3.9437700647471785,7.0271558705925026,2.326387020008474,2.036479210255342]
[11,"South East",4.1338429045219334,0.48632780671511033,3.7078074264388738,-7.518858219913567E-2,-0.42603547808305953,-0.56151638891424605]
[12,"London",5.7616758896060141,0.93968565115541303,5.1315436604641258,0.97818225165751371,-0.63013222914188827,3.8496600502100686E-2]
[13,"Southern",2.1295598587618843,3.9475122206860829,1.9857219620884903,3.7944957857401769,-0.14383789667339397,-0.153016434945906]
[14,"South Western",-0.40992471794746088,5.7852143553789457,1.4864577095510296,7.178559369330312,1.8963824274984904,1.3933450139513663]

{"sheet":"T21","index":35,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,3,1],[2,2,2,3],[2,4,2,5],[2,6,2,7]]}
["Table 21 - Breakdown of the Embedded Export Tariff",null,null,null,null,null,null,null,"Return to Index"]
[]
["Demand Zone",null,"2021/22 August","2019/20 April","2021/22 Draft","2019/20 June (£/kW)","Changes"]
[null,null,"Locational (£/kW)","AGIC (£/kW)","Locational (£/kW)","AGIC (£/kW)","Locational (£/kW)","AGIC (£/kW)"]
[1,"Northern Scotland",-31.508365458679865,2.2878799999999999,-33.710742999562676,2.2829519999999999,{"$f":"E5-C5","v":-2.2023775408828108},{"$f":"F5-D5","v":-4.9280000000000435E-3}]
[2,"Southern Scotland",-24.064754045734333,2.2878799999999999,-24.554614531715565,2.2829519999999999,-0.48986048598123233,-4.9280000000000435E-3]
[3,"Northern",-11.489365868902699,2.2878799999999999,-12.094541583073809,2.2829519999999999,-0.60517571417111071,-4.9280000000000435E-3]
[4,"North West",-5.359748435242131,2.2878799999999999,-5.3303859085425964,2.2829519999999999,2.9362526699534541E-2,-4.9280000000000435E-3]
[5,"Yorkshire",-4.0291400196519618,2.2878799999999999,-4.6535634147480431,2.2829519999999999,-0.62442339509608136,-4.9280000000000435E-3]
[6,"N Wales & Mersey",-3.2590260681648635,2.2878799999999999,-3.8773414829624047,2.2829519999999999,-0.61831541479754115,-4.9280000000000435E-3]
[7,"East Midlands",-0.34231727582440885,2.2878799999999999,-0.82443898731116905,2.2829519999999999,-0.4821217114867602,-4.9280000000000435E-3]
[8,"Midlands",0.91319180312338277,2.2878799999999999,0.74726675096299777,2.2829519999999999,-0.165925052160385,-4.9280000000000435E-3]
[9,"Eastern",1.4435478475076242,2.2878799999999999,1.0796649083521985,2.2829519999999999,-0.36388293915542569,-4.9280000000000435E-3]
[10,"South Wales",-1.2794804244184919,2.2878799999999999,3.0833858058453241,2.2829519999999999,4.3628662302638155,-4.9280000000000435E-3]
[11,"South East",4.6201707112370434,2.2878799999999999,3.632618844239738,2.2829519999999999,-0.98755186699730535,-4.9280000000000435E-3]
[12,"London",6.7013615407614271,2.2878799999999999,6.1097259121216396,2.2829519999999999,-0.59163562863978747,-4.9280000000000435E-3]
[13,"Southern",6.0770720794479676,2.2878799999999999,5.7802177478286669,2.2829519999999999,-0.29685433161930064,-4.9280000000000435E-3]
[14,"South Western",5.3752896374314849,2.2878799999999999,8.6650170788813412,2.2829519999999999,3.2897274414498563,-4.9280000000000435E-3]

{"sheet":"T22","index":36,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[2,0,3,0],[2,1,3,1],[2,2,2,6],[2,7,2,11]]}
["Table 22 - Demand Profiles",null,null,null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","2021/22 August",null,null,null,null,"2021/22 Draft"]
[null,null,"Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)","Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)"]
[1,"Northern Scotland",166.85119000000009,1464.6336839757901,435.09999055976203,0.7571445893643014,1375.3504031294199,121.93900300000008,1436.49662161266,436.61530019772124,0.75527012959522988,1025.2624012798299]
[2,"Southern Scotland",2313.9954409999996,3335.4640144417199,1191.2411661116719,1.6551290592861221,576.63496816867803,1976.9954409999998,3307.9970546007298,1201.0437055355958,1.6627191458285027,630.10281589273598]
[3,"Northern",2046,2496.8238279051902,1032.0405131475279,1.1788084153408753,487.16021679626198,2037,2486.7033160751803,1029.8975507643484,1.1907492583028161,411.05095778844702]
[4,"North West",2881,3931.4538400402103,1470.4954256244812,1.9466438855697703,440.60623134209595,2183,3900.2870833666198,1444.9081317117639,1.9613412253502143,369.48921648100105]
[5,"Yorkshire",4002,3748.3741073923297,1541.4499877212359,1.785082868506324,782.57670229284508,4062,3740.9573324230696,1547.2738862377425,1.805976464396053,670.78089635383594]
[6,"N Wales & Mersey",2841,2557.8730635100401,1008.249955921308,1.2439976199471425,625.38738209890494,2568,2544.2355052104604,1016.9434135038882,1.2588255412696783,533.49493430092195]
[7,"East Midlands",5445,4580.8800460106004,1745.0379746389638,2.2221995245757697,584.70241742099211,5059,4573.3349094955402,1756.5953498512781,2.2459663314864295,504.00591844196697]
[8,"Midlands",4445,4154.7469118581403,1559.6130830678765,2.0089276018315427,267.80509813964096,4198,4137.2348519694806,1551.3811403138156,2.0286469294199021,261.52603292768799]
[9,"Eastern",5672,6267.9535722855398,2013.4571876300215,3.1049397463395301,620.07345221995399,5301,6304.5271387727898,2119.685589468032,3.1389211448437475,772.15640894191392]
[10,"South Wales",1642,1777.73650336736,798.86102470623712,0.84260574229590102,419.06590145965697,1821,1760.8250037390101,787.77486013504586,0.85043869389012161,365.74462178924597]
[11,"South East",3217,3829.8731680287301,1155.18073557087,1.937954866575194,353.73837952197601,3400,3802.5155588787702,1147.2268850623511,1.9582767196665516,326.37984542571803]
[12,"London",5171,4081.9855757434602,2166.9712120293671,1.8274250034738151,126.93379070643601,4657,4094.4101180678895,2173.4723244337092,1.8313756950889839,129.836067057663]
[13,"Southern",7684,5383.5364303701499,2013.6030591365106,2.6100964812319432,394.10731702267498,6553,5358.4981275054897,2004.1981395093412,2.6351485838519797,412.61417598031102]
[14,"South Western",2167,2544.1991951139998,735.1638409589807,1.3125774299402138,258.77756399361203,2412,2533.8080643806202,736.92546739918828,1.3170575976606613,246.44508507034902]
["Total",null,{"$f":"SUM(C5:C18)","v":49693.846631},{"$f":"SUM(D5:D18)","v":50155.533940043264},18866.465156824815,24.433532834278441,7312.9198243131468,46349.934443999999,49981.830686098307,18953.941744123822,24.640713460650868,6658.889377731628]

{"sheet":"T23","index":37,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Table 23 - Generic Annual Load Factors",null,null,null,"Return to Index"]
[]
[]
["Technology","Generic ALF"]
["Gas_Oil",3.9350000000000001E-3]
["Pumped_Storage",0.102893]
["Tidal",0.189]
["Biomass",0.39838699999999999]
["Wave",0.31]
["Onshore_Wind",0.35665999999999998]
["CCGT_CHP",0.50946999999999998]
["Hydro",0.41788599999999998]
["Offshore_Wind",0.48320400000000002]
["Coal",0.27737200000000001]
["Nuclear",0.77564500000000003]
[]
["*Note: "]
["1. ALF figures for Wave and Tidal technology are generic figures provided by BEIS due to no metered data being available."]
["2. 2020 draft ALFs (including generic and station-specific ALFs) will be published on 30th November"]

{"sheet":"T24","index":38,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 24 - Connected Generation Changes",null,null,null,null,null,null,"Return to Index"]
[]
[null,"Power Station","MW Change","Node","Generation Zone"]
[null,"Nemo Link (correction)",-1020,"RICH40",24]
[null,"Abedare",10,"UPPB21",21]
[null,"Aberthaw",-1560,"ABTH20",21]
[null,"Burwell (Tertiary)",-49.9,"BURW40",18]
[null,"Capenhurst 275KV Substation",49.9,"CAPE20",16]
[null,"Exeter (Tertiary)",-49.9,"EXET40",26]
[null,"Fallago Rig 2",-41.4,"FALL40",11]
[null,"Kirkby (Tertiary)",-49.9,"KIBY20",15]
[null,"North Killingholme Power Project",-540,"KILL40",15]
[null,"Oldbury (Tertiary)",-49.9,"OLDB4A",18]
[null,"Seabank (Tertiary)",-49.9,"SEAB40",22]
[null,"Sellindge (Tertiary)",-49.9,"SELL40",24]
[null,"Thurrock",600,"TILB20",24]
[null,"Tralorg Wind Farm",20,"MAHI20",10]
[null,"Bramford (Tertiary PP)",-49.9,"BRFO40",18]

{"sheet":"T25-28","index":39,"n_rows":98,"n_cols":22,"rows_kept":98,"cut":false,"hidden":false,"merged":[[2,18,3,21],[2,2,4,2],[2,1,4,1],[2,3,3,6],[2,11,3,14],[2,7,3,10],[53,0,53,2],[55,0,55,2],[56,0,57,2],[59,0,59,2],[61,0,61,2],[71,0,71,2],[73,0,73,2],[63,0,63,2],[65,0,65,2],[66,0,66,2],[67,0,67,2],[70,0,70,2]]}
["Tables 25-28 - Revenue Breakdown",null,null,null,null,null,null,"Return to Index"]
[]
["2021/22 Revenue"," ","Licence Term","National Grid Electricity Transmission",null,null,null,"Scottish Power Transmission",null,null,null,"SHE Transmission",null,null,null," ",null,null,"NGESO TNUoS Other Pass-Through"]
["Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Notes"]
["Regulatory Year",null,null,"March Forecast","August Forecast","Nov Draft","Jan Final","March Forecast","August Forecast","Nov Draft","Jan Final","March Forecast","July Forecast","Nov Draft","Jan Final",null,null,"Term","March Forecast","August Forecast","Nov Draft","Jan Final"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1585.1201813457344,null,null,null,261.86514,null,null,null,273.41117882229963,null,null,null,"Office of National Statistics",null,"Embedded Offshore Pass-Through (OFETt)",0.58663219450549453,0.5787828904945056,{"$f":"T6","v":0.5787828904945056}]
["Price Control Financial Model Iteration Adjustment","A2","MODt",-393.91407950183287,null,null,null,-8.4996632346660306,null,null,null,-8.2167124603139605,null,null,null,"Bank of England Base Rate",null,"Network Innovation Competition (NICFt)",13.854501000000001,13.854501000000001,{"$f":"T7","v":13.854501000000001}]
["RPI True Up","A3","TRUt",-1.0811590749795008,null,null,null,-2.0577538626467606,null,null,null,0,null,null,null,"From Licence",null,"ESO Network Innovation Allowance (NIAt)",3,3.0398171288203804,0]
["RPI Forecast","A4","RPIFt",1.42,null,null,null,{"$f":"D9","v":1.42},null,null,null,{"$f":"D9","v":1.42},null,null,null,"Forecast",null,"Offshore Transmission Revenue (OFTOt) and Interconnectors Cap&Floor Revenue Adjustment (TICFt)",529.94027182490379,555.80507139240376,545.59171900067929]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",{"$f":"SUM(D6:D8)*D9","v":1689.9774187318692},1688.7872937891002,1961.8054233853557,null,{"$f":"SUM(H6:H8)*H9","v":356.85696652181582},351.57950434085939,378.16477893548591,null,{"$f":"SUM(L6:L8)*L9","v":376.57614223401964},382.5022391723972,null,null,"Forecast",null,"Financial facility (FINt)",null,0,{"$f":"T10","v":0}]
["Pass-Through Business Rates & Licence fee","B1+B3","RBt+LFt",38.084082823484522,null,null,null,4.0883362121391578,{"$f":"H11","v":4.0883362121391578},null,null,0,null,null,null,"Using HM Treasury Forecast",null,"Site Specific Charges Discrepancy (DISt)",null,0,{"$f":"T11","v":0}]
["Temporary Physical Disconnection","B2","TPDt",4.8453188224824792,null,null,null,0,null,null,null,0,null,null,null,null,null,"Termination Sums (TSt)",null,0,{"$f":"T12","v":0}]
["Inter TSO Compensation","B4","ITCt",-2.7582836286043411,null,null,null,null,null,null,null,null,null,null,null,"Forecast",null,"NGET revenue pas-through (NGETTOt)*",{"$f":"D26","v":1754.9134640049667},{"$f":"E26","v":1723.8758044121978},{"$f":"F26","v":1919.8752004610226}]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10]","B","PTt",{"$f":"SUM(D11:D13)","v":40.171118017362666},40.171118017362666,0,null,{"$f":"SUM(H11:H13)","v":4.0883362121391578},{"$f":"H14","v":4.0883362121391578},null,null,{"$f":"SUM(L11:L13)","v":0},null,null,null,"Forecast",null,"SPT revenue pass-through (TSPt)",{"$f":"H26","v":376.74302572120848},{"$f":"I26","v":371.46556354025205},{"$f":"J26","v":390.59681255157727}]
["Financial Incentive for Timely Connections Output","C5","-CONADJt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHETL revenue pass-through (TSHt)",{"$f":"L26","v":374.03426674690797},{"$f":"M26","v":379.96036368528553},{"$f":"N26","v":539.73909270884246}]
["Reliability Incentive Adjustment, stakeholder Satisfaction Adjustment and SF6 Gas Emission Adjustment","C1+C2+C3","RIt+SSOt+SFIt",17.165384433683851,{"$f":"D16","v":17.165384433683851},null,null,3.4101816254997908,null,null,null,0,null,null,null,"Forecast",null,"Total",{"$f":"SUM(S6:S15)","v":3053.0721614924928},{"$f":"SUM(T6:T15)","v":3048.5799040494539},{"$f":"SUM(U6:U15)","v":3410.2361086126166}]
["Outputs Incentive Revenue [C=C1+C2+C3]","C","OIPt",{"$f":"SUM(D15:D16)","v":17.165384433683851},17.165384433683851,0,null,{"$f":"H16","v":3.4101816254997908},3.4101816254997908,null,null,{"$f":"L16","v":0},null,null,null,"Forecast"]
["Network Innovation Allowance","D","NIAt",7.5995428220509522,{"$f":"D18","v":7.5995428220509522},null,null,0,null,null,null,0.9,{"$f":"L18","v":0.9},null,null,"Forecast"]
["Future Environmental Discretionary Rewards","F","EDRt",null,null,null,null,0,null,null,null,0,null,null,null," "]
["Transmission Investment for Renewable Generation","G","TIRGt",null,null,null,null,32.486313791999997,32.486313791999997,31.889813679999996,null,0,null,null,null,"Forecast"]
["Correction Factor","-K","-K",null,null,-12.082688274333066,null,-7.3531054963615894,-7.3531054963615894,null,null,0,null,null,null," "]
["Financial Facility","FINt","FINt"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",{"$f":"D10+D14+D17+D18+D19+D20+D21+D22","v":1754.9134640049667},{"$f":"E10+E14+E17+E18+E19+E20+E21+E22","v":1753.7233390621977},{"$f":"F10+F14+F17+F18+F19+F20+F21+F22","v":1949.7227351110225},null,{"$f":"H10+H14+H17+H18+H19+H20+H21","v":389.48869265509313},{"$f":"I10+I14+I17+I18+I19+I20+I21","v":384.2112304741367},{"$f":"J10+J14+J17+J18+J19+J20+J21","v":410.05459261548589},null,{"$f":"L10+L14+L17+L18+L19+L20+L21","v":377.47614223401962},{"$f":"M10+M14+M17+M18+M19+M20+M21","v":383.40223917239717},542.63908273215304,null,"Forecast"]
["Pre-vesting connection charges","S1"," ",0,29.732881120000002,{"$f":"E24","v":29.732881120000002},null,12.745666933884667,12.745666933884667,19.457780063908615,null,3.4418754871116639,3.4418754871116639,2.8999900233106253,null,"Forecast"]
["Rental Site","S2",null,0,0.11465353,{"$f":"E25","v":0.11465353}]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",{"$f":"D23-D24-D25","v":1754.9134640049667},{"$f":"E23-E24-E25","v":1723.8758044121978},{"$f":"F23-F24-F25","v":1919.8752004610226},null,{"$f":"H23-H24","v":376.74302572120848},371.46556354025205,390.59681255157727,null,374.03426674690797,379.96036368528553,539.73909270884246,null,"Forecast"]
[]
[]
[]
[]
[]
[]
["Notes"]
["All monies are  nominal 'money of the day' prices unless stated otherwise",null,null,null,null,null,null,null,"Total",{"$f":"E26+I26+M26+SUM(T6:T10)","v":3048.5799040494539}]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments are listed separately, as they do not form part of TOs Maximum Revenue"]
[]
["Commentary"]
["All reasonable care has been taken in the preparation of these illustrative tables and the data therein. "]
["TOs offer this data without prejudice and cannot be held responsible for any loss that might be attributed to the use of this data.  "]
["TOs do not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
["This forecast contains as much information as can be currently made available."]
[]
[]
["This respects commercial confidentiality and disclosure considerations."]
[]
["All £ figures are in money of the day"]
[]
["Information provided in £m to one decimal place"]
[]
["SHE Transmission Commentary"]
["All reasonable care has been taken in the preparation of these illustrative tables and the data therein.  SHET offers the data without prejudice and cannot be held responsible for any loss that might be attributed to the use of this data.  SHET does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
["The base revenue forecasts for the RIIO-T1 period (2019/20 to 2020/21, inclusive) reflect the figures authorised by Ofgem in the RIIO-T1 Final Proposals.  "]
["The maximum revenue awarded for the RIIO-T2 period from 2021/22 inclusive, reflects the SHETL T2 business plan submission. CPI has therefore been adopted for indexation purposes and figures have accordingly been indexed up at a flat CPI rate of 2% to reflect the submitted plan."]
[]
[]
["This forecast contains as much information as can be currently made available.  Generally, allowances determined by Ofgem are shown; whilst those for which Ofgem determinations are expected are not. This respects commercial confidentiality and disclosure considerations."]
[]
["It should be noted that the years relating to RIIO-T2 (2021/22 to 2025/26) represent an extrapolation of numbers based on the SHETL business plan and therefore do not reflect anything beyond a high level estimation of a potential scenario. These numbers represent a base programme, constructed from an internal 5 year model which has projected on the assumption that the submitted plan will be enacted in full."]
[]
["Note that actual revenues may vary from those currently forecast.  "]
[]
["All £ figures are in money of the day"]
[]
["Information provided in £m to one decimal place"]
[]
["SHE Transmssion Assumptions"]
["The charging year runs from 1st April to 31st March, with charges set one year in advance. The information available at the time will be reflected in those charges."]
["For 2021/22, which is the first year of RIIO-T2, maximum revenue reflects a number of assumptions and changes to key parameters: \n- increase in base allowed totex to align with projected portfolio impacting fast money expectations for 2021/22 and overall Company RAV; plus\n- an expectation of TIRG revenue following TIRG RAV being reflected within Core RAV - this is expected to occur at the beginning of RIIO-T2; plus\n- an increase in the Business Rates allowance to reflect the actual increase in rates which have been projected for RIIO-T2; \n- an increase in tax revenue allowance assuming that tax is treated as a pass through item; \n- an increase in WACC based on adjusted parameters and transition from RPI to CPI.\nOther inputs around incentives have been assumed as nil, given ongoing discussions over RIIO-T1 close out and implications for RIIO-T2. "]
[]
["Note, due to the RIIO-T2 ongoing settlement discussions following draft determinations, the current forecast does not constitute the expression of SHE Transmission's plans or expectations at an individual  input level (i.e. by a particular incentive); but rather on an overall basis representing revenue collected under the current proposed business plan."]
["The forecast does not account for close out adjustments at the end of RIIO-T1 for any of the two year lag items. "]
[]
["SPT Commentary"]
["All reasonable care has been taken in the preparation of these illustrative tables and the data therein. "]
["SPT offers this data without prejudice and cannot be held responsible for any loss that might be attributed to the use of this data.  "]
["SPT does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
["The base revenue forecasts for the RIIO-ET1 period (2013/14 to 2020/21, inclusive) reflect the figures authorised by Ofgem in the the RIIO-ET1 Final Proposals.  "]
["The base revenue for the RIIO-ET2 period from 2021/22 is equivalent to the SPT Dec 19 Business Plan submission as provided in the published Licence Model (LiMo)."]
["Within the bounds of commercial confidentiality, this forecast provides as much information as possible."]
[]
["This forecast contains as much information as can be currently made available."]
["Generally, allowances determined by Ofgem are shown; and we also include forecasts for anticipated future Ofgem determinations in respect of the Iteration adjustment reflecting our latest view of totex, changes to allowed totex and cost of debt."]
[]
["This respects commercial confidentiality and disclosure considerations."]
[]
["Note that actual revenues may vary from those currently forecast.  "]
[]
["All £ figures are in money of the day"]
[]
["NGET Commentary"]
["The indicative exit charges are based on revenues derived from National Grid’s proposed RIIO-2 framework as set out in our business plan submission of 9th December 2019."]
["RIIO-2 Final Determinations are anticipated to be published by Ofgem in December 2020."]
["In our business plan submission, we highlighted a flat consumer bill from RIIO-1 to RIIO-2.  Our business plan talks about consumers bills pre inflation in RIIO-2 whereas these figures published for charge setting include inflation."]
["In RIIO-2 plan, we were clear that we referenced average bills across RIIO-2 versus average bills across RIIO-1. Revenues at the end of the RIIO-1 period are depressed because of the negative MOD adjustments in the latter years of RIIO-1 mainly as a result of decrease in volume drivers and reduction in cost of debt."]

{"sheet":"T29","index":40,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,8],[26,0,27,0],[23,7,26,7],[26,8,27,8],[26,9,27,9],[22,6,26,6],[20,5,21,5],[3,9,4,9],[14,1,17,1],[17,2,19,2],[18,3,19,3]]}
["Table 29 - Offshore Revenues",null,null,null,null,null,null,null,null,"Return to Index"]
[]
["Offshore Transmission Revenue Forecast (£m)","2020-11-26"]
[null,null,null,null,null,null,null,null,null,"Notes"]
["Regulatory Year","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
["Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.8724963671592052,6.250052539232863,6.4376795312597705,6.6242630380500991,6.7146352817627788,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.8017526906474828,8.07750330830571,8.2426165399928522,8.3950566000719462,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.607167459943749,14.664797654796391,15.105525040799996,15.34111430752977,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.7488529744949677,9.1256414429245591,9.290493192616605,9.4,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,16.325806709079423,14.546011968069125,14.918174357090118,15.142104447452324,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.742778333926285,21.420541259079798,22.906063897722504,23.365925218045124,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.5936963237531,13.944087232595104,13.919036673917866,14.143850757507618,"Current revenues plus indexation"]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.387567597857235,29.315573022344434,31.562492700041204,32.10164736835489,"Current revenues plus indexation"]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,41.77261773651108,43.290408952810004,44.263147942579849,44.541298069877158,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.623202111696155,19.181206555378026,19.66747115753698,20.704610742924775,"Current revenues plus indexation"]
["Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,28.169364454148401,29.216443614680689,29.721504564017465,29.972760229650657,"Current revenues plus indexation"]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,32.730809292973404,33.98287134592244,18.862440472463749,26.397980512439297,"Current revenues plus indexation"]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.572650063642349,23.578973631812271,23.05792297360248,25.25074850216911,"Current revenues plus indexation"]
["Humber Gateway",null,null,29.284541507176115,9.7498990869565194,12.145415107061377,12.47812447894448,11.257241207364295,13.010135870242102,"Current revenues plus indexation"]
["Westermost Rough",null,null,null,11.576692607080746,13.197339934782658,13.564033876782693,13.943530782670807,14.182120187515528,"Current revenues plus indexation"]
["Burbo Bank",null,null,null,null,34.275926251984941,13.060165093969466,12.784653401505304,14.065913939930951,"Current revenues plus indexation"]
["Dudgeon",null,null,null,null,null,18.69643662868048,19.202776704002179,19.598479167851686,"Current revenues plus indexation"]
["Race Bank",null,null,null,null,null,66.016206160164288,26.721614188678799,27.383156335099418,"Current revenues plus indexation"]
["Galloper",null,null,null,null,null,null,37.795820165207729,17.063945045557997,"Current revenues plus indexation"]
["Walney 3",null,null,null,null,null,null,null,13.453626157885081,"Current revenues plus indexation"]
["Walney 4",null,null,null,null,null,null,null,13.453626157885081,"Current revenues plus indexation"]
["Forecast to asset transfer to OFTO in 2020/21",null,null,null,null,null,null,null,103.2,"National Grid Forecast"]
[null,null,null,null,null,null,null,63.923596817553772]
["Forecast to asset transfer to OFTO in 2021/22",null,null,null,null,null,null,null,38.700000000000003,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",{"$f":"SUM(B6:B28)","v":218.38037349491282},248.35699921993759,260.78931257200446,265.53230168097656,317.94499958173537,{"$f":"SUM(G6:G28)","v":390.59670575851976},443.77038581741465,{"$f":"SUM(I6:I29)","v":545.58273489975329}," "]
[]
[]
["Notes:"]
["Figures for historic years represent National Grid's forecast of OFTO revenues at the time final tariffs were calculated for each charging year rather than our current best view."]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments are not included as they do not form part of OFTO Maximum Revenue"]