Sinthani ndondomeko malo osiyanasiyana digiri decimal, UTM kujambula AutoCAD

Template iyi ya Excel imapangidwa koyambirira kuti isinthe magawo amtundu kukhala UTM, kuchokera pamitundu ya decimal mpaka madigiri, mphindi ndi masekondi. Zomwe chosiyana ndi template yomwe tachita kale, monga tawonera mu chitsanzo:

Kuwonjezera apo:

• Iye akuwatsimikizira iwo mu unyolo
• Amawasandutsa iwo ku makonzedwe UTM, ndi kusankha kusankha Datum
• Gwiritsani ntchito lamulo la dotolo kuti mupange mfundo ku AutoCAD ndi imodzi yokha
• Gwiritsani ntchito lamulo la polyline kuti muyambe kutsogolo ndi Copy / paste

Kodi ntchito yosintha makonzedwe amtundu wa UTM ikuchitika bwanji?

• Pofuna kukhazikitsa magawo olowa, katundu amaikidwa m'maselo. Izi zachitika ndi tabu ya Data, posankha kutsimikizira deta. Timasankha kuti pamangogwirizira zidziwitso za pakati pa -180 ndi 180, zomwe ndizochuluka kwambiri zomwe zimathandizira kutalika. Ndiyeno uthenga wolakwika ukuwonetsa kuti deta siyiloledwa. Pankhani ya ma latitudo, amawonetsedwa pakati pa -90 ndi 90.
• Kusankha Chigawo zotalika omwe ndime G zinthu khungu, kuti ngati ntchito ndi zoipa za W lemba kwalembedwa, ngati mawu abwino aikidwa E.

Izi zachitika ndi ndondomekoyi   =INDE(G37<0,”W”,”E”)

• Mofananamo ndi ma latitudes omwe ali m'mbali H, ngati mgwirizanowu uli wolakwika, lembani kalata S, ngati ndizogwirizana N.

Njirayi idzakhala   =INDE(H37<0,”N”,”Y”)

• Kuchotsa madigiri, mtengo wapatali umagwiritsidwa ntchito ndipo chiwerengerocho chimadulidwa mpaka zero zochepa = KUKHALA KWAMBIRI (KUDZIWA (G37,0)) motere, -87.452140 idzasinthidwa ku 87
• Kuti mupeze mphindi, mtengo woyambirira umachotsedwa pamtengo wotsika, kotero kuti zotsalira zokha ndizomwe zimatsalira (0.452140) ndipo mtengowo umachulukitsidwa ndi 60, yomwe ndi chiwerengero chonse cha mphindi mu digiri. Amachotsedwa m'malo opanda zero motero amapezeka kuti mu 0.452140 pali mphindi 27 = TRUNC ((ABS (G37) -J37) * 60,0)
• Kuti tipeze masekondi, ziwonetsero (0.452140) zimachulukitsidwa ndi 3600, yomwe ndi kuchuluka kwa masekondi mu degree (60 × 60), ndipo timachotsa zomwe tidachotsapo kale, zomwe ndi mphindi (27) zochulukitsidwa nthawi 60. Kenako kuzungulira kumayikidwa, ndi selo yolozera komwe kuchuluka kwa malo amalo osungira kumatha kusinthidwa kuti kulawe. Chifukwa chake, pali masekondi 7.704.   =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
• Kuti agwirizane ndi lamulo loti, chingwe_chiwonetsero chikugwiritsidwa, kotero kuti maselo okha amangoponyedwa ku mzere wa command AutoCAD =CONCATENATE(“_point “,ROUND(S37,2),”,”,ROUND(T37,2)).  Mofananamo, lamulo la polyline =CONCATENATE(“_pline “,ROUND(S37,2),”,”,ROUND(T37,2)).  Kuzungulira kumagwiritsidwa ntchito kotero kuti maunyolo siatali kwambiri.

Mu template pali zotsatila zotsatila zochita izi.

Kuchokera pano mukhoza kukopera template, kulipira Makhadi a ngongole kapena Paypal.