Skip to content
  • Register
    • We are pleased to announce that as of March 4, 2025, an updated Rich Text Editor has been introduced in the MyFitnessPal Community. To learn more about the changes, please click here. We look forward to sharing this new feature with you!

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

    24567…16

    Replies

    • 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!!
    • Posts: 210 Member
      bump
    • 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.
    • 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 :-)
    • Posts: 376 Member
      Bump
    • Posts: 63
      awesome thank you for posting this :)
    • Posts: 12 Member
      bump
    • Posts: 3
      bump
    • 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.
    • 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.
    • 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.
    • Posts: 99 Member
      Thanks for sharing!
    • Posts: 220 Member
      Saving this, fershur! Thanks!
    • Posts: 874 Member
      Thanks for sharing, have saved this to my desktop.
    • Posts: 66 Member
      Bump - thank you for sharing
    • Posts: 69 Member
      bump
    • Posts: 14
      bump
    • Posts: 567 Member
      Bump
    • 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.
    • Posts: 31
      Bump :drinker:
    • 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.
    • 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.
    • Posts: 53
      Bump and thank you!
    • Posts: 107 Member
      bump to read later
    • Posts: 56 Member
      That's awesome!! Thanks.
    • 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?
    • 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...
    • Posts: 296 Member
      Bump for later. Thanks for posting!
    • Posts: 50 Member
      thank you! I was wondering that too. :-)
    • Posts: 50 Member
      :glasses: Bump.
    This discussion has been closed.

    Welcome!

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

    Quick Links

    Categories