Spreadsheet for BMR/TDEE Deficit calc, Macro calc, HRM
Options
Replies
-
WOW. . . there are several TDEE spreadsheets floating around the discussion boards but this is the first one that i understand.
Thanks for all your work on this! It's very helpful :flowerforyou:0 -
Bump0
-
Bumping for later.....0
-
I've been tinkering with this spreadsheet more and more and I must say that this is brilliant! I'm extremely big into spreadsheets and never actually thought to make one with calculations such as this!
Thank you so much!0 -
bump!0
-
Bump....Thanks for sharing!!!0
-
:bump:0
-
bump, and thanks0
-
bump Thank you for doing this!!!0
-
I've been tinkering with this spreadsheet more and more and I must say that this is brilliant! I'm extremely big into spreadsheets and never actually thought to make one with calculations such as this!
Thank you so much!
There is a reason why I dropped assembly language programming in high school - obsessive was word used.
Still comes out sometimes, but this is shorter specific focus, so not so bad. Oh wait, I just thought of something!0 -
thanks for doing this!0
-
WOW. . . there are several TDEE spreadsheets floating around the discussion boards but this is the first one that i understand.
Thanks for all your work on this! It's very helpful :flowerforyou:
It was comments on some of those others that I used as improvements to this one.
And seeing how folks got confused on some website calculators that are not clear.0 -
To clear up confusion in my own head: using the spreadsheet and the average BF% given by gymgoal I would need to INCREASE my daily intake compared to what MFP recommends? Does this sound right? Is this to prevent plateaus?
Katch gives me BMR of 1620 whereas if I tell MFP to guide me it says I should net 1480, based on current figures and desire to lose 1 1/2 per week? I have been on the site 4 weeks so far and have actually lost about 2.6 kgs (regardless of ticker).
Disclaimer - I have very high BF% (not sure if this affects things)!
Thanks for the tools and the input!0 -
To clear up confusion in my own head: using the spreadsheet and the average BF% given by gymgoal I would need to INCREASE my daily intake compared to what MFP recommends? Does this sound right? Is this to prevent plateaus?
Katch gives me BMR of 1620 whereas if I tell MFP to guide me it says I should net 1480, based on current figures and desire to lose 1 1/2 per week? I have been on the site 4 weeks so far and have actually lost about 2.6 kgs (regardless of ticker).
Disclaimer - I have very high BF% (not sure if this affects things)!
Thanks for the tools and the input!
Your BMR is not the same thing as your calorie target for the day; BMR is just one step along the way of figuring that out. The specifics are different for every person, but the basic idea is:
1) Figure out your BMR (we'll use 1620 for you).
2) Estimate the number of calories you're burning beyond your BMR in a day. Some people just multiply their BMR by a certain number based on activity level, some try to add up the estimated calorie burn of specific activities, or a combination of the two. For this example, I'm just going to assume a Sedentary activity level (desk job) with no exercise, for a multiplier of roughly 1.2. That brings our estimated calorie burn from 1620 to 1944.
3) Now you need to select a reasonable calorie deficit. A deficit of 500 calories per day should lose an average of 1 pound per week (though it's almost never that consistent, in my experience, but it works out over time). So your target in this example would be 1444 (1944 - 500). There are many people who will tell you never to eat less than your BMR, but that's not really important for what I'm explaining at the moment. Just going through the process of picking a calorie target.
Sounds like MFP is estimating your calorie burn to be higher than what I just made up, since you're targeting 1.5 pounds per week. That would mean your TDEE (total calorie burn for the day) is 2230.0 -
Thanks0
-
bump0
-
bump for later0
-
1) Figure out your BMR (we'll use 1620 for you).
....
3) .... There are many people who will tell you never to eat less than your BMR, but that's not really important for what I'm explaining at the moment.
This IS the bit that's got me confused at the moment - whether one should or shouldn't be eating below BMR.
My lifestyle (job) is pretty sedentary other than when I exercise so the exercise calories are separate and monitored on a HRM. (Approx 2400 cals a week).
I have lost in the few weeks I've been here but not necessarily at the targeted rate so I'm looking to "tweak" things.0 -
bump for later0
-
bumping for later!0
This discussion has been closed.
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392K Introduce Yourself
- 43.6K Getting Started
- 259.8K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.4K Recipes
- 232.3K Fitness and Exercise
- 402 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
- 998 Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions