linerindex.blogg.se

#Dinner menu calendar download

If the ingredient is also stored in another location, enter that information in the Loc02 and Loc02 Qty columns.Enter the current quantity on hand in the Loc01 Qty column.On the Recipe_Ingred sheet, there are location columns at the left side of the Ingredients table.įor any ingredient that you want to track: You can edit this list, and add new locations, or delete storage locations that you don't need. On the Admin_Lists sheet, there's a small table with locations where you might store your ingredients at home. an Admin_Lists sheet, with a locations table.additional columns in the ingredients table.

If you download the Basic Meal Planner with Inventory, there are (optional) In column E, enter the unit price, or an approximate price.For most items, use the unit type that you'd see in most of your recipes, such as "cup" for sugar, even though you buy it in a bag. In column C, enter the ingredient category, such as Meat or Dairy - you can create your own categories, if you prefer.If an ingredient that you need is NOT in the list, enter it in column B.Sort the list by ingredient name, to see what ingredients have already been entered.To check for ingredients, and add new ones: Soon, you will be selecting the ingredients for your recipes, and those ingredients should be entered in the cost list first.

Later, those items can be added to the "Other" row on the weekly menu, so they get added to the shopping list.Īfter you have entered the recipe names, go the Recipe_Ingredients worksheet. NOTE: You can also enter items that you purchase weekly, such as "Milk, weekly", or "Coffee, ground".

In column B, enter the name of the dishĮnter a link to a recipe online, or type a cookbook name and page.

There are a few sample items in the Excel weekly meal planner, and you can add new items to the list, at any time. Worksheet, if they haven't been entered already.

Click the Get My Recipes button, to see a list of recipes that are on the Meal_Ingredients sheet.Īfter you select your recipes, you will enter them on the Meal_Items.

For example, you might want to use a specific ingredient from your pantry or fridge, before its "Best Before" date. You can also search the recipes that are already entered on the Meal_Ingredients sheet. Then, if you like the recipe, print a copy, to refer to later. A macro runs, and pulls a list of recipesįor the selected ingredient. On the Recipes sheet, enter an ingredient name in cell A2, then click To find more recipes, you can look through your collection of cookbooks, or go to the Recipes sheet in the Excel Weekly There are a few recipes in the sample file, to get you started. The first step is to choose some recipes for your weekly meals.

Note: For special occasions, see my Excel Pena, who created the Recipe Selector tool in the meal planner. To see a quick overview of how the Excel Weekly Meal Planner works, watch this short video. Enter your favourite meals, list their basic ingredients,Īnd click a button to create a shopping list for a week's meals. To help you make the job of meal planning easier, you can use this Excel weekly meal Get the Excel Weekly Meal Planner Excel Meal Planner Intro

#Dinner menu calendar download