{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Tổng quan Bữa tiệc","Danh sách Khách","Thức ăn & Đồ uống","Thiết yếu Khác","Bố trí chỗ ngồi"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Tổng quan Bữa tiệc","index":0,"n_rows":21,"n_cols":8,"rows_kept":21}
[]
[]
[null,"Tổng quan Bữa tiệc"]
[]
[]
[null,"SỰ KIỆN",null,"TÓM TẮT KHÁCH",{"$nulls":3},{"$f":"\"CHƯA TRẢ LỜI:  \"&OutstandingRSVPs","v":"CHƯA TRẢ LỜI:  2"}]
[null,"Sinh nhật lần thứ 75 của Bà",null,"TỔNG QUAN LƯỢT TRẢ LỜI",null,"CHI PHÍ MỖI KHÁCH",null,"SỐ TIỀN NGÂN SÁCH"]
[{"$nulls":3},"Khách đã Xác nhận","Tổng Xác nhận","Thức ăn","Khác","Tổng cộng"]
[null,"NGÀY",null,"Người lớn",{"$f":"SUMIF(GuestTable[CÓ THAM DỰ?],\"=Có\",GuestTable[NGƯỜI LỚN])","v":26},{"$f":"FoodTable[[#Totals],[CHI PHÍ MỖI NGƯỜI LỚN]]","v":{"v":263953.8529494888,"d":"263,953.85 ₫"}},{"$f":"EssentialCostPerGuest","v":{"v":388869.5652173913,"d":"388,869.57 ₫"}},{"$f":"(AttendeeSummary[[#This Row],[Thức ăn]]+AttendeeSummary[[#This Row],[Khác]])*AdultTotal","v":{"v":16973408.87233888,"d":"16,973,408.87 ₫"}}]
[null,"14/06/2011",null,"Trẻ em",{"$f":"SUMIF(GuestTable[CÓ THAM DỰ?],\"=Có\",GuestTable[TRẺ EM])","v":20},{"$f":"FoodTable[[#Totals],[CHI PHÍ MỖI TRẺ EM]]","v":{"v":150859.9911656646,"d":"150,859.99 ₫"}},{"$f":"EssentialCostPerGuest","v":{"v":388869.5652173913,"d":"388,869.57 ₫"}},{"$f":"(AttendeeSummary[[#This Row],[Thức ăn]]+AttendeeSummary[[#This Row],[Khác]])*ChildrenTotal","v":{"v":10794591.127661116,"d":"10,794,591.13 ₫"}}]
[{"$nulls":3},"Tổng cộng",{"$f":"SUBTOTAL(109,AttendeeSummary[Tổng Xác nhận])","v":46},{"$f":"\"TB     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Thức ăn]),\"#,##0.00  ₫\")","v":"TB     207,406.92  ₫"},{"$f":"\"TB     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Khác]),\"#,##0.00  ₫\")","v":"TB     388,869.57  ₫"},{"$f":"SUBTOTAL(109,AttendeeSummary[Tổng cộng])","v":{"v":27767999.999999996,"d":"27,768,000.00 ₫"}}]
[null,"THỜI GIAN"]
[null,"2 giờ chiều đến 4 giờ chiều"]
[]
[null,"VỊ TRÍ",null,"TÓM TẮT NGÂN SÁCH\n"]
[null,"Nhà của Dì Kim",null,"MỤC","ĐẾM","SỐ TIỀN NGÂN SÁCH","TỔNG CHI PHÍ","CHÊNH LỆCH"]
[{"$nulls":3},"Thức ăn và Đồ uống",{"$f":"COUNTA(FoodTable[MỤC THỨC ĂN VÀ ĐỒ UỐNG])","v":18},{"v":10400000,"d":"10,400,000.00 ₫"},{"$f":"FoodTable[[#Totals],[TỔNG CHI PHÍ]]","v":{"v":9880000,"d":"9,880,000.00 ₫"}},{"$f":"BudgetOverview[[#This Row],[SỐ TIỀN NGÂN SÁCH]]-BudgetOverview[[#This Row],[TỔNG CHI PHÍ]]","v":{"v":520000,"d":"520,000.00 ₫"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"Thiết bị & Vật tư"},{"$f":"COUNTA(Table1Budget[Thiết bị & Vật tư])","v":7},{"v":8320000,"d":"8,320,000.00 ₫"},{"$f":"Table1Budget[[#Totals],[Chi phí]]","v":{"v":8320000,"d":"8,320,000.00 ₫"}},{"$f":"BudgetOverview[[#This Row],[SỐ TIỀN NGÂN SÁCH]]-BudgetOverview[[#This Row],[TỔNG CHI PHÍ]]","v":{"v":0,"d":"0.00 ₫"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"Trang trí"},{"$f":"COUNTA(Table2Budget[Trang trí])","v":4},{"v":3120000,"d":"3,120,000.00 ₫"},{"$f":"Table2Budget[[#Totals],[Chi phí]]","v":{"v":3640000,"d":"3,640,000.00 ₫"}},{"$f":"BudgetOverview[[#This Row],[SỐ TIỀN NGÂN SÁCH]]-BudgetOverview[[#This Row],[TỔNG CHI PHÍ]]","v":{"v":-520000,"d":"520,000.00 ₫"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"Khác"},{"$f":"COUNTA(Table3Budget[Khác])","v":4},{"v":6240000,"d":"6,240,000.00 ₫"},{"$f":"Table3Budget[[#Totals],[Chi phí]]","v":{"v":5928000,"d":"5,928,000.00 ₫"}},{"$f":"BudgetOverview[[#This Row],[SỐ TIỀN NGÂN SÁCH]]-BudgetOverview[[#This Row],[TỔNG CHI PHÍ]]","v":{"v":312000,"d":"312,000.00 ₫"}}]
[{"$nulls":3},"Tổng cộng",{"$f":"SUBTOTAL(109,BudgetOverview[ĐẾM])","v":33},{"$f":"SUBTOTAL(109,BudgetOverview[SỐ TIỀN NGÂN SÁCH])","v":{"v":28080000,"d":"28,080,000.00 ₫"}},{"$f":"SUBTOTAL(109,BudgetOverview[TỔNG CHI PHÍ])","v":{"v":27768000,"d":"27,768,000.00 ₫"}},{"$f":"BudgetOverview[[#Totals],[SỐ TIỀN NGÂN SÁCH]]-BudgetOverview[[#Totals],[TỔNG CHI PHÍ]]","v":{"v":312000,"d":"312,000.00 ₫"}}]

{"sheet":"Danh sách Khách","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Danh sách Khách"]
[]
[]
[]
[null,"TÊN","ĐỊA CHỈ","THÀNH PHỐ","BANG","ZIP","ĐIỆN THOẠI","EMAIL","CÓ THAM DỰ?","TRẺ EM","NGƯỜI LỚN","TỔNG"]
[null,"Gia đình 1","Địa chỉ 1","Thành phố 1","Bang 1","Zip 1","Điện thoại 1","Email1","Không",2,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":4}]
[null,"Gia đình 2","Địa chỉ 2","Thành phố 2","Bang 2","Zip 2","Điện thoại 2","Email2","Có",1,1,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":2}]
[null,"Gia đình 3","Địa chỉ 3","Thành phố 3","Bang 3","Zip 3","Điện thoại 3","Email3","Có",3,3,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":6}]
[null,"Gia đình 4","Địa chỉ 4","Thành phố 4","Bang 4","Zip 4","Điện thoại 4","Email4",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":2}]
[null,"Gia đình 5","Địa chỉ 5","Thành phố 5","Bang 5","Zip 5","Điện thoại 5","Email5","Có",4,3,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":7}]
[null,"Gia đình 6","Địa chỉ 6","Thành phố 6","Bang 6","Zip 6","Điện thoại 6","Email6","Có",2,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":4}]
[null,"Gia đình 7","Địa chỉ 7","Thành phố 7","Bang 7","Zip 7","Điện thoại 7","Email7","Có",1,4,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":5}]
[null,"Gia đình 8","Địa chỉ 8","Thành phố 8","Bang 8","Zip 8","Điện thoại 8","Email8","Không",5,3,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":8}]
[null,"Gia đình 9","Địa chỉ 9","Thành phố 9","Bang 9","Zip 9","Điện thoại 9","Email9","Có",3,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":5}]
[null,"Gia đình 10","Địa chỉ 10","Thành phố 10","Bang 10","Zip 10","Điện thoại 10","Email10","Có",null,4,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":4}]
[null,"Gia đình 11","Địa chỉ 11","Thành phố 11","Bang 11","Zip 11","Điện thoại 11","Email11","Có",3,5,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":8}]
[null,"Gia đình 12","Địa chỉ 12","Thành phố 12","Bang 12","Zip 12","Điện thoại 12","Email12","Không",2,3,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":5}]
[null,"Gia đình 13","Địa chỉ 13","Thành phố 14","Bang 13","Zip 13","Điện thoại 13","Email13","Có",3,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":5}]
[null,"Gia đình 14","Địa chỉ 14","Thành phố 14","Bang 14","Zip 14","Điện thoại 14","Email14","Không",null,1,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":1}]
[null,"Gia đình 15","Địa chỉ 15","Thành phố 15","Bang 15","Zip 15","Điện thoại 15","Email15",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[TRẺ EM]:[NGƯỜI LỚN]])","v":2}]

{"sheet":"Thức ăn & Đồ uống","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Thức ăn & Đồ uống"]
[]
[null,"Nhập chi phí khẩu phần và ước tính để tự động tính tổng phần và chi phí mỗi khẩu phần dựa trên tổng tham dự"]
[null,"MỤC THỨC ĂN VÀ ĐỒ UỐNG","TỔNG CHI PHÍ","KHẨU PHẦN MỖI TRẺ EM","KHẨU PHẦN MỖI NGƯỜI LỚN","TỔNG KHẨU PHẦN","CHI PHÍ MỖI KHẨU PHẦN","CHI PHÍ MỖI TRẺ EM","CHI PHÍ MỖI NGƯỜI LỚN","CHÚ THÍCH"]
[null,"Nước xô đa",{"v":312000,"d":"312,000.00 ₫"},0.5,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":62},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":5032.258064516129,"d":"5,032.26 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":2516.1290322580644,"d":"2,516.13 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":10064.516129032258,"d":"10,064.52 ₫"}},"Chai 2 lít"]
[null,"Hộp nước hoa quả",{"v":312000,"d":"312,000.00 ₫"},2,0,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":40},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":7800,"d":"7,800.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":15600,"d":"15,600.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":0,"d":"0.00 ₫"}},"Táo và nho trắng"]
[null,"Rượu",{"v":1040000,"d":"1,040,000.00 ₫"},0,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":52},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":20000,"d":"20,000.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":0,"d":"0.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":40000,"d":"40,000.00 ₫"}}]
[null,"Bánh",{"v":1560000,"d":"1,560,000.00 ₫"},1,1,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":46},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":33913.04347826087,"d":"33,913.04 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":33913.04347826087,"d":"33,913.04 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":33913.04347826087,"d":"33,913.04 ₫"}},"Đặt hàng từ hàng bánh địa phương"]
[null,"Kem",{"v":416000,"d":"416,000.00 ₫"},1,1.5,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":59},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":7050.847457627118,"d":"7,050.85 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":7050.847457627118,"d":"7,050.85 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":10576.271186440677,"d":"10,576.27 ₫"}}]
[null,"Ly pút-đinh",{"v":312000,"d":"312,000.00 ₫"},1,0,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":20},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":15600,"d":"15,600.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":15600,"d":"15,600.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":0,"d":"0.00 ₫"}},"Mua ly đóng gói: vani và sô cô la"]
[null,"Nấm nhồi",{"v":665600,"d":"665,600.00 ₫"},1,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":9244.444444444445,"d":"9,244.44 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":9244.444444444445,"d":"9,244.44 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":18488.88888888889,"d":"18,488.89 ₫"}},"Nấm nhồi với pho mát kem và xúc xích"]
[null,"Bruschetta",{"v":457600,"d":"457,600.00 ₫"},0,3,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":78},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":5866.666666666667,"d":"5,866.67 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":0,"d":"0.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":17600,"d":"17,600.00 ₫"}},"Cà chua và ngò thơm "]
[null,"Cá hồi hun khói",{"v":1040000,"d":"1,040,000.00 ₫"},1,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":14444.444444444445,"d":"14,444.44 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":14444.444444444445,"d":"14,444.44 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":28888.88888888889,"d":"28,888.89 ₫"}}]
[null,"Bánh mì mini",{"v":416000,"d":"416,000.00 ₫"},1,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":5777.777777777777,"d":"5,777.78 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":5777.777777777777,"d":"5,777.78 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":11555.555555555555,"d":"11,555.56 ₫"}},"4 túi - các loại"]
[null,"Pho mát kem",{"v":208000,"d":"208,000.00 ₫"},1,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":2888.8888888888887,"d":"2,888.89 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":2888.8888888888887,"d":"2,888.89 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":5777.777777777777,"d":"5,777.78 ₫"}},"2 bồn lớn"]
[null,"Nụ bạch hoa",{"v":249600,"d":"249,600.00 ₫"},1,2,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":3466.6666666666665,"d":"3,466.67 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":3466.6666666666665,"d":"3,466.67 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":6933.333333333333,"d":"6,933.33 ₫"}},"3 lọ"]
[null,"Cánh gà",{"v":936000,"d":"936,000.00 ₫"},2,4,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":144},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":6500,"d":"6,500.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":13000,"d":"13,000.00 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":26000,"d":"26,000.00 ₫"}},"Mua từ của hàng bán lẻ địa phương"]
[null,"Món khai vị hummus",{"v":208000,"d":"208,000.00 ₫"},4,6,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":881.3559322033898,"d":"881.36 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":3525.423728813559,"d":"3,525.42 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":5288.135593220339,"d":"5,288.14 ₫"}},"Làm trước một đêm"]
[null,"Pitta chiên giòn phủ phô mai bào",{"v":291200,"d":"291,200.00 ₫"},4,6,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":1233.8983050847457,"d":"1,233.90 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":4935.593220338983,"d":"4,935.59 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":7403.389830508475,"d":"7,403.39 ₫"}},"Làm trước một đêm"]
[null,"Các loại rau",{"v":624000,"d":"624,000.00 ₫"},4,10,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":340},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":1835.2941176470588,"d":"1,835.29 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":7341.176470588235,"d":"7,341.18 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":18352.941176470587,"d":"18,352.94 ₫"}},"Cà rốt chẻ, cần tây, bông cải xanh, súp lơ, ớt đỏ và xanh"]
[null,"Viên pho mát",{"v":312000,"d":"312,000.00 ₫"},5,10,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":866.6666666666666,"d":"866.67 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":4333.333333333333,"d":"4,333.33 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":8666.666666666666,"d":"8,666.67 ₫"}},"Các loại: pho mát kem, pho mát cứng với các loại hạt"]
[null,"Bánh quy",{"v":520000,"d":"520,000.00 ₫"},5,10,{"$f":"(FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]]*ChildrenTotal)+(FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TỔNG CHI PHÍ]]/FoodTable[[#This Row],[TỔNG KHẨU PHẦN]],\"\")","v":{"v":1444.4444444444443,"d":"1,444.44 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI TRẺ EM]],\"\")","v":{"v":7222.222222222222,"d":"7,222.22 ₫"}},{"$f":"IFERROR(FoodTable[[#This Row],[CHI PHÍ MỖI KHẨU PHẦN]]*FoodTable[[#This Row],[KHẨU PHẦN MỖI NGƯỜI LỚN]],\"\")","v":{"v":14444.444444444443,"d":"14,444.44 ₫"}},"Các loại"]
[null,"Tổng cộng",{"$f":"SUBTOTAL(109,FoodTable[TỔNG CHI PHÍ])","v":{"v":9880000,"d":"9,880,000.00 ₫"}},{"$f":"SUBTOTAL(109,FoodTable[KHẨU PHẦN MỖI TRẺ EM])","v":34.5},{"$f":"SUBTOTAL(109,FoodTable[KHẨU PHẦN MỖI NGƯỜI LỚN])","v":65.5},{"$f":"SUBTOTAL(109,FoodTable[TỔNG KHẨU PHẦN])","v":2393},{"$f":"SUBTOTAL(109,FoodTable[CHI PHÍ MỖI KHẨU PHẦN])","v":{"v":143846.6973553393,"d":"143,846.70 ₫"}},{"$f":"SUBTOTAL(109,FoodTable[CHI PHÍ MỖI TRẺ EM])","v":{"v":150859.9911656646,"d":"150,859.99 ₫"}},{"$f":"SUBTOTAL(109,FoodTable[CHI PHÍ MỖI NGƯỜI LỚN])","v":{"v":263953.8529494888,"d":"263,953.85 ₫"}}]

{"sheet":"Thiết yếu Khác","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Thiết yếu Khác"]
[]
[]
[null,"Thiết bị & Vật tư","Chi phí","Mua","Ghi chú"]
[null,"Thuê phòng/hội trường",{"v":5200000,"d":"5,200,000.00 ₫"},"Có"]
[null,"Vải lanh trải bàn",{"v":624000,"d":"624,000.00 ₫"},"Có","Tiền thuê"]
[null,"Bàn và ghế",{"v":0,"d":"0.00 ₫"},null,"Có trong tiền thuê hội trường"]
[null,"Khăn ăn cho đồ uống",{"v":520000,"d":"520,000.00 ₫"}]
[null,"Khăn ăn cho bữa ăn",{"v":416000,"d":"416,000.00 ₫"},null,"Tiền thuê"]
[null,"Phụ vụ bàn",{"v":1040000,"d":"1,040,000.00 ₫"},null,"Tiền thuê"]
[null,"Bộ đồ uống",{"v":520000,"d":"520,000.00 ₫"},null,"Tiền thuê"]
[null,"Tổng cộng",{"$f":"SUBTOTAL(109,Table1Budget[Chi phí])","v":{"v":8320000,"d":"8,320,000.00 ₫"}}]
[]
[]
[null,"Trang trí","Chi phí","Mua","Ghi chú"]
[null,"Bóng bay",{"v":520000,"d":"520,000.00 ₫"}]
[null,"Thùng chứa khí hê-li",{"v":1040000,"d":"1,040,000.00 ₫"},null,"Tiền thuê"]
[null,"Vật trang trí ở giữa",{"v":2080000,"d":"2,080,000.00 ₫"},"Có","Tổng 10"]
[null,"Bình rượu",{"v":0,"d":"0.00 ₫"},null,"Mượn từ Sandy"]
[null,"Tổng cộng",{"$f":"SUBTOTAL(109,Table2Budget[Chi phí])","v":{"v":3640000,"d":"3,640,000.00 ₫"}}]
[]
[]
[null,"Khác","Chi phí","Mua","Ghi chú"]
[null,"Giấy mời",{"v":1040000,"d":"1,040,000.00 ₫"},"Có"]
[null,"Bưu phí",{"v":1248000,"d":"1,248,000.00 ₫"},"Có"]
[null,"Thợ ảnh",{"v":2600000,"d":"2,600,000.00 ₫"},null,"2 giờ (2 giờ chiều  - 4 giờ chiều)"]
[null,"Quà tặng của bữa tiệc",{"v":1040000,"d":"1,040,000.00 ₫"}]
[null,"Tổng cộng",{"$f":"SUBTOTAL(109,Table3Budget[Chi phí])","v":{"v":5928000,"d":"5,928,000.00 ₫"}}]

{"sheet":"Bố trí chỗ ngồi","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Bố trí chỗ ngồi"]
{"$rows_empty":33}
[{"$nulls":33},"*1 mét vuông= khoảng 1 foot vuông"]
["Ghi chú",{"$nulls":18},{"$f":"\" Tổng số khách đã xác nhận: \"&ConfirmedGuests","v":" Tổng số khách đã xác nhận: 46"}]
[{"$nulls":19},"Bạn có thể sử dụng bất kỳ thiết lập bảng sau đây:"]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)&\" bàn tròn 54-inch (6 chỗ)\"","v":"8 bàn tròn 54-inch (6 chỗ)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0) &\" bàn tròn 60-inch (8 chỗ)\"","v":"6 bàn tròn 60-inch (8 chỗ)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/10,0)&\" bàn tròn 72-inch (10 chỗ)\"","v":"5 bàn tròn 72-inch (10 chỗ)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)& \" bàn hình vuông 30-inch x 72-inch (6 chỗ)\"","v":"8 bàn hình vuông 30-inch x 72-inch (6 chỗ)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0)&\" bàn hình vuông 30-inch x 96-inch (8 chỗ)\"","v":"6 bàn hình vuông 30-inch x 96-inch (8 chỗ)"}]
[{"$nulls":19},"(Không gian ưu tiên giữa các bàn: 42 in-sơ)"]