Ok guys, here is the new spreadsheet link:
https://docs.google.com/spreadsheet/...DczajVTNkhMd3c
Have a look around. There are a bunch of changes:
1.
colours, just to make it easier to figure out that you are really in the new sheet and not editing the old one :-)
2.
Platoon Total: The percentage changed. It now shows how well we are doing as a team in relation to what we pledged. e.g. 50 lbs pledged, 5 lbs weight lost, 10% of goal reached
3.
Black Ops: Top row shows the % of the real BL contestant with the lowest percentage. That's what we measure against. I couldn't find this weeks yet but I think it was a gain. So as far as you don't gain, you are fine.
I also deleted all the people that didn't report back in the last week (
Sarati, you unfortunately didn't report back either)
4.
PledgeBoard and form: New feature to help Peanutt out a bit with the pledge board. (This is a trial, we will see how well it works I guess.) You can now follow this link:
https://docs.google.com/spreadsheet/...ajVTNkhMd3c6MQ
It is a survey to ask your stats for the week. The information goes to the spreadsheet and creates a table that Peanutt can use to post the pledge board instead of manually collecting the information from the thread.
Unfortunately, it does not (yet?) update your tab on the spreadsheet.
If you made a mistake on the form, you can re-submit the whole form. If we see two (hopefully not more) entries from one person, the last submitted will count.
5.
New members: Peanutt and I agreed that we need to see some commitment before we are going to add new members. It takes some time to create the sheet for a new member and we had quite a lot of members join and disappear after a week or two. Not cool :-(
So, to be added to the spreadsheet, we want to see at least two weeks of pledges, losses and posts before we will add new members. If you are interested, post here or PM me and I will put you on the list for new additions.
Everbody
can use the form to report your stats every Sunday but
do not add yourself to the sheet!
Phew, I think that's all. Now I need a cappuccino!
If you have any questions, comments or if something doesn't work, please let me know.