{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Blad1","Januari","Groepen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Blad1","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Som van BEDRAG","Kolomlabels"]
["Rijlabels","Cash geldopname","Eten en drinken","Games","Horeca","Kledij","Loon","Opleidingen","Opleidingscheques terugbetaling","Reizen","Tandarts","Vakbond lidmaatschap","Vakbond terugbetaling","Eindtotaal"]
["2018-01-02",null,null,null,null,-50.99,null,null,null,null,null,null,null,-50.99]
["2018-01-04",null,null,null,null,null,25.95,null,null,null,null,null,null,25.95]
["2018-01-05",null,null,null,null,null,null,null,null,null,null,-12.87,null,-12.87]
["2018-01-08",-100,null,null,null,null,null,null,null,null,null,null,null,-100]
["2018-01-11",null,null,null,null,null,null,null,null,-1253.8499999999999,null,null,null,-1253.8499999999999]
["2018-01-18",null,null,null,null,null,null,null,250,null,null,null,null,250]
["2018-01-20",-75,null,null,null,null,null,null,null,null,null,null,null,-75]
["2018-01-24",null,null,null,null,null,1728.9,null,null,null,null,null,null,1728.9]
["2018-01-26",null,null,null,null,null,null,null,null,null,null,null,95,95]
["2018-01-29",null,-68.790000000000006,-25,-78.95,null,null,-275.5,null,null,null,null,null,-448.24]
["2018-01-30",null,null,null,null,null,78,null,null,null,-160,null,null,-82]
["Eindtotaal",-175,-68.790000000000006,-25,-78.95,-50.99,1832.8500000000001,-275.5,250,-1253.8499999999999,-160,-12.87,95,76.900000000000091]

{"sheet":"Januari","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["#","DATUM","BEDRAG","DETAILS","GROEP"]
[1,"2018-01-30",-160,"BETALING MET BANKKAART                   30-01          160,00-MET KAART 3939 04XX XXXX X234 3 MEDIPOLIS  BRUSSEL 3/01/2018 VALUTADATUM : 30/01/2018 ","Tandarts"]
[2,"2018-01-30",78,"EUROPESE OVERSCHRIJVING VAN              30-01           78,00+ PROFAX NV BRECHT BE38 3200 0507 3372  BIC BBRUBEBB REFERTE OPDRACHTGEVER : 2000026 MEDEDELING : /CUBICENTER 1.1.2018 VALUTADATUM : 30/01/2018 ","Loon"]
[3,"2018-01-29",-25,"BETALING MET BANKKAART                   28-01            25,00-MET KAART 3939 04XX XXXX X234 3 CONSOLEPRO B.V.   AMSTERDAM 28/01/2018 UITGEVOERD OP 28-01 VALUTADATUM : 28/01/2018 ","Games"]
[4,"2018-01-29",-68.790000000000006,"BETALING MET BANKKAART                   28-01           68,79-MET KAART 3939 04XX XXXX X234 3 DRANKDOZIJN       BREDA  28/01/2018 UITGEVOERD OP 28-01 VALUTADATUM : 28/01/2018 ","Eten en drinken"]
[5,"2018-01-29",-78.95,"EUROPESE OVERSCHRIJVING NAAR             28-01          78,95-JANSSENS FRANK BE89001759538645 BIC GEBABEBB    VIA MOBILE BANKING MEDEDELING : HELFT VAN ETENTJE UITGEVOERD OP 28-01 VALUTADATUM : 28/01/2018 ","Horeca"]
[6,"2018-01-29",-275.5,"EUROPESE OVERSCHRIJVING NAAR             28-01          275,50-OPLEIDINGSCENTRUM BE26001755538029 BIC GEBABEBB TERUG UITGEVOERD OP 28-01 VALUTADATUM : 28/01/2018 ","Opleidingen"]
[7,"2018-01-26",95,"EUROPESE OVERSCHRIJVING VAN              26-01          95,00+FV ABVV-NST SCHTTERMANSTRAAT 78 2610 EDEGEM BE57 8939 4400 1035  BIC VDSPBE91 MEDEDELING : 81-1750-4 BOUW 2016 VALUTADATUM : 26/01/2018 ","Vakbond terugbetaling"]
[8,"2018-01-24",1728.9,"EUROPESE OVERSCHRIJVING VAN              24-01        1.728,90+ PROFAX NV BRECHT BE38 3200 0507 3372  BIC BBRUBEBB REFERTE OPDRACHTGEVER : 613154801231091002098 MEDEDELING : /A/ WERKGEVER: 06154 WERKNEMER: 001 6785 01 DATUM: 22/01/2018  ","Loon"]
[9,"2018-01-20",-75,"GELDOPNAME AAN ANDERE AUTOMATEN          20-01          75,00-MET KAART 3939 04XX XXXX X234 3 SELFBANK LAGEWEG DIEST 20/01/2018 VALUTADATUM : 20/01/2018 ","Cash geldopname"]
[10,"2018-01-18",250,"EUROPESE OVERSCHRIJVING VAN              18-01          250,00+APB POA - CVOPA LUIK BE97 0910 1891 7049  BIC GKCCBEBB REFERTE OPDRACHTGEVER : 16012051380064789996 MEDEDELING : TERUGBETALING OPLEIDINGSCHEQUES VALUTADATUM : 18/01/2018 ","Opleidingscheques terugbetaling"]
[11,"2018-01-11",-1253.8499999999999,"EUROPESE OVERSCHRIJVING NAAR             11-01        1.253,85-JETAIR BE770017555678 BIC GEBABEBB    VIA MOBILE BANKING VALUTADATUM : 11/01/2018 ","Reizen"]
[13,"2018-01-08",-100,"GELDOPNAME AAN ANDERE AUTOMATEN          06-01          100,00-MET KAART 3939 04XX XXXX X234 3 GENT 3989 06/01/2018 UITGEVOERD OP 06-01 VALUTADATUM : 06/01/2018 ","Cash geldopname"]
[14,"2018-01-05",-12.87,"EUROPESE DOMICILIERING VAN               05-01           12,87-ABVV  MANDAAT NUMMER : N017649 REFERTE : 9918 BIJDRAGEN 012018-012018 MEDEDELING : 089350419 VALUTADATUM : 05/01/2018 ","Vakbond lidmaatschap"]
[15,"2018-01-04",25.95,"EUROPESE OVERSCHRIJVING VAN              04-01          25,95+PROFAX NV BRECHT BE38 3200 0507 3372  BIC BBRUBEBB REFERTE OPDRACHTGEVER : 61315010310518552009765 MEDEDELING : /A/ WERKGEVER: 06154 WERKNEMER: 001 6785 01 DATUM: 02/01/2018  ","Loon"]
[16,"2018-01-02",-50.99,"BETALING MET BANKKAART                   29-12           50,99-MET KAART 3939 04XX XXXX X234 3 SUITSUPPLY LOKEREN P 29/12/2017 VALUTADATUM : 29/12/2017 ","Kledij"]
[]
[]
[]
[]
[null,null,null,"Hoe krijg ik in KOLOM E (Tabblad Januari) automatisch de juiste groep op basis van de de toegewezen trefwoorden/groep op het Tabblad \"Groepen\""]

{"sheet":"Groepen","index":2,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Groep","Trefwoorden/-cijfers"]
[null,"Loon","PROFAX NV"]
[null,"Loon","BE38 3200 0507 3372"]
[null,"Loon","WERKGEVER"]
[null,"Loon","WERKNEMER"]
[null,"Tandarts","MEDIPOLIS"]
[null,"Games","CONSOLEPRO B.V."]
[null,"Eten en drinken","DRANKDOZIJN"]
[null,"Horeca","ETENTJE"]
[null,"Opleidingen","BE26001755538029"]
[null,"Opleidingen","OPLEIDINGSCENTRUM"]
[null,"Vakbond terugbetaling","BE57 8939 4400 1035"]
[null,"Vakbond terugbetaling","ABVV-NST"]
[null,"Cash geldopname","GELDOPNAME"]
[null,"Cash geldopname","SELFBANK"]
[null,"Opleidingscheques terugbetaling","BE97 0910 1891 7049"]
[null,"Opleidingscheques terugbetaling","APB POA - CVOPA"]
[null,"Opleidingscheques terugbetaling","OPLEIDINGSCHEQUES"]
[null,"Reizen","JETAIR"]
[null,"Reizen","BE770017555678"]
[null,"Vakbond lidmaatschap","ABVV"]
[null,"Kledij","SUITSUPPLY"]