{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["開始","來源資料","依產品","依產品-客戶","依產品-客戶篩選"],"not_rendered":{"pivot_tables":3},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":6,"n_cols":2,"rows_kept":6}
[null,"關於此範本"]
[null,"此活頁簿可用來追蹤各項產品的每季銷售額。"]
[null,"在[來源資料] 工作表中輸入詳細資料，並重新整理其他工作表中的所有樞紐分析表，即可更新銷售資料。"]
[null,"附註： "]
[null,"我們已在每個工作表的儲存格 A1 提供額外指示。此文字已刻意隱藏。若要移除文字，請選取儲存格 A1，然後選取 [刪除]。若要取消隱藏文字，請選取儲存格 A1，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10、選取 [表格] 選項，然後選取 [替代文字]。針對樞紐分析表，在表格中按 SHIFT 並按 F10、選取 [樞紐分析表選項]，然後選取 [替代文字] 索引標籤。"]

{"sheet":"來源資料","index":1,"n_rows":8,"n_cols":7,"rows_kept":8}
["在此工作表中建立每季銷售額報表。在從儲存格 B3 開始的 [來源資料] 表格中輸入詳細資料。"]
[]
[null,"產品","客戶","第 1 季","第 2 季","第 3 季","第 4 季"]
[null,"產品 1","客戶 1",0,{"v":702,"d":"NT$702.00"},0,0]
[null,"產品 2","客戶 2",{"v":312,"d":"NT$312.00"},0,0,0]
[null,"產品 3","客戶 3",0,0,0,{"v":1170,"d":"NT$1,170.00"}]
[null,"產品 4","客戶 4",{"v":1170,"d":"NT$1,170.00"},0,0,0]
[null,"產品 5","客戶 5",{"v":1123.2,"d":"NT$1,123.20"},0,0,{"v":2607.15,"d":"NT$2,607.15"}]

{"sheet":"依產品","index":2,"n_rows":9,"n_cols":6,"rows_kept":9}
["在此工作表中更新從儲存格 B2 開始的 [依產品別] 樞紐分析表。選取 [分析] 索引標籤下的 [重新整理]，以更新在 [來源資料] 中所做的變更。"]
["儲存格 C2 是 [數值] 標籤。",null,"數值"]
["從右側儲存格開始是產品樞紐分析表。","產品","第 1 季加總","第 2 季加總","第 3 季加總","第 4 季加總"]
[null,"產品 1",0,{"v":702,"d":"NT$702.00"},0,0]
[null,"產品 2",{"v":312,"d":"NT$312.00"},0,0,0]
[null,"產品 3",0,0,0,{"v":1170,"d":"NT$1,170.00"}]
[null,"產品 4",{"v":1170,"d":"NT$1,170.00"},0,0,0]
[null,"產品 5",{"v":1123.2,"d":"NT$1,123.20"},0,0,{"v":2607.15,"d":"NT$2,607.15"}]
[null,"總計",{"v":2605.2,"d":"NT$2,605.20"},{"v":702,"d":"NT$702.00"},0,{"v":3777.15,"d":"NT$3,777.15"}]

{"sheet":"依產品-客戶","index":3,"n_rows":14,"n_cols":6,"rows_kept":14}
["在此工作表中更新從儲存格 B2 開始的 [依產品與客戶別] 樞紐分析表。選取 [分析] 索引標籤下的 [重新整理]，以更新在 [來源資料] 中所做的變更。"]
["儲存格 C2 是 [數值] 標籤。",null,"數值"]
["從右側儲存格開始是 [依產品和客戶] 樞紐分析表。","產品","第 1 季加總","第 2 季加總","第 3 季加總","第 4 季加總"]
[null,"產品 1"]
[null,"客戶 1",0,{"v":702,"d":"NT$702.00"},0,0]
[null,"產品 2"]
[null,"客戶 2",{"v":312,"d":"NT$312.00"},0,0,0]
[null,"產品 3"]
[null,"客戶 3",0,0,0,{"v":1170,"d":"NT$1,170.00"}]
[null,"產品 4"]
[null,"客戶 4",{"v":1170,"d":"NT$1,170.00"},0,0,0]
[null,"產品 5"]
[null,"客戶 5",{"v":1123.2,"d":"NT$1,123.20"},0,0,{"v":2607.15,"d":"NT$2,607.15"}]
[null,"總計",{"v":2605.2,"d":"NT$2,605.20"},{"v":702,"d":"NT$702.00"},0,{"v":3777.15,"d":"NT$3,777.15"}]

{"sheet":"依產品-客戶篩選","index":4,"n_rows":16,"n_cols":6,"rows_kept":16}
["在此工作表中更新從儲存格 B4 開始的樞紐分析表。選取 [分析] 索引標籤下的 [重新整理]，以更新在 [來源資料] 中所做的變更。下一個指示在儲存格 A3。"]
[]
["右側儲存格是提示。","這個樞紐分析表會篩選出第 1 季的前 10 名暢銷產品"]
["儲存格 C4 是 [數值] 標籤。",null,"數值"]
["從右側儲存格開始是 [前 10 項產品和客戶] 樞紐分析表。","產品","第 1 季加總","第 2 季加總","第 3 季加總","第 4 季加總"]
[null,"產品 1"]
[null,"客戶 1",0,{"v":702,"d":"NT$702.00"},0,0]
[null,"產品 2"]
[null,"客戶 2",{"v":312,"d":"NT$312.00"},0,0,0]
[null,"產品 3"]
[null,"客戶 3",0,0,0,{"v":1170,"d":"NT$1,170.00"}]
[null,"產品 4"]
[null,"客戶 4",{"v":1170,"d":"NT$1,170.00"},0,0,0]
[null,"產品 5"]
[null,"客戶 5",{"v":1123.2,"d":"NT$1,123.20"},0,0,{"v":2607.15,"d":"NT$2,607.15"}]
[null,"總計",{"v":2605.2,"d":"NT$2,605.20"},{"v":702,"d":"NT$702.00"},0,{"v":3777.15,"d":"NT$3,777.15"}]