#FREE PRINTABLE CALORIE COUNTER TRACKER HOW TO#

In this video example, I will rename the Drinks & Juices category to Abcd. The name of the source table (table with items) can be edited in Formulas > Name Manager or in Table tools > Design > Table Name. Both have to be exactly the same (and without spaces). The category name is joined with the name of the source table. It contains the list of categories that can be changed. I strongly recommend to do backup copy of your Eating diary file before any change in categories. So I enter this into the database.Ĭrusty Croc Chips: 30 g (grams), Calories: 158, Carbohydrates: 1.7, Proteins: 14, Fats: 10, Fiber: 1.2 On the back side of the bag is a table with nutrition. You can use any number.įor example, I bought a bag of chips and eat 150 grams. You can use cups, fl oz, gram, ml or whatever you need, it is up to you. The basic unit does not to be exactly 1 oz. Now you can use Peanuts in the Eating diary.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.

#FREE PRINTABLE CALORIE COUNTER TRACKER 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. This file will help you track what you eat.

Free printable calorie counter tracker