Home |
Search |
Today's Posts |
|
Metalworking (rec.crafts.metalworking) Discuss various aspects of working with metal, such as machining, welding, metal joining, screwing, casting, hardening/tempering, blacksmithing/forging, spinning and hammer work, sheet metal work. |
Reply |
|
LinkBack | Thread Tools | Display Modes |
|
#1
Posted to rec.crafts.metalworking
|
|||
|
|||
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 |
#2
Posted to rec.crafts.metalworking
|
|||
|
|||
OT distance calculator
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. |
#3
Posted to rec.crafts.metalworking
|
|||
|
|||
OT distance calculator
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. |
#4
Posted to rec.crafts.metalworking
|
|||
|
|||
OT distance calculator
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 |
#5
Posted to rec.crafts.metalworking
|
|||
|
|||
OT distance calculator
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BTU calculator | Metalworking | |||
RC beam calculator | Home Repair | |||
Pocket Calculator | Electronics Repair | |||
Irregular bolt circle calculator from simple distance measurements | Metalworking | |||
Calculator | Metalworking |