March Madness Bike Challenge Weekly Results (Page 2)

Team Captains!

Thanks for double dog checking ... the fallacy in the master spreadsheet formula dealt with the value in C5 for the ACC. I checked the rest of the column and did not find a similar misattribution.

While it does drop the ACC to a less lofty position, it does not change the rank order too much - except that the WCC + PAC 10 are now ruling the roost!

It is still anyone's game though, so the team that RIDES LOTS will win!

In the Big 10, we had a member (jcjsc00) increase his goal.  This is not reflected in the master spreadsheet.  Should be 960 minutes instead 750 minutes--will slightly lower our overall percentage, should not change the rankings though. 

 --Craig

Ummmm ... slight correction ...

WCC + PAC 10 Continue ruling the roost!

Go Team

Gotcha ... the goal has been increased.  Here's to hoping they reach 99.99999% of those minutes.

Jerry:

You rock! Thanks for taking the time to go through the spreadsheet.  Runnergirl29 was a late but welcome addition to the SEC Team ... suspect that when I added the line in the spreadsheet, it did not capture in the forumla.

Tucker (Speedball)/Big 12:

I looked at the submittals for weeks 1 + 2. Parker815 is down for a 0 for week 1 ... just want to confirm that it not captured somewhere else.

Michele (zagagirl)/WCC + PAC 10:

Same for you but in reverse ... the 153 number for jerryrika was based upon submittal.  Want to make sure this discrepancy was not accounted for somewhere else.

Please let me know and I'll make the changes - but do not want to make changes unless I have the Team Captain's okay.

Thanks!

He didn't put that time down in his log until after he returned from a trip and after I had submitted week 1.   The time is included with week 2.  Let me know if that is a problem.

Tucker:

Nope ... no problem, we're good -- just wanted to make sure that I did not do something that would cause it to be double counted.

Michele:

What say you?

Big 10 week-3 statistics are attached.

 --Craig

WCC - PAC10   Our bb teams (YEAH ZAGS! Way to Go UW Huskies!) are still dancing and our March Madness Bike Team is still racking up the miles!

My work is crazy busy this morning so I may not get the results in till tonight.  Sorry for the delay.

Cheers

James 

CANADIAN DISQUALIFICATION! 

CANADIAN DISQUALIFICATION!

;^ )

You wish... The losers always want to disqualify the strongest team!  It's the only way they win ... Here is the Canuck data for the past week

Cheers

James 

DRAFT Week Three totals are attached + draft synopsis is below ... please take a look through to ensure that your team's information is correct.  I am 2 for 2 in terms of weekly revisions and want to be sure that we catch any mistakes during the week it occurs.

The SEC suffered a series of set backs this week; Jered (HornJM) had to check himself into the emergency room on Thursday night due to stomach issues ... and they removed his gallbaldder.  Sebastian (Sebjamesm) reinjured his ankle and is beating himself up with an aircast (he cannot flex his ankle at all, so there is not even a chance for swimming w/out a buoy or aquajogging).

Please take a moment to drop into their logs to leave them an inspire or two.

The new rank order for week three is:

Revisions?  Post 'em here and the Team Captain will sort them out. (To ensure that we are all working off of the same set of numbers, any revisions have to have the input of the team captain.)

All in all, it was a good week of cycling all around!  The challenge is definitely working for me ... I am logging miles I never would have if it weren't for fear of letting the others down.

I don't think he said anything about DQing the WCC/Pac-10.

You two want to start something? 

http://www.beginnertriathlete.com/discussion/forums/thread-view.asp?tid=37699&posts=34#M373550

See you there!

Couple of problems on the Big 10 page.   The last four riders are not getting included in the total.  I think the formula for cell G22 should be SUM(G5:G21) instead of SUM(G5:G17).  Also rider kimta did not want her mountain bike time included as part of the challenge so her time for week 3 should be 180 minutes instead of 300 minutes (sorry about that).

--Craig

Craig:

Good catch on the formula!  As a safeguard, I checked the tally from the Big 10's previous two weeks and they correctly accounted for each line-item (I also double checked the other team's aggregates just to be sure). I have also decreased Kimta's minutes from 300 to 180 (although I think Kimta ought to include it as mountain biking is hard work!). 

The good news is that the BIG 10 has moved up to FOURTH PLACE! 

New rank order:

The good news is that no team is "out" of the competition in that what separates the last team from the first team is not insurmountable ... plenty of time to catch-up and take your moment to shine in first place!