Spreadsheet Link

cycletrak1
cycletrak1 Posts: 607 Member
edited March 2017 in Social Groups
Please feel free to set your own weight loss goal for the challenge.

The spreadsheet is just an added tool to use. It is not required to use the spreadsheet in order to participate in this challenge. o:)

You can enter your weight on the day of your normal weigh-in. Just find the date range on the spreadsheet that corresponds with your particular weigh-in day and enter your weight in that column.

For those who do not weigh weekly, please PREFILL the "Weigh-In Weeks", with your last known weight, until the week of your next actual Weigh-In week.

Enter your Starting Weight in the column with the heading that is highlighted in pink.

Please note that if you have joined us on a previous challenge, check the spreadsheet as your info may already be listed. B)

Spreadsheet Link:
https://docs.google.com/spreadsheets/d/1QZkhViYh_L2SsYseuDDDjU5H5GAsSbtD2TGtvDf8HAE/edit?usp=sharing

If you find a problem with the spreadsheet calculations, please feel free to message me or post a comment. I try hard to make sure everything is correct, but sometimes mistakes happen. :s

Some folks have had trouble entering info on the spreadsheet.
Make sure you have google sheets app downloaded to your device.
(It's too hard to use my Android tablet for this so I use my ProBook laptop to access the spreadsheet.)

If you are still having trouble, use a desktop/laptop computer, log into the MFP website and try clicking the link.

And sometimes, it's just Google having issues.

If those don't work, leave your info on this thread and someone will enter it for you. :)

For those who are new to MFP, or to this type challenge, here is an explanation of some of the spreadsheet column headings:

MFP SW - your weight when you first initially started using MFP. (MFP Starting Weight)
Starting Weight - your weight at the beginning of this challenge
Challenge Target - the weight you are aiming for at the end of this challenge
UGW - the weight you would like to be at the very end of your fitness journey - (Ultimate Goal Weight).

Hope this helps with your fitness journey.

:flowerforyou:

Replies

  • jvcjim
    jvcjim Posts: 812 Member
    it seems that there is an error in the spreadshet formulas. the last 2 weeks i have had to edit my row to correct them.
  • cycletrak1
    cycletrak1 Posts: 607 Member
    jvcjim wrote: »
    it seems that there is an error in the spreadshet formulas. the last 2 weeks i have had to edit my row to correct them.

    @jvcjim Thank you for catching that. <3
    The affected columns were fixed and should calculate correctly now. ;)

    :flowerforyou:
  • kethra
    kethra Posts: 85 Member
    Looks like there's an error in the total challenge loss column (G)

    =SUM (K16,S16,U16,W16,Y16,AA16,AC16,AE16,AG16,AI16)

    It skips from column K to S, skipping the weeks of M, O, and Q. :D
  • cycletrak1
    cycletrak1 Posts: 607 Member
    kethra wrote: »
    Looks like there's an error in the total challenge loss column (G)

    =SUM (K16,S16,U16,W16,Y16,AA16,AC16,AE16,AG16,AI16)

    It skips from column K to S, skipping the weeks of M, O, and Q. :D

    @kethra column AK was missing too :#
    I had modified an earlier version and missed adding those columns. >:)

    Thanks for letting me know. It's fixed now! o:)

    :flowerforyou: