{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Submission Sheet","Auto","Calendar","Drop down boxes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Submission Sheet","index":0,"n_rows":62,"n_cols":42,"rows_kept":62,"cut":false,"hidden":false,"merged":[[54,0,61,0],[54,3,54,6],[55,1,58,1],[55,2,58,3],[3,26,4,26],[3,27,4,27],[3,28,4,28],[3,20,4,20],[3,21,4,21],[2,24,4,24],[3,22,4,22],[3,23,4,23],[2,41,4,41],[2,37,4,37],[2,38,4,38],[2,3,4,3],[2,0,4,0],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,1,4,1],[2,2,4,2],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[2,36,4,36],[3,25,4,25]]}
["Indication of FFR results for tender round 104, accepted tenders will be officially notified via issued acceptance letter"]
[]
["Tender Ref","Status","Rejection Code","Company Name","Tendered Unit \n(BMU/Unit ID)","TO connection  /  DNO connection","Generation Type","Start Date","End Date","Tendered Period \n(dd.mm.yy - dd.mm.yy)","Applicable FFR Capability Data Table","Tendered Frames per Service Day",null,null,null,null,null,null,null,null,"Tendered Prices***",null,null,null,"BMUs  Only - Applicable Balancing Service           (i.e. ABSVD Imbalance) YES/NO","Dynamic Providers Only",null,null,null,"Dynamic Providers only",null,null,null,null,null,null,"Please indicate as per detail change provision if you are adding volume","Please state the accepted tender that you are stacking onto","Please state if this is an all or nothing bid.\n\nClearly reference what lines are included in each all or nothing bid","Non-Dynamic Providers                                              ",null,"Comments "]
[null,null,null,null,null,null,null,null,null,null,null,"Working Days \n(Mon-Fri)",null,null,"Saturdays",null,null,"Sundays/Bank Holidays",null,null,"Availability Fee (£/h)","Nomination Fee (£/h)","Window Initiation Fee (£/window)","Response Energy Fee (Non-BM only) (£/MW/h)",null,"Maximum Part Load Point (MW)","Minimum Part Load Point (MW)","Minimum MEL (MW)","Maximum SEL (MW)",null,null,null,null,null,null,null,null,null,null,"Volume of Response Tendered"]
[null,null,null,null,null,null,null,null,null,null,null,"From","To","Duration (h)","From","To","Duration (h)","From","To","Duration (h)",null,null,null,null,null,null,null,null,null,"Primary Response (max.) @ 0.2Hz (MW)","Primary Response (max.) @ 0.5Hz (MW)","Primary Response (max.) @ 0.8Hz (MW)","Secondary Response (max.) @ 0.2/0.2Hz (MW)","Secondary Response (max.) @ 0.5/0.5Hz (MW)","High Frequency Response (max.) @ 0.2Hz (MW)","High Frequency Response (max.) @ 0.5Hz (MW)",null,null,null,"Automatic Response Energy Deliverable by 10s (MW)","Automatic Response Energy Deliverable by 30s (MW)"]
[104,null,null,"Example Company","Ex-FFR-1","TO connection","Wind",{"$f":"'Drop down boxes'!D3","v":"2018-10-01"},{"$f":"'Drop down boxes'!E2","v":"2018-10-31"},{"$f":"TEXT(H6,\"DD.MM.YY\")&\" - \"&TEXT(I6,\"DD.MM.YY\")&\" (\"&DATEDIF(H6,I6+1,\"m\")&\" months)\"","v":"01.10.18 - 31.10.18 (1 months)"},"As per FFR framework agreement ","23:00:00","07:00:00",8,"23:00:00","07:00:00",8,"23:00:00","07:00:00",8,100,600,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-"]
[{"$f":"A6","v":104},null,null,"Example Company",{"$f":"E6","v":"Ex-FFR-1"},"DNO connection","Gas",{"$f":"H6","v":"2018-10-01"},{"$f":"I6","v":"2018-10-31"},{"$f":"TEXT(H7,\"DD.MM.YY\")&\" - \"&TEXT(I7,\"DD.MM.YY\")&\" (\"&DATEDIF(H7,I7+1,\"m\")&\" months)\"","v":"01.10.18 - 31.10.18 (1 months)"},"As per FFR framework agreement ","07:00:00","23:00:00",16,"07:00:00","23:00:00",16,"07:00:00","23:00:00",16,600,100,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,"-","-","-"]
[{"$f":"A6+0.001","v":104.001},"Rejected",1.3,"First Hydro Company","DINO-1","TO connection","Hydro","2018-09-01","2018-09-30",{"$f":"TEXT(H8,\"DD.MM.YY\")&\" - \"&TEXT(I8,\"DD.MM.YY\")&\" (\"&DATEDIF(H8,I8+1,\"m\")&\" months)\"","v":"01.09.18 - 30.09.18 (1 months)"},"As per FFR framework agreement ",700,1500,{"$f":"IF(L8>M8, (2400-L8+M8)/100, IF(L8=M8, 24, (M8-L8)/100))","v":8},700,1500,{"$f":"IF(O8>P8, (2400-O8+P8)/100, IF(O8=P8, 24, (P8-O8)/100))","v":8},700,1500,{"$f":"IF(R8>S8, (2400-R8+S8)/100, IF(R8=S8, 24, (S8-R8)/100))","v":8},1300,1300,0,"-","NO",150,150,288,150,68,170,170,107,170,0,0]
[{"$f":"A8+0.001","v":104.00200000000001},"Rejected",1.3,"RWE Generation UK plc","DIDCB05Z","TO connection","Gas","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L9>M9, (2400-L9+M9)/100, IF(L9=M9, 24, (M9-L9)/100))","v":8},2300,700,{"$f":"IF(O9>P9, (2400-O9+P9)/100, IF(O9=P9, 24, (P9-O9)/100))","v":8},2300,700,{"$f":"IF(R9>S9, (2400-R9+S9)/100, IF(R9=S9, 24, (S9-R9)/100))","v":8},1132,0,0,null,"YES",540,515,680,410,40,104,125,55,140,40,105,"N/A","N/A","AoN with line below","N/A","N/A","7-8 mins required to transition between PLPs\n"]
[{"$f":"A9+0.001","v":104.00300000000001},"Rejected",2,"RWE Generation UK plc","DIDCB05Z","TO connection","Gas","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,1132,0,0,null,"YES",740,502,502,410,0,0,0,0,0,32,92,"N/A","N/A","AoN with line above","N/A","N/A","7-8 mins required to transition between PLPs.\nMultiple PLPs will be required due to ambient conditions - no loss of FR capability.\nFull Load operation, PLP=MEL."]
[104.00400000000002,"Rejected",1.3,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,752,0,null,null,"Yes",550,550,785,467,60,92,92,80,126,60,140,null,null,"A",null,null,"Station needs 20 minutes to ramp between PLPs of overnight and daytime tenders. Either A or B. Station declared MEL may be below Minimum MEL due to high ambient temperature, however Frequency Response will be maintained. "]
[104.00500000000002,"Rejected",1.3,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,752,0,null,null,"Yes",785,785,785,467,0,0,0,0,0,40,140,null,null,"A",null,null,"Station needs 20 minutes to ramp between PLPs of overnight and daytime tenders. Either A or B.  Station declared MEL may be below Minimum MEL due to high ambient temperature, however Frequency Response will be maintained. "]
[104.00600000000003,"Rejected",1.3,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,2035,0,null,null,"Yes",550,550,760,467,60,92,92,80,126,60,140,null,null,"B",null,null," Either A or B. "]
[104.00700000000003,"Rejected",4,"Energy Pool","EPFFR-1","DNO connection","Battery","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,4.91,0,"-","-","-","-","-","-","-",0.4,1,1,0.4,1,0.4,1,"-","-","A","-","-","Mutually exclusive of B. High 30mins only"]
[104.00800000000004,"Accepted","N/A","Energy Pool","EPFFR-1","DNO connection","Battery","2018-08-31","2018-09-30",{"$f":"TEXT(H15,\"DD.MM.YY\")&\" - \"&TEXT(I15,\"DD.MM.YY\")&\" (\"&DATEDIF(H15,I15+1,\"m\")&\" months)\"","v":"31.08.18 - 30.09.18 (1 months)"},"As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,11.64,0,"-","-","-","-","-","-","-",0.4,1,1,0.4,1,0.4,1,"-","-","B","-","-","Mutually exclusive of A. High 30mins only"]
[104.00900000000004,"Rejected",1.3,"KiWi Power Ltd","KIWID-1","DNO connection","Battery","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,16,null,null,null,null,null,null,null,null,0.8,2,2,0.8,2,0.8,2]
[104.01000000000005,"Accepted","N/A","Limejump Ltd","LJDYN-3","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,27.96,null,null,null,null,null,null,null,null,1.6,4,4,1.6,4,1.6,4,null,null,null,null,null,"H only for 30mins"]
[{"$f":"A17+0.001","v":104.01100000000005},"Rejected",1.3,"Limejump Ltd","LJDYN-3","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1500,2300,8,1500,2300,8,1500,2300,8,23.96,null,null,null,null,null,null,null,null,1.6,4,4,1.6,4,1.6,4,null,null,null,null,null,"H only for 30mins"]
[104.01200000000006,"Accepted","N/A","Limejump Virtual 9","LJDYW-1","DNO connection","DSF: Storage (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,63,null,null,null,null,null,null,null,null,2.8,7,7,2.8,7,2.8,7,null,null,null,null,null,"H only for 30mins, only one of 104.003, 104.004"]
[104.01300000000006,"Rejected",4,"Limejump Virtual 9","LJDYW-1","DNO connection","DSF: Storage (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,1500,16,2300,1500,16,2300,1500,16,70,null,null,null,null,null,null,null,null,2.8,7,7,2.8,7,2.8,7,null,null,null,null,null,"H only for 30mins, only one of 104.003, 104.004"]
[104.01400000000007,"Accepted","N/A","Limejump Ltd","LJDYN-7","DNO connection","DSF: Storage (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,110,null,null,null,null,null,null,null,null,4,10,10,4,10,4,10,null,null,null,null,null,"H only for 30mins"]
[104.01500000000007,"Rejected",1.3,"Limejump Ltd","LJDYN-7","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,110,null,null,null,null,null,null,null,null,4,10,10,4,10,4,10,null,null,null,null,null,"H only for 30mins"]
[104.01600000000008,"Rejected",1.3,"Limejump Ltd","LJDYN-5","DNO connection","DSF: Storage (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,66,null,null,null,null,null,null,null,null,2.4,6,6,2.4,6,2.4,6,null,null,null,null,null,"H only for 30mins"]
[104.01700000000008,"Accepted","N/A","Limejump Ltd","LJDYN-6","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,138,null,null,null,null,null,null,null,null,8,20,20,8,20,8,20,null,null,null,null,null,"H only for 30mins"]
[104.01800000000009,"Rejected",1.3,"Limejump Ltd","LJDYN-6","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1500,2300,8,1500,2300,8,1500,2300,8,137,null,null,null,null,null,null,null,null,8,20,20,8,20,8,20,null,null,null,null,null,"H only for 30mins"]
[104.01900000000009,"Rejected",1.3,"Limejump Ltd","LJDYP-2","DNO connection","DSF: Storage (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,300,4,2300,300,4,2300,300,4,140,null,null,null,null,null,null,null,null,0,0,0,0,0,8,20,null,null,null,null,null,"H only for 30mins"]
[104.0200000000001,"Accepted","N/A","Limejump Ltd","LJDYN-1","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,54,null,null,null,null,null,null,null,null,2.4,6,6,2.4,6,2.4,6,null,null,null,null,null,"H only for 30mins, only one of 104.015, 104.016"]
[104.0210000000001,"Rejected",4,"Limejump Ltd","LJDYN-1","DNO connection","DSF: Storage (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,60,null,null,null,null,null,null,null,null,2.4,6,6,2.4,6,2.4,6,null,null,null,null,null,"H only for 30mins, only one of 104.015, 104.016"]
[{"$f":"A28+0.001","v":104.02200000000011},"Rejected",1.3,"KiWi Power Ltd","KIWIS-1","DNO connection","Multiple Fuel Type","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[104.02300000000011,"Rejected",4,"Limejump Ltd","LJFFR-1","DNO connection","DSF: Distributed generation (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,22.400000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Only one of 104.005, 104.006"]
[104.02400000000011,"Accepted","N/A","Limejump Ltd","LJFFR-1","DNO connection","DSF: Distributed generation (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,26.459999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Only one of 104.005, 104.006"]
[104.02500000000012,"Rejected",4,"Limejump Ltd","LJFFR-2","DNO connection","DSF: Distributed generation (for export)","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,23.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Only one of 104.007, 104.008"]
[104.02600000000012,"Accepted","N/A","Limejump Ltd","LJFFR-2","DNO connection","DSF: Distributed generation (for export)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,28.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Only one of 104.007, 104.008"]
[104.02700000000013,"Accepted","N/A","Noriker Unity","NKPU-5","DNO connection","hybrid","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,10,0,null,null,null,null,null,null,null,4.8,12,12,0,0,0.4,1,"additional volume",74.188999999999993]
[104.02800000000013,"Accepted","N/A","Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,22,"-","-","-","-","-","-","-","-",{"$f":"AH35*0.4","v":1.2000000000000002},{"$f":"AH35","v":3},{"$f":"AH35","v":3},{"$f":"AH35*0.4","v":1.2000000000000002},3,{"$f":"AJ35*0.4","v":2.8000000000000003},7,"-","-","B",null,null,"Mutually exclusive of A"]
[104.02900000000014,"Accepted","N/A","PeakGen","PGFFR-7","DNO connection","Diesel","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[104.03000000000014,"Accepted","N/A","PeakGen","PGFFR-8","DNO connection","Diesel","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[104.03100000000015,"Rejected",1.3,"PeakGen","PGFFR-5","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[104.03200000000015,"Accepted","N/A","PeakGen","PGFFR-9","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[104.03300000000016,"Accepted","N/A","REstore Flexpond UK Ltd.","REST-1","DNO connection","Multiple Fuel Type","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,27.8,"-","-","-","-","-","-","-","-",1.6,4,4,1.6,4,1.6,4,"NO","-","-","-","-","-"]
[104.03400000000016,"Accepted","N/A","REstore Flexpond UK Ltd.","REST-1","DNO connection","Multiple Fuel Type","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,4.95,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,0.4,1,"YES",102252,"-","-","-","-"]
[104.03500000000017,"Rejected",1.3,"REstore Flexpond UK Ltd.","RESTFFR-1","DNO connection","DSF: Load response","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,51.75,"-","-","-","-","-","-","-","-",0,35,35,0,45,0,0,"NO","-","-","-","-","-"]
[104.03600000000017,"Accepted","N/A","REstore Flexpond UK Ltd.","RESTFFR-1","DNO connection","DSF: Load response","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,80.45,"-","-","-","-","-","-","-","-",0,35,35,0,45,0,0,"NO","-","-","-","-","-"]
[104.03700000000018,"Accepted","N/A","Upside Energy","UPEN-1","DNO connection","Battery","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,7,null,null,null,null,null,null,null,null,0.4,1,1,0.4,1,0,0]
[104.03800000000018,"Rejected",1.3,"Buxton Power Limited","BPLFFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16]
[104.03900000000019,"Rejected",1.3,"Buxton Power Limited","BPLFFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1500,700,16,1500,700,16,1500,700,16,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16]
[104.04000000000019,"Accepted","N/A","NG1 Power Limited","NG1FFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[104.0410000000002,"Accepted","N/A","NG1 Power Limited","NG1FFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1500,700,16,1500,700,16,1500,700,16,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[104.0420000000002,"Rejected",1.3,"Waterswallows Power Limited","WPLFFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,14]
[104.04300000000021,"Rejected",1.3,"Waterswallows Power Limited","WPLFFR-1","DNO connection","Diesel","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1500,700,16,1500,700,16,1500,700,16,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,14]
[104.04400000000021,"Accepted","N/A","Electricity North West Ltd","ENWL-1","DNO connection","DSF: Load response","2018-08-31","2018-09-30","31.08.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,12.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[104.04500000000021,"Rejected",1.3,"Electricity North West Ltd","ENWL-1","DNO connection","DSF: Load response","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",1900,2300,4,1900,2300,4,1900,2300,4,26.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[104.04600000000022,"Rejected",1.3,"Keystone Power Ltd","PLYM-FFR","DNO connection","DSF: Distributed generation (onsite)","2018-09-01","2018-09-30","01.09.18 - 30.09.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,24,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"planning now approved night ops"]
[]
["Rejection Codes","Code",null,"Reason"]
[null,1,"Beneficial",null,1.1000000000000001,"Req. satisifed by more beneficial bids"]
[null,null,null,null,1.2,"No outstanding req."]
[null,null,null,null,1.3,"Desired procurement volume already met"]
[null,null,null,null,1.4,"Formed part of AON. Not collectively beneficial"]
[null,2,"Price not beneificial across tendered period"]
[null,3,"Does not meet tender prerequisites"]
[null,4,"Multiple tenders received for the same unit"]

{"sheet":"Auto","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Path to the Tenders Folder","S:\\OandT\\EBandET\\Contracts\\Services & Projects\\Firm Frequency Response Service\\FFR spreadshhet test\\Ariba Received"]
["Tender Round",97]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Calendar","index":2,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["May-18","Jun-18","Jul-18","Aug-18","Sep-18","Oct-18","Nov-18","Dec-18","Jan-19","Feb-19","Mar-19","Apr-19","May-19","Jun-19","Jul-19","Aug-19","Sep-19","Oct-19","Nov-19","Dec-19","Jan-20","Feb-20","Mar-20","Apr-20","May-20","Jun-20","Jul-20","Aug-20","Sep-20","Oct-20","Nov-20","Dec-20","Jan-21","Feb-21","Mar-21","Apr-21","May-21","Jun-21"]
[101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138]
["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","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01"]
[null,"2018-07-01",null,null,"2018-10-01",null,null,"2019-01-01",null,null,"2019-04-01",null,null,"2019-07-01",null,null,"2019-10-01",null,null,"2020-01-01",null,null,"2020-04-01",null,null,"2020-07-01",null,null,"2020-10-01",null,null,"2021-01-01",null,null,"2021-04-01",null,null,"2021-07-01"]
[null,"2018-08-01",null,null,"2018-11-01",null,null,"2019-02-01",null,null,"2019-05-01",null,null,"2019-08-01",null,null,"2019-11-01",null,null,"2020-02-01",null,null,"2020-05-01",null,null,"2020-08-01",null,null,"2020-11-01",null,null,"2021-02-01",null,null,"2021-05-01",null,null,"2021-08-01"]
[null,"2018-09-01",null,null,"2018-12-01",null,null,"2019-03-01",null,null,"2019-06-01",null,null,"2019-09-01",null,null,"2019-12-01",null,null,"2020-03-01",null,null,"2020-06-01",null,null,"2020-09-01",null,null,"2020-12-01",null,null,"2021-03-01",null,null,"2021-06-01",null,null,"2021-09-01"]
[null,"2018-10-01",null,null,"2018-10-01",null,null,"2019-04-01",null,null,"2019-04-01",null,null,"2019-10-01",null,null,"2019-10-01",null,null,"2020-04-01",null,null,"2020-04-01",null,null,"2020-10-01",null,null,"2020-10-01",null,null,"2021-04-01",null,null,"2021-04-01",null,null,"2021-10-01"]
[null,"2018-11-01",null,null,"2018-11-01",null,null,"2019-05-01",null,null,"2019-05-01",null,null,"2019-11-01",null,null,"2019-11-01",null,null,"2020-05-01",null,null,"2020-05-01",null,null,"2020-11-01",null,null,"2020-11-01",null,null,"2021-05-01",null,null,"2021-05-01",null,null,"2021-11-01"]
[null,"2018-12-01",null,null,"2018-12-01",null,null,"2019-06-01",null,null,"2019-06-01",null,null,"2019-12-01",null,null,"2019-12-01",null,null,"2020-06-01",null,null,"2020-06-01",null,null,"2020-12-01",null,null,"2020-12-01",null,null,"2021-06-01",null,null,"2021-06-01",null,null,"2021-12-01"]
[null,"2019-01-01",null,null,"2019-01-01",null,null,"2019-07-01",null,null,"2019-07-01",null,null,"2020-01-01",null,null,"2020-01-01",null,null,"2020-07-01",null,null,"2020-07-01",null,null,"2021-01-01",null,null,"2021-01-01",null,null,"2021-07-01",null,null,"2021-07-01",null,null,"2022-01-01"]
[null,"2019-02-01",null,null,"2019-02-01",null,null,"2019-08-01",null,null,"2019-08-01",null,null,"2020-02-01",null,null,"2020-02-01",null,null,"2020-08-01",null,null,"2020-08-01",null,null,"2021-02-01",null,null,"2021-02-01",null,null,"2021-08-01",null,null,"2021-08-01",null,null,"2022-02-01"]
[null,"2019-03-01",null,null,"2019-03-01",null,null,"2019-09-01",null,null,"2019-09-01",null,null,"2020-03-01",null,null,"2020-03-01",null,null,"2020-09-01",null,null,"2020-09-01",null,null,"2021-03-01",null,null,"2021-03-01",null,null,"2021-09-01",null,null,"2021-09-01",null,null,"2022-03-01"]
[null,"2019-04-01",null,null,"2019-04-01",null,null,"2019-10-01",null,null,"2019-10-01",null,null,"2020-04-01",null,null,"2020-04-01",null,null,"2020-10-01",null,null,"2020-10-01",null,null,"2021-04-01",null,null,"2021-04-01",null,null,"2021-10-01",null,null,"2021-10-01",null,null,"2022-04-01"]
[null,"2019-05-01",null,null,"2019-05-01",null,null,"2019-11-01",null,null,"2019-11-01",null,null,"2020-05-01",null,null,"2020-05-01",null,null,"2020-11-01",null,null,"2020-11-01",null,null,"2021-05-01",null,null,"2021-05-01",null,null,"2021-11-01",null,null,"2021-11-01",null,null,"2022-05-01"]
[null,"2019-06-01",null,null,"2019-06-01",null,null,"2019-12-01",null,null,"2019-12-01",null,null,"2020-06-01",null,null,"2020-06-01",null,null,"2020-12-01",null,null,"2020-12-01",null,null,"2021-06-01",null,null,"2021-06-01",null,null,"2021-12-01",null,null,"2021-12-01",null,null,"2022-06-01"]
[null,"2019-07-01",null,null,"2019-07-01",null,null,"2020-01-01",null,null,"2020-01-01",null,null,"2020-07-01",null,null,"2020-07-01",null,null,"2021-01-01",null,null,"2021-01-01",null,null,"2021-07-01",null,null,"2021-07-01",null,null,"2022-01-01",null,null,"2022-01-01",null,null,"2022-07-01"]
[null,"2019-08-01",null,null,"2019-08-01",null,null,"2020-02-01",null,null,"2020-02-01",null,null,"2020-08-01",null,null,"2020-08-01",null,null,"2021-02-01",null,null,"2021-02-01",null,null,"2021-08-01",null,null,"2021-08-01",null,null,"2022-02-01",null,null,"2022-02-01",null,null,"2022-08-01"]
[null,"2019-09-01",null,null,"2019-09-01",null,null,"2020-03-01",null,null,"2020-03-01",null,null,"2020-09-01",null,null,"2020-09-01",null,null,"2021-03-01",null,null,"2021-03-01",null,null,"2021-09-01",null,null,"2021-09-01",null,null,"2022-03-01",null,null,"2022-03-01",null,null,"2022-09-01"]
[null,"2019-10-01",null,null,"2019-10-01",null,null,"2020-04-01",null,null,"2020-04-01",null,null,"2020-10-01",null,null,"2020-10-01",null,null,"2021-04-01",null,null,"2021-04-01",null,null,"2021-10-01",null,null,"2021-10-01",null,null,"2022-04-01",null,null,"2022-04-01",null,null,"2022-10-01"]
[null,"2019-11-01",null,null,"2019-11-01",null,null,"2020-05-01",null,null,"2020-05-01",null,null,"2020-11-01",null,null,"2020-11-01",null,null,"2021-05-01",null,null,"2021-05-01",null,null,"2021-11-01",null,null,"2021-11-01",null,null,"2022-05-01",null,null,"2022-05-01",null,null,"2022-11-01"]
[null,"2019-12-01",null,null,"2019-12-01",null,null,"2020-06-01",null,null,"2020-06-01",null,null,"2020-12-01",null,null,"2020-12-01",null,null,"2021-06-01",null,null,"2021-06-01",null,null,"2021-12-01",null,null,"2021-12-01",null,null,"2022-06-01",null,null,"2022-06-01",null,null,"2022-12-01"]
[null,"2020-01-01",null,null,"2020-01-01",null,null,"2020-07-01",null,null,"2020-07-01",null,null,"2021-01-01",null,null,"2021-01-01",null,null,"2021-07-01",null,null,"2021-07-01",null,null,"2022-01-01",null,null,"2022-01-01",null,null,"2022-07-01",null,null,"2022-07-01",null,null,"2023-01-01"]
[null,"2020-02-01",null,null,"2020-02-01",null,null,"2020-08-01",null,null,"2020-08-01",null,null,"2021-02-01",null,null,"2021-02-01",null,null,"2021-08-01",null,null,"2021-08-01",null,null,"2022-02-01",null,null,"2022-02-01",null,null,"2022-08-01",null,null,"2022-08-01",null,null,"2023-02-01"]
[null,"2020-03-01",null,null,"2020-03-01",null,null,"2020-09-01",null,null,"2020-09-01",null,null,"2021-03-01",null,null,"2021-03-01",null,null,"2021-09-01",null,null,"2021-09-01",null,null,"2022-03-01",null,null,"2022-03-01",null,null,"2022-09-01",null,null,"2022-09-01",null,null,"2023-03-01"]
[null,"2020-04-01",null,null,"2020-04-01",null,null,"2020-10-01",null,null,"2020-10-01",null,null,"2021-04-01",null,null,"2021-04-01",null,null,"2021-10-01",null,null,"2021-10-01",null,null,"2022-04-01",null,null,"2022-04-01",null,null,"2022-10-01",null,null,"2022-10-01",null,null,"2023-04-01"]
[null,"2020-05-01",null,null,"2020-05-01",null,null,"2020-11-01",null,null,"2020-11-01",null,null,"2021-05-01",null,null,"2021-05-01",null,null,"2021-11-01",null,null,"2021-11-01",null,null,"2022-05-01",null,null,"2022-05-01",null,null,"2022-11-01",null,null,"2022-11-01",null,null,"2023-05-01"]
[null,"2020-06-01",null,null,"2020-06-01",null,null,"2020-12-01",null,null,"2020-12-01",null,null,"2021-06-01",null,null,"2021-06-01",null,null,"2021-12-01",null,null,"2021-12-01",null,null,"2022-06-01",null,null,"2022-06-01",null,null,"2022-12-01",null,null,"2022-12-01",null,null,"2023-06-01"]
[null,"2020-07-01",null,null,"2020-07-01",null,null,"2021-01-01",null,null,"2021-01-01",null,null,"2021-07-01",null,null,"2021-07-01",null,null,"2022-01-01",null,null,"2022-01-01",null,null,"2022-07-01",null,null,"2022-07-01",null,null,"2023-01-01",null,null,"2023-01-01",null,null,"2023-07-01"]
[null,"2020-08-01",null,null,"2020-08-01",null,null,"2021-02-01",null,null,"2021-02-01",null,null,"2021-08-01",null,null,"2021-08-01",null,null,"2022-02-01",null,null,"2022-02-01",null,null,"2022-08-01",null,null,"2022-08-01",null,null,"2023-02-01",null,null,"2023-02-01",null,null,"2023-08-01"]
[null,"2020-09-01",null,null,"2020-09-01",null,null,"2021-03-01",null,null,"2021-03-01",null,null,"2021-09-01",null,null,"2021-09-01",null,null,"2022-03-01",null,null,"2022-03-01",null,null,"2022-09-01",null,null,"2022-09-01",null,null,"2023-03-01",null,null,"2023-03-01",null,null,"2023-09-01"]
[null,null,null,null,"2020-10-01",null,null,null,null,null,"2021-04-01",null,null,null,null,null,"2021-10-01",null,null,null,null,null,"2022-04-01",null,null,null,null,null,"2022-10-01",null,null,null,null,null,"2023-04-01"]
[null,null,null,null,"2020-11-01",null,null,null,null,null,"2021-05-01",null,null,null,null,null,"2021-11-01",null,null,null,null,null,"2022-05-01",null,null,null,null,null,"2022-11-01",null,null,null,null,null,"2023-05-01"]
[null,null,null,null,"2020-12-01",null,null,null,null,null,"2021-06-01",null,null,null,null,null,"2021-12-01",null,null,null,null,null,"2022-06-01",null,null,null,null,null,"2022-12-01",null,null,null,null,null,"2023-06-01"]
[null,null,null,null,"2021-01-01",null,null,null,null,null,"2021-07-01",null,null,null,null,null,"2022-01-01",null,null,null,null,null,"2022-07-01",null,null,null,null,null,"2023-01-01",null,null,null,null,null,"2023-07-01"]
[null,null,null,null,"2021-02-01",null,null,null,null,null,"2021-08-01",null,null,null,null,null,"2022-02-01",null,null,null,null,null,"2022-08-01",null,null,null,null,null,"2023-02-01",null,null,null,null,null,"2023-08-01"]
[null,null,null,null,"2021-03-01",null,null,null,null,null,"2021-09-01",null,null,null,null,null,"2022-03-01",null,null,null,null,null,"2022-09-01",null,null,null,null,null,"2023-03-01",null,null,null,null,null,"2023-09-01"]
[]
[]
["Today:",{"$f":"TODAY()","v":"2018-08-16"},{"$f":"CONCATENATE(LEFT(TEXT(B39, \"mmmm\"),3), \"-\", RIGHT(TEXT(B39, \"yyyy\"),2))","v":"Aug-18"}]
[null,null,{"$f":"IF(DAY(B39)<7, HLOOKUP(C39,A1:AL2,2,FALSE), HLOOKUP(C39,A1:AL2,2,FALSE) +1)","v":105}]

{"sheet":"Drop down boxes","index":3,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"Today's date",null,"Start dates","End dates",null,null,"TO connection",null,"Gas",null,"DSF: Load response"]
["TODAY:",{"$f":"TODAY()","v":"2018-08-16"},null,{"$f":"IF(DAY(B2)<7,EOMONTH(B2, 0),EOMONTH(B2,1))","v":"2018-09-30"},{"$f":"IF(DAY(B2)<7, EOMONTH(B2,1), EOMONTH(B2,2))","v":"2018-10-31"},null,null,"DNO connection",null,"Hydro",null,"DSF: Distributed generation (onsite)",null,2300,2300]
[null,null,null,{"$f":"IF(DAY(B2)<7, EOMONTH(B2,0)+1, EOMONTH(B2,1)+1)","v":"2018-10-01"},null,null,null,null,null,"Diesel",null,"DSF: Storage (onsite)",null,300]
[null,null,null,null,null,null,null,null,null,"Bio Fuel",null,"DSF: Distributed generation (for export)",null,700]
[null,null,null,null,null,null,null,null,null,"Coal",null,"DSF: Storage (for export)",null,1100]
[null,null,null,null,null,null,null,null,null,"Wind",null,"Multiple Fuel Type",null,1500]
[null,null,null,null,null,null,null,null,null,"Solar",null,null,null,1900]
[null,null,null,null,null,null,null,null,null,"Battery"]
[null,null,null,null,null,null,null,null,null,"Interconnector"]
[null,null,null,null,null,null,null,null,null,"Dual Fuel"]
[null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF($D$7=\"TO connection\",'Drop down boxes'!$J$1:$J$11,IF($D$7=\"DNO connection\",'Drop down boxes'!$L$1:$L$6,\"\"))","v":""}]