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

24

Replies

  • Hildy_J
    Hildy_J Posts: 1,050 Member
    Impressive. Really impressive!

    Thanks for posting. :smile:
  • Buddhasmiracle
    Buddhasmiracle Posts: 925 Member
    Bump squared
  • mumblemagic
    mumblemagic Posts: 1,090 Member
    As many people mentioned before, there are very good tools such as trendweight and libra which you could use to visualize your weight trend!

    All you have to do is enter daily weigh-ins and it will calculate stuff for you, make a nice, pretty plot:P

    True, however, getting one's nerd on and having the equations behind the tool is so much fun! (If you are that way inclined of course. I am, others might not be and there's nothing wrong with that :smile: ).
  • MicheleStitches
    MicheleStitches Posts: 306 Member
    You are the best! I LOVE math! :flowerforyou:
  • Mr_Knight
    Mr_Knight Posts: 9,532 Member
    Good stuff, thank you for sharing! My TDEE coefficient comes in at a steady 150%.
  • Mr_Knight
    Mr_Knight Posts: 9,532 Member
    I added another constant - "Burn Coeff". The reason is that I'm showing a 150% TDEE, which is not consistent with my actual lifestyle. By having a knob for exercise calories, I can dial in the appropriate TDEE coefficient.

    The good news is that it appears I've been underestimating my burn, especially for the last 2 months, by about 20%. So TDEE coeff of 135% and a Burn Coeff of 120%.
  • wild_wild_life
    wild_wild_life Posts: 1,334 Member
    Awesome. How much would you charge to do mine? :smile:

    I could write you a haiku in exchange.
  • cad39too
    cad39too Posts: 874 Member
    Wow :)
  • cr1111dn
    cr1111dn Posts: 13 Member
    This is so great! Love the idea of daily weigh-ins to help understanding the process! Knowledge is power :)
  • LilchookNZ
    LilchookNZ Posts: 66
    Bump for later - give my heap some wrapping time :)
  • fivethreeone
    fivethreeone Posts: 8,196 Member
    amazing. tagging.
  • Hauntinglyfit
    Hauntinglyfit Posts: 5,537 Member
    Will you do my homework for me?
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Very nice.

    If you are interested in extracting the data automatically see http://www.myfitnesspal.com/topics/show/1122752-export-and-analyze-your-own-data-in-excel
  • MagicalLeopleurodon
    MagicalLeopleurodon Posts: 623 Member
    I did the happy seal clap over this
  • juniperfox
    juniperfox Posts: 127 Member
    I really appreciate your taking the time to share this! Not just results, but methods! I can't wait to get home and start a sheet of my own. Do you mind if I message you in case I have questions?
  • Spartan_1_1_7
    Spartan_1_1_7 Posts: 132 Member
    bump for later reference
  • Barbonica
    Barbonica Posts: 337 Member
    I love data, and have been plotting weight and measurements for a couple years. Was thinking about adding calories now that I have enough data. Thanks for sharing,
  • susanrechter
    susanrechter Posts: 386 Member
    Like the judge asked, "do you have any documentation?" Be sure to save them and look at them when you're a healthy 80 year old and check out your comparatives. Will be interesting.:smile:
  • emienne
    emienne Posts: 29 Member
    I know what I'll be doing after my kids are in bed tonight! Making my already crazy spreadsheet even better! Thank you for sharing this - love all my data and charts and graphs!
  • bert16
    bert16 Posts: 726 Member
    Bump (thanks, OP!)
  • Vini9
    Vini9 Posts: 343 Member
    Bumping for later :)
  • sierra_12
    sierra_12 Posts: 249 Member
    bump for later (:
  • thatonepersonfromtheinternet
    thatonepersonfromtheinternet Posts: 136 Member
    This is so cool!
  • LesaDave
    LesaDave Posts: 1,480 Member
    bump
  • rb16fitness
    rb16fitness Posts: 236 Member
    pinterest :smile:
  • engian
    engian Posts: 70 Member
    Bump. Outstanding.
  • The_WoIverine
    The_WoIverine Posts: 367 Member
    Damn, gotta read this during the day.
  • nelinelineli
    nelinelineli Posts: 330 Member
    I added another constant - "Burn Coeff". The reason is that I'm showing a 150% TDEE, which is not consistent with my actual lifestyle. By having a knob for exercise calories, I can dial in the appropriate TDEE coefficient.

    The good news is that it appears I've been underestimating my burn, especially for the last 2 months, by about 20%. So TDEE coeff of 135% and a Burn Coeff of 120%.

    The more parameters the better - I'm really happy to see people taking this a notch further to meet their needs!
    Just wanted to ask - have you used the BMR formula for men? The one I left in the spreadsheet was for women, and I just realized some people might have not changed that coefficient at the end (from -161 to +5). Doesn't make a big difference in relative terms, but just checking:D
  • Mr_Knight
    Mr_Knight Posts: 9,532 Member
    Forgot about that! It knocks the TDEE coeff down by 5% for me. Thanks for pointing that out.
  • Cinloykko
    Cinloykko Posts: 117 Member
    The nerd in me is doing a very discombobulated happy dance :) I LOVE me some data!!! Thanks for all for this and the links. *cheers*

Categories