Dec. Swim Challenge: CAPTAINS ONLY please

I like the 3rd row you added "Weekly Pace Met" however the pace I listed was Pace Distance for that point in the month - not pace distance for that week. 

Using Cell G10 as an example:

 You have =IF (G8=" ","TBD,IF(G8>=G9,"Yes","NO")

I suggest =IF (G8=" ","TBD,IF($L8>=G9,"Yes","NO")

Steve

Man I hate when I do that, I didn't confirm with bogus data!  OK, better yet, I improved it so that each week stands alone for the pacing by summing the present and previous week(s) to the pace.  So one can see if they slacked or not and made it up the following week.

I attached an update template, check it out...

Let's go ahead and post on the 4th for the first 3 days.  You can tell the smack talk is pretty bottled up!

Team Canada Spreadsheet

22 participants!

Here is our spreadsheet for the week.

Midwest Blizzards spreadsheet.

Thanks All,

I'm working on and off on the compiled teams spreadsheet, I'll most likely have it done later tonight.  Make sure you post any updates to your team and the results for me.  Thanks again!

Attached is the team FL Fish speadsheet.

Hey Captains!

I went ahead and completed what needed to be completed to get the results out today and posted it on the main thread.  I'm going to be swamped here at work the rest of the week.  Also attached is the compiled spreadsheet for all teams.  We may have a few people to add along the way and I can update the results if there is a need to.  Happy swimming!

Crazy Canucks - Spreadsheet Updated - Monday December 4th

 I had a couple more people join our team.  I also noticed the Calculations on our Team Results Summary near the top of the spreadsheet weren't summing the correct cells (missing some cells).

Thanks for your work DRM. 

Steve

Steve found an error and upon rechecking there were two errors total.  Here are the updated results for week 1 with the Wk1-R1 spreadsheet attached:

Dear Captains,

It appears I may have a team member situation that requires some concurrence.  The team member in question does not have any log inputs and still has not read the PM.  If this team member does not have any log input by Monday's weekly deadline I request to remove this team member from my teams roster...

Ack!

When was the last time the person checked in with any of the team posts? 

Midwest Blizzards Spreadsheet Dec. 10, 2006

FYI - I also have a teemmate that has no logs so far this month.  I am game to drops those people but I also am game to give it another week.

Thanks for the feedback. Last time the team member was on BT was Sat AM.  But they have not looked at the PM yet as it is still in my Inbox and it was sent 12-4.  They have zero logs so either they track privately or...

Anyways, I'll give them another week to see what happens.