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. As soon as Bill sends me something better, I’ll let you know. Can’t Microsoft invent something to make weight loss easier? I don’t even care if it has menus or a Ribbon! Excel Calorie Counter Food Dataīill Gates isn’t answering my phone calls, so I created an Excel Calorie Counter that I can use in the meantime. Apparently it takes a bit of effort, including dietary changes and maybe some exercise. Now, here is an Excel Calorie Counter to add to your tool kit.Īs Dick Kusleika pointed out in the comments for the Weight Loss Tracker, simply downloading the workbook doesn’t have any effect on your weight. On Monday I described the horrible side effects of Christmas cookies, and posted an Excel Weight Loss Tracker workbook.
0 kommentar(er)
