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

2456726

Replies

  • Word of warning - Unless I did something really wrong, that won't work for very overweight folks. According to that, my activity level is .53, and I work out 5 days a week, at least. Yes, POINT five three. ROFL! But it is an impressive tool for folks who are a normal weight and wanting to build muscle and that sort of thing! Great tool!

    Shannon

    .53 is not an option for activity level.

    Sedentary (Little or no exercise + desk job) 1.2
    Lightly Active (Little daily activity & light exercise 1-3 days a week) 1.3/ 1.4
    Moderately Active (Moderately active daily life & Moderate exercise 3-5 days a week) 1.5/ 1.6
    Very Active (Physically demanding lifestyle & Hard exercise or sports 6-7 days a week) 1.7/ 1.8
    Extremely Active (Hard daily exercise or sports and physical job) 1.9 /2
  • MFPAddict
    MFPAddict Posts: 2,069 Member
    Bump to check from home
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    I like this - I think. if I don't want to gain, what do I put in the chart? can I put - something?

    Sorry if it's a dumbass question :P

    I updated it for you :)
    There is a weight loss plan, safe enough to prevent any stuff that would make the loss dangerous (shrinking thryoid, catabolism, resistance, fatigue, etc...)
  • gecho
    gecho Posts: 426 Member
    Hey, if you want to lose, just use the cut value, that gives you a daily 15% deficit.
    I'll add later a colum for a weight lose estimation plan :)

    i need the weight loss column

    HELP!!!:frown:
    any chance of making it pounds and inches for those of us (ME!!!:embarassed: ) who royally suck at figuring the conversions?

    I'm 167 lbs
    5'9
    activity level is Sedentary
    NO clue what the body fat % would be
    Ideal weight gain? i want to lose 27lbs to be my goal of 140lbs
    current cals is 1200/day
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Hey, if you want to lose, just use the cut value, that gives you a daily 15% deficit.
    I'll add later a colum for a weight lose estimation plan :)

    i need the weight loss column

    HELP!!!:frown:
    any chance of making it pounds and inches for those of us (ME!!!:embarassed: ) who royally suck at figuring the conversions?

    I'm 167 lbs
    5'9
    activity level is Sedentary
    NO clue what the body fat % would be
    Ideal weight gain? i want to lose 27lbs to be my goal of 140lbs
    current cals is 1200/day

    It has been updated, just download it again :)

    edit ; later I'll add the kilos to lbs and cm to inches columns :)
  • tdvogl
    tdvogl Posts: 9 Member
    Excellent! I will take a look later with more time!
  • thetiwi1890
    thetiwi1890 Posts: 239 Member
    Thank you!
    :flowerforyou:
  • Felidae_1981
    Felidae_1981 Posts: 200 Member
    So we still enter say ".5" into the weight difference column, and then go by the weight loss plan...

    I estimated my body fat % at 23% (need to get this measured but think that s accurte). It says I should eat 1725 to cut @15%... since I have restricted my carbs to 130 or less - I was WAYYY over every day, not just a little I am having a hard time reaching 1200...
  • Bump...
  • jodi_bannister
    jodi_bannister Posts: 90 Member
    Awesome...thanks :)
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    So we still enter say ".5" into the weight difference column, and then go by the weight loss plan...

    I estimated my body fat % at 23% (need to get this measured but think that s accurte). It says I should eat 1725 to cut @15%... since I have restricted my carbs to 130 or less - I was WAYYY over every day, not just a little I am having a hard time reaching 1200...

    Nope in fact, this one should not be updated. It's a value considered as safe (eg regular, slow weight loss)
    you have nothing to do for the weight loss plan, but fill your values :)
    I'll update the sheet to make it clearer
  • lcharity79
    lcharity79 Posts: 94 Member
    bump - thanks!
  • lin7604
    lin7604 Posts: 2,951 Member
    awesome thanks so much!!!!! just can't wait for it to show it in lbs,lol so i don't have to Google the conversion constantly...
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    So we still enter say ".5" into the weight difference column, and then go by the weight loss plan...

    I estimated my body fat % at 23% (need to get this measured but think that s accurte). It says I should eat 1725 to cut @15%... since I have restricted my carbs to 130 or less - I was WAYYY over every day, not just a little I am having a hard time reaching 1200...

    The spreadsheet has been updated. You can download it again.
    So how the plan should be considered :
    - Weight yourself every week, the same day, the same time, before eating anything, after having said hello to Mister Poo
    - If you are losing weight faster than the plan, it means that it MAY BE potentially not a good thing
    - If you are losing weight slower than the plan, it means, you can allow yourself a bigger deficit (eg eat less for instance)

    :smokin:
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    awesome thanks so much!!!!! just can't wait for it to show it in lbs,lol so i don't have to Google the conversion constantly...

    Hehe, i'll do it later ;)
  • Felidae_1981
    Felidae_1981 Posts: 200 Member
    Thank you <3

    And those Americans just need to switch to metric already. So much easier anyway :P

    10s, 100s, 1000s and so on - I'll NEVER get the US system.
  • shedoos
    shedoos Posts: 446 Member
    thanks
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    I've updated it, now you have the equivalent kilos -> lbs for the build and lose plans, also I've added a converter, you can now quickly know your values in centimeters and kilos.
  • BigPapaGato
    BigPapaGato Posts: 96 Member
    Awesome... Just wish I could view it on my iPad here at work :(
  • megjeg
    megjeg Posts: 18
    Bump!
  • brokenartist
    brokenartist Posts: 52 Member
    Thanks man, this is great. I am basing my macros off this calculator as opposed to the MFP default settings.
  • Nelski
    Nelski Posts: 1,607 Member
    Nice work, thanks!
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    thanks! :)
    I'm myself updating my goals for my tomorrow diary, I was too high in proteins, it's useless and costs too much ahah
  • AntWrig
    AntWrig Posts: 2,273 Member
    Your Mifflin-St Jeor, 20% cut only has a cut of 10% in the formula, you may want to fix that.
    A -10% start is not bad at all. Most people start at -20/-35 and they wonder why they stall.
  • lin7604
    lin7604 Posts: 2,951 Member
    thanks! :)
    I'm myself updating my goals for my tomorrow diary, I was too high in proteins, it's useless and costs too much ahah

    how do we figure out how much protein we should be having daily?
  • simone207
    simone207 Posts: 45 Member
    bump
  • Cant wait to use this!! thanks alot.
  • lakersfan4life
    lakersfan4life Posts: 322 Member
    bumpity bump
  • foster59803
    foster59803 Posts: 439 Member
    Wow! Thanks for doing this and sharing with us! I love spreadsheets... is that lame or what? LOL!
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    thanks! :)
    I'm myself updating my goals for my tomorrow diary, I was too high in proteins, it's useless and costs too much ahah

    how do we figure out how much protein we should be having daily?

    Use the macros repartition table into my sheet, it gives you the amount of protein you should eat based on your daily intake.
    Then you can update your MFP goals, so the macros hit my values
    In the end, you would have : 50-55% cabs 30% fat, 15-20% proteins :)
This discussion has been closed.