Viewing the message boards in:

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

11011121315

Replies

  • Posts: 68 Member
    bump
  • Posts: 271
    Bump
  • Posts: 52

    I'm glad it worked that well for you with info, it wasn't really intended as educational, I figured someone would only give it a try if they had done some reading already, and just wanted a storage place for their stats and easier way of looking at it.

    It has been actually a stress relief for when exercise can't be, so beneficial for me too.

    Now to start the app development, ahah.
  • Posts: 52
    oopsy, that previous thing posted "too fast". hah haaa. Still learning here.

    I think for me it was so fantastic since I have been reading so much the past month. First getting totally confused with MFP system and by reading some posts in general forum. More and more confused and unsure about everything. Then I finally bumped into PUs stuff (thank you goes there too) and it started to make sense and some how this spreadsheet totally opened up the info for me. But I do think you do need to have been familiar with the terminology and it helps if you have read these boards and maybe done some calculations with the other outside calculators. This spreadsheet though made it easy for me to see and understand all that above information not to mention that it is great that it is all there, on one page. I will be using the Simple Setup and the tab where you can track your progress. Awesome!!
  • Posts: 7,692 Member
    bump
  • Posts: 51 Member
    bump
  • Posts: 85 Member
    bump
  • Very helpful! thanks
  • Posts: 461 Member
    bump
  • Posts: 18,842 Member
    Very helpful! thanks

    Hope you find it useful.

    Added a section on the Progress tab to include adding up your daily eaten calories over the course of one measurement to the next.
    That way if the eating goal was 1750, and your avg was 1850, should come as no surprise you might not have seen results.
  • Posts: 88 Member
    Bumping so I can find it again. Thank you!!
  • Posts: 109 Member
    Bump
  • Posts: 170 Member
    Bump
  • Posts: 8 Member
    Clearly a lot of work to gather and consolidate but incredibly helpful. Thank you
  • Posts: 31
    Bump
  • Posts: 47 Member
    Bump
  • Posts: 18,842 Member
    Clearly a lot of work to gather and consolidate but incredibly helpful. Thank you

    When I heard of all the scratch paper being used, or setting up their own spreadsheets, and tracking their own results, and going to multiple sites - no way.

    Plus I already had most the stuff in one place for my own use helping others, just some tweaking to make it easier.
  • Posts: 411 Member
    bump
  • Posts: 13 Member
    Bump
  • Posts: 29 Member
    bump
  • Posts: 72 Member
    bump
  • Posts: 47
    Thank you for sharing this information!
  • Posts: 279 Member
    bump
  • Posts: 113 Member
    bump
  • Posts: 18,842 Member
    Major new tab added - FitBit_BodyMedia

    So reason for using this rather than default MFP syncing and using.

    You want the 15-20% deficit method used with TDEE Deficit, not the block of calories MFP uses (250, 500, ect).
    You have many workouts that those devices are not good at estimating calorie burn, lifting, spin, rowing, ect, so you do want some syncing, but some manual logging, and want the same % Deficit method.
    You want a totally static number to eat everyday, and do normal exercise included TDEE Deficit method avg out daily.
    You want to use the Simple Setup tab recommendation, and want the non-exercise TDEE to match what the device says.
    You got a tested RMR figure and BMR based on that is very different than BMR the device is using for non-moving time, so you want to adjust the height to try to get the BMR's the same for better TDEE estimate.
    Your Katch BMR is very different than BMR device is using, desire same adjustment for better TDEE estimate.

    Fill in Simple Setup tab down to the Goal Weight.
    Go to FitBit_BodyMedia tab.
    Delete sample yellow cells.
    Enter in your tested RMR if you have one, leave blank if none.
    Adjustment is shown for the device site to use, if desired.

    3 options shown for the 2 methods.
    MFP method - daily eating goal changes as activity changes or you log exercise calories, with deficit. Normal sync method, but using % deficit rather than block calories. Trying to minimize adjustment amounts so fewer big changes.
    TDEE method - daily eating goal changes a little bit as activity changes, no logging of exercise expected if the device correctly estimates calories burn.
    TDEE method using Simple Setup tab - static daily eating goal, and device used for non-exercise day TDEE, activity calc for exercise, potentially bigger deficit given if lifting part of routine.

    I can still make improvements to it, so feedback still desired.
  • Posts: 261 Member
    Thanks for sharing!
  • Posts: 105 Member
    bump
  • Posts: 1
    :wink:
  • Posts: 17
    Wow this is great! Thanks for putting in all the hard work. :flowerforyou:
  • Posts: 18,842 Member
    Wow this is great! Thanks for putting in all the hard work. :flowerforyou:

    Hope you find it useful. Just keep updating and sticking to a plan.
This discussion has been closed.