Spreadsheet for BMR/TDEE Deficit, Macro calcs, HRM zones

12467…16

Replies

  • sundaysurf
    sundaysurf Posts: 72 Member
    Thank you! It is awesome!
  • valorieflowers
    valorieflowers Posts: 154
    Wow, thanks! BUMP!
  • TigressStripes
    TigressStripes Posts: 33 Member
    bump.
  • heybales
    heybales Posts: 18,842 Member
    I am happy to see this thread again as I used your calculator last week! Wanted to say a big thank you ;)

    And a big welcome, just hope its useful to others.
    I've used it enough for others stats and advice for sure.
  • sandkrain
    sandkrain Posts: 78 Member
    bump
    looks like good info, will use later when i have more time
  • orangesmartie
    orangesmartie Posts: 1,870 Member
    Thanks. Just bumping this so I can find the spreadsheet when i get home
  • Keiko385
    Keiko385 Posts: 514 Member
    bump for reference
  • heybales
    heybales Posts: 18,842 Member
    Made several minor changes to the spreadsheet that have come up lately as being useful.

    BMR/TDEE tab - TDEE calc 3B. Since FitBit and BodyMedia both use Harris BMR calc to help set the foundation of your daily calorie burn estimate and that is the least accurate BMR, if your Katch BMR calc is different by 150-250 calories, that could mean being too conservitive then need be.
    So now when you enter in 3 non-exercise days, if you have a Katch BMR, the difference in calorie burn is calculated, and you are shown a corrected average to use.

    HRM tab - changed the links for HRmax test to actual website with tests.

    MFP Tweak tab - added a section to enter your reported calorie burn, so the same deficit can be taken on it for proper logging for eating them back. Just like the TDEE method would have done. Plus a table range of calorie burns with the deficit value to log.
  • OnionCookie
    OnionCookie Posts: 272 Member
    Bump
  • giggitygoo
    giggitygoo Posts: 1,978 Member
    bump
  • aneciarobinson
    aneciarobinson Posts: 60 Member
    Thank you!
  • Tami113
    Tami113 Posts: 117 Member
    bump
  • heybales
    heybales Posts: 18,842 Member
    Thank you!

    Welcome, hope you find it useful.

    Every so often, pull up a new master copy, check the revision date and the note there, and see if any improvement is worth getting the newer one.
  • heybales
    heybales Posts: 18,842 Member
    Thanks. Just bumping this so I can find the spreadsheet when i get home

    Welcome, hope it is useful. See post above this one. In fact, some changes since you got it.
  • Shara126
    Shara126 Posts: 144 Member
    bump
  • Brianabomb
    Brianabomb Posts: 87 Member
    bump
  • Lane1012
    Lane1012 Posts: 211 Member
    blump
  • wavdawg4
    wavdawg4 Posts: 139 Member
    Thanks :) Just bumping this so I can take a look at it when i get home :)
  • clickybang
    clickybang Posts: 10 Member
    Thank you! Marking for downloading later :-)
  • simplyeater
    simplyeater Posts: 270 Member
    bump for later

    Thanks for putting the effort in on this one!
  • Nefetete
    Nefetete Posts: 343 Member
    Thanks for posting and taking the time to create the spreadsheet. I've used ur previous versions and love it. Can't wait to log on tonight and upload to see what the updates are. 
  • heybales
    heybales Posts: 18,842 Member
    Thanks for posting and taking the time to create the spreadsheet. I've used ur previous versions and love it. Can't wait to log on tonight and upload to see what the updates are. 

    Ver 3 here was several things.

    Sadly, I never really kept track of the minor stuff until recently. I'm adding changes as a Note to the cell that says what version date is.
  • skruger22
    skruger22 Posts: 75 Member
    bump for later! Thanks!
  • Flowers4Julia
    Flowers4Julia Posts: 521 Member
    thank you! I just spent the time plugging it all in....took awhile because I am no excel wiz!

    I especially appreciate how when you put in your exercise calories it adjusts off the daily cals so they are not counted double. I have tried to explain this net vs. gross calorie thing to some of my pals and they just hate that! LOL! but, that's why I've lost pounds and maybe because they haven't??

    Anyway, thanks again!

    Edit: cause I can't type/spell either ;-)
  • JeffTCole
    JeffTCole Posts: 140 Member
    thanks
  • VividSugar
    VividSugar Posts: 10
    You read my mind! BUMP!
  • AnnaVee84
    AnnaVee84 Posts: 345 Member
    bump - thanks for sharing!!
  • beatoks
    beatoks Posts: 63
    bump, thanks
  • CassieReannan
    CassieReannan Posts: 1,479 Member
    Wow thanks!
  • ambrosdm
    ambrosdm Posts: 21 Member
    bump

Categories