Converting DMS to D.d
Mon, 09/01/2008 - 5:03pm
 15 years
|
Looking for an excel spreadsheet or any other method to convert a file with ° ' " (in one column) to decimals, the file I have has over 12000 lats and longs. Each lat and long is in a separate column.
Formula
While I don't have what you are requesting, degrees are made up of 60 minutes of arc (') and each minute, 60 seconds of arc ("). The means 1 arcminute = 0.016666 degrees and 1 arcsecond = 0.000277 degrees.
In Excel you could open your file and define each field degrees/arcminutes/arcseconds as a separate column, then write a formula that applies the appropriate multiplier for those two fields and then adds them together, outputting the D.d.
That should get you where you need to go if no one has a template already made.
Drivesmart 66, Nuvi 2595LMT (Died), Nuvi 1490T (Died), Nuvi 260 (Died), GPSMAP 195
.
See http://www.cpearson.com/excel/latlong.htm
Nuvi 660 -- and not upgrading it or maps until Garmin fixes long-standing bugs/problems, and get maps to where they are much more current, AND corrected on a more timely basis when advised of mistakes.
GPS Conversion
This site will do that...
http://www.gpsvisualizer.com/calculators
COWBOY CREED -- If it ain't right, don't do it....If it ain't true, don't say it....If it ain't yours, don't take it.
If you want to ...
Looking for an excel spreadsheet or any other method to convert a file with ° ' " (in one column) to decimals, the file I have has over 12000 lats and longs. Each lat and long is in a separate column.
If you want to send over the file (or a part of it), and you're not in too big of a hurry, I'll write a macro or a program to get the job done. Just send me an email via my 'contact' line and I'll send you an email address that accepts attachments.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."
?
This site will do that...
http://www.gpsvisualizer.com/calculators
Do you have to do each coordinate individually? All 12,000?
Nuvi 660 -- and not upgrading it or maps until Garmin fixes long-standing bugs/problems, and get maps to where they are much more current, AND corrected on a more timely basis when advised of mistakes.
"Got er done"
Looking for an excel spreadsheet or any other method to convert a file with ° ' " (in one column) to decimals, the file I have has over 12000 lats and longs. Each lat and long is in a separate column.
I sent you the converted file.
RT
Update: This option has been programmed into 'POI Verifier II'. It will now convert a file of degree coordinates to decimal coordinates.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."