Re: [UKHAS] ddmm.mmmm to dd.dddd online or with excel

[Mike Willis]

Just do some string processing and then apply a little basic algebra. Minutes are 1/60ths of a degree so to get from decimal minutes mm.mmmm to fractions of a degree simply divide by 60. Same process if it is in degrees mins seconds. The only tricky bit is the string formatting which will need some thought. I have never seen a ddmm.mmmm format. Do you mean dd mm.mmmm?

Mike

On Dec 25, 2012 3:15 PM, "Andrea Germanà" <andre...@gmail.com> wrote:

Hi folks,

I use Sim908 module for record GPS location and Arduino.

Sim908 send the lat and lon in ddmm.mmmm format, but the major service of GPS location online (for example google earth) use the dd.dddd format.

So, How can I convert multiple coordinate to dd.dddd format ?

There is a online converter (I upload a csv file) or a excel functions ?

Thank you so much !

@anerDev

--
 
 

[Allen Sklar]

Hello All

 

Happy Holidays !!!!

 

Andrea,

 

Is this what your looking for ????

 

http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html

 

http://www.directionsmag.com/site/latlong-converter/

 

http://www.ig.utexas.edu/outreach/googleearth/latlong.html

 

Hope this helps...

Allen Sklar, W7AS

Tempe AZ USA

[John Tanner]

Andrea

I'd suggest having a look at using GNU Octave or Scilab (if you aren't a confident programmer) and writing your own code to import a csv file, convert the lat/long data, and then write it back out to a csv. 

Unfortunately, sometimes precisely what you want/need isn't already available on the Internets. If you do write some code, be sure to share it on GitHub so that it is available for others to use in the future. 

Good luck :)

JT

On 26 Dec 2012, at 10:31, Andrea Germanà <andre...@gmail.com> wrote:

HI,

Thank you so much for the response !

I use this site for convert my coordinates from ddmm.mmm to dd.dddddd: http://www.earthpoint.us/Convert.aspx

I put the coordinates in the correct field and it convert !

For example: lat: 3807.947373  lon: 1443.568069 

The output is 

Degrees Lat Long

38.1324562°, 014.7261345°

After I put on Google Earth and it work ! (watch the attachment file EarthPointFlyTo.kml) 

So, my problem isn't the conversion of one coordinate, but is the conversion of many coordinates ! (watch the attachment file dati.csv) 

I need a tool, or a method in excel/open office, to convert a list of coordinates (ddmm.mmmm) to "universal" format (dd.dddddd) ..

This website, http://www.earthpoint.us/Convert.aspx, can convert many coordinates from .csv or .xls file, but need to pay :(

I don't know if I explain my problem, sorry for my bad english !

Andrea

Il giorno martedì 25 dicembre 2012 15:25:13 UTC+1, Andrea Germanà ha scritto:

Hi folks,

I use Sim908 module for record GPS location and Arduino.

Sim908 send the lat and lon in ddmm.mmmm format, but the major service of GPS location online (for example google earth) use the dd.dddd format.

So, How can I convert multiple coordinate to dd.dddd format ?

There is a online converter (I upload a csv file) or a excel functions ?

Thank you so much !

@anerDev

--
 
 

<EarthPointFlyTo.kml>

<dati.csv>

[Daniel Richman]

= TRUNC(A1 / 100.0) + ((A1 / 100.0) - TRUNC(A1 / 100.0)) / 0.6

?

Not particularly well tested, so no guarantees (though I did check a few obvious cases/negative numbers). Hope that helps.

Daniel

--
 
 

[Daniel Richman]

Hi Andrea,

Your attachment does not open properly for me so I can't tell what the
problem is, however:

If you put the latitude or longitude in cell B1 then you will need to
change all A1s to B1 in the formula.

Daniel

On 26 December 2012 12:54, Andrea Germanà <andre...@gmail.com> wrote:
> Hi,
>
> I have created a excel page, but the formula don't work !
>
>
> Watch the attachment file
>
> --
>
>

[Mike Willis]

Here is something simple to explain how it was done. It could all be done in one formula of course.

[Mike Willis]

That is interesting. Open office normally works but the formula is right. The two results you have are of course the same number to different levels of precision. If you need to limit the number of decimals use the number formatting options in the spreadsheet.

 

From: uk...@googlegroups.com [mailto:uk...@googlegroups.com] On Behalf Of Andrea Germanà
Sent: 26 December 2012 14:04
To: uk...@googlegroups.com
Subject: [UKHAS] Re: ddmm.mmmm to dd.dddd online or with excel

 

I use OpenOffice and there is a problem ! Because I can't view the result !

 

But I watched the formula:

 

for extract the dd use: =INT(B2/100)

for extract .dddddd use: =(B2-C2*100)/60

and for dd.dddddd: =C2+D2

 

But the result is in this format: dd.ddddd, have 5 d ...

 

There are different between 38.13246 and 38.1324562 ?

 

thank you

 

 

--