For the nerds in you! TDEE estimation, with graphs :)

124»

Replies

  • Posts: 1,791 Member
    Here I thought I was a geek! This is a great post. I'm posting, so I can find it again.:flowerforyou:
  • Posts: 132 Member
    Bump
  • Posts: 8 Member
    Love this stuff. I worry I could get obsessed with the numbers though. I guess there's worse things to be obsessed with.
  • Posts: 2,716 Member
    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.
  • 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...
  • Posts: 223 Member
    Bump for reading later!! I LOVE SPREADSHEETS!!!! :glasses: :glasses: :glasses:
  • Posts: 179 Member
    Bump
  • Posts: 16 Member
    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 !!??:smile::smile:
  • Posts: 22 Member
    Grat work nelinelineli
  • 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?
  • Posts: 925 Member
    bump, and thank you!
  • Posts: 215 Member
    bump, heading to work, will look for this again this evening.
  • Posts: 646 Member
    This might be a dumb question, but hopefully someone can help me understand. In your description of "net calories corrected" you say it is subtracting the BMR for exercise duration, but the formula has an addition sign which makes the "net calories corrected" end up higher than "net calories"...surely they should be lower?

    BTW, I am absolutely loving this spreadsheet and the general level of geekery in this post. Statistics FTW!
  • This content has been removed.
  • Posts: 274 Member
    Oooh, I'm a research nurse so this makes me want to lick my computer screen!

    Coming back later to read properly :love:
  • Posts: 332 Member
    Bravo !
  • Posts: 59 Member
    Majorly cool. I'll study in more detail. I pull my food, activity, weight data together in Google Spreadsheets from Fitbit automatically. Check my blog at http://johntmoore.blogspot.com/. Also use TrendWeight. Thanks for sharing.
  • Posts: 413 Member
    Bump

Welcome!

It looks like you're new here. Sign in or register to get started.