{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Index","Residuals","TA","TB","TC & Fig D","TE & Fig F","TG & Fig H","TI","TJ","TK & Fig L","TM","TN","TN A-Z","TO","TP","TQ","TR","TS","TT","TU","TV","TW","TY","TZ","TAA","TBB","TCC","TDD","TEE","TFF"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":4,"defined_names":841,"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":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["INDEX"]
[{"$f":"Residuals!A1","v":"Residuals and Averages"}]
[{"$f":"TA!A1","v":"Table A - Summary of Demand Tariffs"}]
[{"$f":"TB!A1","v":"Table B - Demand Tariffs"}]
[{"$f":"'TC & Fig D'!A1","v":"Table C - Change in HH Demand Tariffs"}]
[{"$f":"'TE & Fig F'!A1","v":"Table E - Embedded Export Tariff"}]
[{"$f":"'TG & Fig H'!A1","v":"Table G - NHH Demand Tariff Changes"}]
[{"$f":"TI!A1","v":"Table I - Changes to Average Tariffs"}]
[{"$f":"TJ!A1","v":"Table J - Generation Wider Tariffs"}]
[{"$f":"'TK & Fig L'!A1","v":"Table K - Generation Tariff Changes"}]
[{"$f":"TM!A1","v":"Table M - Local Substation Tariffs"}]
[{"$f":"TN!A1","v":"Table N - Onshore Local Circuit Tariffs"}]
[{"$f":"TO!A1","v":"Table O - CMP203: Circuits subject to one-off charges"}]
[{"$f":"TP!A1","v":"Table P - Offshore Local Tariffs"}]
[{"$f":"TQ!A1","v":"Table Q - Contracted and Modelled TEC"}]
[{"$f":"TR!A1","v":"Table R - Interconnectors"}]
[{"$f":"TS!A1","v":"Table S - Allowed Revenues"}]
[{"$f":"TT!A1","v":"Table T - Generation and Demand Revenue Proportions"}]
[{"$f":"TU!A1","v":"Table U - Charging Bases"}]
[{"$f":"TV!A1","v":"Table V - Residual Calculation"}]
[{"$f":"TW!A1","v":"Table W - Small Generator Discount"}]
[{"$f":"TY!A1","v":"Table Y - Demand Locational Tariffs"}]
[{"$f":"TZ!A1","v":"Table Z - Breakdown of the Embedded Export Tariff"}]
[{"$f":"TAA!A1","v":"Table AA - Demand Profiles"}]
[{"$f":"TBB!A1","v":"Table BB - Annual Load Factors"}]
[{"$f":"TCC!A1","v":"Table CC - Generic Annual Load Factors"}]
[{"$f":"TDD!A1","v":"Table DD - Generation Contracted TEC Changes"}]
[{"$f":"TEE!A1","v":"Table EE - Indicative National Grid Revenue Forecast"}]
[{"$f":"TFF!A1","v":"Table FF - Offshore Revenues"}]
[]
[]
["List of Figures:"]
[{"$f":"'TC & Fig D'!H1","v":"Figure D - Changes to gross HH demand tariffs"}]
[{"$f":"'TE & Fig F'!H1","v":"Figure F - Changes to the EET"}]
[{"$f":"'TG & Fig H'!G1","v":"Figure H - changes to NHH demand tariffs"}]
[{"$f":"'TK & Fig L'!A35","v":"Figure L - Variation in generation zonal tariffs"}]

{"sheet":"Residuals","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Residuals and Averages",null,null,"Return to Index"]
[]
["Residual","2019/20 June","2019/20 Draft","Change since last forecast"]
["Generation",{"$f":"TI!B4","v":-3.6130603651697655},{"$f":"TI!C4","v":-3.5374569999999999},{"$f":"C4-B4","v":7.5603365169765624E-2}]
["Demand",{"$f":"TA!C5","v":51.697066},{"$f":"TA!D5","v":50.822881000000002},{"$f":"C5-B5","v":-0.8741849999999971}]
[]
["Average Tariff",{"$f":"B3","v":"2019/20 June"},{"$f":"C3","v":"2019/20 Draft"},{"$f":"D3","v":"Change since last forecast"}]
["Generation (£/kW)",{"$f":"TI!B5","v":5.6112696379735949},{"$f":"TI!C5","v":5.5030850673754816},{"$f":"C8-B8","v":-0.10818457059811326}," N.B. These generation average tariffs include local tariffs"]
["HH Demand (£/kW)",{"$f":"TA!C4","v":50.745111000000001},{"$f":"TA!D4","v":49.942760999999997},{"$f":"C9-B9","v":-0.80235000000000412}]
["NHH Demand (p/kWh)",{"$f":"TA!C13","v":6.5571590000000004},{"$f":"TA!D13","v":6.4568180000000002},-0.10034100000000024]
["Embedded Export (£/kW)",{"$f":"TA!C7","v":14.306876000000001},{"$f":"TA!D7","v":14.261808},-4.5068000000000552E-2]

{"sheet":"TA","index":2,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Table A - Summary of Demand Tariffs",null,null,null,"Return to Index"]
[]
[null,"HH Tariffs",{"$f":"Residuals!B3","v":"2019/20 June"},{"$f":"Residuals!C3","v":"2019/20 Draft"},"Change"]
[null,"Average Tariff (£/kW)",50.745111000000001,49.942760999999997,{"$f":"D4-C4","v":-0.80235000000000412}]
[null,"Residual (£/kW)",51.697066,50.822881000000002,{"$f":"D5-C5","v":-0.8741849999999971}]
[null,"EET",{"$f":"C3","v":"2019/20 June"},{"$f":"D3","v":"2019/20 Draft"},{"$f":"E3","v":"Change"}]
[null,"Average Tariff (£/kW)",14.306876000000001,14.261808,{"$f":"D7-C7","v":-4.5068000000000552E-2}]
[null,"Phased residual (£/kW)",14.65,14.65,{"$f":"D8-C8","v":0}]
[null,"AGIC (£/kW)",3.3272680000000001,3.3272680000000001,0]
[null,"Embedded Export Volume (GW)",7.75280802278,7.75280802278,0]
[null,"Total Credit (£m)",110.9184626243141,110.56905919862743,-0.34940342568667404]
[null,"NHH Tariffs",{"$f":"C6","v":"2019/20 June"},{"$f":"D6","v":"2019/20 Draft"},{"$f":"E6","v":"Change"}]
[null,"Average (p/kWh)",6.5571590000000004,6.4568180000000002,-0.10034100000000024]

{"sheet":"TB","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Table B - Demand Tariffs",null,null,null,"Return to Index"]
[]
["Zone","Zone Name","HH Demand Tariff (£/kW)","NHH Demand Tariff (p/kWh)","Embedded Export Tariff (£/kW)"]
[1,"Northern Scotland",20.395102999999999,2.745374,0]
[2,"Southern Scotland",30.179224000000001,3.9508030000000001,0]
[3,"Northern",40.450515000000003,5.1384359999999996,7.6049020000000001]
[4,"North West",47.255412999999997,6.1269910000000003,14.409800000000001]
[5,"Yorkshire",47.463149999999999,6.0409410000000001,14.617537]
[6,"N Wales & Mersey",48.769199999999998,6.1483220000000003,15.923586999999999]
[7,"East Midlands",50.863602,6.6633290000000001,18.017989]
[8,"Midlands",52.351899000000003,6.9022399999999999,19.506285999999999]
[9,"Eastern",53.212159,7.4218200000000003,20.366546]
[10,"South Wales",49.149475000000002,5.797504,16.303861999999999]
[11,"South East",55.534681999999997,7.8708799999999997,22.689070000000001]
[12,"London",58.599620000000002,6.2151069999999997,25.754007000000001]
[13,"Southern",56.762613000000002,7.5108499999999996,23.917000000000002]
[14,"South Western",55.110511000000002,7.6926230000000002,22.264897999999999]
[]
["Residual charge for demand:",null,50.822880972832635]

{"sheet":"TC & Fig D","index":4,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table C - Change in HH Demand Tariffs",null,null,null,null,"Return to Index",null,"Figure D - Changes to gross HH demand tariffs"]
[]
["Zone","Zone Name",{"$f":"TA!C3&\" (£/kW)\"","v":"2019/20 June (£/kW)"},{"$f":"TA!D3&\" (£/kW)\"","v":"2019/20 Draft (£/kW)"},"Change (£/kW)","Change in Residual (£/kW)"]
[1,"Northern Scotland",21.117249000000001,{"$f":"F21","v":20.395102999999999},{"$f":"D4-C4","v":-0.72214600000000218},{"$f":"Residuals!C5-Residuals!B5","v":-0.8741849999999971}]
[2,"Southern Scotland",28.797132000000001,{"$f":"F22","v":30.179224000000001},{"$f":"D5-C5","v":1.3820920000000001},{"$f":"F4","v":-0.8741849999999971}]
[3,"Northern",41.292129000000003,40.450515000000003,-0.84161399999999986,{"$f":"F5","v":-0.8741849999999971}]
[4,"North West",48.128953000000003,47.255412999999997,-0.87354000000000553,-0.8741849999999971]
[5,"Yorkshire",48.421348999999999,47.463149999999999,-0.95819900000000047,-0.8741849999999971]
[6,"N Wales & Mersey",49.711398000000003,48.769199999999998,-0.94219800000000475,-0.8741849999999971]
[7,"East Midlands",51.861094000000001,50.863602,-0.99749200000000116,-0.8741849999999971]
[8,"Midlands",53.158467000000002,52.351899000000003,-0.80656799999999862,-0.8741849999999971]
[9,"Eastern",53.903967000000002,53.212159,-0.69180800000000175,-0.8741849999999971]
[10,"South Wales",50.052638999999999,49.149475000000002,-0.90316399999999675,-0.8741849999999971]
[11,"South East",56.648128,55.534681999999997,-1.1134460000000033,-0.8741849999999971]
[12,"London",59.762093,58.599620000000002,-1.1624729999999985,-0.8741849999999971]
[13,"Southern",57.828961999999997,56.762613000000002,-1.0663489999999953,-0.8741849999999971]
[14,"South Western",56.141033999999998,55.110511000000002,-1.0305229999999952,-0.8741849999999971]
[]
[]
["Zone","Peak (£/kW)","Year Round (£/kW)","Residual £/kW","Small Gen Discount (£/kW)",{"$f":"D3","v":"2019/20 Draft (£/kW)"}]
[1,{"$f":"TY!D7","v":-1.5239750812755033},{"$f":"TY!E7","v":-28.903803276745602},{"$f":"TB!C19","v":50.822880972832635},0,{"$f":"ROUND(SUM(B21+C21+D21+E21),6)","v":20.395102999999999}]
[2,{"$f":"TY!D8","v":-1.8008259710082122},{"$f":"TY!E8","v":-18.842830823983366},{"$f":"D21","v":50.822880972832635},0,{"$f":"ROUND(SUM(B22+C22+D22+E22),6)","v":30.179224000000001}]
[3,{"$f":"TY!D9","v":-3.9006021174270362},{"$f":"TY!E9","v":-6.4717635106886489},{"$f":"D22","v":50.822880972832635},0,40.450515000000003]
[4,{"$f":"TY!D10","v":-1.4322726241876964},{"$f":"TY!E10","v":-2.1351949971757209},50.822880972832635,0,47.255412999999997]
[5,{"$f":"TY!D11","v":-3.2685694614566412},{"$f":"TY!E11","v":-9.1161573975407612E-2},50.822880972832635,0,47.463149999999999]
[6,{"$f":"TY!D12","v":-2.5054789746831334},{"$f":"TY!E12","v":0.4517980954176079},50.822880972832635,0,48.769199999999998]
[7,{"$f":"TY!D13","v":-2.5256287267143165},{"$f":"TY!E13","v":2.5663497854719028},50.822880972832635,0,50.863602]
[8,{"$f":"TY!D14","v":-1.7184954819014304},{"$f":"TY!E14","v":3.2475130956595604},50.822880972832635,0,52.351899000000003]
[9,{"$f":"TY!D15","v":1.3670460189047309},{"$f":"TY!E15","v":1.0222323005488596},50.822880972832635,0,53.212159]
[10,{"$f":"TY!D16","v":-5.9963269210500121},{"$f":"TY!E16","v":4.3229206139761533},50.822880972832635,0,49.149475000000002]
[11,{"$f":"TY!D17","v":3.9569288244466905},{"$f":"TY!E17","v":0.7548726981336471},50.822880972832635,0,55.534681999999997]
[12,{"$f":"TY!D18","v":5.7351625026585893},{"$f":"TY!E18","v":2.0415768374845964},50.822880972832635,0,58.599620000000002]
[13,{"$f":"TY!D19","v":1.9184977990440715},{"$f":"TY!E19","v":4.0212345844068613},50.822880972832635,0,56.762613000000002]
[14,{"$f":"TY!D20","v":-0.68023771665145794},{"$f":"TY!E20","v":4.9678673876081447},50.822880972832635,0,55.110511000000002]

{"sheet":"TE & Fig F","index":5,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Table E - Embedded Export Tariff",null,null,null,"Return to Index",null,null,"Figure F - Changes to the EET"]
[]
[]
["Zone","Zone Name",{"$f":"'TC & Fig D'!C3","v":"2019/20 June (£/kW)"},{"$f":"'TC & Fig D'!D3","v":"2019/20 Draft (£/kW)"},"Change (£/kW)"]
[1,"Northern Scotland",{"$f":"MAX(0,TZ!C5+TZ!D5+TZ!E5)","v":0},{"$f":"E21","v":0},{"$f":"D5-C5","v":0}]
[2,"Southern Scotland",{"$f":"MAX(0,TZ!C6+TZ!D6+TZ!E6)","v":0},{"$f":"E22","v":0},{"$f":"D6-C6","v":0}]
[3,"Northern",{"$f":"MAX(0,TZ!C7+TZ!D7+TZ!E7)","v":7.5723310000000001},7.6049023718843163,3.2571371884316136E-2]
[4,"North West",{"$f":"MAX(0,TZ!C8+TZ!D8+TZ!E8)","v":14.409155},14.409800378636582,6.453786365820946E-4]
[5,"Yorkshire",{"$f":"MAX(0,TZ!C9+TZ!D9+TZ!E9)","v":14.701551},14.617536964567952,-8.4014035432048217E-2]
[6,"N Wales & Mersey",{"$f":"MAX(0,TZ!C10+TZ!D10+TZ!E10)","v":15.9916},15.923587120734474,-6.8012879265525683E-2]
[7,"East Midlands",{"$f":"MAX(0,TZ!C11+TZ!D11+TZ!E11)","v":18.141296000000001},18.017989058757585,-0.12330694124241504]
[8,"Midlands",{"$f":"MAX(0,TZ!C12+TZ!D12+TZ!E12)","v":19.438669000000001},19.506285613758131,6.7616613758129773E-2]
[9,"Eastern",{"$f":"MAX(0,TZ!C13+TZ!D13+TZ!E13)","v":20.184169000000001},20.36654631945359,0.18237731945358959]
[10,"South Wales",{"$f":"MAX(0,TZ!C14+TZ!D14+TZ!E14)","v":16.332841000000002},16.303861692926141,-2.8979307073861094E-2]
[11,"South East",{"$f":"MAX(0,TZ!C15+TZ!D15+TZ!E15)","v":22.928330000000003},22.68906952258034,-0.23926047741966272]
[12,"London",{"$f":"MAX(0,TZ!C16+TZ!D16+TZ!E16)","v":26.042296},25.754007340143186,-0.28828865985681418]
[13,"Southern",{"$f":"MAX(0,TZ!C17+TZ!D17+TZ!E17)","v":24.109165000000001},23.917000383450933,-0.1921646165490678]
[14,"South Western",{"$f":"MAX(0,TZ!C18+TZ!D18+TZ!E18)","v":22.421236},22.264897670956685,-0.15633832904331513]
[]
["Zone","EET Locational £/kW","AGIC £/kW","2019/20 Phased Residual £/kW ","Final EET Tariff £/kW","EET Revenue £m"]
[1,{"$f":"TZ!F5","v":-30.427778358021104},{"$f":"TZ!G5","v":3.3272680000000001},{"$f":"TZ!H5","v":14.65},{"$f":"MAX(0,TZ!F5+TZ!G5+TZ!H5)","v":0},0]
[2,{"$f":"TZ!F6","v":-20.643656794991578},{"$f":"TZ!G6","v":3.3272680000000001},{"$f":"TZ!H6","v":14.65},{"$f":"MAX(0,TZ!F6+TZ!G6+TZ!H6)","v":0},0]
[3,{"$f":"TZ!F7","v":-10.372365628115684},{"$f":"TZ!G7","v":3.3272680000000001},{"$f":"TZ!H7","v":14.65},{"$f":"MAX(0,TZ!F7+TZ!G7+TZ!H7)","v":7.6049023718843163},3.3358843597569234]
[4,{"$f":"TZ!F8","v":-3.5674676213634173},{"$f":"TZ!G8","v":3.3272680000000001},{"$f":"TZ!H8","v":14.65},{"$f":"MAX(0,TZ!F8+TZ!G8+TZ!H8)","v":14.409800378636582},5.9097474343165084]
[5,{"$f":"TZ!F9","v":-3.3597310354320489},{"$f":"TZ!G9","v":3.3272680000000001},{"$f":"TZ!H9","v":14.65},{"$f":"MAX(0,TZ!F9+TZ!G9+TZ!H9)","v":14.617536964567952},11.804154258041962]
[6,{"$f":"TZ!F10","v":-2.0536808792655257},{"$f":"TZ!G10","v":3.3272680000000001},{"$f":"TZ!H10","v":14.65},{"$f":"MAX(0,TZ!F10+TZ!G10+TZ!H10)","v":15.923587120734474},8.7649671880337952]
[7,{"$f":"TZ!F11","v":4.0721058757586359E-2},{"$f":"TZ!G11","v":3.3272680000000001},{"$f":"TZ!H11","v":14.65},{"$f":"MAX(0,TZ!F11+TZ!G11+TZ!H11)","v":18.017989058757585},11.516979660242718]
[8,{"$f":"TZ!F12","v":1.5290176137581299},{"$f":"TZ!G12","v":3.3272680000000001},{"$f":"TZ!H12","v":14.65},{"$f":"MAX(0,TZ!F12+TZ!G12+TZ!H12)","v":19.506285613758131},6.5364001516008683]
[9,{"$f":"TZ!F13","v":2.3892783194535907},{"$f":"TZ!G13","v":3.3272680000000001},{"$f":"TZ!H13","v":14.65},{"$f":"MAX(0,TZ!F13+TZ!G13+TZ!H13)","v":20.36654631945359},16.409173271200093]
[10,{"$f":"TZ!F14","v":-1.6734063070738587},{"$f":"TZ!G14","v":3.3272680000000001},{"$f":"TZ!H14","v":14.65},{"$f":"MAX(0,TZ!F14+TZ!G14+TZ!H14)","v":16.303861692926141},8.3100875442828759]
[11,{"$f":"TZ!F15","v":4.7118015225803376},{"$f":"TZ!G15","v":3.3272680000000001},{"$f":"TZ!H15","v":14.65},{"$f":"MAX(0,TZ!F15+TZ!G15+TZ!H15)","v":22.68906952258034},9.3234736467262671]
[12,{"$f":"TZ!F16","v":7.7767393401431857},{"$f":"TZ!G16","v":3.3272680000000001},{"$f":"TZ!H16","v":14.65},{"$f":"MAX(0,TZ!F16+TZ!G16+TZ!H16)","v":25.754007340143186},4.3995840834318587]
[13,{"$f":"TZ!F17","v":5.9397323834509326},{"$f":"TZ!G17","v":3.3272680000000001},{"$f":"TZ!H17","v":14.65},{"$f":"MAX(0,TZ!F17+TZ!G17+TZ!H17)","v":23.917000383450933},16.566680970443038]
[14,{"$f":"TZ!F18","v":4.2876296709566866},{"$f":"TZ!G18","v":3.3272680000000001},{"$f":"TZ!H18","v":14.65},{"$f":"MAX(0,TZ!F18+TZ!G18+TZ!H18)","v":22.264897670956685},7.6919266305505092]

{"sheet":"TG & Fig H","index":6,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table G - NHH Demand Tariff Changes",null,null,"Return to Index",null,null,"Figure H - changes to NHH demand tariffs"]
[]
["Zone","Zone Name",{"$f":"Residuals!B3&\" (p/kWh)\"","v":"2019/20 June (p/kWh)"},{"$f":"Residuals!C3&\" (p/kWh)\"","v":"2019/20 Draft (p/kWh)"},"Change (p/kWh)"]
[1,"Northern Scotland",2.8425820000000002,{"$f":"TB!D4","v":2.745374},{"$f":"D4-C4","v":-9.7208000000000183E-2}]
[2,"Southern Scotland",3.7698710000000002,{"$f":"TB!D5","v":3.9508030000000001},{"$f":"D5-C5","v":0.18093199999999987}]
[3,"Northern",5.2453459999999996,{"$f":"TB!D6","v":5.1384359999999996},-0.10691000000000006]
[4,"North West",6.2402509999999998,{"$f":"TB!D7","v":6.1269910000000003},-0.11325999999999947]
[5,"Yorkshire",6.1628970000000001,{"$f":"TB!D8","v":6.0409410000000001},-0.12195599999999995]
[6,"N Wales & Mersey",6.2671039999999998,{"$f":"TB!D9","v":6.1483220000000003},-0.1187819999999995]
[7,"East Midlands",6.7940040000000002,{"$f":"TB!D10","v":6.6633290000000001},-0.1306750000000001]
[8,"Midlands",7.0085810000000004,{"$f":"TB!D11","v":6.9022399999999999},-0.10634100000000046]
[9,"Eastern",7.5183099999999996,{"$f":"TB!D12","v":7.4218200000000003},-9.6489999999999299E-2]
[10,"South Wales",5.9040379999999999,{"$f":"TB!D13","v":5.797504},-0.10653399999999991]
[11,"South East",8.0286880000000007,{"$f":"TB!D14","v":7.8708799999999997},-0.15780800000000106]
[12,"London",6.3384,{"$f":"TB!D15","v":6.2151069999999997},-0.12329300000000032]
[13,"Southern",7.6519500000000003,{"$f":"TB!D16","v":7.5108499999999996},-0.14110000000000067]
[14,"South Western",7.8364690000000001,{"$f":"TB!D17","v":7.6926230000000002},-0.14384599999999992]

{"sheet":"TI","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Table I - Changes to Average Tariffs",null,null,null,null,"Return to Index"]
[]
["Generation Tariffs (£/kW)",{"$f":"Residuals!B3","v":"2019/20 June"},{"$f":"Residuals!C3","v":"2019/20 Draft"},"Change since last forecast"]
["Residual",-3.6130603651697655,{"$f":"TJ!F5","v":-3.5374569999999999},{"$f":"C4-B4","v":7.5603365169765624E-2}]
["Average Generation Tariff",5.6112696379735949,5.5030850673754816,{"$f":"C5-B5","v":-0.10818457059811326},"N.B. These generation average tariffs include local tariffs"]

{"sheet":"TJ","index":8,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[32,6,32,7],[1,6,1,8]]}
["Table J - 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",2.2805430000000002,17.691649000000002,15.483853999999999,-3.5374569999999999,25.283488400000003,28.380259200000001,19.0230566]
[2,"East Aberdeenshire",4.3932200000000003,9.2201240000000002,15.483853999999999,-3.5374569999999999,20.618945400000001,23.715716199999999,15.6344466]
[3,"Western Highlands",1.436393,18.259143999999999,15.522353000000001,-3.5374569999999999,24.924133600000001,28.0286042,19.2885536]
[4,"Skye and Lochalsh",-2.8643320000000001,18.259143999999999,17.231377999999999,-3.5374569999999999,21.990628600000001,25.436904200000001,20.997578600000001]
[5,"Eastern Grampian and Tayside",2.0433219999999999,15.184507,14.767083,-3.5374569999999999,22.467137000000001,25.420553600000002,17.303428799999999]
[6,"Central Grampian",2.9673750000000001,14.208477,14.345112,-3.5374569999999999,22.272789200000005,25.1418116,16.491045800000002]
[7,"Argyll",2.9730020000000001,11.114504999999999,24.583506,-3.5374569999999999,27.993953800000003,32.910654999999991,25.491851]
[8,"The Trossachs",2.9851960000000002,11.114504999999999,12.941107000000001,-3.5374569999999999,18.692228600000004,21.280449999999998,13.849451999999999]
[9,"Stirlingshire and Fife",1.8122510000000001,8.5145619999999997,12.163012999999999,-3.5374569999999999,14.816853999999999,17.249456599999998,12.031380799999999]
[10,"South West Scotlands",3.1403759999999998,9.8453230000000005,12.498708000000001,-3.5374569999999999,17.478143800000002,19.977885400000002,12.8993802]
[11,"Lothian and Borders",3.851953,9.8453230000000005,6.686795,-3.5374569999999999,13.540190400000004,14.877549400000003,7.0874672000000007]
[12,"Solway and Cheviot",2.0706319999999998,5.4976139999999996,7.2540100000000001,-3.5374569999999999,8.7344742000000011,10.185276200000001,5.9155985999999992]
[13,"North East England",4.3065899999999999,2.9129480000000001,3.9071359999999999,-3.5374569999999999,6.2252001999999997,7.0066273999999993,1.5348582000000004]
[14,"North Lancashire and The Lakes",1.826522,2.9129480000000001,2.5240879999999999,-3.5374569999999999,2.6386938000000004,3.1435114000000004,0.1518101999999999]
[15,"South Lancashire, Yorkshire and Humber",4.7928170000000003,0.49564399999999997,0.14560899999999999,-3.5374569999999999,1.7683624000000009,1.7974842000000004,-3.1935903999999997]
[16,"North Midlands and North Wales",4.2545820000000001,-1.0920879999999999,0,-3.5374569999999999,-0.15654539999999972,-0.15654539999999972,-3.9742921999999998]
[17,"South Lincolnshire and North Norfolk",2.4120170000000001,-0.604939,0,-3.5374569999999999,-1.6093911999999997,-1.6093911999999997,-3.7794325999999998]
[18,"Mid Wales and The Midlands",1.511077,-0.15529399999999999,0,-3.5374569999999999,-2.1506151999999998,-2.1506151999999998,-3.5995746]
[19,"Anglesey and Snowdon",4.7736799999999997,-1.0311920000000001,0,-3.5374569999999999,0.41126939999999967,0.41126939999999967,-3.9499338000000002]
[20,"Pembrokeshire",9.0297009999999993,-4.395975,0,-3.5374569999999999,1.9754639999999988,1.9754639999999988,-5.2958470000000002]
[21,"South Wales & Gloucester",5.948658,-4.2883579999999997,0,-3.5374569999999999,-1.0194853999999998,-1.0194853999999998,-5.2528001999999994]
[22,"Cotswold",2.744945,2.559043,-6.7590120000000002,-3.5374569999999999,-4.1524872000000004,-5.5042895999999999,-9.2728517999999998]
[23,"Central London",-5.8534319999999997,2.559043,-6.7451449999999999,-3.5374569999999999,-12.7397706,-14.0887996,-9.2589848000000003]
[24,"Essex and Kent",-3.8669060000000002,2.559043,0,-3.5374569999999999,-5.3571285999999994,-5.3571285999999994,-2.5138397999999995]
[25,"Oxfordshire, Surrey and Sussex",-1.553471,-2.5856150000000002,0,-3.5374569999999999,-7.1594200000000008,-7.1594200000000008,-4.5717030000000003]
[26,"Somerset and Wessex",-1.6440809999999999,-2.876601,0,-3.5374569999999999,-7.4828188000000004,-7.4828188000000004,-4.6880974000000002]
[27,"West Devon and Cornwall",-9.4511999999999999E-2,-5.153912,0,-3.5374569999999999,-7.7550986000000002,-7.7550986000000002,-5.5990218]

{"sheet":"TK & Fig L","index":9,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,3,11],[4,2,4,4],[4,8,4,10],[4,11,5,11],[0,0,0,10],[4,5,4,7]]}
["Table K - 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",{"$f":"Residuals!B3&\" (£/kW)\"","v":"2019/20 June (£/kW)"},{"$f":"Residuals!C3&\" (£/kW)\"","v":"2019/20 Draft (£/kW)"},"Change (£/kW)",{"$f":"C6","v":"2019/20 June (£/kW)"},{"$f":"D6","v":"2019/20 Draft (£/kW)"},"Change (£/kW)",{"$f":"F6","v":"2019/20 June (£/kW)"},{"$f":"G6","v":"2019/20 Draft (£/kW)"},"Change (£/kW)"]
[1,"North Scotland",26.345707599999997,{"$f":"TJ!G5","v":25.283488400000003},{"$f":"D7-C7","v":-1.0622191999999941},29.6038204,{"$f":"TJ!H5","v":28.380259200000001},{"$f":"G7-F7","v":-1.2235611999999989},19.823923199999999,{"$f":"TJ!I5","v":19.0230566},{"$f":"J7-I7","v":-0.8008665999999991},{"$f":"TI!D4","v":7.5603365169765624E-2}]
[2,"East Aberdeenshire",22.587712,{"$f":"TJ!G6","v":20.618945400000001},{"$f":"D8-C8","v":-1.9687665999999986},25.845824799999999,{"$f":"TJ!H6","v":23.715716199999999},{"$f":"G8-F8","v":-2.1301085999999998},16.833454399999997,{"$f":"TJ!I6","v":15.6344466},{"$f":"J8-I8","v":-1.1990077999999968},{"$f":"L7","v":7.5603365169765624E-2}]
[3,"Western Highlands",25.908857800000003,{"$f":"TJ!G7","v":24.924133600000001},-0.98472420000000227,29.169042199999996,{"$f":"TJ!H7","v":28.0286042},-1.1404379999999961,19.895349599999999,{"$f":"TJ!I7","v":19.2885536},-0.60679599999999922,{"$f":"L8","v":7.5603365169765624E-2}]
[4,"Skye and Lochalsh",19.699680999999998,{"$f":"TJ!G8","v":21.990628600000001},2.2909476000000026,22.936847199999999,{"$f":"TJ!H8","v":25.436904200000001},2.5000570000000018,19.7802586,{"$f":"TJ!I8","v":20.997578600000001},1.2173200000000008,7.5603365169765624E-2]
[5,"Eastern Grampian and Tayside",24.414331199999999,{"$f":"TJ!G9","v":22.467137000000001},-1.9471941999999984,27.553367599999998,{"$f":"TJ!H9","v":25.420553600000002},-2.1328139999999962,18.303258799999998,{"$f":"TJ!I9","v":17.303428799999999},-0.99982999999999933,7.5603365169765624E-2]
[6,"Central Grampian",24.275302200000002,{"$f":"TJ!G10","v":22.272789200000005},-2.0025129999999969,27.352947199999999,{"$f":"TJ!H10","v":25.1418116},-2.2111355999999986,17.7123046,{"$f":"TJ!I10","v":16.491045800000002},-1.2212587999999975,7.5603365169765624E-2]
[7,"Argyll",29.220503000000004,{"$f":"TJ!G11","v":27.993953800000003},-1.2265492000000009,34.245640000000002,{"$f":"TJ!H11","v":32.910654999999991},-1.3349850000000103,26.219877,{"$f":"TJ!I11","v":25.491851},-0.72802599999999984,7.5603365169765624E-2]
[8,"The Trossachs",20.601688599999999,{"$f":"TJ!G12","v":18.692228600000004},-1.9094599999999957,23.400277999999997,{"$f":"TJ!H12","v":21.280449999999998},-2.1198279999999983,15.087138999999997,{"$f":"TJ!I12","v":13.849451999999999},-1.2376869999999975,7.5603365169765624E-2]
[9,"Stirlingshire and Fife",16.465624800000001,{"$f":"TJ!G13","v":14.816853999999999},-1.6487708000000012,19.096667399999998,{"$f":"TJ!H13","v":17.249456599999998},-1.8472107999999992,13.129724199999998,{"$f":"TJ!I13","v":12.031380799999999},-1.0983433999999992,7.5603365169765624E-2]
[10,"South West Scotlands",17.079496199999998,{"$f":"TJ!G14","v":17.478143800000002},0.39864760000000388,19.7388026,{"$f":"TJ!H14","v":19.977885400000002},0.23908280000000204,13.4951288,{"$f":"TJ!I14","v":12.8993802},-0.59574860000000029,7.5603365169765624E-2]
[11,"Lothian and Borders",13.610147999999999,{"$f":"TJ!G15","v":13.540190400000004},-6.9957599999995068E-2,15.097715600000001,{"$f":"TJ!H15","v":14.877549400000003},-0.22016619999999776,7.6364348000000009,{"$f":"TJ!I15","v":7.0874672000000007},-0.54896760000000011,7.5603365169765624E-2]
[12,"Solway and Cheviot",8.6718278000000026,{"$f":"TJ!G16","v":8.7344742000000011},6.2646399999998437E-2,10.172829799999999,{"$f":"TJ!H16","v":10.185276200000001},1.2446400000001745E-2,6.0496264000000002,{"$f":"TJ!I16","v":5.9155985999999992},-0.13402780000000103,7.5603365169765624E-2]
[13,"North East England",5.8394792000000004,{"$f":"TJ!G17","v":6.2252001999999997},0.38572099999999931,6.6280949999999992,{"$f":"TJ!H17","v":7.0066273999999993},0.3785324000000001,1.536079,{"$f":"TJ!I17","v":1.5348582000000004},-1.2207999999995778E-3,7.5603365169765624E-2]
[14,"North Lancashire and The Lakes",2.5158546000000008,{"$f":"TJ!G18","v":2.6386938000000004},0.12283919999999959,3.04732,{"$f":"TJ!H18","v":3.1435114000000004},9.6191400000000371E-2,0.25032700000000041,{"$f":"TJ!I18","v":0.1518101999999999},-9.8516800000000515E-2,7.5603365169765624E-2]
[15,"South Lancashire, Yorkshire and Humber",1.5845178000000004,{"$f":"TJ!G19","v":1.7683624000000009},0.18384460000000047,1.6080306000000002,{"$f":"TJ!H19","v":1.7974842000000004},0.18945360000000022,-3.1822171999999997,{"$f":"TJ!I19","v":-3.1935903999999997},-1.1373199999999972E-2,7.5603365169765624E-2]
[16,"North Midlands and North Wales",-0.33476999999999979,{"$f":"TJ!G20","v":-0.15654539999999972},0.17822460000000007,-0.33476999999999979,{"$f":"TJ!H20","v":-0.15654539999999972},0.17822460000000007,-3.9452560000000001,{"$f":"TJ!I20","v":-3.9742921999999998},-2.9036199999999734E-2,7.5603365169765624E-2]
[17,"South Lincolnshire and North Norfolk",-1.8730267999999999,{"$f":"TJ!G21","v":-1.6093911999999997},0.26363560000000019,-1.8730267999999999,{"$f":"TJ!H21","v":-1.6093911999999997},0.26363560000000019,-3.8027783999999998,{"$f":"TJ!I21","v":-3.7794325999999998},2.3345799999999972E-2,7.5603365169765624E-2]
[18,"Mid Wales and The Midlands",-2.598338,{"$f":"TJ!G22","v":-2.1506151999999998},0.4477228000000002,-2.598338,{"$f":"TJ!H22","v":-2.1506151999999998},0.4477228000000002,-3.7100719999999998,{"$f":"TJ!I22","v":-3.5995746},0.11049739999999986,7.5603365169765624E-2]
[19,"Anglesey and Snowdon",0.30667020000000011,{"$f":"TJ!G23","v":0.41126939999999967},0.10459919999999956,0.30667020000000011,{"$f":"TJ!H23","v":0.41126939999999967},0.10459919999999956,-3.8732503999999999,{"$f":"TJ!I23","v":-3.9499338000000002},-7.668340000000029E-2,7.5603365169765624E-2]
[20,"Pembrokeshire",1.9604011999999988,{"$f":"TJ!G24","v":1.9754639999999988},1.5062799999999932E-2,1.9604011999999988,{"$f":"TJ!H24","v":1.9754639999999988},1.5062799999999932E-2,-5.4199004000000004,{"$f":"TJ!I24","v":-5.2958470000000002},0.1240534000000002,7.5603365169765624E-2]
[21,"South Wales & Gloucester",-1.0194344000000002,{"$f":"TJ!G25","v":-1.0194853999999998},-5.099999999957916E-5,-1.0194344000000002,{"$f":"TJ!H25","v":-1.0194853999999998},-5.099999999957916E-5,-5.4092092000000003,{"$f":"TJ!I25","v":-5.2528001999999994},0.15640900000000091,7.5603365169765624E-2]
[22,"Cotswold",-4.1458000000000004,{"$f":"TJ!G26","v":-4.1524872000000004},-6.6872000000000043E-3,-5.4909581999999997,{"$f":"TJ!H26","v":-5.5042895999999999},-1.3331400000000215E-2,-9.4353866000000011,{"$f":"TJ!I26","v":-9.2728517999999998},0.16253480000000131,7.5603365169765624E-2]
[23,"Central London",-12.861636000000001,{"$f":"TJ!G27","v":-12.7397706},0.12186540000000079,-14.184247200000001,{"$f":"TJ!H27","v":-14.0887996},9.5447600000001742E-2,-9.3226516000000004,{"$f":"TJ!I27","v":-9.2589848000000003},6.3666800000000023E-2,7.5603365169765624E-2]
[24,"Essex and Kent",-5.895761199999999,{"$f":"TJ!G28","v":-5.3571285999999994},0.53863259999999968,-5.895761199999999,{"$f":"TJ!H28","v":-5.3571285999999994},0.53863259999999968,-2.7095956000000001,{"$f":"TJ!I28","v":-2.5138397999999995},0.19575580000000059,7.5603365169765624E-2]
[25,"Oxfordshire, Surrey and Sussex",-7.5417369999999995,{"$f":"TJ!G29","v":-7.1594200000000008},0.38231699999999869,-7.5417369999999995,{"$f":"TJ!H29","v":-7.1594200000000008},0.38231699999999869,-4.7935080000000001,{"$f":"TJ!I29","v":-4.5717030000000003},0.22180499999999981,7.5603365169765624E-2]
[26,"Somerset and Wessex",-8.3119094000000011,{"$f":"TJ!G30","v":-7.4828188000000004},0.82909060000000068,-8.3119094000000011,{"$f":"TJ!H30","v":-7.4828188000000004},0.82909060000000068,-5.2586192,{"$f":"TJ!I30","v":-4.6880974000000002},0.57052179999999986,7.5603365169765624E-2]
[27,"West Devon and Cornwall",-8.0518181999999996,{"$f":"TJ!G31","v":-7.7550986000000002},0.29671959999999942,-8.0518181999999996,{"$f":"TJ!H31","v":-7.7550986000000002},0.29671959999999942,-5.8841415999999995,{"$f":"TJ!I31","v":-5.5990218},0.28511979999999948,7.5603365169765624E-2]
[]
["Figure L - Variation in generation zonal tariffs"]

{"sheet":"TM","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 M - Local Substation Tariffs",null,null,null,"Return to Index"]
[]
[{"$f":"Index!J11&\" Local Substation Tariff (£/kW)\"","v":" Local Substation Tariff (£/kW)"}]
["Substation\nRating","Connection\nType","132kV","275kV","400kV"]
[]
["<1320 MW","No redundancy",0.197964,0.113248,8.1598000000000004E-2]
["<1320 MW","Redundancy",0.43609799999999999,0.26981699999999997,0.19623199999999999]
[">=1320 MW","No redundancy",0,0.35508299999999998,0.256797]
[">=1320 MW","Redundancy",0,0.582955,0.42550900000000003]

{"sheet":"TN","index":11,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table N - Onshore Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",4.2336660000000004,"Dunhill",1.412272,"Luichart",0.56596900000000006]
["Aigas",0.644872,"Dumnaglass",1.830606,"Mark Hill",0.86331100000000005]
["An Suidhe",3.0023879999999998,"Edinbane",6.7491469999999998,"Marchwood",0.37629800000000002]
["Arecleoch",2.0478710000000002,"Ewe Hill",2.3997959999999998,"Millennium Wind ",1.8004960000000001]
["Baglan Bay",0.75026700000000002,"Fallago",1.8259000000000001E-2,"Moffat",0.177954]
["Beinneun Wind Farm",1.480658,"Farr",3.5155069999999999,"Mossford",2.839493]
["Bhlaraidh Wind Farm",0.64882099999999998,"Fernoch",4.3370759999999997,"Nant",-1.2112050000000001]
["Black Hill",1.531255,"Ffestiniogg",0.24945700000000001,"Necton",1.1087590000000001]
["BlackCraig Wind Farm",6.2069460000000003,"Finlarig",0.315718,"Rhigos",0.100477]
["Black Law",1.722917,"Foyers",0.742448,"Rocksavage",1.7458999999999999E-2]
["BlackLaw Extension",3.6536680000000001,"Galawhistle",1.458315,"Saltend",0.336368]
["Clyde (North)",0.10813200000000001,"Glendoe",1.813672,"South Humber Bank",0.93801400000000001]
["Clyde (South)",0.12504899999999999,"Glenglass",4.744186,"Spalding",0.27648]
["Corriegarth",3.108511,"Gordonbush",1.169225,"Strathbrora",0.77983499999999994]
["Corriemoillie",1.6409549999999999,"Griffin Wind",9.5650449999999996,"Stronelairg",1.413146]
["Coryton",5.2904E-2,"Hadyard Hill",5.9374989999999999,"Strathy Wind",2.0036369999999999]
["Cruachan",1.7985720000000001,"Harestanes",2.4826929999999998,"Wester Dod",0.28713100000000003]
["Crystal Rig",-4.8382000000000001E-2,"Hartlepool",0.59630000000000005,"Whitelee",0.104644]
["Culligran",1.7089270000000001,"Hedon",0.178507,"Whitelee Extension",0.29091]
["Deanie",2.8075230000000002,"Invergarry",-0.67513800000000002,"Gills Bay",2.4831159999999999]
["Dersalloch",2.375095,"Kilgallioch",1.0377179999999999,"Kype Muir",1.4624919999999999]
["Didcot",0.51970700000000003,"Kilmorack",0.19472900000000001,"Middle Muir",1.9544429999999999]
["Dinorwig",2.3656999999999999,"Langage",0.64871199999999996,"Dorenell",2.0692629999999999]
["Dunlaw Extension",1.4814970000000001,"Lochay",0.36081999999999997,"Millennium South",0.92898000000000003]
["Aberdeen Bay",2.5708440000000001,"Middleton",0.11003,"Killingholme",0.70452700000000001]

{"sheet":"TN A-Z","index":12,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Table N - Onshore Local Circuit Tariffs",null,null,null,null,null,null,"Return to Index"]
[]
["Substation Name","(£/kW)","Substation Name","(£/kW)","Substation Name","(£/kW)"]
["Achruach",{"$f":"IF(ISNA(VLOOKUP(A4,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A4,TN!$C$4:$D$28,2,0)),VLOOKUP(A4,TN!$E$4:$F$28,2,0),VLOOKUP(A4,TN!$C$4:$D$28,2,0)),VLOOKUP(A4,TN!$A$4:$B$28,2,0))","v":4.2336660000000004},"Dunhill",{"$f":"IF(ISNA(VLOOKUP(C4,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C4,TN!$C$4:$D$28,2,0)),VLOOKUP(C4,TN!$E$4:$F$28,2,0),VLOOKUP(C4,TN!$C$4:$D$28,2,0)),VLOOKUP(C4,TN!$A$4:$B$28,2,0))","v":1.412272},"Lochay",{"$f":"IF(ISNA(VLOOKUP(E4,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E4,TN!$C$4:$D$28,2,0)),VLOOKUP(E4,TN!$E$4:$F$28,2,0),VLOOKUP(E4,TN!$C$4:$D$28,2,0)),VLOOKUP(E4,TN!$A$4:$B$28,2,0))","v":0.36081999999999997}]
["Aberdeen Bay",{"$f":"IF(ISNA(VLOOKUP(A5,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A5,TN!$C$4:$D$28,2,0)),VLOOKUP(A5,TN!$E$4:$F$28,2,0),VLOOKUP(A5,TN!$C$4:$D$28,2,0)),VLOOKUP(A5,TN!$A$4:$B$28,2,0))","v":2.5708440000000001},"Dunlaw Extension",{"$f":"IF(ISNA(VLOOKUP(C5,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C5,TN!$C$4:$D$28,2,0)),VLOOKUP(C5,TN!$E$4:$F$28,2,0),VLOOKUP(C5,TN!$C$4:$D$28,2,0)),VLOOKUP(C5,TN!$A$4:$B$28,2,0))","v":1.4814970000000001},"Luichart",{"$f":"IF(ISNA(VLOOKUP(E5,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E5,TN!$C$4:$D$28,2,0)),VLOOKUP(E5,TN!$E$4:$F$28,2,0),VLOOKUP(E5,TN!$C$4:$D$28,2,0)),VLOOKUP(E5,TN!$A$4:$B$28,2,0))","v":0.56596900000000006}]
["Aigas",{"$f":"IF(ISNA(VLOOKUP(A6,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A6,TN!$C$4:$D$28,2,0)),VLOOKUP(A6,TN!$E$4:$F$28,2,0),VLOOKUP(A6,TN!$C$4:$D$28,2,0)),VLOOKUP(A6,TN!$A$4:$B$28,2,0))","v":0.644872},"Edinbane",{"$f":"IF(ISNA(VLOOKUP(C6,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C6,TN!$C$4:$D$28,2,0)),VLOOKUP(C6,TN!$E$4:$F$28,2,0),VLOOKUP(C6,TN!$C$4:$D$28,2,0)),VLOOKUP(C6,TN!$A$4:$B$28,2,0))","v":6.7491469999999998},"Marchwood",{"$f":"IF(ISNA(VLOOKUP(E6,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E6,TN!$C$4:$D$28,2,0)),VLOOKUP(E6,TN!$E$4:$F$28,2,0),VLOOKUP(E6,TN!$C$4:$D$28,2,0)),VLOOKUP(E6,TN!$A$4:$B$28,2,0))","v":0.37629800000000002}]
["An Suidhe",{"$f":"IF(ISNA(VLOOKUP(A7,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A7,TN!$C$4:$D$28,2,0)),VLOOKUP(A7,TN!$E$4:$F$28,2,0),VLOOKUP(A7,TN!$C$4:$D$28,2,0)),VLOOKUP(A7,TN!$A$4:$B$28,2,0))","v":3.0023879999999998},"Ewe Hill",{"$f":"IF(ISNA(VLOOKUP(C7,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C7,TN!$C$4:$D$28,2,0)),VLOOKUP(C7,TN!$E$4:$F$28,2,0),VLOOKUP(C7,TN!$C$4:$D$28,2,0)),VLOOKUP(C7,TN!$A$4:$B$28,2,0))","v":2.3997959999999998},"Mark Hill",{"$f":"IF(ISNA(VLOOKUP(E7,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E7,TN!$C$4:$D$28,2,0)),VLOOKUP(E7,TN!$E$4:$F$28,2,0),VLOOKUP(E7,TN!$C$4:$D$28,2,0)),VLOOKUP(E7,TN!$A$4:$B$28,2,0))","v":0.86331100000000005}]
["Arecleoch",{"$f":"IF(ISNA(VLOOKUP(A8,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A8,TN!$C$4:$D$28,2,0)),VLOOKUP(A8,TN!$E$4:$F$28,2,0),VLOOKUP(A8,TN!$C$4:$D$28,2,0)),VLOOKUP(A8,TN!$A$4:$B$28,2,0))","v":2.0478710000000002},"Fallago",{"$f":"IF(ISNA(VLOOKUP(C8,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C8,TN!$C$4:$D$28,2,0)),VLOOKUP(C8,TN!$E$4:$F$28,2,0),VLOOKUP(C8,TN!$C$4:$D$28,2,0)),VLOOKUP(C8,TN!$A$4:$B$28,2,0))","v":1.8259000000000001E-2},"Middle Muir",{"$f":"IF(ISNA(VLOOKUP(E8,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E8,TN!$C$4:$D$28,2,0)),VLOOKUP(E8,TN!$E$4:$F$28,2,0),VLOOKUP(E8,TN!$C$4:$D$28,2,0)),VLOOKUP(E8,TN!$A$4:$B$28,2,0))","v":1.9544429999999999}]
["Baglan Bay",{"$f":"IF(ISNA(VLOOKUP(A9,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A9,TN!$C$4:$D$28,2,0)),VLOOKUP(A9,TN!$E$4:$F$28,2,0),VLOOKUP(A9,TN!$C$4:$D$28,2,0)),VLOOKUP(A9,TN!$A$4:$B$28,2,0))","v":0.75026700000000002},"Farr",{"$f":"IF(ISNA(VLOOKUP(C9,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C9,TN!$C$4:$D$28,2,0)),VLOOKUP(C9,TN!$E$4:$F$28,2,0),VLOOKUP(C9,TN!$C$4:$D$28,2,0)),VLOOKUP(C9,TN!$A$4:$B$28,2,0))","v":3.5155069999999999},"Middleton",{"$f":"IF(ISNA(VLOOKUP(E9,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E9,TN!$C$4:$D$28,2,0)),VLOOKUP(E9,TN!$E$4:$F$28,2,0),VLOOKUP(E9,TN!$C$4:$D$28,2,0)),VLOOKUP(E9,TN!$A$4:$B$28,2,0))","v":0.11003}]
["Beinneun Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A10,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A10,TN!$C$4:$D$28,2,0)),VLOOKUP(A10,TN!$E$4:$F$28,2,0),VLOOKUP(A10,TN!$C$4:$D$28,2,0)),VLOOKUP(A10,TN!$A$4:$B$28,2,0))","v":1.480658},"Fernoch",{"$f":"IF(ISNA(VLOOKUP(C10,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C10,TN!$C$4:$D$28,2,0)),VLOOKUP(C10,TN!$E$4:$F$28,2,0),VLOOKUP(C10,TN!$C$4:$D$28,2,0)),VLOOKUP(C10,TN!$A$4:$B$28,2,0))","v":4.3370759999999997},"Millennium South",{"$f":"IF(ISNA(VLOOKUP(E10,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E10,TN!$C$4:$D$28,2,0)),VLOOKUP(E10,TN!$E$4:$F$28,2,0),VLOOKUP(E10,TN!$C$4:$D$28,2,0)),VLOOKUP(E10,TN!$A$4:$B$28,2,0))","v":0.92898000000000003}]
["Bhlaraidh Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A11,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A11,TN!$C$4:$D$28,2,0)),VLOOKUP(A11,TN!$E$4:$F$28,2,0),VLOOKUP(A11,TN!$C$4:$D$28,2,0)),VLOOKUP(A11,TN!$A$4:$B$28,2,0))","v":0.64882099999999998},"Ffestiniogg",{"$f":"IF(ISNA(VLOOKUP(C11,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C11,TN!$C$4:$D$28,2,0)),VLOOKUP(C11,TN!$E$4:$F$28,2,0),VLOOKUP(C11,TN!$C$4:$D$28,2,0)),VLOOKUP(C11,TN!$A$4:$B$28,2,0))","v":0.24945700000000001},"Millennium Wind ",{"$f":"IF(ISNA(VLOOKUP(E11,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E11,TN!$C$4:$D$28,2,0)),VLOOKUP(E11,TN!$E$4:$F$28,2,0),VLOOKUP(E11,TN!$C$4:$D$28,2,0)),VLOOKUP(E11,TN!$A$4:$B$28,2,0))","v":1.8004960000000001}]
["Black Hill",{"$f":"IF(ISNA(VLOOKUP(A12,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A12,TN!$C$4:$D$28,2,0)),VLOOKUP(A12,TN!$E$4:$F$28,2,0),VLOOKUP(A12,TN!$C$4:$D$28,2,0)),VLOOKUP(A12,TN!$A$4:$B$28,2,0))","v":1.531255},"Finlarig",{"$f":"IF(ISNA(VLOOKUP(C12,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C12,TN!$C$4:$D$28,2,0)),VLOOKUP(C12,TN!$E$4:$F$28,2,0),VLOOKUP(C12,TN!$C$4:$D$28,2,0)),VLOOKUP(C12,TN!$A$4:$B$28,2,0))","v":0.315718},"Moffat",{"$f":"IF(ISNA(VLOOKUP(E12,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E12,TN!$C$4:$D$28,2,0)),VLOOKUP(E12,TN!$E$4:$F$28,2,0),VLOOKUP(E12,TN!$C$4:$D$28,2,0)),VLOOKUP(E12,TN!$A$4:$B$28,2,0))","v":0.177954}]
["Black Law",{"$f":"IF(ISNA(VLOOKUP(A13,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A13,TN!$C$4:$D$28,2,0)),VLOOKUP(A13,TN!$E$4:$F$28,2,0),VLOOKUP(A13,TN!$C$4:$D$28,2,0)),VLOOKUP(A13,TN!$A$4:$B$28,2,0))","v":1.722917},"Foyers",{"$f":"IF(ISNA(VLOOKUP(C13,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C13,TN!$C$4:$D$28,2,0)),VLOOKUP(C13,TN!$E$4:$F$28,2,0),VLOOKUP(C13,TN!$C$4:$D$28,2,0)),VLOOKUP(C13,TN!$A$4:$B$28,2,0))","v":0.742448},"Mossford",{"$f":"IF(ISNA(VLOOKUP(E13,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E13,TN!$C$4:$D$28,2,0)),VLOOKUP(E13,TN!$E$4:$F$28,2,0),VLOOKUP(E13,TN!$C$4:$D$28,2,0)),VLOOKUP(E13,TN!$A$4:$B$28,2,0))","v":2.839493}]
["BlackCraig Wind Farm",{"$f":"IF(ISNA(VLOOKUP(A14,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A14,TN!$C$4:$D$28,2,0)),VLOOKUP(A14,TN!$E$4:$F$28,2,0),VLOOKUP(A14,TN!$C$4:$D$28,2,0)),VLOOKUP(A14,TN!$A$4:$B$28,2,0))","v":6.2069460000000003},"Galawhistle",{"$f":"IF(ISNA(VLOOKUP(C14,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C14,TN!$C$4:$D$28,2,0)),VLOOKUP(C14,TN!$E$4:$F$28,2,0),VLOOKUP(C14,TN!$C$4:$D$28,2,0)),VLOOKUP(C14,TN!$A$4:$B$28,2,0))","v":1.458315},"Nant",{"$f":"IF(ISNA(VLOOKUP(E14,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E14,TN!$C$4:$D$28,2,0)),VLOOKUP(E14,TN!$E$4:$F$28,2,0),VLOOKUP(E14,TN!$C$4:$D$28,2,0)),VLOOKUP(E14,TN!$A$4:$B$28,2,0))","v":-1.2112050000000001}]
["BlackLaw Extension",{"$f":"IF(ISNA(VLOOKUP(A15,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A15,TN!$C$4:$D$28,2,0)),VLOOKUP(A15,TN!$E$4:$F$28,2,0),VLOOKUP(A15,TN!$C$4:$D$28,2,0)),VLOOKUP(A15,TN!$A$4:$B$28,2,0))","v":3.6536680000000001},"Gills Bay",{"$f":"IF(ISNA(VLOOKUP(C15,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C15,TN!$C$4:$D$28,2,0)),VLOOKUP(C15,TN!$E$4:$F$28,2,0),VLOOKUP(C15,TN!$C$4:$D$28,2,0)),VLOOKUP(C15,TN!$A$4:$B$28,2,0))","v":2.4831159999999999},"Necton",{"$f":"IF(ISNA(VLOOKUP(E15,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E15,TN!$C$4:$D$28,2,0)),VLOOKUP(E15,TN!$E$4:$F$28,2,0),VLOOKUP(E15,TN!$C$4:$D$28,2,0)),VLOOKUP(E15,TN!$A$4:$B$28,2,0))","v":1.1087590000000001}]
["Clyde (North)",{"$f":"IF(ISNA(VLOOKUP(A16,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A16,TN!$C$4:$D$28,2,0)),VLOOKUP(A16,TN!$E$4:$F$28,2,0),VLOOKUP(A16,TN!$C$4:$D$28,2,0)),VLOOKUP(A16,TN!$A$4:$B$28,2,0))","v":0.10813200000000001},"Glendoe",{"$f":"IF(ISNA(VLOOKUP(C16,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C16,TN!$C$4:$D$28,2,0)),VLOOKUP(C16,TN!$E$4:$F$28,2,0),VLOOKUP(C16,TN!$C$4:$D$28,2,0)),VLOOKUP(C16,TN!$A$4:$B$28,2,0))","v":1.813672},"Rhigos",{"$f":"IF(ISNA(VLOOKUP(E16,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E16,TN!$C$4:$D$28,2,0)),VLOOKUP(E16,TN!$E$4:$F$28,2,0),VLOOKUP(E16,TN!$C$4:$D$28,2,0)),VLOOKUP(E16,TN!$A$4:$B$28,2,0))","v":0.100477}]
["Clyde (South)",{"$f":"IF(ISNA(VLOOKUP(A17,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A17,TN!$C$4:$D$28,2,0)),VLOOKUP(A17,TN!$E$4:$F$28,2,0),VLOOKUP(A17,TN!$C$4:$D$28,2,0)),VLOOKUP(A17,TN!$A$4:$B$28,2,0))","v":0.12504899999999999},"Glenglass",{"$f":"IF(ISNA(VLOOKUP(C17,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C17,TN!$C$4:$D$28,2,0)),VLOOKUP(C17,TN!$E$4:$F$28,2,0),VLOOKUP(C17,TN!$C$4:$D$28,2,0)),VLOOKUP(C17,TN!$A$4:$B$28,2,0))","v":4.744186},"Rocksavage",{"$f":"IF(ISNA(VLOOKUP(E17,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E17,TN!$C$4:$D$28,2,0)),VLOOKUP(E17,TN!$E$4:$F$28,2,0),VLOOKUP(E17,TN!$C$4:$D$28,2,0)),VLOOKUP(E17,TN!$A$4:$B$28,2,0))","v":1.7458999999999999E-2}]
["Corriegarth",{"$f":"IF(ISNA(VLOOKUP(A18,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A18,TN!$C$4:$D$28,2,0)),VLOOKUP(A18,TN!$E$4:$F$28,2,0),VLOOKUP(A18,TN!$C$4:$D$28,2,0)),VLOOKUP(A18,TN!$A$4:$B$28,2,0))","v":3.108511},"Gordonbush",{"$f":"IF(ISNA(VLOOKUP(C18,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C18,TN!$C$4:$D$28,2,0)),VLOOKUP(C18,TN!$E$4:$F$28,2,0),VLOOKUP(C18,TN!$C$4:$D$28,2,0)),VLOOKUP(C18,TN!$A$4:$B$28,2,0))","v":1.169225},"Saltend",{"$f":"IF(ISNA(VLOOKUP(E18,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E18,TN!$C$4:$D$28,2,0)),VLOOKUP(E18,TN!$E$4:$F$28,2,0),VLOOKUP(E18,TN!$C$4:$D$28,2,0)),VLOOKUP(E18,TN!$A$4:$B$28,2,0))","v":0.336368}]
["Corriemoillie",{"$f":"IF(ISNA(VLOOKUP(A19,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A19,TN!$C$4:$D$28,2,0)),VLOOKUP(A19,TN!$E$4:$F$28,2,0),VLOOKUP(A19,TN!$C$4:$D$28,2,0)),VLOOKUP(A19,TN!$A$4:$B$28,2,0))","v":1.6409549999999999},"Griffin Wind",{"$f":"IF(ISNA(VLOOKUP(C19,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C19,TN!$C$4:$D$28,2,0)),VLOOKUP(C19,TN!$E$4:$F$28,2,0),VLOOKUP(C19,TN!$C$4:$D$28,2,0)),VLOOKUP(C19,TN!$A$4:$B$28,2,0))","v":9.5650449999999996},"South Humber Bank",{"$f":"IF(ISNA(VLOOKUP(E19,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E19,TN!$C$4:$D$28,2,0)),VLOOKUP(E19,TN!$E$4:$F$28,2,0),VLOOKUP(E19,TN!$C$4:$D$28,2,0)),VLOOKUP(E19,TN!$A$4:$B$28,2,0))","v":0.93801400000000001}]
["Coryton",{"$f":"IF(ISNA(VLOOKUP(A20,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A20,TN!$C$4:$D$28,2,0)),VLOOKUP(A20,TN!$E$4:$F$28,2,0),VLOOKUP(A20,TN!$C$4:$D$28,2,0)),VLOOKUP(A20,TN!$A$4:$B$28,2,0))","v":5.2904E-2},"Hadyard Hill",{"$f":"IF(ISNA(VLOOKUP(C20,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C20,TN!$C$4:$D$28,2,0)),VLOOKUP(C20,TN!$E$4:$F$28,2,0),VLOOKUP(C20,TN!$C$4:$D$28,2,0)),VLOOKUP(C20,TN!$A$4:$B$28,2,0))","v":5.9374989999999999},"Spalding",{"$f":"IF(ISNA(VLOOKUP(E20,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E20,TN!$C$4:$D$28,2,0)),VLOOKUP(E20,TN!$E$4:$F$28,2,0),VLOOKUP(E20,TN!$C$4:$D$28,2,0)),VLOOKUP(E20,TN!$A$4:$B$28,2,0))","v":0.27648}]
["Cruachan",{"$f":"IF(ISNA(VLOOKUP(A21,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A21,TN!$C$4:$D$28,2,0)),VLOOKUP(A21,TN!$E$4:$F$28,2,0),VLOOKUP(A21,TN!$C$4:$D$28,2,0)),VLOOKUP(A21,TN!$A$4:$B$28,2,0))","v":1.7985720000000001},"Harestanes",{"$f":"IF(ISNA(VLOOKUP(C21,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C21,TN!$C$4:$D$28,2,0)),VLOOKUP(C21,TN!$E$4:$F$28,2,0),VLOOKUP(C21,TN!$C$4:$D$28,2,0)),VLOOKUP(C21,TN!$A$4:$B$28,2,0))","v":2.4826929999999998},"Strathbrora",{"$f":"IF(ISNA(VLOOKUP(E21,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E21,TN!$C$4:$D$28,2,0)),VLOOKUP(E21,TN!$E$4:$F$28,2,0),VLOOKUP(E21,TN!$C$4:$D$28,2,0)),VLOOKUP(E21,TN!$A$4:$B$28,2,0))","v":0.77983499999999994}]
["Crystal Rig",{"$f":"IF(ISNA(VLOOKUP(A22,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A22,TN!$C$4:$D$28,2,0)),VLOOKUP(A22,TN!$E$4:$F$28,2,0),VLOOKUP(A22,TN!$C$4:$D$28,2,0)),VLOOKUP(A22,TN!$A$4:$B$28,2,0))","v":-4.8382000000000001E-2},"Hartlepool",{"$f":"IF(ISNA(VLOOKUP(C22,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C22,TN!$C$4:$D$28,2,0)),VLOOKUP(C22,TN!$E$4:$F$28,2,0),VLOOKUP(C22,TN!$C$4:$D$28,2,0)),VLOOKUP(C22,TN!$A$4:$B$28,2,0))","v":0.59630000000000005},"Strathy Wind",{"$f":"IF(ISNA(VLOOKUP(E22,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E22,TN!$C$4:$D$28,2,0)),VLOOKUP(E22,TN!$E$4:$F$28,2,0),VLOOKUP(E22,TN!$C$4:$D$28,2,0)),VLOOKUP(E22,TN!$A$4:$B$28,2,0))","v":2.0036369999999999}]
["Culligran",{"$f":"IF(ISNA(VLOOKUP(A23,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A23,TN!$C$4:$D$28,2,0)),VLOOKUP(A23,TN!$E$4:$F$28,2,0),VLOOKUP(A23,TN!$C$4:$D$28,2,0)),VLOOKUP(A23,TN!$A$4:$B$28,2,0))","v":1.7089270000000001},"Hedon",{"$f":"IF(ISNA(VLOOKUP(C23,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C23,TN!$C$4:$D$28,2,0)),VLOOKUP(C23,TN!$E$4:$F$28,2,0),VLOOKUP(C23,TN!$C$4:$D$28,2,0)),VLOOKUP(C23,TN!$A$4:$B$28,2,0))","v":0.178507},"Stronelairg",{"$f":"IF(ISNA(VLOOKUP(E23,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E23,TN!$C$4:$D$28,2,0)),VLOOKUP(E23,TN!$E$4:$F$28,2,0),VLOOKUP(E23,TN!$C$4:$D$28,2,0)),VLOOKUP(E23,TN!$A$4:$B$28,2,0))","v":1.413146}]
["Deanie",{"$f":"IF(ISNA(VLOOKUP(A24,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A24,TN!$C$4:$D$28,2,0)),VLOOKUP(A24,TN!$E$4:$F$28,2,0),VLOOKUP(A24,TN!$C$4:$D$28,2,0)),VLOOKUP(A24,TN!$A$4:$B$28,2,0))","v":2.8075230000000002},"Invergarry",{"$f":"IF(ISNA(VLOOKUP(C24,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C24,TN!$C$4:$D$28,2,0)),VLOOKUP(C24,TN!$E$4:$F$28,2,0),VLOOKUP(C24,TN!$C$4:$D$28,2,0)),VLOOKUP(C24,TN!$A$4:$B$28,2,0))","v":-0.67513800000000002},"Wester Dod",{"$f":"IF(ISNA(VLOOKUP(E24,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E24,TN!$C$4:$D$28,2,0)),VLOOKUP(E24,TN!$E$4:$F$28,2,0),VLOOKUP(E24,TN!$C$4:$D$28,2,0)),VLOOKUP(E24,TN!$A$4:$B$28,2,0))","v":0.28713100000000003}]
["Dersalloch",{"$f":"IF(ISNA(VLOOKUP(A25,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A25,TN!$C$4:$D$28,2,0)),VLOOKUP(A25,TN!$E$4:$F$28,2,0),VLOOKUP(A25,TN!$C$4:$D$28,2,0)),VLOOKUP(A25,TN!$A$4:$B$28,2,0))","v":2.375095},"Kilgallioch",{"$f":"IF(ISNA(VLOOKUP(C25,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C25,TN!$C$4:$D$28,2,0)),VLOOKUP(C25,TN!$E$4:$F$28,2,0),VLOOKUP(C25,TN!$C$4:$D$28,2,0)),VLOOKUP(C25,TN!$A$4:$B$28,2,0))","v":1.0377179999999999},"Whitelee",{"$f":"IF(ISNA(VLOOKUP(E25,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E25,TN!$C$4:$D$28,2,0)),VLOOKUP(E25,TN!$E$4:$F$28,2,0),VLOOKUP(E25,TN!$C$4:$D$28,2,0)),VLOOKUP(E25,TN!$A$4:$B$28,2,0))","v":0.104644}]
["Didcot",{"$f":"IF(ISNA(VLOOKUP(A26,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A26,TN!$C$4:$D$28,2,0)),VLOOKUP(A26,TN!$E$4:$F$28,2,0),VLOOKUP(A26,TN!$C$4:$D$28,2,0)),VLOOKUP(A26,TN!$A$4:$B$28,2,0))","v":0.51970700000000003},"Killingholme",{"$f":"IF(ISNA(VLOOKUP(C26,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C26,TN!$C$4:$D$28,2,0)),VLOOKUP(C26,TN!$E$4:$F$28,2,0),VLOOKUP(C26,TN!$C$4:$D$28,2,0)),VLOOKUP(C26,TN!$A$4:$B$28,2,0))","v":0.70452700000000001},"Whitelee Extension",{"$f":"IF(ISNA(VLOOKUP(E26,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(E26,TN!$C$4:$D$28,2,0)),VLOOKUP(E26,TN!$E$4:$F$28,2,0),VLOOKUP(E26,TN!$C$4:$D$28,2,0)),VLOOKUP(E26,TN!$A$4:$B$28,2,0))","v":0.29091}]
["Dinorwig",{"$f":"IF(ISNA(VLOOKUP(A27,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A27,TN!$C$4:$D$28,2,0)),VLOOKUP(A27,TN!$E$4:$F$28,2,0),VLOOKUP(A27,TN!$C$4:$D$28,2,0)),VLOOKUP(A27,TN!$A$4:$B$28,2,0))","v":2.3656999999999999},"Kilmorack",{"$f":"IF(ISNA(VLOOKUP(C27,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C27,TN!$C$4:$D$28,2,0)),VLOOKUP(C27,TN!$E$4:$F$28,2,0),VLOOKUP(C27,TN!$C$4:$D$28,2,0)),VLOOKUP(C27,TN!$A$4:$B$28,2,0))","v":0.19472900000000001}]
["Dorenell",{"$f":"IF(ISNA(VLOOKUP(A28,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A28,TN!$C$4:$D$28,2,0)),VLOOKUP(A28,TN!$E$4:$F$28,2,0),VLOOKUP(A28,TN!$C$4:$D$28,2,0)),VLOOKUP(A28,TN!$A$4:$B$28,2,0))","v":2.0692629999999999},"Kype Muir",{"$f":"IF(ISNA(VLOOKUP(C28,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C28,TN!$C$4:$D$28,2,0)),VLOOKUP(C28,TN!$E$4:$F$28,2,0),VLOOKUP(C28,TN!$C$4:$D$28,2,0)),VLOOKUP(C28,TN!$A$4:$B$28,2,0))","v":1.4624919999999999}]
["Dumnaglass",{"$f":"IF(ISNA(VLOOKUP(A29,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(A29,TN!$C$4:$D$28,2,0)),VLOOKUP(A29,TN!$E$4:$F$28,2,0),VLOOKUP(A29,TN!$C$4:$D$28,2,0)),VLOOKUP(A29,TN!$A$4:$B$28,2,0))","v":1.830606},"Langage",{"$f":"IF(ISNA(VLOOKUP(C29,TN!$A$4:$B$28,2,0)),IF(ISNA(VLOOKUP(C29,TN!$C$4:$D$28,2,0)),VLOOKUP(C29,TN!$E$4:$F$28,2,0),VLOOKUP(C29,TN!$C$4:$D$28,2,0)),VLOOKUP(C29,TN!$A$4:$B$28,2,0))","v":0.64871199999999996}]

{"sheet":"TO","index":13,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table O - 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":"TP","index":14,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,1,2,3]]}
["Table P - Offshore Local Tariffs",null,null,"Return to Index"]
[]
["Offshore Generator","Tariff Component (£/kW)"]
[null,"Substation","Circuit","ETUoS"]
["Barrow",7.9773300000000003,41.737380000000002,1.0363960000000001]
["Burbo Bank",10.335699,19.789100999999999,0]
["Dudgeon",14.972203,23.345723,0]
["Greater Gabbard",14.956555083413724,34.368690851758956,0]
["Gunfleet",17.264665999999998,15.850315,2.9625149999999998]
["Gwynt Y Mor",18.214690380552216,17.943720090036013,0]
["Humber Gateway",14.494729471284327,32.704940593350059,0]
["Lincs",14.908307000000001,58.369428410444392,0]
["London Array",10.148476,34.56514315595858,0]
["Ormonde",24.661619000000002,45.942286000000003,0.36612099999999997]
["Robin Rigg East",{"$f":"B16","v":-0.45620699999999997},{"$f":"C16","v":30.219788999999999},9.3665040000000008]
["Robin Rigg West",-0.45620699999999997,30.219788999999999,9.3665040000000008]
["Sheringham Shoal",23.827399,27.943956,0.60741900000000004]
["Thanet",18.145429325222704,33.811420700438767,0.81396029809865711]
["Walney 1",21.284146,42.387321999999998,0]
["Walney 2",21.129352000000001,42.760756000000001,0]
["West of Duddon Sands",8.2129707929770408,40.525921199819919,0]
["Westermost Rough",17.29375633262589,29.253635208952339,0]

{"sheet":"TQ","index":15,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table Q - Contracted and Modelled TEC",null,null,null,null,"Return to Index"]
[]
["Generation (GW)","2018/19","2019/20 Initial Forecast","2019/20 April Forecast","2019/20 June Forecast","2019/20 Draft Tariffs","2019/20 Final Tariffs"]
["Contracted TEC",79.028809999999993,85.464610000000022,{"$f":"85938.76/1000","v":85.938759999999988},83.9,80.556650000000005]
["Modelled Best View TEC",79.028809999999993,77.680610000000016,{"$f":"77496.86/1000","v":77.496859999999998},77.7,80.556650000000005]
["Chargeable TEC",71.934310000000025,73.833610000000022,{"$f":"71711.76/1000","v":71.711759999999998},71.900000000000006,73.324650000000005]

{"sheet":"TR","index":16,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Table R - 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]
["IFA2","Chilling 400kV","France",26,0,1100,0]
["ElecLink","Sellindge 400kV","France",24,0,1000,0]
["BritNed","Grain 400kV","Netherlands",24,0,1200,0]
["Belgium Interconnector (Nemo)","Richborough 400kV","Belgium",24,0,1000,0]
["East - West","Connah's Quay 400kV","Republic of Ireland",16,0,505,0]
["Moyle","Auchencrosh 275kV","Northern Ireland",10,0,307,0]

{"sheet":"TS","index":17,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,0,3,0],[2,2,2,6]]}
["Table S - Allowed Revenues",null,null,null,null,null,"Return to Index"]
[]
["£m Nominal Value","2018/19 TNUoS Revenue","2019/20 TNUoS Revenue"]
[null,{"$f":"TEE!D5","v":"2018/19 (fixed forecast)"},{"$f":"TEE!E5","v":"Initial Forecast"},{"$f":"TEE!F5","v":"April Forecast"},{"$f":"TEE!G5","v":"June Forecast"},{"$f":"TEE!H5","v":"Nov Draft"},"Jan \n2019 Final"]
["National Grid"]
["Price controlled revenue",1653.9179700263246,1768.5197291650261,1728.1223686166347,1770.6013999438635,{"$f":"F8+F7","v":1737.7075641887611}]
["Less income from connections",44.002400999999999,41.882612399999999,44.002400999999999,44.002400999999999,31.61]
["Income from TNUoS",{"$f":"+B6-B7","v":1609.9155690263246},1726.6371167650261,1684.1199676166348,1726.5989989438635,1706.0975641887612]
[]
["Scottish Power Transmission"]
["Price controlled revenue",364.83,404.5082414306442,404.5082414306442,404.5082414306442,397.54632788457468]
["Less income from connections",14.869146848602265,14.532127031019199,14.532127031019199,14.532127031019199,14.5]
["Income from TNUoS",{"$f":"+B11-B12","v":349.96085315139771},389.97611439962503,389.97611439962503,389.97611439962503,383.04632788457468]
[]
["SHE Transmission"]
["Price controlled revenue",369.81799999999998,352.85033470848703,352.85033470848703,352.85033470848703,341.20864336283182]
["Less income from connections",3.4071159999999998,3.4635076286130482,3.4635076286130482,3.4635076286130482,3.4025073746312677]
["Income from TNUoS",{"$f":"+B16-B17","v":366.41088400000001},349.38682707987397,349.38682707987397,349.38682707987397,337.80613598820054]
[]
["Offshore",318.14381186500032,466.66162681762478,386.47878665563246,387.43985204476695,388.38619450276207]
["Network Innovation Competition",32.664404040000001,42.5,32.664404040000001,32.664404040000001,32.664404040000001]
[]
["Interconnectors (Cap & Floor)",-6.8,-6.8,-6.8,-6.8,-8.4]
["Total to Collect from TNUoS",{"$f":"+B23+B21+B20+B18+B13+B8","v":2670.2955220827225},{"$f":"+C23+C21+C20+C18+C13+C8","v":2968.3616850621502},2835.826099791766,2879.2661965081297,{"$f":"+F23+F21+F20+F18+F13+F8","v":2839.6006266042987}]

{"sheet":"TT","index":18,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Table T - Generation and Demand Revenue Proportions",null,null,null,null,null,"Return to Index"]
[]
[null,null,{"$f":"TQ!C3","v":"2019/20 Initial Forecast"},{"$f":"TQ!D3","v":"2019/20 April Forecast"},{"$f":"TQ!E3","v":"2019/20 June Forecast"},{"$f":"TQ!F3","v":"2019/20 Draft Tariffs"},{"$f":"TQ!G3","v":"2019/20 Final Tariffs"}]
["CAPEC","Limit on generation tariff (€/MWh)",2.5,2.5,2.5,2.5]
["y","Error Margin",0.21,0.21,0.21,0.21]
["ER","Exchange Rate (€/£)",1.0900000000000001,1.1299999999999999,1.124927,1.124927]
["MAR","Total Revenue (£m)",2968.3616850621493,2835.8126099188039,2879.2521943684746,2839.5542987197236]
["GO","Generation Output (TWh)",243.12236122457247,247.03485845324252,229.83357135990477,229.83357135990477]
["G","% of revenue from generation",0.1484050535056938,0.15225422987595572,0.14014464841765573,0.14210391633203351]
["D","% of revenue from demand",0.85159494649430623,0.84774577012404428,0.85985535158234427,0.85789608366796655]
["G.R","Revenue recovered from generation (£m)",440.51987469589966,{"$f":"D7*D9","v":431.76446499571148},403.51178648553361,403.51178648553355]
["D.R","Revenue recovered from demand (£m)",2527.8418103662498,{"$f":"D7*D10","v":2404.0481449230924},2475.7404078829409,2436.0425122341903]

{"sheet":"TU","index":19,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Table U - Charging Bases",null,null,null,"Return to Index"]
[]
["Charging Bases",{"$f":"TQ!D3","v":"2019/20 April Forecast"},{"$f":"TQ!E3","v":"2019/20 June Forecast"},{"$f":"TQ!F3","v":"2019/20 Draft Tariffs"},{"$f":"TQ!G3","v":"2019/20 Final Tariffs"}]
["Generation (GW)",71.711759999999984,71.910959999999989,73.324649999999991]
["NHH Demand (4pm-7pm TWh)",25.512098981321838,25.512098981321838,25.512098981321838]
["Net Charging"]
["Total Average Net Triad (GW)",43.572821858760001,43.572821858760001,43.572821858760001]
["HH  Demand Average Net Triad (GW)",10.254642452956,10.254642452956,10.254642452956]
["Gross charging"]
["Total Average Gross Triad (GW)",51.325629881540003,51.325629881540003,51.325629881539996]
["HH Demand Average Gross Triad (GW)",18.007450475736,18.007450475736,18.007450475736]
["Embedded Generation Export (GW)",7.75280802278,7.75280802278,7.75280802278]

{"sheet":"TV","index":20,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Table V - Residual Calculation",null,null,null,null,"Return to Index"]
[]
[null,"Component",{"$f":"TQ!D3","v":"2019/20 April Forecast"},{"$f":"TQ!E3","v":"2019/20 June Forecast"},{"$f":"TQ!F3","v":"2019/20 Draft Tariffs"},{"$f":"TQ!G3","v":"2019/20 Final Tariffs"}]
["G","Proportion of revenue recovered from generation (%)",0.15225422987595572,0.14014464841765573,0.14210391633203351]
["D","Proportion of revenue recovered from demand (%)",0.84774577012404428,0.85985535158234427,0.85789608366796655]
["R","Total TNUoS revenue (£m)",2835.8126099188039,2879.2521943684746,2839.5542987197236]
["Generation Residual"]
["RG","Generator residual tariff (£/kW)",-3.2912402716384705,-3.6130603651697628,-3.5374568044202386]
["ZG","Revenue recovered from the locational element of generator tariffs (£m)",330.71220221052158,329.09945382201983,333.63545226636705]
["O","Revenue recovered from offshore local tariffs (£m)",298.70558008131661,295.95369689863878,289.00026481897936]
["LG","Revenue recovered from onshore local substation tariffs (£m)",19.24758904918,19.240538614640002,19.37683965982]
["SG","Revenue recovered from onshore local circuit tariffs (£m)",19.119726116766145,19.03673654754331,20.882011814599721]
["BG","Generator charging base (GW)",71.711759999999984,71.910959999999989,73.324649999999991]
["Gross Demand Residual"]
["RD","Demand residual tariff (£/kW)",50.298595774651638,51.697065773793433,50.822880972832635]
["ZD","Revenue recovered from the locational element of demand tariffs (£m)",-66.685577739219312,-66.725593360095743,-61.90480689235153]
["EE","Amount to be paid to Embedded Export Tariffs (£m)",110.87338762864964,110.9184626243141,110.56905919862743]
["BD","Demand Gross charging base (GW)",51.325629881540003,51.325629881540003,51.325629881539996]

{"sheet":"TW","index":21,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,2],[0,0,0,4]]}
["Table W - Small Generator Discount"]
[]
["Small Generator Discount Calculation"]
["Generator Residual (£/kW)","G",-3.5374568044202417]
["Demand Residual (£/kW)","D",50.822880972832635]
["Small Generator Discount (£/kW)","T = (G + D)/4",11.821356]
["Forecast Small Generator Volume (kW)","V",2759260]
["2017/18 SGD cost (£)","V x T",32618194.756559998]
["Prior year reconcilation (£)","R",0]
["Total SGD Cost (£)","C = (V x T) + R",32618194.756559998]
["Total System Triad Demand (kW)","TD",51325629.881539993]
["Total HH Triad Demand (kW)","HHD",18007450.475736]
["Total NHH Consumption (kWh)","NHHD",25512098981.321838]
["Increase in HH Demand tariff (£/kW)","HHT = C/TD",0.63551474832053845]
["Total Cost to HH Customers (£)","HHC = HHT * HHD",11444000.356981924]
["Increase in NHH Demand tariff (p/kWh)","NHHT = (C - HHC)/NHHD",8.2996677047546444E-2]
["Total Cost to NHH Customers (£)","NHHC = NHHT * NHHD",21174194.399578072]

{"sheet":"TY","index":22,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,4,2],[4,3,4,4],[4,5,4,6]]}
["Table Y - Demand Locational Tariffs",null,null,null,null,null,"Return to Index"]
[]
[]
[]
["Zone",{"$f":"Residuals!B3","v":"2019/20 June"},"2019/20 April",{"$f":"Residuals!C3","v":"2019/20 Draft"},"2019/20 June (£/kW)","Changes"]
[null,"Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)","Peak (£/kW)","Year Round (£/kW)"]
[1,-2.0412450726915945,-28.538571553183434,-1.5239750812755033,-28.903803276745602,{"$f":"D7-B7","v":0.5172699914160912},{"$f":"E7-C7","v":-0.36523172356216804}]
[2,-2.2447355247916572,-20.655198530507644,-1.8008259710082122,-18.842830823983366,{"$f":"D8-B8","v":0.44390955378344499},{"$f":"E8-C8","v":1.8123677065242774}]
[3,-3.5788331008029823,-6.8261039729431099,-3.9006021174270362,-6.4717635106886489,-0.32176901662405388,0.35434046225446103]
[4,-1.1241210081862911,-2.4439919678877691,-1.4322726241876964,-2.1351949971757209,-0.30815161600140528,0.30879697071204815]
[5,-2.8392059564937848,-0.4365107434962272,-3.2685694614566412,-9.1161573975407612E-2,-0.42936350496285636,0.34534916952081962]
[6,-2.2595580255543681,0.27389003167399151,-2.5054789746831334,0.4517980954176079,-0.24592094912876528,0.1779080637436164]
[7,-2.1589022108686726,2.3229301509767084,-2.5256287267143165,2.5663497854719028,-0.36672651584564386,0.24341963449519444]
[8,-1.4363065432233166,2.8977073584640296,-1.7184954819014304,3.2475130956595604,-0.28218893867811379,0.34980573719553076]
[9,1.359902704818573,0.84699833211192366,1.3670460189047309,1.0222323005488596,7.1433140861578703E-3,0.17523396843693595]
[10,-6.14432423759615,4.4998972270102957,-5.9963269210500121,4.3229206139761533,0.1479973165461379,-0.17697661303414236]
[11,4.2137715826503959,0.73729069342247833,3.9569288244466905,0.7548726981336471,-0.25684275820370539,1.7582004711168775E-2]
[12,5.6561897422208647,2.4088378639300796,5.7351625026585893,2.0415768374845964,7.897276043772461E-2,-0.3672610264454832]
[13,1.8169245291263321,4.314971979340263,1.9184977990440715,4.0212345844068613,0.10157326991773941,-0.29373739493340167]
[14,-0.95592019244338344,5.3998883713837156,-0.68023771665145794,4.9678673876081447,0.27568247579192551,-0.43202098377557085]

{"sheet":"TZ","index":23,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[2,0,3,1],[2,2,2,4],[2,5,2,7],[2,8,2,10]]}
["Table Z - Breakdown of the Embedded Export Tariff",null,null,null,null,null,null,null,null,null,null,"Return to Index"]
[]
["Demand Zone",null,{"$f":"Residuals!B3","v":"2019/20 June"},null,null,{"$f":"Residuals!C3","v":"2019/20 Draft"},null,null,"Changes"]
[null,null,"Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)","Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)","Locational (£/kW)","AGIC (£/kW)","Phased Residual (£/kW)"]
[1,"Northern Scotland",-30.579816999999998,3.3272680000000001,14.65,-30.427778358021104,3.3272680000000001,14.65,{"$f":"F5-C5","v":0.15203864197889416},{"$f":"G5-D5","v":0},0]
[2,"Southern Scotland",-22.899933999999998,3.3272680000000001,14.65,-20.643656794991578,3.3272680000000001,14.65,{"$f":"F6-C6","v":2.2562772050084199},{"$f":"G6-D6","v":0},{"$f":"H6-E6","v":0}]
[3,"Northern",-10.404937,3.3272680000000001,14.65,-10.372365628115684,3.3272680000000001,14.65,3.2571371884316136E-2,0,0]
[4,"North West",-3.5681129999999999,3.3272680000000001,14.65,-3.5674676213634173,3.3272680000000001,14.65,6.4537863658253869E-4,0,0]
[5,"Yorkshire",-3.2757170000000002,3.3272680000000001,14.65,-3.3597310354320489,3.3272680000000001,14.65,-8.4014035432048662E-2,0,0]
[6,"N Wales & Mersey",-1.985668,3.3272680000000001,14.65,-2.0536808792655257,3.3272680000000001,14.65,-6.8012879265525683E-2,0,0]
[7,"East Midlands",0.16402800000000001,3.3272680000000001,14.65,4.0721058757586359E-2,3.3272680000000001,14.65,-0.12330694124241365,0,0]
[8,"Midlands",1.461401,3.3272680000000001,14.65,1.5290176137581299,3.3272680000000001,14.65,6.7616613758129995E-2,0,0]
[9,"Eastern",2.2069009999999998,3.3272680000000001,14.65,2.3892783194535907,3.3272680000000001,14.65,0.18237731945359092,0,0]
[10,"South Wales",-1.6444270000000001,3.3272680000000001,14.65,-1.6734063070738587,3.3272680000000001,14.65,-2.8979307073858651E-2,0,0]
[11,"South East",4.9510620000000003,3.3272680000000001,14.65,4.7118015225803376,3.3272680000000001,14.65,-0.23926047741966272,0,0]
[12,"London",8.0650279999999999,3.3272680000000001,14.65,7.7767393401431857,3.3272680000000001,14.65,-0.28828865985681418,0,0]
[13,"Southern",6.1318970000000004,3.3272680000000001,14.65,5.9397323834509326,3.3272680000000001,14.65,-0.1921646165490678,0,0]
[14,"South Western",4.4439679999999999,3.3272680000000001,14.65,4.2876296709566866,3.3272680000000001,14.65,-0.15633832904331335,0,0]

{"sheet":"TAA","index":24,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,0,18,1],[2,0,3,0],[2,1,3,1],[2,2,2,6],[2,7,2,11]]}
["Table AA - Demand Profiles",null,null,null,null,null,null,"Return to Index"]
[]
["Zone","Zone Name",{"$f":"Residuals!B3","v":"2019/20 June"},null,null,null,null,{"$f":"Residuals!C3","v":"2019/20 Draft"}]
[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",499.4470878504585,1483.1581980599999,427.58099095348541,0.78417740827603,958.03354100000001,716,1483.1581980599999,427.58099095348541,0.78417740827603,958.03354100000001]
[2,"Southern Scotland",2695.2802337591597,3444.3512881749998,1125.6193456983801,1.7712229685994472,678.45211199999994,2961,3444.3512881749998,1125.6193456983801,1.7712229685994472,678.45211199999994]
[3,"Northern",2702.3018897993657,2575.9529187349995,902.07940785267442,1.3176976488981178,438.64920239999998,2018,2575.9529187349995,902.07940785267442,1.3176976488981178,438.64920239999998]
[4,"North West",3067.4972273778667,4037.4046861050001,1413.353912556697,2.023841932113466,410.12000715000005,3103,4037.4046861050001,1413.353912556697,2.023841932113466,410.12000715000005]
[5,"Yorkshire",4384.0810294471312,3818.4646561599993,1495.2762792970595,1.8253089893201262,807.53373749999992,3417,3818.4646561599993,1495.2762792970595,1.8253089893201262,807.53373749999992]
[6,"N Wales & Mersey",2557.7445581819634,2627.7808294499996,991.00236734188491,1.2983116701150454,550.43923969999992,2217,2627.7808294499996,991.00236734188491,1.2983116701150454,550.43923969999992]
[7,"East Midlands",5375.7499999999991,4651.1254094899996,1717.461032432876,2.2393722031630907,639.19339848000004,5407,4651.1254094899996,1717.461032432876,2.2393722031630907,639.19339848000004]
[8,"Midlands",4424.72,4251.4588521649994,1388.5716972475714,2.1714337960257994,335.0919945,4777,4251.4588521649994,1388.5716972475714,2.1714337960257994,335.0919945]
[9,"Eastern",6238.2137738786842,6447.1848001049993,1931.3322439446451,3.2377270298612606,805.69248284999992,5122,6447.1848001049993,1931.3322439446451,3.2377270298612606,805.69248284999992]
[10,"South Wales",1673.9196255192999,1821.8665522399999,778.90072875383839,0.88419467755153347,509.70056670000008,1371,1821.8665522399999,778.90072875383839,0.88419467755153347,509.70056670000008]
[11,"South East",3870.8045207727018,3906.2703441649992,1059.9055823903232,2.0083136803934449,410.92357874999999,3611,3906.2703441649992,1059.9055823903232,2.0083136803934449,410.92357874999999]
[12,"London",5599.2426459072658,4186.8787037349994,2202.526200933848,1.8709621594887456,170.83104875000001,5444,4186.8787037349994,2202.526200933848,1.8709621594887456,170.83104875000001]
[13,"Southern",6565.8930395182133,5476.4880377549989,1933.2113283909596,2.677801362684086,692.67385979999995,7342,5476.4880377549989,1933.2113283909596,2.677801362684086,692.67385979999995]
[14,"South Western",2210.0784100137666,2597.2446051999996,640.62935794175746,1.401733454831644,345.47325319999999,2030,2597.2446051999996,640.62935794175746,1.401733454831644,345.47325319999999]
["Total",null,51864.974042025882,51325.629881539993,18007.450475736001,25.512098981321838,7752.8080227800001,49536,51325.629881539993,18007.450475736001,25.512098981321838,7752.8080227800001]

{"sheet":"TBB","index":25,"n_rows":153,"n_cols":13,"rows_kept":153,"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 BB - 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,2013,2014,2015,2016,2017,2013,2014,2015,2016,2017]
["ABERTHAW","Coal","Actual","Actual","Actual","Actual","Actual",0.65541257807655495,0.59004330923389103,0.54261128391407498,0.50833521943176097,5.0742028560084002E-2,0.54699699999999996]
["ACHRUACH","Onshore_Wind","Generic","Generic","Partial","Actual","Actual",0,0,0.33646357776295172,0.36714027556546602,0.44346390039290601,0.38235599999999997]
["AFTON","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.34873806267123292,0.372641]
["AIKENGALL II","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.3350822747390737,0.368089]
["AN SUIDHE","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.41584343083405201,0.36942157479099302,0.35490004883714898,0.34093801902193099,0.41232310667896799,0.378882]
["ARECLEOCH","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.33829642123287701,0.29729821857726502,0.36861218962707298,0.197246025594809,0.351728172314348,0.32910800000000001]
["BAGLAN BAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.164106310386473,0.37919411976374801,0.29122807938016398,0.55203024845311399,0.24289057598769101,0.30443799999999999]
["BARROW","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.54108013952308398,0.47023147767630602,0.47179137573365698,0.44258400177574803,0.47041739599188198,0.47081299999999998]
["BARRY","CCGT_CHP","Actual","Actual","Actual","Partial","Actual",1.2989333719210201E-2,4.00253553283169E-3,2.1726858795488899E-2,0.24346810070366304,5.4067842222869896E-3,1.3374E-2]
["BEAULY CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.356682727170123,0.371167481389517,0.35009377714184697,0.304872009743754,0.21993679137922001,0.33721600000000002]
["BEINNEUN","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.30962259491185495,0.25821378974487902,0.31747599999999998]
["BHLARAIDH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.3343385073251417,0.46320944740402498,0.39404699999999998]
["BLACK LAW","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.31964758858824799,0.26788123500503003,0.26903507340001898,0.23462257952170901,0.21213706756442999,0.25718000000000002]
["BLACKCRAIG WINDFARM","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.36020780297841432,0.37646499999999999]
["BLACKLAW EXTENSION","Onshore_Wind","Generic","Generic","Partial","Actual","Actual",0,0,0.33463518219555971,0.13109509959632101,0.30487027968036501,0.25686700000000001]
["BRIMSDOWN","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.18764508209105599,0.11122891513340501,0.16446307094672999,0.45061451646297801,0.27616835465350498,0.209426]
["BURBO BANK EXT","Offshore_Wind","Generic","Generic","Actual","Actual","Actual",0,0,0.16778070946818099,0.25023333288390298,0.49385001842663501,0.30395499999999998]
["CARRAIG GHEAL","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.45276001588247,0.489276742108398,0.456253571216441,0.40421056680563799,0.45537137184832199,0.454795]
["CARRINGTON","CCGT_CHP","Generic","Generic","Partial","Actual","Actual",0,0,0.3873179456354211,0.58011467672738204,0.588066414019771,0.51849999999999996]
["CLUNIE","Hydro","Actual","Actual","Actual","Actual","Actual",0.45325597142822799,0.43248848709835902,0.47971062125601699,0.32829734596531501,0.32169911552151798,0.40468100000000001]
["CLYDE (NORTH)","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.42659796826401603,0.36888200338329902,0.414119955832082,0.26885827469840801,0.39261850077119598,0.39187300000000003]
["CLYDE (SOUTH)","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.39894143162029799,0.29411498571286998,0.399615108709797,0.34875075158115898,0.39163405708471899,0.37977499999999997]
["CONNAHS QUAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.12823325623717799,0.18373886208722101,0.28271331694979002,0.37458810965521799,0.20084575565813001,0.22243299999999999]
["CONON CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.54282017709389496,0.55528666747692201,0.58986017229552101,0.486782110595463,0.50854726848313003,0.535551]
["CORBY","CCGT_CHP","Actual","Actual","Actual","Generic","Partial",8.0833811305070696E-2,9.6755250856876099E-2,4.5411090613629801E-2,0,0.44650267471817034,7.4332999999999996E-2]
["CORRIEGARTH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.2256446215719359,0.41201308318443502,0.34075]
["CORRIEMOILLIE","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.32231556767602521,0.30421041816870897,0.33704000000000001]
["CORYTON","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",9.7852081906392704E-2,0.17512277825342501,0.26399989725637502,0.63038258875570796,0.16402197017694101,0.201048]
["COTTAM","Coal","Actual","Actual","Actual","Actual","Actual",0.67395065987442904,0.51442571974885798,0.34415738035063798,0.14938710884703199,0.21658024514840199,0.35838799999999998]
["COTTAM DEVELOPMENT CENTRE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.16024885613548401,0.31313200682041498,0.28238223679831898,0.67248224669094303,0.56300656789377601,0.38617400000000002]
["COUR","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.38324651608781651,0.55427298140104797,0.44070399999999998]
["COWES","Gas_Oil","Actual","Actual","Actual","Actual","Actual",9.5630609352857798E-4,3.1354939414300299E-3,4.91223919730298E-3,5.3193958798981996E-3,6.94162998615058E-3,4.4559999999999999E-3]
["CRUACHAN","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",9.6968557233291799E-2,9.0515564030718101E-2,8.8672791180245097E-2,7.1914205064342096E-2,9.6225170454545497E-2,9.1804999999999998E-2]
["CRYSTAL RIG II","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.50254902637151699,0.47595772367811501,0.48383573641799299,0.40267936437032598,0.52580234597313202,0.48744700000000002]
["CRYSTAL RIG III","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.39950324776240453,0.51902032459797798,0.43437199999999998]
["DAMHEAD CREEK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.77178298732238504,0.67464099449785897,0.64898267657740205,0.68111906733032701,0.63510756785501599,0.66824799999999995]
["DEESIDE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.17303464157467799,0.13901820499179901,0.174579468789407,0.27109004171057199,0.20816400035813401,0.18525900000000001]
["DERSALLOCH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.33772827680984346,0.39857562868109397,0.37363200000000002]
["DIDCOT B","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.186624277581382,0.25534496906760901,0.41138874162700501,0.50135842185888901,0.441233777213139,0.36932199999999998]
["DIDCOT GTS","Gas_Oil","Actual","Actual","Actual","Actual","Actual",9.0184133905595704E-4,2.84283027319559E-3,4.8611452983037999E-3,4.5171427134897701E-4,6.3372002139125798E-3,2.869E-3]
["DINORWIG","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",0.150897882433979,0.15064992945149899,0.14635290296391601,0.15959556169383099,0.14946748554311201,0.150338]
["DRAX","Coal","Actual","Actual","Actual","Actual","Actual",0.80515072689948997,0.82214882916342302,0.76202974091981301,0.62270490335673701,0.55889599091784803,0.729962]
["DUDGEON","Offshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.42479123656399509,0.46978164326484001,0.463364]
["DUNGENESS B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.61006793810905702,0.54691735244298501,0.70761712753741102,0.79340330167886197,0.68208599259612801,0.66659000000000002]
["DUNLAW EXTENSION","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.348226027397261,0.30079745596868901,0.29120287841912801,0.26554948390314997,0.31084012125398103,0.30094700000000002]
["DUNMAGLASS","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.38971283211726665,0.756935856893034,0.51041400000000003]
["EDINBANE WIND","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.39478456918801003,0.31245787009463399,0.355936875786455,0.32500929510511201,0.34592910517724501,0.34229199999999999]
["EGGBOROUGH","Coal","Actual","Actual","Actual","Partial","Actual",0.72184276055641805,0.45742090994680601,0.27015724542514002,0.40028347224945743,7.1714846409298497E-2,0.48314000000000001]
["ERROCHTY","Hydro","Actual","Actual","Actual","Actual","Actual",0.28262804566209998,0.25358466666666701,0.28150746812386201,0.16177510502283099,0.13608132115677299,0.232289]
["EWE HILL","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.33331440986692951,0.33184895796745101,0.34991899999999998]
["FALLAGO","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.54868317716260695,0.44726670709665101,0.55799188708004499,0.43217618673896502,0.494158411022324,0.49670300000000001]
["FARR WINDFARM","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.44721190688902102,0.38571157186817601,0.40996274723806098,0.34176565291840399,0.38304598471312301,0.39290700000000001]
["FASNAKYLE G1 & G3","Hydro","Actual","Actual","Actual","Actual","Actual",0.35369476622989898,0.57483445006948597,0.53157307505741702,0.30976839884852098,0.38167328022632502,0.42231400000000002]
["FAWLEY CHP","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.63361911955956296,0.72848387954453497,0.57697838489428499,0.632006259753772,0.760792769204092,0.66470300000000004]
["FFESTINIOG","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",5.4631331494165401E-2,4.3250886288686001E-2,3.4113434780408798E-2,5.6748704020801601E-2,4.2117838977676299E-2,4.6667E-2]
["FIDDLERS FERRY","Coal","Actual","Actual","Actual","Actual","Actual",0.49037387413162697,0.45243520014799399,0.27459099161581302,8.2478041080199002E-2,0.139908421362331,0.28897800000000001]
["FINLARIG","Hydro","Actual","Actual","Actual","Actual","Actual",0.59914200913241999,0.59409224436142305,0.65134884362753098,0.49640155666251601,0.52641482634564896,0.57321599999999995]
["FOYERS","Pumped_Storage","Actual","Actual","Actual","Actual","Actual",0.147097059360731,0.12304765791476401,0.15432328969338199,0.113046172374429,0.145333159436834,0.138493]
["FREASDAIL","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.32560000103742975,0.38970883726192102,0.36663400000000002]
["GALAWHISTLE","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.34976463860960666,0.42445535743829199,0.38627099999999998]
["GALLOPER","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.54759290999865684,0.51287700000000003]
["GARRY CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.55930840843547303,0.64382752042778102,0.60277189387402896,0.61049780401345799,0.60000964011055002,0.60442600000000002]
["GLANDFORD BRIGG","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",1.56726410369716E-2,5.4007747827367796E-3,1.81907428106199E-2,2.7682205617822E-2,1.84180838060975E-2,1.7427000000000002E-2]
["GLEN APP","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.25137326719852493,0.248393296746932,0.29478700000000002]
["GLENDOE","Hydro","Actual","Actual","Actual","Actual","Actual",0.36380152641225899,0.32349442821817398,0.348531586003127,0.23860458746417801,0.240105310790244,0.30404399999999998]
["GLENMORISTON","Hydro","Actual","Actual","Actual","Actual","Actual",0.44459442383308001,0.48748697044647399,0.50692112078779605,0.346708965943683,0.44395957635717898,0.45867999999999998]
["GORDONBUSH","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.46559426451402502,0.47798074853229,0.47716060206869598,0.50412572080887097,0.34176195694716299,0.47357900000000003]
["GRAIN","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.413833251312336,0.44003087697299798,0.39789525285981697,0.53822697901710603,0.397755364544297,0.41725299999999999]
["GRANGEMOUTH","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.55904693683409401,0.62616791286149198,0.59827419171220397,0.51455779109588995,0.58978594939117202,0.58236900000000003]
["GREAT YARMOUTH","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.20740867157111401,0.186633121089126,0.598956855899615,0.63512032949997199,0.501520629404138,0.43596200000000002]
["GREATER GABBARD","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.48303838013698602,0.42132704178082198,0.50246784858834204,0.43113151301369901,0.46493850981735102,0.45970299999999997]
["GRIFFIN WIND","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.31956575911426399,0.31315162916370198,0.310283896707019,0.25822831413394698,0.28896986809802699,0.30413499999999999]
["GUNFLEET SANDS I","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.56647192969225302,0.47013226582747403,0.50465008382700005,0.45794015019586098,0.47301896188426201,0.48259999999999997]
["GUNFLEET SANDS II","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.52236125677796796,0.44721115689212398,0.49052130827356599,0.43989288670091298,0.46992754530536501,0.46922000000000003]
["GWYNT Y MOR","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",8.0035578386605799E-2,0.61618518157837898,0.63127610364584397,0.448323335998282,0.504030505306031,0.52284600000000003]
["HADYARD HILL","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.319488341529095,0.27763546423135499,0.36652655843457499,0.31436362732595802,0.340375022282559,0.32474199999999998]
["HARESTANES","Onshore_Wind","Partial","Actual","Actual","Actual","Actual",0.24141903753342409,0.28635514423425401,0.27809293828130799,0.22546389403880401,0.29012459543378999,0.284858]
["HARTLEPOOL","Nuclear","Actual","Actual","Actual","Actual","Actual",0.737556674724684,0.56280333026901697,0.53866646784165795,0.78039047981145004,0.80621774296058402,0.69358299999999995]
["HEYSHAM","Nuclear","Actual","Actual","Actual","Actual","Actual",0.73362806206759101,0.68825209852353597,0.72734398547746304,0.79616878170588201,0.85161689582172095,0.75238000000000005]
["HINKLEY POINT B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.68866352327825597,0.70141130281830399,0.67641227236746504,0.71226459331399705,0.834643153267142,0.70077999999999996]
["HUMBER GATEWAY","Offshore_Wind","Generic","Partial","Actual","Actual","Actual",0,0.43934259907638029,0.62963062489650701,0.59719514476961399,0.54991295973432897,0.59224600000000005]
["HUNTERSTON","Nuclear","Actual","Actual","Actual","Actual","Actual",0.847952648635664,0.79136830459257002,0.82178591270143997,0.83293933870734604,0.79864447069802602,0.81779000000000002]
["IMMINGHAM","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.37821875501420898,0.56831612756896199,0.69468623295527698,0.71955030591358005,0.64317510881300999,0.63539199999999996]
["INDIAN QUEENS","Gas_Oil","Actual","Actual","Actual","Actual","Actual",2.3211529680365302E-3,8.7568493150684903E-4,7.22710122300286E-4,8.4737442922374403E-4,7.4029109589041097E-4,8.2100000000000001E-4]
["KEADBY","CCGT_CHP","Actual","Generic","Partial","Actual","Actual",6.2901873077998299E-7,0,0.35185791673461503,0.28607587136916801,0.38695736550848198,0.22434499999999999]
["KEITH HILL","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.36985771518264854,0.37968099999999999]
["KILBRAUR","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.51377731206978805,0.543549614939004,0.50380721053204003,0.46534190349621801,0.56750149253731297,0.52037800000000001]
["KILGALLIOCH","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.25273920687061607,0.25325405952094798,0.29686200000000001]
["KILLIN CASCADE","Hydro","Actual","Actual","Actual","Actual","Actual",0.455355871630579,0.44820519222271299,0.53234830189787896,0.27496182979820299,0.34923094896155599,0.417597]
["KILLINGHOLME (POWERGEN)","Gas_Oil","Generic","Generic","Generic","Generic","Partial",0,0,0,0,5.4426092085235927E-3,3.6240000000000001E-3]
["LANGAGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.40874856984283198,0.34862899921794199,0.16531039232557401,0.44541262456166902,0.42336801193269302,0.39358199999999999]
["LINCS WIND FARM","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.465986773515982,0.438178385844749,0.491306424778235,0.445192400203339,0.51091140393122103,0.46749499999999999]
["LITTLE BARFORD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.33628590043810902,0.49664404387264,0.39982893621080101,0.648596694742687,0.66306726983833197,0.51502300000000001]
["LOCHLUICHART","Onshore_Wind","Partial","Actual","Actual","Actual","Actual",0.27672843103202965,0.202103088809477,0.29266281084184698,0.31689689299186002,0.343321940970154,0.31762699999999999]
["LONDON ARRAY","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.51270301116184702,0.64088023646444903,0.66868203335068099,0.53624547655287402,0.50551464032035898,0.563276]
["LYNEMOUTH","Coal","Generic","Generic","Partial","Generic","Actual",0,0,0.68019590251732409,0,1.07832272496656E-2,0.35571399999999997]
["MARCHWOOD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.48684462455606298,0.66402085743277495,0.55087936395108394,0.75424782174409399,0.67369242493051396,0.62953099999999995]
["MARK HILL","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.30286296273646401,0.26794246790729698,0.34022684469189302,0.21965297880589299,0.31091456664082001,0.29390699999999997]
["MEDWAY","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.14554548744292201,0.28096225684931497,0.34179949796591003,0.35150475724536401,0.36726104075420102,0.32475599999999999]
["MILLENNIUM","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.52661775553213896,0.53263637161924804,0.48403756830601102,0.44976350544432703,0.53648756585879898,0.51443099999999997]
["MINNYGAP","Onshore_Wind","Generic","Generic","Generic","Generic","Actual",0,0,0,0,0.30996197260274,0.35971599999999998]
["NANT","Hydro","Actual","Actual","Actual","Actual","Actual",0.355883485540335,0.36404047184170502,0.37378785670916798,0.30635013698630098,0.34902575342465703,0.35631699999999999]
["ORMONDE","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.49656084094368302,0.42871113394216198,0.47198584168184599,0.41218757229832598,0.37716158295281599,0.43762800000000002]
["PEMBROKE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.60392779833506705,0.67534601032848096,0.64559626876473897,0.77647842086793295,0.70286596891281095,0.67460299999999995]
["PEN Y CYMOEDD","Onshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.26944647543301026,0.36094778398622102,0.33832899999999999]
["PETERBOROUGH","CCGT_CHP","Actual","Actual","Partial","Actual","Actual",1.83111746342372E-2,1.0929220948653401E-2,4.1031739247611623E-2,1.7913749883515101E-2,4.3488631068865904E-3,1.5717999999999999E-2]
["PETERHEAD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.41881070118411901,4.8577519977168896E-3,0.23381269296448101,0.42229194520547902,0.65780801080042794,0.35830499999999998]
["RACE BANK","Offshore_Wind","Generic","Generic","Generic","Partial","Actual",0,0,0,0.45306214474534423,0.38197767608929001,0.44352000000000003]
["RAMPION","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.40988458053652976,0.466974]
["RATCLIFFE-ON-SOAR","Coal","Actual","Actual","Actual","Actual","Actual",0.717403170646567,0.56176677811066,0.196813985540261,0.15465655751594601,0.193779864730829,0.31745400000000001]
["ROBIN RIGG EAST","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.46756217738733402,0.553208902868771,0.51970033088817602,0.50509602690093303,0.42559880757395302,0.49745299999999998]
["ROBIN RIGG WEST","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.48062881179273398,0.53414963519952396,0.56088136161598101,0.51538305290847697,0.473990817947191,0.51005400000000001]
["ROCKSAVAGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",2.6154584954055999E-2,4.4251747561869302E-2,0.198061320667206,0.58680632039573799,0.29812207692090897,0.180145]
["RYE HOUSE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",7.4694763387297594E-2,5.3701021809241002E-2,7.7905599978345896E-2,0.156538393045311,0.13473585656352799,9.5779000000000003E-2]
["SALTEND","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.69006230759651399,0.67951750726442595,0.55622808960506698,0.77401942963885395,0.70159584142797904,0.69039200000000001]
["SANQUHAR","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.3520975587138509,0.37376100000000001]
["SEABANK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.18278149907861699,0.25695602811882501,0.27213631809566802,0.41681524906936601,0.554605918403973,0.315303]
["SELLAFIELD","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.25022062895861003,0.18971908307556301,0.28678966155473301,0.19858754308440099,0.136007126233613,0.212842]
["SEVERN POWER","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.32416296817083001,0.246354070641955,0.183226499383907,0.64424587201181804,0.55691995366639901,0.37581199999999998]
["SHERINGHAM SHOAL","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.49351672718707001,0.46228559650648698,0.53618380316303904,0.46971540552294,0.54307147568311898,0.499805]
["SHOREHAM","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.20750114943466,0.102239023700805,0.48951352730072001,0.68986288948684504,0.64299415035877405,0.44667000000000001]
["SIZEWELL B","Nuclear","Actual","Actual","Actual","Actual","Actual",0.82505061918863198,0.84792408129511598,0.98782564327603695,0.81635853057032604,0.73370826104752496,0.82977800000000002]
["SLOY G2 & G3","Hydro","Actual","Actual","Actual","Actual","Actual",0.143470861872146,0.15594133847031999,0.139438866120219,8.1781719463470307E-2,0.120303067922374,0.134404]
["SOUTH HUMBER BANK","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.243372537444699,0.344672563207363,0.486753363016934,0.55341943091493295,0.34617422602390102,0.39253300000000002]
["SPALDING","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.33479965909090897,0.39309199486301399,0.479407452858504,0.60974755059153196,0.529683071035699,0.46739399999999998]
["STAYTHORPE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.37621608862358402,0.56614805229633003,0.69442160164170097,0.65779093798529298,0.52070147359312802,0.58154700000000004]
["STRATHY NORTH & SOUTH","Onshore_Wind","Generic","Generic","Partial","Actual","Actual",0,0,0.49633997511837152,0.36198723621109402,0.40231283938618001,0.420213]
["STRONELAIRG","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.37536553170038206,0.381517]
["SUTTON BRIDGE","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",9.4123529780721499E-2,0.17202490786737401,0.13199924048831199,0.38018402537340901,0.29187766389227099,0.19863400000000001]
["TAYLORS LANE","Gas_Oil","Actual","Actual","Actual","Actual","Actual",4.8263651065448999E-4,6.4048230593607297E-4,1.70770719489982E-3,8.0470684297311006E-3,1.1712294174622899E-2,3.4650000000000002E-3]
["THANET","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.39748861149162801,0.35593473325723002,0.41343358492714,0.337132357686454,0.38506919672755002,0.379498]
["TODDLEBURN","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.39537385431143102,0.33721112517371699,0.35082324829730199,0.31343541956191101,0.38015814638343198,0.35606399999999999]
["TORNESS","Nuclear","Actual","Actual","Actual","Actual","Actual",0.86466944171975102,0.914945432098766,0.85772513492545299,0.97994229362797602,0.864413034242422,0.88134299999999999]
["USKMOUTH","Coal","Actual","Partial","Actual","Actual","Actual",0.38989883958705601,0.46942842721361921,0.25518398664338499,0.24330435053400001,9.9967738733373001E-4,0.29612899999999998]
["WALNEY 4","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.4520329757771554,0.48102400000000001]
["WALNEY I","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.57704640787294903,0.52055501154097095,0.50753480541544105,0.47461680716543703,0.55947165437302404,0.52918699999999996]
["WALNEY II","Offshore_Wind","Actual","Actual","Actual","Actual","Actual",0.61921902064830203,0.58235492184755899,0.35798761609519802,0.54972707737467996,0.62828977495107696,0.58376700000000004]
["WALNEY III","Offshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.50176200649993052,0.49759999999999999]
["WEST BURTON","Coal","Actual","Actual","Actual","Actual","Actual",0.68917587279646397,0.61536402029860804,0.32732506774452902,0.10107107477140199,0.11819860497342299,0.35362900000000003]
["WEST BURTON B","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",0.30302118792052302,0.468420860137581,0.59347685253559601,0.54287794643958998,0.63242001277420501,0.53492499999999998]
["WEST OF DUDDON SANDS","Offshore_Wind","Partial","Actual","Actual","Actual","Actual",0.4048096442541857,0.40050571852064398,0.48753974712471099,0.48769068050873798,0.554034060699514,0.50975499999999996]
["WESTERMOST ROUGH","Offshore_Wind","Generic","Partial","Actual","Actual","Actual",0,0.26289956433901318,0.54801391276822597,0.58106107250250605,0.63474022663993801,0.58793799999999996]
["WHITELEE","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.35107409810261198,0.29810464668014103,0.31877331773119499,0.27289283778725898,0.29633575829029102,0.30440499999999998]
["WHITELEE EXTENSION","Onshore_Wind","Actual","Actual","Actual","Actual","Actual",0.27010190994205902,0.27778665935186397,0.26765484906361098,0.23525274249678599,0.25166449827104698,0.26313999999999999]
["WHITESIDE HILL","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.38370395355995268,0.384297]
["WILTON","CCGT_CHP","Actual","Actual","Actual","Actual","Actual",4.4940875651492102E-2,0.215866700106084,0.16137916965649199,0.14412988600667101,0.155749761164545,0.153753]
["WINDY STANDARD II","Onshore_Wind","Generic","Generic","Generic","Generic","Partial",0,0,0,0,0.43298126354827943,0.40072200000000002]

{"sheet":"TCC","index":26,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Table CC - Generic Annual Load Factors",null,null,null,"Return to Index"]
[]
[]
["Technology","Generic ALF"]
["Biomass",0.268847]
["CCGT_CHP",0.48637900000000001]
["Coal",0.376162]
["Gas_Oil",2.715E-3]
["Hydro",0.42416500000000001]
["Nuclear",0.76317800000000002]
["Offshore_Wind",0.49551899999999999]
["Onshore_Wind",0.38459300000000002]
["Pumped_Storage",0.106826]
["Tidal",0.189]
["Wave",0.31]

{"sheet":"TDD","index":27,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Table DD - Generation Contracted TEC Changes",null,null,null,"Return to Index"]
[]
[]
["Power Station","MW Change","Node","Generation Zone"]
["Auchencrosh (interconnector CCT)",227,"AUCH20",10]
["Carnedd Wen Wind Farm",-150,"TRAW40",18]
["CDCL",50,"COTT40",16]
["Crookedstane Windfarm",-26.8,"CLYS2R",11]
["Eggborough",-1870,"EGGB40",15]
["Holyhead",-210,"WYLF40",19]
["Marex",-1500,"CONQ40",16]
["Millennium South",-25,"MILS1Q",3]
["Pogbie Wind Farm",-2.2000000000000011,"DUNE10",11]
["Robin Rigg East Offshore Wind Farm",6,"HARK40",12]
["Spalding",70,"SPLN40",17]
["Spalding Energy Expansion",-9.9999999999909051E-3,"SPLN40",17]
["Whitson Substation",49.9,"WHSO20",21]

{"sheet":"TEE","index":28,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Table EE - Indicative National Grid Revenue Forecast",null,null,null,null,null,null,null,"Return to Index"]
[]
[null,null,null,null,null,null,null,null," "]
["Description"," ",null,null,null,null,null,null,"Notes"]
["Regulatory Year"," ","Licence Term","2018/19 (fixed forecast)","Initial Forecast","April Forecast","June Forecast","Nov Draft"]
["Actual RPI"," "," "," ",null,null,null,null,"April to March average"]
["RPI Actual"," ","RPIAt"," ",null,null,null,null,"Office of National Statistics"]
["Assumed Interest Rate"," ","It",7.0500000000000007E-3,5.6249999999999998E-3,1.1599999999999999E-2,1.1599999999999999E-2,1.0899999999999998E-2,"Bank of England Base Rate"]
["Opening Base Revenue Allowance (2009/10 prices)","A1","PUt",1587.627,1585.2280000000001,1585.2280000000001,1585.2280000000001,1585.2280000000001,"From Licence"]
["Price Control Financial Model Iteration Adjustment","A2","MODt",-310.24084085000004,-334,-334,-334,-376.6,"Forecast"]
["RPI True Up","A3","TRUt",-6.0845942150118297,3.2656364182877167,3.2656364182877167,3.2656364182877167,3.2659148150527995,"Forecast"]
["Prior Calendar Year RPI Forecast"," ","GRPIFc-1",3.5999999999999997E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.3250000000000002E-2,"HM Treasury Forecast"]
["Current Calendar Year RPI Forecast"," ","GRPIFc",3.4000000000000002E-2,0.03,0.03,0.03,3.075E-2,"HM Treasury Forecast"]
["Next Calendar Year RPI forecast"," ","GRPIFc+1",3.1E-2,0.03,0.03,0.03,3.4000000000000002E-2,"HM Treasury Forecast"]
["RPI Forecast","A4","RPIFt",1.3140000000000001,1.357,1.357,1.357,1.357,"Using HM Treasury Forecast"]
["Base Revenue [A=(A1+A2+A3)*A4]","A","BRt",{"$f":"SUM(D9:D11)*D15","v":1670.4902563245746},1702.3478646196163,{"$f":"SUM(F9:F11)*F15","v":1702.3478646196163},{"$f":"SUM(G9:G11)*G15","v":1702.3478646196163},{"$f":"SUM(H9:H11)*H15","v":1644.540042404027}]
["Pass-Through Business Rates","B1","RBt",1.563034475468172,35.125264090309322,3.8304626547205786E-4,3.8304626547205786E-4,35.143040211320418,"Forecast"]
["Temporary Physical Disconnection","B2","TPDt",0.70842755869282104,0,0,0,0.36912293551029107,"Forecast"]
["Licence Fee","B3","LFt",-0.37663957632732453,4.5405335158157927,0,0,4.3073758620676941,"Forecast"]
["Inter TSO Compensation","B4","ITCt",1.3447743785507609,0.76609253098295482,0,0,-5.2424163490863736,"Forecast"]
["Termination of Bilateral Connection Agreements","B5","TERMt",0,0,0,0,{"$f":"G21","v":0},"Forecast"]
["SP Transmission Pass-Through","B6","TSPt",349.96085315139794,389.97611439962492,389.96211225997047,389.96211225997047,383,"Forecast"]
["SHE Transmission Pass-Through","B7","TSHt",366.411,349.38682707987397,349.38682707987397,349.38682707987397,337.80613598820054,"Forecast"]
["Offshore Transmission Pass-Through","B8","TOFTOt",318.14381186500037,459.86162681762477,386.47878665563246,387.43985204476695,388.38619450276207,"Forecast"]
["Embedded Offshore Pass-Through","B9","OFETt",0.54981802045525896,0.56739211243328103,0.5678105431946624,0.5678105431946624,0.56739211243328103,"Forecast"]
["Interconnectors Cap&Floor Revenue Adjustment","B10","TICFt",-6.8,null,-6.8,-6.8,-8.4,"Forecast"]
["Pass-Through Items [B=B1+B2+B3+B4+B5+B6+B7+B8+B9+B10]","B","PTt",{"$f":"SUM(D17:D26)","v":1031.5050798732379},{"$f":"SUM(E17:E26)","v":1240.2238505466648},{"$f":"SUM(F17:F26)","v":1119.5959195849368},{"$f":"SUM(G17:G26)","v":1120.5569849740714},{"$f":"SUM(H17:H26)","v":1135.9368452632077}," "]
["Reliability Incentive Adjustment","C1","RIt",4.1357968557807956,4.2415455471470569,4.2415455471470569,4.2415455471470569,3.7615655811242172,"Forecast"]
["Stakeholder Satisfaction Adjustment","C2","SSOt",9.276440123545882,8.5832712034591108,8.6169993151490907,8.6169993151490907,7.15,"Forecast"]
["Sulphur Hexafluoride (SF6) Gas Emissions Adjustment","C3","SFIt",1.4340660973457273,1.6229739981587128,1.6229739981587128,1.6229739981587128,3.1133460876988659,"Forecast"]
["Outputs Incentive Revenue [C=C1+C2+C3+C4]","C","OIPt",{"$f":"SUM(D28:D30)","v":14.846303076672406},{"$f":"SUM(E28:E30)","v":14.447790748764881},{"$f":"SUM(F28:F30)","v":14.481518860454861},{"$f":"SUM(G28:G30)","v":14.481518860454861},{"$f":"SUM(H28:H30)","v":14.024911668823083}," "]
["Network Innovation Allowance","D","NIAt",10.524088614844821,10.724791547103584,10.724791547103584,10.724791547103584,10.360172076327249,"Forecast"]
["Network Innovation Competition","E","NICFt",32.664404040000001,40.5,32.664404040000001,32.664404040000001,32.664404040000001,"Forecast"]
["Future Environmental Discretionary Rewards","F","EDRt",0,2,0,0,0,"Forecast"]
["Transmission Investment for Renewable Generation","G","TIRGt",0,0,0,0,0,"Forecast"]
["Scottish Site Specific Adjustment","H","DISt",6.6479999999999961,0,0,0,0,"Forecast"]
["Scottish Terminations Adjustment","I","TSt",3.0709999999999997,0,0,0,0,"Forecast"]
["Correction Factor","K","-Kt",-55.451092846606805,0,0,42.496620993135622,33.63639475240565,"Calculated by Licensee"]
["Maximum Revenue [M= A+B+C+D+E+F+G+H+I+K]","M","TOt",{"$f":"D16+D27+D31+D32+D33+D34+D35+D36+D37+D38","v":2714.2980390827229},{"$f":"E16+E27+E32+E33+E34+E35+E36+E37+E38+E31","v":3010.2442974621495},{"$f":"F16+F27+F31+F32+F33+F34+F35+F36+F37+F38","v":2879.8144986521115},{"$f":"G16+G27+G31+G32+G33+G34+G35+G36+G37+G38","v":2923.2721850343819},{"$f":"H16+H27+H31+H32+H33+H34+H35+H36+H37+H38","v":2871.1627702047908}," "]
["Pre-vesting connection charges","P"," ",44.002400999999999,41.882612399999999,44.002400999999999,44.002400999999999,{"$f":"31.61","v":31.61},"Forecast"]
["TNUoS Collected Revenue [T=M-B5-P]","T"," ",{"$f":"D39-D40","v":2670.2956380827227},{"$f":"E39-E40","v":2968.3616850621493},{"$f":"F39-F40","v":2835.8120976521113},{"$f":"G39-G40","v":2879.2697840343817},{"$f":"H39-H40","v":2839.5527702047907}," "]
[]
["Notes:"]

{"sheet":"TFF","index":29,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,6],[20,5,21,5],[3,7,4,7],[14,1,17,1],[17,2,19,2],[18,3,19,3],[21,6,22,6]]}
["Table FF - Offshore Revenues",null,null,null,null,null,null,"Return to Index"]
[]
["Offshore Transmission Revenue Forecast (£m)","2018-11-23",null,null,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","2019/20"]
["Barrow",5.4759483870350794,5.6051191659779338,5.6562830188883408,5.8724963671592052,6.250052539232863,6.4415396739902615,"Current revenues plus indexation"]
["Gunfleet",6.8531524225899307,7.0144590179136701,7.0805945993165489,7.4324222805755404,7.8017526906474828,8.0860236304415061,"Current revenues plus indexation"]
["Walney 1",12.491059506303356,12.786364558839976,12.901841570954671,13.136098252828528,13.607167459943749,14.672564615693997,"Current revenues plus indexation"]
["Robin Rigg",7.7094720644957526,7.8914406617198356,7.9933083655200443,8.3673065626659167,8.7488529744949677,9.1303157620679123,"Current revenues plus indexation"]
["Walney 2",12.926960730569261,13.232210748352349,12.515897408645721,12.299313160867388,16.325806709079423,14.553966230346784,"Current revenues plus indexation"]
["Sheringham Shoal",18.92412411049645,19.498933866515603,19.727664616616543,20.025312344572047,20.742778333926285,21.432248969451621,"Current revenues plus indexation"]
["Ormonde",11.570501887309904,11.843091171267096,11.952150078673732,12.15604428015874,12.5936963237531,13.559794413500772,"Current revenues plus indexation"]
["Greater Gabbard",25.999519895629486,26.619250228001508,26.871432565306392,27.309232602224004,28.387567597857235,29.330665166720102,"Current revenues plus indexation"]
["London Array",37.572952823693697,39.21209850266176,39.498702717387403,39.518883339410344,41.77261773651108,43.163704867644711,"Current revenues plus indexation"]
["Thanet",78.856681666789868,17.517052725652213,15.699844477620001,19.512192800879649,18.623202111696155,19.180775248308457,"Current revenues plus indexation"]
["Lincs",null,25.563393838820964,26.687042138144108,27.188145543100443,28.169364454148401,28.99571181266656,"Current revenues plus indexation"]
["Gwynt y mor",null,26.283585134974199,23.646116595083996,29.342874473513998,32.730809292973404,33.98287134592244,"Current revenues plus indexation"]
["West of Duddon Sands",null,35.289999599240495,21.27389291267081,22.045387978983488,22.572650063642349,22.657428525621118,"Current revenues plus indexation"]
["Humber Gateway",null,null,29.284541507176115,9.7498990869565194,12.145415107061377,12.260522605542814,"Current revenues plus indexation"]
["Westermost Rough",null,null,null,11.576692607080746,13.197339934782658,13.503117014534162,"Current revenues plus indexation"]
["Burbo Bank",null,null,null,null,34.275926251984941,13.032599083969467,"Current revenues plus indexation"]
["Dudgeon",null,null,null,null,null,84.402345536339283,"National Grid Forecast"]
["Forecast to asset transfer to OFTO in 2019/20",null,null,null,null,null,null,"National Grid Forecast"]
["Offshore Transmission Pass-Through (B7)",{"$f":"SUM(B6:B23)","v":218.38037349491282},248.35699921993759,260.78931257200446,265.53230168097656,317.94499958173537,388.38619450276195," "]
[]
[]
["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"]