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

124»

Replies

  • Booksandbeaches
    Booksandbeaches 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:
  • sphira
    sphira Posts: 132 Member
    Bump
  • dantb32
    dantb32 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.
  • minizebu
    minizebu 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.
  • angefit2014
    angefit2014 Posts: 1
    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...
  • charliehefferon
    charliehefferon Posts: 223 Member
    Bump for reading later!! I LOVE SPREADSHEETS!!!! :glasses: :glasses: :glasses:
  • Aries03
    Aries03 Posts: 179 Member
    Bump
  • AmyBinthe603
    AmyBinthe603 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:
  • gordan1972
    gordan1972 Posts: 22 Member
    Grat work nelinelineli
  • bigboyhealth
    bigboyhealth Posts: 6
    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?
  • Buddhasmiracle
    Buddhasmiracle Posts: 925 Member
    bump, and thank you!
  • BeckyMBisMe
    BeckyMBisMe Posts: 215 Member
    bump, heading to work, will look for this again this evening.
  • GertrudeHorse
    GertrudeHorse 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!
  • Unknown
    Unknown
    This content has been removed.
  • Blokeypoo
    Blokeypoo 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:
  • OverDoIt
    OverDoIt Posts: 332 Member
    Bravo !
  • johnthomasmoore
    johnthomasmoore 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.
  • 1Cor1510
    1Cor1510 Posts: 413 Member
    Bump

Categories