LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Calculating compass bearing or angles

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.

Last edited by Whaylonsmithers : May 20th 12 at 03:00 AM Reason: Clarification
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bearing calculation fenny Excel Discussion (Misc queries) 0 February 8th 11 07:51 AM
charting bearing and distance MJB Excel Discussion (Misc queries) 1 June 19th 09 09:07 AM
how to convert number to bearing .exp. 40.4040 to 40d 40' 40" melz Excel Worksheet Functions 2 November 22nd 08 11:40 AM
Compass degrees formatting Stephen Excel Discussion (Misc queries) 1 September 23rd 07 05:50 PM
Compass Heading drawing from an angles list Mahieux Excel Programming 4 June 24th 07 07:23 PM


All times are GMT +1. The time now is 03:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"