{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["ข้อมูลการขาย","รายงานยอดขาย","สินค้าคงคลัง"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"ข้อมูลการขาย","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"ยอดขายรายวันจากเครื่องเก็บเงิน"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"วันที่","เวลา","หมายเลขธุรกรรม","หมายเลขผลิตภัณฑ์/SKU","คำอธิบาย","ยอดขาย","% ภาษี","ภาษีขาย","ผลรวม"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"No description found\")","v":"ผ้าห่ม"},{"v":74.95,"d":"฿74.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]*tblSalesData[[#This Row],[% ภาษี]]","v":{"v":3.7475000000000005,"d":"฿3.75"}},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]+tblSalesData[[#This Row],[ภาษีขาย]]","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]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"No description found\")","v":"ผ้าปูโต๊ะ, กลม 6 ฟุต"},{"v":34.99,"d":"฿34.99"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]*tblSalesData[[#This Row],[% ภาษี]]","v":{"v":1.7495000000000003,"d":"฿1.75"}},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]+tblSalesData[[#This Row],[ภาษีขาย]]","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]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"No description found\")","v":"จานกลม"},{"v":55.95,"d":"฿55.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]*tblSalesData[[#This Row],[% ภาษี]]","v":{"v":2.7975000000000003,"d":"฿2.80"}},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]+tblSalesData[[#This Row],[ภาษีขาย]]","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]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"No description found\")","v":"จานสี่เหลี่ยม"},{"v":2.95,"d":"฿2.95"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]*tblSalesData[[#This Row],[% ภาษี]]","v":{"v":0.14750000000000002,"d":"฿0.15"}},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]+tblSalesData[[#This Row],[ภาษีขาย]]","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]],tblInventory[],2,0)),\"\",VLOOKUP(tblSalesData[[#This Row],[หมายเลขผลิตภัณฑ์/SKU]],tblInventory[],2,0)),\"No description found\")","v":"หมอน"},{"v":14.98,"d":"฿14.98"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]*tblSalesData[[#This Row],[% ภาษี]]","v":{"v":0.7490000000000001,"d":"฿0.75"}},{"$f":"tblSalesData[[#This Row],[ยอดขาย]]+tblSalesData[[#This Row],[ภาษีขาย]]","v":{"v":15.729000000000001,"d":"฿15.73"}}]

{"sheet":"รายงานยอดขาย","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"ยอดขายรายวันจากเครื่องเก็บเงิน"]
[]
[]
[]
[]
[]
[null,"หมายเลขผลิตภัณฑ์/SKU","คำอธิบาย","วันที่","ยอดขาย","ภาษีขาย ","ผลรวม "]
[null,90001,"ผ้าห่ม",null,{"v":7495,"d":"฿7,495.00"},{"v":374.75,"d":"฿374.75"},{"v":7869.75,"d":"฿7,869.75"}]
[null,90002,"หมอน","2012-02-01",{"v":14.98,"d":"฿14.98"},{"v":0.7490000000000001,"d":"฿0.75"},{"v":15.729000000000001,"d":"฿15.73"}]
[null,90004,"จานสี่เหลี่ยม","2012-02-01",{"v":2.95,"d":"฿2.95"},{"v":0.14750000000000002,"d":"฿0.15"},{"v":3.0975,"d":"฿3.10"}]
[null,90005,"จานกลม","2012-02-01",{"v":55.95,"d":"฿55.95"},{"v":2.7975000000000003,"d":"฿2.80"},{"v":58.7475,"d":"฿58.75"}]
[null,90023,"ผ้าปูโต๊ะ, กลม 6 ฟุต","2012-02-01",{"v":34.99,"d":"฿34.99"},{"v":1.7495000000000003,"d":"฿1.75"},{"v":36.7395,"d":"฿36.74"}]
[null,"ผลรวมทั้งหมด",null,null,{"v":7603.869999999999,"d":"฿7,603.87"},{"v":380.19350000000003,"d":"฿380.19"},{"v":7984.0635,"d":"฿7,984.06"}]

{"sheet":"สินค้าคงคลัง","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"ยอดขายรายวันจากเครื่องเก็บเงิน"]
[]
[]
[]
[]
[]
[null,"หมายเลขผลิตภัณฑ์/SKU","คำอธิบาย"]
[null,90001,"ผ้าห่ม"]
[null,90002,"หมอน"]
[null,90003,"ผ้าปูที่นอน"]
[null,90004,"จานสี่เหลี่ยม"]
[null,90005,"จานกลม"]
[null,90006,"ชาม, ใหญ่"]
[null,90007,"ชาม, เล็ก"]
[null,90008,"จานกลม, เล็ก"]
[null,90009,"ส้อม, เล็ก"]
[null,90010,"ส้อม, ใหญ่"]
[null,90011,"ช้อน, เล็ก"]
[null,90012,"ช้อน, ใหญ่"]
[null,90013,"มีดปาดเนย, เล็ก"]
[null,90014,"มีดปาดเนย, ใหญ่"]
[null,90015,"ผ้าปูโต๊ะ, 10x5"]
[null,90016,"ผ้าปูโต๊ะ, 8x5"]
[null,90017,"ผ้าปูโต๊ะ, 8x8"]
[null,90018,"ผ้าปูโต๊ะ, 6x6"]
[null,90019,"ผ้าปูโต๊ะ, 6x4"]
[null,90020,"ผ้าปูโต๊ะ, 4x4"]
[null,90021,"ผ้าปูโต๊ะ, กลม 10 ฟุต"]
[null,90022,"ผ้าปูโต๊ะ, กลม 8 ฟุต"]
[null,90023,"ผ้าปูโต๊ะ, กลม 6 ฟุต"]