Tuesday, June 7, 2011

Reno/Tahoe Odyssey Timing Template

The Google Doc that I used this year as a Reno/Tahoe Odyssey team captain worked so well, I thought I'd share it with anyone who's interested. Here's the link to the Reno/Tahoe Odysey Template.

There are five main parts to the template. The first sheet is an instruction sheet for people who may happen upon the template without seeing this post. It can be deleted if you're comfortable using the template without it.

The first thing you'll need to do when setting up a team is collect everyone's info. This is what the Team Info page is for. This is (I think) all the info you'll need to collect to fill out the registration form - Name, age, sex, address, phone and email. 10k time and t-shirt size. Once you get that all entered , you can start trying to collect the entry fees from your team members...

After you get your team registered, you'll need to get everybody's legs assigned. Once this is done, you can plug the team members names and predicted paces into the Predicted Times sheet. This will calculate for you how long each leg should take, and what the overall time for your team should be. Once you get your actual start time, you can input that at the top right of the sheet, and you'll see about what times of day each leg should start and finish. Of course, these can vary during the actual running of the race, but this is a nice sheet to print out and have along to see how you're doing against your predicted times.

This year, at the captains meeting and packet pick-up, they asked for a list of cell phone numbers for at least two people in each van. Easy enough to use the Phone List sheet for this - just copy and paste the data over from the Team Info sheet.

On to the race. Now, a note on recording the timing of the race. I thought that the "official" time recording sheet included in the Runner's Handbook was a little cramped - it was going to get messy, especially trying to write on it with cold hands at night. So, I created a spreadsheet with a little more room, to record the leg time and total elapsed time after each handoff. As we went along, I copied the data from this sheet legibly onto the official time sheet, which I handed in at the end. A benefit of this is that it left me with a copy of all of out leg times at the end - most teams just turn their sheet in and then have no record afterwards. (You may need to play with the font size if you want this sheet to print onto one page.)

After you rest up a little, hop back onto the spreadsheet and go to the Actual Time sheet. Enter all the leg times, and it will calculate out the paces that were actually run for each leg, as well as cumulative pace for each person's three legs.

Hope this helps, and that people get some use out of it. Of course, simply by changing the leg mileage, you could easily adapt this for Hood to Coast or a Ragnar relay as well. Let me know if this works for you!


Steve said...

This looks vaguely familiar... :p

Turi said...

Yep, I didn't credit the original author. Figured I had manipulated it around enough it was no longer copyrightable... ;)