{"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,"產品識別碼","產品名稱","價格日期","零售單價","批發單價*","銷售數量 (零售)","銷售數量 (批發)","總銷售數量","總銷售金額"]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2012-01-01",600,{"v":600,"d":"NT$600"},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":1129800,"d":"NT$1,129,800"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-01-01",2640,{"v":1620,"d":"NT$1,620"},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":4249500,"d":"NT$4,249,500"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-01-01",2100,{"v":1320,"d":"NT$1,320"},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":2939160,"d":"NT$2,939,160"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-01-01",1890,{"v":1320,"d":"NT$1,320"},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":3297450,"d":"NT$3,297,450"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-01-01",1050,{"v":810,"d":"NT$810"},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":2107920,"d":"NT$2,107,920"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-02-01",1650,{"v":1320,"d":"NT$1,320"},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":3118500,"d":"NT$3,118,500"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-02-01",2490,{"v":1620,"d":"NT$1,620"},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":3503070,"d":"NT$3,503,070"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-02-01",1020,{"v":1020,"d":"NT$1,020"},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":2096100,"d":"NT$2,096,100"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-02-01",1050,{"v":750,"d":"NT$750"},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":1798650,"d":"NT$1,798,650"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2012-02-01",1230,{"v":1140,"d":"NT$1,140"},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":2721600,"d":"NT$2,721,600"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-02-29",810,{"v":540,"d":"NT$540"},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":1477170,"d":"NT$1,477,170"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-02-29",1140,{"v":840,"d":"NT$840"},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":2355360,"d":"NT$2,355,360"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-02-29",2760,{"v":2760,"d":"NT$2,760"},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":6132720,"d":"NT$6,132,720"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-02-29",1290,{"v":1080,"d":"NT$1,080"},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":2729280,"d":"NT$2,729,280"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2012-02-29",2940,{"v":2190,"d":"NT$2,190"},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":4738080,"d":"NT$4,738,080"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-03-31",1140,{"v":840,"d":"NT$840"},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":2297820,"d":"NT$2,297,820"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-03-31",1500,{"v":1080,"d":"NT$1,080"},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":2201400,"d":"NT$2,201,400"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-03-31",720,{"v":690,"d":"NT$690"},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":1677690,"d":"NT$1,677,690"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-03-31",2160,{"v":1710,"d":"NT$1,710"},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":5287680,"d":"NT$5,287,680"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2012-03-31",2550,{"v":1290,"d":"NT$1,290"},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":3678090,"d":"NT$3,678,090"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-04-30",2730,{"v":1950,"d":"NT$1,950"},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":4036890,"d":"NT$4,036,890"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-04-30",2730,{"v":1650,"d":"NT$1,650"},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":5443110,"d":"NT$5,443,110"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-04-30",1260,{"v":1260,"d":"NT$1,260"},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":2257920,"d":"NT$2,257,920"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-04-30",2550,{"v":1290,"d":"NT$1,290"},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":2691810,"d":"NT$2,691,810"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2012-04-30",2460,{"v":2130,"d":"NT$2,130"},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":4421730,"d":"NT$4,421,730"}}]
[null,1,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"恤衫"},"2012-05-14",1020,{"v":930,"d":"NT$930"},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":2306640,"d":"NT$2,306,640"}}]
[null,2,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"涼鞋"},"2012-05-14",1920,{"v":1200,"d":"NT$1,200"},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":3677520,"d":"NT$3,677,520"}}]
[null,3,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"雨傘"},"2012-05-14",990,{"v":900,"d":"NT$900"},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":1906290,"d":"NT$1,906,290"}}]
[null,4,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"水壺"},"2012-05-14",870,{"v":810,"d":"NT$810"},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":1951620,"d":"NT$1,951,620"}}]
[null,5,{"$f":"IFERROR(IF(tblSales[[#This Row],[產品識別碼]]<>\"\",VLOOKUP(tblSales[產品識別碼],tblProducts[[產品識別碼]:[名稱]],2,FALSE),\"\"),\"未知的產品識別碼\")","v":"短褲"},"2013-12-11",720,{"v":450,"d":"NT$450"},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":1490580,"d":"NT$1,490,580"}}]

{"sheet":"價目表","index":2,"n_rows":18,"n_cols":6,"rows_kept":18,"merged":[[15,1,15,5]]}
[null,"產品價目表"]
[]
[null,"冒險工廠"]
[null,"30126 屏東縣"]
[null,"水果鄉永大路 4 號"]
[null,"電話：(123) 555-0100"]
[null,"傳真：(425) 555-0152"]
[null,"www.adventure-works.com",{"$nulls":3},"上次更新日期：2013/8/15"]
[]
[null,"產品識別碼","名稱","描述","零售單價","批發單價*"]
[null,1,"恤衫"," 我們的 100% 純棉防縮恤衫可讓您涼爽一夏。",{"v":660,"d":"NT$660"},{"v":450,"d":"NT$450.00"}]
[null,2,"涼鞋","穿上我們堅固耐走的膠底涼鞋，即使是最炙熱的沙灘，都能行走自如。",{"v":300,"d":"NT$300"},{"v":180,"d":"NT$180.00"}]
[null,3,"雨傘"," 我們的超大型海灘傘能夠阻隔 96% 的各種有害紫外線，能幫您遮陽防曬。",{"v":900,"d":"NT$900"},{"v":600,"d":"NT$600.00"}]
[null,4,"水壺"," 我們的保溫水壺能維持最佳水溫，讓您補充水份，暢快無比。",{"v":210,"d":"NT$210"},{"v":150,"d":"NT$150.00"}]
[null,5,"短褲","我們的速乾尼龍短褲，讓您一從水中出來，就能直接上車。",{"v":450,"d":"NT$450"},{"v":240,"d":"NT$240.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,\"None\")","v":"涼鞋"}]
[null,"產品名稱","零售單價","加總 - 總銷售數量"]
[null,"涼鞋",{"v":1140,"d":"NT$1,140"},2464]
[null,null,{"v":1500,"d":"NT$1,500"},1777]
[null,null,{"v":1920,"d":"NT$1,920"},2539]
[null,null,{"v":2100,"d":"NT$2,100"},1787]
[null,null,{"v":2490,"d":"NT$2,490"},1758]
[null,null,{"v":2730,"d":"NT$2,730"},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]