Spreadsheet for BMR/TDEE Deficit calc, Macro calc, HRM
Options
Replies
-
Awesome, and thanks0
-
Also on BLOG:
http://www.myfitnesspal.com/blog/heybales?month=201207
After observing so many desiring to increase their calories to get out of a stall, but the confusion over different BMR values found, different TDEE calculators doing things different ways, desires to still eat back exercise calories and basically use MFP but tweak it, I wanted a spreadsheet with everything in one place.
I could never find a site that really had everything in one place, though some came close. If I could do web page coding, I could have done it there. But I think there is something to be said for a spreadsheet you can download as Excel or into your own Google account, and keep your figures for future reference and changes, which a web page can't give you.
So this Spreadsheet is hopefully self-explanatory if you have seen any of the discussions regarding TDEE and deficits (Roadmap from helloitsdan, EM2WL group, ect), and BMR, ect. It is not totally meant as educational, which you can get elsewhere.
I'm hopefully done tweaking, as I got suggestions from my friends list and the first version was out for awhile, but let me know if something lacking or wrong. Which means check back for updates compared to your saved version. The date is there.
The sheet mentions the fact you can copy it to your own Google account, or download it as Excel, and most the formatting looks correct, the math is the same. The one that is there is locked of course so no accidental changes.
Hope you can find it useful.
https://docs.google.com/spreadsheet/ccc?key=0Amt7QBR9-c6MdGVTbGswLUUzUHNVVUlNSW9wZWloeUE
Great idea..and lots of hard work went into this...so kudos.
Just FYI - Most current data show that your RMR not only changes as you lose weight, and slows as you diet, but that it doesn't increase when you exercise, nor is it what the typical formulas suggest - it's lower.
Therefore your typical calorie burns will not have the amount or effect you expect them too...but less.
A recent article referred to just this and provides a model for a new calculator other than the typical Mifflin-St. Joer which predicts how many cals you need to maintain a setpoint - ie if you weren't dieting.
I'll give the link below to the article which contains a link to the calculator. Getting a Metabolic Cart and measurement of your RMR is the most accurate for your current weight and would have to be redone after losing significantly more weight.
Bottom line - you don't necessarily want to eat back all your calories that you exercise off..or eat all the calories MFP tells you that you can. Do what works for you..but be aware of the facts as you do.
http://well.blogs.nytimes.com/2012/08/01/dieting-vs-exercise-for-weight-loss/
http://www.pbrc.edu/research-and-faculty/calculators/weight-loss-predictor//0 -
Thanks!0
-
bump for later use0
-
Wow!! Thank you!0
-
bump0
-
Thank you! This is great! Now i know why i'm not losing and what i need to do!
My BMR is just over 1200, and my TDEE at 1400! Very little space for a good deficit! lol
Very informative tho x0 -
Great idea..and lots of hard work went into this...so kudos.
Just FYI - Most current data show that your RMR not only changes as you lose weight, and slows as you diet, but that it doesn't increase when you exercise, nor is it what the typical formulas suggest - it's lower.
Therefore your typical calorie burns will not have the amount or effect you expect them too...but less.
A recent article referred to just this and provides a model for a new calculator other than the typical Mifflin-St. Joer which predicts how many cals you need to maintain a setpoint - ie if you weren't dieting.
I'll give the link below to the article which contains a link to the calculator. Getting a Metabolic Cart and measurement of your RMR is the most accurate for your current weight and would have to be redone after losing significantly more weight.
Bottom line - you don't necessarily want to eat back all your calories that you exercise off..or eat all the calories MFP tells you that you can. Do what works for you..but be aware of the facts as you do.
http://well.blogs.nytimes.com/2012/08/01/dieting-vs-exercise-for-weight-loss/
http://www.pbrc.edu/research-and-faculty/calculators/weight-loss-predictor//
Correct on RMR on couple points.
As weight is loss, it lowers, along with BMR of course. Hence need to update stats.
As you exercise and become a more efficient system, it lowers. Hence TDEE estimate of calories is very minor, like 100-150 / hr.
If you take too big a deficit especially with exercise it lowers more, as body conserves other movements to conserve limited energy. Hence need to take a reasonable deficit.
The RMR measurement can be great, and if you wait until you've done a decent amount of cardio and had improvement, not likely to see much more efficiency added, only the slowing with weight loss.
So multiplier from weight stays about the same, unless you massively lose or gain muscle, or undereat too bad and cause slowdown.
And the TDEE deficit method takes care of exactly your concern over calories.
Actually, if you followed MFP method to the letter, and their calorie burn estimates, you'd probably be saved.
You'd likely be given a goal too low if just done by itself with no exercise.
But you exercise and calorie burn is inflated, so you properly eat back those calories, and increase yourself to a more reasonable deficit on workout days.
This also causes automatic calorie cycling.
Some of the desires to improve things actually make it worse. Using HRM for accurate burn data, and then only eating some of it back - coupled with a still too low of a goal for your activity level.
At the bottom of the TDEE calculator section, you'll see how many calories per hr is estimated for your stats there. Probably no where near what you actually burn per hour.
Nice info though, and taken care of in the TDEE deficit method.0 -
Thank you! This is great! Now i know why i'm not losing and what i need to do!
My BMR is just over 1200, and my TDEE at 1400! Very little space for a good deficit! lol
Very informative tho x
That's true, if you don't exercise, little movement for a deficit.
Because that is less than sedentary actually - might confirm the stats are entered correctly. Because 1200 BMR would give 1440 TDEE if no exercise.0 -
Thank you!0
-
bump to download later...Tks0
-
this is awesome, bumping for download later when I get home0
-
I love spreadsheets - and this one is awesome! Thanks!0
-
heybales, you helped me set my calories up about 2 or 3 weeks ago. I haven't gained or lost anything yet. But, this morning it looked like I had lost a little less than a lb. So, I am still hopeful its going to work for me..
I really appreciated your help!! I'm so close to my goal any weight loss will be slow I guess....0 -
Bump:)0
-
heybales, you helped me set my calories up about 2 or 3 weeks ago. I haven't gained or lost anything yet. But, this morning it looked like I had lost a little less than a lb. So, I am still hopeful its going to work for me..
I really appreciated your help!! I'm so close to my goal any weight loss will be slow I guess....
Make sure you are measuring in many spots. You may be losing more than weight. Inches counts big time too.0 -
Great info!!!!!0
-
BUMP!0
-
bump0
-
heybales, you helped me set my calories up about 2 or 3 weeks ago. I haven't gained or lost anything yet. But, this morning it looked like I had lost a little less than a lb. So, I am still hopeful its going to work for me..
I really appreciated your help!! I'm so close to my goal any weight loss will be slow I guess....
Make sure you are measuring in many spots. You may be losing more than weight. Inches counts big time too.
Thank You I will!!0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 391.9K Introduce Yourself
- 43.5K Getting Started
- 259.8K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.3K Recipes
- 232.3K Fitness and Exercise
- 399 Sleep, Mindfulness and Overall Wellness
- 6.4K Goal: Maintaining Weight
- 8.5K Goal: Gaining Weight and Body Building
- 152.8K Motivation and Support
- 7.9K Challenges
- 1.3K Debate Club
- 96.3K Chit-Chat
- 2.5K Fun and Games
- 3.4K MyFitnessPal Information
- 23 News and Announcements
- 980 Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions