{"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":"¥702.00"},0,0]
[null,"产品 2","客户 2",{"v":312,"d":"¥312.00"},0,0,0]
[null,"产品 3","客户 3",0,0,0,{"v":1170,"d":"¥1,170.00"}]
[null,"产品 4","客户 4",{"v":1170,"d":"¥1,170.00"},0,0,0]
[null,"产品 5","客户 5",{"v":1123.2,"d":"¥1,123.20"},0,0,{"v":2607.15,"d":"¥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":"¥702.00"},0,0]
[null,"产品 2",{"v":312,"d":"¥312.00"},0,0,0]
[null,"产品 3",0,0,0,{"v":1170,"d":"¥1,170.00"}]
[null,"产品 4",{"v":1170,"d":"¥1,170.00"},0,0,0]
[null,"产品 5",{"v":1123.2,"d":"¥1,123.20"},0,0,{"v":2607.15,"d":"¥2,607.15"}]
[null,"总计",{"v":2605.2,"d":"¥2,605.20"},{"v":702,"d":"¥702.00"},0,{"v":3777.15,"d":"¥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":"¥702.00"},0,0]
[null,"产品 2"]
[null,"客户 2",{"v":312,"d":"¥312.00"},0,0,0]
[null,"产品 3"]
[null,"客户 3",0,0,0,{"v":1170,"d":"¥1,170.00"}]
[null,"产品 4"]
[null,"客户 4",{"v":1170,"d":"¥1,170.00"},0,0,0]
[null,"产品 5"]
[null,"客户 5",{"v":1123.2,"d":"¥1,123.20"},0,0,{"v":2607.15,"d":"¥2,607.15"}]
[null,"总计",{"v":2605.2,"d":"¥2,605.20"},{"v":702,"d":"¥702.00"},0,{"v":3777.15,"d":"¥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":"¥702.00"},0,0]
[null,"产品 2"]
[null,"客户 2",{"v":312,"d":"¥312.00"},0,0,0]
[null,"产品 3"]
[null,"客户 3",0,0,0,{"v":1170,"d":"¥1,170.00"}]
[null,"产品 4"]
[null,"客户 4",{"v":1170,"d":"¥1,170.00"},0,0,0]
[null,"产品 5"]
[null,"客户 5",{"v":1123.2,"d":"¥1,123.20"},0,0,{"v":2607.15,"d":"¥2,607.15"}]
[null,"总计",{"v":2605.2,"d":"¥2,605.20"},{"v":702,"d":"¥702.00"},0,{"v":3777.15,"d":"¥3,777.15"}]