{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Start","Rij","verzameling"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":"Start","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[47,6,47,7]]}
[]
[null,"Deze Excel bevat een macro die individuele bestellingen verzamelt en opslaat in één Excel bestand. De macro"]
[null,"werkt als volgt:"]
[]
[null,"1.","Pas eventueel de standaard variabelen aan zodat deze correct zijn voor de Excels met daarin de"]
[null,null,"bestellingen. Indien ' aangepast'  leeg is dan wordt de 'standaard'  toegepast"]
[]
[null,"2.","Klik op de start knop om de macro te starten"]
[]
[null,"3.","Selecteer de folder waarin alle Excel bestanden staan met de individuele bestellingen"]
[]
[null,"4.","De macro opent één voor één de Excel bestanden en kopieert de juiste kolommen naar een nieuw"]
[null,null,"Excel bestand"]
[]
[null,"5.","Wanneer alle Excel bestanden zijn doorlopen, berekent de macro het totaal van alle kolommen per rij"]
[]
[null,"6.","De macro slaat het nieuwe Excel bestand met de totalen op en geeft hieronder een samenvatting met"]
[null,null,"eventuele fouten"]
[]
[]
[]
[]
[]
[]
[null,"Standaard variabelen voor lokatie van producten en waardes"]
[]
[null,null,null,null,null,null,null,null,"standaard",null,"aangepast",null,"toegepast",null,null,"productkolom","waardekolom"]
[]
[null,"De naam van het tabblad waarin de producten en waardes staan ",null,null,null,null,null,null,"Rij",null,null,null,{"$f":"IF(ISBLANK(K29),I29,K29)","v":"Rij"},null,null,"A","A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B","B"]
[null,"Kolomnummer waarin de productnamen staan",null,null,null,null,null,null,"B",null,null,null,{"$f":"IF(ISBLANK(K31),I31,K31)","v":"B"},null,null,"C","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D","D"]
[null,"Kolomnummer waarin de waardes staan",null,null,null,null,null,null,"C",null,null,null,{"$f":"IF(ISBLANK(K33),I33,K33)","v":"C"},null,null,"E","E"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F","F"]
[null,"Rijnummer vanaf waar de totalen worden berekend",null,null,null,null,null,null,9,null,null,null,{"$f":"IF(ISBLANK(K35),I35,IF(ISNUMBER(K35),MAX(1,FLOOR(K35,1)),I35))","v":9},null,null,"G","G"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H","H"]
[null,"Rijnummer tot waar de totalen worden berekend",null,null,null,null,null,null,16,null,null,null,{"$f":"IF(ISBLANK(K37),I37,IF(ISNUMBER(K37),MAX(1,FLOOR(K37,1)),I37))","v":16}]
[]
[null,"Het tabblad 'Rij' in deze Excel is een voorbeeld waarin de 'standaard'  variabelen van naam, kolomnummers"]
[null,"en rijnummer kloppen"]
[]
[null,"Het tabblad 'verzameling' in deze Excel is een voorbeeld van hoe de kolommen verzameld worden."]
[null,"In kolom ' A'  worden de producten opgesomd. In kolom ' B'  staan de totalen van kolom ' C'  en verder."]
[]
[]
[null,"Samenvatting"]
[]
[null,"Datum uitvoeren macro:"]
[]
[null,"Naam van het nieuwe Excel bestand:"]
[]
[null,"Geselecteerde folder:"]
[]
[null,"Aantal Excel bestanden in folder:"]
[]
[null,"Aantal Excel bestanden succesvol gekopieerd:"]
[]
[null,"Aantal Excel bestanden niet gekopieerd:",null,null,null,null,null,"Reden is omdat de naam van het tabblad "]
[null,null,null,null,null,null,null,"niet aanwezig is in de volgende Excel(-s)"]

{"sheet":"Rij","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"voornaam","jan"]
[null,"achternaam","jansen"]
[null,"straat","dorpstraat"]
[null,"nummer",1]
[null,"postcode","1010AA"]
[null,"plaats","Alkmaar"]
[null,"tel. nr",123456789]
["besteld","item","aantal","totaalprijs"]
["","trui A",0,""]
["","trui B",2,""]
["","trui C",0,""]
["","trui D",0,""]
["","broek A",0,""]
["","broek B",0,""]
["","broek C",1,""]
["","broek D",0,""]

{"sheet":"verzameling","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["voornaam",null,"jan","maria","kees"]
["achternaam",null,"jansen","maarsen","vissers"]
["straat",null,"dorpstraat","kerstraat","stadhuisplein"]
["nummer",null,1,5,15]
["postcode",null,"1010AA","2121BD","3145TF"]
["plaats",null,"Alkmaar","Dordrecht","Zevenaar"]
["tel. nr",null,123456789,123456789,123456789]
["item",null,"aantal","aantal","aantal"]
["trui A",{"$f":"SUM(C9:E9)","v":0},0,0,0]
["trui B",{"$f":"SUM(C10:E10)","v":5},2,0,3]
["trui C",1,0,0,1]
["trui D",1,0,1,0]
["broek A",0,0,0,0]
["broek B",0,0,0,0]
["broek C",2,1,0,1]
["broek D",0,0,0,0]