Distance between GPS points (Decimal degrees)

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Feb 1, 2005.

  1. Guest

    Guest Guest

    Does anyone have a function created in Excel to calculate the distance
    between two GPS points which are in decimal degrees?
     
    Guest, Feb 1, 2005
    #1
    1. Advertisements

  2. Guest

    Myrna Larson Guest

    I vaguely remember that Chip Pearson has some formulas for this sort of thing.
    Try searching as www.cpearson.com

    On Tue, 1 Feb 2005 09:05:03 -0800, "David Reavill" <David
    > wrote:

    >Does anyone have a function created in Excel to calculate the distance
    >between two GPS points which are in decimal degrees?
     
    Myrna Larson, Feb 2, 2005
    #2
    1. Advertisements

  3. Guest

    Chip Pearson Guest

    The formula is at www.cpearson.com/excel/latlong.htm


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Myrna Larson" <> wrote in
    message news:...
    >I vaguely remember that Chip Pearson has some formulas for this
    >sort of thing.
    > Try searching as www.cpearson.com
    >
    > On Tue, 1 Feb 2005 09:05:03 -0800, "David Reavill" <David
    > > wrote:
    >
    >>Does anyone have a function created in Excel to calculate the
    >>distance
    >>between two GPS points which are in decimal degrees?

    >
     
    Chip Pearson, Feb 2, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    How do I convert from decimal degrees to degrees, minutes and sec.

    Guest, Sep 16, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    230
    JE McGimpsey
    Sep 16, 2004
  2. Guest

    How can I convert degrees minutes seconds to decimal degrees

    Guest, Sep 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    470
    ~Jeff~
    Sep 23, 2004
  3. Guest

    Distance between two GPS points (Decimal degrees)

    Guest, Feb 1, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    344
    Guest
    Feb 1, 2005
  4. Guest

    how can I add degrees? ie 300degrees + 100 degrees = 40 degrees

    Guest, Jul 18, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    269
    Guest
    Jul 18, 2007
  5. Al

    Degrees Minutes Decimal Minutes to Decimal Degrees.

    Al, Mar 18, 2010, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    234
    Ron Rosenfeld
    Mar 18, 2010
Loading...

Share This Page