{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Kalender","Data","Misc"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Kalender","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Laatste update:","2017-05-13T19:50:24","(Klik voor extra uitleg)",null,null,null,"© 2004-2017 - http://www.wimgielis.be"]
[null,{"$f":"\"U hebt gekozen voor een kalender \"&IF(Misc!D24>0,\"met in totaal \"&Misc!D24&\" categorieën van \"&Misc!D25&\" ploegen. \",\"zonder categorieën. \")&IF(Misc!D24>0,IF(Misc!F24>0,\"In de database werden \" & Misc!$F$24&\" items gevonden.\",\" De database bevat geen items voor jouw categorieën en datums.\"),\"De laatste juist gekozen kalender wordt opnieuw getoond.\")","v":"U hebt gekozen voor een kalender met in totaal 21 categorieën van 7 ploegen. In de database werden 7 items gevonden."}]
["dag","datum","uur","samen","thuisploeg","uitploeg","stand","ploeg","activiteit","voorbij?"]
["2017-04-27","2017-04-27","20:30:00",null,"Union","Lierse","1-3","Lierse","competitie","ja"]
["2017-05-01","2017-05-01",null,null,"Lierse","KV Mechelen","0-0","Lierse","competitie","ja"]
["2017-05-06","2017-05-06","20:00:00",null,"Lierse","Union","2-1","Lierse","competitie","ja"]
["2017-05-13","2017-05-13",null,null,"Waasland-Beveren","Lierse",null,"Lierse","competitie","ja"]
["2017-05-16","2017-05-16",null,null,"Lierse","Sint-Truiden",null,"Lierse","competitie"]
["2017-05-19","2017-05-19",null,null,"Standard","Lierse",null,"Lierse","competitie"]
["2017-06-09","2017-06-09","20:45:00",null,"Estland","België",null,"Rode Duivels","competitie"]

{"sheet":"Data","index":1,"n_rows":149,"n_cols":9,"rows_kept":149,"cut":false,"hidden":false,"merged":[]}
["dag","datum","uur","samen","thuisploeg","uitploeg","stand","ploeg","activiteit"]
[{"$f":"B2","v":"2016-07-14"},"2016-07-14","20:00:00",null,"Racing Genk","Buducnost Podgorica","2-0","Europees","competitie"]
[{"$f":"B3","v":"2016-07-21"},"2016-07-21","20:45:00",null,"Buducnost Podgorica","Racing Genk","2-0","Europees","competitie"]
[{"$f":"B4","v":"2016-07-28"},"2016-07-28","20:00:00",null,"Racing Genk","Cork City","1-0","Europees","competitie"]
[{"$f":"B5","v":"2016-07-28"},"2016-07-28","20:30:00",null,"AA Gent","FC Viitorul Constanta","5-0","Europees","competitie"]
[{"$f":"B6","v":"2016-08-04"},"2016-08-04","20:15:00",null,"FC Viitorul Constanta","AA Gent","0-0","Europees","competitie"]
[{"$f":"B7","v":"2016-08-04"},"2016-08-04","20:45:00",null,"Cork City","Racing Genk","1-2","Europees","competitie"]
[{"$f":"B8","v":"2016-08-05"},"2016-08-05","20:30:00",null,"Roeselare","Lierse","2-2","Lierse","competitie"]
[{"$f":"B9","v":"2016-08-14"},"2016-08-14","12:30:00",null,"Lierse","Cercle Brugge","2-0","Lierse","competitie"]
[{"$f":"B10","v":"2016-08-18"},"2016-08-18","19:00:00",null,"Slavia Praag","Anderlecht","0-3","Europees","competitie"]
[{"$f":"B11","v":"2016-08-18"},"2016-08-18","20:00:00",null,"Lokomotiva Zagreb","Racing Genk","2-2","Europees","competitie"]
[{"$f":"B12","v":"2016-08-18"},"2016-08-18","20:30:00",null,"AA Gent","KF Shkëndija","2-1","Europees","competitie"]
[{"$f":"B13","v":"2016-08-21"},"2016-08-21","12:30:00",null,"Union","Lierse","2-2","Lierse","competitie"]
[{"$f":"B14","v":"2016-08-25"},"2016-08-25","20:00:00",null,"Anderlecht","Slavia Praag","3-0","Europees","competitie"]
[{"$f":"B15","v":"2016-08-25"},"2016-08-25","20:00:00",null,"KF Shkëndija","AA Gent","0-4","Europees","competitie"]
[{"$f":"B16","v":"2016-08-25"},"2016-08-25","20:00:00",null,"Racing Genk","Lokomotiva Zagreb","2-0","Europees","competitie"]
[{"$f":"B17","v":"2016-08-27"},"2016-08-27","20:00:00",null,"Waremme","Lierse","2-8","Lierse","beker"]
[{"$f":"B18","v":"2016-09-01"},"2016-09-01","20:45:00",null,"België","Spanje","0-2","Rode Duivels","oefenmatch"]
[{"$f":"B19","v":"2016-09-02"},"2016-09-02","20:30:00",null,"Lierse","OH Leuven","2-2","Lierse","competitie"]
[{"$f":"B20","v":"2016-09-04"},"2016-09-04","14:30:00","13:50:00","Lucyvo","Wavria","4-2","Lucyvo","beker"]
[{"$f":"B21","v":"2016-09-06"},"2016-09-06","20:45:00",null,"Cyprus","België","0-3","Rode Duivels","competitie"]
[{"$f":"B22","v":"2016-09-09"},"2016-09-09","20:30:00",null,"Antwerp","Lierse","1-2","Lierse","competitie"]
[{"$f":"B23","v":"2016-09-11"},"2016-09-11","14:30:00","13:50:00","Lucyvo","Team Pouvri","1-6","Lucyvo","competitie"]
[{"$f":"B24","v":"2016-09-14"},"2016-09-14","20:45:00",null,"Club Brugge","Leicester City","0-3","Europees","competitie"]
[{"$f":"B25","v":"2016-09-15"},"2016-09-15","19:00:00",null,"Anderlecht","FK Qabala","3-1","Europees","competitie"]
[{"$f":"B26","v":"2016-09-15"},"2016-09-15","19:00:00",null,"Rapid Wien","Racing Genk","3-2","Europees","competitie"]
[{"$f":"B27","v":"2016-09-15"},"2016-09-15","21:05:00",null,"Sporting Braga","AA Gent","1-1","Europees","competitie"]
[{"$f":"B28","v":"2016-09-15"},"2016-09-15","21:05:00",null,"Standard","Celta de Vigo","1-1","Europees","competitie"]
[{"$f":"B29","v":"2016-09-17"},"2016-09-17","20:00:00",null,"Lierse","Tubeke","5-1","Lierse","competitie"]
[{"$f":"B30","v":"2016-09-18"},"2016-09-18","14:30:00",null,"El Condor","Lucyvo","3-0","Lucyvo","competitie"]
[{"$f":"B31","v":"2016-09-21"},"2016-09-21","20:30:00",null,"Lierse","AA Gent","1-2","Lierse","beker"]
[{"$f":"B32","v":"2016-09-23"},"2016-09-23","20:00:00","19:45:00","Bots","Jets","4-6","BOTS","competitie"]
[{"$f":"B33","v":"2016-09-25"},"2016-09-25","16:00:00",null,"Lommel United","Lierse","0-3","Lierse","competitie"]
[{"$f":"B34","v":"2016-09-27"},"2016-09-27","20:45:00",null,"FC Kopenhagen","Club Brugge","4-0","Europees","competitie"]
[{"$f":"B35","v":"2016-09-29"},"2016-09-29","19:00:00",null,"AA Gent","Atiker Konyaspor","2-0","Europees","competitie"]
[{"$f":"B36","v":"2016-09-29"},"2016-09-29","19:00:00",null,"Ajax","Standard","1-0","Europees","competitie"]
[{"$f":"B37","v":"2016-09-29"},"2016-09-29","21:05:00",null,"Racing Genk","Sassuolo","3-1","Europees","competitie"]
[{"$f":"B38","v":"2016-09-29"},"2016-09-29","21:05:00",null,"Saint-Etienne","Anderlecht","1-1","Europees","competitie"]
[{"$f":"B39","v":"2016-10-02"},"2016-10-02","12:30:00",null,"Lierse","Roeselare","0-2","Lierse","competitie"]
[{"$f":"B40","v":"2016-10-02"},"2016-10-02","12:30:00",null,"Nieuw Polonia","Lucyvo","5-0","Lucyvo","competitie"]
[{"$f":"B41","v":"2016-10-05"},"2016-10-05","21:00:00","20:45:00","Bots","Zimmer","4-5","BOTS","competitie"]
[{"$f":"B42","v":"2016-10-06"},"2016-10-06","20:30:00",null,"Cercle Brugge","Lierse","0-0","Lierse","competitie"]
[{"$f":"B43","v":"2016-10-07"},"2016-10-07","20:45:00",null,"België","Bosnië-Herzegovina","4-0","Rode Duivels","competitie"]
[{"$f":"B44","v":"2016-10-09"},"2016-10-09","14:30:00","13:50:00","Lucyvo","t Hoekske","4-2","Lucyvo","competitie"]
[{"$f":"B45","v":"2016-10-09"},"2016-10-09","20:00:00",null,"Lierse","Antwerp","2-0","Lierse","competitie"]
[{"$f":"B46","v":"2016-10-10"},"2016-10-10","20:45:00",null,"Gibraltar","België","0-6","Rode Duivels","competitie"]
[{"$f":"B47","v":"2016-10-14"},"2016-10-14","19:00:00","18:45:00","Bots","De Ronde Tafel","2-5","BOTS","competitie"]
[{"$f":"B48","v":"2016-10-15"},"2016-10-15","20:00:00",null,"Lierse","Union","2-1","Lierse","competitie"]
[{"$f":"B49","v":"2016-10-16"},"2016-10-16","14:30:00",null,"De Duif","Lucyvo","2-5","Lucyvo","competitie"]
[{"$f":"B50","v":"2016-10-18"},"2016-10-18","20:45:00",null,"Club Brugge","FC Porto","1-1","Europees","competitie"]
[{"$f":"B51","v":"2016-10-19"},"2016-10-19","21:00:00",null,"Le Future","Bots","0-2","BOTS","competitie"]
[{"$f":"B52","v":"2016-10-20"},"2016-10-20","19:00:00",null,"Shakhtar Donetsk","AA Gent","5-0","Europees","competitie"]
[{"$f":"B53","v":"2016-10-20"},"2016-10-20","19:00:00",null,"Standard","Panathinaikos","2-2","Europees","competitie"]
[{"$f":"B54","v":"2016-10-20"},"2016-10-20","21:05:00",null,"1. FSV Mainz 05","Anderlecht","1-1","Europees","competitie"]
[{"$f":"B55","v":"2016-10-20"},"2016-10-20","21:05:00",null,"Racing Genk","Athletic Club","2-0","Europees","competitie"]
[{"$f":"B56","v":"2016-10-21"},"2016-10-21","20:30:00",null,"Tubeke","Lierse","1-3","Lierse","competitie"]
["2015-08-16","2016-10-23","14:30:00","13:50:00","Lucyvo","Goka","0-4","Lucyvo","competitie"]
[{"$f":"B58","v":"2016-10-28"},"2016-10-28","21:00:00",null,"Bots","Figaro Boys","5-5","BOTS","competitie"]
[{"$f":"B59","v":"2016-10-30"},"2016-10-30","14:00:00",null,"Team Pouvri","Lucyvo","5-1","Lucyvo","beker"]
[{"$f":"B60","v":"2016-10-30"},"2016-10-30","16:00:00",null,"Lierse","Lommel United","0-2","Lierse","competitie"]
[{"$f":"B61","v":"2016-11-02"},"2016-11-02","20:45:00",null,"FC Porto","Club Brugge","1-0","Europees","competitie"]
[{"$f":"B62","v":"2016-11-03"},"2016-11-03","19:00:00",null,"Anderlecht","1. FSV Mainz 05","6-1","Europees","competitie"]
[{"$f":"B63","v":"2016-11-03"},"2016-11-03","19:00:00",null,"Athletic Club","Racing Genk","5-3","Europees","competitie"]
[{"$f":"B64","v":"2016-11-03"},"2016-11-03","21:05:00",null,"AA Gent","Shakhtar Donetsk","3-5","Europees","competitie"]
[{"$f":"B65","v":"2016-11-03"},"2016-11-03","21:05:00",null,"Panathinaikos","Standard","0-3","Europees","competitie"]
[{"$f":"B66","v":"2016-11-06"},"2016-11-06","14:30:00","13:50:00","Lucyvo","De Knuddeboys","3-1","Lucyvo","competitie"]
[{"$f":"B67","v":"2016-11-06"},"2016-11-06","16:00:00",null,"OH Leuven","Lierse","0-1","Lierse","competitie"]
[{"$f":"B68","v":"2016-11-09"},"2016-11-09","20:45:00",null,"Nederland","België","1-1","Rode Duivels","oefenmatch"]
[{"$f":"B69","v":"2016-11-11"},"2016-11-11","20:30:00",null,"Lierse","Union","1-0","Lierse","competitie"]
[{"$f":"B70","v":"2016-11-13"},"2016-11-13","14:30:00",null,"H.T.H.","Lucyvo","8-0","Lucyvo","competitie"]
[{"$f":"B71","v":"2016-11-13"},"2016-11-13","20:45:00",null,"België","Estland","8-1","Rode Duivels","competitie"]
[{"$f":"B72","v":"2016-11-20"},"2016-11-20","12:30:00",null,"Tubeke","Lierse","0-3","Lierse","competitie"]
[{"$f":"B73","v":"2016-11-21"},"2016-11-21","22:30:00",null,"Bots","Oud Lier","4-4","BOTS","competitie"]
[{"$f":"B74","v":"2016-11-22"},"2016-11-22","20:45:00",null,"Leicester City","Club Brugge","2-1","Europees","competitie"]
[{"$f":"B75","v":"2016-11-24"},"2016-11-24","17:00:00",null,"FK Qabala","Anderlecht","1-3","Europees","competitie"]
[{"$f":"B76","v":"2016-11-24"},"2016-11-24","19:00:00",null,"AA Gent","Sporting Braga","2-2","Europees","competitie"]
[{"$f":"B77","v":"2016-11-24"},"2016-11-24","19:00:00",null,"Celta de Vigo","Standard","1-1","Europees","competitie"]
[{"$f":"B78","v":"2016-11-24"},"2016-11-24","21:05:00",null,"Racing Genk","Rapid Wien","1-0","Europees","competitie"]
[{"$f":"B79","v":"2016-11-25"},"2016-11-25","20:30:00",null,"Roeselare","Lierse","2-1","Lierse","competitie"]
[{"$f":"B80","v":"2016-11-27"},"2016-11-27","14:00:00",null,"Sint-Michiel","Lucyvo","5-0","Lucyvo","competitie"]
[{"$f":"B81","v":"2016-12-02"},"2016-12-02","20:30:00",null,"Lierse","Antwerp","2-2","Lierse","competitie"]
[{"$f":"B82","v":"2016-12-04"},"2016-12-04","14:30:00","13:50:00","Lucyvo","H.T.H.","0-5*","Lucyvo","competitie"]
[{"$f":"B83","v":"2016-12-07"},"2016-12-07","20:45:00",null,"Club Brugge","FC Kopenhagen","0-2","Europees","competitie"]
[{"$f":"B84","v":"2016-12-08"},"2016-12-08","19:00:00",null,"Anderlecht","Saint-Etienne","2-3","Europees","competitie"]
[{"$f":"B85","v":"2016-12-08"},"2016-12-08","21:05:00",null,"Atiker Konyaspor","AA Gent","0-1","Europees","competitie"]
[{"$f":"B86","v":"2016-12-08"},"2016-12-08","21:05:00",null,"Standard","Ajax","1-1","Europees","competitie"]
[{"$f":"B87","v":"2016-12-09"},"2016-12-09","12:30:00",null,"Sassuolo","Racing Genk","0-2","Europees","competitie"]
[{"$f":"B88","v":"2016-12-09"},"2016-12-09","21:00:00",null,"Bots","De Kroon","5-1","BOTS","competitie"]
[{"$f":"B89","v":"2016-12-10"},"2016-12-10","17:00:00",null,"Cercle Brugge","Lierse","0-1","Lierse","competitie"]
[{"$f":"B90","v":"2016-12-11"},"2016-12-11","14:30:00","13:50:00","Lucyvo","DWM Lint","0-3","Lucyvo","beker"]
[{"$f":"B91","v":"2016-12-16"},"2016-12-16","20:00:00",null,"Bots","Apollonia","5-6","BOTS","competitie"]
[{"$f":"B92","v":"2016-12-18"},"2016-12-18","11:00:00",null,"De Knuddeboys","Lucyvo","1-0","Lucyvo","competitie"]
[{"$f":"B93","v":"2016-12-18"},"2016-12-18","16:00:00",null,"Lierse","OH Leuven","1-1","Lierse","competitie"]
[{"$f":"B94","v":"2016-12-19"},"2016-12-19","20:00:00",null,"Bots","De Boeliekes","10-1","BOTS","competitie"]
[{"$f":"B95","v":"2017-01-08"},"2017-01-08","18:00:00",null,"Lierse","Lommel United","5-1","Lierse","competitie"]
[{"$f":"B96","v":"2017-01-09"},"2017-01-09","22:30:00",null,"Bots","Pallieters United","6-4","BOTS","competitie"]
[{"$f":"B97","v":"2017-01-13"},"2017-01-13","21:00:00",null,"Bots","Whitecaps","9-1","BOTS","competitie"]
[{"$f":"B98","v":"2017-01-15"},"2017-01-15","18:00:00",null,"Union","Lierse","0-0","Lierse","competitie"]
[{"$f":"B99","v":"2017-01-22"},"2017-01-22","15:00:00",null,"Lierse","Cercle Brugge","1-1","Lierse","competitie"]
[{"$f":"B100","v":"2017-01-23"},"2017-01-23","19:00:00",null,"Bots","ORL United","6-3","BOTS","competitie"]
[{"$f":"B101","v":"2017-01-27"},"2017-01-27","20:00:00",null,"OH Leuven","Lierse","2-3","Lierse","competitie"]
[{"$f":"B102","v":"2017-01-29"},"2017-01-29","14:30:00","13:50:00","Lucyvo","Nieuw Polonia","0-5","Lucyvo","competitie"]
[{"$f":"B103","v":"2017-02-03"},"2017-02-03",null,null,"Bots","Pallieters United","7-5","BOTS","competitie"]
[{"$f":"B104","v":"2017-02-04"},"2017-02-04","20:30:00",null,"Lierse","Tubeke","3-0","Lierse","competitie"]
["2015-09-13","2017-02-05","11:00:00","13:45:00","t Hoekske","Lucyvo","0-2","Lucyvo","competitie"]
[{"$f":"B106","v":"2017-02-11"},"2017-02-11","20:30:00",null,"Antwerp","Lierse","0-2","Lierse","competitie"]
[{"$f":"B107","v":"2017-02-12"},"2017-02-12","14:30:00","13:50:00","Lucyvo","De Duif","3-0","Lucyvo","competitie"]
[{"$f":"B108","v":"2017-02-16"},"2017-02-16","19:00:00",null,"AA Gent","Tottenham","1-0","Europees","competitie"]
[{"$f":"B109","v":"2017-02-16"},"2017-02-16","19:00:00",null,"Astra Giurgiu","Racing Genk","2-2","Europees","competitie"]
[{"$f":"B110","v":"2017-02-16"},"2017-02-16","21:05:00",null,"Anderlecht","Zenit","2-0","Europees","competitie"]
[{"$f":"B111","v":"2017-02-17"},"2017-02-17","20:30:00",null,"Lommel United","Lierse","1-1","Lierse","competitie"]
[{"$f":"B112","v":"2017-02-19"},"2017-02-19","15:00:00",null,"Goka","Lucyvo","0-1","Lucyvo","competitie"]
[{"$f":"B113","v":"2017-02-23"},"2017-02-23","19:00:00",null,"Zenit","Anderlecht","3-1","Europees","competitie"]
[{"$f":"B114","v":"2017-02-23"},"2017-02-23","21:05:00",null,"Racing Genk","Astra Giurgiu","1-0","Europees","competitie"]
[{"$f":"B115","v":"2017-02-23"},"2017-02-23","21:05:00",null,"Tottenham","AA Gent","2-2","Europees","competitie"]
[{"$f":"B116","v":"2017-02-26"},"2017-02-26","11:00:00",null,"Vatanspor","Lucyvo","0-1","Lucyvo","competitie"]
[{"$f":"B117","v":"2017-02-26"},"2017-02-26","16:00:00",null,"Lierse","Roeselare","1-1","Lierse","competitie"]
[{"$f":"B118","v":"2017-03-03"},"2017-03-03","22:00:00",null,"Figaro Boys","Bots","4-7","BOTS","competitie"]
[{"$f":"B119","v":"2017-03-05"},"2017-03-05","11:00:00","10:15:00","Lucyvo","Vatanspor","3-3","Lucyvo","competitie"]
[{"$f":"B120","v":"2017-03-09"},"2017-03-09","19:00:00",null,"Apoel Nicosia","Anderlecht","0-1","Europees","competitie"]
[{"$f":"B121","v":"2017-03-09"},"2017-03-09","21:05:00",null,"AA Gent","Racing Genk","2-5","Europees","competitie"]
[{"$f":"B122","v":"2017-03-12"},"2017-03-12","14:30:00","13:50:00","Lucyvo","Sint-Michiel","3-1","Lucyvo","competitie"]
[{"$f":"B123","v":"2017-03-13"},"2017-03-13","21:30:00",null,"De Kroon","Bots","3-2","BOTS","competitie"]
[{"$f":"B124","v":"2017-03-16"},"2017-03-16","19:00:00",null,"Anderlecht","Apoel Nicosia","1-0","Europees","competitie"]
[{"$f":"B125","v":"2017-03-16"},"2017-03-16","21:05:00",null,"Racing Genk","AA Gent","1-1","Europees","competitie"]
[{"$f":"B126","v":"2017-03-19"},"2017-03-19","14:00:00",null,"Team Pouvri","Lucyvo","6-0","Lucyvo","competitie"]
[{"$f":"B127","v":"2017-03-24"},"2017-03-24",null,null,"Apollonia","Bots","1-4","BOTS","competitie"]
[{"$f":"B128","v":"2017-03-25"},"2017-03-25","20:45:00",null,"België","Griekenland","1-1","Rode Duivels","competitie"]
[{"$f":"B129","v":"2017-03-26"},"2017-03-26","14:30:00","13:50:00","Lucyvo","El Condor","4-3","Lucyvo","competitie"]
[{"$f":"B130","v":"2017-03-28"},"2017-03-28","18:00:00",null,"Rusland","België","3-3","Rode Duivels","oefenmatch"]
[{"$f":"B131","v":"2017-04-02"},"2017-04-02","20:00:00",null,"Lierse","Standard","1-0","Lierse","competitie"]
[{"$f":"B132","v":"2017-04-09"},"2017-04-09","20:00:00",null,"KV Mechelen","Lierse","1-0","Lierse","competitie"]
[{"$f":"B133","v":"2017-04-13"},"2017-04-13","21:05:00",null,"Anderlecht","Manchester United","1-1","Europees","competitie"]
[{"$f":"B134","v":"2017-04-13"},"2017-04-13","21:05:00",null,"Celta de Vigo","Racing Genk","3-2","Europees","competitie"]
[{"$f":"B135","v":"2017-04-15"},"2017-04-15","20:30:00",null,"Sint-Truiden","Lierse","2-1","Lierse","competitie"]
[{"$f":"B136","v":"2017-04-20"},"2017-04-20","20:45:00",null,"Manchester United","Anderlecht","2-1","Europees","competitie"]
[{"$f":"B137","v":"2017-04-20"},"2017-04-20","20:45:00",null,"Racing Genk","Celta de Vigo","1-1","Europees","competitie"]
[{"$f":"B138","v":"2017-04-22"},"2017-04-22","20:00:00",null,"Lierse","Waasland-Beveren","2-3","Lierse","competitie"]
[{"$f":"B139","v":"2017-04-27"},"2017-04-27","20:30:00",null,"Union","Lierse","1-3","Lierse","competitie"]
[{"$f":"B140","v":"2017-05-01"},"2017-05-01",null,null,"Lierse","KV Mechelen","0-0","Lierse","competitie"]
[{"$f":"B141","v":"2017-05-06"},"2017-05-06","20:00:00",null,"Lierse","Union","2-1","Lierse","competitie"]
[{"$f":"B142","v":"2017-05-13"},"2017-05-13",null,null,"Waasland-Beveren","Lierse",null,"Lierse","competitie"]
[{"$f":"B143","v":"2017-05-16"},"2017-05-16",null,null,"Lierse","Sint-Truiden",null,"Lierse","competitie"]
[{"$f":"B144","v":"2017-05-19"},"2017-05-19",null,null,"Standard","Lierse",null,"Lierse","competitie"]
[{"$f":"B145","v":"2017-06-09"},"2017-06-09","20:45:00",null,"Estland","België",null,"Rode Duivels","competitie"]
[{"$f":"B146","v":"2017-08-31"},"2017-08-31","20:45:00",null,"België","Gibraltar",null,"Rode Duivels","competitie"]
[{"$f":"B147","v":"2017-09-03"},"2017-09-03","20:45:00",null,"Griekenland","België",null,"Rode Duivels","competitie"]
[{"$f":"B148","v":"2017-10-07"},"2017-10-07","20:45:00",null,"Bosnië-Herzegovina","België",null,"Rode Duivels","competitie"]
[{"$f":"B149","v":"2017-10-10"},"2017-10-10","20:45:00",null,"België","Cyprus",null,"Rode Duivels","competitie"]

{"sheet":"Misc","index":2,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"ploeg","activiteit",null,null,"binnen range of dates","binnen range of dates","binnen range of dates",null,{"$f":"DCOUNT(Data!$A$1:$I$1,Data!$A$1,$K$1:$N$22)","v":{"$error":"#VALUE!"}},"datum","datum","ploeg","activiteit",null,1,"ja"]
[true,"Lucyvo","competitie",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Lucyvo\")*$A$2:$A$22)","v":5},{"$f":"SUMPRODUCT((DBPloegen=B2)*(DBCategorien=C2))","v":20},{"$f":"SUMPRODUCT((DBPloegen=B2)*(DBCategorien=C2)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F2:F6)=1,\"t\",\"en\")&\" er \"&IF(SUM(F2:F6)=0,\"geen\",SUM(F2:F6))&\" item\"&IF(SUM(F2:F6)=1,\"\",\"s\")","v":"komen er geen items"},{"$f":"\"kom\"&IF(F2=1,\"t\",\"en\")&\" er \"&IF(F2=0,\"geen\",F2)&\" item\"&IF(F2=1,\"\",\"s\")","v":"komen er geen items"},null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":1},{"$f":"\">=\" & $P$4","v":">=42848"},{"$f":"\"<=\" & $P$5","v":"<=42925"},{"$f":"INDEX($B$2:$B$22,$J2)","v":"Lucyvo"},{"$f":"INDEX($C$2:$C$22,$J2)","v":"competitie"},null,{"$f":"NOW()","v":"2017-05-13T19:50:24.800"},""]
[true,"Lucyvo","beker",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Boerenbond\")*$A$2:$A$22)","v":5},3,{"$f":"SUMPRODUCT((DBPloegen=B3)*(DBCategorien=C3)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F7:F11)=1,\"t\",\"en\")&\" er \"&IF(SUM(F7:F11)=0,\"geen\",SUM(F7:F11))&\" item\"&IF(SUM(F7:F11)=1,\"\",\"s\")","v":"komen er geen items"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":2},{"$f":"\">=\" & $P$4","v":">=42848"},{"$f":"\"<=\" & $P$5","v":"<=42925"},"Lucyvo","beker"]
[true,"Lucyvo","oefenmatch",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Bots\")*$A$2:$A$22)","v":3},0,{"$f":"SUMPRODUCT((DBPloegen=B4)*(DBCategorien=C4)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F12:F14)=1,\"t\",\"en\")&\" er \"&IF(SUM(F12:F14)=0,\"geen\",SUM(F12:F14))&\" item\"&IF(SUM(F12:F14)=1,\"\",\"s\")","v":"komen er geen items"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":3},">=42848","<=42925","Lucyvo","oefenmatch",null,{"$f":"IF(ISBLANK($Q$4),Data!#REF!,$Q$4)","v":"2017-04-23"},"2017-04-23"]
[true,"Lucyvo","training",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Lierse\")*$A$2:$A$22)","v":3},0,{"$f":"SUMPRODUCT((DBPloegen=B5)*(DBCategorien=C5)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F15:F17)=1,\"t\",\"en\")&\" er \"&IF(SUM(F15:F17)=0,\"geen\",SUM(F15:F17))&\" item\"&IF(SUM(F15:F17)=1,\"\",\"s\")","v":"komen er 6 items"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":4},">=42848","<=42925","Lucyvo","training",null,{"$f":"IF(ISBLANK($Q$5),MAX(Data!#REF!),$Q$5)","v":"2017-07-09"},"2017-07-09"]
[true,"Lucyvo","activiteit",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Eureco\")*$A$2:$A$22)","v":2},0,{"$f":"SUMPRODUCT((DBPloegen=B6)*(DBCategorien=C6)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F18:F19)=1,\"t\",\"en\")&\" er \"&IF(SUM(F18:F19)=0,\"geen\",SUM(F18:F19))&\" item\"&IF(SUM(F18:F19)=1,\"\",\"s\")","v":"komen er geen items"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":5},">=42848","<=42925","Lucyvo","activiteit"]
[true,"Boerenbond","competitie",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Rode Duivels\")*$A$2:$A$22)","v":2},0,{"$f":"SUMPRODUCT((DBPloegen=B7)*(DBCategorien=C7)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(SUM(F20:F21)=1,\"t\",\"en\")&\" er \"&IF(SUM(F20:F21)=0,\"geen\",SUM(F20:F21))&\" item\"&IF(SUM(F20:F21)=1,\"\",\"s\")","v":"komt er 1 item"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":6},">=42848","<=42925","Boerenbond","competitie"]
[true,"Boerenbond","beker",{"$f":"SUMPRODUCT(($B$2:$B$22=\"Europees\")*$A$2:$A$22)","v":1},0,{"$f":"SUMPRODUCT((DBPloegen=B8)*(DBCategorien=C8)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},{"$f":"\"kom\"&IF(F22=1,\"t\",\"en\")&\" er \"&IF(F22=0,\"geen\",F22)&\" item\"&IF(SUM(F22)=1,\"\",\"s\")","v":"komen er geen items"},"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":7},">=42848","<=42925","Boerenbond","beker"]
[true,"Boerenbond","oefenmatch",null,0,{"$f":"SUMPRODUCT((DBPloegen=B9)*(DBCategorien=C9)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":8},">=42848","<=42925","Boerenbond","oefenmatch"]
[true,"Boerenbond","training",null,0,{"$f":"SUMPRODUCT((DBPloegen=B10)*(DBCategorien=C10)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":9},">=42848","<=42925","Boerenbond","training"]
[true,"Boerenbond","activiteit",null,0,{"$f":"SUMPRODUCT((DBPloegen=B11)*(DBCategorien=C11)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":10},">=42848","<=42925","Boerenbond","activiteit"]
[true,"Bots","competitie",null,16,{"$f":"SUMPRODUCT((DBPloegen=B12)*(DBCategorien=C12)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":11},">=42848","<=42925","Bots","competitie"]
[true,"Bots","nacompetitie",null,0,{"$f":"SUMPRODUCT((DBPloegen=B13)*(DBCategorien=C13)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":12},">=42848","<=42925","Bots","nacompetitie"]
[true,"Bots","oefenmatch",null,0,{"$f":"SUMPRODUCT((DBPloegen=B14)*(DBCategorien=C14)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":13},">=42848","<=42925","Bots","oefenmatch"]
[true,"Lierse","competitie",null,38,{"$f":"SUMPRODUCT((DBPloegen=B15)*(DBCategorien=C15)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":6},null,"komen er 6 items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":14},">=42848","<=42925","Lierse","competitie"]
[true,"Lierse","beker",null,2,{"$f":"SUMPRODUCT((DBPloegen=B16)*(DBCategorien=C16)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":15},">=42848","<=42925","Lierse","beker"]
[true,"Lierse","oefenmatch",null,0,{"$f":"SUMPRODUCT((DBPloegen=B17)*(DBCategorien=C17)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":16},">=42848","<=42925","Lierse","oefenmatch"]
[true,"Eureco","competitie",null,0,{"$f":"SUMPRODUCT((DBPloegen=B18)*(DBCategorien=C18)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":17},">=42848","<=42925","Eureco","competitie"]
[true,"Eureco","oefenmatch",null,0,{"$f":"SUMPRODUCT((DBPloegen=B19)*(DBCategorien=C19)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":18},">=42848","<=42925","Eureco","oefenmatch"]
[true,"Rode Duivels","competitie",null,10,{"$f":"SUMPRODUCT((DBPloegen=B20)*(DBCategorien=C20)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":1},null,"komt er 1 item",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":19},">=42848","<=42925","Rode Duivels","competitie"]
[true,"Rode Duivels","oefenmatch",null,3,{"$f":"SUMPRODUCT((DBPloegen=B21)*(DBCategorien=C21)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":20},">=42848","<=42925","Rode Duivels","oefenmatch"]
[true,"Europees","competitie",null,56,{"$f":"SUMPRODUCT((DBPloegen=B22)*(DBCategorien=C22)*(DBDatums>=Misc!$P$4)*(DBDatums<=Misc!$P$5))","v":0},null,"komen er geen items",null,{"$f":"IF(ROW()-1<=$D$24,SMALL(IF($A$2:$A$22,ROW($A$2:$A$22)-1,100),ROW()-1),\"\")","v":21},">=42848","<=42925","Europees","competitie"]
[]
[null,null,null,{"$f":"SUM(D2:D8)","v":21},null,{"$f":"SUM(F2:F22)","v":7}]
[null,null,null,{"$f":"COUNTIF(D2:D8,\">0\")","v":7}]