Bonii-Prep, the spread sheet app for rally planning, has been updated to v1.12 with an important fix and two new features. The fix corrects a problem with incorrect symbol assignment when there were more than 56 locations. It now works correctly with up to 500 locations and includes instructions for increasing this. If you are using or evaluating Bonii-Prep, you should get this update.
The new features are small unless they are important to you. First, suffix codes can now be used to change both the symbol and symbol color on individual locations. Second, lat/long values can be entered using either a dot or a comma as the decimal character. This is important if you are in a location where a computer expects a comma as a decimal character. Either way, the exported GPX file uses a dot in lat/long values.
There are versions for both Excel and the free LibreOffice spreadsheet that work in both Windows and Mac computers. Bonii-Prep is free for use and available for download at <turnlink.net/rally/>.
Please contact me with questions or problems.
It’s been a busy week. Thanks to all who tried v1.12 and told me about its problems. These have been fixed in v1.12a now available at <turnlink.net/rally/>. Please try it again.
The symbol assignment and sorting problems came from increasing the number of rows available without properly adjusting the formulas and macro codes. I’ve increased the number of rows to 750 and eliminated the instructions for adding more. If you need help with more (and God help you if you do), let me know and I’ll extend a copy for you.
It has also come to my attention that Excel in Mac Office 2011 (Excel v14) does not properly open the files needed for export and import, so I have to drop support for that version of Excel. The inexpensive alternative is the free LibreOffice with the LibreOffice edition of Bonii-Prep which is reliable and has the same features as the Excel edition.
My apologies to all who tried v1.12 and found it screwed up.
Again, pease contact me with questions or problems.