{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["factuur","Herinnering","Aangetekende","klantenlisting"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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","index":0,"n_rows":447,"n_cols":19,"rows_kept":447,"cut":false,"hidden":false,"merged":[[446,0,446,13],[10,4,11,7],[10,3,11,3],[18,3,18,8],[10,1,11,2],[194,8,194,9],[3,10,3,12],[4,10,4,12],[17,6,17,7],[17,10,17,11],[53,12,53,13],[194,10,194,11],[175,2,175,5],[176,2,176,5],[177,2,177,5],[168,2,168,5],[169,2,169,5],[161,10,161,11],[162,10,162,11],[163,10,163,11],[164,10,164,11],[165,10,165,11],[166,10,166,11],[165,6,165,7],[14,12,14,13],[7,10,7,13],[8,10,8,13],[9,10,9,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,10,24,11],[29,10,29,11],[49,12,50,13],[49,7,50,11],[24,1,24,8],[26,1,26,8],[20,1,20,8],[30,1,30,8],[22,1,22,8],[28,1,28,8],[36,1,36,8],[35,10,35,11],[29,1,29,8],[31,1,31,8],[23,3,23,8],[25,3,25,8],[27,3,27,8],[32,10,32,11],[44,9,44,11],[36,10,36,11],[37,10,37,11],[28,10,28,11],[30,10,30,11],[31,10,31,11],[39,9,40,11],[163,2,163,5],[164,2,164,5],[158,6,158,7],[159,6,159,7],[160,6,160,7],[161,6,161,7],[161,2,161,5],[162,2,162,5],[158,2,158,5],[159,2,159,5],[160,2,160,5],[163,6,163,7],[164,6,164,7],[159,10,159,11],[160,10,160,11],[157,6,157,7],[53,3,53,9],[157,2,157,5],[56,3,56,7],[155,0,155,13],[62,0,62,13],[54,12,54,13],[158,10,158,11],[39,12,40,13],[43,3,43,8],[34,1,34,8],[35,1,35,8],[45,3,45,8],[37,1,37,8],[38,1,38,8],[47,3,47,8],[47,9,47,11],[45,9,45,11],[46,9,46,11],[46,3,46,8],[14,3,14,6],[18,10,18,11],[38,10,38,11],[33,10,33,11],[34,10,34,11],[171,2,171,5],[172,2,172,5],[173,2,173,5],[165,2,165,5],[166,2,166,5],[167,2,167,5],[172,6,172,7],[173,6,173,7],[32,1,32,8],[33,1,33,8],[25,10,25,11],[26,10,26,11],[27,10,27,11],[14,8,14,9],[16,1,16,13],[44,3,44,8],[44,12,47,13],[43,12,43,13],[43,9,43,11],[170,2,170,5],[174,2,174,5],[166,6,166,7],[167,6,167,7],[167,10,167,11],[168,6,168,7],[178,6,178,7],[175,6,175,7],[176,6,176,7],[169,6,169,7],[170,6,170,7],[174,6,174,7],[171,6,171,7],[168,10,168,11],[169,10,169,11],[170,10,170,11],[171,10,171,11],[172,10,172,11],[173,10,173,11],[174,10,174,11],[175,10,175,11],[176,10,176,11],[177,6,177,7],[6,10,6,14],[210,10,210,12],[184,6,184,7],[185,6,185,7],[186,6,186,7],[187,6,187,7],[188,6,188,7],[189,6,189,7],[190,6,190,7],[191,6,191,7],[192,6,192,7],[185,10,185,11],[186,10,186,11],[187,10,187,11],[188,10,188,11],[189,10,189,11],[190,10,190,11],[191,10,191,11],[180,6,180,7],[181,6,181,7],[182,6,182,7],[183,6,183,7],[183,10,183,11],[162,6,162,7],[192,10,192,11],[184,10,184,11],[177,10,177,11],[178,10,178,11],[179,10,179,11],[180,10,180,11],[187,2,187,5],[188,2,188,5],[189,2,189,5],[190,2,190,5],[191,2,191,5],[192,2,192,5],[182,2,182,5],[183,2,183,5],[184,2,184,5],[185,2,185,5],[186,2,186,5],[181,10,181,11],[182,10,182,11],[179,2,179,5],[179,6,179,7],[180,2,180,5],[181,2,181,5],[178,2,178,5],[196,0,196,14],[197,2,197,5],[197,6,197,7],[197,10,197,11],[198,2,198,5],[198,6,198,7],[198,10,198,11],[200,0,200,14],[201,2,201,5],[201,6,201,7],[201,10,201,11],[272,0,273,14],[274,0,274,14],[202,2,202,5],[202,6,202,7],[202,10,202,11],[203,2,203,5],[203,6,203,7],[203,10,203,11],[204,2,204,5],[204,6,204,7],[204,10,204,11],[393,0,394,14],[395,0,395,14],[325,0,325,13],[317,4,317,7],[438,4,438,7]]}
["2021-01-10","Markata",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"***",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"***",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"***",null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"},null,null,null,null,null,null,null,4]
[null,"Ondn°:",null,"***",null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(K7,klantenlisting!B:B,klantenlisting!A:A,\" \")","v":"cust-001"},null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"klant1",null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(K7,klantenlisting!B:B,klantenlisting!C:C,\" \")","v":"adres1"},null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(K7,klantenlisting!B:B,klantenlisting!D:D)","v":"postcode 1"},null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M10>0,\"Ondn°:\",\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(K7,klantenlisting!B:B,klantenlisting!G:G)","v":0},null,null,"Offerte :","of",null,10]
[null,"Factuur :",null,{"$f":"_xlfn.XLOOKUP(B11,P10:P14,Q10:Q14,\"\")","v":"vk"},"2021 - 0",null,null,null,null,null,null,null,null,null,null,"Order :","or",null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factuur :","vk",null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Creditnota :","cn",null,13]
[null,null,null,{"$f":"IF(B11=P10,\"Opmaakdatum :\",\"Datum :\")","v":"Datum :"},null,null,null,null,{"$f":"IF(B11=\"Factuur :\",\"Datum opeisbaarheid BTW :\",0)","v":"Datum opeisbaarheid BTW :"},null,null,null,{"$f":"IF(B11=\"Factuur :\",\"Leverdatum :\",0)","v":"Leverdatum :"},null,null,"Bestelbon :","bb",null,14]
[null,null,null,"22 februari 2021",null,null,null,null,{"$f":"IF(B11=\"Factuur :\",D15,0)","v":"22 februari 2021"},null,null,null,{"$f":"IF(AND(B11=\"Factuur :\",D15>1/1/2020),D15-15,\"\")","v":"2021-02-07"},null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null," Plaats levering of uitvoering werf :",null,null,null,null,null,null,null,null,null,null,null,null,null,",",null,null,17]
[null,"Diverse werven",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K8&\", \"&K9","v":"adres1, postcode 1"},null,null,18]
[null,"Artikel",null,"Aard goederen / werkuren",null,null,null,null,null,"Aantal","Eenheid",null,"Bedrag","BTW %",null,"Diverse werven",null,null,19]
[null,"Goederen",null,{"$f":"IF(B20=P34,\"(zie bijlage)\",\"\")","v":"(zie bijlage)"},null,null,null,null,null,{"$f":"IF(K7=\"VSS\",SUM(A159:A193),)","v":0},{"$f":"_xlfn.IFNA(INDEX($P$26:$Q$36,MATCH($B$20,$P$26:$P$36,0),2),0)","v":0},null,{"$f":"_xlfn.IFNA(SUM(J20*K20),0)","v":0},6,null,"Andere : ",null,null,20]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B21=\"\",Q26,B21=\"Werkuren\",Q27,B21=\"Levering\",Q28,B21=\"Verzending\",Q29,B21=\"Afhaling\",Q30,B21=\"Voorrijkosten\",Q31,B21=\"KM-vergoeding\",Q32)","v":0},null,null,null,null,"home adres",null,null,21]
[null,"Werkuren",null,{"$f":"IF(B22=P27,\"(zie bijlage)\",\"\")","v":"(zie bijlage)"},null,null,null,null,null,{"$f":"IF(K7=\"VSS\",SUM(B159:B193),)","v":0},{"$f":"_xlfn.IFNA(INDEX($P$26:$Q$36,MATCH($B$22,$P$26:$P$36,0),2),0)","v":100},null,{"$f":"_xlfn.IFNA(SUM(J22*K22),0)","v":0},6,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,"Voorrijkosten",null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G198>1/1/2020),SUM(J198:J199),0)","v":0},{"$f":"_xlfn.IFNA(INDEX($P$26:$Q$36,MATCH(B24,$P$26:$P$36,0),2),0)","v":3.363E-2},null,{"$f":"_xlfn.IFNA(SUM(J24*K24),0)","v":0},6,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,"KM-vergoeding",null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G202>1/1/2020),SUM(J202:J205),0)","v":0},{"$f":"_xlfn.IFNA(INDEX($P$26:$Q$36,MATCH(B26,$P$26:$P$36,0),2),0)","v":0.35420000000000001},null,{"$f":"_xlfn.IFNA(SUM(J26*K26),0)","v":0},6,null," ",0,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkuren",100,null,27]
[null," ",null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFNA(INDEX($P$26:$Q$36,MATCH($B$28,$P$26:$P$36,0),2),\"\")","v":0},null,{"$f":"_xlfn.IFNA(SUM(J28*K28),0)","v":0},null,null,"Levering",null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J29*K29)","v":0},null,null,"Verzending",0,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Afhaling",0,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Voorrijkosten",3.363E-2,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"KM-vergoeding",0.35420000000000001,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Maaltijd",30,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Goederen",{"$f":"K195","v":0},null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Gepresteerde dagen",450,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Gepresteerde lange dagen",525,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,"Totaal excl. BTW",null,null,{"$f":"SUM(M20:M39)","v":0},null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,"BTW %","Maatstaf van heffing",null,null,null,null,null,"Bedrag BTW",null,null,{"$f":"IF(B11=\"Creditnota :\",\"Terugbetaling van :\",\"Totaal te betalen :\")","v":"Totaal te betalen :"},null,null,null,null,null,44]
[null,"Medecontractant","O",{"$f":"SUM(IF(N20=0,M20,),IF(N22=0,M22,),IF(N24=0,M24,),IF(N26=0,M26,),IF(N28=0,M28,))","v":0},null,null,null,null,null,0,null,null,{"$f":"IF(B11=\"Creditnota :\",SUM(-(D48:L48)),SUM(D48:L48))","v":0},null,null,null,null,null,45]
[null,null,6,{"$f":"SUM(IF(N20=6,M20,),IF(N22=6,M22,),IF(N24=6,M24,),IF(N26=6,M26,),IF(N28=6,M26,))","v":0},null,null,null,null,null,{"$f":"SUM(D46*0.06)","v":0},null,null,null,null,null,null,null,null,46]
[null,null,21,{"$f":"SUM(IF(N20=21,M20,),IF(N22=21,M22,),IF(N24=21,M24,),IF(N26=21,M26,),IF(N28=21,M28,))","v":0},null,null,null,null,null,{"$f":"SUM(D47*0.21)","v":0},null,null,null,null,null,null,null,null,47]
[null,null,null,{"$f":"SUM(D45:I47)","v":0},null,null,null,null,null,{"$f":"SUM(J45:L47)","v":0},null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,{"$f":"IF(B11=\"Offerte :\",\"Minimum bedrag te voldoen voor akkoord :\",\"\")","v":""},null,null,null,null,{"$f":"IF(B11=\"Offerte :\",M45*0.3,\"\")","v":""},null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zakelijk","BE123456789",null,53]
[null,null,null,{"$f":"IF(OR(B11=P10,B11=P12),\"Netto te betalen op rekening :\",\"\")","v":"Netto te betalen op rekening :"},null,null,null,null,null,null,null,{"$f":"IF(OR(B11=P10,B11=P12),\"IBAN:  \",\"\")","v":"IBAN:  "},{"$f":"IF(OR(B11=P10,B11=P12),Q53,\"\")","v":"BE123456789"},null,null,"Privé","BE987654321",null,54]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(B11=P10,B11=P12),\"BIC:  \",\"\")","v":"BIC:  "},{"$f":"IF(OR(B11=P10,B11=P12),\"KREDBEBB\",\"\")","v":"KREDBEBB"},null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Offerte :\",\"Geldigheid :\",B11=\"Factuur :\",\"Factuurvoorwaarden :\",B11=\"Creditnota :\",\"\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"Factuurvoorwaarden :"},null,null,null,null,{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Offerte :\",\"30 dagen na opmaakdatum\",B11=\"Factuur :\",\"Betaalbaar contant\",B11=\"Creditnota :\",\"Het bedrag wordt binnen 30 dagen terug gestort op uw rekening,\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"Betaalbaar contant"},null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,{"$f":"IF(B11=\"Offerte :\",\"Voorwaarden :\",)","v":0},{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Factuur :\",\"Algemene verkoopsvoorwaarden op achterzijde, u hebt kennis \",B11=\"Offerte :\",\"Voor akkoord dient een voorschot van minimum 30% voldaan te worden\",B11=\"Creditnota :\",\"of verrekend met een volgende factuur.\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"Algemene verkoopsvoorwaarden op achterzijde, u hebt kennis "},null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Factuur :\",\"genomen hier van en gaat akkoord met de voorwaarden.\",B11=\"Offerte :\",\"binnen de termijn van geldigheid van de offerte.\",B11=\"Creditnota :\",\"\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"genomen hier van en gaat akkoord met de voorwaarden."},null,null,null,null,null,null,"14 dagen",null,null,59]
[null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Offerte :\",\"\",B11=\"Factuur :\",\"Factuurclausule :\",B11=\"Creditnota :\",\"\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"Factuurclausule :"},{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Offerte :\",\"\",B11=\"Factuur :\",\"Te betalen binnen een termijn van:\",B11=\"Creditnota :\",\"\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":"Te betalen binnen een termijn van:"},null,null,{"$f":"IF(B11=P12,IF(M10>1,P60,P59),)","v":"14 dagen"},null,"1/5",null,"30 dagen",null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P9,\"\",B11=\"Offerte :\",\"\",B11=\"Factuur :\",\"\",B11=\"Creditnota :\",\"\",B11=\"Bestelbon :\",\"\",B11=\"Order :\",\"\")","v":""},null,null,null,null,null,null,null,null,null,62]
["Algemene verkoopsvoorwaarden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]
["1.","De goederen worden geleverd zoals omschreven op de factuur of in de bestelbon. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67]
["2.","De goederen worden geleverd binnen de termijn zoals op de bestelbon vermeld, rekening houdend met",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68]
[null,"de gebruikelijke tolerantie eigen aan de aard van de industrie of handel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70]
["3.","De goederen worden vervoerd op kosten en op risico van de koper. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71]
[null,"De levering gebeurt bij de verkoper, behoudens andersluidende schriftelijke overeenkomst.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73]
["4.","Klachten betreffende de geleverde goederen kunnen niet aanvaard worden wanneer zij niet schriftelijk bij ons toekomen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[null,"binnen de zeven dagen na levering. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75]
[null,"Verborgen gebreken dienen binnen korte termijn na de ontdekking ervan gemeld te worden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
["5.","Onze leveringen zijn ten laatste betaalbaar de ",null,null,{"$f":"_xlfn.IFS(L60=\"14 dagen\",\"14e\",L60=\"30 dagen\",\"30e\",L60=P58,\"30e\")","v":"14e"},"dag na factuurdatum.",null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,"Onze leveringen zijn contant betaalbaar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80]
["6.","De geleverde koopwaar blijft onze eigendom zolang de volledige prijs (hoofdsom kosten en interesten) niet betaald is.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81]
[null,"De verkrijger draagt de risico’s vanaf de levering. Deze moet de goederen in hun staat bewaren.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82]
[null,"De verkoop wordt van rechtswege ontbonden bij niet-betaling op de vervaldag en de goederen worden onverwijld teruggegeven.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83]
[null,"Bij gebrek aan betaling van de factuur op de 7e dag na de aangetekende verzending van een aanmaning,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84]
[null,"kan de overeenkomst door ons van rechtswege en op eenvoudige aangetekend verzonden verklaring worden ontbonden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85]
[null,"Dit alles onverminderd het betalen van schadevergoeding door de in gebreke gebleven koper.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
["7.","De factuur dient betaald te worden binnen de termijn van",null,null,null,null,{"$f":"_xlfn.IFS(L60=\"14 dagen\",\"14\",L60=\"30 dagen\",\"30\",L60=P58,\"30\")","v":"14"},"dagen na factuurdatum.",null,null,null,null,null,null,null,null,null,null,88]
[null,"Betalingen na deze termijn brengen van rechtswege en zonder ingebrekestelling interesten op gelijk aan 10 %, alsmede (evenzeer van rechtswege ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89]
[null,"en zonder ingebrekestelling) een forfaitaire vergoeding van 10 % op het factuurbedrag (met een minimum van EUR 75) als schadebeding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[null,"Wanneer de verkoper zijn verplichtingen niet nakomt, is de consument, d.i. elke natuurlijke of rechtspersoon,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91]
[null,"die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten verwerft of gebruikt,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92]
[null,"gerechtigd een vergoeding te eisen voor de rechtbank overeenkomstig het gemeen recht.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94]
["8.","Al onze overeenkomsten worden beheerst door het Belgisch recht. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95]
[null,"Wanneer de klant een natuurlijk of rechtspersoon is die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96]
[null,"verwerft of gebruikt, worden alle betwistingen voortvloeiend uit onderhavige overeenkomst beslecht voor de rechtbank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97]
[null,"van de woonplaats van de consument. In de andere gevallen kunnen zij enkel beslecht worden door de rechtbank van  Hasselt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99]
["9.","Klachten betreffende de factuur dienen binnen de 7 dagen schriftelijk toe te komen op de hoofdzetel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100]
[null,"Indien hieraan niet voldaan wordt, gaat men akkoord met de factuur.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102]
["10.","De prijzen vermeld op een offerte hebben een maximale geldigheidsduur van 30 dagen na opmaak.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103]
[null,"Voor akkoord van een offerte, dient een voorschot voldaan te worden van minstens 30% binnen de termijn van geldigheid van de offerte.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105]
["11.","Het bedrijf behoudt zich het recht om de Algemene voorwaarden eenzijdig en op eender welk tijdstip aan te passen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,"Deze voorwaarden gelden als enige voorwaarden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,123]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,124]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,135]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2/5",null,null,null,null,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148]
[null,{"$f":"(B1)","v":"Markata"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149]
[null,{"$f":"(B2)","v":"***"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150]
[null,{"$f":"(B3)","v":"***"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151]
[null,{"$f":"(B4)","v":"***"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
[null,"Ondn°:",null,{"$f":"(D5)","v":"***"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,153]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154]
["Bijlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,157]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,158]
[null,null,{"$f":"IF(K7=\"VSS\",\"Locatie\",\"Benaming\")","v":"Benaming"},null,null,null,{"$f":"IF(K7=\"VSS\",\"Datum\",\"Referentie\")","v":"Referentie"},null,"EHprijs","Aantal",null,"Totaal",null,null,null,"Aankoopbedrag",null,null,159]
[{"$f":"IF(K7=\"VSS\",IF(I159=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B159=1,275,AND(K7=\"VSS\",G159>1/1/2000),250,P159<10,P159*2,P159<20,P159*1.5,P159>20,P159*1.4)","v":0},null,{"$f":"ROUNDUP(I159*J159,2)","v":0},null,null,null,null,null,null,null,160]
[{"$f":"IF(K7=\"VSS\",IF(I160=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(AND(K7=\"VSS\",B160=1),275,AND(K7=\"VSS\",G160>1/1/2000),250,P160<10,P160*2,P160<20,P160*1.5,P160>20,P160*1.4)","v":0},null,0,null,null,null,null,null,null,null,161]
[{"$f":"IF(K7=\"VSS\",IF(I161=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B161=1,275,AND(K7=\"VSS\",G161>1/1/2000),250,P161<10,P161*2,P161<20,P161*1.5,P161>20,P161*1.4)","v":0},null,0,null,null,null,null,null,null,null,162]
[{"$f":"IF(K7=\"VSS\",IF(I162=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B162=1,275,AND(K7=\"VSS\",G162>1/1/2000),250,P162<10,P162*2,P162<20,P162*1.5,P162>20,P162*1.4)","v":0},null,0,null,null,null,null,null,null,null,163]
[{"$f":"IF(K7=\"VSS\",IF(I163=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B163=1,275,AND(K7=\"VSS\",G163>1/1/2000),250,P163<10,P163*2,P163<20,P163*1.5,P163>20,P163*1.4)","v":0},null,0,null,null,null,null,null,null,null,164]
[{"$f":"IF(K7=\"VSS\",IF(I164=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B164=1,275,AND(K7=\"VSS\",G164>1/1/2000),250,P164<10,P164*2,P164<20,P164*1.5,P164>20,P164*1.4)","v":0},null,0,null,null,null,null,null,null,null,165]
[{"$f":"IF(K7=\"VSS\",IF(I165=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B165=1,275,AND(K7=\"VSS\",G165>1/1/2000),250,P165<10,P165*2,P165<20,P165*1.5,P165>20,P165*1.4)","v":0},null,0,null,null,null,null,null,null,null,166]
[{"$f":"IF(K7=\"VSS\",IF(I166=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B166=1,275,AND(K7=\"VSS\",G166>1/1/2000),250,P166<10,P166*2,P166<20,P166*1.5,P166>20,P166*1.4)","v":0},null,0,null,null,null,null,null,null,null,167]
[{"$f":"IF(K7=\"VSS\",IF(I167=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B167=1,275,AND(K7=\"VSS\",G167>1/1/2000),250,P167<10,P167*2,P167<20,P167*1.5,P167>20,P167*1.4)","v":0},null,0,null,null,null,null,null,null,null,168]
[{"$f":"IF(K7=\"VSS\",IF(I168=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B168=1,275,AND(K7=\"VSS\",G168>1/1/2000),250,P168<10,P168*2,P168<20,P168*1.5,P168>20,P168*1.4)","v":0},null,0,null,null,null,null,null,null,null,169]
[{"$f":"IF(K7=\"VSS\",IF(I169=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B169=1,275,AND(K7=\"VSS\",G169>1/1/2000),250,P169<10,P169*2,P169<20,P169*1.5,P169>20,P169*1.4)","v":0},null,0,null,null,null,null,null,null,null,170]
[{"$f":"IF(K7=\"VSS\",IF(I170=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B170=1,275,AND(K7=\"VSS\",G170>1/1/2000),250,P170<10,P170*2,P170<20,P170*1.5,P170>20,P170*1.4)","v":0},null,0,null,null,null,null,null,null,null,171]
[{"$f":"IF(K7=\"VSS\",IF(I171=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B171=1,275,AND(K7=\"VSS\",G171>1/1/2000),250,P171<10,P171*2,P171<20,P171*1.5,P171>20,P171*1.4)","v":0},null,0,null,null,null,null,null,null,null,172]
[{"$f":"IF(K7=\"VSS\",IF(I172=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B172=1,275,AND(K7=\"VSS\",G172>1/1/2000),250,P172<10,P172*2,P172<20,P172*1.5,P172>20,P172*1.4)","v":0},null,0,null,null,null,null,null,null,null,173]
[{"$f":"IF(K7=\"VSS\",IF(I173=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B173=1,275,AND(K7=\"VSS\",G173>1/1/2000),250,P173<10,P173*2,P173<20,P173*1.5,P173>20,P173*1.4)","v":0},null,0,null,null,null,null,null,null,null,174]
[{"$f":"IF(K7=\"VSS\",IF(I174=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B174=1,275,AND(K7=\"VSS\",G174>1/1/2000),250,P174<10,P174*2,P174<20,P174*1.5,P174>20,P174*1.4)","v":0},null,0,null,null,null,null,null,null,null,175]
[{"$f":"IF(K7=\"VSS\",IF(I175=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B175=1,275,AND(K7=\"VSS\",G175>1/1/2000),250,P175<10,P175*2,P175<20,P175*1.5,P175>20,P175*1.4)","v":0},null,0,null,null,null,null,null,null,null,176]
[{"$f":"IF(K7=\"VSS\",IF(I176=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B176=1,275,AND(K7=\"VSS\",G176>1/1/2000),250,P176<10,P176*2,P176<20,P176*1.5,P176>20,P176*1.4)","v":0},null,0,null,null,null,null,null,null,null,177]
[{"$f":"IF(K7=\"VSS\",IF(I177=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B177=1,275,AND(K7=\"VSS\",G177>1/1/2000),250,P177<10,P177*2,P177<20,P177*1.5,P177>20,P177*1.4)","v":0},null,0,null,null,null,null,null,null,null,178]
[{"$f":"IF(K7=\"VSS\",IF(I178=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B178=1,275,AND(K7=\"VSS\",G178>1/1/2000),250,P178<10,P178*2,P178<20,P178*1.5,P178>20,P178*1.4)","v":0},null,0,null,null,null,null,null,null,null,179]
[{"$f":"IF(K7=\"VSS\",IF(I179=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B179=1,275,AND(K7=\"VSS\",G179>1/1/2000),250,P179<10,P179*2,P179<20,P179*1.5,P179>20,P179*1.4)","v":0},null,0,null,null,null,null,null,null,null,180]
[{"$f":"IF(K7=\"VSS\",IF(I180=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B180=1,275,AND(K7=\"VSS\",G180>1/1/2000),250,P180<10,P180*2,P180<20,P180*1.5,P180>20,P180*1.4)","v":0},null,0,null,null,null,null,null,null,null,181]
[{"$f":"IF(K7=\"VSS\",IF(I181=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B181=1,275,AND(K7=\"VSS\",G181>1/1/2000),250,P181<10,P181*2,P181<20,P181*1.5,P181>20,P181*1.4)","v":0},null,0,null,null,null,null,null,null,null,182]
[{"$f":"IF(K7=\"VSS\",IF(I182=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B182=1,275,AND(K7=\"VSS\",G182>1/1/2000),250,P182<10,P182*2,P182<20,P182*1.5,P182>20,P182*1.4)","v":0},null,0,null,null,null,null,null,null,null,183]
[{"$f":"IF(K7=\"VSS\",IF(I183=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B183=1,275,AND(K7=\"VSS\",G183>1/1/2000),250,P183<10,P183*2,P183<20,P183*1.5,P183>20,P183*1.4)","v":0},null,0,null,null,null,null,null,null,null,184]
[{"$f":"IF(K7=\"VSS\",IF(I184=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B184=1,275,AND(K7=\"VSS\",G184>1/1/2000),250,P184<10,P184*2,P184<20,P184*1.5,P184>20,P184*1.4)","v":0},null,0,null,null,null,null,null,null,null,185]
[{"$f":"IF(K7=\"VSS\",IF(I185=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B185=1,275,AND(K7=\"VSS\",G185>1/1/2000),250,P185<10,P185*2,P185<20,P185*1.5,P185>20,P185*1.4)","v":0},null,0,null,null,null,null,null,null,null,186]
[{"$f":"IF(K7=\"VSS\",IF(I186=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B186=1,275,AND(K7=\"VSS\",G186>1/1/2000),250,P186<10,P186*2,P186<20,P186*1.5,P186>20,P186*1.4)","v":0},null,0,null,null,null,null,null,null,null,187]
[{"$f":"IF(K7=\"VSS\",IF(I187=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B187=1,275,AND(K7=\"VSS\",G187>1/1/2000),250,P187<10,P187*2,P187<20,P187*1.5,P187>20,P187*1.4)","v":0},null,0,null,null,null,null,null,null,null,188]
[{"$f":"IF(K7=\"VSS\",IF(I188=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B188=1,275,AND(K7=\"VSS\",G188>1/1/2000),250,P188<10,P188*2,P188<20,P188*1.5,P188>20,P188*1.4)","v":0},null,0,null,null,null,null,null,null,null,189]
[{"$f":"IF(K7=\"VSS\",IF(I189=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B189=1,275,AND(K7=\"VSS\",G189>1/1/2000),250,P189<10,P189*2,P189<20,P189*1.5,P189>20,P189*1.4)","v":0},null,0,null,null,null,null,null,null,null,190]
[{"$f":"IF(K7=\"VSS\",IF(I190=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B190=1,275,AND(K7=\"VSS\",G190>1/1/2000),250,P190<10,P190*2,P190<20,P190*1.5,P190>20,P190*1.4)","v":0},null,0,null,null,null,null,null,null,null,191]
[{"$f":"IF(K7=\"VSS\",IF(I191=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B191=1,275,AND(K7=\"VSS\",G191>1/1/2000),250,P191<10,P191*2,P191<20,P191*1.5,P191>20,P191*1.4)","v":0},null,0,null,null,null,null,null,null,null,192]
[{"$f":"IF(K7=\"VSS\",IF(I192=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B192=1,275,AND(K7=\"VSS\",G192>1/1/2000),250,P192<10,P192*2,P192<20,P192*1.5,P192>20,P192*1.4)","v":0},null,0,null,null,null,null,null,null,null,193]
[{"$f":"IF(K7=\"VSS\",IF(I193=250,1,),)","v":0},null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B193=1,275,AND(K7=\"VSS\",G193>1/1/2000),250,P193<10,P193*2,P193<20,P193*1.5,P193>20,P193*1.4)","v":0},null,0,null,null,null,null,null,null,null,194]
[]
[null,null,null,null,null,null,null,null,"Tussentotaal :  ",null,{"$f":"SUM(K159:L193)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195]
[{"$f":"IF(K7=\"VSS\",\"Maaltijd\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,196]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G198>1/1/2000),30,)","v":0},{"$f":"IF(AND(K7=\"VSS\",G198>1/1/2000),1,)","v":0},{"$f":"SUM(I198*J198)","v":0},null,null,null,null,null,null,null,197]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G199>1/1/2000),30,)","v":0},{"$f":"IF(AND(K7=\"VSS\",G199>1/1/2000),1,)","v":0},{"$f":"SUM(I199*J199)","v":0},null,null,null,null,null,null,null,198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,199]
[{"$f":"_xlfn.IFS(K7=\"VSS\",\"KM-vergoeding\",B11=P12,P27,B11=P10,\"\",B11=P11,\"\",B11=P13,\"\",B11=P14,\"\",B11=P15,\"\")","v":"Werkuren"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G202>1/1/2000),Q32,\"\")","v":""},null,{"$f":"IF(AND(OR(K7=\"VSS\",B11=P12),G202>1/1/2000),ROUNDUP(I202*J202,2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G203>1/1/2000),Q32,\"\")","v":""},null,{"$f":"IF(AND(OR(K7=\"VSS\",B11=P12),G203>1/1/2000),ROUNDUP(I203*J203,2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G204>1/1/2000),Q32,\"\")","v":""},null,{"$f":"IF(AND(OR(K7=\"VSS\",B11=P12),G204>1/1/2000),ROUNDUP(I204*J204,2),\"\")","v":""},null,null,null,null,"tussentotaal"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7=\"VSS\",G205>1/1/2000),Q32,\"\")","v":""},null,{"$f":"IF(AND(OR(K7=\"VSS\",B11=P12),G205>1/1/2000),ROUNDUP(I205*J205,2),\"\")","v":""},null,null,null,null,{"$f":"SUM(P159:P193)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"verschil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K195-P205)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Bijlage bij",{"$f":"B11","v":"Factuur :"},{"$f":"(E11)","v":"2021 - 0"},null,null,"3/5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4/5"]
[]
["6% BTW-tarief voor renovatiewerken aan woningen ouder dan 10 jaar"]
[]
["ATTEST"]
[]
[null,"Toepassing van het verlaagd btw-tarief op werken in onroerende staat aan privé-woningen."]
[null,"Krachtens de bepalingen van de rubrieken XXXI en XXXVIII van het Koninklijk Besluit nr. 20"]
[null,"van 20 juli 1970 tot vaststelling van de tarieven van de belasting over de toegevoegde waarde"]
[null,"en tot indeling van de goederen en diensten bij die tarieven."]
[]
[null,{"$f":"\"Ondergetekende : \"&$K$7","v":"Ondergetekende : klant1"}]
[]
[null,{"$f":"\"Wonende te : \"&$K$8 & \" te  \" & $K$9","v":"Wonende te : adres1 te  postcode 1"}]
[]
[null,"verklaart dat het gebouw gelegen te :",null,null,null,null,"…...................................................................................................................."]
[]
[null,"waarvan hij/zij"]
[null,null,"eigenaar"]
[null,null,"huurder"]
[null,null,"vruchtgebruiker"]
[null,null,"zaakvoerder"]
[null,"is, effectief in gebruik sedert ten minste 10 jaar vòòr het eerste tijdstip van de verschuldigdheid van de btw"]
[null,"op de werken die worden uitgevoerd overeenkomstig"]
[null,null,"de aannemingsovereenkomst"]
[null,null,"de bestelbon"]
[null,null,"de offerte"]
[null,null,"de factuur"]
[null,{"$f":"\"die werd ondertekend op \" &$D$15 &\" en na de voornoemde werken efectief en\"","v":"die werd ondertekend op 22 februari 2021 en na de voornoemde werken efectief en"}]
[null,null,"uitsluitend"]
[null,null,"hoofdzakelijk"]
[null,"zal gebruikt worden als privéwoning."]
[]
[]
[]
[]
[null,"Ondertekende verklaart hierbij dientengevolge, opdracht te hebben gegeven tot facturatie tegen 6%"]
[null," van de volgende factu(u)r(en):"]
[null,{"$f":"\"factuurnummer: \"&$D$11&\" \"&$E$11&\" , van het jaar \"&YEAR($D$15)","v":"factuurnummer: vk 2021 - 0 , van het jaar 2021"}]
[]
[]
[null,"Ondertekende verklaart te weten  dat een foutieve verklaring aanleiding kan geven tot supplementaire BTW,"]
[null,"boeten en intresten,waarvoor de  ondertekende verantwoordelijke is, ingevolge het"]
[null,"Koninklijk Besluitnr. 20 van 20 juli 1970."]
[null,"Deze bedragen zullen hem integraal ten laste worden gelegd, indien ze verschuldigd blijken te zijn volgens"]
[null,"de BTW-administratie ingevolge de wetgeving."]
[]
[null,{"$f":"\"Opgemaakt (in 2 exemplaren) te \" &$K$9","v":"Opgemaakt (in 2 exemplaren) te postcode 1"}]
[]
[null,{"$f":"\"Datum: \"&$D$15","v":"Datum: 22 februari 2021"}]
[]
[null,"Handtekening:"]
[]
[]
[]
["Terug te zenden naar de aannemer die de werken heeft uitgevoerd."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"5/5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"6/7"]
[]
["6% BTW-tarief voor renovatiewerken aan woningen ouder dan 10jaar"]
[]
["ATTEST"]
[]
[null,"Toepassing van het verlaagd btw-tarief op werken in onroerende staat aan privé-woningen."]
[null,"Krachtens de bepalingen van de rubrieken XXXI en XXXVIII van het Koninklijk Besluit nr. 20"]
[null,"van 20 juli 1970 tot vaststelling van de tarieven van de belasting over de toegevoegde waarde"]
[null,"en tot indeling van de goederen en diensten bij die tarieven."]
[]
[null,{"$f":"\"Ondergetekende : \"&$K$7","v":"Ondergetekende : klant1"}]
[]
[null,{"$f":"\"Wonende te : \"&$K$8 & \" te  \" & $K$9","v":"Wonende te : adres1 te  postcode 1"}]
[]
[null,"verklaart dat het gebouw gelegen te :",null,null,null,null,"…...................................................................................................................."]
[]
[null,"waarvan hij/zij"]
[null,null,"eigenaar"]
[null,null,"huurder"]
[null,null,"vruchtgebruiker"]
[null,null,"zaakvoerder"]
[null,"is, effectief in gebruik sedert ten minste 10 jaar vòòr het eerste tijdstip van de verschuldigdheid van de btw"]
[null,"op de werken die worden uitgevoerd overeenkomstig"]
[null,null,"de aannemingsovereenkomst"]
[null,null,"de bestelbon"]
[null,null,"de offerte"]
[null,null,"de factuur"]
[null,{"$f":"\"die werd ondertekend op \" &$D$15 &\" en na de voornoemde werken efectief en\"","v":"die werd ondertekend op 22 februari 2021 en na de voornoemde werken efectief en"}]
[null,null,"uitsluitend"]
[null,null,"hoofdzakelijk"]
[null,"zal gebruikt worden als privéwoning."]
[]
[]
[]
[]
[null,"Ondertekende verklaart hierbij dientengevolge, opdracht te hebben gegeven tot facturatie tegen 6%"]
[null," van de volgende factu(u)r(en):"]
[null,{"$f":"\"factuurnummer: \"&$D$11&\" \"&$E$11&\" , van het jaar \"&YEAR($D$15)","v":"factuurnummer: vk 2021 - 0 , van het jaar 2021"}]
[]
[]
[null,"Ondertekende verklaart te weten  dat een foutieve verklaring aanleiding kan geven tot supplementaire BTW,"]
[null,"boeten en intresten,waarvoor de  ondertekende verantwoordelijke is, ingevolge het"]
[null,"Koninklijk Besluitnr. 20 van 20 juli 1970."]
[null,"Deze bedragen zullen hem integraal ten laste worden gelegd, indien ze verschuldigd blijken te zijn volgens"]
[null,"de BTW-administratie ingevolge de wetgeving."]
[]
[null,{"$f":"\"Opgemaakt (in 2 exemplaren) te \" &$K$9","v":"Opgemaakt (in 2 exemplaren) te postcode 1"}]
[]
[null,{"$f":"\"Datum: \"&$D$15","v":"Datum: 22 februari 2021"}]
[]
[null,"Handtekening:"]
[]
[]
[]
["Terug te zenden naar de aannemer die de werken heeft uitgevoerd."]

{"sheet":"Herinnering","index":1,"n_rows":144,"n_cols":48,"rows_kept":144,"cut":false,"hidden":false,"merged":[[30,51,30,52],[10,40,11,45],[12,52,12,53],[14,43,14,46],[14,48,14,49],[14,52,14,53],[3,50,3,52],[4,50,4,52],[7,50,7,53],[8,50,8,53],[9,50,9,51],[60,0,60,15],[10,1,11,6],[14,4,14,7],[14,9,14,10],[14,13,14,14],[23,2,23,3],[12,13,12,15],[22,14,22,15],[9,11,9,12],[27,4,27,8],[3,11,3,13],[4,11,4,13],[6,11,6,15],[7,11,7,14],[8,11,8,14]]}
["2021-01-10",{"$f":"factuur!B1","v":"Markata"}]
[null,"***"]
[null,"***"]
[1,"***",null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"}]
[null,{"$f":"factuur!B5","v":"Ondn°:"},null,null,{"$f":"factuur!D5","v":"***"},123456789,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon\",_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!A:A),_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!A:A,klantenlisting!A6))","v":"cust-001"}]
[2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!K7","v":"klant1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!K8","v":"adres1"}]
[3,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!K9","v":"postcode 1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10>0,\"Ondn°:\",\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!G:G,\" \")","v":0},null,null,"Herinnering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aanmaning"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2e Aanmaning"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Pelt,",{"$f":"factuur!D15","v":"22 februari 2021"}]
[]
[]
[5]
[null,"Betreft factuur :",null,{"$f":"factuur!E11","v":"2021 - 0"}]
[]
[]
[null,"Geachte Heer, Mevrouw,"]
[]
[]
[null,"Hierbij willen wij u informeren dat uw rekening nog een openstaand saldo vertoond van",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(factuur!M45)","v":0}]
[null,"op factuur :",{"$f":"D17","v":"2021 - 0"}]
[]
[]
[null,"Wij gaan er van uit dat u de betaling over het hoofd hebt gezien en vragen u dan ook het achterstallige bedrag"]
[null,"over te maken op onze rekening :",null,null,{"$f":"factuur!M54","v":"BE123456789"},null,null,null,null,"BIC: ******",null,null,"met vermelding van het"]
[null,"factuurnummer."]
[null,"Als u intussen het bedrag gestort heeft, mag u deze kennisgeving als onbestaand beschouwen."]
[]
[]
[null,"Bij vragen of betalingsproblemen kan u ons steeds bereiken op het nummer : +32(0)***"]
[null,"of per mail ","info@me.be"]
[]
[]
[]
[]
[null,"Met beleefde groeten,"]
[]
[]
[]
[]
[null,"Katarzynski Mark"]
[null,"Zaakvoerder."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"factuur!A63","v":"Algemene verkoopsvoorwaarden."}]
[]
[]
[1,"De goederen worden geleverd zoals omschreven op de factuur of in de bestelbon. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y66","v":0},{"$f":"factuur!Z66","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN66","v":0},{"$f":"factuur!AO66","v":0}]
[]
[2,"De goederen worden geleverd binnen de termijn zoals op de bestelbon vermeld, rekening houdend met",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y68","v":0},{"$f":"factuur!Z68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN68","v":0},{"$f":"factuur!AO68","v":0}]
[null,"de gebruikelijke tolerantie eigen aan de aard van de industrie of handel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z69","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO69","v":0}]
[]
[3,"De goederen worden vervoerd op kosten en op risico van de koper. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y71","v":0},{"$f":"factuur!Z71","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN71","v":0},{"$f":"factuur!AO71","v":0}]
[null,"De levering gebeurt bij de verkoper, behoudens andersluidende schriftelijke overeenkomst.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z72","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO72","v":0}]
[]
[4,"Klachten betreffende de geleverde goederen kunnen niet aanvaard worden wanneer zij niet schriftelijk bij ons toekomen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y74","v":0},{"$f":"factuur!Z74","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN74","v":0},{"$f":"factuur!AO74","v":0}]
[null,"binnen de zeven dagen na levering. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z75","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO75","v":0}]
[null,"Verborgen gebreken dienen binnen korte termijn na de ontdekking ervan gemeld te worden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z76","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO76","v":0}]
[]
[5,"Onze leveringen zijn ten laatste betaalbaar de ",null,null,"14e","dag na factuurdatum.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y78","v":0},{"$f":"factuur!Z78","v":0},null,null,null,{"$f":"IF(AL10>0,\"30e\",\"14e\")","v":"14e"},{"$f":"factuur!AD78","v":0},null,null,null,null,null,null,null,null,{"$f":"factuur!AN78","v":0},{"$f":"factuur!AO78","v":0},null,null,null,null,{"$f":"factuur!AS78","v":0}]
[null,"Onze leveringen zijn contant betaalbaar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z79","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO79","v":0}]
[]
[6,"De geleverde koopwaar blijft onze eigendom zolang de volledige prijs (hoofdsom kosten en interesten) niet betaald is.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y81","v":0},{"$f":"factuur!Z81","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN81","v":0},{"$f":"factuur!AO81","v":0}]
[null,"De verkrijger draagt de risico’s vanaf de levering. Deze moet de goederen in hun staat bewaren.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z82","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO82","v":0}]
[null,"De verkoop wordt van rechtswege ontbonden bij niet-betaling op de vervaldag en de goederen worden onverwijld teruggegeven.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z83","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO83","v":0}]
[null,"Bij gebrek aan betaling van de factuur op de 7e dag na de aangetekende verzending van een aanmaning,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z84","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO84","v":0}]
[null,"kan de overeenkomst door ons van rechtswege en op eenvoudige aangetekend verzonden verklaring worden ontbonden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z85","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO85","v":0}]
[null,"Dit alles onverminderd het betalen van schadevergoeding door de in gebreke gebleven koper.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z86","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO86","v":0}]
[]
[7,"De factuur dient betaald te worden binnen de termijn van",null,null,null,null,14,"dagen na factuurdatum.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y88","v":0},{"$f":"factuur!Z88","v":0},null,null,null,null,null,{"$f":"IF(AL10>0,\"30\",\"14\")","v":"14"},{"$f":"factuur!AF88","v":0},null,null,null,null,null,null,{"$f":"factuur!AN88","v":0},{"$f":"factuur!AO88","v":0},null,null,null,null,null,null,{"$f":"factuur!AU88","v":0}]
[null,"Betalingen na deze termijn brengen van rechtswege en zonder ingebrekestelling interesten op gelijk aan 10 %, alsmede (evenzeer van rechtswege ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z89","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO89","v":0}]
[null,"en zonder ingebrekestelling) een forfaitaire vergoeding van 10 % op het factuurbedrag (met een minimum van EUR 75) als schadebeding.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z90","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO90","v":0}]
[null,"Wanneer de verkoper zijn verplichtingen niet nakomt, is de consument, d.i. elke natuurlijke of rechtspersoon,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z91","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO91","v":0}]
[null,"die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten verwerft of gebruikt,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z92","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO92","v":0}]
[null,"gerechtigd een vergoeding te eisen voor de rechtbank overeenkomstig het gemeen recht.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z93","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO93","v":0}]
[]
[8,"Al onze overeenkomsten worden beheerst door het Belgisch recht. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y95","v":0},{"$f":"factuur!Z95","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN95","v":0},{"$f":"factuur!AO95","v":0}]
[null,"Wanneer de klant een natuurlijk of rechtspersoon is die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z96","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO96","v":0}]
[null,"verwerft of gebruikt, worden alle betwistingen voortvloeiend uit onderhavige overeenkomst beslecht voor de rechtbank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z97","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO97","v":0}]
[null,"van de woonplaats van de consument. In de andere gevallen kunnen zij enkel beslecht worden door de rechtbank van  Hasselt.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z98","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO98","v":0}]
[]
[9,"Klachten betreffende de factuur dienen binnen de 7 dagen schriftelijk toe te komen op de hoofdzetel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y100","v":0},{"$f":"factuur!Z100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN100","v":0},{"$f":"factuur!AO100","v":0}]
[null,"Indien hieraan niet voldaan wordt, gaat men akkoord met de factuur.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z101","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO101","v":0}]
[]
[10,"De prijzen vermeld op een offerte hebben een maximale geldigheidsduur van 30 dagen na opmaak.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y103","v":0},{"$f":"factuur!Z103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN103","v":0},{"$f":"factuur!AO103","v":0}]
[null,"Voor akkoord van een offerte, dient een voorschot voldaan te worden van minstens 30% binnen de termijn van geldigheid van de offerte.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z104","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO104","v":0}]
[]
[11,"Het bedrijf behoudt zich het recht om de Algemene voorwaarden eenzijdig en op eender welk tijdstip aan te passen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Y106","v":0},{"$f":"factuur!Z106","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AN106","v":0},{"$f":"factuur!AO106","v":0}]
[null,"Deze voorwaarden gelden als enige voorwaarden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!Z107","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO107","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-05"]

{"sheet":"Aangetekende","index":2,"n_rows":189,"n_cols":14,"rows_kept":189,"cut":false,"hidden":false,"merged":[[157,6,157,8],[157,9,157,10],[157,12,157,14],[154,0,154,9],[154,10,154,15],[9,11,9,12],[3,11,3,13],[4,11,4,13],[6,11,6,15],[7,11,7,14],[8,11,8,14],[10,1,11,7],[12,13,12,14],[14,4,14,7],[14,9,14,10],[14,13,14,14],[59,0,59,15],[26,9,26,11],[33,9,33,10],[33,6,33,8],[33,12,33,14]]}
["2021-01-10","Markata"]
[null,"***"]
[null,"***"]
[null,"***",null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"}]
[null,"Ondn°:",null,null,"***",123456789,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon\",_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!A:A),_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!A:A,\"\"))","v":"cust-001"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!K7","v":"klant1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!C:C,\" \")","v":"adres1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!D:D,\" \")","v":"postcode 1"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10>1,\"Ondn°:\",\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(L7,klantenlisting!B:B,klantenlisting!G:G,\" \")","v":0}]
[null,"Aangetekende zending"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"home",{"$f":"factuur!D15","v":"22 februari 2021"}]
[]
[]
[]
[null,"Betreft factuur:",null,{"$f":"factuur!E11","v":"2021 - 0"}]
[]
[]
[null,"Geachte Heer, Mevrouw,"]
[]
[]
[null,"Alle vorige aanmaningen bleven zonder gevolg. Behoudens betaling of reactie binnen de 8 dagen "]
[null,"op dit voorstel tot minnelijke schikking, zullen wij laten dagvaarden."]
[]
[null,"Indien u deze dagvaarding niet wenst te ontvangen, manen wij u aan om het volledige bedrag van"]
[null,{"$f":"M34","v":75},"per kerende te betalen op onze rekening :",null,null,null,null,null,null,{"$f":"factuur!M54","v":"BE123456789"},null,null,"BIC: ****,"]
[null,"of ons een voorstel ",null,"tot afbetaling ","te zenden per post of per mail op het volgend adres :",null,null,null,null,null,null,null,null,"info@me.be"]
[null,{"$f":"IF(B12=Q14,\"\",\"Als u het bedrag intussen gestort hebt, mag u deze kennisgeving als onbestaand beschouwen.\")","v":""}]
[]
[]
[]
[null,{"$f":"IF(B12=Q14,\"Factuur\",\"\")","v":"Factuur"},null,{"$f":"IF(B12=Q14,\"bedrag\",\"\")","v":"bedrag"},null,null,{"$f":"IF(B12=Q14,\"intrest\",\"\")","v":"intrest"},null,null,{"$f":"IF(B12=Q14,\"schadebeding\",\"\")","v":"schadebeding"},null,null,{"$f":"IF(B12=Q14,\"Totaal te betalen\",\"\")","v":"Totaal te betalen"}]
[null,{"$f":"D17","v":"2021 - 0"},null,{"$f":"factuur!M45","v":0},null,null,{"$f":"SUM(D34*0.1)","v":0},null,null,{"$f":"IF(D34*0.1>75,D34*0.1,75)","v":75},null,null,{"$f":"SUM(D34,G34,J34)","v":75}]
[]
[]
[]
[]
[null,"Met beleefde groeten,"]
[]
[null,"Katarzynski Mark"]
[null,"Zaakvoerder."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Algemene verkoopsvoorwaarden."]
[]
[]
[1,"De goederen worden geleverd zoals omschreven op de factuur of in de bestelbon. "]
[]
[2,"De goederen worden geleverd binnen de termijn zoals op de bestelbon vermeld, rekening houdend met"]
[null,"de gebruikelijke tolerantie eigen aan de aard van de industrie of handel."]
[]
[3,"De goederen worden vervoerd op kosten en op risico van de koper. "]
[null,"De levering gebeurt bij de verkoper, behoudens andersluidende schriftelijke overeenkomst."]
[]
[4,"Klachten betreffende de geleverde goederen kunnen niet aanvaard worden wanneer zij niet schriftelijk bij ons toekomen"]
[null,"binnen de zeven dagen na levering. "]
[null,"Verborgen gebreken dienen binnen korte termijn na de ontdekking ervan gemeld te worden."]
[]
[5,"Onze leveringen zijn ten laatste betaalbaar de ",null,null,"14e","dag na factuurdatum."]
[null,"Onze leveringen zijn contant betaalbaar."]
[]
[6,"De geleverde koopwaar blijft onze eigendom zolang de volledige prijs (hoofdsom kosten en interesten) niet betaald is."]
[null,"De verkrijger draagt de risico’s vanaf de levering. Deze moet de goederen in hun staat bewaren."]
[null,"De verkoop wordt van rechtswege ontbonden bij niet-betaling op de vervaldag en de goederen worden onverwijld teruggegeven."]
[null,"Bij gebrek aan betaling van de factuur op de 7e dag na de aangetekende verzending van een aanmaning,"]
[null,"kan de overeenkomst door ons van rechtswege en op eenvoudige aangetekend verzonden verklaring worden ontbonden."]
[null,"Dit alles onverminderd het betalen van schadevergoeding door de in gebreke gebleven koper."]
[]
[7,"De factuur dient betaald te worden binnen de termijn van",null,null,null,null,14,"dagen na factuurdatum."]
[null,"Betalingen na deze termijn brengen van rechtswege en zonder ingebrekestelling interesten op gelijk aan 10 %, alsmede (evenzeer van rechtswege "]
[null,"en zonder ingebrekestelling) een forfaitaire vergoeding van 10 % op het factuurbedrag (met een minimum van EUR 75) als schadebeding."]
[null,"Wanneer de verkoper zijn verplichtingen niet nakomt, is de consument, d.i. elke natuurlijke of rechtspersoon,"]
[null,"die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten verwerft of gebruikt,"]
[null,"gerechtigd een vergoeding te eisen voor de rechtbank overeenkomstig het gemeen recht."]
[]
[8,"Al onze overeenkomsten worden beheerst door het Belgisch recht. "]
[null,"Wanneer de klant een natuurlijk of rechtspersoon is die uitsluitend voor niet-beroepsmatige doeleinden, de producten of diensten"]
[null,"verwerft of gebruikt, worden alle betwistingen voortvloeiend uit onderhavige overeenkomst beslecht voor de rechtbank"]
[null,"van de woonplaats van de consument. In de andere gevallen kunnen zij enkel beslecht worden door de rechtbank van  Hasselt."]
[]
[9,"Klachten betreffende de factuur dienen binnen de 7 dagen schriftelijk toe te komen op de hoofdzetel."]
[null,"Indien hieraan niet voldaan wordt, gaat men akkoord met de factuur."]
[]
[10,"De prijzen vermeld op een offerte hebben een maximale geldigheidsduur van 30 dagen na opmaak."]
[null,"Voor akkoord van een offerte, dient een voorschot voldaan te worden van minstens 30% binnen de termijn van geldigheid van de offerte."]
[]
[11,"Het bedrijf behoudt zich het recht om de Algemene voorwaarden eenzijdig en op eender welk tijdstip aan te passen."]
[null,"Deze voorwaarden gelden als enige voorwaarden."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-05"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Voorstel tot afbetaling.",null,null,null,null,null,null,null,null,null,{"$f":"(factuur!K5)","v":"cust-001"}]
[]
[null,{"$f":"IF(B141=Q143,\"Factuur\",\"\")","v":"Factuur"},null,{"$f":"IF(B141=Q143,\"bedrag\",\"\")","v":"bedrag"},null,null,{"$f":"IF(B141=Q143,\"intrest\",\"\")","v":"intrest"},null,null,{"$f":"IF(B141=Q143,\"schadebeding\",\"\")","v":"schadebeding"},null,null,{"$f":"IF(B141=Q143,\"Totaal te betalen\",\"\")","v":"Totaal te betalen"}]
[null,{"$f":"D17","v":"2021 - 0"},null,{"$f":"factuur!M45","v":0},null,null,{"$f":"SUM(D158*0.1)","v":0},null,null,{"$f":"IF(D158*0.1>75,D158*0.1,75)","v":75},null,null,{"$f":"SUM(D158,G158,J158)","v":75}]
[]
["( )","Ik wens bewijsstukken te ontvangen."]
["( )","Reeds betaald. Ik zend hierbij een kopie van mijn betalingsbewijs."]
["( )","Opmerkingen :"]
[null,"…...................................................................................................................................................................................................."]
[null,"…...................................................................................................................................................................................................."]
[null,"…...................................................................................................................................................................................................."]
["( )","Ik wens een afbetalingsplan. Hieronder mijn voorstel :"]
[null,"…...................................................................................................................................................................................................."]
[null,"…...................................................................................................................................................................................................."]
[null,"…...................................................................................................................................................................................................."]
[]
[]
[null,"Opgemaakt te  …..................................",null,null,null,"op","…................................................"]
[]
[]
[]
[null,"Naam, Handtekening en eventueel stempel."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mijn e-mail  adres :",null,"…............................................................................."]
[]
[null,"Telefoonnummer waarop ik makkelijk te bereiken ben :",null,null,null,null,null,null,null,"…..................................................."]

{"sheet":"klantenlisting","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["cust-000","Benaming","Adres","Postcode & gemeente","Tel / GSM","email","BTW-nr","herkenbare benaming"]
["cust-001","klant1","adres1","postcode 1",null,"mail1@hotmail.com"]
["cust-002","klant2","adres2","postcode2",null,"mail2@hotmail.com","BE123456789"]
["cust-003","klant3","adres3","postcode3",null,"mail3@hotmail.com"]
["cust-004","klant4","adres4","postcode4",null,"mail4@hotmail.com"]