{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Base","Inschrijving","Betalingen","Betaalt","Blad1","Param"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Base","index":0,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Ins,  Nr","Naam & Voor naam","Klant Bij ","Datum ins,",null,null,null,null,null,null,null,"Café"]
[1,"Marie-Paul","Marie-Paule","2015-09-24",null,null,null,null,null,null,1,"Erna"]
[2,"Sarah Baert","Marie-Paule","2015-09-24",null,null,null,null,null,null,2,"Marie-Paule"]
[3,"Nathalie","Marie-Paule","2015-09-24",null,null,null,null,null,null,3,"Ysora"]
[4,"Dany","Marie-Paule","2015-09-24",null,null,null,null,null,null,4,"Voglkske"]
[5,"Thibo","Marie-Paule","2015-09-24",null,null,null,null,null,null,5,"Voglkske"]
[6,"Kevin","Marie-Paule","2015-09-24"]
[7,"Bernadette","Marie-Paule","2015-09-24"]
[8,"Filip","Marie-Paule","2015-09-24"]
[9,"Antoinnet","Marie-Paule","2015-09-24"]
[10,"Brigitte","Marie-Paule","2015-09-24"]
[11,"Werner Brulez","Marie-Paule","2015-09-24"]
[12,"Werner Brulez","Marie-Paule","2015-09-24"]
[13,"Patrick Minnaert","Marie-Paule","2015-09-24"]
[14,"Minnaert Fabienne","Marie-Paule","2015-09-24"]
[15,"Marc Coorvits","Marie-Paule","2015-09-24"]
[16,"Maheur Adelin","Marie-Paule","2015-09-24"]
[17,"Rudy V","Marie-Paule","2015-09-24"]
[18,"D,B,A,","Marie-Paule","2015-09-24"]
[19,"Baele Marleen","Marie-Paule","2015-09-24"]
[20,"Danielle","Marie-Paule","2015-09-24"]
[21,"Albert Vanderbrugge","Marie-Paule","2015-09-24"]
[22,"Diego","Marie-Paule","2015-09-24"]
[23,"Kimberly","Marie-Paule","2015-09-24"]
[24,"frankie","Erna","2015-09-24"]
[25,"Erna t'Genieterke","Erna","2015-09-24"]
[26,"Robin  Verstraeten","Erna","2015-09-24"]
[27,"Loic  Verstraeten","Erna","2015-09-24"]
[28,"Quint  Verstraeten","Erna","2015-09-24"]
[29,"Olivia  Verstraeten","Erna","2015-09-24"]
[30,"Jonas Verstraeten","Erna","2015-09-24"]
[31,"Frank t'Genieterke","Erna","2015-09-24"]
[32,"Liban","Erna","2015-09-24"]
[33,"Darline","Erna","2015-09-24"]
[34,"Luc Van Overmeire","Erna","2015-09-24"]
[35,"Vanessa Vangermeersch","Erna","2015-09-24"]
[36,"Gunther Vangermeersch","Erna","2015-09-24"]
[37,"Jean-Pierre vangermeersch","Erna","2015-09-24"]
[38,"Jozef Matton","Erna","2015-09-24"]
[39,"Chipie p","Erna","2015-09-24"]
[40,"Buffalo Bill","Erna","2015-09-24"]
[41,"Dianeke","Erna","2015-09-24"]
[42,"Freddy Moens","Erna","2015-09-24"]
[43,"Duji","Erna"]
[44,"Johan De Cock","Erna"]
[45,"Margueriete Lalojaux","Erna"]
[46,"Michel Notre-Dame","Erna"]
[47,"Triene","Erna"]
[48,"Paul","Erna"]
[49,"Franske","Erna"]
[50,"Kristof De Groote","Erna"]
[51,"Juf Marleen","Erna"]
[52,"Dolfke","Erna"]
[53,"Manolito","Erna"]
[54,"Dirk ","Erna"]
[55,"Isaura","Erna"]
[56,"Jommeke","Erna"]
[57,"Cynthia","Erna"]
[58,"Vandenabeele Luc","Erna"]
[59,"Lieca","Erna"]

{"sheet":"Inschrijving","index":1,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["inschrijving",4,null,"Inschrijving Nr","Naam & Voor naam","Klant Bij ","Datum ins,"]
[null,null,null,{"$f":"MAX(Base!A:A)+1","v":60},{"$f":"E5&\"\"","v":""},{"$f":"E6&\"\"","v":"Voglkske"},{"$f":"E7","v":"2016-08-12"}]
[]
[null,null,null,"Inschrijving Nr",{"$f":"D2","v":60}]
[null,null,null,"Naam & Voor naam"]
[null,null,null,"Klant Bij ",{"$f":"INDEX(Café,B1)","v":"Voglkske"}]
[null,null,null,"Datum ins,",{"$f":"TODAY()","v":"2016-08-12"}]

{"sheet":"Betalingen","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Nr",{"$f":"INDEX(Inschrijving,param_no_ligne)","v":10}]
[]
[null,null,null,"Naam & Voor naam",{"$f":"IF(param_no_ligne=0,\"\",INDEX(Naam,param_no_ligne))","v":"Brigitte"}]
[null,null,null,"Betaalt"]

{"sheet":"Betaalt","index":3,"n_rows":61,"n_cols":107,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Betaalt                             Naam & Voormaan","Ins. Nr","2016-08-06",{"$f":"C1+7","v":"2016-08-13"},{"$f":"D1+7","v":"2016-08-20"},"2016-08-27","2016-09-03","2016-09-10","2016-09-17","2016-09-24","2016-10-01","2016-10-08","2016-10-15","2016-10-22","2016-10-29","2016-11-05","2016-11-12","2016-11-19","2016-11-26","2016-12-03","2016-12-10","2016-12-17","2016-12-24","2016-12-31","2017-01-07","2017-01-14","2017-01-21","2017-01-28","2017-02-04","2017-02-11","2017-02-18","2017-02-25","2017-03-04","2017-03-11","2017-03-18","2017-03-25","2017-04-01","2017-04-08","2017-04-15","2017-04-22","2017-04-29","2017-05-06","2017-05-13","2017-05-20","2017-05-27","2017-06-03","2017-06-10","2017-06-17","2017-06-24","2017-07-01","2017-07-08","2017-07-15","2017-07-22","2017-07-29","2017-08-05","2017-08-12","2017-08-19","2017-08-26","2017-09-02","2017-09-09","2017-09-16","2017-09-23","2017-09-30","2017-10-07","2017-10-14","2017-10-21","2017-10-28","2017-11-04",{"$f":"BP1+7","v":"2017-11-11"},"2017-11-18","2017-11-25","2017-12-02","2017-12-09","2017-12-16","2017-12-23","2017-12-30","2018-01-06","2018-01-13","2018-01-20","2018-01-27","2018-02-03","2018-02-10","2018-02-17","2018-02-24","2018-03-03","2018-03-10","2018-03-17","2018-03-24","2018-03-31","2018-04-07","2018-04-14","2018-04-21","2018-04-28","2018-05-05","2018-05-12","2018-05-19","2018-05-26","2018-06-02","2018-06-09","2018-06-16","2018-06-23","2018-06-30","2018-07-07","2018-07-14","2018-07-21","2018-07-28","2018-08-04"]
[{"$f":"Base!B2","v":"Marie-Paul"},{"$f":"Base!A2","v":1},"B","B"]
[{"$f":"Base!B3","v":"Sarah Baert"},{"$f":"Base!A3","v":2},"B","B"]
[{"$f":"Base!B4","v":"Nathalie"},{"$f":"Base!A4","v":3}]
[{"$f":"Base!B5","v":"Dany"},{"$f":"Base!A5","v":4}]
[{"$f":"Base!B6","v":"Thibo"},{"$f":"Base!A6","v":5}]
[{"$f":"Base!B7","v":"Kevin"},{"$f":"Base!A7","v":6}]
[{"$f":"Base!B8","v":"Bernadette"},{"$f":"Base!A8","v":7}]
[{"$f":"Base!B9","v":"Filip"},{"$f":"Base!A9","v":8}]
[{"$f":"Base!B10","v":"Antoinnet"},{"$f":"Base!A10","v":9}]
[{"$f":"Base!B11","v":"Brigitte"},{"$f":"Base!A11","v":10}]
[{"$f":"Base!B12","v":"Werner Brulez"},{"$f":"Base!A12","v":11}]
[{"$f":"Base!B13","v":"Werner Brulez"},{"$f":"Base!A13","v":12}]
[{"$f":"Base!B14","v":"Patrick Minnaert"},{"$f":"Base!A14","v":13}]
[{"$f":"Base!B15","v":"Minnaert Fabienne"},{"$f":"Base!A15","v":14}]
[{"$f":"Base!B16","v":"Marc Coorvits"},{"$f":"Base!A16","v":15}]
[{"$f":"Base!B17","v":"Maheur Adelin"},{"$f":"Base!A17","v":16}]
[{"$f":"Base!B18","v":"Rudy V"},{"$f":"Base!A18","v":17}]
[{"$f":"Base!B19","v":"D,B,A,"},{"$f":"Base!A19","v":18}]
[{"$f":"Base!B20","v":"Baele Marleen"},{"$f":"Base!A20","v":19}]
[{"$f":"Base!B21","v":"Danielle"},{"$f":"Base!A21","v":20}]
[{"$f":"Base!B22","v":"Albert Vanderbrugge"},{"$f":"Base!A22","v":21}]
[{"$f":"Base!B23","v":"Diego"},{"$f":"Base!A23","v":22}]
[{"$f":"Base!B24","v":"Kimberly"},{"$f":"Base!A24","v":23}]
[{"$f":"Base!B25","v":"frankie"},{"$f":"Base!A25","v":24}]
[{"$f":"Base!B26","v":"Erna t'Genieterke"},{"$f":"Base!A26","v":25}]
[{"$f":"Base!B27","v":"Robin  Verstraeten"},{"$f":"Base!A27","v":26}]
[{"$f":"Base!B28","v":"Loic  Verstraeten"},{"$f":"Base!A28","v":27}]
[{"$f":"Base!B29","v":"Quint  Verstraeten"},{"$f":"Base!A29","v":28}]
[{"$f":"Base!B30","v":"Olivia  Verstraeten"},{"$f":"Base!A30","v":29}]
[{"$f":"Base!B31","v":"Jonas Verstraeten"},{"$f":"Base!A31","v":30}]
[{"$f":"Base!B32","v":"Frank t'Genieterke"},{"$f":"Base!A32","v":31}]
[{"$f":"Base!B33","v":"Liban"},{"$f":"Base!A33","v":32}]
[{"$f":"Base!B34","v":"Darline"},{"$f":"Base!A34","v":33}]
[{"$f":"Base!B35","v":"Luc Van Overmeire"},{"$f":"Base!A35","v":34}]
[{"$f":"Base!B36","v":"Vanessa Vangermeersch"},{"$f":"Base!A36","v":35}]
[{"$f":"Base!B37","v":"Gunther Vangermeersch"},{"$f":"Base!A37","v":36}]
[{"$f":"Base!B38","v":"Jean-Pierre vangermeersch"},{"$f":"Base!A38","v":37}]
[{"$f":"Base!B39","v":"Jozef Matton"},{"$f":"Base!A39","v":38}]
[{"$f":"Base!B40","v":"Chipie p"},{"$f":"Base!A40","v":39}]
[{"$f":"Base!B41","v":"Buffalo Bill"},{"$f":"Base!A41","v":40}]
[{"$f":"Base!B42","v":"Dianeke"},{"$f":"Base!A42","v":41}]
[{"$f":"Base!B43","v":"Freddy Moens"},{"$f":"Base!A43","v":42}]
[{"$f":"Base!B44","v":"Duji"},{"$f":"Base!A44","v":43}]
[{"$f":"Base!B45","v":"Johan De Cock"},{"$f":"Base!A45","v":44}]
[{"$f":"Base!B46","v":"Margueriete Lalojaux"},{"$f":"Base!A46","v":45}]
[{"$f":"Base!B47","v":"Michel Notre-Dame"},{"$f":"Base!A47","v":46}]
[{"$f":"Base!B48","v":"Triene"},{"$f":"Base!A48","v":47}]
[{"$f":"Base!B49","v":"Paul"},{"$f":"Base!A49","v":48}]
[{"$f":"Base!B50","v":"Franske"},{"$f":"Base!A50","v":49}]
[{"$f":"Base!B51","v":"Kristof De Groote"},{"$f":"Base!A51","v":50}]
[{"$f":"Base!B52","v":"Juf Marleen"},{"$f":"Base!A52","v":51}]
[{"$f":"Base!B53","v":"Dolfke"},{"$f":"Base!A53","v":52}]
[{"$f":"Base!B54","v":"Manolito"},{"$f":"Base!A54","v":53}]
[{"$f":"Base!B55","v":"Dirk "},{"$f":"Base!A55","v":54}]
[{"$f":"Base!B56","v":"Isaura"},{"$f":"Base!A56","v":55}]
[{"$f":"Base!B57","v":"Jommeke"},{"$f":"Base!A57","v":56}]
[{"$f":"Base!B58","v":"Cynthia"},{"$f":"Base!A58","v":57}]
[{"$f":"Base!B59","v":"Vandenabeele Luc"},{"$f":"Base!A59","v":58}]
[{"$f":"Base!B60","v":"Lieca"},{"$f":"Base!A60","v":59}]
[{"$f":"Base!B61","v":0},{"$f":"Base!A61","v":0}]

{"sheet":"Blad1","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Naam & Voor naam"]

{"sheet":"Param","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
["No de la ligne de l'enregistrement courant",10]
[]
["Nombre d'enregistrements dans la BD",{"$f":"COUNTA(Base!A:A)-1","v":59}]