This to us, is the tricky part of the set up/design of this document.Ĥ) 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. Additionally, we would know that item would be meeting the requirements of 1 protein, and 2 vegetables. On a different workbook we would have the ingredients listed. Ideally, the drop down would just be for 'meals', and the option selected would be spinach salad. For example, on the attached data workbook (tab 'Menu 2'), we had a spinach salad for dinner. 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. We would have a different list for each food group (See 'Approved Foods' tab on the attached document).Ģ) Ensure that our daily intake meets the daily requirements (5 proteins, 3 veggies, 2 fruits). We have researched some available meals, and attempted to incorporate those into the spreadsheet.ġ) 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. Phase 1 has a list of available foods, all which fall into different categories.ġ) The calorie count be as close to 1,000 as possibleĢ) The individual eats 5 times per day (Breakfast, AM Snack, Lunch, PM Snack, and Dinner).ģ) 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). I've attached a document of what we have so far. I'm trying to use Excel to help us stay on track, meal plan, and grocery shop. It would be awesome if the same ingredients could be combined together, but that would just be a cherry on top.We recently started a new diet, PS1000. Then finally on the last sheet it would grab the ingredients list from the recipe sheet. It would pull (based on the recipe number selected) the number of servings for that recipe. The meal plan would randomly select a number corresponding to a recipe and then display that recipe name on the weekly planner. Thank you for any help or guidance that can be provided. I am just trying to figure out if it is possible and if so what functions I might need to make it happen so that I can research and figure it out. I don't want or expect anyone to do this for me. Then on the third sheet it would compile required ingredients from the recipe sheet. A random selector would select one of the recipes and fill it in on the meal plan chart. Then on a second sheet have the meal plan laid out. I'm trying to have the recipes on one sheet. Like the title says, I am trying to figure out an excel sheet that could function as a weekly meal planner. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Or use tableit, or the ExcelToReddit converter (thanks to u/tirlibibi17), to convert your data into a Reddit table. Provide some dataĪdd screenshots in your text post, or provide links to uploaded images at an image-hosting site. Tip: For VBA or Power Query, select the code, press Tab, then copy/paste the selection into your post or comment. The best way to display code on Reddit is to put it in a code-block This awards the user a ClippyPoint and changes the post flair to solved. OPs may (and should) reply to any solutions saying: Solution Verified
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |