{"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":2445,"n_cols":8,"rows_kept":2445,"cut":false,"hidden":false,"merged":[[46,2,46,3],[21,0,22,0],[21,1,22,1],[21,2,22,2]]}
[null,null,null,null,null,null,null,"FACTUUR"]
[]
[null,null,null,null,null,"FACTUURNR.",null,"202001-011"]
[]
[null,null,null,null,null,"FACTUURDATUM",null,"2020-01-31"]
[]
[]
[]
[]
[]
[null,null,null,null,"KEBERS BELGIE NV"]
[]
[]
[]
[]
[]
[]
[]
[]
["Werf Bayer"]
[]
["Omschrijving","Uren","Euro/uur","Procent","BTW","BTW","BTW","BTW"]
[null,null,null,"Toeslag","Exclusief","Tarief","Bedrag","Inclusief"]
["Gepresteerde gewone uren",10,35,null,{"$f":"SUM(($B24*$C24)*(1+$D24))","v":350},0.21,{"$f":"SUM($E24*$F24)","v":73.5},{"$f":"IF($F24=\"\",\"\",$E24+$G24)","v":423.5}]
[null,15,35,null,525,0.19,99.75,624.75]
[null,20,35,null,700,0.06,42,742]
[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,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,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($E$24:$E$45)","v":1575},null,{"$f":"SUM($G$24:$G$45)","v":215.25}]
["TOTAAL TE BETALEN",null,null,null,null,null,null,{"$f":"SUM($H$24:$H$45)","v":1790.25}]
[]
[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":73.5}]
[null,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":99.75}]
[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":42}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(($B2436*$C2436)*(1+$D2436))","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]

{"sheet":"FACTUURLIJST","index":1,"n_rows":17,"n_cols":42,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Nr",null,"Vervaldatum","Overschreden","Dagen te ",null,"Datum klant","Bankuitrekselnr","Status",null,"Nr fact/crednt","Datum fact/crednt","Naam dokument","Omschrijving",null,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,null,"Totaal","Creditnota(d)",null,"Firmanaam","Dienst boekhouden","Straat + nr","Postcode + Gemeente","Land","BTW nummer","Mnd"]
[null,null,null,"bedrag","laat betaald",null,"betaald fact",null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q4-R4)","v":17325},null,null,null,{"$f":"SUM(U4-V4)","v":808.5},null,null,null,{"$f":"SUM(Y4-Z4)","v":1097.25},null,null,null,{"$f":"SUM(AC4-AD4)","v":462},null,null,null,{"$f":"SUM(AG4-AH4)","v":19692.75}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($Q$7:$Q$1000)","v":17325},{"$f":"SUM($R$7:$R$1000)","v":0},null,null,{"$f":"SUM($U$7:$U$1000)","v":808.5},{"$f":"SUM($V$7:$V$1000)","v":0},null,null,{"$f":"SUM($Y$7:$Y$1000)","v":1097.25},{"$f":"SUM($Z$7:$Z$1000)","v":0},null,null,{"$f":"SUM($AC$7:$AC$1000)","v":462},{"$f":"SUM($AD$7:$AD$1000)","v":0},null,null,{"$f":"SUM($AG$7:$AG$1000)","v":19692.75},{"$f":"SUM($AH$7:$AH$1000)","v":0}]
[]
[0,null,null,null,null,null,null,null,null,null,"Factuur nr"]
[{"$f":"IF($K7=\"\",\"\",1+$A6)","v":1},null,"2020-03-01",{"$f":"IF(OR(G7=\"\")*TODAY()>=C7,AG7,\"\")","v":""},{"$f":"IF(AND(G7=\"\")*TODAY()>=C7,DAYS360(C7,TODAY()+1),IF(G7>=C7,DAYS360(C7,G7+1),\"\"))","v":""},null,null,null,null,null,"202001-001","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,{"$f":"MONTH(L7)","v":1}]
[2,null,"2020-03-01","","",null,null,null,null,null,"202001-002","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[3,null,"2020-03-01","","",null,null,null,null,null,"202001-003","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[4,null,"2020-03-01","","",null,null,null,null,null,"202001-004","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[5,null,"2020-03-01","","",null,null,null,null,null,"202001-005","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[6,null,"2020-03-01","","",null,null,null,null,null,"202001-006","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[7,null,"2020-03-01","","",null,null,null,null,null,"202001-007","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[8,null,"2020-03-01","","",null,null,null,null,null,"202001-008","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[9,null,"2020-03-01","","",null,null,null,null,null,"202001-009","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[10,null,"2020-03-01","","",null,null,null,null,null,"202001-010","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,1]
[{"$f":"IF($K17=\"\",\"\",1+$A16)","v":11},null,"2020-03-01",{"$f":"IF(OR(G17=\"\")*TODAY()>=C17,AG17,\"\")","v":""},{"$f":"IF(AND(G17=\"\")*TODAY()>=C17,DAYS360(C17,TODAY()+1),IF(G17>=C17,DAYS360(C17,G17+1),\"\"))","v":""},null,null,null,null,null,"202001-011","2020-01-31","FACTUUR","Werf Bayer",null,null,1575,null,null,0.21,73.5,null,null,0.19,99.75,null,null,0.06,42,null,null,null,1790.25,null,null,"KEBERS BELGIE NV",null,null,null,null,null,{"$f":"MONTH(L17)","v":1}]

{"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"]