{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LEES DIT","Factuur Opstellen","Factuur","Alle Facturen","BTW"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":100,"n_cols":17,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,"Klik hieronder en kies de klant:",null,null,null,null,null,null,"Omschrijving","prijs per stuk:","tarief","ex BTW",null,"Naam","aanvulling","Adres","Plaats"]
[null,null,null,null,null,null,null,null,"Bezorgkosten plaatselijk",8,"hoog",{"$f":"ROUND(J2/IF(K2=\"hoog\",1.21,IF(K2=\"laag\",1.06,1)),2)","v":6.61},null,"ComputerIdee","T.a.v. D. van der Schraaf","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,null,null,null,0,null,"Excel Tekst en Uitleg","Wim de Groot, trainer","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,null,null,null,0]
[null,{"$f":"VLOOKUP(B2,N:Q,4,0)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,0]
["Betreft:",null,null,"ex BTW","ex BTW",null,"BTW",null,null,null,null,0]
["Datum:","Omschrijving","Aantal:","Prijs per stuk","Bedrag","BTW:","is",null,null,null,null,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B8,I:L,4,0),0)","v":0},{"$f":"C8*D8","v":0},{"$f":"IFERROR(VLOOKUP(B8,I:L,3,0),0)","v":0},{"$f":"(IFERROR(VLOOKUP(B8,I:L,2,0),0)-IFERROR(VLOOKUP(B8,I:L,4,0),0))*C8","v":0},null,null,null,null,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B9,I:L,4,0),0)","v":0},0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,{"$f":"ROUND(J17/IF(K17=\"hoog\",1.21,IF(K17=\"laag\",1.06,1)),2)","v":0}]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,0,null,null,null,null,0]
[null,null,null,null,"ex BTW","BTW",null,null,null,null,null,0]
[null,null,null,"BTW 21%",{"$f":"SUMIF(F8:F24,\"hoog\",E8:E24)","v":0},{"$f":"SUMIF(F8:F24,\"hoog\",G8:G24)","v":0},null,null,null,null,null,0]
[null,null,null,"BTW 6%",{"$f":"SUMIF(F8:F24,\"laag\",E8:E24)","v":0},{"$f":"SUMIF(F8:F24,\"laag\",G8:G24)","v":0},null,null,null,null,null,0]
[null,null,null,"BTW 0%",{"$f":"SUMIF(F8:F24,\"nul\",E8:E24)","v":0},null,null,null,null,null,null,0]
[null,null,null,"Subtotaal",{"$f":"SUM(E26:E28)","v":0},{"$f":"SUM(F26:F28)","v":0},null,null,null,null,null,0]
[null,null,null,"TOTAAL ",null,{"$f":"SUM(E29:F29)","v":0},null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J81/IF(K81=\"hoog\",1.21,IF(K81=\"laag\",1.06,1)),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Factuur","index":2,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[6,4,6,6],[13,5,13,6],[15,5,15,6],[52,1,52,6],[0,5,0,6],[1,4,1,6],[2,4,2,6],[3,4,3,6],[4,4,4,6],[5,4,5,6]]}
[]
[null,null,"Excel Tekst en Uitleg",null,"Mussenveld 129"]
[null,null,"adviseren, ontwerpen, trainen",null,"7827 AJ Emmen"]
[]
[null,null,"Wim de Groot",null,"wdegroot@home.nl"]
[null,null,"denkt buiten de hokjes",null,"www.exceltekstenuitleg.nl"]
[null,null,null,null,"KvK. nr. 01129273"]
[]
[]
[]
[]
[]
[]
[null,"(hier komt de naam)",null,null,"Factuurnr.:","(automatisch)"]
[null,"(hier komt de aanvulling)"]
[null,"(hier komt het adres)",null,null,"Datum:","(automatisch)"]
[null,"(hier komt PC Woonplaats)"]
[]
[]
[null,"Betreft:"]
[null,"Datum:","Omschrijving","Aantal","Prijs per stuk","Bedrag ex BTW","BTW tarief"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,0,0,0]
[null,null,null,null,null,"ex BTW","BTW"]
[null,null,null,null,"BTW 21%","bedragen"]
[null,null,null,null,"BTW 6%","verschijnen"]
[null,null,null,null,"BTW 0%","automatisch "]
[null,null,null,null,"Subtotaal"]
[null,null,null,null,"TOTAAL "]
[]
[]
[]
[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. \"&F14","v":"onder vermelding van: Factuurnr. (automatisch)"}]

{"sheet":"Alle Facturen","index":3,"n_rows":100,"n_cols":21,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,11,0,14],[0,15,0,17],[0,20,1,20],[0,0,0,3],[0,4,0,6]]}
["Facturen VERKOOP",null,null,null,"Bedrag zonder BTW",null,null,"BTW","Totaal factuur",null,null,"Facturen INKOOP",null,null,null,"Bedrag zonder BTW",null,null,"BTW","Totaal factuur","naar BTW-aangifte >>"]
["Factuurdatum","Factuurnr.","Betreft","Naam","tegen 21%","tegen 6%","tegen 0%","bedraagt","met BTW","Betaald op:",null,"Factuurdatum:","Factuurnr.","Betreft","Naam leverancier","tegen 21%","tegen 6%","tegen 0%","bedraagt","met BTW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(P3*21%,2)+ROUND(Q3*6%,2)","v":0},{"$f":"SUM(P3:S3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(P35*21%,2)+ROUND(Q35*6%,2)","v":0},{"$f":"SUM(P35:S35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(P67*21%,2)+ROUND(Q67*6%,2)","v":0},{"$f":"SUM(P67:S67)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(P99:S99)","v":0},"Hebt u meer Inkoop-facturen?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"Kopieer dan deze twee gele cellen omlaag."]

{"sheet":"BTW","index":4,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,8,2,11],[28,3,28,4],[30,3,30,4],[0,1,0,6],[3,8,3,11],[9,8,9,11]]}
[null,"BTW aangifte"]
[null,"Jaar:",2017]
[null,null,"Eerste kwartaal","Tweede kwartaal","Derde kwartaal","Vierde kwartaal",null,null,"BTW omrekenen"]
[null,"van",{"$f":"DATE(C2,1,1)","v":"2017-01-01"},{"$f":"DATE(C2,4,1)","v":"2017-04-01"},{"$f":"DATE(C2,7,1)","v":"2017-07-01"},{"$f":"DATE(C2,10,1)","v":"2017-10-01"},null,null,"van inclusief naar exclusief"]
[null,"tot",{"$f":"DATE(C2,3,31)","v":"2017-03-31"},{"$f":"DATE(C2,6,30)","v":"2017-06-30"},{"$f":"DATE(C2,9,30)","v":"2017-09-30"},{"$f":"DATE(C2,12,31)","v":"2017-12-31"},null,null,null,null,"Kies tarief:"]
[null,"VERKOOP",null,null,null,null,null,null,"Bedrag incl. BTW:",1060,"laag"]
[null,"Leveringen/diensten belast met:",null,null,null,null,null,null,"Bedrag excl. BTW",{"$f":"ROUND(IF(K6=\"hoog\",J6/1.21,J6/1.06),2)","v":1000}]
[null,0.21,{"$f":"SUMIFS('Alle Facturen'!E:E,'Alle Facturen'!A:A,\">=\"&C4,'Alle Facturen'!A:A,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!E:E,'Alle Facturen'!A:A,\">=\"&D4,'Alle Facturen'!A:A,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!E:E,'Alle Facturen'!A:A,\">=\"&E4,'Alle Facturen'!A:A,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!E:E,'Alle Facturen'!A:A,\">=\"&F4,'Alle Facturen'!A:A,\"<=\"&F5)","v":0},null,null,"BTW bedraagt",{"$f":"J6-J7","v":60}]
[null,0.06,{"$f":"SUMIFS('Alle Facturen'!F:F,'Alle Facturen'!A:A,\">=\"&C4,'Alle Facturen'!A:A,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!F:F,'Alle Facturen'!A:A,\">=\"&D4,'Alle Facturen'!A:A,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!F:F,'Alle Facturen'!A:A,\">=\"&E4,'Alle Facturen'!A:A,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!F:F,'Alle Facturen'!A:A,\">=\"&F4,'Alle Facturen'!A:A,\"<=\"&F5)","v":0}]
[null,"0% of niet bij u belast",{"$f":"SUMIFS('Alle Facturen'!G:G,'Alle Facturen'!A:A,\">=\"&C4,'Alle Facturen'!A:A,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!G:G,'Alle Facturen'!A:A,\">=\"&D4,'Alle Facturen'!A:A,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!G:G,'Alle Facturen'!A:A,\">=\"&E4,'Alle Facturen'!A:A,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!G:G,'Alle Facturen'!A:A,\">=\"&F4,'Alle Facturen'!A:A,\"<=\"&F5)","v":0},null,null,"van exclusief naar inclusief"]
[null,"Verschuldigde omzetbelasting",null,null,null,null,null,null,null,null,"Kies tarief:"]
[null,0.21,{"$f":"ROUND(C8*21%,0)","v":0},{"$f":"ROUND(D8*21%,0)","v":0},{"$f":"ROUND(E8*21%,0)","v":0},{"$f":"ROUND(F8*21%,0)","v":0},null,null,"Bedrag excl. BTW:",1000,"hoog"]
[null,0.06,{"$f":"ROUND(C9*6%,0)","v":0},{"$f":"ROUND(D9*6%,0)","v":0},{"$f":"ROUND(E9*6%,0)","v":0},{"$f":"ROUND(F9*6%,0)","v":0},"+",null,"Bedrag incl. BTW",{"$f":"ROUND(IF(K12=\"hoog\",J12*1.21,J12*1.06),2)","v":1210}]
[null,"Totaal",{"$f":"SUM(C12:C13)","v":0},{"$f":"SUM(D12:D13)","v":0},0,0,null,null,"BTW bedraagt",{"$f":"J13-J12","v":210}]
[null,"INKOOP"]
[null,"Leveringen/diensten belast met:"]
[null,0.21,{"$f":"SUMIFS('Alle Facturen'!P:P,'Alle Facturen'!L:L,\">=\"&C4,'Alle Facturen'!L:L,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!P:P,'Alle Facturen'!L:L,\">=\"&D4,'Alle Facturen'!L:L,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!P:P,'Alle Facturen'!L:L,\">=\"&E4,'Alle Facturen'!L:L,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!P:P,'Alle Facturen'!L:L,\">=\"&F4,'Alle Facturen'!L:L,\"<=\"&F5)","v":0}]
[null,0.06,{"$f":"SUMIFS('Alle Facturen'!Q:Q,'Alle Facturen'!L:L,\">=\"&C4,'Alle Facturen'!L:L,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!Q:Q,'Alle Facturen'!L:L,\">=\"&D4,'Alle Facturen'!L:L,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!Q:Q,'Alle Facturen'!L:L,\">=\"&E4,'Alle Facturen'!L:L,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!Q:Q,'Alle Facturen'!L:L,\">=\"&F4,'Alle Facturen'!L:L,\"<=\"&F5)","v":0}]
[null,"0% of niet bij u belast",{"$f":"SUMIFS('Alle Facturen'!R:R,'Alle Facturen'!L:L,\">=\"&C4,'Alle Facturen'!L:L,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!R:R,'Alle Facturen'!L:L,\">=\"&D4,'Alle Facturen'!L:L,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!R:R,'Alle Facturen'!L:L,\">=\"&E4,'Alle Facturen'!L:L,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!R:R,'Alle Facturen'!L:L,\">=\"&F4,'Alle Facturen'!L:L,\"<=\"&F5)","v":0}]
[null,"Betaalde voorbelasting"]
[null,0.21,{"$f":"ROUND(C17*21%,0)","v":0},{"$f":"ROUND(D17*21%,0)","v":0},{"$f":"ROUND(E17*21%,0)","v":0},{"$f":"ROUND(F17*21%,0)","v":0}]
[null,0.06,{"$f":"ROUND(C18*6%,0)","v":0},{"$f":"ROUND(D18*6%,0)","v":0},{"$f":"ROUND(E18*6%,0)","v":0},{"$f":"ROUND(F18*6%,0)","v":0},"+"]
[null,"Totaal",{"$f":"SUM(C21:C22)","v":0},{"$f":"SUM(D21:D22)","v":0},{"$f":"SUM(E21:E22)","v":0},{"$f":"SUM(F21:F22)","v":0}]
[]
[null,"Verschuldigde omzetbelasting",{"$f":"C14","v":0},{"$f":"D14","v":0},0,0]
[null,"Betaalde voorbelasting",{"$f":"C23","v":0},{"$f":"D23","v":0},0,0,"-"]
[null,"Subtotaal",{"$f":"C25-C26","v":0},{"$f":"D25-D26","v":0},0,0]
[null,null,{"$f":"IF(C27>=0,\"Te betalen\",\"Terug te vragen\")","v":"Te betalen"},{"$f":"IF(D27>=0,\"Te betalen\",\"Terug te vragen\")","v":"Te betalen"},"Te betalen","Te betalen"]
[null,null,null,"Totaal hele jaar",null,{"$f":"SUM(C27:F27)","v":0}]
[null,null,null,null,"Vermindering volgens Kleine Ondernemers Regeling:",{"$f":"IF(F29<1345,F29,IF(F29<1883,2.5*(1883-F29),0))","v":0},"-"]
[null,null,null,"Te betalen",null,{"$f":"F29-F30","v":0}]