Spreadsheet for bodyfat, BMR, TDEE, progress tracker

Options
24567

Replies

  • nik2710
    nik2710 Posts: 49 Member
    Options
    bump for later
  • 61Sarie
    61Sarie Posts: 5
    Options
    Bump
  • GoGoGadgetMum
    GoGoGadgetMum Posts: 292 Member
    Options
    So I retested with my average heart rate for an half hour spin. Average heart rate was 157 which was pretty hard to do not going over the speed which I think you said was about 6.4km(I could be wrong as I cant for the life of me find the original thread) So I walked at 6kmph at 12 incline.

    HRM 190
    Calc 221
    fitbit 145

    So this time compared to the walk/run link it was close to 20% under. One weird thing was that the fitbit registered me walking at 6.6km.

    I wondered if the high incline may have put it out too much? Would you suggest I retest at a higher speed and lower incline. But I only have little short legs so it will end up a jog.

    Thanks
  • heybales
    heybales Posts: 18,842 Member
    Options
    So I retested with my average heart rate for an half hour spin. Average heart rate was 157 which was pretty hard to do not going over the speed which I think you said was about 6.4km(I could be wrong as I cant for the life of me find the original thread) So I walked at 6kmph at 12 incline.

    HRM 190
    Calc 221
    fitbit 145

    So this time compared to the walk/run link it was close to 20% under. One weird thing was that the fitbit registered me walking at 6.6km.

    I wondered if the high incline may have put it out too much? Would you suggest I retest at a higher speed and lower incline. But I only have little short legs so it will end up a jog.

    Thanks

    Very interesting. Good memory too.
    Max was 6.3 mph actually jogging flat, so 10 Kmph.
    Walking is max 4 mph, so 6.4 Kmph.

    12% incline probably too steep, as personal efficiency starts making a big difference. You can walk steep emphasizing the glutes or the quads, or balance between them. Or very inefficient with big steps, or way too small steps.

    Probably 5% is max incline.

    But jogging up to 10 Kmph should probably allow getting your HR up to matching 157. Just need a longer warmup then.

    And in the studies, up to that speed the calculations were still within 15 calories of tested.
  • DoxieLove10612
    DoxieLove10612 Posts: 145 Member
    Options
    wow thanks for listing that s/s! This is exciting.
  • aliciab307
    aliciab307 Posts: 370 Member
    Options
    Is this bf calc more accurate?
  • heybales
    heybales Posts: 18,842 Member
    Options
    Is this bf calc more accurate?

    If you dig around studies on those 2 calcs, those are usually considered the two best. What's also nice is they mainly use different body parts. So out of proportion in one area can have some balance by the other formula at least.
    Though, say even at goal weight in years past, if you have small wrists compared to say forearms bigger, or big thighs compared to smaller hips - your body can throw them off badly in mainly 1 direction.
    Usually they get throw off in opposite directions, so the avg still is within 5% of reality. Especially as inches are lost and accuracy improves.
  • GoGoGadgetMum
    GoGoGadgetMum Posts: 292 Member
    Options
    So I retested with my average heart rate for an half hour spin. Average heart rate was 157 which was pretty hard to do not going over the speed which I think you said was about 6.4km(I could be wrong as I cant for the life of me find the original thread) So I walked at 6kmph at 12 incline.

    HRM 190
    Calc 221
    fitbit 145

    So this time compared to the walk/run link it was close to 20% under. One weird thing was that the fitbit registered me walking at 6.6km.

    I wondered if the high incline may have put it out too much? Would you suggest I retest at a higher speed and lower incline. But I only have little short legs so it will end up a jog.

    Thanks

    Very interesting. Good memory too.
    Max was 6.3 mph actually jogging flat, so 10 Kmph.
    Walking is max 4 mph, so 6.4 Kmph.

    12% incline probably too steep, as personal efficiency starts making a big difference. You can walk steep emphasizing the glutes or the quads, or balance between them. Or very inefficient with big steps, or way too small steps.

    Probably 5% is max incline.

    But jogging up to 10 Kmph should probably allow getting your HR up to matching 157. Just need a longer warmup then.

    And in the studies, up to that speed the calculations were still within 15 calories of tested.

    So the guinea pig is back again.

    Did it this time at 8kmphr incline 3... It was bang on for my 157 average hr

    Results
    Exrx 212
    Hrm 184 (202 if I take into the 13.5% from previous test.
    Fitbit 231

    So pretty close to the 15 cal difference you mentioned earlier.

    Thanks for the information. I've been going through your spreadsheet and it seems the only real change I need to make is change active activity to very active. I average 15,000 steps a day and at least once a week 20,000. I wish more mums would realise that it is not sedentary activity being at home a lot. So I'm eating at active tdee for a month then will go from there. Bump to small cut at very active will probably equate to similar daily cals....maybe 100 more.

    Thank you for your time
  • hope002
    hope002 Posts: 1,066 Member
    Options
    bump
  • MrsT_2009
    MrsT_2009 Posts: 90 Member
    Options
    bump
  • Flowers4Julia
    Flowers4Julia Posts: 521 Member
    Options
    Bump :)
  • divemunkey
    divemunkey Posts: 288 Member
    Options
    Heybales, when you do the wrist measurement on the sheet, it says to use the smallest part of the wrist, but should that be taken above (towards the elbow) or below (towards the fingers) the the ulnar styloid process (bony round thing on the back of the wrist)?
  • BarbellCowgirl
    BarbellCowgirl Posts: 1,271 Member
    Options
    Heybales, can I ask a quick question about the BMF adjustment?
    I am 65",160lbs, 28% BF

    Doing the BodyMedia calculations as you mentioned in another thread I came up with:

    My average number of cals burned while sleeping was 1.17 cals/min X 1440 = 1685

    While sitting at rest was 1.18 cals/min X 1440 = 1699

    I entered my info into the BodyMedia tab. The calculations came out to:
    Katch BMR: 1504
    Mifflin: 1455
    Cunningham RMR:1655

    The height adjustment suggested was to adjust to 70". That's a 5" increase. Is this correct? It seems it would actually skew the data the wrong way, but perhaps I am misunderstanding the adjustment.

    Thank you
  • RetiredAndLovingIt
    RetiredAndLovingIt Posts: 1,394 Member
    Options
    bump
  • heybales
    heybales Posts: 18,842 Member
    Options
    Heybales, when you do the wrist measurement on the sheet, it says to use the smallest part of the wrist, but should that be taken above (towards the elbow) or below (towards the fingers) the the ulnar styloid process (bony round thing on the back of the wrist)?

    Hand side, though I guess bad inflammation could skew it. But trying to get just bone aspect, usually little fat there, though it can lower slightly.
  • heybales
    heybales Posts: 18,842 Member
    Options
    Heybales, can I ask a quick question about the BMF adjustment?
    I am 65",160lbs, 28% BF

    Doing the BodyMedia calculations as you mentioned in another thread I came up with:

    My average number of cals burned while sleeping was 1.17 cals/min X 1440 = 1685

    While sitting at rest was 1.18 cals/min X 1440 = 1699

    I entered my info into the BodyMedia tab. The calculations came out to:
    Katch BMR: 1504
    Mifflin: 1455
    Cunningham RMR:1655

    The height adjustment suggested was to adjust to 70". That's a 5" increase. Is this correct? It seems it would actually skew the data the wrong way, but perhaps I am misunderstanding the adjustment.

    Thank you

    So those 2 reading averages are so close it tells me the sensors really aren't working well for the heat related reading, there should be difference between BMR and RMR, as the Katch and Cunningham show a spread.

    And the BMF has not lowered closer to the Katch BMR with it's adjusted value, if it is much.

    Because it in general would need to come up, from around Mifflin to a higher Katch value (great news, more LBM than expected for your age, weight, height).

    The formula actually averages BMR with RMR, from calculated values.

    Sounds like your device is not only bad with sensors for you, but wrong direction. Or you sleep really warm, more than expected.
  • BarbellCowgirl
    BarbellCowgirl Posts: 1,271 Member
    Options
    Heybales, can I ask a quick question about the BMF adjustment?
    I am 65",160lbs, 28% BF

    Doing the BodyMedia calculations as you mentioned in another thread I came up with:

    My average number of cals burned while sleeping was 1.17 cals/min X 1440 = 1685

    While sitting at rest was 1.18 cals/min X 1440 = 1699

    I entered my info into the BodyMedia tab. The calculations came out to:
    Katch BMR: 1504
    Mifflin: 1455
    Cunningham RMR:1655

    The height adjustment suggested was to adjust to 70". That's a 5" increase. Is this correct? It seems it would actually skew the data the wrong way, but perhaps I am misunderstanding the adjustment.

    Thank you

    So those 2 reading averages are so close it tells me the sensors really aren't working well for the heat related reading, there should be difference between BMR and RMR, as the Katch and Cunningham show a spread.

    And the BMF has not lowered closer to the Katch BMR with it's adjusted value, if it is much.

    Because it in general would need to come up, from around Mifflin to a higher Katch value (great news, more LBM than expected for your age, weight, height).

    The formula actually averages BMR with RMR, from calculated values.

    Sounds like your device is not only bad with sensors for you, but wrong direction. Or you sleep really warm, more than expected.

    Thank for taking the time to answer. It's interesting because I've had this for about 9 months and I lose .8 lbs a week when I have a 500 cal deficit (18% of my TDEE). So I assumed that was well within the margin of error. I am going to maintenance for a few weeks (or more) and wanted to make it as accurate as possible.
  • heybales
    heybales Posts: 18,842 Member
    Options
    Thank for taking the time to answer. It's interesting because I've had this for about 9 months and I lose .8 lbs a week when I have a 500 cal deficit (18% of my TDEE). So I assumed that was well within the margin of error. I am going to maintenance for a few weeks (or more) and wanted to make it as accurate as possible.

    How close are the bodyfat calcs to each other - within 5%?
  • 1flowergirl
    1flowergirl Posts: 57 Member
    Options
    Bump
  • BarbellCowgirl
    BarbellCowgirl Posts: 1,271 Member
    Options
    Thank for taking the time to answer. It's interesting because I've had this for about 9 months and I lose .8 lbs a week when I have a 500 cal deficit (18% of my TDEE). So I assumed that was well within the margin of error. I am going to maintenance for a few weeks (or more) and wanted to make it as accurate as possible.

    How close are the bodyfat calcs to each other - within 5%?

    No. Actually the Navy method has me at 30%, the Covert Bailey has me at 21%(I wish!!!!). I had a visual estimation done by Sarauk and SideSteel and they put me around 28% so I'm using that value. Very well could be that I am 30+%, but that was the best guesstimate.