{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabel","Groepen","Blad3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Tabel","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["tekst","Rekening","Groep"]
["Op rekeningnummer BE73 8800 0008 7890 met referentie 1568﻿﻿﻿7",{"$f":"AccountNumber($A2)","v":"BE73 8800 0008 7890"},{"$f":"IFERROR(INDEX(Groepen!$B$2:$C6,MATCH(Tabel!$B2,Groepen!$C$2:$C$6,0),1),\"\")","v":"De Rots"}]
["Betaling werd gedaan naar Taverne de Rots op rekeningnummer BE66 8888 7777 6666",{"$f":"AccountNumber($A3)","v":"BE66 8888 7777 6666"},{"$f":"IFERROR(INDEX(Groepen!$B$2:$C7,MATCH(Tabel!$B3,Groepen!$C$2:$C$6,0),1),\"\")","v":"Supermarkt"}]
["Betaling werd gedaan naar Taverne de Rots op rekeningnummer BE56 9999 8888 7777  met referentie 1568﻿﻿﻿7","BE56 9999 8888 7777",{"$f":"IFERROR(INDEX(Groepen!$B$2:$C8,MATCH(Tabel!$B4,Groepen!$C$2:$C$6,0),1),\"\")","v":"Loon"}]
[]
[]
[]
[]
[]
[]
[]
["Elke CEL A ( Tabblad \"Tabel\") zou doorzocht moeten worden op alle trefwoorden uit KOLOM C (Tabblad \"Groepen\").\nDe gevonden trefwoorden in CEL A (Tabblad \"Tabel\") zouden moeten verwijzen naar de correcte groep in KOLOM B (Tabblad \"Groepen\")\nDeze groepherkenning zou dan per rij weergegeven worden in KOLOM E (Tabblad \"Tabel\")"]

{"sheet":"Groepen","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Groep","Trefwoorden"]
[null,"Loon","BE56 9999 8888 7777"]
[null,"Supermarkt","BE66 8888 7777 6666"]
[null,"Bakker","BE66 8888 7777 8888"]
[null,"De Rots","BE73 8800 0008 7890"]

{"sheet":"Blad3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}