- #My daily calorie tracker professional
- #My daily calorie tracker free
Next, follow the steps below, to sort the list - otherwise the Food Entry drop downs won't work correctly
Type the number of calories in 1 serving, then press Enter. Type the measure for 1 serving of the food item, such as 1 piece or 15 ml, then press Tab. Type the name of the new food item, then press Tab. The table will automatically expand to include the new item's row Press Tab, to go to the cell to the right. In the first blank row below the table, type a category name, such as Vegetables. Scroll down to the end of the food list table. To add a new food item, follow these steps: You can add new foods to the FoodList table, or edit the existing food items. In the Calorie Counter with Recipe Calculator sample file, there are 9 columns with food information - Category, Food Item, Measure, Calories, Protein, Fat, Carbs and Fibre (you can change the spelling to Fiber, if you prefer!) In the basic version of the Calorie Counter workbook, there are 5 columns with food information - Category, Food Item, Measure and Calories To see the built-in list of foods and their calories, go to the FoodList sheet. The other has an Excel table with orange formatting. One has an Excel table with green formatting. NOTE: In the workbook for 2 people, there are 2 DailyRecord sheets, with colour coding. The dates are stored in column A, which is not shown Here is a screen shot of stored records on the DailyRecord sheet. Refreshes the pivot table report on the FoodPivot sheet. Clears the green cells on the FoodEntry sheet (Date and food data), so you can start fresh the next day. Adds the entry date in column A for each row that was pasted. Pastes the food entries onto the DailyRecord sheet, below any previous entries. Copies all the food entries from the green cells. Checks cell B2, and shows a message if no date was entered. That button runs a macro, named AddData, to save the food data, and clear the green cells. Or, type a different number, such as 0.5 or 1.5, if you are eating more or less than a single serving size.Īfter you enter a quantity, the Calories column will automatically show the total calories in your serving of the selected food item.Īt the end of each day, click the "Save Daily Data and Clear" button, at the top of the FoodEntry sheet. Type a 1 in the Qty column, if you are eating a single serving of that size. In the example shown below, the measure is 175 mL (about 6 oz). The drop down list limits the food item selections, based on the Category selected in each row.įinally, enter the number of servings that you ate, based on the single serving amount that appears in the Measure column. The drop down list was created with dependent data validation. In the Food Item column, click the drop down arrow, then select one of the foods from that list. Then, in the next column, use the drop down list to select a food category. Next, select the meal type (Breakfast/Lunch/Dinner/Snack) #My daily calorie tracker professional
One has green cells for data entry, and the other has orange cells for data entry.Įach day, enter the date, and the target calories that your medial professional recommends as your daily calorie intake. NOTE: In the workbook for 2 people, there are 2 FoodEntry sheets.Follow these steps each day, to track your calories. (pdf files with restaurant foods at bottom of page).
#My daily calorie tracker free
(sign-up is required, free membership available).(type a food in the search box at top right).If you're looking for more nutrient information, to add items to the food list, you can try these websites: Check food product labels for accurate nutrition numbers. Target Calories: Check with your medical professional for advice on your target calories.įood Data: Most of the food data was obtained from Health Canada, so the ingredients and calorie counts might be different where you live. I am not a medical professional, so use this workbook for entertainment purposes only, or in consultation with a medical professional. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protein, fibre and fat per serving.Īfter you calculate the recipe's nutrients, you can add that as an item in the workbook's food list. There is also an enhanced Calorie Counter workbook that contains a recipe calculator. Use the basic Calorie Counter spreadsheet to keep track of the food that you eat each day, and the nutrients that the food contains. Get the Calorie Counter Excel Calorie Counter Intro
0 kommentar(er)
