Dweba ipholigoni e Microstation kusuka Excel
Ukusebenzisa le template, ungadonsa i-polygonal ku-Microstation, ohlwini lwamabherethi nama-distances ku-Excel, noma uhlu lwezixhumanisi x, y, z.
Icala le-1: Uhlu Lokhokho Nezindawo
Ake sithi sinalo leli tafula lwedatha kusuka ensimini:
Kumakholomu okuqala uneziteshi, khona-ke ibanga eliya ezindaweni ezimbili zamadesimali futhi ekugcineni ukuthwala. Sifisa ukudweba le polygon, sisebenzisa iMicrostation.
Kulabo abakwenzile ngethuluzi le-AccuDraw bazoqonda ukuthi liyaphambuka, hhayi kuphela ngoba ithuluzi linamasu alo njengamawindi ahambayo kodwa futhi ngoba zonke izixhumanisi kufanele zifakwe; iphutha ngenombolo, ukushiya eyodwa noma ukusetha kabusha umyalo kungaphoqelela ukufaka kabusha idatha ukuqinisekisa ukuthi yini esiyiphutha.
Kulokhu sizokwenza ngokusebenzisa isifanekiso se-Excel, esikuvumela ukuba ufake idatha ebhokisini, bese uhlela umdwebo we-polygonal kwi-Microstation.
| Isiteshi | Ibanga | I-Rumbo | ||||||
| 1 | - | 2 | 29.53 | N | I-21 ° | 57 ' | 15.04 " | W |
| 2 | - | 3 | 34.30 | N | I-9 ° | 20 ' | 18.51 " | W |
| 3 | - | 4 | 19.67 | N | I-16 ° | 14 ' | 20.41 " | E |
| 4 | - | 5 | 38.05 | N | I-10 ° | 59 ' | 2.09 " | E |
| 5 | - | 6 | 52.80 | S | I-89 ° | 16 ' | 30.23 " | E |
| 6 | - | 7 | 18.70 | S | I-81 ° | 43 ' | 5.54 " | E |
| 7 | - | 8 | 15.18 | N | I-46 ° | 12 ' | 23.79 " | E |
| 8 | - | 9 | 24.34 | S | I-83 ° | 34 ' | 23.62 " | E |
| 9 | - | 10 | 17.87 | S | I-76 ° | 6 ' | 49.78 " | E |
| 10 | - | 11 | 33.64 | N | I-78 ° | 38 ' | 19.03 " | E |
| 11 | - | 12 | 17.05 | N | I-88 ° | 22 ' | 24.25 " | E |
| 12 | - | 13 | 29.98 | S | I-85 ° | 34 ' | 34.94 " | E |
| 36 | - | 37 | 21.79 | N | I-69 ° | 17 ' | 35.24 " | W |
Indlela iS template isebenza ngayo:
Ngesifanekiso esithwetshiwe:
- Idatha yokubeka, uma kulandelana, inombolo yokuqala ibhaliwe futhi ithempulethi igcwele amakholomu E no-G.
- Amabanga ekholomu H,
- Idatha yenkambo noma yenkambo. Akudingekile ukufaka izimpawu zamadigri, imizuzu noma imizuzwana njengoba ifomethi yeseli isivele iyifaka.
Ithempulethi inenketho yokukhetha ukuthi yiziphi izinqamuleli esilindele ukuba zibekwe eceleni; khumbula ukuthi uma sisebenzisa kuphela ama-decimals amabili, i-polygonal ngokuqinisekile ngeke ivaliwe ngoba ukucaca kuzolahleka ekupheleni kwesigamu.
Ithempulethi futhi ikuvumela ukuthi ukhethe ukuxhumanisa kwephoyinti lokuqala, ukufeza i-georeference. Masikhumbule ukuthi le misebenzi kule fomethi ivame ukuphakanyiswa ngama-theodolite ajwayelekile, ngakho-ke okungenani elilodwa lawo wonke amaphuzu linokuxhumanisa kwesithenjwa se-UTM.
Inkinobho yokudweba igxiliwe, futhi ngenxa yalokho ku-Microstation sizoba ne-polygon, njengoba kuboniswe kuvidiyo.
Icala le-2: Uhlu lwezixhumanisi ze-UTM
Isifanekiso sisebenza futhi uma lokho esinakho uhlu lwezixhumanisi ezisefomini Igama, eMpumalanga, eNyakatho, Ekuphakameni. Kanye netafula elinqunyelwe eliboniswe ngezansi.
| I-Dot | X | Y | Z |
| 1 | 418,034.12 | 1590,646.87 | 514.25 |
| 2 | 418,028.56 | 1590,680.72 | 526.11 |
| 33 | 418,107.63 | 1590,609.31 | 446.07 |
| 34 | 418,090.65 | 1590,610.45 | 420.49 |
| 35 | 418,065.54 | 1590,611.78 | 343.22 |
| 36 | 418,045.16 | 1590,619.48 | 335.91 |
Isebenza kuwo womabili amacala. Ukudabula kuzodwetshwa, kufakwe incazelo noma inombolo njengombhalo ku-vertex ngayinye. Izosebenzisa usayizi wombhalo, umbala, uhlobo lwefonti nokuqondanisa okusetshenziswayo eMicrostation. Ngakho-ke uma kungabonakali kithi, kwenziwa kuphela futhi.
Isifanekiso sitholakalela ukulandwa ngemali ekhokhwayo. Futhi sithi kungokomfanekiso, ngoba kulabo abaziphilisa ngokwenza i-cadastral noma i-topography iguana besebenzisa iMicrostation, bazobe besindisa umsebenzi omningi.
Yamukela Isifanekiso nge-Paypal noma i-Credit Card.
Funda ukuthi ungenza kanjani lezi ezinye izifanekiso ku Inkambo yokukopela ye-Excel-CAD-GIS.
Hola
Uma ufuna ukwengeza iziteshi eziningi,
Faka imigqa oyifunayo, isibonelo faka phakathi kwemigqa 10 ne11
Ngemuva kwalokho ukopisha umugqa owodwa ophelele ngokuwuthinta kusuka kunhlokweni kwesobunxele bese unamathisela emigqeni oyifakile kahle kufaka phakathi imigqa ye-10 ne-11 futhi okwenza amafomula ahambe futhi i-chaining iyaqhubeka.
Uma ungabaza, futhi uma ubheka ukuthi uthenge ithempulethi ungacela ukuxhaswa kulo editor@geofumadas.com
Phendula ngokucaphuna
Sawubona ithempulethi ayingivumeli ukuthi ngengeze iziteshi eziningi, ungangitshela ukuthi ngizifaka kanjani sicela, futhi uma unganikeza imiyalo enemininingwane
Usuku oluhle ngithole ithempulethi yakho ukwenza i-polygonal kodwa yangangivumeli ukuthi ngengeze imigqa eminingi ungangitshela ukuthi ngifaka kanjani iziteshi eziningi sicela
Cha. Isifanekiso sisebenza kuphela ne-Microstation.
ithempulethi ibuye isebenzele i-autocad noma i-civicad?
Nginomephu wefoni we-6 engifuna ukulayisha amanye amaphuzu, kepha mina ngiwaxhuma kwikhompyutha yami enefasitelana le-7 futhi aliwuboni
Ngithumelele ifayela le-excel, nedatha oyengezile. Ukuhlola ukuthi kungani kungasebenzi kuwe.
umhleli (at) geofumed. i-com
Ngine-template, ngibhala isiteshi, inkambo, ibanga, kanye nesixhumanisi sokuqala senkambo, ungayidonseli, angiyiqondi, x.