MGRS Calculating Bearing and Distance over multiple map Sheet
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.
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
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.
Originally Posted by shg
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By sgtkling in forum Excel Formulas & Functions
Last Post: 04-19-2016, 06:50 PM
By funkmeister79 in forum Excel Formulas & Functions
Last Post: 03-03-2015, 01:06 PM
By jackalek in forum Excel Formulas & Functions
Last Post: 07-14-2014, 08:27 AM
By OmJose in forum Excel General
Last Post: 07-29-2013, 04:51 PM
By Ulrich in forum Excel Programming / VBA / Macros
Last Post: 09-06-2010, 10:55 AM
By noisewatter in forum Excel General
Last Post: 04-29-2009, 01:55 PM
By akolln in forum Excel Formulas & Functions
Last Post: 12-15-2007, 12:34 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1