{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FACTUUR INVOER","FACTUURLIJST","Factuur"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"FACTUUR INVOER","index":0,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[46,2,46,3],[21,0,22,0],[21,1,22,1],[21,2,22,2],[19,0,19,7]]}
["TTAS",null,null,null,null,null,null,"FACTUUR"]
["HOOGSTRAAT 170"]
["BE-9100 MECHELEN",null,null,null,null,"FACTUURNR.",null,"201903-005"]
["BELGIE"]
[null,null,null,null,null,"FACTUURDATUM",null,"2019-03-06"]
["GSM 0477 583 713"]
["Btw-nr. BE 0456 777 888"]
["ANDRE.VAN.DRIESSE@TELENET.BE"]
[]
[]
[null,null,null,null,"WILLY DE WITTE"]
[null,null,null,null,"DIENST BOEKHOUDEN"]
[null,null,null,null,"LANGSTRAAT 45"]
[null,null,null,null,"9400 VILVOORDE"]
[null,null,null,null,"BELGIE"]
[null,null,null,null,"BE 0342 345 876"]
[]
[]
[]
["Werf nr 190 maart 2019"]
[]
["Omschrijving","Uren","Euro/uur","Procent","BTW","BTW","BTW","BTW"]
[null,null,null,"Toeslag","Exclusief","Tarief","Bedrag","Inclusief"]
[null,null,null,null,{"$f":"SUM(($B$24*$C$24)*(1+$D24))","v":0},null,{"$f":"$E$24*$F$24","v":0},{"$f":"IF($F$24=\"\",\"\",$E$24+$G$24)","v":""}]
[null,null,null,null,{"$f":"SUM(($B$25*$C$25)*(1+$D25))","v":0},null,{"$f":"$E$25*$F$25","v":0},{"$f":"IF($F$25=\"\",\"\",$E25+$G$25)","v":""}]
[null,null,null,null,{"$f":"SUM(($B$26*$C$26)*(1+$D26))","v":0},null,{"$f":"$E$26*$F$26","v":0},{"$f":"IF(F26=\"\",\"\",E26+G26)","v":""}]
[null,null,null,null,{"$f":"SUM(($B$27*$C$27)*(1+$D27))","v":0},null,{"$f":"$E$27*$F$27","v":0},{"$f":"IF($F$27=\"\",\"\",$E$27+$G$27)","v":""},null,null,"201903-001","FACTUUR NR"]
["Gepresteerde gewone uren",140.5,32,null,{"$f":"SUM(($B$28*$C$28)*(1+$D$28))","v":4496},0.21,{"$f":"$E$28*$F$28","v":944.16},{"$f":"IF($F$28=\"\",\"\",$E$28+$G$28)","v":5440.16},null,null,"2019-03-06","DATUM KLANT BETAALD"]
[null,null,null,null,{"$f":"SUM(($B$29*$C$29)*(1+$D$29))","v":0},null,{"$f":"$E$29*$F$29","v":0},{"$f":"IF($F$29=\"\",\"\",$E$29+$G$29)","v":""},null,null,"Bankuitrekselnr  15 / 3","INVOEREN"]
[null,null,null,null,{"$f":"SUM(($B$30*$C$30)*(1+$D$30))","v":0},null,{"$f":"$E$30*$F$30","v":0},{"$f":"IF($F$30=\"\",\"\",$E$30+$G$30)","v":""},null,null,"OK BETAALD","STATUS"]
[null,null,null,null,{"$f":"SUM(($B$31*$C$31)*(1+$D$31))","v":0},null,{"$f":"$E$31*$F$31","v":0},{"$f":"IF($F$31=\"\",\"\",$E$31+$G$31)","v":""}]
[null,null,null,null,{"$f":"SUM((B32*C32)+((B32*C32)*D32))","v":0},null,{"$f":"E32*F32","v":0},{"$f":"IF(F32=\"\",\"\",E32+G32)","v":""}]
[null,null,null,null,0,null,{"$f":"E33*F33","v":0},{"$f":"IF(F33=\"\",\"\",E33+G33)","v":""}]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,{"$f":"E36*F36","v":0},""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,{"$f":"SUM((B44*C44)+((B44*C44)*D44))","v":0},null,0,""]
[null,null,null,null,{"$f":"SUM((B45*C45)+((B45*C45)*D45))","v":0},null,{"$f":"E45*F45","v":0},""]
[null,null,null,null,{"$f":"SUM(E24:E45)","v":4496},null,{"$f":"SUM(G24:G45)","v":944.16}]
["TOTAAL TE BETALEN",null,null,null,null,null,null,{"$f":"SUM($H$24:$H$45)","v":5440.16}]
[]
[null,null,null,null,"BTW aan",{"$f":"IFERROR(VLOOKUP(21%,$F$24:$F$45,1,0),\"\")","v":0.21},{"$f":"(SUMIF($F$24:$F$45,0.21,$G$24:$G$45))","v":944.16}]
["ING Bank  IBAN BE80 9514 7536 8526",null,null,null,null,{"$f":"IFERROR(VLOOKUP(19%,$F$24:$F$45,1,0),\"\")","v":""},{"$f":"(SUMIF($F$24:$F$45,0.19,$G$24:$G$45))","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(6%,$F$24:$F$45,1,0),\"\")","v":""},{"$f":"(SUMIF($F$24:$F$45,0.06,$G$24:$G$45))","v":0}]
["U wordt verzocht het vermelde bedrag binnen de 30 dagen over te maken"]
["op het onderstaande rekeningnummer met vermelding van factuurnummer"]

{"sheet":"FACTUURLIJST","index":1,"n_rows":11,"n_cols":40,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Nr",null,"Vervaldatum","Overschreden",null,"Datum","Bankuitrek","Status","FACTUUR NR","DATUM",null,"FACTUUR ",null,"OMSCHRIJVING",null,"Exclusief BTW","Creditnota",null,"BTW Tarief(a)","BTW Bedrag(a)","Creditnota(a)",null,"BTW Tarief(b)","BTW Bedrag(b)","Creditnota(b)",null,"BTW Tarief(c)","BTW Bedrag(c)","Creditnota(c)",null,"Totaal","Creditnota(d)",null,"FIRMANAAM","DIENST BOEKHOUDEN","STRAAT + NR","POSTCODE + GEMEENTE","LAND","BTW nummer","Mnd"]
[null,null,null,"bedrag",null,"Klant betaald",null,null,null,null,null,"CREDITNOTA",null,null,null,{"$f":"SUM(P4-Q4)","v":22480},null,null,null,{"$f":"SUM(T4-U4)","v":4720.8},null,null,null,{"$f":"SUM(X4-Y4)","v":0},null,null,null,{"$f":"SUM(AB4-AC4)","v":0},null,null,{"$f":"SUM(AE4-AF4)","v":27200.799999999999}]
[null,null,null,null,null,"Factuur",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":"SUM($P$7:$P$994)","v":22480},{"$f":"SUM($Q$7:$Q$994)","v":0},null,null,{"$f":"SUM($T$7:$T$994)","v":4720.8},{"$f":"SUM($U$7:$U$994)","v":0},null,null,{"$f":"SUM($X$7:$X$994)","v":0},{"$f":"SUM($Y$7:$Y$994)","v":0},null,null,{"$f":"SUM($AB$7:$AB$994)","v":0},{"$f":"SUM($AC$7:$AC$994)","v":0},null,{"$f":"SUM($AE$7:$AE$994)","v":27200.799999999999},{"$f":"SUM($AF$7:$AF$994)","v":0}]
[]
[0,null,null,null,null,null,null,null,"FACTUUR NR"]
[{"$f":"IF($I7=\"\",\"\",1+$A6)","v":1},null,"2019-04-05",{"$f":"SUMIF(C7,\"<\"&TODAY(),AE7)","v":0},null,"2019-03-06","Bankuitrekselnr 15 / 3","Ok Betaald","201903-001","2019-03-02",null,"FACTUUR",null,"Werf nr 190 maart 2019",null,4496,null,null,0.21,944.16,null,null,"",0,null,null,"",0,null,null,5440.16,null,null,"WILLY DE WITTE","DIENST BOEKHOUDEN","LANGSTRAAT 45","9400 VILVOORDE","BELGIE","BE 0342 345 876",{"$f":"MONTH(J7)","v":3}]
[{"$f":"IF($I8=\"\",\"\",1+$A7)","v":2},null,"2019-04-05",{"$f":"SUMIF(C8,\"<\"&TODAY(),AE8)","v":0},null,null,null,null,"201903-002","2019-03-02",null,"FACTUUR",null,"Werf nr 190 maart 2019",null,4496,null,null,0.21,944.16,null,null,"",0,null,null,"",0,null,null,5440.16,null,null,"WILLY DE WITTE","DIENST BOEKHOUDEN","LANGSTRAAT 45","9400 VILVOORDE","BELGIE","BE 0342 345 876",{"$f":"MONTH(J8)","v":3}]
[{"$f":"IF($I9=\"\",\"\",1+$A8)","v":3},null,"2019-04-05",{"$f":"SUMIF(C9,\"<\"&TODAY(),AE9)","v":0},null,null,null,null,"201903-003","2019-03-03",null,"FACTUUR",null,"Werf nr 190 maart 2019",null,4496,null,null,0.21,944.16,null,null,"",0,null,null,"",0,null,null,5440.16,null,null,"WILLY DE WITTE","DIENST BOEKHOUDEN","LANGSTRAAT 45","9400 VILVOORDE","BELGIE","BE 0342 345 876",{"$f":"MONTH(J9)","v":3}]
[{"$f":"IF($I10=\"\",\"\",1+$A9)","v":4},null,"2019-04-05",{"$f":"SUMIF(C10,\"<\"&TODAY(),AE10)","v":0},null,null,null,null,"201903-004","2019-03-03",null,"FACTUUR",null,"Werf nr 190 maart 2019",null,4496,null,null,0.21,944.16,null,null,"",0,null,null,"",0,null,null,5440.16,null,null,"WILLY DE WITTE","DIENST BOEKHOUDEN","LANGSTRAAT 45","9400 VILVOORDE","BELGIE","BE 0342 345 876",{"$f":"MONTH(J10)","v":3}]
[{"$f":"IF($I11=\"\",\"\",1+$A10)","v":5},null,"2019-04-05",{"$f":"SUMIF(C11,\"<\"&TODAY(),AE11)","v":0},null,null,null,null,"201903-005","2019-03-04",null,"FACTUUR",null,"Werf nr 190 maart 2019",null,4496,null,null,0.21,944.16,null,null,"",0,null,null,"",0,null,null,5440.16,null,null,"WILLY DE WITTE","DIENST BOEKHOUDEN","LANGSTRAAT 45","9400 VILVOORDE","BELGIE","BE 0342 345 876",{"$f":"MONTH(J11)","v":3}]

{"sheet":"Factuur","index":2,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":true,"merged":[[21,0,22,0],[21,1,22,1],[21,2,22,2],[46,2,46,3],[19,0,19,7]]}
["A.V.D.",null,null,null,null,null,null,"FACTUUR"]
["HOOGSTRAAT 170"]
["BE-9100 SINT-NIKLAAS",null,null,null,null,"FACTUURNR.",null,"201902-074"]
["BELGIE"]
[null,null,null,null,null,"FACTUURDATUM",null,"2019-02-10"]
["GSM 0477 583 713"]
["Btw-nr. BE 0456 777 888"]
["ANDRE.VAN.DRIESSE@TELENET.BE"]
[]
[]
[null,null,null,null,"VAN DEN BORRE"]
[null,null,null,null,"DIENST BOEKHOUDEN"]
[null,null,null,null,"KALKSTRAAT 78"]
[null,null,null,null,"4620 SINT-NIKLAAS"]
[null,null,null,null,"BELGIE"]
[null,null,null,null,"BE 3456 987 123"]
[]
[]
[]
["Werf Lanxess Bayer nr 190 januari 2019"]
[]
["Omschrijving","Uren","Euro/uur","Procent","BTW","BTW","BTW","BTW"]
[null,null,null,"Toeslag","Exclusief","Tarief","Bedrag","Inclusief"]
[null,null,null,null,0,null,0,{"$f":"IF(F24=\"\",\"\",E24+G24)","v":""}]
[null,null,null,null,0,null,0,{"$f":"IF(F25=\"\",\"\",E25+G25)","v":""}]
[null,null,null,null,0,null,0,{"$f":"IF(F26=\"\",\"\",E26+G26)","v":""}]
[null,null,null,null,0,null,0,{"$f":"IF(F27=\"\",\"\",E27+G27)","v":""}]
["Gepresteerde gewone uren",140.5,32,null,4496,0.21,944.16,{"$f":"IF($F$28=\"\",\"\",$E$28+$G$28)","v":5440.16}]
["overuren (8) + 1 ste uur (geen toeslag)",4,32,null,128,0.21,26.88,{"$f":"IF(F29=\"\",\"\",E29+G29)","v":154.88}]
["overuren (8) + vanaf 2de uur",3,32,0.5,144,0.21,30.24,174.24]
[null,2,5,0.5,15,0.21,3.15,18.149999999999999]
["Zaterdagen",8,32,0.5,384,0.19,72.959999999999994,456.96]
["Zondagen",8,32,0.5,384,0.21,80.64,464.64]
[null,null,null,null,0,null,0,""]
["Feestdagen",8,32,1,512,0.06,30.72,542.72]
[null,null,null,null,0,null,0,""]
["Gepresteerd ploegwerk",null,null,null,0,null,0,""]
["Gepresteerd nachtwerk",null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,0,null,0,""]
[null,null,null,null,{"$f":"SUM(E24:E45)","v":6063},null,{"$f":"SUM(G24:G45)","v":1188.75}]
["TOTAAL TE BETALEN",null,null,null,null,null,null,{"$f":"SUM($H$24:$H$45)","v":7251.75}]
[]
[null,null,null,null,"BTW aan",{"$f":"IFERROR(VLOOKUP(21%,$F$24:$F$45,1,0),\"\")","v":0.21},{"$f":"(SUMIF($F$24:$F$45,0.21,$G$24:$G$45))","v":1085.07}]
["Recordbank  IBAN BE80 9514 7536 8526",null,null,null,null,{"$f":"IFERROR(VLOOKUP(19%,$F$24:$F$45,1,0),\"\")","v":0.19},{"$f":"(SUMIF($F$24:$F$45,0.19,$G$24:$G$45))","v":72.959999999999994}]
[null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(6%,$F$24:$F$45,1,0),\"\")","v":0.06},{"$f":"(SUMIF($F$24:$F$45,0.06,$G$24:$G$45))","v":30.72}]
["U wordt verzocht het vermelde bedrag binnen de 30 dagen over te maken"]
["op het onderstaande rekeningnummer met vermelding van factuurnummer"]