For the nerds in you! TDEE estimation, with graphs :)
Options
Replies
-
I love this post.0
-
wow...impressive!0
-
I love it.0
-
wow!! that's really cool! very informative I'm impressed! thanks!0
-
bump0
-
bump0
-
bump to try to figure this out later...this is going to take more brain power than I have access to right now.0
-
Bump!0
-
Love it! I'd really like to adapt this for my own use, but need some help. Now for us data idiots--how do you change to inches/pounds. (pretend you're explaining it to a 5 year old!) And what else would I need to change besides starting date, weight and age?0
-
Love it! I'd really like to adapt this for my own use, but need some help. Now for us data idiots--how do you change to inches/pounds. (pretend you're explaining it to a 5 year old!) And what else would I need to change besides starting date, weight and age?
To change to pounds you can just copy the formula for BMR in pounds (that's on the right side of the spreadsheet) and paste it in the first cell of the BMR column and then drag the cell down till the end of the column (to replace the old formula that's in kg). You need to change the dates, age, height, daily weigh-ins, calories in, calories from exercise and exercise duration for each day.0 -
Here I thought I was a geek! This is a great post. I'm posting, so I can find it again.:flowerforyou:0
-
Bump0
-
Love this stuff. I worry I could get obsessed with the numbers though. I guess there's worse things to be obsessed with.0
-
Bumping to fully digest later. (And, I thought that I was all geeky and nerdy with my spreadsheets. LOL!)
Very Cool! Thank you for sharing this with us, O.P.0 -
Hi OP are you still around?
Could you share how you posted your graphs?
Can't seem to get any to load...
Thanks - and great thread...0 -
Bump for reading later!! I LOVE SPREADSHEETS!!!! :glasses: :glasses: :glasses:0
-
Bump0
-
wow. This is amazing.. I sent the link to myself at work so when I'm bored later I can spend more time on this! Amazing!
Isn't excel just the best thing !!??0 -
Grat work nelinelineli0
-
I do something similar. There is one point I'd like to hear your thoughts on. I personally believe the 3500 calories to 1 pound or 7700 calories to 1 kilogram is too oversimplified because some percentage of your weight loss will be muscle loss. Depending on the calorie deficit you are using and the types of exercise you are doing, the amount of muscle loss could be anywhere from 8% to 30% - which is quite a large range. Any thoughts on how you could incorporate that into your graphs for more accurate predicted theoretical weight loss?0
Categories
- All Categories
- 1.4M Health, Wellness and Goals
- 392.1K Introduce Yourself
- 43.6K Getting Started
- 259.9K Health and Weight Loss
- 175.7K Food and Nutrition
- 47.4K Recipes
- 232.3K Fitness and Exercise
- 403 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
- 999 Feature Suggestions and Ideas
- 2.4K MyFitnessPal Tech Support Questions