#Automatic meal planner download

In columns E:F, formula will display the ingredient information that you entered on the Recipe_Ingred sheet.

For example, type a 2, if the recipe calls for 2 cans of beans. In column D, enter the quantity required for the selected recipe.Or, just type the missing ingredient in the cell, and no cost information will be calculated. If the ingredient isn't in the list, go to the Recipe_Ingred list and add it. In column C, select the name of an ingredient from the drop down list.Select the name of one of your meal items from the drop down list. NOTE: You don't need to enter ingredients that you usually have on hand, such as salt and pepper, or cooking oil. It has a list where you will enter the main ingredients In the screen shot below, ground beef is in the fridge freezer, and in the basement freezer, for a total of 3 pounds.Īfter you have entered the recipe names and ingredient costs, go the Meal_Ingredients worksheet. The Loc Qty column has a formula that sums the amounts for the 2 locations.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.

#Automatic meal planner download

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