{"text_format":"1","workbook":"xlsx","n_sheets":51,"sheets":["Index","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","T13","T14","T15","T16","T17","T18","T19","T20","T21","T22","T23","T24","T25","T26","T27","T28","T29","T30","T31","T32","T33","T34","T35","T36","T37","T38","T39","T40","T41","T42","T43","T44","T45","T46","T47","T48","T49","T50"],"not_rendered":{"charts":20,"images":0,"macros":0,"external_links":4,"defined_names":23,"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":60,"n_cols":1,"rows_kept":60,"cut":false,"hidden":false,"merged":[[54,0,55,0],[1,0,2,0]]}
[]
["Table"]
[]
[{"$f":"'T1'!B2","v":"Table 1 - 2017/18 Generation Tariffs"}]
[{"$f":"'T2'!B2","v":"Table 2 - 2018/19 Generation Tariffs"}]
[{"$f":"'T3'!B2","v":"Table 3 - 2019/20 Generation Tariffs"}]
[{"$f":"'T4'!B2","v":"Table 4  - 2020/21 Generation Tariffs"}]
[{"$f":"'T5'!B2","v":"Table 5 - 2021/22 Generation Tariffs"}]
[{"$f":"'T6'!A2","v":"Table 6 – Onshore Local Circuit Tariffs "}]
[{"$f":"'T7'!B2","v":"Table 7 – 2018/19 Onshore Local Substation Tariffs"}]
[{"$f":"'T8'!B2","v":"Table 8 – 2018/19 Offshore Local Tariffs"}]
[{"$f":"'T9'!B2","v":"Table 9 - Small Generator Discount"}]
[{"$f":"'T10'!B2","v":"Table 10 – Half-Hour Demand Tariffs"}]
[{"$f":"'T11'!B2","v":"Table 11 – Non Half-Hour Demand Tariffs"}]
[{"$f":"'T12'!B2","v":"Table 12  - Contracted and Modelled TEC"}]
[{"$f":"'T13'!B2","v":"Table 13 – Calculation of Generator and Demand Revenue Proportions"}]
[{"$f":"'T14'!_Ref386537083","v":"Table 14 – Transmission Owner Revenues"}]
[{"$f":"'T15'!B2","v":"Table 15 – Inflation Indices"}]
[{"$f":"'T16'!B2","v":"Table 16 – Demand Forecasts"}]
[{"$f":"'T17'!B2","v":"Table 17 – Expansion Constants"}]
[{"$f":"'T18'!B2","v":"Table 18 – Interconnector Adjustments"}]
[{"$f":"'T19'!B2","v":"Table 19 - Wider tariffs for a Conventional 80% load factor generator"}]
[{"$f":"'T20'!B2","v":"Table 20 - Wider tariffs for an Intermittent 40% load factor generator"}]
[{"$f":"'T21'!B2","v":"Table 21 - Changes in Half-Hour Metered Tariffs"}]
[{"$f":"'T22'!B2","v":"Table 22  - Changes in Non-Half-hour Metered Tariffs"}]
[{"$f":"'T23'!B2","v":"Table 23 - Calculation of Residuals"}]
[{"$f":"'T24'!B2","v":"Table 24 - 2018/19 Generation Scenarios - Wider Generation Peak 80% Tariffs"}]
[{"$f":"'T25'!B2","v":"Table 25 - 2018/19 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"}]
[{"$f":"'T26'!B2","v":"Table 26 - 2018/19 Generation Scenarios - HH Demand Tariffs"}]
[{"$f":"'T27'!B$2","v":"Table 27 - 2018/19 Generation Scenarios - NHH Demand Tariffs"}]
[{"$f":"'T28'!B2","v":"Table 28 - 2019/20 Generation Scenarios - Wider Generation Peak 80% Tariffs"}]
[{"$f":"'T29'!B2","v":"Table 29 - 2019/20 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"}]
[{"$f":"'T30'!B$2","v":"Table 30 - 2019/20 Generation Scenarios - HH Demand Tariffs"}]
[{"$f":"'T31'!B$2","v":"Table 31 - 2019/20 Generation Scenarios - NHH Demand Tariffs"}]
[{"$f":"'T32'!B2","v":"Table 32 - 2020/21 Generation Scenarios - Wider Generation Peak 80% Tariffs"}]
[{"$f":"'T33'!B2","v":"Table 33 - 2020/21 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"}]
[{"$f":"'T34'!B$2","v":"Table 34 - 2020/21 Generation Scenarios - HH Demand Tariffs"}]
[{"$f":"'T35'!B$2","v":"Table 35 - 2020/21 Generation Scenarios - NHH Demand Tariffs"}]
[{"$f":"'T36'!B2","v":"Table 36 - 2021/22 Generation Scenarios - Wider Generation Peak 80% Tariffs"}]
[{"$f":"'T37'!B2","v":"Table 37 - 2021/22 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"}]
[{"$f":"'T38'!B$2","v":"Table 38 - 2021/22 Generation Scenarios - HH Demand Tariffs"}]
[{"$f":"'T39'!B$2","v":"Table 39 - 2021/22 Generation Scenarios - NHH Demand Tariffs"}]
[{"$f":"'T40'!B2","v":"Table 40 - National Grid Revenue Forecast"}]
[{"$f":"'T41'!B2","v":"Table 41 - Scottish Power Transmission Revenue Forecast"}]
[{"$f":"'T42'!B2","v":"Table 42 - SHE Transmission Revenue Forecast"}]
[{"$f":"'T43'!B2","v":"Table 43 - Offshore Transmission Revenue Forecast"}]
[{"$f":"'T44'!B2","v":"Table 44 - Contracted TEC at Peak"}]
[{"$f":"'T45'!B2","v":"Table 45 - Contracted TEC at Peak by Zone"}]
[{"$f":"'T46'!B2","v":"Table 46 - Zonal Summary of Modelled Demand"}]
[{"$f":"'T47'!B2","v":"Table 47 - Zonal Summary of Chargeable System Demand"}]
[{"$f":"'T48'!B2","v":"Table 48 - Zonal Summary of Chargeable HH Demand"}]
[{"$f":"'T49'!B2","v":"Table 49 - Zonal Summary of Chargeable NHH Demand"}]
[{"$f":"'T50'!B2","v":"Table 50 - Breakdown of HH Demand Tariffs, and CMP264/265 Calculator"}]
[]
["Table"]
[]
[{"$f":"'T19'!J2","v":"Figure 1 – Wider tariffs for a conventional 80% generator"}]
[{"$f":"'T20'!J2","v":"Figure 2 - Wider tariffs for an intermittent 40% load factor generator"}]
[{"$f":"'T10'!$J$2","v":"Figure 3 - Half Hour Demand Tariffs"}]
[{"$f":"'T11'!$J$2","v":"Figure 4 - Non-Half Hour Demand Tariffs"}]

{"sheet":"T1","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2],[1,1,1,8]]}
[]
[null,"Table 1 - 2017/18 Generation Tariffs"]
[]
[null,"Generation Tariffs ",null,"System Peak Tariff","Shared Year Round Tariff","Not Shared Year Round Tariff","Residual Tariff","Conventional 80% Load Factor","Intermittent 40% Load Factor"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",-1.9998209562638912E-3,11.940060126963088,16.909971966108053,-1.8538830625793763,24.606137184142881,19.83211295431391]
[null,2,"East Aberdeenshire",0.79433765711051751,5.5767531471524334,16.909971966108049,-1.8538830625793763,20.311829078361136,17.286790162389643]
[null,3,"Western Highlands",-0.40834303815016409,10.088312340521858,16.676506250547522,-1.8538830625793763,22.484930022235467,18.857948124176886]
[null,4,"Skye and Lochalsh",-6.2241811405247578,10.088312340521858,16.419588150069476,-1.8538830625793763,16.412173819382829,18.60103002369884]
[null,5,"Eastern Grampian and Tayside",0.2730134809951103,8.9542103098611054,16.107178930427033,-1.8538830625793763,21.689677596731649,17.834979991792096]
[null,6,"Central Grampian",2.4373588925906557,10.092599201898214,17.127996643964394,-1.8538830625793763,25.785551835494243,19.311153262144302]
[null,7,"Argyll",1.5567473585919951,8.0288930916489232,25.544208421394011,-1.8538830625793763,31.670187190725763,26.901882595474202]
[null,8,"The Trossachs",1.7843930483784165,8.0288930916489232,15.18382333977233,-1.8538830625793763,21.537447798890504,16.541497513852519]
[null,9,"Stirlingshire and Fife",-0.13383412786018298,3.91369262241134,13.153459234574937,-1.8538830625793763,14.29669614206445,12.865053220960098]
[null,10,"South West Scotland",1.6955790216126485,6.3482836578488984,14.148463065252514,-1.8538830625793763,19.068785950564902,14.833893465812698]
[null,11,"Lothian and Borders",2.8189585474017327,6.3482836578488984,9.0324816690156364,-1.8538830625793763,15.076184080117111,9.717912069575819]
[null,12,"Solway and Cheviot",0.56803148686770977,3.4966637193300594,7.6700081798539106,-1.8538830625793763,9.1814875796062925,7.2147906050065576]
[null,13,"North East England",3.144167820105066,2.0425189399158636,4.1987475548579845,-1.8538830625793763,7.1230474643163664,3.1618720682449535]
[null,14,"North Lancashire and The Lakes",1.2024459536691063,2.0425189399158636,3.0098583811257047,-1.8538830625793763,3.9924364241481261,1.9729828945126739]
[null,15,"South Lancashire, Yorkshire and Humber",3.9977917253589186,0.56822549491648777,0.16438604213002056,-1.8538830625793763,2.7628751008427539,-1.4622068224827607]
[null,16,"North Midlands and North Wales",3.7455360926556054,-0.95102759114154978,0,-1.8538830625793763,1.1308309571629891,-2.2342940990359961]
[null,17,"South Lincolnshire and North Norfolk",2.1937463846031506,-0.33520178427444008,0,-1.8538830625793763,7.1701894604222272E-2,-1.9879637762891522]
[null,18,"Mid Wales and The Midlands",1.2296140224491419,-0.19863275737497008,0,-1.8538830625793763,-0.7831752460302106,-1.9333361655293644]
[null,19,"Anglesey and Snowdon",4.4154049294297533,-1.7040579571447279,0,-1.8538830625793763,1.1982755011345947,-2.5355062454372677]
[null,20,"Pembrokeshire",9.0488997285780552,-3.8844391922538883,0,-1.8538830625793763,4.0874653121955689,-3.4076587394809317]
[null,21,"South Wales & Gloucester",6.1530817072013466,-3.9442042772889159,0,-1.8538830625793763,1.1438352227908373,-3.4315647734949426]
[null,22,"Cotswold",3.1466738788005024,2.0651772903258325,-6.0561862999687701,-1.8538830625793763,-3.1112536514869777,-7.0839984464178132]
[null,23,"Central London",-4.2695528696743406,2.0651772903258325,-5.486684752310758,-1.8538830625793763,-9.9579788523038086,-6.5144968987598011]
[null,24,"Essex and Kent",-3.6682471897635716,2.0651772903258325,0,-1.8538830625793763,-3.8699884200822821,-1.0278121464490433]
[null,25,"Oxfordshire, Surrey and Sussex",-1.1534795882494817,-2.6686285730042729,0,-1.8538830625793763,-5.142265509232276,-2.9213344917810855]
[null,26,"Somerset and Wessex",-1.2432608685373212,-3.9216457390154797,0,-1.8538830625793763,-6.2344605223290817,-3.4225413581855681]
[null,27,"West Devon and Cornwall",0.19566547189430367,-5.3017755490802738,0,-1.8538830625793763,-5.8996380299492914,-3.9745932822114858]

{"sheet":"T2","index":2,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 2 - 2018/19 Generation Tariffs"]
[]
[null,"Generation Tariffs ",null,"System Peak Tariff","Shared Year Round Tariff","Not Shared Year Round Tariff","Residual Tariff","Conventional 80% Load Factor","Intermittent 40% Load Factor"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",2.1702164131168451,12.0847466657602,20.513532365149111,-3.2036006033283315,29.147945507545785,22.143830428124858]
[null,2,"East Aberdeenshire",3.2410003360599515,4.7638595048177157,20.513532365149111,-3.2036006033283315,24.362019701734901,19.215475563747866]
[null,3,"Western Highlands",1.5896423554529553,11.354975464623983,20.135135572057109,-3.2036006033283315,27.605157695880919,21.473525154578368]
[null,4,"Skye and Lochalsh",1.5973579783027876,11.354975464623983,25.696390315493158,-3.2036006033283315,33.174128062166801,27.03477989801442]
[null,5,"Eastern Grampian and Tayside",3.303910724162233,9.8497572606310531,18.788793149495636,-3.2036006033283315,26.768909078834376,19.525095450419723]
[null,6,"Central Grampian",3.4504259963003618,9.8577915717174758,18.799150696408567,-3.2036006033283315,26.932209346754576,19.538666721767225]
[null,7,"Argyll",2.793271392353597,8.3391527633777329,27.149031952448283,-3.2036006033283315,33.410024952175732,27.281092454471043]
[null,8,"The Trossachs",3.0885334878080606,8.3391527633777329,16.772494664419,-3.2036006033283315,23.328749759600914,16.90455516644176]
[null,9,"Stirlingshire and Fife",1.6928772939165142,5.0010139968105936,14.321114892039017,-3.2036006033283315,16.811202780075675,13.117919887434924]
[null,10,"South West Scotland",2.616139029812893,6.4680130089765671,15.240509951516831,-3.2036006033283315,19.827458785182646,14.624114551779128]
[null,11,"Lothian and Borders",3.2536790723067184,6.4680130089765671,9.7035504088844498,-3.2036006033283315,14.928039285044091,9.0871550091467466]
[null,12,"Solway and Cheviot",1.7873716036478158,3.7398992951197476,8.5476326491234129,-3.2036006033283315,10.123323085538695,6.8399917638429812]
[null,13,"North East England",3.5470242004257377,2.180826581479729,4.5430031308160617,-3.2036006033283315,6.6310879930972515,2.2117331600796217]
[null,14,"North Lancashire and The Lakes",1.3521201039553772,2.180826581479729,3.2103541441149384,-3.2036006033283315,3.103534909925767,0.87908417337849842]
[null,15,"South Lancashire, Yorkshire and Humber",4.2180376226658556,0.64384213875124885,0.15137837866850584,-3.2036006033283315,1.6808891090070293,-2.7946853691593261]
[null,16,"North Midlands and North Wales",3.171105800920647,-0.67350005582167205,0,-3.2036006033283315,-0.57129484706502209,-3.4730006256570003]
[null,17,"South Lincolnshire and North Norfolk",1.460356775571837,0.1151510282761801,0,-3.2036006033283315,-1.6511230051355505,-3.1575401920178594]
[null,18,"Mid Wales and The Midlands",0.74633099348791965,0.32191172545013413,0,-3.2036006033283315,-2.1997402294803043,-3.0748359131482781]
[null,19,"Anglesey and Snowdon",4.6789023732576451,-1.3781976485814214,0,-3.2036006033283315,0.37274365106417617,-3.7548796627609002]
[null,20,"Pembrokeshire",9.0996195901380528,-3.8688509059884075,0,-3.2036006033283315,2.8009382620189949,-4.7511409657236943]
[null,21,"South Wales & Gloucester",6.1072514136489655,-3.9167741827317233,0,-3.2036006033283315,-0.22976853586474499,-4.7703102764210215]
[null,22,"Cotswold",3.0029600742893887,2.7258263088763481,-6.6800454742310889,-3.2036006033283315,-4.7000249561689529,-8.7933155540088812]
[null,23,"Central London",-5.9582050997738474,2.7258263088763481,-6.4915961030145093,-3.2036006033283315,-13.472740759015609,-8.6048661827923016]
[null,24,"Essex and Kent",-4.1148643614735709,2.7258263088763481,0,-3.2036006033283315,-5.1378039177008237,-2.1132700797777924]
[null,25,"Oxfordshire, Surrey and Sussex",-1.5104850675457071,-2.3443086743377108,0,-3.2036006033283315,-6.5895326103442073,-4.1413240730634158]
[null,26,"Somerset and Wessex",-1.166418414653827,-3.4706218277709775,0,-3.2036006033283315,-7.1465164801989403,-4.5918493344367226]
[null,27,"West Devon and Cornwall",0.20188212560112129,-4.9826324239642803,0,-3.2036006033283315,-6.9878244168986345,-5.1966535729140437]

{"sheet":"T3","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 3 - 2019/20 Generation Tariffs"]
[]
[null,"Generation Tariffs ",null,"System Peak Tariff","Shared Year Round Tariff","Not Shared Year Round Tariff","Residual Tariff","Conventional 80% Load Factor","Intermittent 40% Load Factor"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",2.4981138853098526,11.193763683572787,21.142366090359143,-4.754307730889793,27.841183191637434,20.865563832898467]
[null,2,"East Aberdeenshire",3.7349331632904987,4.3702451330475336,21.142366090359143,-4.754307730889793,23.619187629197878,18.136156412688365]
[null,3,"Western Highlands",2.5455882617838528,10.814414832062639,20.865996903860733,-4.754307730889793,27.308809300404903,20.437455105795998]
[null,4,"Skye and Lochalsh",2.5473013061372134,10.814414832062639,26.59530893191609,-4.754307730889793,33.039834372813623,26.166767133851355]
[null,5,"Eastern Grampian and Tayside",4.0901088139919048,9.4503116487273005,19.359383912243519,-4.754307730889793,26.255434314327474,18.385200840844647]
[null,6,"Central Grampian",4.3497067075879476,9.4554198017982003,19.367041982353797,-4.754307730889793,26.526776800490513,18.394902172183286]
[null,7,"Argyll",3.8095924721101362,7.9977325708380054,27.711267318488538,-4.754307730889793,33.164738116379283,26.156052615933948]
[null,8,"The Trossachs",3.9902697609304116,7.9977325708380054,17.115581581825879,-4.754307730889793,22.749729668536901,15.560366879271289]
[null,9,"Stirlingshire and Fife",2.2902342718534237,4.8778089271405376,14.42210223826959,-4.754307730889793,15.860275920945654,11.618918078236014]
[null,10,"South West Scotland",3.637937083026987,6.1425451345314199,15.362303119808393,-4.754307730889793,19.159968579570723,13.065013442731171]
[null,11,"Lothian and Borders",3.7416158039462206,6.1425451345314199,10.118529210709797,-4.754307730889793,14.019873391391364,7.8212395336325722]
[null,12,"Solway and Cheviot",2.0768218560553122,3.5501261816743446,8.5980533134761643,-4.754307730889793,8.7606683839811588,5.2637960552561092]
[null,13,"North East England",3.9952330780766832,2.00119404007763,4.3779241181229391,-4.754307730889793,5.2198046973719334,0.42409400326419799]
[null,14,"North Lancashire and The Lakes",1.8942007865249095,2.00119404007763,2.933024296444283,-4.754307730889793,1.6738725841415034,-1.0208058184144582]
[null,15,"South Lancashire, Yorkshire and Humber",4.520282076992129,0.35542001745600699,0.21126779920981639,-4.754307730889793,0.26157815927695793,-4.400871924697574]
[null,16,"North Midlands and North Wales",3.1333311959036485,-1.0415460133546783,0,-4.754307730889793,-2.4542133456698871,-5.1709261362316639]
[null,17,"South Lincolnshire and North Norfolk",1.280349450778919,0.57489944294435835,0,-4.754307730889793,-3.0140387257553871,-4.5243479537120495]
[null,18,"Mid Wales and The Midlands",0.62287917989516106,0.69077659190969753,0,-4.754307730889793,-3.5788072774668738,-4.4779970941259144]
[null,19,"Anglesey and Snowdon",5.5831900277647915,-2.2728230437015591,0,-4.754307730889793,-0.98937613808624914,-5.6634369483704168]
[null,20,"Pembrokeshire",9.1370647599490535,-3.7170316631735827,0,-4.754307730889793,1.4091316985203948,-6.2411203961592259]
[null,21,"South Wales & Gloucester",5.9421735791440762,-3.672168948630246,0,-4.754307730889793,-1.7498693106499137,-6.2231753103418912]
[null,22,"Cotswold",2.6608121988020565,3.3551989415783297,-6.9893674291381611,-4.754307730889793,-6.3987038079632335,-10.401595583396622]
[null,23,"Central London",-6.1175423425120012,3.3551989415783297,-6.7886858841298663,-4.754307730889793,-14.976376804268995,-10.200914038388326]
[null,24,"Essex and Kent",-4.3569279306224526,3.3551989415783297,0,-4.754307730889793,-6.4270765082495815,-3.4122281542584609]
[null,25,"Oxfordshire, Surrey and Sussex",-1.6087568593129562,-1.8022786409999958,0,-4.754307730889793,-7.804887503002746,-5.4752191872897917]
[null,26,"Somerset and Wessex",-1.7962034991363287,-1.5866254984401962,0,-4.754307730889793,-7.8198116287782788,-5.388957930265871]
[null,27,"West Devon and Cornwall",-0.99590264055889544,-4.8833565852106906,0,-4.754307730889793,-9.6568956396172414,-6.7076503649740697]

{"sheet":"T4","index":4,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 4  - 2020/21 Generation Tariffs"]
[]
[null,"Generation Tariffs ",null,"System Peak Tariff","Shared Year Round Tariff","Not Shared Year Round Tariff","Residual Tariff","Conventional 80% Load Factor","Intermittent 40% Load Factor"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",1.6873864463474288,12.873710038810609,20.55811525424642,-5.9485452078558048,26.595924523786532,19.75905406191486]
[null,2,"East Aberdeenshire",2.5774521722665811,6.2883831731676327,20.55811525424642,-5.9485452078558048,22.217728757191303,17.124923315657668]
[null,3,"Western Highlands",1.5318130002091048,12.135964353604159,19.946065624963033,-5.9485452078558048,25.238104900199662,18.851906158548893]
[null,4,"Skye and Lochalsh",1.5265537490760683,12.135964353604159,25.86172398571868,-5.9485452078558048,31.148504009822272,24.767564519304539]
[null,5,"Eastern Grampian and Tayside",2.8643813515779697,10.979741795669922,18.552173261512856,-5.9485452078558048,24.251802841770957,16.99552477192502]
[null,6,"Central Grampian",2.9589822279938325,11.14928609057106,18.823491363551121,-5.9485452078558048,24.753357256145996,17.33466059192374]
[null,7,"Argyll",2.4784886261366368,9.6665852355887907,27.558980919508926,-5.9485452078558048,31.822192526260789,25.477069805888636]
[null,8,"The Trossachs",2.6668023322831536,9.6665852355887907,16.383505882990331,-5.9485452078558048,20.835031195888714,14.301594769370045]
[null,9,"Stirlingshire and Fife",1.0894125013331215,6.3479018453317853,13.312399184772273,-5.9485452078558048,13.531587954515018,9.9030147150491832]
[null,10,"South West Scotland",2.0804657765736119,7.8832970007953493,14.540051189810008,-5.9485452078558048,16.978609359164093,11.744824782272342]
[null,11,"Lothian and Borders",3.7657582372395382,7.8832970007953493,9.2426573107225103,-5.9485452078558048,13.366507940742522,6.4474309031848449]
[null,12,"Solway and Cheviot",1.6044641361783818,5.2291679153608435,7.3768439887576438,-5.9485452078558048,7.2160972493688966,3.5199659470461775]
[null,13,"North East England",3.9378944066013548,4.3210987375097849,4.8213645180755469,-5.9485452078558048,6.2675927068289248,0.60125880522365627]
[null,14,"North Lancashire and The Lakes",1.4759991050337009,4.3210987375097849,0.95513880492708914,-5.9485452078558048,-6.052830788718655E-2,-3.2649669079248014]
[null,15,"South Lancashire, Yorkshire and Humber",4.1381624411318221,0.96769150235610535,7.242466203232506E-2,-5.9485452078558048,-0.96380490280677389,-5.489043944881038]
[null,16,"North Midlands and North Wales",3.5092389460989422,-0.94852725299934137,0,-5.9485452078558048,-3.1981280641563359,-6.327956109055541]
[null,17,"South Lincolnshire and North Norfolk",1.8394907870236612,5.4971048807826384E-2,1.3049330397143895E-16,-5.9485452078558048,-4.0650775817858822,-5.9265567883326744]
[null,18,"Mid Wales and The Midlands",1.6130412568010506,-0.13341826845652807,0,-5.9485452078558048,-4.4422385658199763,-6.0019125152384163]
[null,19,"Anglesey and Snowdon",5.2703674014235107,-1.8294258479384125,0,-5.9485452078558048,-2.1417184847830244,-6.6803155470311699]
[null,20,"Pembrokeshire",9.0757427086438494,-3.9415719948024774,0,-5.9485452078558048,-2.606009505393736E-2,-7.5251740057767957]
[null,21,"South Wales & Gloucester",5.8046777497328943,-3.9460675107337719,0,-5.9485452078558048,-3.3007214667099283,-7.5269722121493139]
[null,22,"Cotswold",2.4402645295257717,3.2609915019847309,-7.2092819136653912,-5.9485452078558048,-8.1087693904076392,-11.853430520727304]
[null,23,"Central London",-5.9018499328004239,3.2609915019847309,-7.1459672262188052,-5.9485452078558048,-16.38756916528725,-11.790115833280717]
[null,24,"Essex and Kent",-4.4153208455757085,3.2609915019847309,0,-5.9485452078558048,-7.7550728518437282,-4.6441486070619122]
[null,25,"Oxfordshire, Surrey and Sussex",-1.7201201182491703,-2.2155761854580769,0,-5.9485452078558048,-9.4411262744714364,-6.8347756820390355]
[null,26,"Somerset and Wessex",-0.83781890803937209,-1.6504992028031387,0,-5.9485452078558048,-8.1067634781376867,-6.6087448889770606]
[null,27,"West Devon and Cornwall",8.7766681772704497E-2,-4.1164440827068152,0,-5.9485452078558048,-9.1539337922485533,-7.5951228409385312]

{"sheet":"T5","index":5,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 5 - 2021/22 Generation Tariffs"]
[]
[null,"Generation Tariffs ",null,"System Peak Tariff","Shared Year Round Tariff","Not Shared Year Round Tariff","Residual Tariff","Conventional 80% Load Factor","Intermittent 40% Load Factor"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",3.0207235055343178,10.919436817435097,26.261280188780834,-7.6061571202046574,30.411396028058576,23.022897795550215]
[null,2,"East Aberdeenshire",1.299991611330271,7.944565985385232,24.030127064743436,-7.6061571202046574,24.079614344177237,19.601796338692871]
[null,3,"Western Highlands",2.7150213165265127,10.234164856399541,24.805630383948824,-7.6061571202046574,28.101826465390317,21.293139206303984]
[null,4,"Skye and Lochalsh",2.6925801414657293,10.234164856399541,32.836119255786436,-7.6061571202046574,36.109874162167145,29.323628078141596]
[null,5,"Eastern Grampian and Tayside",3.3808837331438708,9.3297381867224001,22.517314626236701,-7.6061571202046574,25.755831788553834,18.643052780721003]
[null,6,"Central Grampian",3.4346715935078693,9.4538746908243727,22.88449178489472,-7.6061571202046574,26.276106010857433,19.059884541019812]
[null,7,"Argyll",3.3059239965496063,8.4113399917716478,30.525058563814593,-7.6061571202046574,32.953897433576863,26.283437440318593]
[null,8,"The Trossachs",3.0344654341298627,8.4113399917716478,19.753544130023155,-7.6061571202046574,21.910924437365679,15.511923006527159]
[null,9,"Stirlingshire and Fife",1.6347352160853061,5.9693742418405797,15.458137086270508,-7.6061571202046574,14.262214575623624,10.239729662802084]
[null,10,"South West Scotland",1.9230900802852509,6.8489767721610821,16.824847441645836,-7.6061571202046574,16.620961819455296,11.958281030305614]
[null,11,"Lothian and Borders",3.4193820493154723,6.8489767721610821,11.570841807689835,-7.6061571202046574,12.863248154529515,6.7042753963496109]
[null,12,"Solway and Cheviot",1.4602527639584131,4.8114199068573873,8.8746578859646608,-7.6061571202046574,6.5778894552043274,3.1930687285029586]
[null,13,"North East England",4.0214430467057918,4.0730516518689877,5.908541687197097,-7.6061571202046574,5.5822689351934214,-6.8394772259964931E-2]
[null,14,"North Lancashire and The Lakes",1.2945970442891166,4.0730516518689877,2.0240529691803353,-7.6061571202046574,-1.0290657852400154,-3.9528834902767267]
[null,15,"South Lancashire, Yorkshire and Humber",4.5507202330811793,1.0415129507108742,0.29363509286517703,-7.6061571202046574,-1.9285914336896015,-6.8959168470551306]
[null,16,"North Midlands and North Wales",3.4055726987983048,-0.33409122409635256,0,-7.6061571202046574,-4.4678574006834344,-7.7397936098431988]
[null,17,"South Lincolnshire and North Norfolk",2.5305593975665981,-0.37911309208335819,0,-7.6061571202046574,-5.3788881963047457,-7.7578023570380008]
[null,18,"Mid Wales and The Midlands",1.456689154103654,0.3826624196243722,0,-7.6061571202046574,-5.8433380304015055,-7.453092152354909]
[null,19,"Anglesey and Snowdon",4.247012438126081,-0.50359315240550029,0,-7.6061571202046574,-3.7620192040029767,-7.8075943811668571]
[null,20,"Pembrokeshire",8.2564734500757009,-5.8134375572776058,0,-7.6061571202046574,-4.0004337159510417,-9.9315321431156995]
[null,21,"South Wales & Gloucester",4.2697840955346535,-6.3891927043986039,0,-7.6061571202046574,-8.4477271881888871,-10.161834201964099]
[null,22,"Cotswold",2.7503992897081377,2.6159122644466479,-7.3331852093583967,-7.6061571202046574,-10.096213228297598,-13.892977423784394]
[null,23,"Central London",-5.5837457754560287,2.6159122644466479,-7.03211335296296,-7.6061571202046574,-18.129286437066327,-13.591905567388959]
[null,24,"Essex and Kent",-3.7298660356611539,2.6159122644466479,0,-7.6061571202046574,-9.2432933443084924,-6.5597922144259986]
[null,25,"Oxfordshire, Surrey and Sussex",-1.2741222783663024,-2.7132420931306935,0,-7.6061571202046574,-11.050873073075515,-8.6914539574569343]
[null,26,"Somerset and Wessex",-0.82656429756400451,-2.4305685845175864,0,-7.6061571202046574,-10.377176285382731,-8.5783845540116914]
[null,27,"West Devon and Cornwall",-0.26280454076238269,-4.885556616081292,0,-7.6061571202046574,-11.777406953832074,-9.5603797666371744]

{"sheet":"T6","index":6,"n_rows":97,"n_cols":6,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
[]
["Table 6 – Onshore Local Circuit Tariffs "]
[]
["Connection Point","2017/18 (£/kW)","2018/19 (£/kW)","2019/20 (£/kW)","2020/21 (£/kW)","2021/22 (£/kW)"]
["Aberdeen Bay","-",2.4712914207725651,2.5454301633957415,2.6217500668286005,2.7004468603465428]
["Achruach",3.9398723759145851,4.059987118052315,4.1817045835365541,4.3070620941516875,-2.5930061377539153]
["Aigas",0.60154389781921658,0.61990048476424753,0.63849749930717514,0.65764602749252343,0.67738199701498258]
["An Suidhe",2.8196008135015309,-0.85530137176689192,-0.88055569154379998,-0.90683347390555924,-0.93446542776362462]
["Arecleoch",1.9102760433753663,1.9685696249516318,2.0276267137001813,2.0881418646489349,2.1511091805645224]
["Aultmore","-","-","-",1.686505890942376,1.7371295592872493]
["Baglan Bay",0.69950708534256822,0.72068683744197337,0.74231323126922766,0.76438288313595493,0.78752342170509959]
["Beinneun Wind Farm",1.3818937855355933,1.4233211957715193,1.4660208316446628,1.5100164724503391,1.5553015002918231]
["Benbrack & Quantans Hill","-","-",-4.4581067697894445,-4.5915499701950804,-4.7284745783316406]
["Bhlaraidh Wind Farm",0.59384051242067515,0.61196202447864945,0.630320885213009,0.64926046868348375,0.66870742712248255]
["Black Hill",0.79353930429905839,0.81775478264814294,0.84228742612757723,0.86758418514883429,0.89358273037875491]
["Black Law",1.6071552020196311,1.6561988118159989,1.705884776170479,1.7570325009272374,1.8097731590392612]
["BlackCraig Wind Farm",5.7899063481818596,5.9665899113753254,6.1455876087165864,6.3298636431140061,6.5198538940874258]
["BlackLaw Extension",3.4081806375412196,3.5121839603647134,3.6175494791756551,3.7260789207145661,3.837858242457453]
["Bodelwyddan",0.10582632278784415,0.1090556965748094,0.1123273674720537,0.11570005338504243,0.11916810415110177]
["Brochlock",1.3173824801775691,1.3575834465989907,1.3983109499969442,1.4403069884531783,1.4834680868517685]
["Carraig Gheal",4.0458275604148728,4.1697319189399238,4.2948196254715931,4.423588222715118,4.5563649269928055]
["Carrington",-3.2881977931769335E-2,-3.0796544411943454E-2,-3.1615904087578188E-2,-3.2426578701782768E-2,-0.18367290237801087]
["Clyde (North)",0.10086663646041698,0.10394466150356207,0.1070630013486686,0.11023038476926121,0.11358313813080288]
["Clyde (South)",0.11664738442277237,0.12020697144847442,0.12381318059192865,0.12747610625735384,0.13135340328997624]
["Corriegarth",3.4665658342800953,3.572350827475661,3.6795213522999224,3.7897682965232771,3.903604202654996]
["Corriemoillie",1.5306960974540813,1.5783124036208209,1.6256472954692802,1.6744555200429512,1.7246178313379514]
["Coryton",4.7815056719178337E-2,4.9269219466656314E-2,5.0805525354710772E-2,5.0631903137637789E-2,0.35792407997954639]
["Crossburns","-","-","-","-",0.31070484237071178]
["Cruachan",1.67679004526307,1.7361587002882628,1.7882461953232345,1.8412481625479247,1.8971196721847021]
["Crystal Rig",0.33492857509501639,3.1825468039911146E-2,4.2566741544061003E-2,0.3782334063274036,5.6467617531516266E-2]
["Culligran",1.5941054395642578,1.6427508255568561,1.6920333503235616,1.7427667812246026,1.795078181358267]
["Dalquhandy","-","-","-","-",1.0961678527233754]
["Deanie",2.6188875078555656,2.6988049277005488,2.7797690755315649,2.8631168548689891,2.9490570122314383]
["Dersalloch",2.2155143283657028,2.2831224971860409,2.3516161721016218,2.4221775070163356,2.4948295969826124]
["Didcot",0.47693755379158742,0.49336421150989546,0.77710107113448512,0.8009607573754578,0.54157439085846149]
["Dinorwig",2.206750185574879,2.2740909096588968,2.3423136369486635,2.4126449717309382,2.484960537438837]
["Dorenell","-",1.9891332550899299,2.0488072527426278,2.1103399098213305,2.1735796144346535]
["Dumnaglass",1.7076087379583333,1.7597177667092974,1.8125092997105676,1.8667544451528582,1.9228911160629494]
["Dunlaw Extension",1.3791725636141288,1.4238147892580391,1.4659048633116103,1.5100852338218618,1.5562013552042553]
["Earlshaugh Wind Farm",3.4645217482666011,3.574140082501005,3.6815832826363892,3.7921105761044358,3.9071233335254485]
["Edinbane",-6.2915434301704289,6.4892543125841531,6.6839288339549867,6.8843304644980226,7.0909733636685601]
["EnochHill","-","-","-",1.6755089720030119,1.72573957583196]
["Ewe Hill",1.2639173068413023,1.302486741289018,1.3415613435276885,1.3818719434817393,1.4232624293485245]
["FAAR","-",3.3793731268598166,3.4807543206656106,3.5851202356620395,3.6927322587941465]
["Fallago",0.90548255344309525,0.19119094759949135,0.21155538870027404,1.0080616050370554,0.2495911525550196]
["Ffestiniogg",0.2326964073339455,0.23979732191143091,0.24699124156877383,0.25430557587229979,0.26203300818031222]
["Finlarig",0.29450487995124158,0.30349192886680643,0.31259668673281055,0.32196930645263477,0.33163382495483806]
["Foyers",0.692563340987146,0.71369745809789364,0.7351083818408225,0.75685604510126114,0.77987648229493967]
["Galawhistle",0.77841256357845257,1.4018436714323912,1.4438989815753627,1.4871915583764588,1.5318324295533015]
["Gills Bay","-",2.3869599061079163,2.4585687032911543,2.532407891785597,2.608295537321585]
["Glen Kyllachy","-","-",0.44656669533258619,0.45995615207519319,0.47376260707834073]
["Glendoe",1.6918128160679411,1.7434398197919518,1.7957430143857103,1.8496194348864441,1.9051037639618003]
["Glenmorie","-","-","-",1.9931433256591704,2.0529712973394778]
["GlenUllinish","-","-","-","-",2.368813035391705]
["Gordonbush",0.37603678546724734,1.1112018881555841,1.1501618117856132,0.23590093898325926,0.22565423124814382]
["Griffin Wind",-0.84561859489925839,-0.86851442212646635,4.1865978341950862,4.3447897804125777,10.069254144200325]
["Hadyard Hill",2.5457829599421582,2.6234695367934471,2.7021736228972499,2.7831940380592024,2.8667359965316921]
["Harestanes",2.3049277746883905,2.379160183350129,2.4507539865109864,2.5242979041481739,2.6013365332660081]
["Hartlepool",0.55278231773891118,0.56974848232356456,0.58678454558690418,0.60410128125954354,0.14799012852231222]
["Hedon",0.16641203963488685,0.17150632351295814,0.17665330528313189,0.1818813817013219,0.18741537568489283]
["Hornsea 1","-",0.68921995380404555,0.71027560436278026,0.77208675791529124,0.79558587234988909]
["Invergarry",1.3051835975624058,1.3454398394267058,1.3858934703399546,1.4275379946760758,1.4703724324636454]
["Kergord","-","-","-","-",123.71324405315102]
["Kilbraur",0.2374714969901057,0.73780846932219346,0.76515437595856672,0.10421216112542685,9.1198689791446311E-2]
["Kilgallioch",0.96799433377335597,0.99753344507450314,1.0274594484267385,1.0578561118985501,1.0900317288359269]
["Kilmorack",0.18164490221564664,0.18718793981062654,0.1928035780049461,0.19858565683052837,0.20454531590544733]
["Kings Lynn","-","-","-",0.42397352095456903,0.43668125111186018]
["Knottingley","-","-",-0.10428782883285831,-0.1067684806168708,-0.11068124336386508]
["Kype Muir","-",1.4058587048833839,1.4480344660298856,1.4915443199485443,1.5362197650111062]
["Langage",0.60479198346497531,0.62319627321466442,0.64189633322704021,-0.3386961085593766,-0.34880494632146158]
["Lochay",0.33657700565856158,0.34684791870492138,0.35725335626606902,0.36796492166015465,0.37901008566267264]
["Luichart",0.52793774123857673,0.54495408451407279,0.56128822678932788,0.57813012486058069,0.59543929537539175]
["Marchwood",0.35127870449966586,0.36187566695398493,0.3727294886414847,0.3841976414859215,0.39570697670673149]
["Margree",5.5374735939379383,5.706453972346635,5.8776475915170341,6.0538899518688893,6.2355963298404209]
["Mark Hill",0.80530621045010242,0.82988076523004839,0.85477718818695037,0.88006516872232254,0.90683311894753549]
["Middle Muir","-",1.8787595596516566,1.9351223464412073,1.9931433256591715,2.0529712973394778]
["Millennium South","-",0.8931337654553323,0.91995327679684014,0.94759532765356902,0.97597788426558418]
["Millennium Wind ",1.6802418188064974,1.7307735548156062,1.7826967614600737,1.8361901340116402,1.8912629942329922]
["Moffat",0.15504215104432814,0.16366910262244375,0.16879817336147068,0.17392196704393709,0.18040961109568709]
["Mossford",2.6487054789965927,2.7304387240800949,2.8123374055423307,2.8967334085419036,2.9835773691144554]
["Nant",2.3083458920858577,2.3792290076621083,2.4506016268554456,2.5240748316400596,2.5998340522609342]
["Necton",1.0344102580306127,1.0658350866580422,1.0978021894901149,1.1307242227377297,1.1646329743741484]
["New Deer","-","-",0.61336535415109317,0.63176631477562606,0.65071930421889479]
["Rhigos",9.3346946606972306E-2,9.6115884256005382E-2,9.901817060752946E-2,0.10199583593407908,0.10505585317123819]
["Rocksavage",1.6271435577435454E-2,1.6772216482767253E-2,1.7275188688470226E-2,-1.7793256836701174E-2,-1.8326863777970909E-2]
["Saltend",0.3135848686988561,0.32318311893343937,0.33288183821805584,0.3427333559802957,0.35316133356356805]
["South Humber Bank",0.8674916006283222,0.89687209683537994,0.92415682472624172,0.98370042441242411,0.3926815495975563]
["Spalding",0.25540675919761102,0.26447652513845243,0.66836741735922933,0.68845728697671327,0.2896652355263592]
["Stornoway","-","-","-","-",96.123026635610259]
["Strathy Wind",2.0183520697142665,1.9486392239183374,1.997084917325278,1.8615985986924133,1.9025687625744012]
["Stronelairg",1.3324062042173357,1.3641213068847051,1.4037583653663026,1.4466271391558732,1.4883862395413141]
["Tom Na Clach","-",1.878759559651658,1.9351223464412073,1.9931433256591709,2.0529712973394765]
["Ulziside",8.9316367544828399,9.2041927013380587,9.4803184823781823,9.7649434601946439,10.057669877955032]
["Wester Dodds",0.64789857488428926,0.35434599445433618,0.37476288375091837,0.72041122090383214,0.40889450479877154]
["Whitelee",9.7612873993952021E-2,0.10059160790667275,0.10360935614387293,0.10667456590573671,0.1099191659330348]
["Whitelee Extension",0.27136378970318675,0.27964466998055038,0.28803401007996671,0.29655529321794716,0.30557528129383665]
["Willow","-","-","-",1.5331871735839775,1.579208690261136]

{"sheet":"T7","index":7,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,4,2],[3,3,3,5]]}
[]
[null,"Table 7 – 2018/19 Onshore Local Substation Tariffs"]
[]
[null,"Substation Rating","Connection Type","Local Substation Tariff (£/kW)"]
[null,null,null,"132kV","275kV","400kV"]
[null,"<1320 MW","No redundancy",0.19029799999999999,0.108863,7.8437999999999994E-2]
[null,"<1320 MW","Redundancy",0.419211,0.25936799999999999,0.188634]
[null,">=1320 MW","No redundancy",0,0.341333,0.24685299999999999]
[null,">=1320 MW","Redundancy",0,0.56038100000000002,0.40903099999999998]

{"sheet":"T8","index":8,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,1,4,1],[3,2,3,4]]}
[]
[null,"Table 8 – 2018/19 Offshore Local Tariffs"]
[]
[null,"Offshore Generator","Tariff Component (£/kW)"]
[null,null,"Substation","Circuit","ETUoS"]
[null,"Robin Rigg East",-0.43854011627368433,29.049564086905271,9.0037967928947396]
[null,"Robin Rigg West",-0.43854011627368433,29.049564086905271,9.0037967928947396]
[null,"Gunfleet Sands 1 & 2",16.596112597200005,15.236531475315793,2.8477953466736854]
[null,"Barrow",7.6684173343263184,40.121150581294742,0.99626350566315813]
[null,"Ormonde",23.706627232389479,44.163226134126326,0.35194381345263165]
[null,"Walney 1",20.45994292547369,40.745924480526327,0]
[null,"Walney 2",20.311143659084216,41.104897442178959,0]
[null,"Thanet",17.442769471678105,32.502114235891199,0.78244066780486665]
[null,"Sheringham Shoal",22.90471063934336,26.861860112681931,0.58389788687227495]
[null,"Greater Gabbard",14.37738053669551,33.037804773089654,0]
[null,"London Array",9.755488197395449,33.226649698878809,0]
[null,"Lincs",14.331000590470389,56.109142732807967,0]
[null,"Humber Gateway",13.933438564085785,31.438481235699879,0]
[null,"West of Duddon Sands",7.8949334100567272,38.956603806186081,0]
[null,"Westermost Rough",16.624076487959563,28.120823487435395,0]
[null,"Gwynt Y Mor",17.509348476221057,17.248871183210532,0]

{"sheet":"T9","index":9,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,4,6,6]]}
[]
[null,"Table 9 - Small Generator Discount"]
[]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Small Generator Discount (£/kW)",-11.351718,-12.243778000000001,"Discontinued"]
[null,"Included in HH Tariffs below (£/kW)",0.55224502910287654,0.70217482761748884]
[null,"Included in NHH Tariffs below (p/kWh)",7.5173695664380466E-2,9.5341712880720617E-2]

{"sheet":"T10","index":10,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,4,1],[3,2,4,2]]}
[]
[null,"Table 10 – Half-Hour Demand Tariffs",null,null,null,null,null,null,null,"Figure 3 - Half Hour Demand Tariffs"]
[]
[null,"Zone","Zone Name","17/18 ","18/19 ","19/20","20/21 ","21/22 "]
[null,null,null,"(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"Northern Scotland",29.577678632287913,47.198075997413461,53.957947323790414,59.83242615700815,64.775539891502262]
[null,2,"Southern Scotland",30.480981292263362,32.06734321112684,37.19688876799357,43.503656068163586,47.004206252398603]
[null,3,"Northern",39.223189345703574,43.058949071044019,48.698406618606967,53.613326925146374,58.599389818490067]
[null,4,"North West",45.245665385684219,49.961849951674118,55.842687161981374,61.637254482418463,66.935206648736695]
[null,5,"Yorkshire",44.967106975809635,49.844919435192409,55.700058398421248,61.174330667211855,66.427637216928645]
[null,6,"N Wales & Mersey",46.791119349549064,51.292558480981278,57.175674016208156,63.237148172583183,69.084447447978405]
[null,7,"East Midlands",47.889102828530575,53.178359735833816,59.203341378910345,64.972758001255869,70.50267295037473]
[null,8,"Midlands",49.457443659855223,54.491823269194441,60.486237448252147,66.434640585866021,72.40780754434455]
[null,9,"Eastern",49.617070410733149,54.947707298362516,60.662801941359014,66.49182561810872,72.325592480230227]
[null,10,"South Wales",45.551887109764252,50.609673473569245,56.362041022963155,62.575426118807563,71.968036428933047]
[null,11,"South East",52.537577427049257,57.305005673304272,63.151432125842454,69.138630696311168,75.210211834742935]
[null,12,"London",54.969648691968111,60.156259447773614,66.018213430024161,72.089843378734415,78.107382653310424]
[null,13,"Southern",53.405079522679799,58.442708753379584,63.852977014444683,69.997406093609328,76.378584433955922]
[null,14,"South Western",51.95558266680645,56.886937525662944,63.506484776891568,67.444149354772122,74.777717067988448]

{"sheet":"T11","index":11,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7],[3,1,4,1],[3,2,4,2]]}
[]
[null,"Table 11 – Non Half-Hour Demand Tariffs",null,null,null,null,null,null,null,"Figure 4 - Non-Half Hour Demand Tariffs"]
[]
[null,"Zone","Zone Name","17/18 ","18/19 ","19/20","20/21 ","21/22 "]
[null,null,null,"(p/kWh)","(p/kWh)","(p/kWh)","(p/kWh)","(p/kWh)"]
[null,1,"Northern Scotland",6.2156080486078134,10.781961677964235,13.488736712118339,16.48353501241462,19.515291787100679]
[null,2,"Southern Scotland",4.26274657676373,4.5329706412185233,5.3258071817701707,6.4103976296176732,7.128367373120823]
[null,3,"Northern",5.9434932353381562,6.6653909630730848,7.7328452881862892,8.8636556555333286,10.07674602382353]
[null,4,"North West",5.8781852477560523,6.4365018599422283,7.1184233348453336,7.905337122716027,8.6478305042155128]
[null,5,"Yorkshire",5.9787826001230284,6.5630838860899745,7.2486085004383094,7.9974481779173479,8.7309565369362971]
[null,6,"N Wales & Mersey",6.607274125394766,7.3031819377000478,8.2203910492484162,9.3298908891263714,10.463994820291983]
[null,7,"East Midlands",6.2487955308333438,6.8328424236388461,7.4669202564620161,8.1742918495084353,8.8539420941507245]
[null,8,"Midlands",6.4263167030941792,6.9625767017871114,7.5735788552075318,8.2833667948563985,8.99535422223477]
[null,9,"Eastern",7.0951344242047512,7.889447248865995,8.7548355828406059,9.8002693376989196,10.890233151123569]
[null,10,"South Wales",5.7753695281434307,6.3180926333252456,6.9022935229768976,7.6429285841118313,8.7759514768015183]
[null,11,"South East",7.4752199591476929,8.2014679603269833,9.1020287339263461,10.197731762516012,11.357165327258743]
[null,12,"London",5.4873780214557382,5.4957687033634217,5.3664818755771924,5.227633130488833,4.9728620054990431]
[null,13,"Southern",7.047919709454991,7.623327133824354,8.2135969506208308,9.0240086681573235,9.8752399381322249]
[null,14,"South Western",7.4648134118615435,8.2404012595423044,9.2893622525662227,10.122366763969955,11.51919630819963]

{"sheet":"T12","index":12,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Table 12  - Contracted and Modelled TEC"]
[]
[null,"Best View","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Contracted TEC (GW)",72.2,79.569060000000007,91.115760000000023,108.65706000000003,121.36126000000002]
[null,"Modelled TEC (GW)",72.2,72.619660000000025,73.829560000000015,82.909960000000027,90.930460000000025]
[null,"Chargeable TEC (GW)",67.599999999999994,66.834660000000014,66.94456000000001,73.224960000000024,77.845460000000017]
[]
[]
[null,"All TEC"," \n","2018/19","2019/20","2020/21","2021/22"]
[null,"Contracted TEC (GW)",null,79.569060000000007,91.115760000000023,108.65706000000003,121.36126000000002]
[null,"Modelled TEC (GW)",null,79.569060000000007,91.115760000000023,108.65706000000003,121.36126000000002]
[null,"Chargeable TEC (GW)",null,73.784060000000011,84.230760000000018,98.972060000000027,108.27626000000001]
[]
[]
[null,"Sustained Coal"," \n","2018/19","2019/20","2020/21","2021/22"]
[null,"Contracted TEC (GW)",null,79.569060000000007,91.115760000000023,108.65706000000003,121.36126000000002]
[null,"Modelled TEC (GW)",null,76.426660000000012,79.636560000000031,89.248960000000025,98.724460000000008]
[null,"Chargeable TEC (GW)",null,70.641660000000016,72.751560000000026,79.563960000000023,85.63946]
[]
[]
[null,"Accelerated Offshore"," \n","2018/19","2019/20","2020/21","2021/22"]
[null,"Contracted TEC (GW)",null,79.569060000000007,91.115760000000023,108.65706000000003,121.36126000000002]
[null,"Modelled TEC (GW)",null,72.748660000000015,74.279560000000018,83.899960000000021,95.195460000000011]
[null,"Chargeable TEC (GW)",null,66.963660000000019,67.394560000000013,74.214960000000019,82.110460000000003]

{"sheet":"T13","index":13,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Table 13 – Calculation of Generator and Demand Revenue Proportions"]
[]
[null," ",null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5,2.5,2.5]
[null,"y","Error Margin",0.21,0.21,0.21,0.21,0.21]
[null,"ER","Exchange Rate (€/£)",1.27,1.1100000000000001,1.1000000000000001,1.0900000000000001,1.0900000000000001]
[null,"MAR","Total Revenue (£m)",2631.4836569216873,2833.4608886620958,3062.5709590024871,3288.6993525016792,3475.9190488216145]
[null,"GO","Generation Output (TWh)",250.95,239.90199022627161,229.30098717930065,216.78560700898657,204.35420376476401]
[null,"G","% of revenue from generation",{"$f":"D5*(1-D6)*D9/D7/D8","v":0.14830298821627588},{"$f":"E5*(1-E6)*E9/E7/E8","v":0.15064709097467607},{"$f":"F5*(1-F6)*F9/F7/F8","v":0.13442937493353127},{"$f":"G5*(1-G6)*G9/G7/G8","v":0.11943919675456072},{"$f":"H5*(1-H6)*H9/H7/H8","v":0.10652573133819385}]
[null,"D","% of revenue from demand",{"$f":"1-D10","v":0.85169701178372414},{"$f":"1-E10","v":0.8493529090253239},{"$f":"1-F10","v":0.86557062506646876},{"$f":"1-G10","v":0.88056080324543928},{"$f":"1-H10","v":0.89347426866180613}]
[null,"G.MAR","Revenue recovered from generation (£m)",{"$f":"D8*D10","v":390.25688976377955},{"$f":"E8*E10","v":426.85264026746529},{"$f":"F8*F10","v":411.69949970828975},{"$f":"G8*G10","v":392.79960903004451},{"$f":"H8*H10","v":370.2748187480816}]
[null,"D.MAR","Revenue recovered from demand (£m)",{"$f":"D8*D11","v":2241.2267671579079},{"$f":"E8*E11","v":2406.6082483946307},{"$f":"F8*F11","v":2650.8714592941974},{"$f":"G8*G11","v":2895.8997434716348},{"$f":"H8*H11","v":3105.644230073533}]

{"sheet":"T14","index":14,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 14 – Transmission Owner Revenues"]
[]
[null,"£m Nominal","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"National Grid"]
[null,"Price controlled revenue",1748.7570980414512,1727.770785133421,1794.5191728226666,1942.0266095568991,2008.8008115326274]
[null,"Less income from connections",41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999]
[null,"Income from TNUoS",1706.8744856414512,1685.888172733421,1752.6365604226667,1900.1439971568991,1966.9181991326275]
[]
[null,"Scottish Power Transmission"]
[null,"Price controlled revenue",333.7,390.54065630478544,449.58476464809411,430.5806896088979,465.80949946454081]
[null,"Less income from connections",12.75,26.779541984732823,27.755333333333329,28.953558590941771,28.978072625698324]
[null,"Income from TNUoS",320.95,363.76111432005263,421.82943131476077,401.62713101795612,436.8314268388425]
[]
[null,"SHE Transmission"]
[null,"Price controlled revenue",304.7,366.48655954513987,378.04100527710841,375.16575305517694,415.34424290465637]
[null,"Less income from connections",3.35,3.2440075136088322,2.7055295180722894,2.7741752766175716,2.8707531650096558]
[null,"Income from TNUoS",301.34999999999997,363.24255203153103,375.33547575903611,372.39157777855934,412.47348973964671]
[]
[null,"Offshore",270.20460754023685,380.16603753882629,472.47871877631263,574.03664654826468,619.195933110498]
[null,"Network Innovation Competition",32.071100479999998,40.5,40.5,40.5,40.5]
[null,"Total to Collect from TNUoS",2631.450193661688,2833.5578766238309,3062.7801862727765,3288.6993525016792,3475.9190488216145]

{"sheet":"T15","index":15,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 15 – Inflation Indices"]
[]
[null,"2009/10",null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,1,null,1.2709999999999999,1.3089999999999999,1.343,1.3839999999999999,1.4259999999999999]

{"sheet":"T16","index":16,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 16 – Demand Forecasts"]
[]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Average System Demand at Triad (GW)",47.684350893042456,46.43,45.43,45.15,44.97]
[null,"Average HH Metered Demand at Triad (GW)",13.227054908495282,14.25,15.31,16.52,17.73]
[null,"NHH Annual Energy between 4pm and 7pm (TWh)",25.313203316155612,23.7,22.25,20.87,19.579999999999998]
[]
[]
[]
[null,"`"]

{"sheet":"T17","index":17,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 17 – Expansion Constants"]
[]
[null,"£/MWkm","17/18 ","18/19 ","19/20","20/21 ","21/22"]
[null,"Expansion Constant",13.574496066616412,13.988732530796636,14.408394506720535,14.840646341922152,15.285865732179817]

{"sheet":"T18","index":18,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 18 – Interconnector Adjustments"]
[]
[null,"Interconnector","Zone","Adjustment (MW)"]
[null,"Aquind Interconnector",26,"2000 from 2021/22"]
[null,"Auchencrosh (interconnector CCT)",10,80]
[null,"Belgium Interconnector (Nemo)",24,"1000 from 2018/19"]
[null,"Britned",24,1200]
[null,"East West Interconnector",16,505]
[null,"ElecLink",24,1000]
[null,"FAB Link Interconnector",26,"1400 from 2020/21"]
[null,"IFA Interconnector",24,2000]
[null,"IFA2 Interconnector",26,"1100 from 2019/20"]
[null,"Norway Interconnector",2,"1400 from 2021/22"]
[null,"NS Link",13,"1400 from 2020/21"]

{"sheet":"T19","index":19,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 19 - Wider tariffs for a Conventional 80% load factor generator",null,null,null,null,null,null,null,"Figure 1 – Wider tariffs for a conventional 80% generator"]
[]
[null,"Wider Tariffs for a Conventional 80% Generator",null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",{"$f":"'T1'!H6","v":24.606137184142881},{"$f":"'T2'!H6","v":29.147945507545785},{"$f":"'T3'!H6","v":27.841183191637434},{"$f":"'T4'!H6","v":26.595924523786532},{"$f":"'T5'!H6","v":30.411396028058576}]
[null,2,"East Aberdeenshire",{"$f":"'T1'!H7","v":20.311829078361136},{"$f":"'T2'!H7","v":24.362019701734901},{"$f":"'T3'!H7","v":23.619187629197878},{"$f":"'T4'!H7","v":22.217728757191303},{"$f":"'T5'!H7","v":24.079614344177237}]
[null,3,"Western Highlands",{"$f":"'T1'!H8","v":22.484930022235467},{"$f":"'T2'!H8","v":27.605157695880919},{"$f":"'T3'!H8","v":27.308809300404903},{"$f":"'T4'!H8","v":25.238104900199662},{"$f":"'T5'!H8","v":28.101826465390317}]
[null,4,"Skye and Lochalsh",{"$f":"'T1'!H9","v":16.412173819382829},{"$f":"'T2'!H9","v":33.174128062166801},{"$f":"'T3'!H9","v":33.039834372813623},{"$f":"'T4'!H9","v":31.148504009822272},{"$f":"'T5'!H9","v":36.109874162167145}]
[null,5,"Eastern Grampian and Tayside",{"$f":"'T1'!H10","v":21.689677596731649},{"$f":"'T2'!H10","v":26.768909078834376},{"$f":"'T3'!H10","v":26.255434314327474},{"$f":"'T4'!H10","v":24.251802841770957},{"$f":"'T5'!H10","v":25.755831788553834}]
[null,6,"Central Grampian",{"$f":"'T1'!H11","v":25.785551835494243},{"$f":"'T2'!H11","v":26.932209346754576},{"$f":"'T3'!H11","v":26.526776800490513},{"$f":"'T4'!H11","v":24.753357256145996},{"$f":"'T5'!H11","v":26.276106010857433}]
[null,7,"Argyll",{"$f":"'T1'!H12","v":31.670187190725763},{"$f":"'T2'!H12","v":33.410024952175732},{"$f":"'T3'!H12","v":33.164738116379283},{"$f":"'T4'!H12","v":31.822192526260789},{"$f":"'T5'!H12","v":32.953897433576863}]
[null,8,"The Trossachs",{"$f":"'T1'!H13","v":21.537447798890504},{"$f":"'T2'!H13","v":23.328749759600914},{"$f":"'T3'!H13","v":22.749729668536901},{"$f":"'T4'!H13","v":20.835031195888714},{"$f":"'T5'!H13","v":21.910924437365679}]
[null,9,"Stirlingshire and Fife",{"$f":"'T1'!H14","v":14.29669614206445},{"$f":"'T2'!H14","v":16.811202780075675},{"$f":"'T3'!H14","v":15.860275920945654},{"$f":"'T4'!H14","v":13.531587954515018},{"$f":"'T5'!H14","v":14.262214575623624}]
[null,10,"South West Scotland",{"$f":"'T1'!H15","v":19.068785950564902},{"$f":"'T2'!H15","v":19.827458785182646},{"$f":"'T3'!H15","v":19.159968579570723},{"$f":"'T4'!H15","v":16.978609359164093},{"$f":"'T5'!H15","v":16.620961819455296}]
[null,11,"Lothian and Borders",{"$f":"'T1'!H16","v":15.076184080117111},{"$f":"'T2'!H16","v":14.928039285044091},{"$f":"'T3'!H16","v":14.019873391391364},{"$f":"'T4'!H16","v":13.366507940742522},{"$f":"'T5'!H16","v":12.863248154529515}]
[null,12,"Solway and Cheviot",{"$f":"'T1'!H17","v":9.1814875796062925},{"$f":"'T2'!H17","v":10.123323085538695},{"$f":"'T3'!H17","v":8.7606683839811588},{"$f":"'T4'!H17","v":7.2160972493688966},{"$f":"'T5'!H17","v":6.5778894552043274}]
[null,13,"North East England",{"$f":"'T1'!H18","v":7.1230474643163664},{"$f":"'T2'!H18","v":6.6310879930972515},{"$f":"'T3'!H18","v":5.2198046973719334},{"$f":"'T4'!H18","v":6.2675927068289248},{"$f":"'T5'!H18","v":5.5822689351934214}]
[null,14,"North Lancashire and The Lakes",{"$f":"'T1'!H19","v":3.9924364241481261},{"$f":"'T2'!H19","v":3.103534909925767},{"$f":"'T3'!H19","v":1.6738725841415034},{"$f":"'T4'!H19","v":-6.052830788718655E-2},{"$f":"'T5'!H19","v":-1.0290657852400154}]
[null,15,"South Lancashire, Yorkshire and Humber",{"$f":"'T1'!H20","v":2.7628751008427539},{"$f":"'T2'!H20","v":1.6808891090070293},{"$f":"'T3'!H20","v":0.26157815927695793},{"$f":"'T4'!H20","v":-0.96380490280677389},{"$f":"'T5'!H20","v":-1.9285914336896015}]
[null,16,"North Midlands and North Wales",{"$f":"'T1'!H21","v":1.1308309571629891},{"$f":"'T2'!H21","v":-0.57129484706502209},{"$f":"'T3'!H21","v":-2.4542133456698871},{"$f":"'T4'!H21","v":-3.1981280641563359},{"$f":"'T5'!H21","v":-4.4678574006834344}]
[null,17,"South Lincolnshire and North Norfolk",{"$f":"'T1'!H22","v":7.1701894604222272E-2},{"$f":"'T2'!H22","v":-1.6511230051355505},{"$f":"'T3'!H22","v":-3.0140387257553871},{"$f":"'T4'!H22","v":-4.0650775817858822},{"$f":"'T5'!H22","v":-5.3788881963047457}]
[null,18,"Mid Wales and The Midlands",{"$f":"'T1'!H23","v":-0.7831752460302106},{"$f":"'T2'!H23","v":-2.1997402294803043},{"$f":"'T3'!H23","v":-3.5788072774668738},{"$f":"'T4'!H23","v":-4.4422385658199763},{"$f":"'T5'!H23","v":-5.8433380304015055}]
[null,19,"Anglesey and Snowdon",{"$f":"'T1'!H24","v":1.1982755011345947},{"$f":"'T2'!H24","v":0.37274365106417617},{"$f":"'T3'!H24","v":-0.98937613808624914},{"$f":"'T4'!H24","v":-2.1417184847830244},{"$f":"'T5'!H24","v":-3.7620192040029767}]
[null,20,"Pembrokeshire",{"$f":"'T1'!H25","v":4.0874653121955689},{"$f":"'T2'!H25","v":2.8009382620189949},{"$f":"'T3'!H25","v":1.4091316985203948},{"$f":"'T4'!H25","v":-2.606009505393736E-2},{"$f":"'T5'!H25","v":-4.0004337159510417}]
[null,21,"South Wales & Gloucester",{"$f":"'T1'!H26","v":1.1438352227908373},{"$f":"'T2'!H26","v":-0.22976853586474499},{"$f":"'T3'!H26","v":-1.7498693106499137},{"$f":"'T4'!H26","v":-3.3007214667099283},{"$f":"'T5'!H26","v":-8.4477271881888871}]
[null,22,"Cotswold",{"$f":"'T1'!H27","v":-3.1112536514869777},{"$f":"'T2'!H27","v":-4.7000249561689529},{"$f":"'T3'!H27","v":-6.3987038079632335},{"$f":"'T4'!H27","v":-8.1087693904076392},{"$f":"'T5'!H27","v":-10.096213228297598}]
[null,23,"Central London",{"$f":"'T1'!H28","v":-9.9579788523038086},{"$f":"'T2'!H28","v":-13.472740759015609},{"$f":"'T3'!H28","v":-14.976376804268995},{"$f":"'T4'!H28","v":-16.38756916528725},{"$f":"'T5'!H28","v":-18.129286437066327}]
[null,24,"Essex and Kent",{"$f":"'T1'!H29","v":-3.8699884200822821},{"$f":"'T2'!H29","v":-5.1378039177008237},{"$f":"'T3'!H29","v":-6.4270765082495815},{"$f":"'T4'!H29","v":-7.7550728518437282},{"$f":"'T5'!H29","v":-9.2432933443084924}]
[null,25,"Oxfordshire, Surrey and Sussex",{"$f":"'T1'!H30","v":-5.142265509232276},{"$f":"'T2'!H30","v":-6.5895326103442073},{"$f":"'T3'!H30","v":-7.804887503002746},{"$f":"'T4'!H30","v":-9.4411262744714364},{"$f":"'T5'!H30","v":-11.050873073075515}]
[null,26,"Somerset and Wessex",{"$f":"'T1'!H31","v":-6.2344605223290817},{"$f":"'T2'!H31","v":-7.1465164801989403},{"$f":"'T3'!H31","v":-7.8198116287782788},{"$f":"'T4'!H31","v":-8.1067634781376867},{"$f":"'T5'!H31","v":-10.377176285382731}]
[null,27,"West Devon and Cornwall",{"$f":"'T1'!H32","v":-5.8996380299492914},{"$f":"'T2'!H32","v":-6.9878244168986345},{"$f":"'T3'!H32","v":-9.6568956396172414},{"$f":"'T4'!H32","v":-9.1539337922485533},{"$f":"'T5'!H32","v":-11.777406953832074}]

{"sheet":"T20","index":20,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Table 20 - Wider tariffs for an Intermittent 40% load factor generator",null,null,null,null,null,null,null,"Figure 2 - Wider tariffs for an intermittent 40% load factor generator"]
[]
[null,"Wider Tariffs for an Intermittent 40% Generator",null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",{"$f":"'T1'!I6","v":19.83211295431391},{"$f":"'T2'!I6","v":22.143830428124858},{"$f":"'T3'!I6","v":20.865563832898467},{"$f":"'T4'!I6","v":19.75905406191486},{"$f":"'T5'!I6","v":23.022897795550215}]
[null,2,"East Aberdeenshire",{"$f":"'T1'!I7","v":17.286790162389643},{"$f":"'T2'!I7","v":19.215475563747866},{"$f":"'T3'!I7","v":18.136156412688365},{"$f":"'T4'!I7","v":17.124923315657668},{"$f":"'T5'!I7","v":19.601796338692871}]
[null,3,"Western Highlands",{"$f":"'T1'!I8","v":18.857948124176886},{"$f":"'T2'!I8","v":21.473525154578368},{"$f":"'T3'!I8","v":20.437455105795998},{"$f":"'T4'!I8","v":18.851906158548893},{"$f":"'T5'!I8","v":21.293139206303984}]
[null,4,"Skye and Lochalsh",{"$f":"'T1'!I9","v":18.60103002369884},{"$f":"'T2'!I9","v":27.03477989801442},{"$f":"'T3'!I9","v":26.166767133851355},{"$f":"'T4'!I9","v":24.767564519304539},{"$f":"'T5'!I9","v":29.323628078141596}]
[null,5,"Eastern Grampian and Tayside",{"$f":"'T1'!I10","v":17.834979991792096},{"$f":"'T2'!I10","v":19.525095450419723},{"$f":"'T3'!I10","v":18.385200840844647},{"$f":"'T4'!I10","v":16.99552477192502},{"$f":"'T5'!I10","v":18.643052780721003}]
[null,6,"Central Grampian",{"$f":"'T1'!I11","v":19.311153262144302},{"$f":"'T2'!I11","v":19.538666721767225},{"$f":"'T3'!I11","v":18.394902172183286},{"$f":"'T4'!I11","v":17.33466059192374},{"$f":"'T5'!I11","v":19.059884541019812}]
[null,7,"Argyll",{"$f":"'T1'!I12","v":26.901882595474202},{"$f":"'T2'!I12","v":27.281092454471043},{"$f":"'T3'!I12","v":26.156052615933948},{"$f":"'T4'!I12","v":25.477069805888636},{"$f":"'T5'!I12","v":26.283437440318593}]
[null,8,"The Trossachs",{"$f":"'T1'!I13","v":16.541497513852519},{"$f":"'T2'!I13","v":16.90455516644176},{"$f":"'T3'!I13","v":15.560366879271289},{"$f":"'T4'!I13","v":14.301594769370045},{"$f":"'T5'!I13","v":15.511923006527159}]
[null,9,"Stirlingshire and Fife",{"$f":"'T1'!I14","v":12.865053220960098},{"$f":"'T2'!I14","v":13.117919887434924},{"$f":"'T3'!I14","v":11.618918078236014},{"$f":"'T4'!I14","v":9.9030147150491832},{"$f":"'T5'!I14","v":10.239729662802084}]
[null,10,"South West Scotland",{"$f":"'T1'!I15","v":14.833893465812698},{"$f":"'T2'!I15","v":14.624114551779128},{"$f":"'T3'!I15","v":13.065013442731171},{"$f":"'T4'!I15","v":11.744824782272342},{"$f":"'T5'!I15","v":11.958281030305614}]
[null,11,"Lothian and Borders",{"$f":"'T1'!I16","v":9.717912069575819},{"$f":"'T2'!I16","v":9.0871550091467466},{"$f":"'T3'!I16","v":7.8212395336325722},{"$f":"'T4'!I16","v":6.4474309031848449},{"$f":"'T5'!I16","v":6.7042753963496109}]
[null,12,"Solway and Cheviot",{"$f":"'T1'!I17","v":7.2147906050065576},{"$f":"'T2'!I17","v":6.8399917638429812},{"$f":"'T3'!I17","v":5.2637960552561092},{"$f":"'T4'!I17","v":3.5199659470461775},{"$f":"'T5'!I17","v":3.1930687285029586}]
[null,13,"North East England",{"$f":"'T1'!I18","v":3.1618720682449535},{"$f":"'T2'!I18","v":2.2117331600796217},{"$f":"'T3'!I18","v":0.42409400326419799},{"$f":"'T4'!I18","v":0.60125880522365627},{"$f":"'T5'!I18","v":-6.8394772259964931E-2}]
[null,14,"North Lancashire and The Lakes",{"$f":"'T1'!I19","v":1.9729828945126739},{"$f":"'T2'!I19","v":0.87908417337849842},{"$f":"'T3'!I19","v":-1.0208058184144582},{"$f":"'T4'!I19","v":-3.2649669079248014},{"$f":"'T5'!I19","v":-3.9528834902767267}]
[null,15,"South Lancashire, Yorkshire and Humber",{"$f":"'T1'!I20","v":-1.4622068224827607},{"$f":"'T2'!I20","v":-2.7946853691593261},{"$f":"'T3'!I20","v":-4.400871924697574},{"$f":"'T4'!I20","v":-5.489043944881038},{"$f":"'T5'!I20","v":-6.8959168470551306}]
[null,16,"North Midlands and North Wales",{"$f":"'T1'!I21","v":-2.2342940990359961},{"$f":"'T2'!I21","v":-3.4730006256570003},{"$f":"'T3'!I21","v":-5.1709261362316639},{"$f":"'T4'!I21","v":-6.327956109055541},{"$f":"'T5'!I21","v":-7.7397936098431988}]
[null,17,"South Lincolnshire and North Norfolk",{"$f":"'T1'!I22","v":-1.9879637762891522},{"$f":"'T2'!I22","v":-3.1575401920178594},{"$f":"'T3'!I22","v":-4.5243479537120495},{"$f":"'T4'!I22","v":-5.9265567883326744},{"$f":"'T5'!I22","v":-7.7578023570380008}]
[null,18,"Mid Wales and The Midlands",{"$f":"'T1'!I23","v":-1.9333361655293644},{"$f":"'T2'!I23","v":-3.0748359131482781},{"$f":"'T3'!I23","v":-4.4779970941259144},{"$f":"'T4'!I23","v":-6.0019125152384163},{"$f":"'T5'!I23","v":-7.453092152354909}]
[null,19,"Anglesey and Snowdon",{"$f":"'T1'!I24","v":-2.5355062454372677},{"$f":"'T2'!I24","v":-3.7548796627609002},{"$f":"'T3'!I24","v":-5.6634369483704168},{"$f":"'T4'!I24","v":-6.6803155470311699},{"$f":"'T5'!I24","v":-7.8075943811668571}]
[null,20,"Pembrokeshire",{"$f":"'T1'!I25","v":-3.4076587394809317},{"$f":"'T2'!I25","v":-4.7511409657236943},{"$f":"'T3'!I25","v":-6.2411203961592259},{"$f":"'T4'!I25","v":-7.5251740057767957},{"$f":"'T5'!I25","v":-9.9315321431156995}]
[null,21,"South Wales & Gloucester",{"$f":"'T1'!I26","v":-3.4315647734949426},{"$f":"'T2'!I26","v":-4.7703102764210215},{"$f":"'T3'!I26","v":-6.2231753103418912},{"$f":"'T4'!I26","v":-7.5269722121493139},{"$f":"'T5'!I26","v":-10.161834201964099}]
[null,22,"Cotswold",{"$f":"'T1'!I27","v":-7.0839984464178132},{"$f":"'T2'!I27","v":-8.7933155540088812},{"$f":"'T3'!I27","v":-10.401595583396622},{"$f":"'T4'!I27","v":-11.853430520727304},{"$f":"'T5'!I27","v":-13.892977423784394}]
[null,23,"Central London",{"$f":"'T1'!I28","v":-6.5144968987598011},{"$f":"'T2'!I28","v":-8.6048661827923016},{"$f":"'T3'!I28","v":-10.200914038388326},{"$f":"'T4'!I28","v":-11.790115833280717},{"$f":"'T5'!I28","v":-13.591905567388959}]
[null,24,"Essex and Kent",{"$f":"'T1'!I29","v":-1.0278121464490433},{"$f":"'T2'!I29","v":-2.1132700797777924},{"$f":"'T3'!I29","v":-3.4122281542584609},{"$f":"'T4'!I29","v":-4.6441486070619122},{"$f":"'T5'!I29","v":-6.5597922144259986}]
[null,25,"Oxfordshire, Surrey and Sussex",{"$f":"'T1'!I30","v":-2.9213344917810855},{"$f":"'T2'!I30","v":-4.1413240730634158},{"$f":"'T3'!I30","v":-5.4752191872897917},{"$f":"'T4'!I30","v":-6.8347756820390355},{"$f":"'T5'!I30","v":-8.6914539574569343}]
[null,26,"Somerset and Wessex",{"$f":"'T1'!I31","v":-3.4225413581855681},{"$f":"'T2'!I31","v":-4.5918493344367226},{"$f":"'T3'!I31","v":-5.388957930265871},{"$f":"'T4'!I31","v":-6.6087448889770606},{"$f":"'T5'!I31","v":-8.5783845540116914}]
[null,27,"West Devon and Cornwall",{"$f":"'T1'!I32","v":-3.9745932822114858},{"$f":"'T2'!I32","v":-5.1966535729140437},{"$f":"'T3'!I32","v":-6.7076503649740697},{"$f":"'T4'!I32","v":-7.5951228409385312},{"$f":"'T5'!I32","v":-9.5603797666371744}]

{"sheet":"T21","index":21,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 21 - Changes in Half-Hour Metered Tariffs"]
[]
[null,"Zone","Zone Name","Difference 17/18 to 18/19 (£/kW)","Difference 18/19 to 19/20 (£/kW)","Difference 19/20 to 20/21 (£/kW)","Difference 20/21 to 21/22 (£/kW)"]
[null,1,"Northern Scotland",{"$f":"'T10'!E6-'T10'!D6","v":17.620397365125548},{"$f":"'T10'!F6-'T10'!E6","v":6.7598713263769525},{"$f":"'T10'!G6-'T10'!F6","v":5.8744788332177365},{"$f":"'T10'!H6-'T10'!G6","v":4.9431137344941121}]
[null,2,"Southern Scotland",{"$f":"'T10'!E7-'T10'!D7","v":1.5863619188634779},{"$f":"'T10'!F7-'T10'!E7","v":5.1295455568667307},{"$f":"'T10'!G7-'T10'!F7","v":6.3067673001700157},{"$f":"'T10'!H7-'T10'!G7","v":3.5005501842350171}]
[null,3,"Northern",{"$f":"'T10'!E8-'T10'!D8","v":3.835759725340445},{"$f":"'T10'!F8-'T10'!E8","v":5.639457547562948},{"$f":"'T10'!G8-'T10'!F8","v":4.9149203065394076},{"$f":"'T10'!H8-'T10'!G8","v":4.9860628933436928}]
[null,4,"North West",{"$f":"'T10'!E9-'T10'!D9","v":4.7161845659898987},{"$f":"'T10'!F9-'T10'!E9","v":5.8808372103072557},{"$f":"'T10'!G9-'T10'!F9","v":5.7945673204370891},{"$f":"'T10'!H9-'T10'!G9","v":5.2979521663182325}]
[null,5,"Yorkshire",{"$f":"'T10'!E10-'T10'!D10","v":4.8778124593827741},{"$f":"'T10'!F10-'T10'!E10","v":5.8551389632288391},{"$f":"'T10'!G10-'T10'!F10","v":5.4742722687906067},{"$f":"'T10'!H10-'T10'!G10","v":5.2533065497167897}]
[null,6,"N Wales & Mersey",{"$f":"'T10'!E11-'T10'!D11","v":4.501439131432214},{"$f":"'T10'!F11-'T10'!E11","v":5.883115535226878},{"$f":"'T10'!G11-'T10'!F11","v":6.0614741563750272},{"$f":"'T10'!H11-'T10'!G11","v":5.8472992753952227}]
[null,7,"East Midlands",{"$f":"'T10'!E12-'T10'!D12","v":5.2892569073032405},{"$f":"'T10'!F12-'T10'!E12","v":6.0249816430765293},{"$f":"'T10'!G12-'T10'!F12","v":5.7694166223455241},{"$f":"'T10'!H12-'T10'!G12","v":5.5299149491188615}]
[null,8,"Midlands",{"$f":"'T10'!E13-'T10'!D13","v":5.0343796093392186},{"$f":"'T10'!F13-'T10'!E13","v":5.9944141790577063},{"$f":"'T10'!G13-'T10'!F13","v":5.9484031376138731},{"$f":"'T10'!H13-'T10'!G13","v":5.9731669584785294}]
[null,9,"Eastern",{"$f":"'T10'!E14-'T10'!D14","v":5.3306368876293675},{"$f":"'T10'!F14-'T10'!E14","v":5.7150946429964975},{"$f":"'T10'!G14-'T10'!F14","v":5.8290236767497063},{"$f":"'T10'!H14-'T10'!G14","v":5.8337668621215073}]
[null,10,"South Wales",{"$f":"'T10'!E15-'T10'!D15","v":5.0577863638049934},{"$f":"'T10'!F15-'T10'!E15","v":5.7523675493939095},{"$f":"'T10'!G15-'T10'!F15","v":6.2133850958444086},{"$f":"'T10'!H15-'T10'!G15","v":9.3926103101254839}]
[null,11,"South East",{"$f":"'T10'!E16-'T10'!D16","v":4.7674282462550153},{"$f":"'T10'!F16-'T10'!E16","v":5.8464264525381822},{"$f":"'T10'!G16-'T10'!F16","v":5.9871985704687134},{"$f":"'T10'!H16-'T10'!G16","v":6.0715811384317675}]
[null,12,"London",{"$f":"'T10'!E17-'T10'!D17","v":5.1866107558055035},{"$f":"'T10'!F17-'T10'!E17","v":5.8619539822505473},{"$f":"'T10'!G17-'T10'!F17","v":6.0716299487102532},{"$f":"'T10'!H17-'T10'!G17","v":6.0175392745760092}]
[null,13,"Southern",{"$f":"'T10'!E18-'T10'!D18","v":5.0376292306997854},{"$f":"'T10'!F18-'T10'!E18","v":5.4102682610650987},{"$f":"'T10'!G18-'T10'!F18","v":6.1444290791646452},{"$f":"'T10'!H18-'T10'!G18","v":6.3811783403465938}]
[null,14,"South Western",{"$f":"'T10'!E19-'T10'!D19","v":4.9313548588564942},{"$f":"'T10'!F19-'T10'!E19","v":6.6195472512286244},{"$f":"'T10'!G19-'T10'!F19","v":3.9376645778805539},{"$f":"'T10'!H19-'T10'!G19","v":7.3335677132163255}]

{"sheet":"T22","index":22,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,6],[3,1,4,1],[3,2,4,2]]}
[]
[null,"Table 22  - Changes in Non-Half-hour Metered Tariffs"]
[]
[null,"Zone","Zone Name","Difference 17/18 to 18/19","Difference 18/19 to 19/20","Difference 19/20 to 20/21","Difference 20/21 to 21/22"]
[null,null,null,"(p/kWh)","(p/kWh)","(p/kWh)","(p/kWh)"]
[null,1,"Northern Scotland",{"$f":"'T11'!E6-'T11'!D6","v":4.5663536293564215},{"$f":"'T11'!F6-'T11'!E6","v":2.7067750341541039},{"$f":"'T11'!G6-'T11'!F6","v":2.9947983002962815},{"$f":"'T11'!H6-'T11'!G6","v":3.031756774686059}]
[null,2,"Southern Scotland",{"$f":"'T11'!E7-'T11'!D7","v":0.2702240644547933},{"$f":"'T11'!F7-'T11'!E7","v":0.79283654055164732},{"$f":"'T11'!G7-'T11'!F7","v":1.0845904478475026},{"$f":"'T11'!H7-'T11'!G7","v":0.71796974350314979}]
[null,3,"Northern",{"$f":"'T11'!E8-'T11'!D8","v":0.72189772773492855},{"$f":"'T11'!F8-'T11'!E8","v":1.0674543251132045},{"$f":"'T11'!G8-'T11'!F8","v":1.1308103673470393},{"$f":"'T11'!H8-'T11'!G8","v":1.2130903682902012}]
[null,4,"North West",{"$f":"'T11'!E9-'T11'!D9","v":0.55831661218617601},{"$f":"'T11'!F9-'T11'!E9","v":0.68192147490310528},{"$f":"'T11'!G9-'T11'!F9","v":0.78691378787069333},{"$f":"'T11'!H9-'T11'!G9","v":0.74249338149948585}]
[null,5,"Yorkshire",{"$f":"'T11'!E10-'T11'!D10","v":0.58430128596694608},{"$f":"'T11'!F10-'T11'!E10","v":0.68552461434833489},{"$f":"'T11'!G10-'T11'!F10","v":0.74883967747903846},{"$f":"'T11'!H10-'T11'!G10","v":0.73350835901894929}]
[null,6,"N Wales & Mersey",{"$f":"'T11'!E11-'T11'!D11","v":0.69590781230528176},{"$f":"'T11'!F11-'T11'!E11","v":0.91720911154836848},{"$f":"'T11'!G11-'T11'!F11","v":1.1094998398779552},{"$f":"'T11'!H11-'T11'!G11","v":1.1341039311656118}]
[null,7,"East Midlands",{"$f":"'T11'!E12-'T11'!D12","v":0.58404689280550226},{"$f":"'T11'!F12-'T11'!E12","v":0.63407783282316998},{"$f":"'T11'!G12-'T11'!F12","v":0.70737159304641928},{"$f":"'T11'!H12-'T11'!G12","v":0.67965024464228918}]
[null,8,"Midlands",{"$f":"'T11'!E13-'T11'!D13","v":0.53625999869293217},{"$f":"'T11'!F13-'T11'!E13","v":0.61100215342042041},{"$f":"'T11'!G13-'T11'!F13","v":0.70978793964886666},{"$f":"'T11'!H13-'T11'!G13","v":0.71198742737837151}]
[null,9,"Eastern",{"$f":"'T11'!E14-'T11'!D14","v":0.79431282466124387},{"$f":"'T11'!F14-'T11'!E14","v":0.8653883339746109},{"$f":"'T11'!G14-'T11'!F14","v":1.0454337548583137},{"$f":"'T11'!H14-'T11'!G14","v":1.0899638134246494}]
[null,10,"South Wales",{"$f":"'T11'!E15-'T11'!D15","v":0.54272310518181488},{"$f":"'T11'!F15-'T11'!E15","v":0.58420088965165196},{"$f":"'T11'!G15-'T11'!F15","v":0.74063506113493371},{"$f":"'T11'!H15-'T11'!G15","v":1.133022892689687}]
[null,11,"South East",{"$f":"'T11'!E16-'T11'!D16","v":0.72624800117929045},{"$f":"'T11'!F16-'T11'!E16","v":0.90056077359936282},{"$f":"'T11'!G16-'T11'!F16","v":1.0957030285896661},{"$f":"'T11'!H16-'T11'!G16","v":1.1594335647427307}]
[null,12,"London",{"$f":"'T11'!E17-'T11'!D17","v":8.3906819076835504E-3},{"$f":"'T11'!F17-'T11'!E17","v":-0.12928682778622935},{"$f":"'T11'!G17-'T11'!F17","v":-0.13884874508835932},{"$f":"'T11'!H17-'T11'!G17","v":-0.25477112498978993}]
[null,13,"Southern",{"$f":"'T11'!E18-'T11'!D18","v":0.57540742436936299},{"$f":"'T11'!F18-'T11'!E18","v":0.59026981679647683},{"$f":"'T11'!G18-'T11'!F18","v":0.81041171753649266},{"$f":"'T11'!H18-'T11'!G18","v":0.85123126997490139}]
[null,14,"South Western",{"$f":"'T11'!E19-'T11'!D19","v":0.77558784768076094},{"$f":"'T11'!F19-'T11'!E19","v":1.0489609930239183},{"$f":"'T11'!G19-'T11'!F19","v":0.83300451140373255},{"$f":"'T11'!H19-'T11'!G19","v":1.396829544229675}]

{"sheet":"T23","index":23,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 23 - Calculation of Residuals"]
[]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"RG (£/kW)",{"$f":"((C9*C7)-C10-C12-C13-C14)/C15","v":-1.853327994632828},{"$f":"((D9*D7)-D10-D12-D13-D14)/D15","v":-3.2036006033283271},{"$f":"((E9*E7)-E10-E12-E13-E14)/E15","v":-4.5358727154677032},{"$f":"((F9*F7)-F10-F12-F13-F14)/F15","v":-5.9485452076334351},{"$f":"((G9*G7)-G10-G12-G13-G14)/G15","v":-7.6061571202046592}]
[null,"RD (£/kW)",{"$f":"((C9*C8)-C11)/C16","v":47.301861566140332},{"$f":"((D9*D8)-D11)/D16","v":52.242687115919537},{"$f":"((E9*E8)-E11)/E16","v":58.235155390940058},{"$f":"((F9*F8)-F11)/F16","v":64.604218903196696},{"$f":"((G9*G8)-G11)/G16","v":69.591790547320969}]
[null,"G",{"$f":"'T13'!D10","v":0.14830298821627588},{"$f":"'T13'!E10","v":0.15064709097467607},{"$f":"'T13'!F10","v":0.13442937493353127},{"$f":"'T13'!G10","v":0.11943919675456072},{"$f":"'T13'!H10","v":0.10652573133819385}]
[null,"D",{"$f":"'T13'!D11","v":0.85169701178372414},{"$f":"'T13'!E11","v":0.8493529090253239},{"$f":"'T13'!F11","v":0.86557062506646876},{"$f":"'T13'!G11","v":0.88056080324543928},{"$f":"'T13'!H11","v":0.89347426866180613}]
[null,"R (£m)",{"$f":"'T13'!D8","v":2631.4836569216873},{"$f":"'T13'!E8","v":2833.4608886620958},{"$f":"'T13'!F8","v":3062.5709590024871},{"$f":"'T13'!G8","v":3288.6993525016792},{"$f":"'T13'!H8","v":3475.9190488216145}]
[null,"ZG (£m)",274.96728874315193,313.20792838474574,317.67337348057549,343.22449301876679,444.98766498082716]
[null,"ZD (£m)",-14.331797656046701,-19.019714397513546,5.2483498837906968,-20.980740007695672,-23.898590839490847]
[null,"O (£m)",208.46816305662131,293.90104300000002,365.81949564539377,444.95326215751248,480.35314373067013]
[null,"LC (£m)",14.605960191185485,16.877452513783155,15.978597832491145,21.236999628995289,17.070670201951401]
[null,"LS (£m)",17.50045021,16.977773468180001,15.88003590282,18.966839111919999,19.968139689240001]
[null,"BG (£m)",{"$f":"'T12'!C7","v":67.599999999999994},{"$f":"'T12'!D7","v":66.834660000000014},{"$f":"'T12'!E7","v":66.94456000000001},{"$f":"'T12'!F7","v":73.224960000000024},{"$f":"'T12'!G7","v":77.845460000000017}]
[null,"BD (£m)",{"$f":"'T16'!C5","v":47.684350893042456},{"$f":"'T16'!D5","v":46.43},{"$f":"'T16'!E5","v":45.43},{"$f":"'T16'!F5","v":45.15},{"$f":"'T16'!G5","v":44.97}]

{"sheet":"T24","index":24,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 24 - 2018/19 Generation Scenarios - Wider Generation Peak 80% Tariffs"]
[]
[]
[null,"Wider Tariffs for a Conventional 80% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",29.147945507545785,29.93143987761453,28.267357609026703,29.141049170479889]
[null,2,"East Aberdeenshire",24.362019701734901,25.10860283160671,23.500838818473436,24.356393582849144]
[null,3,"Western Highlands",27.605157695880919,28.2818432584127,26.749443718786626,27.598820568391574]
[null,4,"Skye and Lochalsh",33.174128062166801,33.873182436210406,32.321335930270976,33.167888712814509]
[null,5,"Eastern Grampian and Tayside",26.768909078834376,27.49412649970639,25.942900206909592,26.762953466844195]
[null,6,"Central Grampian",26.932209346754576,27.681512321249819,26.189529179526545,26.925366773559119]
[null,7,"Argyll",33.410024952175732,34.228863833527797,32.79938947777817,33.403233319584437]
[null,8,"The Trossachs",23.328749759600914,24.024535798333012,22.584331311585206,23.320261367570488]
[null,9,"Stirlingshire and Fife",16.811202780075675,17.316313428098354,15.799005421972083,16.803401308085348]
[null,10,"South West Scotland",19.827458785182646,20.616356037988368,19.364724721590431,19.819487637923125]
[null,11,"Lothian and Borders",14.928039285044091,15.517609875392532,14.876255833358922,14.925560437777522]
[null,12,"Solway and Cheviot",10.123323085538695,10.791508974081657,9.783602877832255,10.123038010331767]
[null,13,"North East England",6.6310879930972515,6.6522605007356272,6.9364338796985905,6.6333792409358363]
[null,14,"North Lancashire and The Lakes",3.103534909925767,4.021376861481853,3.0072092160772486,3.1089855810360509]
[null,15,"South Lancashire, Yorkshire and Humber",1.6808891090070293,1.681183354190126,1.8584587636828513,1.6873904479513522]
[null,16,"North Midlands and North Wales",-0.57129484706502209,-0.34230288339565407,-0.10383970153466882,-0.56363985320141463]
[null,17,"South Lincolnshire and North Norfolk",-1.6511230051355505,-1.614747242672038,-1.2903035686774378,-1.6442767560099052]
[null,18,"Mid Wales and The Midlands",-2.1997402294803043,-2.0893325366813564,-1.8782851209969949,-2.1790750753003927]
[null,19,"Anglesey and Snowdon",0.37274365106417617,1.0390974867500935,0.22950798739691036,0.38279485184783191]
[null,20,"Pembrokeshire",2.8009382620189949,1.3686822145670963,2.4521589212240422,2.8083500326731894]
[null,21,"South Wales & Gloucester",-0.22976853586474499,-1.7164157202360495,-0.70087936046313626,-0.22237541861117371]
[null,22,"Cotswold",-4.7000249561689529,-6.2959083292654325,-5.3081453619087835,-4.6927807663748098]
[null,23,"Central London",-13.472740759015609,-13.516694776422133,-13.093331974852765,-13.465879007865885]
[null,24,"Essex and Kent",-5.1378039177008237,-5.4095911254567826,-5.0017725748897348,-5.129933991873294]
[null,25,"Oxfordshire, Surrey and Sussex",-6.5895326103442073,-6.7320830379378087,-6.2382990165341656,-6.5812795609334476]
[null,26,"Somerset and Wessex",-7.1465164801989403,-9.0812459043471545,-8.3629899840946571,-7.140089236023381]
[null,27,"West Devon and Cornwall",-6.9878244168986345,-10.304118732116784,-9.5388358670140256,-6.9805411636894714]

{"sheet":"T25","index":25,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 25 - 2018/19 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"]
[]
[]
[null,"Wider Tariffs for an Intermittent 40% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",22.143830428124858,22.77879635029317,21.67450086451942,22.138432589235585]
[null,2,"East Aberdeenshire",19.215475563747866,19.833161663930298,18.758549935749606,19.210712833948683]
[null,3,"Western Highlands",21.473525154578368,22.03015791451088,21.019211881676821,21.468516876871966]
[null,4,"Skye and Lochalsh",27.03477989801442,27.613617702108002,26.58310194409599,27.029869398445072]
[null,5,"Eastern Grampian and Tayside",19.525095450419723,20.103025936970816,19.084788177324555,19.520378625832571]
[null,6,"Central Grampian",19.538666721767225,20.11695827536677,19.136140441915661,19.533232757220809]
[null,7,"Argyll",27.281092454471043,27.911805790734327,26.98224263988012,27.276017849795601]
[null,8,"The Trossachs",16.90455516644176,17.423048985255306,16.488495690379363,16.89778380232719]
[null,9,"Stirlingshire and Fife",13.117919887434924,13.527017701761975,12.603053240701524,13.111656366178886]
[null,10,"South West Scotland",14.624114551779128,15.17260469695101,14.314973123857445,14.617728926039158]
[null,11,"Lothian and Borders",9.0871550091467466,9.5859458395794785,8.9021521126356653,9.0862616833997158]
[null,12,"Solway and Cheviot",6.8399917638429812,7.1182891127365853,6.5616568782570255,6.84034719118055]
[null,13,"North East England",2.2117331600796217,2.1816165317809002,2.1294668048024676,2.2143589880820675]
[null,14,"North Lancashire and The Lakes",0.87908417337849842,1.0915495987675143,0.69389856304674602,0.88486942465264562]
[null,15,"South Lancashire, Yorkshire and Humber",-2.7946853691593261,-2.7370451270754441,-2.9003818254900446,-2.7883099090538881]
[null,16,"North Midlands and North Wales",-3.4730006256570003,-3.5062297753887566,-3.4573066991039547,-3.4659758891800911]
[null,17,"South Lincolnshire and North Norfolk",-3.1575401920178594,-3.3609357522616099,-3.1727151228512431,-3.15091982790993]
[null,18,"Mid Wales and The Midlands",-3.0748359131482781,-3.1983875362336041,-3.0297076040902713,-3.0613060965132162]
[null,19,"Anglesey and Snowdon",-3.7548796627609002,-3.5776414855404051,-3.5537532791391122,-3.7466568228239678]
[null,20,"Pembrokeshire",-4.7511409657236943,-5.1211412231471005,-4.7967618418720619,-4.7442378408514898]
[null,21,"South Wales & Gloucester",-4.7703102764210215,-5.1209254996613129,-4.8474228766136251,-4.7634164782491286]
[null,22,"Cotswold",-8.7933155540088812,-9.3422328551725506,-9.0196005559672052,-8.7868090875833982]
[null,23,"Central London",-8.6048661827923016,-8.6624114448321858,-8.4791659367074885,-8.5987421550112408]
[null,24,"Essex and Kent",-2.1132700797777924,-2.3054636127774804,-2.134035838369567,-2.106137877318921]
[null,25,"Oxfordshire, Surrey and Sussex",-4.1413240730634158,-4.2637819801502834,-4.095789271315148,-4.1340003088129302]
[null,26,"Somerset and Wessex",-4.5918493344367226,-5.0484220089490499,-4.8611109084241129,-4.5854384728038386]
[null,27,"West Devon and Cornwall",-5.1966535729140437,-5.9481748598730517,-5.765901916537282,-5.1898147067643556]

{"sheet":"T26","index":26,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 26 - 2018/19 Generation Scenarios - HH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",47.198075997413461,46.313884128660334,48.153186371879485,47.208330085747988]
[null,2,"Southern Scotland",32.06734321112684,31.198702940977608,32.811750243558386,32.079895151888103]
[null,3,"Northern",43.058949071044019,42.741225588801314,42.945067185990794,43.062283224505919]
[null,4,"North West",49.961849951674118,49.095250668864054,49.842820235609693,49.961307168180667]
[null,5,"Yorkshire",49.844919435192409,49.702485844824857,49.521444851148367,49.844478898424036]
[null,6,"N Wales & Mersey",51.292558480981278,50.353680832559398,51.245727805398161,51.289008771554116]
[null,7,"East Midlands",53.178359735833816,52.885423088073892,52.850872705113879,53.177145666819193]
[null,8,"Midlands",54.491823269194441,54.051482766627537,54.428446399869841,54.489748106022695]
[null,9,"Eastern",54.947707298362516,54.902651044055666,54.502119087114011,54.946758348761243]
[null,10,"South Wales",50.609673473569245,52.108025953941777,50.988111588214217,50.60818264028876]
[null,11,"South East",57.305005673304272,57.783460256843682,57.279586569825319,57.303886622547637]
[null,12,"London",60.156259447773614,60.194857017755666,59.75502956311648,60.155217420541035]
[null,13,"Southern",58.442708753379584,59.147547549561175,58.596843250208323,58.441454852275399]
[null,14,"South Western",56.886937525662944,59.159986087900094,58.300261325947794,56.885553896083678]

{"sheet":"T27","index":27,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 27 - 2018/19 Generation Scenarios - NHH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",10.781961677964235,10.578844332760379,11.00156166565715,10.784311185572021]
[null,2,"Southern Scotland",4.5329706412185233,4.4100794511318782,4.6382960540789986,4.5347460816858467]
[null,3,"Northern",6.6653909630730848,6.6161298512374831,6.6477424048566274,6.6659066319114189]
[null,4,"North West",6.4365018599422283,6.324937301837724,6.421173455260349,6.4364325345374835]
[null,5,"Yorkshire",6.5630838860899745,6.5443333414193807,6.5205075347671988,6.5630262297040449]
[null,6,"N Wales & Mersey",7.3031819377000478,7.1694233005053922,7.2965152667529765,7.3026756755964399]
[null,7,"East Midlands",6.8328424236388461,6.7952235460956363,6.7907897652178244,6.8326871202654784]
[null,8,"Midlands",6.9625767017871114,6.9063500756580911,6.9544788087618912,6.9623123981045376]
[null,9,"Eastern",7.889447248865995,7.8829823270861779,7.8254307522284652,7.8893102893068425]
[null,10,"South Wales",6.3180926333252456,6.5049033196616257,6.3652693237523046,6.3179076079450684]
[null,11,"South East",8.2014679603269833,8.2699960578610696,8.1978337871261253,8.2013071243234972]
[null,12,"London",5.4957687033634217,5.4992243150060629,5.459286583642462,5.4956775370840782]
[null,13,"Southern",7.623327133824354,7.7152152113211034,7.6434181418838456,7.6231640741078213]
[null,14,"South Western",8.2404012595423044,8.5699335605927693,8.4452972252117426,8.2401999634832475]

{"sheet":"T28","index":28,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 28 - 2019/20 Generation Scenarios - Wider Generation Peak 80% Tariffs"]
[]
[]
[null,"Wider Tariffs for a Conventional 80% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",28.54333126792314,28.109675051050822,27.724821806795301,27.900521058693236]
[null,2,"East Aberdeenshire",24.209195976328413,23.185946592171369,23.55736872632022,23.682998365494285]
[null,3,"Western Highlands",28.006745173402113,26.917987738844602,27.219975109406224,27.370554812330731]
[null,4,"Skye and Lochalsh",33.735092277870777,32.678175684944769,32.954514391811735,33.10195991448294]
[null,5,"Eastern Grampian and Tayside",26.905103376239644,25.718075889291775,26.132784853242878,26.318938498971704]
[null,6,"Central Grampian",27.172955653480869,25.649758818231021,26.342763467389862,26.58953016019683]
[null,7,"Argyll",33.799139886750389,32.260313979237623,33.118331232659926,33.230940356205458]
[null,8,"The Trossachs",23.414099110246752,21.828062680471589,22.539229550743297,22.807022470764004]
[null,9,"Stirlingshire and Fife",16.516936701989597,14.986096056890391,15.630200672351595,15.911611678564077]
[null,10,"South West Scotland",19.83224702086483,18.078795758609807,18.588990648758017,19.223026127418883]
[null,11,"Lothian and Borders",14.609037576752602,13.849457418674733,13.962318952048026,14.083719123396031]
[null,12,"Solway and Cheviot",9.3325948253282789,8.9671509648891767,8.7626829411062737,8.8261721774113813]
[null,13,"North East England",5.7667323464037432,5.4600371380520496,5.5734909880959789,5.2862665430997406]
[null,14,"North Lancashire and The Lakes",2.1965232918924871,2.2902161757432378,1.7703373352526803,1.7425396326122353]
[null,15,"South Lancashire, Yorkshire and Humber",0.78467487178276318,0.87331617778399018,0.52845910459768497,0.33220108392971959]
[null,16,"North Midlands and North Wales",-2.0013589808559873,-1.1342286312263798,-1.4667543818845408,-2.3278107745945285]
[null,17,"South Lincolnshire and North Norfolk",-2.6501697686466508,-2.2821366902756837,-2.6038185479461031,-2.9452247880818119]
[null,18,"Mid Wales and The Midlands",-3.1762556292119202,-2.2722498534455884,-3.104174508410122,-3.4780468832512939]
[null,19,"Anglesey and Snowdon",-0.38734408510913898,-0.19139797894388444,-1.1164984824213762,-0.90940516075372102]
[null,20,"Pembrokeshire",-1.3000879780033694,-0.7624977187520221,0.77369148502204599,1.4883991845876974]
[null,21,"South Wales & Gloucester",-5.4437826071000668,-3.575764716556161,-2.5182454829069005,-1.670625340208979]
[null,22,"Cotswold",-7.0663553429576709,-7.9652942142723848,-7.3107407893317404,-6.3207104864317598]
[null,23,"Central London",-14.873846170249948,-14.103660537268098,-14.597467930618865,-14.898607132508296]
[null,24,"Essex and Kent",-6.3882164482021029,-5.5814064016973317,-6.1250669468284809,-6.3458967831371051]
[null,25,"Oxfordshire, Surrey and Sussex",-8.237980429051218,-7.3244450886913448,-7.7280164127168725,-7.7211079427404439]
[null,26,"Somerset and Wessex",-8.8300319655324948,-8.5240069616135834,-8.3581259050413585,-7.7430103928389702]
[null,27,"West Devon and Cornwall",-10.882399699152487,-12.725427931048227,-11.935060738228165,-9.5777118052006891]

{"sheet":"T29","index":29,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 29 - 2019/20 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"]
[]
[]
[null,"Wider Tariffs for an Intermittent 40% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",20.778046653419288,22.929789969271908,21.146272444007408,20.929773675151942]
[null,2,"East Aberdeenshire",18.026999241750765,20.290690504180233,18.435255102803872,18.20263777525993]
[null,3,"Western Highlands",20.356221649220686,21.977638308672375,20.746011096897313,20.503413599631862]
[null,4,"Skye and Lochalsh",26.083872543863183,27.737608955303024,26.479449802675276,26.233102494254297]
[null,5,"Eastern Grampian and Tayside",18.286303995914817,19.878842870033203,18.724057359036458,18.452427782901658]
[null,6,"Central Grampian",18.286756392145961,19.9368654572773,18.856576765813138,18.461100418868391]
[null,7,"Argyll",26.02686576785575,27.75637769213315,26.732821617116766,26.226224671488843]
[null,8,"The Trossachs",15.465316871023077,16.907265467178242,15.951018118461807,15.621875242940531]
[null,9,"Stirlingshire and Fife",11.538181194867146,12.438604183053874,11.739157132039953,11.676983322432546]
[null,10,"South West Scotland",12.953574820785175,14.468727495923689,13.455912407666467,13.129324343072311]
[null,11,"Lothian and Borders",7.721499742933621,8.6608046538488512,7.7240544366214534,7.8922850049431474]
[null,12,"Solway and Cheviot",5.1296875590032842,6.0406456969753357,5.2790475518446103,5.3322839547135832]
[null,13,"North East England",0.39161048842732349,1.0876720816304051,0.50255616802129222,0.50539610479731945]
[null,14,"North Lancashire and The Lakes",-1.363673915098301,-0.24804661886302171,-0.76884204808492429,-0.95864700597852259]
[null,15,"South Lancashire, Yorkshire and Humber",-4.4355285853972717,-3.8722596111431962,-4.4318688820280148,-4.3150692654661311]
[null,16,"North Midlands and North Wales",-5.3143292027996143,-4.5100717386575262,-4.9933417021644093,-5.0712696319921911]
[null,17,"South Lincolnshire and North Norfolk",-4.471900238808681,-4.3166375683247189,-4.6386937542890312,-4.4371257161819875]
[null,18,"Mid Wales and The Midlands",-4.4413399707162551,-3.6366695798940394,-4.4522696255378644,-4.392704343557007]
[null,19,"Anglesey and Snowdon",-5.9875451216658,-4.4192002761943954,-5.1015431612841828,-5.5891198951794614]
[null,20,"Pembrokeshire",-6.5758363776550626,-6.4227965701818164,-6.2565420617380125,-6.1692956166149466]
[null,21,"South Wales & Gloucester",-6.6718852800938739,-6.3426196994408048,-6.2819735639626577,-6.1513772690340254]
[null,22,"Cotswold",-10.236854904359003,-10.848476175330887,-10.610505296377251,-10.33358276233778]
[null,23,"Central London",-10.081139957697943,-9.9604723622658486,-10.170738347603404,-10.132412025816542]
[null,24,"Essex and Kent",-3.3575366933870043,-3.1985607645282128,-3.4301931848832812,-3.3379178472225037]
[null,25,"Oxfordshire, Surrey and Sussex",-5.4493369506379006,-5.1901227975444604,-5.4585767106372902,-5.4014699001058446]
[null,26,"Somerset and Wessex",-5.4288214046977377,-5.3746992045785973,-5.4790656813498755,-5.3183175635290958]
[null,27,"West Devon and Cornwall",-6.7847053155105677,-7.1977289200881698,-7.1731825317229649,-6.6358466537691196]

{"sheet":"T30","index":30,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 30 - 2019/20 Generation Scenarios - HH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",54.740663633673748,55.523589041902476,54.819323904933221,54.745266014100402]
[null,2,"Southern Scotland",37.979605077876904,38.739359946590199,38.138842440629745,37.988038315458958]
[null,3,"Northern",49.481122928490301,49.635136890875003,49.470486628481268,49.484083710052637]
[null,4,"North West",56.625403471864708,56.131005173211001,56.46500492087781,56.626074217558063]
[null,5,"Yorkshire",56.482774708304582,55.897866138678225,56.133661340824368,56.483510289642659]
[null,6,"N Wales & Mersey",57.958390326091489,57.246599613992707,57.883311421609982,57.957287383384468]
[null,7,"East Midlands",59.986057688793679,59.365863434656319,59.594721162812739,59.986330487416652]
[null,8,"Midlands",61.268953758135481,60.982784321334961,61.282367641739256,61.268719841076773]
[null,9,"Eastern",61.445518251242348,60.775320437402989,61.109821584182178,61.445948663801715]
[null,10,"South Wales",57.144757332846488,59.969695717425637,57.983833819200413,57.144868680886717]
[null,11,"South East",63.934148435725788,63.709980238888811,63.883892887785919,63.934480833852739]
[null,12,"London",66.800929739907502,66.334893822334962,66.55082638799125,66.80130673529986]
[null,13,"Southern",64.635693324328017,64.950968369532731,64.923696300569944,64.635944693031078]
[null,14,"South Western",64.289201086774909,67.090772103325264,65.744065563870194,64.289375851481395]

{"sheet":"T31","index":31,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 31 - 2019/20 Generation Scenarios - NHH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",13.594693634606816,13.789863517188623,13.614267848251361,13.595730433865898]
[null,2,"Southern Scotland",5.4317641042586473,5.5405074128384584,5.4545574094208114,5.4329638175227393]
[null,3,"Northern",7.8388022106747659,7.8631456648265026,7.8370949259756726,7.8392491155017661]
[null,4,"North West",7.2243802573338103,7.1613958651737004,7.2039399912393751,7.2244735962769395]
[null,5,"Yorkshire",7.3545654229267861,7.2784726359067768,7.3091371438973267,7.3546663428585388]
[null,6,"N Wales & Mersey",8.3263479717368938,8.2239704101248723,8.315546975550042,8.3261810582348765]
[null,7,"East Midlands",7.5728771789504927,7.4947006613405645,7.5235277705304391,7.5729207614271017]
[null,8,"Midlands",7.6795357776960085,7.6437528456360431,7.6812233077208791,7.6795165694413132]
[null,9,"Eastern",8.8607925053290835,8.7640267893626387,8.8123378646864321,8.8608457424211906]
[null,10,"South Wales",7.0082504454653742,7.3542643265629284,7.1110168076474274,7.008276889323124]
[null,11,"South East",9.2079856564148237,9.1756341704912163,9.2007354541757671,9.2080248731247352]
[null,12,"London",5.472438798065669,5.4348155190146228,5.4521507768703099,5.4725231092497895]
[null,13,"Southern",8.3195538731093084,8.3601409999697331,8.3566058229478912,8.3195928933071652]
[null,14,"South Western",9.3953191750547003,9.8050644447267779,9.6081198192990431,9.3953339192257985]

{"sheet":"T32","index":32,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 32 - 2020/21 Generation Scenarios - Wider Generation Peak 80% Tariffs"]
[]
[]
[null,"Wider Tariffs for a Conventional 80% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",26.595924523786532,30.55258810637768,26.494677176916774,26.668483466427645]
[null,2,"East Aberdeenshire",22.217728757191303,25.98873392315754,22.535422087716263,22.2982438376904]
[null,3,"Western Highlands",25.238104900199662,27.296884456669456,25.575217034842836,25.313018101313418]
[null,4,"Skye and Lochalsh",31.148504009822272,33.261957086338832,31.493341460041961,31.224120937865351]
[null,5,"Eastern Grampian and Tayside",24.251802841770957,26.281315718079856,24.77710481410935,24.328711207898579]
[null,6,"Central Grampian",24.753357256145996,26.789459128646651,25.182925542175411,24.830470038295047]
[null,7,"Argyll",31.822192526260789,36.50542635555955,32.191718430148818,31.908574912510019]
[null,8,"The Trossachs",20.835031195888714,22.72165477696198,21.208957704411525,20.901414380791344]
[null,9,"Stirlingshire and Fife",13.531587954515018,15.118057249031516,13.81229740484587,13.572698558535256]
[null,10,"South West Scotland",16.978609359164093,18.161287027467527,17.340849630802602,17.052185446114109]
[null,11,"Lothian and Borders",13.366507940742522,14.259853773257912,13.872964307894557,13.446695325278439]
[null,12,"Solway and Cheviot",7.2160972493688966,8.7824104322306695,7.6966582447216521,7.2997761694902135]
[null,13,"North East England",6.2675927068289248,6.7084788213918829,6.839709462205585,6.3554341891788955]
[null,14,"North Lancashire and The Lakes",-6.052830788718655E-2,1.2093927955606638,0.42268484656788896,2.9827477716023232E-2]
[null,15,"South Lancashire, Yorkshire and Humber",-0.96380490280677389,-0.43914958423263695,-0.41024563853472351,-0.86454752192695139]
[null,16,"North Midlands and North Wales",-3.1981280641563359,-2.2065254133469168,-2.0502636737595918,-3.0372972427978415]
[null,17,"South Lincolnshire and North Norfolk",-4.0650775817858822,-3.6012762173543083,-3.6967768926567488,-4.0280084814844752]
[null,18,"Mid Wales and The Midlands",-4.4422385658199763,-3.7336413499560761,-4.0499890128051863,-4.2000016474413666]
[null,19,"Anglesey and Snowdon",-2.1417184847830244,-1.8759270253093323,-2.0372506406951145,-2.0525116345735608]
[null,20,"Pembrokeshire",-2.606009505393736E-2,-2.9521838411357111,-2.1896074514664172,6.0902120048851316E-2]
[null,21,"South Wales & Gloucester",-3.3007214667099283,-5.8616867716795094,-4.7630725395347362,-3.2134257894978306]
[null,22,"Cotswold",-8.1087693904076392,-10.123082220595199,-9.5405540899976842,-8.0058868061481459]
[null,23,"Central London",-16.38756916528725,-16.24203764062927,-16.26846019124234,-16.277166309527516]
[null,24,"Essex and Kent",-7.7550728518437282,-7.5567159093022349,-7.7643187138986089,-7.6300368408487849]
[null,25,"Oxfordshire, Surrey and Sussex",-9.4411262744714364,-9.1818306898065032,-9.3208972037442379,-9.3495289217573401]
[null,26,"Somerset and Wessex",-8.1067634781376867,-10.722222259429376,-8.9276155786542652,-8.0173430778591417]
[null,27,"West Devon and Cornwall",-9.1539337922485533,-12.795144162347373,-10.22687152401279,-9.0636066994793563]

{"sheet":"T33","index":33,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 33 - 2020/21 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"]
[]
[]
[null,"Wider Tariffs for an Intermittent 40% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",19.75905406191486,21.600436164357387,19.889174071568519,19.76047014455478]
[null,2,"East Aberdeenshire",17.124923315657668,18.786602529580168,17.223262407825665,17.13026177812084]
[null,3,"Western Highlands",18.851906158548893,19.654818634204407,19.127476436184075,18.855146013434862]
[null,4,"Skye and Lochalsh",24.767564519304539,25.602739491788643,25.044308690652144,24.771513092166721]
[null,5,"Eastern Grampian and Tayside",16.99552477192502,17.815496584257303,17.206617782109952,17.000561326729887]
[null,6,"Central Grampian",17.33466059192374,18.393326681906061,17.513286696336039,17.340550854541242]
[null,7,"Argyll",25.477069805888636,29.349918434159331,25.662161303936522,25.494667877148942]
[null,8,"The Trossachs",14.301594769370045,15.58417206489419,14.440231663330005,14.298776742561627]
[null,9,"Stirlingshire and Fife",9.9030147150491832,10.383820199699912,9.8811711688734789,9.8791050882008982]
[null,10,"South West Scotland",11.744824782272342,12.56432569274466,11.885208511252314,11.749257900730038]
[null,11,"Lothian and Borders",6.4474309031848449,7.0828879242155027,6.5182240605846093,6.4503424544723575]
[null,12,"Solway and Cheviot",3.5199659470461775,4.3581693749104184,3.5646104897908639,3.5227674305457395]
[null,13,"North East England",0.60125880522365627,0.97489329326296215,0.68995330158688173,0.60668720856435598]
[null,14,"North Lancashire and The Lakes",-3.2649669079248014,-2.614528593068679,-3.1048992698600202,-3.2649105493954984]
[null,15,"South Lancashire, Yorkshire and Humber",-5.489043944881038,-5.2140089298405101,-5.5257109539412212,-5.5471098790584605]
[null,16,"North Midlands and North Wales",-6.327956109055541,-5.7995378715794859,-6.168666337194681,-6.1891008815276738]
[null,17,"South Lincolnshire and North Norfolk",-5.9265567883326744,-5.6929510749458334,-5.943560607148636,-5.6419802062382987]
[null,18,"Mid Wales and The Midlands",-6.0019125152384163,-5.1614874022199633,-5.8596392529145565,-5.6726914702992808]
[null,19,"Anglesey and Snowdon",-6.6803155470311699,-4.8110030373167598,-6.0739463267204599,-6.6594157669511462]
[null,20,"Pembrokeshire",-7.5251740057767957,-7.9756519382819056,-7.674403941554286,-7.407286947917771]
[null,21,"South Wales & Gloucester",-7.5269722121493139,-7.942317729174607,-7.5046689142126546,-7.408621357322458]
[null,22,"Cotswold",-11.853430520727304,-12.42243101126256,-11.795981136071457,-11.68889790669483]
[null,23,"Central London",-11.790115833280717,-11.613320523515704,-11.6931986243249,-11.628608805319406]
[null,24,"Essex and Kent",-4.6441486070619122,-4.7220729286023788,-4.613787549516096,-4.5559502763384847]
[null,25,"Oxfordshire, Surrey and Sussex",-6.8347756820390355,-6.6707266266447149,-6.6282285069436391,-6.7057193034022422]
[null,26,"Somerset and Wessex",-6.6087448889770606,-7.050953760244294,-6.4068118022491056,-6.4929342360750129]
[null,27,"West Devon and Cornwall",-7.5951228409385312,-8.1206781395634433,-7.3592293048004382,-7.4775624966457173]

{"sheet":"T34","index":34,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 34 - 2020/21 Generation Scenarios - HH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",59.83242615700815,56.784013128425734,60.568951122224249,60.361167480897457]
[null,2,"Southern Scotland",44.271965089049964,41.973187140577537,43.688505165000606,44.039735213589083]
[null,3,"Northern",54.381635946032752,53.778225570805333,53.637444612534843,54.144404943260056]
[null,4,"North West",62.40556350330484,61.637932378629785,61.696073064748902,62.163437169135605]
[null,5,"Yorkshire",61.942639688098232,61.535749938122365,61.128972348409583,61.764333785153603]
[null,6,"N Wales & Mersey",64.005457193469567,62.976440856457792,63.4319239422381,63.741769071847692]
[null,7,"East Midlands",65.741067022142246,65.373988453187309,64.992819021513228,65.422346482345432]
[null,8,"Midlands",67.202949606752398,66.742210977646437,66.709938221920893,66.904039503830163]
[null,9,"Eastern",67.260134638995098,67.328701793697419,66.829516379709858,66.934784349942291]
[null,10,"South Wales",63.343735139693941,67.154577166009162,65.215629422881776,63.02916446680198]
[null,11,"South East",69.906939717197545,70.589993927771786,69.828852444127506,69.584915832276167]
[null,12,"London",72.858152399620792,73.185019159677239,72.62598604988635,72.534723674647907]
[null,13,"Southern",70.765715114495706,71.822229610345531,70.852931702341124,70.44632689506409]
[null,14,"South Western",68.2124583756585,72.42574230790963,69.192991744290794,67.895723377564607]

{"sheet":"T35","index":35,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 35 - 2020/21 Generation Scenarios - NHH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",16.48353501241462,15.525924316049343,16.569604663566359,16.512405191670783]
[null,2,"Southern Scotland",6.5157962269726184,6.1762170179105054,6.4290441772088549,6.4808022329798609]
[null,3,"Northern",8.9690542528882737,8.8669507573106401,8.843869118161976,8.9276915705181246]
[null,4,"North West",8.0107357200709721,7.9130261495268313,7.9204217951121141,7.9803611330448669]
[null,5,"Yorkshire",8.1028467752722921,8.0501905501892352,7.9969674158109552,8.0800274984621598]
[null,6,"N Wales & Mersey",9.4352894864813166,9.2826077177686752,9.3498798806308248,9.395597138830718]
[null,7,"East Midlands",8.2796904468633805,8.2344551448500276,8.1864218058429223,8.2404575048829418]
[null,8,"Midlands",8.3887653922113437,8.3323595385446865,8.3282498922025248,8.3524473387721923]
[null,9,"Eastern",9.9056679350538648,9.9149237612000203,9.841418554864882,9.8569373018913513]
[null,10,"South Wales",7.7483271814667765,8.215034446041221,7.9781092272218563,7.7110508111503702]
[null,11,"South East",10.303130359870957,10.403019538812982,10.290824305733626,10.254847691137313]
[null,12,"London",5.3330317278437782,5.3621213963450591,5.3211392068231946,5.3145007492556777]
[null,13,"Southern",9.1294072655122687,9.2663005925712181,9.1412828088447071,9.0888610258839524]
[null,14,"South Western",10.2277653613249,10.859042019977268,10.373942605566899,10.179245953328337]

{"sheet":"T36","index":36,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 36 - 2021/22 Generation Scenarios - Wider Generation Peak 80% Tariffs"]
[]
[]
[null,"Wider Tariffs for a Conventional 80% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",29.422092823020247,30.652081890476882,30.789753175548405,29.788604793175445]
[null,2,"East Aberdeenshire",24.420170675465375,26.323121803898079,24.374433961317138,24.396152336344617]
[null,3,"Western Highlands",26.951606479725701,27.244199298781769,28.206590189548322,27.029820375649088]
[null,4,"Skye and Lochalsh",34.968541463600467,35.334780294472992,36.220372359510549,35.043643190028519]
[null,5,"Eastern Grampian and Tayside",25.137379655142272,25.51537973905015,26.131639452523139,25.415800650665609]
[null,6,"Central Grampian",25.973908844356803,25.93215339474175,26.988983924857884,25.063950085022306]
[null,7,"Argyll",32.68200594542536,36.296169768615897,33.905229111705076,32.086446298141183]
[null,8,"The Trossachs",21.645556911171496,21.440848096826599,22.593676608982747,20.552561994264575]
[null,9,"Stirlingshire and Fife",14.108020455893818,20.360100200378493,14.797764355909429,19.432622960653333]
[null,10,"South West Scotland",16.409979317902764,17.405625713452935,17.416065953215131,16.025350238319934]
[null,11,"Lothian and Borders",12.551040446560709,11.734816799667662,13.606424049586778,12.387969501419697]
[null,12,"Solway and Cheviot",6.2848231239832364,7.8774749141423017,7.3548605567985614,6.2061615821877325]
[null,13,"North East England",5.2309047866381215,4.4719303992643686,6.1941224894317539,4.6814944635520384]
[null,14,"North Lancashire and The Lakes",-1.3699602297340858,0.28984144416986712,-0.17770130269834716,-1.4053804600890718]
[null,15,"South Lancashire, Yorkshire and Humber",-2.28521979671822,-2.3120004389687745,-1.7154866529649873,-2.0374480827723236]
[null,16,"North Midlands and North Wales",-4.833121888384162,-3.6327981769590654,-3.4480699549484997,-4.5960341045322695]
[null,17,"South Lincolnshire and North Norfolk",-5.7429625965836291,-4.5407408917036189,-5.2859259571202681,-5.467451841754583]
[null,18,"Mid Wales and The Midlands",-6.2370985283935534,-2.5207606721098967,-5.3975544879904414,-5.650049598392398]
[null,19,"Anglesey and Snowdon",-4.1462845344771777,-3.1376667964299734,-3.1516571719809425,-3.957125230309078]
[null,20,"Pembrokeshire",-4.3667949585317931,-7.556533177166723,-3.3981363070615407,-2.6079498530914185]
[null,21,"South Wales & Gloucester",-8.6230701665118659,-10.660756038943148,-6.3105069965927392,-5.3356642569350736]
[null,22,"Cotswold",-10.460253673140585,-13.255204242623867,-10.777679050522359,-10.416240182104115]
[null,23,"Central London",-18.491518437774555,-12.676056992385803,-18.048209633491219,-17.980121006458994]
[null,24,"Essex and Kent",-9.6149612696320617,-6.0247699424896126,-9.3525821915726048,-9.0446949144327888]
[null,25,"Oxfordshire, Surrey and Sussex",-11.429820263189617,-8.4165328329589144,-10.898673768610983,-10.638230760322948]
[null,26,"Somerset and Wessex",-10.740439349303998,-10.542988202419366,-12.062581832006607,-9.9870105617469243]
[null,27,"West Devon and Cornwall",-12.142955569390839,-14.471595101243032,-14.108323513284466,-11.193078783422314]

{"sheet":"T37","index":37,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,1,4,2]]}
[]
[null,"Table 37 - 2021/22 Generation Scenarios - Wider Generation Intermittent 40% Tariffs"]
[]
[]
[null,"Wider Tariffs for an Intermittent 40% Generator",null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone","Zone Name","(£/kW)","(£/kW)","(£/kW)","(£/kW)"]
[null,1,"North Scotland",21.963253296432089,23.699971780722482,22.638229967720537,22.572611964539941]
[null,2,"East Aberdeenshire",19.57805121412833,21.187947281514543,19.765369704177978,20.197290118795706]
[null,3,"Western Highlands",20.101179443357935,20.82146433174519,20.731058757597538,20.406240660554417]
[null,4,"Skye and Lochalsh",28.141668915238522,28.900580104254413,28.773515434399862,28.44660892104357]
[null,5,"Eastern Grampian and Tayside",17.944697533017138,18.087303768388406,18.560362142571783,17.324402853326465]
[null,6,"Central Grampian",18.641127104507703,18.950518851065237,19.252174108661311,17.859935423645016]
[null,7,"Argyll",25.888496792285618,29.322676261180245,25.836050662634975,25.11660458287075]
[null,8,"The Trossachs",15.125659516032155,15.909838723783835,15.662633179526665,14.881693718591752]
[null,9,"Stirlingshire and Fife",9.9580653805167572,15.134091609228328,10.213510393865878,14.808436664379194]
[null,10,"South West Scotland",11.607076299524767,12.659170900057042,12.111654536749199,11.754157634727786]
[null,11,"Lothian and Borders",6.3352543279434341,6.6282892406568861,6.8379659559317769,6.6903280388242798]
[null,12,"Solway and Cheviot",2.844601831425293,4.154010386719805,3.3199268593795423,3.1188157444243618]
[null,13,"North East England",-0.43348204746087493,-0.19323720133506495,8.2394779010129149E-2,-0.29019435253626824]
[null,14,"North Lancashire and The Lakes",-4.2991225652880996,-2.8948069107620045,-3.8508927565196087,-4.0130012674487112]
[null,15,"South Lancashire, Yorkshire and Humber",-7.2485988470058675,-6.44402676810118,-6.7667032812816341,-6.7658615985317923]
[null,16,"North Midlands and North Wales",-8.0914495734193004,-6.8679549619196889,-7.508827302736055,-7.6687605085999193]
[null,17,"South Lincolnshire and North Norfolk",-8.1117888312760762,-6.7236116259927368,-7.2979780638618017,-7.5459723553520686]
[null,18,"Mid Wales and The Midlands",-7.8203462022845827,-5.192459757255274,-7.0502746465827348,-7.2602101296583523]
[null,19,"Anglesey and Snowdon",-8.1584481295414211,-5.7426240193503642,-7.3325114930392949,-7.8458508063235328]
[null,20,"Pembrokeshire",-10.284174054249327,-9.6917385477403464,-9.3347481608216949,-9.6509206520259667]
[null,21,"South Wales & Gloucester",-10.404264271079693,-9.6638776205753913,-9.2330041510237422,-9.5433149533097446]
[null,22,"Cotswold",-14.239502447694548,-15.128591980444341,-13.53451403883335,-14.320390882261755]
[null,23,"Central London",-13.939009727441992,-11.441852572551621,-13.178692656927252,-13.564148147828485]
[null,24,"Essex and Kent",-6.9165659493671336,-4.9877627918956158,-6.2072542472859684,-6.427781910799844]
[null,25,"Oxfordshire, Surrey and Sussex",-9.0512608521366396,-6.817515384171049,-8.2499336922680495,-8.5472091431801847]
[null,26,"Somerset and Wessex",-8.9301004292047939,-7.6342821871776625,-8.4891441201538349,-8.5631984191580734]
[null,27,"West Devon and Cornwall",-9.9131196500432637,-9.2898896538306683,-9.5860474407845508,-9.6138685935036623]

{"sheet":"T38","index":38,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 38 - 2021/22 Generation Scenarios - HH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)","HH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",63.879997176923212,61.882839535854217,63.294243733029731,63.88513277114992]
[null,2,"Southern Scotland",46.108663537819552,47.15908617128693,47.097396642450242,48.137566842314385]
[null,3,"Northern",57.703847103911016,60.0585004013939,58.83272630897379,59.983575304750126]
[null,4,"North West",66.039663934157645,67.236316169785752,67.126203614736028,67.979716519544596]
[null,5,"Yorkshire",65.532094502349594,67.582058730915847,66.774841331849942,67.326930659618043]
[null,6,"N Wales & Mersey",68.188904733399355,68.652192648403357,68.609427148216213,69.938310155666002]
[null,7,"East Midlands",69.60713023579568,71.071052678270192,70.960486904773461,71.324903056417554]
[null,8,"Midlands",71.512264829765499,73.372466605448594,72.610527939505943,73.111422461165091]
[null,9,"Eastern",71.430049765651177,70.957364701302865,73.013199644141167,72.748595400065824]
[null,10,"South Wales",71.072493714353996,76.412349666329959,71.308799416671462,70.121873178606208]
[null,11,"South East",74.314669120163884,73.432552366585156,76.185229250312645,75.50503063852085]
[null,12,"London",77.211839938731373,75.49383651816764,78.944136769011791,78.476485176428099]
[null,13,"Southern",75.483041719376871,75.830482546354773,77.320768333084629,76.611309315764657]
[null,14,"South Western",73.882174353409397,78.809265807510499,77.36823381377404,74.522233061170994]

{"sheet":"T39","index":39,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 39 - 2021/22 Generation Scenarios - NHH Demand Tariffs"]
[]
[null,null,null,"Base Case","All TEC","Sustained Coal","Accelerated Wind"]
[null,"Zone No.","Zone Name","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)","NHH Zonal Tariff (£/kW)"]
[null,1,"Northern Scotland",19.390702494224616,18.635224900755027,19.063803971078482,19.243832187665713]
[null,2,"Southern Scotland",7.0037780802447589,7.1517385147981667,7.1423796147401708,7.3004302130495251]
[null,3,"Northern",9.9521567309474648,10.32799439532198,10.116615881478259,10.315237063392546]
[null,4,"North West",8.5232412113394478,8.6868142344163051,8.6725937292344533,8.7827095488634814]
[null,5,"Yorkshire",8.6063672440602321,8.8826617045084966,8.7766423297094942,8.8491170493259332]
[null,6,"N Wales & Mersey",10.339405527415918,10.398301081200346,10.391827922617253,10.593375476995101]
[null,7,"East Midlands",8.7293528012746595,8.9253879972730523,8.9115096498918493,8.9571552570593056]
[null,8,"Midlands",8.870764929358705,9.1151982497872801,9.0206696392083412,9.0827423549136306]
[null,9,"Eastern",10.765643858247504,10.683879092539497,10.993736593841165,10.953903384836822]
[null,10,"South Wales",8.6513621839254533,9.3171500654700399,8.6959001439995927,8.551350196090997]
[null,11,"South East",11.232576034382678,11.088328533825669,11.504403342348127,11.401640717237585]
[null,12,"London",4.848272712622979,4.8096768646183055,5.0262584149951506,4.9965852433836577]
[null,13,"Southern",9.7506506452561599,9.8045583546450352,9.9970595577715464,9.9053737890223896]
[null,14,"South Western",11.394607015323565,12.140786039820197,11.918554048426548,11.479685670482576]

{"sheet":"T40","index":40,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[3,1,3,3],[4,12,5,12],[3,4,3,11]]}
[]
[null,"Table 40 - National Grid Revenue Forecast"]
[]
[null,"National Grid Revenue Forecast",null,null,"2017-02-01",null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,"Notes"]
[null,"Regulatory Year"," "," ","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Actual RPI"," "," ",256.66666666666669," "," "," "," "," "," "," ","April to March average"]
[null,"RPI Actual"," ","RPIAt",1.19," "," "," "," "," "," "," ","Office of National Statistics"]
[null,"Assumed Interest Rate"," ","It",5.0000000000000001E-3,0,0.95000000000000007,2E-3,2.4999999999999996E-3,4.9999999999999992E-3,8.0000000000000002E-3,8.0000000000000002E-3,"Bank of England Base Rate"]
[null,"Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1443.829,1475.5930000000001,1571.3869999999999,1554.942,1587.627,1585.2280000000001,1571.5840000000001,1571.5840000000001,"From Licence; assumed similar in 2021/22"]
[null,"Price Control Financial Model Iteration Adjustment","A2","MODt",-5.5,-114.4,-185.4,-253.3,-290,-270,-190,-190,"Determined by Ofgem; NGET forecast"]
[null,"RPI True Up","A3","TRUt",-0.52728791368496775,4.7019113011489599,-19.921431381693402,-31.397222077804624,-6.084497024461367,-6.5766664140402229,-6.4793369372893155,-1.0577939224326987,"Licensee Actual/Forecast"]
[null,"Prior Calendar Year RPI Forecast"," ","GRPIFc-1",3.1E-2,2.5000000000000001E-2,0.01,1.7999999999999999E-2,3.5000000000000003E-2,3.1E-2,0.03,3.1E-2,"HM Treasury Forecast"]
[null,"Current Calendar Year RPI Forecast"," ","GRPIFc",3.1E-2,2.4E-2,2.1000000000000001E-2,3.5000000000000003E-2,3.1E-2,0.03,3.1E-2,3.1E-2,"HM Treasury Forecast"]
[null,"Next Calendar Year RPI forecast"," ","GRPIFc+1",0.03,3.2000000000000001E-2,0.03,3.1E-2,0.03,3.1E-2,3.1E-2,3.1E-2,"HM Treasury Forecast"]
[null,"RPI Forecast","A4","RPIFt",1.2051000000000001,1.2266528212575316,1.2330000000000001,1.2709999999999999,1.3089999999999999,1.343,1.3839999999999999,1.4259999999999999,"Using HM Treasury Forecast"]
[null,"Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",{"$f":"SUM(E10:E12)*E16","v":1732.6948432352185},1675.4788464888604,1684.3588461063721,1614.4811127391104,1690.6291363949799,1757.5187410059441,1903.1448536787914,{"$f":"SUM(L10:L12)*L16","v":1968.6303698666111}]
[null,"Pass-Through Business Rates","B1","RBt"," ",1.2353308097829103,1.5001179260431783,2.6894278826733395,4.3689138901091207,4.0630441241651161,4.2239764051880719,4.3785040440792571,"Licensee Actual/Forecast"]
[null,"Temporary Physical Disconnection","B2","TPDt",0.14395339862662926,1.2337689401095423E-2,9.0478361183892381E-2,0,0,0,0,0,"Licensee Actual/Forecast"]
[null,"Licence Fee","B3","LFt"," ",2.0207027597467815,2.6933961403912292,3.187695280052341,3.4536449799316209,3.4458584531271903,3.5511754549800272,3.6541921144659915,"Licensee Actual/Forecast"]
[null,"Inter TSO Compensation","B4","ITCt"," ",3.8222435083326589,2.6745437559665044,0.49862315564851822,0.7496954923835718,0.71736058687093474,0.74307205738918647,0.76792422886418976,"Licensee Actual/Forecast"]
[null,"Termination of Bilateral Connection Agreements","B5","TERMt",0,0,0,0,0,0,0,0,"Does not affect TNUoS"]
[null,"SP Transmission Pass-Through","B6","TSPt",312.179148,295.664557,294.62336299999998,320.96520036000004,363.76111432005257,421.82943131476071,401.62713101795606,436.8314268388425,"14/15 - 17/18  Charge setting. Later from TSP Calculation."]
[null,"SHE Transmission Pass-Through","B7","TSHt",213.95951766583201,338.20730217321301,322.83631648970299,301.36826289999999,363.1455636086223,375.26520226506022,372.30688590488751,412.3863715077606,"14/15 - 17/18  Charge setting. Later from TSH Calculation."]
[null,"Offshore Transmission Pass-Through","B8","TOFTOt",218.38037349491276,248.35699921993759,260.78931257200446,270.20460754023702,380.16603800000001,472.339765,574.03664654826503,619.195933110498,"14/15 - 17/18  Charge setting. Later from OFTO Calculation."]
[null,"Embedded Offshore Pass-Through","B9","OFETt",0.43733608355648018,0.64941914461921546,0.6544976173613446,0.51506514657980451,0.53053745928338758,0.54641693811074921,0.56270358306188928,0.5777687296416939,"Licensee Actual/Forecast"]
[null,"Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9]","B","PTt",{"$f":"SUM(E18:E26)","v":745.10032864292793},889.96889230503325,885.86202586265358,899.42888226519096,1116.1755077503826,1278.2070786820948,{"$f":"SUM(K18:K26)","v":1357.0515909717278},{"$f":"SUM(L18:L26)","v":1477.7921205741522}," "]
[null,"Reliability Incentive Adjustment","C1","RIt"," ",2.3615637797660018,3.920644330261553,4.0380877505969011,4.1509246564852047,4.1964785346430684,4.3116341026308529,4.4253046205281388,"Licensee Actual/Forecast"]
[null,"Stakeholder Satisfaction Adjustment","C2","SSOt"," ",8.6930597323224994,10.123488255861568,8.6047337676510143,8.5103267010475765,8.1503292059826471,8.5602977698476526,8.9478076195688914,"Licensee Actual/Forecast"]
[null,"Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt"," ",2.8092019735619482,2.6616746854357087,2.6133241702293648,2.7266419999122542,2.8085759054854185,2.9390839268337525,3.016568978708384,"Licensee Actual/Forecast"]
[null,"Awarded Environmental Discretionary Rewards","C4","EDRt"," ",0,2.0215574999999997,0,0,0,0,0,"Only includes EDR awarded to licensee to date"]
[null,"Outputs Incentive Revenue [C=C1+C2+C3+C4]","C","OIPt",{"$f":"SUM(E28:E31)","v":0},13.863825485650448,18.727364771558829,15.256145688477281,15.387893357445034,15.155383646111133,15.811015799312258,16.389681218805414," "]
[null,"Network Innovation Allowance","D","NIAt",10.915977512381877,10.555516732879822,10.611460730470144,10.171231010256395,10.650963559288373,11.072368068337449,11.989812578176386,12.402371330159651,"Licensee Actual/Forecast"]
[null,"Network Innovation Competition","E","NICFt",17.849214,18.760655919999998,44.854879889999999,32.071100479999998,40.5,40.5,40.5,40.5,"Sum of NICF awards determined by Ofgem/Forecast by National Grid"]
[null,"Future Environmental Discretionary Rewards","F","EDRt"," "," ",0,0,2,2,2,2,"Sum of future EDR awards forecast by National Grid"]
[null,"Transmission Investment for Renewable Generation","G","TIRGt",15.997326508799999,15.699016829576131,0,0,0,0,0,0,"Licensee Actual/Forecast"]
[null,"Scottish Site Specific Adjustment","H","DISt",1.9849141507976036,0.79100000000000004,2.8649227140000022,6.0579279490409306,0,0,0,0,"Licensee Actual/Forecast"]
[null,"Scottish Terminations Adjustment","I","TSt",-0.28187454000000001,0.10154699999999994,7.2928609999999949E-2,-1.1215534200000001,0,0,0,0,"Licensee Actual/Forecast"]
[null,"Correction Factor","K","-Kt"," ",56.423778228050232,103.97796600318905,97.021422609611989,0,0,0,0,"Calculated by Licensee"]
[null,"Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",{"$f":"SUM(E17,E27,E32:E39)","v":2524.2607295101257},2681.6430789900505,2751.3303946882438,2673.3662693216875,2875.343501062096,3104.4535714024873,3330.4972730280078,3517.7145429897282," "]
[null,"Termination Charges","B5"," ",0,0,0,0,0,0,0,0," "]
[null,"Pre-vesting connection charges","P"," ",46.954162359999998,44.955204119999998,42.677043259999913,41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,"Licensee Actual/Forecast"]
[null,"TNUoS Collected Revenue [T=M-B5-P]","T"," ",{"$f":"E40-E41-E42","v":2477.3065671501258},2636.6878748700506,{"$f":"G40-G41-G42","v":2708.6533514282437},2631.4836569216873,2833.4608886620958,3062.5709590024871,3288.6146606280076,3475.831930589728," "]
[null,"Final Collected Revenue","U","TNRt",2376.2289190000001,2592.6842391499999," "," "," "," "," "," ","Licensee Actual"]
[null,"Forecast percentage change to Maximum Revenue M"," "," ",null,{"$f":"F40/E40-1","v":6.2347897600287805E-2},2.5986797513873006E-2,-2.8336882228712001E-2,7.5551649640457352E-2,7.9680939079370017E-2,7.2812717738085508E-2,5.6213008032733436E-2," "]
[null,"Forecast percentage change to TNUoS Collected Revenue T"," "," ",null,{"$f":"F43/E43-1","v":6.4336529775269602E-2},2.7293892934422415E-2,-2.849005926353243E-2,7.6754127356687407E-2,8.085873754501427E-2,7.3808478122298071E-2,5.6928916666073803E-2," "]
[]
[null,"Notes:"]
[null,"All monies are  nominal 'money of the day' prices unless stated otherwise"]
[null,"Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
[null,"Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
[null,"NIC payments to all Transmission Owners are inlcuded in National Grid Maximum Revenue and are included here"]
[null,"2014/15 and 2015/16 pass through to other networks is based on forecast at time of tariff setting"]

{"sheet":"T41","index":41,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[48,1,48,3],[50,1,50,3],[3,1,3,3],[4,9,5,9],[40,1,40,3],[42,1,42,3],[45,1,45,3],[4,1,5,1],[4,2,5,2],[4,3,5,3],[3,4,3,8]]}
[]
[null,"Table 41 - Scottish Power Transmission Revenue Forecast"]
[]
[null,"Scottish Power Transmission Revenue Forecast\n (adjusted for NGET RPI forecast)",null,null,"2017-02-09",null,null,null,null," "]
[null,"Description"," ","Licence\nTerm",null,null,null,null,null,"Notes"]
[null,"Regulatory Year"," "," ","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Actual RPI"," "," "]
[null,"RPI Actual"," ","RPIAt"]
[null,"Assumed Interest Rate"," ","It",2E-3,3.0000000000000001E-3,6.0000000000000001E-3,0.01,0.01,"National Grid forecast"]
[null,"Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",249.43865690088543,253.06460956893324,256.44516916158233,254.23808456838287,272.96995445386386]
[null,"Price Control Financial Model Iteration Adjustment","A2","MODt",-13.548999999999999,12.5,21.44993411786345,5.3,5.8]
[null,"RPI True Up","A3","TRUt",-5.8094742730015909,-0.86485249103220274,0,0,0]
[null,"RPI Forecast","A4","RPIFt",1.2709999999999999,1.3089999999999999,1.343,1.3839999999999999,1.4259999999999999]
[null,"Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",292.43191212004035,346.49198201497245,373.2131237042957,359.2007090426419,397.52595505120985," "]
[null,"Pass-Through Business Rates","B1","RBt",-4.701512329974511,-3.6867485615946198,26.840015685099608,27.638850437856583,28.374628404034887]
[null,"Temporary Physical Disconnection","B2","TPDt",0,0,0,0,0]
[null,"Pass-Through Items [B=B1+B2]","B","PTt",-4.701512329974511,-3.6867485615946198,26.840015685099608,27.638850437856583,28.374628404034887," "]
[null,"Reliability Incentive Adjustment","C1","RIt",2.9305489936413602,1.2078903710058526,1.2493647876936647,1.2924356195007949,0]
[null,"Stakeholder Satisfaction Adjustment","C2","SSOt",0.92124821273358382,0.60394518550292631,0.62468239384683233,0.64621780975039744,0]
[null,"Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt",0.19177795924852106,0,0,0,0]
[null,"Awarded Environmental Discretionary Rewards","C4","EDRt",4.0400999999999989,0.69022306914620146,0.71392273582495114,0.73853463971473987,0]
[null,"Financial Incentive for Timely Connections Output","C5","-CONADJt",0,0,0,0,0]
[null,"Outputs Incentive Revenue [C=C1+C2+C3+C4+C5]","C","OIPt",8.0836751656234647,2.5020586256549802,2.5879699173654478,2.6771880689659322,0," "]
[null,"Network Innovation Allowance","D","NIAt",1.0575000000000001,0.9992366412213739,0.99481481481481471,0.99496764917325653,0]
[null,"Transmission Investment for Renewable Generation","G","TIRGt",33.040580455999994,32.910480063999991,32.618322008,25.940433791999997,25.768413216000003]
[null,"Correction Factor","K","-Kt",3.8248690782070618,-1.2667341588580803,0,0,0]
[null,"Maximum Revenue (M= A+B+C+D+G+J+K]","M","TOt",333.73702448989638,377.9502746253961,436.25424612957556,416.45214899063768,451.66899667124471," "]
[null,"Excluded Services","P","EXCt",11.288,12.59038167938931,13.330518518518518,14.128540618260242,14.140502793296088,"Post BETTA Connection Charges"]
[null,"Site Specifc Charges","S","EXSt",22.7,26.779541984732823,27.755333333333329,28.953558590941768,28.978072625698324,"Pre & Post BETTA Connection Charges"]
[null,"TNUoS Collected Revenue (T=M+P-S)","T","TSPt",322.32502448989641,363.76111432005263,421.82943131476077,401.62713101795612,436.8314268388425,"General System Charge"]
[null,"Final Collected Revenue","U","TNRt",322.32502448989641,363.76111432005263,421.82943131476077,401.62713101795612,436.8314268388425]
[null,"Forecast percentage change to TNUoS Collected Revenue T"," "," ",9.8438532049640814E-2,0.1285537475587939,0.15963310730244018,-4.7892107086596525E-2,8.7654177474659756E-2," "]
[]
[null,"Notes:"]
[null,"All monies are  nominal 'money of the day' prices unless stated otherwise"]
[null,"Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
[null,"Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
[null,"NIC payments are not included as they do not form part of SPT Maximum Revenue"]
[]
[null,"Commentary"]
[null,"All reasonable care has been taken in the preparation of these illustrative tables and the data therein.  SPT offers this data without prejudice and cannot be held responsible for any loss that might be attributed to the use of this data.  SPT does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
[null,"The base revenue forecasts for the RIIO-ET1 period (2014/15 to 2020/21, inclusive) reflect the figures authorised by Ofgem in the the RIIO-ET1 Final Proposals.  "]
[null,"Within the bounds of commercial confidentiality, this forecast provides as much information as possible."]
[]
[null,"This forecast contains as much information as can be currently made available.  Generally, allowances determined by Ofgem are shown; and we also include forecasts for anticipated future Ofgem determinations in respect of the Iteration adjustment reflecting our latest view of totex, changes to allowed totex and cost of debt."]
[null,"This respects commercial confidentiality and disclosure considerations."]
[]
[null,"Note that actual revenues may vary from those currently forecast.  "]
[]
[null,"All £ figures are in money of the day"]
[]
[null,"Information provided in £m to one decimal place"]
[]
[null,"Assumptions"]
[null,"It is assumed that there will be one set of price changes per year effective on 1st April."]

{"sheet":"T42","index":42,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[[49,1,49,5],[51,1,51,5],[3,1,3,3],[4,9,5,9],[43,1,43,5],[4,1,5,1],[4,2,5,2],[4,3,5,3],[46,1,46,7],[3,4,3,8]]}
[]
[null,"Table 42 - SHE Transmission Revenue Forecast"]
[]
[null,"SHE Transmission Revenue Forecast\n (adjusted for NGET RPI forecast)",null,null,"2017-02-13",null,null,null,null," "]
[null,"Description"," ","Licence\nTerm",null,null,null,null,null,"Notes"]
[null,"Regulatory Year"," "," ","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Actual RPI"," "," "]
[null,"RPI Actual"," ","RPIAt"]
[null,"Assumed Interest Rate"," ","It",1.7899999999999999E-2,2E-3,3.0000000000000001E-3,6.0000000000000001E-3,0,"National Grid forecast"]
[null,"Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",119.59699999999999,120,122.09699999999999,122.52500000000001,217.92500000000001,"As per licence"]
[null,"Price Control Financial Model Iteration Adjustment","A2","MODt",52.688000000000002,63,91.5,80.400000000000006,0,"MOD value published on 30 November 2016. "]
[null,"RPI True Up","A3","TRUt",-6.1337279999999996,-2.3010199999999998,-3.97,-2.722,0,"RPI true up reflective of RPIF being higher than RPI outturn"]
[null,"RPI Forecast","A4","RPIFt",1.27092,1.3089999999999999,1.343,1.3839999999999999,1.4259999999999999,"NGET RPI forecast"]
[null,"Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",211.16497461024002,236.53496482,281.52906099999996,277.08095199999997,310.76105000000001]
[null,"Pass-Through Business Rates","B1","RBt",19.216000000000001,19.721811699762323,20.150056475903614,20.668220121638452,0,"Reflective of substantial increase in business rates expected due to the change in rateable assets since last valuation."]
[null,"Temporary Physical Disconnection","B2","TPDt",0.10299999999999999,0,0,0,0,"Expected to remain at similar levels across remaining years of the price control."]
[null,"Pass-Through Items [B=B1+B2]","B","PTt",19.319000000000003,19.721811699762323,20.150056475903614,20.668220121638452,0]
[null,"Reliability Incentive Adjustment","C1","RIt",1.657,1.7011078739553784,1.7161679216867469,1.7605510368579174,1.7706430155210642,"Expected to remain at similar levels across remaining years of the price control."]
[null,"Stakeholder Satisfaction Adjustment","C2","SSOt",0.85673999999999995,0.7537062025607606,0.72610993975903604,0.74539459221806981,0.74966740576496671,"Expected to remain at similar levels across remaining years of the price control following Ofgem's determination"]
[null,"Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt",-5.2200000000000003E-2,-5.419458713486161E-2,-5.6632530120481923E-2,-5.8820253535575587E-2,-5.9157427937915744E-2,"Expected to remain at similar levels across remaining years of the price control."]
[null,"Awarded Environmental Discretionary Rewards","C4","EDRt",0,0,0,0,0]
[null,"Financial Incentive for Timely Connections Output","C5","-CONADJt",0,0,0,0,0,"N/A"]
[null,"Outputs Incentive Revenue [C=C1+C2+C3+C4+C5]","C","OIPt",2.4615399999999998,2.4006194893812776,2.3856453313253012,2.4471253755404119,2.4611529933481151]
[null,"Network Innovation Allowance","D","NIAt",1.296,1.4451889902629762,1.4562650602409637,1.4603649153660143,1.4687361419068736,"Expected to remain at similar levels across remaining years of the price control."]
[null,"Transmission Investment for Renewable Generation","G","TIRGt",84.256190000000004,83.52088399907997,82.451907379518076,81.609045211401778,80.356186252771622,"Based on forecast of TIRG related revenue."]
[null,"Compensatory Payments Adjustment","J","SHCPt",0,0,0,0,0,"N/A"]
[null,"Correction Factor","K","-Kt",-13.775,4.4971471287280531,-28.944279367469878,-27.774315234117385,0,"Reflective of tariffs set."]
[null,"Maximum Revenue (M= A+B+C+D+G+J+K]","M","TOt",304.72270461024004,348.12061612721453,359.02865587951806,355.49139238982923,395.04712538802664]
[null,"Excluded Services","P","EXCt",17.5,18.365943417925322,19.012349397590363,19.674360665347692,20.297117516629712,"Post BETTA Connection Charges - reflecting projects forecasted to complete and RPI uplift. 16/17 connection charges reflective of updated STCP 13-1 schedule. This reflects changes to project connection dates and mod apps to capital contributions for some projects. "]
[null,"Site Specifc Charges","S","EXSt",3.355,3.3409959365176722,2.7758030120481929,2.8588671502894405,2.9578713968957868,"Post-Vesting, Pre-BETTA Connection Charges - reflecting projects terminating and RPI uplift"]
[null,"TNUoS Collected Revenue (T=M+P-S)","T","TSHt",318.86770461024003,363.14556360862218,375.26520226506022,372.30688590488751,412.3863715077606]
[null,"Final Collected Revenue","U","TNRt",0,0,0,0,0]
[null,"Forecast percentage change to TNUoS Collected Revenue T"," ",null,null,null,null,null,null," "]
[]
[null,"Notes:"]
[null,"All monies are  nominal 'money of the day' prices unless stated otherwise"]
[null,"Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
[null,"Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
[null,"NIC payments are not included as they do not form part of SHET Maximum Revenue"]
[]
[null,"Commentary"]
[null,"All reasonable care has been taken in the preparation of these illustrative tables and the data therein.  SHET offers these data without prejudice and cannot be held responsible for any loss that might be attributed to the use of these data.  SHET does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
[null,"The base revenue forecasts for the RIIO-ET1 period (2014/15 to 2020/21, inclusive) reflect the figures authorised by Ofgem in the RIIO-ET1 Final Proposals.  "]
[null,"Within the bounds of commercial confidentiality, this forecast provides as much information as possible."]
[]
[null,"This forecast contains as much information as can be currently made available.  Generally, allowances determined by Ofgem are shown; whilst those for which Ofgem determinations are expected are not."]
[null,"This respects commercial confidentiality and disclosure considerations."]
[]
[null,"Note that actual revenues may vary from those currently forecast.  "]
[]
[null,"All £ figures are in money of the day"]
[]
[null,"Information provided in £m to one decimal place"]
[]
[null,"Assumptions"]
[null,"It is assumed that there will be one set of price changes per year effective on 1st April."]

{"sheet":"T43","index":43,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,2,3,9],[4,10,5,10],[15,2,18,2],[18,3,20,3],[19,4,20,4]]}
[]
[null,"Table 43 - Offshore Transmission Revenue Forecast"]
[]
[null,"Offshore Transmission Revenue Forecast","2017-02-20",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,"Notes"]
[null,"Regulatory Year","2014/15","2015/16","2016/17","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,"Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.8724963671592052,5.9335841425035687,6.1116359551559141,6.2949850338105904,6.4933019758864168,"Current revenues plus indexation"]
[null,"Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.4249984897309567,7.6478334459090407,7.8772684492863112,7.8688011953413062,"Current revenues plus indexation"]
[null,"Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.528200814636111,13.93416063131653,14.352185450256027,14.016976698399851,"Current revenues plus indexation"]
[null,"Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.3564278787342126,8.6071748669484123,8.8653901129568649,8.8665460191235148,"Current revenues plus indexation"]
[null,"Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,14.002315518803382,14.422577795772643,14.855255129645824,14.979406485796211,"Current revenues plus indexation"]
[null,"Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.62068068008319,21.239590553049258,21.876778269640738,21.884541658694165,"Current revenues plus indexation"]
[null,"Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.523694555737656,12.899556641817052,13.28654334107156,13.541186083233205,"Current revenues plus indexation"]
[null,"Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.164119257930345,29.009291379283294,29.879570120661793,31.146086274191902,"Current revenues plus indexation"]
[null,"London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,39.716431327484607,40.908202153141239,42.13544821773548,42.116665315028825,"Current revenues plus indexation"]
[null,"Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.435705210069173,18.989026268327844,19.558697056377678,20.600915339998259,"Current revenues plus indexation"]
[null,"Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,26.623898286721705,27.422912601698048,28.245599979748995,28.476300071999269,"Current revenues plus indexation"]
[null,"Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,27.86974144016234,28.706279050414615,29.567467421927049,29.415393071063622,"Current revenues plus indexation"]
[null,"West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.377606184024472,23.049341621825537,23.740821870480307,23.002271413793011,"Current revenues plus indexation"]
[null,"Humber Gateway",null,null,29.284541507176115,9.7498990869565194,11.589142086907277,11.937213895386744,12.295330312248346,12.311845437400713,"Current revenues plus indexation"]
[null,"Westermost Rough",null,null,null,11.576692607080746,12.863254239107732,13.340657125707359,13.740876839478583,13.740876839478583,"Current revenues plus indexation"]
[null,"Forecast to commission in 2017/18",null,null,null,4.6723058592602724,18.54335202934541,19.100046348666833,19.67304773912684,20.263239171300647,"National Grid Forecast"]
[null,"Forecast to commission in 2018/19",null,null,null,null,91.59288539684421,132.70438139244592,136.68551283421928,140.78607821924589,"National Grid Forecast"]
[null,"Forecast to commission in 2019/20",null,null,null,null,null,42.448837049446368,60.803542658050944,62.627648937792472,"National Grid Forecast"]
[null,"Forecast to commission in 2020/21",null,null,null,null,null,null,70.30232571154157,107.0578529027301,"National Grid Forecast"]
[null,"Forecast to commission in 2021/22",null,null,null,null,null,null,null,0,"National Grid Forecast"]
[null,"Offshore Transmission Pass-Through (B7)",{"$f":"SUM(C7:C26)","v":218.38037349491282},{"$f":"SUM(D7:D26)","v":248.35699921993759},260.78931257200446,270.20460754023685,380.16603753882629,472.47871877631263,{"$f":"SUM(I7:I26)","v":574.03664654826468},619.195933110498," "]
[]
[null,"Notes:"]
[null,"All monies are  nominal 'money of the day' prices unless stated otherwise"]
[null,"Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
[null,"Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
[null,"NIC payments are not included as they do not form part of OFTO Maximum Revenue"]

{"sheet":"T44","index":44,"n_rows":259,"n_cols":10,"rows_kept":259,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Table 44 - Contracted TEC at Peak"]
[]
[null,"Generator","Technology","Nodes","Zone","2017/18\n(MW)","2018/19\n(MW)","2019/20\n(MW)","2020/21\n(MW)","2021/22\n(MW)"]
[null,"Aquind Interconnector","Interconnectors","LOVE40",26,0,0,0,0,2000]
[null,"Auchencrosh (interconnector CCT)","Interconnectors","AUCH20",10,80,80,80,80,80]
[null,"Belgium Interconnector (Nemo)","Interconnectors","CANT40",24,0,1000,1000,1000,1000]
[null,"Britned","Interconnectors","GRAI40",24,1200,1200,1200,1200,1200]
[null,"East West Interconnector","Interconnectors","CONQ40",16,505,505,505,505,505]
[null,"ElecLink","Interconnectors","SELL40",24,1000,1000,1000,1000,1000]
[null,"FAB Link Interconnector","Interconnectors","EXET40",26,0,0,0,1400,1400]
[null,"IFA Interconnector","Interconnectors","SELL40",24,2000,2000,2000,2000,2000]
[null,"IFA2 Interconnector","Interconnectors","FAWL40",26,0,0,1100,1100,1100]
[null,"Norway Interconnector","Interconnectors","PEHE40",2,0,0,0,0,1400]
[null,"NS Link","Interconnectors","BLYT4A",13,0,0,0,1400,1400]
[null,"Aberarder Wind Farm","Wind Onshore","ABED10",1,0,0,35.799999999999997,35.799999999999997,35.799999999999997]
[null,"Aberdeen Offshore Wind Farm","Wind offshore","ABBA10",10,0,99,99,99,99]
[null,"Aberthaw","Coal","ABTH20",21,1610,1610,1610,1610,1610]
[null,"A'Chruach Wind Farm","Wind Onshore","ACHR1R",7,43,43,43,43,43]
[null,"Afton","Wind Onshore","BLAC10",10,50,50,50,50,50]
[null,"Aigas","Hydro","AIGA1Q",1,20,20,20,20,20]
[null,"Aikengall II Windfarm","Wind Onshore","WDOD10",11,140,140,140,140,140]
[null,"An Suidhe Wind Farm, Argyll (SRO)","Wind Onshore","ANSU10",7,19.3,19.3,19.3,19.3,19.3]
[null,"Arecleoch","Wind Onshore","AREC10",10,114,114,114,114,114]
[null,"Aultmore Wind Farm","Wind Onshore","AULW10",1,0,0,0,29.5,29.5]
[null,"Bad a Cheo Wind Farm","Wind Onshore","MYBS11",1,0,29.9,29.9,29.9,29.9]
[null,"Baglan Bay","CCGT","BAGB20",21,552,552,552,552,552]
[null,"Barrow Offshore Wind Farm","Wind Offshore","HEYS40",14,90,90,90,90,90]
[null,"Barry Power Station","CCGT","ABTH20",21,142,142,142,142,142]
[null,"Beatrice Wind Farm","Wind Offshore","BLHI40",1,0,294,588,588,588]
[null,"Beaw Field Wind Farm","Wind Onshore","KERG20",1,0,0,0,72,72]
[null,"Beinn an Tuirc 3","Wind Onshore","CAAD1Q",7,0,0,0,50,50]
[null,"Beinneun Wind Farm","Wind Onshore","BEIN10",3,109,109,109,109,109]
[null,"Benbrack & Quantans Hill","Wind Onshore","KEON10",1,0,0,72,72,72]
[null,"Bhlaraidh Wind Farm","Wind Onshore","BHLA10",3,108,108,108,108,108]
[null,"Blackcraig Wind Farm","Wind Onshore","BLCW10",10,57.5,57.5,57.5,57.5,57.5]
[null,"Blacklaw","Wind Onshore","BLKL10",11,118,118,118,118,118]
[null,"Blacklaw Extension","Wind Onshore","BLKX10",11,60,60,60,60,60]
[null,"BP Grangemouth","CHP","GRMO20",9,120,120,120,120,120]
[null,"Bradwell B","Nuclear","GRAI40",24,0,0,0,0,1670]
[null,"Burbo Bank Extension Offshore Wind Farm","Wind Offshore","BODE40",16,254,254,254,254,254]
[null,"C.Gen Killingholme North Power Station","CCGT","KILL40",15,0,0,490,490,490]
[null,"Cantick Head","Tidal","BASK20",1,0,0,0,0,30]
[null,"Carnedd Wen Wind Farm","Wind Onshore","TRAW40",18,0,0,150,150,150]
[null,"Carraig Gheal Wind Farm","Wind Onshore","FERO10",7,46,46,46,46,46]
[null,"Carrington Power Station","CCGT","CARR40",16,910,910,910,910,910]
[null,"CDCL","CCGT","COTT40",16,395,395,395,395,395]
[null,"Clunie","Hydro","CLUN1S",5,61.2,61.2,61.2,61.2,61.2]
[null,"Clyde North","Wind Onshore","CLYN2Q",11,374.5,374.5,374.5,374.5,374.5]
[null,"Clyde South","Wind Onshore","CLYS2R",11,128.80000000000001,128.80000000000001,128.80000000000001,128.80000000000001,128.80000000000001]
[null,"Codling Park Wind Farm","Wind Offshore","PENT40",19,0,0,0,0,1000]
[null,"Connahs Quay","CCGT","CONQ40",16,1380,1380,1380,1380,1380]
[null,"Corby","CCGT","GREN40_EME",18,401,401,401,401,401]
[null,"Corriegarth","Wind Onshore","COGA10",1,69,69,69,69,69]
[null,"Corriemoillie Wind Farm","Wind Onshore","CORI10",1,47.5,47.5,47.5,47.5,47.5]
[null,"Coryton","CCGT","COSO40",24,800,704,704,704,704]
[null,"Cottam","Coal","COTT40",16,2000,2000,2000,2000,2000]
[null,"Cour Wind Farm","Wind Onshore","CRSS10",7,20.5,20.5,20.5,20.5,20.5]
[null,"Creag Riabhach Wind Farm","Wind Onshore","CASS1Q",1,0,0,0,72.599999999999994,72.599999999999994]
[null,"Crookedstane Windfarm","Wind Onshore","CLYS2R",11,18.399999999999999,18.399999999999999,18.399999999999999,18.399999999999999,18.399999999999999]
[null,"Crossburns Wind Farm","Wind Onshore","CROB20",5,0,0,0,0,99]
[null,"Crossdykes","Wind Onshore","EWEH1Q",12,0,46,46,46,46]
[null,"Cruachan","Pump Storage","CRUA20",8,440,440,440,440,440]
[null,"Crystal Rig 2 Wind Farm","Wind Onshore","CRYR40",11,138,138,138,138,138]
[null,"Crystal Rig 3 Wind Farm","Wind Onshore","CRYR40",11,62,13.8,13.8,62,62]
[null,"Culligran","Hydro","CULL1Q",1,19.100000000000001,19.100000000000001,19.100000000000001,19.100000000000001,19.100000000000001]
[null,"Cumberhead","Wind Onshore","GAWH10",11,0,0,50,50,50]
[null,"Dalquhandy Wind Farm","Wind Onshore","DALQ10",0,0,0,0,0,45]
[null,"Damhead Creek","CCGT","KINO40",24,805,805,805,805,805]
[null,"Damhead Creek II","CCGT","KINO40",24,0,0,1800,1800,1800]
[null,"Deanie","Hydro","DEAN1Q",1,38,38,38,38,38]
[null,"Deeside","CCGT","CONQ40",16,1,1,1,1,1]
[null,"Dersalloch Wind Farm","Wind Onshore","DERS1Q",10,69,69,69,69,69]
[null,"Didcot B","CCGT","DIDC40",25,1550,1550,1550,1550,1550]
[null,"Dinorwig","Pump Storage","DINO40",19,1644,1644,1644,1644,1644]
[null,"Dogger Bank Platform 1","Wind Offshore","CREB40",15,0,0,0,0,500]
[null,"Dogger Bank Platform 3","Wind Offshore","LACK40",15,0,0,0,500,1000]
[null,"Dogger Bank Platform 4","Wind Offshore","CREB40",15,0,0,0,0,500]
[null,"Dorenell Wind Farm","Wind Onshore","DORE11",1,0,220,220,220,220]
[null,"Douglas West","Wind Onshore","COAL10",11,0,0,0,0,45]
[null,"Drax (Biomass)","Biomass","DRAX40",15,1905,1905,1905,1905,1905]
[null,"Drax (Coal)","Coal","DRAX40",15,2001,2001,2001,2001,2001]
[null,"Druim Leathann","Wind Onshore","COUA1Q",5,0,0,0,46.2,46.2]
[null,"Dudgeon Offshore Wind Farm","Wind Offshore","NECT40",17,400,400,400,400,400]
[null,"Dungeness B","Nuclear","DUNG40",24,1091,1091,1091,1091,1091]
[null,"Dunlaw Extension","Wind Onshore","DUNE10",11,29.75,29.75,29.75,29.75,29.75]
[null,"Dunmaglass Wind Farm","Wind Onshore","DUNM10",1,94,94,94,94,94]
[null,"East Anglia 3","Wind Offshore","BRFO40",18,0,0,0,0,1200]
[null,"East Anglia One","Wind Offshore","BRFO40",18,0,129,680,680,680]
[null,"East Anglia One North","Wind Offshore","BRFO40",18,0,0,0,520,520]
[null,"Edinbane Wind, Skye","Wind Onshore","EDIN10",4,41.4,41.4,41.4,41.4,41.4]
[null,"Enfield","CCGT","BRIM2A_LPN",24,408,408,408,408,408]
[null,"Enoch Hill","Wind Onshore","ENHI10",0,0,0,0,69,69]
[null,"Errochty","Hydro","ERRO10",5,75,75,75,75,75]
[null,"Ewe Hill","Wind Onshore","EWEH1Q",12,39,39,39,39,39]
[null,"Fallago Rig Wind Farm","Wind Onshore","FALL40",11,144,144,144,144,144]
[null,"Farr Wind Farm, Tomatin","Wind Onshore","FAAR1Q",1,92,92,92,92,92]
[null,"Fasnakyle G1 & G2","Hydro","FASN20",3,46,46,46,46,46]
[null,"Fawley CHP","CHP","FAWL40",26,158,158,158,158,158]
[null,"Ffestiniog","Pump Storage","FFES20",16,360,360,360,360,360]
[null,"Fiddlers Ferry","Coal","FIDF20_ENW",15,1455,1455,1455,1987,1987]
[null,"Finlarig","Hydro","FINL1Q",6,16.5,16.5,16.5,16.5,16.5]
[null,"Firth of Forth Offshore Wind Farm 1A","Wind Offshore","TEAL20",9,0,0,0,0,545]
[null,"Firth of Forth Offshore Wind Farm 1B","Wind Offshore","TEAL20",9,0,0,0,0,530]
[null,"Foyers","Pump Storage","FOYE20",1,300,300,300,300,300]
[null,"Freasdail","Wind Onshore","CRSS10",7,22.2,22.2,22.2,22.2,22.2]
[null,"Galawhistle Wind Farm","Wind Onshore","GAWH10",11,55.2,55.2,55.2,55.2,55.2]
[null,"Galloper Wind Farm","Wind Offshore","LEIS10",18,340,340,340,340,340]
[null,"Gateway Energy Centre Power Station","CCGT","COSO40",24,0,0,0,1096,1096]
[null,"Gilston Hill Wind Farm","Wind Onshore","DUNE10",11,0,0,0,21,21]
[null,"Glen App Windfarm","Wind Onshore","AREC10",10,32.200000000000003,32.200000000000003,32.200000000000003,32.200000000000003,32.200000000000003]
[null,"Glen Kyllachy Wind Farm","Wind Onshore","GLKY10",1,0,0,48.5,48.5,48.5]
[null,"Glen Ullinish Wind Farm","Wind Onshore","GLNU10",0,0,0,0,0,42]
[null,"Glendoe","Hydro","GLDO1G",3,99.9,99.9,99.9,99.9,99.9]
[null,"Glenmorie Windfarm","Wind Onshore","GLEM10",3,0,0,0,114,114]
[null,"Glenmoriston","Hydro","GLEN1Q",3,37,37,37,37,37]
[null,"Glenmuckloch Wind Farm","Wind Onshore","GLGL1Q",10,0,0,0,25.6,25.6]
[null,"Glenouther Wind Farm (Harelaw)","Wind Onshore","NEIL10",11,0,0,0,24,24]
[null,"Gordonbush Wind","Wind Onshore","GORW20",1,70,70,70,108,108]
[null,"Grain","CCGT","GRAI40",24,1517,1517,1517,1517,1517]
[null,"Great Yarmouth","CCGT","NORM40",18,405,405,405,405,405]
[null,"Greater Gabbard Offshore Wind Farm","Wind Offshore","LEIS10",18,500,500,500,500,500]
[null,"Greenwire Wind Farm - Pentir","Wind Offshore","PENT40",19,0,0,0,1000,1000]
[null,"Griffin Wind Farm","Wind Onshore","GRIF1S",5,188.6,188.6,188.6,188.6,188.6]
[null,"Gunfleet Sands II Offshore Wind Farm","Wind Offshore","BRFO40",18,64,64,64,64,64]
[null,"Gunfleet Sands Offshore Wind Farm","Wind Offshore","BRFO40",18,99.9,99.9,99.9,99.9,99.9]
[null,"Gwynt Y Mor Offshore Wind Farm","Wind Offshore","BODE40",16,574,574,574,574,574]
[null,"Hadyard Hill","Wind Onshore","HADH10",10,99.9,99.9,99.9,99.9,99.9]
[null,"Halsary Wind Farm","Wind Onshore","MYBS11",1,0,0,0,28.5,28.5]
[null,"Harestanes","Wind Onshore","HARE10",12,125.00000000000001,125.00000000000001,125.00000000000001,125.00000000000001,125.00000000000001]
[null,"Harry Burn Wind Farm","Wind Onshore","ELVA2Q",11,0,0,0,110,110]
[null,"Harting Rig Wind Farm","Wind Onshore","KYPE10",11,0,0,0,61.2,61.2]
[null,"Hartlepool","Nuclear","HATL20",13,1207,1207,1207,1207,1207]
[null,"Hatfield Power Station","CCGT","THOM41",16,0,0,800,800,800]
[null,"Heysham Power Station","Nuclear","HEYS40",14,2433,2433,2433,2433,2433]
[null,"Hinkley Point B","Nuclear","HINP40",26,1061,1061,1061,1061,1061]
[null,"Hirwaun Power Station","CCGT","RHIG40",21,0,0,0,299,299]
[null,"Holyhead","Biomass","WYLF40",19,0,0,210,210,210]
[null,"Hopsrig Wind Farm","Wind Onshore","EWEH1Q",12,0,0,0,0,73.599999999999994]
[null,"Hornsea Power Station 1A","Wind Offshore","KILL40",15,0,0,400,400,400]
[null,"Hornsea Power Station 1B","Wind Offshore","KILL40",15,0,400,400,400,400]
[null,"Hornsea Power Station 1C","Wind Offshore","KILL40",15,0,0,400,400,400]
[null,"Hornsea Power Station 2A","Wind Offshore","KILL40",15,0,0,500,500,500]
[null,"Hornsea Power Station 2B","Wind Offshore","KILL40",15,0,0,0,500,500]
[null,"Humber Gateway Offshore Wind Farm","Wind Offshore","HEDO20",15,220,220,220,220,220]
[null,"Hunterston","Nuclear","HUER40",10,1074,1074,1074,1074,1074]
[null,"Immingham","CHP","HUMR40",15,1218,1218,1218,1218,1218]
[null,"Inch Cape Offshore Wind Farm Platform 1","Wind Offshore","COCK20",11,0,0,0,330,330]
[null,"Inch Cape Offshore Wind Farm Platform 2","Wind Offshore","COCK20",11,0,0,0,270,270]
[null,"Indian Queens","OCGT","INDQ40",27,140,140,140,140,140]
[null,"Invergarry","Hydro","INGA1Q",3,20,20,20,20,20]
[null,"J G Pears","CHP","HIGM20",16,0,13,30,30,30]
[null,"Keadby","CCGT","KEAD40",16,755,755,755,755,755]
[null,"Keadby II","CCGT","KEAD40",16,0,0,820,820,820]
[null,"Keith Hill Wind Farm","Wind Onshore","DUNE10",11,4.5,4.5,4.5,4.5,4.5]
[null,"Kilbraur Wind Farm","Wind Onshore","STRB20",1,67,67,67,67,67]
[null,"Kilgallioch","Wind Onshore","KILG20",10,274,228,228,228,228]
[null,"Killingholme","CCGT","KILL40",15,0,600,600,600,600]
[null,"Kilmorack","Hydro","KIOR1Q",1,20,20,20,20,20]
[null,"Kings Lynn A","CCGT","WALP40_EME",17,0,281,281,281,281]
[null,"Kings Lynn B","CCGT","KLYN40",17,0,0,0,981,981]
[null,"Knottingley Power Station","CCGT","KNOT40",15,0,0,1652,1652,1652]
[null,"Kype Muir","Wind Onshore","KYPE10",11,0,88.4,88.4,88.4,88.4]
[null,"Langage","CCGT","LAGA40",27,905,905,905,905,905]
[null,"Lethans Wind Farm","Wind Onshore","GLGL1Q",10,0,0,0,88.4,88.4]
[null,"Limekilns","Wind Onshore","DOUN10",1,0,0,0,90,90]
[null,"Lincs Offshore Wind Farm","Wind Offshore","WALP40_EME",17,256,256,256,256,256]
[null,"Little Barford","CCGT","EASO40",18,740,740,740,740,740]
[null,"Loch Hill Wind Farm","Wind Onshore","GLLE10",10,0,0,0,27.5,27.5]
[null,"Lochay","Hydro","LOCH10",6,47,47,47,47,47]
[null,"Lochluichart","Wind Onshore","CORI10",1,69,69,69,69,69]
[null,"London Array Offshore Wind Farm","Wind Offshore","CLEH40",24,630,630,630,630,630]
[null,"Luichart","Hydro","LUIC1Q",1,34,34,34,34,34]
[null,"Lynemouth Power Station","Coal","BLYT20",13,376,376,376,376,376]
[null,"Marchwood","CCGT","MAWO40",26,920,920,920,920,920]
[null,"Marex","Pump Storage","CONQ40",16,0,1500,1500,1500,1500]
[null,"Margree","Wind Onshore","MARG10",10,42.5,42.5,42.5,42.5,42.5]
[null,"Mark Hill Wind Farm","Wind Onshore","MAHI20",10,53,53,53,53,53]
[null,"Medway Power Station","CCGT","GRAI40",24,735,735,735,735,735]
[null,"MeyGen Tidal","Tidal","GILB10",1,0,15,71,154,237]
[null,"Middle Muir Wind Farm","Wind Onshore","MIDM10",11,0,51,51,51,51]
[null,"Millennium South","Wind Onshore","MILS1Q",3,0,25,25,25,25]
[null,"Millennium Wind (Stage 3), Ceannacroc","Wind Onshore","MILW1Q",3,65,65,65,65,65]
[null,"Minnygap","Wind Onshore","MOFF10",11,25,25,25,25,25]
[null,"Moray Firth Offshore Wind Farm","Wind Offshore","NEDE20",2,0,0,20,504,1000]
[null,"Mossford","Hydro","MOSS1S",1,18.66,18.66,18.66,18.66,18.66]
[null,"Muaitheabhal Wind Farm","Wind Onshore","STWN20",4,0,0,0,150,150]
[null,"Nant","Hydro","NANT1Q",7,15,15,15,15,15]
[null,"Neart Na Gaoithe Offshore Wind Farm","Wind Offshore","CRYR40",11,0,450,450,450,450]
[null,"Ormonde Offshore Wind Farm","Wind Offshore","HEYS40",14,150,150,150,150,150]
[null,"Orrin","Hydro","ORRI10",1,18,18,18,18,18]
[null,"Pembroke Power Station","CCGT","PEMB40",20,2199,2199,2199,2199,2199]
[null,"Pen Y Cymoedd Wind Farm","Wind Onshore","RHIG40",21,228,228,228,228,228]
[null,"Pencloe Windfarm","Wind Onshore","BLAC10",10,63,63,63,63,63]
[null,"Peterborough","CCGT","WALP40_EME",17,245,245,245,245,245]
[null,"Peterhead","CCGT","PEHE20",2,400,400,400,1180,1180]
[null,"Pogbie Wind Farm","Wind Onshore","DUNE10",11,11.8,11.8,11.8,11.8,11.8]
[null,"Progress Power Station","CCGT","BRFO40",18,0,0,0,299,299]
[null,"Race Bank Wind Farm","Wind Offshore","WALP40_EME",17,565,565,565,565,565]
[null,"Rampion Offshore Wind Farm","Wind Offshore","BOLN40",25,400,400,400,400,400]
[null,"Ratcliffe on Soar","Coal","RATS40",18,2021,2021,2021,2021,2021]
[null,"Robin Rigg East Offshore Wind Farm","Wind Offshore","HARK40",12,92,92,92,92,92]
[null,"Robin Rigg West Offshore Wind Farm","Wind Offshore","HARK40",12,92,92,92,92,92]
[null,"Rocksavage","CCGT","ROCK40",16,810,810,810,810,810]
[null,"Rye House","CCGT","RYEH40",24,715,715,715,715,715]
[null,"Sallachy Wind Farm","Wind Onshore","CASS1Q",1,0,0,0,66,66]
[null,"Saltend","CCGT","SAES20",15,1100,1100,1100,1100,1100]
[null,"Sandy Knowe Wind Farm","Wind Onshore","GLGL1Q",10,0,0,0,90,90]
[null,"Sanquhar Wind Farm","Wind Onshore","GLGL1Q",10,30,30,30,30,30]
[null,"Seabank","CCGT","SEAB40",22,1234,1234,1234,1234,1234]
[null,"Sellafield","CHP","HUTT40",14,155,155,155,155,155]
[null,"Severn Power","CCGT","USKM20",21,850,850,850,850,850]
[null,"Sheringham Shoal Offshore Wind Farm","Wind Offshore","NORM40",18,315,315,315,315,315]
[null,"Shoreham","CCGT","BOLN40",25,420,420,420,420,420]
[null,"Sizewell B","Nuclear","SIZE40",18,1216,1216,1216,1216,1216]
[null,"Sizewell C","Nuclear","SIZE40",18,0,0,1670,1670,3340]
[null,"Sloy G2 and G3","Hydro","SLOY10",8,80,80,80,80,80]
[null,"South Humber Bank","CCGT","SHBA40",15,1365,1365,1365,1365,1365]
[null,"South Kyle","Wind Onshore","NECU10",10,0,0,0,165,165]
[null,"Spalding","CCGT","SPLN40",17,880,880,880,880,880]
[null,"Spalding Energy Expansion","CCGT","SPLN40",17,0,0,0,920,920]
[null,"Staythorpe C","CCGT","STAY40",16,1752,1752,1752,1752,1752]
[null,"Stella North EFR Submission","Battery","STEW40",0,0,25,25,25,25]
[null,"Stornoway Wind Farm","Wind Onshore","STWN20",1,0,0,0,129.6,129.6]
[null,"Strathy North and South Wind","Wind Onshore","STRW10",1,200.25,67.650000000000006,67.650000000000006,67.650000000000006,225.25]
[null,"Strathy Wood","Wind Onshore","GORW20",1,0,0,0,84,84]
[null,"Stronelairg","Wind Onshore","STRL10",3,227.8,227.8,227.8,227.8,227.8]
[null,"Sutton Bridge","CCGT","WALP40_EME",17,819,819,819,819,819]
[null,"Taylors Lane","CCGT","WISD20_LPN",23,0,144,144,144,144]
[null,"Tees Renewable Energy Plant","Biomass","GRSA20",13,0,285,285,285,285]
[null,"Thanet Offshore Wind Farm","Wind Offshore","CANT40",24,300,300,300,300,300]
[null,"Thorpe Marsh","CCGT","THOM41",16,0,0,0,1600,1600]
[null,"Tidal Lagoon","Tidal","BAGB20",21,0,0,0,320,320]
[null,"Toddleburn Wind Farm","Wind Onshore","DUNE10",11,27.6,27.6,27.6,27.6,27.6]
[null,"Tom Na Clach","Wind Onshore","TOMN1J",1,0,39.1,39.1,39.1,39.1]
[null,"Torness","Nuclear","TORN40",11,1215,1215,1215,1215,1215]
[null,"Trafford Power - Stage 1","CCGT","CARR40",16,0,1944,1944,1944,1944]
[null,"Tralorg Wind Farm","Wind Onshore","MAHI20",10,0,20,20,20,20]
[null,"Triton Knoll Offshore Wind Farm","Wind Offshore","BICF4A",17,0,0,360,900,900]
[null,"Upper Sonachan","Wind Onshore","MYBS11",1,0,0,0,0,58]
[null,"Uskmouth","Coal","USKM20",21,230,230,230,230,230]
[null,"Viking Wind Farm","Wind Onshore","KERG20",1,0,0,0,412,412]
[null,"Walney 3 Offshore Wind Farm","Wind Offshore","HEYS40",14,330,330,330,330,330]
[null,"Walney 4 Offshore Wind Farm","Wind Offshore","HEYS40",14,330,330,330,330,330]
[null,"Walney I Offshore Wind Farm","Wind Offshore","HEYS40",14,182,182,182,182,182]
[null,"Walney II Offshore Wind Farm","Wind Offshore","STAH4A",14,182,182,182,182,182]
[null,"West Burton A","Coal","WBUR40",16,1987,1987,1987,1987,1987]
[null,"West Burton B","CCGT","WBUR40",16,1295,1295,1295,1295,1295]
[null,"West of Duddon Sands Offshore Wind Farm","Wind Offshore","HEYS40",14,382,382,382,382,382]
[null,"Westermost Rough Offshore Wind Farm","Wind Offshore","HEDO20",15,205,205,205,205,205]
[null,"Westray South","Tidal","DOUN20",1,0,0,0,0,60]
[null,"Whitelaw Brae Windfarm","Wind Onshore","CLYS2R",11,0,0,50.4,50.4,50.4]
[null,"Whitelee","Wind Onshore","WLEE20",10,305,305,305,305,305]
[null,"Whitelee Extension","Wind Onshore","WLEX20",10,206,206,206,206,206]
[null,"Whiteside Hill Wind Farm","Wind Onshore","GLGL1Q",10,27,27,27,27,27]
[null,"Willington","CCGT","WILE40",18,0,0,0,1530,1530]
[null,"Willow Wind Farm","Wind Onshore","WILW10",10,0,0,0,45,45]
[null,"Wilton","CCGT","GRSA20",13,141,141,141,141,141]
[null,"Windy Standard II (Brockloch Rig 1) Wind Farm","Wind Onshore","DUNH1R",10,75,75,75,75,75]

{"sheet":"T45","index":45,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Table 45 - Contracted TEC at Peak by Zone"]
[]
[null,"Zone","2017/18\n(MW)","2018/19\n(MW)","2019/20\n(MW)","2020/21\n(MW)","2021/22\n(MW)"]
[null,1,{"$f":"SUMIF('T44'!$E:$E,$B5,'T44'!F:F)","v":1176.51},{"$f":"SUMIF('T44'!$E:$E,$B5,'T44'!G:G)","v":1641.91},{"$f":"SUMIF('T44'!$E:$E,$B5,'T44'!H:H)","v":2148.21},{"$f":"SUMIF('T44'!$E:$E,$B5,'T44'!I:I)","v":3253.4099999999994},{"$f":"SUMIF('T44'!$E:$E,$B5,'T44'!J:J)","v":3642.0099999999993}]
[null,2,{"$f":"SUMIF('T44'!$E:$E,$B6,'T44'!F:F)","v":400},{"$f":"SUMIF('T44'!$E:$E,$B6,'T44'!G:G)","v":400},{"$f":"SUMIF('T44'!$E:$E,$B6,'T44'!H:H)","v":420},{"$f":"SUMIF('T44'!$E:$E,$B6,'T44'!I:I)","v":1684},{"$f":"SUMIF('T44'!$E:$E,$B6,'T44'!J:J)","v":3580}]
[null,3,{"$f":"SUMIF('T44'!$E:$E,$B7,'T44'!F:F)","v":712.7},{"$f":"SUMIF('T44'!$E:$E,$B7,'T44'!G:G)","v":737.7},{"$f":"SUMIF('T44'!$E:$E,$B7,'T44'!H:H)","v":737.7},{"$f":"SUMIF('T44'!$E:$E,$B7,'T44'!I:I)","v":851.7},{"$f":"SUMIF('T44'!$E:$E,$B7,'T44'!J:J)","v":851.7}]
[null,4,{"$f":"SUMIF('T44'!$E:$E,$B8,'T44'!F:F)","v":41.4},{"$f":"SUMIF('T44'!$E:$E,$B8,'T44'!G:G)","v":41.4},{"$f":"SUMIF('T44'!$E:$E,$B8,'T44'!H:H)","v":41.4},{"$f":"SUMIF('T44'!$E:$E,$B8,'T44'!I:I)","v":191.4},{"$f":"SUMIF('T44'!$E:$E,$B8,'T44'!J:J)","v":191.4}]
[null,5,{"$f":"SUMIF('T44'!$E:$E,$B9,'T44'!F:F)","v":324.79999999999995},{"$f":"SUMIF('T44'!$E:$E,$B9,'T44'!G:G)","v":324.79999999999995},{"$f":"SUMIF('T44'!$E:$E,$B9,'T44'!H:H)","v":324.79999999999995},{"$f":"SUMIF('T44'!$E:$E,$B9,'T44'!I:I)","v":371},{"$f":"SUMIF('T44'!$E:$E,$B9,'T44'!J:J)","v":470}]
[null,6,{"$f":"SUMIF('T44'!$E:$E,$B10,'T44'!F:F)","v":63.5},{"$f":"SUMIF('T44'!$E:$E,$B10,'T44'!G:G)","v":63.5},{"$f":"SUMIF('T44'!$E:$E,$B10,'T44'!H:H)","v":63.5},{"$f":"SUMIF('T44'!$E:$E,$B10,'T44'!I:I)","v":63.5},{"$f":"SUMIF('T44'!$E:$E,$B10,'T44'!J:J)","v":63.5}]
[null,7,{"$f":"SUMIF('T44'!$E:$E,$B11,'T44'!F:F)","v":166},{"$f":"SUMIF('T44'!$E:$E,$B11,'T44'!G:G)","v":166},{"$f":"SUMIF('T44'!$E:$E,$B11,'T44'!H:H)","v":166},{"$f":"SUMIF('T44'!$E:$E,$B11,'T44'!I:I)","v":216},{"$f":"SUMIF('T44'!$E:$E,$B11,'T44'!J:J)","v":216}]
[null,8,{"$f":"SUMIF('T44'!$E:$E,$B12,'T44'!F:F)","v":520},{"$f":"SUMIF('T44'!$E:$E,$B12,'T44'!G:G)","v":520},{"$f":"SUMIF('T44'!$E:$E,$B12,'T44'!H:H)","v":520},{"$f":"SUMIF('T44'!$E:$E,$B12,'T44'!I:I)","v":520},{"$f":"SUMIF('T44'!$E:$E,$B12,'T44'!J:J)","v":520}]
[null,9,{"$f":"SUMIF('T44'!$E:$E,$B13,'T44'!F:F)","v":120},{"$f":"SUMIF('T44'!$E:$E,$B13,'T44'!G:G)","v":120},{"$f":"SUMIF('T44'!$E:$E,$B13,'T44'!H:H)","v":120},{"$f":"SUMIF('T44'!$E:$E,$B13,'T44'!I:I)","v":120},{"$f":"SUMIF('T44'!$E:$E,$B13,'T44'!J:J)","v":1195}]
[null,10,{"$f":"SUMIF('T44'!$E:$E,$B14,'T44'!F:F)","v":2652.1},{"$f":"SUMIF('T44'!$E:$E,$B14,'T44'!G:G)","v":2725.1},{"$f":"SUMIF('T44'!$E:$E,$B14,'T44'!H:H)","v":2725.1},{"$f":"SUMIF('T44'!$E:$E,$B14,'T44'!I:I)","v":3166.6},{"$f":"SUMIF('T44'!$E:$E,$B14,'T44'!J:J)","v":3166.6}]
[null,11,{"$f":"SUMIF('T44'!$E:$E,$B15,'T44'!F:F)","v":2552.5499999999997},{"$f":"SUMIF('T44'!$E:$E,$B15,'T44'!G:G)","v":3093.75},{"$f":"SUMIF('T44'!$E:$E,$B15,'T44'!H:H)","v":3194.15},{"$f":"SUMIF('T44'!$E:$E,$B15,'T44'!I:I)","v":4058.55},{"$f":"SUMIF('T44'!$E:$E,$B15,'T44'!J:J)","v":4103.55}]
[null,12,{"$f":"SUMIF('T44'!$E:$E,$B16,'T44'!F:F)","v":348},{"$f":"SUMIF('T44'!$E:$E,$B16,'T44'!G:G)","v":394},{"$f":"SUMIF('T44'!$E:$E,$B16,'T44'!H:H)","v":394},{"$f":"SUMIF('T44'!$E:$E,$B16,'T44'!I:I)","v":394},{"$f":"SUMIF('T44'!$E:$E,$B16,'T44'!J:J)","v":467.6}]
[null,13,{"$f":"SUMIF('T44'!$E:$E,$B17,'T44'!F:F)","v":1724},{"$f":"SUMIF('T44'!$E:$E,$B17,'T44'!G:G)","v":2009},{"$f":"SUMIF('T44'!$E:$E,$B17,'T44'!H:H)","v":2009},{"$f":"SUMIF('T44'!$E:$E,$B17,'T44'!I:I)","v":3409},{"$f":"SUMIF('T44'!$E:$E,$B17,'T44'!J:J)","v":3409}]
[null,14,{"$f":"SUMIF('T44'!$E:$E,$B18,'T44'!F:F)","v":4234},{"$f":"SUMIF('T44'!$E:$E,$B18,'T44'!G:G)","v":4234},{"$f":"SUMIF('T44'!$E:$E,$B18,'T44'!H:H)","v":4234},{"$f":"SUMIF('T44'!$E:$E,$B18,'T44'!I:I)","v":4234},{"$f":"SUMIF('T44'!$E:$E,$B18,'T44'!J:J)","v":4234}]
[null,15,{"$f":"SUMIF('T44'!$E:$E,$B19,'T44'!F:F)","v":9469},{"$f":"SUMIF('T44'!$E:$E,$B19,'T44'!G:G)","v":10469},{"$f":"SUMIF('T44'!$E:$E,$B19,'T44'!H:H)","v":13911},{"$f":"SUMIF('T44'!$E:$E,$B19,'T44'!I:I)","v":15443},{"$f":"SUMIF('T44'!$E:$E,$B19,'T44'!J:J)","v":16943}]
[null,16,{"$f":"SUMIF('T44'!$E:$E,$B20,'T44'!F:F)","v":12978},{"$f":"SUMIF('T44'!$E:$E,$B20,'T44'!G:G)","v":16435},{"$f":"SUMIF('T44'!$E:$E,$B20,'T44'!H:H)","v":18072},{"$f":"SUMIF('T44'!$E:$E,$B20,'T44'!I:I)","v":19672},{"$f":"SUMIF('T44'!$E:$E,$B20,'T44'!J:J)","v":19672}]
[null,17,{"$f":"SUMIF('T44'!$E:$E,$B21,'T44'!F:F)","v":3165},{"$f":"SUMIF('T44'!$E:$E,$B21,'T44'!G:G)","v":3446},{"$f":"SUMIF('T44'!$E:$E,$B21,'T44'!H:H)","v":3806},{"$f":"SUMIF('T44'!$E:$E,$B21,'T44'!I:I)","v":6247},{"$f":"SUMIF('T44'!$E:$E,$B21,'T44'!J:J)","v":6247}]
[null,18,{"$f":"SUMIF('T44'!$E:$E,$B22,'T44'!F:F)","v":6101.9},{"$f":"SUMIF('T44'!$E:$E,$B22,'T44'!G:G)","v":6230.9},{"$f":"SUMIF('T44'!$E:$E,$B22,'T44'!H:H)","v":8601.9},{"$f":"SUMIF('T44'!$E:$E,$B22,'T44'!I:I)","v":10950.9},{"$f":"SUMIF('T44'!$E:$E,$B22,'T44'!J:J)","v":13820.9}]
[null,19,{"$f":"SUMIF('T44'!$E:$E,$B23,'T44'!F:F)","v":1644},{"$f":"SUMIF('T44'!$E:$E,$B23,'T44'!G:G)","v":1644},{"$f":"SUMIF('T44'!$E:$E,$B23,'T44'!H:H)","v":1854},{"$f":"SUMIF('T44'!$E:$E,$B23,'T44'!I:I)","v":2854},{"$f":"SUMIF('T44'!$E:$E,$B23,'T44'!J:J)","v":3854}]
[null,20,{"$f":"SUMIF('T44'!$E:$E,$B24,'T44'!F:F)","v":2199},{"$f":"SUMIF('T44'!$E:$E,$B24,'T44'!G:G)","v":2199},{"$f":"SUMIF('T44'!$E:$E,$B24,'T44'!H:H)","v":2199},{"$f":"SUMIF('T44'!$E:$E,$B24,'T44'!I:I)","v":2199},{"$f":"SUMIF('T44'!$E:$E,$B24,'T44'!J:J)","v":2199}]
[null,21,{"$f":"SUMIF('T44'!$E:$E,$B25,'T44'!F:F)","v":3612},{"$f":"SUMIF('T44'!$E:$E,$B25,'T44'!G:G)","v":3612},{"$f":"SUMIF('T44'!$E:$E,$B25,'T44'!H:H)","v":3612},{"$f":"SUMIF('T44'!$E:$E,$B25,'T44'!I:I)","v":4231},{"$f":"SUMIF('T44'!$E:$E,$B25,'T44'!J:J)","v":4231}]
[null,22,{"$f":"SUMIF('T44'!$E:$E,$B26,'T44'!F:F)","v":1234},{"$f":"SUMIF('T44'!$E:$E,$B26,'T44'!G:G)","v":1234},{"$f":"SUMIF('T44'!$E:$E,$B26,'T44'!H:H)","v":1234},{"$f":"SUMIF('T44'!$E:$E,$B26,'T44'!I:I)","v":1234},{"$f":"SUMIF('T44'!$E:$E,$B26,'T44'!J:J)","v":1234}]
[null,23,{"$f":"SUMIF('T44'!$E:$E,$B27,'T44'!F:F)","v":0},{"$f":"SUMIF('T44'!$E:$E,$B27,'T44'!G:G)","v":144},{"$f":"SUMIF('T44'!$E:$E,$B27,'T44'!H:H)","v":144},{"$f":"SUMIF('T44'!$E:$E,$B27,'T44'!I:I)","v":144},{"$f":"SUMIF('T44'!$E:$E,$B27,'T44'!J:J)","v":144}]
[null,24,{"$f":"SUMIF('T44'!$E:$E,$B28,'T44'!F:F)","v":11201},{"$f":"SUMIF('T44'!$E:$E,$B28,'T44'!G:G)","v":12105},{"$f":"SUMIF('T44'!$E:$E,$B28,'T44'!H:H)","v":13905},{"$f":"SUMIF('T44'!$E:$E,$B28,'T44'!I:I)","v":15001},{"$f":"SUMIF('T44'!$E:$E,$B28,'T44'!J:J)","v":16671}]
[null,25,{"$f":"SUMIF('T44'!$E:$E,$B29,'T44'!F:F)","v":2370},{"$f":"SUMIF('T44'!$E:$E,$B29,'T44'!G:G)","v":2370},{"$f":"SUMIF('T44'!$E:$E,$B29,'T44'!H:H)","v":2370},{"$f":"SUMIF('T44'!$E:$E,$B29,'T44'!I:I)","v":2370},{"$f":"SUMIF('T44'!$E:$E,$B29,'T44'!J:J)","v":2370}]
[null,26,{"$f":"SUMIF('T44'!$E:$E,$B30,'T44'!F:F)","v":2139},{"$f":"SUMIF('T44'!$E:$E,$B30,'T44'!G:G)","v":2139},{"$f":"SUMIF('T44'!$E:$E,$B30,'T44'!H:H)","v":3239},{"$f":"SUMIF('T44'!$E:$E,$B30,'T44'!I:I)","v":4639},{"$f":"SUMIF('T44'!$E:$E,$B30,'T44'!J:J)","v":6639}]
[null,27,{"$f":"SUMIF('T44'!$E:$E,$B31,'T44'!F:F)","v":1045},{"$f":"SUMIF('T44'!$E:$E,$B31,'T44'!G:G)","v":1045},{"$f":"SUMIF('T44'!$E:$E,$B31,'T44'!H:H)","v":1045},{"$f":"SUMIF('T44'!$E:$E,$B31,'T44'!I:I)","v":1045},{"$f":"SUMIF('T44'!$E:$E,$B31,'T44'!J:J)","v":1045}]
[null,"Total",{"$f":"SUM(C5:C31)","v":72193.459999999992},{"$f":"SUM(D5:D31)","v":79544.06},91090.760000000009,108563.06,121180.26]

{"sheet":"T46","index":46,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,4,1]]}
[]
[null,"Table 46 - Zonal Summary of Modelled Demand"]
[]
[null,"Demand Zone","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,null,"MW","MW","MW","MW","MW"]
[null,1,683.41163472485994,227,226,228,231]
[null,2,3069.9276113145088,2820.3501231149562,2820.3501231149562,2820.3501231149562,2815.3501231149562]
[null,3,2608.6194430713422,2508,2519,2531,2542]
[null,4,3504.43559719114,3234,3232,3240,3261]
[null,5,4650.7617840490175,4347,4364,4375,4392]
[null,6,2687.6257413845751,2831,2894,2946,3007]
[null,7,5137.05,5333,5400,5474,5557]
[null,8,4497.6200000000008,4594,4609,4628,4675]
[null,9,5849.5500799044394,5843,5914,5982,6066]
[null,10,1968.4491287141259,1969,1976,1990,1997]
[null,11,3626.1968574439834,3355,3367,3383,3417]
[null,12,5317.1114330342762,5271,5441,5565,5638]
[null,13,5935.9985053198043,5668,5719,5820,5868]
[null,14,2604.2421694114041,2609,2629,2658,2699]
[null,"Total",{"$f":"SUM(C6:C19)","v":52140.999985563474},{"$f":"SUM(D6:D19)","v":50609.350123114957},{"$f":"SUM(E6:E19)","v":51110.350123114957},{"$f":"SUM(F6:F19)","v":51640.350123114957},{"$f":"SUM(G6:G19)","v":52165.350123114957}]

{"sheet":"T47","index":47,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,4,1]]}
[]
[null,"Table 47 - Zonal Summary of Chargeable System Demand"]
[]
[null,"Demand Zone","2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,null,"MW","MW","MW","MW","MW"]
[null,1,923.39290518154701,899.10278287619053,879.73808800485324,874.31597344087879,870.83032836403811]
[null,2,3109.18075648987,3027.392841052344,2962.1894630413094,2943.9325171982196,2932.195909156233]
[null,3,2266.9940537198099,2207.3601075183888,2159.8184295619299,2146.5067597341213,2137.9492577019587]
[null,4,3853.9566242042001,3752.5771602337095,3671.7549082364294,3649.1246776771909,3634.5766723176807]
[null,5,3565.7788173020404,3471.9799554090223,3397.2011495634692,3376.2630839267144,3362.8028988745145]
[null,6,2349.8904015339499,2288.0758424907212,2238.7957252714509,2224.9972924500553,2216.126871350587]
[null,7,4360.13004310631,4245.4355382860795,4153.9982016871973,4128.3957474395102,4111.9370268517123]
[null,8,4124.5780954244401,4016.0798539568427,3929.5823339491567,3905.3630283470047,3889.7934747456211]
[null,9,6035.8988667776202,5877.1227695452435,5750.5424815946672,5715.1000009685058,5692.3155491374018]
[null,10,1656.5409925711999,1612.9651939186424,1578.2254740410065,1568.4983524752683,1562.2452028972937]
[null,11,3711.1965426071197,3613.5724246251648,3535.7440286608062,3513.9520777907856,3499.9429665172011]
[null,12,4111.6954374663601,4003.5360781102272,3917.3087234233817,3893.165064111065,3877.6441402674327]
[null,13,5179.4554173176493,5043.2083172415969,4934.5887110119693,4904.1752212676738,4884.6236921463405]
[null,14,2435.6619393403398,2371.5911347358287,2320.5122819523735,2306.210203173006,2297.0160096719837]
[null,"Total",{"$f":"SUM(C6:C19)","v":47684.350893042458},{"$f":"SUM(D6:D19)","v":46430},{"$f":"SUM(E6:E19)","v":45430.000000000007},{"$f":"SUM(F6:F19)","v":45150},{"$f":"SUM(G6:G19)","v":44970}]

{"sheet":"T48","index":48,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,4,1]]}
[]
[null,"Table 48 - Zonal Summary of Chargeable HH Demand"]
[]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,null,"MW","MW","MW","MW","MW"]
[null,1,-668.02518754006996,-719.6884709635583,-773.22319231242648,-834.3335817767005,-895.44397124097463]
[null,2,641.72624725943103,691.35564089732713,742.78279734302305,801.48738158763808,860.19196583225335]
[null,3,314.28879402604002,338.59504975628477,363.78176924692775,392.53264715605786,421.28352506518803]
[null,4,1174.62172956108,1265.4638362085363,1359.5965847265047,1467.0500052045629,1574.5034256826211]
[null,5,1106.63776172046,1192.2221699093645,1280.9067664078857,1382.1410699580842,1483.375373508283]
[null,6,519.72386685261199,559.91792231035947,601.56795723309494,649.11186502225542,696.65577281141577]
[null,7,1456.3131601862899,1568.9405295600641,1685.647684741374,1818.8700033917373,1952.0923220421007]
[null,8,1400.27141784163,1508.56466857392,1620.780707078366,1748.8763736730637,1876.9720402677615]
[null,9,1472.8609945053199,1586.7681291789879,1704.8014075600215,1839.5375083534652,1974.2736091469094]
[null,10,554.19907683760096,597.0593529375634,641.47218901572603,692.16986038796813,742.86753176021034]
[null,11,870.40427992040998,937.71902170751969,1007.4721559538333,1087.0960167444368,1166.7198775350403]
[null,12,2194.2604212165502,2363.9586603857933,2539.8040063513331,2740.5331276893548,2941.2622490273766]
[null,13,1649.5978441991599,1777.173334688468,1909.3700880056451,2060.273929056385,2211.1777701071255]
[null,14,540.174501908769,581.95015484937073,625.23907864869227,674.65379355169148,724.06850845469069]
[null,"Total",{"$f":"SUM(C6:C19)","v":13227.054908495282},{"$f":"SUM(D6:D19)","v":14250.000000000002},15310.000000000002,16520,17730]

{"sheet":"T49","index":49,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,1,4,1]]}
[]
[null,"Table 49 - Zonal Summary of Chargeable NHH Demand"]
[]
[null,null,"2017/18","2018/19","2019/20","2020/21","2021/22"]
[null,null,"TWh","TWh","TWh","TWh","TWh"]
[null,1,0.75225297642106703,0.70431210615689621,0.66122128109666412,0.62021070276347778,0.5818747273650644]
[null,2,1.76349874604969,1.6511114677731418,1.5500940994916628,1.4539534317479101,1.364082807552663]
[null,3,1.2867901254155101,1.204783353234617,1.1310729793025414,1.0609210372154625,0.99534422178623638]
[null,4,2.0635602677575,1.9320501532352208,1.8138445531427707,1.7013454302961628,1.5961832067656381]
[null,5,1.85009563232831,1.7321895588851199,1.6262117166748489,1.5253500461574876,1.431066310673867]
[null,6,1.29552264685725,1.2129593535449827,1.1387487601846358,1.0681207471934089,1.0020989089624794]
[null,7,2.22653039872502,2.0846342436677872,1.9570933300256652,1.8357095639386802,1.7222421304225852]
[null,8,2.0977760860117902,1.9640854070313742,1.8439198441539273,1.7295553774153918,1.622649462855456]
[null,9,3.1892579612672201,2.9860074498667788,2.8033192303601617,2.6294504421400711,2.466920922716942]
[null,10,0.87023311332356501,0.81477340217171679,0.76492439655361599,0.71748189465500978,0.67313346896718207]
[null,11,1.99565684849878,1.8684741997562491,1.7541582677036516,1.6453610358191106,1.5436592755792133]
[null,12,1.9278990406801,1.8050345779412649,1.694599972961736,1.5894966937398398,1.4912479762063275]
[null,13,2.6756026639855901,2.5050872599750051,2.3518224276136652,2.2059565871594247,2.0696037363000253]
[null,14,1.3185268088342199,1.2344974667598452,1.1589691407344538,1.0870870097585641,1.0198928438463193]
[null,"Total",{"$f":"SUM(C6:C19)","v":25.313203316155612},{"$f":"SUM(D6:D19)","v":23.7},{"$f":"SUM(E6:E19)","v":22.249999999999996},{"$f":"SUM(F6:F19)","v":20.869999999999997},{"$f":"SUM(G6:G19)","v":19.579999999999995}]

{"sheet":"T50","index":50,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[[61,6,62,6],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[42,6,43,6],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[42,1,43,1],[42,2,43,2],[42,3,43,3],[42,4,43,4],[42,5,43,5],[4,6,5,6],[4,8,5,8],[4,9,5,9],[4,10,5,10],[23,6,24,6],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[23,11,24,11],[23,12,24,12],[4,11,5,11],[4,12,5,12],[42,11,43,11],[42,12,43,12],[42,8,43,8],[42,9,43,9],[42,10,43,10],[23,8,24,8],[23,9,24,9],[23,10,24,10],[61,8,62,8],[61,9,62,9],[61,10,62,10],[61,11,62,11],[61,12,62,12],[61,13,62,13],[4,14,5,14],[23,14,24,14],[42,14,43,14],[61,14,62,14],[23,13,24,13],[42,13,43,13],[4,13,5,13]]}
[]
[null,"Table 50 - Breakdown of HH Demand Tariffs, and CMP264/265 Calculator",null,null,null,null,null,null,"CMP264/265 WACM4 Indicative Embedded Export Tariff*"]
[]
[]
[null,"Zone","Zone Name","18/19 Demand \nPeak Security\nHH (£/kW)","18/19 Demand\nYear Round\nHH (£/kW)","18/19 Demand\nResidual\nHH (£/kW)","18/19 Demand\nTotal \nHH (£/kW)",null,"Zone","Zone Name","18/19 Demand \nPeak Security\nHH (£/kW)","18/19 Demand\nYear Round\nHH (£/kW)","18/19 *Demand\nResidual Phasing (£/kW)","**Indicative Avoided GSP Infrastructure Credit (£/kW)","18/19 Indicative Embedded Export Tariff (£/kW)"]
[]
[null,1,"Northern Scotland",2.0931474662090972,-7.137758584715173,52.242687115919537,47.198075997413461,null,1,"Northern Scotland",{"$f":"D7","v":2.0931474662090972},{"$f":"E7","v":-7.137758584715173},{"$f":"F7*2/3","v":34.828458077279691},1.62,{"$f":"IF(SUM(K7:N7)<0,0,SUM(K7:N7))","v":31.403846958773617}]
[null,2,"Southern Scotland",-1.5953033220617614,-18.580040582730938,52.242687115919537,32.067343211126797,null,2,"Southern Scotland",{"$f":"D8","v":-1.5953033220617614},-18.580040582730938,{"$f":"F8*2/3","v":34.828458077279691},1.62,{"$f":"IF(SUM(K8:N8)<0,0,SUM(K8:N8))","v":16.273114172486995}]
[null,3,"Northern",-3.2185547481210133,-5.9651832967545051,52.242687115919537,43.058949071044019,null,3,"Northern",-3.2185547481210133,-5.9651832967545051,34.828458077279691,1.62,27.264720032404174]
[null,4,"North West",-0.8645861570968898,-1.4162510071485293,52.242687115919537,49.961849951674118,null,4,"North West",-0.8645861570968898,-1.4162510071485293,34.828458077279691,1.62,34.16762091303427]
[null,5,"Yorkshire",-2.5875386099035573,0.18977092917642935,52.242687115919537,49.844919435192409,null,5,"Yorkshire",-2.5875386099035573,0.18977092917642935,34.828458077279691,1.62,34.050690396552561]
[null,6,"N Wales & Mersey",-2.1853984545963092,1.2352698196580496,52.242687115919537,51.292558480981278,null,6,"N Wales & Mersey",-2.1853984545963092,1.2352698196580496,34.828458077279691,1.62,35.498329442341429]
[null,7,"East Midlands",-1.7026796439188547,2.6383522638331334,52.242687115919537,53.178359735833816,null,7,"East Midlands",-1.7026796439188547,2.6383522638331334,34.828458077279691,1.62,37.384130697193967]
[null,8,"Midlands",-1.4524076703154656,3.7015438235903693,52.242687115919537,54.491823269194441,null,8,"Midlands",-1.4524076703154656,3.7015438235903693,34.828458077279691,1.62,38.697594230554593]
[null,9,"Eastern",1.6747837655668443,1.0302364168761349,52.242687115919537,54.947707298362516,null,9,"Eastern",1.6747837655668443,1.0302364168761349,34.828458077279691,1.62,39.153478259722668]
[null,10,"South Wales",-6.1719946434784942,4.5389810011282021,52.242687115919537,50.609673473569245,null,10,"South Wales",-6.1719946434784942,4.5389810011282021,34.828458077279691,1.62,34.815444434929397]
[null,11,"South East",3.8059051822185692,1.2564133751661659,52.242687115919537,57.305005673304272,null,11,"South East",3.8059051822185692,1.2564133751661659,34.828458077279691,1.62,41.510776634664424]
[null,12,"London",5.54922405680216,2.3643482750519169,52.242687115919537,60.156259447773614,null,12,"London",5.54922405680216,2.3643482750519169,34.828458077279691,1.62,44.362030409133766]
[null,13,"Southern",1.8862373582804888,4.3137842791795578,52.242687115919537,58.442708753379584,null,13,"Southern",1.8862373582804888,4.3137842791795578,34.828458077279691,1.62,42.648479714739736]
[null,14,"South Western",-0.86740061277341707,5.5116510225168236,52.242687115919537,56.886937525662944,null,14,"South Western",-0.86740061277341707,5.5116510225168236,34.828458077279691,1.62,41.092708487023096]
[]
[]
[]
[null,"Zone","Zone Name","19/20 Demand \nPeak Security\nHH (£/kW)","19/20 Demand\nYear Round\nHH (£/kW)","19/20 Demand\nResidual\nHH (£/kW)","19/20 Demand\nTotal\nHH (£/kW)",null,"Zone","Zone Name","19/20 Demand \nPeak Security\nHH (£/kW)","19/20 Demand\nYear Round\nHH (£/kW)","19/20 *Demand\nResidual Phasing (£/kW)","**Indicative Avoided GSP Infrastructure Credit (£/kW)","19/20 Indicative Embedded Export Tariff (£/kW)"]
[]
[null,1,"Northern Scotland",2.2329494141065411,-6.5101574812561864,58.235155390940058,53.957947323790414,null,1,"Northern Scotland",{"$f":"D26","v":2.2329494141065411},{"$f":"E26","v":-6.5101574812561864},{"$f":"F26/3","v":19.411718463646686},1.62,{"$f":"IF(SUM(K26:N26)<0,0,SUM(K26:N26))","v":16.754510396497039}]
[null,2,"Southern Scotland",-2.3666874253123642,-18.671579197634124,58.235155390940058,37.19688876799357,null,2,"Southern Scotland",{"$f":"D27","v":-2.3666874253123642},{"$f":"E27","v":-18.671579197634124},{"$f":"F27/3","v":19.411718463646686},1.62,{"$f":"IF(SUM(K27:N27)<0,0,SUM(K27:N27))","v":0}]
[null,3,"Northern",-3.6288956608738214,-5.9078531114592678,58.235155390940058,48.698406618606967,null,3,"Northern",{"$f":"D28","v":-3.6288956608738214},{"$f":"E28","v":-5.9078531114592678},{"$f":"F28/3","v":19.411718463646686},1.62,11.494969691313596]
[null,4,"North West",-1.4810241547166045,-0.91144407424207685,58.235155390940058,55.842687161981374,null,4,"North West",-1.4810241547166045,-0.91144407424207685,19.411718463646686,1.62,18.639250234688006]
[null,5,"Yorkshire",-2.9157397369765823,0.38064274445777357,58.235155390940058,55.700058398421248,null,5,"Yorkshire",-2.9157397369765823,0.38064274445777357,19.411718463646686,1.62,18.496621471127877]
[null,6,"N Wales & Mersey",-2.9320358485876672,1.8725544738557645,58.235155390940058,57.175674016208156,null,6,"N Wales & Mersey",-2.9320358485876672,1.8725544738557645,19.411718463646686,1.62,19.972237088914785]
[null,7,"East Midlands",-1.6819516588905703,2.6501376468608555,58.235155390940058,59.203341378910345,null,7,"East Midlands",-1.6819516588905703,2.6501376468608555,19.411718463646686,1.62,21.999904451616974]
[null,8,"Midlands",-1.8942422469854108,4.1453243042975032,58.235155390940058,60.486237448252147,null,8,"Midlands",-1.8942422469854108,4.1453243042975032,19.411718463646686,1.62,23.28280052095878]
[null,9,"Eastern",1.9407199463691589,0.48692660404979904,58.235155390940058,60.662801941359014,null,9,"Eastern",1.9407199463691589,0.48692660404979904,19.411718463646686,1.62,23.459365014065643]
[null,10,"South Wales",-6.0486218167169836,4.1755074487400776,58.235155390940058,56.362041022963155,null,10,"South Wales",-6.0486218167169836,4.1755074487400776,19.411718463646686,1.62,19.15860409566978]
[null,11,"South East",4.2718438666239633,0.64443286827843593,58.235155390940058,63.151432125842454,null,11,"South East",4.2718438666239633,0.64443286827843593,19.411718463646686,1.62,25.947995198549087]
[null,12,"London",6.0007789983646402,1.782279040719466,58.235155390940058,66.018213430024161,null,12,"London",6.0007789983646402,1.782279040719466,19.411718463646686,1.62,28.814776502730794]
[null,13,"Southern",2.1634528845880694,3.4543687389165569,58.235155390940058,63.852977014444683,null,13,"Southern",2.1634528845880694,3.4543687389165569,19.411718463646686,1.62,26.649540087151312]
[null,14,"South Western",7.1941934163692045E-2,5.1993874517878211,58.235155390940058,63.506484776891568,null,14,"South Western",7.1941934163692045E-2,5.1993874517878211,19.411718463646686,1.62,26.303047849598201]
[]
[]
[]
[null,"Zone","Zone Name","20/21 Demand \nPeak Security\nHH (£/kW)","20/21 Demand\nYear Round\nHH (£/kW)","20/21 Demand\nResidual\nHH (£/kW)","20/21 Demand\nTotal\nHH (£/kW)",null,"Zone","Zone Name","20/21 Demand \nPeak Security\nHH (£/kW)","20/21 Demand\nYear Round\nHH (£/kW)","20/21 *Demand\nResidual Phasing (£/kW)","**Indicative Avoided GSP Infrastructure Credit (£/kW)","20/21 Indicative Embedded Export Tariff (£/kW)"]
[]
[null,1,"Northern Scotland",3.5188846754622132,-8.2906774216507593,64.604218903196696,59.83242615700815,null,1,"Northern Scotland",{"$f":"D45","v":3.5188846754622132},{"$f":"E45","v":-8.2906774216507593},0,1.62,{"$f":"IF(SUM(K45:N45)<0,0,SUM(K45:N45))","v":0}]
[null,2,"Southern Scotland",-1.1938686542836947,-19.906694180749415,64.604218903196696,43.503656068163586,null,2,"Southern Scotland",{"$f":"D46","v":-1.1938686542836947},{"$f":"E46","v":-19.906694180749415},0,1.62,{"$f":"IF(SUM(K46:N46)<0,0,SUM(K46:N46))","v":0}]
[null,3,"Northern",-3.474264509048592,-7.5166274690017296,64.604218903196696,53.613326925146374,null,3,"Northern",{"$f":"D47","v":-3.474264509048592},{"$f":"E47","v":-7.5166274690017296},0,1.62,0]
[null,4,"North West",-0.99027479532332441,-1.9766896254549082,64.604218903196696,61.637254482418463,null,4,"North West",-0.99027479532332441,-1.9766896254549082,0,1.62,0]
[null,5,"Yorkshire",-2.8143099487532628,-0.61557828723157781,64.604218903196696,61.174330667211855,null,5,"Yorkshire",-2.8143099487532628,-0.61557828723157781,0,1.62,0]
[null,6,"N Wales & Mersey",-2.1661906848700423,0.79911995425652949,64.604218903196696,63.237148172583183,null,6,"N Wales & Mersey",-2.1661906848700423,0.79911995425652949,0,1.62,0.2529292693864873]
[null,7,"East Midlands",-2.2206436471716513,2.5891827452308247,64.604218903196696,64.972758001255869,null,7,"East Midlands",-2.2206436471716513,2.5891827452308247,0,1.62,1.9885390980591735]
[null,8,"Midlands",-1.6497269946075259,3.4801486772768508,64.604218903196696,66.434640585866021,null,8,"Midlands",-1.6497269946075259,3.4801486772768508,0,1.62,3.450421682669325]
[null,9,"Eastern",1.5132588001970082,0.37434791471501638,64.604218903196696,66.49182561810872,null,9,"Eastern",1.5132588001970082,0.37434791471501638,0,1.62,3.5076067149120247]
[null,10,"South Wales",-5.9078579729335106,3.8790651885443781,64.604218903196696,62.575426118807563,null,10,"South Wales",-5.9078579729335106,3.8790651885443781,0,1.62,0]
[null,11,"South East",4.0915891836133342,0.44282260950113805,64.604218903196696,69.138630696311168,null,11,"South East",4.0915891836133342,0.44282260950113805,0,1.62,6.1544117931144724]
[null,12,"London",5.7925776657162,1.693046809821519,64.604218903196696,72.089843378734415,null,12,"London",5.7925776657162,1.693046809821519,0,1.62,9.10562447553772]
[null,13,"Southern",2.1091929039544128,3.2839942864582197,64.604218903196696,69.997406093609328,null,13,"Southern",2.1091929039544128,3.2839942864582197,0,1.62,7.0131871904126326]
[null,14,"South Western",-0.97708843006390356,3.8170188816393305,64.604218903196696,67.444149354772122,null,14,"South Western",-0.97708843006390356,3.8170188816393305,0,1.62,4.4599304515754268]
[]
[]
[]
[null,"Zone","Zone Name","21/22 Demand \nPeak Security\nHH (£/kW)","21/22 Demand\nYear Round\nHH (£/kW)","21/22 Demand\nResidual\nHH (£/kW)","21/22 Demand\nTotal\nHH (£/kW)",null,"Zone","Zone Name","21/22 Demand \nPeak Security\nHH (£/kW)","21/22 Demand\nYear Round\nHH (£/kW)","20/21 *Demand\nResidual Phasing (£/kW)","**Indicative Avoided GSP Infrastructure Credit (£/kW)","20/21 Indicative Embedded Export Tariff (£/kW)"]
[]
[null,1,"Northern Scotland",4.3307742109921161,-9.0921393597624114,69.536905040272558,64.775539891502262,null,1,"Northern Scotland",{"$f":"D64","v":4.3307742109921161},{"$f":"E64","v":-9.0921393597624114},0,1.62,{"$f":"IF(SUM(K64:N64)<0,0,SUM(K64:N64))","v":0}]
[null,2,"Southern Scotland",-1.6466721691331387,-20.886026618740814,69.536905040272558,47.004206252398603,null,2,"Southern Scotland",{"$f":"D65","v":-1.6466721691331387},{"$f":"E65","v":-20.886026618740814},0,1.62,{"$f":"IF(SUM(K65:N65)<0,0,SUM(K65:N65))","v":0}]
[null,3,"Northern",-3.5611455589899976,-7.3763696627924933,69.536905040272558,58.599389818490067,null,3,"Northern",-3.5611455589899976,-7.3763696627924933,0,1.62,0]
[null,4,"North West",-0.97878602691830929,-1.6229123646175529,69.536905040272558,66.935206648736695,null,4,"North West",-0.97878602691830929,-1.6229123646175529,0,1.62,0]
[null,5,"Yorkshire",-2.9670655486489173,-0.1422022746949958,69.536905040272558,66.427637216928645,null,5,"Yorkshire",-2.9670655486489173,-0.1422022746949958,0,1.62,0]
[null,6,"N Wales & Mersey",-1.189452807904773,0.73699521561062076,69.536905040272558,69.084447447978405,null,6,"N Wales & Mersey",-1.189452807904773,0.73699521561062076,0,1.62,1.1675424077058478]
[null,7,"East Midlands",-2.2652646536436971,3.2310325637458699,69.536905040272558,70.50267295037473,null,7,"East Midlands",-2.2652646536436971,3.2310325637458699,0,1.62,2.5857679101021729]
[null,8,"Midlands",-1.071853082025475,3.9427555860974675,69.536905040272558,72.40780754434455,null,8,"Midlands",-1.071853082025475,3.9427555860974675,0,1.62,4.4909025040719923]
[null,9,"Eastern",1.1026220906112403,1.6860653493464295,69.536905040272558,72.325592480230227,null,9,"Eastern",1.1026220906112403,1.6860653493464295,0,1.62,4.4086874399576699]
[null,10,"South Wales",-4.6893873763022791,7.1205187649627684,69.536905040272558,71.968036428933047,null,10,"South Wales",-4.6893873763022791,7.1205187649627684,0,1.62,4.0511313886604894]
[null,11,"South East",3.6343081250240803,2.0389986694462974,69.536905040272558,75.210211834742935,null,11,"South East",3.6343081250240803,2.0389986694462974,0,1.62,7.2933067944703778]
[null,12,"London",5.4331699975558507,3.1373076154820154,69.536905040272558,78.107382653310424,null,12,"London",5.4331699975558507,3.1373076154820154,0,1.62,10.190477613037867]
[null,13,"Southern",1.9225963179649759,4.9190830757183885,69.536905040272558,76.378584433955922,null,13,"Southern",1.9225963179649759,4.9190830757183885,0,1.62,8.4616793936833652]
[null,14,"South Western",-0.58147799056021909,5.8222900182761093,69.536905040272558,74.777717067988448,null,14,"South Western",-0.58147799056021909,5.8222900182761093,0,1.62,6.8608120277158902]
[]
[]
[null,null,null,null,null,null,null,null,"*Indicative Avoided GSP Infrastructure Cost – £1.62/kW is based on National Grid’s estimate of this value in 2013 and is expressed in 2013/14 prices."]
[null,null,null,null,null,null,null,null,"*Demand Residual – The demand residual is expected to be affected by the implementation of WACM 4, \nhowever for the purpose of providing an initial view of the embedded export tariff, it has been assumed to be the same as current forecasts."]