Lot Plotting Tutorial in Autocad (Data Input using Excel)
:: 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 : 37
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 : 28
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..

vamp_lestat- CGP Guru
- Number of posts : 1930
Age : 37
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 : 37
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 : 74
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 : 37
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 : 38
Location : manila
Registration date : 27/11/2009
effreymm- CGP Guru
- Number of posts : 1617
Age : 41
Location : Sunshine City Laoag/Ilocos Norte/Doha Qatar
Registration date : 17/07/2009
DELL1520- CGP Apprentice
- Number of posts : 371
Age : 41
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 : 38
Location : makati
Registration date : 10/08/2009
n_n
kua pang 2007 lng pho b yan???
jarold12- Number of posts : 1
Age : 31
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 : 31
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 : 36
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 : 37
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 : 33
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..


mokong- CGP Guru
- Number of posts : 1926
Age : 37
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 : 33
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 : 37
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 : 42
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 : 38
Location : singapore
Registration date : 04/06/2009
Page 1 of 3 • 1, 2, 3
:: Tutorials :: Other Tutorials
Page 1 of 3
Permissions in this forum:
You cannot reply to topics in this forum
|
|