Hoohuli Geographic i hŘnń ia i kekimala degere, UTM, a kokoke ia ma ka AutoCAD

Hana mua ʻia kēia anakuhi Excel e hoʻolilo i nā wahi hulina i UTM, mai ka palapala kekona a i nā kekele, minuke a me kekona. He aha wale nō e kū'ē i ke mamua i hana muaʻia e mākou, e like me ka mea iʻikeʻia ma ka hiʻohiʻona:

Pāku'i hou:

• Hoʻopiʻiʻo ia iā lākou i kahi kaulahao
• Hoʻololi iā lākou i nā kaʻina UTM, me ke koho e koho i kahi Datum
• E hoʻokumu i ke kauoha kiko e hana i nā helu ma ka AutoCAD me kahi kope / pākaʻi
• E hoʻokumu i ka kauoha polyline e huki i ke alahele me kahi kope / paʻu

Pehea ka hana o ka hoʻohuli ʻana i nā wahi kūlike i UTM:

• No ke ʻano o nā kahua hoʻokomo, kau ʻia nā waiwai ma nā hunaola. Hana ʻia kēia me ka ʻikepili ʻIkepili, i ke koho hōʻoia ʻikepili. Koho mākou i laila e kākoʻo wale i ka ʻikepili decimal ma waena o -180 a me 180, ʻo ia ka palena kiʻekiʻe e kākoʻo ana i nā lōʻihi. A laila hōʻike i ka ʻelele hemahema ʻaʻole ʻae ʻia ka ʻikepili. I ke ʻano o nā latitude, ua hōʻike ʻia ma waena o -90 a me 90.
• E koho i ka hemisphere i loko o kona lōʻihi, a nō ka kolamu G, o ka halepaahao keia, i ina ka i kahi kūlike o ka io ka mea i palapalaia i ka W kikokikona, ina maikaʻi kikokikona ua kau E.

Ua hanaʻia kēia me ke kumuhana   = ʻAe(G37<0,”W”,”E”)

• Penei hoʻi me nā latitudes i loko o ka pae H, inā heʻole ka'ōpala, e kākau i ka leka S, inā he mea kūpono ia.

E lilo ke kumupaa   = ʻAe(H37<0,”N”,”Y”)

• No ka unuhiʻana i nā degree, ua hoʻohanaʻia ka helu kūpono a ua hoʻopunipuniʻia ka helu a loaʻaʻole nā ​​decimals = ABS (TROUBLE (G37,0)) i kēiaʻano, e hoʻololiʻiaʻo -87.452140 i ka 87
• No ka unuhi ʻana i nā minuke, ua unuhi ʻia ke kumu kumu mai ka waiwai i ʻoki ʻia, no laila koe wale nā ​​decimals (0.452140) a hoʻonui ʻia kēlā waiwai i 60, ʻo ia ka huina helu o nā minuke i kahi kekelē. Kuhi ʻia ia i nā wahi keke ʻole a no laila loaʻa iā mākou i ka 0.452140 aia he 27 mau minuke = TRUNC ((ABS (G37) -J37) * 60,0)
• No ka loaʻa ʻana o nā kekona, hoʻonui ʻia nā decimals (0.452140) e 3600, ʻo ia ka helu o kekona i kahi kekelē (60 × 60), a unuhi mākou i nā mea a mākou i unuhi ai ma mua, ʻo ia nā minuke (27) i hoʻonui ʻia. manawa 60. A laila hoʻopili ʻia kahi pōʻai, me kahi keaka kikoʻī kahi o ka helu o nā wahi decimal e hiki ai ke hoʻoponopono ʻia e like me ka ʻono. No laila, he 7.704 kekona.   =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
• No ka hoʻopiʻiʻana i ke kauoha o ka mākuhi, hoʻohanaʻia ka string string, no laila e kope kopeʻia nā pūnaewele i ka laina kauoha o AutoCAD =CONCATENATE(“_point “, ROUND(S37,2),”,”, ROUND(T37,2)).  Pēlā hoʻi, ke kauoha polyline =CONCATENATE(“_pline “, ROUND(S37,2),”,”, ROUND(T37,2)).  Hoʻopiliʻia ka paeʻana no ka meaʻaʻole lōʻihi nā kaulahao.

Aia i loko o ke kumukūʻai he mau manaʻo kōkua e hana i kēia hana hope loa.

Maiʻaneʻi hiki iāʻoe ke kiʻi i ke kumukūʻai, me ka ukuʻana me Kāleka Kāpena a Paypal paha.