I have decided to withdraw from this year’s Iron Butt Rally and I wanted to make my bonus preparation spreadsheet tool available to everyone who wanted to use it.
Over the years riding in rallies I have developed a spreadsheet tool ( image below ) that I use to handle most of the work building the bonus names using the convention that I like to use in Basecamp to build routes for a rally.
The tool will build a bonus name following the conventions I like to use based off of many ideas from top rally riders. Among some of the features is that the tool assigns waypoint symbols and waypoint symbol color based on bonus availability and bonus point value. I use waypoint symbols that are available in Garmin’s Basecamp that have the same symbol with at least three different colors. That way I can have three different point value ranges that make it easier to decide on what bonuses I should include in my route planning. I use RED to identify the high point bonuses so it is easier to see them in Basecamp.
The tool will also import bonus GPX files and bonus point files to make getting the raw data easier into the spreadsheet.
You can download my Excel spreadsheet tool by clicking this link: http://www.gregrice.com/rallyplanning/RallyPlanning-Bonus-Prep-Bonus-Points-Import.zip
If you have questions about how to use the spreadsheet tool please review the bonus help file which is downloadable here: http://www.gregrice.com/rallyplanning/Bonus-prep-greg-rice-information-2.jpg
More help is available by going to my “how I rally” webpage where there is a lot more information regarding how to use my bonus prep tool: http://www.gregrice.com/rallys/rallys.html
After reading the help information and my rally webpage you still have questions you can reach out to me and I will try and assist you.
Over the years riding in rallies I have developed a spreadsheet tool ( image below ) that I use to handle most of the work building the bonus names using the convention that I like to use in Basecamp to build routes for a rally.
The tool will build a bonus name following the conventions I like to use based off of many ideas from top rally riders. Among some of the features is that the tool assigns waypoint symbols and waypoint symbol color based on bonus availability and bonus point value. I use waypoint symbols that are available in Garmin’s Basecamp that have the same symbol with at least three different colors. That way I can have three different point value ranges that make it easier to decide on what bonuses I should include in my route planning. I use RED to identify the high point bonuses so it is easier to see them in Basecamp.
The tool will also import bonus GPX files and bonus point files to make getting the raw data easier into the spreadsheet.
You can download my Excel spreadsheet tool by clicking this link: http://www.gregrice.com/rallyplanning/RallyPlanning-Bonus-Prep-Bonus-Points-Import.zip
If you have questions about how to use the spreadsheet tool please review the bonus help file which is downloadable here: http://www.gregrice.com/rallyplanning/Bonus-prep-greg-rice-information-2.jpg
More help is available by going to my “how I rally” webpage where there is a lot more information regarding how to use my bonus prep tool: http://www.gregrice.com/rallys/rallys.html
After reading the help information and my rally webpage you still have questions you can reach out to me and I will try and assist you.