Gadzira bhokisi rekutakura uye marefu kubva kuhutano hweUTM

Iyi chinyorwa chiri kutarisana naGeorge, weParaguay anotiita isu Mubvunzo unotevera:

Chinhu chinofadza kukwazisa ... nguva yadarika yekutsvaga kuti ndanga ndauya pasina chikonzero pawebhusaiti yako uye ndakawana ichinakidza, zvese zviri mukati uye nenzira inonakidza yekutaura sainzi yako .. Ndinoda kubvunza iwe, kana iwe uchiziva chero script, kana chero chimiro Excel yekundibatsira kuita zvinotevera: Ndakagadziridza muCAD a polygon pamwe nemakona ayo akacherechedza zvakanyatsozivikanwa, uye neUminiti dzavo dzinoenderana. Ndinogona Export zvakakwana TXT kuverenga excel.Mi mubvunzo: kuziva UTM Data 1 ... N pfungwa, zvinokwanisika kuwana mashoko mwaka, mirayiridzo uye madaro kureva kuti kubva mashoko I zvinopa? kuti 1 pfungwa ane X ... Y ..., uye achiziva kuti 2 pfungwa ane X ... Y ...; UNOGONA KUTI NDIDZIDZIDZA DISTANCE DZINOVANYA NAVANHU VEMWEYO? kuitira kuti tigokwanisa kugadzirira inoenderana fomu pachako? maita basa ... zvakanakisa kubva kuParaguay!

Zvakanaka, izvo Diego anotsvaka zvinobva UTM inoratidzira gadzira chati yemafani uye madhiri ... uye apo Isita yakapera, ini ndadya hove keke, turret muhuchi uye ini ndakatora mifananidzo yakanaka ye sawdust makapeti ... heino mhinduro. Chekutanga ngatitaridzei kuti nzira yakanyanya kunaka yekuita izvi nechishandiso chakakodzera (Inogona kuva ne macro Vba of Microstationne Softdesk kana AutoCAD Civil 3D) asi nokuda kwezvinangwa zvekudzidza, uye kunzwisisa kuti muupenyu iwe unoshandisa izvo zvaunazvo, ngatione kuti tingazviita sei neExcel.

1. Gadzira mapoinzi

Diego anotiudza kuti ane nzira yekutumira mapoinzi kune txt faira, kuvhura neExcel, saka kwandiri ndichaita kuburikidza neMicrostation. Nekuti ini ndoda kutumira iyo data kuExcel, ini ndichaisa mapoinzi pane yega vertex. Kuti zviite kuti zvionekwe, ini ndachinja ukobvu hwemutsara, uye zvakakosha kuti unzwisise kuti Microstation ichavatumira kune iyo txt faira mune marongero avakagadzirwa, saka zvakafanira kuti vagadzire zvichiteerana.

Kuti uvatumire kuExcel, chishandiso che "export coordinates" chinoshandiswa, ndinogadzira "fenzi" inovhara mapoinzi ese uye ndinogadzirisa iyo data:

• Ndinopa zita re txt faira se test444.txt
• Ndakaratidza kuti murairo unondifarira ndeye XYZ
• Maumbirwo emayunitsi kubva ku“master units” ari mumamita
• Ini ndinoratidza kuti ini ndinongoda zvidimbu zviviri
• Zvadaro comma separator uye nhamba kubva ku1

Nekudzvanya bhatani re "fenzi" uye nekudzvanya pachiratidziro, sisitimu yakagadzira iyo txt faira uye yakagadzira nhamba yeimwe neimwe yemapoinzi, kubva pa1 kusvika 36.

2. Vhura tafura kubva kune Excel

Kuti uzarure faira iyi kubva kuExcel, enda ku "faira / vhura" uye sarudza rudzi rwefaira "text file, .prn .csv .txt" Zvadaro, mupaneti inooneka, sarudza kuti zvinyorwa zvinoparadzaniswa nemakoma. Pakupedzisira faira rakavhurwa nemakoramu matatu, mune yekutanga nhamba dzemapoinzi, mune yechipiri X coordinate uye yechitatu y coordinate.

3. Calculate Distance

Ngatidzokerei kumitemo yekutanga ye trigonometry kutanga. Rangarira kuti isu tiri kutsvaga chinhambwe uye kona.

a = musiyano mune iyo Y inoronga (yakatorwa nekutora x2 - x1), mutsetse Mb = kusiyanisa neX inoratidzira (inotorwa nekubvisa y2 - y1), mugwaro Lc = hypotenuse iyo ichava iyo midzi yekukomba ye b mraba pamwe yakaenzana, mumutsara P uye ino ichava kukosha kwemahara.

4. Course calculation

Iye zvino, nokuda kwechidzidzo chatinofanira kuita maverengi akawanda; asi vose vanobva kumakona pakati pechiteshi uye chinotevera. Kuyera kwekona. Ngatiyeukei kuti iyo cosine yemakona yakaenzana nekuparadzanisa b pakati pe c, kana delta x pakati pemuganhu wakaverengwa sehupotenuse.

Saka zvinoitwa chete muExcel kupatsanura chikamu L nekoramu P. Isu tinoitawo kuverenga kweiyo sine, ichave iri yekuparadzanisa iyo Delta Y neiyo hypotenuse (M neP). Zvino for kuverenga iyo angle, tinongoshandisa cosin inoshandiswa kune iyo koromo inenge iine uye sekuti Excel inoshandisa mahara, inowedzera kukosha kwa180 uye inoiparadzanisa pakati PI; chimiro chaizotarisa seichi: = ACOS (chinyorwa R) * 180 / PI ().

Iye zvino kuverenga iyo Kumabvazuva / Kumadokero Isu tinopa mamiriro: kana cosine iri positive, nyora E, kana iyo cosine isiri iyo, nyora W. Mushonga unotaridzika seizvi: =SI(R2 <0,"W","E") ... iri mukoramu T Kuverengera Kumucheto / South kumabvazuva, tinogovera mamiriro akafanana neapfuura, asi ane sine; kureva kuti, kana sine iri positive, nyora N, kana iri negative, nyora S uye fomula yacho ichaita seizvi: =SI(R2<0,”W”,”E”)… iri muchikamu U

Iye zvino ngatirangarirei kuti iyo yakambofungidzirwa kona yakabva kune yakatwasuka, kumabvazuva uye izvo zvatinoda zvine chekuita nekuchamhembe kana kumaodzanyemba. Saka mune iyo NW ne SW quadrants tinotora madigiri makumi mapfumbamwe, saka zvatinoita kugadzira mamiriro ekuti kana cosine isina kunaka, tinobvisa makumi mapfumbamwe uye muNE neSE quadrants tinotora makumi mapfumbamwe kubvisa kona ... muchikamu V

Chikamu Col V chinoratidza kona, asi nemadhigiramu. Kuti tishandure madimikira kuita madhigirii, maminetsi nemasekondi, zvatinoita kuichengeta nenzvimbo zero zero, sezvazviri muchikamu W. To kuverenga maminitsi, tinobvisa madhigirii akazara kubvisa madhiri akapfupfudzika uye kuwedzeredza nemakumi matanhatu. Tobva tadzitora nenzvimbo dzedhisimali sezvazvinoonekwa mukoramu Y. Kana ma seconds, maminiti anobviswa kubvisa maminetsi akachekwa, uye kuwedzerwa nemakumi matanhatu. Pakupedzisira, masekonzi akakwenenzverwa kunzvimbo mbiri dzemadhora ... chenjera, kana marongero eUTM akashandiswa anga asina nzvimbo dzinopfuura mbiri, kukosha kwemasekondi hakuzove chaizvo chaizvo, saka zvingave zvirinani kuvasiira kune desimali.

5. Kusika kwetafura yemitemo uye kure

Nguva yemwaka.

Nokuda kweizvi ndashandisa fomula ye concatenate, saka ndinowedzera sero rine nhamba 1, ipapo nzvimbo hyphen nzvimbo, uyezve sero ine nhamba 2; saka ndine chimiro chezviteshi "1 - 2"

Mharaunda.  Izvi zvinouya kubva munharaunda isina pfungwa.

Dzidzo.  Izvi zvinongoda kuunza kukosha kwakatarwa mumatombo akaverengwa kare, uye kuti sero kuwedzera chidimbu chechidimbu, maminiti kana yechipiri inogadzirwa munzvimbo yechisera sekuratidzwa mumufananidzo. Kuwedzerwa ini ndakawedzera korona yekucherechedza, nokuti mu topographic nyanzvi inowanzodiwa. Kubva pano unogona kukopa faira mu format dwg, muchimiro DGN, the Excel file uye faira txt.

Saka izvozvo heino faira iri muExcel iyo yaunogadzira nayo yemusoro uye yematafura tafura kubva kune akateedzana UTM marongero. Kuti uwedzere mapoinzi, unogona kuteedzera makoramu nekuaisa, zviri nani nekuti nenzira iyi unovimbisa mafomula, uchitsvaga kuremekedza mutsara wekutanga newokupedzisira. Iwe unofanirwa zvakare kuteedzera iyo data kubva kune yekutanga poindi kusvika kumagumo kwekutanga, kuitira kuti chiteshi chekupedzisira chiverengerwe zvakanaka.

Pano unogona kutora template kuti ugadzire bhokisi rekutakura uye marefu kubva kuhutano hweUTM.

Inoda mupiro wekufananidzira wekuburitsa, waunogona kuita nawo PayPal kana kadhi rechikwereti.

Icho chinomiririra kana mumwe achifunga nezvekubatsira kwaanoita uye nyore nyore kwaanogona kuwana.