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 hannun dama misali ne na ratsawa bisa ɗagawa da nisa tare da tsari mai zuwa.

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.

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:

= CIN GINDI("wuri wuri ;”,xy ="U7",",V7,";)

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.

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.

= CIN GINDI("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:

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

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