Rubuta polygon a Microstation daga Excel

Yin amfani da wannan samfuri, zaku iya samo polygonal a cikin Microstation, daga jerin bearings da nisa a Excel, ko jerin jerin x, y, z.

Case 1: Lissafin Rumbos da Rarraba

Sannan muna da wannan tebur na bayanan da ke fitowa daga filin:

A cikin ginshiƙan farko kuna da tashoshi, to nesa zuwa wurare goma na ƙarshe kuma ƙarshe ɗaukar. Muna fatan zana wannan polygon, ta amfani da Microstation.

Ga wadanda suka yi shi tare da kayan aiki na AccuDraw zasu fahimci cewa mahaukaci ne, ba kawai saboda kayan aiki yana da 'ya'yanta su zama taga mai iyo amma kuma saboda dole ne ka shigar da kowanne ɗayan haɗin; kuskure a cikin wani adadi, ƙetare ɗaya ko ba sake saita umarnin zai tilasta sake sake shigar da bayanai har sai tabbatar cewa muna da mummunan aiki ba.

A wannan yanayin za mu yi ta ta amfani da samfurin Excel, wanda ke ba ka damar shigar da bayanai a cikin akwati, sannan kuma ka tsara zane-zane na polygonal akan Microstation.

Sa'a Distance Flights
1 - 2      29.53 N 21 ° 57 ' 15.04 » W
2 - 3      34.30 N 9 ° 20 ' 18.51 » W
3 - 4      19.67 N 16 ° 14 ' 20.41 » E
4 - 5      38.05 N 10 ° 59 ' 2.09 » E
5 - 6      52.80 S 89 ° 16 ' 30.23 » E
6 - 7      18.70 S 81 ° 43 ' 5.54 » E
7 - 8      15.18 N 46 ° 12 ' 23.79 » E
8 - 9      24.34 S 83 ° 34 ' 23.62 » E
9 - 10      17.87 S 76 ° 6 ' 49.78 » E
10 - 11      33.64 N 78 ° 38 ' 19.03 » E
11 - 12      17.05 N 88 ° 22 ' 24.25 » E
12 - 13      29.98 S 85 ° 34 ' 34.94 » E
36 - 37      21.79 N 69 ° 17 ' 35.24 » W

Ta yaya Template Works:

fitar da microstation

Ta hanyar samfurin an shigar:

  • Bayanai na tashoshin, idan sun kasance a jere, kawai rubuta lambar farko kuma samfurin ya cika a ginshiƙai E da G.
  • Tsakanin gefe na H,
  • Taken labarai ko hanya. Ba lallai ba ne a shigar da alamomin don digiri, mintina ko sakan kamar yadda tsarin kwayar halitta ya riga ya ƙunsa.

Samfurin yana da zaɓi don zaɓar nau'in adadi nawa da muke tsammanin za a ƙaddara; Ka tuna cewa idan mun yi amfani da nau'i biyu kawai kawai, polygon ba zai rufe ba saboda zai rasa daidaituwa a cikin adadi na biyu.

Hakanan samfurin yana ba ku damar zaɓar haɗin kai don batun farko, don cimma burin ƙasa. Bari mu tuna cewa waɗannan ayyukan a cikin wannan tsarin yawanci ana tashe su tare da ka'idodi na yau da kullun, don haka aƙalla ɗayan ɗayan maki yana da haɗin UTM.

fitar da microstation

Ana danna maballin zane, kuma a sakamakon haka a Microstation za mu sami madauren polygon, kamar yadda aka nuna a bidiyo.

Case 2: Lissafin haɗin UTM

Samfurin yana aiki idan abin da muke da shi shine jerin abubuwan daidaitawa a cikin suna Sunan, Gabas, Arewa, Hawan Sama. Hakanan teburin da aka nuna a ƙasa.

Point X Y Z
1   418,034.12   1590,646.87 514.25
2   418,028.56   1590,680.72 526.11
33   418,107.63   1590,609.31 446.07
34   418,090.65   1590,610.45 420.49
35   418,065.54   1590,611.78 343.22
36   418,045.16   1590,619.48 335.91

 

fitar da microstation

Yana aiki ga duka shari'un. Za a zana gefen, yana ƙara bayanin ko lamba azaman rubutu a kowane kusurwa. Zaiyi amfani da girman rubutu, launi, nau'in rubutu da daidaitawa wanda ake amfani dashi a Microstation. Don haka idan bai zama mana ba, za a sake ƙirƙira shi ne kawai.

Samfurin yana samuwa don saukewa don farashi maras muhimmanci. Kuma muna faɗi na alama ne, saboda waɗanda ke yin rayuwa ta hanyar yin amfani da Microstation, ko kuma adana yanayin ƙasa, zasu adana aiki da yawa.

Samo da Samfuri tare da Paypal ko Katin Bashi.


Koyi yadda ake yin wannan da sauran samfura a cikin Excel-CAD-GIS hanya mai cuta.


 

8 Amsawa zuwa "Zana polygonal a cikin Microstation daga Excel"

  1. hola
    Idan kana son ƙara ƙarin tashoshin,
    Sanya layuka da kuke buƙata, misali saka tsakanin layuka 10 da 11
    Bayan haka kwafa ɗayan cikakkun layuka ta taɓa shi daga kan na gefen hagu sannan sai a liƙa a cikin layuka da kuka saka da kyau ciki har da layin 10 da 11 kuma hakan yana sa tsarin ya tafi kuma chakin ya ci gaba.

    Idan kuna da shakku, kuma a ra'ayin cewa kun sayi samfuri zaku iya neman tallafi daga editor@geofumadas.com

    gaisuwa

  2. Ina kwana da safe samfirin bai bari na ƙara ƙarin tashoshin ba, za ku iya gaya mani yadda ake ƙara su don Allah, kuma idan kuna iya ba da cikakkun bayanai

  3. Ina kwana ina samin samfirinku don yin polygonal amma ba bari na ƙara ƙarin layuka ba za ku iya gaya mani yadda ake ƙara ƙarin tashoshin don Allah

  4. Ina da kayan aiki na 6 mobil wanda nake so in sauke wasu matakai, amma na haɗa shi zuwa kwamfutarka wanda ke da windows 7 kuma baya gane shi

  5. Ku aiko min da kyakkyawan fayil, tare da bayanan da kuka kara. Don tabbatar da abin da ya sa ba ya aiki a gare ku.

    edita (a) geofumadas. tare da

  6. Ina da samfurin, da aka rubuta tashar, hanya, nesa, da kuma haɗin farko don hanya, kada ku zana shi, ba ku fahimta ba, x.

Barin amsa

Your email address ba za a buga.

Wannan shafin yana amfani da Akismet don rage spam. Koyi yadda aka sarrafa bayanan bayaninka.