Get this free Excel calorie counter workbook. Choose from the list of foods, and add your favourite foods, and their nutrition information. Get the basic version, or the recipe calculator version.
Use the basic Calorie Counter workbook to keep track of the food that you eat, and the nutrients that it contains.
There is also an advanced Calorie Counter workbook that contains a recipe calculator. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protien, fibre and fat per serving. After you calculate the recipe's nutrients, you can add that as an item in the workbook's food list.
The main sheet is named FoodEntry. Each day, enter the date, and your target calories.
Then, select the time (Breakfast/Lunch/Dinner/Snack) and the food category.
In the Food Item column, select one of the foods from that category. Dependent data validiation is used here, to limit the selections, based on the choice in Category column.
Finally, enter the quantity that you are eating, based on the amount that appears in the Measure column. In this example, the amount is 175 mL (about 6 oz).
Type a 1 in the Qty column, if you are eating a serving of that size. Or, type a different number, such as 0.5 or 1.5, if you are eating more or less than that.
After you enter a quantity, the Calories column will show the total calories in your serving.
At the end of each day, click the "Save Daily Data and Clear" button, at the top of the FoodEntry sheet.
That clears the green cells on the FoodEntry sheet, so you can start fresh the next day.
All the food data is pasted onto the DailyRecord sheet, below any previous entries.
To see the stored list of foods and their calories, go to the FoodList sheet. You can add new foods, or edit the existing foods.
IMPORTANT: After you make changes, be sure to sort the list again, by Category and Food Item.
The list must be sorted, or the dependent drop down list on the FoodEntry sheet will not work correctly.
On the FoodPivot sheet, you can see a pivot table that summarizes the stored food data.
Excel Calorie Counter -- Download the basic Excel Calorie Counter workbook. The zipped file is in xlsm format and contains macros. Enable macros when you open the file, so the Save Data button will work correctly. ExcelCalorieCounter2007.zip
Excel Calorie Counter With Recipe Calculator: Same features as basic Excel Calorie Counter, plus a Recipe Calculator --calculate nutrients per serving in your favourite recipes, and add those to the Food List. The zipped file is in xlsm format and contains macros. Enable macros when you open the file, so the Save Data button will work correctly. ExcelCalorieCounter2007Recipe.zip
Last updated: May 22, 2017 10:20 AM