Yenza ndlela ibhokisi kunye nomgama ukusuka uqondisa UTM

Esi sithuba sisabela ku-Diego, waseParaguay osenzayo umbuzo olandelayo:

Kwakuluvuyo ukuba ambulise ... ixesha elithile eyadlulayo kufuna ababeze ngempazamo angafuni website yakho ndaze ndafumanisa ukuba umnandi kakhulu, bobabini ngenxa esonwabisa wabaleka njengoko indlela yokunxibelelana ciencia.Yo wakho ndingathanda ukubuza ukuba wazi ezinye script, okanye isakhelo Excel ukunceda ndiyenze oku kulandelayo: Ndiye ndatshekisha kwi-CAD i-polygon kunye namanqaku ayo okuchongwa ngokuchanekileyo, kwaye kunye ne-UTM idibanisa. Andikwazi ngokupheleleyo kumazwe angaphandle ukuba txt ukufunda excel.Mi umbuzo: besazi data 1 UTM ... N amanqaku, unako ukufumana idata amaxesha, izalathiso imigama okt ukususela inkcazelo mna eyam? indawo 1 iye X ... Y ..., esazi nokwazi ukuba ingongoma 2 uye X ... Y ...; INGABE UNINGIXELISA UKUQALA OKUQHELEKILEYO KANYE NENKOSI YENYE? ukuze ukwazi ukwenza iphepha elihambelanayo ngokuzenzekelayo, sibonga ... ngokubhekiselele kwiParaguay!

Ewe, oko uGeorge ofuna ukuba kuvela UTM izilungiso ukujikelezisa imiyalelo ibhokisi kunye nemigama ... kwaye njengoko egqibile Ista, xa ndiye kudliwe ikeyiki intlanzi, fritters ebusini sazeka Iifoto ezilungileyo iikhaphethi esisesweni ... nantsi impendulo. Okokuqala, makhe siqaphele ukuba indlela efanelekileyo yokwenza oku i sixhobo esifanelekileyo (sinokuba nayo Vba macro of Microstationnge Softdesk okanye i-AutoCAD Civil 3D) kodwa ngenjongo yokufunda, nokuqonda ukuba ebomini kufuneka usebenzise oko unakho, makhe sibone indlela yokwenza ngayo nge-Excel.

1. Ukuvelisa amaphuzu

U-Diego usitshela ukuba unendlela yokuthumela iifayile kwifayile ye-txt, ukuyivula nge-Excel, ngoko kwimeko yam ndiya kuyenza nge-Microstation. Ngenxa yokuba ndifuna ukuthumela idatha kwi-Excel, ndiya kufaka amanqaku kwi-vertex nganye. Ukuze kubonakale, nditshintshile ububanzi bomgca, kwaye kubalulekile ukuqonda ukuba i-Microstation iya kubathumela kwifayile ye-txt ngendlela eyadalwa ngayo, ngoko kuyimfuneko ukuyidala ngokulandelelana.

i-microstation ibonisa ukugqwesa

Ukuwathumela e-Excel, kusetyenziswa isixhobo "sokuhambisa izixhobo", ndenza "uthango" oluquka onke amanqaku kwaye ndiqwalasele idatha:

  • Ndibabela igama lefayile ye-txt njenge-test444.txt
  • Ndibonisa ukuba umyalelo ondibathandayo ngu-XYZ
  • Ifomathi yeeyunithi ezivela "kwiiyunithi eziphambili" ezikwiimitha
  • Ndibonisa ukuba ndifuna kuphela izibini ezimbini
  • Emva koko umdibanisi ngama-commas kunye nenani le-1

Ngokucofa kwiqhosha "ucingo" kwaye ucofe kwiscreen, le nkqubo yenza ifayile ye-txt kwaye yenza inani kwinqaku ngalinye, ukusuka kwi-1 ukuya kwi-36.

i-microstation ibonisa i-txt

2 Vula itafile kwi-Exceli-txt exel microstation

Ukuvula le fayile kwi-Excel, "ifayile / vula" yenziwa kwaye uhlobo lweefayile "yifayile yokubhaliweyo, .prn .csv .txt" Kukhethwa kwiiphaneli ezibonakalayo, kukhethwe ukuba isicatshulwa sahlulwe ngamakomityi. Okokugqibela ifayile ivulwe ngeekholamu ezintathu, kwindawo yokuqala kukho amanani manqaku, elesibini ulungelelwaniso lwe-X kwaye kolwesithathu ulungelelwaniso.

3 Bala umgamai-trigonometry

Masibuyele kwimimiselo ebalulekileyo ye-trigonometry kuqala. Khumbula ukuba sifuna umgama kunye nekota.

umahluko likwajongana = Y (isuswa ngokuthabatha x2 - x1) e Mb = kwikholam umahluko alungelelanisa X (isuswa ngokuthabatha y2 - y1) e LC = kwikholam hypotenuse ke ingcambu ye square b ngaphezulu isikwere kwikholam P kunye nale iya kuba yinani lomgama.

hypotenuse trigonometry

4 Ukubala kwekhosi

Ngoku, ngenxa yeklasi sifuna ukwenza amanani amaninzi; kodwa zonke zivela kwinqanaba eliphakathi kwesitishi kunye nomlandelelwano.sine cosine ngakumbi Ukubalwa kwekota. Khumbula ukuba i cosine kwinqanaba lilingana nokuhlukanisa phakathi kwe-c, oko kukuthi i-delta x phakathi komgama obalwa njengesiqu.

Ngoko ke kwenziwa kuphela kwi-Excel ngokuhlula ikholomu L phakathi kwekholamu P. Senza ukubala sine, eya kulwahlula i-Delta Y phakathi kwe-hypotenuse (M phakathi kweP). Ngoku balala i-angle, sisebenzisa kuphela i-cosine engenanto kwikholam equlethekileyo kwaye ekubeni i-Excel isebenzisa i-radians, sandisa ixabiso nge-180 kwaye sihlula PI; ifom ibonakala ngathi: = ACOS (ikholomu R) * 180 / PI ().

Ngoku ukubala Ukuqhelaniswa kweMpuma / yeNtshona Sinika imeko: ukuba i-cosine inethemba, bhala u-E, ukuba ngaba i-cosine leyo ayinayo, bhala u-W. Ifomula ikhangeleka ngolu hlobo: = EWE (R2 <0, 2 W », EE) ... kwikholam T Ukubala Ukhokelo lwaseNyakatho / lwaseMzantsi, sabela imeko efana nale yangaphambili, kodwa ngesifuba; Oko kukuthi, ukuba i-sine is positive, bhala u-N, ukuba ayilunganga, bhala u-S kwaye ifomula ingalolu hlobo: = EWE (R2 <0, »W», E E)… kwikholamu U

khumbula kaloku ukuba savumelana ebalwa tyaba, empumalanga yaye yintoni esimele lumalunga ngasentla okanye ngasezantsi. Ngoko xa NW kunye SW zezine nesahlulo ukuthatha degrees 90, ngoko into esiyenzayo ukudala imeko ukuba i cosine lelikhabayo, uthabathe 90 kunye NE zezine kwaye wenza Khupha 90 thabatha ikona thina ... kuba kwikholam V

ekhosini

Ikholomu V ibonisa i-angle, kodwa kwifomati yedesimali. Ukuguqula ama-decimals ukuya kumadigri, imizuzu kunye nemizuzwana into esiyenzayo iyakunqumla nge-zero decimals, njengoko ikholamu. balala imizuzu, sithatha iidridi ezigqibeleleyo ngaphantsi kweedricity truncated kwaye sandisa nge60. Emva koko sibagxotha ngezitifiketi zero njengoko kubonakala kwikholam Y. Xa kwenzeka imizuzwana, shenxisa imizuzu ukususa imizuzu emithathu, uphinde wande nge60. Ekugqibeleni ke imizuzwana ukuba thumbanails wokugqibela ezimbini ... iliso ukuba uququzelelo UTM ezazisetyenziswa kungekho iindawo ngaphezu ezimbini wokugqibela, akayi kuba ichanekile kakhulu ixabiso eliphela kwishumi le yokugqibela, ngoko kuya kufuneka kakhulu ekhohlo ukuya lokugqibela.

5 Ukudala izikhokelo kunye nemitha yeetafile

Amaxesha

izikhokelo kunye nemidaNgale nto ndisebenzise ifomula eyenziwe ngomda, ngoko ke ndongeza iseli enenombolo 1, emva koko isithuba se-hyphen space, emva koko iseli enenombolo 2; ngale ndlela ndishiywe ngendlela yezikhululo ze- «1 - 2»

Imida. Ezi zivela kwikholam ye hypotenuse.imizuzu kunye nemizuzwana

Ikhosi. Oku kufuna kuphela ukuzisa inani elibaliweyo kwiikholomu ezibalwe ngaphambili, kwaye iseli ukuba yonge isibonakaliso sesimbo, imzuzu okanye yesibini yenziwe kwiipropati zeseli njengoko kuboniswe kumfanekiso. Ukongezelela ndongeze iikholomu yokuqwalasela, kuba uphando lwezobuqhetseba lufunekayo. Ukusuka apha ungalanda ifayile kwifomathi Dwg, kwifomathi Dgn, ifayile ye-Excel kunye nefayili txt.

Ngoko ke Nantsi ifayile kwi-Excel apho ungayenza ikhosi yeebherethi kunye nemida ukusuka kwizikhokelo ze-UTM ezilandeleleneyo. Ukongeza amaphuzu, unako ukukopa iikholomu uze uzifake, kungcono ngendlela oqinisekisa ngayo amafomula, ufuna ukuhlonipha umqolo wokuqala nookugqibela. Kumele ukopishe idatha yedatha yokuqala ekupheleni kowokuqala, ukwenzela ukuba isiteshini sokugqibela sibalwa ngokunjalo.

Apha ungayilanda ithemplate ukwenza ibhokisi yeebherethi kunye nemida ukusuka kwii-UTM.

u-Rumbos DownloadsIfuna inqaku lokufuzisela ukukhuphela, ongayenza nalo PayPal okanye ikhadi lekhredithi.

Kufanekisela ukuba umntu ucinga ngento ebonelela ngayo kunye nokukhululeka okungafumaneka kuwo.


Funda ukuba ungayenza njani le kunye nezinye itemplate kwi Ikhosi yokukopela ye-Excel-CAD-GIS.


Iimpendulo ze-41 "Yakha ikhosi yeebherethi kunye nemida ukusuka kuma-UTM"

  1. Kukho sisixhobo ekuthiwa Calculo_Topográfico.exe, wena automates inkqubo baguqukele UTM ilungelelanise lolwandiso, kubandakanywa engile, iibheringi kunye nemigama, kwakunye nezinye izixhobo eziluncedo ezifana ukufumana isiphoso mhlawumbi le saveyi, mhlawumbi ngasempumalanga okanye engile amabanga, linciphisa yepholigoni indawo wafuna alungise kwicala elinye okanye engile, ezilungele kwamalungu omzimba, yaye ngokukodwa wenze umzobo e AutoCAD, elikuvumela ukuba khuphelo no colo (okanye) Pilot (s) yepolygons nge ukuba u sebenza; kwakhona athumele kwelinye i data ukuba iifomati izikhululo zizonke, ukuba ukulayisha (okanye download) ingcaciso.

  2. Umbuzo: Ngenxa yokuba i-deltas ibabala ukusuka phezulu kwaye ayikho enye indlela?

  3. I-template ebalulekileyo, ndenze i-macro ngqo kwi-Microstation eyenza ngokufanayo kum kwaye iyakuthumela kwifayile ye-txt.

  4. Ndiyaneliseke ngokwenene kwaye ngelo xesha ndixolisa kakhulu ngenxa yokuba ndingakwazi ukukhuphela isicelo, kuba andinakukwenza igalelo lomfuziselo, kuba andiyikuvelisa okwangoku? kum umsebenzi wam nje njengomcebisi kwaye ndinomdla kuloo nkcazelo ukunyusa nokuqinisa umsebenzi wam, ukuba unokwenza unomdla wokuwuthumela kum ndiya kukubulela kakhulu
    I-Samana Dominican Republic

  5. Hlola i-imeyile yakho, ngogaxekile.
    Ukukhishwa kwekhonkco kungahamba khona.

    Phendula nge quote

  6. Ukugqwesa, kubaluleke kakhulu !! kodwa ndenza nje igalelo kwaye ithemplate ayikhutshwe ..
    Phendula nge quote

  7. Molo mva kwemini uza kuba nenqaku okanye imizekelo yokubala ubalo lwesikali? sisicelo kunye nokubaluleka, imibuliso evela eMexico

  8. Ngokugqithiseleyo, kwesi sikhokelo ndikwazi ukucacisa iphepha eligqithisileyo elibala izikhombisi, siyabonga ngokukwabelana ngolwazi oluxabisekileyo.

    Izibingelelo zaseNicaragua

  9. Sawubona, unjani? I kakuhle ithemba, ndifuna ukubona ukuba enokusinceda ungazifunela oh uzobe imigama phakathi kweendawo ezimbini kunye nezifundo zabo zilungelelanise oh kunokuba kunye kwisibanzi nakwiside kuba ungenza ntoni na coordendas utm UX na ukuba akukho ngxaki kodwa mna andikwazi ukuyenza Olu luhlobo oluthile lwezilungeleliso abazibonisayo kumaphu amaphepha e-Google.
    Ukubulisa .. Ndiyathemba impendulo yakho ukuba kunokwenzeka ..

  10. Bahlobo, xa nifunda imibuzo malunga nokubalwa kwe-topographic, ukuveliswa "kwetafile" zonxibelelaniso kunye neelebheli zokuhamba kunye nokuhamba umgama e-Autocad, ndiyacebisa ukusebenzisa isixhobo seCIVILCAD, esaphuhliswa eMexico, le modyuli yenza i-autocad ibe sisixhobo sokubala okusephezulu, iiprofayili , icandelo, i-contours, njl njl.
    Ngokuphathelele kwimibuzo yakho ye-UTM yefulethi, zonke iinkqubo zenkqubo ye-GPS (izisombululo ze-GNSS zentengiso, izisombululo ze-Ashtech ze-Promark 2, I-Ofisi ye-Spectra Precision Survey ye-GPS Epoch 10 kunye ne-50, njl. Njl. Ukulungelelanisa, konke abakudingayo kungokunxibelelana kube linye okanye ngaphezulu kwi-UTM kunye nakwimithombo yolungelelwaniso "olucwebe" (oko kukuthi, izihlanganisi abanqwenela ukuzisebenzisa nesitishi sonke) kwaye iinkqubo ziya kubala amanqaku kunye nolwazi oluyimfuneko bayayidinga, funda nje iimanyuwali ezihambelana nezixhobo zabo kwaye ucwangcise kakuhle ukuqokelelwa kwedatha. Imibuliso evela kwisiXeko saseMexico. I-imeyile yam yile gilberto1@sitg.com.mx.

  11. Kuya kunyanzeleka ukuba kwenziwe uhlengahlengiso etafileni, kodwa ingasebenza kakuhle. Ukuba usithumela umzekelo singazama.

  12. Igalelo elihle Sele ndibekile itafile yam. Ndingathanda ukwazi ukuba ingandinceda na ukufumana ii-angles zedatha nedatha esele ikho kule tafile inye. Enkosi !!

  13. UNjingalwazi, kunye nenkqubo yokujika?
    Ukususela kwisikhokelo ukuya kwiinkcukacha zendawo?
    Imuchas Gracias

  14. Unyanisile, kuyenzeka ukuba bandwidth ye geofumadas.com, apho iifayile kunye nemifanekiso kule bhloko isingathwe khona, yagqithiswa. Kuya kufuneka ndinyuse ububanzi, uzame kwakhona kamva.

  15. Kuthiwani, zama ukukhuphela ifayela eligqithisileyo kodwa undiphawule ongekhoyo, ndinokukunceda ngale nto.

    mbuliso

  16. Kufuneka ube yinto ecacileyo kwizinto ezibhekiselele kuzo.

    Ngaba usebenze ukusho i-geographic kunye neesigidi, imizuzu, imizuzwana? Ukuze usebenzise kwesi sixhobo.

    Ukuba awuzange ubhekisele kuyo, makhe sibone ukuba usinika umzekelo ukukunceda.

  17. Ndine-UTM idibanisa njengoko ndenzayo ukuze ndibencitshise kubambiswano lwezolimo.

  18. Into ebaluleke kakhulu kukuba ubale i-AutoCAD, into okhangelayo ayikho kuphela ukubala indawo kodwa ukuqinisekisa ukuvalwa, mhlawumbi kukho itemplate eyenza oko ufuna kodwa andiyazi.

  19. Lephepha lihle kakhulu. Ndingathanda ukwazi ukubala (kwi-Excel) indawo ephuma kwi-polygon eyenziwa ekulayisheni amacandelo kunye neebherethi ezifunyenweyo kwintsimi. Ndingu-draftsman kwaye ndisebenzisa inkqubo ye-Autocad, ndidibanisa neetafile ze-Excel.
    Ndiyayixabisa kakhulu umdla wakho ekuphenduleni umbuzo wam
    Izibingelelo ze-Asuncion del Paraguay
    Mabel

  20. Ndicinga ukuba uyayiphazamisa inkqubo, ukuba awunazo ii-utm iziququzeleli, akufuneki uzijonge. Kuya kufuneka utolike oko ukutshoyo umzobo wakho wovavanyo, kukho inqaku lokuqala, ukuba alitsho ukuba lilungelelanise indawo, ngoko ke jonga ukuba kukho ikhosi kunye nomgama oya kwinqanaba elilandelayo.

  21. Ifayile ayikho loo nto, kukubala iseshati yekhosi ngokusekelwe kumaphupha kunye nezilungiso

  22. I-Maestro Alvarez, eli fayile libala i-UTM izikhokelo ukusuka kwicandelo eliphambili eliphakanyiswe ngezithuthi kunye nenqanaba elimangalisayo kodwa andisayi kuqonda

  23. Khangela umhlobo wasePeru ungithumelele itemplate kunye nombuzo kodwa andiqondi ukuba i-UTM ifakwe ekuqaleni ekuqaleni kwePI nganye, njengoko ifayile ifakile

  24. Molo Jcp, ndiyaqonda ukuba unombindi ophakathi, kunye nezikhululo kunye nesikhululo ngasinye kukho imbonakalo esekunene nakwesobunxele. Ndicinga ukuba eyona nto ifanelekileyo kukuba ungazami ukwenza ulungelelwaniso lwe-utm, kodwa wenze izangqa ukusuka kwiziko, ubeka inqaku kwindawo yokuhlangana yesangqa kunye nomgca.

    oku kuya kwenza ukuba ube nomnye ofana nalo msebenzi

    http://geofumadas.com/construir-curvas-de-nivel-usando-autocad/

    Emva koko, ukongeza iindawo eziphakamileyo, qwa lasela ifom apho apho ungena khona unganika ukuphakama.

  25. Dear uMnu Alvarez ndisebenzisa civil 3d 2009, iindawo zokungena UTM format CSV kodwa ngoku kufuneka ukuba kuguqulwe amacandelo emnqamlezweni yayisakhiwa ehambayo kunye nenqanaba UTM e Excel, ndiya kuba axis ecacisiweyo phezulu kuye yokuqala yam indawo 0 000 + GPS geotagging ... ukuze ukubala amanqaku njengoko PI of nesikhondo yam kunye namacandelo ukuba UTM

    Ndivela eHonduras

    jcpescotosb@hotmail.com

  26. Enyanisweni, sele ndinezilungelelaniso kwi-utm, kodwa ndifuna ukunciphisa i-plane ye-topographic ukuze ndisebenze ensimini

  27. Khangela, andizange ndisebenzise loo Phawula kodwa ndiyabona ukuba ibonakala ngathi i-Mobile Mapper isoloko ivela eThales.

    Kule nto ndiyenzile oku:

    1 Cinezela iqhosha «MENU»
    2 Khetha «Iiyunithi zemephu»
    3 Khetha «Inkqubo yokuLungelelanisa» kwaye ukhethe i-UTM
    4 Ukhetha «i-Datum» kwaye apha ibonisa i-WGS84

  28. Bancinci, bhinqa i-2, kwisixeko saseMexico indawo ye14, ndiya kuxabisa naluphi na ulwazi onokunceda.

  29. ... ahem, ahem ...

    Yaye yintoni na i-gps, brand and model abayisebenzisayo?
    Kukuphi ilizwe kunye nendawo ohlala kuyo?

  30. sangeet Dear, ngaphezu kwabo bonke umbuliso, ndiye ndaphawula ukuba ulwazi lwakho topography software kusasele, ndibe nako ukunceda, inkampani Ndisebenzela, ukulawula GPS, kwaye ndifuna ukwazi ukuba ulungise uququzelelo UTM of ezihambelanayo nezobhalo O Planas, nolawulo entsimini, baye wakhangela inkcazelo eninzi ngayo aze kakhulu impendulo yakho.

  31. U-Pablo, uvavanyo lwakho luchanekile, ndenzile ukulungiswa kokubhala, kukho ikholomu L phakathi kwekholomu P

    enye ingxaki oyibekayo, ndicinga ukuba ulahlekelwe ukugqiba izimvo ukuze ukwazi ukuhlalutya

  32. Ndandilandela imiyalelo yesinyathelo ngamanyathelo. Ndiye ndaqonda kakuhle, kodwa ngokwenza oko andikwazi ukuphumeza iziphumo ezilungileyo.
    Ubonakala sengathi u-Mae wenza into engalunganga. Kwakhona kwindlela yokucwangciswa kweeyunithi ze-Autocad yinxalenye yeengalo kunye nesalathiso andiyicaca kakuhle.
    Ndifuna ukucebisa ukuba uphonononge kwakhona ii-angles ndicinga ukuba kukho impazamo, apho isithi "ukwahlula ikholomu N ngekholamu P" ndicinga ukuba ikholamu L yikholamu uP.
    Enye impazamo ebhaliweyo ibonakala ekubalweni kweNyakatho / yaseMzantsi, i-formula ithi: kuya kuba ngathi: = EYE (R2

  33. Ukuba uthetha icebo elilinganiswe kwindawo apho indawo yatshintsha ... ayiyi kukukhonza.

    Ukuba uthetha ukuba nolu lungelelwaniso kwenye indawo ye-utm, akukho lutshintsho kuba ucinga ukuba uthetha malunga nobubanzi obulinganayo, ke iilungelelanisi ziyafana

  34. Sawubona,

    Ndiyayithanda le ndlela yokwenza kakuhle, ndinombuzo

    Isebenza njani xa kukho utshintsho lwesiguqu?

    Gracias

    juan

  35. mmm, thumela umbhalo othetha ngawo kum imeyile, ukuyihlolisisa.

    Ndiya kubona oko kukho

  36. ngqiqweni! Ngoku uye ku-100%, ndiyisebenzise kwaye yinyaniso! Ndiyabulela kakhulu umva, kuye kwaba luncedo kum.

    Umbuzo malunga nawo, kuba sikwiinkqubo ezenzekelayo. Sebenzisa i-AutoCAD, ukuba ne-polygon yolwazi olugwetyiweyo, ene-UTM vertices eyaziwayo, endiyifunayo luphawu lwamacandelo, ukwenzela ukuba xa ndicofa kuwo ndiwanike ilebheli yawo ehambelana nayo, umzekelo: 176.35

  37. ukulungele, sele ndilayishe uguqulelo lwe-2 yefayile ebalaseleyo. Isizathu yayikukuba kwi-quadrants NE kunye ne-SE ye-90 kwafuneka ikhutshiwe.

    Zama kwaye undixelele nantoni na.

    Kufuneka ucace, ukuba i-decimals ethe xaxa isetyenziselwa ukulungiswa kwe-UTM, iya kutshintsha i-decimals yomzuzwana.

  38. mmm, ulungile, ndicinga ukuba ndiyazi indlela yokuyicombulula

    Ndiya kukujonga xa ndibuyela ekhaya

  39. unjingalwazi oyintanda, okokuqala kukubonga ngokuphendula kwakho ngokukhawuleza, ndiyifumana ngexesha!
    Ndiphawule ukuba yandinceda kakhulu, bendiyivavanya, nangona ndingathanda ukuveza ukuthandabuza / ukucebisa / inkxalabo: Ndibala umgama kakuhle, ngoku ikona indinika umphelelisi, umzekelo endaweni yokuba ngu88d13'13 », iyandinika I1d21'47 »!!! Kuya kufuneka uhlengahlengiso oluncinci kwaye senziwe! Enkosi kwakhona ngoncedo lwakho!

Shiya impendulo

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.