The Hull Truth - Boating and Fishing Forum

The Hull Truth - Boating and Fishing Forum (https://www.thehulltruth.com/index.php)
-   Marine Electronics Forum (https://www.thehulltruth.com/marine-electronics-forum-19/)
-   -   Lat&Long in .xlsx information request (https://www.thehulltruth.com/marine-electronics-forum/1109962-lat-long-xlsx-information-request.html)

bellerive 08-22-2020 04:26 PM

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?

bellerive 08-22-2020 04:28 PM

I'm going to be entering in thousands of numbers so I want to be 100000% sure I am doing it right

SHAMROCK69 08-22-2020 04:32 PM

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

capt_matt 08-22-2020 05:04 PM

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.

Kerry 08-22-2020 05:17 PM

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?

jwelk 08-22-2020 06:22 PM

why do you need millimeter accuracy? I would venture 3 digits would be sufficient. (6 ft)

bellerive 08-24-2020 09:04 AM

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

bellerive 08-24-2020 09:10 AM


Originally Posted by SHAMROCK69 (Post 13978050)
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


bellerive 08-24-2020 05:13 PM


Originally Posted by jwelk (Post 13978312)
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?

bellerive 08-24-2020 05:23 PM


Originally Posted by jwelk (Post 13978312)
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?

Angler2500cc 08-24-2020 06:12 PM

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

vman24 08-24-2020 06:17 PM

interesting

Kerry 08-24-2020 07:41 PM


Originally Posted by bellerive (Post 13984036)
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?

bellerive 08-24-2020 09:55 PM


Originally Posted by Kerry (Post 13984513)

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:grin:


All times are GMT -7. The time now is 12:36 AM.

Powered by vBulletin® Version 3.9.3.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright © 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.