#FOOD TRACKER AND CALORIE COUNTER HOW TO#
#FOOD TRACKER AND CALORIE COUNTER FREE#

When I reopen the file, I’m getting a repaired error notification, which requires the file to be saved to a new name. I autosave my file every 2 min, and save it after finishing some work.

#FOOD TRACKER AND CALORIE COUNTER FREE#

– removed sheets protection – feel free to do any updates or changes you want 🙂 – repaired formulas in eating_diary_clear.xlsx

#FOOD TRACKER AND CALORIE COUNTER HOW TO#

– added new videos: How to change the category name, How to add the new category Version with sample data: eating_diary.xslxĬlear version: eating_diary_clear.xlsx Edit. In this example, I will create the new category called CategoryName 🙂 As in the previous, it doesn’t matter of the sheet name. Only the source table and the item in Type sheet is important. As you see, it doesn’t matter of the sheet name. 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. 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.

Food tracker and calorie counter