Dec Swim Challenge Goals/Actual Spreadsheet

What happens if more than one team reaches their goal?

Have we decided on a punishment for the losers yet?

If your team loses, you agree to change your signature line to the following for the period of January 1 through January 31.

I joined the swim challenge started by Renee
Lose that thing...I thought there was no way.
but the (insert winning team name) came to fight
their skilz are just out of sight
so humbled weakness our sig line does display. - Morey1

If When Florida Force wins, we have chosen this avatar for ALL the losers to use as their own for the period of January 1 through January 31. No other teams have submitted a humiliation-avatar for the losers.

Edited by Renee 2005-12-01 1:20 PM

(jackass.jpg)

Damn Renee thats funny.

Georgia Shockers: We need a good avatar!!!

Swim stats as of 12/4/05.

• The Great White North is spanking all contenders, at 17% of goal (team aggregrate). Although this is only half of the formula, it's certainly a strong and early showing by the Canucks. 
• Any team at 13% or above is on goal since we are 13% into the month (as of 12/4).
• Several teams have not checked in as of 3 minutes ago. I originally said first reporting week ends 12/11 but some people got excited and jumped the gun so I'm accomodating both the early reporters and the folks who want to report 12/11. If you don't report until 12/12 that's fine, okey-dokey, hunky-dory.

Edited by Renee 2005-12-06 9:53 AM




Attachments
----------------
dec swim challenge.xls (29KB - 76 downloads)

I updated the spreadsheet to include New England Pooltriots stats.

Also, I added 2 columns to give a better idea of where everyone truly stands. As a reminder, this Challenge is being scored on 2 items:

1. Percentage of teammates meeting their goal
2. Average goal attainment percentage for team

After adding the two new columns, things shaped up quite differently than the spreadsheet with only averge goal attainment. As you will see when you open the spreadsheet, having a high number of teammates at or above goal is paramount to winning the challenge. You can have the highest average goal attainment % but if you don't have a high number of teammates at or above goal, as well, you can still lose.

This is an early spreadsheet; next week we'll see total participation and more than a week's worth of swimming effort.

Here are the preliminary standings:

1. Team Canada - 38%
2. Team Utah - 36%
3. Texas Yeehaws - 24%
4. Florida Force - 22%
5. New England Pootriots and  Carolina Curmudgeons - tied with 20%

Laura, sure I will continue posting the overall standing within the post.

For All: I will be offline until next Tuesday morning. Please be sure to report your numbers to your team captain. I will update the spreadsheet upon my return and try to post it here by end of day Tuesday, if my schedule allows.

Here it is folks. Read it and weep or rejoice.

Numbers are (in this order) % of total team goal attainment as of 12/11, percentage of team members at or above 35.5% of goal (11 out of 31 days = 35.5% into the month), and total score.

1. Midwest Blizzards: 43% of overall goal, 92% at or above goal, 67% total score
2. Crazy Canucks: 47-75-61%
3. MidAtlantic Crabs: 40-50-45
4. Carolina Curmudgeons: 31-43-37.1
5. Team Utah: 40-33-36.6
6. Northeast Pooltriots: 34-33-34
7. Florida Force: 29-33-31
8. Southwest Swashbucklers: 32-25-29
9. Georgia Shockers: 32-25-28
10. Texas Yeehaws: 28-17-22
11. Pacific Ring of Fire: 26-17-21

Notice that the effect of having a high percentage of teammates simply meeting their goal can push a team into the lead, even if their average % of goal is lower than another team's. Do not underestimate the importance of simply meeting your respective goal.

Are the Gamecock Wahoos still in the competition or not? Nobody reported from that team.

Pipe down, cheesehead.

What, of your cheesey head or of the fact that apparently there's nothing better to do in the frozen midwest than get to the pool? 

Stop the presses.

It was brought to my attention (thank you, soloryder) that my formulae were wrong. In some cases, I had copied a formula to another team without adjusting for # of teammembers; in other cases, some people had dropped out and I hadn't adjusted for the new # of teammembers. Sorry for the confusion.

Adjusted standings are as follows:

1. Crazy Canucks: 47-79-63
2. Midwest Blizzards: 43-79-61
3. Team Utah: 40-80-60
4. MidAtlantic Crabs: 40-67-53
5. Carolina Curmudgeons: 31-38-34
6. Southwest Swashbuckers: 32-33-33.84 tied with Pacific Ring of Fire: 26/40/33.84
7. Georgia Shockers: 32-33-33.62
8. Florida Force: 29-33-31
9. NewEngland Pooltriots: 34-29-31
10. Texas Yeehaws: 28-25-26

Attachments
----------------
dec swim challenge 121105.xls (40KB - 79 downloads)