{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Home","Factuur in","Factuur uit","openstaande rekeningen","Klanten","Leveranciers","Voorraad","Producten","Werknemers","Blad1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Factuur in","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","Productnaam","Aankopprijs","Aantal","Totaal"]
[1,"Bureaustoel ST (standaard stoel) ",{"$f":"IFERROR(VLOOKUP(B3,product,2,0),\"\")","v":33.33},10,{"$f":"IF(COUNT(C3,D3)=2,$C3*$D3,\"\")","v":333.29999999999995}]
[2,null,{"$f":"IFERROR(VLOOKUP(B4,product,2,0),\"\")","v":""},null,{"$f":"IF(COUNT(C4,D4)=2,$C4*$D4,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP(B5,product,2,0),\"\")","v":""},null,""]
[4,null,{"$f":"IFERROR(VLOOKUP(B6,product,2,0),\"\")","v":""},null,""]
[5,null,{"$f":"IFERROR(VLOOKUP(B7,product,2,0),\"\")","v":""},null,""]
[6,null,{"$f":"IFERROR(VLOOKUP(B8,product,2,0),\"\")","v":""},null,""]
[7,null,{"$f":"IFERROR(VLOOKUP(B9,product,2,0),\"\")","v":""},null,""]
[8,null,{"$f":"IFERROR(VLOOKUP(B10,product,2,0),\"\")","v":""},null,""]
[9,null,{"$f":"IFERROR(VLOOKUP(B11,product,2,0),\"\")","v":""},null,""]
[10,null,{"$f":"IFERROR(VLOOKUP(B12,product,2,0),\"\")","v":""},null,""]
[11,null,{"$f":"IFERROR(VLOOKUP(B13,product,2,0),\"\")","v":""},null,""]
[12,null,{"$f":"IFERROR(VLOOKUP(B14,product,2,0),\"\")","v":""},null,""]
[13,null,{"$f":"IFERROR(VLOOKUP(B15,product,2,0),\"\")","v":""},null,""]
[14,null,{"$f":"IFERROR(VLOOKUP(B16,product,2,0),\"\")","v":""},null,""]
[15,null,{"$f":"IFERROR(VLOOKUP(B17,product,2,0),\"\")","v":""},null,""]

{"sheet":"Factuur uit","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","Productnaam","Verkoopprijs","Aantal","Totaal"]
[1,"Bureaustoel ST (standaard stoel) ",{"$f":"IFERROR(VLOOKUP(B3,product,3,0),\"\")","v":99.99},8,{"$f":"IF(COUNT(C3,D3)=2,$C3*$D3,\"\")","v":799.92}]
[2,null,{"$f":"IFERROR(VLOOKUP(B4,product,3,0),\"\")","v":""},null,{"$f":"IF(COUNT(C4,D4)=2,$C4*$D4,\"\")","v":""}]
[3,null,{"$f":"IFERROR(VLOOKUP(B5,product,3,0),\"\")","v":""},null,""]
[4,null,{"$f":"IFERROR(VLOOKUP(B6,product,3,0),\"\")","v":""},null,""]
[5,null,{"$f":"IFERROR(VLOOKUP(B7,product,3,0),\"\")","v":""},null,""]
[6,null,{"$f":"IFERROR(VLOOKUP(B8,product,3,0),\"\")","v":""},null,""]
[7,null,{"$f":"IFERROR(VLOOKUP(B9,product,3,0),\"\")","v":""},null,""]
[8,null,{"$f":"IFERROR(VLOOKUP(B10,product,3,0),\"\")","v":""},null,""]
[9,null,{"$f":"IFERROR(VLOOKUP(B11,product,3,0),\"\")","v":""},null,""]
[10,null,{"$f":"IFERROR(VLOOKUP(B12,product,3,0),\"\")","v":""},null,""]
[11,null,{"$f":"IFERROR(VLOOKUP(B13,product,3,0),\"\")","v":""},null,""]
[12,null,{"$f":"IFERROR(VLOOKUP(B14,product,3,0),\"\")","v":""},null,""]
[13,null,{"$f":"IFERROR(VLOOKUP(B15,product,3,0),\"\")","v":""},null,""]
[14,null,{"$f":"IFERROR(VLOOKUP(B16,product,3,0),\"\")","v":""},null,""]
[15,null,{"$f":"IFERROR(VLOOKUP(B17,product,3,0),\"\")","v":""},null,""]
[]
["bedrag goederen",{"$f":"IF(COUNT(E3:E17)>0,SUM(E3:E17),\"\")","v":799.92}]
[null,null,"HK (-)",0.03,{"$f":"IF(COUNT(B19)=1,IF(B19>500,(B19/100*3),0),\"\")","v":23.997599999999998}]
[null,null,"FK (-)",0.02,{"$f":"IF(COUNT(B19)=1,(B19/100)*2,\"\")","v":15.998399999999998},"binnen de 8 dagen (niet voor particulieren)"]
[null,null,"BTW (+)",0.21,{"$f":"IF(COUNT(B19)=1,B19*D22,\"\")","v":167.98319999999998}]
[]
["totaalbedrag ",null,null,null,{"$f":"IF(COUNT(B19)=1,B19-E20+E22,\"\")","v":943.90559999999994}]

{"sheet":"openstaande rekeningen","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Klanten","index":4,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
["Ondernemers:"]
[]
["KlaCode","KlaNaam","Adres","Gemeente","Postcode","Ondernemingsnummer","Telefoon ","Fax"]
[2001,"Century 21 ","Luxemburgstraat 16 B","BRUSSEL",1000,452840243,"050/62.50.80","050/62.50.80"]
[{"$f":"$A5+1","v":2002},"AccentJobs","Beversesteenweg 576","Roeselare","8800 ",455069956,"051/46.05.00","051/46.05.00"]
[{"$f":"$A6+1","v":2003},"B&B Industriebouw","Haltstraat 84","Overpelt",3900,442036522,"+32 (0)11 80 33 36","+32 (0)11 80 33 37"]
[{"$f":"$A7+1","v":2004},"Tuinmeubelen Thooft","Moortelputstraat 1","Gent","B-9031",419553704,"09/282.31.22","09/282.31.22"]
[{"$f":"$A8+1","v":2005},"Belfius Vlaamse Ardennen CVBA","Nederstraat 17 ","Oudenaarde",9700,459674288,"0455/33.90.90","/"]
[{"$f":"$A9+1","v":2006},"Neckermann ","Voorstraat 36","Kortrijk ",8500,837437919,"056/21.98.17","/"]
[]
["Particulieren:"]
[]
["KlaCode","KlaNaam"]
[3001,"Hans"]
[{"$f":"$A15+1","v":3002},"Marie"]
[{"$f":"$A16+1","v":3003},"Lara"]
[3004,"Jan "]
[3005,"Lander"]
[3006,"Stefaan "]
[3007,"Natalie"]
[3008,"Els"]
[3009,"Yves"]
[3010,"Stefanie "]
[3011,"Geert "]

{"sheet":"Leveranciers","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["LevCode","LevNaam ","Adres ","Gemeente","Postcode","Ondernemingsnummer","Telefoon ","Fax"]
[1001,"I.M.B ","Posthoornstraat 11","Mechelen ",2800,405912336,"02/339.21.11","02/339.34.78"]
[{"$f":"$A5+1","v":1002},"Bruneau ","kortrijksesteenweg 140","Gent ",9000,465015822,"09/241.72.72","/"]
[1003,"OTTO OFFICE ","Interleuvenlaan 62","Leuven ",3000,889777931,"070/.23.40.00","070/23.40.00"]
[1004,"Buro Market ","Kortrijksesteenweg 1169","Gent ",9000,862222607,"02/725.14.14","02/725.16.16"]
[1005,"OffiSil","Krasnikstraat 15","Ruislede",8755,452228549," 051/68 69 80"," 051/68 69 80"]
[1006,"Schäfer Shop","Excelsiorlaan 14","Zaventem",1930,414944620,"02/725.00.00","02/725.00.00"]
[1007,"Tackburo","kortrijksesteenweg 5","Sint-Martens-Latem",9830,401089654,"09/225.28.15","09/233.12.77"]

{"sheet":"Voorraad","index":6,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","producten","Voorraad"]
[1,"Bureaustoel ST (standaard stoel) ",5]
[2,"Bureaustoel SU (super kwalitatief) ",5]
[3,"Bureautafel STK (standaard kwaliteit bureau klein) ",3]
[4,"Bureautafel STG (standaard kwaliteit bureau groot) ",3]
[5,"Bureautafel STN (standaard kwaliteit bureau normaal) ",3]
[6,"Bureautafel SUK (super kwalitatief klein, 2 gaten voor oplaadbedrading, 2 kastjes, 2 lades) ",3]
[7,"Bureautafel SUG (super kwalitatief groot, 4 gaten voor oplaadbedrading, 5 kastjes, 5 lades) ",3]
[8,"Bureautafel SUN (super kwalitatief normaal, 3 gaten voor oplaadbedrading, 3 kastjes, 3 lades)  ",3]
[9,"Archiefkast K (klein) (hoogte: 103 cm)",3]
[10,"Archiefkast N (normaal) ",3]
[11,"Archiefkast G (groot) (hoogte 198 cm)",3]
[12,"Sorteersysteem K (klein) (4 vakjes)",3]
[13,"Sorteersysteem N (normaal) (8 vakjes) ",3]
[14,"Sorteersysteem G (groot) (24 vakken)",3]
[15,"Printpapier  A4 (500 blaadjes) ",200]
[16,"Stylo’s ( groen, blauw, rood, zwart: /per stuk) ",200]
[17,"Nietjesmachine ",10]
[18,"Nietjes  1000",50]
[19,"Perforator ",10]
[20,"Ringmap (rug van 45 mm)",300]
[21,"Klasseringsmap  (rug van 8cm)",300]
[22,"Printer  ",3]
[23,"Inkt (zwart en kleur) ",100]
[24,"Rekenmachine  ",10]
[25,"Telefoon  ",10]
[26,"Papiermand  ",50]
[27,"Bureauonderlegger  52*65 cm",50]
[28,"Postbakje ",300]
[29,"Planningsbord ",3]
[30,"Agenda  ",100]
[31,"Stempel  ",20]
[32,"Enveloppes  (50 stuks)",200]
[33,"Alcoholstiften  ",100]
[34,"Etiketten  ( 100 bladzijden met 24 etiketten per blad) ",100]
[35,"Cursusblok  (100 bladzijden)",200]
[36,"Fotopapier  A4 (100 bladzijden)",100]
[37,"Markeringsstiften (blauw, geel, oranje, groen, roze)",200]
[38,"post-it geel (450 blaadjes) ",100]
[39,"correctiemiddel ",100]
[40,"U-mapje ",100]
[41,null,null,"(blanco lijn nodig voor factur uit)"]

{"sheet":"Producten","index":7,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","producten","aankoopprijs ","verkoopprijs/stuk "]
[1,"Bureaustoel ST (standaard stoel) ",{"$f":"$D3/3","v":33.33},99.99]
[2,"Bureaustoel SU (super kwalitatief) ",{"$f":"$D4/3","v":63.330000000000005},189.99]
[3,"Bureautafel STK (standaard kwaliteit bureau klein) ",19.663333333333334,58.99]
[4,"Bureautafel STG (standaard kwaliteit bureau groot) ",36.663333333333334,109.99]
[5,"Bureautafel STN (standaard kwaliteit bureau normaal) ",49.99666666666667,149.99]
[6,"Bureautafel SUK (super kwalitatief klein, 2 gaten voor oplaadbedrading, 2 kastjes, 2 lades) ",63.523333333333333,190.57]
[7,"Bureautafel SUN (super kwalitatief normaal, 3 gaten voor oplaadbedrading, 4 kastjes, 4 lades)  ",120.23,360.69]
[8,"Bureautafel SUG (super kwalitatief groot, 4 gaten voor oplaadbedrading, 5 kastjes, 5 lades) ",173.33,519.99]
[9,"Archiefkast K (klein) (hoogte: 103 cm)",128.93666666666667,386.81]
[10,"Archiefkast N (normaal) (hoogte 150cm)",136.78666666666666,410.36]
[11,"Archiefkast G (groot) (hoogte 198 cm)",149.24333333333334,447.73]
[12,"Sorteersysteem K (klein) (4 vakjes)",2.9866666666666668,8.9600000000000009]
[13,"Sorteersysteem N (normaal) (8 vakjes) ",5.7766666666666664,17.329999999999998]
[14,"Sorteersysteem G (groot) (24 vakken)",33.726666666666667,101.18]
[15,"Printpapier  A4 (500 blaadjes) ",2.4866666666666668,7.46]
[16,"Stylo’s ( groen, blauw, rood, zwart: /per stuk) ",0.11333333333333334,0.34]
[17,"Nietjesmachine ",6.66,19.98]
[18,"Nietjes  1000",9.9999999999999992E-2,0.3]
[19,"Perforator ",2.3066666666666666,6.92]
[20,"Ringmap (rug van 45 mm)",0.81333333333333335,2.44]
[21,"Klasseringsmap  (rug van 8cm)",0.41333333333333333,1.24]
[22,"Printer  ",35.663333333333334,106.99]
[23,"Inkt (zwart 1000pg en kleur 825pg) ",21.493333333333336,64.48]
[24,"Rekenmachine  ",1.6633333333333333,4.99]
[25,"Vaste telefoon met snoer ",6.666666666666667,20]
[26,"Papiermand  ",1.0966666666666667,3.29]
[27,"Bureauonderlegger  52*65 cm",3.0066666666666664,9.02]
[28,"Postbakje ",0.56999999999999995,1.71]
[29,"Planningsbord ",46.366666666666667,139.1]
[30,"Agenda  ",1.03,3.09]
[31,"Stempel  ",2.1933333333333334,6.58]
[32,"Enveloppes  (50 stuks)",0.48,1.44]
[33,"Alcoholstiften (zwart)",0.46333333333333332,1.39]
[34,"Etiketten  ( 100 bladzijden met 24 etiketten per blad) ",2.83,8.49]
[35,"Cursusblok  (100 bladzijden)",0.32,0.96]
[36,"Fotopapier  A4 (100 bladzijden)",4.76,14.28]
[37,"Markeringsstiften (blauw, geel, oranje, groen, roze)",9.6666666666666665E-2,0.28999999999999998]
[38,"post-it geel (450 blaadjes) ",2.2466666666666666,6.74]
[39,"correctiemiddel ",0.49666666666666665,1.49]
[40,"Alcoholstift (kleur)",0.46333333333333332,1.39]
[41,null,null,null,"(blanco lijn nodig voor factur uit)"]

{"sheet":"Werknemers","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Blad1","index":9,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Ik moet voor informatica een kassasysteem maken in excel maar weet niet hoe ik ervoor zorg dat mijn aantallen bij factuur in (zie excel in blijage) bij de  voorraad komt te staan (wij hebben dit-"]
[null," voorlopig opgelost door een kolom bij te maken (maar iedere keer dat we de factuur in wissen gaat ook het getal weg) Andere suggesties zijn ook toegestaan!"]