{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Index","Residuals","T1","T2 & Fig 1","T3 & Fig 2","T4 & Fig 3","T5","T6 & Fig 4","T7","T8","T9","T10","T11","T12","T13","T14","T15","T16","T17","T18","T19 & Fig 5","T20 & Fig 6","T21 & Fig 7","T22","T23 & T24","T25","T26","T27"],"not_rendered":{"charts":9,"images":0,"macros":1,"external_links":3,"defined_names":215,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["TNUoS Tariff Forecast for Charging Year 2018/19 - October 2017"]
["Index"]
["Residuals and Averages"]
[{"$f":"'T1'!A1","v":"Table 1 - Demand Tariffs"}]
[{"$f":"'T2 & Fig 1'!A1&\" \"&\"&\"&\" \"&'T2 & Fig 1'!H1","v":"Table 2 - Gross HH Demand Tariffs & Figure 1 - Gross HH Demand Tariffs"}]
[{"$f":"'T3 & Fig 2'!A1&\" \"&\"&\"&\" \"&'T3 & Fig 2'!H1","v":"Table 3 - Embedded Export Tariff & Figure 2 - Embedded Export Tariff"}]
[{"$f":"'T4 & Fig 3'!A1&\" \"&\"&\"&\" \"&'T4 & Fig 3'!G1","v":"Table 4 - NHH Demand Tariff Changes & Figure 3 - NHH Demand Tariff Changes"}]
[{"$f":"'T5'!A1","v":"Table 5 - Generation Wider Tariffs"}]
[{"$f":"'T6 & Fig 4'!A1&\" \"&\"&\"&\" \"&'T6 & Fig 4'!K1","v":"Table 6 - Generation Tariff Changes & Figure 4 - Variation in Generation Zonal Tariffs"}]
[{"$f":"'T7'!A1:E1","v":"Table 7 - Local Substation Tariffs"}]
[{"$f":"'T8'!A1:F1","v":"Table 8 - Local Circuit Tariffs"}]
[{"$f":"'T9'!A1:E1","v":"Table 9 - CMP203: Circuits subject to one-off charges"}]
[{"$f":"'T10'!A1:D1","v":"Table 10 - Offshore Local Tariffs"}]
[{"$f":"'T11'!A1:E1","v":"Table 11 - Contracted and Modelled TEC"}]
[{"$f":"'T12'!A1","v":"Table 12 - Interconnectors"}]
[{"$f":"'T13'!A1","v":"Table 13 - Allowed Revenues"}]
[{"$f":"'T14'!A1:F1","v":"Table 14 - Generation and Demand Revenue Proportions"}]
[{"$f":"'T15'!A1","v":"Table 15 - Charging Bases"}]
[{"$f":"'T16'!A1:F1","v":"Table 16 - Residual Calculation"}]
[{"$f":"'T17'!A1","v":"Table 17 - Small Generator Discount"}]
[{"$f":"'T18'!A1","v":"Table 18 - Summary of CUSC Modifications affecting 2018/19 TNUoS Tariffs"}]
[{"$f":"'T19 & Fig 5'!A1&\" & \"&'T19 & Fig 5'!H1","v":"Table 19 - The impact of CMP282 on HH Demand Tariffs & Figure 5 - The impact of CMP282 on HH Demand Tariffs"}]
[{"$f":"'T20 & Fig 6'!A1&\" & \"&'T20 & Fig 6'!G1","v":"Table 20 - The impact of CMP282 on NHH Demand Tariffs & Figure 6 - The impact of CMP282 on NHH Demand Tariffs"}]
["Table 21 - The impact of CMP282 on Embedded Export Tariffs & Figure 7 - The impact of CMP282 on Embedded Export Tariffs"]
["Table 22 - Demand Profiles"]
["Table 23 & Table 24 - Annual Load Factors and Generic Annual Load Factors"]
["Table 25 - Generation TEC Changes"]
["Table 26 - Indicative National Grid Revenue Forecast"]
["Table 27 - Offshore Revenues"]

{"sheet":"Residuals","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Residual","2018/19 June","2018/19\nOctober","Change"]
["Generation",-3.2820828327400391,-2.337478141048372,{"$f":"C2-B2","v":0.94460469169166705}]
["Demand",52.204555113829372,46.655916801415302,{"$f":"C3-B3","v":-5.5486383124140701}]
[]
["Average Tariff","2018/19 June","2018/19\nOctober","Change"]
["Generation (£/kW)",6.1734724880435934,5.7365117883695484,{"$f":"C6-B6","v":-0.43696069967404494},"N.B. These generation average tariffs include local tariffs"]
["Net HH Demand (£/kW)",52.774282356096322,"-","-"]
["Gross HH Demand (£/kW)","-",46.200318814420704,"-"]
["NHH Demand (p/kWh)",6.999888592239202,6.231475348214536,{"$f":"C9-B9","v":-0.76841324402466604}]
["Embedded Export (£/kW)","-",29.15069181832348,"n/a"]

{"sheet":"T1","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Demand Tariffs"]
[]
["Zone","Zone Name","Gross HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)","Embedded Export Tariff (£/kWh)"]
[1,"Northern Scotland",42.625827985698301,5.6859636320180336,27.958110205356878]
[2,"Southern Scotland",25.070186751578298,3.3791833474038087,10.402468971236868]
[3,"Northern",36.695152402174379,4.8508150506181682,22.027434621832953]
[4,"North West",43.772059876019924,5.8773948867203689,29.104342095678497]
[5,"Yorkshire",43.584368805139277,5.7210520430925333,28.916651024797851]
[6,"N Wales & Mersey",45.186144984497773,5.8864329507162338,30.518427204156346]
[7,"East Midlands",47.14251956447923,6.2971425799082423,32.474801784137803]
[8,"Midlands",48.600885243197737,6.7054421475771555,33.933167462856311]
[9,"Eastern",49.119669370429719,7.1129240566440437,34.451951590088299]
[10,"South Wales",46.53302992527594,5.6408748725579176,31.865312144934514]
[11,"South East",52.267997821592694,7.7365640971009197,37.600280041251267]
[12,"London",54.590747102128311,6.0710882307944098,39.923029321786885]
[13,"Southern",53.551076366662976,7.335474902007121,38.883358586321549]
[14,"South Western",53.611446414975269,7.8145111760658752,38.943728634633842]
[]
["Tariffs include small gen tariff of:",null,0.59180097892612671,7.9965034203212673E-2]
["Residual charge for gross demand:",null,46.655916801415302]

{"sheet":"T2 & Fig 1","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 2 - Gross HH Demand Tariffs",null,null,null,null,null,null,"Figure 1 - Gross HH Demand Tariffs"]
[]
["Zone","Peak Security Tariff\n(£/kW)","Year Round Security Tariff (£/kW)","Residual (£/kW)","Small Gen Discount (£/kW)","Final Tariff (£/kW)"]
[1,3.8651521192787863E-2,-4.6605413158359097,46.655916801415302,0.59180097892612671,42.625827985698301]
[2,-1.8806091380220706,-20.296921890741061,46.655916801415302,0.59180097892612671,25.070186751578298]
[3,-3.4430312161771721,-7.1095341619898758,46.655916801415302,0.59180097892612671,36.695152402174379]
[4,-1.161861449524149,-2.3137964547973544,46.655916801415302,0.59180097892612671,43.772059876019924]
[5,-2.933824451940414,-0.72952452326173634,46.655916801415302,0.59180097892612671,43.584368805139277]
[6,-1.6579429227826525,-0.40362987306100284,46.655916801415302,0.59180097892612671,45.186144984497773]
[7,-2.0838482958922415,1.9786500800300471,46.655916801415302,0.59180097892612671,47.14251956447923]
[8,-1.1793265340397221,2.5324939968960338,46.655916801415302,0.59180097892612671,48.600885243197737]
[9,1.2679874348188853,0.60396415526941127,46.655916801415302,0.59180097892612671,49.119669370429719]
[10,-5.3542723415210451,4.6395844864555604,46.655916801415302,0.59180097892612671,46.53302992527594]
[11,3.9876433613366893,1.0326366799145821,46.655916801415302,0.59180097892612671,52.267997821592694]
[12,5.3859670002019744,1.9570623215849103,46.655916801415302,0.59180097892612671,54.590747102128311]
[13,2.1628471024719129,4.1405114838496351,46.655916801415302,0.59180097892612671,53.551076366662976]
[14,0.29607652341011859,6.0676521112237269,46.655916801415302,0.59180097892612671,53.611446414975269]

{"sheet":"T3 & Fig 2","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 3 - Embedded Export Tariff",null,null,null,null,null,null,"Figure 2 - Embedded Export Tariff"]
[]
["Zone","EET Locational Tariff £/kW","AGIC (£/kW)","2018/19 Phased Residual (£/kW )","Final Tariff (£/kW)","EET Revenue (£m)"]
[1,-4.6218897946431214,3.22,29.36,27.958110205356878,27.981655459567417]
[2,-22.177531028763131,3.22,29.36,10.402468971236868,6.9647198683660569]
[3,-10.552565378167047,3.22,29.36,22.027434621832953,12.791949531961297]
[4,-3.4756579043215035,3.22,29.36,29.104342095678497,9.9948263057163373]
[5,-3.6633489752021502,3.22,29.36,28.916651024797851,18.370652194721043]
[6,-2.0615727958436554,3.22,29.36,30.518427204156346,16.416973562488561]
[7,-0.10519821586219447,3.22,29.36,32.474801784137803,15.480160640950645]
[8,1.3531674628563117,3.22,29.36,33.933167462856311,7.1753196806926507]
[9,1.8719515900882966,3.22,29.36,34.451951590088299,21.505184674070279]
[10,-0.71468785506548471,3.22,29.36,31.865312144934514,10.558256153263924]
[11,5.0202800412512714,3.22,29.36,37.600280041251267,11.969242353339929]
[12,7.3430293217868847,3.22,29.36,39.923029321786885,5.9513878889155816]
[13,6.303358586321548,3.22,29.36,38.883358586321549,16.978717608613749]
[14,6.363728634633846,3.22,29.36,38.943728634633842,7.801107481441635]

{"sheet":"T4 & Fig 3","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 4 - NHH Demand Tariff Changes",null,null,null,null,null,"Figure 3 - NHH Demand Tariff Changes"]
[]
["Zone","Zone Name","2018/19\nJune Forecast\n(p/kWh)","2018/19 October Forecast (p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",10.184611148907443,5.6859636320180336,-4.4986475168894096,null,0]
[2,"Southern Scotland",4.7115280032563112,3.3791833474038087,-1.3323446558525025]
[3,"Northern",6.1430917841406076,4.8508150506181682,-1.2922767335224394]
[4,"North West",6.5128360335088136,5.8773948867203689,-0.63544114678844466]
[5,"Yorkshire",6.7761592424547636,5.7210520430925333,-1.0551071993622303]
[6,"N Wales & Mersey",7.0818669309870881,5.8864329507162338,-1.1954339802708542]
[7,"East Midlands",7.0090193176783204,6.2971425799082423,-0.71187673777007809]
[8,"Midlands",7.1152737799154053,6.7054421475771555,-0.40983163233824982]
[9,"Eastern",7.7825343714660393,7.1129240566440437,-0.66961031482199562]
[10,"South Wales",6.5198208160339721,5.6408748725579176,-0.87894594347605448]
[11,"South East",8.1844878255241351,7.7365640971009197,-0.44792372842321537]
[12,"London",6.0919925045595669,6.0710882307944098,-2.0904273765157022E-2]
[13,"Southern",7.7726237390293313,7.335474902007121,-0.4371488370222103]
[14,"South Western",8.2333899842374745,7.8145111760658752,-0.41887880817159928]

{"sheet":"T5","index":6,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,6,32,7],[32,2,32,4],[1,6,1,8]]}
["Table 5 - Generation Wider Tariffs"]
[null,null,null,null,null,null,"Example Tariffs:"]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",2.2415339953151832,19.71358542747857,15.377880722182308,-2.337478141048372,27.977228773995513,31.052804918431974,20.925836752125363]
[2,"East Aberdeenshire",4.4936252171854116,10.286068211613909,15.377880722182308,-2.337478141048372,22.687306223174012,25.762882367610477,17.154829865779501]
[3,"Western Highlands",1.7189802583571754,18.661794548017845,15.377880722182308,-2.337478141048372,26.613242333468921,29.688818477905386,20.505120400341074]
[4,"Skye and Lochalsh",1.7341847625158362,18.661794548017845,21.196840090908623,-2.337478141048372,31.283614332608643,35.522982350790365,26.324079769067389]
[5,"Eastern Grampian and Tayside",2.7332535541544276,15.780106484329155,14.954895644509515,-2.337478141048372,24.983777116176991,27.974756245078893,18.929460097192806]
[6,"Central Grampian",3.4715450671147945,14.914730578406507,14.666316168422309,-2.337478141048372,24.798904323529477,27.732167557213938,18.294730258736539]
[7,"Argyll",3.139357297607885,11.744597312144457,24.331456436673161,-2.337478141048372,29.662722155613608,34.529013442948241,26.691817220482573]
[8,"The Trossachs",3.4853943087329622,11.744597312144457,13.541154476912318,-2.337478141048372,21.376517598930015,24.084748494312475,15.90151526072173]
[9,"Stirlingshire and Fife",2.0707366682353578,8.8121348383158882,12.887016793101882,-2.337478141048372,17.092579832321203,19.669983190941579,14.074392587379865]
[10,"South West Scotlands",2.3935566968514279,9.5038153807593364,13.011888865149187,-2.337478141048372,18.068641952529873,20.671019725559713,14.47593687640455]
[11,"Lothian and Borders",3.4589651303760522,9.5038153807593364,7.4419557338727822,-2.337478141048372,14.678103881033376,16.166495027807933,8.906003745128146]
[12,"Solway and Cheviot",1.8727227716776655,5.515458293856125,7.4198309892952166,-2.337478141048372,9.8834760571503679,11.36744225500941,7.288536165789294]
[13,"North East England",3.655605505420187,3.2734780353496369,4.0263356007119482,-2.337478141048372,7.157978273221083,7.9632453933634721,2.9982486738034311]
[14,"North Lancashire and The Lakes",1.4567180618669053,3.2734780353496369,2.5708178976848099,-2.337478141048372,3.7946766672460903,4.3088402467830527,1.5427309707762928]
[15,"South Lancashire, Yorkshire and Humber",4.2558050393641906,1.224412206727773,0,-2.337478141048372,2.897856663698037,2.897856663698037,-1.8477132583572629]
[16,"North Midlands and North Wales",3.3435712813291816,-0.25067717620323471,0,-2.337478141048372,0.80555139931822195,0.80555139931822195,-2.4377490115296658]
[17,"South Lincolnshire and North Norfolk",2.090056968459101,-0.18780066444961874,0,-2.337478141048372,-0.39766170414896607,-0.39766170414896607,-2.4125984068282196]
[18,"Mid Wales and The Midlands",1.2132138543397424,0.10992558356909411,0,-2.337478141048372,-1.0363238198533544,-1.0363238198533544,-2.2935079076207345]
[19,"Anglesey and Snowdon",3.5828515678566144,0.17775631106439921,0,-2.337478141048372,1.3875784756597618,1.3875784756597618,-2.2663756166226126]
[20,"Pembrokeshire",8.3014505461281836,-4.5828542732885618,0,-2.337478141048372,2.2976889864489625,2.2976889864489625,-4.1706198503637966]
[21,"South Wales & Gloucester",5.2887304861809916,-4.667698178828724,0,-2.337478141048372,-0.78290619793035976,-0.78290619793035976,-4.2045574125798613]
[22,"Cotswold",2.1644268913464511,2.3320482663554185,-7.0677496437873621,-2.337478141048372,-3.9616123516474766,-5.3751622804049486,-8.4724084782935662]
[23,"Central London",-5.5747446185481007,2.3320482663554185,-6.2617145993497934,-2.337478141048372,-11.055955825991973,-12.308298745861931,-7.6663734338559983]
[24,"Essex and Kent",-3.9545492767881241,2.3320482663554185,0,-2.337478141048372,-4.4263888047521611,-4.4263888047521611,-1.4046588345062045]
[25,"Oxfordshire, Surrey and Sussex",-1.4083902583204171,-2.526833731678118,0,-2.337478141048372,-5.7673353847112834,-5.7673353847112834,-3.3482116337196191]
[26,"Somerset and Wessex",-2.1575553706949142,-4.571951000093553,0,-2.337478141048372,-8.1525943118181292,-8.1525943118181292,-4.1662585410857931]
[27,"West Devon and Cornwall",-1.5642456473612103,-6.853368892278545,0,-2.337478141048372,-9.3844189022324187,-9.3844189022324187,-5.0788256979597897]
[]
[null,null,"Small Generation Discount (£/kW)",null,null,11.079610000000001]

{"sheet":"T6 & Fig 4","index":7,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,8],[4,2,4,4],[4,5,4,7],[4,8,5,8],[0,0,0,7]]}
["Table 6 - Generation Tariff Changes",null,null,null,null,null,null,null,null,null,"Figure 4 - Variation in Generation Zonal Tariffs"]
[]
[]
["Generation Wider Tariffs (£/kW)"]
[null,null,"Conventional 80%",null,null,"Intermittent 40%",null,null,"Change in Residual (£/kW)"]
["Zone","Zone Name","2018/19\nJune forecast (£/kW)","2018/19 October forecast (£/kW)","Change (£/kW)","2018/19 \nJune forecast (£/kW)","2018/19 October forecast (£/kW)","Change (£/kW)"]
[1,"North Scotland",26.594951091740178,31.052804918431974,4.457853826691796,23.575005611983961,20.925836752125363,-2.6491688598585981,0.94460469169166705]
[2,"East Aberdeenshire",20.218644189554311,25.762882367610477,5.5442381780561654,17.394826714600654,17.154829865779501,-0.23999684882115346,0.94460469169166705]
[3,"Western Highlands",26.324497007207743,29.688818477905386,3.364321470697643,22.731588751153286,20.505120400341074,-2.2264683508122118,0.94460469169166705]
[4,"Skye and Lochalsh",31.929103197001631,35.522982350790365,3.593879153788734,28.336285347208115,26.324079769067389,-2.0122055781407262,0.94460469169166705]
[5,"Eastern Grampian and Tayside",24.929824268032466,27.974756245078893,3.0449319770464278,20.377783723239858,18.929460097192806,-1.4483236260470527,0.94460469169166705]
[6,"Central Grampian",25.37563308749408,27.732167557213938,2.3565344697198576,20.510009933704939,18.294730258736539,-2.2152796749684001,0.94460469169166705]
[7,"Argyll",31.989107904412542,34.529013442948241,2.5399055385356988,28.153335944974476,26.691817220482573,-1.4615187244919028,0.94460469169166705]
[8,"The Trossachs",21.839694147001683,24.084748494312475,2.2450543473107913,17.48424256468094,15.90151526072173,-1.58272730395921,0.94460469169166705]
[9,"Stirlingshire and Fife",15.987663756172767,19.669983190941579,3.6823194347688126,14.065884123378483,14.074392587379865,8.5084640013821655E-3,0.94460469169166705]
[10,"South West Scotlands",19.296497260537066,20.671019725559713,1.3745224650226469,15.239805308303817,14.47593687640455,-0.76386843189926701,0.94460469169166705]
[11,"Lothian and Borders",14.889637853123793,16.166495027807933,1.2768571746841406,10.025159810642551,8.906003745128146,-1.1191560655144048,0.94460469169166705]
[12,"Solway and Cheviot",9.6678254889966642,11.36744225500941,1.6996167660127455,7.0890055019264668,7.288536165789294,0.19953066386282714,0.94460469169166705]
[13,"North East England",6.5559798382395069,7.9632453933634721,1.4072655551239652,2.3971680443560088,2.9982486738034311,0.60108062944742224,0.94460469169166705]
[14,"North Lancashire and The Lakes",2.7783852372946503,4.3088402467830527,1.5304550094884024,0.85111694652873693,1.5427309707762928,0.69161402424755591,0.94460469169166705]
[15,"South Lancashire, Yorkshire and Humber",1.771292768939476,2.897856663698037,1.126563894758561,-2.756495826451324,-1.8477132583572629,0.90878256809406111,0.94460469169166705]
[16,"North Midlands and North Wales",0.10456207546290619,0.80555139931822195,0.70098932385531576,-3.489930802054495,-2.4377490115296658,1.0521817905248292,0.94460469169166705]
[17,"South Lincolnshire and North Norfolk",-0.97052709643870161,-0.39766170414896607,0.57286539228973554,-3.2296201989897386,-2.4125984068282196,0.81702179216151904,0.94460469169166705]
[18,"Mid Wales and The Midlands",-1.6825320943694355,-1.0363238198533544,0.64620827451608109,-3.0869367223683288,-2.2935079076207345,0.7934288147475943,0.94460469169166705]
[19,"Anglesey and Snowdon",4.2694982573745044E-2,1.3875784756597618,1.3448834930860167,-3.5861463824081863,-2.2663756166226126,1.3197707657855737,0.94460469169166705]
[20,"Pembrokeshire",2.6325269046289388,2.2976889864489625,-0.33483791817997632,-4.8562399604999582,-4.1706198503637966,0.68562011013616164,0.94460469169166705]
[21,"South Wales & Gloucester",-0.53670834495992459,-0.78290619793035976,-0.24619785297043517,-4.9076635394502128,-4.2045574125798613,0.70310612687035157,0.94460469169166705]
[22,"Cotswold",-5.16813143752176,-5.3751622804049486,-0.20703084288318863,-9.0984434439047845,-8.4724084782935662,0.6260349656112183,0.94460469169166705]
[23,"Central London",-11.664579278168031,-12.308298745861931,-0.64371946769390043,-7.9325767682678663,-7.6663734338559983,0.26620333441186794,0.94460469169166705]
[24,"Essex and Kent",-4.7815085494134646,-4.4263888047521611,0.35511974466130347,-2.1827925300108957,-1.4046588345062045,0.77813369550469114,0.94460469169166705]
[25,"Oxfordshire, Surrey and Sussex",-6.0719101066629211,-5.7673353847112834,0.30457472195163771,-4.1563572173005321,-3.3482116337196191,0.80814558358091304,0.94460469169166705]
[26,"Somerset and Wessex",-8.2162871874537036,-8.1525943118181292,6.3692875635574353E-2,-4.9217801521374795,-4.1662585410857931,0.75552161105168647,0.94460469169166705]
[27,"West Devon and Cornwall",-9.4111511427172161,-9.3844189022324187,2.6732240484797387E-2,-5.8341946849750634,-5.0788256979597897,0.75536898701527377,0.94460469169166705]

{"sheet":"T7","index":8,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,2,4],[0,0,0,4]]}
["Table 7 - Local Substation Tariffs"]
[]
["Substation Rating","Connection Type","Local Substation Tariff (£/kW)"]
[null,null,"132kV","275kV","400kV"]
["<1320 MW","No redundancy",0.191605,0.10961,7.8976000000000005E-2]
["<1320 MW","Redundancy",0.42209000000000002,0.26114999999999999,0.18992999999999999]
[">=1320 MW","No redundancy",0,0.34367700000000001,0.24854799999999999]
[">=1320 MW","Redundancy",0,0.56423000000000001,0.41184100000000001]

{"sheet":"T8","index":9,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 8 - Local Circuit Tariffs"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",4.0969952379809111,"Dinorwig",2.2897107188671626,"Kilmorack",0.1884736579380393,"Kype Muir",1.4155149788040073]
["Aigas",0.62415833006805932,"Dunlaw Extension",1.4331231014158263,"Langage",0.62747706506516709,"Middle Muir",1.8916639979682306]
["An Suidhe",-0.91135375987932044,"Dunhill",1.3669081373271068,"Lochay",0.34923027654798111,"Dorenell",2.0027958056073105]
["Arecleoch",1.9820909322240641,"Dumnaglass",1.7718045551748178,"Luichart",0.54869715335588232,"Millennium South",0.89926833947549212]
["Baglan Bay",0.7256362358775893,"Edinbane",6.5338263716148655,"Mark Hill",0.8355808800158957,"Aberdeen Bay",2.4882657204043626]
["Beinneun Wind Farm",1.4330974124678739,"Earlshaugh Wind Farm",3.5979358398452908,"Margree",5.7456492929581602,"Killingholme",0.67706949508846637]
["Bhlaraidh Wind Farm",0.62797987382531206,"Ewe Hill",1.3114329950684189,"Marchwood",0.36436050735266584,"Middleton",0.10750513090764864]
["Black Hill",0.82337160897195782,"Fallago",0.19127346755899557,"Millennium Wind ",1.7426615372151275]
["BlackCraig Wind Farm",6.0075720003691471,"Farr",3.4025846718604629,"Moffat",0.16403971641165507]
["Black Law",1.6675745705166094,"Fernoch",4.1983721183034781,"Mossford",2.7491930015559269]
["BlackLaw Extension",3.5363077291781058,"Ffestiniogg",0.24144439257206371,"Nant",2.3955709678733839]
["Bodelwyddan",0.10980475597535429,"Finlarig",0.30557649197948372,"Necton",-0.35693642805053594]
["Carrington",-3.0889171975966155E-2,"Foyers",0.71859955681372834,"Rhigos",9.6777595931114332E-2]
["Clyde (North)",0.10465861527471804,"Galawhistle",1.4114723677147578,"Rocksavage",1.6887418043244742E-2]
["Clyde (South)",0.12103262443866684,"Glendoe",1.7554148016344049,"Saltend",0.32540293285364591]
["Corriegarth",3.0086617846155841,"Glenglass",9.2674125723205449,"South Humber Bank",0.90305822969417848]
["Corriemoillie",1.589153192135869,"Gordonbush",0.57881959760364654,"Spalding",0.26634623963538845]
["Coryton",4.958267181579034E-2,"Griffin Wind",4.0798051172371261,"Strathbrora",0.42746931111181768]
["Cruachan",1.8059735929304308,"Hadyard Hill",2.6414890862557732,"Stronelairg",1.4035444840981941]
["Crystal Rig",3.1390314389878167E-2,"Harestanes",2.3947481078618846,"Strathy Wind",2.0587127798533409]
["Culligran",1.6540342154877261,"Hartlepool",0.57369686921175111,"Wester Dod",0.3561261036449167]
["Deanie",2.717341925444122,"Hedon",0.17268433097075456,"Whitelee",0.10128253091101787]
["Dersalloch",2.2988043407102778,"Invergarry",1.3546811206366125,"Whitelee Extension",0.28156543593262978]
["Didcot",0.49730458601764344,"Kilgallioch",1.0043850982009257,"Gills Bay",2.4033549667287732]

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

{"sheet":"T10","index":11,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3],[0,0,0,3]]}
["Table 10 - Offshore Local Tariffs"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",7.721088,40.396726999999998,1.0031060000000001]
["Greater Gabbard",14.476132939224387,33.264728070229594,0]
["Gunfleet",16.710104999999999,15.341184999999999,2.867356]
["Gwynt Y Mor",17.629613097744357,17.36734669172932,0]
["Lincs",14.429434427937485,56.494533704032406,0]
["London Array",9.8224946938066733,33.454870095311591,0]
["Ormonde",23.869458999999999,44.466566,0.35436099999999998]
["Robin Rigg East",-0.44155299999999997,29.249093999999999,9.0656409999999994]
["Robin Rigg West",-0.44155299999999997,29.249093999999999,9.0656409999999994]
["Sheringham Shoal",23.062033817866098,27.046363347868027,0.58790844491607164]
["Thanet",17.562576788990821,32.725358091743118,0.78781493577981654]
["Walney 1",20.600473999999998,41.025790999999998,0]
["Walney 2",20.450652999999999,41.387231,0]
["West of Duddon Sands",7.9491605093575144,39.224180936137365,0]
["Westermost Rough",16.738260534825386,28.31397403202778,0]
["Humber Gateway",14.029141709048812,31.654419427358672,0]

{"sheet":"T11","index":12,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 11 - Contracted and Modelled TEC"]
[]
["(GW)","2017/18 Final","2018/19 Initial Forecast","2018/19 June Forecast","2018/19 Oct Forecast"]
["Contracted TEC",72.193460000000016,79.569059999999993,78.825610000000012,82.445610000000002]
["Modelled Best View TEC",72.193460000000016,72.619659999999996,75.456410000000005,79.683410000000023]

{"sheet":"T12","index":13,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Table 12 - Interconnectors"]
[]
["Interconnector","Site","Interconnected\nSystem","Generation\nZone","Transport Model (Generation MW) Peak","Transport Model (Generation MW) Year Round","Charging Base (Generation MW)"]
["IFA Interconnector","Sellindge 400kV","France",24,0,2000,0]
["ElecLink","Sellindge 400kV","France",24,0,1000,0]
["BritNed","Grain 400kV","Netherlands",24,0,1200,0]
["East - West","Deesside 400kV","Republic of Ireland",16,0,505,0]
["Moyle","Auchencrosh 275kV","Northern Ireland",10,0,80,0]

{"sheet":"T13","index":14,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table 13 - Allowed Revenues"]
[]
["£m Nominal Value","2017/18 TNUoS Revenue","2018/19 TNUoS Revenue"]
[null,"Jan\n2017\nFinal","Feb 2017 Initial View","June\n2017\nUpdate","Oct\n2017\nUpdate","Dec\n2017\nDraft","Jan \n2018 Final"]
["National Grid"]
["Price controlled revenue",1748.7570980414505,1727.770785133421,1719.0487703426393,1647.1306037484155]
["Less income from connections",41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999]
["Income from TNUoS",{"$f":"+B6-B7","v":1706.8744856414505},1685.888172733421,1677.1661579426393,1605.2479913484156,0,0]
[]
["Scottish Power Transmission"]
["Price controlled revenue",{"$f":"+B12+B13","v":333.74000036000007},390.54065630478544,377.73246643716254,360.46666610469617,{"$f":"+F12+F13","v":0},{"$f":"+G12+G13","v":0}]
["Less income from connections",12.774800000000001,26.779541984732823,13.971352117109999,14.200000000000001]
["Income from TNUoS",320.96520036000004,363.76111432005263,363.76111432005257,346.26666610469618]
[]
["SHE Transmission"]
["Price controlled revenue",{"$f":"+B17+B18","v":304.72326290000001},366.48655954513987,366.73460571949607,358.58543433685088,{"$f":"+F17+F18","v":0},{"$f":"+G17+G18","v":0}]
["Less income from connections",3.355,3.2440075136088322,3.5890421108737836,3.4635076286130482]
["Income from TNUoS",301.36826289999999,363.24255203153103,363.1455636086223,355.12192670823782]
[]
["Offshore",270.20460754023691,380.16603753882629,373.18406027717322,312.14587309437724]
["Network Innovation Competition",32.071100479999998,40.5,40.5,40.5]
["Transmission EDR",null,null,2,2]
["Total to Collect from TNUoS",{"$f":"+B22+B21+B20+B18+B13+B8","v":2631.4836569216873},2833.5578766238309,{"$f":"+D22+D21+D20+D18+D13+D8","v":2819.7568961484876},{"$f":"+E22+E21+E20+E18+E13+E8","v":2661.2824572557265},0,0]

{"sheet":"T14","index":15,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 14 - Generation and Demand Revenue Proportions"]
[]
[null,null,"2017/18 Final","2018/19\nInitial","2018/19\nJune","2018/19\nOct"]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5,2.5]
["y","Error Margin",0.21,0.21,0.21,0.21]
["ER","Exchange Rate (€/£)",1.27,1.1100000000000001,1.1599999999999999,1.1599999999999999]
["MAR","Total Revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265]
["GO","Generation Output (TWh)",250.95,239.90199022627161,252.62423194547756,252.62423194547756]
["G","% of revenue from generation",0.14830298821627588,0.15064709097467605,{"$f":"E4*(1-E5)*E8/E6/E7","v":0.15253603366506521},0.16161927181593977]
["D","% of revenue from demand",0.85169701178372414,0.84935290902532401,{"$f":"1-E9","v":0.84746396633493482},0.83838072818406029]
["G.R","Revenue recovered from generation (£m)",{"$f":"C7*C9","v":390.25688976377955},{"$f":"D7*D9","v":426.85264026746518},{"$f":"E7*E9","v":430.11453283820538},430.11453283820538]
["D.R","Revenue recovered from demand (£m)",{"$f":"C7*C10","v":2241.2267671579079},{"$f":"D7*D10","v":2406.6082483946307},{"$f":"E7*E10","v":2389.6423633102813},2231.1679244175211]

{"sheet":"T15","index":16,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,11,3],[5,0,5,6],[8,0,8,6]]}
["Table 15 - Charging Bases"]
[]
["Charging Bases","2017/18","2018/19 Initial","2018/19 June","2018/19 October","2018/19 Draft","2018/19 Final"]
["Generation (GW)",67.579759999999993,66.834660000000014,69.671409999999995,74.978409999999997]
["NHH Demand (4pm-7pm TWh)",25.313203316155612,23.7,24.196416902536797,24.172250676783577]
["Net Charging"]
["Total Average Triad (GW)",47.684350893042456,46.43,46.004028260728987,45.947271541834986]
["HH  Demand Average Triad (GW)",13.227054908495282,14.25,13.186728568343657,13.285364566873497]
["Gross Charging"]
["Total Average Triad (GW)","Introduced by CMP264/265",null,null,52.463074137117367]
["HH  Demand Average Triad (GW)",null,null,null,19.801167162155881]
["Embedded Generation Export (GW)",null,null,null,6.515802595282385]

{"sheet":"T16","index":17,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[14,5,16,5],[18,2,21,4]]}
["Table 16 - Residual Calculation"]
[]
[null,"Component","2017/18","2018/19 Initial","2018/19 June","2018/19 October"]
["G","Proportion of revenue recovered from generation (%)",0.14830298821627588,0.15064709097467607,0.15253603366506521,0.16161927181593977]
["D","Proportion of revenue recovered from demand (%)",0.85169701178372414,0.8493529090253239,0.84746396633493482,0.83838072818406029]
["R","Total TNUoS revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265]
["Generation Residual"]
["RG","Generator residual tariff (£/kW)",-1.8538830625793754,{"$f":"((D6*D4)-D9-D10-D11-D12)/D13","v":-3.2036006033283266},{"$f":"((E6*E4)-E9-E10-E11-E12)/E13","v":-3.2820828327400378},-2.3374781410483694]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",274.96728874315193,313.20792838474574,334.03183243068628,322.20269611755737]
["O","Revenue recovered from offshore local tariffs (£m)",208.46816305662131,293.90104300000002,288.423609,244.00475299999999]
["LG","Revenue recovered from onshore local substation tariffs (£m)",17.50045021,16.977773468180001,17.786043930629997,20.689817210000001]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",14.605960191185485,16.877452513783155,18.540386170681664,18.47766093621048]
["BG","Generator charging base (GW)",67.579759999999993,66.834660000000014,69.671409999999995,74.978409999999997]
["Net Demand Residual"]
["RD","Demand residual tariff (£/kW)",47.260756295627864,{"$f":"((D6*D5)-D16)/D17","v":52.242687115919537},{"$f":"((E6*E5)-E16)/E17","v":52.204555113829379},"no longer calculated"]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",-12.371719513376464,-19.019714397513546,-11.977465485109299]
["BD","Demand Net charging base (GW)",47.684350893042456,46.43,46.004028260728987]
["Gross Demand Residual"]
["RD","Demand residual tariff (£/kW)","Introduced by CMP264/265 \nto replace 'net residual'",null,null,{"$f":"(F5*F6-F20+F21)/F22","v":46.655916801415309}]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",null,null,null,-26.604744266200935]
["EE","Amount to be paid to Embedded Export Tariffs (£m)",null,null,null,189.94015340410911]
["BD","Demand Gross charging base (GW)",null,null,null,52.463074137117367]

{"sheet":"T17","index":18,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,2]]}
["Table 17 - Small Generator Discount"]
[]
["Small Generator Discount Calculation"]
["Generator Residual (£/kW)","G",-2.337478141048372]
["Demand Residual (£/kW)","D",46.655916801415302]
["Small Generator Discount (£/kW)","T = (G + D)/4",11.079610000000001]
["Forecast Small Generator Volume (kW)","V",2780910.0000000009]
["2017/18 SGD cost (£)","V x T",{"$f":"+C7*C6","v":30811398.245100014}]
["Prior year reconcilation (£)","R",-236300.38672000915]
["Total SGD Cost (£)","C = (V x T) + R",{"$f":"C8+C9","v":30575097.858380005}]
["Total Gross System Triad Demand (kW)","TD",52463074.137117364]
["Total HH Gross Triad Demand (kW)","HHD",19801167.162155882]
["Total NHH Consumption (kWh)","NHHD",24172250676.783577]
["Increase in HH Demand tariff (£/kW)","HHT = C/TD",{"$f":"+C10/C11","v":0.58279272347764077}]
["Total Cost to HH Customers (£)","HHC = HHT * HHD",{"$f":"+C14*C12","v":11539976.138468854}]
["Increase in NHH Demand tariff (p/kWh)","NHHT = (C - HHC)/NHHD",{"$f":"100*(+C10-(+C14*C12))/(C13)","v":7.8747825241584052E-2}]
["Total Cost to NHH Customers (£)","NHHC = NHHT * NHHD",{"$f":"(+C16*C13)/100","v":19035121.719911147}]

{"sheet":"T18","index":19,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,5,0],[3,1,5,1],[3,2,5,2],[6,0,8,0],[6,1,8,1],[6,2,8,2],[13,3,14,3],[15,0,17,0],[15,1,17,1],[15,2,17,2],[9,0,10,0],[9,1,10,1],[9,2,12,2],[9,3,12,3],[11,0,12,0],[11,1,12,1],[18,0,20,0],[18,1,20,1],[18,2,20,2],[13,0,14,0],[13,1,14,1],[13,2,14,2]]}
["Table 18 - Summary of CUSC Modifications affecting 2018/19 TNUoS Tariffs"]
[]
["Mod Number","Description","Modification approved?","Status in the October 2017 Tariffs"]
[251,"Removing the error margin in the cap on total TNUoS recovered by generation and introducing a new charging element to TNUoS to ensure compliance with European Commission Regulation 838/2010","No – The final modification report was submitted to Ofgem in October 2016.","Not implemented."]
[]
[null,null,null,"Discussed in section 6.5 below"]
[261,"Ensuring the TNUoS paid by Generators in GB in Charging Year 2015/16 is in compliance with the €2.5/MWh annual average limit set in EU Regulation 838/2010 Part B (3)","No – the final report was submitted to GEMA in June 2017","Not implemented."]
[]
[null,null,null,"Indicative recovery rates below"]
[264,"Embedded Generation Triad Avoidance Standstill","Yes - WACM4 was approved by Ofgem","Implemented in Forecast. See below for information about Judicial Review."]
[]
[265,"Gross charging of TNUoS for HH demand where embedded generation is in Capacity Market"]
[]
[268,"Recognition of sharing by Conventional Carbon plant of Not-Shared Year-Round circuits","Yes - the original proposal was approved","Implemented in Forecast"]
[]
[282,"The effect Negative Demand has on Zonal Locational Demand Tariffs","No – expected Ofgem decision November 2017","Not implemented."]
[]
[null,null,null,"Implemented as an example in section 6.4 below"]
[283,"Consequential Changes to enable the Interconnector Cap and Floor regime","No – The final report was published in October 2017.","Not implemented."]
[]
[null,null,null,"Discussed in section 6.6  below"]

{"sheet":"T19 & Fig 5","index":20,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
["Table 19 - The impact of CMP282 on HH Demand Tariffs",null,null,null,null,null,null,"Figure 5 - The impact of CMP282 on HH Demand Tariffs"]
[]
[null,null,"Gross HH Demand"]
["Zone","Zone Name","2018/19\nOctober Forecast\n(£/kW)","2018/19 October CMP282\n(£/kW)","Change (£/kW)"]
[1,"Northern Scotland",42.625827985698301,18.351266903436535,{"$f":"D5-C5","v":-24.274561082261766}]
[2,"Southern Scotland",25.070186751578298,25.131649897065973,{"$f":"D6-C6","v":6.1463145487675064E-2}]
[3,"Northern",36.695152402174379,36.924539581278196,{"$f":"D7-C7","v":0.22938717910381712}]
[4,"North West",43.772059876019924,43.86648851609926,9.4428640079335935E-2]
[5,"Yorkshire",43.584368805139277,43.831984255327384,0.24761545018810693]
[6,"N Wales & Mersey",45.186144984497773,45.43376043468588,0.24761545018810693]
[7,"East Midlands",47.14251956447923,47.390135014667337,{"$f":"D11-C11","v":0.24761545018810693}]
[8,"Midlands",48.600885243197737,48.848500693385844,{"$f":"D12-C12","v":0.24761545018810693}]
[9,"Eastern",49.119669370429719,49.367284820617826,0.24761545018810693]
[10,"South Wales",46.53302992527594,46.780645375464047,0.24761545018810693]
[11,"South East",52.267997821592694,52.515613271780801,0.24761545018810693]
[12,"London",54.590747102128311,54.838362552316418,0.24761545018810693]
[13,"Southern",53.551076366662976,53.798691816851083,0.24761545018810693]
[14,"South Western",53.611446414975269,53.859061865163376,{"$f":"D18-C18","v":0.24761545018810693}]

{"sheet":"T20 & Fig 6","index":21,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 20 - The impact of CMP282 on NHH Demand Tariffs",null,null,null,null,null,"Figure 6 - The impact of CMP282 on NHH Demand Tariffs"]
[]
["Zone","Zone Name","2018/19\nOctober Forecast\n(p/kWh)","2018/19 October CMP282 (p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",5.6859636320180336,2.4485170583084086,{"$f":"D4-C4","v":-3.237446573709625}]
[2,"Southern Scotland",3.3791833474038087,3.3874685071495554,{"$f":"D5-C5","v":8.2851597457467285E-3}]
[3,"Northern",4.8508150506181682,4.8811368871520777,{"$f":"D6-C6","v":3.0321836533909519E-2}]
[4,"North West",5.8773948867203689,5.8900757678050395,1.2680881084670581E-2]
[5,"Yorkshire",5.7210520430925333,5.7535545162822759,3.2502473189742531E-2]
[6,"N Wales & Mersey",5.8864329507162338,5.9186899782653075,3.2257027549073669E-2]
[7,"East Midlands",6.2971425799082423,6.3302184399937032,3.3075860085460818E-2]
[8,"Midlands",6.7054421475771555,6.7396048955202446,3.4162747943089045E-2]
[9,"Eastern",7.1129240566440437,7.1487782685507302,3.5854211906686473E-2]
[10,"South Wales",5.6408748725579176,5.6708928243299725,3.0017951772054907E-2]
[11,"South East",7.7365640971009197,7.7732097781211245,3.6645681020204712E-2]
[12,"London",6.0710882307944098,6.098639171224165,2.7550940429755144E-2]
[13,"Southern",7.335474902007121,7.3693925466501531,3.3917644643032041E-2]
[14,"South Western",7.8145111760658752,7.8505986630930629,3.608748702718767E-2]

{"sheet":"T21 & Fig 7","index":22,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 21 - The impact of CMP282 on Embedded Export Tariffs",null,null,null,null,"Figure 7 - The impact of CMP282 on Embedded Export Tariffs"]
[]
["Zone","October 2017 Final Tariff (£/kW)","October CMP282 Final Tariff (£/kW)","Difference"]
[1,27.958110205356878,3.4359336729070051,{"$f":"C4-B4","v":-24.522176532449873}]
[2,10.402468971236868,10.216316666536443,{"$f":"C5-B5","v":-0.18615230470042476}]
[3,22.027434621832953,22.009206350748663,-1.8228271084289815E-2]
[4,29.104342095678497,28.951155285569726,-0.153186810108771]
[5,28.916651024797851,28.916651024797851,0]
[6,30.518427204156346,30.518427204156346,0]
[7,32.474801784137803,32.474801784137803,0]
[8,33.933167462856311,33.933167462856311,0]
[9,34.451951590088299,34.451951590088299,0]
[10,31.865312144934514,31.865312144934514,0]
[11,37.600280041251267,37.600280041251267,0]
[12,39.923029321786885,39.923029321786885,0]
[13,38.883358586321549,38.883358586321549,0]
[14,38.943728634633842,38.943728634633842,0]

{"sheet":"T22","index":23,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,5],[2,6,2,10],[18,0,18,1]]}
["Table 22 - Demand Profiles"]
[]
[null,null,"2018/19 June",null,null,null,"2018/19 October"]
["Zone","Zone Name","Locational Model Demand (MW)","Tariff model Peak Demand (MW)","NET Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)"]
[1,"Northern Scotland",227,927.916882956481,-530.02496740858703,0.74276272859237802,227,1477.05451191266,489.05889990612468,0.74080350740442558,1000.8421618642174]
[2,"Southern Scotland",2820.3501231149562,2998.8151384038401,662.00811142768896,1.6852569669808399,2820.3501231149562,3500.4961069016904,1258.7854835184103,1.6632260196384325,669.52565661322433]
[3,"Northern",2508,2240.74228238862,525.80025580163795,1.2131444588354501,2508,2663.97949725749,1078.2985069717167,1.1999622256092375,580.7280671387075]
[4,"North West",3234,3684.8086880763803,1166.91099583603,1.9433727223278801,3234,4116.8568956563204,1522.5202795527034,1.9323067221059214,343.41357976273923]
[5,"Yorkshire",4347,3395.1576770059901,1006.6918504366899,1.75745498142884,4347,3919.7286234056701,1609.7345542740311,1.760521979873624,635.29667315094866]
[6,"N Wales & Mersey",2831,2280.7562867912998,593.76109850607497,1.2282518642483,2831,2677.5738987326799,1085.2983354390524,1.2228860168028479,537.93642289182958]
[7,"East Midlands",5333,4228.4752755132195,1375.9468189301699,2.1495860917236298,5333,4763.0073902219901,1878.0744115097325,2.1600750862099853,476.68222099855501]
[8,"Midlands",4594,3959.84252014103,1353.5430726606701,1.99928411371102,4594,4370.5052269223597,1616.9579396754075,1.9952568166336415,211.45446232058501]
[9,"Eastern",5843,5829.3239991273804,1428.6043823566499,3.0728860264920499,5843,6604.5136430028497,2132.6107427056013,3.0856416867034842,624.20802542452316]
[10,"South Wales",1969,1591.52032355397,526.25381624359602,0.83332723790098995,1969,1842.6417320212599,838.74346685036028,0.82936644145817029,331.34011382789242]
[11,"South East",3355,3579.4361953556199,837.95038508740902,1.9151525079209499,3355,3999.2986685067899,1168.9667994362562,1.9102578781343114,318.32854277171538]
[12,"London",5271,3917.8693003962599,2068.4357275764901,1.8204737173518399,5271,4322.8634936607696,2285.7297464800777,1.8361010423280268,149.07155068184611]
[13,"Southern",5668,5014.1964256641695,1617.34208324107,2.5605089297542998,5668,5583.9145494300201,2072.2063774299195,2.5632591444412274,436.65769177116687]
[14,"South Western",2609,2355.1672653547298,553.50493764806595,1.2749545552683299,2609,2620.63989948482,764.18161840648941,1.2725861094402413,200.31742606443373]
["Total",null,50609.350123114957,46004.028260728985,13186.728568343657,24.196416902536797,{"$f":"SUM(G5:G18)","v":50609.350123114957},{"$f":"SUM(H5:H18)","v":52463.074137117364},{"$f":"SUM(I5:I18)","v":19801.167162155882},{"$f":"SUM(J5:J18)","v":24.172250676783577},{"$f":"SUM(K5:K18)","v":6515.8025952823837}]

{"sheet":"T23 & T24","index":24,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Table 23 & Table 24 - Annual Load Factors and Generic Annual Load Factors"]
[]
["For the latest Annual Load Factors, please see:"]
["http://www2.nationalgrid.com/UK/Industry-information/System-charges/Electricity-transmission/Approval-conditions/Condition-5/"]

{"sheet":"T25","index":25,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 25 - Generation TEC Changes"]
[]
[]
["Power Station","Node","MW Change","Generation Zone"]
["Aikengall II Windfarm","WDOD10",140,11]
["Eggborough","EGGB40",1870,15]
["Galloper Wind Farm","LEIS10",-86,18]
["Loganhead Windfarm","EWEH1Q",36,12]
["Margree","MARG10",-43,10]
["Pencloe Windfarm","BLAC10",-63,10]
["Peterhead","PEHE20",1180,2]
["Powersite @ Drakelow","DRAK40",380,18]
["Race Bank Wind Farm","WALP40_EME",160,17]
["Spalding Energy Expansion","SPLN40",300,17]
["Sutton Bridge","WALP40_EME",31,17]
["Tees Renewable Energy Plant","GRSA20",-285,13]
["West Burton B","WBUR40",-38,16]
["West Burton Energy Storage","WBUR40",38,16]

{"sheet":"T26","index":26,"n_rows":55,"n_cols":9,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,3,2,5],[3,2,3,4],[3,5,3,7]]}
["Table 26 - Indicative National Grid Revenue Forecast"]
[]
[null,null,null,"2017-10-26",null,null,null,null," "]
["Description"," ","Licence\nTerm","Yr t-1","Yr t","Yr t+1",null,null,"Notes"]
["Regulatory Year"," "," ","2014/15","2015/16","2016/17","2017/18","2018/19"]
["Actual RPI"," "," ",null," ",264.99166666666673," ",null,"April to March average"]
["RPI Actual"," ","RPIAt",null," ",1.228," ",null,"Office of National Statistics"]
["Assumed Interest Rate"," ","It",5.0000000000000001E-3,7.000000000000001E-3,3.3602150537634405E-3,2.9166666666666668E-3,3.7499999999999999E-3,"Bank of England Base Rate"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1443.829,1475.5930000000001,1571.3869999999999,1554.942,1587.627,"From Licence"]
["Price Control Financial Model Iteration Adjustment","A2","MODt",-5.5,-114.4,-185.4,-253.3,-311,"Forecast"]
["RPI True Up","A3","TRUt",-0.52728791368496775,4.7019113011489599,-19.921431381693402,-31.397222077804624,-6.0845942150118297,"Forecast"]
["Prior Calendar Year RPI Forecast"," ","GRPIFc-1",3.1E-2,2.5000000000000001E-2,0.01,1.7999999999999999E-2,3.5000000000000003E-2,"HM Treasury Forecast"]
["Current Calendar Year RPI Forecast"," ","GRPIFc",3.1E-2,2.4E-2,2.1000000000000001E-2,3.5000000000000003E-2,3.5000000000000003E-2,"HM Treasury Forecast"]
["Next Calendar Year RPI forecast"," ","GRPIFc+1",0.03,3.2000000000000001E-2,0.03,3.1E-2,0.03,"HM Treasury Forecast"]
["RPI Forecast","A4","RPIFt",1.2051000000000001,1.2266528212575316,1.2330000000000001,1.2709999999999999,1.3140000000000001,"Using HM Treasury Forecast"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",1732.6948432352185,1675.4788464888604,1684.3588461063721,1614.4811127391104,1669.4927212014745]
["Pass-Through Business Rates","B1","RBt"," ",1.2353308097829103,1.5001179260431783,2.6894278826733395,1.563034475468172,"Forecast"]
["Temporary Physical Disconnection","B2","TPDt",0.14395339862662926,1.2337689401095423E-2,9.0478361183892381E-2,0,0,"Forecast"]
["Licence Fee","B3","LFt"," ",2.0207027597467815,2.6933961403912292,3.187695280052341,-0.37663957632732453,"Forecast"]
["Inter TSO Compensation","B4","ITCt"," ",3.8222435083326589,2.6745437559665044,0.49862315564851822,1.3447743785507609,"Forecast"]
["Termination of Bilateral Connection Agreements","B5","TERMt",0,0,0,0,0,"Forecast"]
["SP Transmission Pass-Through","B6","TSPt",312.179148,295.664557,294.62336299999998,320.96520036000004,346.26666610469618,"Forecast"]
["SHE Transmission Pass-Through","B7","TSHt",213.95951766583201,338.20730217321301,322.83631648970299,301.36826289999999,355.12192670823782,"Forecast"]
["Offshore Transmission Pass-Through","B8","TOFTOt",218.38037349491276,248.35699921993759,260.78931257200446,270.20460754023702,312.14587309437718,"Forecast"]
["Embedded Offshore Pass-Through","B9","OFETt",0.43733608355648018,0.64941914461921546,0.6544976173613446,0.51506514657980451,0.55065488197802193,"Forecast"]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9]","B","PTt",745.10032864292793,889.96889230503325,885.86202586265358,899.42888226519096,1016.6162900669809," "]
["Reliability Incentive Adjustment","C1","RIt"," ",2.3615637797660018,3.920644330261553,4.0380877505969011,4.1357968557807956,"Forecast"]
["Stakeholder Satisfaction Adjustment","C2","SSOt"," ",8.6930597323224994,10.123488255861568,8.6047337676510143,7.5689481553576456,"Forecast"]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt"," ",2.8092019735619482,2.6616746854357087,2.6133241702293648,1.4340660973457273,"Forecast"]
["Awarded Environmental Discretionary Rewards","C4","EDRt"," ",0,2.0215574999999997,0,0,"Forecast"]
["Outputs Incentive Revenue [C=C1+C2+C3+C4]","C","OIPt",0,13.863825485650448,18.727364771558829,15.256145688477281,13.13881110848417," "]
["Network Innovation Allowance","D","NIAt",10.915977512381877,10.555516732879822,10.611460730470144,10.171231010256395,10.51780414356929,"Forecast"]
["Network Innovation Competition","E","NICFt",17.849214,18.760655919999998,44.854879889999999,32.071100479999998,40.5,"Forecast"]
["Future Environmental Discretionary Rewards","F","EDRt"," "," ",0,0,2,"Forecast"]
["Transmission Investment for Renewable Generation","G","TIRGt",15.997326508799999,15.699016829576131,0,0,0,"Forecast"]
["Scottish Site Specific Adjustment","H","DISt",1.9849141507976036,0.79100000000000004,2.8649227140000022,6.0579279490409306,6.2920000000000016,"Forecast"]
["Scottish Terminations Adjustment","I","TSt",-0.28187454000000001,0.10154699999999994,7.2928609999999949E-2,-1.1215534200000001,-1.5000000000000013E-2,"Forecast"]
["Correction Factor","K","-Kt"," ",56.423778228050232,103.97796600318905,97.021422609611989,-55.377556864782285,"Calculated by Licensee"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",2524.2607295101257,2681.6430789900505,2751.3303946882438,2673.3662693216875,2703.1650696557267," "]
["Termination Charges","B5"," ",0,0,0,0,0," "]
["Pre-vesting connection charges","P"," ",46.954162359999998,44.955204119999998,42.677043259999913,41.882612399999999,41.882612399999999,"Forecast"]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",2477.3065671501258,2636.6878748700506,2708.6533514282437,2631.4836569216873,2661.2824572557265," "]
["Final Collected Revenue","U","TNRt",{"$f":"D42","v":2477.3065671501258},{"$f":"E42","v":2636.6878748700506},2708.6533514282437,2631.4836569216873,2661.2824572557265,"Forecast"]
["Forecast percentage change to Maximum Revenue M"," "," ",null,6.2347897600287805E-2,2.5986797513873006E-2,-2.8336882228712001E-2,1.1146546089099818E-2," "]
["Forecast percentage change to TNUoS Collected Revenue T"," "," ",null,6.4336529775269602E-2,2.7293892934422415E-2,-2.849005926353243E-2,1.132395417150267E-2," "]
[]
["Notes:"]
["All monies are  nominal 'money of the day' prices unless stated otherwise"]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments to all Transmission Owners are inlcuded in National Grid Maximum Revenue and are included here"]
["2014/15 and 2015/16 pass through to other networks is based on forecast at time of tariff setting"]
[]
[]
["\\\\uk.corporg.net\\NGTDFS$\\ETO_Charge Setting\\FY_2017_18\\1 December Forecast\\7 MAR\\[2016-12-18 Revenue Template Mary NG template.xlsx]"]

{"sheet":"T27","index":27,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,6,4,6],[14,1,17,1],[17,2,19,2],[18,3,19,3]]}
["Table 27 - Offshore Revenues"]
[]
["Offshore Transmission Revenue Forecast","2017-10-26",null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Notes"]
["Regulatory Year","2014/15","2015/16","2016/17","2017/18","2018/19"]
["Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.8724963671592052,5.9651953059247482,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.4642451364935463,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.600137956803552,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.4010328963439935,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,14.075987435509106,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.729116815732169,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.589809043396217,"Current revenues plus indexation"]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.491690671610868,"Current revenues plus indexation"]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,40.004783020642677,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.532744477726002,"Current revenues plus indexation"]
["Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,26.815609614232621,"Current revenues plus indexation"]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,28.150149535187346,"Current revenues plus indexation"]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.601756310460388,"Current revenues plus indexation"]
["Humber Gateway",0,null,29.284541507176115,9.7498990869565194,11.701470208094138,"Current revenues plus indexation"]
["Westermost Rough",0,null,null,11.576692607080746,12.990473107780094,"Current revenues plus indexation"]
["Forecast to asset transfer to OFTO in 2018/19",0,0,0,0,40.031671558439704,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2019/20",0,0,0,0,0,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2020/21",0,0,0,0,0,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2021/22",0,0,0,0,0,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",218.38037349491282,248.35699921993759,260.78931257200446,265.53230168097656,312.14587309437718," "]
[]
[]
["Notes:"]
[]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments are not included as they do not form part of OFTO Maximum Revenue"]