Data & techie stuff for BAFS 2017

[Vicegrip]

Let’s hope he landed gently into the pile of little blue name bubbles that were directly under him on the chart. Now on to the hard part. Trying to ride my name bubble out of the bubble bin.

[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.

[hozn]

@Brett L. 151839 wrote:

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.

It’s based on the reported precipitation for the weather underground station closest to your ride start location during the timespan of your ride, if memory serves. You can file a complaint with wunderground if you feel slighted

[chuxtr]

Can anyone tell me if it’s possible to import the individual leaderboard into an Excel spreadsheet so that it’s formatted into columns? That is name, points, days, and miles each in a separate column? I’m trying to figure out an easy way to calculate my Points per Mile Pointless Prize standings that doesn’t involve cutting and pasting into Word, setting up tabs, and then copying and pasting into Excel. If there’s an easy way to do this, I’d at least be able to provide updates on where people stand. If not, I guess I’ll just hand jam at the end. Thank you!

[jrenaut]

@chuxtr 151877 wrote:

Can anyone tell me if it’s possible to import the individual leaderboard into an Excel spreadsheet so that it’s formatted into columns? That is name, points, days, and miles each in a separate column? I’m trying to figure out an easy way to calculate my Points per Mile Pointless Prize standings that doesn’t involve cutting and pasting into Word, setting up tabs, and then copying and pasting into Excel. If there’s an easy way to do this, I’d at least be able to provide updates on where people stand. If not, I guess I’ll just hand jam at the end. Thank you!

I’ll try to throw together a leaderboard for you, unless you’d prefer it be a surprise at the end.

[chuxtr]

@jrenaut 151881 wrote:

I’ll try to throw together a leaderboard for you, unless you’d prefer it be a surprise at the end.

If it’s not too much trouble, a leaderboard would be cool. Points/mile to two decimal places. If possible, to look something like this:

Name Points/mile Points Miles Days ridden

BIG THANK YOU!

[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.]

@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….

[chuxtr]

Brett,

Appreciate the Excel help. May be beyond my feeble skills. Also the Ride Days doesn’t have all the info I need to calculate standings (and tiebreaker). Cheers,

Chuck

[LhasaCM]

@chuxtr 151923 wrote:

Brett,

Appreciate the Excel help. May be beyond my feeble skills. Also the Ride Days doesn’t have all the info I need to calculate standings (and tiebreaker). Cheers,

Chuck

It has the main ingredients, you just have to supply a little math.

You have # of days and # of miles, and you’d just have to apply the formula (10x days plus miles rounded down) to get points. Then you can divide points by rounded down miles to get the standings, then look at your tiebreakers.

[chuxtr]

@LhasaCM 151927 wrote:

It has the main ingredients, you just have to supply a little math.

You have # of days and # of miles, and you’d just have to apply the formula (10x days plus miles rounded down) to get points. Then you can divide points by rounded down miles to get the standings, then look at your tiebreakers.

Doh! Thank you!

[Judd]

It looks like teams have been added to the Freezing Saddles website. Team 10 had one member not showing up (Jan). I was showing up on Team 10 until I hit the “Login” button in the upper right hand corner and reauthorized the Strava connection. I then disappeared entirely from the site entirely. Eeeeek! Help me tech Gods!

[hozn]

@Judd 152420 wrote:

It looks like teams have been added to the Freezing Saddles website. Team 10 had one member not showing up (Jan). I was showing up on Team 10 until I hit the “Login” button in the upper right hand corner and reauthorized the Strava connection. I then disappeared entirely from the site entirely. Eeeeek! Help me tech Gods!

I suspect it will sort itself out, but if you are still off the leaderboard in the AM, let me know. It may be a fix I attempted to make for excluding the slackers team (which turned into a rabbit hole — and didn’t actually happen in the end).

[jwetzel]

@hozn 152424 wrote:

I suspect it will sort itself out, but if you are still off the leaderboard in the AM, let me know. It may be a fix I attempted to make for excluding the slackers team (which turned into a rabbit hole — and didn’t actually happen in the end).

One of my teammates who was on the leaderboard but not on the strava team yet has been dumped from the leaderboard. Related?

[Judd]

@hozn 152424 wrote:

I suspect it will sort itself out, but if you are still off the leaderboard in the AM, let me know. It may be a fix I attempted to make for excluding the slackers team (which turned into a rabbit hole — and didn’t actually happen in the end).

GD slackers ruining everything again.

[Author]

Posts