Lot Plotting Tutorial in Autocad (Data Input using Excel)

First topic message reminder :

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

paturo naman po kung paano lagyan ng palatandaan ung bawat line, ung lalagyan po ng bilog kung saan mag mimit ung each lines, thanks

bakit ganun sir moks, pinepaste ko na yung sa text na galing sa excel. image ng text na galing sa excel yung nilalagay nya mismo sa model space?

sir salamat sa info maganda to

iba-iba talaga mga method natin

DI NA MADOWNLOAD YUNG EXCEL:(

Galing naman nito ayos, salamat po sa pag share, 

thanks dito sir mokong 

TFS.  

Masubukan nga mamaya...