{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Index","Residuals","T1","T2","T3","T4","T5","T6","T7","T8 & Fig 4","T9","T10","T10 A-Z","T11","T12","T13","T14","T15","T16","T17","T18","T20","T21","T22","T23","T24","T25","T26","T27"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":4,"defined_names":840,"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":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["INDEX"]
[{"$f":"Residuals!A1","v":"Residuals and Averages"}]
[{"$f":"'T1'!A1","v":"Table 1 - Summary of Demand Tariffs"}]
[{"$f":"'T2'!A1","v":"Table 2 - Demand Tariffs"}]
[{"$f":"'T3'!A1","v":"Table 3 - Change in HH Demand Tariffs"}]
[{"$f":"'T4'!A1","v":"Table 4 - Embedded Export Tariff"}]
[{"$f":"'T5'!A1","v":"Table 5 - NHH Demand Tariff Changes"}]
[{"$f":"'T6'!A1","v":"Table 6 - Changes to Average Tariffs"}]
[{"$f":"'T7'!A1","v":"Table 7 - Generation Wider Tariffs"}]
[{"$f":"'T8 & Fig 4'!A1","v":"Table 8 - Generation Tariff Changes"}]
[{"$f":"'T9'!A1","v":"Table 9 - Local Substation Tariffs"}]
[{"$f":"'T10'!A1","v":"Table 10 - Onshore Local Circuit Tariffs"}]
[{"$f":"'T11'!A1","v":"Table 11 - CMP203: Circuits subject to one-off charges"}]
[{"$f":"'T12'!A1","v":"Table 12 - Offshore Local Tariffs"}]
[{"$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'!A1","v":"Table 16 - Generation and Demand Revenue Proportions"}]
[{"$f":"'T17'!A1","v":"Table 17 - Charging Bases"}]
[{"$f":"'T18'!A1","v":"Table 18 - Residual Calculation"}]
["Table xx - Small Generator Discount: Not Applicable"]
[{"$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 - Annual Load Factors"}]
[{"$f":"'T24'!A1","v":"Table 24 - Generic Annual Load Factors"}]
[{"$f":"'T25'!A1","v":"Table 25 - Generation Contracted TEC Changes"}]
[{"$f":"'T26'!A1","v":"Table 26 - Indicative National Grid Revenue Forecast"}]
[{"$f":"'T27'!A1","v":"Table 27 - 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":"'T6'!B3","v":"2019/20 April"},{"$f":"'T6'!C3","v":"2019/20 June"},{"$f":"'T6'!D3","v":"Change since last forecast"}]
["Generation",{"$f":"'T6'!B4","v":-3.2912402716384728},{"$f":"'T6'!C4","v":-3.6130603651697655},{"$f":"'T6'!D4","v":-0.32182009353129271}]
["Demand",{"$f":"'T1'!C5","v":50.298596000000003},{"$f":"'T1'!D5","v":51.697066},{"$f":"'T1'!E5","v":1.3984699999999961}]
[]
["Average Tariff",{"$f":"B3","v":"2019/20 April"},{"$f":"C3","v":"2019/20 June"},{"$f":"D3","v":"Change since last forecast"}]
["Generation (£/kW)",{"$f":"'T6'!B5","v":6.0208320782492519},{"$f":"'T6'!C5","v":5.6112696379735949},{"$f":"'T6'!D5","v":-0.40956244027565702}," N.B. These generation average tariffs include local tariffs"]
["HH Demand (£/kW)",{"$f":"'T1'!C4","v":49.346251000000002},{"$f":"'T1'!D4","v":50.745111000000001},{"$f":"C9-B9","v":1.3988599999999991}]
["NHH Demand (p/kWh)",{"$f":"'T1'!C13","v":6.3747059999999998},{"$f":"'T1'!D13","v":6.5571590000000004},0.18245300000000064]
["Embedded Export (£/kW)",{"$f":"'T1'!C7","v":14.301062},{"$f":"'T1'!D7","v":14.306876000000001},5.814000000000874E-3]

{"sheet":"T1","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Summary of Demand Tariffs",null,null,null,"Return to Index"]
[]
[null,"HH Tariffs","2019/20 April","2019/20 June","Change"]
[null,"Average Tariff (£/kW)",49.346251000000002,50.745111000000001,1.3988599999999991]
[null,"Residual (£/kW)",50.298596000000003,51.697066,1.3984699999999961]
[null,"EET","2019/20 April","2019/20 June","Change"]
[null,"Average Tariff (£/kW)",14.301062,14.306876000000001,5.814000000000874E-3]
[null,"Phased residual (£/kW)",14.65,14.65,0]
[null,"AGIC (£/kW)",3.32,3.3272680000000001,7.2680000000002742E-3]
[null,"Embedded Export Volume (GW)",7.75280802278,7.75280802278,0]
[null,"Total Credit (£m)",110.87338762864964,110.9184626243141,4.5074995664464268E-2]
[null,"NHH Tariffs","2019/20 April","2019/20 June","Change"]
[null,"Average (p/kWh)",6.3747059999999998,6.5571590000000004,0.18245300000000064]

{"sheet":"T2","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Table 2 - 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",21.117249000000001,2.8425820000000002,0]
[2,"Southern Scotland",28.797132000000001,3.7698710000000002,0]
[3,"Northern",41.292129000000003,5.2453459999999996,7.5723310000000001]
[4,"North West",48.128953000000003,6.2402509999999998,14.409155]
[5,"Yorkshire",48.421348999999999,6.1628970000000001,14.701551]
[6,"N Wales & Mersey",49.711398000000003,6.2671039999999998,15.9916]
[7,"East Midlands",51.861094000000001,6.7940040000000002,18.141296000000001]
[8,"Midlands",53.158467000000002,7.0085810000000004,19.438669000000001]
[9,"Eastern",53.903967000000002,7.5183099999999996,20.184169000000001]
[10,"South Wales",50.052638999999999,5.9040379999999999,16.332840999999998]
[11,"South East",56.648128,8.0286880000000007,22.928329999999999]
[12,"London",59.762093,6.3384,26.042296]
[13,"Southern",57.828961999999997,7.6519500000000003,24.109165000000001]
[14,"South Western",56.141033999999998,7.8364690000000001,22.421236]
[]
["Residual charge for demand:",null,51.697065773793433]

{"sheet":"T3","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table 3 - Change in HH Demand Tariffs",null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","2019/20 April (£/kW)","2019/20 June (£/kW)","Change (£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",19.737006000000001,21.117249000000001,{"$f":"D4-C4","v":1.3802430000000001},1.3984697737934297]
[2,"Southern Scotland",27.418724000000001,28.797132000000001,{"$f":"D5-C5","v":1.3784080000000003},1.3984697737934297]
[3,"Northern",39.892709000000004,41.292129000000003,1.3994199999999992,1.3984697737934297]
[4,"North West",46.722382000000003,48.128953000000003,1.4065709999999996,1.3984697737934297]
[5,"Yorkshire",47.014046,48.421348999999999,1.4073029999999989,1.3984697737934297]
[6,"N Wales & Mersey",48.298681000000002,49.711398000000003,1.4127170000000007,1.3984697737934297]
[7,"East Midlands",50.452343999999997,51.861094000000001,1.4087500000000048,1.3984697737934297]
[8,"Midlands",51.752366000000002,53.158467000000002,1.4061009999999996,1.3984697737934297]
[9,"Eastern",52.491084999999998,53.903967000000002,1.4128820000000033,1.3984697737934297]
[10,"South Wales",48.660552000000003,50.052638999999999,1.3920869999999965,1.3984697737934297]
[11,"South East",55.225293000000001,56.648128,1.4228349999999992,1.3984697737934297]
[12,"London",58.34778,59.762093,1.4143129999999999,1.3984697737934297]
[13,"Southern",56.468265000000002,57.828961999999997,1.3606969999999947,1.3984697737934297]
[14,"South Western",54.806629000000001,56.141033999999998,1.3344049999999967,1.3984697737934297]
[]
[]
["Zone","Peak (£/kW)","Year Round (£/kW)","Residual £/kW","Small Gen Discount (£/kW)","2019/20 June (£/kW)"]
[1,-2.0412450726915945,-28.538571553183434,51.697065773793433,0,{"$f":"ROUND(SUM(B21+C21+D21+E21),6)","v":21.117249000000001}]
[2,-2.2447355247916572,-20.655198530507644,51.697065773793433,0,{"$f":"ROUND(SUM(B22+C22+D22+E22),6)","v":28.797132000000001}]
[3,-3.5788331008029823,-6.8261039729431099,51.697065773793433,0,41.292129000000003]
[4,-1.1241210081862911,-2.4439919678877691,51.697065773793433,0,48.128953000000003]
[5,-2.8392059564937848,-0.4365107434962272,51.697065773793433,0,48.421348999999999]
[6,-2.2595580255543681,0.27389003167399151,51.697065773793433,0,49.711398000000003]
[7,-2.1589022108686726,2.3229301509767084,51.697065773793433,0,51.861094000000001]
[8,-1.4363065432233166,2.8977073584640296,51.697065773793433,0,53.158467000000002]
[9,1.359902704818573,0.84699833211192366,51.697065773793433,0,53.903967000000002]
[10,-6.14432423759615,4.4998972270102957,51.697065773793433,0,50.052638999999999]
[11,4.2137715826503959,0.73729069342247833,51.697065773793433,0,56.648128]
[12,5.6561897422208647,2.4088378639300796,51.697065773793433,0,59.762093]
[13,1.8169245291263321,4.314971979340263,51.697065773793433,0,57.828961999999997]
[14,-0.95592019244338344,5.3998883713837156,51.697065773793433,0,56.141033999999998]

{"sheet":"T4","index":5,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table 4 - Embedded Export Tariff",null,null,null,"Return to Index"]
[]
[]
["Zone","Zone Name","2019/20 April (£/kW)","2019/20 June (£/kW)","Change (£/kW)"]
[1,"Northern Scotland",0,0,{"$f":"D5-C5","v":0}]
[2,"Southern Scotland",0,0,{"$f":"D6-C6","v":0}]
[3,"Northern",7.5641129999999999,7.5723310000000001,8.2180000000002806E-3]
[4,"North West",14.393786,14.409155,1.5368999999999744E-2]
[5,"Yorkshire",14.685451,14.701551,1.6099999999999781E-2]
[6,"N Wales & Mersey",15.970084999999999,15.9916,2.1515000000000839E-2]
[7,"East Midlands",18.123747999999999,18.141296000000001,1.7548000000001451E-2]
[8,"Midlands",19.423770000000001,19.438669000000001,1.4898999999999774E-2]
[9,"Eastern",20.162489000000001,20.184169000000001,2.1679999999999922E-2]
[10,"South Wales",16.331956000000002,16.332840999999998,8.8499999999669399E-4]
[11,"South East",22.896697,22.928329999999999,3.1632999999999356E-2]
[12,"London",26.019183999999999,26.042296,2.3112000000001132E-2]
[13,"Southern",24.139669000000001,24.109165000000001,-3.0504000000000531E-2]
[14,"South Western",22.478033,22.421236,-5.6796999999999542E-2]
[]
["Zone","EET Locational £/kW","AGIC £/kW","2019/20 Phased Residual £/kW ","Final Tariff £/kW","EET Revenue £m"]
[1,-30.579816625875029,3.3272680000000001,14.65,0,0]
[2,-22.899934055299301,3.3272680000000001,14.65,0,0]
[3,-10.404937073746092,3.3272680000000001,14.65,7.5723310000000001,3.3215969211101299]
[4,-3.56811297607406,3.3272680000000001,14.65,14.409155,5.9094827614379657]
[5,-3.2757166999900118,3.3272680000000001,14.65,14.701551,11.871998668345048]
[6,-1.9856679938803765,3.3272680000000001,14.65,15.9916,8.8024041489550005]
[7,0.16402794010803579,3.3272680000000001,14.65,18.141296000000001,11.595796604789083]
[8,1.461400815240713,3.3272680000000001,14.65,19.438669000000001,6.513742303723963]
[9,2.2069010369304967,3.3272680000000001,14.65,20.184169000000001,16.262233265628627]
[10,-1.6444270105858543,3.3272680000000001,14.65,16.332840999999998,8.3248583081253802]
[11,4.9510622760728742,3.3272680000000001,14.65,22.928329999999999,9.4217915318058409]
[12,8.0650276061509452,3.3272680000000001,14.65,26.042296,4.4488326702562828]
[13,6.1318965084665953,3.3272680000000001,14.65,24.109165000000001,16.699788036632729]
[14,4.4439681789403318,3.3272680000000001,14.65,22.421236,7.7459374035040538]

{"sheet":"T5","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 5 - NHH Demand Tariff Changes",null,null,"Return to Index"]
[]
["Zone","Zone Name","2019/20 April (p/kWh)","2019/20 June (p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",2.6567880000000001,2.8425820000000002,{"$f":"D4-C4","v":0.18579400000000001}]
[2,"Southern Scotland",3.5894219999999999,3.7698710000000002,{"$f":"D5-C5","v":0.1804490000000003}]
[3,"Northern",5.067577,5.2453459999999996,0.17776899999999962]
[4,"North West",6.0578789999999998,6.2402509999999998,0.18237199999999998]
[5,"Yorkshire",5.9837809999999996,6.1628970000000001,0.1791160000000005]
[6,"N Wales & Mersey",6.0890029999999999,6.2671039999999998,0.17810099999999984]
[7,"East Midlands",6.6094530000000002,6.7940040000000002,0.18455099999999991]
[8,"Midlands",6.8231960000000003,7.0085810000000004,0.18538500000000013]
[9,"Eastern",7.3212469999999996,7.5183099999999996,0.19706299999999999]
[10,"South Wales",5.7398319999999998,5.9040379999999999,0.16420600000000007]
[11,"South East",7.8270309999999998,8.0286880000000007,0.20165700000000086]
[12,"London",6.1883970000000001,6.3384,0.15000299999999989]
[13,"Southern",7.471902,7.6519500000000003,0.18004800000000021]
[14,"South Western",7.6502049999999997,7.8364690000000001,0.18626400000000043]

{"sheet":"T6","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Table 6 - Changes to Average Tariffs",null,null,null,null,"Return to Index"]
[]
["Generation Tariffs (£/kW)","2019/20 April","2019/20 June","Change since last forecast"]
["Residual",-3.2912402716384728,-3.6130603651697655,{"$f":"C4-B4","v":-0.32182009353129271}]
["Average Generation Tariff",6.0208320782492519,5.6112696379735949,{"$f":"C5-B5","v":-0.40956244027565702},"N.B. These generation average tariffs include local tariffs"]

{"sheet":"T7","index":8,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[32,6,32,7],[1,6,1,8]]}
["Table 7 - Generation Wider Tariffs",null,null,null,null,null,null,null,"Return to Index"]
[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",2.6334780000000002,17.866047999999999,16.290564,-3.6130599999999999,26.345707599999997,29.6038204,19.823923199999999]
[2,"East Aberdeenshire",4.85642,10.389875999999999,16.290564,-3.6130599999999999,22.587712,25.845824799999999,16.833454399999997]
[3,"Western Highlands",2.0662050000000001,18.018719000000001,16.300922,-3.6130599999999999,25.908857800000003,29.169042199999996,19.895349599999999]
[4,"Skye and Lochalsh",-4.0508990000000002,18.018719000000001,16.185831,-3.6130599999999999,19.699680999999998,22.936847199999999,19.7802586]
[5,"Eastern Grampian and Tayside",3.028972,15.552842,15.695182000000001,-3.6130599999999999,24.414331199999999,27.553367599999998,18.303258799999998]
[6,"Central Grampian",3.703503,14.842848999999999,15.388225,-3.6130599999999999,24.275302200000002,27.352947199999999,17.7123046]
[7,"Argyll",3.318511,11.768129999999999,25.125685000000001,-3.6130599999999999,29.220503000000004,34.245640000000002,26.219877]
[8,"The Trossachs",3.6058870000000001,11.768129999999999,13.992946999999999,-3.6130599999999999,20.601688599999999,23.400277999999997,15.087138999999997]
[9,"Stirlingshire and Fife",2.379372,8.968928,13.155213,-3.6130599999999999,16.465624800000001,19.096667399999998,13.129724199999998]
[10,"South West Scotlands",2.4320170000000001,9.5291420000000002,13.296531999999999,-3.6130599999999999,17.079496199999998,19.7388026,13.4951288]
[11,"Lothian and Borders",3.6496240000000002,9.5291420000000002,7.4378380000000002,-3.6130599999999999,13.610147999999999,15.097715600000001,7.6364348000000009]
[12,"Solway and Cheviot",1.965527,5.3941910000000002,7.5050100000000004,-3.6130599999999999,8.6718278000000026,10.172829799999999,6.0496264000000002]
[13,"North East England",3.8859560000000002,3.0151500000000002,3.943079,-3.6130599999999999,5.8394792000000004,6.6280949999999992,1.536079]
[14,"North Lancashire and The Lakes",1.5909329999999999,3.0151500000000002,2.657327,-3.6130599999999999,2.5158546000000008,3.04732,0.25032700000000041]
[15,"South Lancashire, Yorkshire and Humber",4.4769690000000004,0.78319700000000003,0.117564,-3.6130599999999999,1.5845178000000004,1.6080306000000002,-3.1822171999999997]
[16,"North Midlands and North Wales",3.942682,-0.83048999999999995,0,-3.6130599999999999,-0.33476999999999979,-0.33476999999999979,-3.9452560000000001]
[17,"South Lincolnshire and North Norfolk",2.1194700000000002,-0.474296,0,-3.6130599999999999,-1.8730267999999999,-1.8730267999999999,-3.8027783999999998]
[18,"Mid Wales and The Midlands",1.2087460000000001,-0.24253,0,-3.6130599999999999,-2.598338,-2.598338,-3.7100719999999998]
[19,"Anglesey and Snowdon",4.4401109999999999,-0.65047600000000005,0,-3.6130599999999999,0.30667020000000011,0.30667020000000011,-3.8732503999999999]
[20,"Pembrokeshire",9.1871419999999997,-4.5171010000000003,0,-3.6130599999999999,1.9604011999999988,1.9604011999999988,-5.4199004000000004]
[21,"South Wales & Gloucester",6.185924,-4.4903729999999999,0,-3.6130599999999999,-1.0194344000000002,-1.0194344000000002,-5.4092092000000003]
[22,"Cotswold",3.0409639999999998,2.258661,-6.7257910000000001,-3.6130599999999999,-4.1458000000000004,-5.4909581999999997,-9.4353866000000011]
[23,"Central London",-5.7650600000000001,2.258661,-6.6130560000000003,-3.6130599999999999,-12.861636000000001,-14.184247200000001,-9.3226516000000004]
[24,"Essex and Kent",-4.0896299999999997,2.258661,0,-3.6130599999999999,-5.895761199999999,-5.895761199999999,-2.7095956000000001]
[25,"Oxfordshire, Surrey and Sussex",-1.5677810000000001,-2.95112,0,-3.6130599999999999,-7.5417369999999995,-7.5417369999999995,-4.7935080000000001]
[26,"Somerset and Wessex",-1.4077310000000001,-4.1138979999999998,0,-3.6130599999999999,-8.3119094000000011,-8.3119094000000011,-5.2586192]
[27,"West Devon and Cornwall",0.103405,-5.6777040000000003,0,-3.6130599999999999,-8.0518181999999996,-8.0518181999999996,-5.8841415999999995]

{"sheet":"T8 & Fig 4","index":9,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,3,11],[4,2,4,4],[4,8,4,10],[4,11,5,11],[0,0,0,10],[4,5,4,7]]}
["Table 8 - Generation Tariff Changes",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
[]
["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","2019/20 April (£/kW)","2019/20 June (£/kW)","Change (£/kW)","2019/20 April (£/kW)","2019/20 June (£/kW)","Change (£/kW)","2019/20 April (£/kW)","2019/20 June (£/kW)","Change (£/kW)"]
[1,"North Scotland",26.657823,26.345707599999997,{"$f":"D7-C7","v":-0.31211540000000326},29.926952,29.6038204,{"$f":"G7-F7","v":-0.32313159999999996},20.168315,19.823923199999999,{"$f":"J7-I7","v":-0.34439180000000036},-0.32182036516976531]
[2,"East Aberdeenshire",22.8946422,22.587712,{"$f":"D8-C8","v":-0.30693020000000004},26.163771199999999,25.845824799999999,{"$f":"G8-F8","v":-0.3179464000000003},17.175398600000001,16.833454399999997,{"$f":"J8-I8","v":-0.34194420000000392},-0.32182036516976531]
[3,"Western Highlands",26.220525000000002,25.908857800000003,-0.3116671999999987,29.491709999999998,29.169042199999996,-0.32266780000000139,20.239207,19.895349599999999,-0.34385740000000098,-0.32182036516976531]
[4,"Skye and Lochalsh",20.010278,19.699680999999998,-0.31059700000000134,23.258369000000002,22.936847199999999,-0.32152180000000286,20.123736999999998,19.7802586,-0.34347839999999863,-0.32182036516976531]
[5,"Eastern Grampian and Tayside",24.734248000000001,24.414331199999999,-0.31991680000000144,27.883822600000002,27.553367599999998,-0.33045500000000416,18.641037799999999,18.303258799999998,-0.33777900000000116,-0.32182036516976531]
[6,"Central Grampian",24.594900800000005,24.275302200000002,-0.31959860000000262,27.679658799999999,27.352947199999999,-0.32671159999999944,18.017112400000002,17.7123046,-0.30480780000000252,-0.32182036516976531]
[7,"Argyll",31.033503000000003,29.220503000000004,-1.8129999999999988,36.480863400000004,34.245640000000002,-2.2352234000000024,28.629747200000004,26.219877,-2.4098702000000038,-0.32182036516976531]
[8,"The Trossachs",20.906191399999997,20.601688599999999,-0.30450279999999808,23.718589399999999,23.400277999999997,-0.31831140000000246,15.4549352,15.087138999999997,-0.36779620000000257,-0.32182036516976531]
[9,"Stirlingshire and Fife",16.773730999999998,16.465624800000001,-0.30810619999999744,19.411293200000003,19.096667399999998,-0.31462580000000528,13.461078600000002,13.129724199999998,-0.33135440000000393,-0.32182036516976531]
[10,"South West Scotlands",17.365251000000001,17.079496199999998,-0.28575480000000297,20.031466999999999,19.7388026,-0.2926643999999996,13.821,13.4951288,-0.32587119999999992,-0.32182036516976531]
[11,"Lothian and Borders",13.941138,13.610147999999999,-0.33099000000000167,15.440879000000001,15.097715600000001,-0.3431633999999999,7.9886250000000008,7.6364348000000009,-0.3521901999999999,-0.32182036516976531]
[12,"Solway and Cheviot",9.0345643999999989,8.6718278000000026,-0.3627365999999963,10.545061199999999,10.172829799999999,-0.37223140000000043,6.4195036000000005,6.0496264000000002,-0.36987720000000035,-0.32182036516976531]
[13,"North East England",6.1632347999999997,5.8394792000000004,-0.32375559999999926,6.9527205999999993,6.6280949999999992,-0.32462560000000007,1.8599877999999999,1.536079,-0.32390879999999989,-0.32182036516976531]
[14,"North Lancashire and The Lakes",2.8427735999999992,2.5158546000000008,-0.32691899999999841,3.3760886000000001,3.04732,-0.32876860000000008,0.57913380000000014,0.25032700000000041,-0.32880679999999973,-0.32182036516976531]
[15,"South Lancashire, Yorkshire and Humber",1.9143587999999996,1.5845178000000004,-0.32984099999999916,1.9379013999999994,1.6080306000000002,-0.32987079999999924,-2.8580078000000002,-3.1822171999999997,-0.32420939999999954,-0.32182036516976531]
[16,"North Midlands and North Wales",-2.1355999999999042E-3,-0.33476999999999979,-0.33263439999999989,-2.1355999999999042E-3,-0.33476999999999979,-0.33263439999999989,-3.6197848000000001,-3.9452560000000001,-0.32547119999999996,-0.32182036516976531]
[17,"South Lincolnshire and North Norfolk",-1.5402922000000003,-1.8730267999999999,-0.33273459999999955,-1.5402922000000003,-1.8730267999999999,-0.33273459999999955,-3.4778256000000001,-3.8027783999999998,-0.32495279999999971,-0.32182036516976531]
[18,"Mid Wales and The Midlands",-2.2677172000000003,-2.598338,-0.33062079999999971,-2.2677172000000003,-2.598338,-0.33062079999999971,-3.3875396000000002,-3.7100719999999998,-0.32253239999999961,-0.32182036516976531]
[19,"Anglesey and Snowdon",0.64293400000000034,0.30667020000000011,-0.33626380000000022,0.64293400000000034,0.30667020000000011,-0.33626380000000022,-3.5455380000000001,-3.8732503999999999,-0.32771239999999979,-0.32182036516976531]
[20,"Pembrokeshire",2.2780249999999995,1.9604011999999988,-0.31762380000000068,2.2780249999999995,1.9604011999999988,-0.31762380000000068,-5.0981940000000003,-5.4199004000000004,-0.32170640000000006,-0.32182036516976531]
[21,"South Wales & Gloucester",-0.70465980000000084,-1.0194344000000002,-0.31477459999999935,-0.70465980000000084,-1.0194344000000002,-0.31477459999999935,-5.0880584000000004,-5.4092092000000003,-0.32115079999999985,-0.32182036516976531]
[22,"Cotswold",-3.8333348000000007,-4.1458000000000004,-0.31246519999999967,-5.1814886000000007,-5.4909581999999997,-0.30946959999999901,-9.1236777999999994,-9.4353866000000011,-0.31170880000000167,-0.32182036516976531]
[23,"Central London",-12.526722999999999,-12.861636000000001,-0.33491300000000201,-13.849813599999999,-14.184247200000001,-0.33443360000000233,-8.9983617999999996,-9.3226516000000004,-0.32428980000000074,-0.32182036516976531]
[24,"Essex and Kent",-5.5568786000000001,-5.895761199999999,-0.33888259999999892,-5.5568786000000001,-5.895761199999999,-0.33888259999999892,-2.3829088,-2.7095956000000001,-0.32668680000000005,-0.32182036516976531]
[25,"Oxfordshire, Surrey and Sussex",-7.1996666000000005,-7.5417369999999995,-0.342070399999999,-7.1996666000000005,-7.5417369999999995,-0.342070399999999,-4.4847828000000005,-4.7935080000000001,-0.30872519999999959,-0.32182036516976531]
[26,"Somerset and Wessex",-8.0751811999999994,-8.3119094000000011,-0.23672820000000172,-8.0751811999999994,-8.3119094000000011,-0.23672820000000172,-4.9793555999999999,-5.2586192,-0.27926360000000017,-0.32182036516976531]
[27,"West Devon and Cornwall",-7.8182494,-8.0518181999999996,-0.23356879999999958,-7.8182494,-8.0518181999999996,-0.23356879999999958,-5.5810551999999998,-5.8841415999999995,-0.30308639999999976,-0.32182036516976531]
[]
["Figure 4 - Variation in Generation Zonal Tariffs"]

{"sheet":"T9","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,4,1],[2,0,2,4],[3,2,4,2],[3,3,4,3],[3,4,4,4]]}
["Table 9 - Local Substation Tariffs",null,null,null,"Return to Index"]
[]
["2019/20 Local Substation Tariff (£/kW)"]
["Substation\nRating","Connection\nType","132kV","275kV","400kV"]
[]
["<1320 MW","No redundancy",0.197964,0.113248,8.1598000000000004E-2]
["<1320 MW","Redundancy",0.43609799999999999,0.26981699999999997,0.19623199999999999]
[">=1320 MW","No redundancy",0,0.35508299999999998,0.256797]
[">=1320 MW","Redundancy",0,0.582955,0.42550900000000003]

{"sheet":"T10","index":11,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 10 - Onshore Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",4.232856,"Dunlaw Extension",1.4797499999999999,"Lochay",0.36081999999999997]
["Aigas",0.644872,"Dunhill",1.412272,"Luichart",0.56547400000000003]
["An Suidhe",-0.94106999999999996,"Dumnaglass",1.830606,"Mark Hill",0.86331100000000005]
["Arecleoch",2.0478710000000002,"Edinbane",6.7480669999999998,"Marchwood",0.37631399999999998]
["Baglan Bay",0.75011499999999998,"Ewe Hill",1.354956,"Millennium Wind ",1.8007850000000001]
["Beinneun Wind Farm",1.480947,"Fallago",0.199323,"Moffat",0.169407]
["Bhlaraidh Wind Farm",0.64882200000000001,"Farr",3.5155069999999999,"Mossford",0.44192100000000001]
["Black Hill",1.531255,"Fernoch",4.3371040000000001,"Nant",-1.2112879999999999]
["BlackCraig Wind Farm",6.2069460000000003,"Ffestiniogg",0.24945700000000001,"Necton",-0.36216399999999999]
["Black Law",1.722917,"Finlarig",0.315718,"Rhigos",0.10037]
["BlackLaw Extension",3.6536680000000001,"Foyers",0.742448,"Rocksavage",1.7455999999999999E-2]
["Carrington",-3.2834000000000002E-2,"Galawhistle",1.458315,"Saltend",0.33621000000000001]
["Clyde (North)",0.10813200000000001,"Glendoe",1.813672,"South Humber Bank",0.93423]
["Clyde (South)",0.12504899999999999,"Glenglass",2.9383530000000002,"Spalding",0.277642]
["Corriegarth",3.108511,"Gordonbush",0.196905,"Strathbrora",6.9948999999999997E-2]
["Corriemoillie",1.64046,"Griffin Wind",9.5667690000000007,"Stronelairg",1.417537]
["Coryton",5.1513000000000003E-2,"Hadyard Hill",2.7291530000000002,"Strathy Wind",2.0289169999999999]
["Cruachan",1.8653759999999999,"Harestanes",2.4741469999999999,"Wester Dod",0.36885499999999999]
["Crystal Rig",3.3341999999999997E-2,"Hartlepool",0.59202100000000002,"Whitelee",0.104644]
["Culligran",1.7089270000000001,"Hedon",0.17841899999999999,"Whitelee Extension",0.29091]
["Deanie",2.8075230000000002,"Invergarry",1.3990069999999999,"Gills Bay",2.4831159999999999]
["Dersalloch",2.375095,"Kilgallioch",1.0377179999999999,"Kype Muir",1.4624919999999999]
["Didcot",0.51526499999999997,"Kilmorack",0.19472900000000001,"Middle Muir",1.9544429999999999]
["Dinorwig",2.3656999999999999,"Langage",0.648563,"Dorenell",2.0692629999999999]
["Millennium South",0.92849199999999998,"Aberdeen Bay",2.5708440000000001,"Killingholme",0.70074199999999998]
["Middleton",0.10978499999999999]

{"sheet":"T10 A-Z","index":12,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 10 - Onshore Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",{"$f":"IF(ISNA(VLOOKUP(A4,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A4,'T10'!$E$4:$F$29,2,0),VLOOKUP(A4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A4,'T10'!$A$4:$B$29,2,0))","v":4.232856},"Dumnaglass",{"$f":"IF(ISNA(VLOOKUP(C4,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C4,'T10'!$E$4:$F$29,2,0),VLOOKUP(C4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C4,'T10'!$A$4:$B$29,2,0))","v":1.830606},"Langage",{"$f":"IF(ISNA(VLOOKUP(E4,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E4,'T10'!$E$4:$F$29,2,0),VLOOKUP(E4,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E4,'T10'!$A$4:$B$29,2,0))","v":0.648563}]
["Aberdeen Bay",{"$f":"IF(ISNA(VLOOKUP(A5,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A5,'T10'!$E$4:$F$29,2,0),VLOOKUP(A5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A5,'T10'!$A$4:$B$29,2,0))","v":2.5708440000000001},"Dunhill",{"$f":"IF(ISNA(VLOOKUP(C5,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C5,'T10'!$E$4:$F$29,2,0),VLOOKUP(C5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C5,'T10'!$A$4:$B$29,2,0))","v":1.412272},"Lochay",{"$f":"IF(ISNA(VLOOKUP(E5,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E5,'T10'!$E$4:$F$29,2,0),VLOOKUP(E5,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E5,'T10'!$A$4:$B$29,2,0))","v":0.36081999999999997}]
["Aigas",{"$f":"IF(ISNA(VLOOKUP(A6,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A6,'T10'!$E$4:$F$29,2,0),VLOOKUP(A6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A6,'T10'!$A$4:$B$29,2,0))","v":0.644872},"Dunlaw Extension",{"$f":"IF(ISNA(VLOOKUP(C6,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C6,'T10'!$E$4:$F$29,2,0),VLOOKUP(C6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C6,'T10'!$A$4:$B$29,2,0))","v":1.4797499999999999},"Luichart",{"$f":"IF(ISNA(VLOOKUP(E6,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E6,'T10'!$E$4:$F$29,2,0),VLOOKUP(E6,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E6,'T10'!$A$4:$B$29,2,0))","v":0.56547400000000003}]
["An Suidhe",{"$f":"IF(ISNA(VLOOKUP(A7,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A7,'T10'!$E$4:$F$29,2,0),VLOOKUP(A7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A7,'T10'!$A$4:$B$29,2,0))","v":-0.94106999999999996},"Edinbane",{"$f":"IF(ISNA(VLOOKUP(C7,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C7,'T10'!$E$4:$F$29,2,0),VLOOKUP(C7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C7,'T10'!$A$4:$B$29,2,0))","v":6.7480669999999998},"Marchwood",{"$f":"IF(ISNA(VLOOKUP(E7,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E7,'T10'!$E$4:$F$29,2,0),VLOOKUP(E7,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E7,'T10'!$A$4:$B$29,2,0))","v":0.37631399999999998}]
["Arecleoch",{"$f":"IF(ISNA(VLOOKUP(A8,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A8,'T10'!$E$4:$F$29,2,0),VLOOKUP(A8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A8,'T10'!$A$4:$B$29,2,0))","v":2.0478710000000002},"Ewe Hill",{"$f":"IF(ISNA(VLOOKUP(C8,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C8,'T10'!$E$4:$F$29,2,0),VLOOKUP(C8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C8,'T10'!$A$4:$B$29,2,0))","v":1.354956},"Mark Hill",{"$f":"IF(ISNA(VLOOKUP(E8,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E8,'T10'!$E$4:$F$29,2,0),VLOOKUP(E8,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E8,'T10'!$A$4:$B$29,2,0))","v":0.86331100000000005}]
["Baglan Bay",{"$f":"IF(ISNA(VLOOKUP(A9,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A9,'T10'!$E$4:$F$29,2,0),VLOOKUP(A9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A9,'T10'!$A$4:$B$29,2,0))","v":0.75011499999999998},"Fallago",{"$f":"IF(ISNA(VLOOKUP(C9,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C9,'T10'!$E$4:$F$29,2,0),VLOOKUP(C9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C9,'T10'!$A$4:$B$29,2,0))","v":0.199323},"Middle Muir",{"$f":"IF(ISNA(VLOOKUP(E9,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E9,'T10'!$E$4:$F$29,2,0),VLOOKUP(E9,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E9,'T10'!$A$4:$B$29,2,0))","v":1.9544429999999999}]
["Beinneun Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A10,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A10,'T10'!$E$4:$F$29,2,0),VLOOKUP(A10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A10,'T10'!$A$4:$B$29,2,0))","v":1.480947},"Farr",{"$f":"IF(ISNA(VLOOKUP(C10,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C10,'T10'!$E$4:$F$29,2,0),VLOOKUP(C10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C10,'T10'!$A$4:$B$29,2,0))","v":3.5155069999999999},"Middleton",{"$f":"IF(ISNA(VLOOKUP(E10,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E10,'T10'!$E$4:$F$29,2,0),VLOOKUP(E10,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E10,'T10'!$A$4:$B$29,2,0))","v":0.10978499999999999}]
["Bhlaraidh Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A11,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A11,'T10'!$E$4:$F$29,2,0),VLOOKUP(A11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A11,'T10'!$A$4:$B$29,2,0))","v":0.64882200000000001},"Fernoch",{"$f":"IF(ISNA(VLOOKUP(C11,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C11,'T10'!$E$4:$F$29,2,0),VLOOKUP(C11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C11,'T10'!$A$4:$B$29,2,0))","v":4.3371040000000001},"Millennium South",{"$f":"IF(ISNA(VLOOKUP(E11,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E11,'T10'!$E$4:$F$29,2,0),VLOOKUP(E11,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E11,'T10'!$A$4:$B$29,2,0))","v":0.92849199999999998}]
["Black Hill",{"$f":"IF(ISNA(VLOOKUP(A12,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A12,'T10'!$E$4:$F$29,2,0),VLOOKUP(A12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A12,'T10'!$A$4:$B$29,2,0))","v":1.531255},"Ffestiniogg",{"$f":"IF(ISNA(VLOOKUP(C12,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C12,'T10'!$E$4:$F$29,2,0),VLOOKUP(C12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C12,'T10'!$A$4:$B$29,2,0))","v":0.24945700000000001},"Millennium Wind ",{"$f":"IF(ISNA(VLOOKUP(E12,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E12,'T10'!$E$4:$F$29,2,0),VLOOKUP(E12,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E12,'T10'!$A$4:$B$29,2,0))","v":1.8007850000000001}]
["Black Law",{"$f":"IF(ISNA(VLOOKUP(A13,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A13,'T10'!$E$4:$F$29,2,0),VLOOKUP(A13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A13,'T10'!$A$4:$B$29,2,0))","v":1.722917},"Finlarig",{"$f":"IF(ISNA(VLOOKUP(C13,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C13,'T10'!$E$4:$F$29,2,0),VLOOKUP(C13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C13,'T10'!$A$4:$B$29,2,0))","v":0.315718},"Moffat",{"$f":"IF(ISNA(VLOOKUP(E13,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E13,'T10'!$E$4:$F$29,2,0),VLOOKUP(E13,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E13,'T10'!$A$4:$B$29,2,0))","v":0.169407}]
["BlackCraig Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A14,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A14,'T10'!$E$4:$F$29,2,0),VLOOKUP(A14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A14,'T10'!$A$4:$B$29,2,0))","v":6.2069460000000003},"Foyers",{"$f":"IF(ISNA(VLOOKUP(C14,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C14,'T10'!$E$4:$F$29,2,0),VLOOKUP(C14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C14,'T10'!$A$4:$B$29,2,0))","v":0.742448},"Mossford",{"$f":"IF(ISNA(VLOOKUP(E14,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E14,'T10'!$E$4:$F$29,2,0),VLOOKUP(E14,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E14,'T10'!$A$4:$B$29,2,0))","v":0.44192100000000001}]
["BlackLaw Extension",{"$f":"IF(ISNA(VLOOKUP(A15,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A15,'T10'!$E$4:$F$29,2,0),VLOOKUP(A15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A15,'T10'!$A$4:$B$29,2,0))","v":3.6536680000000001},"Galawhistle",{"$f":"IF(ISNA(VLOOKUP(C15,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C15,'T10'!$E$4:$F$29,2,0),VLOOKUP(C15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C15,'T10'!$A$4:$B$29,2,0))","v":1.458315},"Nant",{"$f":"IF(ISNA(VLOOKUP(E15,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E15,'T10'!$E$4:$F$29,2,0),VLOOKUP(E15,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E15,'T10'!$A$4:$B$29,2,0))","v":-1.2112879999999999}]
["Carrington",{"$f":"IF(ISNA(VLOOKUP(A16,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A16,'T10'!$E$4:$F$29,2,0),VLOOKUP(A16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A16,'T10'!$A$4:$B$29,2,0))","v":-3.2834000000000002E-2},"Gills Bay",{"$f":"IF(ISNA(VLOOKUP(C16,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C16,'T10'!$E$4:$F$29,2,0),VLOOKUP(C16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C16,'T10'!$A$4:$B$29,2,0))","v":2.4831159999999999},"Necton",{"$f":"IF(ISNA(VLOOKUP(E16,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E16,'T10'!$E$4:$F$29,2,0),VLOOKUP(E16,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E16,'T10'!$A$4:$B$29,2,0))","v":-0.36216399999999999}]
["Clyde (North)",{"$f":"IF(ISNA(VLOOKUP(A17,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A17,'T10'!$E$4:$F$29,2,0),VLOOKUP(A17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A17,'T10'!$A$4:$B$29,2,0))","v":0.10813200000000001},"Glendoe",{"$f":"IF(ISNA(VLOOKUP(C17,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C17,'T10'!$E$4:$F$29,2,0),VLOOKUP(C17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C17,'T10'!$A$4:$B$29,2,0))","v":1.813672},"Rhigos",{"$f":"IF(ISNA(VLOOKUP(E17,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E17,'T10'!$E$4:$F$29,2,0),VLOOKUP(E17,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E17,'T10'!$A$4:$B$29,2,0))","v":0.10037}]
["Clyde (South)",{"$f":"IF(ISNA(VLOOKUP(A18,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A18,'T10'!$E$4:$F$29,2,0),VLOOKUP(A18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A18,'T10'!$A$4:$B$29,2,0))","v":0.12504899999999999},"Glenglass",{"$f":"IF(ISNA(VLOOKUP(C18,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C18,'T10'!$E$4:$F$29,2,0),VLOOKUP(C18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C18,'T10'!$A$4:$B$29,2,0))","v":2.9383530000000002},"Rocksavage",{"$f":"IF(ISNA(VLOOKUP(E18,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E18,'T10'!$E$4:$F$29,2,0),VLOOKUP(E18,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E18,'T10'!$A$4:$B$29,2,0))","v":1.7455999999999999E-2}]
["Corriegarth",{"$f":"IF(ISNA(VLOOKUP(A19,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A19,'T10'!$E$4:$F$29,2,0),VLOOKUP(A19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A19,'T10'!$A$4:$B$29,2,0))","v":3.108511},"Gordonbush",{"$f":"IF(ISNA(VLOOKUP(C19,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C19,'T10'!$E$4:$F$29,2,0),VLOOKUP(C19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C19,'T10'!$A$4:$B$29,2,0))","v":0.196905},"Saltend",{"$f":"IF(ISNA(VLOOKUP(E19,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E19,'T10'!$E$4:$F$29,2,0),VLOOKUP(E19,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E19,'T10'!$A$4:$B$29,2,0))","v":0.33621000000000001}]
["Corriemoillie",{"$f":"IF(ISNA(VLOOKUP(A20,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A20,'T10'!$E$4:$F$29,2,0),VLOOKUP(A20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A20,'T10'!$A$4:$B$29,2,0))","v":1.64046},"Griffin Wind",{"$f":"IF(ISNA(VLOOKUP(C20,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C20,'T10'!$E$4:$F$29,2,0),VLOOKUP(C20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C20,'T10'!$A$4:$B$29,2,0))","v":9.5667690000000007},"South Humber Bank",{"$f":"IF(ISNA(VLOOKUP(E20,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E20,'T10'!$E$4:$F$29,2,0),VLOOKUP(E20,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E20,'T10'!$A$4:$B$29,2,0))","v":0.93423}]
["Coryton",{"$f":"IF(ISNA(VLOOKUP(A21,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A21,'T10'!$E$4:$F$29,2,0),VLOOKUP(A21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A21,'T10'!$A$4:$B$29,2,0))","v":5.1513000000000003E-2},"Hadyard Hill",{"$f":"IF(ISNA(VLOOKUP(C21,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C21,'T10'!$E$4:$F$29,2,0),VLOOKUP(C21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C21,'T10'!$A$4:$B$29,2,0))","v":2.7291530000000002},"Spalding",{"$f":"IF(ISNA(VLOOKUP(E21,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E21,'T10'!$E$4:$F$29,2,0),VLOOKUP(E21,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E21,'T10'!$A$4:$B$29,2,0))","v":0.277642}]
["Cruachan",{"$f":"IF(ISNA(VLOOKUP(A22,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A22,'T10'!$E$4:$F$29,2,0),VLOOKUP(A22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A22,'T10'!$A$4:$B$29,2,0))","v":1.8653759999999999},"Harestanes",{"$f":"IF(ISNA(VLOOKUP(C22,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C22,'T10'!$E$4:$F$29,2,0),VLOOKUP(C22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C22,'T10'!$A$4:$B$29,2,0))","v":2.4741469999999999},"Strathbrora",{"$f":"IF(ISNA(VLOOKUP(E22,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E22,'T10'!$E$4:$F$29,2,0),VLOOKUP(E22,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E22,'T10'!$A$4:$B$29,2,0))","v":6.9948999999999997E-2}]
["Crystal Rig",{"$f":"IF(ISNA(VLOOKUP(A23,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A23,'T10'!$E$4:$F$29,2,0),VLOOKUP(A23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A23,'T10'!$A$4:$B$29,2,0))","v":3.3341999999999997E-2},"Hartlepool",{"$f":"IF(ISNA(VLOOKUP(C23,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C23,'T10'!$E$4:$F$29,2,0),VLOOKUP(C23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C23,'T10'!$A$4:$B$29,2,0))","v":0.59202100000000002},"Strathy Wind",{"$f":"IF(ISNA(VLOOKUP(E23,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E23,'T10'!$E$4:$F$29,2,0),VLOOKUP(E23,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E23,'T10'!$A$4:$B$29,2,0))","v":2.0289169999999999}]
["Culligran",{"$f":"IF(ISNA(VLOOKUP(A24,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A24,'T10'!$E$4:$F$29,2,0),VLOOKUP(A24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A24,'T10'!$A$4:$B$29,2,0))","v":1.7089270000000001},"Hedon",{"$f":"IF(ISNA(VLOOKUP(C24,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C24,'T10'!$E$4:$F$29,2,0),VLOOKUP(C24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C24,'T10'!$A$4:$B$29,2,0))","v":0.17841899999999999},"Stronelairg",{"$f":"IF(ISNA(VLOOKUP(E24,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E24,'T10'!$E$4:$F$29,2,0),VLOOKUP(E24,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E24,'T10'!$A$4:$B$29,2,0))","v":1.417537}]
["Deanie",{"$f":"IF(ISNA(VLOOKUP(A25,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A25,'T10'!$E$4:$F$29,2,0),VLOOKUP(A25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A25,'T10'!$A$4:$B$29,2,0))","v":2.8075230000000002},"Invergarry",{"$f":"IF(ISNA(VLOOKUP(C25,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C25,'T10'!$E$4:$F$29,2,0),VLOOKUP(C25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C25,'T10'!$A$4:$B$29,2,0))","v":1.3990069999999999},"Wester Dod",{"$f":"IF(ISNA(VLOOKUP(E25,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E25,'T10'!$E$4:$F$29,2,0),VLOOKUP(E25,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E25,'T10'!$A$4:$B$29,2,0))","v":0.36885499999999999}]
["Dersalloch",{"$f":"IF(ISNA(VLOOKUP(A26,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A26,'T10'!$E$4:$F$29,2,0),VLOOKUP(A26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A26,'T10'!$A$4:$B$29,2,0))","v":2.375095},"Kilgallioch",{"$f":"IF(ISNA(VLOOKUP(C26,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C26,'T10'!$E$4:$F$29,2,0),VLOOKUP(C26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C26,'T10'!$A$4:$B$29,2,0))","v":1.0377179999999999},"Whitelee",{"$f":"IF(ISNA(VLOOKUP(E26,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E26,'T10'!$E$4:$F$29,2,0),VLOOKUP(E26,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E26,'T10'!$A$4:$B$29,2,0))","v":0.104644}]
["Didcot",{"$f":"IF(ISNA(VLOOKUP(A27,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A27,'T10'!$E$4:$F$29,2,0),VLOOKUP(A27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A27,'T10'!$A$4:$B$29,2,0))","v":0.51526499999999997},"Killingholme",{"$f":"IF(ISNA(VLOOKUP(C27,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C27,'T10'!$E$4:$F$29,2,0),VLOOKUP(C27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C27,'T10'!$A$4:$B$29,2,0))","v":0.70074199999999998},"Whitelee Extension",{"$f":"IF(ISNA(VLOOKUP(E27,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(E27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E27,'T10'!$E$4:$F$29,2,0),VLOOKUP(E27,'T10'!$C$4:$D$29,2,0)),VLOOKUP(E27,'T10'!$A$4:$B$29,2,0))","v":0.29091}]
["Dinorwig",{"$f":"IF(ISNA(VLOOKUP(A28,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A28,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A28,'T10'!$E$4:$F$29,2,0),VLOOKUP(A28,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A28,'T10'!$A$4:$B$29,2,0))","v":2.3656999999999999},"Kilmorack",{"$f":"IF(ISNA(VLOOKUP(C28,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C28,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C28,'T10'!$E$4:$F$29,2,0),VLOOKUP(C28,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C28,'T10'!$A$4:$B$29,2,0))","v":0.19472900000000001}]
["Dorenell",{"$f":"IF(ISNA(VLOOKUP(A29,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(A29,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A29,'T10'!$E$4:$F$29,2,0),VLOOKUP(A29,'T10'!$C$4:$D$29,2,0)),VLOOKUP(A29,'T10'!$A$4:$B$29,2,0))","v":2.0692629999999999},"Kype Muir",{"$f":"IF(ISNA(VLOOKUP(C29,'T10'!$A$4:$B$29,2,0)),IF(ISNA(VLOOKUP(C29,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C29,'T10'!$E$4:$F$29,2,0),VLOOKUP(C29,'T10'!$C$4:$D$29,2,0)),VLOOKUP(C29,'T10'!$A$4:$B$29,2,0))","v":1.4624919999999999}]

{"sheet":"T11","index":13,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 11 - 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"]

{"sheet":"T12","index":14,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3],[5,1,5,3]]}
["Table 12 - Offshore Local Tariffs",null,null,"Return to Index"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",7.9750719999999999,41.725569999999998,1.036103]
["Burbo Bank","Tariff will be published in November 2018"]
["Greater Gabbard",14.952322961002251,34.358965851182582,0]
["Gunfleet",17.259781,15.845829999999999,2.9616769999999999]
["Gwynt Y Mor",18.209536332782015,17.938642716301572,0]
["Humber Gateway",14.490628027529294,32.695686369280466,0]
["Lincs",14.904088309836,58.352912136159098,0]
["London Array",10.145604047789117,34.555362567033505,0]
["Ormonde",24.654641000000002,45.929285999999998,0.36601800000000001]
["Robin Rigg East",-0.45607799999999998,30.211238000000002,9.3638530000000006]
["Robin Rigg West",-0.45607799999999998,30.211238000000002,9.3638530000000006]
["Sheringham Shoal",23.820655642636375,27.936049039876004,0.60724759690944752]
["Thanet",18.14029487563289,33.801853385605099,0.81372997904454203]
["Walney 1",21.278123999999998,42.375328000000003,0]
["Walney 2",21.123373999999998,42.748657000000001,0]
["West of Duddon Sands",8.2106468422033565,40.514453942928284,0]
["Westermost Rough",17.288862873313519,29.245357569850661,0]

{"sheet":"T13","index":15,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 13 - Contracted and Modelled TEC",null,null,null,null,"Return to Index"]
[]
["(GW)","2018/19","2019/20 Initial Forecast","2019/20 April Forecast","2019/20 June Forecast","2019/20 Draft Tariffs","2019/20 Final Tariffs"]
["Contracted TEC",79.028809999999993,85.464610000000022,{"$f":"85938.76/1000","v":85.938759999999988},83.9]
["Modelled Best View TEC",79.028809999999993,77.680610000000016,{"$f":"77496.86/1000","v":77.496859999999998},77.7]
["Chargeable TEC",71.934310000000025,73.833610000000022,{"$f":"71711.76/1000","v":71.711759999999998},71.900000000000006]

{"sheet":"T14","index":16,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Table 14 - Interconnectors",null,null,null,null,null,"Return to Index"]
[]
["Interconnector","Site","Interconnected\nSystem","Generation\nZone","Transport Model (Generation MW) Peak","Transport Model (Generation MW) Year Round","Charging Base (Generation MW)"]
["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,1000,0]
["East - West","Connah's Quay 400kV","Republic of Ireland",16,0,505,0]
["Moyle","Auchencrosh 275kV","Northern Ireland",10,0,80,0]

{"sheet":"T15","index":17,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table 15 - Allowed Revenues",null,null,null,null,null,"Return to Index"]
[]
["£m Nominal Value","2018/19 TNUoS Revenue","2019/20 TNUoS Revenue"]
[null,{"$f":"'T26'!D5","v":"2018/19 (fixed forecast)"},{"$f":"'T26'!E5","v":"Initial Forecast"},{"$f":"'T26'!F5","v":"April Forecast"},{"$f":"'T26'!G5","v":"June Forecast"},{"$f":"'T26'!H5","v":"Nov Draft"},"Jan \n2019 Final"]
["National Grid"]
["Price controlled revenue",1653.9179700263246,1768.5197291650261,1728.1223686166347,1770.6013999438635]
["Less income from connections",44.002400999999999,41.882612399999999,44.002400999999999,44.002400999999999]
["Income from TNUoS",{"$f":"+B6-B7","v":1609.9155690263246},1726.6371167650261,1684.1199676166348,1726.5989989438635]
[]
["Scottish Power Transmission"]
["Price controlled revenue",364.83,404.5082414306442,404.5082414306442,{"$f":"D11","v":404.5082414306442}]
["Less income from connections",14.869146848602265,14.532127031019199,14.532127031019199,{"$f":"D12","v":14.532127031019199}]
["Income from TNUoS",{"$f":"+B11-B12","v":349.96085315139771},389.97611439962503,389.97611439962503,389.97611439962503]
[]
["SHE Transmission"]
["Price controlled revenue",369.81799999999998,352.85033470848703,352.85033470848703,{"$f":"D16","v":352.85033470848703}]
["Less income from connections",3.4071159999999998,3.4635076286130482,3.4635076286130482,{"$f":"D17","v":3.4635076286130482}]
["Income from TNUoS",{"$f":"+B16-B17","v":366.41088400000001},349.38682707987397,349.38682707987397,349.38682707987397]
[]
["Offshore",318.14381186500032,466.66162681762478,386.47878665563246,{"$f":"'T26'!G24","v":387.43985204476695}]
["Network Innovation Competition",32.664404040000001,42.5,32.664404040000001,{"$f":"'T26'!G33","v":32.664404040000001}]
["EDR"]
["Interconnectors (Cap & Floor)",-6.8,-6.8,-6.8,{"$f":"D23","v":-6.8}]
["Total to Collect from TNUoS",{"$f":"+B23+B21+B20+B18+B13+B8","v":2670.2955220827225},{"$f":"+C23+C21+C20+C18+C13+C8","v":2968.3616850621502},2835.826099791766,2879.2661965081297]

{"sheet":"T16","index":18,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 16 - Generation and Demand Revenue Proportions",null,null,null,null,null,"Return to Index"]
[]
[null,null,"2019/20 Initial  ","2019/20 April  ","2019/20 June","2019/20 Draft","2019/20 Final  "]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5]
["y","Error Margin",0.21,0.21,0.21]
["ER","Exchange Rate (€/£)",1.0900000000000001,1.1299999999999999,1.124927]
["MAR","Total Revenue (£m)",2968.3616850621493,2835.8126099188039,2879.2521943684746]
["GO","Generation Output (TWh)",243.12236122457247,247.03485845324252,229.83357135990477]
["G","% of revenue from generation",0.1484050535056938,0.15225422987595572,0.14014464841765573]
["D","% of revenue from demand",0.85159494649430623,0.84774577012404428,0.85985535158234427]
["G.R","Revenue recovered from generation (£m)",440.51987469589966,{"$f":"D7*D9","v":431.76446499571148},403.51178648553361]
["D.R","Revenue recovered from demand (£m)",2527.8418103662498,{"$f":"D7*D10","v":2404.0481449230924},2475.7404078829409]

{"sheet":"T17","index":19,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Table 17 - Charging Bases",null,null,null,"Return to Index"]
[]
["Charging Bases","2019/20 April ","2019/20 June","2019/20 Draft","2019/20 Final  "]
["Generation (GW)",71.711759999999984,71.910959999999989]
["NHH Demand (4pm-7pm TWh)",25.512098981321838,25.512098981321838]
["Net Charging"]
["Total Average Net Triad (GW)",43.572821858760001,43.572821858760001]
["HH  Demand Average Net Triad (GW)",10.254642452956,10.254642452956]
["Gross charging"]
["Total Average Gross Triad (GW)",51.325629881540003,51.325629881540003]
["HH Demand Average Gross Triad (GW)",18.007450475736,18.007450475736]
["Embedded Generation Export (GW)",7.75280802278,7.75280802278]

{"sheet":"T18","index":20,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 18 - Residual Calculation",null,null,null,null,"Return to Index"]
[]
[null,"Component","2019/20 April","2019/20 June","2019/20 Draft","2019/20 Final "]
["G","Proportion of revenue recovered from generation (%)",0.15225422987595574,0.14014464841765575]
["D","Proportion of revenue recovered from demand (%)",0.84774577012404428,0.85985535158234427]
["R","Total TNUoS revenue (£m)",2835.8126099188039,2879.2521943684746]
["Generation Residual"]
["RG","Generator residual tariff (£/kW)",-3.2912402716384705,-3.6130603651697628]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",330.71220221052158,329.09945382201983]
["O","Revenue recovered from offshore local tariffs (£m)",298.70558008131661,295.95369689863878]
["LG","Revenue recovered from onshore local substation tariffs (£m)",19.24758904918,19.240538614640002]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",19.119726116766145,19.03673654754331]
["BG","Generator charging base (GW)",71.711759999999984,71.910959999999989]
["Gross Demand Residual"]
["RD","Demand residual tariff (£/kW)",50.298595774651638,51.697065773793433]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",-66.685577739219312,-66.725593360095743]
["EE","Amount to be paid to Embedded Export Tariffs (£m)",110.87338762864964,110.9184626243141]
["BD","Demand Gross charging base (GW)",51.325629881539996,51.325629881539996]

{"sheet":"T20","index":21,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
["Table 20 - Demand Locational Tariffs",null,null,null,null,null,"Return to Index"]
[]
[]
[]
["Zone","2019/20 April","2019/20 April","2019/20 June","2019/20 June (£/kW)","Changes"]
[null,"Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)"]
[1,-2.0479069678368464,-28.513682926796921,-2.0412450726915945,-28.538571553183434,6.6618951452519504E-3,-2.4888626386513124E-2]
[2,-2.2402753456840774,-20.639596648935001,-2.2447355247916572,-20.655198530507644,-4.460179107579787E-3,-1.560188157264264E-2]
[3,-3.581823188124293,-6.8240638924597086,-3.5788331008029823,-6.8261039729431099,2.9900873213106749E-3,-2.0400804834013186E-3]
[4,-1.1265154396761521,-2.4496986380409322,-1.1241210081862911,-2.4439919678877691,2.3944314898609598E-3,5.7066701531631736E-3]
[5,-2.8423277229761807,-0.44222163895275202,-2.8392059564937848,-0.4365107434962272,3.1217664823959268E-3,5.7108954565248116E-3]
[6,-2.2899351797666037,0.29002031108081344,-2.2595580255543681,0.27389003167399151,3.0377154212235524E-2,-1.6130279406821935E-2]
[7,-2.1619764959505687,2.3157245548684284,-2.1589022108686726,2.3229301509767084,3.0742850818961109E-3,7.2055961082799769E-3]
[8,-1.437143394970835,2.8909138558307115,-1.4363065432233166,2.8977073584640296,8.3685174751835234E-4,6.793502633318127E-3]
[9,1.3547432862807172,0.83774616944326141,1.359902704818573,0.84699833211192366,5.1594185378558421E-3,9.2521626686622449E-3]
[10,-6.1391312445268635,4.5010873615838296,-6.14432423759615,4.4998972270102957,-5.1929930692864446E-3,-1.1901345735338964E-3]
[11,4.2039979417701137,0.7226993724348556,4.2137715826503959,0.73729069342247833,9.7736408802822083E-3,1.4591320987622725E-2]
[12,5.6505852363776485,2.3985985412975528,5.6561897422208647,2.4088378639300796,5.6045058432161454E-3,1.0239322632526804E-2]
[13,1.8380258050999772,4.3316430397544501,1.8169245291263321,4.314971979340263,-2.1101275973645084E-2,-1.6671060414187089E-2]
[14,-0.9217489023764025,5.4297818302218914,-0.95592019244338344,5.3998883713837156,-3.4171290066980942E-2,-2.9893458838175846E-2]

{"sheet":"T21","index":22,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10]]}
["Table 21 - Breakdown of the Embedded Export Tariff",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
["Demand Zone",null,"2019/20 April",null,null,"2019/20 June",null,null,"Changes"]
[null,null,"Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)","Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)","Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)"]
[1,"Northern Scotland",-30.561589894633769,3.32,14.65,-30.579816625875029,3.3272680000000001,14.65,{"$f":"F5-C5","v":-1.8226731241259841E-2},{"$f":"G5-D5","v":7.2680000000002742E-3},0]
[2,"Southern Scotland",-22.87987199461908,3.32,14.65,-22.899934055299301,3.3272680000000001,14.65,{"$f":"F6-C6","v":-2.0062060680221094E-2},{"$f":"G6-D6","v":7.2680000000002742E-3},{"$f":"H6-E6","v":0}]
[3,"Northern",-10.405887080584002,3.32,14.65,-10.404937073746092,3.3272680000000001,14.65,9.5000683790935625E-4,7.2680000000002742E-3,0]
[4,"North West",-3.5762140777170845,3.32,14.65,-3.56811297607406,3.3272680000000001,14.65,8.1011016430245775E-3,7.2680000000002742E-3,0]
[5,"Yorkshire",-3.2845493619289328,3.32,14.65,-3.2757166999900118,3.3272680000000001,14.65,8.8326619389209604E-3,7.2680000000002742E-3,0]
[6,"N Wales & Mersey",-1.9999148686857902,3.32,14.65,-1.9856679938803765,3.3272680000000001,14.65,1.4246874805413645E-2,7.2680000000002742E-3,0]
[7,"East Midlands",0.1537480589178597,3.32,14.65,0.16402794010803579,3.3272680000000001,14.65,1.0279881190176088E-2,7.2680000000002742E-3,0]
[8,"Midlands",1.4537704608598765,3.32,14.65,1.461400815240713,3.3272680000000001,14.65,7.6303543808364793E-3,7.2680000000002742E-3,0]
[9,"Eastern",2.1924894557239787,3.32,14.65,2.2069010369304967,3.3272680000000001,14.65,1.4411581206517976E-2,7.2680000000002742E-3,0]
[10,"South Wales",-1.6380438829430339,3.32,14.65,-1.6444270105858543,3.3272680000000001,14.65,-6.383127642820341E-3,7.2680000000002742E-3,0]
[11,"South East",4.9266973142049695,3.32,14.65,4.9510622760728742,3.3272680000000001,14.65,2.4364961867904711E-2,7.2680000000002742E-3,0]
[12,"London",8.0491837776752018,3.32,14.65,8.0650276061509452,3.3272680000000001,14.65,1.5843828475743393E-2,7.2680000000002742E-3,0]
[13,"Southern",6.169668844854427,3.32,14.65,6.1318965084665953,3.3272680000000001,14.65,-3.7772336387831729E-2,7.2680000000002742E-3,0]
[14,"South Western",4.5080329278454894,3.32,14.65,4.4439681789403318,3.3272680000000001,14.65,-6.4064748905157565E-2,7.2680000000002742E-3,0]

{"sheet":"T22","index":23,"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","2019/20 April","2019/20 April","2019/20 April","2019/20 April","2019/20 April","2019/20 June","2019/20 June","2019/20 June","2019/20 June","2019/20 June"]
[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",499.4470878504585,1483.1581980599999,427.58099095348541,0.78417740827603,958.03354100000001,499.4470878504585,1483.1581980599999,427.58099095348541,0.78417740827603,958.03354100000001]
[2,"Southern Scotland",2695.2802337591597,3444.3512881749998,1125.6193456983801,1.7712229685994472,678.45211199999994,2695.2802337591597,3444.3512881749998,1125.6193456983801,1.7712229685994472,678.45211199999994]
[3,"Northern",2702.3018897993657,2575.9529187349995,902.07940785267442,1.3176976488981178,438.64920239999998,2702.3018897993657,2575.9529187349995,902.07940785267442,1.3176976488981178,438.64920239999998]
[4,"North West",3067.4972273778667,4037.4046861050001,1413.353912556697,2.023841932113466,410.12000715000005,3067.4972273778667,4037.4046861050001,1413.353912556697,2.023841932113466,410.12000715000005]
[5,"Yorkshire",4384.0810294471312,3818.4646561599993,1495.2762792970595,1.8253089893201262,807.53373749999992,4384.0810294471312,3818.4646561599993,1495.2762792970595,1.8253089893201262,807.53373749999992]
[6,"N Wales & Mersey",2557.7445581819634,2627.7808294499996,991.00236734188491,1.2983116701150454,550.43923969999992,2557.7445581819634,2627.7808294499996,991.00236734188491,1.2983116701150454,550.43923969999992]
[7,"East Midlands",5375.7499999999991,4651.1254094899996,1717.461032432876,2.2393722031630907,639.19339848000004,5375.7499999999991,4651.1254094899996,1717.461032432876,2.2393722031630907,639.19339848000004]
[8,"Midlands",4424.72,4251.4588521649994,1388.5716972475714,2.1714337960257994,335.0919945,4424.72,4251.4588521649994,1388.5716972475714,2.1714337960257994,335.0919945]
[9,"Eastern",6238.2137738786842,6447.1848001049993,1931.3322439446451,3.2377270298612606,805.69248284999992,6238.2137738786842,6447.1848001049993,1931.3322439446451,3.2377270298612606,805.69248284999992]
[10,"South Wales",1673.9196255192999,1821.8665522399999,778.90072875383839,0.88419467755153347,509.70056670000008,1673.9196255192999,1821.8665522399999,778.90072875383839,0.88419467755153347,509.70056670000008]
[11,"South East",3870.8045207727018,3906.2703441649992,1059.9055823903232,2.0083136803934449,410.92357874999999,3870.8045207727018,3906.2703441649992,1059.9055823903232,2.0083136803934449,410.92357874999999]
[12,"London",5599.2426459072658,4186.8787037349994,2202.526200933848,1.8709621594887456,170.83104875000001,5599.2426459072658,4186.8787037349994,2202.526200933848,1.8709621594887456,170.83104875000001]
[13,"Southern",6565.8930395182133,5476.4880377549989,1933.2113283909596,2.677801362684086,692.67385979999995,6565.8930395182133,5476.4880377549989,1933.2113283909596,2.677801362684086,692.67385979999995]
[14,"South Western",2210.0784100137666,2597.2446051999996,640.62935794175746,1.401733454831644,345.47325319999999,2210.0784100137666,2597.2446051999996,640.62935794175746,1.401733454831644,345.47325319999999]
["Total",null,51864.974042025882,51325.629881539993,18007.450475736001,25.512098981321838,7752.8080227800001,51864.974042025882,51325.629881539993,18007.450475736001,25.512098981321838,7752.8080227800001]

{"sheet":"T23","index":24,"n_rows":142,"n_cols":13,"rows_kept":142,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,5,1],[4,2,4,6],[4,7,4,11],[4,12,5,12]]}
["Table 23 - Annual Load Factors",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
[]
[]
["Power Station","Technology","Yearly Load Factor Source",null,null,null,null,"Yearly Load Factor Value",null,null,null,null,"Specific ALF"]
[null,null,2012,2013,2014,2015,2016,2012,2013,2014,2015,2016]
["ABERTHAW","Coal","Actual","Actual","Actual","Actual","Actual",0.74013700000000004,0.65541300000000002,0.59004299999999998,0.54261099999999995,0.50833499999999998,0.59602200000000005]
["ACHRUACH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.33646399999999999,0.36714000000000002,0.34899400000000003]
["AN SUIDHE WIND FARM","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.31637999999999999,0.41584300000000002,0.36942199999999997,0.35489999999999999,0.34093800000000002,0.35508699999999999]
["ARECLEOCH","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.324826,0.33829599999999999,0.29729800000000001,0.368612,0.197246,0.32013999999999998]
["BAGLAN BAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.275756,0.164106,0.37919399999999998,0.29122799999999999,0.55203000000000002,0.31539299999999998]
["BARKING","CCGT_CHP","Actual","Actual","Partial","Generic","Generic",2.3383000000000001E-2,1.8801999999999999E-2,0.14193,0,0,6.1371000000000002E-2]
["BARROW OFFSHORE WIND LTD","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.42884,0.54108000000000001,0.47023100000000001,0.47179100000000002,0.44258399999999998,0.461536]
["BARRY","CCGT_CHP","Actual","Actual","Actual","Actual","Partial",6.999E-3,1.2989000000000001E-2,4.0029999999999996E-3,2.1727E-2,0.25430000000000003,1.3905000000000001E-2]
["BEAULY CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.25453199999999998,0.35668299999999997,0.37116700000000002,0.35009400000000002,0.30487199999999998,0.33721600000000002]
["BEINNEUN","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.30962200000000001,0.332125]
["BHLARAIDH","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.33433800000000002,0.340364]
["BLACK LAW","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.22068299999999999,0.31964799999999999,0.26788099999999998,0.26903500000000002,0.234623,0.25718000000000002]
["BLACKLAW EXTENSION","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.33463500000000002,0.13109499999999999,0.269702]
["BRIMSDOWN","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.21875900000000001,0.18764500000000001,0.11122899999999999,0.164463,0.45061499999999999,0.19028900000000001]
["BURBO BANK","Offshore_Wind","Generic","Generic","Generic","Actual","Actual",0,0,0,0.16778100000000001,0.25023299999999998,0.30435499999999999]
["CARRAIG GHEAL","Onshore_Wind","Partial","Actual","Actual","Actual","Actual",0.29811799999999999,0.45276,0.48927700000000002,0.45625399999999999,0.40421099999999999,0.46609699999999998]
["CARRINGTON","CCGT_CHP","Generic","Generic","Generic","Partial","Actual",0,0,0,0.387318,0.58011500000000005,0.46651999999999999]
["CLUNIE SCHEME","Hydro","Actual","Actual","Actual","Actual","Actual",0.334563,0.45325599999999999,0.43248799999999998,0.479711,0.32829700000000001,0.40676899999999999]
["CLYDE (NORTH)","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.28534500000000002,0.42659799999999998,0.36888199999999999,0.41411999999999999,0.26885799999999999,0.35611599999999999]
["CLYDE (SOUTH)","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.31608399999999998,0.39894099999999999,0.29411500000000002,0.399615,0.34875099999999998,0.35459200000000002]
["CONNAHS QUAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.18510399999999999,0.12823300000000001,0.18373900000000001,0.28271299999999999,0.37458799999999998,0.21718499999999999]
["CONON CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.47528599999999999,0.54281999999999997,0.55528699999999998,0.58986000000000005,0.48678199999999999,0.52829599999999999]
["CORRIEGARTH","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.22564400000000001,0.30413299999999999]
["CORRIEMOILLIE","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.32231500000000002,0.33635599999999999]
["CORYTON","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.15686900000000001,9.7851999999999995E-2,0.175123,0.26400000000000001,0.63038300000000003,0.19866400000000001]
["COTTAM","Coal","Actual","Actual","Actual","Actual","Actual",0.65069999999999995,0.67395099999999997,0.51442600000000005,0.34415699999999999,0.14938699999999999,0.50309499999999996]
["COTTAM DEVELOPMENT CENTRE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.13736100000000001,0.160249,0.31313200000000002,0.28238200000000002,0.67248200000000002,0.25192100000000001]
["COUR","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.38324599999999998,0.35666700000000001]
["COWES","Gas_Oil","Actual","Actual","Actual","Actual","Actual",1.743E-3,9.5600000000000004E-4,3.1350000000000002E-3,4.9119999999999997E-3,5.3189999999999999E-3,3.264E-3]
["CRUACHAN","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",8.4280999999999995E-2,9.6969E-2,9.0515999999999999E-2,8.8673000000000002E-2,7.1914000000000006E-2,8.7822999999999998E-2]
["CRYSTAL RIG II","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.40684500000000001,0.50254900000000002,0.47595799999999999,0.48383599999999999,0.40267900000000001,0.45554600000000001]
["CRYSTAL RIG III","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.399503,0.36208600000000002]
["DAMHEAD CREEK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.45061699999999999,0.771783,0.67464100000000005,0.64898299999999998,0.68111900000000003,0.66824799999999995]
["DEESIDE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.197551,0.17303499999999999,0.139018,0.17457900000000001,0.27109,0.18172199999999999]
["DERSALLOCH","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.33772799999999997,0.34149400000000002]
["DIDCOT B","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.49013400000000001,0.18662400000000001,0.25534499999999999,0.411389,0.50135799999999997,0.38562299999999999]
["DIDCOT GTS","Gas_Oil","Actual","Actual","Actual","Actual","Actual",7.2000000000000005E-4,9.0200000000000002E-4,2.843E-3,4.8609999999999999E-3,4.5199999999999998E-4,1.488E-3]
["DINORWIG","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",0.15099000000000001,0.150898,0.15065000000000001,0.14635300000000001,0.15959599999999999,0.15084600000000001]
["DRAX","Coal","Actual","Actual","Actual","Actual","Actual",0.82477400000000001,0.80515099999999995,0.82214900000000002,0.76202999999999999,0.62270499999999995,0.79644300000000001]
["DUDGEON","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.42479099999999997,0.47163100000000002]
["DUNGENESS B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.59829500000000002,0.61006800000000005,0.54691699999999999,0.70761700000000005,0.79340299999999997,0.63866000000000001]
["DUNLAW EXTENSION","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.32377099999999998,0.34822599999999998,0.30079699999999998,0.29120299999999999,0.26554899999999998,0.305257]
["DUNMAGLASS","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.38971299999999998,0.35882199999999997]
["EDINBANE WIND","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.293933,0.394785,0.31245800000000001,0.355937,0.32500899999999999,0.33113500000000001]
["EGGBOROUGH","Coal","Actual","Actual","Actual","Actual","Partial",0.72688399999999997,0.72184300000000001,0.45742100000000002,0.27015699999999998,0.39769300000000002,0.63538300000000003]
["ERROCHTY","Hydro","Actual","Actual","Actual","Actual","Actual",0.145869,0.28262799999999999,0.253585,0.28150700000000001,0.161775,0.232289]
["EWE HILL","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.333314,0.34002300000000002]
["FALLAGO","Onshore_Wind","Partial","Actual","Actual","Actual","Actual",0.32986900000000002,0.54868300000000003,0.44726700000000003,0.55799200000000004,0.432176,0.51798100000000002]
["FARR WINDFARM TOMATIN","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.34014899999999998,0.447212,0.385712,0.40996300000000002,0.34176600000000001,0.37914700000000001]
["FASNAKYLE G1 & G3","Hydro","Actual","Actual","Actual","Actual","Actual",0.22117600000000001,0.35369499999999998,0.57483399999999996,0.53157299999999996,0.30976799999999999,0.398345]
["FAWLEY CHP","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.61136199999999996,0.63361900000000004,0.72848400000000002,0.57697799999999999,0.63200599999999996,0.62566200000000005]
["FFESTINIOGG","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",2.9286E-2,5.4630999999999999E-2,4.3250999999999998E-2,3.4112999999999997E-2,5.6749000000000001E-2,4.3999000000000003E-2]
["FIDDLERS FERRY","Coal","Actual","Actual","Actual","Actual","Actual",0.61638599999999999,0.49037399999999998,0.45243499999999998,0.27459099999999997,8.2477999999999996E-2,0.40579999999999999]
["FINLARIG","Hydro","Actual","Actual","Actual","Actual","Actual",0.40295199999999998,0.59914199999999995,0.59409199999999995,0.65134899999999996,0.49640200000000001,0.56321200000000005]
["FOYERS","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",0.1348,0.14709700000000001,0.123048,0.15432299999999999,0.11304599999999999,0.13498199999999999]
["FREASDAIL","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.3256,0.337451]
["GALAWHISTLE","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.34976400000000002,0.34550599999999998]
["GARRY CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.48599300000000001,0.55930800000000003,0.64382799999999996,0.60277199999999997,0.61049799999999999,0.59085900000000002]
["GLANDFORD BRIGG","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",3.336E-3,1.5672999999999999E-2,5.4010000000000004E-3,1.8190999999999999E-2,2.7681999999999998E-2,1.3088000000000001E-2]
["GLEN APP","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.25137300000000001,0.31270900000000001]
["GLENDOE","Hydro","Actual","Actual","Actual","Actual","Actual",0.17335,0.36380200000000001,0.323494,0.34853200000000001,0.23860500000000001,0.30354399999999998]
["GLENMORISTON","Hydro","Actual","Actual","Actual","Actual","Actual",0.36304500000000001,0.44459399999999999,0.487487,0.50692099999999995,0.34670899999999999,0.43170900000000001]
["GORDONBUSH","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.37892999999999999,0.46559400000000001,0.47798099999999999,0.477161,0.50412599999999996,0.47357900000000003]
["GRAIN","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.25457999999999997,0.41383300000000001,0.44003100000000001,0.397895,0.53822700000000001,0.41725299999999999]
["GRANGEMOUTH","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.52859400000000001,0.55904699999999996,0.62616799999999995,0.59827399999999997,0.51455799999999996,0.56197200000000003]
["GREAT YARMOUTH","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.19026999999999999,0.20740900000000001,0.18663299999999999,0.59895699999999996,0.63512000000000002,0.33221200000000001]
["GREATER GABBARD OFFSHORE WIND FARM","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.40177800000000002,0.48303800000000002,0.42132700000000001,0.50246800000000003,0.43113200000000002,0.44516600000000001]
["GRIFFIN WIND","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.17988499999999999,0.31956600000000002,0.31315199999999999,0.310284,0.25822800000000001,0.29388799999999998]
["GUNFLEET SANDS I","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.50149600000000005,0.56647199999999998,0.47013199999999999,0.50465000000000004,0.45794000000000001,0.492093]
["GUNFLEET SANDS II","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.45013199999999998,0.52236099999999996,0.44721100000000003,0.49052099999999998,0.43989299999999998,0.46262199999999998]
["GWYNT Y MOR","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.18853500000000001,8.0035999999999996E-2,0.61618499999999998,0.63127599999999995,0.44832300000000003,0.56526200000000004]
["HADYARD HILL","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.27692699999999998,0.31948799999999999,0.27763500000000002,0.36652699999999999,0.31436399999999998,0.30382900000000002]
["HARESTANES","Onshore_Wind","Generic","Partial","Actual","Actual","Actual",0,0.22244800000000001,0.28635500000000003,0.27809299999999998,0.225464,0.26330399999999998]
["HARTLEPOOL","Nuclear","Actual","Actual","Actual","Actual","Actual",0.80263200000000001,0.73755700000000002,0.56280300000000005,0.53866599999999998,0.78039000000000003,0.69358299999999995]
["HEYSHAM","Nuclear","Actual","Actual","Actual","Actual","Actual",0.83382800000000001,0.73362799999999995,0.68825199999999997,0.72734399999999999,0.79616900000000002,0.75238000000000005]
["HINKLEY POINT B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.61758199999999996,0.68866400000000005,0.70141100000000001,0.67641200000000001,0.71226500000000004,0.68882900000000002]
["HUMBER GATEWAY OFFSHORE WIND FARM","Offshore_Wind","Generic","Generic","Generic","Actual","Actual",0,0,0,0.62963100000000005,0.59719500000000003,0.573959]
["HUNTERSTON","Nuclear","Actual","Actual","Actual","Actual","Actual",0.73598399999999997,0.84795299999999996,0.79136799999999996,0.82178600000000002,0.83293899999999998,0.81536500000000001]
["IMMINGHAM","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.50179300000000004,0.37821900000000003,0.56831600000000004,0.69468600000000003,0.71955000000000002,0.58826500000000004]
["INDIAN QUEENS","Gas_Oil","Actual","Actual","Actual","Actual","Actual",3.4229999999999998E-3,2.3210000000000001E-3,8.7600000000000004E-4,7.2300000000000001E-4,8.4699999999999999E-4,1.348E-3]
["KEADBY","CCGT_CHP","Actual","Actual","Generic","Partial","Actual",4.6124999999999999E-2,9.9999999999999995E-7,0,0.351858,0.286076,0.110734]
["KILBRAUR","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.45230599999999999,0.51377700000000004,0.54354999999999998,0.503807,0.46534199999999998,0.494309]
["KILGALLIOCH","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.25273899999999999,0.313164]
["KILLIN CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.32342900000000002,0.45535599999999998,0.44820500000000002,0.53234800000000004,0.27496199999999998,0.408997]
["KILLINGHOLME (NP)","CCGT_CHP","Actual","Actual","Actual","Generic","Generic",0.10655199999999999,7.4217000000000005E-2,0.116191,0,0,9.8987000000000006E-2]
["KILLINGHOLME (POWERGEN)","Gas_Oil","Generic","Generic","Generic","Generic","Generic",0,0,0,0,0,0]
["KINGS LYNN A","CCGT_CHP","Actual","Actual","Actual","Generic","Generic",3.0000000000000001E-6,0,0,0,0,9.9999999999999995E-7]
["LANGAGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.41911500000000002,0.40874899999999997,0.34862900000000002,0.16531000000000001,0.445413,0.39216400000000001]
["LINCS WIND FARM","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.20324400000000001,0.46598699999999998,0.43817800000000001,0.49130600000000002,0.44519199999999998,0.46749499999999999]
["LITTLE BARFORD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.16380700000000001,0.33628599999999997,0.49664399999999997,0.39982899999999999,0.64859699999999998,0.41092000000000001]
["LOCHLUICHART","Onshore_Wind","Generic","Partial","Actual","Actual","Actual",0,0.24939700000000001,0.202103,0.29266300000000001,0.31689699999999998,0.27055400000000002]
["LONDON ARRAY","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.38951999999999998,0.51270300000000002,0.64088000000000001,0.668682,0.53624499999999997,0.61526899999999995]
["LYNEMOUTH","Coal","Generic","Generic","Generic","Partial","Generic",0,0,0,0.68019600000000002,0,0.58687500000000004]
["MARCHWOOD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.43353700000000001,0.48684500000000003,0.66402099999999997,0.55087900000000001,0.75424800000000003,0.56724799999999997]
["MARK HILL","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.30167500000000003,0.30286299999999999,0.26794200000000001,0.340227,0.21965299999999999,0.290827]
["MEDWAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",1.0718E-2,0.14554500000000001,0.28096199999999999,0.34179900000000002,0.35150500000000001,0.256102]
["MILLENNIUM","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.42131800000000003,0.52661800000000003,0.532636,0.48403800000000002,0.449764,0.48680600000000002]
["NANT","Hydro","Actual","Actual","Actual","Actual","Actual",0.20896500000000001,0.355883,0.36403999999999997,0.37378800000000001,0.30635000000000001,0.34209099999999998]
["ORMONDE","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.48840600000000001,0.49656099999999997,0.42871100000000001,0.47198600000000002,0.412188,0.46575299999999997]
["PEMBROKE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.61543400000000004,0.60392800000000002,0.675346,0.64559599999999995,0.776478,0.645459]
["PEN Y CYMOEDD","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.26944600000000002,0.31873299999999999]
["PETERBOROUGH","CCGT_CHP","Actual","Actual","Actual","Partial","Actual",9.5060000000000006E-3,1.8311000000000001E-2,1.0928999999999999E-2,4.1031999999999999E-2,1.7913999999999999E-2,1.5717999999999999E-2]
["PETERHEAD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.31376599999999999,0.41881099999999999,4.8580000000000003E-3,0.23381299999999999,0.422292,0.32213000000000003]
["RACE BANK","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.45306200000000002,0.48105500000000001]
["RATCLIFFE-ON-SOAR","Coal","Actual","Actual","Actual","Actual","Actual",0.66746099999999997,0.71740300000000001,0.56176700000000002,0.19681399999999999,0.15465699999999999,0.47534700000000002]
["ROBIN RIGG EAST","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.37415700000000002,0.46756199999999998,0.55320899999999995,0.51970000000000005,0.50509599999999999,0.49745299999999998]
["ROBIN RIGG WEST","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.38225399999999998,0.48062899999999997,0.53415000000000001,0.56088099999999996,0.51538300000000004,0.51005400000000001]
["ROCKSAVAGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.41482000000000002,2.6155000000000001E-2,4.4252E-2,0.19806099999999999,0.58680600000000005,0.21904399999999999]
["RYE HOUSE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.10718800000000001,7.4694999999999998E-2,5.3700999999999999E-2,7.7906000000000003E-2,0.15653800000000001,8.6596000000000006E-2]
["SALTEND","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.81583399999999995,0.69006199999999995,0.67951799999999996,0.55622799999999994,0.77401900000000001,0.71453299999999997]
["SEABANK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.152311,0.182781,0.25695600000000002,0.27213599999999999,0.41681499999999999,0.237291]
["SELLAFIELD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.14054900000000001,0.25022100000000003,0.189719,0.28678999999999999,0.19858799999999999,0.212842]
["SEVERN POWER","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.277976,0.32416299999999998,0.24635399999999999,0.183226,0.64424599999999999,0.282831]
["SHERINGHAM SHOAL","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.36643100000000001,0.49351699999999998,0.46228599999999997,0.53618399999999999,0.46971499999999999,0.47517300000000001]
["SHOREHAM","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0,0.20750099999999999,0.102239,0.489514,0.689863,0.26641799999999999]
["SIZEWELL B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.96726000000000001,0.82505099999999998,0.84792400000000001,0.98782599999999998,0.81635899999999995,0.88007800000000003]
["SLOY G2 & G3","Hydro","Actual","Actual","Actual","Actual","Actual",9.1252E-2,0.14347099999999999,0.155941,0.13943900000000001,8.1781999999999994E-2,0.124721]
["SOUTH HUMBER BANK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.27976299999999998,0.24337300000000001,0.34467300000000001,0.48675299999999999,0.55341899999999999,0.370396]
["SPALDING","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.34697600000000001,0.33479999999999999,0.393092,0.47940700000000003,0.60974799999999996,0.40649200000000002]
["STAYTHORPE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.54411699999999996,0.37621599999999999,0.56614799999999998,0.69442199999999998,0.65779100000000001,0.58935199999999999]
["STRATHY NORTH & SOUTH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.49634,0.361987,0.40056799999999998]
["SUTTON BRIDGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.201652,9.4123999999999999E-2,0.17202500000000001,0.13199900000000001,0.38018400000000002,0.16855899999999999]
["TAYLORS LANE","Gas_Oil","Actual","Actual","Actual","Actual","Actual",2.0370000000000002E-3,4.8299999999999998E-4,6.4000000000000005E-4,1.7080000000000001E-3,8.0470000000000003E-3,1.462E-3]
["THANET OFFSHORE WIND FARM","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.41109299999999999,0.39748899999999998,0.355935,0.41343400000000002,0.33713199999999999,0.38817200000000002]
["TODDLEBURN","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.32717499999999999,0.395374,0.33721099999999998,0.350823,0.31343500000000002,0.33840300000000001]
["TORNESS","Nuclear","Actual","Actual","Actual","Actual","Actual",0.84866900000000001,0.86466900000000002,0.91494500000000001,0.85772499999999996,0.97994199999999998,0.87911300000000003]
["USKMOUTH","Coal","Actual","Actual","Partial","Actual","Actual",0.45193800000000001,0.389899,0.46942800000000001,0.25518400000000002,0.24330399999999999,0.365674]
["WALNEY I","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.442799,0.57704599999999995,0.52055499999999999,0.50753499999999996,0.47461700000000001,0.50090199999999996]
["WALNEY II","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.54790700000000003,0.61921899999999996,0.58235499999999996,0.35798799999999997,0.54972699999999997,0.58376700000000004]
["WEST BURTON","Coal","Actual","Actual","Actual","Actual","Actual",0.70586800000000005,0.68917600000000001,0.61536400000000002,0.32732499999999998,0.10107099999999999,0.54395499999999997]
["WEST BURTON B","CCGT_CHP","Partial","Actual","Actual","Actual","Actual",0.21329899999999999,0.30302099999999998,0.46842099999999998,0.59347700000000003,0.54287799999999997,0.53492499999999998]
["WEST OF DUDDON SANDS OFFSHORE WIND FARM","Offshore_Wind","Generic","Partial","Actual","Actual","Actual",0,0.404447,0.40050599999999997,0.48753999999999997,0.48769099999999999,0.45857900000000001]
["WESTERMOST ROUGH","Offshore_Wind","Generic","Generic","Partial","Actual","Actual",0,0,0.26290000000000002,0.548014,0.58106100000000005,0.46399200000000002]
["WHITELEE","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.28226499999999999,0.351074,0.29810500000000001,0.31877299999999997,0.272893,0.29971399999999998]
["WHITELEE EXTENSION","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.12414600000000001,0.27010200000000001,0.27778700000000001,0.26765499999999998,0.23525299999999999,0.25767000000000001]
["WILTON","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",3.4257999999999997E-2,4.4941000000000002E-2,0.215867,0.16137899999999999,0.14413000000000001,0.116817]

{"sheet":"T24","index":25,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Table 24 - Generic Annual Load Factors",null,null,null,"Return to Index"]
[]
[]
["Technology","Generic ALF"]
["Gas_Oil",1.89E-3]
["Pumped_Storage",0.104412]
["Tidal",0.189]
["Biomass",0.268847]
["Wave",0.31]
["Onshore_Wind",0.34337699999999999]
["CCGT_CHP",0.43212699999999998]
["Hydro",0.41365600000000002]
["Offshore_Wind",0.49505100000000002]
["Coal",0.540215]
["Nuclear",0.76400100000000004]

{"sheet":"T25","index":26,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Table 25 - Generation Contracted TEC Changes",null,null,null,"Return to Index"]
[]
[]
["Power Station","Node","MW Change","Generation Zone"]
["Blacklaw Extension",-9,"BLKX10",11]
["Cowes",140,"FAWL40",26]
["Didcot B",-100,"DIDC40",25]
["Liberty Steel Dalzell",18,"WISH10",11]
["Morlais",120,"WYLF40",19]
["Neart Na Gaoithe Offshore Wind Farm",-450,"CRYR40",11]
["Beinn an Tuirc 3",-50,"CAAD1Q",7]
["Sizewell C",-1670,"SIZE40",18]

{"sheet":"T26","index":27,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Table 26 - Indicative National Grid Revenue Forecast",null,null,null,null,null,null,null,"Return to Index"]
[]
[null,null,null,null,null,null,null,null," "]
["Description"," ",null,null,null,null,null,null,"Notes"]
["Regulatory Year"," ","Licence Term","2018/19 (fixed forecast)","Initial Forecast","April Forecast","June Forecast","Nov Draft"]
["Actual RPI"," "," "," ",null,null,null,null,"April to March average"]
["RPI Actual"," ","RPIAt"," ",null,null,null,null,"Office of National Statistics"]
["Assumed Interest Rate"," ","It",7.0500000000000007E-3,5.6249999999999998E-3,1.1599999999999999E-2,1.1599999999999999E-2,null,"Bank of England Base Rate"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1587.627,1585.2280000000001,1585.2280000000001,1585.2280000000001,null,"From Licence"]
["Price Control Financial Model Iteration Adjustment","A2","MODt",-310.24084085000004,-334,-334,-334,null,"Forecast"]
["RPI True Up","A3","TRUt",-6.0845942150118297,3.2656364182877167,3.2656364182877167,3.2656364182877167,null,"Forecast"]
["Prior Calendar Year RPI Forecast"," ","GRPIFc-1",3.5999999999999997E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,null,"HM Treasury Forecast"]
["Current Calendar Year RPI Forecast"," ","GRPIFc",3.4000000000000002E-2,0.03,0.03,0.03,null,"HM Treasury Forecast"]
["Next Calendar Year RPI forecast"," ","GRPIFc+1",3.1E-2,0.03,0.03,0.03,null,"HM Treasury Forecast"]
["RPI Forecast","A4","RPIFt",1.3140000000000001,1.357,1.357,1.357,null,"Using HM Treasury Forecast"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",{"$f":"SUM(D9:D11)*D15","v":1670.4902563245746},1702.3478646196163,{"$f":"SUM(F9:F11)*F15","v":1702.3478646196163},{"$f":"SUM(G9:G11)*G15","v":1702.3478646196163}]
["Pass-Through Business Rates","B1","RBt",1.563034475468172,35.125264090309322,3.8304626547205786E-4,3.8304626547205786E-4,null,"Forecast"]
["Temporary Physical Disconnection","B2","TPDt",0.70842755869282104,0,0,0,null,"Forecast"]
["Licence Fee","B3","LFt",-0.37663957632732453,4.5405335158157927,0,0,null,"Forecast"]
["Inter TSO Compensation","B4","ITCt",1.3447743785507609,0.76609253098295482,0,0,null,"Forecast"]
["Termination of Bilateral Connection Agreements","B5","TERMt",0,0,0,0,null,"Forecast"]
["SP Transmission Pass-Through","B6","TSPt",349.96085315139794,389.97611439962492,389.96211225997047,389.96211225997047,null,"Forecast"]
["SHE Transmission Pass-Through","B7","TSHt",366.411,349.38682707987397,349.38682707987397,349.38682707987397,null,"Forecast"]
["Offshore Transmission Pass-Through","B8","TOFTOt",318.14381186500037,459.86162681762477,386.47878665563246,387.43985204476695,null,"Forecast"]
["Embedded Offshore Pass-Through","B9","OFETt",0.54981802045525896,0.56739211243328103,0.5678105431946624,0.5678105431946624,null,"Forecast"]
["Interconnectors Cap&Floor Revenue Adjustment","B10","TICFt",-6.8,null,-6.8,-6.8,null,"Forecast"]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10]","B","PTt",{"$f":"SUM(D17:D26)","v":1031.5050798732379},{"$f":"SUM(E17:E26)","v":1240.2238505466648},{"$f":"SUM(F17:F26)","v":1119.5959195849368},{"$f":"SUM(G17:G26)","v":1120.5569849740714},null," "]
["Reliability Incentive Adjustment","C1","RIt",4.1357968557807956,4.2415455471470569,4.2415455471470569,4.2415455471470569,null,"Forecast"]
["Stakeholder Satisfaction Adjustment","C2","SSOt",9.276440123545882,8.5832712034591108,8.6169993151490907,8.6169993151490907,null,"Forecast"]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt",1.4340660973457273,1.6229739981587128,1.6229739981587128,1.6229739981587128,null,"Forecast"]
["Outputs Incentive Revenue [C=C1+C2+C3+C4]","C","OIPt",{"$f":"SUM(D28:D30)","v":14.846303076672406},{"$f":"SUM(E28:E30)","v":14.447790748764881},{"$f":"SUM(F28:F30)","v":14.481518860454861},{"$f":"SUM(G28:G30)","v":14.481518860454861},null," "]
["Network Innovation Allowance","D","NIAt",10.524088614844821,10.724791547103584,10.724791547103584,10.724791547103584,null,"Forecast"]
["Network Innovation Competition","E","NICFt",32.664404040000001,40.5,32.664404040000001,32.664404040000001,null,"Forecast"]
["Future Environmental Discretionary Rewards","F","EDRt",0,2,0,0,null,"Forecast"]
["Transmission Investment for Renewable Generation","G","TIRGt",0,0,0,0,null,"Forecast"]
["Scottish Site Specific Adjustment","H","DISt",6.6479999999999961,0,0,0,null,"Forecast"]
["Scottish Terminations Adjustment","I","TSt",3.0709999999999997,0,0,0,null,"Forecast"]
["Correction Factor","K","-Kt",-55.451092846606805,0,0,42.496620993135622,null,"Calculated by Licensee"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",{"$f":"D16+D27+D31+D32+D33+D34+D35+D36+D37+D38","v":2714.2980390827229},{"$f":"E16+E27+E32+E33+E34+E35+E36+E37+E38+E31","v":3010.2442974621495},{"$f":"F16+F27+F31+F32+F33+F34+F35+F36+F37+F38","v":2879.8144986521115},{"$f":"G16+G27+G31+G32+G33+G34+G35+G36+G37+G38","v":2923.2721850343819},null," "]
["Pre-vesting connection charges","P"," ",44.002400999999999,41.882612399999999,44.002400999999999,44.002400999999999,null,"Forecast"]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",{"$f":"D39-D40","v":2670.2956380827227},{"$f":"E39-E40","v":2968.3616850621493},{"$f":"F39-F40","v":2835.8120976521113},{"$f":"G39-G40","v":2879.2697840343817},null," "]
[]
["Notes:"]

{"sheet":"T27","index":28,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,6],[20,5,22,5],[20,6,22,6],[3,7,4,7],[14,1,17,1],[17,2,19,2],[18,3,19,3]]}
["Table 27 - Offshore Revenues",null,null,null,null,null,null,"Return to Index"]
[]
["Offshore Transmission Revenue Forecast (£m)","2018-04-23",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,"Notes"]
["Regulatory Year","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20"]
["Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.8724963671592052,6.250052539232863,6.1694894992964837,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.8017526906474828,7.7205088618084137,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.607167459943749,14.069129245606696,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.7488529744949677,8.6885736900033326,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,16.325806709079423,14.564798437612154,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.742778333926285,21.447818012328305,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.5936963237531,13.022214024468811,"Current revenues plus indexation"]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.387567597857235,29.319792181785161,"Current revenues plus indexation"]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,41.77261773651108,41.352990120511258,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.623202111696155,19.178562011203304,"Current revenues plus indexation"]
["Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,28.169364454148401,27.717352905199309,"Current revenues plus indexation"]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,32.730809292973404,28.993113093727139,"Current revenues plus indexation"]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.572650063642349,23.289427130937753,"Current revenues plus indexation"]
["Humber Gateway",null,null,29.284541507176115,9.7498990869565194,12.145415107061377,12.047327542431878,"Current revenues plus indexation"]
["Westermost Rough",null,null,null,11.576692607080746,13.197339934782658,13.482889086448367,"Current revenues plus indexation"]
["Burbo Bank",null,null,null,null,34.275926251984941,57.429126707901062,"National Grid Forecast"]
["Dudgeon",null,null,null,null,null,null,"National Grid Forecast"]
["Race Bank",null,null,null,null,null,null,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2019/20",null,null,null,null,null,48.946739493497546,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",{"$f":"SUM(B6:B24)","v":218.38037349491282},248.35699921993759,260.78931257200446,265.53230168097656,317.94499958173537,387.43985204476695," "]
[]
[]
["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"]