{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Verkoopgegevens","Verkooprapport","Voorraad"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Verkoopgegevens","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"DAGELIJKSE KASVERKOOP"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"DATUM","TIJD","TRANSACTIENUMMER","SKU/PRODUCTNUMMER","BESCHRIJVING","VERKOOPBEDRAG","BTW %","BTW","TOTAAL"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"\",VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"Geen beschrijving gevonden\")","v":"Deken"},{"v":74.95,"d":"€ 74.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]*tblVerkoopgegevens[[#This Row],[BTW %]]","v":{"v":3.7475000000000005,"d":"€ 3.75"}},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]+tblVerkoopgegevens[[#This Row],[BTW]]","v":{"v":78.6975,"d":"€ 78.70"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"\",VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"Geen beschrijving gevonden\")","v":"Tafelkleed, 180 rond"},{"v":34.99,"d":"€ 34.99"},{"v":0.05,"d":"5.00%"},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]*tblVerkoopgegevens[[#This Row],[BTW %]]","v":{"v":1.7495000000000003,"d":"€ 1.75"}},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]+tblVerkoopgegevens[[#This Row],[BTW]]","v":{"v":36.7395,"d":"€ 36.74"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"\",VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"Geen beschrijving gevonden\")","v":"Rond bord"},{"v":55.95,"d":"€ 55.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]*tblVerkoopgegevens[[#This Row],[BTW %]]","v":{"v":2.7975000000000003,"d":"€ 2.80"}},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]+tblVerkoopgegevens[[#This Row],[BTW]]","v":{"v":58.7475,"d":"€ 58.75"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"\",VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"Geen beschrijving gevonden\")","v":"Vierkant bord"},{"v":2.95,"d":"€ 2.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]*tblVerkoopgegevens[[#This Row],[BTW %]]","v":{"v":0.14750000000000002,"d":"€ 0.15"}},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]+tblVerkoopgegevens[[#This Row],[BTW]]","v":{"v":3.0975,"d":"€ 3.10"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"\",VLOOKUP(tblVerkoopgegevens[[#This Row],[SKU/PRODUCTNUMMER]],tblVoorraad[],2,0)),\"Geen beschrijving gevonden\")","v":"Kussen"},{"v":14.98,"d":"€ 14.98"},{"v":0.05,"d":"5.00%"},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]*tblVerkoopgegevens[[#This Row],[BTW %]]","v":{"v":0.7490000000000001,"d":"€ 0.75"}},{"$f":"tblVerkoopgegevens[[#This Row],[VERKOOPBEDRAG]]+tblVerkoopgegevens[[#This Row],[BTW]]","v":{"v":15.729000000000001,"d":"€ 15.73"}}]

{"sheet":"Verkooprapport","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"DAGELIJKSE KASVERKOOP"]
[]
[]
[]
[]
[]
[null,"SKU/PRODUCTNUMMER","BESCHRIJVING","DATUM","Verkoopbedrag ","Btw ","Totaal "]
[null,90001,"Deken","2012-02-01",{"v":74.95,"d":"€ 74.95"},{"v":3.7475000000000005,"d":"€ 3.75"},{"v":78.6975,"d":"€ 78.70"}]
[null,90002,"Kussen","2012-02-01",{"v":14.98,"d":"€ 14.98"},{"v":0.7490000000000001,"d":"€ 0.75"},{"v":15.729000000000001,"d":"€ 15.73"}]
[null,90004,"Vierkant bord","2012-02-01",{"v":2.95,"d":"€ 2.95"},{"v":0.14750000000000002,"d":"€ 0.15"},{"v":3.0975,"d":"€ 3.10"}]
[null,90005,"Rond bord","2012-02-01",{"v":55.95,"d":"€ 55.95"},{"v":2.7975000000000003,"d":"€ 2.80"},{"v":58.7475,"d":"€ 58.75"}]
[null,90023,"Tafelkleed, 180 rond","2012-02-01",{"v":34.99,"d":"€ 34.99"},{"v":1.7495000000000003,"d":"€ 1.75"},{"v":36.7395,"d":"€ 36.74"}]
[null,"Grand Total",null,null,{"v":183.82000000000002,"d":"€ 183.82"},{"v":9.191000000000003,"d":"€ 9.19"},{"v":193.011,"d":"€ 193.01"}]

{"sheet":"Voorraad","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"DAGELIJKSE KASVERKOOP"]
[]
[]
[]
[]
[]
[null,"SKU/PRODUCTNUMMER","BESCHRIJVING"]
[null,90001,"Deken"]
[null,90002,"Kussen"]
[null,90003,"Lakens"]
[null,90004,"Vierkant bord"]
[null,90005,"Rond bord"]
[null,90006,"Kom, groot"]
[null,90007,"Kom, klein"]
[null,90008,"Rond bord, klein"]
[null,90009,"Vork, klein"]
[null,90010,"Vork, groot"]
[null,90011,"Lepel, klein"]
[null,90012,"Lepel, groot"]
[null,90013,"Botermes, klein"]
[null,90014,"Botermes, groot"]
[null,90015,"Tafelkleed, 300x150"]
[null,90016,"Tafelkleed, 250x150"]
[null,90017,"Tafelkleed, 250x250"]
[null,90018,"Tafelkleed, 180x180"]
[null,90019,"Tafelkleed, 180x120"]
[null,90020,"Tafelkleed, 120x120"]
[null,90021,"Tafelkleed, 300 rond"]
[null,90022,"Tafelkleed, 250 rond"]
[null,90023,"Tafelkleed, 180 rond"]