{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["产品销售报表","历史数据","价目单","价格点透视","销售趋势透视"],"not_rendered":{"charts":2,"defined_names":6,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"产品销售报表","index":0,"n_rows":20,"n_cols":2,"rows_kept":20}
[null,"产品销售报表"]
{"$rows_empty":18}
[null," 产品"]

{"sheet":"历史数据","index":1,"n_rows":33,"n_cols":10,"rows_kept":33}
[null,"历史产品价格列表和销售"]
[]
[null,"产品 ID","产品名称","价格日期","单位零售价","单位批发价*","售出件数（零售）","售出件数（批发）","总销售（数量）","总销售（金额）"]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2012-01-01",200,{"v":200,"d":"¥200"},629,{"v":1254,"d":"1,254"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1883,"d":"1,883"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":376600,"d":"¥376,600"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-01-01",880,{"v":540,"d":"¥540"},734,{"v":1427,"d":"1,427"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2161,"d":"2,161"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1416500,"d":"¥1,416,500"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-01-01",700,{"v":440,"d":"¥440"},744,{"v":1043,"d":"1,043"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1787,"d":"1,787"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":979720,"d":"¥979,720"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-01-01",630,{"v":440,"d":"¥440"},681,{"v":1523,"d":"1,523"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2204,"d":"2,204"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1099150,"d":"¥1,099,150"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-01-01",350,{"v":270,"d":"¥270"},602,{"v":1822,"d":"1,822"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2424,"d":"2,424"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":702640,"d":"¥702,640"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-02-01",550,{"v":440,"d":"¥440"},678,{"v":1515,"d":"1,515"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2193,"d":"2,193"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1039500,"d":"¥1,039,500"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-02-01",830,{"v":540,"d":"¥540"},753,{"v":1005,"d":"1,005"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1758,"d":"1,758"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1167690,"d":"¥1,167,690"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-02-01",340,{"v":340,"d":"¥340"},986,{"v":1069,"d":"1,069"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2055,"d":"2,055"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":698700,"d":"¥698,700"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-02-01",350,{"v":250,"d":"¥250"},848,{"v":1211,"d":"1,211"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2059,"d":"2,059"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":599550,"d":"¥599,550"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2012-02-01",410,{"v":380,"d":"¥380"},980,{"v":1330,"d":"1,330"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2310,"d":"2,310"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":907200,"d":"¥907,200"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-02-29",270,{"v":180,"d":"¥180"},533,{"v":1936,"d":"1,936"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2469,"d":"2,469"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":492390,"d":"¥492,390"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-02-29",380,{"v":280,"d":"¥280"},952,{"v":1512,"d":"1,512"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2464,"d":"2,464"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":785120,"d":"¥785,120"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-02-29",920,{"v":920,"d":"¥920"},956,{"v":1266,"d":"1,266"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2222,"d":"2,222"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":2044240,"d":"¥2,044,240"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-02-29",430,{"v":360,"d":"¥360"},952,{"v":1390,"d":"1,390"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2342,"d":"2,342"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":909760,"d":"¥909,760"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2012-02-29",980,{"v":730,"d":"¥730"},530,{"v":1452,"d":"1,452"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1982,"d":"1,982"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1579360,"d":"¥1,579,360"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-03-31",380,{"v":280,"d":"¥280"},973,{"v":1415,"d":"1,415"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2388,"d":"2,388"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":765940,"d":"¥765,940"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-03-31",500,{"v":360,"d":"¥360"},672,{"v":1105,"d":"1,105"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1777,"d":"1,777"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":733800,"d":"¥733,800"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-03-31",240,{"v":230,"d":"¥230"},769,{"v":1629,"d":"1,629"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2398,"d":"2,398"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":559230,"d":"¥559,230"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-03-31",720,{"v":570,"d":"¥570"},985,{"v":1848,"d":"1,848"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2833,"d":"2,833"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1762560,"d":"¥1,762,560"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2012-03-31",850,{"v":430,"d":"¥430"},721,{"v":1426,"d":"1,426"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2147,"d":"2,147"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1226030,"d":"¥1,226,030"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-04-30",910,{"v":650,"d":"¥650"},603,{"v":1226,"d":"1,226"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1829,"d":"1,829"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1345630,"d":"¥1,345,630"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-04-30",910,{"v":550,"d":"¥550"},892,{"v":1823,"d":"1,823"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2715,"d":"2,715"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1814370,"d":"¥1,814,370"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-04-30",420,{"v":420,"d":"¥420"},611,{"v":1181,"d":"1,181"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1792,"d":"1,792"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":752640,"d":"¥752,640"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-04-30",850,{"v":430,"d":"¥430"},530,{"v":1039,"d":"1,039"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1569,"d":"1,569"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":897270,"d":"¥897,270"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2012-04-30",820,{"v":710,"d":"¥710"},716,{"v":1249,"d":"1,249"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":1965,"d":"1,965"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1473910,"d":"¥1,473,910"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"衬衫"},"2012-05-14",340,{"v":310,"d":"¥310"},850,{"v":1548,"d":"1,548"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2398,"d":"2,398"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":768880,"d":"¥768,880"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"凉鞋"},"2012-05-14",640,{"v":400,"d":"¥400"},876,{"v":1663,"d":"1,663"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2539,"d":"2,539"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":1225840,"d":"¥1,225,840"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"雨伞"},"2012-05-14",330,{"v":300,"d":"¥300"},881,{"v":1149,"d":"1,149"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2030,"d":"2,030"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":635430,"d":"¥635,430"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"水瓶"},"2012-05-14",290,{"v":270,"d":"¥270"},802,{"v":1548,"d":"1,548"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2350,"d":"2,350"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":650540,"d":"¥650,540"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[产品 ID]]<>\"\",VLOOKUP(tblSales[产品 ID],tblProducts[[产品 ID]:[名称]],2,FALSE),\"\"),\"未知产品 ID\")","v":"短裤"},"2013-12-11",240,{"v":150,"d":"¥150"},824,{"v":1994,"d":"1,994"},{"$f":"tblSales[[#This Row],[售出件数（零售）]]+tblSales[[#This Row],[售出件数（批发）]]","v":{"v":2818,"d":"2,818"}},{"$f":"tblSales[[#This Row],[售出件数（零售）]]*tblSales[[#This Row],[单位零售价]]+tblSales[[#This Row],[售出件数（批发）]]*tblSales[[#This Row],[单位批发价*]]","v":{"v":496860,"d":"¥496,860"}}]

{"sheet":"价目单","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[15,1,15,5]]}
[null,"产品价格列表"]
[]
[null,"嘉元实业"]
[null,"23456 Maple Street"]
[null,"Springfield，CA 77503"]
[null,"电话：(425) 555-0150"]
[null,"传真： (425) 555-0152"]
[null,"www.adventure-works.com",{"$nulls":3},"最近更新 2013 年 8 月 15 日"]
[]
[null,"产品 ID","名称","描述","单位零售价","单位批发价*"]
[null,1,"衬衫","我们的 100% 预缩棉衬衫让您清凉一夏。",{"v":220,"d":"¥220"},{"v":150,"d":"¥150.00"}]
[null,2,"凉鞋","穿上我们的厚胶底凉鞋，炙热的沙滩也任凭您随心行走。",{"v":100,"d":"¥100"},{"v":60,"d":"¥60.00"}]
[null,3,"雨伞","我们的超大海滩遮阳伞阻隔 96% 有害紫外线，让您健康畅享海滨乐趣。",{"v":300,"d":"¥300"},{"v":200,"d":"¥200.00"}]
[null,4,"水瓶","隔热水瓶给您清凉畅饮。",{"v":70,"d":"¥70"},{"v":50,"d":"¥50.00"}]
[null,5,"短裤","我们的超快速干爽尼龙短裤让您无惧雨水直抵爱车。",{"v":150,"d":"¥150"},{"v":80,"d":"¥80.00"}]
[]
[{"$nulls":5},"请联系我们了解未列出的项目。"]
[{"$nulls":5},"*批发价格适用于 12 件及以上的件数。"]

{"sheet":"价格点透视","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"hidden":true,"merged":[[1,1,1,3]]}
[null,"价格点数据透视表"]
[null,"此工作表应保持隐藏。对下方数据透视表做出的修改可能导致产品销售报表中数据错误。 "]
[null,"选定产品：",{"$f":"IF(LEN(B5),B5,\"无\")","v":"凉鞋"}]
[null,"产品名称","单位零售价","求和项:总销售（数量）"]
[null,"凉鞋",{"v":380,"d":"¥380"},2464]
[null,null,{"v":500,"d":"¥500"},1777]
[null,null,{"v":640,"d":"¥640"},2539]
[null,null,{"v":700,"d":"¥700"},1787]
[null,null,{"v":830,"d":"¥830"},1758]
[null,null,{"v":910,"d":"¥910"},2715]

{"sheet":"销售趋势透视","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"hidden":true,"merged":[[1,1,1,3]]}
[null,"销售趋势数据透视表"]
[null,"此工作表应保持隐藏。对下方数据透视表做出的修改可能导致产品销售报表中数据错误。 "]
[null,"求和项:总销售（数量）","产品名称"]
[null,"价格日期","凉鞋"]
[null,"1月",1787]
[null,"2月",4222]
[null,"3月",1777]
[null,"4月",2715]
[null,"5月",2539]