![]() When you select a food item, the cell to the right finds the serving size, in the named range, FoodLU.īelow that, another formula finds the Calories per Serving ![]() The second MATCH function finds the table column that the weight is on, in the Activity table headings.The first MATCH function finds the table row that the Activity name is on, in the list of activity names.That's a named range which contains all the Calories Burned values, from the Activity list. The INDEX function will return a value from the ActivityLU range.=INDEX(ActivityLU, MATCH(D6,ActivityList,0), MATCH(D4,WeightList,0)) When you select an activity, the cell to the right finds the calories burned per minute, in the Activity chart. On the Calculator sheet, there are formulas that pull data from the lookup tables, and calculate the calories and time to burn calories. In a cell to the right, formulas show calories per serving for the selected food item, and the total calories.Īt the bottom of the calculator, you can see the amount of time, in hours and in minutes, that it will take to burn those calories, with the selected activity. Finally, enter the number of servings that you'll eat, using whole numbers, or decimals.įor example, if you plan to each 30 fries, and the serving size is 20-25 fries, enter 1.5 in the Servings cell.In a cell to the right, a formula shows the serving size for the selected food item. Next, select a food from the drop down list.In a cell to the right, a formula shows the calories burned per minute for that activity, based on your approximate weight. Next, select an activity from the drop down list.There are only 6 weights in the list, so pick the closest one. First, select your approximate weight from the drop down list.To use the Calorie Burn Calculator, go to the Calculator sheet. Do not change the weights in that list - they have to match the headings in the Activities chart. NOTE: The weights are also listed in a named table on the Admin_Lists sheet. Your exact weight probably won't appear in those headings, so you'll use the weight that's closest to your actual weight. In the Activity chart, there are weights in the headings for columns B:G, shown in pounds. Your physician might be able to provide a list, and there are government lists at these links: The Activities chart is in a named Excel table, on the Activities sheet, and you can add more items to this list. I can only find a very short list on that site now. This data came from a Virginia state government publication, that is no longer available. The chart shows calories burned per minute, for six sample weights The calorie burn calculator workbook contains a chart of activity calories. The Food List is in a named Excel table, on the FoodList sheet, and you can add more items to this list.īe sure to check package labels for accurate calore counts of any foods that you eat. This data comes from a booklet that you can download from the Health Canada (government) website. The calorie burn calculator workbook contains a list of food items, with a serving size, and the number of calories in that serving. Consult your physician for diet and exercise advice.Check package labels for accurate calorie counts. ![]() ![]() The food and calorie burner data is provided as an example only.WARNING: The Excel calorie burn calculator workbook does not provide medical advice or information. Select a weight range, choose a food item and an activity, and the calculator will show you the estimated time, in minutes or hours. Use the Excel calorie burn calculator workbook to see how long it takes to burn calories.k. Download the Workbook Excel Calorie Burn Intro ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |