{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Report","Index","Residuals","T1","T2","T3","T4","T5","T6","T7","T8","T9","T10","T11","T12","T13 & Fig 1","T14","T15 & Fig 2","T16 & Fig 3","T17","T18","T19","T20","T21","T27","TEC changes","Sensitivities"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"Report","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Section","Written By"]
["Titles & Contents","MO"]
["1 Exec Summary","MO"]
["2 Tariff Summary","MO"]
["3 Introduction","MO"]
["4 Updates to the charging model for 2016/17","MO"]
["5 Forecast generation tariffs for 2016/17","MO"]
["6 Forecast demand tariffs for 2016/17","MO"]
["7 Sensitivitied and Uncertainties ","MO"]
["8 Tools & Supporting Information","MO"]
["Appendix A - Revenue Tables","MO"]
["Appendix B - Generation changes","MO"]
["Appendix C - Demand Changes","MO"]
["Appendix D - Generation Zones","MO"]
["Appendix E - Demand zones","MO"]

{"sheet":"Index","index":1,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,1,0]]}
["Index"]
[]
["Residuals"]
["Averages"]
[{"$f":"'T1'!A1","v":"Table 1 - Generation Wider Tariffs"}]
[{"$f":"'T2'!A1","v":"Table 2 - Local Substation Tariffs"}]
[{"$f":"'T3'!A1","v":"Table 3 - Local Circuit Tariffs"}]
[{"$f":"'T4'!A1","v":"Table 4 - Offshore Local Tariffs"}]
[{"$f":"'T5'!A1","v":"Table 5 - Demand Tariffs"}]
[{"$f":"'T6'!A1","v":"Table 6 - Contracted and Modelled TEC"}]
[{"$f":"'T7'!A1","v":"Table 7 - Allowed Revenues"}]
[{"$f":"'T8'!A1","v":"Table 8 - Charging Bases"}]
[{"$f":"'T9'!A1","v":"Table 9 - Interconectors"}]
[{"$f":"'T10'!A1","v":"Table 10 - Generation and Demand Revenue Proportions"}]
[{"$f":"'T11'!A1","v":"Table 11 - Residual Calculation"}]
[{"$f":"'T12'!A1:E1","v":"Table 12 - Small Generator Discount"}]
[{"$f":"'T13 & Fig 1'!A1","v":"Table 13 - Generation Tariff Changes"}]
[{"$f":"'T14'!A1","v":"Table 14 - Circuits subject to one-off charges"}]
[{"$f":"'T15 & Fig 2'!A1","v":"Table 15 - Change in HH Demand Tariffs"}]
[{"$f":"'T16 & Fig 3'!A1","v":"Table 16 - NHH Demand Tariff Changes"}]
[{"$f":"'T17'!A1","v":"Table 17 - National Grid Revenue Forecast"}]
[{"$f":"'T18'!A1","v":"Table 18 - SP Transmission Revenue Forecast"}]
[{"$f":"'T19'!A1","v":"Table 19 - SHE Transmission Revenue Forecast"}]
[{"$f":"'T20'!A1","v":"Table 20 - Offshore Revenues"}]
[{"$f":"'T21'!A1","v":"Table 21 - Demand Profiles"}]
[{"$f":"'T13 & Fig 1'!J1","v":"Figure 1 - Variation on Generation Zonal Tariffs"}]
[{"$f":"'T15 & Fig 2'!H1","v":"Figure 2 - HH Demand Tariffs"}]
[{"$f":"'T16 & Fig 3'!G1","v":"Figure 3 - NHH Demand Tariffs"}]

{"sheet":"Residuals","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Residual","2017/18\nInitial","2017/18\nJune","Change"]
["Generation",-0.92007661117652628,-2.090499571070501,{"$f":"C2-B2","v":-1.1704229598939748}]
["Demand",46.341958241214286,47.954886963010686,{"$f":"C3-B3","v":1.6129287217964006}]
[]
["Average Tariff","2017/18\nInitial","2017/18\nJune","Change"]
["Generation (£/kW)",6.6889568177618504,5.8236988163554857,{"$f":"C6-B6","v":-0.86525800140636466},null,"N.B. These generation average tariffs include local tariffs"]
["HH Demand (£/kW)",47.890868934752639,49.494416089327174,{"$f":"C7-B7","v":1.6035471545745352}]
["NHH Demand (p/kWh)",6.50238477582272,6.4911910405973172,-1.119373522540279E-2]

{"sheet":"T1","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,6,32,7],[32,2,32,4]]}
["Table 1 - Generation Wider Tariffs"]
[]
[null,null,"System Peak","Shared \nYear Round","Not Shared Year Round","Residual","Conventional 80%","Intermittent 40%"]
["Zone","Zone Name","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)","Tariff\n(£/kW)"]
[1,"North Scotland",-0.72179669297923965,12.458814972160027,16.238398939525137,-2.090499571070501,23.393154653203418,19.131425357318648]
[2,"East Aberdeenshire",0.49822687986273101,6.0881880627399152,16.23839893952514,-2.090499571070501,19.516676698509301,16.583174593550606]
[3,"Western Highlands",-0.72359941234923619,10.570364713361794,16.179169046050969,-2.090499571070501,21.821361833320665,18.316815360325187]
[4,"Skye and Lochalsh",-6.4352491499581328,10.570364713361794,15.886838752005694,-2.090499571070501,15.817381801666498,18.024485066279908]
[5,"Eastern Grampian and Tayside",-0.59851636634795591,10.062342254907918,15.972255127454554,-2.090499571070501,21.33311299396243,17.906692458347219]
[6,"Central Grampian",1.6897435328314239,10.971116142256783,16.553234273636679,-2.090499571070501,24.929371149203028,18.85118115946889]
[7,"Argyll",0.74865663731429999,8.5270796862187037,25.471210307979664,-2.090499571070501,30.951031123198426,26.791542611396643]
[8,"The Trossachs",1.1617564920080472,8.5270796862187037,14.879907256606954,-2.090499571070501,20.772827926519462,16.200239560023931]
[9,"Stirlingshire and Fife",-0.38029183066918582,3.5893540218131914,13.22420987724235,-2.090499571070501,13.624901692953218,12.569451914897126]
[10,"South West Scotlands",1.4722556965878455,7.1316139209510325,14.165326483460905,-2.090499571070501,19.252373745739074,14.927472480770819]
[11,"Lothian and Borders",2.6847720585315664,7.1316139209510325,8.5927455101147032,-2.090499571070501,14.892309134336594,9.3548915074246164]
[12,"Solway and Cheviot",0.48206993600299736,4.0678155466474246,7.6090494682878846,-2.090499571070501,9.2548722705383213,7.1456761158763538]
[13,"North East England",3.4066809951548129,2.5841997867073889,4.2631693127207262,-2.090499571070501,7.6467105661709507,3.2063496563331806]
[14,"North Lancashire and The Lakes",1.4018622093704782,2.5841997867073889,2.7253783215054725,-2.090499571070501,4.1041007891713619,1.6685586651179274]
[15,"South Lancashire, Yorkshire and Humber",4.2849266007421276,0.97572454051936175,2.9523422635866145E-3,-2.090499571070501,2.9779590043507027,-1.6972574125991697]
[16,"North Midlands and North Wales",3.6454362540763423,-0.5966884895172172,0,-2.090499571070501,1.0775858913920673,-2.329174966877388]
[17,"South Lincolnshire and North Norfolk",1.782871483472553,-2.6289651998220448E-2,0,-2.090499571070501,-0.32865980919652449,-2.1010154318697891]
[18,"Mid Wales and The Midlands",0.95803576496578968,0.20355883548973708,0,-2.090499571070501,-0.96961673771292167,-2.0090760368746063]
[19,"Anglesey and Snowdon",3.4645798632002811,-0.55024560777951548,0,-2.090499571070501,0.93388380590616782,-2.3105978141823074]
[20,"Pembrokeshire",8.5813763506749741,-4.2876104092751861,0,-2.090499571070501,3.0607884521843238,-3.8055437347805756]
[21,"South Wales & Gloucester",5.8293771170219042,-4.2343605696375715,0,-2.090499571070501,0.35138909024134568,-3.7842437989255298]
[22,"Cotswold",2.8862182358433346,1.84044224144736,-6.0492369938103536,-2.090499571070501,-3.7811645358796322,-7.4035596683019111]
[23,"Central London",-4.333559575959538,1.84044224144736,-5.4315426401668638,-2.090499571070501,-10.383247994039015,-6.7858653146584214]
[24,"Essex and Kent",-3.6644244652252658,1.84044224144736,0,-2.090499571070501,-4.2825702431378794,-1.3543226744915571]
[25,"Oxfordshire, Surrey and Sussex",-1.3110029456591858,-2.8222619522232417,0,-2.090499571070501,-5.6593120785082807,-3.2194043519597977]
[26,"Somerset and Wessex",-1.3710576161077808,-4.0830148531825694,0,-2.090499571070501,-6.7279690697243364,-3.7237055123435288]
[27,"West Devon and Cornwall",5.2849454228553333E-2,-5.4503139213677594,0,-2.090499571070501,-6.3979012539361548,-4.2706251396176054]
[]
[null,null,"Small Generation Discount (£/kW)",null,null,-11.466097]

{"sheet":"T2","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,3,1],[2,2,2,4],[0,0,0,4]]}
["Table 2 - Local Substation Tariffs"]
[]
["Substation Rating","Connection Type","Local Substation Tariff (£/kW)"]
[null,null,"132kV","275kV","400kV"]
["<1320 MW","No redundancy",0.18426300000000001,0.10541,7.5950000000000004E-2]
["<1320 MW","Redundancy",0.405916,0.25114300000000001,0.18265200000000001]
[">=1320 MW","No redundancy",null,0.330507,0.23902399999999999]
[">=1320 MW","Redundancy",null,0.54260900000000001,0.39605899999999999]

{"sheet":"T3","index":5,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table 3 - Local Circuit Tariffs"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",3.937092109153284,"Dinorwig",2.2063185013557534,"Kilmorack",0.1812514132432631]
["Aigas",0.60024080102261079,"Dunlaw Extension",5.4488152680804358,"Langage",0.60347502369155259]
["An Suidhe",2.8018539234655404,"Brochlock",1.9674397720910306,"Lochay",0.33584789441751073]
["Arecleoch",1.9066550520934917,"Dumnaglass",1.7039096239213118,"Luichart",0.52677961276469709]
["Baglan Bay",0.63941752581626754,"Edinbane",-6.277925141633701,"Mark Hill",0.80356171275520683]
["Beinneun Wind Farm",1.3789003147600873,"Earlshaugh Wind Farm",3.453708602809638,"Margree",3.3336777411008116]
["Bhlaraidh Wind Farm",0.59255410311249923,"Ewe Hill",1.261179341084036,"Marchwood",0.35115241747057707]
["Black Hill",1.1851082062249627,"Farr Windfarm",2.0386763153200724,"Millennium Wind ",1.6766020504493211]
["BlackCraig Wind Farm",3.5855636619139442,"Fallago",0.55155277794313418,"Moffat",0.15139817857243382]
["Black Law",1.6036736958436149,"Carraig Gheal",4.0370720395547961,"Mossford",2.6429532240951432]
["BlackLaw Extension",3.4007976530455903,"Ffestiniogg",0.23257947936133214,"Nant",2.3033494222175408]
["Bodelwyddan",0.10198467022757697,"Finlarig",0.29386690761532197,"Necton",-0.34558537056430044]
["Carrington",-3.1755287910246739E-2,"Foyers",0.69106307296947711,"Rhigos",6.7012137058025958E-2]
["Clyde (North)",0.10064813371883387,"Galawhistle",0.77672632435016775,"Rocksavage",1.6195674351113912E-2]
["Clyde (South)",0.11639469657484547,"Glendoe",1.68814792000787,"Saltend",0.31240543154438316]
["Corriegarth",3.4590563726260606,"Ulziside",9.6202067989249471,"South Humber Bank",0.87597950893045617]
["Corriemoillie",1.5273657347020577,"Gordonbush",1.0801598234349554,"Spalding",0.25275819805467381]
["Coryton",5.1732149726288909E-2,"Griffin Wind",-0.87350929670802502,"Kilbraur",0.71735668051233326]
["Cruachan",1.6802210390014751,"Hadyard Hill",2.5402681477530802,"Stronelairg",3.3459372054368788]
["Crystal Rig",0.47153699484517847,"Harestanes",2.2966266041642842,"Strathy Wind",2.3981869381828602]
["Culligran",1.5906522024866621,"Hartlepool",0.55023530889531158,"West of Duddon",0.78382902216122552]
["Deanie",2.6132143326566593,"Hedon",0.16612829453899625,"Whitelee",9.7401419727903782E-2]
["Dersalloch",2.2107149618779083,"Invergarry",1.3023607558329315,"Whitelee Extension",0.27077594684357259]
["Didcot",0.47484131163241083,"Kilgallioch",0.96589741230171333]

{"sheet":"T4","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3],[0,0,0,3]]}
["Table 4 - Offshore Local Tariffs"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",7.4252190000000002,38.848737999999997,0.96466700000000005]
["Greater Gabbard",13.921412,31.990036,0]
["Gunfleet",16.069779,14.753316,2.7574800000000002]
["Gwynt Y Mor",16.954052999999998,16.701837000000001,0]
["Lincs",13.876504000000001,54.329683000000003,0]
["London Array",9.4460999999999995,32.172891,0]
["Ormonde",22.954789000000002,42.762622,0.34078199999999997]
["Robin Rigg East",{"$f":"+B13","v":-0.42463299999999998},{"$f":"+C13","v":28.128278000000002},{"$f":"+D13","v":8.7182480000000009}]
["Robin Rigg West",-0.42463299999999998,28.128278000000002,8.7182480000000009]
["Sheringham Shoal",22.178305000000002,26.009955999999999,0.56537999999999999]
["Thanet",16.889585,31.471333999999999,0.75762600000000002]
["Walney 1",19.811070999999998,39.453696999999998,0]
["Walney 2",19.666990999999999,39.801285999999998,0]
["West of Duddon Sands",7.6445509999999999,37.721124000000003,0]
["Westermost Rough",16.096855999999999,27.228992999999999,0]

{"sheet":"T5","index":7,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 5 - Demand Tariffs"]
[]
["Zone","Zone Name","HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)"]
[1,"Northern Scotland",30.953593482907355,5.2518317125913017]
[2,"Southern Scotland",30.879715036828944,4.9390419453113719]
[3,"Northern",39.401676170665581,5.7937325651863159]
[4,"North West",45.471604886755514,6.2016787937198057]
[5,"Yorkshire",45.330331226926731,6.0845816235931363]
[6,"N Wales & Mersey",47.198854270874641,7.1109987066058844]
[7,"East Midlands",48.575162166429081,6.726673732352654]
[8,"Midlands",50.036516021259331,6.6665239671324485]
[9,"Eastern",50.502771431563353,7.1054862235037808]
[10,"South Wales",47.165954452155596,6.2265817723918069]
[11,"South East",53.474869495240128,6.9869786806549747]
[12,"London",55.95345714605147,7.1796526664391669]
[13,"Southern",54.45443949229842,7.040039368494015]
[14,"South Western",53.046573152982049,7.0590627154095298]

{"sheet":"T6","index":8,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 6 - Contracted and Modelled TEC"]
[]
["(GW)","2016/17","2017/18 Initial forecast","2017/18 June Forecast","2017/18 Oct Forecast","2017/18 Draft Tariffs","2017/18 Final Tariffs"]
["Contracted TEC",69.864960000000025,73.442160000000001,73.092760000000013]
["Modelled Best ViewTEC",69.864960000000025,71.094860000000011,73.796860000000009]

{"sheet":"T7","index":9,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table 7 - Allowed Revenues"]
[]
["£m Nominal Value","2016/17 TNUoS Revenue","2017/18 TNUoS Revenue"]
[null,"Jan\n2016\nFinal","Feb 2016 Initial View","June\n2016\nUpdate","Oct\n2016\nUpdate","Dec\n2016\nDraft","Jan\n2017\nFinal"]
["National Grid"]
["Price controlled revenue",1828.226522736536,1806.4483388119306,1811.2148374453482]
["Less income from connections",42.677043259999913,46.497111164726796,46.497111164726796]
["Income from TNUoS",1785.5494794765361,1759.9512276472037,1764.7177262806213]
[]
["Scottish Power Transmission"]
["Price controlled revenue",306.44,347.0504075235109,340.96570436581135]
["Less income from connections",11.815999999999999,13.912225705329153,13.971352117110026]
["Income from TNUoS",294.62400000000002,333.13818181818175,326.99435224870132]
[]
["SHE Transmission"]
["Price controlled revenue",326.21699999999998,328.51298433523431,327.28222789968652]
["Less income from connections",3.38,3.5890318138156485,3.5890421108737836]
["Income from TNUoS",322.83699999999999,324.92395252141864,323.69318578881274]
[]
["Offshore",260.78931257200446,276.50285638096329,279.2352440078846]
["Network Innovation Competition",44.854879889999999,40.5,40.5]
["Total to Collect from TNUoS",2708.6546719385406,2735.0162183677671,2735.1405083260197]

{"sheet":"T8","index":10,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Table 8 - Charging Bases"]
[]
["Charging Base","2016/17","2017/18\nInitial","2017/18\nJune"]
["Generation (GW)",62.858859999999993,67.255003526274592,67.011859999999999]
["Total Average Triad (GW)",49.8,49.29773805707633,49.100817995910035]
["HH Demand Average Triad (GW)",13.100500000000002,16.299869488936366,16.407205107314489]
["NHH Demand (4pm-7pm TWh)",26.146824999999996,23.138210710754318,23.613824691598762]

{"sheet":"T9","index":11,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Table 9 - Interconectors"]
[]
["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":"T10","index":12,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 10 - Generation and Demand Revenue Proportions"]
[]
[null,null,"2016/17","2017/18\nInitial","2017/18\nJune"]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5]
["y","Error Margin",8.2000000000000003E-2,8.2000000000000003E-2,0.21]
["ER","Exchange Rate (€/£)",1.36,1.34,1.27]
["MAR","Total Revenue (£m)",2708.6533514282437,2735.0162183677676,2735.1403989315527]
["GO","Gerneration Output (TWh)",268.69725000000011,262.66674999999998,250.95]
["G","% of revenue from generation",0.16739927578252611,{"$f":"D8*D4*(1-D5)/(D7*D6)","v":0.16448378307392536},{"$f":"E8*E4*(1-E5)/(E7*E6)","v":0.14268258035902959}]
["D","% of revenue from demand",0.83260072421747389,{"$f":"1-D9","v":0.83551621692607458},{"$f":"1-E9","v":0.85731741964097041}]
["G.R","Revenue recovered from generation (£m)",453.42660937500017,{"$f":"D9*D7","v":449.86581436567155},{"$f":"E9*E7","v":390.2568897637795}]
["D.R","Revenue recovered from demand (£m)",2255.2267420532435,{"$f":"D7*D10","v":2285.1504040020959},{"$f":"E7*E10","v":2344.8835091677734}]

{"sheet":"T11","index":13,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 11 - Residual Calculation"]
[]
[null,null,"2016/17","2017/18\nInitial","2017/18\nJune"]
["RG","Generator residual tariff (£/kW)",0.50578063824885944,{"$f":"((D8*D6)-D9-D11-D12-D13)/D14","v":0.83481411549438267},{"$f":"((E8*E6)-E9-E11-E12-E13)/E14","v":-2.0904993381462877}]
["RD","Demand residual tariff (£/kW)",45.333847850551464,{"$f":"((D8*D7)-D10)/D15","v":46.341958241214279},{"$f":"((E8*E7)-E10)/E15","v":47.954888873076264}]
["G","Proportion of revenue recovered from generation (%)",0.16739927578252611,{"$f":"'T10'!D9","v":0.16448378307392536},{"$f":"'T10'!E9","v":0.14268258035902959}]
["D","Proportion of revenue recovered from demand (%)",0.83260072421747389,{"$f":"'T10'!D10","v":0.83551621692607458},{"$f":"'T10'!E10","v":0.85731741964097041}]
["R","Total TNUoS revenue (£m)",2708.6546719385406,{"$f":"'T7'!C22","v":2735.0162183677671},{"$f":"'T7'!D22","v":2735.1405083260197}]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",191.88636666772777,148.22709476618877,275.30150470116303]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",-2.3977814463896263,0.59668557474437911,-9.7406676174531022]
["O","Revenue recovered from offshore local tariffs (£m)",200.57615206540871,212.90719941334174,223.38819520630764]
["LG","Revenue recovered from onshore local substation tariffs (£m)",15.916481994840002,17.03258027998001,17.611586890639998]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",13.255035369095392,15.553513624802466,14.043867552305372]
["BG","Generator charging base (GW)",62.858859999999993,67.255003526274592,{"$f":"+'T8'!D4","v":67.011859999999999}]
["BD","Demand charging base (GW)",49.8,49.29773805707633,{"$f":"+'T8'!D5","v":49.100817995910035}]

{"sheet":"T12","index":14,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,4],[2,0,2,2]]}
["Table 12 - Small Generator Discount"]
[]
["Small Generator Discount Calculation"]
["Generator Residual (£/kW)","G",-2.090499571070501]
["Demand Residual (£/kW)","D",47.954886963010686]
["Small Generator Discount (£/kW)","T = (G + D)/4",11.466097]
["Forecast Small Generator Volume (kW)","V",2641010.0000000005]
[" 2017/18 SGD cost (£)","V x T",{"$f":"+C7*C6","v":30282076.837970003}]
["Prior year reconcilation (£)","R",0]
["Total SGD Cost (£)","C = (V x T) + R",{"$f":"C8+C9","v":30282076.837970003}]
["Total System Triad Demand (kW)","TD",{"$f":"+'T8'!D5*1000000","v":49100817.995910034}]
["Total HH Triad Demand (kW)","HHD",{"$f":"+'T8'!D6*1000000","v":16407205.10731449}]
["Total NHH Consumption (kWh)","NHHD",{"$f":"+'T8'!D7*1000000000","v":23613824691.598763}]
["Increase in HH Demand tariff (£/kW)","HHT = C/TD",{"$f":"+C10/C11","v":0.6167326344846723}]
["Total Cost to HH Customers (£)","HHC = HHT * HHD",{"$f":"+C14*C12","v":10118858.830364436}]
["Increase in NHH Demand tariff (p/kWh)","NHHT = (C - HHC)/NHHD",{"$f":"100*(+C10-(+C14*C12))/(C13)","v":8.5387345213836369E-2}]
["Total Cost to NHH Customers (£)","NHHC = NHHT * NHHD",{"$f":"(+C16*C13)/100","v":20163218.007605568}]

{"sheet":"T13 & Fig 1","index":15,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[3,0,3,8],[4,2,4,4],[4,5,4,7],[4,8,5,8],[0,0,0,7]]}
["Table 13 - Generation Tariff Changes",null,null,null,null,null,null,null,null,"Figure 1 - Variation on Generation Zonal Tariffs"]
[]
[]
["Wider Generation Tariffs (£/kW)"]
[null,null,"Conventional 80%",null,null,"Intermittent 40%",null,null,"Change in Residual (£/kW)"]
["Zone","Zone Name","2017/18 Initial Forecast (£/kW)","2017/18 \nJune Forecast (£/kW)","Change (£/kW)","2017/18 Initial Forecast (£/kW)","2017/18 \nJune Forecast (£/kW)","Change (£/kW)"]
[1,"North Scotland",24.62042785896524,23.393154653203418,{"$f":"D7-C7","v":-1.2272732057618221},20.659494910327851,19.131425357318648,{"$f":"G7-F7","v":-1.5280695530092032},{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[2,"East Aberdeenshire",20.384153010106786,19.516676698509301,-0.86747631159748551,17.961856590774914,16.583174593550606,-1.3786819972243087,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[3,"Western Highlands",22.586858554750535,21.821361833320665,-0.76549672142986935,19.57956991479924,18.316815360325187,-1.2627545544740535,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[4,"Skye and Lochalsh",19.975510061706469,15.817381801666498,-4.1581282600399714,20.984030930392461,18.024485066279908,-2.9595458641125525,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[5,"Eastern Grampian and Tayside",21.145906283504011,21.33311299396243,0.18720671045841897,18.749072934363721,17.906692458347219,-0.84238047601650123,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[6,"Central Grampian",24.177828998302559,24.929371149203028,0.75154215090046961,19.658066779471728,18.85118115946889,-0.80688562000283781,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[7,"Argyll",29.644480966975465,30.951031123198426,1.3065501562229613,27.306878466640974,26.791542611396643,-0.51533585524433079,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[8,"The Trossachs",19.841940755391061,20.772827926519462,0.93088717112840058,16.88142919405216,16.200239560023931,-0.68118963402822885,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[9,"Stirlingshire and Fife",13.943902789202591,13.624901692953218,-0.31900109624937301,13.356881737202354,12.569451914897126,-0.78742982230522784,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[10,"South West Scotlands",18.577821948950316,19.252373745739074,0.67455179678875865,15.655931351002636,14.927472480770819,-0.7284588702318171,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[11,"Lothian and Borders",15.233746607053163,14.892309134336594,-0.34143747271656899,10.341516434060374,9.3548915074246164,-0.9866249266357574,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[12,"Solway and Cheviot",10.452524510124498,9.2548722705383213,-1.1976522395861764,8.3390433651337261,7.1456761158763538,-1.1933672492573724,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[13,"North East England",8.1301322954846107,7.6467105661709507,-0.48342172931366001,4.37192834793907,3.2063496563331806,-1.1655786916058894,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[14,"North Lancashire and The Lakes",5.0360220784850114,4.1041007891713619,-0.93192128931364948,2.6797874312230712,1.6685586651179274,-1.0112287661051438,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[15,"South Lancashire, Yorkshire and Humber",3.9538111805373841,2.9779590043507027,-0.97585217618668141,-0.30686679647036008,-1.6972574125991697,-1.3903906161288098,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[16,"North Midlands and North Wales",2.0396549328858562,1.0775858913920673,-0.96206904149378891,-1.2082817102105814,-2.329174966877388,-1.1208932566668066,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[17,"South Lincolnshire and North Norfolk",0.56997225541586871,-0.32865980919652449,-0.8986320646123932,-0.65818380717076563,-2.1010154318697891,-1.4428316246990236,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[18,"Mid Wales and The Midlands",0.13518524053140368,-0.96961673771292167,-1.1048019782443252,-0.99465030056175874,-2.0090760368746063,-1.0144257363128477,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[19,"Anglesey and Snowdon",3.0129602310269634,0.93388380590616782,-2.0790764251207956,-1.5566993517266687,-2.3105978141823074,-0.75389846245563863,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[20,"Pembrokeshire",4.3145226535000774,3.0607884521843238,-1.2537342013157535,-2.8105709430468493,-3.8055437347805756,-0.99497279173372632,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[21,"South Wales & Gloucester",1.6273569250467297,0.35138909024134568,-1.275967834805384,-2.7865059668048624,-3.7842437989255298,-0.99773783212066736,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[22,"Cotswold",-2.5182929268065974,-3.7811645358796322,-1.2628716090730348,-6.4232439467199534,-7.4035596683019111,-0.98031572158195779,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[23,"Central London",-8.7933409109094303,-10.383247994039015,-1.5899070831295852,-6.6560878275478004,-6.7858653146584214,-0.12977748711062098,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[24,"Essex and Kent",-3.1292451822740124,-4.2825702431378794,-1.153325060863867,-0.34816951047977585,-1.3543226744915571,-1.0061531640117813,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[25,"Oxfordshire, Surrey and Sussex",-4.4583174590160235,-5.6593120785082807,-1.2009946194922572,-2.2275151942761386,-3.2194043519597977,-0.99188915768365904,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[26,"Somerset and Wessex",-5.4893929602466773,-6.7279690697243364,-1.2385761094776591,-2.7345900721946119,-3.7237055123435288,-0.98911544014891684,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]
[27,"West Devon and Cornwall",-5.1556652999777004,-6.3979012539361548,-1.2422359539584544,-3.282213662128298,-4.2706251396176054,-0.98841147748930736,{"$f":"+Residuals!$D$2","v":-1.1704229598939748}]

{"sheet":"T14","index":16,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table 14 - Circuits subject to one-off charges"]
[]
["Node 1","Node 2","Actual Parameters","Amendment in Transport Model","Generator"]
["Wishaw 132kV","Blacklaw 132kV","11.46km of Cable","11.46km of OHL","Blacklaw"]
["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"]
["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"]
["Crystal Rig 132kV","Western Dod 132kV","3.9km of Cable","3.9km of OHL","Aikengall II"]
["Farigaig 132kV","Dunmaglass 132kV","4km Cable","4km OHL","Dunmaglass"]
["Coalburn 132kV","Galawhistle 132kV","9.7km cable","9.7km OHL","Galawhistle II"]
["Melgarve 132kV","Stronelairg 132kV","10km cable","10km OHL","Stronelairg"]
["Moffat 132kV","Harestanes 132kV","15.33km cable","15.33km OHL","Harestanes"]

{"sheet":"T15 & Fig 2","index":17,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 15 - Change in HH Demand Tariffs",null,null,null,null,null,null,"Figure 2 - HH Demand Tariffs"]
[]
["Zone","Zone Name","2017/18\n Initial\n (£/kW)","2017/18\nJune\n(£/kW)","Change (£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",29.732283042744395,30.953593482907355,{"$f":"D4-C4","v":1.2213104401629593},{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[2,"Southern Scotland",30.445840984074543,30.879715036828944,0.43387405275440116,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[3,"Northern",38.161188547144128,39.401676170665581,1.240487623521453,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[4,"North West",43.592571905836728,45.471604886755514,1.8790329809187867,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[5,"Yorkshire",44.125537501520959,45.330331226926731,1.2047937254057715,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[6,"N Wales & Mersey",45.49839324410263,47.198854270874641,1.7004610267720111,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[7,"East Midlands",47.006707995116813,48.575162166429081,1.5684541713122684,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[8,"Midlands",48.259354721225741,50.036516021259331,1.7771613000335904,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[9,"Eastern",49.023110184099416,50.502771431563353,1.4796612474639375,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[10,"South Wales",45.437360023526118,47.165954452155596,1.7285944286294779,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[11,"South East",51.8299125376737,53.474869495240128,1.6449569575664285,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[12,"London",54.371266954713413,55.95345714605147,1.5821901913380572,{"$f":"Residuals!$D$3","v":1.6129287217964006}]
[13,"Southern",52.832371449332278,54.45443949229842,1.6220680429661414,{"$f":"Residuals!$D$3","v":1.6129287217964006},null,"Table 14"]
[14,"South Western",51.428793397632546,53.046573152982049,1.6177797553495026,{"$f":"Residuals!$D$3","v":1.6129287217964006}]

{"sheet":"T16 & Fig 3","index":18,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table 16 - NHH Demand Tariff Changes",null,null,null,null,null,"Figure 3 - NHH Demand Tariffs"]
[]
["Zone","Zone Name","2017/18\n Initial\n (p/kWh)","2017/18\nJune\n(p/kWh)","Change (p/kWh)"]
[1,"Northern Scotland",4.3268774818189106,5.2518317125913017,{"$f":"D4-C4","v":0.92495423077239103},null,0]
[2,"Southern Scotland",4.8655300411852602,4.9390419453113719,{"$f":"D5-C5","v":7.3511904126111638E-2}]
[3,"Northern",6.2210152239424987,5.7937325651863159,-0.42728265875618288]
[4,"North West",5.8531042562528066,6.2016787937198057,0.34857453746699907]
[5,"Yorkshire",6.9624477947950192,6.0845816235931363,-0.87786617120188293]
[6,"N Wales & Mersey",7.087821133282544,7.1109987066058844,2.3177573323340361E-2]
[7,"East Midlands",6.8117232238799881,6.726673732352654,-8.5049491527334098E-2]
[8,"Midlands",6.8055263430182285,6.6665239671324485,-0.13900237588577991]
[9,"Eastern",6.7855995276422512,7.1054862235037808,0.31988669586152962]
[10,"South Wales",6.9895892959040662,6.2265817723918069,-0.76300752351225931]
[11,"South East",7.070112443802727,6.9869786806549747,-8.3133763147752227E-2]
[12,"London",6.7791260364879209,7.1796526664391669,0.40052662995124599]
[13,"Southern",6.8664467972647554,7.040039368494015,0.17359257122925964]
[14,"South Western",7.4053071412025275,7.0590627154095298,-0.34624442579299775]

{"sheet":"T17","index":19,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,5],[3,7,4,7]]}
["Table 17 - National Grid Revenue Forecast"]
[]
[null,null,null,"2016-06-01",null,null,null," "]
["Description"," ","Licence\nTerm","Yr t-1","Yr t","Yr t+1",null,"Notes"]
["Regulatory Year"," "," ","2014/15","2015/16","2016/17","2017/18"]
["Actual RPI"," "," ",256.66666666666669," "," "," ","April to March average"]
["RPI Actual"," ","RPIAt",1.19," "," "," ","Office of National Statistics"]
["Assumed Interest Rate"," ","It",5.0000000000000001E-3,7.000000000000001E-3,0.95000000000000007,1.575E-2,"Bank of England Base Rate"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1443.829,1475.5930000000001,1571.3869999999999,1554.942,"From Licence"]
["Price Control Financial Model Iteration Adjustment","A2","MODt",-5.5,-114.4,-185.4,-210,"Determined by Ofgem/Licensee forecast"]
["RPI True Up","A3","TRUt",-0.52728791368496775,4.7019113011489599,-19.921431381693402,-31.404964728930214,"Licensee Actual/Forecast"]
["Prior Calendar Year RPI Forecast"," ","GRPIFc-1",3.1E-2,2.5000000000000001E-2,0.01,2.1000000000000001E-2,"HM Treasury Forecast then 2.8%"]
["Current Calendar Year RPI Forecast"," ","GRPIFc",3.1E-2,2.4E-2,2.1000000000000001E-2,0.03,"HM Treasury Forecast then 2.8%"]
["Next Calendar Year RPI forecast"," ","GRPIFc+1",0.03,3.2000000000000001E-2,0.03,3.3000000000000002E-2,"HM Treasury Forecast then 2.8%"]
["RPI Forecast","A4","RPIFt",1.2051000000000001,1.2266528212575316,1.2330000000000001,1.268,"Using HM Treasury Forecast"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",1732.6948432352185,1675.4788464888604,1684.3588461063721,1665.5649607237165]
["Pass-Through Business Rates","B1","RBt"," ",1.2353308097829103,1.5001179260431783,2.6830799018330405,"Licensee Actual/Forecast"]
["Temporary Physical Disconnection","B2","TPDt",0.14395339862662926,1.2337689401095423E-2,9.0478361183892381E-2,0,"Licensee Actual/Forecast"]
["Licence Fee","B3","LFt"," ",2.0207027597467815,2.6933961403912292,3.1801712156619737,"Licensee Actual/Forecast"]
["Inter TSO Compensation","B4","ITCt"," ",3.8222435083326589,2.6745437559665044,0.4974462323857759,"Licensee Actual/Forecast"]
["Termination of Bilateral Connection Agreements","B5","TERMt",0,0,0,0,"Does not affect TNUoS"]
["SP Transmission Pass-Through","B6","TSPt",312.179148,295.664557,294.62336299999998,326.99435224870132,"14/15 & 15/16 & 16/17  Charge setting. Later from TSP Calculation."]
["SHE Transmission Pass-Through","B7","TSHt",213.95951766583201,338.20730217321301,322.83631648970299,323.69318578881274,"14/15 & 15/16 & 16/17  Charge setting. Later from TSH Calculation."]
["Offshore Transmission Pass-Through","B8","TOFTOt",218.38037349491276,248.35699921993759,260.78931257200446,279.2352440078846,"14/15 & 15/16 & 16/17  Charge setting. Later from OFTO Calculation."]
["Embedded Offshore Pass-Through","B9","OFETt",0.43733608355648018,0.64941914461921546,0.6544976173613446,0.65734985711148086,"Licensee Actual/Forecast"]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9]","B","PTt",745.10032864292793,889.96889230503325,885.86202586265358,936.94082925239104," "]
["Reliability Incentive Adjustment","C1","RIt"," ",2.3615637797660018,3.920644330261553,4.0285564655836907,"Licensee Actual/Forecast/Budget"]
["Stakeholder Satisfaction Adjustment","C2","SSOt"," ",8.6930597323224994,10.123488255861568,8.6278923124605527,"Licensee Actual/Forecast/Budget"]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt"," ",2.8092019735619482,2.6616746854357087,3.0438046831243004,"Licensee Actual/Forecast/Budget"]
["Awarded Environmental Discretionary Rewards","C4","EDRt"," ",0,2.0215574999999997,0,"Only includes EDR awarded to licensee to date"]
["Outputs Incentive Revenue [C=C1+C2+C3+C4]","C","OIPt",0,13.863825485650448,18.727364771558829,15.700253461168543," "]
["Network Innovation Allowance","D","NIAt",10.915977512381877,10.555516732879822,10.611460730470144,10.493059252559414,"Licensee Actual/Forecast/Budget"]
["Network Innovation Competition","E","NICFt",17.849214,18.760655919999998,44.854879889999999,40.5,"Sum of NICF awards determined by Ofgem/Forecast by National Grid"]
["Future Environmental Discretionary Rewards","F","EDRt"," "," ",0,2,"Sum of future EDR awards forecast by National Grid"]
["Transmission Investment for Renewable Generation","G","TIRGt",15.997326508799999,15.699016829576131,0,0,"Licensee Actual/Forecast"]
["Scottish Site Specific Adjustment","H","DISt",1.9849141507976036,0.79100000000000004,2.8649227140000022,4.8957006300000003,"Licensee Actual/Forecast"]
["Scottish Terminations Adjustment","I","TSt",-0.28187454000000001,0.10154699999999994,7.2928609999999949E-2,0,"Licensee Actual/Forecast"]
["Correction Factor","K","-Kt"," ",56.423778228050232,103.97796600318905,105.54281617091144,"Calculated by Licensee"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",2524.2607295101257,2681.6430789900505,2751.3303946882438,2781.6376194907471," "]
["Termination Charges","B5"," ",0,0,0,0," "]
["Pre-vesting connection charges","P"," ",46.954162359999998,44.955204119999998,42.677043259999913,46.497111164726796,"Licensee Actual/Forecast"]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",2477.3065671501258,2636.6878748700506,2708.6533514282437,2735.1405083260202," "]
["Final Collected Revenue","U","TNRt",2375.85249526493," "," "," ","Licensee Actual/Forecast"]
["Forecast percentage change to Maximum Revenue M"," "," ",0,6.2347897600287805E-2,2.5986797513873006E-2,1.1015479951449914E-2," "]
["Forecast percentage change to TNUoS Collected Revenue T"," "," ",0,6.4336529775269602E-2,2.7293892934422415E-2,9.778717857643171E-3," "]
[]
["Notes:"]
["All monies are  nominal 'money of the day' prices unless stated otherwise"]
["Licensee forecasts and budgets are subject to change especially where they are influenced by external stakeholders"]
["Greyed out cells are either calculated or not applicable in the year concerned due to the way the licence formula are constructed"]
["NIC payments to all Transmission Owners are inlcuded in National Grid Maximum Revenue and are included here"]
["2014/15 and 2015/16 pass through to other networks is based on forecast at time of tariff setting"]

{"sheet":"T18","index":20,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[3,7,4,7],[44,0,44,4],[47,0,47,4],[49,0,49,4],[2,0,2,2],[3,0,4,0],[3,1,4,1],[3,2,4,2],[2,4,2,5]]}
["Table 18 - SP Transmission Revenue Forecast"]
[]
["Scottish Power Transmission Revenue Forecast",null,null,"Updated:","2016-04-07",null,null," "]
["Description"," ","Licence Term","Yr t-1","Yr t","Yr t+1",null,"Notes"]
[null,null,null,"2014/15","2015/16","2016/17"]
["Actual RPI"," "," ",256.66699999999997," ",0,null,"April to March average"]
["RPI Actual"," ","RPIAt",1.19," ",0,null,"Office of National Statistics"]
["Assumed Interest Rate"," ","It",5.0000000000000001E-3,6.2500000000000003E-3,1.125E-2,1.6749999999999998E-2,"National Grid forecast"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",236.95,258.63299999999998,244.655,249.43899999999999]
["Price Control Financial Model Iteration Adjustment","A2","MODt",6.2,-20.3,-21.8,-4.5]
["RPI True Up","A3","TRUt",-0.1,0.84699999999999998,-3.85,-5.08]
["RPI Forecast","A4","RPIFt",1.2051000000000001,1.2265999999999999,1.2326999999999999,1.2706,"National Grid forecast"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",292.89955500000002,293.37818799999997,269.96746349999995,304.76484539999996," "]
["Pass-Through Business Rates","B1","RBt",0,-20.239999999999998,-4.5,-4.8]
["Temporary Physical Disconnection","B2","TPDt",0,0,0,0]
["Pass-Through Items [B=B1+B2]","B","PTt",0,-20.239999999999998,-4.5,-4.8," "]
["Reliability Incentive Adjustment","C1","RIt",0,2.555035067661843,3,1.2]
["Stakeholder Satisfaction Adjustment","C2","SSOt",0,1.6969034799326455,2.1,0.6]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt",0,-0.16302970986967097,0.1,0]
["Awarded Environmental Discretionary Rewards","C4","EDRt",0,0,0,0.7]
["Financial Incentive for Timely Connections Output","C5","-CONADJt",0,-5.5309761405888044E-2,0,0]
["Outputs Incentive Revenue [C=C1+C2+C3+C4+C5]","C","OIPt",0,4.0335990763189287,5.1999999999999993,2.5," "]
["Network Innovation Allowance","D","NIAt",0.7,1,1,1]
["Transmission Investment for Renewable Generation","G","TIRGt",32.161593499255119,38.090000000000003,31.7,33]
["Correction Factor","K","-Kt",0,-4.9400000000000004,3,5.2]
["Maximum Revenue (M= A+B+C+D+G+J+K]","M","TOt",325.76114849925511,311.32178707631891,306.44,341.66484539999993," "]
["Excluded Services","P","EXCt",7.6999999999999993,8,9.4,11.8,"Post BETTA Connection Charges"]
["Site Specifc Charges","S","EXSt",18.5,18.8,21.8,25.8,"Pre & Post BETTA Connection Charges"]
["TNUoS Collected Revenue (T=M+P-S)","T","TSPt",314.9611484992551,300.5217870763189,294.03999999999996,327.66484539999993,"General System Charge"]
["Final Collected Revenue","U","TNRt",312.2,295.60000000000002,293.96746349999989]
["Forecast percentage change to TNUoS Collected Revenue T"," "," ",0,-4.5844897034880927E-2,-2.156844313811046E-2,0.11435466399129357," "]
[]
["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 are not included as they do not form part of SPT Maximum Revenue"]
[]
["Commentary"]
["All reasonable care has been taken in the preparation of these illustrative tables and the data therein.  SPT offers this data without prejudice and cannot be held responsible for any loss that might be attributed to the use of this data.  SPT does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
["The base revenue forecasts for the RIIO-ET1 period (2014/15 to 2018/19, inclusive) reflect the figures authorised by Ofgem in the the RIIO-ET1 Final Proposals.  "]
["Within the bounds of commercial confidentiality, this forecast provides as much information as possible."]
[]
["This forecast contains as much information as can be currently made available.  Generally, allowances determined by Ofgem are shown; and we also include forecasts for anticipated future Ofgem determinations in respect of the Iteration adjustment reflecting our latest view of totex, changes to allowed totex and cost of debt."]
["This respects commercial confidentiality and disclosure considerations."]
[]
["Note that actual revenues may vary from those currently forecast.  "]
[]
["All £ figures are in money of the day"]
[]
["Information provided in £m to one decimal place"]
[]
["Assumptions"]
["It is assumed that there will be one set of price changes per year effective on 1st April."]

{"sheet":"T19","index":21,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,0,2,2],[3,0,4,0],[3,1,4,1],[3,2,4,2],[2,4,2,5],[3,7,4,7],[42,0,42,5],[45,0,45,5],[48,0,48,5],[50,0,50,5]]}
["Table 19 - SHE Transmission Revenue Forecast"]
[]
["SHE Transmission Revenue Forecast",null,null,"Updated:","2016-02-29",null,null," "]
["Description"," ","Licence Term","Yr t-1","Yr t","Yr t+1",null,"Notes"]
[null,null,null,"2014/15","2015/16","2016/17","2017/18"]
["Actual RPI"," "," ",256.66666666666669," ",0,null,"April to March average"]
["RPI Actual"," ","RPIAt",1.19," ",0,null,"Office of National Statistics"]
["Assumed Interest Rate"," ","It",5.0000000000000001E-3,6.2500000000000003E-3,1.125E-2,1.6749999999999998E-2,"National Grid forecast"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",111.515,124.139,123.63500000000001,119.59699999999999,"From Licence"]
["Price Control Financial Model Iteration Adjustment","A2","MODt",8.6999999999999993,85.2,87.611999999999995,84.8]
["RPI True Up","A3","TRUt",-2E-3,0.52200000000000002,-2.5649999999999999,-6.4219999999999997]
["RPI Forecast","A4","RPIFt",1.2050819527256253,1.2266493019576674,1.2327329838381795,1.276,"16/17 RPIF amended to reflect 16/17 Charge Setting, National Grid forecast from 17/18 onwards"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",144.86651678300561,257.42584915813802,257.24918453331901,252.61609999999999," "]
["Pass-Through Business Rates","B1","RBt",0,-0.69699999999999995,-15.968999999999999,-8.5589999999999993]
["Temporary Physical Disconnection","B2","TPDt",0,0.55500000000000005,0.13200000000000001,0.13500000000000001]
["Pass-Through Items [B=B1+B2]","B","PTt",0,-0.1419999999999999,-15.837,-8.4239999999999995," "]
["Reliability Incentive Adjustment","C1","RIt"," ",1.1779999999999999,0.189,0.69]
["Stakeholder Satisfaction Adjustment","C2","SSOt"," ",1.605,2.2850000000000001,3.226]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt"," ",-0.27100000000000002,-0.17199999999999999,-0.182]
["Awarded Environmental Discretionary Rewards","C4","EDRt"," ",0,0,0]
["Financial Incentive for Timely Connections Output","C5","-CONADJt"," ",0,0,0]
["Outputs Incentive Revenue [C=C1+C2+C3+C4+C5]","C","OIPt",0,2.512,2.302,3.734," "]
["Network Innovation Allowance","D","NIAt",1.2569999999999999,1.6739999999999999,1.6739999999999999,1.6739999999999999]
["Transmission Investment for Renewable Generation","G","TIRGt",72.197999999999993,81.260999999999996,79.887,79.747]
["Compensatory Payments Adjustment","J","SHCPt",0,0.39800000000000002,0,0]
["Correction Factor","K","-Kt"," ",-1.6679999999999999,0.94199999999999995,0]
["Maximum Revenue (M= A+B+C+D+G+J+K]","M","TOt",218.32151678300562,341.46084915813799,326.21699999999998,329.34710000000001," "]
["Excluded Services","P","EXCt",0,0,0,0,"Post BETTA Connection Charges"]
["Site Specifc Charges","S","EXSt",3.4649999999999999,3.472,3.4892197085633421,3.6116859096805585,"Post-Vesting, Pre-BETTA Connection Charges"]
["TNUoS Collected Revenue (T=M+P-S)","T","TSHt",214.85651678300562,337.98884915813801,322.72778029143666,325.73541409031947,"General System Charge"]
["Final Collected Revenue","U","TNRt",217.42500000000001,0,0,0]
["Forecast percentage change to TNUoS Collected Revenue T"," "," ",0,0.57309098285108062,-4.5152034960307397E-2,9.3188368947105804E-3," "]
[]
["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 are not included as they do not form part of SHET Maximum Revenue"]
[]
["Commentary"]
["All reasonable care has been taken in the preparation of these illustrative tables and the data therein.  SHET offers these data without prejudice and cannot be held responsible for any loss that might be attributed to the use of these data.  SHET does not accept or assume responsibility for the use of this information by any person or any person to whom this information is shown or any person to whom this information otherwise becomes available."]
[]
["The base revenue forecasts for the RIIO-ET1 period (2014/15 to 2018/19, inclusive) reflect the figures authorised by Ofgem in the RIIO-ET1 Final Proposals.  "]
["Within the bounds of commercial confidentiality, this forecast provides as much information as possible."]
[]
["This forecast contains as much information as can be currently made available.  Generally, allowances determined by Ofgem are shown; whilst those for which Ofgem determinations are expected are not."]
["This respects commercial confidentiality and disclosure considerations."]
[]
["Note that actual revenues may vary from those currently forecast.  "]
[]
["All £ figures are in money of the day"]
[]
["Information provided in £m to one decimal place"]
[]
["Assumptions"]
["It is assumed that there will be one set of price changes per year effective on 1st April."]

{"sheet":"T20","index":22,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,2,4],[3,5,4,5],[18,3,19,3],[17,2,19,2],[14,1,17,1]]}
["Table 20 - Offshore Revenues"]
[]
["Offshore Transmission Revenue Forecast","2016-06-14",null,null,null," "]
["Description","Yr t-1","Yr t","Yr t+1","Yr t+2","Notes"]
["Regulatory Year","2014/15","2015/16","2016/17","2017/18"]
["Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.9300551874327718]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.5061411895727534]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.11222360129436]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.5312975137718468]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,13.568339293013979]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,19.994072851279611]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.29398863073726]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.288890468540934]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,38.441262407378794]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,17.876874168357521]
["Lincs",null,25.563393838820964,26.687042138144108,27.420176457343075]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,26.031290432324461]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,21.939633027950308]
["Humber Gateway",0,null,29.284541507176115,15.686433231810494,"National Grid Forecast"]
["Westermost Rough",0,null,null,12.508249875368788]
["Forecast to asset transfer to OFTO in 2017/18",null,null,null,11.106315671707641,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",218.38037349491282,248.35699921993759,260.78931257200446,279.2352440078846," "]
[]
[]
[]
["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"]

{"sheet":"T21","index":23,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[2,2,2,5],[2,6,2,9]]}
["Table 21 - Demand Profiles"]
[]
[null,null,"2017/18 Initial",null,null,null,"2017/18 June"]
["Zone","Zone Name","Locational Model Demand (MW)","Tariff model Peak Demand (MW)","Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)","Locational Model Demand (MW)","Tariff model Peak Demand (MW)","Tariff Model HH Demand (MW)","Tariff model NHH Demand (TWh)"]
[1,"Northern Scotland",607.38487584486393,551.47407217606201,-379.54015633595623,0.63948189281120871,679,674.92370160113535,-501.2810036802876,0.69065600896996071]
[2,"Southern Scotland",3214.9352279506529,3113.9293094308109,643.43539256181043,1.5425163967209303,2967.9371351816021,3339.467373161568,713.9991667510568,1.6370035504157836]
[3,"Northern",2590.2002828352838,2152.098507328466,331.63919026919962,1.114453050572229,2604,2271.5758665494195,616.81980453274571,1.1243121773174607]
[4,"North West",4032.1227577668838,3664.1973664897282,1182.7726512068377,1.8497347375918349,3503,4029.5466083963111,1421.9690047048671,1.9123117543725419]
[5,"Yorkshire",4582.8539710512196,3838.6048840253211,1172.9672279206361,1.6871188117183324,4650,3687.662146075013,1334.0789128097094,1.7541884970352524]
[6,"N Wales & Mersey",1887.1401381652749,2988.1510140250971,1170.2446163389188,1.1656215155289023,2687,2457.4444437611733,623.38510805714623,1.2160418598388523]
[7,"East Midlands",5077.2500000000664,4745.4038671495155,1717.8409572806474,2.0888427499353477,5138,4574.137634967451,1596.8762528775374,2.1499566780864683]
[8,"Midlands",4422.2199999999993,4192.5958374307356,1559.5063649663632,1.8674458266075167,4500,4313.6684877882089,1754.3133748463686,1.9218986408847134]
[9,"Eastern",5650.4793966244315,6015.5885278881115,1852.8929074818006,3.0085188457912695,5848,6093.1531706678979,1818.4413067591959,3.0376843059684671]
[10,"South Wales",1921.3848751991832,2221.0610232060053,1012.8996622204962,0.78461541736004414,1967,1724.6416917637678,653.00429578247304,0.81228313881225533]
[11,"South East",3618.4327569259021,3599.3991718491156,1070.9677117249162,1.8545558683580192,3627,3486.9570383158734,1107.5682909134009,1.8223341537086588]
[12,"London",4863.5031870082894,4406.2028125910256,2060.8959381215855,1.8840944766622989,5210,4778.776392646866,2470.280740389634,1.800673955101582]
[13,"Southern",5905.4746298825794,5547.4609108265277,2323.6147625123576,2.4833323997196617,5938.4254810974371,5334.7701471952978,2094.6560273274736,2.5082536636970638]
[14,"South Western",2711.3801210956872,2261.5707526598062,579.73226266675533,1.1678787213767248,2604,2334.0932930200429,703.09382524317016,1.2262263073896984]
["Total",null,{"$f":"SUM(C5:C18)","v":51084.76222035032},49297.738057076327,16299.869488936367,{"$f":"SUM(F5:F18)","v":23.138210710754318},51923.362616279039,49100.817995910023,16407.20510731449,23.613824691598762]

{"sheet":"T27","index":24,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Zone","Zone Name","Peak Security Tariff","Year Round Tariff","Residual","Small Generators Discount","HH Demand Tariff (£/kW)"]
[null,1,"Northern Scotland",2.4064957834728249,-20.024521898060829,47.954886963010686,0.6167326344846723,30.953593482907355]
[null,2,"Southern Scotland",0.12967219483503911,-17.821576755501454,47.954886963010686,0.6167326344846723,30.879715036828944]
[null,3,"Northern",-2.9255031760392471,-6.2444402507905297,47.954886963010686,0.6167326344846723,39.401676170665581]
[null,4,"North West",-1.1681618944558581,-1.9318528162839852,47.954886963010686,0.6167326344846723,45.471604886755514]
[null,5,"Yorkshire",-3.070751468128111,-0.17053690244051709,47.954886963010686,0.6167326344846723,45.330331226926731]
[null,6,"N Wales & Mersey",-1.5483335961908893,0.17556826957017516,47.954886963010686,0.6167326344846723,47.198854270874641]
[null,7,"East Midlands",-2.1136917237770296,2.1172342927107533,47.954886963010686,0.6167326344846723,48.575162166429081]
[null,8,"Midlands",-1.4669442398377075,2.9318406636016832,47.954886963010686,0.6167326344846723,50.036516021259331]
[null,9,"Eastern",1.2587489427956493,0.67240289127235076,47.954886963010686,0.6167326344846723,50.502771431563353]
[null,10,"South Wales",-5.6911255720248333,4.2854604266850709,47.954886963010686,0.6167326344846723,47.165954452155596]
[null,11,"South East",3.8793617218041097,1.0238881759406615,47.954886963010686,0.6167326344846723,53.474869495240128]
[null,12,"London",5.1109237635264781,2.270913785029637,47.954886963010686,0.6167326344846723,55.95345714605147]
[null,13,"Southern",1.8041943837537757,4.0786255110492897,47.954886963010686,0.6167326344846723,54.45443949229842]
[null,14,"South Western",-0.76312435043646942,5.238077905923161,47.954886963010686,0.6167326344846723,53.046573152982049]

{"sheet":"TEC changes","index":25,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Power Station","Node","MW Change","Zone"]
[null,"Aberthaw","ABTH20",-10,21]
[null,"A'Chruach Wind Farm","ACHR1R",-6.8999999999999986,7]
[null,"Afton","BLAC10",-18,10]
[null,"Beatrice Wind Farm","BLHI40",-20,1]
[null,"Blacklaw Extension","BLKX10",-9,11]
[null,"Clyde North","CLYN2Q",-36.699999999999989,11]
[null,"Clyde South","CLYS2R",54,11]
[null,"Crystal Rig 2","CRYR40",-62,11]
[null,"Crystal Rig 3","CRYR40",62,11]
[null,"Drax","DRAX40",-3906,15]
[null,"Drax (Biomass)","DRAX40",1905,15]
[null,"Drax (Coal)","DRAX40",2001,15]
[null,"Harestanes","HARE10",-17.299999999999997,12]
[null,"Keith Hill Wind Farm","DUNE10",0.5,11]
[null,"Lynemouth Power Station","BLYT20",376,13]
[null,"Medway Power Station","GRAI40",35,24]
[null,"Peterborough","WALP40_EME",245,17]
[null,"Rugeley","RUGE40",-980,18]
[null,"Taylors Lane","WISD20_LPN",-144,23]

{"sheet":"Sensitivities","index":26,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,5,4,6],[4,7,4,8]]}
[]
[]
[null,"Sensitivities"]
[]
[null,"£50m increase in revenue recovered from TNUoS",null,null,null,"Change in Demand",null,"Change in Tariff"]
[null,"Change in Generation Tariffs (£/kW)",0,null,null,"Peak Demand (MW)",982]
[null,"Change in HH Demand Tariffs (£/kW)",1.02,null,null,"HH Demand (MW)",328,"HH Tariff (£/kW)",-0.94]
[null,"Change in NHH Demand Tariffs (p/kWh)",0.14000000000000001,null,null,"NHH Demand (TWh)",0,"NHH Tariff (£/kWh)",0]