great circle sailing - nautical calculator of routes and distances
great circle navigation and rhumb line - how to calculate distance and course (bearing) between two points - marine great circle formulas - 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) ?
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.
The sheet "Chart1" shows a diagram with the location of some parameters: great circle navigation, rhumb lines, courses, waypoints:
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) :
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.
|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 !
© 2006-2015 nauticalalmanac