#Meal planner macros template excel how to

Enter the rest of the values (Calories, Carbohydrates, Proteins, …).Enter the name of food below the last line of the table.The list of categories is below.įor example, I want to save Peanuts (1 oz, Calories: 161, Carbohydrates: 4.6, Proteins: 7.3, Fats: 14, Fiber: 2.4) Each category is on the separate worksheet. The file contains 17 named categories of food and 2 custom categories. You have to save the food into the database before the first use.

#Meal planner macros template excel how to

How to save or edit food into the database This is place for your own tables and formulas. You can use the “My calculations” worksheet if you need more than basic day statistics.

Right-click somewhere into the statistics table.

It has to be refreshed or you have to save, close and open again the file. The Pivot table doesn’t show the newly added data immediately. Your diet statistics are made by an ordinary Excel PivotTable on the sheet “Statistics”.

Repeat this procedure for the next food.

Units can be changed but not in this table!

Enter the Quantity in units that are in the column Units (150).

Enter a date below the last line of the table.

For example, you eat 150 grams of Nestle Fitness Corn flakes with 100 ml Semi-skimmed milk. Excel automatically calculates everything else (like number of calories, carbohydrates, proteins, fats and fiber). You simply choose food from the list and type the quantity. There are also some sample data for better orientation how it works. The file contains 17 food categories, eating diary and statistics. Finally, stick to your plan and have quick glance everyday to remind yourself of anything that needs to be done in advance.This file will help you track what you eat. We recommend you to also consider the time you need to make and serve meals while planning as some days you might have less time for the preparation. Weekly Meal Planner helps you to plan a week's worth of meals in advance. New rows are added automatically when using 'Tab' key. 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. Begin by downloading this template and recording the list of food items that you prefer to eat.