{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Home","Factuur in","Factuur uit","openstaande rekeningen","Klanten","Leveranciers","Voorraad","Producten","Werknemers","Grafieken"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":6,"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":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,1,6,25],[20,1,20,3]]}
[null,"Welkom bij Desk Supplies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF(SUM(melding>0),\"Controleer de voorraad\",\"\")","v":"Controleer de voorraad"}]

{"sheet":"Factuur in","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","Leveranciers","Productnaam","Aankoopprijs","Aantal","Totaal EXCL. BTW","Totaal INCL. BTW"]
[1,null,"Bureaustoel ST (standaard stoel) ",{"$f":"IFERROR(VLOOKUP(C3,product,2,0),\"\")","v":33.33},10,{"$f":"IF(COUNT(D3:E4)=2,$D3*$E3,\"\")","v":333.29999999999995},{"$f":"IF(COUNT(F3)=1,($F3*$E$20)+$F3,\"\")","v":403.29299999999995}]
[2,null,null,"",null,{"$f":"IF(COUNT(D4:E5)=2,$D4*$E4,\"\")","v":""},{"$f":"IF(COUNT(F4)=1,($F4*$E$20)+$F4,\"\")","v":""}]
[3,null,null,"",null,"",""]
[4,null,null,"",null,"",""]
[5,null,null,"",null,"",""]
[6,null,null,"",null,"",""]
[7,null,null,"",null,"",""]
[8,null,null,"",null,"",""]
[9,null,null,"",null,"",""]
[10,null,null,"",null,"",""]
[11,null,null,"",null,"",""]
[12,null,null,"",null,"",""]
[13,null,null,"",null,"",""]
[14,null,null,"",null,"",""]
[15,null,null,"",null,"",""]
[]
["bedrag goederen exclusief BTW",null,{"$f":"SUM(F3:F17)","v":333.29999999999995}]
[null,null,null,"BTW (+)",0.21,{"$f":"C19*E20","v":69.992999999999981}]
["totaalbedrag inclusief BTW",null,null,null,null,{"$f":"$C$19+$F$20","v":403.29299999999995}]

{"sheet":"Factuur uit","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","KlantenNaam","Productnaam","Verkoopprijs","Aantal","Totaal EXCL. BTW","Totaal INCL. BTW","In voorraad"]
[1,null,null,{"$f":"IFERROR(VLOOKUP(C3,product,3,0),\"\")","v":""},null,{"$f":"IF(COUNT(D3,E3)=2,$D3*$E3,\"\")","v":""},{"$f":"IF(COUNT(F3)=1,($F3*$E$20)+$F3,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C3,voorraden,7,0),\"\")","v":""}]
[2,null,null,"",null,{"$f":"IF(COUNT(D4,E4)=2,$D4*$E4,\"\")","v":""},{"$f":"IF(COUNT(F4)=1,($F4*$E$20)+$F4,\"\")","v":""},""]
[3,null,null,"",null,"","",""]
[4,null,null,"",null,"","",""]
[5,null,null,"",null,"","",""]
[6,null,null,"",null,"","",""]
[7,null,null,"",null,"","",""]
[8,null,null,"",null,"","",""]
[9,null,null,"",null,"","",""]
[10,null,null,"",null,"","",""]
[11,null,null,"",null,"","",""]
[12,null,null,"",null,"","",""]
[13,null,null,"",null,"","",""]
[14,null,null,"",null,"","",""]
[15,null,null,"",null,"","",""]
[]
["Bedrag goederen exclusief BTW",null,{"$f":"SUM(F3:F17)","v":0}]
[null,null,null,"HK (-)",0.03,{"$f":"IF(C19>500,(C19/100*3),0)","v":0}]
[null,null,null,"FK (-)",0.02,{"$f":"(C19/100)*2","v":0},"binnen de 8 dagen (niet voor particulieren)"]
[null,null,null,"BTW (+)",0.21,{"$f":"C19*E22","v":0}]
[]
["Totaalbedrag inclusief BTW",null,null,null,null,{"$f":"C19-F20+F22","v":0}]

{"sheet":"openstaande rekeningen","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
["Handelsdebiteuren:"]
[]
["KlaCode","KlaNaam","Adres","Gemeente","Postcode","Ondernemingsnummer","Telefoon ","Fax","Te Betalen "]
[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","/"]
[]
["KlaCode","KlaNaam","Te Betalen "]
[3001,"Hans"]
[{"$f":"$A13+1","v":3002},"Marie"]
[{"$f":"$A14+1","v":3003},"Lara"]
[3004,"Jan "]
[3005,"Lander"]
[3006,"Stefaan "]
[3007,"Natalie"]
[3008,"Els"]
[3009,"Yves"]
[3010,"Stefanie "]
[3011,"Geert "]
[]
["Schulden T.O.V. Leveranciers:"]
[]
["LevCode","LevNaam ","Adres ","Gemeente","Postcode","Ondernemingsnummer","Telefoon ","Fax","Te betalen "]
[1001,"I.M.B ","Posthoornstraat 11","Mechelen ",2800,405912336,"02/339.21.11","02/339.34.78"]
[{"$f":"$A28+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":"Klanten","index":4,"n_rows":316,"n_cols":8,"rows_kept":316,"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","/"]
[{"$f":"$A10+1","v":2007}]
[2008]
[2009]
[2010]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[]
["Particulieren:"]
[]
["KlaCode","KlaNaam"]
[3001,"Hans"]
[{"$f":"$A29+1","v":3002},"Marie"]
[3003,"Lara"]
[3004,"Jan "]
[3005,"Lander"]
[3006,"Stefaan "]
[3007,"Natalie"]
[3008,"Els"]
[3009,"Yves"]
[3010,"Stefanie "]
[3011,"Geert "]
[3012]
[3013]
[3014]
[3015]
[3016]
[3017]
[3018]
[3019]
[{"$f":"$A47+1","v":3020}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Century 21 "]
["AccentJobs"]
["B&B Industriebouw"]
["Tuinmeubelen Thooft"]
["Belfius Vlaamse Ardennen CVBA"]
["Neckermann "]
["Hans"]
["Marie"]
["Lara"]
["Jan "]
["Lander"]
["Stefaan "]
["Natalie"]
["Els"]
["Yves"]
["Stefanie "]
["Geert "]

{"sheet":"Leveranciers","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Leveranciers:"]
[]
["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":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Nr.","Producten","Min. Voorraad","Bijbesteld","Verkochte goederen","inkoop","verkoop","Voorraad"]
[1,"Bureaustoel ST (standaard stoel) ",5,{"$f":"IFERROR(VLOOKUP(B3,inkoop,3,0),0)+F3","v":20},{"$f":"IFERROR(VLOOKUP(B3,verkoop,3,0),0)+G3","v":0},10,0,{"$f":"F3-G3","v":10},{"$f":"--(C3>H3)","v":0}]
[2,"Bureaustoel SU (super kwalitatief) ",5,0,0,0,0,{"$f":"F4-G4","v":0},{"$f":"--(C4>H4)","v":1}]
[3,"Bureautafel STK (standaard kwaliteit bureau klein) ",3,0,0,0,0,0,{"$f":"--(C5>G5)","v":1}]
[4,"Bureautafel STG (standaard kwaliteit bureau groot) ",3,0,0,0,0,0,1]
[5,"Bureautafel STN (standaard kwaliteit bureau normaal) ",3,0,0,0,0,0,1]
[6,"Bureautafel SUK (super kwalitatief klein, 2 gaten voor oplaadbedrading, 2 kastjes, 2 lades) ",3,0,0,0,0,0,1]
[7,"Bureautafel SUN (super kwalitatief normaal, 3 gaten voor oplaadbedrading, 4 kastjes, 4 lades)  ",3,0,0,0,0,0,1]
[8,"Bureautafel SUG (super kwalitatief groot, 4 gaten voor oplaadbedrading, 5 kastjes, 5 lades) ",3,0,0,0,0,0,1]
[9,"Archiefkast K (klein) (hoogte: 103 cm)",3,0,0,0,0,0,1]
[10,"Archiefkast N (normaal) (hoogte 150cm)",3,0,0,0,0,0,1]
[11,"Archiefkast G (groot) (hoogte 198 cm)",3,0,0,0,0,0,1]
[12,"Sorteersysteem K (klein) (4 vakjes)",3,0,0,0,0,0,1]
[13,"Sorteersysteem N (normaal) (8 vakjes) ",3,0,0,0,0,0,1]
[14,"Sorteersysteem G (groot) (24 vakken)",3,0,0,0,0,0,1]
[15,"Printpapier  A4 (500 blaadjes) ",200,0,0,0,0,0,1]
[16,"Stylo’s ( groen, blauw, rood, zwart: /per stuk) ",200,0,0,0,0,0,1]
[17,"Nietjesmachine ",10,0,0,0,0,0,1]
[18,"Nietjes  1000",50,0,0,0,0,0,1]
[19,"Perforator ",10,0,0,0,0,0,1]
[20,"Ringmap (rug van 45 mm)",300,0,0,0,0,0,1]
[21,"Klasseringsmap  (rug van 8cm)",300,0,0,0,0,0,1]
[22,"Printer  ",3,0,0,0,0,0,1]
[23,"Inkt (zwart 1000pg en kleur 825pg) ",100,0,0,0,0,0,1]
[24,"Rekenmachine  ",10,0,0,0,0,0,1]
[25,"Vaste telefoon met snoer ",10,0,0,0,0,0,1]
[26,"Papiermand  ",50,0,0,0,0,0,1]
[27,"Bureauonderlegger  52*65 cm",50,0,0,0,0,0,1]
[28,"Postbakje ",300,0,0,0,0,0,1]
[29,"Planningsbord ",3,0,0,0,0,0,1]
[30,"Agenda  ",100,0,0,0,0,0,1]
[31,"Stempel  ",20,0,0,0,0,0,1]
[32,"Enveloppes  (50 stuks)",200,0,0,0,0,0,1]
[33,"Alcoholstiften (zwart)",100,0,0,0,0,0,1]
[34,"Etiketten  ( 100 bladzijden met 24 etiketten per blad) ",100,0,0,0,0,0,1]
[35,"Cursusblok  (100 bladzijden)",200,0,0,0,0,0,1]
[36,"Fotopapier  A4 (100 bladzijden)",100,0,0,0,0,0,1]
[37,"Markeringsstiften (blauw, geel, oranje, groen, roze)",200,0,0,0,0,0,1]
[38,"post-it geel (450 blaadjes) ",100,0,0,0,0,0,1]
[39,"correctiemiddel ",100,0,0,0,0,0,1]
[40,"Alcoholstift (kleur)",100,0,0,0,0,0,1]
[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,"Bureaustoel ST (standaard stoel) ",{"$f":"$D43/3","v":-17.617461538461434},-52.852384615384302,"(blanco lijn nodig voor factur uit)"]

{"sheet":"Werknemers","index":8,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
["Werknemers:"]
[]
["Werknemer Naam ","Adres ","Gemeente","Postcode","Telefoon "]
["Siebe Noppe","Kappel Milanendreef 28","Zwevegem",8550,"04/790.45.507"]
["Michaël Desmet","Hinnestraat 19G","Zwevegem",8550,"04/928.43.170"]
["Robbie Vanmeerhaeghe","Meiweg 39","Zwevegem",8550,"04/980.52.833"]

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