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

galing.. laking tulong nito..

sir..pweding paki sulat ng mas malinaw ang formula??? thanks po....

thanks dito sir. naalala ko yung thesis ko almost 300 bearings yung type ko heheh sakit sa ulo nun ngayon madali na mag plot ng lote. thanks ulit

sir,,bakit point or option keyword ang lumilitaw??? pasensya na po ha, newbie lang....

nice tutorial sir mokong.. thanks for sharing this one...

galing nito. salamat sa pagshare sir. ayos!

kuya medyo hindi ko nasundan kasi hindi ako masyado gumagamit ng excel...

ang galing nito sir!thanks a lot!

thanks for sharing sir. malaking tulong to.

thanks for sharing makes job easir

sinubukan ko kanina galing bro, salamat

thanks for sharing makes job easir

Hi patulong naman po
gagawa ng traverse palan sa details sa baba.
sino po may alam?
kung pwede pademonstrate na sa cad nung magiging itsura nya,
kahit printscreen nalang po
or send sa email ko ung cad file
janepatricio@ymail.com

autocad 2011 po gamit ko.

here are the details:

paclick nalang po ung link:

https://2img.net/r/ihimizer/i/unledgq.jpg/

jane051406 wrote:Hi patulong naman po
gagawa ng traverse palan sa details sa baba.
sino po may alam?
kung pwede pademonstrate na sa cad nung magiging itsura nya,
kahit printscreen nalang po
or send sa email ko ung cad file
janepatricio@ymail.com

autocad 2011 po gamit ko.

here are the details:

paclick nalang po ung link:

https://2img.net/r/ihimizer/i/unledgq.jpg/

nakita ko yung image.. i think this is for road right? survey data po ba ito?

TFS bro!

nice tutorial and tips po sir. thanks.

anensan wrote:TFS bro!

Nasa doha ka rin pala sir.. surveyor ka ba? Sumisilip ka kasi ng level sa profile pic mo.. hehe.. gamit na gamit po iyan sa survey..

tfs sir mokong its a great help

Thanks a lot sir, great help.!

Bakit sir ayaw mag generate sa cad kapag pini-paste ko na yung mga bearing na galing sa excel.?cad 2007 po gamit ko.. " Point or option keyword required" po lumalabas sa command promt.thanks

Thanks for sharring Sir! God bless

Thanks for sharring Sir! God bless

mga sir, newbie lang po ako na gusto matuto nito, pwede po paturo kung paano po lagyang ng label ung bawat line? thanks po

TFS sir mokong.

thanks sir!

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