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

{"sheet":"Index","index":0,"n_rows":27,"n_cols":1,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["INDEX"]
[{"$f":"Residuals!A1","v":"Residuals & Averages"}]
[{"$f":"'T1'!A1","v":"Table 1 - Summary of Demand Tariffs"}]
[{"$f":"'T2'!A1","v":"Table 2 - Demand Tariffs"}]
[{"$f":"'T3'!A1","v":"Table 3 - Gross HH Demand Tariffs"}]
[{"$f":"'T4'!A1","v":"Table 4 - Embedded Export Tariff"}]
[{"$f":"'T5'!A1","v":"Table 5 - NHH Demand Tariff Changes"}]
[{"$f":"'T6'!A1","v":"Table 6 - Summary of Generation Tariffs"}]
[{"$f":"'T7'!A1","v":"Table 7 - Generation Wider Tariffs"}]
[{"$f":"'T8 & Fig 1'!A1","v":"Table 8 - Generation Tariff Changes"}]
[{"$f":"'T9'!A1","v":"Table 9 - Local Substation Tariffs"}]
[{"$f":"'T10'!A1","v":"Table 10 - Onshore Local Circuit Tariffs"}]
[{"$f":"'T11'!A1","v":"Table 11 - CMP203: Circuits subject to one-off charges"}]
[{"$f":"'T12'!A1","v":"Table 12 - Offshore Local Tariffs"}]
[{"$f":"'T13'!A1","v":"Table 13 - Contracted and Modelled TEC"}]
[{"$f":"'T14'!A1","v":"Table 14 - Interconnectors"}]
[{"$f":"'T15'!A1","v":"Table 15 - Allowed Revenues"}]
[{"$f":"'T16'!A1","v":"Table 16 - Generation and Demand Revenue Proportions"}]
[{"$f":"'T17'!A1","v":"Table 17 - Charging Bases"}]
[{"$f":"'T18'!A1","v":"Table 18 - Residual Calculation"}]
[{"$f":"'T19'!A1","v":"Table 19 - Small Generator Discount"}]
[{"$f":"'T20'!A1","v":"Table 20 - Demand Locational Tariffs"}]
[{"$f":"'T21'!A1","v":"Table 21 - Demand Profiles"}]
[{"$f":"'T22'!A1","v":"Table 22 - Annual Load Factors"}]
[{"$f":"'T23'!A1","v":"Table 23 - Generic Annual Load Factors"}]
[{"$f":"'T24'!A1","v":"Table 24 - Indicative National Grid Revenue Forecast"}]
[{"$f":"'T25'!A1","v":"Table 25 - Offshore Revenues"}]

{"sheet":"Residuals","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Residuals & Averages",null,null,"Return to Index"]
[]
["Residual","2018/19\nDraft","2018/19\nDraft","Change"]
["Generation",-2.5179382234887338,-2.5245179579079666,{"$f":"C4-B4","v":-6.5797344192328744E-3}]
["Demand",46.93783996760942,46.933425649672998,{"$f":"C5-B5","v":-4.4143179364226626E-3}]
[]
["Average Tariff","2018/19\nDraft","2018/19\nDecember","Change"]
["Generation (£/kW)",5.9806233909726583,5.9792682078719501,{"$f":"C8-B8","v":-1.3551831007081461E-3}," N.B. These generation average tariffs include local tariffs"]
["HH Demand (£/kW)",46.167323073955004,46.170244457607446,{"$f":"C9-B9","v":2.9213836524419889E-3}]
["NHH Demand (p/kWh)",6.2105657986135832,6.210970802354133,4.0500374054985855E-4]
["Embedded Export (£/kW)",26.906578549817525,26.914672521653966,8.0939718364412272E-3]

{"sheet":"T1","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table 1 - Summary of Demand Tariffs",null,null,"Return to Index"]
[]
["HH Tariffs","2018/19\nDraft ","2018/19\nFinal","Change"]
["Average Tariff (£/kW)",46.167323073955004,46.170243999999997,{"$f":"C4-B4","v":2.9209260449931662E-3}]
["Residual (£/kW)",46.93783996760942,46.933425999999997,{"$f":"C5-B5","v":-4.4139676094232527E-3}]
["EET","2018/19\nDraft ","2018/19\nFinal","Change"]
["Average Tariff (£/kW)",26.906578549817525,26.914673000000001,8.0944501824760096E-3]
["Phased residual (£/kW)",29.36,29.36,0]
["AGIC (£/kW)",3.22,3.22,0]
["Embedded Export Volume (GW)",6.515802595282385,6.515802595282385,0]
["Total Credit (£m)",175.31795434507038,175.3706930677684,5.2738722698023821E-2]
["NHH Tariffs","2018/19\nDraft ","2018/19\nFinal","Change"]
["Average (p/kWh)",6.2105657986135832,6.2109709999999998,{"$f":"C13-B13","v":4.0520138641664261E-4}]

{"sheet":"T2","index":3,"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","HH Demand Tariff\n(£/kW)","NHH Demand Tariff\n(p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",26.304231999999999,3.509185,11.357806]
[2,"Southern Scotland",29.070426999999999,3.9183400000000002,14.124001]
[3,"Northern",37.816827000000004,4.9990410000000001,22.870401999999999]
[4,"North West",43.806241,5.8819850000000002,28.859815000000001]
[5,"Yorkshire",44.073211000000001,5.7851980000000003,29.126785999999999]
[6,"N Wales & Mersey",45.512765000000002,5.9289670000000001,30.566338999999999]
[7,"East Midlands",47.501488999999999,6.3450870000000004,32.555062999999997]
[8,"Midlands",48.796990999999998,6.7325020000000002,33.850566000000001]
[9,"Eastern",49.428548999999997,7.1576769999999996,34.482123000000001]
[10,"South Wales",45.804409999999997,5.5526970000000002,30.857983999999998]
[11,"South East",52.110398000000004,7.7131980000000002,37.163972999999999]
[12,"London",54.906683000000001,6.1061699999999997,39.960256999999999]
[13,"Southern",53.419806999999999,7.3174890000000001,38.473382000000001]
[14,"South Western",51.867519999999999,7.5600930000000002,36.921093999999997]
[]
["Tariffs include small gen tariff of:",null,0.59299999999999997,8.0127000000000004E-2]
["Residual charge for demand:",null,46.933425649672998]

{"sheet":"T3","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 3 - Gross HH Demand Tariffs",null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","2018/19 Draft (£/kW)","2018/19 Final (£/kW)","Change\n(£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",26.298677999999999,26.304231999999999,{"$f":"D4-C4","v":5.5540000000000589E-3},-4.4143503270035467E-3]
[2,"Southern Scotland",29.058761000000001,29.070426999999999,{"$f":"D5-C5","v":1.1665999999998178E-2},{"$f":"+F4","v":-4.4143503270035467E-3}]
[3,"Northern",37.816645000000001,37.816827000000004,1.8200000000234695E-4,{"$f":"+F5","v":-4.4143503270035467E-3}]
[4,"North West",43.804080999999996,43.806241,2.1600000000034925E-3,-4.4143503270035467E-3]
[5,"Yorkshire",44.071351,44.073211000000001,1.8600000000006389E-3,-4.4143503270035467E-3]
[6,"N Wales & Mersey",45.509619000000001,45.512765000000002,3.1460000000009813E-3,-4.4143503270035467E-3]
[7,"East Midlands",47.499335000000002,47.501488999999999,2.1539999999973247E-3,-4.4143503270035467E-3]
[8,"Midlands",48.794504000000003,48.796990999999998,2.486999999995021E-3,-4.4143503270035467E-3]
[9,"Eastern",49.426515999999999,49.428548999999997,2.032999999997287E-3,-4.4143503270035467E-3]
[10,"South Wales",45.802151000000002,45.804409999999997,2.258999999995126E-3,-4.4143503270035467E-3]
[11,"South East",52.108294999999998,52.110398000000004,2.1030000000052951E-3,-4.4143503270035467E-3]
[12,"London",54.904609999999998,54.906683000000001,2.0730000000028781E-3,-4.4143503270035467E-3]
[13,"Southern",53.417644000000003,53.419806999999999,2.1629999999959182E-3,-4.4143503270035467E-3]
[14,"South Western",51.865302999999997,51.867519999999999,2.2170000000016898E-3,-4.4143503270035467E-3]

{"sheet":"T4","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Table 4 - Embedded Export Tariff",null,null,null,"Return to Index"]
[]
[]
["Zone","Zone Name","2018/19\nDraft (£/kW)","2018/19 Final (£/kW)","Change (£/kW)"]
[1,"Northern Scotland",11.347693,11.357806,{"$f":"D5-C5","v":1.0113000000000483E-2}]
[2,"Southern Scotland",14.107775999999999,14.124001,{"$f":"D6-C6","v":1.6225000000000378E-2}]
[3,"Northern",22.865659000000001,22.870401999999999,4.7429999999977213E-3]
[4,"North West",28.853095,28.859815000000001,6.7200000000013915E-3]
[5,"Yorkshire",29.120365,29.126785999999999,6.4209999999995659E-3]
[6,"N Wales & Mersey",30.558634000000001,30.566338999999999,7.7049999999978525E-3]
[7,"East Midlands",32.548349999999999,32.555062999999997,6.7129999999977485E-3]
[8,"Midlands",33.843518000000003,33.850566000000001,7.0479999999975007E-3]
[9,"Eastern",34.475530999999997,34.482123000000001,6.5920000000048162E-3]
[10,"South Wales",30.851165000000002,30.857983999999998,6.8189999999965778E-3]
[11,"South East",37.157310000000003,37.163972999999999,6.6629999999960887E-3]
[12,"London",39.953623999999998,39.960256999999999,6.6330000000007772E-3]
[13,"Southern",38.466659,38.473382000000001,6.7230000000009227E-3]
[14,"South Western",36.914318000000002,36.921093999999997,6.7759999999950082E-3]

{"sheet":"T5","index":6,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 5 - NHH Demand Tariff Changes",null,null,null,"Return to Index"]
[]
["Zone","Zone Name","2018/19\nDraft (p/kWh)","2018/19\nFinal (p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",3.508445,3.509185,{"$f":"D4-C4","v":7.3999999999996291E-4}]
[2,"Southern Scotland",3.9167670000000001,3.9183400000000002,{"$f":"D5-C5","v":1.5730000000000466E-3}]
[3,"Northern",4.9990180000000004,4.9990410000000001,{"$f":"D6-C6","v":2.299999999966218E-5}]
[4,"North West",5.8816949999999997,5.8819850000000002,2.9000000000056758E-4]
[5,"Yorkshire",5.7849550000000001,5.7851980000000003,2.4300000000021527E-4]
[6,"N Wales & Mersey",5.9285579999999998,5.9289670000000001,4.0900000000032577E-4]
[7,"East Midlands",6.3448000000000002,6.3450870000000004,2.8700000000014825E-4]
[8,"Midlands",6.7321590000000002,6.7325020000000002,3.4299999999998221E-4]
[9,"Eastern",7.157381,7.1576769999999996,2.9599999999962989E-4]
[10,"South Wales",5.5524250000000004,5.5526970000000002,2.7199999999982793E-4]
[11,"South East",7.7128839999999999,7.7131980000000002,3.1400000000036954E-4]
[12,"London",6.1059429999999999,6.1061699999999997,2.2699999999975518E-4]
[13,"Southern",7.3171920000000004,7.3174890000000001,2.9699999999976967E-4]
[14,"South Western",7.559768,7.5600930000000002,3.2500000000013074E-4]

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

{"sheet":"T7","index":8,"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.2248030000000001,7.0871000000000004,23.713708,-2.524518,20.891325399999999,25.634067000000002,24.02403]
[2,"East Aberdeenshire",-1.5648329999999999,7.0871000000000004,16.322341000000002,-2.524518,14.638201800000001,17.902670000000001,16.632663000000001]
[3,"Western Highlands",-1.1513359999999999,6.7423999999999999,23.080718000000001,-2.524518,20.1826404,24.798784000000001,23.253160000000001]
[4,"Skye and Lochalsh",-7.0808799999999996,6.7423999999999999,22.985475000000001,-2.524518,14.176902000000002,18.773997000000001,23.157917000000001]
[5,"Eastern Grampian and Tayside",0.22387299999999999,5.9610709999999996,20.926257,-2.524518,19.209217400000004,23.394468799999999,20.7861674]
[6,"Central Grampian",-0.54015400000000002,5.6075889999999999,19.625995,-2.524518,17.1221952,21.047394199999999,19.344512599999998]
[7,"Argyll",-4.2818529999999999,4.9463489999999997,19.310849000000001,-2.524518,12.599387400000003,16.461557200000001,18.764870600000002]
[8,"The Trossachs",0.121027,4.9463489999999997,17.123688000000001,-2.524518,15.252538600000001,18.677276200000001,16.577709600000002]
[9,"Stirlingshire and Fife",-0.69517799999999996,3.8231510000000002,15.547750000000001,-2.524518,12.2770248,15.386574800000002,14.552492399999998]
[10,"South West Scotlands",2.7597930000000002,5.3216299999999999,17.252321999999999,-2.524518,18.294436599999997,21.744900999999999,16.856455999999998]
[11,"Lothian and Borders",2.9213689999999999,5.3216299999999999,11.337033,-2.524518,13.7237814,15.991188000000001,10.941167]
[12,"Solway and Cheviot",1.8477920000000001,3.2995679999999998,9.3943429999999992,-2.524518,9.4784027999999996,11.357271399999998,8.1896521999999994]
[13,"North East England",3.4350170000000002,2.1664330000000001,4.7382970000000002,-2.524518,6.4342830000000006,7.3819423999999998,3.0803522000000005]
[14,"North Lancashire and The Lakes",1.7536989999999999,2.1664330000000001,3.6288990000000001,-2.524518,3.8654466000000007,4.5912264,1.9709542]
[15,"South Lancashire, Yorkshire and Humber",4.3699519999999996,0.91504799999999997,0.108511,-2.524518,2.6642812,2.6859834,-2.0499878000000002]
[16,"North Midlands and North Wales",3.7934809999999999,-0.90336700000000003,0,-2.524518,0.54626939999999991,0.54626939999999991,-2.8858648000000002]
[17,"South Lincolnshire and North Norfolk",2.2057500000000001,-0.38641300000000001,0,-2.524518,-0.62789839999999986,-0.62789839999999986,-2.6790832]
[18,"Mid Wales and The Midlands",1.283844,-9.2372999999999997E-2,0,-2.524518,-1.3145724000000001,-1.3145724000000001,-2.5614672000000001]
[19,"Anglesey and Snowdon",4.5788019999999996,-0.98801799999999995,0,-2.524518,1.2638695999999996,1.2638695999999996,-2.9197252000000002]
[20,"Pembrokeshire",9.1021909999999995,-4.4480240000000002,0,-2.524518,3.0192537999999991,3.0192537999999991,-4.3037276000000002]
[21,"South Wales & Gloucester",6.189622,-4.4199229999999998,0,-2.524518,0.12916559999999988,0.12916559999999988,-4.2924872000000001]
[22,"Cotswold",3.140018,2.19069,-6.5862030000000003,-2.524518,-2.9009104000000003,-4.2181510000000006,-8.2344450000000009]
[23,"Central London",-5.396903,2.19069,-6.3691950000000004,-2.524518,-11.264225000000001,-12.538064,-8.017437000000001]
[24,"Essex and Kent",-3.7731029999999999,2.19069,0,-2.524518,-4.5450689999999998,-4.5450689999999998,-1.648242]
[25,"Oxfordshire, Surrey and Sussex",-1.2734749999999999,-2.8632119999999999,0,-2.524518,-6.0885625999999995,-6.0885625999999995,-3.6698028000000003]
[26,"Somerset and Wessex",-1.3230249999999999,-4.2665709999999999,0,-2.524518,-7.2607998000000009,-7.2607998000000009,-4.2311464000000001]
[27,"West Devon and Cornwall",0.16600300000000001,-5.6634700000000002,0,-2.524518,-6.8892910000000001,-6.8892910000000001,-4.7899060000000002]
[]
[null,null,"Small Generation Discount (£/kW)",null,null,11.102226999999999]

{"sheet":"T8 & Fig 1","index":9,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,0,2,11],[3,2,3,4],[3,8,3,10],[3,11,4,11],[0,0,0,10],[3,5,3,7]]}
["Table 8 - Generation Tariff Changes",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
["Wider Generation Tariffs (£/kW)"]
[null,null,"Conventional Carbon 80%",null,null,"Conventional Low Carbon 80%",null,null,"Intermittent 40%",null,null,"Change in Residual (£/kW)"]
["Zone","Zone Name","2018/19\nDraft (£/kW)","2018/19 Final (£/kW)","Change (£/kW)","2018/19 \nDraft (£/kW)","2018/19 Final (£/kW)","Change (£/kW)","2018/19 \nDraft  (£/kW)","2018/19 Final (£/kW)","Change (£/kW)"]
[1,"North Scotland",21.501234,20.891325399999999,{"$f":"D6-C6","v":-0.60990860000000069},26.3651464,25.634067000000002,{"$f":"G6-F6","v":-0.73107939999999871},24.709525200000002,24.02403,{"$f":"J6-I6","v":-0.68549520000000186},-6.5799579079666159E-3]
[2,"East Aberdeenshire",14.1646298,14.638201800000001,0.47357200000000077,17.275706400000001,17.902670000000001,{"$f":"G7-F7","v":0.62696359999999984},15.945346199999999,16.632663000000001,{"$f":"J7-I7","v":0.68731680000000139},{"$f":"+L6","v":-6.5799579079666159E-3}]
[3,"Western Highlands",20.877295199999999,20.1826404,-0.69465479999999857,25.6209776,24.798784000000001,-0.82219359999999853,23.9774308,23.253160000000001,{"$f":"J8-I8","v":-0.72427079999999933},{"$f":"+L7","v":-6.5799579079666159E-3}]
[4,"Skye and Lochalsh",14.863118800000002,14.176902000000002,-0.6862168000000004,19.585793599999999,18.773997000000001,-0.81179659999999743,23.8723928,23.157917000000001,-0.71447579999999888,-6.5799579079666159E-3]
[5,"Eastern Grampian and Tayside",19.507138600000001,19.209217400000004,-0.29792119999999755,23.750084000000001,23.394468799999999,-0.35561520000000257,21.110554999999998,20.7861674,-0.32438759999999789,-6.5799579079666159E-3]
[6,"Central Grampian",17.195398599999997,17.1221952,-7.3203399999997032E-2,21.134203999999997,21.047394199999999,-8.6809799999997495E-2,19.424490999999996,19.344512599999998,-7.9978399999998118E-2,-6.5799579079666159E-3]
[7,"Argyll",12.6444194,12.599387400000003,-4.5031999999997296E-2,16.514290200000001,16.461557200000001,-5.2732999999999919E-2,18.813315599999999,18.764870600000002,-4.8444999999997407E-2,-6.5799579079666159E-3]
[8,"The Trossachs",15.306032999999999,15.252538600000001,-5.3494399999998166E-2,18.7405802,18.677276200000001,-6.3303999999998695E-2,16.636697599999998,16.577709600000002,-5.8987999999995822E-2,-6.5799579079666159E-3]
[9,"Stirlingshire and Fife",12.268568800000001,12.2770248,8.4559999999989088E-3,15.379125600000002,15.386574800000002,7.4491999999999337E-3,14.554918799999999,14.552492399999998,-2.4264000000009389E-3,-6.5799579079666159E-3]
[10,"South West Scotlands",18.360665600000001,18.294436599999997,-6.6229000000003424E-2,21.8219672,21.744900999999999,-7.7066200000000862E-2,16.9253176,16.856455999999998,-6.8861600000001744E-2,-6.5799579079666159E-3]
[11,"Lothian and Borders",13.732598599999999,13.7237814,-8.8171999999993034E-3,15.996595200000002,15.991188000000001,-5.4072000000005005E-3,10.938792599999999,10.941167,2.3744000000007759E-3,-6.5799579079666159E-3]
[12,"Solway and Cheviot",9.4892029999999998,9.4784027999999996,-1.080020000000026E-2,11.3679694,11.357271399999998,-1.0698000000001429E-2,8.1981871999999996,8.1896521999999994,-8.5350000000001813E-3,-6.5799579079666159E-3]
[13,"North East England",6.4445248000000008,6.4342830000000006,-1.024180000000019E-2,7.3919866000000001,7.3819423999999998,-1.0044200000000281E-2,3.0883637999999998,3.0803522000000005,-8.0115999999992304E-3,-6.5799579079666159E-3]
[14,"North Lancashire and The Lakes",3.8772324000000005,3.8654466000000007,-1.1785799999999735E-2,4.6032055999999999,4.5912264,-1.1979199999999857E-2,1.9809207999999998,1.9709542,-9.9665999999998256E-3,-6.5799579079666159E-3]
[15,"South Lancashire, Yorkshire and Humber",2.6758601999999998,2.6642812,-1.1578999999999784E-2,2.6976377999999999,2.6859834,-1.1654399999999843E-2,-2.0404635999999998,-2.0499878000000002,-9.5242000000004268E-3,-6.5799579079666159E-3]
[16,"North Midlands and North Wales",0.5524593999999996,0.54626939999999991,-6.1899999999996957E-3,0.5524593999999996,0.54626939999999991,-6.1899999999996957E-3,-2.8792507999999999,-2.8858648000000002,-6.6140000000003418E-3,-6.5799579079666159E-3]
[17,"South Lincolnshire and North Norfolk",-0.61620359999999996,-0.62789839999999986,-1.1694799999999894E-2,-0.61620359999999996,-0.62789839999999986,-1.1694799999999894E-2,-2.6697248,-2.6790832,-9.3583999999999889E-3,-6.5799579079666159E-3]
[18,"Mid Wales and The Midlands",-1.3027194000000002,-1.3145724000000001,-1.1852999999999891E-2,-1.3027194000000002,-1.3145724000000001,-1.1852999999999891E-2,-2.5520271999999999,-2.5614672000000001,-9.440000000000115E-3,-6.5799579079666159E-3]
[19,"Anglesey and Snowdon",1.2768436000000003,1.2638695999999996,-1.2974000000000707E-2,1.2768436000000003,1.2638695999999996,-1.2974000000000707E-2,-2.9096991999999999,-2.9197252000000002,-1.0026000000000312E-2,-6.5799579079666159E-3]
[20,"Pembrokeshire",3.0312039999999998,3.0192537999999991,-1.1950200000000688E-2,3.0312039999999998,3.0192537999999991,-1.1950200000000688E-2,-4.2942359999999997,-4.3037276000000002,-9.4916000000004885E-3,-6.5799579079666159E-3]
[21,"South Wales & Gloucester",0.14110719999999954,0.12916559999999988,-1.1941599999999664E-2,0.14110719999999954,0.12916559999999988,-1.1941599999999664E-2,-4.2830004000000006,-4.2924872000000001,-9.4867999999994623E-3,-6.5799579079666159E-3]
[22,"Cotswold",-2.8889768000000005,-2.9009104000000003,-1.1933599999999878E-2,-4.2061885999999999,-4.2181510000000006,-1.1962400000000706E-2,-8.2248757999999995,-8.2344450000000009,-9.5692000000013877E-3,-6.5799579079666159E-3]
[23,"Central London",-11.252416,-11.264225000000001,-1.1809000000001291E-2,-12.526258600000002,-12.538064,-1.1805399999998301E-2,-8.0080297999999992,-8.017437000000001,-9.4072000000018363E-3,-6.5799579079666159E-3]
[24,"Essex and Kent",-4.5332455999999999,-4.5450689999999998,-1.1823399999999928E-2,-4.5332455999999999,-4.5450689999999998,-1.1823399999999928E-2,-1.6388167999999999,-1.648242,-9.4252000000001335E-3,-6.5799579079666159E-3]
[25,"Oxfordshire, Surrey and Sussex",-6.0766770000000001,-6.0885625999999995,-1.1885599999999386E-2,-6.0766770000000001,-6.0885625999999995,-1.1885599999999386E-2,-3.6603460000000001,-3.6698028000000003,-9.456800000000154E-3,-6.5799579079666159E-3]
[26,"Somerset and Wessex",-7.2489226000000002,-7.2607998000000009,-1.1877200000000698E-2,-7.2489226000000002,-7.2607998000000009,-1.1877200000000698E-2,-4.2216928000000005,-4.2311464000000001,-9.4535999999996179E-3,-6.5799579079666159E-3]
[27,"West Devon and Cornwall",-6.8773932000000002,-6.8892910000000001,-1.1897799999999847E-2,-6.8773932000000002,-6.8892910000000001,-1.1897799999999847E-2,-4.7804415999999996,-4.7899060000000002,-9.4644000000005946E-3,-6.5799579079666159E-3]
[]
["Figure 1 - Variation in Generation Zonal Tariffs"]

{"sheet":"T9","index":10,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,4,1],[2,0,2,4],[3,2,4,2],[3,3,4,3],[3,4,4,4]]}
["Table 9 - Local Substation Tariffs",null,null,null,"Return to Index"]
[]
["2018/19 Local Substation Tariff (£/kW)"]
["Substation\nRating","Connection\nType","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":11,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 10 - Onshore Local Circuit Tariffs",null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Aberdeen Bay",2.4879626798830645,"Dumnaglass",1.7715887709152653,"Langage",0.62762037651989477]
["Achruach",4.0962578803312431,"Dunhill",1.3667416645299615,"Lochay",0.34918774454499146]
["Aigas",0.62408231516974366,"Dunlaw Extension",1.4300139811415411,"Luichart",0.54724342918794466]
["An Suidhe",2.9073020991939544,"Edinbane",6.5305450409854151,"Marchwood",0.36425810013886895]
["Arecleoch",1.9818495376396981,"Ewe Hill",1.3112732784693357,"Mark Hill",0.83547911642071615]
["Baglan Bay",0.72592618759597372,"Fallago",0.57243595539935443,"Middle Muir",1.8914336162853709]
["Beinneun Wind Farm",1.4332064805455185,"Farr",3.4021702784038976,"Middleton",0.10462361722341078]
["Bhlaraidh Wind Farm",0.62790458446065256,"Fernoch",4.197281293023293,"Millennium South",0.89856718000739622]
["Black Hill",0.82327133231759497,"Ffestiniogg",0.24141498757966665,"Millennium Wind ",1.7427329041449537]
["Black Law",1.6673714802023334,"Finlarig",0.30553927647686774,"Moffat",0.16008358411208343]
["BlackCraig Wind Farm",6.0068403511180959,"Foyers",0.71851204012187841,"Mossford",0.42767422239767244]
["BlackLaw Extension",3.5358770498784851,"Galawhistle",1.4113004675360066,"Nant",-1.1722406111735757]
["Carrington",-3.2263077555673772E-2,"Gills Bay",2.403062267305228,"Necton",-0.35153639757182586]
["Clyde (North)",0.10464586912744371,"Glendoe",1.7552010134476306,"Rhigos",9.7110542771152414E-2]
["Clyde (South)",0.12101788413609157,"Glenglass",9.2662839141093247,"Rocksavage",1.6893416206248318E-2]
["Corriegarth",3.0082953661787766,"Gordonbush",0.24856842117278613,"Saltend",0.32536687526934627]
["Corriemoillie",1.5875727530685606,"Griffin Wind",4.0753696648830546,"South Humber Bank",0.90263126204018451]
["Coryton",4.9502074093383801E-2,"Hadyard Hill",2.6411673849908524,"Spalding",0.26792168070615779]
["Cruachan",1.8050839454638521,"Harestanes",2.3905203023932162,"Strathbrora",0.12145037225138244]
["Crystal Rig",0.48958863526865037,"Hartlepool",0.57328780410381497,"Strathy Wind",1.997707085087324]
["Culligran",1.6538327742241172,"Hedon",0.1726652848613634,"Stronelairg",1.3756629214073488]
["Deanie",2.7170109862253358,"Invergarry",1.3538927450061817,"Wester Dod",0.81428487565153107]
["Dersalloch",2.298524374282227,"Kilgallioch",1.0042627763036898,"Whitelee",0.10127019592978376]
["Didcot",0.49611903718160749,"Killingholme",0.67666860214641289,"Whitelee Extension",0.28153114468479951]
["Dinorwig",2.2894318599317312,"Kilmorack",0.18845070413729176]
["Dorenell",2.0025518894210244,"Kype Muir",1.4153425862843616]

{"sheet":"T11","index":12,"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":13,"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":14,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 13 - Contracted and Modelled TEC",null,null,null,null,"Return to Index"]
[]
["(GW)","2017/18","2018/19 Initial Forecast","2018/19 June Forecast","2018/19 Oct Forecast","2018/19 Draft Tariffs","2018/19 Final Tariffs"]
["Contracted TEC",72.193460000000016,{"$f":"79569.06/1000","v":79.569059999999993},{"$f":"78825.61/1000","v":78.825609999999998},82.445610000000002,79.028809999999993,79.028809999999993]
["Modelled Best View TEC",72.193460000000016,{"$f":"72619.66/1000","v":72.61966000000001},{"$f":"75456.41/1000","v":75.456410000000005},79.683410000000023,79.028809999999993,79.028809999999993]
["Chargeable TEC",67.579759999999993,66.83466,69.671409999999995,74.978409999999997,71.918009999999995,71.934310000000025]

{"sheet":"T14","index":15,"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":16,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table 15 - Allowed Revenues",null,null,null,null,null,"Return to Index"]
[]
["£m Nominal Value","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,1653.9179700263246]
["Less income from connections",41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,41.882612399999999,44.002400999999999]
["Income from TNUoS",{"$f":"+B6-B7","v":1706.8744856414505},1685.888172733421,1677.1661579426393,1605.2479913484156,1610.6551836096639,1609.9155690263246]
[]
["Scottish Power Transmission"]
["Price controlled revenue",{"$f":"+B12+B13","v":333.74000036000007},390.54065630478544,377.73246643716254,360.46666610469617,361.20319766379362,364.83]
["Less income from connections",12.774800000000001,26.779541984732823,13.971352117109999,14.200000000000001,14.200000000000001,14.869146848602265]
["Income from TNUoS",320.96520036000004,363.76111432005263,363.76111432005257,346.26666610469618,{"$f":"F11-F12","v":347.00319766379363},{"$f":"G11-G12","v":349.96085315139771}]
[]
["SHE Transmission"]
["Price controlled revenue",{"$f":"+B17+B18","v":304.72326290000001},366.48655954513987,366.73460571949607,358.58543433685088,366.44487000000004,369.81799999999998]
["Less income from connections",3.355,3.2440075136088322,3.5890421108737836,3.4635076286130482,3.3999999999999986,3.4071159999999998]
["Income from TNUoS",301.36826289999999,363.24255203153103,363.1455636086223,355.12192670823782,{"$f":"F16-F17","v":363.04487000000006},{"$f":"G16-G17","v":366.41088400000001}]
[]
["Offshore",270.20460754023691,380.16603753882629,373.18406027717322,312.14587309437724,315.7937421237778,318.14381186500032]
["Network Innovation Competition",32.071100479999998,40.5,40.5,40.5,40.5,32.664404040000001]
["EDR",null,null,2,2]
["Interconnectors (Cap & Floor)",null,null,null,null,{"$f":"G23","v":-6.8},-6.8]
["Total to Collect from TNUoS",{"$f":"+B22+B21+B20+B18+B13+B8","v":2631.4836569216873},2833.5578766238309,2819.7568961484876,2661.2824572557265,{"$f":"+F22+F21+F20+F18+F13+F8+F23","v":2670.196993397235},{"$f":"+G22+G21+G20+G18+G13+G8+G23","v":2670.2955220827225}]

{"sheet":"T16","index":17,"n_rows":12,"n_cols":8,"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","2018/19 Final"]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5,2.5,2.5,2.5]
["y","Error Margin",0.21,0.21,0.21,0.21,0.21,0.21]
["ER","Exchange Rate (€/£)",1.27,1.1100000000000001,1.1599999999999999,1.1599999999999999,1.1599999999999999,1.1599999999999999]
["MAR","Total Revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265,2670.1969933972355,2670.3]
["GO","Generation Output (TWh)",250.95,239.90199022627161,252.62423194547756,252.62423194547756,252.62423194547756,252.62423194547756]
["G","% of revenue from generation",0.14830298821627588,0.15064709097467605,0.15253603366506521,0.16161927181593977,0.16107970082423759,0.1610734871880333]
["D","% of revenue from demand",0.85169701178372414,0.84935290902532401,0.84746396633493482,0.83838072818406029,0.83892029917576239,0.83892651281196673]
["G.R","Revenue recovered from generation (£m)",390.25688976377955,426.85264026746518,430.11453283820538,430.11453283820538,430.11453283820538,{"$f":"H7*H9","v":430.11453283820532}]
["D.R","Revenue recovered from demand (£m)",2241.2267671579079,2406.6082483946307,2389.6423633102813,2231.1679244175211,2240.0824605590301,{"$f":"H7*H10","v":2240.1854671617948}]

{"sheet":"T17","index":18,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,11,3]]}
["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,71.934309999999996]
["NHH Demand (4pm-7pm TWh)",25.313203316155612,23.7,24.196416902536797,24.172250676783577,24.172250676783577,24.172250676783577]
["Net Charging"]
["Total Average Net Triad (GW)",47.684350893042456,46.43,46.004028260728987,45.947271541834986,45.947271541834979,45.947271541834979]
["HH  Demand Average Net Triad (GW)",13.227054908495282,14.25,13.186728568343657,13.285364566873497,13.285364566873497,13.285364566873497]
["Gross charging"]
["Total Average Gross Triad (GW)","Introduced by CMP264/265",null,null,52.463074137117367,52.463074137117367,52.463074137117367]
["HH Demand Average Gross Triad (GW)",null,null,null,19.801167162155881,19.801167162155881,19.801167162155881]
["Embedded Generation Export (GW)",null,null,null,6.515802595282385,6.515802595282385,6.515802595282385]

{"sheet":"T18","index":19,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,5],[14,5,16,5],[18,2,21,4],[14,6,16,6],[14,7,16,7]]}
["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\nDraft","2018/19\nFinal"]
["G","Proportion of revenue recovered from generation (%)",0.14830298821627588,0.15064709097467607,0.15253603366506521,0.16161927181593977,0.16107970082423759,0.16107348718803333]
["D","Proportion of revenue recovered from demand (%)",0.85169701178372414,0.8493529090253239,0.84746396633493482,0.83838072818406029,0.83892029917576239,0.83892651281196673]
["R","Total TNUoS revenue (£m)",2631.4836569216873,2833.4608886620958,2819.7568961484867,2661.2824572557265,2670.1969933972355,2670.3]
["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},-2.5245179579079635]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",274.96728874315193,313.20792838474574,334.03183243068628,322.20269611755737,330.78500014536883,329.41712407109287]
["O","Revenue recovered from offshore local tariffs (£m)",208.46816305662131,293.90104300000002,288.423609,244.00475299999999,243.62572800000001,245.31049899999999]
["LG","Revenue recovered from onshore local substation tariffs (£m)",17.50045021,16.977773468180001,17.786043930629997,20.689817210000001,19.23186228782,19.234985074419999]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",14.605960191185485,16.877452513783155,18.540386170681664,18.47766093621048,17.557048741261632,17.751382077410959]
["BG","Generator charging base (GW)",67.579759999999993,66.834660000000014,69.671409999999995,74.978409999999997,71.918009999999995,71.934309999999996]
["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","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},46.933425649672998]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",null,null,null,-64.156169089228271,-47.102963152743214,-46.715629138117094]
["EE","Amount to be paid to Embedded Export Tariffs (£m)",null,null,null,165.20949938625543,175.31795434507038,175.3706930677684]
["BD","Demand Gross charging base (GW)",null,null,null,52.463074137117367,52.463074137117367,52.463074137117367]

{"sheet":"T19","index":20,"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.5245179579079666]
["Demand Residual (£/kW)","D",46.933425649672998]
["Small Generator Discount (£/kW)","T = (G + D)/4",11.102226999999999]
["Forecast Small Generator Volume (kW)","V",2780910.0000000009]
["2017/18 SGD cost (£)","V x T",{"$f":"+C7*C6","v":30874294.08657001}]
["Prior year reconcilation (£)","R",-236300.38672000915]
["Total SGD Cost (£)","C = (V x T) + R",{"$f":"C8+C9","v":30637993.69985}]
["Total System Triad Demand (kW)","TD",45947271.54183498]
["Total HH 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.66680768349768305}]
["Total Cost to HH Customers (£)","HHC = HHT * HHD",{"$f":"+C14*C12","v":13203570.405947553}]
["Increase in NHH Demand tariff (p/kWh)","NHHT = (C - HHC)/NHHD",{"$f":"100*(+C10-(+C14*C12))/(C13)","v":7.2125775655005414E-2}]
["Total Cost to NHH Customers (£)","NHHC = NHHT * NHHD",{"$f":"(+C16*C13)/100","v":17434423.293902449}]

{"sheet":"T20","index":21,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,3,2,4],[2,5,2,6]]}
["Table 20 - Demand Locational Tariffs",null,null,null,null,null,"Return to Index"]
[]
[null,"2018/19 Draft",null,"2018/19 Final",null,"Changes"]
["Zone","Peak\n(£/kW)","Year Round (£/kW)","Peak\n(£/kW)","Year Round (£/kW)","Peak\n(£/kW)","Year Round (£/kW)"]
[1,3.0652853085524256,-24.297592407518348,3.0741366226568374,-24.296330366019777,{"$f":"D5-B5","v":8.851314104411756E-3},{"$f":"E5-C5","v":1.2620414985704542E-3}]
[2,0.13468586944207572,-18.606910203190239,0.13473504475696652,-18.590733712822033,4.9175314890792521E-5,1.6176490368206231E-2]
[3,-3.0976809259450429,-6.6166595809184905,-3.0980721792791757,-6.6115261771823022,-3.9125333413281282E-4,5.1334037361883134E-3]
[4,-1.2146693304078957,-2.5122354092969283,-1.2151007587647378,-2.5050838373553912,-4.3142835684206737E-4,7.1515719415371493E-3]
[5,-2.9021269840910411,-0.55750756929553746,-2.902564284347513,-0.55064983771283738,-4.3730025647192861E-4,6.8577315827000884E-3]
[6,-2.3346526201441917,0.31328628812949022,-2.3351288845381069,0.32146811187515673,-4.7626439391512676E-4,8.1818237456665055E-3]
[7,-2.2577071072822306,2.226057041506424,-2.2581558045781809,2.2332191085280551,-4.4869729595031771E-4,7.1620670216310245E-3]
[8,-1.800712194165623,3.0642306086187707,-1.8011716120706571,3.0717372002294296,-4.5941790503412072E-4,7.5065916106589192E-3]
[9,1.1405028904927716,0.75502780315296025,1.1400577747796321,0.76206548757773407,-4.4511571313954335E-4,7.0376844247738157E-3]
[10,-6.1514431562883978,4.422608296298475,-6.1518955342013886,4.4298796429675091,-4.5237791299079788E-4,7.2713466690341733E-3]
[11,3.8698276019607856,0.70748226393984492,3.8693802592675852,0.71459237945620058,-4.473426932003477E-4,7.1101155163556529E-3]
[12,5.1191546203819387,2.2544698261102254,5.1187082285337544,2.2615492574990195,-4.4639184818429101E-4,7.0794313887940774E-3]
[13,1.6378599496727466,4.2487986459392193,1.6374106796978913,4.255970928737729,-4.4926997485528197E-4,7.1722827985096771E-3]
[14,-1.0280515599441922,5.3623692111762971,-1.0285025628163544,5.3695966910440687,-4.5100287216226498E-4,7.2274798677716134E-3]

{"sheet":"T21","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],[2,0,3,0],[2,1,3,1]]}
["Table 21 - Demand Profiles",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name","2018/19 Draft",null,null,null,null,"2018/19 Final","2018/19 Final","2018/19 Final","2018/19 Final","2018/19 Final"]
[null,null,"Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)","Locational Model Demand (MW)","GROSS Tariff model Peak Demand (MW)","GROSS Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Tariff model Embedded Export (MW)"]
[1,"Northern Scotland",640.44056834040055,1477.05451191266,489.05889990612468,0.74080350740442558,1000.8421618642174,640.44056834040055,1477.05451191266,489.05889990612468,0.74080350740442558,1000.8421618642174]
[2,"Southern Scotland",2724.1305329036354,3500.4961069016904,1258.7854835184103,1.6632260196384325,669.52565661322433,2724.1305329036354,3500.4961069016904,1258.7854835184103,1.6632260196384325,669.52565661322433]
[3,"Northern",2648.876743477872,2663.97949725749,1078.2985069717167,1.1999622256092375,580.7280671387075,2648.876743477872,2663.97949725749,1078.2985069717167,1.1999622256092375,580.7280671387075]
[4,"North West",3168.9334884833547,4116.8568956563204,1522.5202795527034,1.9323067221059214,343.41357976273923,3168.9334884833547,4116.8568956563204,1522.5202795527034,1.9323067221059214,343.41357976273923]
[5,"Yorkshire",4387.6584007241499,3919.7286234056701,1609.7345542740311,1.760521979873624,635.29667315094866,4387.6584007241499,3919.7286234056701,1609.7345542740311,1.760521979873624,635.29667315094866]
[6,"N Wales & Mersey",2393.690698448037,2677.5738987326799,1085.2983354390524,1.2228860168028479,537.93642289182958,2393.690698448037,2677.5738987326799,1085.2983354390524,1.2228860168028479,537.93642289182958]
[7,"East Midlands",5295.7500000000009,4763.0073902219901,1878.0744115097325,2.1600750862099853,476.68222099855501,5295.7500000000009,4763.0073902219901,1878.0744115097325,2.1600750862099853,476.68222099855501]
[8,"Midlands",4409.8199999999988,4370.5052269223597,1616.9579396754075,1.9952568166336415,211.45446232058501,4409.8199999999988,4370.5052269223597,1616.9579396754075,1.9952568166336415,211.45446232058501]
[9,"Eastern",6097.2814177782457,6604.5136430028497,2132.6107427056013,3.0856416867034842,624.20802542452316,6097.2814177782457,6604.5136430028497,2132.6107427056013,3.0856416867034842,624.20802542452316]
[10,"South Wales",1666.2224024423549,1842.6417320212599,838.74346685036028,0.82936644145817029,331.34011382789242,1666.2224024423549,1842.6417320212599,838.74346685036028,0.82936644145817029,331.34011382789242]
[11,"South East",3813.0953070643036,3999.2986685067899,1168.9667994362562,1.9102578781343114,318.32854277171538,3813.0953070643036,3999.2986685067899,1168.9667994362562,1.9102578781343114,318.32854277171538]
[12,"London",5379.5749162800776,4322.8634936607696,2285.7297464800777,1.8361010423280268,149.07155068184611,5379.5749162800776,4322.8634936607696,2285.7297464800777,1.8361010423280268,149.07155068184611]
[13,"Southern",6219.6765523836166,5583.9145494300201,2072.2063774299195,2.5632591444412274,436.65769177116687,6219.6765523836166,5583.9145494300201,2072.2063774299195,2.5632591444412274,436.65769177116687]
[14,"South Western",2244.3945319500863,2620.63989948482,764.18161840648941,1.2725861094402413,200.31742606443373,2244.3945319500863,2620.63989948482,764.18161840648941,1.2725861094402413,200.31742606443373]
["Total",null,51089.545560276129,52463.074137117364,19801.167162155882,24.172250676783577,6515.8025952823837,51089.545560276129,52463.074137117364,19801.167162155882,24.172250676783577,6515.8025952823855]

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

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

{"sheet":"T24","index":25,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,2,3,4],[3,5,3,7],[2,3,2,7]]}
["Table 24 - Indicative National Grid Revenue Forecast",null,null,null,null,null,null,null,"Return to Index"]
[]
[null,null,null,"2018-01-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,7.0500000000000007E-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.5999999999999997E-2,"HM Treasury Forecast"]
["Current Calendar Year RPI Forecast"," ","GRPIFc",3.1E-2,2.4E-2,2.1000000000000001E-2,3.5000000000000003E-2,3.4000000000000002E-2,"HM Treasury Forecast"]
["Next Calendar Year RPI forecast"," ","GRPIFc+1",0.03,3.2000000000000001E-2,0.03,3.1E-2,3.1E-2,"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",{"$f":"SUM(D9:D11)*D15","v":1732.6948432352185},{"$f":"SUM(E9:E11)*E15","v":1675.4788464888604},1684.3588461063721,1614.4811127391104,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,349.96085315139794,"Forecast"]
["SHE Transmission Pass-Through","B7","TSHt",213.95951766583201,338.20730217321301,322.83631648970299,301.36826289999999,366.411,"Forecast"]
["Offshore Transmission Pass-Through","B8","TOFTOt",218.38037349491276,248.35699921993759,260.78931257200446,270.20460754023702,318.14381186500037,"Forecast"]
["Embedded Offshore Pass-Through","B9","OFETt",0.43733608355648018,0.64941914461921546,0.6544976173613446,0.51506514657980451,0.54981802045525896,"Forecast"]
["Interconnectors Cap&Floor Revenue Adjustment","B10","TICFt",null,null,null,null,-6.8,"Forecast"]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10]","B","PTt",{"$f":"SUM(D17:D25)","v":745.10032864292793},{"$f":"SUM(E17:E25)","v":889.96889230503325},885.86202586265358,899.42888226519096,{"$f":"SUM(H17:H26)","v":1031.5050798732379}," "]
["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.276440123545882,"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",{"$f":"SUM(D28:D31)","v":0},{"$f":"SUM(E28:E31)","v":13.863825485650448},18.727364771558829,15.256145688477281,{"$f":"SUM(H28:H31)","v":14.846303076672406}," "]
["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,32.664404040000001,"Forecast"]
["Future Environmental Discretionary Rewards","F","EDRt",0,0,0,0,0,"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.6479999999999961,"Forecast"]
["Scottish Terminations Adjustment","I","TSt",-0.28187454000000001,0.10154699999999994,7.2928609999999949E-2,-1.1215534200000001,3.0709999999999997,"Forecast"]
["Correction Factor","K","-Kt",0,56.423778228050232,103.97796600318905,97.021422609611989,-55.451092846606805,"Calculated by Licensee"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",{"$f":"D16+D27+D32+D33+D34+D35+D36+D37+D38+D39","v":2524.2607295101257},{"$f":"E16+E27+E32+E33+E34+E35+E36+E37+E38+E39","v":2681.6430789900505},2751.3303946882438,2673.3662693216875,2714.2980390827229," "]
["Pre-vesting connection charges","P"," ",46.954162359999998,44.955204119999998,42.677043259999913,41.882612399999999,44.002400999999999,"Forecast"]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",{"$f":"D40-D41","v":2477.3065671501258},{"$f":"E40-E41","v":2636.6878748700506},{"$f":"F40-F41","v":2708.6533514282437},{"$f":"G40-G41","v":2631.4836569216873},{"$f":"H40-H41","v":2670.2956380827227}," "]
[]
["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"]
["Figures for historic years represent National Grid's forecast of TO revenues at the time final tariffs were calculated for each charging year rather than our current best view."]

{"sheet":"T25","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 25 - Offshore Revenues",null,null,null,null,null,"Return to Index"]
[]
["Offshore Transmission Revenue Forecast","2018-01-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,6.250052539232863,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.8017526906474828,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.607167459943748,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.7488529744949677,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,16.325806709079423,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.742778333926285,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.593696323753099,"Current revenues plus indexation"]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.387567597857231,"Current revenues plus indexation"]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,41.77261773651108,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.623202111696152,"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.572650063642349,"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.197339934782658,"Current revenues plus indexation"]
["Forecast to asset transfer to OFTO",null,null,null,{"$f":"4672306/1000000","v":4.6723059999999998},34.474738535249827,"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":270.20460768097655},{"$f":"SUM(F6:F24)","v":318.14381186500032}," "]
[]
[]
["Notes:"]
["Figures for historic years represent National Grid's forecast of OFTO revenues at the time final tariffs were calculated for each charging year rather than our current best view."]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments are not included as they do not form part of OFTO Maximum Revenue"]