I have often seen requests for a means to convert the latitude and longitudes that are aopften given so they can be used by the gps software etc.
I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000
Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)
This should give you 23.3902778 .
I do a copy and then a paste special and use "values" into where you want the latitude. This should give you the results of D2 in the other spreadsheet
I don't worry about the last set.
I usually run the two spreadsheet when copying rest stop etc that I find and after a while it is quite easy and quick. I use the CTRL C for the copy but you have to use the menu for the rest unless you want to create a macro.
I have the reverse formula as well but most need the one described.
Hope this may help someone
Regards
Brian
__________________
11 Mtr house Boat based at Mannum hoping to travel up the Murray as far as I can get then drift back again
The link below looks like it will do the conversion online. The RFS use the GDA I think and the choppers use the lat and longs so been meaning to look for a conversion tool. I believe there are some.
I have often seen requests for a means to convert the latitude and longitudes that are aopften given so they can be used by the gps software etc.
I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000
Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)
This should give you 23.3902778 .
I do a copy and then a paste special and use "values" into where you want the latitude. This should give you the results of D2 in the other spreadsheet
I don't worry about the last set.
I usually run the two spreadsheet when copying rest stop etc that I find and after a while it is quite easy and quick. I use the CTRL C for the copy but you have to use the menu for the rest unless you want to create a macro.
I have the reverse formula as well but most need the one described.
Hope this may help someone
Regards
Brian
Lt James Cook's worst nightmare.
How did I ever navigate my way up the Qld coast without Satnav(in those days) Gps etc?
To each his own but if I ever have to resort to that I'll just book myself into the nursing home now.
To each his own but if I can't get there on land with a map/chart compass and dead reckoning and a few skills, I don't think I'll go. If I really have to I'll throw in a sextant. lol
There is not to many that can use a sextant anymore.
Even when i did my ticket we played with one so we knew how it worked etc but even by then radar was the norm for coastal navigation and GPS was just coming in and I found it invaluable as we were expected to navigate to very close tolerances and radar was unpredictable due to changes in atmospheric changes such as mist and temp changes etc so hard to work of a coast or mountains when the you had mist or rain etc.
Given that it was interesting during the wars over the other side when they kept changing the satellites.
Spent some hairy trips sailing across the Nulabour etc at 2000Ks whilst tied to the whalf or trawling down the gulf at 2 knots LOL. We had to wait till their attack was over and then it returned to normal.
Dead reckoning is OK when your are not working to 1/10 of a mile and 28 miles from shore.
Regards Brian
__________________
11 Mtr house Boat based at Mannum hoping to travel up the Murray as far as I can get then drift back again
I use a spreadsheet so I will try and explain how I have set it up as others may wish to try it as well I will describe how to convert 32.24.29.000
Create a new one spreadsheet and then in cell a3 place the 32 in cell b3 put the 25 and in c3 put the 29 and then in other cell eg d2 type in =A3+(B3/60)+(C3/3600)
I found this handy little URL to help me as I don't have a GPS tracker or nav/sat. I do have a Samsung Tablet with internet which we have found very useful for looking up random places and things.
http://itouchmap.com/latlong.html All you have to do is find the place on a map of the world, double click at the exact place and the website gives the lat and long below the map. I will test this out at Xmas time so will get back as to how handy it is 'on the road'.
I found this handy little URL to help me as I don't have a GPS tracker or nav/sat. I do have a Samsung Tablet with internet which we have found very useful for looking up random places and things.
Charts and maps with the aid of a compass and using dead reckoning is fine for getting from A to B out in the open, or in the bush, but you'd be busier than a one armed wall paper hanger with fleas, using that method to traverse one of our capitol cities in peak hour. And yes, they do sometimes try to send you up the garden path, or the wrong way down a one way street, but like everything (including paper maps) they are only as good as the currency of the data. A GPS (in car navigator type) can be an invaluable tool when planning routes where you need to arrange to be at a camp site and set up by a certain time of day (many work off historical trip times for certain routes), especially if you have one of the camp site databases loaded into it. Or if you want to get from A to B across a city and avoid toll roads because you don't have an E tag and there aren't toll booths to take your money. Or if your other half simply can't read a road map and you need to make a quick decision to turn left or right in peak hour traffic. And if you do take the wrong turn they'll usually get you back on track pretty quickly. Also some of them will give you up to date Traffic Alerts in Capitol cities (not many cities have this function yet though) and allow you to change your route to avoid them. But like any sort of electronic nav aid you do need a backup, which is where the paper maps are good.
Edit: Another handy feature for a lot of them is you can search out local business in an unfamiliar city by way of keyword searching, or dedicated buttons for servos, ATM's, restaurants, medical assistance or even a closeby public loo if you had a dodgy vindaloo at the Indian restaurant it pointed you to.
-- Edited by 03_troopy on Monday 1st of July 2013 07:18:42 PM