Guqulela zika ethile ngeshumi, UTM nokuzoba in AutoCAD

Itemplate ye-Excel yenziwe kuqala ukuba iguqule indawo ye-UTM, ukusuka kwifomathi yedesimali ukuya kwiidigri, imizuzu kunye nemizuzwana. Yintoni kanye 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

 

Kwenziwa njani ukusebenza kokuguqula ulungelelwaniso lwejografi kwi-UTM kwenziwe:

Ukulungelelaniswa kweendawo

  • Ukubeka imeko kwimihlaba yokufaka, iipropathi zibekwe kwiiseli. Oku kwenziwa ngeTebhu yedatha, kukhetho lokuqinisekisa idatha. Sikhethe ukuba kukho idatha yedesimali exhasa kuphela phakathi kwe-180 kunye ne-180, elilelona liphezulu lixhasa ubude. Kwaye ke umyalezo wemposiso ubonakalisa ukuba idatha ayivumelekanga. Kwimeko yobubanzi, kubonisiwe phakathi kwe -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   = IF (G37 <0, »W», »E»)

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

Imfomula iya kuba   = IF (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 imizuzu, ixabiso lantlandlolo liyasuswa kwixabiso elincitshisiweyo, ukuze kushiyeke kuphela iidesimali (0.452140) kwaye elo xabiso liphindaphindwe ngama-60, elilixa lilonke lemizuzu kwisidanga. Inqunyulwe kwiindawo ezingama-zero kwaye ngenxa yoko kufunyenwe ukuba kwi-0.452140 kukho imizuzu engama-27 = I-TRUNK ((ABS (G37) -J37) * 60,0)
  • Ukuguqula idilesi ye-UTMUkufumana imizuzwana, iidesimali (0.452140) ziphindaphindwe ngama-3600, eli inani lemizuzwana kwisidanga (60 × 60), kwaye sithatha into esele siyikhuphile ngaphambili, yimizuzu (27) ephindaphindwayo amaxesha 60. Emva koko kusetyenziswa ukujikeleza, kunye neselferensi yeselfowuni apho inani leendawo zokugqibela zinokuhlengahlengiswa ukuba zingcamle. Ke, kukho imizuzwana eyi-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 ezi-16 "Guqula idesimali yedigital iququzelela ukuya kwiidigri, uye kwi-UTM kwaye uzobe kwi-AutoCAD"

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

  2. Ndiyayibulela intetho yakho kodwa awukaqondi. Inqaku licacisa kakuhle ukuba ungayenza njani ngokwakho, njengoko ndenzile.

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

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

  5. Ha, ulahlekile.

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

    🙂

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

  7. Ndingathanda ukuhlawula ezininzi zezityalo ezilapha kwaye andinako

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

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

  10. EZIQHELEKILEYO UKUBHUMANA NJENGOBA UKUZIWA KWENKCAZO

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

  12. ISICWANGCISO ESISEBENZELEKILEYO SANGENCEDISA NGEMIBUZO

  13. Abasebenzi abalunge kakhulu… .umsebenzi ogqwesileyo !! Masinwabe

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

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