Get this free Excel calorie burn calculator workbook. Select a weight range, choose a food item and an activity, and see how long it takes to burn those calories.
Use the Excel calorie burn calculator workbook to see how long it takes to burn calories.k. Select a weight range, choose a food item and an activity, and the calculator will show you the estimated time, in minutes or hours.
WARNING: The Excel calorie burn calculator workbook does not provide medical advice or information.
The calorie burn calculator workbook contains a list of food items, with a serving size, and the number of calories in that serving. This data comes from a booklet that you can download from the Health Canada (government) website.
The Food List is in a named Excel table, on the FoodList sheet, and you can add more items to this list.
Be sure to check package labels for accurate calore counts of any foods that you eat.
The calorie burn calculator workbook contains a chart of activity calories. The chart shows calories burned per minute, for six sample weights
This data came from a Virginia state government publication, that is no longer available. I can only find a very short list on that site now.
The Activities chart is in a named Excel table, on the Activities sheet, and you can add more items to this list. Your physician might be able to provide a list, and there are government lists at these links:
In the Activity chart, there are weights in the headings for columns B:G, shown in pounds.
Your exact weight probably won't appear in those headings, so you'll use the weight that's closest to your actual weight.
NOTE: The weights are also listed in a named table on the Admin_Lists sheet. Do not change the weights in that list -- they have to match the headings in the Activities chart.
To use the Calorie Burn Calculator, go to the Calculator sheet.
In a cell to the right, a formula shows the calories burned per minute for that activity, based on your approximate weight.
In a cell to the right, a formula shows the serving size for the selected food item.
For 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, formulas show calories per serving for the selected food item, and the total calories.
At 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.
On the Calculator sheet, there are formulas that pull data from the lookup tables, and calculate the calories and time to burn calories.
When you select an activity, the cell to the right finds the calories burned per minute, in the Activity chart.
=INDEX(ActivityLU, MATCH(D6,ActivityList,0), MATCH(D4,WeightList,0))
When you select a food item, the cell to the right finds the serving size, in the named range, FoodLU.
Below that, another formula finds the Calories per Serving
The FoodLU range is based on the Food List table, without the heading cells. The serving size is pulled from column 2 in that named range, and the Calories are pulled from column 3..
NOTE: You could also use and INDEX/MATCH formula for these lookups.
Below the Calories Per Serving, another formula calculates the total calories, by multiplying the number of servings by the calories per serving.
Finally, at the bottom of the Calculator, formulas calculate the time to burn the calories.
This formula calculates the minutes:
Then that number is divided by 60, to calculate the hours:
Download the Calorie Burn Calculator workbook, and other related Excel workbooks, for health and fitness tracking
Last updated: August 14, 2019 4:06 PM