{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["支出","收入","利润损失汇总"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"支出","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"活动预算[活动名称] ",{"$nulls":5},"支出"]
[]
[null,"总支出",{"$nulls":4},"估计","实际"]
[{"$nulls":6},{"$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":333,"d":"¥333.00"}}]
[]
[null,"场地","估计","实际",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,表1[估计])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,表1[实际])","v":{"v":0,"d":"¥0.00"}},null,"汇总",{"$f":"SUBTOTAL(109,表3[估计])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,表3[实际])","v":{"v":20,"d":"¥20.00"}}]
[]
[null,"装饰","估计","实际",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,表4[估计])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,表4[实际])","v":{"v":300,"d":"¥300.00"}},null,"汇总",{"$f":"SUBTOTAL(109,表5[估计])","v":{"v":30,"d":"¥30.00"}},{"$f":"SUBTOTAL(109,表5[实际])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"宣传","估计","实际",null,"奖品","估计","实际"]
[null,"图形工作",{"$nulls":3},"绶带/奖章/奖品"]
[null,"影印/打印",{"v":20,"d":"¥20.00"},null,null,"礼品",{"v":100,"d":"¥100.00"}]
[null,"邮费",{"$nulls":3},"汇总",{"$f":"SUBTOTAL(109,表7[估计])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,表7[实际])","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,表6[估计])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,表6[实际])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"杂项","估计","实际"]
[null,"电话",null,{"v":13,"d":"¥13.00"}]
[null,"交通",{"v":12,"d":"¥12.00"}]
[null,"文具"]
[null,"传真服务"]
[null,"汇总",{"$f":"SUBTOTAL(109,表8[估计])","v":{"v":12,"d":"¥12.00"}},{"$f":"SUBTOTAL(109,表8[实际])","v":{"v":13,"d":"¥13.00"}}]

{"sheet":"收入","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"活动预算[活动名称] ",{"$nulls":4},"收入"]
[]
[null,"总收入",{"$nulls":3},"估计","实际"]
[{"$nulls":5},{"$f":"SUM(F11, F18, F25, F33)","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"SUM(G11,G18,G25, G33)","v":{"v":1831,"d":"¥1,831.00"}}]
[]
[null,"入场券"]
[null,"估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,300,278,"成人数量",{"v":5,"d":"¥5.00"},{"$f":"B8*E8","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"C8*E8","v":{"v":1390,"d":"¥1,390.00"}}]
[null,197,195,"儿童数量",{"v":2,"d":"¥2.00"},{"$f":"B9*E9","v":{"v":394,"d":"¥394.00"}},{"$f":"C9*E9","v":{"v":390,"d":"¥390.00"}}]
[null,42,51,"其他数量",{"v":1,"d":"¥1.00"},{"$f":"B10*E10","v":{"v":42,"d":"¥42.00"}},{"$f":"C10*E10","v":{"v":51,"d":"¥51.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,表9[估计收益])","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"SUBTOTAL(109,表9[实际收益])","v":{"v":1831,"d":"¥1,831.00"}}]
[]
[null,"节目广告"]
[null,"估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,12,null,"封面数量",null,{"$f":"B15*E15","v":{"v":0,"d":"¥0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"¥0.00"}}]
[null,null,158,"半版数量",null,{"$f":"B16*E16","v":{"v":0,"d":"¥0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"¥0.00"}}]
[null,4,null,"四分之一版面数量",null,{"$f":"B17*E17","v":{"v":0,"d":"¥0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,表10[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表10[实际收益])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"参展商/供应商"]
[null,"估计数量","实际数量","类型","价格","估计收益","实际收益"]
[null,23,null,"大型展厅数量",null,{"$f":"B22*E22","v":{"v":0,"d":"¥0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"¥0.00"}}]
[null,354,null,"中型展厅数量",null,{"$f":"B23*E23","v":{"v":0,"d":"¥0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"¥0.00"}}]
[null,56,null,"小型展厅数量",null,{"$f":"B24*E24","v":{"v":0,"d":"¥0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,表11[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表11[实际收益])","v":{"v":0,"d":"¥0.00"}}]
[]
[null,"产品销售"]
[null,"估计数量","实际数量","类型","价格","估计收益","实际收益"]
[{"$nulls":3},"产品储量",null,{"$f":"B29*E29","v":{"v":0,"d":"¥0.00"}},{"$f":"C29*E29","v":{"v":0,"d":"¥0.00"}}]
[null,123,null,"产品储量",null,{"$f":"B30*E30","v":{"v":0,"d":"¥0.00"}},{"$f":"C30*E30","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":3},"产品储量",null,{"$f":"B31*E31","v":{"v":0,"d":"¥0.00"}},{"$f":"C31*E31","v":{"v":0,"d":"¥0.00"}}]
[null,13,null,"产品储量",null,{"$f":"B32*E32","v":{"v":0,"d":"¥0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$nulls":3},{"$f":"SUBTOTAL(109,表12[估计收益])","v":{"v":0,"d":"¥0.00"}},{"$f":"SUBTOTAL(109,表12[实际收益])","v":{"v":0,"d":"¥0.00"}}]

{"sheet":"利润损失汇总","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"活动预算[活动名称] ",{"$nulls":4},"利润 "]
[{"$nulls":6},"损失汇总"]
[]
[]
[null,null,"估计","实际"]
[null,"总收益",{"$f":"收入!F4","v":{"v":1936,"d":"¥1,936.00"}},{"$f":"收入!G4","v":{"v":1831,"d":"¥1,831.00"}}]
[null,"总支出",{"$f":"支出!G4","v":{"v":882,"d":"¥882.00"}},{"$f":"支出!H4","v":{"v":333,"d":"¥333.00"}}]
[]
[null,"总利润（或损失）",{"$f":"C6-C7","v":{"v":1054,"d":"¥1,054.00"}},{"$f":"D6-D7","v":{"v":1498,"d":"¥1,498.00"}}]