{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Voorblad","Klanten","beschikbaarheid","verzenden"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":29,"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":24,"n_cols":21,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,3],[2,1,2,3],[7,5,7,8],[10,1,10,3],[6,5,6,8],[15,5,15,8],[8,5,8,8],[12,1,12,3],[9,1,9,3],[8,1,8,3],[9,5,9,8],[13,1,13,3],[3,1,4,1],[7,1,7,3],[11,1,11,3],[6,1,6,3],[14,5,14,8]]}
[2]
["rij 22 contactpersoon",{"$f":"VLOOKUP(Klantnummer,Klanten,16)","v":42454},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ter info","Ronny van den Bosch"]
["rij 23 emailadressen",{"$f":"VLOOKUP(Klantnummer,Klanten,17)","v":42455},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ter info de klant belt zelf terug"]
[null,"klantendatabase"]
[]
[]
["Naam ",{"$f":"VLOOKUP(Klantnummer,Klanten,2)","v":"klant3"},null,null,"Huurproduct 1",{"$f":"IF(VLOOKUP(Klantnummer,Klanten,10)=\"\",\"\",VLOOKUP(Klantnummer,Klanten,10))","v":9}]
["Factuurnummer",{"$f":"VLOOKUP(Klantnummer,Klanten,3)","v":201601},null,null,"Huurproduct 2",{"$f":"IF(VLOOKUP(Klantnummer,Klanten,11)=\"\",\"\",VLOOKUP(Klantnummer,Klanten,11))","v":0}]
["Telefoonnummer",{"$f":"VLOOKUP(Klantnummer,Klanten,4)","v":"06-12345678"},null,null,"Bijproduct 1",{"$f":"IF(VLOOKUP(Klantnummer,Klanten,12)=\"\",\"\",VLOOKUP(Klantnummer,Klanten,12))","v":8}]
["Adres",{"$f":"VLOOKUP(Klantnummer,Klanten,6)","v":"straat2"},null,null,"Bijproduct 2",{"$f":"IF(VLOOKUP(Klantnummer,Klanten,13)=\"\",\"\",VLOOKUP(Klantnummer,Klanten,13))","v":0}]
["Postcode ",{"$f":"VLOOKUP(Klantnummer,Klanten,7)","v":2727}]
["Woonplaats",{"$f":"VLOOKUP(Klantnummer,Klanten,8)","v":"test"},null,null,"Huurdatum",{"$f":"VLOOKUP(Klantnummer,Klanten,23)","v":"2010-10-10"}]
["E-mail",{"$f":"VLOOKUP(Klantnummer,Klanten,9)","v":"test@hotmail.com"},null,null,"Versturen op",{"$f":"VLOOKUP(Klantnummer,Klanten,14)","v":"2016-03-24"}]
["Pick up point",{"$f":"HYPERLINK(VLOOKUP(Klantnummer,Klanten,5))","v":"Thuis"}]
[null,null,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,15)","v":"x"}]
["Totaalbedrag",40,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,16)","v":"2016-03-25"}]
["Openstaand",40,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,17)","v":"2016-03-26"}]
["Borg al terug?","Nee",null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,18)","v":"2016-03-27"}]
[null,null,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,19)","v":"2016-03-28"}]
[null,null,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,20)","v":"2016-03-29"}]
[null,null,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,21)","v":"2016-03-30"}]
[null,null,null,null,"onderwerg",{"$f":"VLOOKUP(Klantnummer,Klanten,22)","v":"2016-03-31"}]
["Bijzonderheden"]
[{"$f":"VLOOKUP(Klantnummer,Klanten,24)","v":"Paasweekend"}]

{"sheet":"Klanten","index":1,"n_rows":3,"n_cols":24,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nr","Naam:","Factuurnummer","Telefoonnummer","Pick up point","straatnaam:","Postcode","woonplaats","Pick up point","verhuurproduct 1","verhuurproduct 2","bijproduct 1","bijproduct 2","Versturen op","Onderweg","Onderweg","Onderweg","Onderweg","Onderweg","Onderweg","Onderwerg","Onderwerg","Huurdatum:","bijzonderheden"]
[1,"klant1",201601,"06-12345678","Thuis","straat1",2727,"test","test@hotmail.com",10,0,0,0,"2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2010-10-10","Paasweekend"]
[2,"klant3",201601,"06-12345678","Thuis","straat2",2727,"test","test@hotmail.com",9,0,8,0,"2016-03-24","x","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2010-10-10","Paasweekend"]

{"sheet":"beschikbaarheid","index":2,"n_rows":11,"n_cols":253,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag"]
[null,"2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02","2016-04-03","2016-04-04","2016-04-05","2016-04-06","2016-04-07","2016-04-08","2016-04-09","2016-04-10","2016-04-11","2016-04-12","2016-04-13","2016-04-14","2016-04-15","2016-04-16","2016-04-17","2016-04-18","2016-04-19","2016-04-20","2016-04-21","2016-04-22","2016-04-23","2016-04-24","2016-04-25","2016-04-26","2016-04-27","2016-04-28","2016-04-29","2016-04-30","2016-05-01","2016-05-02","2016-05-03","2016-05-04","2016-05-05","2016-05-06","2016-05-07","2016-05-08","2016-05-09","2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14","2016-05-15","2016-05-16","2016-05-17","2016-05-18","2016-05-19","2016-05-20","2016-05-21","2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27","2016-05-28","2016-05-29","2016-05-30","2016-05-31","2016-06-01","2016-06-02","2016-06-03","2016-06-04","2016-06-05","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-11","2016-06-12","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-18","2016-06-19","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-25","2016-06-26","2016-06-27","2016-06-28","2016-06-29","2016-06-30","2016-07-01","2016-07-02","2016-07-03","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-09","2016-07-10","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-16","2016-07-17","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-23","2016-07-24","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","2016-07-30","2016-07-31","2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-06","2016-08-07","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-13","2016-08-14","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-20","2016-08-21","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-27","2016-08-28","2016-08-29","2016-08-30","2016-08-31","2016-09-01","2016-09-02","2016-09-03","2016-09-04","2016-09-05","2016-09-06","2016-09-07","2016-09-08","2016-09-09","2016-09-10","2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17","2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24","2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30","2016-10-01","2016-10-02","2016-10-03","2016-10-04","2016-10-05","2016-10-06","2016-10-07","2016-10-08","2016-10-09","2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15","2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22","2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28","2016-10-29","2016-10-30","2016-10-31","2016-11-01","2016-11-02","2016-11-03","2016-11-04","2016-11-05","2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-12","2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19","2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26"]
["verhuurproduct 1:"]
["totaal",150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150,150]
["verhuurd"]
["beschikbaar"]
[]
["verhuurproduct 2:"]
["Totaal",30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30,30]
["verhuurd"]
["beschikbaar"]

{"sheet":"verzenden","index":3,"n_rows":4,"n_cols":254,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag","zondag","maandag","dinsdag","woensdag","donderdag","vrijdag","zaterdag"]
[null,"2016-03-19","2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26","2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02","2016-04-03","2016-04-04","2016-04-05","2016-04-06","2016-04-07","2016-04-08","2016-04-09","2016-04-10","2016-04-11","2016-04-12","2016-04-13","2016-04-14","2016-04-15","2016-04-16","2016-04-17","2016-04-18","2016-04-19","2016-04-20","2016-04-21","2016-04-22","2016-04-23","2016-04-24","2016-04-25","2016-04-26","2016-04-27","2016-04-28","2016-04-29","2016-04-30","2016-05-01","2016-05-02","2016-05-03","2016-05-04","2016-05-05","2016-05-06","2016-05-07","2016-05-08","2016-05-09","2016-05-10","2016-05-11","2016-05-12","2016-05-13","2016-05-14","2016-05-15","2016-05-16","2016-05-17","2016-05-18","2016-05-19","2016-05-20","2016-05-21","2016-05-22","2016-05-23","2016-05-24","2016-05-25","2016-05-26","2016-05-27","2016-05-28","2016-05-29","2016-05-30","2016-05-31","2016-06-01","2016-06-02","2016-06-03","2016-06-04","2016-06-05","2016-06-06","2016-06-07","2016-06-08","2016-06-09","2016-06-10","2016-06-11","2016-06-12","2016-06-13","2016-06-14","2016-06-15","2016-06-16","2016-06-17","2016-06-18","2016-06-19","2016-06-20","2016-06-21","2016-06-22","2016-06-23","2016-06-24","2016-06-25","2016-06-26","2016-06-27","2016-06-28","2016-06-29","2016-06-30","2016-07-01","2016-07-02","2016-07-03","2016-07-04","2016-07-05","2016-07-06","2016-07-07","2016-07-08","2016-07-09","2016-07-10","2016-07-11","2016-07-12","2016-07-13","2016-07-14","2016-07-15","2016-07-16","2016-07-17","2016-07-18","2016-07-19","2016-07-20","2016-07-21","2016-07-22","2016-07-23","2016-07-24","2016-07-25","2016-07-26","2016-07-27","2016-07-28","2016-07-29","2016-07-30","2016-07-31","2016-08-01","2016-08-02","2016-08-03","2016-08-04","2016-08-05","2016-08-06","2016-08-07","2016-08-08","2016-08-09","2016-08-10","2016-08-11","2016-08-12","2016-08-13","2016-08-14","2016-08-15","2016-08-16","2016-08-17","2016-08-18","2016-08-19","2016-08-20","2016-08-21","2016-08-22","2016-08-23","2016-08-24","2016-08-25","2016-08-26","2016-08-27","2016-08-28","2016-08-29","2016-08-30","2016-08-31","2016-09-01","2016-09-02","2016-09-03","2016-09-04","2016-09-05","2016-09-06","2016-09-07","2016-09-08","2016-09-09","2016-09-10","2016-09-11","2016-09-12","2016-09-13","2016-09-14","2016-09-15","2016-09-16","2016-09-17","2016-09-18","2016-09-19","2016-09-20","2016-09-21","2016-09-22","2016-09-23","2016-09-24","2016-09-25","2016-09-26","2016-09-27","2016-09-28","2016-09-29","2016-09-30","2016-10-01","2016-10-02","2016-10-03","2016-10-04","2016-10-05","2016-10-06","2016-10-07","2016-10-08","2016-10-09","2016-10-10","2016-10-11","2016-10-12","2016-10-13","2016-10-14","2016-10-15","2016-10-16","2016-10-17","2016-10-18","2016-10-19","2016-10-20","2016-10-21","2016-10-22","2016-10-23","2016-10-24","2016-10-25","2016-10-26","2016-10-27","2016-10-28","2016-10-29","2016-10-30","2016-10-31","2016-11-01","2016-11-02","2016-11-03","2016-11-04","2016-11-05","2016-11-06","2016-11-07","2016-11-08","2016-11-09","2016-11-10","2016-11-12","2016-11-13","2016-11-14","2016-11-15","2016-11-16","2016-11-17","2016-11-18","2016-11-19","2016-11-20","2016-11-21","2016-11-22","2016-11-23","2016-11-24","2016-11-25","2016-11-26","27--"]
[]
["Verzenden:"]