{"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":10,"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":63,"n_cols":42,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,24,4,24],[2,0,4,0],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,1,4,1],[2,2,4,2],[3,22,4,22],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[3,20,4,20],[3,21,4,21],[2,41,4,41],[3,25,4,25],[3,26,4,26],[3,27,4,27],[3,28,4,28],[2,36,4,36],[2,37,4,37],[2,38,4,38],[55,0,62,0],[55,3,55,6],[56,1,59,1],[56,2,59,3],[3,23,4,23]]}
["Indication of FFR results for tender round 103, 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)"]
[103,null,null,"Example Company","Ex-FFR-1","TO connection","Wind",{"$f":"'Drop down boxes'!D3","v":"2018-09-01"},{"$f":"'Drop down boxes'!E2","v":"2018-09-30"},{"$f":"TEXT(H6,\"DD.MM.YY\")&\" - \"&TEXT(I6,\"DD.MM.YY\")&\" (\"&DATEDIF(H6,I6+1,\"m\")&\" months)\"","v":"01.09.18 - 30.09.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":103},null,null,"Example Company",{"$f":"E6","v":"Ex-FFR-1"},"DNO connection","Gas",{"$f":"H6","v":"2018-09-01"},{"$f":"I6","v":"2018-09-30"},{"$f":"TEXT(H7,\"DD.MM.YY\")&\" - \"&TEXT(I7,\"DD.MM.YY\")&\" (\"&DATEDIF(H7,I7+1,\"m\")&\" months)\"","v":"01.09.18 - 30.09.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":103.001},"Rejected",3,"BESS HoldCo 3 Ltd","DBESS-33","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,1500,{"$f":"IF(L8>M8, (2400-L8+M8)/100, IF(L8=M8, 24, (M8-L8)/100))","v":16},2300,1500,{"$f":"IF(O8>P8, (2400-O8+P8)/100, IF(O8=P8, 24, (P8-O8)/100))","v":16},2300,1500,{"$f":"IF(R8>S8, (2400-R8+S8)/100, IF(R8=S8, 24, (S8-R8)/100))","v":16},{"$f":"9*MAX(AD8:AJ8)","v":261},null,null,null,null,null,null,null,null,12,29,29,12,12,12,29,null,null,"A",null,null,"all or nothing A or B"]
[{"$f":"A8+0.001","v":103.00200000000001},"Rejected",3,"BESS HoldCo 3 Ltd","DBESS-33","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,{"$f":"IF(L9>M9, (2400-L9+M9)/100, IF(L9=M9, 24, (M9-L9)/100))","v":24},2300,2300,{"$f":"IF(O9>P9, (2400-O9+P9)/100, IF(O9=P9, 24, (P9-O9)/100))","v":24},2300,2300,{"$f":"IF(R9>S9, (2400-R9+S9)/100, IF(R9=S9, 24, (S9-R9)/100))","v":24},{"$f":"9*MAX(AD9:AJ9)","v":261},null,null,null,null,null,null,null,null,12,29,29,12,12,12,29,null,null,"B",null,null,"all or nothing A or B"]
[{"$f":"A9+0.001","v":103.00300000000001},"Rejected",1.3,"Energy Pool","EPFFR-1","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,{"$f":"IF(L10>M10, (2400-L10+M10)/100, IF(L10=M10, 24, (M10-L10)/100))","v":24},2300,2300,{"$f":"IF(O10>P10, (2400-O10+P10)/100, IF(O10=P10, 24, (P10-O10)/100))","v":24},2300,2300,{"$f":"IF(R10>S10, (2400-R10+S10)/100, IF(R10=S10, 24, (S10-R10)/100))","v":24},9.82,0,"-","-","-","-","-","-","-",0.4,1,1,0.4,1,0.4,1,"-","-","A","-","-","Mutrally exclusive of B. High 30mins only"]
[103.00400000000002,"Rejected",1.3,"Energy Pool","EPFFR-1","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L11>M11, (2400-L11+M11)/100, IF(L11=M11, 24, (M11-L11)/100))","v":8},2300,700,{"$f":"IF(O11>P11, (2400-O11+P11)/100, IF(O11=P11, 24, (P11-O11)/100))","v":8},2300,700,{"$f":"IF(R11>S11, (2400-R11+S11)/100, IF(R11=S11, 24, (S11-R11)/100))","v":8},4.95,0,"-","-","-","-","-","-","-",0.4,1,1,0.4,1,"-","-","-","-","B","-","-","Mutrally exclusive of A"]
[103.00500000000002,"Accepted","N/A","REstore Flexpond UK Ltd.","REST-1","DNO connection","Multiple Fuel Type","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L12>M12, (2400-L12+M12)/100, IF(L12=M12, 24, (M12-L12)/100))","v":16},700,2300,{"$f":"IF(O12>P12, (2400-O12+P12)/100, IF(O12=P12, 24, (P12-O12)/100))","v":16},700,2300,{"$f":"IF(R12>S12, (2400-R12+S12)/100, IF(R12=S12, 24, (S12-R12)/100))","v":16},30.36,"-","-","-","-","-","-","-","-",1.6,4,4,1.6,4,1.6,4,"NO","-","-","-","-","-"]
[103.00600000000003,"Rejected",1.3,"REstore Flexpond UK Ltd.","REST-1","DNO connection","Multiple Fuel Type","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L13>M13, (2400-L13+M13)/100, IF(L13=M13, 24, (M13-L13)/100))","v":8},2300,700,{"$f":"IF(O13>P13, (2400-O13+P13)/100, IF(O13=P13, 24, (P13-O13)/100))","v":8},2300,700,{"$f":"IF(R13>S13, (2400-R13+S13)/100, IF(R13=S13, 24, (S13-R13)/100))","v":8},9.49,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,0.4,1,"YES",102252,"-","-","-","-"]
[103.00700000000003,"Rejected",1.3,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L14>M14, (2400-L14+M14)/100, IF(L14=M14, 24, (M14-L14)/100))","v":8},2300,700,{"$f":"IF(O14>P14, (2400-O14+P14)/100, IF(O14=P14, 24, (P14-O14)/100))","v":8},2300,700,{"$f":"IF(R14>S14, (2400-R14+S14)/100, IF(R14=S14, 24, (S14-R14)/100))","v":8},1115,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. "]
[103.00800000000004,"Rejected",2,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L15>M15, (2400-L15+M15)/100, IF(L15=M15, 24, (M15-L15)/100))","v":16},700,2300,{"$f":"IF(O15>P15, (2400-O15+P15)/100, IF(O15=P15, 24, (P15-O15)/100))","v":16},700,2300,{"$f":"IF(R15>S15, (2400-R15+S15)/100, IF(R15=S15, 24, (S15-R15)/100))","v":16},1115,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. "]
[103.00900000000004,"Rejected",2,"ScottishPower","T_DAMC-1","TO connection","Gas","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,3030,0,null,null,"Yes",550,550,760,467,60,92,92,80,126,60,140,null,null,"B",null,null," Either A or B. "]
[103.01000000000005,"Rejected",1.1000000000000001,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L17>M17, (2400-L17+M17)/100, IF(L17=M17, 24, (M17-L17)/100))","v":8},2300,700,{"$f":"IF(O17>P17, (2400-O17+P17)/100, IF(O17=P17, 24, (P17-O17)/100))","v":8},2300,700,{"$f":"IF(R17>S17, (2400-R17+S17)/100, IF(R17=S17, 24, (S17-R17)/100))","v":8},36,"-","-","-","-","-","-","-","-",0.8,2,2,0.8,2,2.4000000000000004,6,"-","-","A","-","-"]
[{"$f":"A17+0.001","v":103.01100000000005},"Rejected",1.1000000000000001,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,1500,{"$f":"IF(L18>M18, (2400-L18+M18)/100, IF(L18=M18, 24, (M18-L18)/100))","v":8},700,2300,{"$f":"IF(O18>P18, (2400-O18+P18)/100, IF(O18=P18, 24, (P18-O18)/100))","v":16},700,2300,{"$f":"IF(R18>S18, (2400-R18+S18)/100, IF(R18=S18, 24, (S18-R18)/100))","v":16},20.5,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,2.4000000000000004,6,"-","-","A"]
[103.01200000000006,"Rejected",1.1000000000000001,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",1500,1900,4,null,null,24,null,null,24,11.5,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,1.2000000000000002,3,"-","-","A"]
[103.01300000000006,"Rejected",1.1000000000000001,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",1900,2300,4,null,null,24,null,null,24,20.5,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,2.4000000000000004,6,"-","-","A"]
[103.01400000000007,"Rejected",2,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,12.6,"-","-","-","-","-","-","-","-",0.8,2,2,0.8,2,0,0,"-","-","B"]
[103.01500000000007,"Rejected",1.3,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,2300,16,700,2300,16,28.700000000000003,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,2.4000000000000004,6,"-","-","B"]
[103.01600000000008,"Rejected",1.3,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",1500,1900,4,null,null,24,null,null,24,16.100000000000001,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,1.2000000000000002,3,"-","-","B"]
[103.01700000000008,"Rejected",1.3,"Open Energi Ltd","OPEN-1","DNO connection","DSF: Load response ","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",1900,2300,4,null,null,24,null,null,24,28.700000000000003,"-","-","-","-","-","-","-","-",0.4,1,1,0.4,1,2.4000000000000004,6,"-","-","B"]
[103.01800000000009,"Rejected",1.3,"Limejump Ltd","LJDYN-6","DNO connection","Battery","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L25>M25, (2400-L25+M25)/100, IF(L25=M25, 24, (M25-L25)/100))","v":16},700,2300,{"$f":"IF(O25>P25, (2400-O25+P25)/100, IF(O25=P25, 24, (P25-O25)/100))","v":16},700,2300,{"$f":"IF(R25>S25, (2400-R25+S25)/100, IF(R25=S25, 24, (S25-R25)/100))","v":16},240,0,null,null,null,null,null,null,null,8,20,20,8,20,8,20]
[103.01900000000009,"Accepted","N/A","Limejump Virtual 9","LJDYW-1","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L26>M26, (2400-L26+M26)/100, IF(L26=M26, 24, (M26-L26)/100))","v":8},2300,700,{"$f":"IF(O26>P26, (2400-O26+P26)/100, IF(O26=P26, 24, (P26-O26)/100))","v":8},2300,700,{"$f":"IF(R26>S26, (2400-R26+S26)/100, IF(R26=S26, 24, (S26-R26)/100))","v":8},35,0,null,null,null,null,null,null,null,2.8,7,7,2.8,7,2.8,7,null,null,null,null,null,"Only one of 103.002, 103.003"]
[103.0200000000001,"Rejected",1.3,"Limejump Virtual 9","LJDYW-1","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,1500,16,2300,1500,16,2300,1500,16,84,0,null,null,null,null,null,null,null,2.8,7,7,2.8,7,2.8,7,null,null,null,null,null,"Only one of 103.002, 103.003"]
[103.0210000000001,"Accepted","N/A","Limejump Ltd","LJDYN-3","DNO connection","Battery","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,1500,8,700,1500,8,700,1500,8,28,0,null,null,null,null,null,null,null,1.6,4,4,1.6,4,1.6,4]
[103.02200000000011,"Accepted","N/A","Limejump Ltd","LJDYN-3","DNO connection","Battery","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",1500,2300,8,1500,2300,8,1500,2300,8,24,0,null,null,null,null,null,null,null,1.6,4,4,1.6,4,1.6,4]
[103.02300000000011,"Rejected",1.3,"Limejump Ltd","LJDYN-5","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,120,0,null,null,null,null,null,null,null,4,10,10,4,10,4,10]
[103.02400000000011,"Rejected",1.3,"Limejump Ltd","LJDYP-4","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,1500,16,2300,1500,16,2300,1500,16,125,0,null,null,null,null,null,null,null,4,10,10,4,10,4,10,null,null,null,null,null,"Only one of 103.009, 103.010"]
[103.02500000000012,"Rejected",1.3,"Limejump Ltd","LJDYP-4","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,125,0,null,null,null,null,null,null,null,4,10,10,4,10,4,10,null,null,null,null,null,"Only one of 103.009, 103.010"]
[103.02600000000012,"Rejected",4,"Limejump Ltd","LJDYP-2","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,1500,16,2300,1500,16,2300,1500,16,140,0,null,null,null,null,null,null,null,8,20,20,8,20,8,20,null,null,null,null,null,"Only one of 103.011, 103.012"]
[{"$f":"A33+0.001","v":103.02700000000013},"Accepted","N/A","Limejump Ltd","LJDYP-2","DNO connection","Battery","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,140,0,null,null,null,null,null,null,null,8,20,20,8,20,8,20,null,null,null,null,null,"Only one of 103.011, 103.012"]
[{"$f":"A34+0.001","v":103.02800000000013},"Rejected",3,"Noriker Unity","NKPU-5","DNO connection","hybrid","2018-07-31","2018-08-31","31.07.18 - 31.08.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]
[{"$f":"A34+0.002","v":103.02900000000012},"Rejected",1.3,"KiWi Power Ltd","KIWIS-1","DNO connection","Multiple Fuel Type","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L36>M36, (2400-L36+M36)/100, IF(L36=M36, 24, (M36-L36)/100))","v":8},2300,700,{"$f":"IF(O36>P36, (2400-O36+P36)/100, IF(O36=P36, 24, (P36-O36)/100))","v":8},2300,700,{"$f":"IF(R36>S36, (2400-R36+S36)/100, IF(R36=S36, 24, (S36-R36)/100))","v":8},12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,8]
[103.03000000000013,"Rejected",1.3,"KiWi Power Ltd","KIWIS-1","DNO connection","Multiple Fuel Type","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L37>M37, (2400-L37+M37)/100, IF(L37=M37, 24, (M37-L37)/100))","v":16},700,2300,{"$f":"IF(O37>P37, (2400-O37+P37)/100, IF(O37=P37, 24, (P37-O37)/100))","v":16},700,2300,{"$f":"IF(R37>S37, (2400-R37+S37)/100, IF(R37=S37, 24, (S37-R37)/100))","v":16},14.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,8]
[103.03100000000013,"Rejected",1.1000000000000001,"REstore Flexpond UK Ltd.","RESTFFR-1","DNO connection","DSF: Load response","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,8,2300,700,8,2300,700,8,58,"-","-","-","-","-","-","-","-",0,35,35,0,45,0,0,"NO","-","-","-","-","-"]
[103.03200000000014,"Accepted","N/A","REstore Flexpond UK Ltd.","RESTFFR-1","DNO connection","DSF: Load response","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,85,"-","-","-","-","-","-","-","-",0,35,35,0,45,0,0,"NO","-","-","-","-","-"]
[103.03300000000014,"Rejected",1.3,"Limejump Ltd","LJFFR-1","DNO connection","Multiple Fuel Type","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,2300,24,2300,2300,24,2300,2300,24,60,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Only one of 103.007, 103.008"]
[103.03400000000015,"Rejected",1.3,"Limejump Ltd","LJFFR-1","DNO connection","Multiple Fuel Type","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,16,700,2300,16,700,2300,16,60,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Only one of 103.007, 103.008"]
[103.03500000000015,"Rejected",1.3,"PeakGen","PGFFR7","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)",null,700,2300,{"$f":"IF(L42>M42, (2400-L42+M42)/100, IF(L42=M42, 24, (M42-L42)/100))","v":16},700,2300,{"$f":"IF(O42>P42, (2400-O42+P42)/100, IF(O42=P42, 24, (P42-O42)/100))","v":16},700,2300,{"$f":"IF(R42>S42, (2400-R42+S42)/100, IF(R42=S42, 24, (S42-R42)/100))","v":16},34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[103.03600000000016,"Rejected",1.3,"PeakGen","PGFFR8","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)",null,700,2300,{"$f":"IF(L43>M43, (2400-L43+M43)/100, IF(L43=M43, 24, (M43-L43)/100))","v":16},700,2300,{"$f":"IF(O43>P43, (2400-O43+P43)/100, IF(O43=P43, 24, (P43-O43)/100))","v":16},700,2300,{"$f":"IF(R43>S43, (2400-R43+S43)/100, IF(R43=S43, 24, (S43-R43)/100))","v":16},41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[103.03700000000016,"Rejected",1.1000000000000001,"PeakGen","PGFFR4","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)",null,700,2300,16,700,2300,16,700,2300,16,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[103.03800000000017,"Accepted","N/A","PeakGen","PGFFR5","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)",null,700,2300,16,700,2300,16,700,2300,16,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[103.03900000000017,"Accepted","N/A","PeakGen","PGFFR9","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)",null,700,2300,16,700,2300,16,700,2300,16,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[103.04000000000018,"Rejected",1.3,"PeakGen","PGFFR7","DNO connection","Diesel","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)",null,2300,700,8,2300,700,8,2300,700,8,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[103.04100000000018,"Accepted","N/A","PeakGen","PGFFR8","DNO connection","Diesel","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)",null,2300,700,8,2300,700,8,2300,700,8,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[103.04200000000019,"Rejected",1.3,"NG1 Power Limited","NG1FFR-1","DNO connection","Diesel","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L49>M49, (2400-L49+M49)/100, IF(L49=M49, 24, (M49-L49)/100))","v":8},2300,700,{"$f":"IF(O49>P49, (2400-O49+P49)/100, IF(O49=P49, 24, (P49-O49)/100))","v":8},2300,700,{"$f":"IF(R49>S49, (2400-R49+S49)/100, IF(R49=S49, 24, (S49-R49)/100))","v":8},26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[103.04300000000019,"Accepted","N/A","NG1 Power Limited","NG1FFR-1","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L50>M50, (2400-L50+M50)/100, IF(L50=M50, 24, (M50-L50)/100))","v":16},700,2300,{"$f":"IF(O50>P50, (2400-O50+P50)/100, IF(O50=P50, 24, (P50-O50)/100))","v":16},700,2300,{"$f":"IF(R50>S50, (2400-R50+S50)/100, IF(R50=S50, 24, (S50-R50)/100))","v":16},37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[103.0440000000002,"Rejected",1.3,"Buxton Power Limited","BPLFFR-1","DNO connection","Diesel","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L51>M51, (2400-L51+M51)/100, IF(L51=M51, 24, (M51-L51)/100))","v":8},2300,700,{"$f":"IF(O51>P51, (2400-O51+P51)/100, IF(O51=P51, 24, (P51-O51)/100))","v":8},2300,700,{"$f":"IF(R51>S51, (2400-R51+S51)/100, IF(R51=S51, 24, (S51-R51)/100))","v":8},21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16]
[103.0450000000002,"Accepted","N/A","Buxton Power Limited","BPLFFR-1","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L52>M52, (2400-L52+M52)/100, IF(L52=M52, 24, (M52-L52)/100))","v":16},700,2300,{"$f":"IF(O52>P52, (2400-O52+P52)/100, IF(O52=P52, 24, (P52-O52)/100))","v":16},700,2300,{"$f":"IF(R52>S52, (2400-R52+S52)/100, IF(R52=S52, 24, (S52-R52)/100))","v":16},30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,16]
[103.04600000000021,"Accepted","N/A","Waterswallows Power Limited","WPLFFR-1","DNO connection","Diesel","2018-07-31","2018-08-31","31.07.18 - 31.08.18 (1 months)","As per FFR framework agreement ",2300,700,{"$f":"IF(L53>M53, (2400-L53+M53)/100, IF(L53=M53, 24, (M53-L53)/100))","v":8},2300,700,{"$f":"IF(O53>P53, (2400-O53+P53)/100, IF(O53=P53, 24, (P53-O53)/100))","v":8},2300,700,{"$f":"IF(R53>S53, (2400-R53+S53)/100, IF(R53=S53, 24, (S53-R53)/100))","v":8},18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,14]
[103.04700000000021,"Accepted","N/A","Waterswallows Power Limited","WPLFFR-1","DNO connection","Diesel","2018-08-01","2018-08-31","01.08.18 - 31.08.18 (1 months)","As per FFR framework agreement ",700,2300,{"$f":"IF(L54>M54, (2400-L54+M54)/100, IF(L54=M54, 24, (M54-L54)/100))","v":16},700,2300,{"$f":"IF(O54>P54, (2400-O54+P54)/100, IF(O54=P54, 24, (P54-O54)/100))","v":16},700,2300,{"$f":"IF(R54>S54, (2400-R54+S54)/100, IF(R54=S54, 24, (S54-R54)/100))","v":16},26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,14]
[]
["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":false,"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-07-17"},{"$f":"CONCATENATE(LEFT(TEXT(B39, \"mmmm\"),3), \"-\", RIGHT(TEXT(B39, \"yyyy\"),2))","v":"Jul-18"}]
[null,null,{"$f":"IF(DAY(B39)<7, HLOOKUP(C39,A1:AL2,2,FALSE), HLOOKUP(C39,A1:AL2,2,FALSE) +1)","v":104}]

{"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-07-17"},null,{"$f":"IF(DAY(B2)<7,EOMONTH(B2, 0),EOMONTH(B2,1))","v":"2018-08-31"},{"$f":"IF(DAY(B2)<7, EOMONTH(B2,1), EOMONTH(B2,2))","v":"2018-09-30"},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-09-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":""}]