Rubuta polygon tare da bearings da nisa daga Excel zuwa Microstation

Bayan 'yan shekarun da suka gabata, na wallafa wata kasida wadda na nuna yadda za a yi amfani da bayanai cikin Excel zuwa gina polygonal tare da AutoCAD, ba tare da yin dukan yarjejeniya ba:

@distance <kwana ...

Ranar da muka kasance a cikin AutoCAD, wani ya tambaye ni idan za a iya yin haka tare da layin umarnin Microsation. Amsar ita ce YES, dole ne ka fahimci cewa Microstation Keyin ba daidai ba ne da layin umarnin AutoCAD. Bari mu ga yadda za a iya gina shi, ta hanyar wucewa mun koya abubuwa da yawa da aka yi amfani da wannan shirin:

Akwatin da ke dama yana da misali na polygonal bisa ga kwatance da nisa.

Tsarin ƙwaƙwalwar ƙwaƙwalwa da kuma nesa

Tare da Microstation zaka iya zana wannan kamar yadda na fada a baya, tare da rashin hasara marar kyau - kuma irin wannan na AutoCAD-, cewa yana da wuyar yin rubutu daya bayan daya, yiwuwar yin kuskure kuma ba ma sake sake saiti baya ba.

Tsarin mahimmanci

To, tsari na ƙaddamarwa daidai ne kawai abin da na bayyana tare da AutoCAD, dole ne ka fahimci wani abu wanda Microstation ya bambanta.

Ba'a gina keyin ba don yin umurni a layi na rubutu amma don yin kira tare da daidaitaccen abu, don haka yana goyon bayan ainihin 56. Bugu da ƙari kuma, yana buƙatar yin amfani da tip din (;) don rarrabe dokokin, ba kamar AutoCAD ba, wanda ya zo ne daga tsarin ƙaddamarwa na Shirye-shiryen, wannan yana kawo ma'anar Clipper da abin da Microstation ya yi a lokacin an kira shi Ustation.

Idan aka ba wannan, hanyar da ta fi sauƙi, ita ce kiran umarnin daga fayil ɗin rubutu tare da umurnin @ na tsammanin ƙananan sani amma wannan ita ce hanyar da Microstation ke amfani dashi akai don aiwatar da umarni na batutuwa. Ko da fitarwa daga matakan txt yana da wani mdl wanda yake aikata wannan.

Amfani da takardar Excel Na yi aiki a baya don koyar da yadda za a sauya daga bearings da nisa zuwa hadewa, zan nuna yadda za a yi ta ƙaddara don Microstation:

Kammala mahimman bayanai.

Abinda ke damu shine ƙarshe, cewa Key a karshe zama:

wuri wuri ;xy =374037.736,1580735.145;

Matsayin wuri shi ne tsari na umarni, ciki har da sararin samaniya, alamar allon shine ya nuna wani tsari, xy = shine tsari don shigar da haɗin gwiwar da daidaitattun shuɗi biyu da kore su ne sanannun sanannun. A karshen wani sabon salo mai nuna alama shigar ko mataki zuwa sabon umarni.

Sabili da haka, suna ɗauka cewa sel na sha'awa na a cikin U7 da V7 zuwa concatenate zai zama:

= KASHI («wuri wuri »,»xy =",U7, »,»,V7, »;»)

Tsarin ƙwaƙwalwar ƙwaƙwalwa da kuma nesa

Ta wannan hanyar, Na kwafa abinda ke ciki na shafi na AA cikin fayil txt, wanda zan kira Rahotanni2.txt. Ina bayar da shawarar ku sanya shi tsaye a C don haka hanya bata da wuya.

A wannan yanayin, Ina sanya shi a cikin takardunku, hanyar za ta kasance: C: \ Masu amfani \ User \ Documents \ pf-points2.txt

don aiwatar da shi, za mu kunna layin layin umarni (key a), an yi wannan daga Abubuwan amfani> maɓallin a sa'an nan kuma shigar da tsari:

C: \ Masu amfani \ User \ Documents \ pf-points2.txt

Mun shiga, kuma a can suna da shi, abubuwan da aka tsara a cikin tsari. Yana da kyau don samun matakan launi mai haske don nunawa.

Tsarin ƙwaƙwalwar ƙwaƙwalwa da kuma nesa

Concatenate Lines.

Saboda wannan, aikin yana kama da haka, umurnin da dole ne muyi shine layin wuriBugu da kari, muna nuna cewa layin yana da asalin asali da kuma maƙasudin manufa.

layin wuri ;xy =374032.234,1580716.255.xy =374037.736,1580735.145.

= KASHI («layin wuri »,»xy =«, U6,», », V6,»; »,»xy =«, U7,», », V7,»; »)

Kwafi da manna ga fayil txt, ajiye kuma sake gudu

C: \ Masu amfani \ User \ Documents \ pf-points2.txt

Kuma a can suna da shi:

Tsarin ƙwaƙwalwar ƙwaƙwalwa da kuma nesa

Kuma ƙarin amfani, shine gina ginin bearings da nisa kawai yana bukatar yinwa Copy in Excel, kuma kuje a cikin Microstation. Tare da manna na musamman da za ka iya zaɓar tsakanin kasancewa hoton, wani ɓangaren rubutu da aka haɗa ko aka haɗa

Tsarin ƙwaƙwalwar ƙwaƙwalwa da kuma nesa

hanyoyi zuwa ƙwaƙwalwaDon kammala labarin, Ina shirya fayil ɗin misali a Excel, wanda kawai zasu canza matsayin asalin, kwatance da nisa kuma samfuri na iya zama da amfani ga kowane iguana tare da fiye da rabi na labaran haƙarƙari. Har ila yau a nan misalin txt.

Yana buƙatar taimako na musamman don saukewa, wanda zaka iya yi tare Katin bashi ko Paypal.

12 tana maida hankali ga "Zana polygon tare da bearings da nisa daga Excel zuwa Microstation"

  1. ba ya bari in yi shi, a cikin Microstation ya gaya mini umarni na shigarwa sanarwa

  2. Hi! abokai suna so su tambayi su, Ina bukatan shirin na 2015 na 6 ko kuma idan za ku iya sauƙaƙe ni zuwa intarlar.grasias.

  3. Shin wani zai iya fada mani idan samfurin ya fita ya kusantar da polygons tare da autocad, yana dace da kowane irin autocad ko ƙungiyar 3d?

  4. Ya ƙaunataccena, na karbi fayil na nema, na gode sosai !!

  5. Messrs ya nemi kudi ta Pay Pal amma ba zan iya samun hanyar barin ni in sauke fayil din Excel don microstation ba

  6. kamar yadda na yi don ku iya ba ni kariya, aika shi zuwa gare ni wasiku akwai mutane da suke da wuyar samun karbar ta ta biya ... na gode kuma ina godiya sosai ... jaime

  7. A cikin shafin saukewa na wannan shafin yanar gizon akwai takardar da ke ba ka damar zana maki daga haɗin kai a Excel

  8. BAYANYA YAKE DA COMBIERTO DA CORDENADA OF SUNIYA NA GASKIYA GA GASKIYA MEGUSTARIA YA YI YA MUTANE MIO NE 2007 YAKE KA

  9. Har ila yau, a autocad za ka iya a cikin mdl ............ ..

Deja un comentario

Your email address ba za a buga.

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