{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["factuur","Herinnering","Aangetekende","klantenlisting","Artikelen","locatie"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"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":445,"n_cols":19,"rows_kept":445,"cut":false,"hidden":false,"merged":[[199,8,199,9],[392,0,393,14],[394,0,394,14],[186,10,186,11],[187,10,187,11],[192,10,192,11],[10,4,11,8],[5,9,5,13],[444,0,444,14],[324,0,324,13],[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],[198,2,198,5],[198,6,198,7],[198,10,198,11],[200,0,200,14],[201,2,201,5],[201,6,201,7],[179,2,179,5],[180,2,180,5],[181,2,181,5],[201,10,201,11],[189,10,189,11],[190,10,190,11],[191,10,191,11],[183,10,183,11],[180,10,180,11],[181,10,181,11],[182,10,182,11],[178,2,178,5],[196,0,196,14],[197,2,197,5],[197,6,197,7],[197,10,197,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],[185,10,185,11],[194,8,194,9],[194,10,194,11],[184,10,184,11],[188,10,188,11],[44,3,44,8],[159,10,159,11],[160,10,160,11],[157,6,157,7],[168,2,168,5],[169,2,169,5],[161,10,161,11],[162,10,162,11],[53,3,53,9],[157,2,157,5],[56,3,56,7],[163,10,163,11],[164,10,164,11],[165,10,165,11],[166,10,166,11],[165,2,165,5],[166,2,166,5],[167,2,167,5],[158,10,158,11],[176,10,176,11],[177,10,177,11],[171,2,171,5],[173,2,173,5],[178,10,178,11],[179,10,179,11],[176,2,176,5],[177,2,177,5],[171,10,171,11],[172,10,172,11],[173,10,173,11],[175,10,175,11],[175,2,175,5],[172,2,172,5],[174,2,174,5],[174,10,174,11],[163,2,163,5],[164,2,164,5],[170,2,170,5],[167,10,167,11],[168,10,168,11],[169,10,169,11],[170,10,170,11],[158,2,158,5],[159,2,159,5],[160,2,160,5],[157,10,157,11],[49,12,50,13],[49,7,50,11],[53,12,53,13],[46,3,46,8],[39,9,40,11],[30,1,30,8],[25,10,25,11],[26,10,26,11],[27,10,27,11],[32,1,32,8],[18,10,18,11],[38,10,38,11],[33,10,33,11],[34,10,34,11],[21,3,21,8],[19,3,19,8],[27,3,27,8],[32,10,32,11],[36,10,36,11],[28,10,28,11],[30,10,30,11],[31,10,31,11],[24,10,24,11],[14,12,14,13],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[33,1,33,8],[10,3,11,3],[18,3,18,8],[22,1,22,8],[28,1,28,8],[17,6,17,7],[17,10,17,11],[14,8,14,9],[16,1,16,13],[29,10,29,11],[24,1,24,8],[26,1,26,8],[10,1,11,2],[20,1,20,8],[23,10,23,11],[29,1,29,8],[31,1,31,8],[23,3,23,8],[25,3,25,8],[161,2,161,5],[162,2,162,5],[44,12,47,13],[43,12,43,13],[43,9,43,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],[36,1,36,8],[35,10,35,11],[155,0,155,13],[62,0,62,13],[54,12,54,13],[44,9,44,11],[37,10,37,11],[46,9,46,11]]}
["2021-01-10","aaa",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"bbb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"ccc",null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"},null,null,null,null,null,null,null,null,2]
[null,111,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(J6,klantenlisting!B:B,klantenlisting!A:A,\" \")","v":"cust-002"},null,null,null,null,null,null,null,null,3]
[null,"Ondn°:",null,"BE 012345678",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,"klant2",null,null,null,null,null,null,null,null,5]
[null,{"$f":"IF(AND($L$10>1,_xlfn.XLOOKUP($J$6,klantenlisting!B:B,klantenlisting!K:K)>1),\"Klantnummer : \" & _xlfn.XLOOKUP($J$6,klantenlisting!B:B,klantenlisting!K:K),)","v":0},null,null,null,null,null,null,null,{"$f":"IF(L10>1,\"t.a.v. \" & (_xlfn.XLOOKUP(J6,klantenlisting!$B:$B,klantenlisting!$J:$J)),)","v":0},null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(J6,klantenlisting!B:B,klantenlisting!C:C,\" \")","v":"weg 12"},null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(J6,klantenlisting!B:B,klantenlisting!E:E)","v":"1020 Hier"},null,null,null,null,null,"Offerte :","OF",null,8]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L10>0,\"Ondn°:\",\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP($J$6,klantenlisting!B:B,klantenlisting!H:H)","v":0},null,null,null,"Order :","OR",null,9]
[null,"Factuur :",null,{"$f":"_xlfn.XLOOKUP(B11,P9:P14,Q9:Q14,\"\")","v":"VK"},"2021-0",null,null,null,null,null,null,null,null,null,null,"Factuur :","VK",null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Creditnota :","CN",null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestelbon :","BB",null,12]
[null,null,null,{"$f":"IF(B11=P9,\"Opmaakdatum :\",\"Datum :\")","v":"Datum :"},null,null,null,null,{"$f":"IF(B11=P11,\"Datum opeisbaarheid BTW :\",0)","v":"Datum opeisbaarheid BTW :"},null,null,null,{"$f":"IF(B11=P11,\"Leverdatum :\",0)","v":"Leverdatum :"},null,null,null,null,null,13]
[null,null,null,"11 maart 2021",null,null,null,null,{"$f":"IF(B11=P11,D15,0)","v":"11 maart 2021"},null,null,null,{"$f":"IF(AND(B11=P11,D15>1/1/2020),D15-15,\"\")","v":"2021-02-24"},null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null," Plaats levering of uitvoering werf :",null,null,null,null,null,null,null,null,null,null,null,null,null,",",null,null,16]
[null,",",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J8&\", \"&J9","v":"weg 12, 1020 Hier"},null,null,17]
[null,"Artikel",null,"Aard goederen / werkuren",null,null,null,null,null,"Aantal","Eenheid",null,"Bedrag","BTW %",null,"Diverse werven",null,null,18]
[null,"Goederen",null,{"$f":"IF(B20=P34,\"(zie bijlage)\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(B20<>\"\",VLOOKUP(B20,$P$42:$Q$51,2,0),\"\")","v":5},21,null,"Andere : ",null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home",null,null,20]
[null,"Werkuren",null,{"$f":"IF(B22=P27,\"(zie bijlage)\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(B22<>\"\",VLOOKUP(B22,$P$42:$Q$51,2,0),\"\")","v":0},null,null,"Ophaling Filiaal",null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,"Maaltijd",null,null,null,null,null,null,null,{"$f":"IF(AND($J$6=klantenlisting!$B$3,G198>1/1/2020),SUM(J198:J199),0)","v":0},null,null,{"$f":"IF(B24<>\"\",VLOOKUP(B24,$P$42:$Q$51,2,0),\"\")","v":45},{"$f":"IF(AND(J6=klantenlisting!B3,OR(B24=P32,B24=P33)),21,)","v":21},null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,"Werkuren",null,null,null,null,null,null,null,{"$f":"IF(AND(J6=klantenlisting!B3,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":50},null,0,{"$f":"IF(AND(J6=klantenlisting!B3,OR(B26=P32,B26=P33)),21,)","v":0},null,"Prijzen",0,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afhaling",0,null,26]
[null,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":""},null,{"$f":"IF(B28<>\"\",VLOOKUP(B28,$P$27:$Q$37,2,0),\"\")","v":""},null,null,"Gepresteerde dagen",375,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gepresteerde lange dagen",425,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J30*K30)","v":0},null,null,"Goederen",{"$f":"K191","v":""},null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"KM-vergoeding",0.35420000000000001,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Levering",null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Maaltijd",45,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Verzending",0,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Voorrijkosten",3.363E-2,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,"Werkuren",50,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,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,"Totaal excl. BTW",null,null,{"$f":"SUM(M20:M39)","v":50},null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bedrag",0,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afhaling",0,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gepresteerde dagen",375,null,42]
[null,null,"BTW %","Maatstaf van heffing",null,null,null,null,null,"Bedrag BTW",null,null,{"$f":"IF(B11=P12,\"Terugbetaling van :\",\"Totaal te betalen :\")","v":"Totaal te betalen :"},null,null,"Gepresteerde lange dagen",425,null,43]
[null,{"$f":"IF(OR(N20=C45,N22=C45,N24=C45,N26=C45,N28=C45),\"Medecontractant\",)","v":0},"O",{"$f":"SUM(IF(N20=\"O\",M20,),IF(N22=\"O\",M22,),IF(N24=\"O\",M24,),IF(N26=\"O\",M26,),IF(N28=\"O\",M28,))","v":0},null,null,null,null,null,0,null,null,{"$f":"IF($B$11=$P$12,SUM(-(D48:L48)),SUM(D48:L48))","v":61},null,null,"Goederen",5,null,44]
[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,"KM-vergoeding",0.35420000000000001,null,45]
[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":50},null,null,null,null,null,{"$f":"SUM(D47*0.21)","v":10.5},null,null,null,null,null,"Levering",null,null,46]
[null,null,null,{"$f":"ROUNDUP(SUM(D45:I47),0.01)","v":50},null,null,null,null,null,{"$f":"ROUNDUP(SUM(J45:L47),0.01)","v":11},null,null,null,null,null,"Maaltijd",45,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Verzending",0,null,48]
[null,null,null,null,null,null,null,{"$f":"IF(B11=P9,\"Minimum bedrag te voldoen voor akkoord :\",\"\")","v":""},null,null,null,null,{"$f":"IF(B11=\"Offerte :\",M45*0.3,\"\")","v":""},null,null,"Voorrijkosten",3.363E-2,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Werkuren",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,"Zakelijk","BE132",null,52]
[null,null,null,{"$f":"IF(OR(B11=P9,B11=P11),\"Netto te betalen op rekening :\",\"\")","v":"Netto te betalen op rekening :"},null,null,null,null,null,null,null,{"$f":"IF(OR(B11=P9,B11=P11),\"IBAN:  \",\"\")","v":"IBAN:  "},{"$f":"IF(OR(B11=P9,B11=P11),Q53,)","v":"BE132"},null,null,"Privé","BE123",null,53]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(B11=P9,B11=P11),\"BIC:  \",\"\")","v":"BIC:  "},{"$f":"IF(OR(B11=P9,B11=P11),\"KREDBEBB\",\"\")","v":"KREDBEBB"},null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P9,\"Geldigheid :\",B11=P11,\"Factuurvoorwaarden :\",B11=P12,\"\",B11=P13,\"\",B11=\"Order :\",\"\")","v":"Factuurvoorwaarden :"},null,null,null,null,{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P9,\"30 dagen na opmaakdatum\",B11=P11,\"Betaalbaar contant\",B11=P12,\"Het bedrag wordt binnen 30 dagen terug gestort op uw rekening,\",B11=P13,\"\",B11=P10,\"\")","v":"Betaalbaar contant"},null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,{"$f":"IF(B11=P9,\"Voorwaarden :\",)","v":0},{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P11,\"Algemene verkoopsvoorwaarden op achterzijde, u hebt kennis \",B11=P9,\"Voor akkoord dient een voorschot van minimum 30% voldaan te worden\",B11=P12,\"of verrekend met een volgende factuur.\",B11=P13,\"\",B11=P10,\"\")","v":"Algemene verkoopsvoorwaarden op achterzijde, u hebt kennis "},null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P11,\"genomen hier van en gaat akkoord met de voorwaarden.\",B11=P9,\"binnen de termijn van geldigheid van de offerte.\",B11=P12,\"\",B11=P13,\"\",B11=P10,\"\")","v":"genomen hier van en gaat akkoord met de voorwaarden."},null,null,null,null,null,null,"14 dagen",null,null,58]
[null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P9,\"\",B11=P11,\"Factuurclausule :\",B11=P12,\"\",B11=P13,\"\",B11=P10,\"\")","v":"Factuurclausule :"},{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P9,\"\",B11=P11,\"Te betalen binnen een termijn van:\",B11=P12,\"\",B11=P13,\"\",B11=P10,\"\")","v":"Te betalen binnen een termijn van:"},null,null,{"$f":"IF(B11=P11,IF(L10>1,P60,P59),)","v":"14 dagen"},null,null,null,"30 dagen",null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.IFS(B11=P14,\"\",B11=P9,\"\",B11=P11,\"\",B11=P12,\"\",B11=P13,\"\",B11=P10,\"\")","v":""},null,null,null,null,null,null,null,null,null,61]
["Algemene verkoopsvoorwaarden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,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]
["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,65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,66]
["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,67]
[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,68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,69]
["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,70]
[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,71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72]
["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,73]
[null,"binnen de zeven dagen na levering. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74]
[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,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76]
["5.",{"$f":"\"Onze leveringen zijn ten laatste betaalbaar de \" & (_xlfn.IFS(L60=\"14 dagen\",\"14e\",L60=\"30 dagen\",\"30e\",L60=P58,\"30e\")) & \" dag na factuurdatum.\"","v":"Onze leveringen zijn ten laatste betaalbaar de 14e dag na factuurdatum."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[null,"Onze leveringen zijn contant betaalbaar.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79]
["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,80]
[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,81]
[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,82]
[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,83]
[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,84]
[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,85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86]
["7.",{"$f":"\"De factuur dient betaald te worden binnen de termijn van \" & (_xlfn.IFS(L60=\"14 dagen\",\"14\",L60=\"30 dagen\",\"30\",L60=P58,\"30\")) & \" dagen na factuurdatum.\"","v":"De factuur dient betaald te worden binnen de termijn van 14 dagen na factuurdatum."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87]
[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,88]
[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,89]
[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,90]
[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,91]
[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,92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93]
["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,94]
[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,95]
[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,96]
[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,97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98]
["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,99]
[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,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101]
["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,102]
[null,"Voor akkoord van een offerte, dient een voorschot voldaan te worden van ten minste 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,103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104]
["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,105]
[null,"Deze voorwaarden gelden als enige voorwaarden.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,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,null,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,{"$f":"(B1)","v":"aaa"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,148]
[null,{"$f":"(B2)","v":"bbb"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149]
[null,{"$f":"(B3)","v":"ccc"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150]
[null,{"$f":"(B4)","v":111},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151]
[null,"Ondn°:",null,{"$f":"(D5)","v":"BE 012345678"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,152]
[null,null,null,null,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,155]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,156]
[null,null,{"$f":"IF(J6=klantenlisting!B3,\"Locatie\",\"Benaming\")","v":"Locatie"},null,null,null,{"$f":"IF(J6=klantenlisting!B3,\"Datum\",\"Referentie\")","v":"Datum"},null,"EHprijs","Aantal","Totaal",null,null,null,null,"Aankoopbedrag","totaal verkoop",null,157]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C159,locatie!A:A,locatie!B:B,),)","v":{"$error":"#N/A"}},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C159,locatie!A:A,locatie!C:C,),)","v":{"$error":"#N/A"}},"1mod autom 2p 20a",null,null,null,{"$f":"IF(factuur!$C159<>\"\",VLOOKUP(factuur!$C159,Artikelen!$A$2:$G$51,2,0),\"\")","v":"abb2cdb111201R0204"},null,{"$f":"IF(factuur!$C159<>\"\",VLOOKUP(factuur!$C159,Artikelen!$A$2:$G$51,6,0),\"\")","v":1},1,{"$f":"IF(C159<>\"\",ROUNDUP(I159*J159,2),\"\")","v":1},null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C159,Artikelen!A:A,Artikelen!C:C))","v":0},{"$f":"SUM(P159*J159)","v":0},null,158]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C160,locatie!A:A,locatie!B:B,),)","v":{"$error":"#N/A"}},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C160,locatie!A:A,locatie!C:C,),)","v":{"$error":"#N/A"}},"2x 1/2 toets lens cream",null,null,null,{"$f":"IF(factuur!$C160<>\"\",VLOOKUP(factuur!$C160,Artikelen!$A$2:$G$51,2,0),\"\")","v":"NIK10061507"},null,{"$f":"IF(factuur!$C160<>\"\",VLOOKUP(factuur!$C160,Artikelen!$A$2:$G$51,6,0),\"\")","v":2},2,{"$f":"IF(C160<>\"\",ROUNDUP(I160*J160,2),\"\")","v":4},null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C160,Artikelen!A:A,Artikelen!C:C))","v":0},{"$f":"SUM(P160*J160)","v":0},null,159]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C161,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C161,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C161<>\"\",VLOOKUP(factuur!$C161,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C161<>\"\",VLOOKUP(factuur!$C161,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},0,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C161,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,160]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C162,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C162,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C162<>\"\",VLOOKUP(factuur!$C162,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C162<>\"\",VLOOKUP(factuur!$C162,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},0,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C162,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,161]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C163,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C163,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C163<>\"\",VLOOKUP(factuur!$C163,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C163<>\"\",VLOOKUP(factuur!$C163,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},0,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C163,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,162]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C164,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C164,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C164<>\"\",VLOOKUP(factuur!$C164,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C164<>\"\",VLOOKUP(factuur!$C164,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C164,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,163]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C165,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C165,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C165<>\"\",VLOOKUP(factuur!$C165,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C165<>\"\",VLOOKUP(factuur!$C165,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C165,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,164]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C166,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C166,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C166<>\"\",VLOOKUP(factuur!$C166,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C166<>\"\",VLOOKUP(factuur!$C166,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C166,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,165]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C167,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C167,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C167<>\"\",VLOOKUP(factuur!$C167,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C167<>\"\",VLOOKUP(factuur!$C167,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C167,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,166]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C168,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C168,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C168<>\"\",VLOOKUP(factuur!$C168,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C168<>\"\",VLOOKUP(factuur!$C168,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C168,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,167]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C169,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C169,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C169<>\"\",VLOOKUP(factuur!$C169,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C169<>\"\",VLOOKUP(factuur!$C169,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C169,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,168]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C170,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C170,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C170<>\"\",VLOOKUP(factuur!$C170,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C170<>\"\",VLOOKUP(factuur!$C170,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C170,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,169]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C171,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C171,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C171<>\"\",VLOOKUP(factuur!$C171,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C171<>\"\",VLOOKUP(factuur!$C171,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C171,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,170]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C172,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C172,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C172<>\"\",VLOOKUP(factuur!$C172,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C172<>\"\",VLOOKUP(factuur!$C172,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C172,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,171]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C173,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C173,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C173<>\"\",VLOOKUP(factuur!$C173,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C173<>\"\",VLOOKUP(factuur!$C173,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C173,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,172]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C174,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C174,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C174<>\"\",VLOOKUP(factuur!$C174,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C174<>\"\",VLOOKUP(factuur!$C174,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C174,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,173]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C175,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C175,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C175<>\"\",VLOOKUP(factuur!$C175,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C175<>\"\",VLOOKUP(factuur!$C175,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C175,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,174]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C176,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C176,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C176<>\"\",VLOOKUP(factuur!$C176,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C176<>\"\",VLOOKUP(factuur!$C176,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C176,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,175]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C177,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C177,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C177<>\"\",VLOOKUP(factuur!$C177,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C177<>\"\",VLOOKUP(factuur!$C177,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C177,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,176]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C178,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C178,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C178<>\"\",VLOOKUP(factuur!$C178,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C178<>\"\",VLOOKUP(factuur!$C178,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C178,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,177]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C179,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C179,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C179<>\"\",VLOOKUP(factuur!$C179,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C179<>\"\",VLOOKUP(factuur!$C179,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C179,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,178]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C180,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C180,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C180<>\"\",VLOOKUP(factuur!$C180,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C180<>\"\",VLOOKUP(factuur!$C180,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C180,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,179]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C181,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C181,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C181<>\"\",VLOOKUP(factuur!$C181,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C181<>\"\",VLOOKUP(factuur!$C181,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C181,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,180]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C182,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C182,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C182<>\"\",VLOOKUP(factuur!$C182,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C182<>\"\",VLOOKUP(factuur!$C182,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C182,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,181]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C183,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C183,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C183<>\"\",VLOOKUP(factuur!$C183,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C183<>\"\",VLOOKUP(factuur!$C183,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C183,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,182]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C184,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C184,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C184<>\"\",VLOOKUP(factuur!$C184,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C184<>\"\",VLOOKUP(factuur!$C184,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C184,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,183]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C185,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C185,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C185<>\"\",VLOOKUP(factuur!$C185,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C185<>\"\",VLOOKUP(factuur!$C185,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C185,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,184]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C186,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C186,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C186<>\"\",VLOOKUP(factuur!$C186,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C186<>\"\",VLOOKUP(factuur!$C186,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C186,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,185]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C187,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C187,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C187<>\"\",VLOOKUP(factuur!$C187,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C187<>\"\",VLOOKUP(factuur!$C187,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C187,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,186]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C188,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C188,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C188<>\"\",VLOOKUP(factuur!$C188,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C188<>\"\",VLOOKUP(factuur!$C188,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C188,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,187]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C189,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C189,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C189<>\"\",VLOOKUP(factuur!$C189,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C189<>\"\",VLOOKUP(factuur!$C189,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C189,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,188]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C190,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C190,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C190<>\"\",VLOOKUP(factuur!$C190,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C190<>\"\",VLOOKUP(factuur!$C190,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C190,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,189]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C191,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C191,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C191<>\"\",VLOOKUP(factuur!$C191,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C191<>\"\",VLOOKUP(factuur!$C191,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C191,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,190]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C192,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C192,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C192<>\"\",VLOOKUP(factuur!$C192,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C192<>\"\",VLOOKUP(factuur!$C192,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C192,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,191]
[{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C193,locatie!A:A,locatie!B:B,),)","v":0},{"$f":"IF($J$6=klantenlisting!$B$3,_xlfn.XLOOKUP(C193,locatie!A:A,locatie!C:C,),)","v":0},null,null,null,null,{"$f":"IF(factuur!$C193<>\"\",VLOOKUP(factuur!$C193,Artikelen!$A$2:$G$51,2,0),\"\")","v":""},null,{"$f":"IF(factuur!$C193<>\"\",VLOOKUP(factuur!$C193,Artikelen!$A$2:$G$51,6,0),\"\")","v":""},null,"",null,null,null,null,{"$f":"IF(J6=klantenlisting!B3,,_xlfn.XLOOKUP(C193,Artikelen!A:A,Artikelen!C:C))","v":0},0,null,192]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,193]
[null,null,null,null,null,null,null,null,"Tussentotaal :  ",null,{"$f":"ROUNDUP(SUM(K159:L193),0.01)","v":5},null,null,null,null,null,null,null,194]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,195]
[{"$f":"IF($J$6=klantenlisting!$B$3,\"Maaltijd\",\"\")","v":"Maaltijd"},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($J$6=klantenlisting!$B$3,G198>1/1/2000),30,)","v":0},{"$f":"IF(AND($J$6=klantenlisting!$B$3,G198>1/1/2000),1,)","v":0},{"$f":"ROUNDUP(SUM(I198*J198),0.01)","v":0},null,null,null,null,"tussentotaal aankoop",null,null,197]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($J$6=klantenlisting!$B$3,G199>1/1/2000),30,)","v":0},{"$f":"IF(AND($J$6=klantenlisting!$B$3,G199>1/1/2000),1,)","v":0},{"$f":"ROUNDUP(SUM(I199*J199),0.01)","v":0},null,null,null,null,{"$f":"CEILING(SUM(Q159:Q193),0.01)","v":0},null,null,198]
[null,null,null,null,null,null,null,null,"Tussentotaal :  ",null,null,null,null,null,null,null,null,null,199]
[{"$f":"_xlfn.IFS($J$6=klantenlisting!$B$3,\"KM-vergoeding\",$B$11=$P$11,$P$27,$B$11=$P$9,\"\",$B$11=$P$10,\"\",$B$11=$P$12,\"\",$B$11=$P$13,\"\",$B$11=$P$15,\"\")","v":"KM-vergoeding"},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($J$6=klantenlisting!$B$3,G202>1/1/2000),$Q$32,\"\")","v":""},null,{"$f":"IF(AND(OR($J$6=klantenlisting!$B$3,$B$11=$P$11),G202>1/1/2000),ROUNDUP(I202*J202,2),\"\")","v":""},null,null,null,null,"tussentotaal verkoop"]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($J$6=klantenlisting!$B$3,G203>1/1/2000),$Q$32,\"\")","v":""},null,{"$f":"IF(AND(OR($J$6=klantenlisting!$B$3,$B$11=$P$11),G203>1/1/2000),ROUNDUP(I203*J203,2),\"\")","v":""},null,null,null,null,{"$f":"K195","v":5}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($J$6=klantenlisting!$B$3,G204>1/1/2000),$Q$32,\"\")","v":""},null,{"$f":"IF(AND(OR($J$6=klantenlisting!$B$3,$B$11=$P$11),G204>1/1/2000),ROUNDUP(I204*J204,2),\"\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND($J$6=klantenlisting!$B$3,G205>1/1/2000),$Q$32,\"\")","v":""},null,{"$f":"IF(AND(OR($J$6=klantenlisting!$B$3,$B$11=$P$11),G205>1/1/2000),ROUNDUP(I205*J205,2),\"\")","v":""}]
[]
[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-P203)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=P14,,\"Bijlage bij : \" & $D$11 &\" \" & $E$11)","v":"Bijlage bij : VK 2021-0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 van 20 juli 1970  tot vaststelling "]
[null,"van de tarieven van de belasting over de toegevoegde waarde en tot indeling van de goederen en diensten bij die tarieven."]
[]
[]
[null,{"$f":"\"Ondergetekende : \" & factuur!$J$6","v":"Ondergetekende : klant2"}]
[]
[null,{"$f":"\"Wonende te : \" & factuur!$J$8 & \" , \" & factuur!$J$9","v":"Wonende te : weg 12 , 1020 Hier"}]
[]
[null,"verklaart dat het gebouw gelegen te :",null,null,"…...................................................................................................................."]
[]
[null,"waarvan hij/zij"]
[null,null,"eigenaar"]
[null,null,"huurder"]
[null,null,"vruchtgebruiker"]
[null,null,"zaakvoerder"]
[null,"is, effectief in gebruik is sedert ten minste 10 jaar vòòr het eerste tijdstip van de verschuldigdheid van de btw op de werken"]
[null,"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 \"& factuur!$D$15 &\" en na de uitvoering van de vermelde werken effectief en\"","v":"die werd ondertekend op 11 maart 2021 en na de uitvoering van de vermelde werken effectief 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% 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, boeten en intresten,"]
[null,"waarvoor de  ondertekende verantwoordelijke is, ingevolge het 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 \" &$J$9","v":"Opgemaakt (in 2 exemplaren) te 1020 Hier"}]
[]
[null,{"$f":"\"Datum : \" & $D$15","v":"Datum : 11 maart 2021"}]
[]
[null,"Handtekening :"]
[]
[]
[]
["Terug te zenden naar de aannemer die de werken heeft uitgevoerd."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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 van 20 juli 1970  tot vaststelling "]
[null,"van de tarieven van de belasting over de toegevoegde waarde en tot indeling van de goederen en diensten bij die tarieven."]
[]
[]
[null,"Ondergetekende : klant2"]
[]
[null,"Wonende te : weg 12 , 1020 Hier"]
[]
[null,"verklaart dat het gebouw gelegen te :",null,null,"…...................................................................................................................."]
[]
[null,"waarvan hij/zij"]
[null,null,"eigenaar"]
[null,null,"huurder"]
[null,null,"vruchtgebruiker"]
[null,null,"zaakvoerder"]
[null,"is, effectief in gebruik is sedert ten minste 10 jaar vòòr het eerste tijdstip van de verschuldigdheid van de btw op de werken"]
[null,"die worden uitgevoerd overeenkomstig"]
[null,null,"de aannemingsovereenkomst"]
[null,null,"de bestelbon"]
[null,null,"de offerte"]
[null,null,"de factuur"]
[null,"die werd ondertekend op 11 maart 2021 en na de uitvoering van de vermelde werken effectief 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% van de volgende factu(u)r(en):"]
[null,"factuurnummer: VK 2021-0, van het jaar 2021."]
[]
[]
[null,"Ondertekende verklaart te weten  dat een foutieve verklaring aanleiding kan geven tot supplementaire BTW, boeten en intresten,"]
[null,"waarvoor de  ondertekende verantwoordelijke is, ingevolge het 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,"Opgemaakt (in 2 exemplaren) te 1020 Hier"]
[]
[null,"Datum : 11 maart 2021"]
[]
[null,"Handtekening :"]
[]
[]
[]
["Terug te zenden naar de aannemer die de werken heeft uitgevoerd."]

{"sheet":"Herinnering","index":1,"n_rows":105,"n_cols":46,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,10,2,12],[3,10,3,12],[5,10,5,13],[7,10,7,13],[8,10,8,13],[60,0,60,13],[10,1,11,6],[14,12,14,13],[3,48,3,50],[4,48,4,50],[7,48,7,51],[8,48,8,51],[9,48,9,49],[30,49,30,50],[10,38,11,43],[12,50,12,51],[14,41,14,44],[14,46,14,47],[14,50,14,51],[9,10,9,11]]}
["2021-01-10",{"$f":"factuur!B1","v":"aaa"}]
[null,{"$f":"factuur!B2","v":"bbb"}]
[null,{"$f":"factuur!B3","v":"ccc"},null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"}]
[1,{"$f":"factuur!B4","v":111},null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon\",_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!A:A),_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!A:A,klantenlisting!A6))","v":"cust-002"}]
[null,{"$f":"factuur!B5","v":"Ondn°:"},null,null,{"$f":"factuur!D5","v":"BE 012345678"}]
[2,null,null,null,null,null,null,null,null,null,{"$f":"factuur!J6","v":"klant2"}]
[null,{"$f":"IF(AND(factuur!L10>1,_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!K:K)>1),\"Klantnummer : \" & _xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!K:K),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(M10>1,\"t.a.v. \" & (_xlfn.XLOOKUP($K$6,klantenlisting!$B:$B,klantenlisting!$J:$J)),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!J8","v":"weg 12"}]
[3,null,null,null,null,null,null,null,null,null,{"$f":"factuur!J9","v":"1020 Hier"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!J10","v":""},null,{"$f":"_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!H:H,\" \")","v":0},null,"Herinnering."]
[null,"Herinnering.",null,null,null,null,null,null,null,null,null,null,null,null,"2e Herinnering."]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aanmaning."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Pelt, \" & factuur!$D$15","v":"Pelt, 11 maart 2021"},null,null,"2e Aanmaning."]
[]
[]
[5]
[null,{"$f":"\"Betreft factuur : \" & factuur!D11 & \" \" & factuur!E11","v":"Betreft factuur : VK 2021-0"}]
[]
[]
[null,"Geachte Heer, Mevrouw,"]
[]
[]
[null,{"$f":"\"Hierbij willen wij u informeren dat uw rekening nog een openstaand saldo vertoond van \" & factuur!$M$45 & \"€\"","v":"Hierbij willen wij u informeren dat uw rekening nog een openstaand saldo vertoond van 61€"}]
[null,{"$f":"\"op factuur : \" & factuur!D11 & \" \" & factuur!E11","v":"op factuur : VK 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,{"$f":"\"over te maken op onze rekening : \" & factuur!M54 & \" BIC: KREDBEBB met vermelding van het\"","v":"over te maken op onze rekening : BE132 BIC: KREDBEBB 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 "]
[]
[]
[]
[]
[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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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 14e dag na factuurdatum.",null,null,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(AJ10>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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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 14 dagen na factuurdatum.",null,null,null,null,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(AJ10>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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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,{"$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 ten minste 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,{"$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,{"$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,{"$f":"factuur!Z107","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!AO107","v":0}]

{"sheet":"Aangetekende","index":2,"n_rows":189,"n_cols":13,"rows_kept":189,"cut":false,"hidden":false,"merged":[[5,10,5,14],[10,1,11,7],[14,9,14,10],[14,13,14,14],[59,0,59,15],[33,9,33,10],[33,6,33,8],[33,12,33,14],[157,6,157,8],[157,9,157,10],[157,12,157,14],[154,0,154,9],[154,10,154,15]]}
["2021-01-10","aaa"]
[null,"bbb"]
[null,"ccc",null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon :\",\"Leverancier :\",\"Klantnummer :\")","v":"Klantnummer :"}]
[null,111,null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"Bestelbon\",_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!A:A),_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!A:A,\"\"))","v":"cust-002"}]
[null,"Ondn°:",null,null,"BE 0123456789"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"factuur!J6","v":"klant2"}]
[null,{"$f":"IF(AND(M10>1,_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!K:K)>1),\"Klantnummer : \" & _xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!K:K),)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(M10>1,\"t.a.v. \" & (_xlfn.XLOOKUP(K6,klantenlisting!$B:$B,klantenlisting!$J:$J)),)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!C:C,\" \")","v":"weg 12"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!E:E,\" \")","v":"1020 Hier"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M10>0,\"Ondn°:\",\"\")","v":""},null,{"$f":"_xlfn.XLOOKUP(K6,klantenlisting!B:B,klantenlisting!H:H,\" \")","v":0}]
[null,"Aangetekende zending."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Pelt, \" & factuur!$D$15","v":"Pelt, 11 maart 2021"}]
[]
[]
[]
[null,{"$f":"\"Betreft factuur : \"&factuur!$D$11&\" \"&factuur!$E$11","v":"Betreft factuur : VK 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 &\"€\" & \" per kerende te betalen op onze rekening : \" & factuur!$M$54 & \"   BIC: KREDBEBB,\"","v":"142,1€ per kerende te betalen op onze rekening : BE132   BIC: KREDBEBB,"}]
[null,"of ons een voorstel tot afbetaling te zenden per post of per mail op het volgend adres :"]
[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":" factuur!$D$11 & \" \" & factuur!$E$11","v":"VK 2021-0"},null,{"$f":"factuur!M45","v":61},null,null,{"$f":"SUM(D34*0.1)","v":6.1000000000000005},null,null,{"$f":"IF(D34*0.1>75,D34*0.1,75)","v":75},null,null,{"$f":"SUM(D34,G34,J34)","v":142.1}]
[]
[]
[]
[]
[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 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 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 ten minste 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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Voorstel tot afbetaling.",null,null,null,null,null,null,null,null,null,{"$f":"(factuur!J4)","v":"cust-002"}]
[]
[null,{"$f":"IF(B141=Q143,\"Factuur : vk\",\"\")","v":"Factuur : vk"},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":"factuur!$E$11","v":"2021-0"},null,{"$f":"factuur!M45","v":61},null,null,{"$f":"SUM(D158*0.1)","v":6.1000000000000005},null,null,{"$f":"IF(D158*0.1>75,D158*0.1,75)","v":75},null,null,{"$f":"SUM(D158,G158,J158)","v":142.1}]
[]
["( )","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":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["cust-000","Benaming","Adres","Adres 2","Postcode & gemeente","Tel / GSM","email","BTW-nr","herkenbare benaming","Aanspreektitel","klantnummer"]
["cust-001","klant1","straat 24",null,"8430  ergens"]
["cust-002","klant2","weg 12",null,"1020 Hier"]
["cust-003","klant3"]
["cust-004","klant4"]
["supp-001","BMW Financiel Services Belgium NV"]
["supp-002","Verisure - Securitas Direct NV"]
["supp-003","LCB LED EUROPE B.V."]
["supp-004","Comptabel BV"]
["supp-005","REXEL Belgium SA/NV"]
["supp-006","1EUROHOSTING"]
["supp-007","Vlaamse overheid - VKB"]
["supp-008","BRICCS"]
["supp-009","L.E.S. LANKLAAR NV"]
["supp-010","Telenet Group NV"]
["supp-011","B & A ACCOUNTANTS BVBA"]
["supp-012","TELENET GROUP SA"]
["supp-013","TELENET BVBA"]
["supp-014","iTunes and App Store"]
["supp-015","AUTOVEILIGHEID NV/AUTOKEURING"]
["supp-016","KBC Verzekeringen NV"]
["supp-017","SERVICE STATION OVERPELT"]
["supp-018","COLOR YOUR LIFE BVBA"]
["supp-019","GEMEENTEBESTUUR PELT"]
["supp-020","APPLE STORE"]
["supp-021","ENGELBERT STRAUSS BVBA"]
["supp-022","HOTEL HULST B.V."]
["supp-023","SPHINX"]
["supp-024","GIMO BVBA"]
["supp-025","paypal"]
["supp-026","DESAIR N.V."]
["supp-027","T.P.L. Belgium BVBA"]
["supp-028","Castor NV"]
["supp-029","Eurorent verhuurbedrijf NV"]
["supp-030","Microsoft 365 Family"]
["supp-031","Bol.com B.V."]
["supp-032","Madreco nv"]

{"sheet":"Artikelen","index":4,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Benaming","referentie","Kolom1","Leverancier","Categorie","Originele prijs","verm.factor korting"]
["1mod autom 2p 20a","abb2cdb111201R0204",null,"L.E.S. LANKLAAR NV","zekering",1]
["2x 1/2 toets lens cream","NIK10061507",null,"REXEL Belgium SA/NV","schakelaar",2]
["52M KAMGELEIDER L1-L2-L3-N / L1+N/L","FTGE89452130",null,"REXEL Belgium SA/NV","zekeringkast",3]
["afdekpl. 60mm 2-voudig cream","NIK10076200",null,"REXEL Belgium SA/NV","schakelaar",4]
["afdekpl. 60mm 3-voudig cream","NIK10076300",null,"REXEL Belgium SA/NV","schakelaar afwerking",5]
["afdekpl. 71mm 2-voudig cream","NIK10076800",null,"REXEL Belgium SA/NV","schakelaar afwerking",6]
["afdepkpl. Enkel cream","NIK10076100 ",null,"REXEL Belgium SA/NV","schakelaar afwerking",7]
["aftakdoos OPB.DS IP55","HEL250",null,"REXEL Belgium SA/NV","installatiemateriaal",8]
["aftakdoos plexo vierk. IP55","LEG092005",null,"REXEL Belgium SA/NV","installatiemateriaal",9]
["autom. Resi9 2P 16A","SERR9F64216",null,"REXEL Belgium SA/NV","zekering",10]
["autom. Resi9 2P 20A","SERR9F64220",null,"REXEL Belgium SA/NV","zekering",11]
["autom. Resi9 4p 32a","SERR9F64432",null,"REXEL Belgium SA/NV","zekering",12]
["bew.melder master","thethemuras180100upnwh",null,"REXEL Belgium SA/NV","schakelaar",13]
["bew.melder slave","THETHEMURAS180SLAVEUPWH",null,"REXEL Belgium SA/NV","schakelaar",14]
["buisklem beugel 20mm","REY0115",null,"REXEL Belgium SA/NV","installatiemateriaal",15]
["controlesch.2P 16A","NIK10076300",null,"REXEL Belgium SA/NV","schakelaar",16]
["deur voor kast","haggp413p",null,"REXEL Belgium SA/NV","zekeringkast",17]
["diff.4p 40a 30mA","SERR9R01440",null,"REXEL Belgium SA/NV","zekering",18]
["DLP einddeksel 50x80","LEG075755",null,"REXEL Belgium SA/NV","DLP goot",19]
["DLP gootafdichting 50x80/130","LEG075780",null,"REXEL Belgium SA/NV","DLP goot",20]
["DLP mosaic cdoos2x2P+A zwart","LEG077182",null,"REXEL Belgium SA/NV","DLP goot",21]
["DLP platte hoek","LEG075770",null,"REXEL Belgium SA/NV","DLP goot",22]
["DLP RJ45 CAT6 FTP 2mod zwart","LEG079485",null,"REXEL Belgium SA/NV","DLP goot",23]
["DLP wisselsch.easyled-10AX","LEG079111L",null,"REXEL Belgium SA/NV","DLP goot",24]
["DLP zwart klik-in 50x80x2m","LEG075750",null,"REXEL Belgium SA/NV","DLP goot",25]
["elflex 3G2,5","flxrexflex3g25",null,"REXEL Belgium SA/NV","bekabeling",26]
["hydro doos 2-voudig 3ing","NIK70084212",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",27]
["hydro doos enkel - wurgnippel","NIK70083101",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",28]
["invoertul M20 voor buis 16/20","ABBFOBCGM2",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",29]
["klein materiaal","kl.mat.",null,null,"materiaal",30]
["LED baten 120cm 40W 3000K","AR001970",null,"LCB LED EUROPE B.V.","verlichting",31]
["LED baten 90cm 30W 6000K","AR184469",null,"LCB LED EUROPE B.V.","verlichting",32]
["led schijnwerper + sensor","AR187422",null,"LCB LED EUROPE B.V.","verlichting",33]
["Makita haakse slijper 800W 125mm","9558HNRGZ",null,"Madreco nv","Elek. Gereedschap",34,0.9]
["opbouwdoos 1x 1xM20","NIK70084101",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",35]
["opbouwdoos enkel 2xM20","NIK70084102 ",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",36]
["PU schuim niet uitzettend","TEC7 PUFOAM",null,"BRICCS","materiaal",37]
["PVC buis lichtgrijs RAL7035 M20","BPP094112",null,"REXEL Belgium SA/NV","materiaal",38]
["sch. 2x wissel","NIK17002605",null,"REXEL Belgium SA/NV","schakelaar",39]
["Snelspankop voor haakse slijper","SDS clic-moer",null,"Madreco nv","Elek. Gereedschap",40]
["switch TP-link","TL-SG105",null,"Bol.com B.V.","internet",41]
["vega verdeelkast 18mod.","hagvb118r",null,"REXEL Belgium SA/NV","zekeringkast",42]
["verdeelkast 52mod","haggd413u",null,"REXEL Belgium SA/NV","zekeringkast",43]
["verdeelkast deur voor haggd413u","haggp413p",null,"REXEL Belgium SA/NV","zekeringkast",44]
["verdeelkast vector IP65 8+2M","HAGVE110M",null,"REXEL Belgium SA/NV","zekeringkast",45]
["verdeelkast vega 18mod.","hagvb118r",null,"REXEL Belgium SA/NV","zekeringkast",46]
["verl.eenheid blauw","NIK17037223",null,"REXEL Belgium SA/NV","schakelaar",47]
["WCD 2P+A+KV","NIK70036600",null,"REXEL Belgium SA/NV","schakelaar spatwaterdicht",48]
["wcd pen+veiligh cream 21diepte","NIK10066100",null,"REXEL Belgium SA/NV","schakelaar",49]
["wcd pen+veiligh cream 28,5diepte","NIK10066600",null,"REXEL Belgium SA/NV","schakelaar",50]

{"sheet":"locatie","index":5,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["locatie","dag","lange dag"]
[]
["antwerpen",1]
["antwerpen - lang",null,1]
["baal",1]
["baal - lang",null,1]
["boom",1]
["boom - lang",null,1]
["bredene",1]
["bredene - lang",null,1]
["dendermonde",1]
["dendermonde - lang",null,1]
["diegem",1]
["diegem - lang",null,1]
["essen",1]
["essen - lang",null,1]
["gavere",1]
["gavere - lang",null,1]
["gieten",1]
["gieten - lang",null,1]
["hamme",1]
["hamme - lang",null,1]
["herentals",1]
["herentals - lang",null,1]
["hoogerheide",1]
["hoogerheide - lang",null,1]
["hulst",1]
["hulst - lang",null,1]
["koksijde",1]
["koksijde - lang",null,1]
["koppenberg",1]
["koppenberg - lang",null,1]
["kortrijk",1]
["kortrijk - lang",null,1]
["lille",1]
["lille - lang",null,1]
["loenhout",1]
["loenhout - lang",null,1]
["memorial van damme",1]
["memorial van damme - lang",null,1]
["merksplas",1]
["merksplas - lang",null,1]
["meulebeke",1]
["meulebeke - lang",null,1]
["middelkerke",1]
["middelkerke - lang",null,1]
["namen",1]
["namen - lang",null,1]
["neerpelt",1]
["neerpelt - lang",null,1]
["niel",1]
["niel - lang",null,1]
["oostende",1]
["oostende - lang",null,1]
["oostmalle",1]
["oostmalle - lang",null,1]
["overijse",1]
["overijse - lang",null,1]
["Ronse",1]
["Ronse - lang",null,1]
["ruddervoorde",1]
["ruddervoorde - lang",null,1]
["valkenburg",1]
["valkenburg - lang",null,1]
["VUB Brussel",1]
["VUB Brussel - lang",null,1]
["waterloo",1]
["waterloo - lang",null,1]
["wevelgem",1]
["wevelgem - lang",null,1]
["zolder",1]
["zolder - lang",null,1]
["zonhoven",1]
["zonhoven - lang",null,1]