I-AutoCAD-AutoDeskCartografiaUkulanda
Guqula kwendawo ukuze ukubala ngeshumi, UTM udwebe AutoCAD
Lesi sifanekiso se-Excel siqale senziwe ukuguqula ukuxhumanisa kwendawo kube yi-UTM, kusuka kufomethi yedesimali iye kumadijithi, imizuzu namasekhondi. Yini nje ngokuphambene nesifanekiso esasikwenzile ngaphambilini, njengoba kuboniswe kusibonelo:
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
Kwenziwa kanjani ukusebenza kokuguqulwa kokuxhumanisa kwendawo ku-UTM?
- Ukwenza isimo senkambu yokufaka, izakhiwo zibekwa kumaseli. Lokhu kwenziwa ngethebhu yedatha, kunketho yokuqinisekisa idatha. Sikhetha ukuthi kukhona idatha yedesimali kuphela esekelwa phakathi kuka -180 no-180, okuyisilinganiso esiphezulu esisekela ubude. Futhi-ke umyalezo wephutha ukhombisa ukuthi idatha ayivunyelwe. Endabeni yobubanzi, kuboniswa phakathi kuka -90 no-90.
- Ukuze ukhethe i-hemisphere ngobude, obukukholomu G, iseli selungisiwe, uma ukuhlanganiswa kungalungile umbhalo W ubhaliwe, uma kunjalo, umbhalo E.
Lokhu kwenziwa ngefomula =YEBO(G37<0,”W”,”E”)
- Ngendlela efanayo nangama-latitudes ase-H ikholomu, uma ukuhlanganiswa kungalungile, incwadi S ibhaliwe, uma i-N imnandi.
Ifomula izoba =YEBO(H37<0,”N”,”Y”)
- 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 langempela lisuswa kunani elincishisiwe, ukuze kusalwe amadesimali kuphela (0.452140) futhi lelo nani liphindaphindwe ngama-60, okuyinani eliphelele lemizuzu ngedigri. Inqunywe ezindaweni ezingama-zero zero ngakho-ke kutholakala ukuthi ku-0.452140 kunemizuzu engama-27 = TRUNK ((ABS (G37) -J37) * 60,0)
- Ukuthola imizuzwana, siphindaphinda ama-decimals (0.452140) ngo-3600, okuyinombolo yamasekhondi ku-degree (60 × 60), bese sisusa lokho esesikukhiphile ngaphambili, okuyimizuzu (27) ephindaphindwayo izikhathi 60. Bese kusetshenziswa ukugoqa, neseli lesethenjwa lapho inani lezindawo zamadesimali ukuze likwazi ukulungiswa ukunambitha. Ngakho-ke, kunemizuzwana 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 =CONCATENATE(“_iphoyinti “,ROUND(S37,2),”,”,ROUND(T37,2)). Ngokufanayo, umyalo we-polyline =CONCATENATE(“_pline “,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.
Ukuqonda
Siphinde sikuthumele ku-imeyili yakho.
Ngilinde ukulandwa kwesifanekiso se-excel
ngitshele, kwenzekani okungajwayelekile.
Uma uthenge ithempulethi, cela ukwesekwa ngeposi owathola isixhumanisi sokulanda
Othandekayo ukuguqulwa ku-UTM akulungile, amanani ayilungile, sicela usize uma ngenza into engalungile
Ngiyazisa ukuphawula kwakho kodwa awuzange uqonde. Lesi sihloko sichaza ukuthi ungakwenza kanjani wena ngokwakho, njengoba nje ngakwenza.
Hlola i-imeyili, kuhlanganise nogaxekile. Uma unezinkinga eziningi uxhumane nathi kwi-imeyili evela kulamudi yakho.
Ungangisiza ngicela, ngithenge ngekhadi lami futhi angikwazi ukulanda usizo lwethempulethi nge favooor
Ha, uyiphuthelwe.
Zonke izifanekiso zikhululekile emavikini amabili okuqala ngemva kokushicilelwa, bese ukulanda kukhokhiswa.
🙂
Kuyinto engavamile ukuthengisa izifanekiso, ngiyazi ukuthi kunzima ukuzenza kodwa kuhle ukuthi sizokwenza, abangane be-Geofumadas avaces are hahaha kabili kanzima. ????
Sekuvele kunikwe amandla.
Ukubingelela
Ngingathanda ukukhokhela izithombo eziningi ezilapha futhi angikwazi
Ngingayilanda kuphi? ama-templates nokunye okuningi akunakwenzeka (ukucacisa ngokukhokha kwe-paypal) ngiyabonga
EXCELLENT! THANKA NGOKWENZA UKWAZI.
IMIBUZO EVELA EMEXICO.
kuhle kakhulu! UKUTHUTHUKANA NJENGOBA UMSEBENZI WOKWAZI
Ithuluzi eliwusizo kakhulu, langisiza kakhulu, ngiyabonga abangani, imikhonzo evela e-Guanajuato, eMexico
I-gracias
I-EXCELLENT TOOL yangisiza NGAMARAVILLA
Abasebenzi abahle kakhulu… .umsebenzi omuhle kakhulu !! Jabulela