The Christmas Countdown

Join

Spreadsheet for Weight Tracking

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.

Replies

  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Oops. I figured out a better way to do the formula. I'll update it.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Still making changes. Patience. :)
  • cwilson26
    cwilson26 Posts: 30 Member
    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
    Ready. Finally. :-P I kept screwing up the columns.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    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
    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: 61 Member
    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
    Thanks, I was wondering why it wouldn't let me add anything
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Is it working? I changed it this morning. It should be public now.
  • cmacdonald8
    cmacdonald8 Posts: 20 Member
    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
    Maybe I am dumb but I cannot figure out how to input the info?? It won't let me??
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    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
    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
    Thank you for doing that! You are awesome! :)
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    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
    Thank you, it worked great!
  • KatM2014
    KatM2014 Posts: 263 Member
    Thank you for doing that! :)
  • goldenaurea
    goldenaurea Posts: 16
    Thank You!!!
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    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
    Just inputed my goals and weight! So very excited!!! :)
  • freckles_cmj
    freckles_cmj Posts: 205 Member
    added myself :)

    really hoping to shatter my goal :)
  • amandattown
    amandattown Posts: 17 Member
    This is great! Thank you! Added myself :)
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Remember: the weight for Week One should match your Challenge Starting Weight. I had to do that to get the formulas to work.
  • BeckyZT
    BeckyZT Posts: 2 Member
    Thanks for giving me the incentive to give myself a Christmas present! I am looking forward to achieving that present!
  • freckles_cmj
    freckles_cmj Posts: 205 Member
    i think mine is right now...
  • DianneBoo
    DianneBoo Posts: 226 Member
    Thanks so much! I added mine! Warning to all of you though....I only weigh in on the first of every month! :)
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    Thanks so much! I added mine! Warning to all of you though....I only weigh in on the first of every month! :)
    That's fine. You can just pick a column to add your weigh-in. If you're weighing in on December 1st, just log it on December 4th on the spreadsheet. :) You might want to weigh in on or close to December 25th, though, for the sake of the goal.
  • EnchantedEvening
    EnchantedEvening Posts: 671 Member
    I put a note on the spreadsheet, but just in case you don't see it...

    Don't enter a number under "Weight Lost", "Total Weight Lost", or "Total % Lost". Those fields have hidden formulas that will automatically compute the numbers. When you enter your weight next week, for example, it'll automatically show you've lost 1, 2, 3, whatever pounds in the total.

    If you type a number there, it erases the formula and just keeps the number you type there. That will keep the sheet from computing any of your numbers. You CAN do the math if you want, but why? ;)
  • KatM2014
    KatM2014 Posts: 263 Member
    Just giving this a bump :)

Categories