Dweba i-polygon ngamabherethi namabanga ukusuka ku-Excel kuya ku-Microstation

Eminyakeni embalwa eyedlule ngashicilele isihloko esabonisa indlela yokwazisa idatha ku-Excel kuya ukwakha i-polygonal nge-AutoCAD, ngaphandle kokwenza yonke inqubo:

@distance

Ngolunye usuku besisesifundweni se-AutoCAD othile wangibuza ukuthi lokho kungenziwa yini ngomugqa womyalo weMicrosation. Impendulo ithi YEBO, kufanele uqonde nje ukuthi i-Microstation's Keyin ayifani nolayini womyalo we-AutoCAD. Ake sibone ukuthi ingakhiwa kanjani, ngokudlulayo sifunda izinto ezincane ezisetshenziswe kancane kulolu hlelo:

Ibhokisi elingakwesokudla liyisibonelo sokunqamula okusekelwe kumabheringi namabanga anesakhiwo esilandelayo.

Nge-microstation ungadonsela lokhu njengoba ngichazile ngaphambili, ngengozi ecacile-futhi okufanayo kwe-AutoCAD-, ukuthi kunzima ukuloba ngamunye, kungenzeka ukuthi wenze amaphutha ngisho noma ungabe usuqala kabusha inkambo yangaphambilini.

Yebo, inqubo yokuncintisana ifana nje lokho engikuchazile nge-AutoCAD, kufanele uqonde okuthile okuthi i-Microstation ihluke.

I-keyin ayakhelwanga ngokususelwa ekwenzeni imiyalo kulayini wombhalo kepha ekubizeni imiyalo enokuma kwento, ngakho-ke isekela izinhlamvu ezingama-56 kuphela. Ngokwengeziwe, kudinga ukuthi kusetshenziswe i-semicolon (;) ukwehlukanisa ama-oda ngoba, ngokungafani ne-AutoCAD, evela kumqondo wohlelo oluyisisekelo, iletha umqondo weClipper nalokho okwenziwa yiMicrostation lapho kwakusabizwa ngokuthi i-Ustation.

Ngokunikezwe lokhu, indlela elula ukubiza ama-oda kusuka kufayela lombhalo ngomyalo we- @, engicabanga ukuthi bambalwa kakhulu abawaziyo kepha okuyinqubo iMicrostation ebilokhu iyisebenzisa ukucubungula ama-batch oda. Kufaka phakathi i- ngenisa amaphuzu avela kuhlu lwe-txt yi-mdl okwenza lokhu.

Ngisebenzisa i-Excel sheet engangiyisebenzele ngaphambili ukufundisa indlela yokuguqula kusuka ekuthwaleni nasezindaweni ezihamba phambili ukuya ezixhumanisini, ngizobonisa ukuthi izokwenzela kanjani i-Microstation:

Qondanisa amaphuzu.

Okuthandayo kithi ekugcineni, ukuthi Ngena ngemvume ukugcina kube:

indawo yendawo ;xy =374037.736,1580735.145;

Indawo yiphuzu umyalo wephuzu, kufaka phakathi isikhala, i-semicolon ukukhombisa enye i-oda, i-xy = i-oda lokufaka izixhumanisi futhi izixhumanisi ezimbili eziluhlaza okwesibhakabhaka nokuluhlaza yizindawo ezaziwayo. Ekugcineni isemikholoni entsha ekhombisa ifayili le- faka noma uthathe umyalo omusha.

Ngakho-ke, ngicabanga ukuthi amangqamuzana enentshisekelo yami ase-U7 ne-V7 ukuze abonisane nabo kungaba:

=XHUMANA("indawo yendawo ;”,”xy ="U7,”,V7";")

Ngale ndlela, ngikopisha kuphela okuqukethwe kwekholomu AA kufayili ye-txt, engizoyibiza punchpoints2.txt. Ngiphakamisa ukuthi bakubeke ngqo ku-C ngakho-ke indlela ayinzima kangako.

Kulolu cala, ngikufaka emadokhumenti ami, indlela izoba: C: \ Abasebenzisi \ Umsebenzisi \ Amadokhumenti \ pf-amaphuzu2.txt

ukuyikhipha, senza i-window yomyalo we-command isebenze (ukhiye ku), lokhu kwenziwa kusukela Izinsiza> key in bese ufaka i-oda:

@C: \ Users \ User \ Documents \ punchpoints2.txt

Singena, futhi lapho unawo, amaphuzu akhonjwe ngokulandelana kwawo. Kuyinto elula ukuba nobukhulu bomugqa obukhulu ukuze ziboniswe.

Qondanisa imigqa.

Kulokhu, ukusebenza kufana, umyalo okufanele siwusebenze uwukuthi umugqa wendawoNgaphezu kwalokho, sibonisa ukuthi umugqa unendawo yokuvela futhi iphuzu lokuya kuyo.

umugqa wendawo ;xy =I-374032.234,1580716.255;xy =I-374037.736,1580735.145;

=XHUMANA("umugqa wendawo ;”,”xy =“,U6,””,,V6,”;”,”xy =“,U7,””,V7,”;”)

Sikopisha futhi sinamathisele kufayela le-txt, sigcine bese siqalisa futhi

@C: \ Users \ User \ Documents \ punchpoints2.txt

Futhi lapho banakho:

Futhi inzuzo eyengeziwe, ukuthi ukwakha ibhokisi lamabherethi namabanga kudinga ukwenza Kopisha ku-Excel, futhi udla ku Microstation. Ngokunamathisela okukhethekile ungakhetha phakathi kokuba isithombe, ispredishithi esishumekiwe noma esixhunyiwe

Ukuqedela lesi sihloko, Ngilungiselela ifayela lesibonelo ku-Excel, lapho kuphela iphuzu lokuvela, izikhombisi-ndlela kanye namabanga okude kufanele ashintshwe futhi ithempulethi ingaba usizo kunoma i-iguana engaphezu kwesigamu sezinamba zezimbambo.  Futhi lapha isibonelo txt.

Kudinga umnikelo ongokomfanekiso wokulanda, ongakwenza ngawo Ikhadi lesikweletu noma i-Paypal.