Guqulela zika ethile ngeshumi, UTM nokuzoba in AutoCAD

Ithemplateli ye-Excel yenziwe ekuqaleni ukuba iguqulwe i-geographic coordinates ibe yi-UTM, ukusuka kwifomati yedesimali ukuya kumadigri, imizuzu kunye nemizuzwana. Yintoni nje ngokuchasene nethemplate esayenza ngaphambili, njengoko kuboniswe kumzekelo:

Ukulungelelaniswa kweendawo

Ukongezwa:

  • Uyabatshengisa ngokukhenketha
  • Ukuguqula kwii-coordinates UTM, kunye nenketho yokukhetha iDatum
  • Qinisekisa umyalelo wecatshulwa ukudala amaphuzu kwi-AutoCAD ngekhophi enye / unamathisele
  • Qinisekisa umyalelo we-polyline ukudweba i-polygonal nge Copy / unamathisele

Ukulungelelaniswa kweendawo

Indlela ukusebenza ngayo ukuguqulwa kweendawo zokuhlala kwi-UTM kwenziwe:

Ukulungelelaniswa kweendawo

  • Ukumisela imimandla yenkxaso, ubeka izakhiwo kwiiseli. Oku kwenziwa ngeTebhu yedata, kwindlela yokuqinisekisa idatha. Sakhetha ukuba kukho kuphela inkxaso yedatha yedatha phakathi kwe-180 kunye ne-180 eyona nto ibalulekileyo exhasa ubude. Emva koko umyalezo wephutha ubonisa ukuba idatha ayivunyelwe. Kwimeko yokulandelana, kuboniswa phakathi -90 kunye ne-90.
  • Ukuze ukhethe ikhweyitha e ubude, leyo kumhlathi G, iimeko iseli, ukuba lo yokuququzelela lelikhabayo W kwitekisi ebhaliweyo, ukuba okubhaliweyo ezintle ibekwa E.

Oku kwenziwa ngefomula = EWE (G37 <0, »W», »E»)

  • Ngendlela efanayo kunye neendlela ezisekholini H, ukuba ulungelelaniso lubi, i-letter S ibhaliwe, ukuba i-N. ilungile.

Imfomula iya kuba = EWE (H37 <0, »N», »S»)

  • Ukukhupha iidridi, ixabiso elipheleleyo lisetyenzisiweyo kwaye inani linamanqanaba atshwayo = ABS (I-TRUNK (G37,0)) Ngale ndlela, i-87.452140 iya kuba yi-87
  • Ukukhupha imaminithi, ixabiso langaphambili lexabiso eligqithisiweyo liyakhutshwa, ukwenzela ukuba kuphela i-decimals ehlala (0.452140) kwaye olo xabiso lwandiswa yi-60, leyo iyonke inani lemizuzu ngezinga. Ixunyiwe kwiindawo ezidumileyo kwaye ke kufumaneka ukuba kwi-0.452140 kukho imizuzu ye-27 = I-TRUNK ((ABS (G37) -J37) * 60,0)
  • Ukuguqula idilesi ye-UTMKuba yokugqibela, idesimali (0.452140) yande ngo 3600 leyo inani lemizuzwana kuchazo isidanga (60 × 60) yaye sisuswe koko siye sisuswe ngaphambili, ezo imizuzu (27) banda 60. Emva koko kusetyenziswe ukujikeleza, kunye neselferensi yesalathisi apho inani lezitshatyalali likwazi ukulungiswa ukuze lithande. Ngoko unemizuzwana ye-7.704. =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
  • Ukumisela umyalelo wephuzu, umtya we-_point usetyenziswe, ukuze kuphela iiseli zikopishwe kumgca we-AutoCAD umyalelo = QINISEKISA («_ inqaku«, Round (S37,2), »,», Round (T37,2). Ngokufanayo, umyalelo we-polyline = QINISEKISA («_ ipline«, Round (S37,2), »,», Round (T37,2). Ukujikeleza kusetyenziswa ukwenzela ukuba iintambo ezide kakhulu zingenziwa.

Kwi-template kukho ezinye izicwangciso zokuqhuba lo msebenzi wokugqibela.

Ukusuka apha ungalanda i template, ukuhlawula Ikhadi lesikweletu okanye i-Paypal.



Funda ukuba ungayenza njani le kunye nezinye itemplate kwi Ikhosi yokukopela ye-Excel-CAD-GIS.


Iimpendulo ze-16 "Ukuguqula i-decimal yolwazi idibanisa ukuya kumadigri, ukuya ku-UTM uze udwebe kwi-AutoCAD"

  1. Othandekayo ukuguqulwa kwi-UTM ayilunganga, ixabiso alichanekanga, nceda uncede ukuba ndenza into engalunganga

  2. Jonga i-imeyile, kubandakanya ugaxekile. Ukuba uneengxaki ezininzi, sinxibelelane nathi nge-imeyile ebonakala kwirisithi yakho.

  3. Unokundinceda, ndenze ukuthenga ngekhadi lam kwaye andinakukukhuphela uncedo lwe template nge favooor

  4. Ha, ulahlekile.

    Zonke iitemplates zikhululekile kwiiveki ezimbini zokuqala emva kokushicilelwa, kwaye ukukhuphela kuhlawulwa.

    🙂

  5. Kubi ukuba bathengisa itemplates, ndiyazi ukuba iindleko zokwenza ntoni kodwa into emnandi siza kuyenza, izihlobo zee-Geofumadas avaces zisiqingatha se-hahaha. 🙂

  6. Ndingathanda ukuhlawula ezininzi zezityalo ezilapha kwaye andinako

  7. Ndingayilanda phi? iimodeli kunye nokunye okuninzi akunakwenzeka (kucacisa nge-paypal payment) mbulela

  8. KUNYE! NOKUBA WAKHO UKUBA UKUFAKA UKWAZI.
    IIMVUMO EZIFUNDA EMEXICO.

  9. EZIQHELEKILEYO UKUBHUMANA NJENGOBA UKUZIWA KWENKCAZO

  10. Ithuluzi eluncedo kakhulu, landincede kakhulu, nkosibulela bahlobo, ukubingelela kwilizwe laseGuanajuato, eMexico

  11. ISICWANGCISO ESISEBENZELEKILEYO SANGENCEDISA NGEMIBUZO

  12. Ithemplate enhle kakhulu ... umsebenzi obalaseleyo! Ukubulisa

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.