Tuesday, January 31, 2012

Race compilation

I've computed relative time* for each skier for each race and used these to rank the skiers in both classic and skate technique. The spreadsheet is on google docs.

*It's really relative speed and is computed as 3rd fastest time overall (among all teams) divided by your time. So the number is how fast you were relative to the 3rd fastest skier. I used 3rd fastest thinking this might be more stable than the fastest skier (since a super fast skier in one race could skew the results among races)

1 comment:

mucklechumps said...

Jeff, you are now my favorite nerd! This is one of the most impressive spreadsheets I've ever seen!!!