{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["开始","市场营销预算计划","分类图表"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"关于模板"]
[null,"在此工作簿中创建市场营销预算计划和分类图表。"]
[null,"在市场营销预算计划工作表中输入类别、数量和成本。自动计算活动成本和估计的市场营销总计。"]
[null,"簇状柱形图在分类图表工作表中自动更新。"]
[null,"备注： "]
[null,"“市场营销预算计划”和“分类图表”工作表的 A 列中提供了附加说明。已故意隐藏此文本。若要删除文本，请选择 A 列，然后选择“删除”。若要取消隐藏文本，请选择 A 列，然后更改字体颜色。"]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”。对于数据透视表，请在表格内按 SHIFT+F10，选择“数据透视表”选项，然后选择“替换文本”选项卡。"]

{"sheet":"市场营销预算计划","index":1,"n_rows":61,"n_cols":7,"rows_kept":61,"merged":[[2,4,7,6],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
["在此工作表中创建渠道市场营销预算。此列的单元格中显示有关如何使用此工作表的有用说明。请向下移动箭头开始了解。"]
["此工作簿的标题位于右侧单元格中。","市场营销预算计划"]
["按主要类别筛选数据表格的切片器在单元格 E3 中。",{"$nulls":3},"按主要类别筛选数据表格的切片器在本单元格中。"]
["在单元格 D4 中输入与会者人数。","与会者人数",null,50]
["活动成本在单元格 D5 中自动进行计算。","活动成本",null,{"$f":"SUMIF(数据[主要类别],\"活动\",数据[估计小计])","v":{"v":2500,"d":"¥2,500.00"}}]
["每个人的活动价格在单元格 D6 中自动进行计算。","每个人的活动价格",null,{"$f":"EventCosts/NumberOfAttendees","v":{"v":50,"d":"¥50.00"}}]
["估计市场营销总计在单元格 D7 中自动进行计算。","估计市场营销总计",null,{"$f":"SUMIF(数据[主要类别],\"<>活动\",数据[估计小计])","v":{"v":45743,"d":"¥45,743.00"}}]
["小计在单元格 D8 中自动进行计算。下一条说明位于单元格 A10 中。","小计",null,{"$f":"SUBTOTAL(109,数据[估计小计])","v":{"v":48243,"d":"¥48,243.00"}}]
[]
["从右侧单元格开始，在“数据”表中输入详细信息。","主要类别","次要类别","估计数量","估计单位成本","估计小计","备注"]
[null,"研究","调查公司费用",2,{"v":2300,"d":"¥2,300.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":4600,"d":"¥4,600.00"}}]
[null,"研究","Web 调查",1,{"v":1100,"d":"¥1,100.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1100,"d":"¥1,100.00"}}]
[null,"研究","独立调查",3,{"v":300,"d":"¥300.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":900,"d":"¥900.00"}}]
[null,"研究","其他调查",2,{"v":250,"d":"¥250.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":500,"d":"¥500.00"}}]
[null,"通信","促销小册子",{"v":5000,"d":"5,000"},{"v":0.15,"d":"¥0.15"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":750,"d":"¥750.00"}}]
[null,"通信","电视",5,{"v":4000,"d":"¥4,000.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":20000,"d":"¥20,000.00"}}]
[null,"通信","电台",13,{"v":350,"d":"¥350.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":4550,"d":"¥4,550.00"}}]
[null,"通信","Web",1,{"v":350,"d":"¥350.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":350,"d":"¥350.00"}}]
[null,"网络","网络",null,null,{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"网络","成员资格",3,{"v":50,"d":"¥50.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":150,"d":"¥150.00"}}]
[null,"网络","隶属关系",2,{"v":20,"d":"¥20.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":40,"d":"¥40.00"}}]
[null,"网络","订阅",2,{"v":32,"d":"¥32.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":64,"d":"¥64.00"}}]
[null,"活动","与会者人数",50,null,{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"活动","膳食（早餐、午餐或晚餐）",null,null,{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"活动","食品",null,{"v":23,"d":"¥23.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"活动","税费 (10%)",null,{"v":2.3000000000000003,"d":"¥2.30"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"活动","食品和饮料小费 (20%)",null,{"v":5.0600000000000005,"d":"¥5.06"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"活动","洗熨服务",1,{"v":300,"d":"¥300.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":300,"d":"¥300.00"}}]
[null,"活动","娱乐 #1",1,{"v":800,"d":"¥800.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":800,"d":"¥800.00"}}]
[null,"活动","娱乐 #2",1,{"v":1200,"d":"¥1,200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1200,"d":"¥1,200.00"}}]
[null,"活动","其他服务",1,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":200,"d":"¥200.00"}}]
[null,"音频/视频服务","基本 PA 系统和指挥",1,{"v":0,"d":"¥0.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"由会场提供（通常）"]
[null,"音频/视频服务","屏幕",1,{"v":0,"d":"¥0.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"由会场提供（通常）"]
[null,"音频/视频服务","XGA 数据/视频投影仪租赁",1,{"v":45,"d":"¥45.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":45,"d":"¥45.00"}}]
[null,"音频/视频服务","无线鼠标",1,{"v":12,"d":"¥12.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":12,"d":"¥12.00"}}]
[null,"音频/视频服务","电源板",1,{"v":0,"d":"¥0.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"由会场提供（通常）"]
[null,"音频/视频服务","延长线",1,{"v":0,"d":"¥0.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"由会场提供（通常）"]
[null,"音频/视频服务","颈式话筒",1,{"v":0,"d":"¥0.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"由会场提供（通常）"]
[null,"音频/视频服务","劳动和弱点技工",1,{"v":300,"d":"¥300.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":300,"d":"¥300.00"}}]
[null,"音频/视频服务","税费 (8.8%)",null,{"v":31.415999999999997,"d":"¥31.42"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"额外成本","邀请（打印和邮政成本）",null,{"v":834,"d":"¥834.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"额外成本","时间和支出 (T&E)",null,{"v":600,"d":"¥600.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"额外成本","公司教职员工 T&E",null,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}},"<现场人员数量>"]
[null,"额外成本","客户评价 T&E",null,{"v":100,"d":"¥100.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":0,"d":"¥0.00"}}]
[null,"赠奖","赠送 #1",25,{"v":10,"d":"¥10.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":250,"d":"¥250.00"}},"<赠送项目描述>"]
[null,"赠奖","赠送 #2",25,{"v":5,"d":"¥5.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":125,"d":"¥125.00"}},"<赠送项目描述>"]
[null,"促销活动","产品赠送",50,{"v":8,"d":"¥8.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":400,"d":"¥400.00"}}]
[null,"促销活动","产品折扣",300,{"v":3,"d":"¥3.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":900,"d":"¥900.00"}}]
[null,"促销活动","特别优惠",200,{"v":2.5,"d":"¥2.50"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":500,"d":"¥500.00"}}]
[null,"广告","小册子（开发和生产）",{"v":5000,"d":"5,000"},{"v":0.15,"d":"¥0.15"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":750,"d":"¥750.00"}}]
[null,"广告","邮件",{"v":15000,"d":"15,000"},{"v":0.04,"d":"¥0.04"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":600,"d":"¥600.00"}}]
[null,"广告","明信片",{"v":15000,"d":"15,000"},{"v":0.03,"d":"¥0.03"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":450,"d":"¥450.00"}}]
[null,"广告","电视",2,{"v":600,"d":"¥600.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1200,"d":"¥1,200.00"}}]
[null,"广告","电台",4,{"v":300,"d":"¥300.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1200,"d":"¥1,200.00"}}]
[null,"广告","报纸",6,{"v":220,"d":"¥220.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1320,"d":"¥1,320.00"}}]
[null,"广告","广告牌",2,{"v":556,"d":"¥556.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1112,"d":"¥1,112.00"}}]
[null,"广告","公交车身侧面",3,{"v":125,"d":"¥125.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":375,"d":"¥375.00"}}]
[null,"公共关系","慈善活动",3,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":600,"d":"¥600.00"}}]
[null,"公共关系","广告",4,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":800,"d":"¥800.00"}}]
[null,"公共关系","员工促销活动",6,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":1200,"d":"¥1,200.00"}}]
[null,"公共关系","赞助",3,{"v":200,"d":"¥200.00"},{"$f":"数据[[#This Row],[估计数量]]*数据[[#This Row],[估计单位成本]]","v":{"v":600,"d":"¥600.00"}}]

{"sheet":"分类图表","index":2,"n_rows":8,"n_cols":13,"rows_kept":8,"merged":[[7,1,7,12]]}
["数据透视表和 分类图表位于此工作表中。此列的单元格中显示有关如何使用此工作表的有用说明。请向下移动箭头开始了解。"]
["此工作簿的标题位于右侧单元格中。","市场营销预算计划"]
[]
["显示主要类别及其小计的摘要数据透视图从单元格 C4 开始。下一条指示位于单元格 A8 中。",null,"主要类别"]
[null,null,"促销活动","额外成本","公共关系","广告","活动","通信","网络","研究","音频/视频服务","赠奖","Grand Total"]
[null,"估计小计",{"v":0,"d":"¥0.00"},{"v":7007,"d":"¥7,007.00"},{"v":357,"d":"¥357.00"},{"v":25650,"d":"¥25,650.00"},{"v":2500,"d":"¥2,500.00"},{"v":375,"d":"¥375.00"},{"v":254,"d":"¥254.00"},{"v":1800,"d":"¥1,800.00"},{"v":3200,"d":"¥3,200.00"},{"v":7100,"d":"¥7,100.00"},{"v":48243,"d":"¥48,243.00"}]
[]
["显示主要类别及其估算小计的列数据透视图位于右侧单元格中。 "," 显示主要类别及其估算小计的列数据透视图位于本单元格中。 "]