Тёмный

Converting Degree Minutes (DM) to Decimal Degrees (DD) 

Moulay Anwar Sounny-Slitine
Подписаться 6 тыс.
Просмотров 41 тыс.
50% 1

In this video I convert Longitude and Latitude from Degree Minutes (DM) to to Decimal Degrees (DD) in Excel. I apply the Text-to-column tool, then I use a find and replace to clean up the numbers. ONce that is done I apply a formula that converts minutes to degrees and adds it to degree to get the final decimal degree for the sheet.

Опубликовано:

 

20 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 29   
@medium-old
@medium-old Месяц назад
Hi Prof -- I took your class in at UF, back in 2020. Working now heavily with marine geospatial coordinates which require this conversion. Thanks so much for your dedication to publicly accessible GIS tutorials.
@sounny
@sounny Месяц назад
So happy you are still benefiting from it. Thanks for the kind words.
@FRK-f9s
@FRK-f9s Год назад
Very helpful! Thanks a lot for detailed explanation without time wasting!
@BrianWasHere
@BrianWasHere 3 года назад
This is exactly what I needed for a project I'm working on. Many thanks!
@HBOIchip
@HBOIchip 2 года назад
as a florida marine scientist, I am always in this same situation, the text to columns trick is great, and thanks for the reminder for the rest (this is after going from DMS to DM.m)
@jamesbailey674
@jamesbailey674 3 года назад
You just saved me 60hrs of work. TY so much
@spencerphillips3905
@spencerphillips3905 2 года назад
Thank you very much! Straightforward and easy to follow.
@nmlogistics4426
@nmlogistics4426 3 года назад
exactly what i was looking for! a million thanks!
@supuchick
@supuchick 5 лет назад
Thank you so much Moulay, your illustrations done step-by-step are veeeery helpful, totally sorted me out! :)
@albandemontgolfier9116
@albandemontgolfier9116 2 года назад
Thanks for the tips, that was clear !
@sounny
@sounny 2 года назад
Happy it helped.
@EngrRajaSherazAhmed
@EngrRajaSherazAhmed 5 месяцев назад
its very helpfull Bravo
@droserabinata
@droserabinata Год назад
Hey I keep coming back to this video every time I have to do this. I work in a natural history collection and people submit data in all kinds of different formats.
@sounny
@sounny Год назад
Great to hear it is having a positive impact for your work.
@droserabinata
@droserabinata Год назад
I used it again
@AjithVenkatesanBhuvana_
@AjithVenkatesanBhuvana_ 2 года назад
Hello Sir, I'm Ajith From India, I have followed your pattern for the conversion of DM to DD but for me, the formula is not working it shows the value as an error. Can you please help me to sort out the issue?
@surferol10
@surferol10 3 года назад
Good explanation, how about if the data contains positions in both the northern and southern hemisphere, eastern and western hemisphere?
@claudiubita8435
@claudiubita8435 3 года назад
Thank you for this video!
@jempabiona9021
@jempabiona9021 6 лет назад
Thank you so much for this!
@nishanghimire3502
@nishanghimire3502 2 года назад
Thankyou you really saved me
@seanherd-hoare2251
@seanherd-hoare2251 4 года назад
Thank you, very useful!!
@happykhan299
@happykhan299 4 года назад
Great..can you please guide on Lamert datum transformation...I am facing this problem...will be great help.. Or any formula in excel.. Points or toposheet is on Lambert, indian zone1 wgs 84 N41.. Thanks
@shaneliki
@shaneliki 5 лет назад
Thanks alot, this has helped me today
@mithrandir1313
@mithrandir1313 Год назад
A W E S O M E ! tnx!
@aliyahbhatbhat8458
@aliyahbhatbhat8458 Год назад
Thank you
@frezera6381
@frezera6381 5 лет назад
helped me a lot
@jonathanopokuoti9688
@jonathanopokuoti9688 5 лет назад
Excellent
@martinsmuts2557
@martinsmuts2557 6 лет назад
Thanks!
@JustRonDon
@JustRonDon 5 лет назад
thank you
Далее
1 Subscriber = 1 Penny
00:17
Просмотров 46 млн
Это было КРАСИВО!
01:00
Просмотров 992 тыс.
1 Subscriber = 1 Penny
00:17
Просмотров 46 млн