Convert decimal geographic inosvika kune zvidimbu, kuenda kuUTM uye inodha muCotCAD

Iyi template yeExcel inotanga kugadzirwa kuti ishandure nzvimbo dzenharaunda muUTM, kubva pamadhigiramu kusvika kumadhigirii, maminetsi nemasekondi. Chete chii zvinopesana ne template yatakanga tamboita, sezvinoonekwa mumuenzaniso:

Kuwedzerwa:

• Anotaura navo muketani
• Anovashandura kuhurongwa UTM, pamwe nesarudzo yekusarudza Datum
• Concatenate dot dot kuti upe pfungwa mu AutoCAD neCopi imwechete / paste
• Taurai mutemo wepa polyline kuti muve nechepa neKopa / kunyanya

Iko kushanda kwekushandura nzvimbo dzenzvimbo muUTM kunoitwa sei?

• Kugadzirisa minda yekuisa, zvivakwa zvinoiswa pane maseru. Izvi zvinoitwa neData dhata, mune sarudzo yekusimbisa data. Isu takasarudza kuti pane chete inotsigira dhata yedesimali pakati -180 na180, inova ndiyo yepamusoro inotsigira kureba. Uyezve meseji yekukanganisa inoratidza kuti iyo data haitenderwe. Muchiitiko chematanho, inoratidzwa pakati -90 ne90.
• Kusarudza hemisphere mu urefu, vari mbiru G, sero mamiriro, kuti kana rinoronga akaipa ari W rugwaro kuchinzi, kana zvakanaka rugwaro anoiswa E.

Izvi zvinoitwa neyomutambo   =HONGU(G37<0,”W”,”E”)

• Saizvozvowo ne-latitudes iri muhurukuro H, kana kurongeka kusina kunaka, nyora tsamba S, kana yakanaka N.

Chirevo chichava   =HONGU(H37<0,”N”,”Y”)

• Kuti abvise dhigirii, kukosha kwakakwana kunoshandiswa uye nhamba yacho inotarirwa kusvika kune zero = ABS (KUTANGA (G37,0)) nenzira iyi, a-87.452140 ichashandurwa ku 87
• Kuti ubvise maminetsi, iyo yekutanga kukosha inobviswa kubva kune yakatemwa kukosha, kuti zvisaririra zvisaririra (0.452140) uye kukosha ikoko kunowedzerwa ne60, inova iyo yakazara maminetsi mune degree. Iyo inotemwa kusvika zero zero nzvimbo uye nekudaro zvinowanikwa kuti mu 0.452140 pane maminetsi makumi maviri nemanomwe = TRUNC ((ABS (G37) -J37) * 60,0)
• Kuti tiwane masekondi, madhimoni (0.452140) anowedzerwa ne3600, inova nhamba yemasekondi muchidimbu (60 × 60), uye tinobvisa izvo zvatakatobvisa kare, zvinova maminetsi (27) akawedzera times 60. Ipapo kutenderedza kunoiswa, iine chirevo chesero uko huwandu hwenzvimbo dzemadhora kuitira kuti zvigadziriswe kuravira. Nekudaro, kune 7.704 masekondi.   =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
• Kuti aratidze pfungwa yacho, chirevo che_chinoshandiswa chinoshandiswa, kuitira kuti masero chete anyoreswa kumutsetse weMotokari weCotCAD =CONCATENATE(“_point “, ROUND(S37,2),”,”,ROUND(T37,2)).  Saizvozvowo, murairo wepa polyline =CONCATENATE(“_pline “, ROUND(S37,2),”,”, ROUND(T37,2)).  Kupoteredza kunoshandiswa kuitira kuti maketani asati akareba.

Mu template pane mamwe mazano ekuita chiito chekupedzisira.

Kubva pano unogona kutora template, kuripa Kadhi kadikiti kana Paypal.