Page 2 of 2
Re: Charter GPS points
Posted: Sat Aug 15, 2020 4:59 pm
by shnapper20
hi excuse my ignorance but how do I load these gps marks? which format are they in? eg "S3817503 E14438461 Kings slack water"
is this S 38deg 17.5min 3 sec or is it S 38deg 17min 50.3sec or is it S 38.17503 deg? every thing I place on my map looks wrong. much appreciated john
Re: Charter GPS points
Posted: Sat Aug 15, 2020 5:26 pm
by barra mick
It's very old.
I remember seeing the post a few years ago
Re: Charter GPS points
Posted: Sat Aug 15, 2020 6:14 pm
by 4liters
Format is as follows:
S38 17.503
E144 38.461
I put the list into an excel spreadsheet and then used a formula to put them into the correct format because I was transposing too many of them incorrectly trying to do it as I went.
=IF(LEFT(A1,1)="S",(LEFT(A1,3)&" "&(MID(A1,4,2))&"."&(RIGHT(A1,3))),(LEFT(A1,4)&" "&(MID(A1,5,2))&"."&(RIGHT(A1,3))))
A lot of them come from a book (
https://books.google.com.au/books/about ... TB2mZLyV4C ) so there's nothing too special about them, I think the ones in the Rip and offshore are his charter ones though.
Re: Charter GPS points
Posted: Sun Aug 16, 2020 9:46 am
by e.welch
Wow I wish my dad hadn’t sold the boat even more now lol all good info though