The Spreadsheet - Discussion
Replies
-
Lostcoastline wrote: »Can I change my starting weight? I weighed myself on Sunday and my starting weight is wrong. It should be 128.
Updated per your request.
0 -
Kenda2427 wrote: »
I'm a little confused. I just checked the weigh in sheet and the numbers are filed in for the Jan 20th weigh in which isn't till next week. Am I missing something?"
Here is reply:
The milestone days are now ranking days and not the weigh in days. However, the milestone is now treated as a 10% continuum where the most current weigh in will be placed. This is meant to accommodate all schedules. If any one miss weigh in during the milestone the current weight will move to the next milestone. This will ensure that no one drops out once they join the spreadsheet.
I expect that this will be little confusing in the beginning but will settle in after couple of milestones. Let me know if you need more explanation.0 -
I will weigh and enter my weight every Monday. That's been my routine in the past.
Hope we have great success this time!0 -
The spreadsheet is fantastic, and it seems like doing it this way will be a lot easier for everyone to be included in the rankings. Thanks again for all your hard work putting this together, Balancedwalker!0
-
I tried to update my weight today but couldn't. I went to the weigh in tab but the cell in column D was locked. I put it in column F. Is this correct or what am I doing wrong?0
-
I tried to update my weight today but couldn't. I went to the weigh in tab but the cell in column D was locked. I put it in column F. Is this correct or what am I doing wrong?
It is working fine. Use the link provided in the group info. I am pasting the link here again:
https://docs.google.com/spreadsheets/d/1hdkI2hkyB5DhlGrGIxnweT3UOe0_d1rrEyRIse9TNtM/edit?usp=sharing
0 -
Hi - I'm trying to update but can't see beyond the first 100 rows (cells look blank). Is this just me?0
-
Hi - I'm trying to update but can't see beyond the first 100 rows (cells look blank). Is this just me?
Just checked the spreadsheet and it is working fine. However, on any mobile device the Google spreadsheet is incrementally loaded. You will need to scroll down to get the rest of sheet downloaded and shown. Another reason may be your internet speed.
The best way to view/update the spreadsheet is on laptop/desktop. Also, only the Weigh In sheet can be updated.
0 -
The spreadsheet won't let me edit. The old spreadsheet never gave me issues.0
-
just_special wrote: »The spreadsheet won't let me edit. The old spreadsheet never gave me issues.
Only weigh in sheet could be updated. Try now.0 -
Just for clarification for our 2nd weigh in time. We weigh in weekly on the original tab-Weigh in, and it will update to our weekly weights?
UPDATE: I should have read more comments
I have updated correctly it appears. Thank you so much! 0 -
Thanks for the help, seems laptop is the way forward !0
-
Hi, I entered my starting weight when I joined the group, I believe on the 13th or 14th. Then I entered a new weight both yesterday and today. But when I entered my weight today I noticed that it is showing my start weight as the weight I logged yesterday. Did I update in the wrong place?
My starting weight should have been 174. I then logged 172.8 yesterday and 172.2 today. Thank you!0 -
Thanks for the help, seems laptop is the way forward !shannonlmell wrote: »Hi, I entered my starting weight when I joined the group, I believe on the 13th or 14th. Then I entered a new weight both yesterday and today. But when I entered my weight today I noticed that it is showing my start weight as the weight I logged yesterday. Did I update in the wrong place?
My starting weight should have been 174. I then logged 172.8 yesterday and 172.2 today. Thank you!
No, you entered correctly. Due to some typo the last few eateries were not showing correct start weight. I have corrected yours. Thank you for letting me know.
0 -
balancedwalker wrote: »just_special wrote: »The spreadsheet won't let me edit. The old spreadsheet never gave me issues.
Only weigh in sheet could be updated. Try now.
Works now. Thanks!!0 -
The group target has been revised to 1000 lbs (half a US ton).0
-
lalepepper wrote: »The spreadsheet is fantastic, and it seems like doing it this way will be a lot easier for everyone to be included in the rankings. Thanks again for all your hard work putting this together, Balancedwalker!
TOTALLY AGREE!!!0 -
I obviously do not know what I am doing. I am trying to update my weight in Column D but it won't allow me to change the value that is already there...it seems to be locked but I am sure that it is something I am not doing correctly. Can anyone explain how I make the change? Thanks.0
-
Never mind...I figured it out! It is very helpful if you read the 'Help' tab.0
-
Can you please edit -my Short Term Goal is now 0...I would like it to read 132...I thought I entered this...0
-
Can you please edit -my Short Term Goal is now 0...I would like it to read 132...I thought I entered this...
100 Days Loss Goal is the lbs that any member wants to lose and not the end weight. Though both could be used as goals but for uniformity in the group and formulas to work the Goal need to be 'delta' and not the end weight. You can self update delta whatever you want.
0 -
Can you please edit -my Short Term Goal is now 0...I would like it to read 132...I thought I entered this...
Please check the column G in tab Progress. It now shows 100 Days Goal to be 132 lbs. The Weigh In tab, Column E will show 100 days 'delta' goal. Please note that in your case it will be 16 lbs. We have to be consistent for the group so can't enter 132 lbs here. I hope that it clarifies a bit.
0 -
Hi there. I entered my weight for the 1st milestone but it is registering it as the second. I think its because I forgot about time difference as in UK so missed cut off time of 6pm Los Angeles time. Is there a way to fix this? Many thanks0
-
clare180927 wrote: »Hi there. I entered my weight for the 1st milestone but it is registering it as the second. I think its because I forgot about time difference as in UK so missed cut off time of 6pm Los Angeles time. Is there a way to fix this? Many thanks
An important rule of this group is that after the cut off time/date (ranking milestone) the progress sheet can not be revised for the current weight. All members have 10 days to enter their current weight.
0 -
[quote=An important rule of this group is that after the cut off time/date (ranking milestone) the progress sheet can not be revised for the current weight. All members have 10 days to enter their current weight.
[/quote]
Ok no problem Didnt realise this was the case. Thanks for replying!
0 -
I am a little late with joining... my starting weight on the 1st was 255, on the 11th it was 251, I am now 247.. i'm not sure how to put my starting weight in0
-
Please confirm: i submitted my starting weight before launch. Now, I just opened the spreadsheet and updated my weight on the first page in column D. Is that correct? Thank you.0
-
Will there be a re-sort to alphabitize the list with new additions or will those (like me!) who started late be towards the end? (Just so I know where to look for myself on there!)0
-
Thank you Balancedwalk i was able to finally join. I missed being apart of the discussions. Your first challenge was awesome to be a part of and looking forward to the sequel.
0 -
When is our next milestone?0
This discussion has been closed.