{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Factuur Opstellen","Factuur","Alle Facturen","BTW"],"not_rendered":{"charts":0,"images":0,"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":"Factuur Opstellen","index":0,"n_rows":200,"n_cols":16,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[null,"Kies hieronder de klant:",null,null,null,null,null,"Omschrijving","prijs per stuk:","tarief","ex btw",null,"Naam","aanvulling","Adres","Postcode Plaats"]
[null,null,null,null,null,null,null,"Bezorgkosten plaatselijk",8,"geen",{"$f":"I2/IF(J2=\"hoog\",1.21,IF(J2=\"laag\",1.09,1))","v":8},null,"ComputerIdee","T.a.v. D. van der Schraaf","Richard Holkade 8","2033 PZ Haarlem"]
[null,{"$f":"VLOOKUP(B2,M:P,2,0)","v":{"$error":"#N/A"}},null,"Datum en factuurnummer",null,null,null,"Bezorgkosten regio",16,"geen",{"$f":"I3/IF(J3=\"hoog\",1.21,IF(J3=\"laag\",1.09,1))","v":16},null,"Excel Tekst en Uitleg","Wim de Groot, trainer"]
[null,{"$f":"VLOOKUP(B2,M:P,3,0)","v":{"$error":"#N/A"}},null,"komen automatisch op de factuur",null,null,null,"Bloemstuk blauw/oranje",25,"hoog",{"$f":"I4/IF(J4=\"hoog\",1.21,IF(J4=\"laag\",1.09,1))","v":20.66115702479339}]
[null,{"$f":"VLOOKUP(B2,M:P,4,0)","v":{"$error":"#N/A"}},null,null,null,null,null,"Bloemstuk geel/paars",25,"hoog",20.66115702479339]
["Betreft:",null,null,null,null,null,null,"Bloemstuk rood/groen",25,"hoog",20.66115702479339]
["Datum:","Omschrijving","Aantal:","Prijs per stuk","Bedrag ex BTW","btw:",null,"Bloemstuk Anthurium",25,"hoog",20.66115702479339]
[null,null,null,{"$f":"IFERROR(VLOOKUP(B8,H:K,4,0),0)","v":0},{"$f":"C8*D8","v":0},{"$f":"IFERROR(VLOOKUP(B8,H:K,3,0),0)","v":0},null,"Boeket gele rozen",10,"laag",9.1743119266055047]
[null,null,null,0,{"$f":"C9*D9","v":0},0,null,"Boeket rode rozen",10,"laag",9.1743119266055047]
[null,null,null,0,0,0,null,"Boeket rozen/gipskruid",12,"laag",11.009174311926605]
[null,null,null,0,0,0,null,"Boeket witte rozen",10,"laag",9.1743119266055047]
[null,null,null,0,0,0,null,"Boeket rozen zalmkleur",10,"laag",9.1743119266055047]
[null,null,null,0,0,0,null,"Boeket gemengde rozen",12,"laag",11.009174311926605]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,0,0,0,null,null,null,null,0]
[null,null,null,"Subtotaal","ex btw","btw",null,null,null,null,0]
[null,null,null,"btw 21%",{"$f":"SUMIF(F8:F24,\"hoog\",E8:E24)","v":0},{"$f":"E26*21%","v":0},null,null,null,null,0]
[null,null,null,"btw 9%",{"$f":"SUMIF(F8:F24,\"laag\",E8:E24)","v":0},{"$f":"E27*9%","v":0},null,null,null,null,0]
[null,null,null,"btw-vrij",{"$f":"SUMIF(F8:F24,\"geen\",E8:E24)","v":0},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,0]
[null,null,null,"TOTAAL ",null,{"$f":"E29+ F29","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I67/IF(J67=\"hoog\",1.21,IF(J67=\"laag\",1.09,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I131/IF(J131=\"hoog\",1.21,IF(J131=\"laag\",1.09,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I195/IF(J195=\"hoog\",1.21,IF(J195=\"laag\",1.09,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Factuur","index":1,"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],[7,1,7,6]]}
[]
[null,null,"Uw bedrijfsnaam",null,"adres"]
[null,null,null,null,"PC Woonplaats"]
[null,"(logo)"]
[null,null,"en andere tekst",null,"e-mailadres@provider.nl"]
[null,null,null,null,"www.uw website.nl"]
[null,null,null,null,"KvK. nr. 0123456"]
[null,"Pas het deel hierboven aan. EN VUL ONDER AAN DIT BLAD UW BANKNUMMER EN NAAM IN!"]
[]
[]
[]
[]
[]
[null,"(naam)",null,null,"Factuurnr.:","verschijnt automatisch "]
[null,"(contactpersoon)"]
[null,"(Adres)",null,null,"Datum:","verschijnt automatisch "]
[null,"(PC Woonplaats)"]
[]
[]
[null,"Betreft:"]
[null,"Datum","Omschrijving","Aantal","Prijs per stuk","Bedrag ex BTW","BTW tarief"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Betaling binnen 14 dagen op rekeningnr. NL ####"]
[null,null,"t.n.v. ## Uw Bedrijf ##"]
[null,null,{"$f":"\"onder vermelding van: Factuurnr. \"&F14","v":"onder vermelding van: Factuurnr. verschijnt automatisch "}]

{"sheet":"Alle Facturen","index":2,"n_rows":100,"n_cols":22,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,16,0,18],[0,21,1,21],[0,5,0,7],[0,11,0,15],[0,0,0,4]]}
["Facturen VERKOOP",null,null,null,null,"Bedrag zonder btw",null,null,"btw","Totaal factuur",null,"Facturen INKOOP",null,null,null,null,"Bedrag zonder btw",null,null,"btw","Totaal factuur","naar btw-aangifte >>"]
["Factuurdatum","Factuurnr.","Betreft","Naam","Ontvangen op:","tegen 21%","tegen 9%","geen btw","bedraagt","met btw",null,"Factuurdatum:","Factuurnr.","Betreft","Naam leverancier","Betaald op:","tegen 21%","tegen 9%","geen btw","bedraagt","met btw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Q3*21%,2)+ROUND(R3*9%,2)","v":0},{"$f":"SUM(Q3:T3)","v":0}]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,{"$f":"ROUND(Q35*21%,2)+ROUND(R35*9%,2)","v":0},{"$f":"SUM(Q35:T35)","v":0}]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,{"$f":"ROUND(Q67*21%,2)+ROUND(R67*9%,2)","v":0},{"$f":"SUM(Q67:T67)","v":0}]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,0]
[null,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,null,0,{"$f":"SUM(Q99:T99)","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,null,0,0,"Kopieer dan deze twee gele cellen omlaag."]

{"sheet":"BTW","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,8,2,11],[29,3,29,4],[0,1,0,6],[3,8,3,11],[9,8,9,11]]}
[null,"btw aangifte"]
[null,"Jaar:",2020]
[null,null,"Eerste kwartaal","Tweede kwartaal","Derde kwartaal","Vierde kwartaal",null,null,"btw omrekenen"]
[null,"van",{"$f":"DATE(C2,1,1)","v":"2020-01-01"},{"$f":"DATE(C2,4,1)","v":"2020-04-01"},{"$f":"DATE(C2,7,1)","v":"2020-07-01"},{"$f":"DATE(C2,10,1)","v":"2020-10-01"},null,null,"van inclusief naar exclusief"]
[null,"tot",{"$f":"DATE(C2,3,31)","v":"2020-03-31"},{"$f":"DATE(C2,6,30)","v":"2020-06-30"},{"$f":"DATE(C2,9,30)","v":"2020-09-30"},{"$f":"DATE(C2,12,31)","v":"2020-12-31"},null,null,null,null,"Kies tarief:"]
[null,"VERKOOP",null,null,null,null,null,null,"Bedrag incl. btw:",1090,"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.09),2)","v":1000}]
[null,0.21,{"$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,null,"btw bedraagt",{"$f":"J6-J7","v":90}]
[null,0.09,{"$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,"0% of btw-vrij",{"$f":"SUMIFS('Alle Facturen'!H:H,'Alle Facturen'!A:A,\">=\"&C4,'Alle Facturen'!A:A,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!H:H,'Alle Facturen'!A:A,\">=\"&D4,'Alle Facturen'!A:A,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!H:H,'Alle Facturen'!A:A,\">=\"&E4,'Alle Facturen'!A:A,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!H:H,'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":"C8*21%","v":0},0,0,0,null,null,"Bedrag excl. btw:",1000,"hoog"]
[null,0.09,{"$f":"C9*9%","v":0},0,0,0,"+",null,"Bedrag incl. btw",{"$f":"ROUND(IF(K12=\"hoog\",J12*1.21,J12*1.09),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'!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.09,{"$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,"0% of btw-vrij",{"$f":"SUMIFS('Alle Facturen'!S:S,'Alle Facturen'!L:L,\">=\"&C4,'Alle Facturen'!L:L,\"<=\"&C5)","v":0},{"$f":"SUMIFS('Alle Facturen'!S:S,'Alle Facturen'!L:L,\">=\"&D4,'Alle Facturen'!L:L,\"<=\"&D5)","v":0},{"$f":"SUMIFS('Alle Facturen'!S:S,'Alle Facturen'!L:L,\">=\"&E4,'Alle Facturen'!L:L,\"<=\"&E5)","v":0},{"$f":"SUMIFS('Alle Facturen'!S:S,'Alle Facturen'!L:L,\">=\"&F4,'Alle Facturen'!L:L,\"<=\"&F5)","v":0}]
[null,"Betaalde voorbelasting"]
[null,0.21,{"$f":"C17*21%","v":0},0,0,0]
[null,0.09,{"$f":"C18*9%","v":0},0,0,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":"TRUNC(C14)","v":0},0,0,0]
[null,"Betaalde voorbelasting",{"$f":"ROUNDUP(C23,0)","v":0},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}]