{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dashboard B","Dashboard A","Catering Request Form","Sheet7","Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Dashboard B","index":0,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Product","Excl VAT","Incl VAT"]
[]
[null,null,"Tea or Coffee BV1",1,1.2]
[null,null,"UW Still and Sparkling Water – 1 Ltr bottle (BV3)",1.25,1.32]
[null,null,"Fairtrade Orange Juice – per Jug  (BV4a)",2.5,2.64]
[null,null,"Apple Juice – per Jug (BV4b)",2.5,2.64]
[null,null,"Cranberry Juice – per Jug (BV4c)",2.5,2.64]
[null,null,"Classic Biscuits (x 2) BV5a",0.45,0.48]
[null,null,"Luxury Biscuits (x2) BV5b",0.65,0.78]
[null,null,"Indulgent Cookies (x2) BV5c",0.9,1.08]
[null,null,"Mini Danish Pastry (BV2)",1,1.2]
[null,null,"Mini Muffins – Blueberry or Chocolate (BV8)",0.75,0.78]
[null,null,"Mini Tray Bake Selection (BV7)",1.05,1.26]
[null,null,"Fresh Fruit Platter (BF1)",0.85,1.02]
[null,null,"Fresh Fruit Whole (BF2)",0.55000000000000004,0.66]
[null,null,"Yogurts BF4",1,1.2]
[]
[null,null,"The Spread (SL1)",3.3,3.96]
[null,null,"The Big Spread (SL2)",3.95,4.74]
[null,null,"The Works (SL3)",4.4000000000000004,5.28]
[null,null,"Back to Basics (WL1)",8.25,9.9]
[null,null,"World Flavours (WL2)",8.8000000000000007,10.56]
[null,null,"Lighter Options (WL3)",10.45,12.54]
[null,null,"Premium Working Lunch (WL4)",13.3,15.96]
[null,null,"Grilled Chicken Caesar Salad Bowl (SS1)",8.25,9.9]
[null,null,"Roasted Salmon Nicoise Salad Bowl (SS2)",8.25,9.9]
[null,null,"Roasted Mediterranean Vegetable & Goats Cheese Salad Bowl (SS3)",8.25,9.9]
[]
[]
[]
[null,null,"St John's"]
[null,null,"City Campus"]
[null,null,"Riverside"]
[null,null,"Arena"]

{"sheet":"Dashboard A","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"Product","Price","Quantity","Total Excluding VAT "]
[null,"Lighter Options (WL3)",{"$f":"IF(B5=\"\",\"\",VLOOKUP(B5,ProductLookUp,2,FALSE))","v":10.45},null,{"$f":"IF(C5=\"\",\"\",C5*D5)","v":0}]
[null,"World Flavours (WL2)",8.8000000000000007,null,0]
[null,"The Big Spread (SL2)",3.95,null,0]
[null,"The Works (SL3)",4.4000000000000004,null,0]
[null,null,"",null,""]
[null,null,"",null,""]
[null,null,"",null,""]
[null,null,""]
[null,null,""]
[null,null,null,"Total "]
[null,null,{"$f":"IF(B15=\"\",\"\",VLOOKUP(B15,ProductLookUp,2,FALSE))","v":""}]
[]
[null,null,null,null,"Dairy Free"]
[null,null,"UE.AAA",null,"Gluten Free "]
[null,null,"UE.ACC",null,"Halal"]
[null,null,"UE.CCS",null,"Kosher "]
[null,null,"UE.CNF",null,"Vegetarian "]
[null,null,"UE.PPP ",null,"Other (please specify below)"]
[null,null,"UE.WAR"]

{"sheet":"Catering Request Form","index":2,"n_rows":92,"n_cols":12,"rows_kept":92,"cut":false,"hidden":false,"merged":[[28,1,28,4],[21,3,21,4],[22,3,22,4],[25,3,25,4],[21,6,21,7],[22,6,22,7],[23,3,23,4],[25,6,25,7],[24,3,24,4],[23,6,23,7],[24,6,24,7],[17,10,17,11],[1,0,2,11],[13,10,13,11],[27,6,27,7],[28,6,28,7],[11,4,13,4],[27,3,27,4],[26,6,26,7],[26,3,26,4],[18,6,18,7],[20,6,20,7],[11,5,13,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[8,5,8,6],[3,1,3,2],[3,4,3,6],[3,9,3,11],[14,9,15,9],[14,10,15,11],[15,1,15,7],[11,1,12,1],[11,2,12,2],[10,5,10,6],[0,1,0,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[9,1,9,2],[9,4,9,11],[24,9,24,11],[20,9,20,11],[22,10,22,11],[18,10,18,11],[17,3,17,4],[17,6,17,7],[18,3,18,4],[20,3,20,4],[19,3,19,4],[19,6,19,7]]}
[null,"Please save a copy of this order form before making any changes to it. "]
["CATERING SERVICE REQUEST FORM"]
[]
[null,"1. Order Details",null,null,"2. Requester Details",null,null,null,null,"3. Requestee Details "]
[]
[null,"Date of Order:",null,null,"Requested By:",null,null,null,null,"Requested For:"]
[null,"Date of Function:",null,null,"Telephone:",null,null,null,null,"KX Ref (if applicable): "]
[null,null,null,null,"Email Address:"]
[]
[null,"4. Location Details ",null,null,"5. Booking Details "]
[null,null,null,null,null,null,null,null,null,null,null,"Quantity"]
[null,"Campus/ Location: ",null,null,"Special Delivery Requirements:",null,null,null,null,"Dietary Requirements: "]
[null,null,null,null,null,null,null,null,null,"Dietary Requirements: "]
[null,"Building/Room Code:",null,null,null,null,null,null,null,"Other:"]
[null,null,null,null,null,null,null,null,null,"Additional Information: "]
[null,"CATERING BOOKING DETAILS (click for instructions)"]
[null,"Times Required","Product","Price",null,"Quantity","Total Excl VAT "]
[null,null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Options_Pricing,2,FALSE))","v":""},null,null,{"$f":"IF(D18=\"\",\"\",D18*F18)","v":""},null,null,"Collection Time"]
[null,null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Options_Pricing,2,FALSE))","v":""},null,null,{"$f":"IF(D19=\"\",\"\",D19*F19)","v":""},null,null,"Number of Delegates:"]
[null,null,null,"",null,null,{"$f":"IF(D20=\"\",\"\",D20*F20)","v":""}]
[null,null,null,"",null,null,{"$f":"IF(D21=\"\",\"\",D21*F21)","v":""},null,null,"6. Finance "]
[null,null,null,"",null,null,{"$f":"IF(D22=\"\",\"\",D22*F22)","v":""}]
[null,null,null,"",null,null,"",null,null,"Cost Centre + Account Code:"]
[null,null,null,"",null,null,{"$f":"IF(D24=\"\",\"\",D24*F24)","v":""}]
[null,null,null,"",null,null,{"$f":"IF(D25=\"\",\"\",D25*F25)","v":""},null,null,"7. Authorisation"]
[null,null,null,"",null,null,{"$f":"IF(D26=\"\",\"\",D26*F26)","v":""}]
[null,null,null,"",null,null,{"$f":"IF(D27=\"\",\"\",D27*F27)","v":""},null,null,"ARO Reference Number:"]
[null,null,null,"",null,null,"",null,null,"Requester:"]
[null,"Please email completed form to catering@worc.ac.uk",null,null,null,"Total            (Excl VAT)",{"$f":"SUM(G18:H28)","v":0},null,null,"Aramark: "]
[null,0.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Tea or Coffee",1.1000000000000001]
[null,null,"UW Still and Sparkling Water – 1 Ltr bottle",1.25]
[null,null,"Fairtrade Orange Juice – per Jug (serves 6)",2.5]
[null,null,"Apple Juice – per Jug (serves 6)",2.5]
[null,null,"Cranberry Juice – per Jug (serves 6)",2.5]
[null,null,"Classic Biscuits (x 2)",0.45]
[null,null,"Luxury Biscuits (x2)",0.75]
[null,null,"Indulgent Cookies (x2)",1]
[null,null,"Mini Danish Pastry",1.2]
[null,null,"Mini Muffins – Blueberry or Chocolate",0.75]
[null,null,"Mini Tray Bake Selection",1.25]
[null,null,"Fresh Fruit Platter ",0.95]
[null,null,"Fresh Fruit Whole",0.6]
[null,null,"Yogurts",1.1000000000000001]
[null,null,"The Spread",3.8]
[null,null,"The Big Spread",4.25]
[null,null,"The Works",4.8]
[null,null,"Back to Basics",9]
[null,null,"World Flavours",9.5]
[null,null,"Lighter Options",11.5]
[null,null,"Premium Working Lunch",14.25]

{"sheet":"Sheet7","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":4,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Flask of Filter Coffee (serves approx. 4)",4]
[null,"Flask of Tea (serves approx. 4)",4]
[null,"Fair Trade Orange Juice  1 Ltr (serves approx. 7)",2.5]
[null,"Bottled Water 1 Ltr (serves approx. 7)",1]
[null,"Fruit Scone filled with Strawberry Jam, Freshly Whipped Cream and Strawberries (serves 4)                               ",10]
[null,"Fruit Scone filled with Strawberry Jam, Freshly Whipped Cream and Strawberries (additional per person serving)                                 ",2.5]
[null,"Selection of Cakes, including Mini Muffins Mini Chocolate Brownies & Mini Flapjacks (serves 4)                ",4.5999999999999996]
[null,"Selection of Cakes, including Mini Muffins Mini Chocolate Brownies & Mini Flapjacks (additional per person serving)              ",1.1499999999999999]
[null,"Freshly Baked Cookies",2.8]
[null,"Freshly Baked Cookies (additional per person serving)",0.7]
[null,"Mini Pack Traditional Biscuits (serves 4)                                                                          ",1.6]
[null,"Mini Pack Traditional Biscuits (additional per person serving)                                                                         ",0.4]
[null,"Luxury Biscuit Selection (2 each, price per person)                                  ",2.4]
[null,"Luxury Biscuit Selection (additional per person serving)                               ",0.6]
[null,"Fresh Fruit Platter (serves 4)",6.4]
[null,"Fresh Fruit Platter (additional per person serving)",1.6]
[null,"Yoghurt Pots topped with Granola (serves 4)",6.4]
[null,"Yoghurt Pots topped with Granola (additional per person serving)",1.6]
[null,"Warm Bacon Bap (serves 4)",7.2]
[null,"Warm Bacon Bap (additional per person serving)",1.8]
[null,"Warm Sausage Bap (serves 4)",7.2]
[null,"Warm Sausage Bap (additional per person serving)",1.8]
[null,"Continental Pastries (serves 4)",4.8]
[null,"Continental Pastries (additional per person serving)",1.2]
[null,"Packed Lunches to Go",4.8499999999999996,null," "]
[null,"Soup & Sandwich (serves 4)",15]
[null,"Soup & Sandwich (additional per person serving) ",3.75]
[null,"Sandwich Lunch (serves 4)",16]
[null,"Sandwich Lunch (additional per person serving)",4]
[null,"Working Finger Buffet (serves 4)",24]
[null,"Working Finger Buffet (additional per person serving)",6]
[null,"Cold Fork Buffet (serves 4)",56]
[null,"Cold Fork Buffet (additional per person serving)",14]
[null,"Pizza & Side Lunch (serves 4)",18]
[null,"Pizza & Side Lunch (additional per person serving)",4.5]
[null,"Assorted freshly cut Platter of Sandwiches, Wraps & Mini Rolls (serves 4)                                  ",13.6]
[null,"Assorted freshly cut Platter of Sandwiches, Wraps & Mini Rolls (additional per person serving)                             ",3.4]
[null,"Chefs’ selection Cheeseboard (serves 4)                                                                        ",18]
[null,"Chefs’ selection Cheeseboard (additional per person serving)                                                                    ",4.5]
[null,"Local Cheeseboard for minimum 4 delegates                                            ",26]
[null,"Local Cheeseboard (additional per person serving)                                      ",6.5]
[null,"Fruit Platter (serves 4)                                                                                                                         ",6.4]
[null,"Fruit Platter (additional per person serving)                                                                                                                       ",1.6]
[null,"Bowl of Olives (serves 4)                                                                                          ",4.8]
[null,"Bowl of Olives (additional per person serving)                                                                                        ",1.2]
[null,"Selection of Crudités & Dips  (serves 4)                                                            ",4.8]
[null,"Selection of Crudités & Dips  (additional per person serving)                                                         ",1.2]
[null,"Tortilla Chips with Salsa (per person serving)",1.2]
[null,"Chicken Skewers (2 each, price per person )",1.2]
[null,"Baked Mini Sausage Rolls (per person serving)",1.2]
[null,"Mini Vegetable Spring Rolls (2 each, price per person)",1.2]
[null,"Tyrrells Crisps (per person serving)",1]
[null,"Mini Samosa (2 each, price per person)",1.2]
[null,"Bread Roll & Butter ",0.6]
[null,"Chicken Caesar with Home Baked Croutons (serves 4)",30]
[null,"Chicken Caesar with Home Baked Croutons (additional per persons serving)",7.5]
[null,"Freshly Seared Tuna Niçoise (serves 4)",30]
[null,"Freshly Seared Tuna Niçoise (additional per person serving)",7.5]
[null,"Chargrilled Vegetables with Feta and Cumin Couscous (serves 4)",30]
[null,"Chargrilled Vegetables with Feta and Cumin Couscous (additional per person serving)",7.5]
[null,"Roasted Butternut Squash with Crumbled Goats Cheese and Toasted Sunflower Seeds (serves 4)",30]
[null,"Roasted Butternut Squash with Crumbled Goats Cheese and Toasted Sunflower Seeds (additional per person serving)",7.5]
[null,"Pan Fried Salmon with Pesto and Dressed Rocket Leaves (serves 4)",30]
[null,"Pan Fried Salmon with Pesto and Dressed Rocket Leaves (additional per person serving)",7.5]
[null,"Shredded Rare Beef and Roasted Artichokes with Dressed Watercress Leaves, Horseradish Cream (serves 4)",30]
[null,"Shredded Rare Beef and Roasted Artichokes with Dressed Watercress Leaves, Horseradish Cream (additional per person serving)",7.5]
[null,"Parma Ham, Poached English Pears and Shaved Aged Parmesan Cheese with Dressed Leaves and Balsamic Vinaigrette (serves 4)",30]
[null,"Parma Ham, Poached English Pears and Shaved Aged Parmesan Cheese with Dressed Leaves and Balsamic Vinaigrette (additional per person serving)",7.5]
[null,"Scottish Smoked Salmon with Pickled Cucumber and  Samphire with Burnt Lemon Dressing topped with Caper Popcorn (serves 4)",30]
[null,"Scottish Smoked Salmon with Pickled Cucumber and  Samphire with Burnt Lemon Dressing topped with Caper Popcorn (additional per person serving)",7.5]