OnlineConversion Forums Welcome to OnlineConversion.com Forums

Go Back   OnlineConversion Forums > Main Forums > Resources

Resources You may post links to other conversion resources here. You may also review resources posted by others.

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2012, 04:00 AM
rlaughton rlaughton is offline
Junior Member
 
Join Date: Mar 2012
Location: Milton Ontario Canada
Posts: 1
Rep Power: 0
rlaughton is on a distinguished road
Default GPS Coordinate Conversions - EXCEL

I arrived here for the first time this morning to check on a conversion and found the confirmation I needed quite quickly. Interesting site, so I registered, as I may be able to assist on some other issues.

I do a lot of Military Research, primarily related to the Great War of 1914-1919 which involves a lot of map interpretation to locate grave sites and trenches from battles. A great deal of this I have put up on Google Earth in KMZ files (they are rebuilding those at present due to major changes at Google). I found myself often needing to convert GPS co-ordinates on-the-fly so I made a little Excel spreadsheet that I keep on my Smartphone. If I knew how to write an App I would do that but I don't.

Here is the simple spreadsheet you can download from my company web site:

http://censol.ca/uploads/Shared%20Pr...Conversion.xls

(OOPS! It won't let me add the link as I am a new user. ) There is no method to disable BB code on this forum so I altered the link so it is not active. You will have to add the http part back in at the beginning to make the link work.

If any of you are into TRENCH MAPS, visit that specific page on my CEFSG MATRIX Project here:

http://cefresearch.com/matrix/Utilities/Maps/trench.htm

You will have to change all the xxxx to read http.

[Mod Edit to http:] -JS

Last edited by JohnS; 03-03-2012 at 12:33 PM.
Reply With Quote
  #2  
Old 03-03-2012, 12:36 PM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,549
Rep Power: 19
JohnS will become famous soon enough
Default Re: GPS Coordinate Conversions - EXCEL

I've editted the links to "http:" so they are active.

The Excel program converts longitude/latitude formats among:
Decimal Degrees
Degrees-decimal minutes
Degrees-minutes-decimal seconds.
Reply With Quote
  #3  
Old 02-14-2014, 10:20 AM
jmould jmould is offline
Junior Member
 
Join Date: Feb 2014
Posts: 1
Rep Power: 0
jmould is on a distinguished road
Default Re: GPS Coordinate Conversions - EXCEL

I cant download the excel program can you assist. I get a 404 error
Reply With Quote
  #4  
Old 02-16-2014, 03:33 AM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,549
Rep Power: 19
JohnS will become famous soon enough
Default Re: GPS Coordinate Conversions - EXCEL

Quote:
Originally Posted by jmould View Post
I cant download the excel program can you assist. I get a 404 error
Sorry, the file is not on this site. The original poster placed it on his company site, and it is now taken down. It only changes between three degree formats, which is relatively trivial. I get the same error as you.

What exactly do you need to convert (from and to)? We may have a converter or be able to refer you to one.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 05:35 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1997-2005, 2007, OnlineConversion.com