Meal Planning Template For Mac

• Meal Planning Calendar Printable
• Meal Planning Template For Mac 2017

Oct 26, 2018 - To help you make the job of meal planning easier, you can use this Excel weekly meal planner template. Enter your favourite meals, list their.

1. Discover ideas about Weekly Meal Planner Template. Meal Planner with. Microsoft Excel template - download to organize and plan meals! Input a months.
2. Jan 10, 2017 - New Macs come with Numbers, a spreadsheet program that's perfect for. Numbers has a built in Meal Planner template, which even has a.

Excel Meal Planner Intro To help you make the job of meal planning easier, you can use this Excel weekly meal planner template. Enter your favourite meals, list their basic ingredients, and click a button to create a shopping list for a week's meals. To see a quick overview of how the Excel Weekly Meal Planner works, watch this short video. Your browser can't show this frame. Here is a link to the page Thanks to, who created the Recipe Selector tool in the meal planner. Note: For special occasions, see my.

Select Recipes The first step is to choose some recipes for your weekly meals. There are a few recipes in the sample file, to get you started. To find more recipes, you can look through your collection of cookbooks, or go to the Recipes sheet in the Excel Weekly Meal Planner. On the Recipes sheet, enter an ingredient name in cell A2, then click the Get Recipes button.

Meal Planning Calendar Printable

A macro runs, and pulls a list of recipes for the selected ingredient. To see one of the recipes, click its link. Then, if you like the recipe, print a copy, to refer to later. Sqltunes for mac pro. Enter the List of Meal Items After you select your recipes, you will enter them on the MealItems worksheet, if they haven't been entered already. There are a few sample items in the Excel weekly meal planner, and you can add new items to the list, at any time.

To add a new recipe:. Go to the MealItems sheet. In column B, enter the name of the dish. In column C, you can enter a link to a recipe online, or type a cookbook name and page number. List Recipe Ingredients and Costs After you have entered the recipe names, go the RecipeIngredients worksheet. Soon, you will be selecting the ingredients for your recipes, and those ingredients should be entered in the cost list first.

Meal Planning Template For Mac 2017

To check for ingredients, and add new ones:. Go the RecipeIngredients worksheet. Sort the list by ingredient name, to see what ingredients have already been entered. If an ingredient that you need is not already in the list, enter it in column B. In column C, enter the ingredient category, such as Meat or Dairy. In column D, enter the unit, such cup, or lb, or 14 oz can. In column E, enter the unit cost, or an approximate cost.

List the Meal Ingredients After you have entered the recipe names and ingredient costs, go the MealIngredients worksheet. It has a list where you will enter the main ingredients for each recipe.

In column B, select the name of one of your meal items from the drop down list. In column C, select the name of an ingredient from the drop down list. If the ingredient isn't in the list, go to the RecipeIngred list and add it. Or, just type the missing ingredient in the cell, and no cost information will be calculated. In column D, enter the quantity required for the selected recipe.

For example, type a 2, if the recipe calls for 2 cans of beans. In columns E:F, formula will display the ingredient information that you entered on the RecipeIngred sheet. In columns G:J, formulas in the grey cells calculate the costs for the shopping list. Select the Weekly Meals After you have entered all the ingredients, you're ready to start the weekly meal planning. On the WeekPlan sheet, select items for each weekday's meals, by using the lists in columns C:E. There are 5 selection cells for each meal, and you can also add snacks, and other items you need to purchase.

Tip: If you want to find recipes that you have already entered, and that use a specific ingredient, go to the MyRecipes sheet. Enter an ingredient name in cell A2, then click the Get My Recipes button, to see a list of recipes. Create the Weekly Shopping List After you select each day's meals, click the Shopping List button at the top of the WeekPlan sheet. This runs a macro, which uses an to copy all the ingredients for the selected meals to the ShoppingList sheet, and sorts the shopping list by ingredient name. As you select each day's meal, that meal's ingredients are marked with a 1 on the MealIngredients worksheet, in column G.

On the MealItems sheet, in cells G1:G2, there is a criteria range that's used in the advanced filter. It checks for ingredients that are marked with a 1 (or higher) in column G. Print the Shopping List After the shopping list has been created, the items are summarized by category, in an You can print the list, add any other grocery items that you need, and then head to the grocery store. Weekly Meal Planner VBA Code Shown below is the code that is in the weekly meal planner sample file. The first macro - CreateShoppingList - is on a regular code module.

The remaining code is on the sheet module for the Recipes worksheet CreateShoppingList Macro In the sample file, you'll find this code on a. It creates the shopping list, based on the selected meals.