{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["LEES DIT","Factuur Opstellen","Factuur","Alle Facturen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"LEES DIT","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,"© Auteursrecht: Wim de Groot"]
[]
[null,null,null,"Dit Excel-bestand is gemaakt door Wim de Groot voor ComputerIdee."]
[null,null,null,"U mag dit bestand gratis gebruiken en wij wensen u er veel plezier mee."]
[]
[null,null,null,"Op grond van het auteursrecht mag u dit bestand alleen kopiëren voor uzelf. "]
[null,null,null,"U mag dit bestand:"]
[null,null,null,"* niet verkopen"]
[null,null,null,"* niet vermenigvuldigen en verkopen"]
[null,null,null,"* niet op een website te koop aanbieden"]
[null,null,null,"* niet op cd, dvd, USB-stick en dergelijke te koop aanbieden"]
[]
[null,null,null,"U mag dit bestand gratis via uw eigen website aanbieden:"]
[null,null,null,"* als u daarvoor geen vergoeding vraagt,"]
[null,null,null,"* als u vermeldt dat het bestand van Wim de Groot afkomstig is,"]
[null,null,null,"* als u daarover een bericht stuurt naar info@exceltekstenuitleg.nl"]
[null,null,null,"* als u daarbij een link plaatst naar www.exceltekstenuitleg.nl"]
[]
[null,null,null,"Vragen over de werking van dit bestand kunt u sturen naar:"]
[null,null,null,"redactie@computeridee.nl"]
[]
[]
[null,null,null,"Zelf leren werken met Excel?"]
[null,null,null,"Ik kom graag een cursus verzorgen op uw bedrijf."]
[null,null,null,"Klik hier voor de mogelijkheden"]
[null,null,null,"Reactie van een deelnemer: \"Eindelijk iemand die Excel helder uitlegt!\""]
[]
[]
[null,null,null,"Wim de Groot denkt buiten de hokjes."]
[]
[null,null,null,"www.exceltekstenuitleg.nl"]

{"sheet":"Factuur Opstellen","index":1,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Klik hieronder en kies de naam:",null,null,null,null,null,null,"Omschrijving","per maand",null,null,null,"Naam","aanvulling","Adres","Plaats"]
[null,null,null,null,null,null,null,null,"Contributie senioren",14,null,null,null,"D. van der Schraaf",null,"Richard Holkade 8","2033 PZ Haarlem"]
[null,{"$f":"VLOOKUP(B2,N:Q,2,0)","v":{"$error":"#N/A"}},null,"Factuurnummer en datum",null,null,null,null,"Contributie junioren",9,null,null,null,"Wim de Groot","Excel Tekst en Uitleg","Mussenveld 129","7827 AJ Emmen"]
[null,{"$f":"VLOOKUP(B2,N:Q,3,0)","v":{"$error":"#N/A"}},null,"komen automatisch op de factuur",null,null,null,null,"Contributie pupillen",6]
[null,{"$f":"VLOOKUP(B2,N:Q,4,0)","v":{"$error":"#N/A"}}]
["Betreft:"]
[null,"Omschrijving","Aantal maanden:","per maand","Bedrag"]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B8,I:L,2,0),0)","v":0},{"$f":"C8*D8","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[]
[]
[]
[]
[]
[null,null,null,"TOTAAL ",{"$f":"SUM(E8:E24)","v":0}]

{"sheet":"Factuur","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,3,0,5],[6,3,6,5],[13,4,13,5],[15,4,15,5],[52,1,52,5],[1,3,1,5],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5]]}
[]
[null,null,"Scouting","adres"]
[null,null,"binnen en buiten actief","PC Woonplaats"]
[null,"(logo)"]
[null,null,"uw naam","e-mailadres@provider.nl"]
[null,null,"penningmeester","www.vereniging.nl"]
[null,null,null,"KvK. nr. 0123456"]
[]
[]
[]
[]
[]
[]
[null,"(hier komt de naam)",null,"Factuurnr.:","(automatisch)"]
[null,"(hier komt de aanvulling)"]
[null,"(hier komt het adres)",null,"Datum:","(automatisch)"]
[null,"(hier komt PC Woonplaats)"]
[]
[]
[null,"Betreft:","Contributie 3e kwartaal 2017"]
[null,null,"Omschrijving","Aantal maanden","per maand","Bedrag"]
[]
[]
[]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,"bedragen",0]
[null,null,null,null,"verschijnen"]
[null,null,null,null,"automatisch "]
[]
[]
[]
[null,null,null,null,"TOTAAL ",42]
[]
[]
[]
[null,null,"Betaling binnen 14 dagen op rekeningnr. NL89 ASNB 0707 7315 42"]
[null,null,"t.n.v. Excel Tekst en Uitleg, Emmen"]
[null,null,{"$f":"\"onder vermelding van: Factuurnr. \"&E14","v":"onder vermelding van: Factuurnr. (automatisch)"}]

{"sheet":"Alle Facturen","index":3,"n_rows":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,11,0,14],[0,0,0,3],[0,4,0,6]]}
["Facturen CONTRIBUTIE",null,null,null,null,null,null,null,null,null,null,"Facturen INKOOP"]
["Factuurdatum","Factuurnr.","Betreft","Naam",null,null,null,null,"Totaal factuur","Betaald op:",null,"Factuurdatum:","Factuurnr.","Betreft","Naam leverancier","Totaal factuur"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hebt u meer Inkoop-facturen?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kopieer dan deze twee gele cellen omlaag."]