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

12357…16

Replies

  • ambrosdm
    ambrosdm Posts: 21 Member
    bump:happy:
  • runway22
    runway22 Posts: 3
    Awesome tool! Thanks!! :)
  • heybales
    heybales Posts: 18,842 Member
    thank you! I just spent the time plugging it all in....took awhile because I am no excel wiz!

    I especially appreciate how when you put in your exercise calories it adjusts off the daily cals so they are not counted double. I have tried to explain this net vs. gross calorie thing to some of my pals and they just hate that! LOL! but, that's why I've lost pounds and maybe because they haven't??

    Anyway, thanks again!

    Edit: cause I can't type/spell either ;-)

    You bet.

    i figured there are enough inaccuracies in food labeling, in the HRM calorie burn too, why not make as exact as possible what can be made that way. Over the course of a week it can add up to 1000 calories easy depending on your workout length and intensity.
    Longer and less intense get the worse effect.
  • heybales
    heybales Posts: 18,842 Member
    Awesome tool! Thanks!! :)

    Wish it wasn't like a swiss army knife with everything under the sun in it, even that one little tool you never know what it's for.
    But everything in there has come up multiple times when running numbers or for myself, so thought it best to include.
  • JMFresh
    JMFresh Posts: 76 Member
    awesome
  • islandgirl3333
    islandgirl3333 Posts: 51 Member
    Bump
  • Lrdoflamancha
    Lrdoflamancha Posts: 1,280 Member
    Bumpity bump
  • jfhbrl
    jfhbrl Posts: 13 Member
    BUMP!!!
  • jnchorn
    jnchorn Posts: 250 Member
    Thanks for sharing. :)
  • rydn4h2o
    rydn4h2o Posts: 255
    bump
  • heybales
    heybales Posts: 18,842 Member
    Thanks for sharing. :)

    Welcome, hope you find it useful and informative.
  • heybales
    heybales Posts: 18,842 Member
    Any suggestions from all the downloaders of the spreadsheet?
  • sandobr1
    sandobr1 Posts: 319 Member
    Ooooh bedtime reading!
  • heybales
    heybales Posts: 18,842 Member
    Ooooh bedtime reading!

    it'll probably send you off to sleep in that case! Which may indeed be a good desired thing.
  • empowerme12
    empowerme12 Posts: 32 Member
    BUMP
  • monastempletransformed
    monastempletransformed Posts: 74 Member
    Thanks
    Bump
  • diverdiza
    diverdiza Posts: 82 Member
    Any suggestions from all the downloaders of the spreadsheet?
    Only (teeny tiny point) that some sentences don't seem complete - a wrapping thing or such because if you click on the cell itself the sentence is all there. Example: PAS level 3 description (HRM tab).
    Really not significant but if you're looking for work.... ;-)
  • heybales
    heybales Posts: 18,842 Member
    Any suggestions from all the downloaders of the spreadsheet?
    Only (teeny tiny point) that some sentences don't seem complete - a wrapping thing or such because if you click on the cell itself the sentence is all there. Example: PAS level 3 description (HRM tab).
    Really not significant but if you're looking for work.... ;-)

    Well, that is good catch. I've tried to look at the Excel conversion and see what can be changed in the Google spreadsheet to make it come out correctly once converted. But only caught a couple major ones that really messed things up.

    I'll have to start making my way through for visual things. That is strange though, must be a change of font size.

    Thanks for comment. Visual changes shouldn't be too bad, Finish a tab at a time hopefully.
  • MariaMariaM
    MariaMariaM Posts: 1,322 Member
    Can't see spreadsheet at work. I need to check it out later.
  • heybales
    heybales Posts: 18,842 Member
    Anyone else use this through Google Documents on Safari on Mac or iPad, and any advice?

    Or at least had the option to download as Excel file and use in Mac's MS Office Excel?
  • stephenson2012
    stephenson2012 Posts: 94 Member
    This is a great spreadsheet. Thanks for the great work.
  • stljam
    stljam Posts: 512 Member
    bookmark
  • doubleduofa
    doubleduofa Posts: 284 Member
    Subscribing
  • Jennical
    Jennical Posts: 219 Member
    Bump...
  • heybales
    heybales Posts: 18,842 Member
    This is a great spreadsheet. Thanks for the great work.

    Glad you like it and hopefully made sense to ya.
  • heybales
    heybales Posts: 18,842 Member
    Subscribing

    I was thinking of doing that on my blog, updates on what I've done to the spreadsheet, and for those subscribed, you'd find out.

    I don't do many blogs, so not a lot of updates otherwise.
  • heybales
    heybales Posts: 18,842 Member
    Can't see spreadsheet at work. I need to check it out later.

    Since you pretty much know how much you need to eat to maintain at your level of workout, I'd be very interesting in your feedback on any of the TDEE calc's you care to compare to what really does work for you.

    I know the standard Harris TDEE calc under-estimated exercise, but I have a feeling the WHO TDEE calc does to, despite 3 separate workout levels for your time.
  • happycauseIride
    happycauseIride Posts: 536 Member
    Bump to keep. Great info.
  • diverdiza
    diverdiza Posts: 82 Member
    heybales - one "real" tweak I'd love is a metric version of the bodyfat tool :-)
  • heybales
    heybales Posts: 18,842 Member
    heybales - one "real" tweak I'd love is a metric version of the bodyfat tool :-)

    Ya, I need to expand the area to make that possible. What worked out was the Covert that has the most measurements used, is already based on inches. And I saw my cloth tape measure and saw that it always had inches and cm's on it.

    Perhaps I should just switch it around, cm's being more accurate anyway.

    I'll have to think about more room.

Categories