+ Reply to Thread
Results 1 to 3 of 3

CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

  1. #1
    Jon re Excel
    Guest

    CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

    is there a formula for this?

  2. #2
    Dave Peterson
    Guest

    Re: CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

    A visit to Chip Pearson's site is in order:
    http://www.cpearson.com/excel/latlong.htm



    Jon re Excel wrote:
    >
    > is there a formula for this?


    --

    Dave Peterson

  3. #3
    Ron Rosenfeld
    Guest

    Re: CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS

    On Tue, 8 Mar 2005 16:33:03 -0800, Jon re Excel <Jon re
    [email protected]> wrote:

    >is there a formula for this?



    =60*180/PI()*ACOS((SIN(RADIANS(Pos1 Lat)) * SIN(RADIANS(Pos2 Lat)))
    + (COS(RADIANS(Pos1 Lat)) * COS(RADIANS(Pos2 Lat)) *
    COS(RADIANS(Pos2 Long) - RADIANS(Pos1 Long))))

    Pos1 Lat is the Latitude, in decimal degrees of position 1
    and so forth.

    Positions in the N latitudes and W longitudes are entered as postive numbers.
    Positions in the S latitudes and E longitudes are entered as negative numbers.

    The result will be in nautical miles.




    --ron

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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