For doing that, you can use a "Tab" on your keyboard to move between the cells. You also have an option to add values in this sheet. Meals: This sheet has comprehensive list of food choices for breakfast, lunch, afternoon snacks and dinner that can be used as dropdown list in Planner A and Planner B.This sheet also has Grocery List which allows you to plan the things that you need to purchase. However in this layout you can manage the information from Monday to Sunday, in side to side format which means you can view two days together. ![]() Planner B: With this sheet, you can plan your main meal and side meals using drop down lists for your breakfast, lunch, afternoon snacks and dinner as above.In this layout you can manage the information from Monday to Sunday, organized in one after the other format. Planner A: Use this sheet to plan your main meal and side meals using drop down lists for your breakfast, lunch, afternoon snacks and dinner.This template includes two planners as follows: ![]() You can then use this list later for selecting from drop down lists. Involve everyone at home including kids to identify a comprehensive list of meals they like. Smaller items you do by doing weekly inventory.Begin by downloading this template and recording the list of food items that you prefer to eat. eggs from pancakes, muffins and cookies)ģ At the end you have a daily shopping list per day (80 eggs used, 50g parsley used, 15kg potatoes used) that you can send to your grocer for the main items. chicken with rice for 100pax)Ģ The list then converts the dish into its predetermined ingredients (50g of parsley, 200g of potatoes, 1 egg etc), multiplies that by the number of servings of each event and adds other ingredients from dishes that day, that they have in common (e.g. The excel Mona Lisa I am looking for would behave like this:ġ The cooks can place in a weekly list the dishes they make plus the amount of people they serve (e.g. We have many functions where we know what we cook and make and cater and I want to make it easier for our kitchen team when they have to order for the weekly functions for the week. This list is the best I have found in a long while and I am amazed by what you have done! I don’t know if you are working on request and for pay but I am working on a project for a hotel kitchen that works as follows. _ Author Debra Dalgleish Posted on JApCategories Excel Templates If you have any ideas for the next version of the weekly meal planner, please let me know. After you unzip the file, be sure to enable macros, if you want to use the shopping list feature. The file is in xlsm format, and contains macros that create the shopping list. To download the sample file, go to the Excel Meal Planner page on my Contextures website. The shopping list still works the same – just click a button and it updates the pivot table with the grocery items for the week’s meals.īut now the shopping list will show the costs too, so you can bring enough money to the grocery store, when you go shopping. If an item wasn’t selected for the current week’s meals, its quantity and cost are zero. ![]() Based on the meal items you selected, and the food costs on the ingredients sheet, the weekly grocery cost can be calculated. Within each meal block, there are 5 cells with drop down lists, so you have more room to enter meal items.Īnother change to the new version is that you can enter the food costs too. In the new version, the layout is set up for 3 meals, and snacks, with a separate column for each weekday. In the meal entry sheet, there wasn’t even a spot to indicate which meal you were planning, if there were 2 or more meals on the same day. In the old version, the meals were entered in a long list, and you could choose up to 3 items for each meal. I hadn’t used it for quite a while, and after opening it this week, I decided it was time for an update. There is an Excel weekly meal planner on my website, and you can use it to organize your meals, and create a shopping list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |