Dulani mfundo, mizere ndi malemba a polygonal kuchokera ku Excel mpaka AutoCAD

Ndili ndi mndandanda wa ma coordinates mu Excel.

Mwa izi pali X coordinate, Y coordinate, komanso dzina la vertex. Zomwe ndikufuna ndikujambula mu AutoCAD. M'nkhani ino tidzagwiritsa ntchito zolemba kuchokera ku malemba osakanikirana mu Excel.

Konzani lamulo lolowetsa mfundo mu AutoCAD

Tebulo tikuonera Zithunzi, monga mmene tikuonera, chikuphatikizapo ndime otchedwa vertex, ndiye UTM amayang'anira kwa X mizati, Y.

Chinthu choyamba chimene tiyenera kuchita ndikugwirizanitsa makonzedwewo monga lamulo la AutoCAD likuyembekezera. Mwachitsanzo, kuti tijambule mfundo yomwe tikhala nayo: POINT coordinateX, coordinateY.

Choncho, zomwe titi tichite ndikuyika ndondomeko yatsopano ndi deta iyi, mwa mawonekedwe:

MFUNDO 374037.8,1580682.4
MFUNDO 374032.23,1580716.25
MFUNDO 374037.73,1580735.14
MFUNDO 374044.98,1580772.49
MFUNDO 374097.77,1580771.83
MFUNDO 374116.27,1580769.13

Kuti ndichite chonchi, ndachita zotsatirazi:

• Ndayitana selo D4 ndi dzina POINT,
• Ndapanga ndi ntchito ya concatenate, chingwe chomwe chimaphatikizapo selo la POINT, ndiye ndasiya danga pogwiritsa ntchito "", ndiye ndagwirizanitsa selo B5 ndi kuzungulira kwa manambala awiri, kenako kujambula comma yomwe ndagwiritsa ntchito "," , ndiye ndaphatikiza cell C5. Kenako ndakopera mizere yotsalayo.

Dulani mfundo mu Excel

Ndapopera zomwe zili m'kabuku D ku fayilo yolemba.

Kuti muchite izi, lembani mu bar ya SCRIPT, kenako Enter key. Izi zimabweretsa wofufuzayo ndipo ndimayang'ana fayilo yomwe ndayitanitsa geofumadas.scr. Mukasankhidwa, batani lotseguka limasindikizidwa.

Ndipo voila, apo ife tiri ndi mazithunzi omwe atsekedwa.

Ngati malowa sakuwoneka, m'pofunika kuyandikira pazokwanira zonse za zinthu. Pachifukwa ichi timalemba lamuloli kuti Zoom, kulowa, Kukula, kulowa.

Ngati ziwonetsedwe zikuwonekera siwoneke, lamulo la PTYPE likuyankhidwa, ndiye omwe amasonyezedwa mu chithunzi akusankhidwa.

Gwiritsani ntchito lamulo ku Excel ndikujambula polygon mu AutoCAD

Kujambula polygon kudzakhala lingaliro lomwelo. ndizosiyana zomwe tidzakhale ndi lamulo la PLINE, kenako ma concatenated amayang'anira ndipo pamapeto pake lamulo la CLOSE.

PLINE
374037.8,1580682.4
374032.23,1580716.25
374037.73,1580735.14
...
374111.31,1580644.84
374094.32,1580645.98
374069.21,1580647.31
374048.83,1580655.01
PAFUPI

Tidzayitana izi geofumadas2.scr, ndipo tikazichita tidzakhala ndi chithunzi cha zojambulazo. Ndinasankha mtundu wachikaso kuti ndiwone kusiyana kwake ndi mawonekedwe ofiira.

Gwiritsani ntchito lamulo ku Excel ndipo muzindikire mavoti a AutoCAD

Pomaliza, timakhala ndikutanthauzira zolemba za gawo loyamba monga mafotokozedwe pa vesi lililonse. Pachifukwa ichi, tidzasunga lamuloli motere:

TEXT JC 374037.8,1580682.4 3 0 1

Lamuloli likuimira:

• Lamulo la TEXT,
• Mkhalidwe wa malembawo, pamutu uwu ndi wolondola, ndiye chifukwa chake kalata J,
• Pakatikati mwalemba, tinasankha Center, ndicho chifukwa chake kalata C
• Mgwirizanitsi wa X, Y,
• Ndiye kukula kwa mawuwo, tasankha 3,
• Mzere wa kasinthasintha, mu nkhani iyi 0,
• Pomaliza ndime yomwe tikuyembekeza, mzere woyamba udzakhala nambala 1

Tayamba kufalikira ku maselo ena, izi zidzakhala motere:

TEXT JC 374037.8,1580682.4 3 0 1
TEXT JC 374032.23,1580716.25 3 0 2
TEXT JC 374037.73,1580735.14 3 0 3
TEXT JC 374044.98,1580772.49 3 0 3A
TEXT JC 374097.77,1580771.83 3 0 4
TEXT JC 374116.27,1580769.13 3 0 5
TEXT JC 374127.23,1580779.64 3 0 6
...

Ndinayitana fayilo ya geofumadas3.cdr 

Ndatsegula mtundu wobiriwira, kuti ndiwone kusiyana kwake. Pulogalamuyo ikangotchulidwa, timakhala ndi mawuwo kukula kwake, pakati penipeni.

Sakanizani Foni ya AutoCAD yogwiritsidwa ntchito mu chitsanzo ichi.

Nkhaniyi ikuwonetsa momwe template imamangidwira. Ngati mugwiritsa ntchito template mu Excel, yomwe idamangidwa kale kuti ingodyetsa deta, Mukhoza kugula apa.