{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Database","Werk","Releases","Hulp"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":13,"comments":2,"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":"Database","index":0,"n_rows":116,"n_cols":65,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Database ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"Categorie","Reserve popup1","Reserve popup0","Reserve popup1","Reserve popup2","Reserve popup3","Reserve popup4","Reserve popup5","Reserve popup6","Reserve popup7","Reserve popup8"]
["#","Artikel","Merk","Categorie","Winkel","Prijs","Aankoopdatum","Einddatum","Opmerkingen","Aankoopbewijs","Website","Email","Reserve1","Reserve2","Reserve3","Reserve4","Reserve5","Reserve6","Reserve7","Reserve8","Reserve9","Reserve10","Reserve11","Reserve12","Reserve13","Reserve14","Reserve15","Reserve16","Reserve17","Reserve18","Reserve19","Reserve20","Reserve21","Reserve22","Reserve23","Reserve24","Reserve25","Reserve26","Reserve27","Reserve28","Reserve29","Reserve30","Reserve31","Reserve32","Reserve33","Reserve34","Gemaakt","Wijz.datum","Door",null,null,null,{"$f":"ROW()","v":2},null,null,null,null,null,null,null,null,null," "]
[{"$f":"IF(AV3=\"\",\"\",ROW()-rijkop)","v":1},"Artikel","Merk","Categorie","Winkel",1,"2020-05-08","2022-05-08",null,"Koppelen","https://www.website","contact@website.nl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-08","2020-05-08","Gebruiker",null,null,null,null,null,"Auto&Motor"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beeld&Geluid"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computers&Telefoon"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Games&Speelgoed"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garage"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hobby"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Huis"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Huishoud elektro"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kleding"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meubelen"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overig"]
[{"$f":"IF(AV14=\"\",\"\",ROW()-rijkop)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sieraden&Horloges"]
[{"$f":"IF(AV15=\"\",\"\",ROW()-rijkop)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sport"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tuin"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verlichting"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV31=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV39=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV53=\"\",\"\",ROW()-rijkop)","v":""}]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(BC3:BC53)","v":15},{"$f":"COUNTA(BD3:BD53)","v":0},0,0,0,0,0,0,0,0,0]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Database!BC3:BC\",BC54+2)","v":"Database!BC3:BC17"},{"$f":"CONCATENATE(\"Database!Bd3:Bd\",BD54+2)","v":"Database!Bd3:Bd2"},{"$f":"CONCATENATE(\"Database!Be3:Be\",BE54+2)","v":"Database!Be3:Be2"},{"$f":"CONCATENATE(\"Database!Bf3:Bf\",BF54+2)","v":"Database!Bf3:Bf2"},{"$f":"CONCATENATE(\"Database!Bg3:Bg\",BG54+2)","v":"Database!Bg3:Bg2"},{"$f":"CONCATENATE(\"Database!Bh3:Bh\",BH54+2)","v":"Database!Bh3:Bh2"},{"$f":"CONCATENATE(\"Database!Bi3:Bi\",BI54+2)","v":"Database!Bi3:Bi2"},{"$f":"CONCATENATE(\"Database!Bj3:Bj\",BJ54+2)","v":"Database!Bj3:Bj2"},{"$f":"CONCATENATE(\"Database!Bk3:Bk\",BK54+2)","v":"Database!Bk3:Bk2"},{"$f":"CONCATENATE(\"Database!Bk3:Bk\",BL54+2)","v":"Database!Bk3:Bk2"},"Database!Bk3:Bk2"]
[{"$f":"IF(AV56=\"\",\"\",ROW()-rijkop)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,1,1,0,0,0,0,null,"0 = niet sorteren"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 = sorteren"]
["",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N.B. rij33 t/m rij 53 wordt niet gebruikt"]
[""]
[""]
[""]
[{"$f":"IF(AV62=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV74=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV94=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(AV102=\"\",\"\",ROW()-rijkop)","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Werk","index":1,"n_rows":4500,"n_cols":50,"rows_kept":4500,"cut":false,"hidden":true,"merged":[[46,2,46,4]]}
[null,"Zoektrefferhulp:","","","","","","nvt","nvt","","","","","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt",{"$f":"COLUMN()","v":49},{"$f":"COLUMN()","v":50}]
[null,"#","Artikel","Merk","Categorie","Winkel","Prijs","Aankoopdatum","Einddatum","Opmerkingen","Aankoopbewijs","Website","Email","Reserve1","Reserve2","Reserve3","Reserve4","Reserve5","Reserve6","Reserve7","Reserve8","Reserve9","Reserve10","Reserve11","Reserve12","Reserve13","Reserve14","Reserve15","Reserve16","Reserve17","Reserve18","Reserve19","Reserve20","Reserve21","Reserve22","Reserve23","Reserve24","Reserve25","Reserve26","Reserve27","Reserve28","Reserve29","Reserve30","Reserve31","Reserve32","Reserve33","Reserve34","Gemaakt","Wijz.datum","Door"]
[null,1,"Artikel","Merk","Categorie","Winkel",1,"2020-05-08","2022-05-08",null,"Koppelen","https://www.website","contact@website.nl",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-05-08","2020-05-08","Gebruiker"]
[null,"Zoektreffer:",{"$f":"IF(zoekargument=\"\",\"\",IF(ISERROR(SEARCH(zoekargument,C3,1)),\"\",IF(SEARCH(zoekargument,C3,1)>0,\"*\",\"\")))","v":""},"","","","","nvt","nvt","","","","","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt","nvt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ASD",null,"sdfg","Geblokkeerd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DTIK",42224.662559722223,"Keimpe"]

{"sheet":"Releases","index":2,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Datum","Versie","Omschrijving"]
["2015-08-10",0,"Kleine bugfixes denk vooral aan kode gewijzigd."]
[null,null,"Bij import wordt eenmaal extra sub \"ophalen\" uitgevoerd op gegevens nieuwe 1e record. Daarmee wordt voorkomen dat aangegeven wordt dat "]
[null,null,"er een wijziging is."]
[null,null,"Tevens wordt opgeslagen en weergegeven wanneer voor laatst bestand is opgeslagen en door wie"]
[null,null,"Bij wijzigen, verwijderen, nieuw record en importeren wordt er altijd gesaved. Bestand is dan meteen up-to-date"]
[null,null,"Import kent vervangen en aanvullen."]
[null,null,"Foutje gevonden: als blijkt dat er een veld met   (alt 22/244 teken) is crasht het programma. Zat bij record 31 en daar ging het mis."]
[null,null,"Ga ik nog herstellen d.m.v. macro-tje. Heeft te maken met chr(10) harde return."]
[null,null,"Importeren bij vervangen tevens de mogelijkheid kode-wijzigen en lijsten als IVR e.d. over te nemen"]
["2015-08-25",0,"Tabblad Werk opgedeeld in deel met alleen de hulpgegevens tbv formulier en tabblad Hulp tbv van de echte werkgegevens, alsmede instellingsgegevens"]
[null,null,"Hiermee wordt bewerkstelligt dat er geen problemen meer ontstaan met wijzigingen in tabblad Werk (Private Sub Worksheet_Change(ByVal Target As Range))"]
[null,null,"Daarbij \"wijzigingen\" uitgebreid met zoeken naar zoekargument en wissen, alsmede de keus om niet of wel b=het bestand meteen op te slaan."]
[null,null,"Printen via Dymo toegegevoegd."]
[null,null,"Papersize uitgezet bij macro, omdat 99012 Large Adress niet overal dezelfde interne papersdize heeft (bij ontwikkelaar was dit 146)."]
[null,null,"Eerst even via preview papersize instellen en printen, daarna onthoudt hij dit best wel. Daarna steeds printen"]
["2015-08-31",0,"Uitbreiding met wijzigen Instellingen."]
[null,null,"Nu via 1 button mogelijk en dan 3 keuzes namelijk Wijzigingen, Printkeuze en inhoud popuplijstjes."]
["2015-11-25",8,"FUNCTION vervangen door SUB"]
[null,null,"URL-volgen mogelijkheid ingebouwd tbv website klant, alsmede Outlook start vanuit formulier."]
[null,null,"Doorvoor is het wel noodzakelijk om verwijzingen mbt Outlook te selecteren onder VBA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2015-12-04",4,"Vanaf hier een kopie met aanpassingen gemaakt tbv Garantie."]
[]
["2015-12-06",4,"Het voorgaande komt uit een ander bestand wat als basis diende voor dit bestand."]
[null,null,"Nu ook ingebouwd dat hij als gekoppelde bestanden een excel-file kan openen terwijl de Form nog open staat. Hij doiet dit door een extra excel.applicatie te openen."]
[null,null,"Tevens bij deleten niet meer record nummer noemen bij slagen, maar artikel naam"]
["2015-12-24",4,"Bij selecteren aankoopnota een kleine bugfix gedaan. Als namelijk de paden nog niet gefeinieerd zijn kan het zijn dat de standaard mappen paden niet bestaan en dan crashte het "]
[null,null,"programma. Nu gaat hij het pad nemen waar ook het programma zelf staat."]

{"sheet":"Hulp","index":3,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":true,"merged":[[46,2,46,4],[13,7,13,9],[16,8,16,9],[65,2,65,3],[68,2,68,3],[74,2,74,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3]]}
[null,null,null,null,null,null,null,null,null,null,"Backup_Garantie_KWJ"]
[null,null,null,null,null,null,null,null,null,"Niet aankomen!!!!!!"]
[null,null,null,null,null,null,null,null,null,"Opgeslagen Backupbestanden:","Bestandsnaam Backup"]
[null,null,null,null,null,null,null,null,null,"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_08052020_12-31-18.xlsm",{"$f":"CONCATENATE(I17,K1,\"_\",TEXT(NOW(),\"ddmmjjjj\"),\"_\",TEXT(NOW(),\"uu-mm-ss\"),\".xlsm\")","v":"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_08052020_12-31-18.xlsm"}]
[null,"Vorig tabblad tbv terugspringen",null,null,null,"Laatste keer gebruikt",null,null,null,"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_07052020_14-13-48.xlsm"]
[null,"Database"," naam",null,null,"Keimpe","2020-05-08T12:31:18",null,null,"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_23042020_15-32-42.xlsm"]
[null,"Rij in vorig tabblad tbv terugspringen",null,null,null,null,null,null,null,"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_23042020_15-28-46.xlsm"]
[null,3,"positie",null,null,null,null,null,null,"B:\\Keimpe\\Garantie\\Backup_Garantie_KWJ_23042020_15-26-13.xlsm"]
[null,"Aantal records  door macro tbv bladeren"]
[null,3,"regels met inhoud, aantal argumenten wordt geteld in kolom",null,"A",null,null,null,null,"standaard map:"]
[null,null," er worden dus geen lege regels geteld!!!",null,null,null,null,null,null,{"$f":"LEFT(CELL(\"bestandsnaam\",A2),FIND(\"\\[\",CELL(\"bestandsnaam\",A2),1))","v":"A:\\www.kwjansma.nl\\downloads\\"}]
[null,"Aantal titels  door macro tbv wijzigen",null,null,null,null,null,null,null,{"$f":"LEFT(J11,1)","v":"A"}]
[null,{"$f":"COUNTA(Werk!B2:AZ2)","v":49}," kolommen"]
[null,null,null,null,null,null,null,"Backup"]
[null,"Aantal kopregels in Blad voor recs beginnen",null,null,null,null,null,null,"Opslag-map"]
[null,2," aantal regels voordat inhoud recs begint, kijk in kolom ",null,null,null,null,null,"afsluiten met \\",null,"Default"]
[null,null,null,null,null,null,null,null,"B:\\Keimpe\\Garantie\\",null,{"$f":"J11","v":"A:\\www.kwjansma.nl\\downloads\\"}]
[null,"Database"]
[null,1," 1= kijken; 2 toevoegen","vorige kode",1,"1=kijken/wijzigen; 2=nooit wijzigen; 3  vanuit database naar form",null,null,"Contract-map"]
[null,null," 2 = ook vanuit database naar form",null,null,null,null,null,"afsluiten met \\",null,"Default"]
[null,"datum",{"$f":"NOW()","v":"2020-05-08T12:31:18.320"},null,null,null,null,null,"Z:\\Aankopen Online en offline\\",null,{"$f":"J11","v":"A:\\www.kwjansma.nl\\downloads\\"}]
[null,"user","Keimpe",null,null,null,null,null,{"$f":"LEFT(I21,1)","v":"Z"}]
[]
[null,"Wachttijd",0," 0 = nee, 1 = ja; wordt gebruikt voor de batchprint. Dan wordt formulier namelijk automatisch gesloten",null,null,null,null,"Contract-map tbv verwijderde records"]
[null,"Preview",1," 0 = meteen printen; 1 = preview. Werkt niet bij batchprint",null,null,null,null,"afsluiten met \\",null,"Default"]
[null,null,null,null,null,"aantal \"nvt\"",null,null,"B:\\Keimpe\\Garantie\\Verwijderde rekeningen\\",null,{"$f":"J11","v":"A:\\www.kwjansma.nl\\downloads\\"}]
[null,"Zoekargument",null,"Aantal treffers",{"$f":"MAX(0,B13-3-COUNTBLANK(Werk!C1:AV1)-F27)","v":0},{"$f":"COUNTIF(Werk!C1:AV1,\"nvt\")","v":37},null,null,{"$f":"LEFT(I26,1)","v":"B"}]
[]
[null,"Rij in vorig tabblad tbv terugspringen bij annuleren nieuw",null,null,null,"Instellingen fomulier input tbv keuzes"]
[null,102,"positie",null,null,"Methode wijzigingen verwerken",1,null,{"$f":"IF(ISERROR(VLOOKUP(J30,F30:G36,2,FALSE)),G30,VLOOKUP(J30,F30:G36,2,FALSE))","v":1}]
[null,null,null,null,null,"Popupkeuzes aanpassen",2]
[null,"Huidig week/jaarnummer",null,"Nu dag en tijd",null,"Printkeuzes",3]
[null,{"$f":"WEEKNUM(D33) & \"/\" & YEAR(D33)","v":"19/2020"},"positie",{"$f":"NOW()","v":"2020-05-08T12:31:18.320"},null,"Mappen kiezen (Backup en Rekeningen)",4]
[null,null,null,null,null,"Mail (Aanhef en afsluiting)",5]
[null,"Aantal records",null,null,null,null,6]
[null,{"$f":"B10-B16","v":1},"records",null,null,null,7]
[]
[null,"Kode wijzigen",null,null,null,"Keuzes tbv Macro instellinge kode wijzigen",null,null,"Logo-bestand-picture"]
[null,0,"0 = alleen button wijzigen; 1 = ook bij eerste record, laatste record, volgende, vorige, afsluiten en naar Database",null,null,0,null,null,null,null,"Default vanaf kwjansma.nl"]
[null,0,"0 = geen bestand saven na wijziging; 1 = elke keer na wijziging wordt bestand opgeslagen",null,null,1,null,null,null,null,"https://www.kwjansma.nl/downloads/logo_Garantie.gif"]
[null,"Hulpveld gewijzigd in range B3:AV3 zie programmacode bij Blad2(werk)"]
[null,0,"0 = niets gewijzigd; 1 = wijziging",null,null,"Linkhulp macro Zoom_contract "]
[null,null,null,null,null,"Z:\\Aankopen Online en offline\\Welkoop\\Verticuteer_2020\\Bestelling_436.pdf",null,"pdf"]
[]
[null,"Importsectie"]
[null,null,null,null,null,"Geimporteerd","Soort import"]
[null,null,"Z:\\Teledent\\Personeel\\Personeelsbestand_v1.1.xlsm",null,null,"2015-11-03T14:11:59","Vervangen"]
[null,null,"Personeelsbestand_v1.1.xlsm",null,null,"Chr(10) vervangen",0,"Mogen niet voorkomen, zijn harde returns en als die in de "]
[null,"Importeren lijsten en vervangen vanuit nw bestand, alsmede kode wijzigen; teller personeelsnummer, backup historie en backup- en contractmap",null,null,null,"Chr(13) vervangen",0,"velden voorkomen staakt de Form met werken,"]
[null,1,"0=nee, 1 =ja (Is alleen van toepassing bij vervangen, niet bij toevoegen!!)",null,null,null,null,"daarom vervangen door een spatie!!"]
[]
[null,null,null,null,"Niet aankomen!!!","Popup-opslag bij form tbv annuleren"]
[null,"Popup soorten:","Categorie",{"$f":"IF(ISERROR(VLOOKUP(C53,C54:D62,2,FALSE)),D54,VLOOKUP(C53,C54:D62,2,FALSE))","v":"BC"},{"$f":"B6&\"!\"&D53","v":"Database!BC"},"Auto&Motor",{"$f":"E53 & 3","v":"Database!BC3"},"wordt gebruikt tbv macro Popup2"]
[null,null,{"$f":"+Database!BC1","v":"Categorie"},"BC",1,"Beeld&Geluid",{"$f":"E53&32","v":"Database!BC32"},"wordt gebruikt tbv macro Popup2"]
[null,null,{"$f":"+Database!BD1","v":"Reserve popup1"},"BD",{"$f":"E54+1","v":2},"Computers&Telefoon",{"$f":"IF(ISERROR(VLOOKUP(C53,C54:E62,3,FALSE)),E54,VLOOKUP(C53,C54:E62,3,FALSE))","v":1},"wordt gebruikt tbv macro Popup2"]
[null,null,{"$f":"+Database!BE1","v":"Reserve popup0"},"BE",{"$f":"E55+1","v":3},"Games&Speelgoed"]
[null,null,{"$f":"+Database!BF1 &\" \"&  Database!BF2","v":"Reserve popup1 "},"BF",4,"Garage"]
[null,null,{"$f":"+Database!BG1","v":"Reserve popup2"},"BG",5,"Hobby"]
[null,null,{"$f":"+Database!BH1","v":"Reserve popup3"},"BH",6,"Huis"]
[null,null,{"$f":"+Database!BI1 & \" \" & Database!BI2","v":"Reserve popup4 "},"BI",7,"Huishoud elektro"]
[null,null,{"$f":"+Database!BJ1","v":"Reserve popup5"},"BJ",8,"Meubelen"]
[null,null,{"$f":"+Database!BK1","v":"Reserve popup6"},"BK",9,"Sieraden&Horloges"]
[null,null,null,null,null,"Sport"]
[null,null,null,null,null,"Tuin"]
[null,"Mailgegevens:",null,null,null,"Verlichting"]
[null,"Aanhef","Beste,",null,null,"Overig"]
[null,"Afronding e.d."]
[null,"Regel"]
[null,1]
[null,{"$f":"B69+1","v":2}]
[null,3,"Met vriendelijke groeten,"]
[null,4]
[null,5,"K.W.Jansma"]
[null,6,"06-39115763"]
[null,7]