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

1…5681011…26

Replies

  • MDWilliams1857
    MDWilliams1857 Posts: 315 Member
    I must just be a moron because I have no idea what Im supposed to do with that. I filled in the weight and height but none of the other numbers changed. What am I missing?
  • Jodi827
    Jodi827 Posts: 40
    Bump for later. Thanks!
  • NewJay12
    NewJay12 Posts: 51 Member
    Thanks! Great spreadsheet
  • mgoulsbra
    mgoulsbra Posts: 21 Member
    Great spreadsheet - but I have a question about the Macros.. For my data it's given me "Ideal" of 34% protein, 30% fat, 36 % carbs - which is close to what I have already set as my goals, but the "realistic" is 57% protein, 25% fat, 18% carbs.

    I'd never survive on 18% carbs (I've tried loe carb and it doesn't work for me). I guess I'm not understanding why it would be realistic to have only 18% carbs??
  • CindyRx
    CindyRx Posts: 46 Member
    I'll have to check it out later, thanks!
  • mukamom
    mukamom Posts: 207 Member
    Great spreadsheet - but I have a question about the Macros.. For my data it's given me "Ideal" of 34% protein, 30% fat, 36 % carbs - which is close to what I have already set as my goals, but the "realistic" is 57% protein, 25% fat, 18% carbs.

    I'd never survive on 18% carbs (I've tried loe carb and it doesn't work for me). I guess I'm not understanding why it would be realistic to have only 18% carbs??

    My realistic carbs are 15% 25% fat and 60% protein......perhaps its because of one or more factors...such as age, height, gender??

    Thoughts, anyone??
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)
  • rayleansout
    rayleansout Posts: 234
    Nice work! Thank You!!
  • fxst78
    fxst78 Posts: 221 Member
    Bump
  • mgoulsbra
    mgoulsbra Posts: 21 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks
  • lisaisso
    lisaisso Posts: 337 Member
    bump for later
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks

    And your current intake too :) Macros use that value ;)
  • mgoulsbra
    mgoulsbra Posts: 21 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks

    And your current intake too :) Macros use that value ;)

    I put current intake as 1200 (and before anyone says anything, I know it's low... that's why I was looking at the spreadsheet - to see what changes I should be making)
  • CallmeSbo
    CallmeSbo Posts: 611 Member
    Thank you so much. You rock!
  • marthafox1
    marthafox1 Posts: 191 Member
    Thank you
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    @ all : you can download it again, the plans were not working correctly.
    I've removed the weigh gain/ lose split, since being in deficit invert both charts.
    Now you know how you weight will evolve accross weeks based on how much you eat :)
    I'd like to have feedbacks regarding the macros repartition. I've added an "alternative" macros lines, but input from people with weird results excepted thanks! (I need your daily intakes)
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks

    And your current intake too :) Macros use that value ;)

    I put current intake as 1200 (and before anyone says anything, I know it's low... that's why I was looking at the spreadsheet - to see what changes I should be making)

    Thanks!!
    So here is what you should try
    Higher your intakes to 1400 calories per day.
    Please re-download the sheet, I updated it for your values - the "alternative" macros has been updated based on your input.
    You have now all the infos to start on Monday your new shiny weight lose plan :flowerforyou:
  • reallymyBEST
    reallymyBEST Posts: 242 Member
    bump
  • mgoulsbra
    mgoulsbra Posts: 21 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks

    And your current intake too :) Macros use that value ;)

    I put current intake as 1200 (and before anyone says anything, I know it's low... that's why I was looking at the spreadsheet - to see what changes I should be making)

    Thanks!!
    So here is what you should try
    Higher your intakes to 1400 calories per day.
    Please re-download the sheet, I updated it for your values - the "alternative" macros has been updated based on your input.
    You have now all the infos to start on Monday your new shiny weight lose plan :flowerforyou:

    Sorry if I am being dumb, but I downloaded the new sheet, and put in 1400 for intake as you suggest - but that then shows I'll lose 0.14kg per week. In order to achieve the safe 0.45kg per week I have to adjust the calorie intake to 1050. What am I doing wrong?
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    That where these kind of calculations show their limits :)
    Try to put the 1400 calories anyway (that won't do any harm) and every week weight yourself. Based on your weight :
    If you lose too slowly : you can reduce your intakes
    too quickly : lower slightly :)
  • FaithandFitness
    FaithandFitness Posts: 653 Member
    Thanks! Wonderful tool. I am just a bit confused about the macros. What is the difference between Realistic and Ideal? Can I choose either an expect results?
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    Realistic : Mine
    Ideal : Ideals that I can't stick too (I'm way overy protein)
    Alternative : For people who get incoherent results :laugh:
    In fact, you should chose ideal, if it contains around 20-30% fat, 55% carbs, and the rest in proteins :)
  • FaithandFitness
    FaithandFitness Posts: 653 Member
    Realistic : Mine
    Ideal : Ideals that I can't stick too (I'm way overy protein)
    Alternative : For people who get incoherent results :laugh:
    In fact, you should chose ideal, if it contains around 20-30% fat, 55% carbs, and the rest in proteins :)

    Thanks! That is helpful. I will give "ideal" a spin!
  • Dragonwolf
    Dragonwolf Posts: 5,600 Member
    This is awesome, thanks! I wonder if there's a way to request for sticky?
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    I'll ask :)
  • Kichelchen
    Kichelchen Posts: 79 Member
    Bump, in case there's gonna be some more changes! I LOVE stuff like that :D Cheers, man!
  • erickirb
    erickirb Posts: 12,294 Member
    The realistic one are close to my measures. Would you provide me your measures so I can create a third macros plan?
    You are not the first one to tell me this. So I a third should do it :)

    Height: 155cm
    Weight: 68.5kg
    Age: 40 (Femaie)
    Activity Level 1.2
    Body Fat: Don't know

    Is that what you needed?

    Thanks

    And your current intake too :) Macros use that value ;)

    I put current intake as 1200 (and before anyone says anything, I know it's low... that's why I was looking at the spreadsheet - to see what changes I should be making)

    Thanks!!
    So here is what you should try
    Higher your intakes to 1400 calories per day.
    Please re-download the sheet, I updated it for your values - the "alternative" macros has been updated based on your input.
    You have now all the infos to start on Monday your new shiny weight lose plan :flowerforyou:

    Sorry if I am being dumb, but I downloaded the new sheet, and put in 1400 for intake as you suggest - but that then shows I'll lose 0.14kg per week. In order to achieve the safe 0.45kg per week I have to adjust the calorie intake to 1050. What am I doing wrong?

    What did you use as your activity level? This sheet is different then MFP, as you should include your exercise into activity level. So instead of using 1.2 up it to 1.4 or higher depending on how much you workout.
  • CMmrsfloyd
    CMmrsfloyd Posts: 2,380 Member
    Okay, I am very interested in this but I want to check and make sure I'm doing it right - first off, I'm used to the MFP way of determining activity level so it's hard to wrap my brain around setting it to anything other than 'sedentary' - I'm a stay-at-home-mom who cleans the house and does the shopping (I was taking those activities as 'freebie' calories and kept my activity level at sedentary on MFP), my exercise currently consists of Jillian Michaels dvds, usually the ones w/ weights but sometimes just cardio, generally for between 35-60 minutes per day with an occasional day for rest. My HRM usually estimates that I burn around 250 for the 35 minute workout and around 450-500 on the days that I go for an hour. How should I set my activity level? Do I try to account for the exercise or do I set it at sedentary or lightly active and then add back in my exercise calories on top of the goal it gives me? MFP currently has me set at 1390 per day for 1/2 lb per week, I normally end up eating 1700-2000 on workout days and I normally lose 1/2-1 lb per week (though I thought it would be even slower at this point since I'm only 7 lbs from goal), in order for me to get the formula to show that range for the 'cut' I have to put in an activity level of 1.6-1.8, which makes me nervous! Am I *really* that active based on the amount I workout? I mean I guess I have to be if the numbers work out, it's just hard for me to believe.....

    Also, for comparison I tried to fill in the bodyfat % - I used 2 calculators online (one covert-bailey on fat2fitradio.com and one on scientificpsychic.com) - one told me 21.9% and one told me 26.7% so I took the average between the two and entered 24.3%. Comparing the Katch-McArdle and the Mifflin-St Jeor they are very close (one bmr 1312 and the other 1288).

    Thanks for putting this together, it is really fascinating and I'm going to run my husband's numbers next. He has been working hard for a month and a half now, lost 5 lbs straight away in the beginning but has been stuck bouncing between the same couple of lbs since then and he's getting frustrated. He's 5'10", 190 lbs, works a desk job and works out with me about 35 minutes per day I'd say 5-6 days per week, his HRM estimates that he burns around 400-450 calories on good workout days. How should I set his activity level? I also have his measurements and will try to estimate his bodyfat % on those websites and see what happens. He has been trying to eat 1500 minimum plus his exercise calories, I can see changes in his body (although his measurements have not changed very much) but the weight is not moving.

    Also, when we type in the 'current calorie intake' that's total, not net, right?
  • PercivalHackworth
    PercivalHackworth Posts: 1,437 Member
    It's your daily intake, regardless the trainnings you have, since we suppose the activity level cover them :)
  • BumInTheSun73
    BumInTheSun73 Posts: 37 Member
    Wow thanks so much for this! Look forward to checking it out :)
This discussion has been closed.

Categories