[Brett L.]

One thing you could do is have diminishing returns on longer ride days, instead of a single bonus. Ie: Points = Daily Mileage ^ 0.9. Having a higher factor doesn’t necessarily penalize long rides, but it would provide some degree normalization to the high outliers.

[Brett L.]

I am Locutus of Borg

Edit: Team name suggestion – Unimatrix zero-seven

[Brett L.]

Cheers everyone! I know a few of you and am looking forward to meeting everyone else! My weekday riding is mostly commuting, but I look forward to plenty of weekend socializing and miles. Just need to tag onto Eric W.’s rides…. If I can survive them!
Jeff – elf dog looks not happy in that picture haha

[Brett L.]

These still available for tonight? They aren’t all sold out yet?

[Brett L.]

@chuxtr 151916 wrote:

Ride Day table doesn’t contain all the data I need.

Points = #Rides * 10 + #Miles

You need Points, Rides and Miles, yes?

[Brett L.]

@LhasaCM 151908 wrote:

FWIW – as a backup plan to a live leaderboard, it’s not a total PITA to do if you use the ride day table (http://www.freezingsaddles.com/people/ridedays), which can be cut and pasted into Excel very easily.

Or do that….

[Brett L.]

Chuxtr

While we’re waiting on the leaderboard, you could also paste into Excel directly and, without worrying about separating into columns, utilize the two formulas directly to parse out number of riding days and number of miles:

# Days:
=IF(ISERR(VALUE(MID(A1,FIND(“days”,A1)-3,2))),VALUE(MID(A1,FIND(“days”,A1)-2,1)),VALUE(MID(A1,FIND(“days”,A1)-3,2)))
\The only reason for the “ISERR” is to accomodate those with single digit riding days. Since you are only accounting for those greater than 30 days and the competition is less than 100 days, you could simplify this forumla.

# Miles:
=VALUE(MID(A1,FIND(“,”,A1)+2,LEN(A1)-FIND(“,”,A1)-7))

Since there are cell references in there, I’ll explain that I have done no formatting to the cells. I did a “select all” of the freezing saddles leaderboard, pasted into Excel, and deleted the preceding cells before Bob J. Each User has it’s own row. It looks something like:

[ATTACH=CONFIG]13140[/ATTACH]

[Brett L.]

Embrace the sleaze!

[Brett L.]

How is the “rainiest ride” calculated? Is it based upon a particular rain gauge and therefore does not pick up upon spatial distribution of rainfall? I only ask because I very clearly remember being unbelievably wet last week, but have no record on that rain chart.

[Brett L.]

@Sunyata 151648 wrote:

Touche….

But the most I have ever done in one day is seven, so this is going to be an adventure for sure.

However, I do think maybe I will organize a W&OD brewery ride a little later in the competition to hit up some of the outer breweries in VA. Stayed tuned for more detail on that later this month!

I would be very interested in joining that

[Brett L.]

Nomination:

Don’t know who you were, but you biked past me on Powder Mill 212 near Springfield Road and Patuxent Wildlife Refuge around 4:15. I was walking back towards Springfield to meet my pickup, because I was stupid and let my flat repair kit at home. Thank you for stopping to offer me assistance with your own repairs – and despite me turning down your offer I do appreciate it nonetheless!

[Brett L.]

Stop being cheeky guys. He’s going to be the butt of a lot of jokes. Your puns are really a pain in the a$$.

[Brett L.]

Lost like tears in the rain

[Brett L.]

2170 – goal for me to beat that
Brett L.

[Brett L.]

I must say, that is a much more sensible location

[Author]

Posts