+ Reply to Thread
Results 1 to 5 of 5

Latitude/longitude computation?

  1. #1
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Latitude/longitude computation?

    Hi!

    I can find many formulae to compute the bearing and range between two sets of lat/long coordinates.

    However, I wish to find the lat/long of a second point given the coordinates of the first point, and the bearing and distance from the first point to the second point.

    Any help appreciated. Thank you!

    Edit: The distance between the points will be less than 20 nautical miles, so that should simplify the equation.
    Last edited by Hambone70; 04-27-2014 at 09:12 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Latitude/longitude computation?

    Maybe this will help

    http://geography.about.com/library/f...ancedegree.htm
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    01-16-2011
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2010
    Posts
    234

    Re: Latitude/longitude computation?

    Here is a formula that I found online. "Lat/Long given radial and distance" is what I'm trying to do. However, I'm having trouble converting it into useful Excel equations.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Latitude/longitude computation?

    Quote Originally Posted by Hambone70 View Post
    Hi!

    Edit: The distance between the points will be less than 20 nautical miles, so that should simplify the equation.
    ... and typically are the points used within say the same 1 degree of latitude, and what's the precision required?

    If they're all on the same latitude +/- 1 degree then the longitudinal distance in miles between two points can be fixed (subject to the precision required) and avoid more complicated formulae that would be needed to establish the mileage between two longitudes at any latitude between 0 & 90 degrees. In which case straightforward Euclidean geometry for a flat surface could be used.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Latitude/longitude computation?

    Hi,

    Does the attached help
    Attached Files Attached Files

+ 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. Distance between latitude and longitude
    By fazna ali in forum Excel General
    Replies: 2
    Last Post: 11-06-2012, 05:03 AM
  2. Latitude & Longitude processing help please
    By Pilot_Greg in forum Excel General
    Replies: 11
    Last Post: 12-14-2009, 03:31 PM
  3. MGRS to Longitude/Latitude
    By ajocius in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2009, 11:26 AM
  4. Latitude/Longitude Porblem
    By edwardtong694 in forum Excel General
    Replies: 3
    Last Post: 05-20-2009, 12:23 PM
  5. [SOLVED] Help with Latitude and Longitude.
    By LadiFireBug in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-22-2005, 05:09 AM

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