Spreadsheet - Weigh-In Link

cycletrak1

Many folks are still asking about a spreadsheet, so I started this thread so it's easier for folks to find it. This is a link to the spreadsheet that roxilegend created. (Thank You!)

Please note that I went through and entered everyone's initial info from the weigh-in page. I also entered additional columns for MFP Starting Weight, Target Weight and Ultimate Goal Weight since a lot of folks were including that info in the weigh-in thread. Please double check to make sure the info entered is correct.

If your name 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'll fix it later. This is important so that the formulas remain in tact.

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:



INSANITY CHALLENGE - SEE BELOW:

obscuremusicreference

Good job!

lexbubbles

As the person who created all those formulas (@roxilegend just created the basic document - I did all the coding and stuff), it actually doesn't matter as long as you don't 'insert row' (because then your row will be empty - everyone else's will still be fine though). Sorting the sheet A-Z by name will not change them in the slightest

Although I've already done that, so unless we get any latecomers then we all good.

ALSO this spreadsheet has been in an announcement link at the top of the group for a few days now.

Globug583

My info is correct. Thank you so much for this tool. Happy New Year! Onward and DOWNward to ALL!

Cbanjo

Hi

Please kindly include my information as below:

Start MFP weight: May 12, 2014 - 176.5lbs

Start weight for Challenge - 151.14lbs

Goal Weight for Challenge - 141lbs

Ultimate Goal Weight: 140lbs

Lbs to Lose: 10.14lbs

Thanks

CA_Underdog

Mine info is good. Thanks for putting this together!

leelee99075

This is awesome. Thanks for all your work!!

abella1420

Wow, you have really put a lot of work intothis!

I am a late comer, may i still be added to this spreadsheet?

Start weight for challenge 175
Goal weight for challenge 155
Ultimate goal weight 145

archanajoyce

@lexbubbles and @roxilegend - Thank you

peachy_keen

Thanks @lexbubbles, @cycletrak1 and @roxilegend! I added my info. Looking forward to doing this with everyone.

lexbubbles

abella1420 wrote: »

Wow, you have really put a lot of work intothis!

I am a late comer, may i still be added to this spreadsheet?

Start weight for challenge 175
Goal weight for challenge 155
Ultimate goal weight 145

Done

lexbubbles

Cbanjo wrote: »

Hi

Please kindly include my information as below:

Start MFP weight: May 12, 2014 - 176.5lbs

Start weight for Challenge - 151.14lbs

Goal Weight for Challenge - 141lbs

Ultimate Goal Weight: 140lbs

Lbs to Lose: 10.14lbs

Thanks

Done

12qw34

peachy_keen wrote: »

Thanks @lexbubbles, @cycletrak1 and @roxilegend! I added my info. Looking forward to doing this with everyone.

I second this! Great team effort putting this together!

AshleyNicolePedigo

So awesome. Thanks for doing this. So far I am down 1.2 pounds. Maybe add a little more to it by tomorrow when I put in my new weight!

GrammyPeachy

Thanks for all the work on the spreadsheet! It's the best one I've seen so far on MFP!

mrsKOrtiz

AWESOME job. I love it!!

cycletrak1

lexbubbles wrote: »

As the person who created all those formulas (@roxilegend just created the basic document - I did all the coding and stuff), it actually doesn't matter as long as you don't 'insert row' (because then your row will be empty - everyone else's will still be fine though). Sorting the sheet A-Z by name will not change them in the slightest

Although I've already done that, so unless we get any latecomers then we all good.

ALSO this spreadsheet has been in an announcement link at the top of the group for a few days now.

I was also going to change the formulas and do the same "coding" that you did....just you got there first. You did a wonderful job too!

There were folks "inserting rows" which eliminates the formulas. That's why I asked that they add their info to the bottom of the list. I also fixed the missing formulas for those who inserted rows and I also added the formulas for all the folks that I went through and added to the spreadsheet.

The Announcement was put up the day before I posted this thread. I look at the threads, not necessarily the announcements, so thought it would be helpful to have the spreadsheet link here too.

I've also have been sorting the sheet A-Z, whenever I see new folks have been added.

So I guess between all of us, the spreadsheet will be maintained, which is awesome!

:flowerforyou:

cycletrak1

cycletrak1 wrote: »

lexbubbles wrote: »

As the person who created all those formulas (@roxilegend just created the basic document - I did all the coding and stuff), it actually doesn't matter as long as you don't 'insert row' (because then your row will be empty - everyone else's will still be fine though). Sorting the sheet A-Z by name will not change them in the slightest

Although I've already done that, so unless we get any latecomers then we all good.

ALSO this spreadsheet has been in an announcement link at the top of the group for a few days now.

I was also going to change the formulas and do the same "coding" that you did....you just got there first. You did a wonderful job too!

There were folks "inserting rows" which eliminates the formulas. That's why I asked that they add their info to the bottom of the list. I also fixed the missing formulas for those who inserted rows and I also added the formulas for all the folks that I went through and added to the spreadsheet.

The Announcement was put up the day before I posted this thread. I look at the threads, not necessarily the announcements, so thought it would be helpful to have the spreadsheet link here too.

I've also have been sorting the sheet A-Z, whenever I see new folks have been added.

So I guess between all of us, the spreadsheet will be maintained, which is awesome!

:flowerforyou:

Shell_7609

I just joined today, added my starting info to that thread, current weight is 264.6

cycletrak1

shell3569 wrote: »

I just joined today, added my starting info to that thread, current weight is 264.6

Hey Shell, my Biggest Loser Group Teammate...glad to see you here! I added you to the spreadsheet!

:flowerforyou:

Emilina79

My information is correct, many thanks for all your efforts this is great!!

mrsmuckster

I'm not sure what I am doing wrong. I tried to update my weight in this week's column, and though I can get to the cell it doesn't allow me to enter the data ???

cycletrak1

mrsmuckster wrote: »

I'm not sure what I am doing wrong. I tried to update my weight in this week's column, and though I can get to the cell it doesn't allow me to enter the data ???

I'll enter it for you if you want to message me.

TracyeS4

That is so awesome! Thank you @roxilegend, lexbubbles, and cycletrak1 for putting so much work into the spreadsheet!

sharonhouse81

Thanks!

sharonhouse81

Thanks!

cycletrak1

I added a "MFP Total Loss" column to the spreadsheet. I also did the formula coding for that column.
:flowerforyou:

Mspmpayne

cycletrak1 wrote: »

I added a "MFP Total Loss" column to the spreadsheet. I also did the formula coding for that column.
:flowerforyou:

Thank you so much! You are so good at that stuff!

cycletrak1

@Mspmpayne‌ Thank you!
:flowerforyou:

Mspmpayne

Gee.....I know I was on the spreadsheet. I usually weigh-in on Mondays. I just went to recheck the dates for weigh-in and I'm not on the spreadsheet. Did i miss the deadline?

Onoiam50

I'm a bit confused by the spreadsheet, I appear on the past weeks worksheet but not on the other sheet, have entered my weight in the past weeks sheet. It looks like some rows are hidden on the other worksheet.