Spreadsheet Link

cycletrak1
cycletrak1 Posts: 607 Member
Here is the spreadsheet for the July 4th Challenge that I made, based off of the previous Easter Challenge. :)

https://docs.google.com/spreadsheets/d/1jam6TEnnOltAR8fiStEXcxOfEM05c3OGc9kJsXQ2uT8/edit?usp=sharing

If you are not already listed on the July 4th Challenge Spreadsheet and want to be, just add your info to the BOTTOM of the spreadsheet under the last name listed. By entering your name at the bottom, it will preserve the complex formulas that automatically calculate the weight loss/gain. We'll take care of alphabetizing the names.

Also, please do not insert your name alphabetically into the spreadsheet because the row that is inserted will not have the formulas for calculating the weight loss/gain. :)

Once you enter your initial data, all you have to do is enter your weight in the appropriate "weigh-in" column each week. The formulas will automatically calculate the weight loss/gain. If for some reason it is not calculating, please email me so that it can be fixed. :)

:flowerforyou:

cycletrak1
«134567

Replies

  • tephanies1234
    tephanies1234 Posts: 299 Member
    Thank you!
  • bahbedwire
    bahbedwire Posts: 95 Member
    Thanks for this awesome spreadsheet. Has been so helpful to the community. :) Cheers!
  • I added myself to the bottom. name and my weight when I started mfp. Do I need to insert anything else as primary info?
  • cycletrak1
    cycletrak1 Posts: 607 Member
    edited March 2015
    I added myself to the bottom. name and my weight when I started mfp. Do I need to insert anything else as primary info?

    Thank you for remembering to enter your info at the bottom of the spreadsheet list. :)

    The other thing you could fill in before the Challenge starts is your Ultimate Goal Weight UGW (Column E). UGW is the final weight you would like to get down to and maintain.

    Once the Challenge starts, fill in Column C (Starting Weight for this Challenge), Column D (Target Weight for this Challenge) and of course your weekly weigh-ins.

    :flowerforyou:

    cycletrak1
  • goatsoapgirl
    goatsoapgirl Posts: 17 Member
    Cant put my name there... i am on cell phone is that why.... do i need a laptop or something... thanks
  • playmadcats
    playmadcats Posts: 199 Member
    Am also having same problem.
  • tamhencam
    tamhencam Posts: 86 Member
    Cant put my name there... i am on cell phone is that why.... do i need a laptop or something... thanks

    You will probably need the google sheets app on the phone to make it work. I have an iphone and that's what i had to do.

  • englishmermaid
    englishmermaid Posts: 114 Member
    It wouldn't let me add to it
  • playmadcats
    playmadcats Posts: 199 Member
    Grr new phone now having to be returned after it died on me four days after receiving. Will try again when replacement arrives Monday.
  • Sigma28
    Sigma28 Posts: 83 Member
    Hi everyone! I'm new to challenges. Is there a certain day we should list our weekly weigh-in, or is any designated day alright? Also, a big thank you to cycletrak1 for making the spreadsheet!
  • Sigma28
    Sigma28 Posts: 83 Member
    Oops, never mind. I guess we sign in every Monday.
  • cycletrak1
    cycletrak1 Posts: 607 Member
    edited March 2015
    Sigma28 wrote: »
    Oops, never mind. I guess we sign in every Monday.

    The first weigh-in (Column C-Starting Weight) runs Monday 4/6 thru Sunday 4/12 so you can weigh-in on your regular weigh-in day. It can be any day of the week that you decide. :)

    Thanks for the props on the spreadsheet but @roxilegend was kind enough to start the original basic spreadsheet for our Easter Challenge. Then @lexbubbles & I added extra formulas and a few extra tracking columns. It was truly a group effort!

    For this Challenge, I just made a copy of what the 3 of us had formulated on the Easter Challenge Spreadsheet. :)

    @goatsoapgirl I entered your name on the spreadsheet
    @playmadcats I entered your name on the spreadsheet
    @englishmermaid‌ I entered your name on the spreadsheet

    :flowerforyou:

  • Sigma28
    Sigma28 Posts: 83 Member
    Thanks! And also a thank you shout out to roxilegend and lexbubbles too for their efforts! :smiley:
  • joshuapowell1989
    joshuapowell1989 Posts: 163 Member
    I've added my name, hopefully the thought of having my data available for others to see will give me a positive push in the right direction!
  • rkcampbell
    rkcampbell Posts: 188 Member
    Thank you so much for doing this!
  • literique
    literique Posts: 85 Member
    Added my name to the bottom. So excited for this to begin!
  • Tried to add my name but it wouldn't let me......
  • cycletrak1
    cycletrak1 Posts: 607 Member
    Tried to add my name but it wouldn't let me......

    I added you to the spreadsheet. :smile:

    tamhencam suggested adding the google sheets app to the phone to make it work. They had an iphone and that's what they had to do.

    I use a computer to access the spreadsheet--it's just easier for me than the tablet/phone. :smile:

    :flowerforyou:
  • gizmom19
    gizmom19 Posts: 49 Member
    I can't seem to scroll to the bottom to add my name to the spreadsheet.
  • cycletrak1
    cycletrak1 Posts: 607 Member
    gizmom19 wrote: »
    I can't seem to scroll to the bottom to add my name to the spreadsheet.

    I added you to the spreadsheet.

    :flowerforyou:
  • Hi I would like to be added but can't seem to do it?
  • bjpryor30
    bjpryor30 Posts: 14 Member
    I would also like to be added but can't from my phone. Can you please add me?

  • caaber01
    caaber01 Posts: 28 Member
    I downloaded the Google app but still can't add my info via my iPhone - any other suggestions? I would ask someone to add me but shouldn't I be able to add my own info weekly?
  • shaunjadon
    shaunjadon Posts: 56 Member
    Sorry to be a problem child but I also cannot at to the spreadsheet. Apparently my browser at my job is out of date. Since I'm scheduled night shift for the next few nights, I will probably be unable to access my computer at home. I don't want to forget which I'm apt to do after a few sleepless nights.

    Username: jaznia15
    MFP SW: 254
    CW (as of today): 249.8
    Goal by July 4th: 225
    Ultimate Goal: 145

    If someone could add my name to the list, it would be much appreciated!!!
  • Gingerspice45
    Gingerspice45 Posts: 137 Member
    just joined the spread sheet. I hope this gives me more motivation to try harder. Excited.
  • LogicalDaydreamer
    LogicalDaydreamer Posts: 286 Member
    shaunjadon wrote: »
    Sorry to be a problem child but I also cannot at to the spreadsheet. Apparently my browser at my job is out of date. Since I'm scheduled night shift for the next few nights, I will probably be unable to access my computer at home. I don't want to forget which I'm apt to do after a few sleepless nights.

    Username: jaznia15
    MFP SW: 254
    CW (as of today): 249.8
    Goal by July 4th: 225
    Ultimate Goal: 145

    If someone could add my name to the list, it would be much appreciated!!!

    Added!

  • rainbowzebra25
    rainbowzebra25 Posts: 12 Member
    caaber01 wrote: »
    I downloaded the Google app but still can't add my info via my iPhone - any other suggestions? I would ask someone to add me but shouldn't I be able to add my own info weekly?

    I'm the same? How do we update each week without having to ask one of you?

    MFP SW 191
    Current 189
    Goal 164
    Thanks to anyone who can add me :)
  • littlebabekitty
    littlebabekitty Posts: 398 Member
    edited March 2015
    Hi guys i joined and entered into spreadsheet. Cant wait to start loosing weight!!
  • clairebeaven
    clairebeaven Posts: 20 Member
    Brilliant spreadsheet, should keep us all motivated- Thank you!! :smile:
  • Jenjaz1910
    Jenjaz1910 Posts: 433 Member
    Hi all,
    I can't add the google app to my phone until I have wifi access (which won't be till this evening) and my work laptop won't load the spreadsheet properly, as I am impatien can someone add me to the spreadsheet please?

    Username: Jenjaz1910
    MFP SW: 179lbs
    CW (as of Monday 23rd): 172lbs
    Goal by July 4th: 152lbs
    Ultimate Goal Weight: 138lbs

    Cheers Jen x