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

Options
1…1415171920…24

Replies

  • heybales
    heybales Posts: 18,842 Member
    Options
    Oh, and to update your spreadsheet but keep your Progress tab with your stats.

    If using Excel, easy to copy Sheet over to another Workbook, so if using Excel on your own.

    If using Google Spreadsheet, do the following.

    Make a Copy of new spreadsheet, giving it perhaps a date related name. Leave it open.

    Go into current spreadsheet that has your stats in it already.
    Right click on the Progress tab and select Copy to ...
    Check the box for the name of the new spreadsheet, and Select.
    Notice will say Done, do not choose to open it since it already is.
    Close this old spreadsheet and go to the new one.
    Right click on Progress tab and Delete.
    Right click on Copy of Progress tab and Rename to Progress.
    Done.
  • heybales
    heybales Posts: 18,842 Member
    Options
    Ok, comment was made about the stats being up to 15 digits.
    Turn out that is an issue with conversion to Excel, on the Progress tab.

    So if you don't want 15 digits, have to change it yourself.

    The google spreadsheet is still fine though.
  • SRH7
    SRH7 Posts: 2,037 Member
    Options
    Thank you :flowerforyou:
  • April_Christine
    April_Christine Posts: 66 Member
    Options
    Bump
  • loriband
    loriband Posts: 54 Member
    Options
    This is great!!! Thanks for sharing.
  • Lila999
    Lila999 Posts: 6
    Options
    Bump
  • dixiewhiskey
    dixiewhiskey Posts: 3,333 Member
    Options
    Very cool!
  • pagermain
    pagermain Posts: 33 Member
    Options
    bump
  • heybales
    heybales Posts: 18,842 Member
    Options
    Very cool!

    Kept taking the concerns and issues I saw reported on the forums, and mainly to help myself run people's numbers easier. Now hopefully easy enough for personal use.
  • volume77
    volume77 Posts: 670 Member
    Options
    bump
  • edinat
    edinat Posts: 159 Member
    Options
    BUMP
  • IAmPersuaded
    IAmPersuaded Posts: 48 Member
    Options
    Exactly the information I have been needing! Thank you!
  • pamperedhen
    pamperedhen Posts: 446 Member
    Options
    Bumpity!! bump! BUMP!
  • Polymorphist
    Polymorphist Posts: 41
    Options
    Funny, I was actually going to sit down tonight and start building my own web page with all of the calculations so I could have them in one place. I'm still going to do that, but I might glance at this spreadsheet to save me some time. I have a hosting plan so i'm probably going to throw it up there when i'm done.

    Okay, on with the construction...
  • okcat4
    okcat4 Posts: 224 Member
    Options
    bump
  • dixiewhiskey
    dixiewhiskey Posts: 3,333 Member
    Options
    Very cool!

    Kept taking the concerns and issues I saw reported on the forums, and mainly to help myself run people's numbers easier. Now hopefully easy enough for personal use.

    I forgot to say thank you.. this saved me a lot of time! I'll be using this again when I need to re-evaluate in the future :flowerforyou:
  • LisaLamb1
    LisaLamb1 Posts: 149 Member
    Options
    Bump
  • heybales
    heybales Posts: 18,842 Member
    Options
    Funny, I was actually going to sit down tonight and start building my own web page with all of the calculations so I could have them in one place. I'm still going to do that, but I might glance at this spreadsheet to save me some time. I have a hosting plan so i'm probably going to throw it up there when i'm done.

    Okay, on with the construction...

    The one very desired request that made spreadsheet easier than web page was the progress tab. Well, even before that it was retaining the info, as opposed to all other web sites can't of course store it.

    I might suggest if you have means of sending email from the site, have option to email current stats back for record keeping of the person doing it as backup.
    And then a saved cookie so if they want to rerun numbers, the cookie and last stats are found and used. Only about 21 number stats.
  • Pamelaniamh
    Pamelaniamh Posts: 611 Member
    Options
    :flowerforyou:
  • Noni2863
    Noni2863 Posts: 36 Member
    Options
    Thank you soooo much for building this spreadsheet.
    I for one will be forever in your debt.

Categories