{"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":749.5,"d":"NT$749.50"},0.05,{"$f":"tblSalesData[[#This Row],[銷售金額]]*tblSalesData[[#This Row],[稅率]]","v":{"v":37.475,"d":"NT$37.48"}},{"$f":"tblSalesData[[#This Row],[銷售金額]]+tblSalesData[[#This Row],[營業稅]]","v":{"v":786.975,"d":"NT$786.98"}}]
[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":349.9,"d":"NT$349.90"},0.05,{"$f":"tblSalesData[[#This Row],[銷售金額]]*tblSalesData[[#This Row],[稅率]]","v":{"v":17.495,"d":"NT$17.50"}},{"$f":"tblSalesData[[#This Row],[銷售金額]]+tblSalesData[[#This Row],[營業稅]]","v":{"v":367.395,"d":"NT$367.40"}}]
[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":559.5,"d":"NT$559.50"},0.05,{"$f":"tblSalesData[[#This Row],[銷售金額]]*tblSalesData[[#This Row],[稅率]]","v":{"v":27.975,"d":"NT$27.98"}},{"$f":"tblSalesData[[#This Row],[銷售金額]]+tblSalesData[[#This Row],[營業稅]]","v":{"v":587.475,"d":"NT$587.48"}}]
[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":29.5,"d":"NT$29.50"},0.05,{"$f":"tblSalesData[[#This Row],[銷售金額]]*tblSalesData[[#This Row],[稅率]]","v":{"v":1.475,"d":"NT$1.48"}},{"$f":"tblSalesData[[#This Row],[銷售金額]]+tblSalesData[[#This Row],[營業稅]]","v":{"v":30.975,"d":"NT$30.98"}}]
[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":149.8,"d":"NT$149.80"},0.05,{"$f":"tblSalesData[[#This Row],[銷售金額]]*tblSalesData[[#This Row],[稅率]]","v":{"v":7.490000000000001,"d":"NT$7.49"}},{"$f":"tblSalesData[[#This Row],[銷售金額]]+tblSalesData[[#This Row],[營業稅]]","v":{"v":157.29000000000002,"d":"NT$157.29"}}]

{"sheet":"銷售報表","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"每日收銀機銷售額"]
[]
[]
[]
[]
[]
[null,"SKU/產品號碼","描述","日期","加總 - 銷售金額","加總 - 營業稅","加總 - 合計"]
[null,90001,"毛毯","2012-02-01",{"v":749.5,"d":"NT$749.50"},{"v":37.475,"d":"NT$37.48"},{"v":786.975,"d":"NT$786.98"}]
[null,90002,"枕頭","2012-02-01",{"v":149.8,"d":"NT$149.80"},{"v":7.490000000000001,"d":"NT$7.49"},{"v":157.29000000000002,"d":"NT$157.29"}]
[null,90004,"方盤","2012-02-01",{"v":29.5,"d":"NT$29.50"},{"v":1.475,"d":"NT$1.48"},{"v":30.975,"d":"NT$30.98"}]
[null,90005,"圓盤","2012-02-01",{"v":559.5,"d":"NT$559.50"},{"v":27.975,"d":"NT$27.98"},{"v":587.475,"d":"NT$587.48"}]
[null,90023,"桌布，直徑 6'","2012-02-01",{"v":349.9,"d":"NT$349.90"},{"v":17.495,"d":"NT$17.50"},{"v":367.395,"d":"NT$367.40"}]
[null,"總計",null,null,{"v":1838.1999999999998,"d":"NT$1,838.20"},{"v":91.91000000000001,"d":"NT$91.91"},{"v":1930.1100000000001,"d":"NT$1,930.11"}]

{"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'"]