Captains Lounge - October 2020
Replies
-
@1theresamcvean - all things spreadsheet are @jugar.
As for the Mainebeachbum.... mind if I post an edit to just your team?2 -
@1theresamcvean - all things spreadsheet are @jugar.
As for the Mainebeachbum.... mind if I post an edit to just your team?
That would be great. Thanks so much, Beka! Sorry about the trouble.1 -
1theresamcvean wrote: »@Beka3695 and @jugar Ashley @minstrelofsarcasm and I were talking and wondered if it's possible to have a column on the spreadsheet for LTD. I'm concerned we're missing milestones for celebration and we think this would help. Perhaps there's a way to just have it in or near the Finale columns (U and V) as a function of the starting weight for the month, knowing the LTD at that point, and the sum of the change over the month. Please let us know what you think. I know you have a lot to do and only thinking this would assist you and avoid gaffes like the one I made forgetting one of our celebrants.
I'll have a look at this. It would be up to the members to provide their top weight (or LTD when they first join us), even if it happened well before they arrived. Then it would continue to calculate every month when the finale is done. I'll fool around with this and see - good idea!1 -
@Beka3695
Bigblues11 posted on the Downsizers chat yesterday. I replied and gave her the link to the Shrinking Assets chat.bigblues11 wrote: »Hello!
I'm Jen, 50 yrs old, three amazing adult children and two adorable grand babies with one on the way
I have two silly rescued pit bulls and volunteer with several rescues in the area. I love all animals and nature. My kids call me a hippy dippy lol. I live on the coast in Virginia and love gardening, running, biking, lifting weights and yoga. And of course being on/in the water:)
Looking forward to making this journey with you all! I started in October at 224 pounds and am down to 162.4 as of now. Let's do this!0 -
@jugar
The total steps are not adding up correctly for September. The formula seems to be missing 1 week and the for the other weeks it is adding the wrong column. I did and some extra rows at the beginning of September so I hope I didn’t fool it up.
Also, can you move lfca5317 weigh in day from Sunday to Saturday. Thanks!0 -
-
lindamtuck2018 wrote: »@Beka3695
Bigblues11 posted on the Downsizers chat yesterday. I replied and gave her the link to the Shrinking Assets chat.bigblues11 wrote: »Hello!
I'm Jen, 50 yrs old, three amazing adult children and two adorable grand babies with one on the way I have two silly rescued pit bulls and volunteer with several rescues in the area. I love all animals and nature. My kids call me a hippy dippy lol. I live on the coast in Virginia and love gardening, running, biking, lifting weights and yoga. And of course being on/in the water:)
Looking forward to making this journey with you all! I started in October at 224 pounds and am down to 162.4 as of now. Let's do this!
Thank you!!!0 -
mari_moulin wrote: »
@coll7246 is all signed up already (WaistAways) but we have not heard from them yet. If you are in touch, the team chat is at https://community.myfitnesspal.com/en/discussion/10811817/waist-aways-october-2020-team-chat/latest
@mss9675 could certainly still squeak in! Please let them know to message me directly. Thanks!
And yes, that is weird. 2017? Maybe it would be more fun to do 2017 over again instead of 2020? Hope you're doing well, by the way. Hugs flying across the pond!2 -
lindamtuck2018 wrote: »@jugar
The total steps are not adding up correctly for September. The formula seems to be missing 1 week and the for the other weeks it is adding the wrong column. I did and some extra rows at the beginning of September so I hope I didn’t fool it up.
Also, can you move lfca5317 weigh in day from Sunday to Saturday. Thanks!
Yikes! It was odd - some of the final column had all the weeks and some did not. It should be all ok now. And lfca is moved. Let me know if there are any problems with the October step formulae. Thanks!0 -
Welcome! I know it is past our usual time for new members, but you are here and we are glad to see you. I would suggest you change your weigh-in day to Saturday so that you do not miss week 1, but that is up to you. I'll put you in as Monday with this same weight as your starting and week 1, and you can let your team know if you'd like to change that.Username - mss9675
Weight 188.8
Weigh in day Monday
You will be joining the Mission Slimpossibles! Their team chat is at:
https://community.myfitnesspal.com/en/discussion/10811814/mission-slimpossible-october-2020-team-chat#latest
Go ahead over and introduce yourself as soon as possible, and you'll be off and running. Good luck! Your team captains are @TeresaW1020 and @broncobuddee1 -
lindamtuck2018 wrote: »@jugar
The total steps are not adding up correctly for September. The formula seems to be missing 1 week and the for the other weeks it is adding the wrong column. I did and some extra rows at the beginning of September so I hope I didn’t fool it up.
Also, can you move lfca5317 weigh in day from Sunday to Saturday. Thanks!
Yikes! It was odd - some of the final column had all the weeks and some did not. It should be all ok now. And lfca is moved. Let me know if there are any problems with the October step formulae. Thanks!
It’s still not adding up correctly. Most are missing week 4 from the formula and they are all adding the wrong column for weeks 1,2 and 3. Megan can’t do the winners for September without the correct totals. For example, in row 42 to get the grand total it is adding columns AP, Y, Q, and I. It should be AP, AH, Z, R and J. It’s been awhile since I did a lot with spreadsheets but I think this is right. Sorry to be a pain. Thanks!
0 -
1theresamcvean wrote: »@Beka3695 Hi Beka, Ugh...I missed a member of TWNM who needs to be celebrated. It's Steph @ mainebeachbum who has lost and kept off 30+ lbs. I feel terrible. I think it's too late for you to edit your post too. Please let me know what can be done.
I will get this posted in a bit.... sorry - crazy live
1 -
lindamtuck2018 wrote: »lindamtuck2018 wrote: »@jugar
The total steps are not adding up correctly for September. The formula seems to be missing 1 week and the for the other weeks it is adding the wrong column. I did and some extra rows at the beginning of September so I hope I didn’t fool it up.
Also, can you move lfca5317 weigh in day from Sunday to Saturday. Thanks!
Yikes! It was odd - some of the final column had all the weeks and some did not. It should be all ok now. And lfca is moved. Let me know if there are any problems with the October step formulae. Thanks!
It’s still not adding up correctly. Most are missing week 4 from the formula and they are all adding the wrong column for weeks 1,2 and 3. Megan can’t do the winners for September without the correct totals. For example, in row 42 to get the grand total it is adding columns AP, Y, Q, and I. It should be AP, AH, Z, R and J. It’s been awhile since I did a lot with spreadsheets but I think this is right. Sorry to be a pain. Thanks!
no problem! sorry I have been out all day. I'll go look now...
So, I think it is fine now. Hopefully!!!!!0 -
Welcome! I know it is past our usual time for new members, but you are here and we are glad to see you. I would suggest you change your weigh-in day to Saturday so that you do not miss week 1, but that is up to you. I'll put you in as Monday with this same weight as your starting and week 1, and you can let your team know if you'd like to change that.Username - mss9675
Weight 188.8
Weigh in day Monday
You will be joining the Mission Slimpossibles! Their team chat is at:
https://community.myfitnesspal.com/en/discussion/10811814/mission-slimpossible-october-2020-team-chat#latest
Go ahead over and introduce yourself as soon as possible, and you'll be off and running. Good luck! Your team captains are @TeresaW1020 and @broncobuddee
Thank you. I can go in as Saturday for weigh in. 👍0 -
1
-
0
-
lindamtuck2018 wrote: »
She has reconsidered and is going to stay in this month’s challenge.0 -
lindamtuck2018 wrote: »lindamtuck2018 wrote: »
She has reconsidered and is going to stay in this month’s challenge.
I love it when I finally get in here to check what needs to be done, and it is already taken care of!! So glad she is sticking with it
1 -
@jugar
In rows 25 and 27 to 34 there’s a problem. The pounds lost and percent pounds lost are not calculating. Thanks!0 -
I don't see any problem - did you already fix it? It looks fine to me in any case. Sometimes the spreadsheets don't work well on mobile so if you were on a tablet or phone sometimes it gets weird. Let me know if it still gives you troubles!lindamtuck2018 wrote: »@jugar
In rows 25 and 27 to 34 there’s a problem. The pounds lost and percent pounds lost are not calculating. Thanks!0 -
I don't see any problem - did you already fix it? It looks fine to me in any case. Sometimes the spreadsheets don't work well on mobile so if you were on a tablet or phone sometimes it gets weird. Let me know if it still gives you troubles!lindamtuck2018 wrote: »@jugar
In rows 25 and 27 to 34 there’s a problem. The pounds lost and percent pounds lost are not calculating. Thanks!
Weird! It’s fine now. I do use my iPad so maybe it was wonky earlier.0 -
@jugar Can you please change @ Queenieamy 's starting weight to 175. There was a translations issue with stones and pounds. Thanks!1
-
@Beka3695 Milesone for congrats at month end @ kirsten11872 has entered the 140s. She's at 149.4 and almost to goal.
1 -
Week 1 wrapped! Great job, everyone.
Goal Zone reminder - please be sure your goal zone people weigh in every week! And define their zones. If they go above the top weight 2 weeks in a row, they are back on regular team until they get below that point. Thanks!0 -
@Beka3695 Also regarding Kirsten11872, she didn’t just enter the 140s, she also lost 40+ lbs. I think she’ll keep it off.1
This discussion has been closed.