{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["開始","來源資料","樞紐分析表結構","樞紐分析表範例"],"not_rendered":{"defined_names":4,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"開始","index":0,"n_rows":9,"n_cols":2,"rows_kept":9}
[null,"關於此範本"]
[null,"使用此活頁簿來試試看樞紐分析表。"]
[null,"使用來自來源資料工作表的範例資料和樞紐分析表工作表結構的報表範本，來建立範例樞紐分析表工作表。 "]
[null,"範例清單會在範例樞紐分析表工作表中建立，並且可以依任何類別或項目排序。 "]
[null,"您也可以使用交叉分析篩選器來篩選資料。若要將交叉分析篩選器新增至樞紐分析表，請在 [樞紐分析表工具] 底下，[分析] 功能區的 [篩選] 群組中選取 [插入交叉分析篩選器]。"]
[null,"樞紐分析表是 Excel 的其中一個最佳工具，用於從大型的詳細資料集擷取重要資料。資料將會以清單格式組織，類似於查詢傳回的資料庫記錄的方式：每一欄包含類似的資料，第一列為欄標題，並且清單不會因為任何空白列或欄而中斷。  "]
[null,"附註： "]
[null,"「來源資料」與「樞紐分析表結構」工作表中的儲存格 A1、A2 和 A4，以及「範例樞紐分析表」工作表中的儲存格 A1、A2、A4 和 A12 中會提供額外的指示。此文字已刻意隱藏。若要移除文字，請選取欄 A 或儲存格 A1，然後選取 [刪除]。若要取消隱藏文字，請選取欄 A 或儲存格 A1，然後變更字型色彩。"]
[null,"若要深入了解表格，請在表格內按 SHIFT 並按 F10，選取 [表格] 選項，然後選取 [替代文字]。針對樞紐分析表，在表格中按 SHIFT 並按 F10、選取 [樞紐分析表選項]，然後選取 [替代文字] 索引標籤。"]

{"sheet":"來源資料","index":1,"n_rows":9,"n_cols":7,"rows_kept":9}
["使用來自「來源資料」表格的範例資料運算列表，在此工作表的儲存格 B4 開始建立範例樞紐分析表。此範例資料是每季銷售額的總和，並含有產品和客戶詳細資料。它也包含協助程式欄，以及用來傳回日期的公式。此欄可在樞紐分析表的時間表工具來篩選資料。"]
[null,"來源資料"]
[]
[null,"產品","客戶","年度","季度","金額","時間表"]
[null,"產品 1","客戶 1",{"$f":"YEAR(TODAY())+1","v":2023},2,{"v":702,"d":"NT$702.00"},{"$f":"DATE(SourceData[[#This Row],[年度]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-08-01"}]
[null,"產品 2","客戶 2",{"$f":"YEAR(TODAY())+1","v":2023},1,{"v":312,"d":"NT$312.00"},{"$f":"DATE(SourceData[[#This Row],[年度]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]
[null,"產品 3","客戶 3",2023,4,{"v":1170,"d":"NT$1,170.00"},{"$f":"DATE(SourceData[[#This Row],[年度]],SourceData[[#This Row],[季度]]*4,1)","v":"2024-04-01"}]
[null,"產品 4","客戶 4",2023,1,{"v":1170,"d":"NT$1,170.00"},{"$f":"DATE(SourceData[[#This Row],[年度]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]
[null,"產品 5","客戶 5",2023,1,{"v":3730.3500000000004,"d":"NT$3,730.35"},{"$f":"DATE(SourceData[[#This Row],[年度]],SourceData[[#This Row],[季度]]*4,1)","v":"2023-04-01"}]

{"sheet":"樞紐分析表結構","index":2,"n_rows":2,"n_cols":2,"rows_kept":2}
[]
[null,"樞紐分析表"]

{"sheet":"樞紐分析表範例","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[3,9,10,13],[11,9,18,13]]}
[]
[null,"範例樞紐分析表"]
[]
[null," 金額 ",null,"年度","季度"]
[{"$nulls":3},2023,null,null,"2023 Total"]
[null,"客戶","產品",1,2,4]
[null,"客戶 1",null,null,{"v":702,"d":"NT$702.00"},null,{"v":702,"d":"NT$702.00"}]
[null,null,"產品 1",null,{"v":702,"d":"NT$702.00"},null,{"v":702,"d":"NT$702.00"}]
[null,"客戶 2",null,{"v":312,"d":"NT$312.00"},null,null,{"v":312,"d":"NT$312.00"}]
[null,null,"產品 2",{"v":312,"d":"NT$312.00"},null,null,{"v":312,"d":"NT$312.00"}]
[null,"客戶 3",{"$nulls":3},{"v":1170,"d":"NT$1,170.00"},{"v":1170,"d":"NT$1,170.00"}]
[null,null,"產品 3",null,null,{"v":1170,"d":"NT$1,170.00"},{"v":1170,"d":"NT$1,170.00"}]
[null,"客戶 4",null,{"v":1170,"d":"NT$1,170.00"},null,null,{"v":1170,"d":"NT$1,170.00"}]
[null,null,"產品 4",{"v":1170,"d":"NT$1,170.00"},null,null,{"v":1170,"d":"NT$1,170.00"}]
[null,"客戶 5",null,{"v":3730.3500000000004,"d":"NT$3,730.35"},null,null,{"v":3730.3500000000004,"d":"NT$3,730.35"}]
[null,null,"產品 5",{"v":3730.3500000000004,"d":"NT$3,730.35"},null,null,{"v":3730.3500000000004,"d":"NT$3,730.35"}]