milkandcookies
New Member
Hi All,
We recently started a new diet, PS1000. I'm trying to use Excel to help us stay on track, meal plan, and grocery shop.
I've attached a document of what we have so far.
Here are some of the basics:
- PS1000 has three phases. Right now, I'm planning for Phase 1.
- Phase 1 has a list of available foods, all which fall into different categories.
- Daily eating requires that:
1) The calorie count be as close to 1,000 as possible
2) The individual eats 5 times per day (Breakfast, AM Snack, Lunch, PM Snack, and Dinner).
3) The individual consumes 5 proteins (1 per eating time), as well as 3 veggies and 2 fruits per day (which can each be consumed at any meal).
We have researched some available meals, and attempted to incorporate those into the spreadsheet.
Ideal Outcome:
1) Have one sheet with the meals for that day displayed where we can choose from a drop down one meal or food item from an available list, and have the calories displayed. We would have a different list for each food group (See 'Approved Foods' tab on the attached document).
2) Ensure that our daily intake meets the daily requirements (5 proteins, 3 veggies, 2 fruits). We would like to be able to do this by looking at values from another sheet if a meal (rather than a singular food item) is selected. For example, on the attached data workbook (tab 'Menu 2'), we had a spinach salad for dinner. Ideally, the drop down would just be for 'meals', and the option selected would be spinach salad. On a different workbook we would have the ingredients listed. Additionally, we would know that item would be meeting the requirements of 1 protein, and 2 vegetables. This to us, is the tricky part of the set up/design of this document.
3) Have a total calorie intake sum.
4) Be able to plan 7 days in advance, having a summary sheet that consolidates all of our daily choices and meals in a tabular form. (We liked the example in this excel template: http://www.contextures.com/excel-weekly-meal-planner.html)
5) Have a macro that consolidates our foods needed into a shopping list, grouping items together (ie- if we have 1 cup of Broccoli on our weekly meal plan 3 times, the shopping list states Broccoli - 3 cups, instead of listing out Broccoli - 1 cup, 3 times).
If anyone has recommendations, or templates that already exist that would be great. We liked the set up for this document, but don't understand how to change the data for it to do everything we need/want. (http://www.contextures.com/excel-weekly-meal-planner.html).
Any input is appreciated!
Thank you,
Kristi
We recently started a new diet, PS1000. I'm trying to use Excel to help us stay on track, meal plan, and grocery shop.
I've attached a document of what we have so far.
Here are some of the basics:
- PS1000 has three phases. Right now, I'm planning for Phase 1.
- Phase 1 has a list of available foods, all which fall into different categories.
- Daily eating requires that:
1) The calorie count be as close to 1,000 as possible
2) The individual eats 5 times per day (Breakfast, AM Snack, Lunch, PM Snack, and Dinner).
3) The individual consumes 5 proteins (1 per eating time), as well as 3 veggies and 2 fruits per day (which can each be consumed at any meal).
We have researched some available meals, and attempted to incorporate those into the spreadsheet.
Ideal Outcome:
1) Have one sheet with the meals for that day displayed where we can choose from a drop down one meal or food item from an available list, and have the calories displayed. We would have a different list for each food group (See 'Approved Foods' tab on the attached document).
2) Ensure that our daily intake meets the daily requirements (5 proteins, 3 veggies, 2 fruits). We would like to be able to do this by looking at values from another sheet if a meal (rather than a singular food item) is selected. For example, on the attached data workbook (tab 'Menu 2'), we had a spinach salad for dinner. Ideally, the drop down would just be for 'meals', and the option selected would be spinach salad. On a different workbook we would have the ingredients listed. Additionally, we would know that item would be meeting the requirements of 1 protein, and 2 vegetables. This to us, is the tricky part of the set up/design of this document.
3) Have a total calorie intake sum.
4) Be able to plan 7 days in advance, having a summary sheet that consolidates all of our daily choices and meals in a tabular form. (We liked the example in this excel template: http://www.contextures.com/excel-weekly-meal-planner.html)
5) Have a macro that consolidates our foods needed into a shopping list, grouping items together (ie- if we have 1 cup of Broccoli on our weekly meal plan 3 times, the shopping list states Broccoli - 3 cups, instead of listing out Broccoli - 1 cup, 3 times).
If anyone has recommendations, or templates that already exist that would be great. We liked the set up for this document, but don't understand how to change the data for it to do everything we need/want. (http://www.contextures.com/excel-weekly-meal-planner.html).
Any input is appreciated!
Thank you,
Kristi
