Hi All,

Can anyone help me with to how to calculate the compass bearing between grid references on a map, or direct me where to look? I'm hoping to produce a table in Excel that shows the bearing from any one point to any other point when I have a few dozen grid references to choose from. I'm using MGRS and not Lat/Long, so I think its just plotting points on an X,Y axis and a bit of Sine/Cos/Tan. Max distance is about 4 miles and tolerance is the thickness of a pencil line (about 1 degree).

I don't remember trig from high school and my excel skills are very low compared to most people on this forum. So far all I've managed is to manually plot and measure the bearings, or input the data into my GPS (which is pretty tedious) and let it do the calculation. Thanks for any help you can provide. MICHAEL SMITH.

"Whaylonsmithers" wrote:
Can anyone help me with to how to calculate the
compass bearing between grid references on a map,
or direct me where to look?

Google "excel compass bearing", "excel compass heading" etc without quotes,
and evaluate the many hits that you find.

Chip Pearson has some useful info and formulas on this subject.

http://www.cpearson.com/excel/latlong.aspx


Gord

On Sun, 20 May 2012 01:31:22 +0000, Whaylonsmithers
wrote:


Hi All,

Can anyone help me with to how to calculate the compass bearing between
grid references on a map, or direct me where to look?

I don't remember trig from high school and my excel skills are very low
compared to most people on this forum. So far all I've managed is to
manually plot and measure the bearings, or input the data into my GPS
(which is pretty tedious) so it does the hard work.

Thanks for any help you can provide. MICHAEL SMITH.