Sakamakon daidaitattun yanki na ƙayyadaddun wuri zuwa digiri, zuwa UTM kuma zana cikin AutoCAD

Wannan samfuri na Excel an fara yin shine don canza haɗin gizan ƙasar zuwa UTM, daga tsarin goma zuwa digiri, mintuna da sakan. Kamar menene sabanin samfurin da muka yi a baya, kamar yadda aka gani a misali:

Bugu da ƙari:

• Ya ƙaddara su cikin sarkar
• Sanya su zuwa hadewa UTM, tare da zaɓi don zaɓar Datum
• Concatenate da dot umurni don ƙirƙirar maki a AutoCAD tare da guda Copy / manna
• Concatenate umarnin polyline don kusantar da hanya tare da Copy / manna

Ta yaya ake aiki da sauya haɗin haɗin ƙasa a cikin UTM:

• Don sanya yanayin shigar da filayen, ana sanya kaddarorin akan ƙwayoyin. Ana yin wannan tare da Bayanin Bayanai, a cikin zaɓin ingancin bayanan. Mun zabi cewa a can kawai suna tallafawa bayanan ƙayyadaddun tsakanin -180 da 180, wanda shine matsakaicin da ke tallafawa tsayin. Sannan sakon kuskuren yana nuna cewa ba a yarda da bayanan ba. Game da latitude, ana nuna shi tsakanin -90 da 90.
• Don zaɓar mahaɗin a cikin tsayin, wanda yake a cikin sashi na G, tantanin halitta yana kwakwalwa, idan haɗin gwaninta ya saba da rubutu W an rubuta, idan yana da tabbatacce, rubutun E.

Anyi wannan tare da tsari   =IF(G37<0,W”,E))

• Haka kuma tare da latitudes da suke a cikin H, idan haɗin kai ba daidai ba ne, an rubuta wasika S, idan N ya tabbata.

Tsarin zai zama   =YES(H37<0,N”,Y))

• Don fitar da digiri, ana amfani da cikakkiyar darajar kuma an ƙaddara adadi tare da ƙananan ƙira = ABS (TRUNK (G37,0)) ta wannan hanya, -87.452140 za ta zama 87
• Don cire mintoci, an cire asalin asalin daga ƙimar da aka yanke, saboda haka adadi kawai ya rage (0.452140) kuma wannan ƙimar ta ninka ta 60, wanda shine adadin mintuna a cikin digiri. An yanke shi zuwa wurare marasa adadi kuma ta haka ne muka sami cewa a cikin 0.452140 akwai mintuna 27 = TRUNK ((ABS (G37) -J37) * 60,0)
• Don samun dakikoki, ninka adadi (0.452140) zuwa 3600, wanda shine adadin daƙiƙa a cikin digiri (60 × 60), sa'annan ka rage abin da muka riga muka debe a baya, waɗanda sune mintuna (27) da aka ninka sau 60. Sannan a yi amfani da zagaye, tare da tantanin halitta inda yawan wurare goma yake domin a daidaita shi ya dandana. Don haka, akwai sakan 7.704.   =REDONDEAR((((ABS(G37)-J37))*3600)-(K37*60),$L$5)
• Don ƙaddamar da umarni na mahimmanci, ana amfani da layin da aka yi amfani da shi, saboda haka kawai ana yin kwafin kwayoyin zuwa layin umarnin AutoCAD. = CONCATENATE ("_point ", ROUND (S37,2),",", ZAGAYA (T37,2)).  Hakazalika, umurnin polyline = CONCATENATE ("_pline ", ROUND (S37,2),",", ROUND (T37,2)).  Ana amfani da zagaye domin kada a yi sarƙoƙi tsawo.

A cikin samfurin akwai matakai don aiwatar da wannan aikin karshe.

Daga nan zaka iya sauke samfurin, biya tare da Katin bashi ko Paypal.