{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Main","Overall cost","Total categories","BM total","AS Total","Trades","DSR","SO2SO","Energy Imbalance","Operating Reserve","STOR","Constraints","Negative Reserves","Fast Reserve","Response","Reactive","Black Start","Other Reserves","Minor components"],"not_rendered":{"charts":35,"images":0,"macros":1,"external_links":5,"defined_names":139,"comments":1,"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":"Main","index":0,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"2018-10-01"]
[null,null,null,null,"2018-10-31"]

{"sheet":"Overall cost","index":1,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Report Month",{"$f":"Main!E1","v":"2018-10-01"},{"$f":"EOMONTH(C1,0)","v":"2018-10-31"},{"$f":"C1","v":"2018-10-01"},"Balancing Cost ",{"$f":"F1&TEXT(E1,\"mmm yyyy\")","v":"Balancing Cost Oct 2018"}]
[]
[null,"Balancing Mechanism","Trades","Ancillary Services","SO-to-SO","Other","Total"]
[null,{"$f":"SUMIF(#REF!,'Overall cost'!$D$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Overall cost'!$D$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"HLOOKUP($C$1,#REF!,2,FALSE)-E4","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Overall cost'!$D$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Overall cost'!$D$1,#REF!)+SUMIF(#REF!,'Overall cost'!$D$1,#REF!)+SUMIF(#REF!,'Overall cost'!$D$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(B4:F4)","v":{"$error":"#REF!"}}]

{"sheet":"Total categories","index":2,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cost £m","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"Energy Imbalance",-5.6785957729999996,-6.7606795479999997,-2.8102212680000007,-1.1107513009999979,-3.902354275,-0.66875925500000044,-4.3433794999999942E-2]
[null,"Operating Reserve",4.0568053568987184,4.3843095227485316,3.4838511470886586,4.7882804938143604,4.6670818700786576,5.5347661922842297,8.0446105832284491]
[null,"STOR",6.0953541117484296,7.0388447085698704,6.6450671933095311,7.3605102713264117,6.6573802936347501,5.7588933264802806,5.3409918095560407]
[null,"Constraints",25.438006298336621,24.546621061012164,51.196882322284893,39.151005868618796,35.493438561046226,102.183027373923,104.03488756433136]
[null,"Negative Reserve",0.42003371109222998,2.05747189453484,0.40776612894857994,0.57252884519922997,0.39588379449809996,0.56368347816138997,0.21194266466229009]
[null,"Fast Reserve",6.4616424454293018,6.469285508946129,6.0793966458212498,7.5622945054611996,8.2441637224260322,7.5176516044330173,8.4667419404327884]
[null,"Response",11.011784772242429,12.212296822909959,11.445711546144015,10.50263577156284,10.565914832295041,11.369395960617517,10.511618202061747]
[null,"Other Reserve",0.78612493000000017,0.91854516000000008,0.82870663,1.1695935499999999,1.2434275799999999,1.0551749699999997,1.322331023333333]
[null,"Reactive",6.3363181603902037,7.0487829820249992,7.3597044099999982,6.5524431499999993,6.6953027476666707,6.0864996319097324,7.0078329100000012]
[null,"Black Start",3.3660501699999998,3.6704132239652592,3.2253605499999995,2.8651217599999992,3.3852961797999992,3.4405747300000558,3.472761960000001]
[null,"Minor Components",1.3570808525747535,0.83864088952016846,0.98478975824316028,1.0056266047332583,1.8659945098045867,1.4056771916886883,0.45979403059218538]
[null,"Total",{"$f":"SUM(C3:C13)","v":59.650605035712687},{"$f":"SUM(D3:D13)","v":62.424532226231932},88.84701506384009,{"$f":"SUM(F3:F13)","v":80.419289519716088},{"$f":"SUM(G3:G13)","v":75.311529816250044},{"$f":"SUM(H3:H13)","v":144.2465852044979},{"$f":"SUM(I3:I13)","v":148.83007889319819},{"$f":"SUM(J3:J13)","v":0},{"$f":"SUM(K3:K13)","v":0},{"$f":"SUM(L3:L13)","v":0},{"$f":"SUM(M3:M13)","v":0},{"$f":"SUM(N3:N13)","v":0}]
[]
[]
[null,"Volume MW","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"Energy Imbalance",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Operating Reserve",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"STOR (BM only)",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Constraints",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Constraint Margin Replacement",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Negative Reserve",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Fast Reserve (BM only)",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Response (Absolute- BM only)",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[null,"Minor Components",{"$f":"SUMIF(#REF!,'Total categories'!C$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!D$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!E$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!F$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!G$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!H$17,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Total categories'!I$17,#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,"Reporting Month"]
[null,"Energy Imbalance",{"$f":"INDEX($C$3:$N$13,MATCH(B31,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":-4.3433794999999942E-2}]
[null,"Operating Reserve",{"$f":"INDEX($C$3:$N$13,MATCH(B32,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":8.0446105832284491}]
[null,"STOR",{"$f":"INDEX($C$3:$N$13,MATCH(B33,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":5.3409918095560407}]
[null,"Constraints",{"$f":"INDEX($C$3:$N$13,MATCH(B34,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":104.03488756433136}]
[null,"Negative Reserve",{"$f":"INDEX($C$3:$N$13,MATCH(B35,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":0.21194266466229009}]
[null,"Fast Reserve",{"$f":"INDEX($C$3:$N$13,MATCH(B36,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":8.4667419404327884}]
[null,"Response",{"$f":"INDEX($C$3:$N$13,MATCH(B37,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":10.511618202061747}]
[null,"Other Reserve",{"$f":"INDEX($C$3:$N$13,MATCH(B38,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":1.322331023333333}]
[null,"Reactive",{"$f":"INDEX($C$3:$N$13,MATCH(B39,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":7.0078329100000012}]
[null,"Black Start",{"$f":"INDEX($C$3:$N$13,MATCH(B40,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":3.472761960000001}]
[null,"Minor Components",{"$f":"INDEX($C$3:$N$13,MATCH(B41,$B$3:$B$13,0),MATCH(Main!$E$2,'Total categories'!$C$2:$N$2,0))","v":0.45979403059218538}]

{"sheet":"BM total","index":3,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"EOMONTH(C2,0)","v":"2018-04-30"},{"$f":"EOMONTH(D2,0)","v":"2018-05-31"},"2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"Cost £m","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Energy balancing",-5.6785957729999996,-6.7129372250000001,-2.7477750240000005,-1.0514679629999979,-3.870658723,-0.75281671400000039,-0.63645130300000041]
[null,"BM - Operating Reserve",2.5110751954302208,2.1326446359756903,0.85968272959821979,2.0434515995246199,2.3162893296308602,1.5990502732302798,4.0322646780233695]
[null,"BM - STOR",0.32286934174843002,0.27555184856987003,0.17545484330953004,0.26642165132641005,0.18996912363475002,0.32477126648027999,0.28545123955603996]
[null,"BM - Constrained Margin",1.4761581215007502,1.84803044652272,2.27863540465213,2.4498871485113298,1.6063245775979293,3.7974325721958397,3.4292176008090203]
[null,"BM - Constraints E&W",5.4356330801573502,10.698795978391979,19.708498518938004,22.089339090995033,17.606111669924502,59.472696002787373,56.060730571814368]
[null,"BM - Constraints Cheviot",13.203399566677099,1.3377995002535001,7.2112872784648898,0.80874022866837991,1.3778062036959,17.086754503232402,7.7737505933448201]
[null,"BM - Constraints Scotland",8.0191114409930001E-2,1.5488860143422598,4.7539709015554994,0.23373614411699001,1.25290800620885,3.8005352069381497,9.3321397067511711]
[null,"BM - Negative Reserve",0.22926964812080999,8.3770135558110012E-2,7.4540071759729987E-2,1.689183217305E-2,0.11933140243591998,0.4515632341452599,0.19674247003853004]
[null,"BM - Fast Reserve",1.0773172354292999,1.0325338589461301,0.86542248682124978,0.84214935546120018,0.93714556242602998,0.98862691443302009,0.96833745243279012]
[null,"BM - Response",0.93277184224284004,1.3641419429101396,1.0084516969542601,1.5448673615628399,1.5287936042950399,2.6633870326414999,1.5232280532172102]
[null,"BM - Minor Components",1.2202173698917604,1.1494566828511801,1.5945901102273203,1.5264936295931404,2.4924715111293807,2.7549183945881,1.9442274250214204]
[]
[]
[]
[]
[null,"Volume MW","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Energy balancing",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Operating Reserve",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - STOR",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Constrained Margin",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Constraints E&W",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Constraints Cheviot",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Constraints Scotland",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Negative Reserve",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Fast Reserve",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Response",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Minor Components",{"$f":"SUMIF(#REF!,'BM total'!C$18,#REF!)+SUMIF(#REF!,'BM total'!C$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!D$18,#REF!)+SUMIF(#REF!,'BM total'!D$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!E$18,#REF!)+SUMIF(#REF!,'BM total'!E$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!F$18,#REF!)+SUMIF(#REF!,'BM total'!F$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!G$18,#REF!)+SUMIF(#REF!,'BM total'!G$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!H$18,#REF!)+SUMIF(#REF!,'BM total'!H$18,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'BM total'!I$18,#REF!)+SUMIF(#REF!,'BM total'!I$18,#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"AS Total","index":4,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cost £m","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS - Response",10.079012929999589,10.848154879999823,10.451984909189756,8.9941101099999994,9.2313568765480003,8.7060089279760202,8.9883901488445375]
[null,"AS - Fast Reserves",5.3843252100000001,5.4367516499999988,5.1424716590000017,6.7134268199999996,7.307018160000001,6.5290246900000009,7.4984044879999985]
[null,"AS - STOR",5.773167449999999,6.7632928600000009,6.4737298499999998,7.1014421900000011,6.597500150000001,5.4341220600000009,5.0555405700000007]
[null,"AS - Other Reserves",0.78711943000000018,0.91970580000000024,0.82597976999999989,1.1589629499999998,1.1584881,1.0551749699999997,1.322331023333333]
[null,"AS - Black Start",3.3660501699999998,3.6704132239652592,3.2317605499999993,3.0614282200000011,3.574906768760107,3.4405747300000558,3.472761960000001]
[null,"AS - Reactive",6.4658281103902047,7.0741517420249984,7.3603808099999979,6.5619017599999996,6.6967673376666701,6.0864996319097324,7.0078329100000012]
[null,"AS - Constraints ",2.7400137846400008,0.93408829412799987,3.7703722351393254,0.84203858372833162,0.39124366412799993,1.5844116941400002,13.227097964127999]
[null,"AS - SO-SO Costs",0.79709770691244231,0.71385446570400912,0.7192806959206951,0.77428213057815798,0.80238637261455503,0.78076858940644112,0.91045667389232121]
[null,"AS - Other Ancillary Cost",2.2512000000000001E-4,0,0,0,0,0,0]
[null,"AS - Outstanding Liabilities",0.20035137540983619,0.20702975459016407,0.20035137540983619,0.20702975459016407,0.20702975459016407,0.20035137540983619,0]
[]
[]
[null,"Cost £m","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS Mandatory Service",7.2762198100000006,8.3264698499999987,8.1278335199999994,7.8867142799999996,7.8784590400000001,7.2865310099999991,7.8756726700000002]
[null,"AS Commercial Service",13.478868515712728,11.920095331231929,14.241987704839934,13.921814799716332,14.751741365127167,14.543217631817996,28.270748980198196]
[null,"AS Tendered Service",14.443853470000001,15.756021430000006,15.102371118999997,13.057911599999999,12.66399483,11.788629910000001,11.905613378]
[null,"AS Miscellaneous Costs",0.20057649540983621,0.20702975459016407,0.20035137540983619,0.20702975459016407,0.20702975459016407,0.20035137540983619,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Graph Title"]
[null,{"$f":"\"Ancillary Services Cost - \"&TEXT(Main!E1,\"mmm yyyy\")","v":"Ancillary Services Cost - Oct 2018"}]

{"sheet":"Trades","index":5,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Volume MWh","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01",null,"Reporting Month"]
[null,"Buy Volume",22190,73582.5,139079.5,119046.5,126069,176040.5,215568,null,null,null,null,null,null,{"$f":"HLOOKUP(Main!E1,Trades!$C$2:$N$5,4,FALSE)","v":502745}]
[null,"Sell Volume",116182,281479.5,231333.4,309497,306662.2,324343.59999999998,287177]
[null,"Abs value",{"$f":"SUM(C3:C4)","v":138372},{"$f":"SUM(D3:D4)","v":355062},{"$f":"SUM(E3:E4)","v":370412.9},{"$f":"SUM(F3:F4)","v":428543.5},{"$f":"SUM(G3:G4)","v":432731.2},{"$f":"SUM(H3:H4)","v":500384.1},502745]
[]
[]
[null,"Cost £ million","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"Buy Cost",{"$f":"0.237922+0.0651909","v":0.30311290000000002},{"$f":"1.28180166+0.4176639","v":1.6994655599999999},3.281732232,2.4576692499999999,2.1458672569999999,1.2234046654086099,1.810448243677]
[null,"Sell Cost",3.9408755688000001,10.9971745,13.11942185,14.199445320000001,13.846514446,19.302235929416,16.434827500053501]

{"sheet":"DSR","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cost £m","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"NBM - Frequency Response",4.4011577199995902,4.5059536599998227,4.6833553391897533,5.4015874999999998,5.785020836548,5.4890724079760194,5.865991108844538,null,null,null,null,null,0]
[null,"NBM - Short-term operating reserve (STOR)",3.8646811899999998,4.5023688400000008,4.2503607900000002,4.5548541,4.0973911300000001,3.4426071500000002,2.9510646300000003]
[null,"NBM - Fast Reserve",0.83989016999999966,0.92044844999999997,0.54649421899999984,0.63439844999999973,0.77291741999999952,1.1456950499999998,1.3488670379999992]
[]
[]
[null,"Cost £m","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS - Non BM providers",9.1057290799995894,9.9605637899998225,9.5191973181897538,10.705779389999998,10.694389906547999,10.105811527976019,10.191831556844539]
[null,"AS - BM providers",25.489788005030203,25.685994660118272,27.737482465139323,23.078706243727996,24.262891150554779,22.719980176049788,36.380527507461331]
[null,"AS - SO-SO providers",0.79709770691244231,0.71385446570400912,0.7192806959206951,0.77428213057815798,0.80238637261455503,0.78076858940644112,0.91045667389232121]
[null,"AS - Miscellaneous",0.20057649540983621,0.20702975459016409,0.20035137540983622,0.20702975459016409,0.20702975459016409,0.20035137540983622,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Graph Title"]
[null,{"$f":"\"AS Costs By Provider Type - \"&TEXT(Main!E1,\"mmm yyyy\")","v":"AS Costs By Provider Type - Oct 2018"}]

{"sheet":"SO2SO","index":7,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"EOMONTH(C2,0)","v":"2018-04-30"},{"$f":"EOMONTH(D2,0)","v":"2018-05-31"},"2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"Cost £m","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"SO-SO Energy Trades",0,-4.7742323000000003E-2,-6.2446244000000005E-2,-5.9283338000000005E-2,-3.1695551999999995E-2,8.4057459000000001E-2,0.59301750799999997]
[null,"SO-SO Margin",0,0,0,0,0,0,0]
[null,"SO-SO Constrained Margin",0,0,0,0,0,0,0]
[null,"SO-SO Footroom",0,0,8.8663725995000002E-4,4.4665580622500001E-3,0,2.8450799999999998E-3,0]
[null,"SO-SO Ramping",0,0,0,0,0,1.5730533843700001E-3,3.8075162217030001E-2]
[null,"SO-SO Invoked by External Parties",0,-0.10187188744483,-0.24659000149506999,-7.7968851847920004E-2,-0.21245181898009999,-1.8733647485829997E-2,-6.4135937538640012E-2]
[null,"SO-SO Constaints",0,0,0,0,0,0,0]
[null,"AS - SO-SO Interconnector Capability (Commercial)",0.79709770691244231,0.71385446570400912,0.7192806959206951,0.77428213057815798,0.80238637261455503,0.78076858940644112,0.91045667389232121]
[null,null,{"$f":"SUM(C3:C10)","v":0.79709770691244231},{"$f":"SUM(D3:D10)","v":0.56424025525917909},0.4111310876855751,0.64149649879248793,0.55823900163445506,0.85051053430498114,1.4774134065707112,0,0,0,0,0]
[null,"Reporting Month"]
[null,{"$f":"HLOOKUP(Main!E2,SO2SO!$C$2:$N$11,10,FALSE)","v":1.4774134065707112}]

{"sheet":"Energy Imbalance","index":8,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cost","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"Energy Imbalance",-5.6785957729999996,-6.7606795479999997,-2.8102212680000007,-1.1107513009999979,-3.902354275,-0.66875925500000044,-4.3433795000000441E-2]
[]
[]
[null,"Volume MWh","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"Energy Imbalance",{"$f":"'Total categories'!C18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!D18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!E18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!F18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!G18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!H18","v":{"$error":"#REF!"}},{"$f":"'Total categories'!I18","v":{"$error":"#REF!"}}]

{"sheet":"Operating Reserve","index":9,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cost","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Operating Reserve",2.5110751954302208,2.1326446359756903,0.85968272959821979,2.0434515995246199,2.3162893296308602,1.5990502732302798,4.0322646780233695]
[null,"BM - Constrained Operating Reserve",1.4761581215007502,1.84803044652272,2.27863540465213,2.4498871485113298,1.6063245775979293,3.7974325721958397,3.4292176008090203]
[null,"Trade - Operating Reserve",2.8048764967750002E-2,0.18543540725012,3.6704884468090004E-2,0.17895576171568001,0.45915739183087995,-3.0713040849859999E-2,0.29709592357303005]
[null,"Trade - UTEV",0,0,0,0,0,0,0]
[null,"Trade - Constrained Operating Reserve",4.1523274999999998E-2,0.21819903300000001,0.30882812837022006,0.11598598406272999,0.28531057101899004,0.16899638770796996,0.28603238082303001]
[null,"SO-SO - Operating Reserve",0,0,0,0,0,0,0]
[null,"SO-SO - Constrained Operating Reserve",0,0,0,0,0,0,0]
[]
[]
[null,"Volume","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"BM - Constrained Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"Trade - Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"Trade - UTEV",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"Trade - Constrained Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"SO-SO - Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]
[null,"SO-SO - Constrained Operating Reserve",{"$f":"SUMIF(#REF!,'Operating Reserve'!C$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!D$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!E$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!F$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!G$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!H$12,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Operating Reserve'!I$12,#REF!)","v":{"$error":"#REF!"}}]

{"sheet":"STOR","index":10,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - STOR",0.32286934174843002,0.27555184856987003,0.17545484330953004,0.26642165132641005,0.18996912363475002,0.32477126648027999,0.28545123955603996]
[null,"AS - BM STOR (Tendered)",1.9084862600000003,2.2609240200000009,2.2233690600000013,2.5465880899999993,2.50010902,1.9915149099999998,2.1044759400000004]
[null,"AS - NBM STOR availability (Tendered)",2.0170296699999999,2.5433886900000005,2.5732744100000007,2.6072192699999994,2.5712279899999997,2.3333598600000003,2.2295345200000005]
[null,"AS - NBM STOR utilisation (Tendered)",1.8476515200000001,1.9589801500000001,1.67708638,1.9476348300000002,1.5261631400000002,1.1092472899999999,0.72153011]
[null,"AS - BM Season/Term Reconciliation (Tendered)",0,0,0,0,0,0,0]
[null,"AS - NBM Season/Term Reconciliation (Tendered)",0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C3:C8)","v":6.096036791748431},{"$f":"SUM(D3:D8)","v":7.0388447085698722},6.6491846933095324,7.3678638413264093,6.7874692736347502,5.7588933264802806,5.3409918095560407,0,0,0,0,0]
[null,null,{"$f":"SUM(C3:C4,C7)","v":2.2313556017484304},{"$f":"SUM(D3:D4,D7)","v":2.536475868569871},2.3988239033095313,2.8130097413264092,2.6900781436347501,2.31628617648028,2.3899271795560404,0,0,0,0,0]
[null,null,{"$f":"SUM(C5:C6,C8)","v":3.8646811899999998},{"$f":"SUM(D5:D6,D8)","v":4.5023688400000008},4.2503607900000002,4.5548541,4.0973911300000001,3.4426071500000002,2.9510646300000003,0,0,0,0,0]
[]
[null,"MWh","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS - NBM STOR utilisation (Tendered)",48983.042000000001,52527.169000000002,47632.440999999999,58800.014000000003,46902.69,46902.687999999995,33517.138999999996]
[null,"AS - BM STOR utilisation (Tendered)",4468.8760000000002,4942.2079999999996,3480.5,4972.2510000000002,8240.3379999999997,8642.9419999999991,5893.7420000000002]
[null,null,{"$f":"SUM(C14:C15)","v":53451.918000000005},{"$f":"SUM(D14:D15)","v":57469.377},51112.940999999999,63772.264999999999,{"$f":"SUM(G14:G15)","v":55143.028000000006},{"$f":"SUM(H14:H15)","v":55545.62999999999},{"$f":"SUM(I14:I15)","v":39410.880999999994},0,0,0,0,0]
[null,"Reporting Month"]
["Total",5.3409918095560398]
["BM",{"$f":"HLOOKUP(Main!$E$2,STOR!$C$2:$N$11,9,FALSE)","v":2.3899271795560404}]
["Non-BM",{"$f":"HLOOKUP(Main!$E$2,STOR!$C$2:$N$11,10,FALSE)","v":2.9510646300000003}]
["Total Vol",{"$f":"HLOOKUP(Main!$E$1,STOR!$C$13:$N$16,4,FALSE)","v":39410.880999999994}]
[]
[]
[null,null,"2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01"]
[null,"BM STOR (July MBSS)",1523.3530000000001,802.3599999999999,856.43999999999994,1569.425]
[null,"BM STOR",4612.4920000000002,4633.7330000000002,3483.6669999999999,5105.0009999999993,4767.3319999999994]
[null,"AS BM STOR",4468.8760000000002,4942.2079999999996,3480.5,4972.2510000000002,8240.3379999999997]

{"sheet":"Constraints","index":11,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS - BM Intertrip capability (Mandatory - CAP76)",0.11204639999999991,0.1157812799999999,0.11204639999999991,0.1157812799999999,0.1157812799999999,0.11204639999999991,0.1157812799999999]
[null,"AS - BM Intertrip capability  (Commercial)",1.6120484639999991E-2,1.6657834127999992E-2,1.6120484639999991E-2,1.6657834127999992E-2,1.6657834127999992E-2,1.6120484639999991E-2,1.6657834127999992E-2]
[null,"AS - BM Intertrip Arming  (Commercial)",1.638527E-2,0.27202451,3.37651916,6.0774469600000006E-2,0.14374888999999999,0.19997749000000001,0.13619388999999998]
[null,"AS - Interconnector Intertrip Arming (Commercial)",0,0,0,0.64882500000033183,0,1.0024999999999999E-2,0]
[null,"AS - BM Intertrip - trip (Mandatory and Commercial)",0,0,0,0,0,0,0]
[null,"AS - BM Constraints",2.59546163,0.52962467000000002,0.26568619049932479,0,0.11505566,1.2462423194999999,12.958464959999993]
[]
[]
[null,"Costs (£m)","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"BM - Transmission",17.319323160844689,11.610683864340389,31.110988908931542,22.02485966443594,18.852824506429982,77.827324562371018,68.605901469672148]
[null,"Trades - Transmission",0.32481862685915958,0.63170125096372565,3.4350663334674834,2.686199714198708,0.90170147966429182,3.5886769644330978,3.7451112329259115]
[null,"BM - Voltage",0.31470858568920773,0.60466419649893155,0.32690441395582559,0.1975358526362315,0.45879228378367343,1.280998874368249,1.4564722403154353]
[null,"Trades - Voltage",0.20149104661231965,1.2196936538609389,2.4399733948214237,1.92485955170024,1.2316071521242369,0.98382695854586721,0.62831487842969447]
[null,"BM - ROCOF",1.0851920917104938,1.3701335011483977,0.2358635740710161,0.90942012870821709,0.92520921461560768,1.2516626992186208,3.1042475369229163]
[null,"Trades - ROCOF",3.4524590909807986,8.471214370071797,9.8777136708981423,11.214917560211351,12.783727387300374,15.666000342576085,13.267742631937367]
[null,"SO-SO - Constraints",0,0,0,0,0,0,0]
[null,"AS Costs",2.7400137846400008,0.93408829412799987,3.7703722351393254,0.84203858372833162,0.39124366412799993,1.5844116941400002,13.227097964127999]
[]
[]
[null,"Absolute Volume MWh","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"BM - Transmission",223524.63400000002,169041.23699999991,490529.90000000031,240083.21600000001,188414.66199999995,697941.33899999992,575838.32000000111]
[null,"Trades - Transmission",2867,6502.5,39289.4,67527,14720.2,28117.599999999999,59765]
[null,"BM - Voltage",28569.236000000001,38818.62200000001,32251.667999999998,9742.6910000000007,30701.910999999996,93318.000000000029,135939.05700000003]
[null,"Trades - Voltage",20584,70647.5,108480,100644.5,98325,144325.5,129229]
[null,"BM - ROCOF",31162.47,29151.453999999994,14146.085000000003,40904.041999999994,22166.055,61303.894000000015,79615.595000000001]
[null,"Trades - ROCOF",31162.47,29151.453999999994,14146.085000000003,40904.041999999994,22166.055,61303.894000000015,79615.595000000001]
[null,"SO-SO - Constraints",101715,215551,194531.5,226187,273122,307416,256073.5]
[]
[]
[]
[]
[null,"Reporting Month"]
[null,"AS Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Graph Title"]
[null,{"$f":"\"Constraints - \"&TEXT(Main!E1,\"mmm yyyy\")","v":"Constraints - Oct 2018"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"Negative Reserves","index":12,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Negative reserve",0.22926964812080999,8.3770135558110012E-2,7.4540071759729987E-2,1.689183217305E-2,0.11933140243591998,0.4515632341452599,0.19674247003853004]
[null,"Trade -  Negative reserve",0.19076406297142001,1.9737017589767301,0.33233941992889998,0.55117045496392991,0.27655239206217996,0.10927516401613001,1.520019462376E-2]
[null,"SO-SO - Negative reserve",0,0,8.8663725995000002E-4,4.4665580622500001E-3,0,2.8450799999999998E-3,0]
[]
[]
[]
[null,"Volumes","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Negative Reserve",{"$f":"SUMIF(#REF!,'Negative Reserves'!C$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!D$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!E$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!F$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!G$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!H$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!I$9,#REF!)","v":{"$error":"#REF!"}}]
[null,"Trade - Negative Reserve",{"$f":"SUMIF(#REF!,'Negative Reserves'!C$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!D$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!E$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!F$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!G$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!H$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!I$9,#REF!)","v":{"$error":"#REF!"}}]
[null,"SO-SO - Negative Reserve",{"$f":"SUMIF(#REF!,'Negative Reserves'!C$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!D$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!E$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!F$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!G$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!H$9,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,'Negative Reserves'!I$9,#REF!)","v":{"$error":"#REF!"}}]
[null,null,{"$f":"SUM(C10:C12)","v":{"$error":"#REF!"}},{"$f":"SUM(D10:D12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},0,0,0,0,0]
[]
[]
[null,"Reporting Month"]
[null,"Volume",{"$f":"HLOOKUP(Main!E2,'Negative Reserves'!C9:N13,5,FALSE)","v":{"$error":"#REF!"}}]

{"sheet":"Fast Reserve","index":13,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Fast Reserves",1.0773172354292999,1.0325338589461301,0.86542248682124978,0.84214935546120018,0.93714556242602998,0.98862691443302009,0.96833745243279012]
[null,"Hydro Spin Gen No LF (Commercial)",4.0454750400000004,4.0014732000000004,4.1009774400000003,5.5646983699999994,6.0255107399999996,4.9791666400000008,5.6341274499999985]
[null,"BM Optional Fast Reserve (Commercial)",0,0,0,0,0,0,0]
[null,"NBM Optional Fast Reserve Availability (Commercial)",3.2549999999999989E-2,1.5050000000000006E-2,5.2499999999999969E-3,1.3650000000000011E-2,9.1000000000000004E-3,1.3119109999999993E-2,1.0062078000000006E-2]
[null,"NBM Optional Fast Reserve Utilisation (Commercial)",0.15678468000000004,6.3168480000000013E-2,2.3231830000000019E-2,5.1529599999999967E-2,0.12183464999999989,0.53028801999999997,0.66055509999999962]
[null,"BM Firm Fast Reserve (Tendered)",0.49896000000000024,0.51483000000000023,0.49500000000000022,0.51433000000000018,0.50859000000000021,0.40416299999999977,0.51541000000000026]
[null,"NBM Firm Fast Reserve Avail + Nom (Tendered)",0.3743249999999998,0.38680249999999977,0.3743249999999998,0.38683749999999978,0.38680249999999977,0.428757,0.38680249999999977]
[null,"NBM Firm Fast Reserve Utilisation (Tendered)",0.27623048999999994,0.45542747000000017,0.14368738900000003,0.18238135,0.25518026999999993,0.17353091999999992,0.29144735999999988]
[null,"Total BM",{"$f":"SUM(C3:C5,C8)","v":5.6217522754293006},{"$f":"SUM(D3:D5,D8)","v":5.5488370589461304},5.4613999268212501,6.9211777254611997,7.4712463024260298,6.3719565544330203,7.1178749024327885,0,0,0,0,0]
[null,"Total Non-BM",{"$f":"SUM(C6:C7,C9:C10)","v":0.83989016999999966},{"$f":"SUM(D6:D7,D9:D10)","v":0.92044844999999997},0.54649421899999984,0.63439844999999973,0.77291741999999952,1.1456950499999998,1.3488670379999992,0,0,0,0,0]
[]
[]
[]
[null,"Volume","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS - NBM Firm Fast Reserve availability + nomination (Tendered)",63000,65100,46620,65100,65100,78552,65100]
[null,"AS - BM Firm Fast Reserve availability (Tendered)",90720,93780,91080,93960,93960,121800,94140]
[null,"AS - BM Hydro Spin Gen No LF (Commercial)",159712.75,159528.13,164254.81,221511.75,237260.01,200063.52,224153.54]
[]
[]
[]
[null,"Reporting Month"]
[null,"BM",{"$f":"HLOOKUP(Main!$E$2,'Fast Reserve'!$C$2:$N$12,10,FALSE)","v":7.1178749024327885}]
[null,"Non-BM",{"$f":"HLOOKUP(Main!$E$2,'Fast Reserve'!$C$2:$N$12,11,FALSE)","v":1.3488670379999992}]

{"sheet":"Response","index":14,"n_rows":46,"n_cols":38,"rows_kept":46,"cut":false,"hidden":false,"merged":[[20,35,20,37],[20,2,20,4],[20,5,20,7],[20,8,20,10],[20,11,20,13],[20,14,20,16],[20,17,20,19],[20,20,20,22],[20,23,20,25],[20,26,20,28],[20,29,20,31],[20,32,20,34],[34,2,34,4],[34,5,34,7],[34,8,34,10],[34,11,34,13],[34,14,34,16],[34,32,34,34],[34,35,34,37],[34,17,34,19],[34,20,34,22],[34,23,34,25],[34,26,34,28],[34,29,34,31]]}
[]
[null,"Costs","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Response",0.93277184224284004,1.3641419429101396,1.0084516969542601,1.5448673615628399,1.5287936042950399,2.6633870326414999,1.5232280532172102]
[null,"BM Generator Response (Mandatory) ",1.01655202,1.3163757700000001,0.84783121000000006,1.4231160200000006,1.4022486599999997,1.3539585299999997,1.3846211899999998]
[null,"BM Generator Response (Commercial)",3.6332199999999982E-3,2.4158499999999993E-3,3.3382199999999985E-3,2.2192079999999999E-2,3.4454099999999994E-3,1.6601399999999992E-3,1.2082399999999995E-3]
[null,"BM Generator Response Energy (Mandatory) ",-1.7549590000000007E-2,5.2887630000000005E-2,1.1874399999999992E-2,2.7315900000000086E-3,-0.13242075,-0.14906638999999999,-0.23228614999999994]
[null,"BM Generator Response Energy (Commercial) ",2.4391029999999998E-2,1.3107280000000001E-2,2.2147460000000001E-2,2.6845830000000005E-2,8.9274300000000001E-3,1.4221169999999998E-2,1.3363650000000001E-2]
[null,"Hydro Spin Gen with LF",4.9335000000000011E-2,5.870149999999999E-2,3.9289249999999991E-2,8.1493830000000003E-2,5.0556999999999998E-2,4.2613999999999999E-2,5.0193000000000002E-2]
[null,"Hydro Pump deload",0.22949577999999995,0.40629951999999991,0.32227657999999998,0.21654569999999998,0.28260043000000001,0.12800391000000003,3.500458E-2]
[null,"BM Enhanced Frequency Response (Commercial)",0,0,0,0,0,0,0]
[null,"Interconnector Response (Commercial)",0,0,0,0,0,0,0]
[null,"NBM Enhanced Frequency Response (Commercial)",0.77432570999999983,0.83880858000000003,1.0114897200000004,1.5894462099999997,1.7709979700000011,1.7170810099999994,1.7869189299999995]
[null,"NBM Demand Side Response (Commerical)",0.55342712999958976,0.48931667999982198,0.49979961918975363,0.71205014,0.94281759654799902,0.6741789279760203,0.84062797884453777]
[null,"BM Other Response (Commercial)",0,0,0,0,0,0,0]
[null,"NBM Other Response (Commercial)",0.11356677999999995,0.11279195000000004,0.10679139999999991,0.11194775000000007,0.11719586999999999,0.11870782999999997,0.12294295999999991]
[null,"BM FFR (Tendered)",3.5310030000000006,3.6054420000000014,3.6171050000000005,1.2472499999999997,1.2375,1.2049999999999998,1.2509999999999999]
[null,"BM FFR  Response Energy (Tendered)",0.84099475000000012,0.88697166999999999,0.90476744999999981,0.57234756000000009,0.5934778599999998,0.62054515999999982,0.61929453000000012]
[null,"NBM FFR (Tendered)",2.9598381000000002,3.0650364500000005,3.0652745999999995,2.9881434000000002,2.9540093999999999,2.9791046400000001,3.1155012400000004]
[]
[]
[null,null,"2018-04-01",null,null,"2018-05-01",null,null,"2018-06-01",null,null,"2018-07-01",null,null,"2018-08-01",null,null,"2018-09-01",null,null,"2018-10-01",null,null,"2018-11-01",null,null,"2018-12-01",null,null,"2019-01-01",null,null,"2019-02-01",null,null,"2019-03-01"]
[null,"Holding volumes","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H"]
[null,"BM Generator Response (Mandatory) ",null,null,null,150171.685,91998.91,233097.58900000001,104561.59099999999,57607.064000000013,144299.33500000002,151506.82199999999,97958.865000000049,257625.087,128375.481,80725.917000000001,274727.75400000002,135027.89899999998,73518.505999999994,292607.74,126997.64500000002,70855.067999999985,305858.33300000004]
[null,"Hydro Spin Gen with LF",0,1687.68,0,0,2044.17,0,0,1344.87,0,0,3021.29,0,0,1670.86,0,0,1429.84,0,0,1716.98,0]
[null,"Hydro Pump deload",29234.1,36194.6,null,49249.2,60975.199999999997,null,42529.2,52655.199999999997,null,27768.3,34379.800000000003,null,35523.300000000003,44088.2,null,15567.3,19273.8,null,4323.8999999999996,5353.4]
[null,"BM Enhanced Frequency Response (Commercial)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Interconnector Response (Commercial)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NBM Enhanced Frequency Response (Commercial)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"NBM Demand Side Response (Commerical)",0,85038.606701502242,6712,0,76509.528538001963,4152,0,82753.248521882371,664,0,114383.88892087407,80,0,148804.15251235166,0,0,110141.67397579261,464,0,135143.26245186041,5870]
[null,"BM Other Response (Commercial)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"BM FFR (Tendered)",225922,190672,111760,235456,198860.79999999999,120956,228498,192779,100660,82286,53050.6,0,84286,53050.6,0,81430,51253,0,84541,53211.1,0]
[null,"NBM FFR (Tendered)",83197.56,250394.4725,102007.56,125423.58,305355.53000000003,122273.58,137731,336120,143881,121842,353327.28,111977,149093.67499999999,341976.67499999999,126806.675,143007.56,308516.56,112847.19,126083.13,280068.13,96794.13]
[null,null,{"$f":"SUM(C23:C32)","v":338353.66000000003},{"$f":"SUM(D23:D32)","v":563987.35920150229},220479.56,560300.46499999997,735744.13853800204,480479.16900000005,513319.79099999997,723259.38252188242,389504.33500000002,383403.12199999997,656121.72392087406,369682.087,397278.45600000001,670316.40451235161,401534.429,375032.75899999996,564133.3799757926,405918.93,341945.67500000005,546347.94045186043,408522.46300000005,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"2018-04-01",null,null,"2018-05-01",null,null,"2018-06-01",null,null,"2018-07-01",null,null,"2018-08-01",null,null,"2018-09-01",null,null,"2018-10-01",null,null,"2018-11-01",null,null,"2018-12-01",null,null,"2019-01-01",null,null,"2019-02-01",null,null,"2019-03-01"]
[null,"Holding volumes (TWh)","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H","P","S","H"]
[null,"BM Generator Response (Mandatory) ",{"$f":"C23/1000","v":0},0,0,{"$f":"F23/1000","v":150.171685},91.998910000000009,233.097589,{"$f":"I23/1000","v":104.56159099999999},57.607064000000015,144.29933500000001,151.506822,97.958865000000046,257.62508700000001,{"$f":"O23/1000","v":128.37548100000001},80.725916999999995,274.727754,{"$f":"R23/1000","v":135.02789899999996},73.518505999999988,292.60773999999998,{"$f":"U23/1000","v":126.99764500000002},70.855067999999989,305.85833300000002]
[null,"Hydro Spin Gen with LF",0,1.6876800000000001,0,{"$f":"F24/1000","v":0},2.0441700000000003,0,{"$f":"I24/1000","v":0},1.3448699999999998,0,0,3.02129,0,{"$f":"O24/1000","v":0},1.6708599999999998,0,{"$f":"R24/1000","v":0},1.42984,0,{"$f":"U24/1000","v":0},1.71698,0]
[null,"Hydro Pump deload",29.234099999999998,36.194600000000001,0,{"$f":"F25/1000","v":49.249199999999995},60.975199999999994,0,{"$f":"I25/1000","v":42.529199999999996},52.655199999999994,0,27.7683,34.379800000000003,0,{"$f":"O25/1000","v":35.523300000000006},44.088200000000001,0,{"$f":"R25/1000","v":15.567299999999999},19.273799999999998,0,{"$f":"U25/1000","v":4.3239000000000001},5.3533999999999997,0]
[null,"BM Enhanced Frequency Response (Commercial)",0,0,0,{"$f":"F26/1000","v":0},0,0,{"$f":"I26/1000","v":0},0,0,0,0,0,{"$f":"O26/1000","v":0},0,0,{"$f":"R26/1000","v":0},0,0,{"$f":"U26/1000","v":0},0,0]
[null,"Interconnector Response (Commercial)",0,0,0,{"$f":"F27/1000","v":0},0,0,{"$f":"I27/1000","v":0},0,0,0,0,0,{"$f":"O27/1000","v":0},0,0,{"$f":"R27/1000","v":0},0,0,{"$f":"U27/1000","v":0},0,0]
[null,"NBM Enhanced Frequency Response (Commercial)",0,0,0,{"$f":"F28/1000","v":0},0,0,{"$f":"I28/1000","v":0},0,0,0,0,0,{"$f":"O28/1000","v":0},0,0,{"$f":"R28/1000","v":0},0,0,{"$f":"U28/1000","v":0},0,0]
[null,"NBM Demand Side Response (Commerical)",0,85.038606701502246,6.7119999999999997,{"$f":"F29/1000","v":0},76.509528538001959,4.1520000000000001,{"$f":"I29/1000","v":0},82.753248521882369,0.66400000000000003,0,114.38388892087407,0.08,{"$f":"O29/1000","v":0},148.80415251235166,0,{"$f":"R29/1000","v":0},110.14167397579261,0.46400000000000002,{"$f":"U29/1000","v":0},135.14326245186041,5.87]
[null,"BM Other Response (Commercial)",0,0,0,{"$f":"F30/1000","v":0},0,0,{"$f":"I30/1000","v":0},0,0,0,0,0,{"$f":"O30/1000","v":0},0,0,{"$f":"R30/1000","v":0},0,0,{"$f":"U30/1000","v":0},0,0]
[null,"BM FFR (Tendered)",225.922,190.672,111.76,{"$f":"F31/1000","v":235.45599999999999},198.86079999999998,120.956,{"$f":"I31/1000","v":228.49799999999999},192.779,100.66,82.286000000000001,53.050599999999996,0,{"$f":"O31/1000","v":84.286000000000001},53.050599999999996,0,{"$f":"R31/1000","v":81.430000000000007},51.253,0,{"$f":"U31/1000","v":84.540999999999997},53.211100000000002,0]
[null,"NBM FFR (Tendered)",83.197559999999996,250.39447250000001,102.00756,{"$f":"F32/1000","v":125.42358},305.35553000000004,122.27358,{"$f":"I32/1000","v":137.73099999999999},336.12,143.881,121.842,353.32728000000003,111.977,{"$f":"O32/1000","v":149.09367499999999},341.976675,126.806675,{"$f":"R32/1000","v":143.00755999999998},308.51655999999997,112.84719,{"$f":"U32/1000","v":126.08313000000001},280.06813,96.79413000000001]

{"sheet":"Reactive","index":15,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"AS-BM Default Utilisation (Mandatory - CVA)",6.2702793699999999,6.9502131499999997,7.2633594099999987,6.4550056199999988,6.6008566500000008,6.07048918,6.71078347]
[null,"AS-BM Utilisation (Mandatory - SVA)",6.9380100000000031E-3,6.9932999999999966E-3,4.7684999999999993E-3,5.8610499999999961E-3,7.7744799999999959E-3,1.114969E-2,1.2554160000000003E-2]
[null,"AS-BM Reactive Utilisation (Commercial)",0.125,0,0,0,0,0,0.27174999999999999]
[null,"AS-BM Syncronous Compensation ( Commerical)",6.3610730390203388E-2,0.11694529202500002,9.2252900000000027E-2,0.10103508999999995,8.8136207666672364E-2,4.8607619097306128E-3,1.2745279999999999E-2]
[null,"Power Potential ( Commercial)",0,0,0,0,0,0,0]
[]
[]
[null,null,"2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"BM Default Utilisation (Mandatory - CVA)",2115437.9499999997,2364237.4299999997,2412139.4499999997,2087880.8099999994,2105063.69,1855789.89,1976159.58]
[null,"BM Reactive Utilisation (Commercial)",2489,2280,1517,1809,2376,3250.66,3391.84]
[null,"BM Utilisation (Mandatory - SVA)",0,0,0,0,0,0,0]
[null,"Power Potential (Commercial)",0,0,0,0,0,0,0]
[null,null,{"$f":"SUM(C11:C14)","v":2117926.9499999997},{"$f":"SUM(D11:D14)","v":2366517.4299999997},2413656.4499999997,2089689.8099999994,2107439.69,1859040.5499999998,1979551.4200000002,0,0,0,0,0]
[]
[]
[null,"Reporting Month"]
[null,{"$f":"HLOOKUP(Main!E1,Reactive!C10:N15,6,FALSE)","v":1979551.4200000002}]

{"sheet":"Black Start","index":16,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"BM  Black Start Availability (Commercial)",3.1310032699999994,3.31364306,3.0811221499999997,2.7890434400000004,3.1526730899999995,2.8997111700000557,3.2868622800000007]
[null,"Interconnector Black Start Availability (Commercial)",4.464690000000001E-2,3.2394960000000007E-2,4.9838400000000019E-2,4.8384780000000016E-2,5.149968000000002E-2,4.9838400000000019E-2,5.149968000000002E-2]
[null,"BM Black Start Test (Commerical)",0,0,0,0,0,1.4017999999999999E-2,0]
[null,"BM Black Start Capital Contributions (Commerical)",0,0,0,0,0,0.16780716000000001,0]
[null,"BM Black Start Feasibility (Commercial)",0,0.22357520396526012,0,0,4.5933998760107821E-2,0.186,0]
[null,"BM Black Start Warming (Commercial)",0.19039999999999993,0.1008,0.1008,0.22399999999999989,0.32479999999999981,0.1232,0.13439999999999999]
[null,"BM Black Start Other (Commerical)",0,0,0,0,0,0,0]

{"sheet":"Other Reserves","index":17,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
[null,"BM Warming (Commercial)",9.1999999999999998E-2,5.1750160000000003E-2,6.8999999999999999E-3,6.6036659999999997E-2,0.1015595,0.11536666999999999,0.42221401000000003]
[null,"BM Demand Turn Up (Commercial)",0,0,0,0,0,0,0]
[null,"BM Power Potential (Commercial)",0,0,0,0,0,0,0]
[null,"NBM Demand Turn Up (Commerical)",0,3.179284000000001E-2,3.8986970000000003E-2,0.11493933999999989,3.9060519999999987E-2,2.8436919999999987E-2,2.590878000000001E-2]
[null,"BM GT Fast Start Availability (Commerial)",0.40913443999999999,0.4156603000000002,0.38598527999999999,0.43290860999999997,0.45567308000000023,0.41326052999999996,0.37592209999999998]
[null,"Hydro Rapid Start And GT Fast Start Utilisation (Commercial)",0,0,0,0,0,0,9.6226133333333075E-2]
[null,"Hydro Optional Spin Pump (Commercial)",0.28598498999999999,0.4205025,0.39410752000000004,0.54507834000000011,0.56219499999999989,0.49811084999999999,0.40205999999999997]
[]
[]
[null,null,"2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01"]
["availability","Hydro Optional Spin Pump availability (MWh)",20732.75,27099.7,26412.1,38711.800000000003,37026.65,35267.199999999997,29192.05]
[null,"Hydro Rapid Start And GT Fast Start utilisation (MWh)",0,0,0,0,0,0,137.66999999999999]
["sites","BM GT Fast Start Availability number of sites",20,19,18,17,19]
[null,"NBM Demand Turn Up utilisation (MWh)",0,0,0,0,0,0,0]
[null,"BM Power Potential utilisation (MWh)",0,0,0,0,0,0,0]
[null,"BM Demand Turn Up utilisation (MWh)",0,0,0,0,0,0,0]
["instructions","BM Warming instructions",3,5,1,6,3,7,27]

{"sheet":"Minor components","index":18,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Costs","2018-04-30","2018-05-31","2018-06-30","2018-07-31","2018-08-31","2018-09-30","2018-10-31","2018-11-30","2018-12-31","2019-01-31","2019-02-28","2019-03-31"]
[null,"BM - Minor Components",1.2202173698917604,1.1494566828511801,1.5945901102273203,1.5264936295931404,2.4924715111293807,2.7549183945881,1.9442274250214204]
[null,"SO-SO - Minor Components",0,0,0,0,0,0,0]
[null,"AS - Minor Components",0.20057649540983621,0.20702975459016409,0.20035137540983622,0.20702975459016409,0.20702975459016409,0.20035137540983622,0]
[null,"Non-Delivery & Reconciliation"]
[null,"Non Delivery",-0.34349699999999889,-0.43191784999999983,-0.48340252000000045,-0.58798717999999983,-0.54904309999999923,-1.0746153099999978,-0.8741023]
[null,"Reconcilliation",-0.46412434422945004,-0.49088052159019102,-0.59908852640978383,-0.6291931235901207,-0.66340977859023065,-1.2462014576142368,-1.494726992999946]