Updated Rally Planning Spreadsheet - UPDATED
- Thread starter Greg Rice
- Start date
@RobG4 I just sent you an email with an updated rally planning spreadsheet. I think I have fixed the issue of opening files on a Mac.
Test the open files for import bonus data and import bonus points.
Not sure I have fixed the export yet, but I wanted to be sure I am on the right track for working on a Mac.
Here is a link to a zip file also that you can download.
https://www.gregrice.com/2023ibr/2023-IBR-Bonus-Prep-V3H-Bonus-Points-Import-P-RobG.zip
Test the open files for import bonus data and import bonus points.
Not sure I have fixed the export yet, but I wanted to be sure I am on the right track for working on a Mac.
Here is a link to a zip file also that you can download.
https://www.gregrice.com/2023ibr/2023-IBR-Bonus-Prep-V3H-Bonus-Points-Import-P-RobG.zip
Last edited:
@Greg Rice Making progress! I was able to click on the button to import the gpx without a runtime error. I navigated to the file, and when I selected it, I got a runtime error 75, Path/File access Error. I'll send you the screenshot via email. It happens on both the gpx import as well as the bonus point data import.
Hi Greg - I've been using this tool for a few years and love it.
I've downloaded the newer version and have run into an issue --> I've enabled macros and enable editing, but there are still some protected cells. I'm trying to cut n paste straight from another excel spreadsheet. Can't add lat and long.
Thoughts?
TIA
I've downloaded the newer version and have run into an issue --> I've enabled macros and enable editing, but there are still some protected cells. I'm trying to cut n paste straight from another excel spreadsheet. Can't add lat and long.
Thoughts?
TIA
Mark,
Send me an email and I will reply back with the latest version of my spreadsheet.
[email protected]
LeMaitre
IBA Member
LeMaitre
IBA Member
Greg,
Thanks again for doing the hard work on the spreadsheet. Understandably you wrote it for the IBR, how hard would it be to tweak it for shorter length rallies? For example, a 24 hour or shorter rallies will just have a Start and Stop. An option for a rally with just one check point would be advantageous too.
I would consider trying to do it myself, if I was versed in VBA scripts and macros.
Thanks
Mark
Thanks again for doing the hard work on the spreadsheet. Understandably you wrote it for the IBR, how hard would it be to tweak it for shorter length rallies? For example, a 24 hour or shorter rallies will just have a Start and Stop. An option for a rally with just one check point would be advantageous too.
I would consider trying to do it myself, if I was versed in VBA scripts and macros.
Thanks
Mark
Hi Mark,
It would not be to hard as I originally developed the spreadsheet for riding in the Cape Fear rallies. I will get back to you early next week, I am going to be riding this weekend.
Corbinb564
New Member
Yes i see Are you able to take a screenshot and either post it here or email it to me?I was asked by a couple people what is the key benefits of my spreadsheet. So I thought I would share this with everyone. Much of this is on my website also.
Easy to import bonus and points files from a rally master and automatically create a GPX file ready for Basecamp or a GPS.
Easy bonus name creation with bonus code, points and availability.
Automatic calculation of sunrise and sunset based on latitude and longitude. This is good information for daylight only bonuses.
Easy to tag a bonus availability, anytime, daylight only, group photo, etc…
Easy to tag a bonus as part of a combo bonus.
Bonus automatic symbol selection based on points value and bonus availability.
Easy to add comments to a bonus that is imported into Basecamp and then into your GPS so you can see the comments when riding up to a bonus.
Google map link created of the bonus location, you can take a look at the bonus in street view in many cases.
Generates a formatted GPX file for use with Basecamp and or a GPS that includes comments, sunrise and sunset times.
Fast entry into Basecamp with the GPX file that is generated from the spreadsheet with bonus symbols based on point value and availability.
You can also load the GPX file directly into a GPS.
Here are some screenshots showing or Visit now the benefits of my spreadsheet.
Tagging a bonus with a combo bonus code. You can tag a bonus with multiple combo bonuses.
Adding comments to a bonus that carries over to Basecamp and a GPS.
Formatted bonus data in the spreadsheet.
Bonus comments, sunrise and sunset in Basecamp.
How comments, sunrise and sunset look in the GPS.
Comments and sunset also show up on the GPS in the favorites / saved places list. This makes it easier to see when routing to a bonus.
When you tag a bonus to a combo bonus I add that to the GPX file category tag and you can see that on the GPS under saved places. All bonsues tag with a combo bonus then show up under that category ( combo bonus ). This helps keep you from forgetting what bonuses are needed to score that combo bonus.
