Anyone have a script or formula to do this easily? Thanks.
Convert WHAT (SPC/UTM/XYZ) to Lat/Lon ???
Loyal
Corpscon now has a routine to convert that works from inside excel.
http://www.agc.army.mil/corpscon/
:good: Robert Ellis, just use corpscon to convert a user-defined ascii file and bring that into Excel after the fact.
Or is there a particular reason why you want to do it in Excel?
I wanted to incorporate it into a form that we're already using.
> Or is there a particular reason why you want to do it in Excel?
I was only answering his question about excel and letting him know the spreadsheet was already written. The spreadsheet is clumsy in that the degrees minutes and seconds are in separate columns. I do like you say and just process batch files in Corpscon.
I'm not sure what you are converting, but you might find something of use here:
http://www.afsc.noaa.gov/nmml/software/excelgeo.php
Note that this webpage says it uses a spherical model, so it's only giving approximate results.
If you have an excel workbook in the form latitude, longitude, name,icon
You can convert to kml and load the points into Google Map and have a nice
location map with aerial background showing the points. The 'name' can be
the point description or your own point number.
Three cells to convert Lat/Long
One for the zone code and one each for north and east.
Easiest bugger ever.
Try this...
https://surveyorconnect.com/index.php?mode=thread&id=111848