Hloov geographic coordinates rau decimal degrees, UTM thiab yog nqus nyob rau hauv AutoCAD

No Excel template pib ua kom hloov pauv ntawm thaj chaw hauv UTM, los ntawm hom ntawv zauv mus rau degrees, feeb thiab vib nas this. Yog vim dab tsi tsis tooj mus rau lub qauv uas peb tau ua yav tas los, raws li pom nyob rau hauv qhov kev piv txwv:

Ntxiv mus:

• Nws concatenates lawv nyob hauv ib lub saw
• Hloov lawv rau cov haujlwm UTM, nrog rau txoj kev xaiv Xaiv
• Concatenate cov lus hais kom ceev kom tsim tau cov ntsiab lus hauv AutoCAD nrog ib daim Copy / muab tshuaj
• Concatenate cov lus txib polyline mus kos tus polygonal nrog ib Copy / paste

Yuav ua li cas kev ua haujlwm ntawm kev hloov kev ua haujlwm ntawm thaj chaw hauv UTM ua tiav:

• Txhawm rau hais kom cov tswv yim teb, cov khoom raug tso rau ntawm lub hlwb. Qhov no ua tiav nrog Cov Ntaub Ntawv tab, hauv cov ntaub ntawv xaiv tau cov ntaub ntawv. Peb xaiv tias tsuas muaj kev txhawb nqa cov zauv ntawm cov ntaub ntawv ntawm -180 thiab 180, uas yog qhov siab tshaj plaws uas txhawb qhov ntev. Thiab tom qab ntawd cov lus yuam kev qhia tias cov ntaub ntawv tsis raug tso cai. Tus thawj ntawm latitudes, nws yog qhia ntawm -90 thiab 90.
• Yuav kom xaiv tau qhov hemisphere nyob rau hauv lengths, uas yog nyob rau hauv kem G, lub cell tej yam kev mob, uas yog hais tias tus tswj yog tsis zoo lub W ntawv nyeem yog sau, yog tias zoo ntawv nyeem yog muab tso rau E.

Qhov no yog ua nrog mis   =YES(G37<0,”W”,”E”)

• Nyob rau tib txoj kev nrog cov latitudes uas muaj nyob hauv kab H, yog tias lub koom haum tsis pom zoo, tsab ntawv S yog sau, yog tias tus N yog zoo.

Cov mis yuav   =YES(H37<0,”N”,”Y”)

• Yuav kom tshem cov degrees, tus nqi siv yog siv thiab tus naj npawb yog truncated nrog pes tsawg decimals = ABS (TSHUM TAU (G37,0)) nyob rau hauv no txoj kev, ib-87.452140 yuav ua 87
• Yuav rho tawm cov feeb, tus nqi qub yog txiav los ntawm qhov muaj nqis truncated, yog li tsuas yog cov lej muaj nyob (0.452140) thiab tus nqi tau muab khoo nrog 60, uas yog tag nrho cov feeb ntawm ib qib. Nws yog truncated rau pes tsawg qhov chaw decimal thiab yog li nws tau txais tias hauv 0.452140 muaj 27 feeb = LUV ((ABS (G37) -J37) * 60,0)
• Yuav kom txais cov vib nas this, cov zauv (0.452140) yog khoo los ntawm 3600, uas yog tus naj npawb ntawm vib nas this (60 × 60), thiab peb rho qhov peb tau rho tawm ua ntej, uas yog feeb (27) sib npaug lub sij hawm 60. Tom qab ntawd ib qho sib npaug yog siv, nrog siv tus xov tooj ntawm qhov chaw uas muaj pes tsawg tus zauv yog kom nws tuaj yeem hloov kho mus saj Yog li, muaj 7.704 vib nas this.   =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
• Yuav ua kom haum cov lus taw qhia, cov lus teev tso rau hauv cov ntaub ntawv, yog tias lub hlwb tsuas yog theej mus rau AutoCAD hais kom ua kab =CONCATENATE(“_point “,ROUND(S37,2),”,”,”,ROUND(T37,2)).  Zoo sib xws, qhov hais kom ua lub npe =CONCATENATE(“_pline “,ROUND(S37,2),”,”,ROUND(T37,2)).  Muab sib dhos ua kom siv li chains uas ntev dhau lawm.

Nyob rau hauv cov qauv ntawv muaj qee cov tswv yim rau kev ua txhaum kawg nkaus no.

Los ntawm no koj tuaj yeem download tau lub qauv, them nrog Credit card los yog Paypal.