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:

@ nesa

Kwanakin baya muna cikin kwas ɗin AutoCAD wani ya tambaye ni ko za a iya yin hakan ta layin umarnin Microsation. Amsar ita ce EE, kawai ya kamata ku fahimci cewa Microstation's Keyin ba daidai yake da layin umarnin AutoCAD ba. Bari mu ga yadda za'a iya gina shi, yayin wucewa muna koyon ƙananan abubuwa da ba a yi amfani da su sosai a wannan shirin ba:

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 bisa yin umarni a kan layukan rubutu amma don kiran umarni tare da fuskantar abu, don haka kawai yana tallafawa haruffa 56. Bugu da ƙari, yana buƙatar a yi amfani da semicolon (;) don rarrabe umarni saboda, ba kamar AutoCAD ba, wanda ya fito ne daga ƙirar shirye-shiryen Asali, yana kawo ƙirar Clipper da abin da aka yi Microstation a can lokacin an kira shi Ustation.

Idan aka ba da wannan, hanya mafi sauƙi ita ce kiran umarni daga fayil ɗin rubutu tare da umarnin @, wanda ina tsammanin ƙalilan ne suka sani amma wanne hanya Microstation ya saba amfani dashi don aiwatar da umarnin rukuni. Ciki har da shigo da maki daga jerin 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 shine wurin umarni, gami da sarari, semicolon shine nuna wani tsari, xy = shine umarnin don shigar da daidaito kuma mahaɗan biyu shuɗi da kore sune sanannun maki. A karshen sabon semicolon don nuna a 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 ba da shawarar su sanya shi kai tsaye a cikin C don haka hanyar ba ta 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 Ayyuka> maɓalli a ciki sa'an nan kuma shigar da tsari:

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

Mun shiga, kuma a can kuna da shi, maki da aka zana a cikin tsari. Ya dace a sami kaurin layi mai kauri don a nuna su.

 

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,»; »)

Muna kwafa da liƙa kan fayil ɗin txt, adanawa da 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 musamman zaka iya zaɓar tsakanin zama hoto, sakawa ko maƙunsar bayanan rubutu

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 gudummawa ta alama don saukarwa, wanda zaku iya yi da shi Katin bashi ko Paypal.

14 Amsawa zuwa "Zana polygon tare da bearings da nisa daga Excel zuwa Microstation"

  1. Shin Trimble da PowerDraft za a iya fitar da su / shigo da su a nan?

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

  3. 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.

  4. 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?

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

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

  7. Ta yaya zan iya yin hakan domin aƙalla ku sami wasu keɓewa, ku turo min ta imel, akwai mutanen da suke wahalar samunsu ta hanyar biya t .na gode kuma ina mai matuƙar godiya …… ​​jaime

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

  9. HELLO YADDA DA COMBIERTO CIKIN MAGANAR CIKIN SAURARA ZUWA KYAUTA AUTOCAD don YI MAGANIN AUTOCAD MIO NE 2007 THANKS

  10. kuma a cikin autocad zaka iya cikin mdl ………… ..

Barin amsa

Your email address ba za a buga.

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