{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Voorblad","Namen","Parameters","Tennis"],"not_rendered":{"charts":0,"images":1,"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  Teksten samenvoegen"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2015, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Namen","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Voornaam","Achternaam"]
[null,"Jan","Jansen"]
[null,"Jan","Willem","Verdonk"]
[null,"Piet","Pietersen"]
[null,"Marie","Jose","Verburen","Engels"]
[null,"Trees","Verhagen","Terbraak"]
[]
[]
[null,{"$f":"B3","v":"Jan"},{"$f":"C3","v":"Jansen"}]
[null,{"$f":"CONCATENATE(B4,\" \",C4)","v":"Jan Willem"},{"$f":"D4","v":"Verdonk"}]
[null,{"$f":"B5","v":"Piet"},"Pietersen"]
[null,{"$f":"CONCATENATE(B6,\" \",C6)","v":"Marie Jose"},{"$f":"CONCATENATE(D6,\" \",E6)","v":"Verburen Engels"}]
[null,{"$f":"B7","v":"Trees"},{"$f":"CONCATENATE(C7,\" \",D7)","v":"Verhagen Terbraak"}]
[]
[]
[null,{"$f":"B3","v":"Jan"},{"$f":"C3","v":"Jansen"}]
[null,{"$f":"B4&\" \"&C4","v":"Jan Willem"},{"$f":"D4","v":"Verdonk"}]
[null,{"$f":"B5","v":"Piet"},"Pietersen"]
[null,{"$f":"B6&\" \"&C6","v":"Marie Jose"},{"$f":"D6&\" \"&E6","v":"Verburen Engels"}]
[null,{"$f":"B7","v":"Trees"},{"$f":"C7&\" \"&D7","v":"Verhagen Terbraak"}]

{"sheet":"Parameters","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[7,5,7,8],[6,5,6,8],[6,1,6,2]]}
[]
[null,"Jaar",2015]
[null,"Maand","maart"]
[null,"Datum","2015-03-27"]
[]
[]
[null,{"$f":"\"Overzicht van \"&C3&\" \"&C2","v":"Overzicht van maart 2015"},null,null,null,{"$f":"\"Overzicht van \"&C4","v":"Overzicht van 42090"}]
[null,null,null,null,null,{"$f":"\"Overzicht van \"&TEXT(C4,\"mmmm jjjj\")","v":"Overzicht van maart 2015"}]
[null,"Datum","Bedrag"]
[null,{"$f":"DATE(YEAR(C4),MONTH(C4),1)","v":"2015-03-01"}]
[null,{"$f":"+B10+1","v":"2015-03-02"}]
[null,{"$f":"+B11+1","v":"2015-03-03"}]
[null,"2015-03-04"]
[null,"2015-03-05"]
[null,"2015-03-06"]
[null,"2015-03-07"]
[null,"2015-03-08"]
[null,"2015-03-09"]
[null,"2015-03-10"]
[null,"2015-03-11"]
[null,"2015-03-12"]
[null,"2015-03-13"]
[null,"2015-03-14"]
[null,"2015-03-15"]
[null,"2015-03-16"]
[null,"2015-03-17"]

{"sheet":"Tennis","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Datum","Thuis","Uit"]
[null,"2015-04-03","T.V.","Kann","T.V.","'t","Sopje"]
[null,"2015-04-03","T.C.","Wanse","Velden","T.C.","Meerrooi"]
[null,"2015-04-03","T.C.","Weizhe","L.T.C.","De","Panheuvel"]
[null,"2015-04-03","T.C.","Velden","T.C.","Slootdooi"]
[null,"2015-04-10","L.T.C.","De","Panheuvel","T.V.","Kann"]
[null,"2015-04-10","T.C.","Meerrooi","T.C.","Velden"]
[null,"2015-04-10","T.C.","Slootdooi","T.C.","Wanse","Velden"]
[null,"2015-04-10","T.V.","'t","Sopje","T.C.","Weizhe"]
[null,"2015-04-17","T.C.","Weizhe","T.C.","Slootdooi"]
[null,"2015-04-17","T.C.","Velden","L.T.C.","De","Panheuvel"]
[null,"2015-04-17","T.V.","Kann","T.C.","Meerrooi"]
[null,"2015-04-17","T.C.","Wanse","Velden","T.V.","'t","Sopje"]
[null,"2015-04-24","T.C.","Slootdooi","T.V.","Kann"]
[null,"2015-04-24","L.T.C.","De","Panheuvel","T.C.","Wanse","Velden"]
[null,"2015-04-24","T.C.","Meerrooi","T.C.","Weizhe"]
[null,"2015-04-24","T.V.","'t","Sopje","T.C.","Velden"]
[null,"2015-05-01","L.T.C.","De","Panheuvel","T.V.","'t","Sopje"]
[null,"2015-05-01","T.C.","Meerrooi","T.C.","Slootdooi"]
[null,"2015-05-01","T.C.","Weizhe","T.V.","Kann"]
[null,"2015-05-01","T.C.","Wanse","Velden","T.C.","Velden"]
[null,"2015-05-15","T.C.","Velden","T.C.","Weizhe"]
[null,"2015-05-15","T.V.","'t","Sopje","T.C.","Meerrooi"]
[null,"2015-05-15","T.V.","Kann","T.C.","Wanse","Velden"]
[null,"2015-05-15","T.C.","Slootdooi","L.T.C.","De","Panheuvel"]
[null,"2015-05-29","T.V.","Kann","T.C.","Velden"]
[null,"2015-05-29","T.C.","Meerrooi","L.T.C.","De","Panheuvel"]
[null,"2015-05-29","T.C.","Weizhe","T.C.","Wanse","Velden"]
[null,"2015-05-29","T.C.","Slootdooi","T.V.","'t","Sopje"]