Here's a link to the spreadsheet: https://docs.google.com/spreadsheet/...ySVp4aHc#gid=2
It’s that time again when we give thanks to our Maker for the privilege to kick some butt on the road and in the pool. As usual we are keeping things simple and only permitting running, cycling, and swimming with adjustments made to the cycling/swimming mileage to put everything on the same level. Here’s the adjustment ratios:
3.5 cycling miles = 1 running mile
400 meters = 1 running mile
These ratios worked pretty well last year so I vote we keep them the same.
Now let’s revisit last years amazing challenge.
2013 Winners:
Most miles: CJF – Dude put in over 400 miles
and looks like he’s in for 2014 so time for someone (P-diddy?) to claim the title.
Most consistent: Ohio Blue – unfortunately my nickname of Jerome the metronome didn’t stick….which might be due to his name not being Jerome or anything close to it.
Most improved: scottie – Time for him to join the big leagues and go for a top ten finish!
We'll have the same categories this year, but let me know if you want any added in addition to these. I run this thing as a dictatorship so categories are subject to my approval, but, as always, I can be swayed by public opinion.
Charity: In the past we’ve donated some money to charity based on mileage and have allowed the winner to pick the charity of choice. This was all completely voluntary but I think we totally didn’t get it done last year as I don’t recall any record of it. Do we want to allow for this again this year? I like the idea but if no one cares then I’m fine bagging it.
Spreadsheet Tracker: We’ll use a similar spreadsheet tracker as in past years. Basically you just have to put your name on the first tab, then your name will flow through to the other tabs automatically. Then, after your run/bike session you just have to input the miles/meters into the appropriate tab "Running" for a run, "Cycling" for a bike ride, and “Swimming” for, well, a swim. Just input your miles as miles and meters as meters and the spreadsheet will automatically adjust them based on the run/bike ratio of 1:3.5 and the run/swim ratio.
For those that are more visual learners, here's a step by step method including pictures:
Step 1: Input your name on the "Total" tab and also mark whether or not you are participating in the charity portion of the challenge
2013cs.JPG
Step 2: Let's say I ran 6.2 miles on the first day of the challenge. I'd go to the "Running" tab and input "6.2" into the appropriate cell...
2013cs2.JPG
Step 3: Let's say I rode 25 miles on the second day of the challenge. I'd go to the "Cycling" tab and input "25" into the appropriate cell...
2013cs3.JPG
Step4: You can then see your overall total mileage as well as how you stack up against other CSers by going to the "Total" tab...
2013cs4.JPG
It’s that time again when we give thanks to our Maker for the privilege to kick some butt on the road and in the pool. As usual we are keeping things simple and only permitting running, cycling, and swimming with adjustments made to the cycling/swimming mileage to put everything on the same level. Here’s the adjustment ratios:
3.5 cycling miles = 1 running mile
400 meters = 1 running mile
These ratios worked pretty well last year so I vote we keep them the same.
Now let’s revisit last years amazing challenge.
2013 Winners:
Most miles: CJF – Dude put in over 400 miles
and looks like he’s in for 2014 so time for someone (P-diddy?) to claim the title.Most consistent: Ohio Blue – unfortunately my nickname of Jerome the metronome didn’t stick….which might be due to his name not being Jerome or anything close to it.
Most improved: scottie – Time for him to join the big leagues and go for a top ten finish!
We'll have the same categories this year, but let me know if you want any added in addition to these. I run this thing as a dictatorship so categories are subject to my approval, but, as always, I can be swayed by public opinion.
Charity: In the past we’ve donated some money to charity based on mileage and have allowed the winner to pick the charity of choice. This was all completely voluntary but I think we totally didn’t get it done last year as I don’t recall any record of it. Do we want to allow for this again this year? I like the idea but if no one cares then I’m fine bagging it.
Spreadsheet Tracker: We’ll use a similar spreadsheet tracker as in past years. Basically you just have to put your name on the first tab, then your name will flow through to the other tabs automatically. Then, after your run/bike session you just have to input the miles/meters into the appropriate tab "Running" for a run, "Cycling" for a bike ride, and “Swimming” for, well, a swim. Just input your miles as miles and meters as meters and the spreadsheet will automatically adjust them based on the run/bike ratio of 1:3.5 and the run/swim ratio.
For those that are more visual learners, here's a step by step method including pictures:
Step 1: Input your name on the "Total" tab and also mark whether or not you are participating in the charity portion of the challenge
2013cs.JPG
Step 2: Let's say I ran 6.2 miles on the first day of the challenge. I'd go to the "Running" tab and input "6.2" into the appropriate cell...
2013cs2.JPG
Step 3: Let's say I rode 25 miles on the second day of the challenge. I'd go to the "Cycling" tab and input "25" into the appropriate cell...
2013cs3.JPG
Step4: You can then see your overall total mileage as well as how you stack up against other CSers by going to the "Total" tab...
2013cs4.JPG
Comment