{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Home","Current Prices","Current Menu","Week 1","Week 2","Week 3","Week 4","Week 5","Week 6","Week 7","Week 8","Week 9","Reports","Data","ReportData","Instructions","Ideas"],"not_rendered":{"charts":1,"images":220,"macros":1,"external_links":0,"defined_names":5,"comments":0,"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":"Home","index":0,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,7,4,13],[6,7,6,13]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Welcome to the Pendulum Court!"]
[]
[null,null,null,null,null,null,null,"Use the Navigation Menu to the left to begin entering data"]

{"sheet":"Current Prices","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,"Menu","Price"]
[null,null,null,null,null,"Feature",5.35,null,"Other Fixed Data"]
[null,null,null,null,null,"Soup",2.5,null,"# of Seats in Dining Room",80]
[null,null,null,null,null,"Cold Plate",5,null,"Equivalent Meal Factor",{"$f":"SUM(G6,G22,G10)","v":8.4499999999999993}]
[null,null,null,null,null,"Taco Salad",4.5]
[null,null,null,null,null,"Dessert",2.5]
[null,null,null,null,null,"Muffin",1.25]
[null,null,null,null,null,"Cookie",0.75]
[]
[null,null,null,null,null,"A La Carte","Price"]
[null,null,null,null,null,"Entrée",3]
[null,null,null,null,null,"Vegetable",1]
[null,null,null,null,null,"Starch",1.35]
[]
[null,null,null,null,null,"Misc Items","Price"]
[null,null,null,null,null,"Fruit",0.6]
[null,null,null,null,null,"Roll",0.6]
[null,null,null,null,null,"Soda",0.6]
[null,null,null,null,null,"Chocolate Milk",1]
[null,null,null,null,null,"2% Milk",1]
[null,null,null,null,null,"Skim Milk",1]
[null,null,null,null,null,"V-8 Splash",1.5]

{"sheet":"Current Menu","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,4,2,8],[2,10,2,14],[27,4,27,11]]}
[]
[]
[null,null,null,null,"Pendulum Court Menu",null,null,null,null,null,"Backwards Menu for Weeks 4-6"]
[null,null,null,null,null,"Monday","Tuesday","Wednesday","Thursday",null,null,"Monday","Tuesday","Wednesday","Thursday"]
[null,null,null,null,null,1,2,3,4,null,null,1,2,3,4]
[null,null,null,null,"Feature","Chicken Puff Pastry","Beef & Broccoli Stir Fry","Macadamia Chicken","Mediterranean Chicken Pasta",null,"Feature",{"$f":"I6","v":"Mediterranean Chicken Pasta"},{"$f":"H6","v":"Macadamia Chicken"},{"$f":"G6","v":"Beef & Broccoli Stir Fry"},{"$f":"F6","v":"Chicken Puff Pastry"}]
[null,null,null,null,"Soup","Taco Soup","Chicken Pot Pie","Lasagna Soup","Broccoli Cheese Soup",null,"Soup","Broccoli Cheese Soup","Lasagna Soup","Chicken Pot Pie","Taco Soup"]
[null,null,null,null,"Cold Plate","Vermont Turkey Club w/Spinach","Chicken & Berry Sensation","Kansas City BBQ Pork Sandwhich","BBQ Chicken Salad",null,"Cold Plate","BBQ Chicken Salad","Kansas City BBQ Pork Sandwhich","Chicken & Berry Sensation","Vermont Turkey Club w/Spinach"]
[null,null,null,null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad",null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad"]
[null,null,null,null,"Dessert","Decadent Fudge Cake (÷ 12)","Rasberry Buttermilk Pie Tart","Pumpkin Streusel Pie (÷ 8)","Fruit Pizza",null,"Dessert","Fruit Pizza","Pumpkin Streusel Pie (÷ 8)","Rasberry Buttermilk Pie Tart","Decadent Fudge Cake (÷ 12)"]
[null,null,null,null,"Bread","Cherry Chocolate Scone","Carrot Muffin","Lemon Poppy Seed Muffin","Cranberry Orange Scone (÷ 10)",null,"Bread","Cranberry Orange Scone (÷ 10)","Lemon Poppy Seed Muffin","Carrot Muffin","Cherry Chocolate Scone"]
[null,null,null,null,"Cookie","Oatmeal Golden Raisin Cookie","Peanut Butter Chocolate Chip Cookie","Chewy Dbl Chocolate Mint Cookie","Macaroon",null,"Cookie","Macaroon","Chewy Dbl Chocolate Mint Cookie","Peanut Butter Chocolate Chip Cookie","Oatmeal Golden Raisin Cookie"]
[null,null,null,null,"Feature","Russian Beef Stroganoff","Moroccan Chicken","Chicken & Spinach Calzone","Cheddar Herb Cod",null,"Feature","Cheddar Herb Cod","Chicken & Spinach Calzone","Moroccan Chicken","Russian Beef Stroganoff"]
[null,null,null,null,"Soup","Vegetable Chili","Hearty Wild Mushroom Soup","Loaded Baked Potato Soup","Chicken Enchilada Soup",null,"Soup","Chicken Enchilada Soup","Loaded Baked Potato Soup","Hearty Wild Mushroom Soup","Vegetable Chili"]
[null,null,null,null,"Cold Plate","Cajun Chicken Caesar Salad","Turkey Bacon Ranch Sandwhich","Gourmet Gouda & Beef Sandwhich","Oriental Chicken & Mandarin Salad",null,"Cold Plate","Oriental Chicken & Mandarin Salad","Gourmet Gouda & Beef Sandwhich","Turkey Bacon Ranch Sandwhich","Cajun Chicken Caesar Salad"]
[null,null,null,null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad",null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad"]
[null,null,null,null,"Dessert","Lemon Crepe with Rasberry Sauce","Chocolate Rasberry Crème Torte (÷ 10)","Chocolaty Peanut Butter Pie (÷ 6)","Strawberry Shortcake (÷ 10)",null,"Dessert","Strawberry Shortcake (÷ 10)","Chocolaty Peanut Butter Pie (÷ 6)","Chocolate Rasberry Crème Torte (÷ 10)","Lemon Crepe with Rasberry Sauce"]
[null,null,null,null,"Bread","Home Style Cornbread Muffin","Cheddar Chive Scone (÷ 10)","Apple Muffin","Golden Raisin Scone (÷ 10)",null,"Bread","Golden Raisin Scone (÷ 10)","Apple Muffin","Cheddar Chive Scone (÷ 10)","Home Style Cornbread Muffin"]
[null,null,null,null,"Cookie","Peanut Butter Choc Chip Cookie","Chocolate Chip Cookie","Toffee Oatmeal Cookie","Chocolate Chip Cookie",null,"Cookie","Chocolate Chip Cookie","Toffee Oatmeal Cookie","Chocolate Chip Cookie","Peanut Butter Choc Chip Cookie"]
[null,null,null,null,"Feature","Monterey Chicken","Baked Ziti","Stuffed Bean Burrito","Herb Crusted Chicken Breast",null,"Feature","Herb Crusted Chicken Breast","Stuffed Bean Burrito","Baked Ziti","Monterey Chicken"]
[null,null,null,null,"Soup","Black Bean Soup","Chicken Cilantro Bisque","Zuppa Tuscana Soup","Tomato Florentine Soup",null,"Soup","Tomato Florentine Soup","Zuppa Tuscana Soup","Chicken Cilantro Bisque","Black Bean Soup"]
[null,null,null,null,"Cold Plate","Asian Lettuce Un-Wrapped Salad","Grilled Cheese Sandwhich w/Tomato Soup","Turkey & Swiss Crescent Sandwhich","Tuscan Tuna Sandwhich",null,"Cold Plate","Tuscan Tuna Sandwhich","Turkey & Swiss Crescent Sandwhich","Grilled Cheese Sandwhich w/Tomato Soup","Asian Lettuce Un-Wrapped Salad"]
[null,null,null,null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad",null,"Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad","Beef Taco Salad"]
[null,null,null,null,"Dessert","Cheesecake Assortment","Triple Chocolate Turnover","Malted Chocolate Mousse Pie (÷ 6)","Old Fashioned Peach Pie (÷ 8)",null,"Dessert","Old Fashioned Peach Pie (÷ 8)","Malted Chocolate Mousse Pie (÷ 6)","Triple Chocolate Turnover","Cheesecake Assortment"]
[null,null,null,null,"Bread","Pumpkin Chocolate Chip Muffin","Chocolate Chip Sour Cream Muffin","Almond Poppy Seed Scone","Chocolate Avalanche Muffin",null,"Bread","Chocolate Avalanche Muffin","Almond Poppy Seed Scone","Chocolate Chip Sour Cream Muffin","Pumpkin Chocolate Chip Muffin"]
[null,null,null,null,"Cookie","Peanut Butter Chocolate Chip Cookie","Toffee Oatmeal Cookie","Chewy Double Chocolate Mint Cookie","Oatmeal Golden Raisin Cookie",null,"Cookie","Oatmeal Golden Raisin Cookie","Chewy Double Chocolate Mint Cookie","Toffee Oatmeal Cookie","Peanut Butter Chocolate Chip Cookie"]
[]
[null,null,null,null,"Week Lookup Table"]
[null,null,null,null,"Week","Feature","Soup","Cold Plate","Taco Salad","Dessert","Bread","Cookie"]
[null,null,null,null,1,2,3,4,5,6,7,8]
[null,null,null,null,2,9,10,11,12,13,14,15]
[null,null,null,null,3,16,17,18,19,20,21,22]
[null,null,null,null,4,2,3,4,5,6,7,8]
[null,null,null,null,5,9,10,11,12,13,14,15]
[null,null,null,null,6,16,17,18,19,20,21,22]
[null,null,null,null,7,2,3,4,5,6,7,8]
[null,null,null,null,8,9,10,11,12,13,14,15]
[null,null,null,null,9,16,17,18,19,20,21,22]

{"sheet":"Week 1","index":3,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,28,6,28],[17,23,20,23],[1,24,2,25],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken Puff Pastry"},0,44,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Beef & Broccoli Stir Fry"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Macadamia Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Mediterranean Chicken Pasta"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Taco Soup",0,33,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Pot Pie",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Lasagna Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Broccoli Cheese Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Vermont Turkey Club w/Spinach",0,25,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Chicken & Berry Sensation",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Kansas City BBQ Pork Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"BBQ Chicken Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",0,47,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Decadent Fudge Cake (÷ 12)",0,43,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Rasberry Buttermilk Pie Tart",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Pumpkin Streusel Pie (÷ 8)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Fruit Pizza",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",1,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cherry Chocolate Scone",0,65,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Carrot Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Lemon Poppy Seed Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cranberry Orange Scone (÷ 10)",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",0,44,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Dbl Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Macaroon",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 301 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":44},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":235.39999999999998},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":25},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":125},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":47},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":211.5},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":33},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":82.5},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":43},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":107.5},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":65},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":81.25},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":44},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":33},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},12,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":36},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},6,{"$f":"'Current Prices'!$G$16","v":1},6,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},8,{"$f":"'Current Prices'!$G$17","v":1.35},10.8,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},26,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":15.6},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},22,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":13.2},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},15,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":9},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},18,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":18},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},26,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":26},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},13,{"$f":"'Current Prices'!$G$25","v":1},13,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},8,{"$f":"'Current Prices'!$G$26","v":1.5},12,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",0,"Misc. Income:",0,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",1035.75,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",35,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":1000.75},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",114,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 455 items sold with total sales of $1035.75",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":1035.75},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":455},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":118.4319526627219},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":8.7785087719298254},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":1.425},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":10.0075},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":1000.75},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":1.1843195266272191},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":118.43195266272191},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":1.1399999999999999},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":1.4249999999999998},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 2","index":4,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Russian Beef Stroganoff"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Moroccan Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken & Spinach Calzone"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Cheddar Herb Cod"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Vegetable Chili",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Hearty Wild Mushroom Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Loaded Baked Potato Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Enchilada Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Cajun Chicken Caesar Salad",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey Bacon Ranch Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Gourmet Gouda & Beef Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Oriental Chicken & Mandarin Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Lemon Crepe with Rasberry Sauce",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolate Rasberry Crème Torte (÷ 10)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolaty Peanut Butter Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Strawberry Shortcake (÷ 10)",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",2,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Home Style Cornbread Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cheddar Chive Scone (÷ 10)",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Apple Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Golden Raisin Scone (÷ 10)",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Choc Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 3","index":5,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Monterey Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Baked Ziti"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Stuffed Bean Burrito"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Herb Crusted Chicken Breast"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Black Bean Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Cilantro Bisque",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Zuppa Tuscana Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Tomato Florentine Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Asian Lettuce Un-Wrapped Salad",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Grilled Cheese Sandwhich w/Tomato Soup",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey & Swiss Crescent Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Tuscan Tuna Sandwhich",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Cheesecake Assortment",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Triple Chocolate Turnover",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Malted Chocolate Mousse Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Old Fashioned Peach Pie (÷ 8)",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",3,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Pumpkin Chocolate Chip Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Chip Sour Cream Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Almond Poppy Seed Scone",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Avalanche Muffin",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Double Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 4","index":6,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Mediterranean Chicken Pasta"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Macadamia Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Beef & Broccoli Stir Fry"},35,24,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken Puff Pastry"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Broccoli Cheese Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Lasagna Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Pot Pie",25,12,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Taco Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"BBQ Chicken Salad",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Kansas City BBQ Pork Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Chicken & Berry Sensation",45,34,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Vermont Turkey Club w/Spinach",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",35,34,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Fruit Pizza",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Pumpkin Streusel Pie (÷ 8)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Rasberry Buttermilk Pie Tart",76,55,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Decadent Fudge Cake (÷ 12)",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",4,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cranberry Orange Scone (÷ 10)",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Lemon Poppy Seed Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Carrot Muffin",45,44,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cherry Chocolate Scone",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Macaroon",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Dbl Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",65,54,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":24},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":128.39999999999998},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":34},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":170},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":34},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":153},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":12},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":30},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":55},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":137.5},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":44},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":55},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":54},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":40.5},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},3,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":9},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},4,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":4},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},5,{"$f":"'Current Prices'!$G$17","v":1.35},6.75,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},18,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":10.799999999999999},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},17,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":10.199999999999999},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},12,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":7.1999999999999993},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},5,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":5},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},5,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":5},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},2,{"$f":"'Current Prices'!$G$25","v":1},2,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},0,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",0,"Misc. Income:",0,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",567,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":"DISCREPANCY"},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",56,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":511},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",45,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":774.35},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":328},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":60.473372781065095},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":11.355555555555556},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0.5625},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":5.1100000000000003},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":511.00000000000006},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0.60473372781065093},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":60.473372781065095},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0.45},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0.5625},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 5","index":7,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Cheddar Herb Cod"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken & Spinach Calzone"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Moroccan Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Russian Beef Stroganoff"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Enchilada Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Loaded Baked Potato Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Hearty Wild Mushroom Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Vegetable Chili",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Oriental Chicken & Mandarin Salad",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Gourmet Gouda & Beef Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey Bacon Ranch Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Cajun Chicken Caesar Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Strawberry Shortcake (÷ 10)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolaty Peanut Butter Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolate Rasberry Crème Torte (÷ 10)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Lemon Crepe with Rasberry Sauce",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",5,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Golden Raisin Scone (÷ 10)",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Apple Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cheddar Chive Scone (÷ 10)",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Home Style Cornbread Muffin",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Choc Chip Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 6","index":8,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Herb Crusted Chicken Breast"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Stuffed Bean Burrito"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Baked Ziti"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Monterey Chicken"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Tomato Florentine Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Zuppa Tuscana Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Cilantro Bisque",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Black Bean Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Tuscan Tuna Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey & Swiss Crescent Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Grilled Cheese Sandwhich w/Tomato Soup",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Asian Lettuce Un-Wrapped Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Old Fashioned Peach Pie (÷ 8)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Malted Chocolate Mousse Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Triple Chocolate Turnover",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Cheesecake Assortment",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",6,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Avalanche Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Almond Poppy Seed Scone",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Chip Sour Cream Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Pumpkin Chocolate Chip Muffin",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Double Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 7","index":9,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken Puff Pastry"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Beef & Broccoli Stir Fry"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Macadamia Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Mediterranean Chicken Pasta"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Taco Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Pot Pie",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Lasagna Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Broccoli Cheese Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Vermont Turkey Club w/Spinach",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Chicken & Berry Sensation",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Kansas City BBQ Pork Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"BBQ Chicken Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Decadent Fudge Cake (÷ 12)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Rasberry Buttermilk Pie Tart",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Pumpkin Streusel Pie (÷ 8)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Fruit Pizza",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",7,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cherry Chocolate Scone",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Carrot Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Lemon Poppy Seed Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cranberry Orange Scone (÷ 10)",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Dbl Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Macaroon",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 8","index":10,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Russian Beef Stroganoff"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Moroccan Chicken"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Chicken & Spinach Calzone"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Cheddar Herb Cod"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Vegetable Chili",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Hearty Wild Mushroom Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Loaded Baked Potato Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Enchilada Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Cajun Chicken Caesar Salad",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey Bacon Ranch Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Gourmet Gouda & Beef Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Oriental Chicken & Mandarin Salad",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Lemon Crepe with Rasberry Sauce",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolate Rasberry Crème Torte (÷ 10)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Chocolaty Peanut Butter Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Strawberry Shortcake (÷ 10)",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",8,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Home Style Cornbread Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Cheddar Chive Scone (÷ 10)",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Apple Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Golden Raisin Scone (÷ 10)",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Choc Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chocolate Chip Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},0,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":0},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 18 items sold with total sales of $33.5",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":0},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":0},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Week 9","index":11,"n_rows":70,"n_cols":25,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,24,2,25],[5,28,6,28],[17,23,20,23],[51,6,51,9],[51,10,51,13],[51,14,51,17],[51,18,51,21]]}
[null,null,null,null,null,"ü"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,null,null,null,"ü"]
[null,null,null,null,null,"ü",null,"Monday",null,null,null,"Tuesday",null,null,null,"Wednesday",null,null,null,"Thursday"]
[null,null,null,null,null,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4]
[null,null,null,null,null,"ü",null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production",null,null,null,"Daily Production"]
[null,null,null,null,null,null,"Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold","Type","Name of Menu Item","# Prod.","# Sold",null,"WeekLookup Reference"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(H$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(H$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Monterey Chicken"},25,15,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(L$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(L$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Baked Ziti"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(P$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(P$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Stuffed Bean Burrito"},null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(AND($E$13>=4,$E$13<=6),(HLOOKUP(T$5,ReverseMenu,VLOOKUP($E$13,WeekLookupTable,X8))),(HLOOKUP(T$5,CurrentMenu,VLOOKUP($E$13,WeekLookupTable,X8))))","v":"Herb Crusted Chicken Breast"},null,null,null,2]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Black Bean Soup",25,15,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Chicken Cilantro Bisque",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Zuppa Tuscana Soup",null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},"Tomato Florentine Soup",null,null,null,3]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Asian Lettuce Un-Wrapped Salad",25,15,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Grilled Cheese Sandwhich w/Tomato Soup",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Turkey & Swiss Crescent Sandwhich",null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},"Tuscan Tuna Sandwhich",null,null,null,4]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",25,15,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},"Beef Taco Salad",null,null,null,5]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Cheesecake Assortment",25,15,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Triple Chocolate Turnover",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Malted Chocolate Mousse Pie (÷ 6)",null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},"Old Fashioned Peach Pie (÷ 8)",null,null,null,6]
[null,null,null,"WEEK VLOOKUP =",9,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Pumpkin Chocolate Chip Muffin",25,15,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Chip Sour Cream Muffin",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Almond Poppy Seed Scone",null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},"Chocolate Avalanche Muffin",null,null,null,7]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Peanut Butter Chocolate Chip Cookie",25,15,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Toffee Oatmeal Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Chewy Double Chocolate Mint Cookie",null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},"Oatmeal Golden Raisin Cookie",null,null,null,8]
[null,null,null,null,null,null,null,"There were 175 basic items produced and 105 basic items sold",null,null,null,"There were 0 basic items produced and 0 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold",null,null,null,"There were 154 basic items produced and 122 basic items sold"]
[]
[null,null,null,null,null,null,null,"Cashier Sheet",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Daily Sales",null,null,null,"Instructions:"]
[null,null,null,null,null,null,"Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales","Type","# Sold","Price","Total Sales",null,"This is the reference used to find which week to lookup in the menu"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(J8>0,J8,\"\")","v":15},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(J8>0,(H19*I19),\"\")","v":80.25},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(N8>0,N8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(N8>0,(L19*M19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(R8>0,R8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(R8>0,(P19*Q19),\"\")","v":""},{"$f":"'Current Prices'!$F$6","v":"Feature"},{"$f":"IF(V8>0,V8,\"\")","v":""},{"$f":"'Current Prices'!$G$6","v":5.35},{"$f":"IF(V8>0,(T19*U19),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(J10>0,J10,\"\")","v":15},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(J10>0,(H20*I20),\"\")","v":75},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(N10>0,N10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(N10>0,(L20*M20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(R10>0,R10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(R10>0,(P20*Q20),\"\")","v":""},{"$f":"'Current Prices'!$F$8","v":"Cold Plate"},{"$f":"IF(V10>0,V10,\"\")","v":""},{"$f":"'Current Prices'!$G$8","v":5},{"$f":"IF(V10>0,(T20*U20),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(J11>0,J11,\"\")","v":15},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(J11>0,(H21*I21),\"\")","v":67.5},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(N11>0,N11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(N11>0,(L21*M21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(R11>0,R11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(R11>0,(P21*Q21),\"\")","v":""},{"$f":"'Current Prices'!$F$9","v":"Taco Salad"},{"$f":"IF(V11>0,V11,\"\")","v":""},{"$f":"'Current Prices'!$G$9","v":4.5},{"$f":"IF(V11>0,(T21*U21),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(J9>0,J9,\"\")","v":15},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(J9>0,(H22*I22),\"\")","v":37.5},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(N9>0,N9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(N9>0,(L22*M22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(R9>0,R9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(R9>0,(P22*Q22),\"\")","v":""},{"$f":"'Current Prices'!$F$7","v":"Soup"},{"$f":"IF(V9>0,V9,\"\")","v":""},{"$f":"'Current Prices'!$G$7","v":2.5},{"$f":"IF(V9>0,(T22*U22),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(J12>0,J12,\"\")","v":15},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(J12>0,(H23*I23),\"\")","v":37.5},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(N12>0,N12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(N12>0,(L23*M23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(R12>0,R12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(R12>0,(P23*Q23),\"\")","v":""},{"$f":"'Current Prices'!$F$10","v":"Dessert"},{"$f":"IF(V12>0,V12,\"\")","v":""},{"$f":"'Current Prices'!$G$10","v":2.5},{"$f":"IF(V12>0,(T23*U23),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(J13>0,J13,\"\")","v":15},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(J13>0,(H24*I24),\"\")","v":18.75},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(N13>0,N13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(N13>0,(L24*M24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(R13>0,R13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(R13>0,(P24*Q24),\"\")","v":""},{"$f":"'Current Prices'!$F$11","v":"Muffin"},{"$f":"IF(V13>0,V13,\"\")","v":""},{"$f":"'Current Prices'!$G$11","v":1.25},{"$f":"IF(V13>0,(T24*U24),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(J14>0,J14,\"\")","v":15},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(J14>0,(H25*I25),\"\")","v":11.25},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(N14>0,N14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(N14>0,(L25*M25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(R14>0,R14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(R14>0,(P25*Q25),\"\")","v":""},{"$f":"'Current Prices'!$F$12","v":"Cookie"},{"$f":"IF(V14>0,V14,\"\")","v":""},{"$f":"'Current Prices'!$G$12","v":0.75},{"$f":"IF(V14>0,(T25*U25),\"\")","v":""}]
[]
[null,null,null,null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:",null,null,null,"A La Carte:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$15","v":"Entrée"},12,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"H28*I28","v":36},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"L28*M28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"P28*Q28","v":0},{"$f":"'Current Prices'!$F$15","v":"Entrée"},null,{"$f":"'Current Prices'!$G$15","v":3},{"$f":"T28*U28","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},12,{"$f":"'Current Prices'!$G$16","v":1},12,{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"L29*M29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"P29*Q29","v":0},{"$f":"'Current Prices'!$F$16","v":"Vegetable"},null,{"$f":"'Current Prices'!$G$16","v":1},{"$f":"T29*U29","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$17","v":"Starch"},12,{"$f":"'Current Prices'!$G$17","v":1.35},16.200000000000003,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0,{"$f":"'Current Prices'!$F$17","v":"Starch"},null,{"$f":"'Current Prices'!$G$17","v":1.35},0]
[]
[null,null,null,null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:",null,null,null,"Misc. Items:"]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$20","v":"Fruit"},14,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"H33*I33","v":8.4},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"L33*M33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"P33*Q33","v":0},{"$f":"'Current Prices'!$F$20","v":"Fruit"},null,{"$f":"'Current Prices'!$G$20","v":0.6},{"$f":"T33*U33","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$21","v":"Roll"},14,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"H34*I34","v":8.4},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"L34*M34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"P34*Q34","v":0},{"$f":"'Current Prices'!$F$21","v":"Roll"},null,{"$f":"'Current Prices'!$G$21","v":0.6},{"$f":"T34*U34","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$22","v":"Soda"},14,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"H35*I35","v":8.4},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"L35*M35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"P35*Q35","v":0},{"$f":"'Current Prices'!$F$22","v":"Soda"},null,{"$f":"'Current Prices'!$G$22","v":0.6},{"$f":"T35*U35","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},14,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"H36*I36","v":14},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"L36*M36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"P36*Q36","v":0},{"$f":"'Current Prices'!$F$23","v":"Chocolate Milk"},null,{"$f":"'Current Prices'!$G$23","v":1},{"$f":"T36*U36","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$24","v":"2% Milk"},14,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"H37*I37","v":14},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"L37*M37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"P37*Q37","v":0},{"$f":"'Current Prices'!$F$24","v":"2% Milk"},null,{"$f":"'Current Prices'!$G$24","v":1},{"$f":"T37*U37","v":0}]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},14,{"$f":"'Current Prices'!$G$25","v":1},14,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0,{"$f":"'Current Prices'!$F$25","v":"Skim Milk"},null,{"$f":"'Current Prices'!$G$25","v":1},0]
[null,null,null,null,null,null,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},14,{"$f":"'Current Prices'!$G$26","v":1.5},21,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0,{"$f":"'Current Prices'!$F$26","v":"V-8 Splash"},null,{"$f":"'Current Prices'!$G$26","v":1.5},0]
[null,null,null,null,null,null,"Misc.",0,"Misc. Income:",0,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:",null,"Misc.",null,"Misc. Income:"]
[]
[null,null,null,null,null,null,null,"Subtotal of Net Income:",480.15,{"$f":"IF(ABS(I42-I53)>0,\"DISCREPANCY\",\"\")","v":"DISCREPANCY"},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(M42-M53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(Q42-Q53)>0,\"DISCREPANCY\",\"\")","v":""},null,"Subtotal of Net Income:",null,{"$f":"IF(ABS(U42-U53)>0,\"DISCREPANCY\",\"\")","v":""}]
[null,null,null,null,null,null,null,"Minus Discount Meals:",45,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:",null,null,null,"Minus Discount Meals:"]
[null,null,null,null,null,null,null,"Net Income:",{"$f":"I42-I43","v":435.15},null,null,"Net Income:",{"$f":"M42-M43","v":0},null,null,"Net Income:",{"$f":"Q42-Q43","v":0},null,null,"Net Income:",{"$f":"U42-U43","v":0}]
[]
[null,null,null,null,null,null,null,"Number of Guests:",50,null,null,"Number of Guests:",null,null,null,"Number of Guests:",null,null,null,"Number of Guests:"]
[null,null,null,null,null,null,null,"There were 239 items sold with total sales of $480.15",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2",null,null,null,"There were 215 items sold with total sales of $451.2"]
[]
[]
[]
[]
[null,null,null,null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS",null,null,null,"DATA HIDDEN - USED FOR REPORTS"]
[null,null,null,null,null,null,null,"Total Gross Sales:",{"$f":"SUM(J19:J40)","v":480.14999999999992},null,null,"Total Gross Sales:",{"$f":"SUM(N19:N40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(R19:R40)","v":0},null,null,"Total Gross Sales:",{"$f":"SUM(V19:V40)","v":0}]
[null,null,null,null,null,null,null,"Total Items Sold:",{"$f":"SUM(H19:H40)","v":239},null,null,"Total Sales Count:",{"$f":"SUM(L19:L40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(P19:P40)","v":0},null,null,"Total Sales Count:",{"$f":"SUM(T19:T40)","v":0}]
[]
[null,null,null,null,null,null,null,"Equivalent Meals Served",{"$f":"I44/EquivalentMealFactor","v":51.497041420118343},null,null,"Equivalent Meals Served",{"$f":"M44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"Q44/EquivalentMealFactor","v":0},null,null,"Equivalent Meals Served",{"$f":"U44/EquivalentMealFactor","v":0}]
[null,null,null,null,null,null,null,"Average Check:",{"$f":"I44/I46","v":8.7029999999999994},null,null,"Average Check:",{"$f":"M44/M46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"Q44/Q46","v":{"$error":"#DIV/0!"}},null,null,"Average Check:",{"$f":"U44/U46","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Seat Turnover:",{"$f":"I46/DiningRoomCapacity","v":0.625},null,null,"Seat Turnover:",{"$f":"M46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"Q46/DiningRoomCapacity","v":0},null,null,"Seat Turnover:",{"$f":"U46/DiningRoomCapacity","v":0}]
[]
[null,null,null,null,null,null,null,"Minutes Served:",100,null,null,"Minutes Served:",70,null,null,"Minutes Served:",100,null,null,"Minutes Served:",100]
[null,null,null,null,null,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100,null,null,"Normal Minutes:",100]
[]
[null,null,null,null,null,null,null,"Average Sales per Minute:",{"$f":"I44/I60","v":4.3514999999999997},null,null,"Average Sales per Minute:",{"$f":"M44/M60","v":0},null,null,"Average Sales per Minute:",{"$f":"Q44/Q60","v":0},null,null,"Average Sales per Minute:",{"$f":"U44/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Sales:",{"$f":"I63*I61","v":435.15},null,null,"Normalized Sales:",{"$f":"M63*M61","v":0},null,null,"Normalized Sales:",{"$f":"Q63*Q61","v":0},null,null,"Normalized Sales:",{"$f":"U63*U61","v":0}]
[]
[null,null,null,null,null,null,null,"Average Equivalent Meals per Minute:",{"$f":"I56/I60","v":0.51497041420118339},null,null,"Average Equivalent Meals per Minute:",{"$f":"M56/M60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"Q56/Q60","v":0},null,null,"Average Equivalent Meals per Minute:",{"$f":"U56/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Equivalent Meals:",{"$f":"I61*I66","v":51.497041420118336},null,null,"Normalized Equivalent Meals:",{"$f":"M61*M66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"Q61*Q66","v":0},null,null,"Normalized Equivalent Meals:",{"$f":"U61*U66","v":0}]
[]
[null,null,null,null,null,null,null,"Average Number of Checks per Minute:",{"$f":"I46/I60","v":0.5},null,null,"Average Number of Checks per Minute:",{"$f":"M46/M60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"Q46/Q60","v":0},null,null,"Average Number of Checks per Minute:",{"$f":"U46/U60","v":0}]
[null,null,null,null,null,null,null,"Normalized Seat Turnover:",{"$f":"(I69*I61)/DiningRoomCapacity","v":0.625},null,null,"Normalized Seat Turnover:",{"$f":"(M69*M61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(Q69*Q61)/DiningRoomCapacity","v":0},null,null,"Normalized Seat Turnover:",{"$f":"(U69*U61)/DiningRoomCapacity","v":0}]

{"sheet":"Reports","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":13,"n_rows":37,"n_cols":27,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Week","Day","FeatureSales","ColdPlateSales","TacoSaladSales","SoupSales","DessertSales","MuffinSales","CookieSales","ALaCarteSales","MiscItemSales","TotalSales","TotalDiscounts","TotalNetSales","FeatureSold","ColdPlateSold","TacoSaladSold","SoupSold","DessertSold","MuffinSold","CookieSold","ALaCarteSold","MiscItemSold","TotalItemsSold","EquivalentMeals","AverageCheck","NumberofGuests"]
[1,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,118.4319526627219,8.7799999999999994,114]
[1,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,680,35,450,44,25,47,33,43,65,44,26,128,455,119.431952662722,8.7799999999999994,114]
[1,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,120.431952662722,8.7799999999999994,114]
[1,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,121.431952662722,8.7799999999999994,114]
[2,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,122.431952662722,8.7799999999999994,114]
[2,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,900,35,780,44,25,47,33,43,65,44,26,128,455,123.431952662722,8.7799999999999994,114]
[2,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,124.431952662722,8.7799999999999994,114]
[2,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,125.431952662722,8.7799999999999994,114]
[3,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,126.431952662722,8.7799999999999994,114]
[3,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1200,35,900,44,25,47,33,43,65,44,26,128,455,127.431952662722,8.7799999999999994,114]
[3,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,128.43195266272201,8.7799999999999994,114]
[3,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,129.43195266272201,8.7799999999999994,114]
[4,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,130.43195266272201,8.7799999999999994,114]
[4,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,750,35,600,44,25,47,33,43,65,44,26,128,455,131.43195266272201,8.7799999999999994,114]
[4,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,132.43195266272201,8.7799999999999994,114]
[4,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,133.43195266272201,8.7799999999999994,114]
[5,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,134.43195266272201,8.7799999999999994,114]
[5,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1400,35,1200,44,25,47,33,43,65,44,26,128,455,135.43195266272201,8.7799999999999994,114]
[5,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,136.43195266272201,8.7799999999999994,114]
[5,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,137.43195266272201,8.7799999999999994,114]
[6,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,138.43195266272201,8.7799999999999994,114]
[6,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035,35,1000.75,44,25,47,33,43,65,44,26,128,455,139.43195266272201,8.7799999999999994,114]
[6,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,140.43195266272201,8.7799999999999994,114]
[6,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,141.43195266272201,8.7799999999999994,114]
[7,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,142.43195266272201,8.7799999999999994,114]
[7,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,900,35,550,44,25,47,33,43,65,44,26,128,455,143.43195266272201,8.7799999999999994,114]
[7,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,144.43195266272201,8.7799999999999994,114]
[7,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,145.43195266272201,8.7799999999999994,114]
[8,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,146.43195266272201,8.7799999999999994,114]
[8,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1900,35,850,44,25,47,33,43,65,44,26,128,455,147.43195266272201,8.7799999999999994,114]
[8,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,148.43195266272201,8.7799999999999994,114]
[8,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,149.43195266272201,8.7799999999999994,114]
[9,"Monday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,150.43195266272201,8.7799999999999994,114]
[9,"Tuesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1700,35,1400,44,25,47,33,43,65,44,26,128,455,151.43195266272201,8.7799999999999994,114]
[9,"Wednesday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,152.43195266272201,8.7799999999999994,114]
[9,"Thursday",235.4,125,211.5,82.5,107.5,81.25,33,52.8,106.8,1035.75,35,1000.75,44,25,47,33,43,65,44,26,128,455,153.43195266272201,8.7799999999999994,114]

{"sheet":"ReportData","index":14,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Week","Weekly Net Sales","Weekly Item Sales Count","Weekly Equivalent Meals Served","Sales Discounts","Weekly # of Guests","Weekly Gross Sales"]
["Week 1",{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$N$2:$N$37)","v":3452.25},{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$Y$2:$Y$37)","v":479.72781065088787},{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,1,Data!$L$2:$L$37)","v":3787.25}]
["Week 2",{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$N$2:$N$37)","v":3782.25},{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$Y$2:$Y$37)","v":495.72781065088799},{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,2,Data!$L$2:$L$37)","v":4007.25}]
["Week 3",{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$N$2:$N$37)","v":3902.25},{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$Y$2:$Y$37)","v":511.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,3,Data!$L$2:$L$37)","v":4307.25}]
["Week 4",{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$N$2:$N$37)","v":3602.25},{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$Y$2:$Y$37)","v":527.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,4,Data!$L$2:$L$37)","v":3857.25}]
["Week 5",{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$N$2:$N$37)","v":4202.25},{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$Y$2:$Y$37)","v":543.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,5,Data!$L$2:$L$37)","v":4507.25}]
["Week 6",{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$N$2:$N$37)","v":4003},{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$Y$2:$Y$37)","v":559.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,6,Data!$L$2:$L$37)","v":4142.25}]
["Week 7",{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$N$2:$N$37)","v":3552.25},{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$Y$2:$Y$37)","v":575.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,7,Data!$L$2:$L$37)","v":4007.25}]
["Week 8",{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$N$2:$N$37)","v":3852.25},{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$Y$2:$Y$37)","v":591.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,8,Data!$L$2:$L$37)","v":5007.25}]
["Week 9",{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$N$2:$N$37)","v":4402.25},{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$X$2:$X$37)","v":1820},{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$Y$2:$Y$37)","v":607.72781065088805},{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$M$2:$M$37)","v":140},{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$AA$2:$AA$37)","v":456},{"$f":"SUMIF(Data!$A$2:$A$37,9,Data!$L$2:$L$37)","v":4807.25}]

{"sheet":"Instructions","index":15,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"If you can't see everything. You can click the + or - button in the bottom right to zoom in or out.",null,null,null,null,null,null,null,null,null,null,null,null,"TYPES OF REPORTS!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Have \"Normalized\" be a TOGGLE or CHECK box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly Sales",null,"*this disables the normalized check box"]
[]
[null,null,null,null,null,"*BEFORE COPYING",null,null,null,null,null,null,null,null,null,"FIGURE OUT R ON UPDATING DATA"]
[null,null,null,null,null,null,"hyperlinks"]
[null,null,null,null,null,null,"data validation",null,null,null,null,null,null,null,null,"Make an array for each item in the chart?"]
[null,null,null,null,null,null,"links"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*ERROR MESSAGE WHEN THERE IS A DISCREPANCY!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Get rid of sumif functions"]
[null,"Working on getting a pie chart to appear for each day during \"summarize\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Have a text box that tells them to create a report when it's empty!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*MAKE IT NOT Put zEROS on the graph"]
[null,null,null,null,null,null,"*Other ISSUES",null,null,null,null,null,null,null,null,null,"Do loop that increases the datarange if there isn't a zero"]
[null,null,null,null,null,null,null,"Need to have ability to show/hide rows while unprotected",null,null,null,null,null,null,null,"*Make all the buttons depressed if something changes"]

{"sheet":"Ideas","index":16,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Questions",null,null,null,null,null,null,"**Don't forget the discrepancy"]
[null,"-Do you have the new menu",null,null,null,null,null,null,"Use data validation to give instructions for the entry of all data"]
[null,"-Need to prepare the spreadsheets for entry by week 1"]
[null,null,null,null,null,null,null,null,"Get the worksheets in…"]
[null,null,null,null,null,null,null,null,null,"Have a button to update the data?"]
[null,null,null,null,null,null,null,null,null,null,"and a notification confirming it updated?"]
[null,"Feedback"]
[null,null,"Total Sales was very confusing"]
[null,null,"Total Items Sold"]
[null,null,"Write Instructions & Procedures"]
[null,null,"Help with Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,"YOU NEED AN ERROR CHECKING LOOP FOR POPUlATING THE ARRAY IF NOTHING IS THERE!!!!"]
[null,null,"Write INTERFACE with hyperlinks",null,null,null,null,null,null,null,null,null,"THE DAILYSALES AND DAILYSOLD ARRAYS GET SCREWED UP IF THE VALUE IS NULL"]
[]
[null,null,"Average Check",null,null,null,null,null,null,null,null,null,"MSGBOX : \"PLEASE FILL OUT THE FORM BEFORE UPDATING\""]
[null,null,"Seat Turnover"]
[null,null,"Weekly Sales"]
[null,null,"Food Cost %?"]
[null,null,null,"Computrition",null,null,null,null,null,"When a cell changes then the checkmark goes away"]
[]
[null,null,"HIDE the numbers that aren't used"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Need a change event for when any price OR menu item changes…"]
[null,null,"WRITE the instructions for protecting the sheet"]
[]
[null,null,"Create hyperlinks",null,null,null,null,null,null,null,null,null,"Have a clear all button that someone can push"]
[]
[null,null,"Have a button to create charts",null,null,null,null,null,null,null,null,null,"the check boxes are moving with the summarize…"]
[]
[]
[null,null,"April 9th","together"]
[null,null,"April 12th"]
[null,null,13]
[null,null,14]
[null,null,15]
[]
[null,null,"Needs to be ULTRA easy to use and read and see"]
[]
[]
[null,null,"Instructions for Maintenance"]