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

{"sheet":"支出","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"产品发布会"]
[null,"费用详细信息"]
[]
[]
[null,"总支出","估计","实际",null,"节目","估计","实际"]
[null,null,{"$f":"SiteExpenses[[#Totals],[估计]]+DecorationsExpenses[[#Totals],[估计]]+PublicityExpenses[[#Totals],[估计]]+MiscellaneousExpenses[[#Totals],[估计]]+RefreshmentsExpenses[[#Totals],[估计]]+ProgramExpenses[[#Totals],[估计]]+PrizesExpenses[[#Totals],[估计]]","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"SiteExpenses[[#Totals],[实际]]+DecorationsExpenses[[#Totals],[实际]]+PublicityExpenses[[#Totals],[实际]]+MiscellaneousExpenses[[#Totals],[实际]]+RefreshmentsExpenses[[#Totals],[实际]]+ProgramExpenses[[#Totals],[实际]]+PrizesExpenses[[#Totals],[实际]]","v":{"v":1640,"d":"¥1,640.00"}},null,"执行者",{"v":750,"d":"¥750.00"},{"v":700,"d":"¥700.00"}]
[{"$nulls":5},"扬声器",{"v":150,"d":"¥150.00"},{"v":0,"d":"¥0.00"}]
[{"$nulls":5},"差旅"]
[null,"场地","估计","实际",null,"住宿"]
[null,"会议室和大厅费用",{"v":500,"d":"¥500.00"},{"v":450,"d":"¥450.00"},null,"其他"]
[null,"现场人员",{"$nulls":3},"汇总",{"$f":"SUBTOTAL(109,ProgramExpenses[估计])","v":{"v":900,"d":"¥900.00"}},{"$f":"SUBTOTAL(109,ProgramExpenses[实际])","v":{"v":700,"d":"¥700.00"}}]
[null,"设备"]
[null,"桌椅",{"$nulls":3},"宣传","估计","实际"]
[null,"汇总",{"$f":"SUBTOTAL(109,SiteExpenses[估计])","v":{"v":500,"d":"¥500.00"}},{"$f":"SUBTOTAL(109,SiteExpenses[实际])","v":{"v":450,"d":"¥450.00"}},null,"图形工作"]
[{"$nulls":5},"影印/打印",{"v":20,"d":"¥20.00"},{"v":20,"d":"¥20.00"}]
[null,"装饰","估计","实际",null,"邮费"]
[null,"花卉",{"v":200,"d":"¥200.00"},{"v":100,"d":"¥100.00"},null,"汇总",{"$f":"SUBTOTAL(109,PublicityExpenses[估计])","v":{"v":20,"d":"¥20.00"}},{"$f":"SUBTOTAL(109,PublicityExpenses[实际])","v":{"v":20,"d":"¥20.00"}}]
[null,"蜡烛"]
[null,"照明",{"$nulls":3},"奖品","估计","实际"]
[null,"气球",{"$nulls":3},"绶带/奖品"]
[null,"纸",{"$nulls":3},"礼品",{"v":100,"d":"¥100.00"},{"v":100,"d":"¥100.00"}]
[null,"汇总",{"$f":"SUBTOTAL(109,DecorationsExpenses[估计])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[实际])","v":{"v":100,"d":"¥100.00"}},null,"汇总",{"$f":"SUBTOTAL(109,PrizesExpenses[估计])","v":{"v":100,"d":"¥100.00"}},{"$f":"SUBTOTAL(109,PrizesExpenses[实际])","v":{"v":100,"d":"¥100.00"}}]
[]
[null,"茶点","估计","实际",null,"杂项","估计","实际"]
[null,"食物",{"$nulls":3},"电话",{"v":50,"d":"¥50.00"},{"v":50,"d":"¥50.00"}]
[null,"饮料",{"v":220,"d":"¥220.00"},{"v":120,"d":"¥120.00"},null,"交通",{"v":20,"d":"¥20.00"},{"v":20,"d":"¥20.00"}]
[null,"亚麻布",{"v":80,"d":"¥80.00"},{"v":80,"d":"¥80.00"},null,"文具"]
[null,"服务人员和小费",{"$nulls":3},"传真服务"]
[null,"汇总",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[估计])","v":{"v":300,"d":"¥300.00"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[实际])","v":{"v":200,"d":"¥200.00"}},null,"汇总",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[估计])","v":{"v":70,"d":"¥70.00"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[实际])","v":{"v":70,"d":"¥70.00"}}]

{"sheet":"收入","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[6,1,7,1],[9,1,9,6],[16,1,16,6],[23,1,23,6],[30,1,30,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"支出!B3","v":"产品发布会"}]
[null,"收入详细信息"]
[]
[]
[null,"总收入","估计","实际"]
[null,null,{"$f":"SUM(Admissions[[#Totals],[估计收益]],AdsInProgram[[#Totals],[估计收益]],ExhibitorsAndVendors[[#Totals],[估计收益]],SaleOfItems[[#Totals],[估计收益]])","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"SUM(Admissions[[#Totals],[实际收益]],AdsInProgram[[#Totals],[实际收益]],ExhibitorsAndVendors[[#Totals],[实际收益]],SaleOfItems[[#Totals],[实际收益]])","v":{"v":4170,"d":"¥4,170.00"}}]
[]
[null,"入场券"]
[null,"类型","估计","实际","价格","估计收益","实际收益"]
[null,"成人",30,25,{"v":20,"d":"¥20.00"},{"$f":"C12*E12","v":{"v":600,"d":"¥600.00"}},{"$f":"D12*E12","v":{"v":500,"d":"¥500.00"}}]
[null,"儿童",20,22,{"v":10,"d":"¥10.00"},{"$f":"C13*E13","v":{"v":200,"d":"¥200.00"}},{"$f":"D13*E13","v":{"v":220,"d":"¥220.00"}}]
[null,"其他",10,10,{"v":10,"d":"¥10.00"},{"$f":"C14*E14","v":{"v":100,"d":"¥100.00"}},{"$f":"D14*E14","v":{"v":100,"d":"¥100.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,Admissions[估计])","v":60},{"$f":"SUBTOTAL(109,Admissions[实际])","v":57},null,{"$f":"SUBTOTAL(109,Admissions[估计收益])","v":{"v":900,"d":"¥900.00"}},{"$f":"SUBTOTAL(109,Admissions[实际收益])","v":{"v":820,"d":"¥820.00"}}]
[]
[null,"节目广告"]
[null,"类型","估计","实际","价格","估计收益","实际收益"]
[null,"封面",2,4,{"v":50,"d":"¥50.00"},{"$f":"C19*E19","v":{"v":100,"d":"¥100.00"}},{"$f":"D19*E19","v":{"v":200,"d":"¥200.00"}}]
[null,"半页",2,2,{"v":30,"d":"¥30.00"},{"$f":"C20*E20","v":{"v":60,"d":"¥60.00"}},{"$f":"D20*E20","v":{"v":60,"d":"¥60.00"}}]
[null,"四分之一版面",2,2,{"v":20,"d":"¥20.00"},{"$f":"C21*E21","v":{"v":40,"d":"¥40.00"}},{"$f":"D21*E21","v":{"v":40,"d":"¥40.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,AdsInProgram[估计])","v":6},{"$f":"SUBTOTAL(109,AdsInProgram[实际])","v":8},null,{"$f":"SUBTOTAL(109,AdsInProgram[估计收益])","v":{"v":200,"d":"¥200.00"}},{"$f":"SUBTOTAL(109,AdsInProgram[实际收益])","v":{"v":300,"d":"¥300.00"}}]
[]
[null,"参展商/供应商"]
[null,"类型","估计","实际","价格","估计收益","实际收益"]
[null,"大型展厅",5,5,{"v":300,"d":"¥300.00"},{"$f":"C26*E26","v":{"v":1500,"d":"¥1,500.00"}},{"$f":"D26*E26","v":{"v":1500,"d":"¥1,500.00"}}]
[null,"中型展厅",5,4,{"v":200,"d":"¥200.00"},{"$f":"C27*E27","v":{"v":1000,"d":"¥1,000.00"}},{"$f":"D27*E27","v":{"v":800,"d":"¥800.00"}}]
[null,"小型展厅",1,0,{"v":100,"d":"¥100.00"},{"$f":"C28*E28","v":{"v":100,"d":"¥100.00"}},{"$f":"D28*E28","v":{"v":0,"d":"¥0.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[估计])","v":11},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[实际])","v":9},null,{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[估计收益])","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[实际收益])","v":{"v":2300,"d":"¥2,300.00"}}]
[]
[null,"商品销售"]
[null,"类型","估计","实际","价格","估计收益","实际收益"]
[null,"商品 1",2,2,{"v":150,"d":"¥150.00"},{"$f":"C33*E33","v":{"v":300,"d":"¥300.00"}},{"$f":"D33*E33","v":{"v":300,"d":"¥300.00"}}]
[null,"物品​​ 2",5,5,{"v":50,"d":"¥50.00"},{"$f":"C34*E34","v":{"v":250,"d":"¥250.00"}},{"$f":"D34*E34","v":{"v":250,"d":"¥250.00"}}]
[null,"物品​​ 3",5,5,{"v":20,"d":"¥20.00"},{"$f":"C35*E35","v":{"v":100,"d":"¥100.00"}},{"$f":"D35*E35","v":{"v":100,"d":"¥100.00"}}]
[null,"物品 4",5,5,{"v":20,"d":"¥20.00"},{"$f":"C36*E36","v":{"v":100,"d":"¥100.00"}},{"$f":"D36*E36","v":{"v":100,"d":"¥100.00"}}]
[null,"汇总",{"$f":"SUBTOTAL(109,SaleOfItems[估计])","v":17},{"$f":"SUBTOTAL(109,SaleOfItems[实际])","v":17},null,{"$f":"SUBTOTAL(109,SaleOfItems[估计收益])","v":{"v":750,"d":"¥750.00"}},{"$f":"SUBTOTAL(109,SaleOfItems[实际收益])","v":{"v":750,"d":"¥750.00"}}]

{"sheet":"损益汇总","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"支出!B3","v":"产品发布会"}]
[null,"损益汇总"]
[]
[]
[null,"支出汇总","估计","实际",null,"实际支出",{"$nulls":5},"排名","支出","估计","实际","排名值"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"节目"},{"$f":"VLOOKUP(1,$L$8:$O$14,3,FALSE)","v":{"v":900,"d":"¥900.00"}},{"$f":"VLOOKUP(1,$L$8:$O$14,4,FALSE)","v":{"v":700,"d":"¥700.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P8,$P$8:$P$14)","v":2},"场地",{"$f":"SiteExpenses[[#Totals],[估计]]","v":{"v":500,"d":"¥500"}},{"$f":"SiteExpenses[[#Totals],[实际]]","v":{"v":450,"d":"¥450"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"场地"},{"$f":"VLOOKUP(2,$L$8:$O$14,3,FALSE)","v":{"v":500,"d":"¥500.00"}},{"$f":"VLOOKUP(2,$L$8:$O$14,4,FALSE)","v":{"v":450,"d":"¥450.00"}},{"$nulls":7},5,"装饰",{"$f":"DecorationsExpenses[[#Totals],[估计]]","v":{"v":200,"d":"¥200"}},{"$f":"DecorationsExpenses[[#Totals],[实际]]","v":{"v":100,"d":"¥100"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"茶点"},{"$f":"VLOOKUP(3,$L$8:$O$14,3,FALSE)","v":{"v":300,"d":"¥300.00"}},{"$f":"VLOOKUP(3,$L$8:$O$14,4,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$nulls":7},3,"茶点",{"$f":"RefreshmentsExpenses[[#Totals],[估计]]","v":{"v":300,"d":"¥300"}},{"$f":"RefreshmentsExpenses[[#Totals],[实际]]","v":{"v":200,"d":"¥200"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"奖品"},{"$f":"VLOOKUP(4,$L$8:$O$14,3,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$f":"VLOOKUP(4,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$nulls":7},1,"节目",{"$f":"ProgramExpenses[[#Totals],[估计]]","v":{"v":900,"d":"¥900"}},{"$f":"ProgramExpenses[[#Totals],[实际]]","v":{"v":700,"d":"¥700"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"装饰"},{"$f":"VLOOKUP(5,$L$8:$O$14,3,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$f":"VLOOKUP(5,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"¥100.00"}},{"$nulls":7},7,"宣传",{"$f":"PublicityExpenses[[#Totals],[估计]]","v":{"v":20,"d":"¥20"}},{"$f":"PublicityExpenses[[#Totals],[实际]]","v":{"v":20,"d":"¥20"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"杂项"},{"$f":"VLOOKUP(6,$L$8:$O$14,3,FALSE)","v":{"v":70,"d":"¥70.00"}},{"$f":"VLOOKUP(6,$L$8:$O$14,4,FALSE)","v":{"v":70,"d":"¥70.00"}},{"$nulls":7},4,"奖品",{"$f":"PrizesExpenses[[#Totals],[估计]]","v":{"v":100,"d":"¥100"}},{"$f":"PrizesExpenses[[#Totals],[实际]]","v":{"v":100,"d":"¥100"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"宣传"},{"$f":"VLOOKUP(7,$L$8:$O$14,3,FALSE)","v":{"v":20,"d":"¥20.00"}},{"$f":"VLOOKUP(7,$L$8:$O$14,4,FALSE)","v":{"v":20,"d":"¥20.00"}},{"$nulls":7},6,"杂项",{"$f":"MiscellaneousExpenses[[#Totals],[估计]]","v":{"v":70,"d":"¥70"}},{"$f":"MiscellaneousExpenses[[#Totals],[实际]]","v":{"v":70,"d":"¥70"}},70.0014]
[null,"汇总",{"$f":"SUBTOTAL(109,ExpensesSummary[估计])","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"SUBTOTAL(109,ExpensesSummary[实际])","v":{"v":1640,"d":"¥1,640.00"}}]
[]
[null,"收入汇总","估计","实际",null,"实际收益",{"$nulls":5},"排名","收入","估计","实际","排名值"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"参展商/供应商"},{"$f":"VLOOKUP(1,$L$18:$O$21,3,FALSE)","v":{"v":2600,"d":"¥2,600.00"}},{"$f":"VLOOKUP(1,$L$18:$O$21,4,FALSE)","v":{"v":2300,"d":"¥2,300.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P18,$P$18:$P$21)","v":2},"入场券",{"$f":"Admissions[[#Totals],[估计收益]]","v":{"v":900,"d":"¥900"}},{"$f":"Admissions[[#Totals],[实际收益]]","v":{"v":820,"d":"¥820"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"入场券"},{"$f":"VLOOKUP(2,$L$18:$O$21,3,FALSE)","v":{"v":900,"d":"¥900.00"}},{"$f":"VLOOKUP(2,$L$18:$O$21,4,FALSE)","v":{"v":820,"d":"¥820.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P19,$P$18:$P$21)","v":4},"节目广告",{"$f":"AdsInProgram[[#Totals],[估计收益]]","v":{"v":200,"d":"¥200"}},{"$f":"AdsInProgram[[#Totals],[实际收益]]","v":{"v":300,"d":"¥300"}},300.0019]
[null,"商品销售",{"$f":"VLOOKUP(3,$L$18:$O$21,3,FALSE)","v":{"v":750,"d":"¥750.00"}},{"$f":"VLOOKUP(3,$L$18:$O$21,4,FALSE)","v":{"v":750,"d":"¥750.00"}},{"$nulls":7},1,"参展商/供应商",{"$f":"ExhibitorsAndVendors[[#Totals],[估计收益]]","v":{"v":2600,"d":"¥2,600"}},{"$f":"ExhibitorsAndVendors[[#Totals],[实际收益]]","v":{"v":2300,"d":"¥2,300"}},{"v":2300.002,"d":"2300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"节目广告"},{"$f":"VLOOKUP(4,$L$18:$O$21,3,FALSE)","v":{"v":200,"d":"¥200.00"}},{"$f":"VLOOKUP(4,$L$18:$O$21,4,FALSE)","v":{"v":300,"d":"¥300.00"}},{"$nulls":7},3,"商品销售",{"$f":"SaleOfItems[[#Totals],[估计收益]]","v":{"v":750,"d":"¥750"}},{"$f":"SaleOfItems[[#Totals],[实际收益]]","v":{"v":750,"d":"¥750"}},750.0021]
[null,"汇总",{"$f":"SUBTOTAL(109,IncomeSummary[估计])","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"SUBTOTAL(109,IncomeSummary[实际])","v":{"v":4170,"d":"¥4,170.00"}}]
[]
[null,"损益汇总","估计","实际"]
[null,"总收入",{"$f":"IncomeSummary[[#Totals],[估计]]","v":{"v":4450,"d":"¥4,450.00"}},{"$f":"IncomeSummary[[#Totals],[实际]]","v":{"v":4170,"d":"¥4,170.00"}}]
[null,"总支出",{"$f":"ExpensesSummary[[#Totals],[估计]]","v":{"v":2090,"d":"¥2,090.00"}},{"$f":"ExpensesSummary[[#Totals],[实际]]","v":{"v":1640,"d":"¥1,640.00"}}]
[null,"利润（或损失）",{"$f":"C25-C26","v":{"v":2360,"d":"¥2,360.00"}},{"$f":"D25-D26","v":{"v":2530,"d":"¥2,530.00"}}]
[]
[null,"支出与利润（损失）比率",null,null,"估计与实际成本"]