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.. )

TFS po. Magagamit ko po to next year pg nag-Cad na kami sa school. Hehe.

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...

@arki.karl - salamat.. gudluck sa studies...

@vamp_lestat - salamat bro.. yung lupa namin 100 points, haciendero kasi.. hahaha..

laking tulong talaga ito.

thanks mokong for sharing!

salamat at nagustuhan niyo ang tuts ko.. na cancel kasi ang phtobucket ko kaya nag post ako ulit..

Good job, I remember doing this, for parcel & exporting to mapinfo

astig to mas napadali....maraming salamat s tutorial

Tnx bro,

tnx dude.

thanks a lot sir mokong mabuhay kayo.

kua pang 2007 lng pho b yan???

maraming salamat sir, simple yet very useful.

Thanks for the tutorial.

salamat master mokong laking tulong to...

thank you at nagustuhan niyo munting tutorial ko...

useful to, thanks sir

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

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..

bakit ayaw po mag generate sakin, cad 09 po gamit ko. i follow all steps naman ganun pa rin

pwde pala yun!!!!!salamat

di ko pa natry... pero laki tulong nito sir. salamat!

Ang galing!thanks for the tutorial Bro..

galing.. laking tulong nito..