July Tri Challenge - Weekly Update

1. Cavu9 - 0yds/69.35 miles/23.44miles
2. JohnnyKay - 10643meters/95.4 miles/22.8 miles
3. Jiggies - 0meters/0 miles/0 miles
4. Alpine87 - 0yds/187.14 miles/6.5 miles
5. Trimossy - 10600meters/34.55 miles/4 miles
6. Velasqu7 - 14600 yards/6.5 hours/17.4 miles
7. COgirl - 8700 yards/ 213.25 miles/ 31.67miles
8. grvfrog - 2500 yds/ 9 hours/ 2.9 hours 
9. Norakraemer - 0/3.1 miles/8.55 miles

To All Captains:

I received some very nifty spreadsheets but I find this simple method of reporting the easiest to use when updating the master spreadsheet. Format is Team member (in same order they were first added to team roster and are on the spreadsheet), swim actual, bike actual and run actual.

FWIW. If you wanted to score points with the chief clerk here.

For week 2, just the to-date numbers. No need to do more math.

And thanks for the compliment!

Okeley dokeley Renee, you got it!  :-)

Goddess Renee, thanks for your hard work. I know we all appreciate it!

Just a question, why are some names in red and goals in bold?

Forgot to mention - the ones in red show a discrepancy between what I had recorded as their goals and what you sent me this week. Can you check into that? Thanks.

Rollin Thunder's goals:
Swim: 13,000 m
Bike: 600 miles
Run: 60 miles

Blackbud:
120 bike
36 run
12000 swim

Sorry I'm such a dyslexic weiner.

See what a little spanking will get ya???   She likey!!!

Ok, some #s are still trickling in (only 5 days later) but I wanted everyone to have what I have  going into the weekend.

Please note: I added a column to count how many people were at 25% of goal in all three sports, as of 25% into the month. This is the critical scoring column. The team with most people at or above 25% is Team Crazy 8 with 4 people at or above goal in all 3 sports.

The next calculation we look at is % of goal; this is for tie-breakers. There are 4 teams with 3 people at goal. Their average %age of goal places them as follows:

• 2nd - Team Lucky Lancers with 30% average
• 3rd - Team Hoss with 29%
• 4th - Team Good In-10-tions with 28%
• 5th - Team Guinness with 26%

You might notice that Team Yuengling has a higher %age (27) than Team Guinness. However, Team Guinness has more people who are at or above goal so, therefore, they are ahead of Team Yuengling. See how this works? It's not an aggregrate scoring system. It's # of people who meet their goals that matters.

That's what the standings look like as of this past Monday. Hopefully, all captains can get their #s to me by end of day Monday and you will have a timely update by Tuesday morning.

Happy training this weekend!

Here are some other calculations (average score) to ponder over:

• Team Coeur de Leon: 1.1
• Team Crazy Eight: 1.9
• Team Endless Summer: 1.9
• Team Five Alive: 1.7
• Team Good Intentions: 1.6
• Team Guinness: 1.6
• Team Hoss: 1.9
• Team Lucky Lancers: 2.0
• Team Thunderbird: 1.4
• Team Yuengling: 1.9

Right click the file name and choose "save target as".  Name it anything and save it as type "all files".  Launch excel and select "open file".  Set type to "all files" and go the location where you saved the download.  It will then opoen as excel.