![]() 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. To even further help you keep a healthy lifestyle, the template also comes with Tips.įurthermore, the template automatically generates charts so you can have a visual data to help you analyze your nutrition, diet, exercise and weight loss.On Monday I described the horrible side effects of Christmas cookies, and posted an Excel Weight Loss Tracker workbook. Another feature of this template is the Recipe that lets you create healthy recipes for yourself and your family. This Weight Log can help you see if you are rapidly gaining or losing weight, or are fluctuating over a period of time. You can also keep track of your weight using this nutrition tracking database. Meanwhile, the Food Log allows you to record the Date, Food Eaten, Number of Servings, Type of Meal and Description. In the Exercise Log, you can input your daily workout activities according to Date, Exercise Category, Exercise Sub Category, Time Spent, Calories, and Details. This information are reflected from your Exercise Log and Food Log from the Tables Tab. Meanwhile, you open the template with Today’s Report, a form that shows basically the food that you have eaten and the calories you have burned. This Access Template contains tabs for Tables, Queries, Forms and Macros, which can all be found on the convenient Navigation Pane. This database template allows you to record and track your workout and physical activities, as well as what you eat. This Desktop Nutrition Tracking Database Template for Access 2013 is a professionally designed template that can help you be on the right track when it comes to health and fitness. So whether you are a nutritionist, dietitian, personal trainer, personal chef, or you just want to track nutrition intake for a healthier lifestyle, you can find this template very helpful.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |