My gift : Excel spreadsheet for BMR, TDEE, CUT, BUILD and ma

1246726

Replies

  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Have also saved this. Interesting as the BMR is the same as my calories allowed on MFP - so that would mean every bit of exercise I do is bringing me lower than BMR. Perhaps this is why I haven't lost anything in the last 5 months! :noway: I've been at 1200 and only just put it up on MFP to 1lb a week in desperation to try something different.

    Time to start eating more and see how this works.

    Thanks for sharing this and even if it was already on the net I hadn't seen it. :drinker:

    Exactly, eating around the BMR means you lower the metabolism , eg : less energy is required to perform the same task.
    No secret - BMR : vital functions (heart pumping, etc...) now suppose you eat around that and you perform like a crazy, the body won't use the fat, as the cal. deficit is too big, it will "slow down".
    You can "fix" that by eating more first (eg maintenance, or stay in the acceptable cut range)
  • Pookylou
    Pookylou Posts: 988 Member
    Fantastic, I work in stats and I do love me a good spreadsheet :flowerforyou:
  • gtfcnat
    gtfcnat Posts: 199
    bump
  • snakesandladders2
    snakesandladders2 Posts: 59 Member
    Merci beaucoup! very useful!
  • jagoochie
    jagoochie Posts: 218 Member
    thanks!!!
  • Looks awesome going to give a go.
  • eatrunstretch
    eatrunstretch Posts: 233 Member
    Thank-you!
  • bump
  • ladyraven68
    ladyraven68 Posts: 2,003 Member
    Looks fab - just one correction though, from a spreadsheet nerd.

    The female current % intake needs tweeking unless I'm reading it wrong.- The womens % intake is showing a percentage of the Men's Build intake (C7) rather than the female numbers (C19 to C21)
  • Great little tool :D
  • Jenlwb
    Jenlwb Posts: 682 Member
    Much appreciated!
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Looks fab - just one correction though, from a spreadsheet nerd.

    The female current % intake needs tweeking unless I'm reading it wrong.- The womens % intake is showing a percentage of the Men's Build intake (C7) rather than the female numbers (C19 to C21)

    The file has been updated, thanks! :)
  • lisa28115
    lisa28115 Posts: 17,271 Member
    i guess i am going to sound like a dumbass, but i am not sure i know how to use this spreadsheet:blushing:
  • Awesome! Thanks!
  • chezmoss
    chezmoss Posts: 79 Member
    Thanks dude.
  • marianeo
    marianeo Posts: 161 Member
    Great tool, thanks!!
  • snaggly
    snaggly Posts: 48 Member
    Thanks SO much for this. What great work!

    So, realistically, we should not be eating below BMR - if my BMR according to the calculations is 1292, should I be eating the 15% cut of 1427 cals NET or straight cals? In other words, do I take into account cal burn?
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    i guess i am going to sound like a dumbass, but i am not sure i know how to use this spreadsheet:blushing:

    You just fill your age, weight (in kilos), your height (in centimeters), your body fat if you know it, and an activity level (pick one from the activity levels numbers), and how much calories your are eating everyday.

    the sheet will give you :
    - your maintenance, (eating that amount prevent either muscle build, either weight lose)
    - your BMR (via two formulas, quite similar)
    - how much you need to eat in order to gain muscle, and minimizing fat storage
    - how much you need to eat in order to lose weight
    - a build plan : weight yourself one time per week, empty stomach, same day : if you gain too much, it means it's fat
    - a weight loss plan : if you lose too much, it may be dangerous
    - how to setup your MFP goals (custom goals) for every nutrient, with two goals : an "ideal" one, (but hard to apply IRL imho), and a "realistic" one (based on weeks of myself's diaries)
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Thanks SO much for this. What great work!

    So, realistically, we should not be eating below BMR - if my BMR according to the calculations is 1292, should I be eating the 15% cut of 1427 cals NET or straight cals? In other words, do I take into account cal burn?

    Totally yes, in order to lose weight, you stay withing the "cut" range, which is a 15% difference based on MAINTENANCE (the maintenance itself being the activity level per BMR), in other words : vital functions : BMR, no, if you are very active in life : extra energy required :)
    How to lose weight : create a safe calorie deficit :)

    Regarding these famous net: yes!
    suppose now you perform a crazy workout that requires extra 500 calories : you make the deficit bigger, meaning you are out of the sage range. Doing it one, two, three times, is cool, but maintaining a too long important calories deficit (accross months) will only make the weight lose even complicated.
    I was during months (eg 5-6 months) in a extreme calories deficit (I'd say 50-55), now I'm all wozzy ahah :D
  • Hurricane_C
    Hurricane_C Posts: 806 Member
    bump to look at later
  • snaggly
    snaggly Posts: 48 Member
    Thanks SO much for this. What great work!

    So, realistically, we should not be eating below BMR - if my BMR according to the calculations is 1292, should I be eating the 15% cut of 1427 cals NET or straight cals? In other words, do I take into account cal burn?

    Totally yes, in order to lose weight, you stay withing the "cut" range, which is a 15% difference based on MAINTENANCE (the maintenance itself being the activity level per BMR), in other words : vital functions : BMR, no, if you are very active in life : extra energy required :)
    How to lose weight : create a safe calorie deficit :)

    Regarding these famous net: yes!
    suppose now you perform a crazy workout that requires extra 500 calories : you make the deficit bigger, meaning you are out of the sage range. Doing it one, two, three times, is cool, but maintaining a too long important calories deficit (accross months) will only make the weight lose even complicated.
    I was during months (eg 5-6 months) in a extreme calories deficit (I'd say 50-55), now I'm all wozzy ahah :D


    Thanks again for this. It does make a lot of sense to stay within that 15% range particularly so that we don't put the weight back on when going on maintenance after weight loss.
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Now you totally get it!

    Thus it will prevent the yoyo effect : eg I'm during a month on an extreme deficit (45%, 50%), when the diet is over -> Maintenance, or, in most of times, 30% above maintenance (because of the deprivation feelng) --> the yoyo effect :)
    Now suppose you stay in the safe range : you can remain in deficit during months, thus you burn fat, lose weight, and, damn, you EAT :D
  • lisa28115
    lisa28115 Posts: 17,271 Member
    BMR 1,478
    Maintenance 2,217
    Cut (@ 15%) 1,885
    Build (@ 15%) 2,550

    Only fill here !!!
    Weight (in kilos) 89.81
    Height (in cm) 154.94
    Age 46
    Activity Level (pick above) 1.5
    Body Fat (in %) (for M-McArdie only)
    Current calories intake 1900

    Use the following converter :
    Your weight in lbs kilos
    198 89.81
    Yout height in inches Centimeters
    61 154.94

    so 1885 is what i should be eating everyday...whether i exercise or not
    i have been eating around 1900 with at least 1hr walking everyday

    sorry ...to be so dense
    i work 3rd shift...i have been up all nite which i think is another hurdle to my weight loss
    i have lost nothing since i started here in november
  • AH2013
    AH2013 Posts: 385 Member
    FAB! Thanks!
  • lisa28115
    lisa28115 Posts: 17,271 Member
    Damn, i think maybe i got it!!!:noway:

    I should eat 1885 no matter what i do, where i go or what the hell happens
    and i will lose weight!!!!:huh:
  • gazerofthestars
    gazerofthestars Posts: 255 Member
    Very nice! :)
  • MMarvelous
    MMarvelous Posts: 1,067 Member
    Uhm interesting
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Damn, i think maybe i got it!!!:noway:

    I should eat 1885 no matter what i do, where i go or what the hell happens
    and i will lose weight!!!!:huh:

    exactly, by eating that amount, you remain in a low,but constant deficit, check the lose plain, now weight yourself everyweek, and check if your lbs match the plan.
    So, based on your numbers, you would weight 178 lbs in 20 weeks :)
  • i_am_asparagus
    i_am_asparagus Posts: 336 Member
    Thanks. :happy:
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Sure :)
    I'll think about what features I could add :d
This discussion has been closed.