#Meal planning book download

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.

#Meal planning book 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