{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["开始","支出","收入","损益表汇总"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"开始","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"模板简介"]
[null,"使用此“活动预算”工作簿跟踪活动产生的支出以及获得的收益。"]
[null,"在表中的“支出”工作表和“收益”工作表填写活动名称并输入详细信息。"]
[null,"总支出和总收益将会自动计算。"]
[null,"“损益汇总”工作表中的损益汇总和图表将会自动更新。"]
[null,"注释： "]
[null,"每个工作表的 A 列中均提供了额外的说明。并且此文本已被有意隐藏。若要删除文本，请选择 A 列，然后选择“删除”。 "]
[null,"若要了解有关表格的详细信息，请在表格内按 Shift + F10，选择“表格”选项，然后选择“替换文本”"]

{"sheet":"支出","index":1,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,2],[0,3,0,4],[2,1,3,1]]}
["在此工作表的相应表格中输入每个类别的估算金额和实际费用，并在单元格 D1 中输入活动名称，以自定义此工作表和其他工作表的标题。此工作表的副标题位于单元格 H1 中。有关如何使用此工作表的有用说明位于此列的单元格中。下一条说明位于单元格 A3 中。","活动预算",null,"活动名称",{"$nulls":3},"支出"]
[]
["总支出位于右侧单元格中，估计支出标签位于单元格 G3 中，实际支出标签位于单元格 H3 中。","费用总计",{"$nulls":4},"估计","实际"]
["单元格 G4 中的估计总支出和单元格 H4 中的实际总支出将会自动计算。下一条说明位于单元格 A6 中。",{"$nulls":5},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"¥882.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":302,"d":"¥302.00"}}]
[]
["在表中右侧单元格开始输入场地支出，在表中单元格 F6 开始输入茶点支出。下一条指示位于单元格 A13 中。","场地","估计","实际费用",null,"茶点","估计","实际"]
[null,"会议室和大厅费用",{"v":500,"d":"¥500.00"},null,null,"食物"]
[null,"现场人员",{"$nulls":3},"饮料",{"v":20,"d":"¥20.00"}]
[null,"设备",{"$nulls":3},"亚麻布",null,{"v":20,"d":"¥20.00"}]
[null,"桌椅",{"$nulls":3},"服务人员和小费"]
[null,"汇总",{"$f":"SUBTOTAL(109,SiteExpenses[估计])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(103,SiteExpenses[实际费用])","v":{"v":0,"d":"¥0.00"}},null,"汇总",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[估计])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(103,RefreshmentsExpenses[实际])","v":{"v":1,"d":"¥1.00"}}]
[]
["在表中右侧单元格开始输入装饰支出，在表中单元格 F13 开始输入节目支出。下一条说明位于单元格 A21 中。","装饰","估计","实际",null,"节目","估计","实际"]
[null,"花卉",{"v":200,"d":"¥200.00"},{"v":300,"d":"¥300.00"},null,"执行者"]
[null,"蜡烛",{"$nulls":3},"扬声器",{"v":30,"d":"¥30.00"}]
[null,"照明",{"$nulls":3},"差旅"]
[null,"气球",{"$nulls":3},"住宿"]
[null,"纸",{"$nulls":3},"其他"]
[null,"汇总",{"$f":"SUBTOTAL(109,DecorationsExpenses[估计])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[实际])","v":{"v":300,"d":"¥300.00"}},null,"汇总",{"$f":"SUBTOTAL(109,ProgramExpenses[估计])","v":{"v":30,"d":"¥30.00"}},{"$f":"SUBTOTAL(103,ProgramExpenses[实际])","v":{"v":0,"d":"¥0.00"}}]
[]
["在表中右侧单元格开始输入宣传支出，在表中单元格 F21 开始输入奖励支出。下一条说明位于单元格 A27 中","宣传","估计","实际",null,"奖品","估计","实际"]
[null,"图形工作",{"$nulls":3},"绶带/奖章/奖品"]
[null,"影印/打印",{"v":20,"d":"¥20.00"},null,null,"礼品",{"v":100,"d":"¥100.00"}]
[null,"邮费",{"$nulls":3},"汇总",{"$f":"SUBTOTAL(109,PrizesExpenses[估计])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(103,PrizesExpenses[实际])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,PublicityExpenses[估计])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(103,PublicityExpenses[实际])","v":{"v":0,"d":"¥0.00"}}]
[]
["在表中右侧单元格开始输入杂项费用。","杂项","估算金额","实际"]
[null,"电话",null,{"v":13,"d":"¥13.00"}]
[null,"交通",{"v":12,"d":"¥12.00"}]
[null,"文具"]
[null,"传真服务"]
[null,"汇总",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[估算金额])","v":{"v":12,"d":"¥12.00"}},{"$f":"SUBTOTAL(103,MiscellaneousExpenses[实际])","v":{"v":1,"d":"¥1.00"}}]

{"sheet":"收入","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,0,2],[2,1,3,1]]}
["在此工作表的相应表中输入每个类别的估计收益和实际收益。单元格右侧的工作表标题将会自动更新。副标题位于单元格 G1 中。有关如何使用此工作表的有用说明位于此列的单元格中。下一条说明位于单元格 A3 中。",{"$f":"支出!B1","v":"活动预算"},null,{"$f":"支出!D1","v":"活动名称"},null,null,"收入"]
[]
["总收益位于右侧单元格中，估计收益标签位于单元格 F3 中，实际收益标签位于单元格 G3 中。","总收益",{"$nulls":3},"估计","实际"]
["单元格 F4 中的估计总收益和单元格 G4 中的实际收益将会自动计算。",{"$nulls":4},{"$f":"SUM(Admissions[[#Totals],[估计收益]],AdsInProgram[[#Totals],[估计收益]],ExhibitorsAndVendors[[#Totals],[估计收益]],SaleOfItems[[#Totals],[估计收益]])","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"SUM(Admissions[[#Totals],[实际收益]],AdsInProgram[[#Totals],[实际收益]],ExhibitorsAndVendors[[#Totals],[实际收益]],SaleOfItems[[#Totals],[实际收益]])","v":{"v":1831,"d":"¥1,831.00"}}]
["入场券收益标签位于右侧单元格中。","入场券"]
["在表中的右侧单元格开始输入估计的入场券数量和实际的入场券数量以及票价。估计的入场券收益和实际的入场券收益将会自动计算。下一条说明位于单元格 A11 中。","估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,300,278,"成人数量",{"v":5,"d":"¥5.00"},{"$f":"B7*E7","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"C7*E7","v":{"v":1390,"d":"¥1,390.00"}}]
[null,197,195,"儿童数量",{"v":2,"d":"¥2.00"},{"$f":"B8*E8","v":{"v":394,"d":"¥394.00"}},{"$f":"C8*E8","v":{"v":390,"d":"¥390.00"}}]
[null,42,51,"其他数量",{"v":1,"d":"¥1.00"},{"$f":"B9*E9","v":{"v":42,"d":"¥42.00"}},{"$f":"C9*E9","v":{"v":51,"d":"¥51.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,Admissions[估计收益])","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"SUBTOTAL(109,Admissions[实际收益])","v":{"v":1831,"d":"¥1,831.00"}}]
["节目广告收益标签位于右侧单元格中。","节目广告"]
["在表中的右侧单元格开始输入估计的节目广告数量和实际的节目广告数量以及广告价格。估计的广告收益和实际的广告收益将会自动计算。下一条说明位于单元格 A17 中。","估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,12,null,"封面数量",null,{"$f":"B13*E13","v":{"v":0,"d":"¥0.00"}},{"$f":"C13*E13","v":{"v":0,"d":"¥0.00"}}]
[null,null,158,"半版数量",null,{"$f":"B14*E14","v":{"v":0,"d":"¥0.00"}},{"$f":"C14*E14","v":{"v":0,"d":"¥0.00"}}]
[null,4,null,"四分之一版面数量",null,{"$f":"B15*E15","v":{"v":0,"d":"¥0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,AdsInProgram[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,AdsInProgram[实际收益])","v":{"v":0,"d":"¥0.00"}}]
["参展商或供应商收益标签位于右侧单元格。","参展商/供应商"]
["在表中的右侧单元格开始输入估计的参展商和供应商数量和实际的参展商和供应商数量以及展厅价格。估计收益和实际收益将会自动计算。下一条指示位于单元格 A23 中。","估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,23,null,"大型展厅数量",null,{"$f":"B19*E19","v":{"v":0,"d":"¥0.00"}},{"$f":"C19*E19","v":{"v":0,"d":"¥0.00"}}]
[null,354,null,"中型展厅数量",null,{"$f":"B20*E20","v":{"v":0,"d":"¥0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"¥0.00"}}]
[null,56,null,"小型展厅数量",null,{"$f":"B21*E21","v":{"v":0,"d":"¥0.00"}},{"$f":"C21*E21","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[实际收益])","v":{"v":0,"d":"¥0.00"}}]
["产品销售收益标签位于右侧单元格中。","产品销售"]
["在表中的右侧单元格开始输入估计的产品销售量和实际的产品销售量以及产品价格。估计收益和实际收益将会自动计算。","估计数量","实际数量","类型","价格","估计收益","实际收益"]
[{"$nulls":3},"产品储量",null,{"$f":"B25*E25","v":{"v":0,"d":"¥0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"¥0.00"}}]
[null,123,null,"产品储量",null,{"$f":"B26*E26","v":{"v":0,"d":"¥0.00"}},{"$f":"C26*E26","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":3},"产品储量",null,{"$f":"B27*E27","v":{"v":0,"d":"¥0.00"}},{"$f":"C27*E27","v":{"v":0,"d":"¥0.00"}}]
[null,13,null,"产品储量",null,{"$f":"B28*E28","v":{"v":0,"d":"¥0.00"}},{"$f":"C28*E28","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,SaleOfItems[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,SaleOfItems[实际收益])","v":{"v":0,"d":"¥0.00"}}]

{"sheet":"损益表汇总","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"merged":[[0,1,0,2]]}
["此工作表中显示总收益和支出的损益汇总和图表将会自动更新。单元格右侧的工作表标题将会自动更新。副标题位于单元格 G1 和 G2 中。有关如何使用此工作表的有用说明位于此列的单元格中。下一条说明位于单元格 A3 中。",{"$f":"支出!B1","v":"活动预算"},null,{"$f":"支出!D1","v":"活动名称"},null,null,"利润 "]
[{"$nulls":6},"损失汇总"]
["比较估计收益和支出与实际收益和支出的条形图位于单元格 E3 中。",{"$nulls":3},"比较估计收益和支出与实际收益和支出的条形图位于此单元格中。"]
["从右侧单元格开始的汇总表将会自动更新。下一条指示位于单元格 A8 中。"," 总计","估算金额","实际"]
[null,"总收益",{"$f":"收入!F10","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"收入!F4","v":{"v":1936,"d":"¥1,936.00"}}]
[null,"费用总计",{"$f":"支出!G4","v":{"v":882,"d":"¥882.00"}},{"$f":"支出!H4","v":{"v":302,"d":"¥302.00"}}]
[]
["单元格 C8 中的估计总损益和单元格 D8 中的实际总损益将会自动计算。","总利润\n（或损失）",{"$f":"C5-C6","v":{"v":1054,"d":"¥1,054.00"}},{"$f":"D5-D6","v":{"v":1634,"d":"¥1,634.00"}}]