Microstation: Ngenisa Excel izixhumanisi kanye izichasiselo

Icala: Nginayo idatha ephakanyiswe nge-Promark 100 GPS, futhi ngisebenzisa uhlelo lokusebenza lwe-GNSS lokuphinda ngemuva kokusebenza ukuthi lawo madivayisi anakho, ngingathumela ulwazi ku-Excel.

Amakholomu afakwe ophuzi yizimpumalanga, izixhumanisi ezisenyakatho kanye nesichasiselo sabo; konke okuwukuphela kolwazi oluhlobene nokuthunyelwa kokuthunyelwe.

Inkinga: Ngifuna ukuthi abasebenzisi ngezinguqulo zabo ze-Microstation ezinokungenisa idatha.

Izindlela ze-Slug zokwenza

Uma ungenisa izixhumanisi nge-Microstation ne umyalo okwenzelwe lokhu, amaphuzu kuphela eza, hhayi amalebula. Ngendlela ende, umsebenzisi ubebangenisa bevela kwi-CivilCAD ekwenza ngokumangazayo, bese kusuka kwaMicrostation kwavulwa futhi kwaguqulwa kwaba yi-dgn okuyifomethi lapho basebenza khona usuku nosuku. Ngakho… nakuba ngicishe ngahamba, Ngiyabonga ukuthi ungibuze isiphakamiso sokuthi ngikwenze kanjani; yize ngijulile ngicabanga ukuthi bayakwenza ukufakazela ukuthi imiyalo ayigqwali. Kuyinqubo engiyichazile ngaphambili nge-AutoCAD.

Indlela yokuqhathanisa izixhumanisi nge-Excel

Ukwenza i-vba kungaba kuhle, kodwa njengokwezifiso zelinye ilanga esiphethe ngalo: I-Excel kufanele ibe nekhono kunokukhiqiza ispredishithi, lapha inqubo ehlanganisa imiyalo ye-Microstation (ukhiye) nemiyalo ye-Excel (i-concatenate)

Ukudala iphuzu nge-Microstation kwenziwa ngomyalo othi "iphoyinti lendawo", futhi uma ufuna ukuyibeka endaweni ethile yokuxhumanisa, sebenzisa "xy=", njalo usebenzisa isihlukanisi somyalo esiyi-semicolon (;). Ngakho, ngokufaka umyalo indawo yendawo; xy = 388218.835,1566315.816 Ngifanele ukudweba iphuzu nje kulokho kuhlanganiswa.

Endabeni ye-Excel, umyalo we-concatenate usebenza kanjena: concatenate command, open parentheses, bese ukhombisa konke okufanele kuhlanganiswe, futhi ekugcineni uvale obakaki. Ngiyichaza ngendlela ebukekayo, kepha ayinzima lapho iqondwa futhi yenziwa okungenani kanye:

Qondanisa umyalo = QAPHELA sivula abazali ( khona-ke umyalelo we-commando ungumbhalo, nge-semicolon yayo ehlukanisa umyalo "indawo yendawo;" ke u-comma ukuhlukanisa ucingo olulandelayo , ke umyalo ngokucaphuno njengoba kunombhalo "xy=" i-comma ukukhombisa ucingo olusha , futhi lapha sikhetha iseli elifanele  C3 ke u-comma ukukhombisa ucingo olusha , kanye ne-comma kumaphuzu okuhlukaniswa kwezixhumanisi "," i-comma ukukhombisa uchungechunge olulandelayo , iseli eliqukethe ukuxhumanisa kwasenyakatho ne-semicolon yokugcina I-D3,";" bese sivala abakaki )

Kuzobukeka kanje:

=XHUMANA("indawo yendawo ;", "xy ="C3, ","D3, ";")

Uma lokhu sekuqedile, sisanda ukukopisha ifomula kumakholomu alandelayo, kanje:

indawo yendawo; xy = 388218.835,1566315.816;
indawo yendawo; xy = 388219.911,1566320.28;
indawo yendawo; xy = 388216.28,1566320.868;
indawo yendawo; xy = 388215.36,1566316.473;
indawo yendawo; xy = 388211.706,1566317.245;
indawo yendawo; xy = 388212.713,1566321.593;

Indlela yokuyithumela ku-Microstation

Leyo mibhalo ingakhokhishwa iphinde ifakwe ngqo kumugqa womyalo (ukhiye wosizo) futhi ubone ukuthi amaphuzu adonsela.

Kodwa ngiyakwazi ukuyikopisha kufayili ye-txt noma i-csv engingayishayela njengesikripthi.

Isibonelo, ifayela libizwa phobiafreedom.txt, futhi igcinwe ku-C; ngakho ukubiza ukuthi uthayipha ukhiye  @c: \ sweetpots.txt. Igama akufanele libe nezikhala, futhi kungcono ukulibeka endleleni elula.

Ungangenisa kanjani izichasiselo

Isebenza ngendlela efanayo, umahluko wokuthi umyalo awukho kodwa isithonjana sombhalo:  isithonjana sombhalo wesendaweni

I-Concatenamos ifomu elilinganayo, isithonjana sombhalo wendawo yokulayela, iseli equkethe isichazamazwi, siqondisa lapho umbhalo uzobekwa khona:

=CONCATENATE(“isithonjana sombhalo wendawo ;”,B3,”;”,”xy=”,C3,”,,D3,”;”)

Futhi-ke kufanele sihlale kanje.

isithonjana sombhalo; 10; xy = 388218.835,1566315.816;
isithonjana sombhalo; 11; xy = 388219.911,1566320.28;
isithonjana sombhalo; 12; xy = 388216.28,1566320.868;
isithonjana sombhalo; 13; xy = 388215.36,1566316.473;
isithonjana sombhalo; 14; xy = 388211.706,1566317.245;
isithonjana sombhalo; 15; xy = 388212.713,1566321.593;

Futhi lapho banakho:

Ukwenza i-travers, nawe uzokwenza okufanayo, kepha ngomugqa wendawo yomyalo, ngokuqapha ukuthi amaphuzu kufanele abe nokulandelana; okungekho kulokhu. Kungaba ulayini wendawo yomyalo, qala ukuxhumanisa, ukuxhumanisa indawo oya kuyo ...

Impela kunezinye izindlela zokwenza, kanye nezinhlelo zemithombo evulekile ezikwenza ngokumangalisayo. Kepha ukuzivocavoca umzimba kuyasiza ekuqondiseni ingqondo yami futhi kimi, ukuvimbela imiyalo yami ekugqonyeni.