Drop 20 by Easter 2015 ~ Starts Jan. 1st

Join

Spreadsheet or not?

2»

Replies

  • lexbubbles
    lexbubbles Posts: 465 Member
    archanajoyce wrote: »
    @lexbubbles - Nice to see you here! Will you be posting weekly challenges here as well?

    Hey, AJ! I am indeed. First one's up:

    http://community.myfitnesspal.com/en/discussion/10040038/structured-exercise-challenge-round-1#Item_106

    But you only have 2 more days so lots of catching up to do ;)
  • I_can_do_this2
    I_can_do_this2 Posts: 294 Member
    archanajoyce wrote: »
    @roxilegend Thanks for the worksheet. It is simple and easy to use (*)
    Agreed. Thank you.

  • rose1617
    rose1617 Posts: 469 Member
    Love it! I just added myself to it. I have a spreadsheet of my own that I use to track my losses and it helps so much to keep me accountable. One quick question - are we weighing in on the 8th? I was a little confused by the first column that says 1/8-1/15. Does that just mean you can weigh in any time during that time frame?
    - Thanks all!
  • Amrosha
    Amrosha Posts: 14 Member
    Both are great ideas.....thanks!
  • lexbubbles
    lexbubbles Posts: 465 Member
    rose1617 wrote: »
    Love it! I just added myself to it. I have a spreadsheet of my own that I use to track my losses and it helps so much to keep me accountable. One quick question - are we weighing in on the 8th? I was a little confused by the first column that says 1/8-1/15. Does that just mean you can weigh in any time during that time frame?
    - Thanks all!

    That's just because we started on 1/1 and 1/8 is just one week on from that. If your weigh-in day is different just use whatever day during that time-frame, yeah.

    Personally I weigh daily to keep track of fluctuations, so I'll probably just enter my lowest weekly weight.
  • cycletrak1
    cycletrak1 Posts: 607 Member
    A column has been added to enter your Target Weight for this challenge.

    kayjosh2422 suggested Week 1 cover certain dates, so date ranges were added to the rest of the Challenge weeks.

    :flowerforyou:
  • walking_woman
    walking_woman Posts: 127 Member
    That is quite the spreadsheet. Love the fact that everyone makes their own entries. Great work.
  • Mspmpayne
    Mspmpayne Posts: 267 Member
    @ roxilegend WOW thanks for the spreadsheet! Very nice. =)
  • cycletrak1
    cycletrak1 Posts: 607 Member
    If your name and info has not already been entered on the spreadsheet, then enter your info at the bottom of the list. Do not worry about putting your name in alphabetical order. We will fix it later. This is important so that the formulas remain intact.

    Here is the link Easter Challenge Spreadsheet Link:
    https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing


    This is the same link that you will use weekly to record your weight under the appropriately dated week.

    The pounds lost/gained and percent will automatically calculate for you. :)

    If by chance you do not want your info on the spreadsheet, message me and it will be removed.

    cycletrak1

    :flowerforyou:
  • lexbubbles
    lexbubbles Posts: 465 Member
    roxilegend wrote: »
    lexbubbles wrote: »
    lexbubbles wrote: »
    Arbelina wrote: »
    both versions look fine to me. We can also add a second sheet to the spreadsheet that calculates the weight loss for us ;)

    I can do that on this one. I've created a sheet to calculate miles for another group.

    (I hope you don't mind but I just did a quick tweak to prevent the title row from scrolling as we get more members, and so that the 'dates' scroll and don't cover the names)

    Done. I'll have to update the 'total loss' formula each week, unless I put in 'weekly loss' columns (otherwise it'll just show up as YOU HAVE LOST YOUR ENTIRE BODYWEIGHT until there's data for every week), but it'll do. Will also calculate the % of your starting weight you lost.

    Edit: nah, that was annoying me. Auto-calculating* weekly loss columns added.

    *Don't edit, pls. Sensitive code.

    Wow, thanks for making my simple spreadsheet totally awesome! I'm not too good with excel coding.

    I'm glad that you guys are enjoying it! I think it will be good to easily track our progress and that of our peers.

    You are very welcome. I like making sheets. I find it relaxing (I know, I'm weird)
  • Globug583
    Globug583 Posts: 23 Member
    Love the spreadsheet. Thanks for the tool.
  • lexidear
    lexidear Posts: 70 Member
    thanks so much this is awesome :)
  • rose1617
    rose1617 Posts: 469 Member
    lexbubbles wrote: »

    Personally I weigh daily to keep track of fluctuations, so I'll probably just enter my lowest weekly weight.
    Me too. I know there are people that think it's unhealthy, but it really helps me stay focused.
  • dbanks80
    dbanks80 Posts: 3,685 Member
    I like your way KayJosh since I cannot access the spreadsheet on my work laptop. Which I use dily to log everything. It's most likely I will not log on my personal computer to access the spreadsheet. I can try since it is once a month though.
  • lexbubbles
    lexbubbles Posts: 465 Member
    rose1617 wrote: »
    lexbubbles wrote: »

    Personally I weigh daily to keep track of fluctuations, so I'll probably just enter my lowest weekly weight.
    Me too. I know there are people that think it's unhealthy, but it really helps me stay focused.

    I use myweighttracker.com to record them all and it smooths out the data and gives you an overall sense of what's happening. If I weigh myself weekly and find myself up 2lb one week for no discernible reason it angers me. If I'm weighing daily and turns out that one day I was just high w/water or something then I don't give a rat's *kitten*.

    Weighing less often is actually MORE likely to discourage me for that reason. But then I really like data and make spreadsheets for fun so :P
  • yogicarl
    yogicarl Posts: 1,260 Member
    @pumpithockey - have another look at the spreadsheet. You are in alphabetical order there.
This discussion has been closed.

Categories