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

1…1012141516

Replies

  • edinat
    edinat Posts: 159 Member
    BUMP
  • IAmPersuaded
    IAmPersuaded Posts: 48 Member
    Exactly the information I have been needing! Thank you!
  • pamperedhen
    pamperedhen Posts: 446 Member
    Bumpity!! bump! BUMP!
  • Polymorphist
    Polymorphist Posts: 41
    Funny, I was actually going to sit down tonight and start building my own web page with all of the calculations so I could have them in one place. I'm still going to do that, but I might glance at this spreadsheet to save me some time. I have a hosting plan so i'm probably going to throw it up there when i'm done.

    Okay, on with the construction...
  • okcat4
    okcat4 Posts: 224 Member
    bump
  • dixiewhiskey
    dixiewhiskey Posts: 3,333 Member
    Very cool!

    Kept taking the concerns and issues I saw reported on the forums, and mainly to help myself run people's numbers easier. Now hopefully easy enough for personal use.

    I forgot to say thank you.. this saved me a lot of time! I'll be using this again when I need to re-evaluate in the future :flowerforyou:
  • LisaLamb1
    LisaLamb1 Posts: 149 Member
    Bump
  • heybales
    heybales Posts: 18,842 Member
    Funny, I was actually going to sit down tonight and start building my own web page with all of the calculations so I could have them in one place. I'm still going to do that, but I might glance at this spreadsheet to save me some time. I have a hosting plan so i'm probably going to throw it up there when i'm done.

    Okay, on with the construction...

    The one very desired request that made spreadsheet easier than web page was the progress tab. Well, even before that it was retaining the info, as opposed to all other web sites can't of course store it.

    I might suggest if you have means of sending email from the site, have option to email current stats back for record keeping of the person doing it as backup.
    And then a saved cookie so if they want to rerun numbers, the cookie and last stats are found and used. Only about 21 number stats.
  • Pamelaniamh
    Pamelaniamh Posts: 611 Member
    :flowerforyou:
  • Noni2863
    Noni2863 Posts: 36 Member
    Thank you soooo much for building this spreadsheet.
    I for one will be forever in your debt.
  • Thunderfan66
    Thunderfan66 Posts: 105 Member
    Nice work - well done!

    But still so confused about what I should be eating to lose weight! MFP recommends 1200, a dietician recommended 1350, someone else said 1700 and this spreadsheet recommended 2160 or so.....argh!
  • Leanz
    Leanz Posts: 2,025 Member
    Thank you for this!
  • lemonfizzle
    lemonfizzle Posts: 40 Member
    Thanks and bump
  • lynzbeaner
    lynzbeaner Posts: 31 Member
    Bump
  • Treadmillmom1st
    Treadmillmom1st Posts: 579 Member
    Thank you for the spreadsheet my understanding of BMR and TDEE are vague, see here http://www.myfitnesspal.com/topics/show/931670-bmr-and-tdee-explained-for-those-needing-a-guide?page=5 however your spreadsheet has confirmed the daily calorific intake figure I'd calculated to maintain was correct after all.
  • heybales
    heybales Posts: 18,842 Member
    Nice work - well done!

    But still so confused about what I should be eating to lose weight! MFP recommends 1200, a dietician recommended 1350, someone else said 1700 and this spreadsheet recommended 2160 or so.....argh!

    Did you do the bodyfat calc and use your results in the box?
    Then you are getting best estimated BMR.
    Did you fill in the activity calculator honestly for what you will really do?
    Then you are getting best estimated TDEE.
    The TDEG is based on amount to lose and type of workout, so best deficit to keep from undereating, but enough for fat/weight loss.

    MFP is based off YOUR choices of activity level and weight loss goal - you made it 1200. When you follow the program and eat back exercise, now what level of eating would you be at?

    Did dietician know your BF% and use it, and your intended exercise amount?
  • heybales
    heybales Posts: 18,842 Member
    Thank you for the spreadsheet my understanding of BMR and TDEE are vague, see here http://www.myfitnesspal.com/topics/show/931670-bmr-and-tdee-explained-for-those-needing-a-guide?page=5 however your spreadsheet has confirmed the daily calorific intake figure I'd calculated to maintain was correct after all.

    Ya, strange that was almost copied directly from this without any reference to it, though a comment she found great topics on MFP about it.

    http://www.myfitnesspal.com/topics/show/912914-in-place-of-a-road-map-3-2013

    Some people do luck out that the 5 levels decently estimate their activity level. Most don't.
  • jsd_135
    jsd_135 Posts: 291 Member
    bump
  • Rosegardenia
    Rosegardenia Posts: 53 Member
    :flowerforyou: :flowerforyou: :flowerforyou: :flowerforyou: :flowerforyou: :love:
  • purplekty
    purplekty Posts: 57 Member
    bump
  • ajcrain
    ajcrain Posts: 25 Member
    Thanks!
  • RunningTowardsFit
    RunningTowardsFit Posts: 81
    This is wonderful! Thank you :)
    Keeping forever!
  • heybales
    heybales Posts: 18,842 Member
    This is wonderful! Thank you :)
    Keeping forever!

    Do keep the link and check for updates to the ver date, most have been visual lately, but thinking about some other improvements to other tabs perhaps. Probably keep the Simple Setup tab since everything there based on studies.
  • burnt_irish1
    burnt_irish1 Posts: 55 Member
    Bump
  • TendaiMa
    TendaiMa Posts: 72 Member
    Bump...awesome! Thanks for sharing...
  • Healthy_4_Life2
    Healthy_4_Life2 Posts: 595 Member
    Thanks for sharing. Bump.
  • ogiesmom
    ogiesmom Posts: 25 Member
    bump
  • miche_smash
    miche_smash Posts: 131 Member
    Bump
  • Brie4me
    Brie4me Posts: 238
    bump
  • allisonmrn
    allisonmrn Posts: 721 Member
    BUMP

Categories