{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Myyntitiedot","Myyntiraportti","Varasto"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Myyntitiedot","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"PÄIVITTÄINEN KASSAMYYNTI"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"PÄIVÄMÄÄRÄ","AIKA","TAPAHTUMANUMERO","SKU/TUOTENUMERO","KUVAUS","MYYNTISUMMA","VERO-%","ALV","YHTEENSÄ"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"No description found\")","v":"Peitto"},{"v":74.95,"d":"€74.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]*tblSalesData[[#This Row],[VERO-%]]","v":{"v":3.7475000000000005,"d":"€3.75"}},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]+tblSalesData[[#This Row],[ALV]]","v":{"v":78.6975,"d":"€78.70"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"No description found\")","v":"Pöytäliina, 6' pyöreä"},{"v":34.99,"d":"€34.99"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]*tblSalesData[[#This Row],[VERO-%]]","v":{"v":1.7495000000000003,"d":"€1.75"}},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]+tblSalesData[[#This Row],[ALV]]","v":{"v":36.7395,"d":"€36.74"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"No description found\")","v":"Pyöreä lautanen"},{"v":55.95,"d":"€55.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]*tblSalesData[[#This Row],[VERO-%]]","v":{"v":2.7975000000000003,"d":"€2.80"}},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]+tblSalesData[[#This Row],[ALV]]","v":{"v":58.7475,"d":"€58.75"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"No description found\")","v":"Kantikas lautanen"},{"v":2.95,"d":"€2.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]*tblSalesData[[#This Row],[VERO-%]]","v":{"v":0.14750000000000002,"d":"€0.15"}},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]+tblSalesData[[#This Row],[ALV]]","v":{"v":3.0975,"d":"€3.10"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[SKU/TUOTENUMERO]],tblInventory[],2,0)),\"No description found\")","v":"Tyyny"},{"v":14.98,"d":"€14.98"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]*tblSalesData[[#This Row],[VERO-%]]","v":{"v":0.7490000000000001,"d":"€0.75"}},{"$f":"tblSalesData[[#This Row],[MYYNTISUMMA]]+tblSalesData[[#This Row],[ALV]]","v":{"v":15.729000000000001,"d":"€15.73"}}]

{"sheet":"Myyntiraportti","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"PÄIVITTÄINEN KASSAMYYNTI"]
[]
[]
[]
[]
[]
[null,"SKU/TUOTENUMERO","KUVAUS","PÄIVÄMÄÄRÄ","Myyntisumma ","Alv","Yhteensä"]
[null,90001,"Peitto","2012-02-01",7495,374.75,7869.75]
[null,90002,"Tyyny","2012-02-01",14.98,0.7490000000000001,15.729000000000001]
[null,90004,"Kantikas lautanen","2012-02-01",2.95,0.14750000000000002,3.0975]
[null,90005,"Pyöreä lautanen","2012-02-01",55.95,2.7975000000000003,58.7475]
[null,90023,"Pöytäliina, 6' pyöreä","2012-02-01",34.99,1.7495000000000003,36.7395]
[null,"Kaikki yhteensä",null,null,7603.869999999999,380.19350000000003,7984.0635]

{"sheet":"Varasto","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"PÄIVITTÄINEN KASSAMYYNTI"]
[]
[]
[]
[]
[]
[null,"SKU/TUOTENUMERO","KUVAUS"]
[null,90001,"Peitto"]
[null,90002,"Tyyny"]
[null,90003,"Lakanat"]
[null,90004,"Kantikas lautanen"]
[null,90005,"Pyöreä lautanen"]
[null,90006,"Kulho, suuri"]
[null,90007,"Kulho, pieni"]
[null,90008,"Pyöreä lautanen, pieni"]
[null,90009,"Haarukka, pieni"]
[null,90010,"Haarukka, suuri"]
[null,90011,"Lusikka, pieni"]
[null,90012,"Lusikka, suuri"]
[null,90013,"Voiveitsi, pieni"]
[null,90014,"Voiveitsi, suuri"]
[null,90015,"Pöytäliina, 10x5"]
[null,90016,"Pöytäliina, 8x5"]
[null,90017,"Pöytäliina, 8x8"]
[null,90018,"Pöytäliina, 6x6"]
[null,90019,"Pöytäliina, 6x4"]
[null,90020,"Pöytäliina, 4x4"]
[null,90021,"Pöytäliina, 10' pyöreä"]
[null,90022,"Pöytäliina, 8' pyöreä"]
[null,90023,"Pöytäliina, 6' pyöreä"]