great circle sailing and rhumb line - how to calculate distance and course (bearing) between two points - marine great circle formulas - navigation calculator

marine great circle navigation calculator

Formulas, programs and calculations to obtain distance and course (bearing) - loxodromic distances (rhumb line) and orthodromic waypoints (great circle sailing) - orthodromic and loxodromic navigation calculator - two spreadsheet excel files - (free download and use!)

distance and course (bearing) between Vigo and Boston .........
great circle sailing (orthodromy) or rhumb line (loxodromic route) ?

 

You can download and use these files ( they are free ! )

1st file - a full version of Great Circle Sailing - Rhumb Line - Waypoints ( full track ) - Route Graph

A full program for all users (students, sailors, officers and masters of the "merchant navy " .... ) : courses, distances (rhumb line & great circle sailing), orthodromic data ( vertex coordinates ), E.T.A. (estimated time of arrival), compass direction, manual-automatic waypoints calculator and planning routes.

This file is created thanks to the remarkable ability of Jelle Schaap in the development of excel programs. It is a logical evolution and completion of the second file. This feature distinguishes the file from many others currently on the web. The program allows the user to customize all navigation data; 60 waypoints (great circle navigation) and 60 rhumb lines can be managed. Instructions are included in the file.

great circle sailing - rhumb lines and waypoints ( manual or automatic )

The sheet "Chart1" shows a diagram with the location of some parameters: great circle navigation, rhumb lines, courses, waypoints

great circle sailing map ( diagram )

This file was created with Office 2007 in a "binary" format so the program can only be used on personal computers with Office 2007 (or later) installed. The spread of Office 97 and Office 2003 is still considerable. It was decided to prepare a compatible version (albeit with limited functions) : a slightly different version of conditional formatting from the "Office 2007 version". In all versions is essential to enable macros before using the program (calculations are not performed without activating the macro, however, see the instructions in the file). Files include translations in languages (English, German, Dutch, Spanish and Italian).

 

DOWNLOAD - versions for Office 97-2003 or 2007 (or later)

 


 

2nd file - Great Circle Sailing - Rhumb Line - (small program)

This simple file provides the following information (navigation data) : course, distances in nautical miles (great circle and rhumb line), initial course and vertex latitude

a view of the spreadsheet (excel file) :

great circle navigation chart of the area

Coordinates must be entered : latitudes and longitudes (degrees- minutes-seconds) "n" for north latitude, "s" for south latitude, "w" for west longitude, "e" for east longitude.

 

DOWNLOAD - version for office 97-2003 or later

 


 

Formulae
calculation for incr. latitude
formula : ( 7915,7 * log tan (45° + lat/2)) - (3437,7 * e*e * sine lat)
calculation for true course (t.c.) - (bearing) rhumb formula : tang. t.c. = longitude difference/increased latitude difference
calculation for loxodromic distance (rhumb line) t.c. < 45° = latititude diff. * sec t.c.
45° < t.c. < 87° = latititude diff. * tg t.c. * cosec t.c.
t.c. > 87° = longitude diff. * cos med.lat. * cosec t.c.
excel will use the best formula according to the value of the course (0°-90°)
calculation for orthodromic distance (gc great circle) formula : cos gc = (sine lat a * sine lat b) + (cos lat a * cos lat b * cos longitude diff.)
calculation for init. course (oc great circle) formula : ctg oc * sec lat.a = cosec long.diff. * tan lat.b - cot long.diff. * tan lat.a
calculation for vertex latitude formula : cos hl = cos lat a * sine oc

 

Guestbook : I'll be happy to receive suggestions or comments !


 

The author wishes to express his gratitude to Mr. Jelle Schaap for the realization of the file no.1 (authorization to freely distribute the file included )
 
 

© 2006-2014 nauticalalmanac