I have several lat/long readings from a GPS device in excel.

I need to calculate the distance between points. How?

For Latitude, I'm thinking
Pi*7900/360*(lat1-lat2)

Longitude must need some sort of correction for latitude, not sure
how.

Once i get lat distance and long distance
sqrt(lat**2 +long**2)

I need to write this all into excel.

Extra credit question.
Is there some way to make this into a excel function so you just give
it the the two pairs of readings?

Karl

On Mon, 17 Dec 2012 18:43:52 -0500, Karl Townsend
wrote:

I have several lat/long readings from a GPS device in excel.

I need to calculate the distance between points. How?

For Latitude, I'm thinking
Pi*7900/360*(lat1-lat2)

Longitude must need some sort of correction for latitude, not sure
how.

Once i get lat distance and long distance
sqrt(lat**2 +long**2)

I need to write this all into excel.

Extra credit question.
Is there some way to make this into a excel function so you just give
it the the two pairs of readings?

Karl

I cheat by using the line drawing tool in Google Earth. Can also be
used to illustrate LOS between two points. (change line altitude
parameters) Very cool.

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard
wrote:

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

http://en.wikipedia.org/wiki/World_Geodetic_System

WGS84 is used by GPS, GLONASS,

http://koti.mbnet.fi/jukaukor/greatc...ellipsoid.html

This will get you down to the millimeter level, not micrometer. ;-)

For example, from Toronto to Chicago is 702.9810543723332 km elliptic,
but the spherical solution gives only 700.9181433797103 km. That's an
error of more than 2,000 meters.. that could put you on the wrong
runway or something.

http://www.wtsp.com/news/article/264...rport-in-Tampa




Best regards,
Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
Info for manufacturers: http://www.trexon.com
Embedded software/hardware/analog Info for designers: http://www.speff.com

On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany wrote:

On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard
wrote:

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

http://en.wikipedia.org/wiki/World_Geodetic_System

WGS84 is used by GPS, GLONASS,

http://koti.mbnet.fi/jukaukor/greatc...ellipsoid.html

This will get you down to the millimeter level, not micrometer. ;-)

For example, from Toronto to Chicago is 702.9810543723332 km elliptic,
but the spherical solution gives only 700.9181433797103 km. That's an
error of more than 2,000 meters.. that could put you on the wrong runway
or something.

http://www.wtsp.com/news/article/264...y-plane-lands-
at-wrong-airport-in-Tampa


Does GLONASS use WGS84 now? I thought they used some commie system.

--
My liberal friends think I'm a conservative kook.
My conservative friends think I'm a liberal kook.
Why am I not happy that they have found common ground?

Tim Wescott, Communications, Control, Circuits & Software
http://www.wescottdesign.com

On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany
wrote:

On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard
wrote:

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

http://en.wikipedia.org/wiki/World_Geodetic_System

WGS84 is used by GPS, GLONASS,

http://koti.mbnet.fi/jukaukor/greatc...ellipsoid.html

This will get you down to the millimeter level, not micrometer. ;-)

For example, from Toronto to Chicago is 702.9810543723332 km elliptic,
but the spherical solution gives only 700.9181433797103 km. That's an
error of more than 2,000 meters.. that could put you on the wrong
runway or something.

http://www.wtsp.com/news/article/264...rport-in-Tampa



What altitude are you flying at??? Makes a SMALL difference too.


Best regards,
Spehro Pefhany

On Mon, 17 Dec 2012 23:58:39 -0500, the renowned
wrote:

On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany
wrote:

On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard
wrote:

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

http://en.wikipedia.org/wiki/World_Geodetic_System

WGS84 is used by GPS, GLONASS,

http://koti.mbnet.fi/jukaukor/greatc...ellipsoid.html

This will get you down to the millimeter level, not micrometer. ;-)

For example, from Toronto to Chicago is 702.9810543723332 km elliptic,
but the spherical solution gives only 700.9181433797103 km. That's an
error of more than 2,000 meters.. that could put you on the wrong
runway or something.

http://www.wtsp.com/news/article/264...rport-in-Tampa



What altitude are you flying at??? Makes a SMALL difference too.

A VERY small difference in Florida.


Best regards,
Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
Info for manufacturers: http://www.trexon.com
Embedded software/hardware/analog Info for designers: http://www.speff.com

On Mon, 17 Dec 2012 18:43:52 -0500, Karl Townsend
wrote:

I have several lat/long readings from a GPS device in excel.

I need to calculate the distance between points. How?

For Latitude, I'm thinking
Pi*7900/360*(lat1-lat2)

Longitude must need some sort of correction for latitude, not sure
how.

Once i get lat distance and long distance
sqrt(lat**2 +long**2)

I need to write this all into excel.

Extra credit question.
Is there some way to make this into a excel function so you just give
it the the two pairs of readings?

Karl

Try http://www.movable-type.co.uk/scripts/latlong.html

--
Cheers,
John B.

On 12/17/2012 6:43 PM, Karl Townsend wrote:
I have several lat/long readings from a GPS device in excel.

I need to calculate the distance between points. How?

For Latitude, I'm thinking
Pi*7900/360*(lat1-lat2)

Longitude must need some sort of correction for latitude, not sure
how.

Once i get lat distance and long distance
sqrt(lat**2 +long**2)

I need to write this all into excel.

Extra credit question.
Is there some way to make this into a excel function so you just give
it the the two pairs of readings?

Karl


http://www.daftlogic.com/projects-go...calculator.htm

--
http://tinyurl.com/My-Official-Response

Regards,
Joe Agro, Jr.
(800) 871-5022 x113
01.908.542.0244
Flagship Site: http://www.Drill-HQ.com
Automatic / Pneumatic Drills: http://www.AutoDrill.com
Multiple Spindle Drills: http://www.Multi-Drill.com
Production Tapping: http://www.Drill-HQ.com/?page_id=226
VIDEOS: http://www.youtube.com/user/AutoDrill
FACEBOOK: http://www.facebook.com/AutoDrill
TWITTER: http://twitter.com/AutoDrill

V8013-R

Spehro Pefhany wrote:

wrote:

What altitude are you flying at??? Makes a SMALL difference too.

A VERY small difference in Florida.


Not if you're flying over 'Sugarloaf Mountain'. ;-)

On Dec 17, 4:43*pm, Karl Townsend
wrote:
I have several lat/long readings from a GPS device in excel.

I need to calculate the distance between points. How?

For Latitude, I'm thinking
Pi*7900/360*(lat1-lat2)

Longitude must need some sort of correction for latitude, not sure
how.

Once i get lat distance and long distance
sqrt(lat**2 +long**2)

I need to write this all into excel.

Extra credit question.
Is there some way to make this into a excel function so you just give
it the the two pairs of readings?

Karl

I've programmed this for checking distances between zip codes using a
converison table, there are three formulas depending on what you need
for accuracy. Acroos town, the difference between the formulas is
like less than a tenth of a mile, it's more significant at longer
distances.

El cheapo formula:
miles1 = Sqr((69.1 * (lat2 - lat1)) ^ 2 + (53# * (long2 - long1)) ^ 2)

Second best:
miles2 = Sqr((69.1 * (lat2 - lat1)) ^ 2 + (69.1 * (long2 - long1) *
Cos(lat1 / 57.3)) ^ 2)

What I use:
If lat1 lat2 And long1 long2 Then
X = (Sin(lat1 / 57.2958) * Sin(lat2 / 57.2958)) + (Cos(lat1 /
57.2958) * Cos(lat2 / 57.2958) * Cos(long2 / 57.2958 - long1 /
57.2958))
Y = Sqr(1 - X ^ 2)
miles3 = 3963# * Atn(Y / X)
Else
miles3 = 0
End If
Sensitive to where Lattitude and longitude are equal(same zip codes),
hence the check. Also runs a lot longer if you've got thousands of
entries to check.

From a tutorial out on the web from about 10 years back. HTH

Stan

On Mon, 17 Dec 2012 22:19:35 -0600, the renowned Tim Wescott
wrote:

On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany wrote:

On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard
wrote:

On 12/17/2012 6:04 PM, Spehro Pefhany wrote:
oblate spheroid

You are kidding, right?

Mean radius 6,371.0 km[6]

Equatorial radius 6,378.1 km[7][8]
Polar radius 6,356.8 km[9]

I'm seeing that as 22 km of "oblative flattening".

You'd have to mike it to tell the difference.

(BIG micrometer)

http://en.wikipedia.org/wiki/World_Geodetic_System

WGS84 is used by GPS, GLONASS,

http://koti.mbnet.fi/jukaukor/greatc...ellipsoid.html

This will get you down to the millimeter level, not micrometer. ;-)

For example, from Toronto to Chicago is 702.9810543723332 km elliptic,
but the spherical solution gives only 700.9181433797103 km. That's an
error of more than 2,000 meters.. that could put you on the wrong runway
or something.

http://www.wtsp.com/news/article/264...y-plane-lands-
at-wrong-airport-in-Tampa


Does GLONASS use WGS84 now? I thought they used some commie system.

I think you're right- it's apparently actually PZ-90. I might have
seen a reciever that does the transformation.


Best regards,
Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
Info for manufacturers: http://www.trexon.com
Embedded software/hardware/analog Info for designers: http://www.speff.com