+ Reply to Thread
Results 1 to 2 of 2

MGRS Calculating Bearing and Distance over multiple map Sheet

  1. #1
    Registered User
    Join Date
    12-14-2014
    Location
    Wainwright, AB
    MS-Off Ver
    Office 365, Office 2007, Office 2010
    Posts
    2

    MGRS Calculating Bearing and Distance over multiple map Sheet

    Good Day

    I am trying to figure our how to calculate distance and bearing between two distant sites. The grids I have are from two distant map sheets. I know there are websites but I would like to be able to build this into excel. For example Point 1 is 12U WD 08077 51991 and Point 2 is 12U VD 95713 47136. What is the distance and bearing between the two points.
    Thanks

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,622

    Re: MGRS Calculating Bearing and Distance over multiple map Sheet

    How much of this is an Excel question, and how much is a broader geometry/navigational question -- independent of programming language.

    Since I usually find that I need to understand the trig/geometry/math behind a problem, I put that question to a search engine, and found this page: http://www.movable-type.co.uk/scripts/latlong.html
    He describes the trig/geometry involved in the calculations, and includes Excel and Javascript formulas for the "law of cosines" (which he uses to get the "great circle" distance) and the "initial bearing". If you are interested, he also describes the much simple (but only truly applicable to short distances) "equirectangular" formulas that we all know and love from Euclidean "planar" trigonometry.

    Remember, whenever working with trig functions that angles must be expressed in radians and not degrees.

    Onedit: I noticed later that the link above includes an Excel spreadsheet near the bottom with his formulas implemented.
    Last edited by MrShorty; 04-20-2016 at 02:22 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MGRS Distance, Direction Calculation
    By sgtkling in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-19-2016, 06:50 PM
  2. Calculating distance between addresses
    By funkmeister79 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-03-2015, 01:06 PM
  3. [SOLVED] Calculating distance between many GPS points and sorting by distance
    By jackalek in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-14-2014, 08:27 AM
  4. Replies: 7
    Last Post: 07-29-2013, 04:51 PM
  5. Calculating constant bearing with ATAN2 function
    By Ulrich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2010, 10:55 AM
  6. Calculating MPH from distance and time.
    By noisewatter in forum Excel General
    Replies: 1
    Last Post: 04-29-2009, 01:55 PM
  7. calculating time to go a set distance
    By akolln in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-15-2007, 12:34 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1