The Christmas Countdown

Join

Spreadsheet for Weight Tracking

Options
EnchantedEvening
EnchantedEvening Posts: 671 Member
in Social Groups
I created a spreadsheet on Google Docs. The changes will save automatically every time you update your weight. I'll be sure to adjust the formula every week so it subtracts properly.

https://docs.google.com/spreadsheet/ccc?key=0AmYQhjUzXJOldGtDQVFJejBObWdtVGVYVEJ5alhTMkE

There's room for 200 participants. I can add more if necessary.
«1

Replies

  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Oops. I figured out a better way to do the formula. I'll update it.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Still making changes. Patience. :)
  • cwilson26
    cwilson26 Posts: 30 Member
    Options
    Sorry - that was me...I saw your post, but didn't look at the time. Was anxious to add my info!
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Ready. Finally. :-P I kept screwing up the columns.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Sorry - that was me...I saw your post, but didn't look at the time. Was anxious to add my info!
    It's fine. :) I didn't even see you in there. I posted because I realized something was wrong and didn't want anyone to wonder what was up with the format.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Because of the way the formulas are laid out, you'll have to enter your starting weight under both "Starting Weight" and "Week One 11/6". I missed that redundancy, and changing the formulas will take forever. It'll start subtracting when everyone enters their weight next week.
  • hbdub7
    hbdub7 Posts: 91 Member
    Options
    it appears the spreadsheet is in a "veiw only" state...you will need to open it to the public, so we can all enter our totals! :bigsmile:
  • lorriannly
    lorriannly Posts: 37 Member
    Options
    Thanks, I was wondering why it wouldn't let me add anything
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Is it working? I changed it this morning. It should be public now.
  • cmacdonald8
    cmacdonald8 Posts: 20 Member
    Options
    Is it working? I changed it this morning. It should be public now.

    The spreadsheet is public, but we are not allowed to edit. You should just have one check mark to make, I believe it is "anyone can edit". Thanks for making it, looks great!!!
  • kirapewonka16
    kirapewonka16 Posts: 38 Member
    Options
    Maybe I am dumb but I cannot figure out how to input the info?? It won't let me??
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Is it working? I changed it this morning. It should be public now.

    The spreadsheet is public, but we are not allowed to edit. You should just have one check mark to make, I believe it is "anyone can edit". Thanks for making it, looks great!!!
    Gah. I thought I did that. I'll go fix it.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    Oops. It's blocked at work. I promise to fix it when I get home tonight. I could have sworn I changed it to "edit" today.
  • mangusjm
    mangusjm Posts: 34
    Options
    Thank you for doing that! You are awesome! :)
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    There! It should be good to go. Finally. ;)

    This is my first time using Google Docs, so there was a bit of a learning curve. *blush*
  • cmacdonald8
    cmacdonald8 Posts: 20 Member
    Options
    Thank you, it worked great!
  • KatM2014
    KatM2014 Posts: 263 Member
    Options
    Thank you for doing that! :)
  • goldenaurea
    goldenaurea Posts: 16
    Options
    Thank You!!!
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Options
    You're welcome. :) It's fun to watch the numbers come down as a group/team. I use Thintopia for the same reason.
  • kirapewonka16
    kirapewonka16 Posts: 38 Member
    Options
    Just inputed my goals and weight! So very excited!!! :)

Categories