{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Index","T1","T2","T3 & Fig 1","T4 & Fig 2","T5 & Fig 3","T6","T7","T8 & Fig 4","T9","T10","T11","T12","T13","T14","T15","T16","T17","T18","T19","T20","T21","T22","T23 & T24","T25","T26","T27"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":4,"defined_names":677,"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":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Index"]
[]
["Table 1 - Summary of Demand Tariffs"]
[{"$f":"'T2'!A1","v":"Table 2 - Demand Tariffs"}]
[{"$f":"'T3 & Fig 1'!A1&\" \"&\"&\"&\" \"&'T3 & Fig 1'!G1","v":"Table 3 - Gross HH Demand Tariffs & Figure 1 - Gross HH Demand Tariffs"}]
[{"$f":"'T4 & Fig 2'!A1&\" \"&\"&\"&\" \"&'T4 & Fig 2'!H1","v":"Table 4 - Embedded Export Tariff & Figure 2 - Embedded Export Tariff"}]
[{"$f":"'T5 & Fig 3'!A1&\" \"&\"&\"&\" \"&'T5 & Fig 3'!G1","v":"Table 5 - NHH Demand Tariff Changes & Figure 3 - NHH Demand Tariff Changes"}]
["Table 6 - Changes to Average Tariffs"]
[{"$f":"'T7'!A1","v":"Table 7 - Generation Wider Tariffs"}]
[{"$f":"'T8 & Fig 4'!A1&\" \"&\"&\"&\" \"&'T8 & Fig 4'!N1","v":"Table 8 - Generation Tariff Changes & Figure 4 - Variation in Generation Zonal Tariffs"}]
[{"$f":"'T9'!A1:E1","v":"Table 9 - Local Substation Tariffs"}]
[{"$f":"'T10'!A1:F1","v":"Table 10 - Local Circuit Tariffs"}]
[{"$f":"'T11'!A1:E1","v":"Table 11 - CMP203: Circuits subject to one-off charges"}]
[{"$f":"'T12'!A1:D1","v":"Table 12 - Offshore Local Tariffs"}]
[{"$f":"'T13'!A1:E1","v":"Table 13 - Contracted and Modelled TEC"}]
[{"$f":"'T14'!A1","v":"Table 14 - Interconnectors"}]
[{"$f":"'T15'!A1","v":"Table 15 - Allowed Revenues"}]
[{"$f":"'T16'!A1:F1","v":"Table 16 - Generation and Demand Revenue Proportions"}]
["Table 17 - Charging Bases"]
[{"$f":"'T18'!A1:F1","v":"Table 18 - Residual Calculation"}]
["Table 19 - Small Generator Discount "]
["Table 20 - Summary of CUSC Modifications affecting 2018/19 TNUoS Tariffs"]
["Table 21 - Demand Locational 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":"T1","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Summary of Demand Tariffs",null,null,null,"Return to Index"]
[]
[null,"HH Tariffs","2018/19 - October ","2018/19 - \nDraft","Change"]
[null,"Average Tariff (£/kW)",45.814430000000002,46.167323073955004,{"$f":"D4-C4","v":0.35289307395500202}]
[null,"Residual (£/kW)",46.900289999999998,46.93783996760942,{"$f":"D5-C5","v":3.7549967609422197E-2}]
[null,"EET","2018/19 - October ","2018/19 - \nDraft","Change"]
[null,"Average Tariff (£/kW)",25.3352,26.906578549817525,1.5513752620642229]
[null,"Phased residual (£/kW)",29.36,29.36,0]
[null,"AGIC (£/kW)",3.22,3.22,0]
[null,"Embedded Export Volume (GW)",6.515802595282385,6.515802595282385,0]
[null,"Total Credit (£m)",165.20949938625543,175.31795434507038,10.108454958814946]
[null,"NHH Tariffs","2018/19 - October ","2018/19 - \nDraft","Change"]
[null,"Average (p/kWh)",6.1607760788711783,6.2105657986135832,4.978971974240487E-2]

{"sheet":"T2","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Table 2 - Demand Tariffs",null,null,null,"Return to Index"]
[]
["Zone","Zone Name","Gross HH Demand Tariff (£/kW)","NHH Demand Tariff\n(p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",26.298677999999999,3.508445,11.347693]
[2,"Southern Scotland",29.058761000000001,3.9167670000000001,14.107775999999999]
[3,"Northern",37.816645000000001,4.9990180000000004,22.865659000000001]
[4,"North West",43.804080999999996,5.8816949999999997,28.853095]
[5,"Yorkshire",44.071351,5.7849550000000001,29.120365]
[6,"N Wales & Mersey",45.509619000000001,5.9285579999999998,30.558634000000001]
[7,"East Midlands",47.499335000000002,6.3448000000000002,32.548349999999999]
[8,"Midlands",48.794504000000003,6.7321590000000002,33.843518000000003]
[9,"Eastern",49.426515999999999,7.157381,34.475530999999997]
[10,"South Wales",45.802151000000002,5.5524250000000004,30.851165000000002]
[11,"South East",52.108294999999998,7.7128839999999999,37.157310000000003]
[12,"London",54.904609999999998,6.1059429999999999,39.953623999999998]
[13,"Southern",53.417644000000003,7.3171920000000004,38.466659]
[14,"South Western",51.865302999999997,7.559768,36.914318000000002]
[]
["Tariffs include small gen tariff of:",null,0.59314550139855449,8.0146708092447824E-2]
["Residual charge for gross demand:",null,46.93783996760942]

{"sheet":"T3 & Fig 1","index":3,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 3 - Gross HH Demand Tariffs",null,null,null,"Return to Index",null,"Figure 1 - Gross HH Demand Tariffs"]
[]
["Zone","Zone Name","2018/19 October\n(£/kW)","2018/19\nDraft\n(£/kW)","Change (£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",18.351266903436535,26.298677999999999,7.9474110965634637,3.7545967609418085E-2]
[2,"Southern Scotland",25.131649897065973,29.058761000000001,3.9271111029340275,3.7545967609418085E-2]
[3,"Northern",36.924539581278196,37.816645000000001,0.89210541872180471,3.7545967609418085E-2]
[4,"North West",43.86648851609926,43.804080999999996,-6.2407516099263205E-2,3.7545967609418085E-2]
[5,"Yorkshire",43.831984255327384,44.071351,0.23936674467261554,3.7545967609418085E-2]
[6,"N Wales & Mersey",45.43376043468588,45.509619000000001,7.5858565314121051E-2,3.7545967609418085E-2]
[7,"East Midlands",47.390135014667337,47.499335000000002,0.10919998533266551,3.7545967609418085E-2]
[8,"Midlands",48.848500693385844,48.794504000000003,-5.3996693385840899E-2,3.7545967609418085E-2]
[9,"Eastern",49.367284820617826,49.426515999999999,5.9231179382173593E-2,3.7545967609418085E-2]
[10,"South Wales",46.780645375464047,45.802151000000002,-0.97849437546404516,3.7545967609418085E-2]
[11,"South East",52.515613271780801,52.108294999999998,-0.40731827178080238,3.7545967609418085E-2]
[12,"London",54.838362552316418,54.904609999999998,6.6247447683579708E-2,3.7545967609418085E-2]
[13,"Southern",53.798691816851083,53.417644000000003,-0.3810478168510798,3.7545967609418085E-2]
[14,"South Western",53.859061865163376,51.865302999999997,-1.9937588651633789,3.7545967609418085E-2]

{"sheet":"T4 & Fig 2","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 4 - Embedded Export Tariff",null,null,null,"Return to Index",null,null,"Figure 2 - Embedded Export Tariff"]
[]
[]
["Zone","Zone Name","2018/19 October\n(£/kW)","2018/19 Draft\n(£/kW)","Change (£/kW)"]
[1,"Northern Scotland",3.4359336729070051,11.347693,7.9117593270929945]
[2,"Southern Scotland",10.216316666536443,14.107775999999999,3.8914593334635565]
[3,"Northern",22.009206350748663,22.865659000000001,0.85645264925133802]
[4,"North West",28.951155285569726,28.853095,-9.8060285569726346E-2]
[5,"Yorkshire",28.916651024797851,29.120365,0.20371397520214884]
[6,"N Wales & Mersey",30.518427204156346,30.558634000000001,4.0206795843655385E-2]
[7,"East Midlands",32.474801784137803,32.548349999999999,7.3548215862196287E-2]
[8,"Midlands",33.933167462856311,33.843518000000003,-8.9649462856307593E-2]
[9,"Eastern",34.451951590088299,34.475530999999997,2.3579409911697269E-2]
[10,"South Wales",31.865312144934514,30.851165000000002,-1.0141471449345119]
[11,"South East",37.600280041251267,37.157310000000003,-0.44297004125126449]
[12,"London",39.923029321786885,39.953623999999998,3.0594678213113013E-2]
[13,"Southern",38.883358586321549,38.466659,-0.41669958632154902]
[14,"South Western",38.943728634633842,36.914318000000002,-2.029410634633841]

{"sheet":"T5 & Fig 3","index":5,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 5 - NHH Demand Tariff Changes",null,null,null,"Return to Index",null,"Figure 3 - NHH Demand Tariff Changes"]
[]
["Zone","Zone Name","2018/19 October Forecast (p/kWh)","2018/19 Draft Forecast (p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",2.4485170583084086,3.508445,1.0599279416915914]
[2,"Southern Scotland",3.3874685071495554,3.9167670000000001,0.52929849285044472]
[3,"Northern",4.8811368871520777,4.9990180000000004,0.11788111284792269]
[4,"North West",5.8900757678050395,5.8816949999999997,-8.3807678050398238E-3]
[5,"Yorkshire",5.7535545162822759,5.7849550000000001,3.1400483717724192E-2]
[6,"N Wales & Mersey",5.9186899782653075,5.9285579999999998,9.8680217346922561E-3]
[7,"East Midlands",6.3302184399937032,6.3448000000000002,1.4581560006297067E-2]
[8,"Midlands",6.7396048955202446,6.7321590000000002,-7.4458955202443278E-3]
[9,"Eastern",7.1487782685507302,7.157381,8.6027314492698181E-3]
[10,"South Wales",5.6708928243299725,5.5524250000000004,-0.11846782432997216]
[11,"South East",7.7732097781211245,7.7128839999999999,-6.0325778121124607E-2]
[12,"London",6.098639171224165,6.1059429999999999,7.3038287758349085E-3]
[13,"Southern",7.3693925466501531,7.3171920000000004,-5.2200546650152724E-2]
[14,"South Western",7.8505986630930629,7.559768,-0.29083066309306282]

{"sheet":"T6","index":6,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Table 6 - Changes to Average Tariffs",null,null,null,null,"Return to Index"]
[]
["Generation Tariffs","2018/19 February","2018/19 June","2018/19 October","2018/19 Draft","Change since last forecast"]
["Residual",-3.2036006033283315,-3.2820828327400391,-2.337478141048372,-2.5179382234887338,{"$f":"E4-D4","v":-0.18046008244036171}]
["Average Generation Tariff",6.3866957693428095,6.1734724880435934,5.7365117883695484,5.9806233909726583,{"$f":"E5-D5","v":0.24411160260310982},"N.B. These generation average tariffs include local tariffs"]

{"sheet":"T7","index":7,"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 7 - Generation Wider Tariffs",null,null,null,null,null,null,null,"Return to Index"]
[null,null,null,null,null,null,"Example tariffs for a generator of each technology type:"]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional Carbon 80%","Conventional Low Carbon 80%","Intermittent 40%"]
["Zone","Zone Name","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",-1.2522800000000001,7.2697529999999997,24.319562000000001,-2.517938,21.501234,26.3651464,24.709525200000002]
[2,"East Aberdeenshire",-1.5775410000000001,7.2697529999999997,15.555383000000001,-2.517938,14.1646298,17.275706400000001,15.945346199999999]
[3,"Western Highlands",-1.13341,6.9423919999999999,23.718412000000001,-2.517938,20.877295199999999,25.6209776,23.9774308]
[4,"Skye and Lochalsh",-7.0635560000000002,6.9423919999999999,23.613374,-2.517938,14.863118800000002,19.585793599999999,23.8723928]
[5,"Eastern Grampian and Tayside",0.22576299999999999,6.0344150000000001,21.214727,-2.517938,19.507138600000001,23.750084000000001,21.110554999999998]
[6,"Central Grampian",-0.53868899999999997,5.6210050000000003,19.694026999999998,-2.517938,17.195398599999997,21.134203999999997,19.424490999999996]
[7,"Argyll",-4.2809249999999999,4.9547489999999996,19.349354000000002,-2.517938,12.6444194,16.514290200000001,18.813315599999999]
[8,"The Trossachs",0.12198299999999999,4.9547489999999996,17.172736,-2.517938,15.306032999999999,18.7405802,16.636697599999998]
[9,"Stirlingshire and Fife",-0.69586599999999998,3.8001819999999999,15.552784000000001,-2.517938,12.268568800000001,15.379125600000002,14.554918799999999]
[10,"South West Scotlands",2.7599019999999999,5.341869,17.306508000000001,-2.517938,18.360665600000001,21.8219672,16.9253176]
[11,"Lothian and Borders",2.921055,5.341869,11.319983000000001,-2.517938,13.732598599999999,15.996595200000002,10.938792599999999]
[12,"Solway and Cheviot",1.8474889999999999,3.305733,9.3938319999999997,-2.517938,9.4892029999999998,11.3679694,8.1981871999999996]
[13,"North East England",3.4346299999999998,2.172482,4.7373089999999998,-2.517938,6.4445248000000008,7.3919866000000001,3.0883637999999998]
[14,"North Lancashire and The Lakes",1.7532920000000001,2.172482,3.6298659999999998,-2.517938,3.8772324000000005,4.6032055999999999,1.9809207999999998]
[15,"South Lancashire, Yorkshire and Humber",4.3695149999999998,0.92146600000000001,0.108888,-2.517938,2.6758601999999998,2.6976377999999999,-2.0404635999999998]
[16,"North Midlands and North Wales",3.7930229999999998,-0.90328200000000003,0,-2.517938,0.5524593999999996,0.5524593999999996,-2.8792507999999999]
[17,"South Lincolnshire and North Norfolk",2.205308,-0.379467,0,-2.517938,-0.61620359999999996,-0.61620359999999996,-2.6697248]
[18,"Mid Wales and The Midlands",1.2833969999999999,-8.5222999999999993E-2,0,-2.517938,-1.3027194000000002,-1.3027194000000002,-2.5520271999999999]
[19,"Anglesey and Snowdon",4.5783040000000002,-0.97940300000000002,0,-2.517938,1.2768436000000003,1.2768436000000003,-2.9096991999999999]
[20,"Pembrokeshire",9.1017379999999992,-4.4407449999999997,0,-2.517938,3.0312039999999998,3.0312039999999998,-4.2942359999999997]
[21,"South Wales & Gloucester",6.1891699999999998,-4.4126560000000001,0,-2.517938,0.14110719999999954,0.14110719999999954,-4.2830004000000006]
[22,"Cotswold",3.1395659999999999,2.197803,-6.5860589999999997,-2.517938,-2.8889768000000005,-4.2061885999999999,-8.2248757999999995]
[23,"Central London",-5.3973500000000003,2.197803,-6.3692130000000002,-2.517938,-11.252416,-12.526258600000002,-8.0080297999999992]
[24,"Essex and Kent",-3.7735500000000002,2.197803,0,-2.517938,-4.5332455999999999,-4.5332455999999999,-1.6388167999999999]
[25,"Oxfordshire, Surrey and Sussex",-1.2739229999999999,-2.85602,0,-2.517938,-6.0766770000000001,-6.0766770000000001,-3.6603460000000001]
[26,"Somerset and Wessex",-1.323475,-4.2593870000000003,0,-2.517938,-7.2489226000000002,-7.2489226000000002,-4.2216928000000005]
[27,"West Devon and Cornwall",0.165552,-5.6562590000000004,0,-2.517938,-6.8773932000000002,-6.8773932000000002,-4.7804415999999996]
[]
[null,null,"Small Generation Discount (£/kW)",null,null,11.104975]

{"sheet":"T8 & Fig 4","index":8,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,11],[4,2,4,4],[4,8,4,10],[4,11,5,11],[0,0,0,10],[4,5,4,7]]}
["Table 8 - Generation Tariff Changes",null,null,null,null,null,null,null,null,null,null,"Return to Index",null,"Figure 4 - Variation in Generation Zonal Tariffs"]
[]
[]
["Generation Wider Tariffs (£/kW)"]
[null,null,"Conventional Carbon 80%",null,null,"Conventional Low Carbon 80%",null,null,"Intermittent 40%",null,null,"Change in Residual (£/kW)"]
["Zone","Zone Name","2018/19\nOctober tariffs (£/kW)","2018/19 Draft tariffs (£/kW)","Change (£/kW)","2018/19 \nOctober tariffs (£/kW)","2018/19 Draft tariffs (£/kW)","Change (£/kW)","2018/19 \nOctober tariffs (£/kW)","2018/19 Draft tariffs (£/kW)","Change (£/kW)"]
[1,"North Scotland",27.977228773995513,21.501234,{"$f":"D7-C7","v":-6.475994773995513},31.052804918431974,26.3651464,{"$f":"G7-F7","v":-4.6876585184319737},20.925836752125363,24.709525200000002,{"$f":"J7-I7","v":3.7836884478746384},-0.18046022348873381]
[2,"East Aberdeenshire",22.687306223174012,14.1646298,-8.522676423174012,25.762882367610477,17.275706400000001,{"$f":"G8-F8","v":-8.4871759676104759},17.154829865779501,15.945346199999999,-1.2094836657795014,{"$f":"+L7","v":-0.18046022348873381}]
[3,"Western Highlands",26.613242333468921,20.877295199999999,-5.7359471334689225,29.688818477905386,25.6209776,-4.0678408779053861,20.505120400341074,23.9774308,3.4723103996589266,{"$f":"+L8","v":-0.18046022348873381}]
[4,"Skye and Lochalsh",31.283614332608643,14.863118800000002,-16.420495532608641,35.522982350790365,19.585793599999999,-15.937188750790366,26.324079769067389,23.8723928,-2.4516869690673886,-0.18046022348873381]
[5,"Eastern Grampian and Tayside",24.983777116176991,19.507138600000001,-5.4766385161769904,27.974756245078893,23.750084000000001,-4.2246722450788923,18.929460097192806,21.110554999999998,2.1810949028071924,-0.18046022348873381]
[6,"Central Grampian",24.798904323529477,17.195398599999997,-7.6035057235294801,27.732167557213938,21.134203999999997,-6.5979635572139408,18.294730258736539,19.424490999999996,1.1297607412634569,-0.18046022348873381]
[7,"Argyll",29.662722155613608,12.6444194,-17.018302755613608,34.529013442948241,16.514290200000001,-18.014723242948239,26.691817220482573,18.813315599999999,-7.8785016204825737,-0.18046022348873381]
[8,"The Trossachs",21.376517598930015,15.306032999999999,-6.0704845989300154,24.084748494312475,18.7405802,-5.3441682943124746,15.90151526072173,16.636697599999998,0.7351823392782677,-0.18046022348873381]
[9,"Stirlingshire and Fife",17.092579832321203,12.268568800000001,-4.8240110323212022,19.669983190941579,15.379125600000002,-4.2908575909415774,14.074392587379865,14.554918799999999,0.48052621262013417,-0.18046022348873381]
[10,"South West Scotlands",18.068641952529873,18.360665600000001,0.29202364747012766,20.671019725559713,21.8219672,1.1509474744402866,14.47593687640455,16.9253176,2.4493807235954499,-0.18046022348873381]
[11,"Lothian and Borders",14.678103881033376,13.732598599999999,-0.94550528103337683,16.166495027807933,15.996595200000002,-0.16989982780793156,8.906003745128146,10.938792599999999,2.0327888548718533,-0.18046022348873381]
[12,"Solway and Cheviot",9.8834760571503679,9.4892029999999998,-0.39427305715036809,11.36744225500941,11.3679694,5.2714499059014486E-4,7.288536165789294,8.1981871999999996,0.90965103421070559,-0.18046022348873381]
[13,"North East England",7.157978273221083,6.4445248000000008,-0.71345347322108221,7.9632453933634721,7.3919866000000001,-0.57125879336347207,2.9982486738034311,3.0883637999999998,9.0115126196568696E-2,-0.18046022348873381]
[14,"North Lancashire and The Lakes",3.7946766672460903,3.8772324000000005,8.2555732753910149E-2,4.3088402467830527,4.6032055999999999,0.29436535321694723,1.5427309707762928,1.9809207999999998,0.43818982922370697,-0.18046022348873381]
[15,"South Lancashire, Yorkshire and Humber",2.897856663698037,2.6758601999999998,-0.22199646369803716,2.897856663698037,2.6976377999999999,-0.2002188636980371,-1.8477132583572629,-2.0404635999999998,-0.19275034164273697,-0.18046022348873381]
[16,"North Midlands and North Wales",0.80555139931822195,0.5524593999999996,-0.25309199931822235,0.80555139931822195,0.5524593999999996,-0.25309199931822235,-2.4377490115296658,-2.8792507999999999,-0.44150178847033406,-0.18046022348873381]
[17,"South Lincolnshire and North Norfolk",-0.39766170414896607,-0.61620359999999996,-0.2185418958510339,-0.39766170414896607,-0.61620359999999996,-0.2185418958510339,-2.4125984068282196,-2.6697248,-0.25712639317178043,-0.18046022348873381]
[18,"Mid Wales and The Midlands",-1.0363238198533544,-1.3027194000000002,-0.26639558014664577,-1.0363238198533544,-1.3027194000000002,-0.26639558014664577,-2.2935079076207345,-2.5520271999999999,-0.25851929237926541,-0.18046022348873381]
[19,"Anglesey and Snowdon",1.3875784756597618,1.2768436000000003,-0.11073487565976148,1.3875784756597618,1.2768436000000003,-0.11073487565976148,-2.2663756166226126,-2.9096991999999999,-0.64332358337738738,-0.18046022348873381]
[20,"Pembrokeshire",2.2976889864489625,3.0312039999999998,0.73351501355103732,2.2976889864489625,3.0312039999999998,0.73351501355103732,-4.1706198503637966,-4.2942359999999997,-0.12361614963620315,-0.18046022348873381]
[21,"South Wales & Gloucester",-0.78290619793035976,0.14110719999999954,0.9240133979303593,-0.78290619793035976,0.14110719999999954,0.9240133979303593,-4.2045574125798613,-4.2830004000000006,-7.8442987420139332E-2,-0.18046022348873381]
[22,"Cotswold",-3.9616123516474766,-2.8889768000000005,1.0726355516474761,-5.3751622804049486,-4.2061885999999999,1.1689736804049486,-8.4724084782935662,-8.2248757999999995,0.24753267829356673,-0.18046022348873381]
[23,"Central London",-11.055955825991973,-11.252416,-0.19646017400802762,-12.308298745861931,-12.526258600000002,-0.21795985413807095,-7.6663734338559983,-8.0080297999999992,-0.34165636614400086,-0.18046022348873381]
[24,"Essex and Kent",-4.4263888047521611,-4.5332455999999999,-0.10685679524783875,-4.4263888047521611,-4.5332455999999999,-0.10685679524783875,-1.4046588345062045,-1.6388167999999999,{"$f":"J30-I30","v":-0.23415796549379531},-0.18046022348873381]
[25,"Oxfordshire, Surrey and Sussex",-5.7673353847112834,-6.0766770000000001,-0.30934161528871673,-5.7673353847112834,-6.0766770000000001,-0.30934161528871673,-3.3482116337196191,-3.6603460000000001,-0.31213436628038105,-0.18046022348873381]
[26,"Somerset and Wessex",-8.1525943118181292,-7.2489226000000002,0.903671711818129,-8.1525943118181292,-7.2489226000000002,0.903671711818129,-4.1662585410857931,-4.2216928000000005,-5.543425891420739E-2,-0.18046022348873381]
[27,"West Devon and Cornwall",-9.3844189022324187,-6.8773932000000002,2.5070257022324185,-9.3844189022324187,-6.8773932000000002,2.5070257022324185,-5.0788256979597897,-4.7804415999999996,0.29838409795979004,-0.18046022348873381]

{"sheet":"T9","index":9,"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]]}
["Table 9 - Local Substation Tariffs",null,null,null,"Return to Index"]
[]
["Substation Rating","Connection Type","Local Substation Tariff (£/kW)"]
[null,null,"132kV","275kV","400kV"]
["<1320 MW","No redundancy",0.191582,0.109597,7.8966999999999996E-2]
["<1320 MW","Redundancy",0.422039,0.26111800000000002,0.18990599999999999]
[">=1320 MW","No redundancy",0,0.34363500000000002,0.24851799999999999]
[">=1320 MW","Redundancy",0,0.56416100000000002,0.41179100000000002]

{"sheet":"T10","index":10,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 10 - Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",4.0962529892260662,"Dinorwig",2.2894318599317312,"Langage",0.62762037693878259,"Dorenell",2.0025518894210217]
["Aigas",0.624082315169743,"Dunlaw Extension",1.43001856199007,"Lochay",0.34918774454499146,"Millennium South",0.89856718000739622]
["An Suidhe",2.907311919412543,"Dunhill",1.3667416645299648,"Luichart",0.54724342918794566,"Aberdeen Bay",2.4879626798830645]
["Arecleoch",1.9818495376396965,"Dumnaglass",1.7715887709152665,"Mark Hill",0.83547911642071615,"Killingholme",0.67666846492996791]
["Baglan Bay",0.72592618641107964,"Edinbane",6.5305450409854187,"Marchwood",0.36425809942416104,"Middleton",0.1046244480480992]
["Beinneun Wind Farm",1.4332064805455231,"Ewe Hill",1.3112732784693357,"Millennium Wind ",1.7427329041449588]
["Bhlaraidh Wind Farm",0.62790458446065256,"Fallago",0.57243346585846655,"Moffat",0.16009145259542978]
["Black Hill",0.82327133231759497,"Farr",3.4021702784038976,"Mossford",0.42767422239766772]
["BlackCraig Wind Farm",6.0068403511180959,"Fernoch",4.197281293023293,"Nant",-1.1722406111735761]
["Black Law",1.6673714802023356,"Ffestiniogg",0.24141498757966703,"Necton",-0.35153647041543928]
["BlackLaw Extension",3.5358770498784851,"Finlarig",0.30553927647686774,"Rhigos",9.7110545493918066E-2]
["Bodelwyddan",0.10979138309069036,"Foyers",0.71851204012187331,"Rocksavage",1.6893416206248318E-2]
["Carrington",-3.2264422570737077E-2,"Galawhistle",1.4113004675360059,"Saltend",0.32536687526934621]
["Clyde (North)",0.10464586912744371,"Glendoe",1.7552010134476266,"South Humber Bank",0.90263112063829665]
["Clyde (South)",0.12101788413609157,"Glenglass",9.2662839141093247,"Spalding",0.2679216247577923]
["Corriegarth",3.008295366178777,"Gordonbush",0.52056939383621215,"Strathbrora",0.37350428221240467]
["Corriemoillie",1.5875727530685548,"Griffin Wind",4.0764066549934697,"Stronelairg",1.3966516029667784]
["Coryton",4.9502057721099488E-2,"Hadyard Hill",2.6411673849908524,"Strathy Wind",2.0135320558709076]
["Cruachan",1.8050890744955572,"Harestanes",2.3905281708765624,"Wester Dod",0.81428355426165833]
["Crystal Rig",0.48958731387877469,"Hartlepool",0.57328746113606133,"Whitelee",0.10127019592978402]
["Culligran",1.6538327742241172,"Hedon",0.17266528486136348,"Whitelee Extension",0.28153114468479923]
["Deanie",2.7170109862253349,"Invergarry",1.3538927450061806,"Gills Bay",2.403062267305228]
["Dersalloch",2.2985243742822288,"Kilgallioch",1.0042627763036898,"Kype Muir",1.4153425862843623]
["Didcot",0.49611901048982959,"Kilmorack",0.18845070413729101,"Middle Muir",1.8914336162853722]

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

{"sheet":"T12","index":12,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3]]}
["Table 12 - Offshore Local Tariffs",null,null,"Return to Index"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",7.720148,40.391807,1.0029840000000001]
["Greater Gabbard",14.474369922181488,33.260676830664345,0]
["Gunfleet",16.708069999999999,15.339316,2.8670070000000001]
["Gwynt Y Mor",17.627466025146894,17.365231559992413,0]
["Lincs",14.427677098205669,56.487653356485929,0]
["London Array",9.821298433339761,33.450795698758753,0]
["Ormonde",23.866551999999999,44.461150000000004,0.35431800000000002]
["Robin Rigg East",-0.44149899999999997,29.245531,9.0645369999999996]
["Robin Rigg West",-0.44149899999999997,29.245531,9.0645369999999996]
["Sheringham Shoal",23.059225142452885,27.043069429545302,0.58783684481317111]
["Thanet",17.560437880600976,32.721372540885511,0.78771898949607755]
["Walney 1",20.597966,41.020795,0]
["Walney 2",20.448162,41.382190000000001,0]
["West of Duddon Sands",7.9481923982249647,39.219403907646779,0]
["Westermost Rough",16.736222018136207,28.310525734130803,0]
["Humber Gateway",14.027433130104827,31.650564303813745,0]

{"sheet":"T13","index":13,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 13 - Contracted and Modelled TEC",null,null,null,null,"Return to Index"]
[]
["(GW)","2017/18 Final","2018/19 Initial Forecast","2018/19 June Forecast","2018/19 Oct Forecast","2018/19 Draft Tariffs"]
["Contracted TEC",72.193460000000016,79.569059999999993,78.825610000000012,82.4,79.028000000000006]
["Modelled Best View TEC",72.193460000000016,72.619659999999996,75.456410000000005,79.7,79.028000000000006]

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

{"sheet":"T15","index":15,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table 15 - Allowed Revenues",null,null,null,null,null,"Return to Index"]
[]
["£m Nominal Value","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,1652.5377960096639]
["Less income from connections",41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999]
["Income from TNUoS",{"$f":"+B6-B7","v":1706.8744856414505},1685.888172733421,1677.1661579426393,1605.2479913484156,1610.6551836096639,0]
[]
["Scottish Power Transmission"]
["Price controlled revenue",{"$f":"+B12+B13","v":333.74000036000007},390.54065630478544,377.73246643716254,360.46666610469617,361.20319766379362,{"$f":"+G12+G13","v":0}]
["Less income from connections",12.774800000000001,26.779541984732823,13.971352117109999,14.200000000000001,14.200000000000001]
["Income from TNUoS",320.96520036000004,363.76111432005263,363.76111432005257,346.26666610469618,{"$f":"F11-F12","v":347.00319766379363}]
[]
["SHE Transmission"]
["Price controlled revenue",{"$f":"+B17+B18","v":304.72326290000001},366.48655954513987,366.73460571949607,358.58543433685088,366.44487000000004,{"$f":"+G17+G18","v":0}]
["Less income from connections",3.355,3.2440075136088322,3.5890421108737836,3.4635076286130482,3.3999999999999986]
["Income from TNUoS",301.36826289999999,363.24255203153103,363.1455636086223,355.12192670823782,{"$f":"F16-F17","v":363.04487000000006}]
[]
["Offshore",270.20460754023691,380.16603753882629,373.18406027717322,312.14587309437724,308.99374212377779]
["Network Innovation Competition",32.071100479999998,40.5,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,2819.7568961484876,2661.2824572557265,2670.1969933972355,0]

{"sheet":"T16","index":16,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 16 - Generation and Demand Revenue Proportions",null,null,null,null,null,"Return to Index"]
[]
[null,null,"2017/18 Final","2018/19\nInitial","2018/19\nJune","2018/19\nOctober","2018/19\nDraft"]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5,2.5,2.5]
["y","Error Margin",0.21,0.21,0.21,0.21,0.21]
["ER","Exchange Rate (€/£)",1.27,1.1100000000000001,1.1599999999999999,1.1599999999999999,1.1599999999999999]
["MAR","Total Revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265,2670.1969933972355]
["GO","Generation Output (TWh)",250.95,239.90199022627161,252.62423194547756,252.62423194547756,252.62423194547756]
["G","% of revenue from generation",0.14830298821627588,0.15064709097467605,0.15253603366506521,0.16161927181593977,0.16107970082423759]
["D","% of revenue from demand",0.85169701178372414,0.84935290902532401,0.84746396633493482,0.83838072818406029,0.83892029917576239]
["G.R","Revenue recovered from generation (£m)",390.25688976377955,426.85264026746518,430.11453283820538,430.11453283820538,430.11453283820538]
["D.R","Revenue recovered from demand (£m)",2241.2267671579079,2406.6082483946307,2389.6423633102813,2231.1679244175211,2240.0824605590301]

{"sheet":"T17","index":17,"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 17 - Charging Bases",null,null,null,null,null,"Return to Index"]
[]
["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.978099999999998,71.918009999999995]
["NHH Demand (4pm-7pm TWh)",25.313203316155612,23.7,24.196416902536797,24.172250676783577,24.172250676783577]
["Net Charging"]
["Total Average Triad (GW)",47.684350893042456,46.43,46.004028260728987,45.947271541834986,45.947271541834986]
["HH  Demand Average Triad (GW)",13.227054908495282,14.25,13.186728568343657,13.285364566873497,13.285364566873497]
["Gross Charging"]
["Total Average Triad (GW)","Introduced by CMP264/265",null,null,52.463074137117367,52.463074137117367]
["HH  Demand Average Triad (GW)",null,null,null,19.801167162155881,19.801167162155881]
["Embedded Generation Export (GW)",null,null,null,6.515802595282385,6.515802595282385]

{"sheet":"T18","index":18,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[14,5,16,5],[18,2,21,4],[14,6,16,6]]}
["Table 18 - Residual Calculation",null,null,null,null,null,"Return to Index"]
[]
[null,"Component","2017/18","2018/19 Initial","2018/19 June","2018/19 October","2018/19 Draft"]
["G","Proportion of revenue recovered from generation (%)",0.14830298821627588,0.15064709097467607,0.15253603366506521,0.16161927181593977,0.16107970082423759]
["D","Proportion of revenue recovered from demand (%)",0.85169701178372414,0.8493529090253239,0.84746396633493482,0.83838072818406029,0.83892029917576239]
["R","Total TNUoS revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265,2670.1969933972355]
["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},{"$f":"((F6*F4)-F9-F10-F11-F12)/F13","v":-2.3374781410483694},{"$f":"((G6*G4)-G9-G10-G11-G12)/G13","v":-2.5179382234887355}]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",274.96728874315193,313.20792838474574,334.03183243068628,322.20269611755737,330.78500014536883]
["O","Revenue recovered from offshore local tariffs (£m)",208.46816305662131,293.90104300000002,288.423609,244.00475299999999,243.62572800000001]
["LG","Revenue recovered from onshore local substation tariffs (£m)",17.50045021,16.977773468180001,17.786043930629997,20.689817210000001,19.23186228782]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",14.605960191185485,16.877452513783155,18.540386170681664,18.47766093621048,17.557048741261632]
["BG","Generator charging base (GW)",67.579759999999993,66.834660000000014,69.671409999999995,74.978409999999997,71.918009999999995]
["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","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.900293842144286},{"$f":"(G5*G6-G20+G21)/G22","v":46.93783996760942}]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",null,null,null,-64.156169089228271,-47.102963152743214]
["EE","Amount to be paid to Embedded Export Tariffs (£m)",null,null,null,165.20949938625543,175.31795434507038]
["BD","Demand Gross charging base (GW)",null,null,null,52.463074137117367,52.463074137117367]

{"sheet":"T19","index":19,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,2]]}
["Table 19 - Small Generator Discount",null,"Return to Index"]
[]
["Small Generator Discount Calculation"]
["Generator Residual (£/kW)","G",-2.5179382234887338]
["Demand Residual (£/kW)","D",46.93783996760942]
["Small Generator Discount (£/kW)","T = (G + D)/4",11.104975]
["Forecast Small Generator Volume (kW)","V",2780910.0000000009]
["2017/18 SGD cost (£)","V x T",{"$f":"+C7*C6","v":30881936.027250011}]
["Prior year reconcilation (£)","R",-236300.38672000915]
["Total SGD Cost (£)","C = (V x T) + R",{"$f":"C8+C9","v":30645635.640530001}]
["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.58413724595006844}]
["Total Cost to HH Customers (£)","HHC = HHT * HHD",{"$f":"+C14*C12","v":11566599.252698669}]
["Increase in NHH Demand tariff (p/kWh)","NHHT = (C - HHC)/NHHD",{"$f":"100*(+C10-(+C14*C12))/(C13)","v":7.8929499130819189E-2}]
["Total Cost to NHH Customers (£)","NHHC = NHHT * NHHD",{"$f":"(+C16*C13)/100","v":19079036.387831327}]

{"sheet":"T20","index":20,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,0,3,3],[4,0,5,0],[4,1,5,1],[4,2,7,2],[4,3,7,3],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[10,0,12,0],[10,1,12,1],[10,2,12,2],[10,3,12,3],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[17,0,19,0],[17,1,19,1],[17,2,19,2],[17,3,19,3],[16,0,16,3],[20,0,20,3],[21,0,23,0],[21,1,23,1],[21,2,23,2],[21,3,23,3]]}
["Table 20 - Summary of CUSC Modifications affecting 2018/19 TNUoS Tariffs",null,null,null,"Return to Index"]
[]
["Mod Number","Description","Status ","Status in the Draft Tariffs"]
["Approved Modifications affecting Methodology from 1 April 2018"]
[264,"Embedded Generation Triad Avoidance Standstill","Approved – WACM 4 was approved by Ofgem","Implemented. 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","Approved - the original proposal was approved","Implemented"]
[]
[282,"The effect Negative Demand has on Zonal Locational Demand Tariffs","Approved - the original proposal was approved","Implemented"]
[]
[]
[283,"Consequential Changes to enable the Interconnector Cap and Floor regime","Approved - the original proposal was approved.","Implemented"]
[]
[]
["Modifications which may affect tariffs from 1 April 2018 if approved"]
[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","Pending Ofgem decision – the final modification report was submitted to Ofgem in October 2016.","Not implemented.\n\nSee note below\n"]
[]
[]
["Modifications rejected by Ofgem "]
[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)","Rejected","See note below "]

{"sheet":"T21","index":21,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[3,5,3,6]]}
["Table 21 - Demand Locational Tariffs",null,null,null,null,null,"Return to Index"]
[]
[]
[null,"October Forecast",null,"Draft  ",null,"Changes"]
["Zone","Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)"]
[1,-1.9933678319239434,-27.150698495169049,3.0652853085524256,-24.297592407518348,{"$f":"D6-B6","v":5.0586531404763688},{"$f":"E6-C6","v":2.8531060876507013}]
[2,-1.9617618740437621,-20.401921459419793,0.13468586944207572,-18.606910203190239,2.0964477434858377,1.7950112562295537]
[3,-3.4803631282924612,-7.0904305209588774,-3.0976809259450429,-6.6166595809184905,0.38268220234741834,0.47377094004038689]
[4,-1.1734004875718593,-2.4554442268584129,-1.2146693304078957,-2.5122354092969283,-4.1268842836036379E-2,-5.6791182438515442E-2]
[5,-2.933824451940414,-0.72952452326173634,-2.9021269840910411,-0.55750756929553746,3.1697467849372885E-2,0.17201695396619887]
[6,-1.6579429227826525,-0.40362987306100284,-2.3346526201441917,0.31328628812949022,-0.67670969736153919,0.71691616119049306]
[7,-2.0838482958922415,1.9786500800300471,-2.2577071072822306,2.226057041506424,-0.17385881138998904,0.24740696147637697]
[8,-1.1793265340397221,2.5324939968960338,-1.800712194165623,3.0642306086187707,-0.62138566012590091,0.5317366117227369]
[9,1.2679874348188853,0.60396415526941127,1.1405028904927716,0.75502780315296025,-0.12748454432611367,0.15106364788354898]
[10,-5.3542723415210451,4.6395844864555604,-6.1514431562883978,4.422608296298475,-0.79717081476735263,-0.21697619015708547]
[11,3.9876433613366893,1.0326366799145821,3.8698276019607856,0.70748226393984492,-0.11781575937590372,-0.32515441597473715]
[12,5.3859670002019744,1.9570623215849103,5.1191546203819387,2.2544698261102254,-0.26681237982003569,0.29740750452531506]
[13,2.1628471024719129,4.1405114838496351,1.6378599496727466,4.2487986459392193,-0.5249871527991663,0.10828716208958422]
[14,0.29607652341011859,6.0676521112237269,-1.0280515599441922,5.3623692111762971,-1.3241280833543108,-0.70528290004742988]

{"sheet":"T22","index":22,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,6],[2,7,2,11],[18,0,18,1]]}
["Table 22 - Demand Profiles",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
[null,null,"2018/19 October",null,null,null,null,"2018/19 Draft"]
["Zone","Zone Name","Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)","Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)"]
[1,"Northern Scotland",227,1477.05451191266,489.05889990612468,0.74080350740442558,1000.8421618642174,640.44056834040055,1477.05451191266,489.05889990612468,0.74080350740442558,1000.8421618642174]
[2,"Southern Scotland",2820.3501231149562,3500.4961069016904,1258.7854835184103,1.6632260196384325,669.52565661322433,2724.1305329036354,3500.4961069016904,1258.7854835184103,1.6632260196384325,669.52565661322433]
[3,"Northern",2508,2663.97949725749,1078.2985069717167,1.1999622256092375,580.7280671387075,2648.876743477872,2663.97949725749,1078.2985069717167,1.1999622256092375,580.7280671387075]
[4,"North West",3234,4116.8568956563204,1522.5202795527034,1.9323067221059214,343.41357976273923,3168.9334884833547,4116.8568956563204,1522.5202795527034,1.9323067221059214,343.41357976273923]
[5,"Yorkshire",4347,3919.7286234056701,1609.7345542740311,1.760521979873624,635.29667315094866,4387.6584007241499,3919.7286234056701,1609.7345542740311,1.760521979873624,635.29667315094866]
[6,"N Wales & Mersey",2831,2677.5738987326799,1085.2983354390524,1.2228860168028479,537.93642289182958,2393.690698448037,2677.5738987326799,1085.2983354390524,1.2228860168028479,537.93642289182958]
[7,"East Midlands",5333,4763.0073902219901,1878.0744115097325,2.1600750862099853,476.68222099855501,5295.7500000000009,4763.0073902219901,1878.0744115097325,2.1600750862099853,476.68222099855501]
[8,"Midlands",4594,4370.5052269223597,1616.9579396754075,1.9952568166336415,211.45446232058501,4409.8199999999988,4370.5052269223597,1616.9579396754075,1.9952568166336415,211.45446232058501]
[9,"Eastern",5843,6604.5136430028497,2132.6107427056013,3.0856416867034842,624.20802542452316,6097.2814177782457,6604.5136430028497,2132.6107427056013,3.0856416867034842,624.20802542452316]
[10,"South Wales",1969,1842.6417320212599,838.74346685036028,0.82936644145817029,331.34011382789242,1666.2224024423549,1842.6417320212599,838.74346685036028,0.82936644145817029,331.34011382789242]
[11,"South East",3355,3999.2986685067899,1168.9667994362562,1.9102578781343114,318.32854277171538,3813.0953070643036,3999.2986685067899,1168.9667994362562,1.9102578781343114,318.32854277171538]
[12,"London",5271,4322.8634936607696,2285.7297464800777,1.8361010423280268,149.07155068184611,5379.5749162800776,4322.8634936607696,2285.7297464800777,1.8361010423280268,149.07155068184611]
[13,"Southern",5668,5583.9145494300201,2072.2063774299195,2.5632591444412274,436.65769177116687,6219.6765523836166,5583.9145494300201,2072.2063774299195,2.5632591444412274,436.65769177116687]
[14,"South Western",2609,2620.63989948482,764.18161840648941,1.2725861094402413,200.31742606443373,2244.3945319500863,2620.63989948482,764.18161840648941,1.2725861094402413,200.31742606443373]
["Total",null,{"$f":"SUM(C5:C18)","v":50609.350123114957},{"$f":"SUM(D5:D18)","v":52463.074137117364},{"$f":"SUM(E5:E18)","v":19801.167162155882},{"$f":"SUM(F5:F18)","v":24.172250676783577},{"$f":"SUM(G5:G18)","v":6515.8025952823837},{"$f":"SUM(H5:H18)","v":51089.545560276129},52463.074137117364,19801.167162155882,24.172250676783577,6515.8025952823837]

{"sheet":"T23 & T24","index":23,"n_rows":4,"n_cols":13,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Table 23 & Table 24 - Annual Load Factors and Generic Annual Load Factors",null,null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
["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":24,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Table 25 - Generation TEC Changes",null,null,"Return to Index"]
[]
[]
["Power Station","Node","MW Change","Generation Zone"]
["Barry Power Station","ABTH20",93,21]
["Blackcraig Wind Farm","BLCW10",-4.6000000000000014,10]
["Killingholme","KILL40",-600,15]
["Kings Lynn A","WALP40_EME",99,17]
["Loganhead Windfarm","EWEH1Q",-36,12]
["Peterhead","PEHE20",-1180,2]
["Pogbie Wind Farm","DUNE10",11.8,11]
["Powersite @ Drakelow","DRAK40",-380,18]
["Rampion Offshore Wind Farm","BOLN40",400,25]
["Taylors Lane","WISD20_LPN",144,23]
["Trafford Power","CARR40",-1944,16]
["Tralorg Wind Farm","MAHI20",-20,10]

{"sheet":"T26","index":25,"n_rows":52,"n_cols":9,"rows_kept":52,"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,null,null,null,null,"Return to Index"]
[]
[null,null,null,"2017-12-18",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,-310.24084085000004,"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,{"$f":"SUM(H9:H11)*H15","v":1670.4902563245746}]
["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.70842755869282104,"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,347.00319766379363,"Forecast"]
["SHE Transmission Pass-Through","B7","TSHt",213.95951766583201,338.20730217321301,322.83631648970299,301.36826289999999,363.04487000000012,"Forecast"]
["Offshore Transmission Pass-Through","B8","TOFTOt",218.38037349491276,248.35699921993759,260.78931257200446,270.20460754023702,308.99374212377791,"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,{"$f":"SUM(H17:H25)","v":1022.8320615059341}," "]
["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,9.2638932635379323,"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,{"$f":"SUM(H27:H30)","v":14.833756216664455}," "]
["Network Innovation Allowance","D","NIAt",10.915977512381877,10.555516732879822,10.611460730470144,10.171231010256395,10.524088614844821,"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,{"$f":"H16+H26+H31+SUM(H32:H38)","v":2712.0796057972357}," "]
["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,{"$f":"H39-H40-H41","v":2670.1969933972355}," "]
["Final Collected Revenue","U","TNRt",null,null,null,null," ","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 - 2017/18 pass through to other networks is based on forecast at time of tariff setting"]

{"sheet":"T27","index":26,"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",null,null,null,null,null,"Return to Index"]
[]
["Offshore Transmission Revenue Forecast","2017-12-14",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,6.2498520825591388,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.8015038148892577,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.550962439388835,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.8344851195635119,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,16.266050446363451,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.659406380156412,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.96134839027274,"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.58886202651108,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.536635538325498,"Current revenues plus indexation"]
["Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,28.169364454148401,"Current revenues plus indexation"]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,32.730809292973404,"Current revenues plus indexation"]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.257955226677058,"Current revenues plus indexation"]
["Humber Gateway",null,null,29.284541507176115,9.7498990869565194,12.145415107061377,"Current revenues plus indexation"]
["Westermost Rough",null,null,null,11.576692607080746,13.197290934782657,"Current revenues plus indexation"]
["Forecast to asset transfer to OFTO + Interconnector revenue in 2018/19",null,null,null,null,26.55211019849418,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2019/20",null,null,null,null,null,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2020/21",null,null,null,null,null,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2021/22",null,null,null,null,null,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",{"$f":"SUM(B6:B24)","v":218.38037349491282},{"$f":"SUM(C6:C24)","v":248.35699921993759},{"$f":"SUM(D6:D24)","v":260.78931257200446},{"$f":"SUM(E6:E24)","v":265.53230168097656},{"$f":"SUM(F6:F24)","v":308.99374212377779}," "]
[]
[]
["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"]