{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Party Overview","Guest List","Food & Beverage","Other Essentials","Seating Arrangement Grid"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Party Overview","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,"Party Overview"]
[]
[]
[null,"EVENT",null,"GUEST SUMMARY",{"$nulls":3},{"$f":"\"OUTSTANDING RSVPS: \"&OutstandingRSVPs","v":"OUTSTANDING RSVPS: 2"}]
[null,"Grandma's 75th Birthday",null,"RSVP OVERVIEW",null,"COSTS PER GUEST",null,"BUDGET AMOUNT"]
[{"$nulls":3},"Confirmed Guests","Total Confirmed","Food","Other","Total"]
[null,"DATE",null,"Adults",{"$f":"SUMIF(GuestTable[ATTENDING?],\"=Yes\",GuestTable[ADULTS])","v":26},{"$f":"FoodTable[[#Totals],[COST PER ADULT]]","v":{"v":12.690089084110037,"d":"$12.69"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"$18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Food]]+AttendeeSummary[[#This Row],[Other]])*AdultTotal","v":{"v":816.0292727086002,"d":"$816.03"}}]
[null,"2011-06-14",null,"Children",{"$f":"SUMIF(GuestTable[ATTENDING?],\"=Yes\",GuestTable[CHILDREN])","v":20},{"$f":"FoodTable[[#Totals],[COST PER CHILD]]","v":{"v":7.252884190656953,"d":"$7.25"}},{"$f":"EssentialCostPerGuest","v":{"v":18.695652173913043,"d":"$18.70"}},{"$f":"(AttendeeSummary[[#This Row],[Food]]+AttendeeSummary[[#This Row],[Other]])*ChildrenTotal","v":{"v":518.9707272914,"d":"$518.97"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,AttendeeSummary[Total Confirmed])","v":46},{"$f":"\"Avg.     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Food]),\"$#,##0.00\")","v":"Avg.     $9.97"},{"$f":"\"Avg.     \"&TEXT(SUBTOTAL(101,AttendeeSummary[Other]),\"$#,##0.00\")","v":"Avg.     $18.70"},{"$f":"SUBTOTAL(109,AttendeeSummary[Total])","v":{"v":1335,"d":"$1,335.00"}}]
[null,"TIME"]
[null,"2 pm to 4 pm"]
[]
[null,"LOCATION",null,"BUDGET SUMMARY"]
[null,"Aunt Kim's House",null,"ITEM","COUNT","BUDGET AMOUNT","TOTAL COST","DIFFERENCE"]
[{"$nulls":3},"Food and Beverage",{"$f":"COUNTA(FoodTable[FOOD OR BEVERAGE ITEM])","v":18},{"v":500,"d":"$500.00"},{"$f":"FoodTable[[#Totals],[TOTAL COST]]","v":{"v":475,"d":"$475.00"}},{"$f":"BudgetOverview[[#This Row],[BUDGET AMOUNT]]-BudgetOverview[[#This Row],[TOTAL COST]]","v":{"v":25,"d":"$25.00"}}]
[{"$nulls":3},{"$f":"Table1Header","v":"Equipment & Supplies"},{"$f":"COUNTA(Table1Budget[Equipment & Supplies])","v":7},{"v":400,"d":"$400.00"},{"$f":"Table1Budget[[#Totals],[Cost]]","v":{"v":400,"d":"$400.00"}},{"$f":"BudgetOverview[[#This Row],[BUDGET AMOUNT]]-BudgetOverview[[#This Row],[TOTAL COST]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},{"$f":"Table2Header","v":"Decorations"},{"$f":"COUNTA(Table2Budget[Decorations])","v":4},{"v":150,"d":"$150.00"},{"$f":"Table2Budget[[#Totals],[Cost]]","v":{"v":175,"d":"$175.00"}},{"$f":"BudgetOverview[[#This Row],[BUDGET AMOUNT]]-BudgetOverview[[#This Row],[TOTAL COST]]","v":{"v":-25,"d":"($25.00)"}}]
[{"$nulls":3},{"$f":"Table3Header","v":"Other"},{"$f":"COUNTA(Table3Budget[Other])","v":4},{"v":300,"d":"$300.00"},{"$f":"Table3Budget[[#Totals],[Cost]]","v":{"v":285,"d":"$285.00"}},{"$f":"BudgetOverview[[#This Row],[BUDGET AMOUNT]]-BudgetOverview[[#This Row],[TOTAL COST]]","v":{"v":15,"d":"$15.00"}}]
[{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,BudgetOverview[COUNT])","v":33},{"$f":"SUBTOTAL(109,BudgetOverview[BUDGET AMOUNT])","v":{"v":1350,"d":"$1,350.00"}},{"$f":"SUBTOTAL(109,BudgetOverview[TOTAL COST])","v":{"v":1335,"d":"$1,335.00"}},{"$f":"BudgetOverview[[#Totals],[BUDGET AMOUNT]]-BudgetOverview[[#Totals],[TOTAL COST]]","v":{"v":15,"d":"$15.00"}}]

{"sheet":"Guest List","index":1,"n_rows":22,"n_cols":12,"rows_kept":22}
[]
[]
[null,"Guest List"]
[]
[]
[]
[null,"NAME","ADDRESS","CITY","STATE","ZIP","PHONE","EMAIL","ATTENDING?","CHILDREN","ADULTS","TOTAL"]
[null,"Family 1","Address 1","City 1","State 1","Zip 1","Phone 1","Email1","No",2,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":4}]
[null,"Family 2","Address 2","City 2","State 2","Zip 2","Phone 2","Email2","Yes",1,1,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":2}]
[null,"Family 3","Address 3","City 3","State 3","Zip 3","Phone 3","Email3","Yes",3,3,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":6}]
[null,"Family 4","Address 4","City 4","State 4","Zip 4","Phone 4","Email4",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":2}]
[null,"Family 5","Address 5","City 5","State 5","Zip 5","Phone 5","Email5","Yes",4,3,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":7}]
[null,"Family 6","Address 6","City 6","State 6","Zip 6","Phone 6","Email6","Yes",2,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":4}]
[null,"Family 7","Address 7","City 7","State 7","Zip 7","Phone 7","Email7","Yes",1,4,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":5}]
[null,"Family 8","Address 8","City 8","State 8","Zip 8","Phone 8","Email8","No",5,3,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":8}]
[null,"Family 9","Address 9","City 9","State 9","Zip 9","Phone 9","Email9","Yes",3,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":5}]
[null,"Family 10","Address 10","City 10","State 10","Zip 10","Phone 10","Email10","Yes",null,4,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":4}]
[null,"Family 11","Address 11","City 11","State 11","Zip 11","Phone 11","Email11","Yes",3,5,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":8}]
[null,"Family 12","Address 12","City 12","State 12","Zip 12","Phone 12","Email12","No",2,3,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":5}]
[null,"Family 13","Address 13","City 13","State 13","Zip 13","Phone 13","Email13","Yes",3,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":5}]
[null,"Family 14","Address 14","City 14","State 14","Zip 14","Phone 14","Email14","No",null,1,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":1}]
[null,"Family 15","Address 15","City 15","State 15","Zip 15","Phone 15","Email15",null,null,2,{"$f":"SUM(GuestTable[[#This Row],[CHILDREN]:[ADULTS]])","v":2}]

{"sheet":"Food & Beverage","index":2,"n_rows":25,"n_cols":10,"rows_kept":25}
[]
[]
[null,"Food & Beverage"]
[]
[null,"Enter cost and estimated servings to automatically calculate total pieces and cost per serving based on attendance total"]
[null,"FOOD OR BEVERAGE ITEM","TOTAL COST","SERVING PER CHILD","SERVING PER ADULT","TOTAL SERVINGS","COST PER SERVING","COST PER CHILD","COST PER ADULT","NOTES"]
[null,"Soda",{"v":15,"d":"$15.00"},0.5,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":62},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.24193548387096775,"d":"$0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.12096774193548387,"d":"$0.12"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.4838709677419355,"d":"$0.48"}},"2 liter bottles"]
[null,"Juice boxes",{"v":15,"d":"$15.00"},2,0,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":40},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.375,"d":"$0.38"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.75,"d":"$0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0,"d":"$0.00"}},"Apple and white grape"]
[null,"Wine",{"v":50,"d":"$50.00"},0,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":52},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.9615384615384616,"d":"$0.96"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":1.9230769230769231,"d":"$1.92"}}]
[null,"Cake",{"v":75,"d":"$75.00"},1,1,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":46},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":1.6304347826086956,"d":"$1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":1.6304347826086956,"d":"$1.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":1.6304347826086956,"d":"$1.63"}},"Order from local bakery"]
[null,"Ice cream",{"v":20,"d":"$20.00"},1,1.5,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":59},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.3389830508474576,"d":"$0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.3389830508474576,"d":"$0.34"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.5084745762711864,"d":"$0.51"}}]
[null,"Pudding cups",{"v":15,"d":"$15.00"},1,0,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":20},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.75,"d":"$0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.75,"d":"$0.75"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0,"d":"$0.00"}},"Purchase packaged cups: vanilla and chocolate"]
[null,"Stuffed mushrooms",{"v":32,"d":"$32.00"},1,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.4444444444444444,"d":"$0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.4444444444444444,"d":"$0.44"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.8888888888888888,"d":"$0.89"}},"Button mushrooms stuffed with cream cheese and sausage"]
[null,"Bruschetta",{"v":22,"d":"$22.00"},0,3,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":78},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.28205128205128205,"d":"$0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.8461538461538461,"d":"$0.85"}},"Tomato and basil "]
[null,"Smoked salmon",{"v":50,"d":"$50.00"},1,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.6944444444444444,"d":"$0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.6944444444444444,"d":"$0.69"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":1.3888888888888888,"d":"$1.39"}}]
[null,"Mini bagels",{"v":20,"d":"$20.00"},1,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.2777777777777778,"d":"$0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.2777777777777778,"d":"$0.28"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.5555555555555556,"d":"$0.56"}},"4 bags - assorted"]
[null,"Cream cheese",{"v":10,"d":"$10.00"},1,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.1388888888888889,"d":"$0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.1388888888888889,"d":"$0.14"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.2777777777777778,"d":"$0.28"}},"2 big tubs"]
[null,"Capers",{"v":12,"d":"$12.00"},1,2,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":72},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.16666666666666666,"d":"$0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.16666666666666666,"d":"$0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.3333333333333333,"d":"$0.33"}},"3 jars"]
[null,"Chicken wings",{"v":45,"d":"$45.00"},2,4,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":144},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.3125,"d":"$0.31"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.625,"d":"$0.63"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":1.25,"d":"$1.25"}},"Purchase from local wing shop"]
[null,"Hummus",{"v":10,"d":"$10.00"},4,6,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.0423728813559322,"d":"$0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.1694915254237288,"d":"$0.17"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.2542372881355932,"d":"$0.25"}},"Make the night before"]
[null,"Parmesan pita crisps",{"v":14,"d":"$14.00"},4,6,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":236},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.059322033898305086,"d":"$0.06"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.23728813559322035,"d":"$0.24"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.3559322033898305,"d":"$0.36"}},"Make the night before"]
[null,"Assorted vegetables",{"v":30,"d":"$30.00"},4,10,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":340},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.08823529411764706,"d":"$0.09"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.35294117647058826,"d":"$0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.8823529411764707,"d":"$0.88"}},"Carrot sticks, celery, broccoli, cauliflower, red and green peppers"]
[null,"Cheese ball",{"v":15,"d":"$15.00"},5,10,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.041666666666666664,"d":"$0.04"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.20833333333333331,"d":"$0.21"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.41666666666666663,"d":"$0.42"}},"Assorted: cream cheese, sharp cheese w/nuts"]
[null,"Crackers",{"v":25,"d":"$25.00"},5,10,{"$f":"(FoodTable[[#This Row],[SERVING PER CHILD]]*ChildrenTotal)+(FoodTable[[#This Row],[SERVING PER ADULT]]*AdultTotal)","v":360},{"$f":"IFERROR(FoodTable[[#This Row],[TOTAL COST]]/FoodTable[[#This Row],[TOTAL SERVINGS]],\"\")","v":{"v":0.06944444444444445,"d":"$0.07"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER CHILD]],\"\")","v":{"v":0.3472222222222222,"d":"$0.35"}},{"$f":"IFERROR(FoodTable[[#This Row],[COST PER SERVING]]*FoodTable[[#This Row],[SERVING PER ADULT]],\"\")","v":{"v":0.6944444444444444,"d":"$0.69"}},"Assorted"]
[null,"Total",{"$f":"SUBTOTAL(109,FoodTable[TOTAL COST])","v":{"v":475,"d":"$475.00"}},{"$f":"SUBTOTAL(109,FoodTable[SERVING PER CHILD])","v":34.5},{"$f":"SUBTOTAL(109,FoodTable[SERVING PER ADULT])","v":65.5},{"$f":"SUBTOTAL(109,FoodTable[TOTAL SERVINGS])","v":2393},{"$f":"SUBTOTAL(109,FoodTable[COST PER SERVING])","v":{"v":6.915706603622084,"d":"$6.92"}},{"$f":"SUBTOTAL(109,FoodTable[COST PER CHILD])","v":{"v":7.252884190656953,"d":"$7.25"}},{"$f":"SUBTOTAL(109,FoodTable[COST PER ADULT])","v":{"v":12.690089084110037,"d":"$12.69"}}]

{"sheet":"Other Essentials","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[14,1,14,4],[22,1,22,4]]}
[]
[]
[null,"Other Essentials"]
[]
[]
[null,"Equipment & Supplies","Cost","Purchased","Notes"]
[null,"Room/hall rental",{"v":250,"d":"$250.00"},"Yes"]
[null,"Linens",{"v":30,"d":"$30.00"},"Yes","Rent"]
[null,"Tables and chairs",{"v":0,"d":"$0.00"},null,"Included in hall rental"]
[null,"Beverage napkins",{"v":25,"d":"$25.00"}]
[null,"Dinner napkins",{"v":20,"d":"$20.00"},null,"Rent"]
[null,"Table service",{"v":50,"d":"$50.00"},null,"Rent"]
[null,"Glassware",{"v":25,"d":"$25.00"},null,"Rent"]
[null,"Total",{"$f":"SUBTOTAL(109,Table1Budget[Cost])","v":{"v":400,"d":"$400.00"}}]
[]
[]
[null,"Decorations","Cost","Purchased","Notes"]
[null,"Balloons",{"v":25,"d":"$25.00"}]
[null,"Helium tank",{"v":50,"d":"$50.00"},null,"Rent"]
[null,"Centerpieces",{"v":100,"d":"$100.00"},"Yes","10 total"]
[null,"Glass vases",{"v":0,"d":"$0.00"},null,"Borrowing from Sandy"]
[null,"Total",{"$f":"SUBTOTAL(109,Table2Budget[Cost])","v":{"v":175,"d":"$175.00"}}]
[]
[]
[null,"Other","Cost","Purchased","Notes"]
[null,"Invitations",{"v":50,"d":"$50.00"},"Yes"]
[null,"Postage",{"v":60,"d":"$60.00"},"Yes"]
[null,"Photographer",{"v":125,"d":"$125.00"},null,"2 hours (2 pm - 4 pm)"]
[null,"Party favors",{"v":50,"d":"$50.00"}]
[null,"Total",{"$f":"SUBTOTAL(109,Table3Budget[Cost])","v":{"v":285,"d":"$285.00"}}]

{"sheet":"Seating Arrangement Grid","index":4,"n_rows":43,"n_cols":34,"rows_kept":43,"merged":[[35,0,35,17],[35,19,35,33]]}
["Seating Arrangement"]
{"$rows_empty":33}
[{"$nulls":33},"*1 square= approximately 1 square foot"]
["Notes",{"$nulls":18},{"$f":"\" Total confirmed guests: \"&ConfirmedGuests","v":" Total confirmed guests: 46"}]
[{"$nulls":19},"You can use any of the following table setups:"]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)&\" round 54-inch tables (seats 6)\"","v":"8 round 54-inch tables (seats 6)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0) &\" round 60-inch tables (seats 8)\"","v":"6 round 60-inch tables (seats 8)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/10,0)&\" round 72-inch tables (seats 10)\"","v":"5 round 72-inch tables (seats 10)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/6,0)& \" square 30-inch x 72-inch tables (seats 6)\"","v":"8 square 30-inch x 72-inch tables (seats 6)"}]
[{"$nulls":20},{"$f":"ROUNDUP(ConfirmedGuests/8,0)&\" square 30-inch x 96-inch tables (seats 8)\"","v":"6 square 30-inch x 96-inch tables (seats 8)"}]
[{"$nulls":19},"(Preferred space between tables: 42 inches)"]