• There seems to be an uptick in Political comments in recent months. Those of us who are long time members of the site know that Political and Religious content has been banned for years. Nothing has changed. Please leave all political and religious comments out of the forums.

    If you recently joined the forums you were not presented with this restriction in the terms of service. This was due to a conversion error when we went from vBulletin to Xenforo. We have updated our terms of service to reflect these corrections.

    Please note any post refering to a politician will be considered political even if it is intended to be humor. Our experience is these topics have a way of dividing the forums and causing deep resentment among members. It is a poison to the community. We appreciate compliance with the rules.

    The Staff of SOH

  • Server side Maintenance is done. We still have an update to the forum software to run but that one will have to wait for a better time.

Latitude/ Longitude Converter...

Blood_Hawk23

Blood_Hawk23

Charter Member
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.
 
Map Coord Converter Worksheets.zip

163814161156262820.jpg

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.
 
Converter

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
 
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
 
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-US:eek:fficial&client=firefox-a&channel=nts#rls=org.mozilla:en-US:eek:fficial&channel=nts&q=Latitude++Longitude+Converter

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.
 
glh said:
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-US:eek:fficial&client=firefox-a&channel=nts#rls=org.mozilla:en-US:eek:fficial&channel=nts&q=Latitude++Longitude+Converter

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.
Click to expand...

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
 
Reply...

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.
 
You must log in or register to reply here.
Back
Top