Scribd
Upload
64 views4 pages

Lot Plotting Tutorial in Autocad (Data Input Using Excel)

This tutorial provides a step-by-step guide for plotting lots in AutoCAD using data input from Excel, specifically formatted for millimeters. Users are instructed to input lot descriptions into an Excel spreadsheet and use formulas to generate text for AutoCAD. The method is highlighted for its efficiency and ease of editing compared to manual input in AutoCAD.

Uploaded by

Polgadas L. Sam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
64 views4 pages

Lot Plotting Tutorial in Autocad (Data Input Using Excel)

This tutorial provides a step-by-step guide for plotting lots in AutoCAD using data input from Excel, specifically formatted for millimeters. Users are instructed to input lot descriptions into an Excel spreadsheet and use formulas to generate text for AutoCAD. The method is highlighted for its efficiency and ease of editing compared to manual input in AutoCAD.

Uploaded by

Polgadas L. Sam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Lot Plotting Tutorial in Autocad (Data Input using Excel)

 Lot Plotting Tutorial in Autocad (Data Input using Excel)

 by mokong on Sun Feb 14, 2010 6:34 pm

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.

Enlarge this image   Click to see fullsize


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

Enlarge this image   Click to see fullsize


3. In an instant your done!!!

Enlarge this image   Click to see fullsize


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

You might also like