{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["派對總覽","賓客名單","餐飲","其他必需品","座位安排方格"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"派對總覽","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"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(GuestTable[出席？],\"=是\",GuestTable[大人])","v":26},{"$f":"FoodTable[[#Data],[#Totals],[每個大人的成本]]","v":{"v":57.69230769230769,"d":"NT$57.69"}},{"$f":"EssentialCostPerGuest","v":{"v":560.8695652173913,"d":"NT$560.87"}},{"$f":"(AttendeeSummary[[#This Row],[食物]]+AttendeeSummary[[#This Row],[其他]])*AdultTotal","v":{"v":16082.608695652174,"d":"NT$16,082.61"}}]
[null,"2011-06-14",null,"小孩",{"$f":"SUMIF(GuestTable[出席？],\"=是\",GuestTable[小孩])","v":20},{"$f":"FoodTable[每個小孩的成本]","v":{"v":48.91304347826087,"d":"NT$48.91"}},{"$f":"EssentialCostPerGuest","v":{"v":560.8695652173913,"d":"NT$560.87"}},{"$f":"(AttendeeSummary[[#This Row],[食物]]+AttendeeSummary[[#This Row],[其他]])*ChildrenTotal","v":{"v":12195.652173913042,"d":"NT$12,195.65"}}]
[{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,AttendeeSummary[已確認總數])","v":46},{"$f":"\"平均值     \"&TEXT(SUBTOTAL(101,AttendeeSummary[食物]),\"#,##0.00\")","v":"平均值     53.30"},{"$f":"\"平均值     \"&TEXT(SUBTOTAL(101,AttendeeSummary[其他]),\"#,##0.00\")","v":"平均值     560.87"},{"$f":"SUBTOTAL(109,AttendeeSummary[合計])","v":{"v":28278.260869565216,"d":"NT$28,278.26"}}]
[null,"時間"]
[null,"下午 2 - 4 點"]
[]
[null,"地點",null,"預算摘要"]
[null,"怡君阿姨家",null,"項目","個數","預算金額","總成本","差額"]
[{"$nulls":3},"餐飲",{"$f":"COUNTA(FoodTable[食物或飲料項目])","v":18},{"v":15000,"d":"NT$15,000.00"},{"$f":"FoodTable[[#Totals],[總成本]]","v":{"v":14250,"d":"NT$14,250.00"}},{"$f":"BudgetOverview[[#This Row],[預算金額]]-BudgetOverview[[#This Row],[總成本]]","v":{"v":750,"d":"NT$750.00"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"設備與供應品"},{"$f":"COUNTA(Table1Budget[設備與供應品])","v":7},{"v":12000,"d":"NT$12,000.00"},{"$f":"Table1Budget[[#Totals],[成本]]","v":{"v":12000,"d":"NT$12,000.00"}},{"$f":"BudgetOverview[[#This Row],[預算金額]]-BudgetOverview[[#This Row],[總成本]]","v":{"v":0,"d":"NT$0.00"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"佈置裝飾"},{"$f":"COUNTA(Table2Budget[佈置裝飾])","v":4},{"v":4500,"d":"NT$4,500.00"},{"$f":"Table2Budget[[#Totals],[成本]]","v":{"v":5250,"d":"NT$5,250.00"}},{"$f":"BudgetOverview[[#This Row],[預算金額]]-BudgetOverview[[#This Row],[總成本]]","v":{"v":-750,"d":"(NT$750.00)"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"其他"},{"$f":"COUNTA(Table3Budget[其他])","v":4},{"v":9000,"d":"NT$9,000.00"},{"$f":"Table3Budget[[#Totals],[成本]]","v":{"v":8550,"d":"NT$8,550.00"}},{"$f":"BudgetOverview[[#This Row],[預算金額]]-BudgetOverview[[#This Row],[總成本]]","v":{"v":450,"d":"NT$450.00"}}]
[{"$nulls":3},"合計",{"$f":"SUBTOTAL(109,BudgetOverview[個數])","v":33},{"$f":"SUBTOTAL(109,BudgetOverview[預算金額])","v":{"v":40500,"d":"NT$40,500.00"}},{"$f":"SUBTOTAL(109,BudgetOverview[總成本])","v":{"v":40050,"d":"NT$40,050.00"}},{"$f":"BudgetOverview[[#Totals],[預算金額]]-BudgetOverview[[#Totals],[總成本]]","v":{"v":450,"d":"NT$450.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(GuestTable[[#This Row],[小孩]:[大人]])","v":4}]
[null,"家庭 2","地址 2","鄉鎮市區 2","縣/市 2","郵遞區號 2","電話 2","電子郵件 2","是",1,1,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":2}]
[null,"家庭 3","地址 3","鄉鎮市區 3","縣/市 3","郵遞區號 3","電話 3","電子郵件 3","是",3,3,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":6}]
[null,"家庭 4","地址 4","鄉鎮市區 4","縣/市 4","郵遞區號 4","電話 4","電子郵件 4",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":2}]
[null,"家庭 5","地址 5","鄉鎮市區 5","縣/市 5","郵遞區號 5","電話 5","電子郵件 5","是",4,3,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":7}]
[null,"家庭 6","地址 6","鄉鎮市區 6","縣/市 6","郵遞區號 6","電話 6","電子郵件 6","是",2,2,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":4}]
[null,"家庭 7","地址 7","鄉鎮市區 7","縣/市 7","郵遞區號 7","電話 7","電子郵件 7","是",1,4,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":5}]
[null,"家庭 8","地址 8","鄉鎮市區 8","縣/市 8","郵遞區號 8","電話 8","電子郵件 8","否",5,3,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":8}]
[null,"家庭 9","地址 9","鄉鎮市區 9","縣/市 9","郵遞區號 9","電話 9","電子郵件 9","是",3,2,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":5}]
[null,"家庭 10","地址 10","鄉鎮市區 10","縣/市 10","郵遞區號 10","電話 10","電子郵件 10","是",null,4,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":4}]
[null,"家庭 11","地址 11","鄉鎮市區 11","縣/市 11","郵遞區號 11","電話 11","電子郵件 11","是",3,5,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":8}]
[null,"家庭 12","地址 12","鄉鎮市區 12","縣/市 12","郵遞區號 12","電話 12","電子郵件 12","否",2,3,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":5}]
[null,"家庭 13","地址 13","鄉鎮市區 13","縣/市 13","郵遞區號 13","電話 13","電子郵件 13","是",3,2,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":5}]
[null,"家庭 14","地址 14","鄉鎮市區 14","縣/市 14","郵遞區號 14","電話 14","電子郵件 14","否",null,1,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":1}]
[null,"家庭 15","地址 15","鄉鎮市區 15","縣/市 15","郵遞區號 15","電話 15","電子郵件 15",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[小孩]:[大人]])","v":2}]

{"sheet":"餐飲","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"餐飲"]
[]
[null,"輸入成本與估計的份量，本工具便會根據總出席數，自動為您算出總份量與單份成本"]
[null,"食物或飲料項目","總成本","每個小孩的份量","每個大人的份量","總份量","單份成本","每個小孩的成本","每個大人的成本","附註"]
[null,"汽水",{"v":450,"d":"NT$450.00"},0.5,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":62},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":7.258064516129032,"d":"NT$7.26"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":3.629032258064516,"d":"NT$3.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":14.516129032258064,"d":"NT$14.52"}},"2 公升瓶裝"]
[null,"盒裝果汁",{"v":450,"d":"NT$450.00"},2,0,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":40},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":11.25,"d":"NT$11.25"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":22.5,"d":"NT$22.50"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":0,"d":"NT$0.00"}},"蘋果和白葡萄"]
[null,"酒",{"v":1500,"d":"NT$1,500.00"},0,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":52},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":28.846153846153847,"d":"NT$28.85"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":57.69230769230769,"d":"NT$57.69"}}]
[null,"蛋糕",{"v":2250,"d":"NT$2,250.00"},1,1,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":46},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":48.91304347826087,"d":"NT$48.91"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":48.91304347826087,"d":"NT$48.91"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":48.91304347826087,"d":"NT$48.91"}},"向當地的麵包店訂購"]
[null,"冰淇淋",{"v":600,"d":"NT$600.00"},1,1.5,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":59},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":10.169491525423728,"d":"NT$10.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":10.169491525423728,"d":"NT$10.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":15.254237288135592,"d":"NT$15.25"}}]
[null,"布丁杯",{"v":450,"d":"NT$450.00"},1,0,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":20},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":22.5,"d":"NT$22.50"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":22.5,"d":"NT$22.50"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":0,"d":"NT$0.00"}},"購買杯裝布丁：香草和巧克力口味"]
[null,"鑲蘑菇",{"v":960,"d":"NT$960.00"},1,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":13.333333333333334,"d":"NT$13.33"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":13.333333333333334,"d":"NT$13.33"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":26.666666666666668,"d":"NT$26.67"}},"鈕扣蘑菇鑲奶油起司和香腸"]
[null,"普切塔",{"v":660,"d":"NT$660.00"},0,3,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":78},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":8.461538461538462,"d":"NT$8.46"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":0,"d":"NT$0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":25.384615384615387,"d":"NT$25.38"}},"蕃茄和羅勒 "]
[null,"煙燻鮭魚",{"v":1500,"d":"NT$1,500.00"},1,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":20.833333333333332,"d":"NT$20.83"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":20.833333333333332,"d":"NT$20.83"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":41.666666666666664,"d":"NT$41.67"}}]
[null,"迷你貝果",{"v":600,"d":"NT$600.00"},1,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":8.333333333333334,"d":"NT$8.33"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":8.333333333333334,"d":"NT$8.33"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":16.666666666666668,"d":"NT$16.67"}},"4 袋 - 多種混合"]
[null,"奶油起司",{"v":300,"d":"NT$300.00"},1,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":4.166666666666667,"d":"NT$4.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":4.166666666666667,"d":"NT$4.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":8.333333333333334,"d":"NT$8.33"}},"2 大桶"]
[null,"酸豆",{"v":360,"d":"NT$360.00"},1,2,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":5,"d":"NT$5.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":5,"d":"NT$5.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":10,"d":"NT$10.00"}},"3 罐"]
[null,"雞翅",{"v":1350,"d":"NT$1,350.00"},2,4,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":144},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":9.375,"d":"NT$9.38"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":18.75,"d":"NT$18.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":37.5,"d":"NT$37.50"}},"向當地的雞翅店購買"]
[null,"鷹嘴豆泥",{"v":300,"d":"NT$300.00"},4,6,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":1.271186440677966,"d":"NT$1.27"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":5.084745762711864,"d":"NT$5.08"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":7.627118644067796,"d":"NT$7.63"}},"前一天晚上做"]
[null,"帕馬森起司皮塔脆片",{"v":420,"d":"NT$420.00"},4,6,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":1.7796610169491525,"d":"NT$1.78"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":7.11864406779661,"d":"NT$7.12"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":10.677966101694915,"d":"NT$10.68"}},"前一天晚上做"]
[null,"什錦蔬菜",{"v":900,"d":"NT$900.00"},4,10,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":340},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":2.6470588235294117,"d":"NT$2.65"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":10.588235294117647,"d":"NT$10.59"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":26.470588235294116,"d":"NT$26.47"}},"紅蘿蔔條、芹菜、青花椰菜、白花椰菜、紅椒和青椒"]
[null,"起司球",{"v":450,"d":"NT$450.00"},5,10,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":1.25,"d":"NT$1.25"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":6.25,"d":"NT$6.25"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":12.5,"d":"NT$12.50"}},"組合：奶油起司、含堅果的陳年起司"]
[null,"餅乾",{"v":750,"d":"NT$750.00"},5,10,{"$f":"(FoodTable[[#This Row],[每個小孩的份量]]*ChildrenTotal)+(FoodTable[[#This Row],[每個大人的份量]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[總成本]]/FoodTable[[#This Row],[總份量]],\"\")","v":{"v":2.0833333333333335,"d":"NT$2.08"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個小孩的份量]],\"\")","v":{"v":10.416666666666668,"d":"NT$10.42"}},{"$f":"IFERROR(FoodTable[[#This Row],[單份成本]]*FoodTable[[#This Row],[每個大人的份量]],\"\")","v":{"v":20.833333333333336,"d":"NT$20.83"}},"多種混合"]
[null,"合計",{"$f":"SUBTOTAL(109,FoodTable[總成本])","v":{"v":14250,"d":"NT$14,250.00"}},{"$f":"SUBTOTAL(109,FoodTable[每個小孩的份量])","v":34.5},{"$f":"SUBTOTAL(109,FoodTable[每個大人的份量])","v":65.5},{"$f":"SUBTOTAL(109,FoodTable[總份量])","v":2393},{"$f":"SUBTOTAL(109,FoodTable[單份成本])","v":{"v":207.4711981086625,"d":"NT$207.47"}},{"$f":"SUBTOTAL(109,FoodTable[每個小孩的成本])","v":{"v":217.58652571970856,"d":"NT$217.59"}},{"$f":"SUBTOTAL(109,FoodTable[每個大人的成本])","v":{"v":380.70267252330103,"d":"NT$380.70"}}]

{"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":7500,"d":"NT$7,500.00"},"是"]
[null,"亞麻桌巾",{"v":900,"d":"NT$900.00"},"是","已租"]
[null,"桌椅",{"v":0,"d":"NT$0.00"},null,"包含在租場內"]
[null,"飲料紙巾",{"v":750,"d":"NT$750.00"}]
[null,"餐巾",{"v":600,"d":"NT$600.00"},null,"已租"]
[null,"餐桌服務",{"v":1500,"d":"NT$1,500.00"},null,"已租"]
[null,"玻璃器皿",{"v":750,"d":"NT$750.00"},null,"已租"]
[null,"合計",{"$f":"SUBTOTAL(109,Table1Budget[成本])","v":{"v":12000,"d":"NT$12,000.00"}}]
[]
[]
[]
[null,"佈置裝飾","成本","已購買","附註"]
[null,"氣球",{"v":750,"d":"NT$750.00"}]
[null,"氦氣箱",{"v":1500,"d":"NT$1,500.00"},null,"已租"]
[null,"餐桌中央擺飾",{"v":3000,"d":"NT$3,000.00"},"是","共 10 項"]
[null,"玻璃花瓶",{"v":0,"d":"NT$0.00"},null,"向安娜借"]
[null,"合計",{"$f":"SUBTOTAL(109,Table2Budget[成本])","v":{"v":5250,"d":"NT$5,250.00"}}]
[]
[]
[]
[null,"其他","成本","已購買","附註"]
[null,"邀請卡",{"v":1500,"d":"NT$1,500.00"},"是"]
[null,"郵資",{"v":1800,"d":"NT$1,800.00"},"是"]
[null,"攝影師",{"v":3750,"d":"NT$3,750.00"},null,"2 小時 (下午 2 - 4 點)"]
[null,"派對小禮物",{"v":1500,"d":"NT$1,500.00"}]
[null,"合計",{"$f":"SUBTOTAL(109,Table3Budget[成本])","v":{"v":8550,"d":"NT$8,550.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 吋)"]