Spreadsheet or not?
kayjosh2422
Posts: 864 Member
Some people have contacted me about a spreadsheet to have when everyone post their weight and be able to track it easier. My last group had about 1200 people and this one is already at almost 700. Some people weight weekly, some weight monthly and people weigh on different days. Personally if I have the time to sit and go through it all, I would rather be exercising. I do understand it is hard for people to sift through all the pages looking for their post from a week or a month ago. Here is what my plan is. We had the first weigh around Jan. 1st. The next weekly weigh in will be the week of Jan. 8th - the 15th. I will post the topic as Weekly weigh in #2 and continue different post for each week numbering them up to 13 which will be the final one. I will also make topics monthly. You have your starting weight and than we will have Monthly Weigh in #2 on Feb. 1st, #3 on March 1st and the final weigh in will be the April Easter weigh in. My advice is to make a note of your weigh in each time or at least what page you posted on each time to be able to go back, copy and past for the next one. If someone wants to commit the time to make a spreadsheet, shoot me a message and lets talk. But for now, this is the easiest way to keep on track and spend the extra time we all have burning calories.
0
Replies
-
That is a great way kayjosh .. We are all accountable to ourselves.
Our stats also show us where we were and where we are currently. Thus the system does it for us.
Thank you for getting this started and creating a group for like minded individuals
Exercise your butt off
and enjoy your time.
Thanks
0 -
Sounds like a great plan. Thanks for all of your hard work.
Cheers,
Bahbedwire0 -
Best wishes to everyone! Thank you Margaret for creating this challenge. Hopefully we will all meet the goals we have set by Easter!0
-
Sounds good to me 0
-
I made a pretty simple Google Spreadsheet that anyone in the group can use. All you need is to do is follow the link at the end of my post. It'll take you to the document so all you have to do is enter your name and starting weight under the correct sections and do so each week. It saves automatically. I've never made one of these for public use so if it doesn't work - Oops!! Here's the link:
https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing0 -
Thanks Roxilegend for the spreadsheet- looks like it would be easy to see results quicker. I though would prefer the ideas suggested by Kayjosh as the spreadsheet doesn't work on an iPad and I always use an iPad.0
-
Thanks roxilegend !0
-
roxilegend wrote: »I made a pretty simple Google Spreadsheet that anyone in the group can use. All you need is to do is follow the link at the end of my post. It'll take you to the document so all you have to do is enter your name and starting weight under the correct sections and do so each week. It saves automatically. I've never made one of these for public use so if it doesn't work - Oops!! Here's the link:
https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing
Awesome. We should use this!
0 -
both ideas are great - using both.0
-
both versions look fine to me. We can also add a second sheet to the spreadsheet that calculates the weight loss for us 0
-
both versions look fine to me. We can also add a second sheet to the spreadsheet that calculates the weight loss for us
I can do that on this one. I've created a sheet to calculate miles for another group.
(I hope you don't mind but I just did a quick tweak to prevent the title row from scrolling as we get more members, and so that the 'dates' scroll and don't cover the names)0 -
lexbubbles wrote: »both versions look fine to me. We can also add a second sheet to the spreadsheet that calculates the weight loss for us
I can do that on this one. I've created a sheet to calculate miles for another group.
(I hope you don't mind but I just did a quick tweak to prevent the title row from scrolling as we get more members, and so that the 'dates' scroll and don't cover the names)
Done. I'll have to update the 'total loss' formula each week, unless I put in 'weekly loss' columns (otherwise it'll just show up as YOU HAVE LOST YOUR ENTIRE BODYWEIGHT until there's data for every week), but it'll do. Will also calculate the % of your starting weight you lost.
Edit: nah, that was annoying me. Auto-calculating* weekly loss columns added.
*Don't edit, pls. Sensitive code.0 -
Could we put the link to the spreadsheet in the top section of the group? Would make it easy to get to. Thanks!0
-
Thanks for doing the spreadsheet for those who want that. For those who don't I will be still making the topics each week and month. You can use either or both. Remember this challenge is about you, what works for you and what you want out of it. It is called a challenge because in the end you are really only challenging yourself! That really is the hardest challenge of all
0 -
Awesome spreadsheet. Thank you roxilegend and lexbubbles. Nice to see our progress.0
-
Awesome! Thanks for creating this, I just added my name 0
-
roxilegend wrote: »I made a pretty simple Google Spreadsheet that anyone in the group can use. All you need is to do is follow the link at the end of my post. It'll take you to the document so all you have to do is enter your name and starting weight under the correct sections and do so each week. It saves automatically. I've never made one of these for public use so if it doesn't work - Oops!! Here's the link:
https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing
THANKS! Just entered my data.
0 -
Just entered my data.0
-
roxilegend wrote: »I made a pretty simple Google Spreadsheet that anyone in the group can use. All you need is to do is follow the link at the end of my post. It'll take you to the document so all you have to do is enter your name and starting weight under the correct sections and do so each week. It saves automatically. I've never made one of these for public use so if it doesn't work - Oops!! Here's the link:
https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing
Great! I put mine in... Thank you!0 -
lexbubbles wrote: »lexbubbles wrote: »both versions look fine to me. We can also add a second sheet to the spreadsheet that calculates the weight loss for us
I can do that on this one. I've created a sheet to calculate miles for another group.
(I hope you don't mind but I just did a quick tweak to prevent the title row from scrolling as we get more members, and so that the 'dates' scroll and don't cover the names)
Done. I'll have to update the 'total loss' formula each week, unless I put in 'weekly loss' columns (otherwise it'll just show up as YOU HAVE LOST YOUR ENTIRE BODYWEIGHT until there's data for every week), but it'll do. Will also calculate the % of your starting weight you lost.
Edit: nah, that was annoying me. Auto-calculating* weekly loss columns added.
*Don't edit, pls. Sensitive code.
Wow, thanks for making my simple spreadsheet totally awesome! I'm not too good with excel coding.
I'm glad that you guys are enjoying it! I think it will be good to easily track our progress and that of our peers.
0 -
So cool~ I have added my weight on. Ta!0
-
Great job on the spreadsheet! Thank you for your hard work!0
-
Nevermind I figured it out! :disagree:0
-
That is correct I'm afraid0
-
The spreadsheet is fantastic! Thank you0
-
@lexbubbles - Nice to see you here! Will you be posting weekly challenges here as well?0
-
Thanks roxilegend !roxilegend wrote: »I made a pretty simple Google Spreadsheet that anyone in the group can use. All you need is to do is follow the link at the end of my post. It'll take you to the document so all you have to do is enter your name and starting weight under the correct sections and do so each week. It saves automatically. I've never made one of these for public use so if it doesn't work - Oops!! Here's the link:
https://docs.google.com/spreadsheets/d/1AtQ0jKyCWqQbtamBdzxWL-duh4CmQ98Aa26vm07ywwI/edit?usp=sharing
Thanks roxilegend !0 -
Thank you0
-
@roxilegend Thanks for the worksheet. It is simple and easy to use (*)0
-
I think both ways are great and I will try both! Helps me stay motivated to see everyone else's progress! This is going to be a great year! Thanks for everyone for participating, it so much easier together!
0
This discussion has been closed.