Notices
Marine Electronics Forum

Garmin Homeport help needed

Old 07-17-2013, 01:59 PM
  #1  
Senior MemberCaptains Club Member
Thread Starter
 
Join Date: Oct 2005
Location: Key West
Posts: 13,245
Received 3,453 Likes on 1,557 Posts
Default Garmin Homeport help needed

Hey all, so here's what I'm trying to do... I'm working from a Mac computer and I'm trying to take a list of Waypoints and get them into a list form so that they can be printed out on paper. The obvious method to me would be to put them into an Excel spreadsheet.

When I go to export the list, I chose to save it as a .CSV file based on what I had read after a google search. That CSV file actually opens perfectly fine in Excel.

The problem I'm having though is that the actual data is not correct after the export.
The lat/lon is normal in Homeport meaning that it looks like N24 43.574 or whatever the number might be.
But when I export it as the CSV file it comes out looking like this
24.72623297944665

So even when I put it into the excel sheet, the data is wrong right off the bat. Why won't it export normally?

Or, how do I get a list generated that I can somehow print?
Old 07-17-2013, 02:20 PM
  #2  
Senior MemberCaptains Club Member
 
Join Date: Feb 2005
Location: Falmouth, MA
Posts: 6,196
Received 696 Likes on 431 Posts
Default

24 43.574 is ° mm.mmm

24.72..... is just degrees

in other words, it is correct just in a different format. to convert mm.mmm to °, divide by 60. for instance, 45 minutes = 0.75°
Old 07-17-2013, 02:22 PM
  #3  
Senior MemberCaptains Club Member
Thread Starter
 
Join Date: Oct 2005
Location: Key West
Posts: 13,245
Received 3,453 Likes on 1,557 Posts
Default

Originally Posted by chainsaw42 View Post
24 43.574 is ° mm.mmm

24.72..... is just degrees

in other words, it is correct just in a different format. to convert mm.mmm to °, divide by 60. for instance, 45 minutes = 0.75°

makes sense, but is there a way to have Homeport do this before the export? I would rather not have to thru 1,294 waypoints one by one.
Old 07-17-2013, 02:22 PM
  #4  
Senior Member
 
Join Date: Apr 2012
Location: Coastal BC
Posts: 1,668
Likes: 0
Received 7 Likes on 7 Posts
Default

The CSV data is not wrong. The coordinates are expressed as decimal degrees instead of degrees and decimal minutes. In your example, 43.574 minutes is about 0.72623 degrees, so you're seeing two representations of the same coordinates.

If you really want to display degrees and decimal minutes in Excel, apply a text formula to the imported cells. For example, if the first imported latitude is in cell A1, then use the following formula:
="N"&TEXT(INT(A1),"0")&" "&TEXT(MOD(A1,1)*60,"0.000")
to display the coordinates in degrees and decimal minutes. Copy that formula for all the other latitudes.

Similarly, the formula:
="W"&TEXT(INT(A1),"0")&" "&TEXT(MOD(A1,1)*60,"0.000")
should display the longitudes in degrees and decimal minutes.
Old 07-17-2013, 02:22 PM
  #5  
Senior MemberCaptains Club Member
 
Join Date: Feb 2005
Location: Falmouth, MA
Posts: 6,196
Received 696 Likes on 431 Posts
Default

I guess I can add to that too...i'm not sure if the homeport software can export to a different format...but you can convert the degrees with decimals to another format if necessary in excel.
Old 07-17-2013, 02:41 PM
  #6  
Senior Member
 
Join Date: Apr 2012
Location: Coastal BC
Posts: 1,668
Likes: 0
Received 7 Likes on 7 Posts
Default

Originally Posted by coores14 View Post
makes sense, but is there a way to have Homeport do this before the export? I would rather not have to thru 1,294 waypoints one by one.
I don't know of a way to get Homeport to export CSV files with coordinates formatted as you want them, but you will only need to enter 2 variations of a formula in a couple of new columns (one for lat, one for long) and copy/paste that formula for all your waypoints. There's no need to type the same thing 1,294 times...

Edit: By the way, I'm curious why you'd want a hard copy of 1,300 waypoints. Machines will handle the decimal degree format easily, and people could easily be overwhelmed with processing a list with, what 15,000 digits. Just curious. If it's a secret, I'm cool with that

Last edited by yabbut; 07-17-2013 at 02:47 PM. Reason: Curious...
Old 07-17-2013, 03:04 PM
  #7  
Senior MemberCaptains Club Member
Thread Starter
 
Join Date: Oct 2005
Location: Key West
Posts: 13,245
Received 3,453 Likes on 1,557 Posts
Default

Originally Posted by yabbut View Post
I don't know of a way to get Homeport to export CSV files with coordinates formatted as you want them, but you will only need to enter 2 variations of a formula in a couple of new columns (one for lat, one for long) and copy/paste that formula for all your waypoints. There's no need to type the same thing 1,294 times...

Edit: By the way, I'm curious why you'd want a hard copy of 1,300 waypoints. Machines will handle the decimal degree format easily, and people could easily be overwhelmed with processing a list with, what 15,000 digits. Just curious. If it's a secret, I'm cool with that

I'm admittedly an Excel moron. I remembered enough during college to pass the classes. I've tried the formulas and I keep getting errors. Wanna do it for me?

And yeah, the hard copy might not make much sense to most people, but I have my reasons. Also, I edited it down to under 1,000 now
Old 07-17-2013, 03:18 PM
  #8  
Senior Member
 
Join Date: Apr 2012
Location: Coastal BC
Posts: 1,668
Likes: 0
Received 7 Likes on 7 Posts
Default

Originally Posted by coores14 View Post
I'm admittedly an Excel moron. I remembered enough during college to pass the classes. I've tried the formulas and I keep getting errors. Wanna do it for me?
The formulas required to do what you need are easy for anyone with moderate or greater Excel skills. Your best bet is to find someone like that, and they can generate your formatted list from the CSV file within minutes. Good luck.

Last edited by yabbut; 07-18-2013 at 12:58 PM. Reason: Revised response

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 © 2021 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.