OT distance calculator

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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 18:43:52 -0500, the renowned Karl Townsend

Google "Haversine formula" to get the great circle distance between two points.
http://bluemm.blogspot.ca/2007/01/excel-formula-to-calculate-distance.html
That assumes the earth is a perfect sphere rather than the more accurate model of an oblate spheroid. If you need more accuracy than that, there are more complex formulas.
Best regards, Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
snipped-for-privacy@interlog.com Info for manufacturers: http://www.trexon.com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 12/17/2012 6:04 PM, Spehro Pefhany wrote:

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)
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 20:04:25 -0600, the renowned Richard

http://en.wikipedia.org/wiki/World_Geodetic_System
WGS84 is used by GPS, GLONASS,
http://koti.mbnet.fi/jukaukor/greatcircle_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/264803/8/Massive-military-plane-lands-at-wrong-airport-in-Tampa
Best regards, Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
snipped-for-privacy@interlog.com Info for manufacturers: http://www.trexon.com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany wrote:

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.
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 22:19:35 -0600, the renowned Tim Wescott

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"
snipped-for-privacy@interlog.com Info for manufacturers: http://www.trexon.com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 21:37:34 -0500, Spehro Pefhany

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

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 23:58:39 -0500, the renowned snipped-for-privacy@snyder.on.ca wrote:

A VERY small difference in Florida.
Best regards, Spehro Pefhany
--
"it's the network..." "The Journey is the reward"
snipped-for-privacy@interlog.com Info for manufacturers: http://www.trexon.com
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Spehro Pefhany wrote:

Not if you're flying over 'Sugarloaf Mountain'. ;-)
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 18:43:52 -0500, Karl Townsend

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.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On Mon, 17 Dec 2012 18:43:52 -0500, Karl Townsend

Try http://www.movable-type.co.uk/scripts/latlong.html
--
Cheers,
John B.
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 12/17/2012 6:43 PM, Karl Townsend wrote:

http://www.daftlogic.com/projects-google-maps-distance-calculator.htm
--
http://tinyurl.com/My-Official-Response

Regards,
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
wrote:

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
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Polytechforum.com is a website by engineers for engineers. It is not affiliated with any of manufacturers or vendors discussed here. All logos and trade names are the property of their respective owners.