GPS / BoatsMicrostation-Bentley

Microstation: Shigo da ƙayyadaddun bayanai da annotations daga Excel

Shari'ar: Ina da bayanan da aka ambata tare da Promark 100 GPS, da kuma amfani da GNSS aikace-aikace na bayanan cewa waɗannan na'urorin sun ba ni damar aika da bayanin zuwa Excel.

Gumomin da aka nuna a rawaya sune haɗin gabas, arewa da kuma sunayensu; Sauran ne kawai bayanin da ya shafi aikin.

Matsala: Ina buƙatar masu amfani da nauyin Microstation wanda ke da shigo da bayanai.

Ƙarƙashin mahimmancin ƙaddamarwa microstation

Slimy hanyoyi na yin shi

Idan ka shigo da matsayi tare da Microstation tare da umurnin sanya wannan, maki kawai suka zo, ba alamun ba. Ta hanyar dogon lokaci, wani mai amfani yana shigo dasu daga CivilCAD wanda yayi hakan da kyau, sannan daga Microstation aka buɗe shi kuma aka canza shi zuwa dgn wanda shine tsarin da suke aiki a kowace rana. Don haka… ko da yake na kusan tafi, Ina godiya da ka tambayeni wata shawara yadda zan yi; kodayake a cikin zurfin ina tsammanin suna yin hakan ne don tabbatar da cewa umarnin basu da tsatsa. Tsarin kawai ne na bayyana a baya tare da AutoCAD.

Yadda za a hada da Excel

Vba zai yi wani manufa, amma kamar yadda ya saba wata rana da abin da muka gama: Excel ya zama mafi m fiye da yin albashi Tables, nan da hanya hada Microstation dokokin (key a) tare da Excel dokokin (zaman masu alaƙa)

Ƙirƙirar ma'ana tare da Microstation an yi tare da umarnin "wuri", kuma idan kana so ka sanya shi a wani ƙayyadaddun daidaitawa, yi amfani da "xy =", ko da yaushe ta amfani da mai rarraba umarni wanda shine semicolon (;). Don haka, ta hanyar shigar da umarni matsayi; xy = 388218.835,1566315.816 ya kamata ka zana wata ma'ana a cikin wannan haɗin.

A game da Excel, umarnin haɗaɗɗiya yana aiki kamar haka: umarnin haɗawa, buɗe maɓuɓɓuka, sannan nuna duk abin da za a haɗu, kuma a ƙarshe rufe iyayensu. Na bayyana shi a cikin hanya, amma ba rikitarwa bane lokacin da aka fahimta kuma aka aikata sau ɗaya kawai:

Umurnin Concatenate = SANTAWA muna buɗe parentheses ( to, umarnin commando shine rubutun, tare da alamarta wanda ke raba umarnin "Lokaci;" sa'an nan kuma wakafi don rarrabe layi na gaba , to, umarni a rubuce kamar yadda yake rubutu "xy=" da takaddama don nuna sabon kirtani , kuma a nan za mu zaɓi tantanin salula  C3 sa'an nan kuma comma ya nuna sabon kirtani , da kuma takaddama a rubuce don rabuwa da haɗin kai "," da takaddama don nuna layi na gaba , sel mai ɗauke da haɗin arewa da semicolon na ƙarshe D3,";" sai mu rufe baka )

Zai yi kama da wannan:

= CIN GINDI("wuri wuri ;", "xy ="C3, ","D3, ";")

Da zarar an gama wannan, za mu kwafi wannan tsari zuwa ginshiƙai masu zuwa, kamar haka:

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

 

Yadda zaka aika shi zuwa Microstation

Wannan rubutu za a iya kwafe shi kuma a ba shi kai tsaye zuwa layin umarni (maɓallin aikace-aikace a cikin) kuma ga cewa an ɗora maki.

Ƙarƙashin mahimmancin ƙaddamarwa microstation

Amma kuma zan iya kwafe shi cikin fayil txt ko csv wanda zan iya kira a matsayin rubutun.

Alal misali, an kira fayil din glowpoints.txt, kuma an adana shi cikin C; don haka don kira shi ku rubuta maɓallin a cikin  @:: glowpoints.txt. Kada sunan ya sami sarari, kuma ya fi dacewa a sanya shi cikin hanya mai sauƙi.

Ana shigo da annotations

Yana aiki kamar yadda yake, tare da bambanci cewa umarni ba ma'ana bane amma alamar rubutu:  sanya rubutu icon

Concatenamos na daidai nau'i, saitin rubutu wurin rubutu, cell wanda ya ƙunshi bayani, daidaitawa inda za a sanya rubutu:

= CONCATENATE (" icon rubutu wuri;", B3,";", "xy=", C3,", D3,";")

Kuma sai mu zauna a wannan hanya.

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

Kuma a can suna da shi:

Ƙarƙashin mahimmancin ƙaddamarwa microstation

Don ƙirƙirar ƙetaren, za ku yi daidai da wancan, amma tare da layin wurin umarnin, tare da taka tsantsan cewa maki dole ne ya kasance yana da jeri; wanda ba wannan ba ne. Zai zama layin wurin umarni, fara daidaitawa, daidaitawa makoma ...

Tabbas akwai wasu hanyoyi don yin shi, da shirye-shiryen buɗe tushen da suke yin abin al'ajabi. Amma motsa jiki yana da amfani don daidaita tunani na kuma a cikin harkata, hana umarni na yin tsatsa.

Golgi Alvarez

Marubuci, mai bincike, kwararre a cikin Samfuran Gudanar da Ƙasa. Ya halarci Conceptualization da aiwatar da model kamar: National System of Property Administration SINAP a Honduras, Model na Management of hadin gwiwa Municipalities a Honduras, Integrated Model na Cadastre Management - Registry a Nicaragua, System of Administration na Territory SAT a Colombia. . Editan shafin ilimin Geofumadas tun daga 2007 kuma mahaliccin Kwalejin AulaGEO wanda ya haɗa da darussa sama da 100 akan GIS - CAD - BIM - batutuwan Twins na Dijital.

shafi Articles

6 Comments

  1. Ba ni da shirin a hannunka, amma dole ne ka sanya umarnin cikakke, kamar RAZA RUKAN RUKAN RASHIYA.

    Sa'a mai kyau.

  2. Sannu abokina, kyakkyawan bayani, Na sami damar wartsakewa har ma da warware matsalolin da nake tsammanin ba za a iya yin su ba a cikin microstation, Ina da tambaya wacce ke da alaƙa da batun da kuka tattauna a sama, ta yaya zan shigo da da'irar maimakon nufi a matsayin rijiyar tunani? Na aiwatar da duk matakan da aka ambata a sama ta amfani da ma'auni: = CONCATENAR ("place Circle;…..) sannan aka kai zuwa .txt daga baya kuma na ɗauki maɓalli a matsayin @d:\circulo.txt, amma ban kasance ba. iya zayyana su, za ku iya taimaka mini a wannan batun?

    Na gode.

  3. Barka dai, ina kwana, ina son sanin ko kuna da darasi ko bayanin kula kan yadda ake yin post-processing don tallata gps 200 a cikin shirin mafita na GNSS? Nayi kwanaki ina kokarin amma ban samu ba saboda gps ya jefa min files na .csv ... ina jiran amsarku, na gode.

  4. Yayi kyau, saboda na fada muku cewa wadanda suka yi nasara basu zo wurin bitar ba kuma lokacin da na isa ina son in burge su da taimakonsu, kuma maimakon haka sun saba da wasu abubuwa, kuma na ji tsoron tambayar su kai tsaye yadda suka yi ... hehe ya gaya min Victor, muna nemanta a geofumadas ... Yana da kyau koyaushe ya goyi bayanmu saboda koyaushe ya kasance maigidana a cikin wannan, ni kuma ban yi shi azaman gwaji ba, na yi hakan ne saboda na ga cewa ba za su iya fahimtar komai ko kaɗan ba game da dawowar da ya kamata a yi tare da ƙungiyoyin soja amma da gaske duk waɗanda ke cikin bitar sun burge su ...

    wadannan suna taimaka mana wajen samar da karin haske a dubban duban abin da za a iya yi tare da PC, amma jagora yana da mahimmanci don ya iya koya musu.

    a wani ɓangare na masu fasaha YAKE ku, domin zan iya cewa ina guaoooo ne cuku.

Deja un comentario

Your email address ba za a buga. Bukata filayen suna alama da *

Komawa zuwa maɓallin kewayawa