Cruisers Forum
 


Join CruisersForum Today

Reply
 
Thread Tools Rate Thread Display Modes
Old 16-12-2014, 20:44   #31
Senior Cruiser
 
skipmac's Avatar

Cruisers Forum Supporter

Join Date: Oct 2007
Location: 29 49.16 N 82 25.82 W
Boat: Pearson 422
Posts: 12,374
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by sailorchic34 View Post
Well really, feet, fathoms and D,M,S work just as well, and have been used for a really long time. Its a US standard. .
I can deal with feet and fathoms or metric. What is annoying is when I'm using software or online chart viewers and can't tell if the data is in ft or fathoms since I can't just look up at the corner of the chart for the reference. And it can change depending on the zoom level if the viewer switches charts.

Quote:
Originally Posted by sailorchic34 View Post
Much like the British still use the pound and not the euro. Not to mention that we're a pig headed lot.
At least they gave up shillings and pence crowns and farthings and guineas. I can deal with decimal pounds but all that other stuff would give me a headache.
__________________

__________________
The water is always bluer on the other side of the ocean.
skipmac is online now   Reply With Quote
Old 17-12-2014, 00:19   #32
Registered User
 
Tx J's Avatar

Join Date: Jan 2013
Location: South Texas
Boat: Newport 28 & Robalo 20
Posts: 363
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by F51 View Post
Thanks, TX J. Whew! It is going to take a while to digest that Martindale stuff. I found online calculations that do almost exactly what I need. Now if I can get something I can download to use when I am out of range of the internet it will be great!
Yeah, Martindale can get deep and muddy real quick, but has lots of useful stuff.
A Bing search turns up lots of L/L conversions:
convert latitude and longitude - Bing

This one in particular does all three common L/L conversions that you're looking for:
GPS Latitude and Longitude Converter

If you scroll down, past the converter and map, that page has some useful Nav and GPS type information.

Hint:
If you save that webpage to a folder (like your "Nav" folder or whatever) as a "web archive" (in IE- Menu- File_Save As- choose Type_web archive single file ), you will have saved an almost fully functional L/L converter webpage to use offline as you would a standalone app (the elements that go to other (ad/active) links won't present).

When you aren't online you can simply find the .mht file you saved (titled in this case: GPS Latitude and Longitude Converter ), doubleclick on it ('open it'), and it will open in a browser window at anytime, without needing to be connected/online.
Each browser, if you're using something other than Internet Explorer, will handle this "Save webpage as archive" process slightly differently, but still work.

Plug in your L/L and convert it, while you're offline.


The saved webpage (archive) has fully self-contained JavaScript code that does all the L/L calculations right there within the browser renderer/interpreter (offline, and safer too). If you're familiar with HTML, just examine the page source to verify.
JavaScript - Wikipedia, the free encyclopedia

A handy trick that can be used with many webpages, for using them offline.
Create a shortcut on your Desktop and/or Programs List and have the new 'App' ready to use anytime.
__________________

__________________
Tx J is offline   Reply With Quote
Old 28-12-2014, 07:43   #33
Registered User
 
vtlli's Avatar

Join Date: Nov 2012
Location: Dublin, Ireland
Boat: Wylo 35,
Posts: 26
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by F51 View Post
I am constantly having to convert lats & longs from degrees, minutes, seconds to degrees, minutes & decimal minutes or just decimal degrees. I am looking for an excel spreadsheet that will handle these conversions both ways. Any ideas? Thanks.
Few year ago I bought over Amazon cheap engineering calculator (casio fx- Gt plus). It can do this conversation. Also it can do simple arithmetic with dd:mm:ss. Lets say: 530612 - 521856 = 04716 or sqrt if you need
__________________
vtlli is offline   Reply With Quote
Old 28-12-2014, 16:12   #34
cruiser

Join Date: Dec 2012
Location: Seattle
Posts: 1,130
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by sailorchic34 View Post
Cough, Those pesky USA folks keep using charts in feet and fathoms and yes the edge marking are in DD,MM,SS (Just checked the latest NOAA charts).
Actually, it's a test to keep our navigators awake and to let skippers in the know catch inexperienced navigators.

Not all the edge markings on NOAA charts are DD-MM-SS. Some are DD-MM.MMM, and some DD-MM.MMM charts have one tenth divided in six. (Which is both.)

I find the "both" option the most annoying to use.
__________________
Jammer Six is offline   Reply With Quote
Old 05-01-2015, 17:01   #35
Registered User

Join Date: Dec 2014
Boat: Wauquiez Pretorien 35
Posts: 5
Re: Degrees, Minutes & Seconds Conversion

Excel is great if you have a lot of numbers to work with.
However, Excel only calculates angles in radians.
You do the conversion you want if you enter Deg:Min:Sec as a time value, which is also base 60, then display it in a different cell as decimal hours.
check this page for some good ideas:
Latitude And Longitude

I love my mechanical pencil.
__________________
PauHana is offline   Reply With Quote
Old 07-01-2015, 18:54   #36
Registered User
 
FamilyVan's Avatar

Join Date: Nov 2014
Posts: 1,779
Re: Degrees, Minutes & Seconds Conversion

First of all. If you want to Navigate, forget about base 100. I am Canadian, so I was brought up with metric/base 100 system. However, I am also a Navigator and recognise that base 60 and 360 are just inherently better than base 100.
For example: 60 is equally divisible by 1,2,3,4,5,6,10,12,15,20,30 and 60. Whereas 100 is equally divisible by 1,2,4,5,10,20,25 and 50 and 100. Meaning 60 is divisible by 12 whole numbers where 100 is only divisible by 9.
IMHO 60 is a better number than 100.
__________________
FamilyVan is offline   Reply With Quote
Old 07-01-2015, 21:05   #37
Senior Cruiser
 
jackdale's Avatar

Cruisers Forum Supporter

Join Date: Mar 2008
Location: Calgary, AB, Canada
Posts: 5,040
Images: 1
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by Time2Go View Post
What type of pencils are best used on Charts?
Thin? Thick? Hard? Soft?
I use a .9 mm mechanical pencil with soft lead.

BTW - use a white eraser, the pink ones really destroy a chart.
__________________
ISPA Yachtmaster Ocean Instructor Evaluator
Sail Canada Advanced Cruising Instructor
IYT Yachtmaster Coastal Instructor
ASA 201, 203,204, 205, 206, 214
As I sail, I praise God, and care not. (Luke Foxe)
jackdale is offline   Reply With Quote
Old 07-01-2015, 21:17   #38
Senior Cruiser
 
jackdale's Avatar

Cruisers Forum Supporter

Join Date: Mar 2008
Location: Calgary, AB, Canada
Posts: 5,040
Images: 1
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by JohnT View Post
Why on earth have "those pesky USA folks" not converted like the rest of the world?
Then there is chart datum. American and Canadian chart datum is different. It gets exciting when you use a chart that crosses the border and chart datum changes as well. The difference can be as much as 1.8 meters.

Getting folks to change can be tough. While the vast majority of Canadian charts have metric depths the tables to make corrections between reference and secondary ports for tides are in feet only. When the hydrographic service tried to change to metric conversions there was a huge uproar.
__________________
ISPA Yachtmaster Ocean Instructor Evaluator
Sail Canada Advanced Cruising Instructor
IYT Yachtmaster Coastal Instructor
ASA 201, 203,204, 205, 206, 214
As I sail, I praise God, and care not. (Luke Foxe)
jackdale is offline   Reply With Quote
Old 07-01-2015, 21:37   #39
cruiser

Join Date: Dec 2012
Location: Seattle
Posts: 1,130
Re: Degrees, Minutes & Seconds Conversion

.05 mechanical pencils, 2B lead.

I would use .03 lead, but they break too often.

Learn the ruler trick. That will be the end of conversions, although dividers and one line to the nearest grid are still what I use when accuracy counts.
__________________
Jammer Six is offline   Reply With Quote
Old 08-01-2015, 06:28   #40
Registered User
 
FamilyVan's Avatar

Join Date: Nov 2014
Posts: 1,779
Re: Degrees, Minutes & Seconds Conversion

As stated above 2B. The reason being anything hb or harder requires too much pressure to make a mark and will leave indents all over your chart. And it's harder to erase.

Sent from my SGH-I547C using Cruisers Sailing Forum mobile app
__________________
FamilyVan is offline   Reply With Quote
Old 08-01-2015, 09:50   #41
Registered User

Join Date: Apr 2013
Posts: 4,876
Re: Degrees, Minutes & Seconds Conversion

It's really not that hard to set up a simple spreadsheet:

degree/min/sec to decimal degree:

Set up 3 cells:
- Degree
- Min
- Sec

Then write a formula in another cells that adds up: degrees + min/60 + sec/60/60.
The result will be decimal degrees.

The other way is slightly more complicated but not too difficult.

Set up a cell with the decimal degree (X in the formulas below). then put formulas in 3 cells
- Degrees: @rounddown(X, 0)
- Min: @rounddown((X-Degrees)*60,0)
- Sec: (X-degrees-min/60)*60*60

Once set up, you can enterr either one and it will spit out the answer.

I've run across this before and can't believe excel doesn't have a function to do this directly, though you could set up a special function but I've never bothered.
__________________
valhalla360 is online now   Reply With Quote
Old 23-01-2015, 09:32   #42
Registered User
 
HappySeagull's Avatar

Join Date: Dec 2010
Location: B.C.,Canada
Boat: 29'
Posts: 2,395
Re: Degrees, Minutes & Seconds Conversion

Quote:
Originally Posted by F51 View Post
I am constantly having to convert lats & longs from degrees, minutes, seconds to degrees, minutes & decimal minutes or just decimal degrees. I am looking for an excel spreadsheet that will handle these conversions both ways. Any ideas? Thanks.
Try a stand-alone portable application GPS Sway
available here
GPS Sway - Coordinate Coverter - GPSFileDepot
__________________

__________________
HappySeagull is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

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 Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lectrasan low voltage at 5 seconds wynmead Plumbing Systems and Fixtures 13 28-09-2013 15:15
Looking For A 12v Button That Will Close The Circuit For X Seconds rebel heart Electrical: Batteries, Generators & Solar 20 13-08-2012 09:45
120 Seconds fishwife Off Topic Forum 5 26-10-2010 10:10
ST6001+ Beeps Every 30 Seconds in Wind Vane Mode dubhouse Marine Electronics 1 12-05-2010 22:50
From 5 to 70 knots in less than 60 seconds Raven Seamanship & Boat Handling 17 01-08-2007 13:45



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -7. The time now is 07:38.


Google+
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Social Knowledge Networks
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.

ShowCase vBulletin Plugins by Drive Thru Online, Inc.