4/16/2024 0 Comments Excel calorie tracker template![]() Copy the revised formula down to the last row, and right, to the last column.Īlso, see below, for adding more columns to the Calorie Counter Data.With one additional column, you would change that to $B$1:$E$1 In the sample file, the headings are in $B$1:$D$1. Select cell G5, and change the formula, so it includes the heading cells for all the columns in your food lookup table.The heading cells should automatically fill in, based on the headings on the Food Lookup table.Select cells G4:G26, and drag to the right, creating an extra column for each of your new columns.On the FoodEntry sheet, insert extra columns to the right of column G.If you added more columns to the lookup table, such as fat or carbs, you’ll also need to add those columns to the Daily Calorie Counter sheet. The Daily Calorie Counter in the sample file only has calories listed. Add More Columns to the Daily Calorie Counter Or, add the food item to the lookup table on the FoodList worksheet. NOTE: If you can’t find a specific food, just type it in the cell, and enter the calorie count manually. Once the quantity is entered, the total calories for that food item are calculated. For example, if the measurement is 125mL, and you ate 250mL, type 2 as the quantity. Otherwise, the wrong items might appear in the Food Item drop down list.Īfter you select a food item, its measurement appears, and you can enter the quantity that you ate, based on that measurement. This list comes from the FoodList sheet, so it’s important to keep the FoodList sheet sorted by category. There’s a dependent data validation drop down list in the Food Item column, based on the Category that you select. The Meal/Snack and Category source lists are stored in named ranges on the Lists sheet. In the green data entry cells, there are drop down lists, created with Excel’s data validation. There are only 22 rows for data entry, so that should help limit your food intake! In the main sheet, named FoodEntry, you can enter the date, your target calorie count, and all the foods that you eat. Click the check mark at the left, to confirm the change, and click CloseĪlso, see below, for adding more columns to the Daily Calorie Counter The Daily Calorie Counter.In the Refers To box, at the bottom, change the number of columns, from 3, to the number of columns in your revised table.In the list of names, click on FoodLookup.In Excel 2007, click the Formulas tab, and click Name Manager (In Excel 2003, click Insert | Name | Define).If you want to add more columns to the lookup table, such as fat or carbs, you’ll also need to change the named range for the lookup table. ![]() ![]() The food lookup table in the sample file only has calories list. The CONVERT function calculates the amount in the adjacent white cell.Īdd More Columns to the Food Lookup Table There’s also a table where you can do your own conversions, by typing a number in the green cells. The measurements are metric, so I added an approximate conversion list too, in case you don’t speak metric. You can add items to the list, and sort the list by category when you’re finished adding food items. I created a list of foods in an Excel workbook, with categories, food items, measurements and calorie counts. To start, I copied some food data from the Health Canada website. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |