<< Previous Topic | Next Topic >>Return to Index  

Bonii-Prep update

February 17 2017 at 10:09 AM
Charles Turner  (Login Homefire)

 
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.
-Charles Turner
cpturner@turnlink.net

 
 Respond to this message   
AuthorReply
Charles Turner
(Login Homefire)

Bonii-Prep Update v1.12a

February 19 2017, 10:47 AM 

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.
-Charles Turner
cpturner@turnlink.net

 
 Respond to this message   
Ron Messick
(Login mess533)

Re: Bonii-Prep Update v1.12a

February 19 2017, 6:27 PM 

Thanks Charles, for all the hard work. I'm having great success with this latest version.

 
 Respond to this message   
Charles Turner
(Login Homefire)

Bonii-Prep update 1.13

February 28 2017, 12:46 PM 

BP v1.13 is now posted. There are two notable changes–one fix and one new feature. The fix is for the additional Route boxes on sheet 3 (Routes). They now sort properly, each independent of the others. These boxes can be useful for comparing different routings. Other lesser bugs have also been squashed.

The new feature is optional Extended Content in exported files. If the export selection area is extended over into the yellow area to include the Leg column or the Leg and Suffix columns, those values will be included in the exported waypoints and combo tracks to the GPX and TXT files. This extra information is ignored by BaseCamp when importing, but is recognized when importing the GPX file back into Bonii-Prep. This provides a convenient way to preserve your Leg and Suffix information outside of the Bonii-Prep program.

The TXT file format has been expanded to include the Extended Content, and reorganized so it is a straight copy/paste into Bonii-Prep columns. Content is in tab delimited format.

As always Excel and LibreOffice versions that work in both Mac and Windows are available free at

Contact me with problems or questions.

-Charles
cpturner@turnlink.net
SuperSherpa

 
 Respond to this message   
Charles Turner
(Login Homefire)

Bonii-Prep update 1.13a

March 7 2017, 9:22 AM 

BP v1.13a offers a feature modification and revised guidance on file paths for importing and exporting.

The symbol assignment option that allows for substituting symbols using suffix codes has been revised to optionally keep or remove the previously assigned color. This allows for changing a “pin, green “ symbol to “blue, green” or changing it to “heliport” using a single code. Details are in the drop comments.

The revised guidance for entering file paths for export and import applies to Mac users of Excel. Excel v14 (Office for Mac 2011) will work if the disk name is included in the file path. Mac Excel v15 will work with or without the disk name in the file path.

Mac users of LibreOffice must continue to specify a file path without the disk name.

As always Excel and LibreOffice versions that work in both Mac and Windows are available free at
turnlink.net/rally/

Contact me with problems or questions

-Charles
cpturner@turnlink.net
SuperSherpa

 
 Respond to this message   
 
  << Previous Topic | Next Topic >>Return to Index  
Find more forums on Network54Create your own forum at Network54
 Copyright © 1999-2017 Network54. All rights reserved.   Terms of Use   Privacy Statement