Kos ib tug polygon nrog cov lus qhia thiab deb ntawm Excel rau Microstation

Ob peb xyoos dhau los kuv tau luam tawm ib tsab xov xwm qhia tau tias yuav ua li cas rau concatenate cov ntaub ntawv hauv Excel tsim ib tug polygonal nrog AutoCAD, tsis tas yuav tsum tau ua tag nrho cov txheej txheem:

@distance

Lwm hnub peb tau nyob hauv chav AutoCAD ib tug neeg nug kuv yog tias qhov ntawd tuaj yeem ua tiav nrog kab Microsation kab. Cov lus teb yog YOG, koj tsuas yog yuav tsum to taub tias Microstation's Keyin tsis zoo li AutoCAD cov kab hais kom ua. Cia peb pom yuav ua li cas nws tuaj yeem tsim, hauv dhau peb kawm me ntsis khoom siv me me hauv qhov program no:

Lub thawv ntawm sab xis yog ib qho piv txwv ntawm kev sib tw raws li cov bearings thiab kev ncua deb nrog cov qauv hauv qab no.

Nrog Microstation koj tuaj yeem kos qhov no raws li kuv tau piav ua ntej, nrog cov cuab kev tsis zoo -thiab ib qho ntawm AutoCAD-, tias nws yog tsho yuav tsum sau ib los ntawm ib tug, tseem ua yuam kev thiab txawm tsis resetting tus yav dhau los chav kawm.

Qhov tshij, txoj kev sib koom tes yog tib yam nkaus dab tsi kuv piav nrog AutoCAD, koj tsuas muaj to taub ib yam dab tsi uas Microstation sib txawv.

Cov keyin tsis tau tsim los ntawm kev ua cov kab lus hauv cov kab ntawv tab sis rau hu cov lus txib nrog kev tawm tsam, yog li nws tsuas yog txhawb 56 tus cim. Tsis tas li ntawd, nws yuav tsum tau siv lub semicolon (;) siv los cais cov kev txiav txim vim tias, tsis zoo li AutoCAD, uas los ntawm cov Basic programming logic, nws coj lub Clipper logic nrog dab tsi Microstation tau ua thaum muaj nws tseem hu ua Kev Tshaj Tawm.

Muab qhov no, qhov yooj yim tshaj yog hu qhov kev txiav txim los ntawm cov ntawv sau nrog @ hais kom ua, uas kuv xav tias tsawg heev paub tab sis twg yog tus txheej txheem uas Microstation ib txwm siv los ua cov ntawv xaj. Xws li cov cov ntsiab lus ntshuam los ntawm ib daim ntawv teev txt nws 's tus mdl uas ua li no.

Siv cov ntawv Excel uas kuv tau ua yav dhau los ua los qhia txog kev hloov li cas los ntawm txoj kab thiab kev mus rau qhov chaw, Kuv yuav qhia seb nws yuav ua li cas rau Microstation:

Concatenate cov ntsiab lus.

Yam dab tsi uas peb xav tau yog thaum kawg, tias Qhov tseem ceeb kawg yuav:

qhov chaw taw tes ;xy =374037.736,1580735.145;

Qhov chaw taw tes yog qhov taw tes taw qhia, suav nrog qhov chaw, semicolon yog qhia lwm qhov kev txiav txim, tus xy = yog qhov kev txiav txim nkag mus rau hauv cov chaw tswj hwm thiab ob lub chaw sib xyaw xiav thiab ntsuab yog cov ntsiab lus paub. Ntawm kawg hais qhia txog xim kab ntsig tshiab los qhia a nkag mus los sis cov lus txib tshiab.

Yog li ces, piv txwv tias yog lub hlwb ntawm kuv cov paj laum nyob hauv U7 thiab V7 rau concatenate yuav:

=CONCATENATE("qhov chaw taw tes ;”,”xy =",U7, ",",V7, ";")

Ua li no, kuv tsuas luam cov ntsiab lus ntawm kem AA rau hauv cov ntaub ntawv txt, uas kuv yuav hu punchpoints2.txtCov. Kuv hais kom lawv muab nws ncaj qha rau C yog li txoj kev tsis nyuaj.

Hauv qhov no, Kuv tabtom tso nws rau hauv kuv cov ntaub ntawv, txoj kev yuav: C: \ Cov neeg siv \ Neeg siv \ Cov ntaub ntawv \ pf-points2.txt

los coj nws, peb qhib cov lus txib kab qhov rai (tseem ceeb hauv), qhov no yog ua los ntawm Cov Kev Siv> tus yawm sij hauv thiab ces nkag mus rau qhov kev txiav txim:

@C: \ Cov neeg siv \ Neeg \ Cov ntaub ntawv \ punchpoints2.txt

Peb ua Sau, thiab nyob ntawd koj muaj nws, cov ntsiab lus raug kos hauv lawv qhov kev txiav txim. Nws yog qhov yooj yim kom muaj cov kab tuab tuab rau lawv tau ua kom pom.

Concatenate cov kab.

Rau qhov no, txoj haujlwm zoo sib xws, qhov kev hais kom ua peb yuav tsum tau coj qhov chaw kabTsis tas li ntawd xwb, peb qhia tau hais tias txoj kab muaj qhov chaw ntawm keeb kwm thiab lub ntsiab lus ntawm qhov chaw.

qhov chaw kab ;xy =374032.234,1580716.255;xy =374037.736,1580735.145;

=CONCATENATE("qhov chaw kab ;”,”xy =“,U6,”,”,”,”,”,”,”,”xy =“,U7,”,”,”,V7,”;”)

Peb theej thiab muab tshuaj txhuam rau cov ntawv txt, txuag thiab khiav dua

@C: \ Cov neeg siv \ Neeg \ Cov ntaub ntawv \ punchpoints2.txt

Thiab muaj lawv muaj nws:

Thiab qhov kom zoo dua, yog qhov tsim lub npov ntawm cov kabmob thiab kev mus tsuas yog yuav tsum tau ua Copy hauv Excel, thiab muab tshuaj txhuam hauv Microstation. Nrog muab tshuaj txhuam tshwj xeeb koj tuaj yeem xaiv los ua tus duab, ib qho txuas los yog txuas rau pob ntawv tawm

Ua kom tiav cov tshooj, Kuv tabtom npaj cov qauv ntaub ntawv hauv Excel, nyob rau hauv uas tsuas yog qhov chaw ntawm keeb kwm, kev qhia thiab ncua mus yuav tsum tau hloov thiab template yuav ua tau rau ib tug iguana nrog ntau tshaj ib nrab phaus ntawm tav.  Kuj ntawm no piv txwv txt.

Nws yuav tsum muaj cov cim qhia rau lub download, uas koj tuaj yeem ua nrog Credit card los yog Paypal.