Forum: Race Officers

Excel question

Richard Holmes
Nationality: New Zealand
Certifications:
  • Club Race Officer
Hello All,  newbie here.
Question, does anyone have an Excel formula that will.input a latitude, longitude, bearing and distance. Which will the produce the target coordinates. Would be really nice if it accounted for N,S,E,W as well.
Many thanks in advance.  Richard H.
Created: 20-Sep-02 11:52

Comments

P
Angelo Guarino
Nationality: United States of America
Certifications:
  • Regional Judge
  • Fleet Measurer
0
Richard, I don’t have an excel sheet, but I use an app called iSailGPS.  It lets u download charts and set waypoints by lat/long as well as bearing & distance from position/WP. 

Once the new WP is created, you can see its coordinates in the WP’s data. 

image.jpeg 240 KB

image.jpeg 239 KB

.... you can export your WP’s as a KLM file, then import that into Excel. 

image.jpeg 287 KB
Created: 20-Sep-02 11:57
P
Michael Butterfield
Nationality: United Kingdom of Great Britain and Northern Ireland
Certifications:
  • International Judge
  • International Umpire
  • International Race Officer
0
Check e trap.
Created: 20-Sep-02 12:00
Paul Kimmens
Nationality: United Kingdom of Great Britain and Northern Ireland
Certifications:
  • Judge In Training
  • Regional Race Officer
0
I have the marklaying spreadheets  which give bearing and distance from the reference point, but they don't calculate the lat and long of the course marks.
Created: 20-Sep-02 12:14
Ken Hardy
Nationality: United States of America
0
Not a simple formula.  Lines of latitude are all the same distance apart on the globe,  but lines of longitude get closer together as you move away from the equator.  There is a relatively simple formula to determine distance between longitude at a given latitude here.  Scroll down to the section "Lengths of a degree" and use the WGS84 datum formula which is what your GPS is probably set to.  If you just need this for a local racing area it might be easier to just calculate an average distance between lines of longitude using a map or a charting application.  Then build the spreadsheet using typical cartesian maths.  You may be able to find a spreadsheet already built for your purpose online.    
Created: 20-Sep-02 12:54
Matt Bounds
Nationality: United States of America
Certifications:
  • National Judge
  • National Race Officer
0
For what purpose are you developing this?

If it's to generate lat/lon of marks - any MBO knows it's far easier and more accurate to find a position relative to a reference point (driving away from it) than to find a specific reference point (driving towards it).  Due to the inaccuracies of GPS, you'll end up "circling the drain" trying to drive to a reference point.  You'll get within 10 meters or so, but that's about all the accuracy you can expect.
Created: 20-Sep-02 14:13
Steve Kuritz
Nationality: United States of America
Certifications:
  • Regional Judge
  • Regional Race Officer
Niklas Norden
Nationality: Sweden
Certifications:
  • National Race Officer
0
Here's a simple one that (at least) works well in Scandinavian waters: 
NewPositionFromDistanceAndBearing.xlsx 9.94 KB
Created: 20-Sep-03 08:05
Lloyd Causey
Nationality: United States of America
Certifications:
  • Regional Judge
  • Regional Race Officer
0
Niklas
We only got  the name of the spreadsheet.  I cannot download that.  Can you provide a link to the spreadsheet or macro?
Thanks,
Lloyd
Created: 20-Sep-04 18:29
[You must be signed in to add a comment]
Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more