{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["聚会总览","来宾列表","食品及饮料","其他必需品","座位安排网格"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"聚会总览","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[6,3,6,4],[6,5,6,6],[9,1,9,2]]}
[]
[]
[null,"聚会总览"]
[]
[]
[null,"事件",null,"来宾统计",{"$nulls":3},{"$f":"\"未回复人数: \"&OutstandingRSVPs","v":"未回复人数: 2"}]
[null,"祖母 75 岁生日",null,"回复总览",null,"每位来宾成本",null,"预算金额"]
[{"$nulls":3},"确认来宾","确认总计","饮食","其他","总计"]
[null,"日期",null,"成人",{"$f":"SUMIF(来宾表[是否出席？],\"=是\",来宾表[成人])","v":26},{"$f":"食品表[[#Totals],[每位成人成本]]","v":{"v":126.90089084110036,"d":"¥126.90"}},{"$f":"EssentialCostPerGuest","v":{"v":186.95652173913044,"d":"¥186.96"}},{"$f":"(参加者摘要[[#This Row],[饮食]]+参加者摘要[[#This Row],[其他]])*AdultTotal","v":{"v":8160.292727086001,"d":"¥8,160.29"}}]
[null,"2011-06-14",null,"儿童",{"$f":"SUMIF(来宾表[是否出席？],\"=是\",来宾表[儿童])","v":20},{"$f":"食品表[[#Totals],[每位儿童成本]]","v":{"v":72.52884190656951,"d":"¥72.53"}},{"$f":"EssentialCostPerGuest","v":{"v":186.95652173913044,"d":"¥186.96"}},{"$f":"(参加者摘要[[#This Row],[饮食]]+参加者摘要[[#This Row],[其他]])*AdultTotal","v":{"v":6746.6194547882,"d":"¥6,746.62"}}]
[{"$nulls":3},"总计",{"$f":"SUBTOTAL(109,参加者摘要[确认总计])","v":46},{"$f":"\"平均            \"&TEXT(SUBTOTAL(101,参加者摘要[饮食]),\"[$-C04]¥#,##0.00\")","v":"平均            ¥99.71"},{"$f":"\"平均         \"&TEXT(SUBTOTAL(101,参加者摘要[其他]),\"[$-C04]¥#,##0.00\")","v":"平均         ¥186.96"},{"$f":"SUBTOTAL(109,参加者摘要[总计])","v":{"v":14906.9121818742,"d":"¥14,906.91"}}]
[null,"时间"]
[null,"下午 2 点到下午 4 点"]
[]
[null,"地点"]
[null,"Kim 阿姨家中",null,"预算摘要"]
[{"$nulls":3},"项目","计数","预算金额","总成本","差额"]
[{"$nulls":3},"食品和饮料",{"$f":"COUNTA(食品表[食品或饮料项目])","v":18},{"v":5000,"d":"¥5,000.00"},{"$f":"食品表[[#Totals],[总成本]]","v":{"v":4750,"d":"¥4,750.00"}},{"$f":"预算总览[[#This Row],[预算金额]]-预算总览[[#This Row],[总成本]]","v":{"v":250,"d":"¥250.00"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"设备和用品"},{"$f":"COUNTA(表_1_预算[设备和用品])","v":7},{"v":4000,"d":"¥4,000.00"},{"$f":"表_1_预算[[#Totals],[成本]]","v":{"v":4000,"d":"¥4,000.00"}},{"$f":"预算总览[[#This Row],[预算金额]]-预算总览[[#This Row],[总成本]]","v":{"v":0,"d":"¥0.00"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"装饰品"},{"$f":"COUNTA(表_2_预算[装饰品])","v":4},{"v":1500,"d":"¥1,500.00"},{"$f":"表_2_预算[[#Totals],[成本]]","v":{"v":1750,"d":"¥1,750.00"}},{"$f":"预算总览[[#This Row],[预算金额]]-预算总览[[#This Row],[总成本]]","v":{"v":-250,"d":"!(¥250.00!)"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"其他"},{"$f":"COUNTA(表_3_预算[其他])","v":4},{"v":3000,"d":"¥3,000.00"},{"$f":"表_3_预算[[#Totals],[成本]]","v":{"v":2850,"d":"¥2,850.00"}},{"$f":"预算总览[[#This Row],[预算金额]]-预算总览[[#This Row],[总成本]]","v":{"v":150,"d":"¥150.00"}}]
[{"$nulls":3},"总计",{"$f":"SUBTOTAL(109,预算总览[计数])","v":33},{"$f":"SUBTOTAL(109,预算总览[预算金额])","v":{"v":13500,"d":"¥13,500.00"}},{"$f":"SUBTOTAL(109,预算总览[总成本])","v":{"v":13350,"d":"¥13,350.00"}},{"$f":"预算总览[[#Totals],[预算金额]]-预算总览[[#Totals],[总成本]]","v":{"v":150,"d":"¥150.00"}}]

{"sheet":"来宾列表","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"来宾列表"]
[]
[]
[]
[null,"姓名","地址","市/县","省/市/自治区","邮政编码","电话","电子邮件","是否出席？","儿童","成人","总计"]
[null,"家庭 1","地址 1","市/县 1","省/市/自治区 1","邮政编码 1","电话 1","电子邮件 1","否",2,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":4}]
[null,"家庭 2","地址 2","市/县 2","省/市/自治区 2","邮政编码 2","电话 2","电子邮件 2","是",1,1,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":2}]
[null,"家庭 3","地址 3","市/县 3","省/市/自治区 3","邮政编码 3","电话 3","电子邮件 3","是",3,3,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":6}]
[null,"家庭 4","地址 4","市/县 4","省/市/自治区 4","邮政编码 4","电话 4","电子邮件 4",null,null,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":2}]
[null,"家庭 5","地址 5","市/县 5","省/市/自治区 5","邮政编码 5","电话 5","电子邮件 5","是",4,3,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":7}]
[null,"家庭 6","地址 6","市/县 6","省/市/自治区 6","邮政编码 6","电话 6","电子邮件 6","是",2,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":4}]
[null,"家庭 7","地址 7","市/县 7","省/市/自治区 7","邮政编码 7","电话 7","电子邮件 7","是",1,4,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":5}]
[null,"家庭 8","地址 8","市/县 8","省/市/自治区 8","邮政编码 8","电话 8","电子邮件 8","否",5,3,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":8}]
[null,"家庭 9","地址 9","市/县 9","省/市/自治区 9","邮政编码 9","电话 9","电子邮件 9","是",3,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":5}]
[null,"家庭 10","地址 10","市/县 10","省/市/自治区 10","邮政编码 10","电话 10","电子邮件 10","是",null,4,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":4}]
[null,"家庭 11","地址 11","市/县 11","省/市/自治区 11","邮政编码 11","电话 11","电子邮件 11","是",3,5,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":8}]
[null,"家庭 12","地址 12","市/县 12","省/市/自治区 12","邮政编码 12","电话 12","电子邮件 12","否",2,3,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":5}]
[null,"家庭 13","地址 13","市/县 13","省/市/自治区 13","邮政编码 13","电话 13","电子邮件 13","是",3,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":5}]
[null,"家庭 14","地址 14","市/县 14","省/市/自治区 14","邮政编码 14","电话 14","电子邮件 14","否",null,1,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":1}]
[null,"家庭 15","地址 15","市/县 15","省/市/自治区 15","邮政编码 15","电话 15","电子邮件 15",null,null,2,{"$f":"SUM(来宾表[[#This Row],[儿童]:[成人]])","v":2}]

{"sheet":"食品及饮料","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"食品和饮料"]
[]
[null,"请输入成本和预计份数以根据总参与者自动计算总份数和每份的成本"]
[null,"食品或饮料项目","总成本","每位儿童份数","每位成人份数","总份数","每份成本","每位儿童成本","每位成人成本","备注"]
[null,"苏打",{"v":150,"d":"¥150.00"},0.5,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":62},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":2.4193548387096775,"d":"¥2.42"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":1.2096774193548387,"d":"¥1.21"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":4.838709677419355,"d":"¥4.84"}},"2 升瓶装"]
[null,"果汁瓶",{"v":150,"d":"¥150.00"},2,0,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":40},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":3.75,"d":"¥3.75"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":7.5,"d":"¥7.50"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":0},"苹果和白葡萄"]
[null,"酒水",{"v":500,"d":"¥500.00"},0,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":52},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":9.615384615384615,"d":"¥9.62"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":0},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":19.23076923076923,"d":"¥19.23"}}]
[null,"蛋糕",{"v":750,"d":"¥750.00"},1,1,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":46},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":16.304347826086957,"d":"¥16.30"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":16.304347826086957,"d":"¥16.30"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":16.304347826086957,"d":"¥16.30"}},"从当地面包店订购"]
[null,"冰激凌",{"v":200,"d":"¥200.00"},1,1.5,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":59},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":3.389830508474576,"d":"¥3.39"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":3.389830508474576,"d":"¥3.39"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":5.084745762711864,"d":"¥5.08"}}]
[null,"布丁杯",{"v":150,"d":"¥150.00"},1,0,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":20},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":7.5,"d":"¥7.50"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":7.5,"d":"¥7.50"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":0},"购买打包杯：香草和巧克力味"]
[null,"酿蘑菇",{"v":320,"d":"¥320.00"},1,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":72},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":4.444444444444445,"d":"¥4.44"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":4.444444444444445,"d":"¥4.44"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":8.88888888888889,"d":"¥8.89"}},"奶油干酪香肠酿草菇"]
[null,"意式特色面包",{"v":220,"d":"¥220.00"},0,3,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":78},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":2.8205128205128207,"d":"¥2.82"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":0},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":8.461538461538462,"d":"¥8.46"}},"番茄罗勒 "]
[null,"烟熏三文鱼",{"v":500,"d":"¥500.00"},1,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":72},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":6.944444444444445,"d":"¥6.94"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":6.944444444444445,"d":"¥6.94"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":13.88888888888889,"d":"¥13.89"}}]
[null,"迷你百吉饼",{"v":200,"d":"¥200.00"},1,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":72},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":2.7777777777777777,"d":"¥2.78"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":2.7777777777777777,"d":"¥2.78"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":5.555555555555555,"d":"¥5.56"}},"4 包\t（各种口味）"]
[null,"奶油干酪",{"v":100,"d":"¥100.00"},1,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":72},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":1.3888888888888888,"d":"¥1.39"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":1.3888888888888888,"d":"¥1.39"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":2.7777777777777777,"d":"¥2.78"}},"2 大桶"]
[null,"酸豆",{"v":120,"d":"¥120.00"},1,2,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":72},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":1.6666666666666667,"d":"¥1.67"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":1.6666666666666667,"d":"¥1.67"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":3.3333333333333335,"d":"¥3.33"}},"3 罐"]
[null,"鸡翅",{"v":450,"d":"¥450.00"},2,4,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":144},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":3.125,"d":"¥3.13"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":6.25,"d":"¥6.25"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":12.5,"d":"¥12.50"}},"从当地鸡翅店购买"]
[null,"鹰嘴豆泥",{"v":100,"d":"¥100.00"},4,6,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":236},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":0.423728813559322,"d":"¥0.42"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":1.694915254237288,"d":"¥1.69"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":2.542372881355932,"d":"¥2.54"}},"前一晚准备好"]
[null,"帕尔马干酪皮塔饼薯片",{"v":140,"d":"¥140.00"},4,6,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":236},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":0.5932203389830508,"d":"¥0.59"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":2.3728813559322033,"d":"¥2.37"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":3.559322033898305,"d":"¥3.56"}},"前一晚准备好"]
[null,"什锦蔬菜",{"v":300,"d":"¥300.00"},4,10,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":340},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":0.8823529411764706,"d":"¥0.88"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":3.5294117647058822,"d":"¥3.53"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":8.823529411764707,"d":"¥8.82"}},"胡萝卜条、芹菜、西兰花、菜花、红椒和青椒"]
[null,"奶酪球",{"v":150,"d":"¥150.00"},5,10,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":360},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":0.4166666666666667,"d":"¥0.42"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":2.0833333333333335,"d":"¥2.08"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":4.166666666666667,"d":"¥4.17"}},"什锦：奶油干酪、浓郁奶酪夹坚果"]
[null,"咸饼干",{"v":250,"d":"¥250.00"},5,10,{"$f":"(食品表[[#This Row],[每位儿童份数]]*ChildrenTotal)+(食品表[[#This Row],[每位成人份数]]*AdultTotal)","v":360},{"$f":"IFERROR(食品表[[#This Row],[总成本]]/食品表[[#This Row],[总份数]],\"\")","v":{"v":0.6944444444444444,"d":"¥0.69"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位儿童份数]],\"\")","v":{"v":3.4722222222222223,"d":"¥3.47"}},{"$f":"IFERROR(食品表[[#This Row],[每份成本]]*食品表[[#This Row],[每位成人份数]],\"\")","v":{"v":6.944444444444445,"d":"¥6.94"}},"什锦"]
[null,"总计",{"$f":"SUBTOTAL(109,食品表[总成本])","v":{"v":4750,"d":"¥4,750.00"}},{"$f":"SUBTOTAL(109,食品表[每位儿童份数])","v":34.5},{"$f":"SUBTOTAL(109,食品表[每位成人份数])","v":65.5},{"$f":"SUBTOTAL(109,食品表[总份数])","v":2393},{"$f":"SUBTOTAL(109,食品表[每份成本])","v":{"v":69.1570660362208,"d":"¥69.16"}},{"$f":"SUBTOTAL(109,食品表[每位儿童成本])","v":{"v":72.52884190656951,"d":"¥72.53"}},{"$f":"SUBTOTAL(109,食品表[每位成人成本])","v":{"v":126.90089084110036,"d":"¥126.90"}}]

{"sheet":"其他必需品","index":3,"n_rows":32,"n_cols":5,"rows_kept":32,"merged":[[15,1,15,4],[24,1,24,4]]}
[]
[]
[null,"其他必需品"]
[]
[]
[null,"设备和用品","成本","已购买","备注"]
[null,"房间/餐厅租赁",{"v":2500,"d":"¥2,500.00"},"是"]
[null,"日用织品",{"v":300,"d":"¥300.00"},"是","租金"]
[null,"桌椅",0,null,"包含在餐厅租金中"]
[null,"饮料餐巾",{"v":250,"d":"¥250.00"}]
[null,"晚餐餐巾",{"v":200,"d":"¥200.00"},null,"租金"]
[null,"餐桌服务",{"v":500,"d":"¥500.00"},null,"租金"]
[null,"玻璃器具",{"v":250,"d":"¥250.00"},null,"租金"]
[null,"总计",{"$f":"SUBTOTAL(109,表_1_预算[成本])","v":{"v":4000,"d":"¥4,000.00"}}]
[]
[]
[]
[null,"装饰品","成本","已购买","备注"]
[null,"气球",{"v":250,"d":"¥250.00"}]
[null,"氦气瓶",{"v":500,"d":"¥500.00"},null,"租金"]
[null,"餐桌中央装饰品",{"v":1000,"d":"¥1,000.00"},"是","共 10 个"]
[null,"玻璃花瓶",0,null,"从 Sandy 处借入"]
[null,"总计",{"$f":"SUBTOTAL(109,表_2_预算[成本])","v":{"v":1750,"d":"¥1,750.00"}}]
[]
[]
[]
[null,"其他","成本","已购买","备注"]
[null,"邀请函",{"v":500,"d":"¥500.00"},"是"]
[null,"邮资",{"v":600,"d":"¥600.00"},"是"]
[null,"摄影师",{"v":1250,"d":"¥1,250.00"},null,"2 小时（下午 2 点 - 下午 4 点）"]
[null,"聚会装饰品",{"v":500,"d":"¥500.00"}]
[null,"总计",{"$f":"SUBTOTAL(109,表_3_预算[成本])","v":{"v":2850,"d":"¥2,850.00"}}]

{"sheet":"座位安排网格","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["座位安排"]
{"$rows_empty":33}
[{"$nulls":33},"*1 平 = 约 1 平方英尺"]
["备注",{"$nulls":18},{"$f":"\" 确认来宾的总数：  \"&ConfirmedGuests","v":" 确认来宾的总数：  46"}]
[{"$nulls":19},"您可使用以下任一餐桌设置："]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)&\" 张 54 英寸圆桌（6 个座位）\"","v":"8 张 54 英寸圆桌（6 个座位）"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0) &\" 张 60 英寸圆桌（8 个座位）\"","v":"6 张 60 英寸圆桌（8 个座位）"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/10,0)&\" 张 72 英寸圆桌（10 个座位）\"","v":"5 张 72 英寸圆桌（10 个座位）"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)& \" 张 30 英寸 x 72 英寸方桌（6 个座位）\"","v":"8 张 30 英寸 x 72 英寸方桌（6 个座位）"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0)&\" 张 30 英寸 x 96 英寸方桌（8 个座位）\"","v":"6 张 30 英寸 x 96 英寸方桌（8 个座位）"}]
[{"$nulls":19},"（餐桌最佳间距 42 英寸）"]