Main Area and Open Discussion > General Software Discussion
In search of ... a way (Excel macro?) to convert Lat-Long co-ordinates
barney:
BD (Baby Daughter) has been tasked with converting some Lat-Long deg-min-sec coordinates to decimal. There are a number of Web services to accomplish this, several with .gov TLDs, more with .EDU TLDs.
There are also several forae that discuss Excel macros to accomplish this end.
However, nothing I've found so far really fills the bill :(.
BD's requirements are to take a [significant] number of degrees-minutes-seconds values and convert them to a decimal equivalent. I'm thinkin' it would be nice to be able to reverse that process, as well.
It's been a decade since I did anything with Excel (Office 2000), so I'm more than a bit rusty :tellme:.
Checked DC - several discussions involved - but nothing I found seems to cover this.
Anyone have a pointer to such a bit of code? (I'd personally prefer an application for this, but considering the number of conversions to be made - and corporate paranoia - a spreadsheet solution would be better). (If it matters, they are using Office 2003, soon to upgrade to 2007: really progressive :P.)s
skwire:
Do you just have a simple list of coordinates that need converting?
barney:
Nope.
This is an ongoing thing, with new locations on a semi-regular basis. Might be one (1) a week, might be a hundred. That's why I'm looking at the spreadsheet resolution - if it's just one (1), http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html or http://www.directionsmag.com/site/latlong-converter would work just fine. However multiple tens of coordinates would be quite time-consuming.
Actually, I thought perhaps it could be done with AHK or AutoIt!, but corporate paranoia reigns supreme in this arena ... BD is not allowed any software on her laptop that was not installed by her IT group >:(. Otherwise, I have an old VB (5.0) - if I can find it :huh: - app that did exactly that (from my MCI days).
Renegade:
And...
http://support.microsoft.com/kb/213449
Tada~!
They've already got it done for you. :)
Or here if you like:
http://www.ozgrid.com/forum/showthread.php?t=25460&page=1
CWuestefeld:
The formula for this is pretty simple. If you have separate values for Deg, Min, and Sec, then the decimalized equivalent is
--- Code: Text ---Deg+(Min+Sec/60)/60
I've attached an example using Excel formulas.
If you've got to parse out the three values from a single string, that's where all the work is -- but I can't tell you exactly how to do that without seeing the input strings.
Navigation
[0] Message Index
[#] Next page
Go to full version