{"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":"¥749.50"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[销售额]]*tblSalesData[[#This Row],[税率]]","v":{"v":37.475,"d":"¥37.48"}},{"$f":"tblSalesData[[#This Row],[销售额]]+tblSalesData[[#This Row],[营业税]]","v":{"v":786.975,"d":"¥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":"¥349.90"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[销售额]]*tblSalesData[[#This Row],[税率]]","v":{"v":17.495,"d":"¥17.50"}},{"$f":"tblSalesData[[#This Row],[销售额]]+tblSalesData[[#This Row],[营业税]]","v":{"v":367.395,"d":"¥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":"¥559.50"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[销售额]]*tblSalesData[[#This Row],[税率]]","v":{"v":27.975,"d":"¥27.98"}},{"$f":"tblSalesData[[#This Row],[销售额]]+tblSalesData[[#This Row],[营业税]]","v":{"v":587.475,"d":"¥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":"¥29.50"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[销售额]]*tblSalesData[[#This Row],[税率]]","v":{"v":1.475,"d":"¥1.48"}},{"$f":"tblSalesData[[#This Row],[销售额]]+tblSalesData[[#This Row],[营业税]]","v":{"v":30.975,"d":"¥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":"¥149.80"},{"v":0.05,"d":"5.00%"},{"$f":"tblSalesData[[#This Row],[销售额]]*tblSalesData[[#This Row],[税率]]","v":{"v":7.490000000000001,"d":"¥7.49"}},{"$f":"tblSalesData[[#This Row],[销售额]]+tblSalesData[[#This Row],[营业税]]","v":{"v":157.29000000000002,"d":"¥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":"¥749.50"},{"v":37.475,"d":"¥37.48"},{"v":786.975,"d":"¥786.98"}]
[null,90002,"枕头","2012-02-01",{"v":149.8,"d":"¥149.80"},{"v":7.490000000000001,"d":"¥7.49"},{"v":157.29000000000002,"d":"¥157.29"}]
[null,90004,"方形盘","2012-02-01",{"v":29.5,"d":"¥29.50"},{"v":1.475,"d":"¥1.48"},{"v":30.975,"d":"¥30.98"}]
[null,90005,"圆形盘","2012-02-01",{"v":559.5,"d":"¥559.50"},{"v":27.975,"d":"¥27.98"},{"v":587.475,"d":"¥587.48"}]
[null,90023,"桌布（6 英寸圆形）","2012-02-01",{"v":349.9,"d":"¥349.90"},{"v":17.495,"d":"¥17.50"},{"v":367.395,"d":"¥367.40"}]
[null,"总计\n",null,null,{"v":1838.1999999999998,"d":"¥1,838.20"},{"v":91.91000000000001,"d":"¥91.91"},{"v":1930.1100000000001,"d":"¥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 英寸圆形）"]