Dec07 Splash Swim Challenge: CAPTAINS ONLY please (Page 3)

D001 - 2007-12-13 7:12 PM Hi Donto, My original goal was 16,500 due to pool closings this month. I'm ahead of where I'd planned to be (yay!), so I'm going to raise my goal. I'll change it on the spreadsheet. New goal: 22,300 yards. We had some unexpected visitors at the pool today. So swimming has been more, um, "exciting" than I had anticipated. (Check my log if you really want more info....) Happy Swimming! Dee

OK Dee, I have yours and Kendra's changes made. 

pudding heads week 2

 CARP, it turned in last weeks data again, I have the thing updated on my system

Rebellious Reindeers reporting in!

Hopefully I didn't corrupt the spreadsheet this week - LOL

Oh, and I have the same questions as Dee

snowmen for this week

Good morning! Here is the spreedsheet for the Snowballers this week. And I have an increase in goals again for Oceananie to 75,000 yds. She is a swimming monster snowballer And I had the same problem as Dee with the total part of my spreadsheet. So I am sending it to your workshop and you can fix it up there and bring it back here

Chris

Ok I think I fixed Chris' spreadsheet problem.  It looks like she was putting the total for the month in this week, not just this week's total.

Dee,

Sorry, I took a long weekend away from work and BT! 

It appears you are putting the monthly total in for each weeks sub-total. Looking at your entry as an example, you stated that you had 18k+ for week 2, but you only did 8450 for week.  If you use the link to the logs provided (calender view) on the right side is the weeks sub-total.

Just the way it was done since I morphed one of the 1st (original) challenge spreadsheets someone else did a long time ago into what it is now.  I never changed it to use the monthly totals and subtract the difference for the weeks sub-total.

Don 

D001 - 2007-12-17 1:23 PM

Donto - 2007-12-17 10:22 AM Dee,

 

Sorry, I took a long weekend away from work and BT!

It appears you are putting the monthly total in for each weeks sub-total. Looking at your entry as an example, you stated that you had 18k+ for week 2, but you only did 8450 for week. If you use the link to the logs provided (calender view) on the right side is the weeks sub-total.

Just the way it was done since I morphed one of the 1st (original) challenge spreadsheets someone else did a long time ago into what it is now. I never changed it to use the monthly totals and subtract the difference for the weeks sub-total.

Don

 

Well, I understood the issue. I just wasn't sure how you wanted us to handle it. Which one of the following do you prefer we do (a,b,c or d)? a) Clear out the week 1 results. Enter the total amounts (to date) in the week 2 column. (This would give us a running total.) b) Calculate how much people really did in week 2. (Dangerous!) c) Just enter what the log says for week 2, and let you take care of the "other calculations?" d) Something else. Personally, if I get a vote, I opt for "A." It's easy to clear out the Week 1 amounts, and just put the current amounts from peoples' logs in the Week 2 column. Dee

Not sure what to really say Dee. If you just keep adding in the weekly subtotals in the corresponding columns in the spreadsheet, the SS takes care of everything else. If you want to clear the previous weeks and just post the actual work for the week we are on then go ahead. All I need is the data for the week we are on as the master SS has everything compiled.

Here's your teams week 2 SS revised. See what I'm doing here?

Donto

Beth,

Here are your revised week 2 results... 

Revised spreadsheet,

I updated the spreadsheet based on your response to Dee's question

I modified wk 2 to be a formula to subract week 1

oops, I guess I should have read this post first

Judi,

Here's your SS updated for week 2.

Captain Elves,

I have all the data compilied, but I have noticed that a couple of teams have some MIA teammates, this may due to the weather (at least 1), illness (2), MIA, etc.  Let's give it another day before we post the Week 2 results and if you see that someone has updated their logs then we can update and post here.

My team has one MIA but it seems to be do to ab illness and then life issues.  I have asked to see if they are still interested in the challenge.

Here's NN wk2 results for now.

I'm off to the lab and will be away from BT for most of the day...

D001 - 2007-12-17 2:12 PM

Donto - 2007-12-17 1:49 PM

D001 - 2007-12-17 1:23 PM

Donto - 2007-12-17 10:22 AM Dee,

 

Sorry, I took a long weekend away from work and BT!

It appears you are putting the monthly total in for each weeks sub-total. Looking at your entry as an example, you stated that you had 18k+ for week 2, but you only did 8450 for week. If you use the link to the logs provided (calender view) on the right side is the weeks sub-total.

Just the way it was done since I morphed one of the 1st (original) challenge spreadsheets someone else did a long time ago into what it is now. I never changed it to use the monthly totals and subtract the difference for the weeks sub-total.

Don

 

Well, I understood the issue. I just wasn't sure how you wanted us to handle it. Which one of the following do you prefer we do (a,b,c or d)? a) Clear out the week 1 results. Enter the total amounts (to date) in the week 2 column. (This would give us a running total.) b) Calculate how much people really did in week 2. (Dangerous!) c) Just enter what the log says for week 2, and let you take care of the "other calculations?" d) Something else. Personally, if I get a vote, I opt for "A." It's easy to clear out the Week 1 amounts, and just put the current amounts from peoples' logs in the Week 2 column. Dee

Not sure what to really say Dee. If you just keep adding in the weekly subtotals in the corresponding columns in the spreadsheet, the SS takes care of everything else. If you want to clear the previous weeks and just post the actual work for the week we are on then go ahead. All I need is the data for the week we are on as the master SS has everything compiled.

Here's your teams week 2 SS revised. See what I'm doing here?

Donto

Yep. That was option B.

OK! 

BTW, there should be nothing to calculate as going to the calender provides the weeks total on the right side.  I stay away from subtracting the weekly totals from one another as you stated that's dangerous!

My mind is flying with ideas how to change this for the future  

Cat/Donto

question on rule #4

4. Individuals who achieve more than their committed goal will not have these additional swims counted in the first 3 weeks of the challenge (so increase your goal!!!)
EXCEPTION: In the final week of the challenge team members may exceed 100% (up to 120% max,) and use their additional data to assist team members who are struggling to reach their goal

So if someone exceeds their goal before the last week of the challenge, the extra yardage doesn't count, but there's no additional penalty - is that the correct understanding?

thanks!

I'm not enforcing rule #4 anymore because of the issue with pool closures, it would have been a nightmare.  But as captain I believe you should encourage people to push their goals a bit if they expect to continue swimming.  120% max is still the max if it is reached now or later.  So yes any extra work >120% doesn't count and there is no additional penalty.

Thanks Don!