Below is a link to a spreadsheet I made to store fishing numbers in. In the sheet, the first number is the GPS number I use for the pass (somewhere around the #4 buoy you can set this to another number if you like.) The sheet has formulas in it to give the distance and initial bearing from the first number to the each other number. This is useful for me to be able to tellat a glance how far a place is without being nearmy boat or GPS. I put in a couple of numbers as examples. The key things to know are: 1. The Lat and Long need to be in
xx:xx.xxx format (degrees:minutes.thousandths of a minute). This is the most common format that I see used. It has to be a colon between the degrees and minutes and has to be a period between the minutes and decimal minutes. 2. Columns D-H are hidden. Leave them hidden, I used these columns to change the decimal minutes to seconds for the math in columns J and K. 3. Columns J and K are calculated fields with fairly longformulas used in the calculations, do not alter these fields directly, only change fields A, B, C, L ,and M. Below is a screenshot of what the sheet looks like and below that is a link to get a copy. There are no macros in the sheet.
Here is a link to get a copy:
http://members.cox.net/dreamweaver21...aring_v1.1.xls