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

24567…16

Replies

  • dexfatpants
    dexfatpants Posts: 55 Member
    Thank you, love!

    Just trying to get my head around my TDEE, BMR etc and think I am almost there......this will help loads to get it straight!

    Ta!!


    I'm right here with ya! I've been trying to figure out if I'm actually eating enough calories since I seem to be in a stall.

    Thanks so much for posting this!!
  • BlackKat75
    BlackKat75 Posts: 210 Member
    bump
  • beebee0925
    beebee0925 Posts: 441 Member
    I can't copy it to change the values..help

    Yes I was having trouble too. On the top left hand corner click where it says File, then download as, Microsoft Excel document. Then it worked fine for me. Hope this helps.
  • forkeeps251
    forkeeps251 Posts: 22 Member
    Very cool! I haven't had a chance to use it yet, but I will. Being an accountant, I love cool spreadsheets :-)
  • kyodi
    kyodi Posts: 376 Member
    Bump
  • neoblues856
    neoblues856 Posts: 63
    awesome thank you for posting this :)
  • sandcgordon
    sandcgordon Posts: 12 Member
    bump
  • shaneil623
    shaneil623 Posts: 3
    bump
  • heybales
    heybales Posts: 18,842 Member
    Thank you, love!

    Just trying to get my head around my TDEE, BMR etc and think I am almost there......this will help loads to get it straight!

    Ta!!

    While the spreadsheet doesn't get into the meaning of those things, hopefully it'll let you visually see there is a range between BMR and TDEE to take a pretty good deficit out of, and if you go over your daily goal it's not the end of the world.

    Preventing diet stress thinking about it is one less stress no one needs, right.
  • heybales
    heybales Posts: 18,842 Member
    I can't copy it to change the values..help

    That is true, if you don't have a Gmail account or not logged into it in that browser session, the option to Copy to your own account isn't there.
    So you can top right Login, or if no Gmail account, download as Excel spreadsheet.
  • heybales
    heybales Posts: 18,842 Member
    Very cool! I haven't had a chance to use it yet, but I will. Being an accountant, I love cool spreadsheets :-)

    Being a numbers person that must share info with non-numbers people I'm sure, let me know if any improvements visually you see to help with flow or understanding.
  • LoriA6724
    LoriA6724 Posts: 99 Member
    Thanks for sharing!
  • jess393
    jess393 Posts: 220 Member
    Saving this, fershur! Thanks!
  • cad39too
    cad39too Posts: 874 Member
    Thanks for sharing, have saved this to my desktop.
  • fancyacuppa
    fancyacuppa Posts: 66 Member
    Bump - thank you for sharing
  • hollyrlambert
    hollyrlambert Posts: 69 Member
    bump
  • bellesmama75
    bellesmama75 Posts: 14
    bump
  • Jennifer_Lynn_1982
    Jennifer_Lynn_1982 Posts: 567 Member
    Bump
  • awilmeri
    awilmeri Posts: 218 Member
    Thanks for sharing this! I'm just figuring this all out and now I have a way to organize it. Just need to save it to the computer.
  • HealthyShazza
    HealthyShazza Posts: 31
    Bump :drinker:
  • heybales
    heybales Posts: 18,842 Member
    Thanks for sharing this! I'm just figuring this all out and now I have a way to organize it. Just need to save it to the computer.

    That's why I liked the spreadsheet idea over a website. Even if you printed out the info, have to enter it again.

    I guess an app could take care of that though, but not sure about screen view with so much potential data.

    Plus the fact I left programming many many years ago, and not really interested again. Even though this effort was close.
  • heybales
    heybales Posts: 18,842 Member
    Were those having trouble saving it able to do so. Sometimes I wonder about Google Documents. There have been times it tells me after opening it - there is no connection available.
    Which of course would make it difficult to save right then.

    So watch for warning notices at the top regarding that.
  • alanrosez
    alanrosez Posts: 53
    Bump and thank you!
  • aprilwilliams2729
    aprilwilliams2729 Posts: 107 Member
    bump to read later
  • Kendra0024
    Kendra0024 Posts: 56 Member
    That's awesome!! Thanks.
  • heybales
    heybales Posts: 18,842 Member
    Just saw a new online calculator using several of the same functions as here, multiple BMR, multiple level, Macro recommendations.

    But also split high/low for lifting days or IF eating levels.

    Would that be useful to include as a deficit method?
  • nothingwithoutHim
    nothingwithoutHim Posts: 140 Member
    Call me a dumb blonde or whatever...:embarassed:

    In 1A. Activity Level calculator (Katch or Mifflin BMR multiplier based on studies WHO, Durnin, and Bubb), what are you supposed to put in the area designated for "Sedentary"? Should I enter in the number of my BMR x 1.25? Or should it automatically give me a number after I enter every other activity in?

    When I put the minutes/hours of my activity, am I supposed to mulitply them to the numbers directly to their right in the next box, and then re-enter them into the middle box? Or what are the numbers at the far right for? Forgive me for asking so many questions...I think I'm a few fries short of a happy meal when it comes to things like this. :ohwell: Is 1A more accurate than the 1B? I don't have a HRM or fitbit:noway: , so I'm not doing 2 or 3...
  • Nettabee
    Nettabee Posts: 296 Member
    Bump for later. Thanks for posting!
  • beckydragonpoet
    beckydragonpoet Posts: 50 Member
    thank you! I was wondering that too. :-)
  • beckydragonpoet
    beckydragonpoet Posts: 50 Member
    :glasses: Bump.

Categories