Guqula kwendawo ukuze ukubala ngeshumi, UTM udwebe AutoCAD

Lesi template se-Excel senzelwe ekuqaleni ukuguqula izixhumanisi ze-geographic ibe yi-UTM, kusukela kufomethi yedesimali ukuya kumadigri, imizuzu nemizuzwana. Kwenzekani nje ngokuphambene nesifanekiso esasikwenzile ngaphambilini, njengoba kuboniswe kusibonelo:

Izixhumanisi zendawo

Ukwengeza:

  • Uyabatshela ngochungechunge
  • Ziguqulwe zibe izixhumanisi UTM, nekhetho lokukhetha i-Datum
  • Qondanisa umyalo wephashazi ukuze udale amaphuzu ku-AutoCAD ngekhophi eyodwa / unamathisele
  • Qondanisa umyalo we-polyline ukudweba i-polygonal nge-Copy / unamathisele

Izixhumanisi zendawo

Indlela ukuguqulwa kwezixhumanisi zezwe kuya ku-UTM kwenziwa ngayo:

Izixhumanisi zendawo

  • Ukuze ufake amasimu okufakwayo, ufaka izakhiwo kumaseli. Lokhu kwenziwa ngethebhu yedata, ku-option yokuqinisekisa idatha. Sakhetha ukuthi kukhona kuphela idatha yedatha yokusekela phakathi kwe-180 ne-180 okungaphezulu okusekela ubude. Futhi umyalezo wephutha ubonisa ukuthi idatha ayivunyelwe. Endabeni yezilinganiso, kuboniswa phakathi kwe-90 ne-90.
  • Ukuze ukhethe i-hemisphere ngobude, obukukholomu G, iseli selungisiwe, uma ukuhlanganiswa kungalungile umbhalo W ubhaliwe, uma kunjalo, umbhalo E.

Lokhu kwenziwa ngefomula = YES (G37 <0, »W», »E»)

  • Ngendlela efanayo nangama-latitudes ase-H ikholomu, uma ukuhlanganiswa kungalungile, incwadi S ibhaliwe, uma i-N imnandi.

Ifomula izoba = YES (H37 <0, »N», S S))

  • Ukuze ukhiphe amadigri, inani eliphelele lisetshenzisiwe futhi inombolo inamathele ama-zero decimals = ABS (TRUNK (G37,0)) Ngale ndlela, i-87.452140 izoba yi-87
  • Ukukhipha amaminithi, inani lokuqala lexabiso elilinganiselwe lisuswa, ukuze kuphela ama-decimals (0.452140) futhi lelo nani liphindwe yi-60, okungenani inani lamaminithi ngezinga. Iqondiswe ezindaweni zedesimali futhi ngaleyo ndlela itholakala ukuthi ku-0.452140 kunemizuzu engu-27 = TRUNK ((ABS (G37) -J37) * 60,0)
  • Guqula izixhumanisi zendawo ku-UTMKule yakamuva, amadesimali (0.452140) iyanda yi 3600 okuyinto isibalo imizuzwana e ngezinga (60 × 60) futhi sisuswe yini siye ngaphambili sisuswe, okuyizinto imizuzu (27) iphindwe ngu-60. ukuqoqa is zizosetshenziswa kweseli lapho inombolo yezindawo zedesimali kuyinto ukuze ukwazi ukulungisa ukunambitha. Ngakho unemizuzwana engu-7.704. =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
  • Ukuze ugcizelele umyalo wephoyinti, i-string ye-_point isetshenzisiwe, ukuze kuphela amaseli akopishwe kulayini lomyalo we-AutoCAD = QINISEKISA («_ iphuzu«, Round (S37,2), »,», Round (T37,2). Ngokufanayo, umyalo we-polyline = QINISEKISA («_ ipline«, Round (S37,2), »,», Round (T37,2). Ukujikeleza kusetshenziselwa ukuze amaketanga angenziwa isikhathi eside kakhulu.

Esikhathini sethempulethi kukhona amathiphu okwenza lesi senzo sokugcina.

Kusuka lapha ungalanda isifanekiso, ukukhokha Ikhadi lesikweletu noma i-Paypal.



Funda ukuthi ungenza kanjani lezi ezinye izifanekiso ku Inkambo yokukopela ye-Excel-CAD-GIS.


Izimpendulo ze-16 kuya "Guqulela ama-decimal geographicalities kuya degrees, ukuya ku-UTM bese udweba ku-AutoCAD"

  1. Othandekayo ukuguqulwa ku-UTM akulungile, amanani ayilungile, sicela usize uma ngenza into engalungile

  2. Bheka i-imeyili, kufaka ogaxekile. Uma unezinkinga ezengeziwe, xhumana nathi ku-imeyili evela kwirisidi lakho.

  3. Ungangisiza ngicela, ngithenge ngekhadi lami futhi angikwazi ukulanda usizo lwethempulethi nge favooor

  4. Ha, uyiphuthelwe.

    Zonke izifanekiso zikhululekile emavikini amabili okuqala ngemva kokushicilelwa, bese ukulanda kukhokhiswa.

    🙂

  5. Kubi ukuthi bathengisa izifanekiso, ngiyazi ukuthi kubiza malini ukuzenza kodwa okuhle esizokwenza, abangane be-Geofumadas avights bangama-hard hard hahaha. 🙂

  6. Ngingathanda ukukhokhela izithombo eziningi ezilapha futhi angikwazi

  7. Ngingayilanda kuphi? ama-templates nokunye okuningi akunakwenzeka (ukucacisa ngokukhokha kwe-paypal) ngiyabonga

  8. EXCELLENT! THANKA NGOKWENZA UKWAZI.
    IMIBUZO EVELA EMEXICO.

  9. Ithuluzi eliwusizo kakhulu, langisiza kakhulu, ngiyabonga abangani, imikhonzo evela e-Guanajuato, eMexico

Shiya impendulo

Ikheli lakho le ngeke ishicilelwe.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda ukuthi idatha yakho yokuphawula isetshenziswa kanjani.