Notices
Marine Electronics Forum

Lat&Long in .xlsx information request

Old 08-22-2020, 04:26 PM
  #1  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default Lat&Long in .xlsx information request

Just making 100% sure

I just add in lat and long in a "blank work book" in excel an add a number to each column.

Format from the numbers I on paper that I have that are in "82.00.000 26.00.000 format"

To a "82.00000 2600000"


I am not adding any other degree marks, periods, or comas just the 7 digits for latitude and 7 digit longitude with a period seperating the first two numbers of each

Do you loose any accuracy if formated a certain way...as in the way I enter the data format with other information in Degrees and Decimal Minutes to a basic 00.00000 format

Is adding a 8th number to the numbers necessary like" 026.00000 082.00000

Are there any screen shots of this in action?
Old 08-22-2020, 04:28 PM
  #2  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

I'm going to be entering in thousands of numbers so I want to be 100000% sure I am doing it right
Old 08-22-2020, 04:32 PM
  #3  
Senior Member
 
Join Date: Oct 2002
Location: JAX FL
Posts: 2,138
Received 155 Likes on 75 Posts
Default

What format do u have them in? You can not have two decimals. It is either degrees which 26.000000 or degrees minutes which would be 26 00.00 or degrees minutes seconds which would be 26 00 00.00
Old 08-22-2020, 05:04 PM
  #4  
Senior MemberCaptains Club Member
 
Join Date: May 2006
Location: Maryland
Posts: 1,859
Received 184 Likes on 116 Posts
Default

What is your goal after the coordinates are entered in Excel? Are you going to upload the file to a chart plotter? Do some tests before entering in a lot of data to be sure your format will import successfully. You can also test with an export from a chart plotter and then open the coordinate file in Excel and examine the format.
Old 08-22-2020, 05:17 PM
  #5  
Senior Member
 
Join Date: Feb 2001
Location: Australia
Posts: 3,606
Received 84 Likes on 60 Posts
Default

You do need to clarify exactly what you have and what you want to do as your initial post is a little obscure?

Some general comments, adding zeros do nothing to any format be it dDD° MM.mmm' or dDD° MM' SS.sss" or dDD.ddddd° and by writing Lat/Long with some proper delineators then it does make a whole lot easier to understand.
"82.00.000 26.00.000 format" this doesn't mean a great lot and there can never be more than one(1) decimal point in any position format. One can sort of see what you are intending (I think) with the last 3 digits but it's this should not be a guessing game.

....Is adding a 8th number to the numbers necessary like" 026.00000 082.00000
No, not really but if the system wants/expects a zero then do it.

Regards loosing accuracy relative to data format, well No, but this is dependent on the decimal places beit Degrees & decimal degrees, Degrees Minutes and decimal minutes or Degrees Minutes Seconds and decimal seconds. For typical marine systems and relative to the accuracy capability of the Standard Position Service then there is not much point going beyond 5 or 6 decimals degrees, 3 decimal minutes or 1 or 2 decimal seconds and typically the decimal places will be controlled by the system?
Old 08-22-2020, 06:22 PM
  #6  
Senior Member
 
Join Date: Oct 2018
Location: Puerto Rico
Posts: 376
Received 52 Likes on 43 Posts
Default

why do you need millimeter accuracy? I would venture 3 digits would be sufficient. (6 ft)
Old 08-24-2020, 09:04 AM
  #7  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

They are in degrees and decimal minutes like a chart plotter would display. They are on paper and hand written.

I want to copy them over to a digital format and have a chart plotter read them from a sd card which is the middle of the road idea behind this.

Anyway I'll just play around with a .xlsx to .gpx converter an a memory card and put it in a furuno and garmin I have.

I just wanted a clear cut working format to type into excel for ddm 26 00 000 / 82 00 000 no information just numbers to populate marks onto a chartplotter
Old 08-24-2020, 09:10 AM
  #8  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

Originally Posted by SHAMROCK69 View Post
What format do u have them in? You can not have two decimals. It is either degrees which 26.000000 or degrees minutes which would be 26 00.00 or degrees minutes seconds which would be 26 00 00.00
I just put the period to separate them they do not have any characters on paper they are in ddm

Old 08-24-2020, 05:13 PM
  #9  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

Originally Posted by jwelk View Post
why do you need millimeter accuracy? I would venture 3 digits would be sufficient. (6 ft)
Well doesnt depend upon the gps antenna how close to the number I referenced....never mind....

Anyway the point is if I log a number down into excel it does not need any other characters in the numerical data entered then "26 00 000 82 00 000" and logging the late and longs in a different column.

What is a good converting program of .xlsx to .gpx?
Old 08-24-2020, 05:23 PM
  #10  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

Originally Posted by jwelk View Post
why do you need millimeter accuracy? I would venture 3 digits would be sufficient. (6 ft)
I need to log the data digitally. If the marine electronic company had configured a decent app that would allow for easy data entry I would use it but the one and done method is a waste of time

Anyway the point is if I log a number down into excel it does not need any other characters in the numerical data entered then "26 00 000. 82 00 000" and logging the lats and longs in separate columns. Or do I need to make a template with degree marks and decimal points and add the other happy horse shit

What is a good converting program of .xlsx to .gpx?
Old 08-24-2020, 06:12 PM
  #11  
Member
 
Join Date: Oct 2018
Location: Saint Petersburg, FL USA
Posts: 60
Received 10 Likes on 7 Posts
Default

I used this to convert my old numbers from an excel ss to gpx for my simrad. Not sure if this will help you.

jim

https://www.gpsvisualizer.com/convert_input
Old 08-24-2020, 06:17 PM
  #12  
Admirals Club Admiral's Club Member
 
Join Date: Oct 2010
Location: RI
Posts: 1,405
Received 71 Likes on 47 Posts
Default

interesting
Old 08-24-2020, 07:41 PM
  #13  
Senior Member
 
Join Date: Feb 2001
Location: Australia
Posts: 3,606
Received 84 Likes on 60 Posts
Default

Originally Posted by bellerive View Post
Well doesnt depend upon the gps antenna how close to the number I referenced....never mind....
No, the accuracy of the system has some limitations and going beyond 3 decimal minutes doesn't achieve any better accuracy, more decimals is relative to precision but not accuracy in the case of a single freq GPS unit (even with Glonass)

....Anyway the point is if I log a number down into excel it does not need any other characters in the numerical data entered then "26 00 000 82 00 000" and logging the late and longs in a different column.
If you are Degrees Minutes & Decimal minutes then nothing more than your example

...What is a good converting program of .xlsx to .gpx?
Is there such a thing? I would be exporting a sample .gpx file then try and duplicate that format in .xlsx (?) or a simple text editor and import it back?
Old 08-24-2020, 09:55 PM
  #14  
Member
Thread Starter
 
Join Date: Apr 2013
Location: Fort Myers, Florida
Posts: 51
Likes: 0
Received 2 Likes on 2 Posts
Default

Originally Posted by Kerry View Post

Is there such a thing? I would be exporting a sample .gpx file then try and duplicate that format in .xlsx (?) or a simple text editor and import it back?
Yeah I will try that. I was reading about howgow to just simply type the numbers out and then copy the saved file or text (copy and paste it) to a program to convert them to a .gpx.

I'll give it a whirl I just went and bought the memory card to test it out.

I didn't think about that I could open a waypoint in a text program but I guess you can?

Sounds like it will have a language written on to a memory card coming from the chartplotter that I can add and edit it to display all the waypoints I want to add to it and navigate around the mass produces whack software they provide for these expensive machines

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
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Thread Tools
Search this Thread

Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information -

Copyright © 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.