Latitude/ Longitude Converter...

[Blood_Hawk23]

Hey all,

Well I finished it. Its a set of spreadsheets for converting Degrees, Minutes, Seconds coordinates into Decimal Degrees. It Will also go the other way around depending on which sheet you use. Not sure if there is a huge need for it but it might come in handy for Mission and Scenery Creators.

Hopefully I made it simple enough. Sorry I didn't add any directions in the spreadsheets. However, there are some in the Readme. I figured if you don't know what your looking at, then you might not need it.

I've also added my unfinished beta of my Pusan Perimeter Project. A boring read but it my help explain why I made the spreadsheets in the first place.

[Blood_Hawk23]

A new entry has been added to Add-Ons Library, category CFS 2 Utilities Add-ons

Description: Coord Worksheet- For Excel and OpenOffice; GPS Lat and Long Converter.
By John P Fortin (Blood_Hawk23)

Here are two spreadsheets for use in either MS Excel or OpenOffice which will convert Decimal Latitude/Longitude to Degrees, Minutes, Seconds and the other way around. It will also take Decimal Coords and convert them to CFS2 format.

I've included a bata draft of my Pusan Perimiter project. Its unfinished. I may get around to it again. You are welcome to read through it and use it as an example.

So good luck and enjoy.

To check it out, rate it or add comments, visit Map Coord Converter Worksheets.zip
The comments you make there will appear in the posts below.

[Wayland]

Oh, this is great! I can see a lot of uses for this, and will be using it on a regualr basis. Thank You!!

Steve

[dvslats]

Thanks Blood_Hawk.

This will make a nice tool. You can never have too many tools.

[achim27619]

Thank you very much indeed Blood_Hawk,

this is the tool I was waiting for. So far I guessed this conversion now I can be precise.

Cheers


Achim

[glh]

If you Google "Latitude Longitude Converter", you will find a TON of them already out there that do this
in many different formats:

https://www.google.com/search?q=Latitude%2F+Longitude+Converter&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-USfficial&client=firefox-a&channel=nts#rls=org.mozilla:en-USfficial&channel=nts&q=Latitude++Longitude+Converte r

Before I try to do ANYTHING involving processes that can be accomplished by software, I Google what
I imagine are appropriate search phrases. The software or procedure I want is probably already out there
in cyberspace; just gotta find it.

[Shadow Wolf 07]

Sounds like a useful tool... thanks much.

[Blood_Hawk23]

If you Google "Latitude Longitude Converter", you will find a TON of them already out there that do this
in many different formats:

https://www.google.com/search?q=Latitude%2F+Longitude+Converter&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-USfficial&client=firefox-a&channel=nts#rls=org.mozilla:en-USfficial&channel=nts&q=Latitude++Longitude+Converte r

Before I try to do ANYTHING involving processes that can be accomplished by software, I Google what
I imagine are appropriate search phrases. The software or procedure I want is probably already out there
in cyberspace; just gotta find it.

There are alot out there. For me that wasn't the problem. I even reference a few in my Project. The problem was getting everything to work with CFS2 and Google Earth. CFS2 uses a slightly different Lat/Long format. Its a simplified Degree, Minutes, Seconds. Its actually more like Degree and Decimal minutes. Though neither will get the exact coords in CFS2.

Now as Achim and Shadow Wolf know, trying to plot a scenery location tends to be a "Best Guess" in CFS2. The software we use to make the scenery doesn't help the matter. Some want D,M,S. Others want Decimal Degrees. Well none of them can tell you the coords in CFS2.

Now compound that with the fact, as you pointed out, that we all tend to 'Google' our info. This gives us real world info. Though again it doesn't translate into CFS2 acurately. It was also my intent to take from CFS2 and plot it into Google Earth.

Because of all that I made the spreadsheets. With a hope of taking that real world info and make it usable. I hope that I've done just that.

Please point out any errors you find. The formulas could be off. Though everything worked with my test data. There may be some errors in the Southern Latitudes or Western Longitudes. Since most of our missions take place in Northern or Eastern Lat/Long you may not notice.

Areas to watch, Spanish Civil war, Western Atlantic, Pearl Harbor, MTO theater in the North Africa region. Indonesia. Basically South of the Equator or west of the Prime Meridian. So if things don't line up please let me know.

Otherwise, have at it. Sorry it took me so long to finish. Thats one less iron in the fire. Well, kind of. LOL

[Blood_Hawk23]

Here is the link to it in the Warbirds library. Rami must have missed it.

http://www.sim-outhouse.com/sohforum...Worksheets-zip

[Rami]

Good morning,

Sorry, dude! I made it a sticky for you. Sometimes this job feels like an air traffic controller. You try and do right 100% of the time, but usually you only get noticed if you screw something up.