I am sure that I am not alone in trying to find some sort of "easy" way to plan healthy meals for my family. (
I hear a lot of "Amen"'s out there). I am trying to create a new system that involves a spreadsheet and links to recipes - see sidebar. Right now I have the following worksheets in the file:
- Meal Ideas: suggestion of combinations of main dish and sides
- Adult Foods: foods that Snicks and I eat, and some that AG can also eat
- Child Foods: foods that are for AG
- Week 1 Menu: main dish and two sides; spaces for adult and child breakfast, lunch, snack, and dinner; drop down lists draw from Adult Foods and Child Foods
- Week 1 Grocery List: list of groceries to get by store based upon menu for week (does not include what we already have in the pantry) - colors indicate sales and coupons
Although I like the idea of what I have created, it really doesn't fully do what I want it to which should make it super user friendly. Here's what I want it to do:
- Links will be active even in dropdown lists (now I have to refer to the foods lists for the links to recipes)
- Somehow easily be transposed into a more attractive format (word? mail merge?)
- Some sort of database with type of food, main ingredients, etc which would be searchable
- Shopping list is automatically created from necessary ingredients
Here are my thoughts on resolving the last two on that list:
- Create a new blog that is only recipes, then I can categorize each blog entry which would thereby be searchable
- Create a new worksheet for every.single.recipe that includes a column for number/volume of each ingredient; the grocery list would then sum all of the information in the selected sheets (although I don't know how this would work)
It is functional and useful the way it is right now but I am open to any and all suggestions for those who are more tech savvy than me. :)
I am thankful that we have enough food in our cupboards to eat.