{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Daily Meal Planner Setup","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday","Weekly View"],"not_rendered":{"charts":16,"defined_names":44},"read":"whole","date_system":"1900"}

{"sheet":"Daily Meal Planner Setup","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[1,9,1,10],[1,12,1,13],[2,9,2,10],[2,12,2,13],[3,9,3,13],[4,1,27,1],[5,10,5,12],[9,10,9,12],[13,10,13,12],[17,10,17,12]]}
[]
[{"$nulls":9},"DAILY CALORIE TARGET",null,null,"DAILY FAT GRAM TARGET"]
[null," MEAL PLANNER SETUP",{"$nulls":7},{"$f":"BCalories+LCalories+DCalories+SCalories","v":1600},null,null,{"$f":"BFatGrams+LFatGrams+DFatGrams+SFatGrams","v":50}]
[{"$nulls":9},"ENTER TARGET GOALS BY MEAL"]
[null,"This sheet stores information that is used across your meal planner. You can type over the sample data or add new Food Items to customize it to fit your needs. \n\nThe table of Food Items is linked to a drop down list of choices for each meal in your planner. When you select a food item in a daily meal table, for example if you select scrambled eggs for breakfast on Monday, the Serving, Calories, and Fat will automatically populate. All you need to do is make a selection from the drop down list and enter the number of servings.\n\nThe Target Goals you enter for your daily calories and fat grams are automatically carried over to the respective meals so you don't need to enter them each time. For example, change the target calories for Breakfast and then switch to the sheet for any meal plan, such as Monday, and you'll see your change appear in cell E16.\n\nAlso note that your daily Total Calories and Total Fat Grams at the top of each weekly sheet will turn red to help you quickly identify the days you exceed your Daily Calorie and Daily Fat Gram Target goals."]
[{"$nulls":4},"FOOD ITEM","SERVING","CALORIES","FAT",null,null,"BREAKFAST"]
[{"$nulls":4},"asparagus spears","1/2 cup",20,0.2,null,null,375,null,20]
[{"$nulls":4},"bacon","slice",23,1.5,null,null,"CALORIES",null,"FAT GRAMS"]
[{"$nulls":4},"baked potato (no salt)","1/2 cup",51,0.1]
[{"$nulls":4},"banana","banana",200,0.7,null,null,"LUNCH"]
[{"$nulls":4},"blueberries","cup",83,0.5,null,null,450,null,10]
[{"$nulls":4},"butter w/salt","pat",36,4.1,null,null,"CALORIES",null,"FAT GRAMS"]
[{"$nulls":4},"chicken breast","cup",231,5]
[{"$nulls":4},"coffee (black)","mug",5,0,null,null,"DINNER"]
[{"$nulls":4},"cooked broccoli","stalk",98,1.1,null,null,475,null,15]
[{"$nulls":4},"mixed fruit cup","cup",70,0,null,null,"CALORIES",null,"FAT GRAMS"]
[{"$nulls":4},"orange juice","cup",112,0.5]
[{"$nulls":4},"poached egg","egg",71,5,null,null,"SNACKS"]
[{"$nulls":4},"popcorn cake","lg cake",38,0.3,null,null,300,null,5]
[{"$nulls":4},"scrambled eggs","egg",100,7.7,null,null,"CALORIES",null,"FAT GRAMS"]
[{"$nulls":4},"sushi (pink salmon)","1/2 fillet",184,5.5]
[{"$nulls":4},"salad (no dressing)","1 1/2 cups",33,0.1]
[{"$nulls":4},"tuna (light in water)","can",191,1.4]
[{"$nulls":4},"wheat berry toast","slice",89,1.2]

{"sheet":"Monday","index":1,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," MONDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":1236},null,{"$f":"DailyFatGrams","v":40.150000000000006}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[null,"scrambled eggs",2,{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":"egg"},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":200},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":15.4},"blueberries",2,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":166},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":1},"cooked broccoli",1,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":"stalk"},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":98},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":1.1},"blueberries",1,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":83},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":0.5}]
[null,"wheat berry toast",1,{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":"slice"},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":89},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":1.2},"popcorn cake",1,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":"lg cake"},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":38},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":0.3},"baked potato (no salt)",1,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":"1/2 cup"},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":51},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":0.1},"mixed fruit cup",1,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":70},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":0}]
[null,"orange juice",0.5,{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":56},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":0.25},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},"butter w/salt",2,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":"pat"},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":72},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":8.2},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"butter w/salt",1,{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":"pat"},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":36},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":4.1},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},"chicken breast",1,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":231},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":5},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"bacon",2,{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":"slice"},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":46},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":3},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*MondayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*MondayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*MondayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*MondaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,MondayBreakfastTable[CAL])","v":427},{"$f":"SUBTOTAL(109,MondayBreakfastTable[FAT])","v":{"v":23.950000000000003,"d":"23.95"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,MondayLunchTable[CAL])","v":204},{"$f":"SUBTOTAL(109,MondayLunchTable[FAT])","v":{"v":1.3,"d":"1.30"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,MondayDinnerTable[CAL])","v":452},{"$f":"SUBTOTAL(109,MondayDinnerTable[FAT])","v":{"v":14.399999999999999,"d":"14.40"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,MondaySnacksTable[CAL])","v":153},{"$f":"SUBTOTAL(109,MondaySnacksTable[FAT])","v":{"v":0.5,"d":"0.50"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Tuesday","index":2,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," TUESDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":1644.5},null,{"$f":"DailyFatGrams","v":43.699999999999996}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[null,"bacon",3,{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":"slice"},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":69},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":4.5},"mixed fruit cup",1,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":70},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":0},"chicken breast",2,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":462},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":10},"popcorn cake",1,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":"lg cake"},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":38},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":0.3}]
[null,"scrambled eggs",3,{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":"egg"},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":300},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":23.1},"tuna (light in water)",0.5,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":"can"},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":95.5},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":0.7},"cooked broccoli",1,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":"stalk"},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":98},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":1.1},"blueberries",2,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":166},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":1}]
[null,"wheat berry toast",2,{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":"slice"},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":178},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":2.4},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},"baked potato (no salt)",1,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":"1/2 cup"},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":51},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":0.1},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"orange juice",1,{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":"cup"},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":112},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":0.5},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"coffee (black)",1,{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":"mug"},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":5},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":0},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*TuesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*TuesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*TuesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*TuesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,TuesdayBreakfastTable[CAL])","v":664},{"$f":"SUBTOTAL(109,TuesdayBreakfastTable[FAT])","v":{"v":30.5,"d":"30.50"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,TuesdayLunchTable[CAL])","v":165.5},{"$f":"SUBTOTAL(109,TuesdayLunchTable[FAT])","v":{"v":0.7,"d":"0.70"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,TuesdayDinnerTable[CAL])","v":611},{"$f":"SUBTOTAL(109,TuesdayDinnerTable[FAT])","v":{"v":11.2,"d":"11.20"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,TuesdaySnacksTable[CAL])","v":204},{"$f":"SUBTOTAL(109,TuesdaySnacksTable[FAT])","v":{"v":1.3,"d":"1.30"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Wednesday","index":3,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," WEDNESDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":0},null,{"$f":"DailyFatGrams","v":0}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*WednesdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*WednesdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*WednesdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*WednesdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,WednesdayBreakfastTable[CAL])","v":0},{"$f":"SUBTOTAL(109,WednesdayBreakfastTable[FAT])","v":{"v":0,"d":"0.00"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,WednesdayLunchTable[CAL])","v":0},{"$f":"SUBTOTAL(109,WednesdayLunchTable[FAT])","v":{"v":0,"d":"0.00"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,WednesdayDinnerTable[CAL])","v":0},{"$f":"SUBTOTAL(109,WednesdayDinnerTable[FAT])","v":{"v":0,"d":"0.00"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,WednesdaySnacksTable[CAL])","v":0},{"$f":"SUBTOTAL(109,WednesdaySnacksTable[FAT])","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Thursday","index":4,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," THURSDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":0},null,{"$f":"DailyFatGrams","v":0}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*ThursdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*ThursdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*ThursdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*ThursdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,ThursdayBreakfastTable[CAL])","v":0},{"$f":"SUBTOTAL(109,ThursdayBreakfastTable[FAT])","v":{"v":0,"d":"0.00"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,ThursdayLunchTable[CAL])","v":0},{"$f":"SUBTOTAL(109,ThursdayLunchTable[FAT])","v":{"v":0,"d":"0.00"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,ThursdayDinnerTable[CAL])","v":0},{"$f":"SUBTOTAL(109,ThursdayDinnerTable[FAT])","v":{"v":0,"d":"0.00"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,ThursdaySnacksTable[CAL])","v":0},{"$f":"SUBTOTAL(109,ThursdaySnacksTable[FAT])","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Friday","index":5,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," FRIDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":0},null,{"$f":"DailyFatGrams","v":0}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*FridayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*FridayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*FridayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*FridaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,FridayBreakfastTable[CAL])","v":0},{"$f":"SUBTOTAL(109,FridayBreakfastTable[FAT])","v":{"v":0,"d":"0.00"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,FridayLunchTable[CAL])","v":0},{"$f":"SUBTOTAL(109,FridayLunchTable[FAT])","v":{"v":0,"d":"0.00"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,FridayDinnerTable[CAL])","v":0},{"$f":"SUBTOTAL(109,FridayDinnerTable[FAT])","v":{"v":0,"d":"0.00"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,FridaySnacksTable[CAL])","v":0},{"$f":"SUBTOTAL(109,FridaySnacksTable[FAT])","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Saturday","index":6,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," SATURDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":0},null,{"$f":"DailyFatGrams","v":0}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*SaturdayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*SaturdayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*SaturdayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*SaturdaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,SaturdayBreakfastTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SaturdayBreakfastTable[FAT])","v":{"v":0,"d":"0.00"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,SaturdayLunchTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SaturdayLunchTable[FAT])","v":{"v":0,"d":"0.00"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,SaturdayDinnerTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SaturdayDinnerTable[FAT])","v":{"v":0,"d":"0.00"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,SaturdaySnacksTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SaturdaySnacksTable[FAT])","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Sunday","index":7,"n_rows":16,"n_cols":21,"rows_kept":16,"merged":[[1,17,1,18],[1,19,1,20],[2,17,2,18],[2,19,2,20],[5,1,5,4],[6,1,6,5],[6,6,6,10],[6,11,6,15],[6,16,6,20]]}
[]
[{"$nulls":17},"TOTAL CALORIES",null,"TOTAL FAT GRAMS"]
[null," SUNDAY MEAL PLAN",{"$nulls":15},{"$f":"DailyCalories","v":0},null,{"$f":"DailyFatGrams","v":0}]
[]
[]
[null,"MEALS AT A GLANCE"]
[null,"BREAKFAST",{"$nulls":4},"LUNCH",{"$nulls":4},"DINNER",{"$nulls":4},"SNACKS"]
[null,"ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT","FOOD ITEM","SERV","AMT","CAL","FAT"]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B9,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G9,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B10,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G10,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L10,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q10,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B11,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G11,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L11,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q11,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B12,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G12,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L12,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q12,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B13,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G13,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L13,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q13,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],3,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(B14,FoodItemsTable[],4,FALSE)*SundayBreakfastTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],3,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(G14,FoodItemsTable[],4,FALSE)*SundayLunchTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],3,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L14,FoodItemsTable[],4,FALSE)*SundayDinnerTable[[#This Row],[SERV]],\"\")","v":""},null,null,{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],3,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q14,FoodItemsTable[],4,FALSE)*SundaySnacksTable[[#This Row],[SERV]],\"\")","v":""}]
[null,"BREAKFAST TOTAL",null,null,{"$f":"SUBTOTAL(109,SundayBreakfastTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SundayBreakfastTable[FAT])","v":{"v":0,"d":"0.00"}},"LUNCH TOTAL",null,null,{"$f":"SUBTOTAL(109,SundayLunchTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SundayLunchTable[FAT])","v":{"v":0,"d":"0.00"}},"DINNER TOTAL",null,null,{"$f":"SUBTOTAL(109,SundayDinnerTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SundayDinnerTable[FAT])","v":{"v":0,"d":"0.00"}},"SNACKS TOTAL",null,null,{"$f":"SUBTOTAL(109,SundaySnacksTable[CAL])","v":0},{"$f":"SUBTOTAL(109,SundaySnacksTable[FAT])","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TARGET",null,null,{"$f":"BCalories","v":375},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",null,null,{"$f":"LCalories","v":450},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",null,null,{"$f":"DCalories","v":475},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",null,null,{"$f":"SCalories","v":300},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]

{"sheet":"Weekly View","index":8,"n_rows":18,"n_cols":13,"rows_kept":18,"merged":[[5,1,5,4],[6,1,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,12]]}
[]
[{"$nulls":11},"TOTAL CALORIES","TOTAL FAT GRAMS"]
[null," WEEKLY REVIEW",{"$nulls":9},{"$f":"MondayCalories+TuesdayCalories+WednesdayCalories+ThursdayCalories+FridayCalories+SaturdayCalories+SundayCalories","v":2880.5},{"$f":"MondayFatGrams+TuesdayFatGrams+WednesdayFatGrams+ThursdayFatGrams+FridayFatGrams+SaturdayFatGrams+SundayFatGrams","v":83.85}]
[]
[]
[null,"DAILY TOTALS & AVERAGES"]
[null,"BREAKFAST",null,null,"LUNCH",null,null,"DINNER",null,null,"SNACKS"]
[null,"DAY","CAL","FAT","DAY","CAL","FAT","DAY","CAL","FAT","FOOD ITEM","CAL","FAT"]
[null,"Monday",{"$f":"MondayBreakfastTable[[#Totals],[CAL]]","v":{"v":427,"d":"427.00"}},{"$f":"MondayBreakfastTable[[#Totals],[FAT]]","v":{"v":23.950000000000003,"d":"23.95"}},"Monday",{"$f":"MondayLunchTable[[#Totals],[CAL]]","v":{"v":204,"d":"204.00"}},{"$f":"MondayLunchTable[[#Totals],[FAT]]","v":{"v":1.3,"d":"1.30"}},"Monday",{"$f":"MondayDinnerTable[[#Totals],[CAL]]","v":{"v":452,"d":"452.00"}},{"$f":"MondayDinnerTable[[#Totals],[FAT]]","v":{"v":14.399999999999999,"d":"14.40"}},"Monday",{"$f":"MondaySnacksTable[[#Totals],[CAL]]","v":{"v":153,"d":"153.00"}},{"$f":"MondaySnacksTable[[#Totals],[FAT]]","v":{"v":0.5,"d":"0.50"}}]
[null,"Tuesday",{"$f":"TuesdayBreakfastTable[[#Totals],[CAL]]","v":{"v":664,"d":"664.00"}},{"$f":"TuesdayBreakfastTable[[#Totals],[FAT]]","v":{"v":30.5,"d":"30.50"}},"Tuesday",{"$f":"TuesdayLunchTable[[#Totals],[CAL]]","v":{"v":165.5,"d":"165.50"}},{"$f":"TuesdayLunchTable[[#Totals],[FAT]]","v":{"v":0.7,"d":"0.70"}},"Tuesday",{"$f":"TuesdayDinnerTable[[#Totals],[CAL]]","v":{"v":611,"d":"611.00"}},{"$f":"TuesdayDinnerTable[[#Totals],[FAT]]","v":{"v":11.2,"d":"11.20"}},"Tuesday",{"$f":"TuesdaySnacksTable[[#Totals],[CAL]]","v":{"v":204,"d":"204.00"}},{"$f":"TuesdaySnacksTable[[#Totals],[FAT]]","v":{"v":1.3,"d":"1.30"}}]
[null,"Wednesday",{"$f":"WednesdayBreakfastTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"WednesdayBreakfastTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Wednesday",{"$f":"WednesdayLunchTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"WednesdayLunchTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Wednesday",{"$f":"WednesdayDinnerTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"WednesdayDinnerTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Wednesday",{"$f":"WednesdaySnacksTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"WednesdaySnacksTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}}]
[null,"Thursday",{"$f":"ThursdayBreakfastTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"ThursdayBreakfastTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Thursday",{"$f":"ThursdayLunchTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"ThursdayLunchTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Thursday",{"$f":"ThursdayDinnerTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"ThursdayDinnerTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Thursday",{"$f":"ThursdaySnacksTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"ThursdaySnacksTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}}]
[null,"Friday",{"$f":"FridayBreakfastTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"FridayBreakfastTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Friday",{"$f":"FridayLunchTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"FridayLunchTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Friday",{"$f":"FridayDinnerTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"FridayDinnerTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Friday",{"$f":"FridaySnacksTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"FridaySnacksTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}}]
[null,"Saturday",{"$f":"SaturdayBreakfastTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SaturdayBreakfastTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Saturday",{"$f":"SaturdayLunchTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SaturdayLunchTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Saturday",{"$f":"SaturdayDinnerTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SaturdayDinnerTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Saturday",{"$f":"SaturdaySnacksTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SaturdaySnacksTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}}]
[null,"Sunday",{"$f":"SundayBreakfastTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SundayBreakfastTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Sunday",{"$f":"SundayLunchTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SundayLunchTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Sunday",{"$f":"SundayDinnerTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SundayDinnerTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}},"Sunday",{"$f":"SundaySnacksTable[[#Totals],[CAL]]","v":{"v":0,"d":"0.00"}},{"$f":"SundaySnacksTable[[#Totals],[FAT]]","v":{"v":0,"d":"0.00"}}]
[null,"BREAKFAST TOTAL",{"$f":"SUBTOTAL(109,WeeklyBreakfastTable[CAL])","v":{"v":1091,"d":"1091.00"}},{"$f":"SUBTOTAL(109,WeeklyBreakfastTable[FAT])","v":54.45},"LUNCH TOTAL",{"$f":"SUBTOTAL(109,WeeklyLunchTable[CAL])","v":{"v":369.5,"d":"369.50"}},{"$f":"SUBTOTAL(109,WeeklyLunchTable[FAT])","v":{"v":2,"d":"2.00"}},"DINNER TOTAL",{"$f":"SUBTOTAL(109,WeeklyDinnerTable[CAL])","v":{"v":1063,"d":"1063.00"}},{"$f":"SUBTOTAL(109,WeeklyDinnerTable[FAT])","v":{"v":25.599999999999998,"d":"25.60"}},"SNACKS TOTAL",{"$f":"SUBTOTAL(109,WeeklySnacksTable[CAL])","v":{"v":357,"d":"357.00"}},{"$f":"SUBTOTAL(109,WeeklySnacksTable[FAT])","v":{"v":1.8,"d":"1.80"}}]
[null,"BREAKFAST TARGET",{"$f":"BCalories","v":{"v":375,"d":"375.00"}},{"$f":"BFatGrams","v":{"v":20,"d":"20.00"}},"LUNCH TARGET",{"$f":"LCalories","v":{"v":450,"d":"450.00"}},{"$f":"LFatGrams","v":{"v":10,"d":"10.00"}},"DINNER TARGET",{"$f":"DCalories","v":{"v":475,"d":"475.00"}},{"$f":"DFatGrams","v":{"v":15,"d":"15.00"}},"SNACKS TARGET",{"$f":"SCalories","v":{"v":300,"d":"300.00"}},{"$f":"SFatGrams","v":{"v":5,"d":"5.00"}}]
[null,"BREAKFAST AVERAGE",{"$f":"AVERAGE(WeeklyBreakfastTable[CAL])","v":{"v":155.85714285714286,"d":"155.86"}},{"$f":"AVERAGE(WeeklyBreakfastTable[FAT])","v":{"v":7.778571428571429,"d":"7.78"}},"LUNCH AVERAGE",{"$f":"AVERAGE(WeeklyLunchTable[CAL])","v":{"v":52.785714285714285,"d":"52.79"}},{"$f":"AVERAGE(WeeklyLunchTable[FAT])","v":{"v":0.2857142857142857,"d":"0.29"}},"DINNER AVERAGE",{"$f":"AVERAGE(WeeklyDinnerTable[CAL])","v":{"v":151.85714285714286,"d":"151.86"}},{"$f":"AVERAGE(WeeklyDinnerTable[FAT])","v":{"v":3.657142857142857,"d":"3.66"}},"SNACKS AVERAGE",{"$f":"AVERAGE(WeeklySnacksTable[CAL])","v":{"v":51,"d":"51.00"}},{"$f":"AVERAGE(WeeklySnacksTable[FAT])","v":{"v":0.2571428571428572,"d":"0.26"}}]