Credit: Rick Corwine |
Credit: Steve Gallant |
Once released, a stampede ensued to reach the elevators to our rooms. Several hours of planning faced each of us. It was going to be a while before I was to get any sleep. Here's where my learning opportunities (mistakes) began. Being a long time Mac user, I'm used to using tab-delimited text files for importing information into Excel. Those coming from the PC world are more accustomed to comma delimited (CSV) files. First thing I do is open the bonus listing text file and paste it into Excel. I notice right away that the availability column is not there.
LESSON LEARNED: Open and look at all files in the rally pack before anything else!!
Leg 1 TXT file |
Leg 1 CSV file |
So for the next 45 valuable minutes, Fat Boy wastes by having to go line by line and entering in the availability codes from the rally book.
Only now can I start my process to plan my route.
Route planning involves an orchestrated movement of files in and out of various programs with the end result of a route or set of routes that will work within the parameters of the rally. Text becomes Excel spreadsheets. Spreadsheets become GPX files (graphics interchage format in xml), Application text become spreadsheets again.
At the end of several hours of work, a plan is born. Leg 1 includes a combination bonus near and dear to my heart. If you visit and document 9 of the 14 Southeast Conference Football Stadiums, you can score an additional 2500 points. The stadiums alone are very low points, but the lure of the combo bonus is substantial. With that in mind, my route has me heading out of Lexington after bagging the University of Kentucky stadium (along with 80 other bikes in the parking lot) and moving southwest through Tennessee into southwest Arkansas to collect some big point time restricted bonuses. I would then work my way back NW through Hot Springs and Fayetteville where I planned to take a short 3-4 rest. On Day 2 I would head back east collecting some daylight only bonues before making the most of my stadium runs through Mississippi, Alabama and Georgia. I would take an 8 hour rest bonus (big points) in Georgia and then focus on scrambling around the checkpoint area in Maggie Valley, NC on Day 3 making sure I arrived before midnight.
After transferring the route plans to my 2 GPS units I ran into a problem. In addition to the 2 Garmin GPS units, I also load my plan into my iPad Mini that runs the gps app CoPilot GPS. This app is helpful as I can quickly and easily zoom in and out to see the area around a route or bonus. For some reason, the information would not load into CoPilot. I finally gave up as I needed sleep desperately. This would come back to haunt me dearly during the rally. Just after midnight I turned off the light for an anxiety filled fitful sleep.
Great post with a valuable lesson. I appreciate you sharing it; I missed it too and spent too much time going through the book to fill the gap.
ReplyDeleteLove it!
ReplyDeleteJames, just started to read. With the text file you used, I think the "comments" column is the page number in the book. A sort on this column might have made adding the availability data faster to add. I used the CSV file and did not pick up on this until later, it would have made data entry faster for me if the sort was by page number. Having fun reading. John Frick, Cincinnati, OH
ReplyDelete