We help IT Professionals succeed at work.

Convert Excel Long/Lat coordinates to UTM's and Graph them

4,835 Views
Last Modified: 2012-05-11
Im looking to do this for this spreadsheet.

Thanks 2011a-gps-coordinates.xlsx 2011a-gps-coordinates.xlsx
Comment
Watch Question

Berkson WeinTech Freelancer
CERTIFIED EXPERT

Commented:
Can you explain a bit more what you're looking to accomplish?  What type of graph are you hoping for?  If it's just x,y why not use he lat/long coordinates directly.

Converting to UTM is complicated and not completely accurate from what I've been reading:
http://www.uwgb.edu/dutchs/UsefulData/UTMFormulas.htm

Here's a website that converts your decimal notation into UTM, giving a zone, Easting and Northing.  We could look at the javascript that calculates that and convert it into excel, but that's only worthwhile if this is the type of information that you're looking for in the graph.

Let us know?
I have the graphing part figued out per your advice - but it would be worth it  if you could convert the UTM script to excel - that is certainly what I need.
Berkson WeinTech Freelancer
CERTIFIED EXPERT

Commented:
So you're looking for 3 columns: easting, northing and zone?  
Are these always going to be northern hemisphere coordinates?

Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
Most GPSs have an option which lets you export the data in UTM coordinates. Have you considered this?
So you're looking for 3 columns: easting, northing and zone?  

yes


Are these always going to be northern hemisphere coordinates?

yes



Most GPSs have an option which lets you export the data in UTM coordinates. Have you considered this?   Yes - there is a reason why I cant do this with this  GPS unit setup.  I have to export LL
Tech Freelancer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.