Lot Plotting Tutorial in Autocad (Data Input using Excel)
+41
zagvot
Norman
reimhedz
hotarubi
qwertyuiop07
Ian 3D
killerBEE
mhyles
letseor
anensan
jane051406
qcksilver
bahawz
ar_monzter
pepedahepe
brecky
confi
jumach
sandwich20m
zikboi
ONCIRE
brianlagmay
haringsolomon
theomatheus
quilop
pendong
lightfoot
lloydi
KC
mammoo_03
jarold12
ARNEL_PRO
DELL1520
effreymm
shekahkah
rangalua
scorpion21
balongeisler
vamp_lestat
Archi.Karl
mokong
45 posters
:: Tutorials :: Other Tutorials
Page 1 of 3
Page 1 of 3 • 1, 2, 3
Lot Plotting Tutorial in Autocad (Data Input using Excel)
here's a simple tut for you guys... this one is for millimeters in
autocad.. if u wish to make it meters just delete the 1000 on the
formula..
Sample Lot Description:
1. Follow the format as shown and type the data from the lot description. In coulmn F of excel spreadsheet, type the formula as shown below. Repeat the formula in next row of coulmn F or simply just copy and paste. All your inputs in the lot description will translate to text in column F. Copy all this text as highlighted in image shown.
2. In autocad, type line in the command prompt and then enter. Specify your first point. For the second point, move your cursor to the command prompt and paste the text (the one you copied in the excel spreadsheet).
3. In an instant your done!!!
Advantages:
- less time
- it is easy to go back and edit in excel spreadsheet if there is a mistake in the input than manually typing it in autocad (e.g. a lot with 100 points tapos nagkamali ka sa input, mauubos ang time mo sa pag type manually in autocad.. hehehe.. )
autocad.. if u wish to make it meters just delete the 1000 on the
formula..
Sample Lot Description:
1. Follow the format as shown and type the data from the lot description. In coulmn F of excel spreadsheet, type the formula as shown below. Repeat the formula in next row of coulmn F or simply just copy and paste. All your inputs in the lot description will translate to text in column F. Copy all this text as highlighted in image shown.
2. In autocad, type line in the command prompt and then enter. Specify your first point. For the second point, move your cursor to the command prompt and paste the text (the one you copied in the excel spreadsheet).
3. In an instant your done!!!
Advantages:
- less time
- it is easy to go back and edit in excel spreadsheet if there is a mistake in the input than manually typing it in autocad (e.g. a lot with 100 points tapos nagkamali ka sa input, mauubos ang time mo sa pag type manually in autocad.. hehehe.. )
mokong- CGP Guru
- Number of posts : 1926
Age : 41
Location : Nagoya, Japan
Registration date : 02/03/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
TFS po. Magagamit ko po to next year pg nag-Cad na kami sa school. Hehe.
Archi.Karl- CGP Apprentice
- Number of posts : 538
Age : 31
Location : Hagonoy, Bulacan at sa Golden State of Morayta
Registration date : 08/12/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
galing bro.. aus to ah.. magagamit nga toh... pero i doubt namn ung 100 points para sa lot plan... hehehe...
aus aus toh.. tnx for sharing...
aus aus toh.. tnx for sharing...
vamp_lestat- CGP Guru
- Number of posts : 1930
Age : 41
Location : Davao City, Philippines
Registration date : 27/11/2008
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
@arki.karl - salamat.. gudluck sa studies...
@vamp_lestat - salamat bro.. yung lupa namin 100 points, haciendero kasi.. hahaha..
@vamp_lestat - salamat bro.. yung lupa namin 100 points, haciendero kasi.. hahaha..
mokong- CGP Guru
- Number of posts : 1926
Age : 41
Location : Nagoya, Japan
Registration date : 02/03/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
thanks mokong for sharing!
scorpion21- CGP Apprentice
- Number of posts : 769
Age : 77
Location : PI
Registration date : 28/06/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
salamat at nagustuhan niyo ang tuts ko.. na cancel kasi ang phtobucket ko kaya nag post ako ulit..
mokong- CGP Guru
- Number of posts : 1926
Age : 41
Location : Nagoya, Japan
Registration date : 02/03/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
Good job, I remember doing this, for parcel & exporting to mapinfo
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
astig to mas napadali....maraming salamat s tutorial
shekahkah- CGP Newbie
- Number of posts : 45
Age : 41
Location : manila
Registration date : 27/11/2009
effreymm- CGP Guru
- Number of posts : 1617
Age : 44
Location : Sunshine City Laoag/Ilocos Norte/Doha Qatar
Registration date : 17/07/2009
DELL1520- CGP Apprentice
- Number of posts : 371
Age : 44
Location : DOH
Registration date : 16/12/2008
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
thanks a lot sir mokong mabuhay kayo.
ARNEL_PRO- CGP Apprentice
- Number of posts : 315
Age : 42
Location : makati
Registration date : 10/08/2009
n_n
kua pang 2007 lng pho b yan???
jarold12- Number of posts : 1
Age : 34
Location : bataan
Registration date : 23/03/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
maraming salamat sir, simple yet very useful.
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
Thanks for the tutorial.
KC- CGP Newbie
- Number of posts : 16
Age : 34
Location : forums
Registration date : 08/01/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
salamat master mokong laking tulong to...
lloydi- CGP Newbie
- Number of posts : 72
Age : 39
Location : Maranding, Lanao del Norte
Registration date : 06/04/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
thank you at nagustuhan niyo munting tutorial ko...
mokong- CGP Guru
- Number of posts : 1926
Age : 41
Location : Nagoya, Japan
Registration date : 02/03/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
sir, natry ko po siya ok po! thanks!hehe tapos sinubukan ko rin sa Notepad at Word pwede rin.. pag sa Notepad type lang ng diretso pro enter nio every after technical description.. pati ung pinaka last ng technical description dapat may enter.. example:
@116.87<N4-54'E
@79.96<N79-54'E
@133.84<S03-46'W
@79.97<N87-47'W(press enter)
then follow step No. 2 po sa turo nio..hehe
@116.87<N4-54'E
@79.96<N79-54'E
@133.84<S03-46'W
@79.97<N87-47'W(press enter)
then follow step No. 2 po sa turo nio..hehe
pendong- Number of posts : 1
Age : 37
Location : baguio
Registration date : 20/04/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
lightfoot wrote:useful to, thanks sir
ur welcome bro..
pendong wrote:sir, natry ko po siya ok po! thanks!hehe tapos sinubukan ko rin sa Notepad at Word pwede rin.. pag sa Notepad type lang ng diretso pro enter nio every after technical description.. pati ung pinaka last ng technical description dapat may enter.. example:
@116.87<N4-54'E
@79.96<N79-54'E
@133.84<S03-46'W
@79.97<N87-47'W(press enter)
then follow step No. 2 po sa turo nio..hehe
pwd yan bro.. kung saan mas madali sau yun gamitin mo..
anyway pwd rin maggawa ng excel format pero gamit mo coordinates kung naalala niyo pa ang lesson niyo sa surveying... hehehe.. yung may latiude at departure.. pag may time ako gawan ko ng tutorial gamit ay coordinates.. pero as of now eto lng muna..
mokong- CGP Guru
- Number of posts : 1926
Age : 41
Location : Nagoya, Japan
Registration date : 02/03/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
bakit ayaw po mag generate sakin, cad 09 po gamit ko. i follow all steps naman ganun pa rin
quilop- CGP Newbie
- Number of posts : 57
Age : 36
Location : philippine
Registration date : 09/03/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
pwde pala yun!!!!!salamat
theomatheus- CGP Guru
- Number of posts : 1387
Age : 41
Location : planet obsidian panopticon
Registration date : 06/07/2009
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
di ko pa natry... pero laki tulong nito sir. salamat!
haringsolomon- CGP Newbie
- Number of posts : 54
Age : 45
Location : Kung saan nagmula ang mga Mangyan! Pero ang Mangyan nasa Dubai na ngayon!
Registration date : 02/06/2010
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
Ang galing!thanks for the tutorial Bro..
Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)
galing.. laking tulong nito..
ONCIRE- CGP Apprentice
- Number of posts : 545
Age : 41
Location : singapore
Registration date : 04/06/2009
Page 1 of 3 • 1, 2, 3
Similar topics
» ImportingCoordinates from Excel to Autocad
» Autocad Problem about Plotting
» Entering Survey Data using AutoCAD
» 3D autocad tutorial
» autoCAD TO CORELdraw tutorial . . .
» Autocad Problem about Plotting
» Entering Survey Data using AutoCAD
» 3D autocad tutorial
» autoCAD TO CORELdraw tutorial . . .
:: Tutorials :: Other Tutorials
Page 1 of 3
Permissions in this forum:
You cannot reply to topics in this forum
|
|