Excel Calorie Burning Calculator
Good work! You’ve stopped eating cookies, and you’re recording your daily food intake in the Excel Calorie Counter. The pounds are magically melting away, and you’re keeping track of your weight loss.
Here’s one more tool to help you with your healthy living plans – the Excel Calorie Burning Calculator. There’s a download link at the end of this article.
The Food Calories List
The Excel Calorie Burning Calculator has a condensed version of the food list from the Excel Calorie Counter. The list shows food items with their serving size and number of calories. Hmmm…3 slices of bacon aren’t much worse than one banana, at least calorie-wise! That’s good to know.
The Activity Calorie Burning List
If you believe the scientists, you can burn some of those consumed calories by moving around a bit. Or a lot. And apparently, the bigger you are, the more calories that you burn per minute. Yes, some fat guy working in his garden burns more calories than the slim guy who’s hiking. No, that doesn’t seem fair, but it’s hard to argue with the laws of science.
Anyway, the smaller you get, the harder you’ll have to work. But you’ll probably feel better.
The Calorie Burning Calculator
On the main sheet in the workbook, you select your weight range from the data validation drop down list.
Next, choose an activity. A VLOOKUP formula, with MATCH, finds the calories burned per minute for your selected weight.
Then, select a food that you plan to eat, and see approximately how many minutes it will take to burn off the calories.
For example, that 200 pound guy will have to walk for about 38 minutes after he eats one slice of pizza. Instead of phoning for delivery, he should walk to the pizza shop and back.
However, his 160 pound friend will have to walk for about 53 minutes to burn off his slice. And the really bad news is that it would take him almost 2 hours to burn off the pizza slice, if he eats it while sitting at his desk.
I don’t have that kind of time, so my plan is to have a glass of wine, and then just sleep the calories off! I’m always thinking. ;-)
Download the Excel Calorie Burning Calculator
You can download a zipped copy of the sample Excel Calorie Burning Calculator, to calculate your own food intake and activities. The file is in Excel 2007 format, with no macros. If you’re using an older version of Excel, you can download a zipped copy of the sample Excel 2003 Calorie Burning Calculator.
As I mentioned before, I’m not a medical professional, so use this workbook for entertainment only. The calorie counts are from Health Canada, so the ingredients and calorie counts might be different where you live. Check the product labels for accurate numbers.
The activity calorie counts are from the Virginia Department of Human Resource Management, and provide estimates for different weight ranges and activity intensity levels. Your mileage, or “caloriage”, may vary.