Lot Plotting Tutorial in Autocad (Data Input using Excel)

Page 3 of 3 Previous  1, 2, 3

View previous topic View next topic Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by mokong on Sun Feb 14, 2010 11:34 am

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.. )
avatar
mokong
CGP Guru
CGP Guru

Number of posts : 1926
Age : 34
Location : Nagoya, Japan
Registration date : 02/03/2009

View user profile

Back to top Go down


Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by qwertyuiop07 on Sun Feb 26, 2012 8:50 pm

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

qwertyuiop07

Number of posts : 3
Registration date : 24/02/2012

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by Norman on Fri May 24, 2013 12:56 pm

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? scratch
avatar
Norman
CGP Expert
CGP Expert

Number of posts : 3228
Registration date : 21/06/2009

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by zagvot on Mon May 27, 2013 6:41 pm

sir salamat sa info maganda to

iba-iba talaga mga method natin
avatar
zagvot
CGP Newbie
CGP Newbie

Number of posts : 91
Age : 27
Location : surigao city
Registration date : 27/12/2011

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by sheng28 on Mon May 19, 2014 3:15 am

DI NA MADOWNLOAD YUNG EXCEL:(

sheng28

Number of posts : 1
Age : 32
Location : pASIG
Registration date : 19/05/2014

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by edmar on Mon May 19, 2014 8:11 pm

Galing naman nito ayos, salamat po sa pag share, peace man
avatar
edmar
CGP Newbie
CGP Newbie

Number of posts : 110
Age : 33
Location : Doha, Qatar.(Betis,Guagua,Pampanga)
Registration date : 01/08/2010

View user profile http://serforbes.wix.com/edmarforbes

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by ekspay on Sun May 24, 2015 3:40 pm

thanks dito sir mokong  2thumbsup

ekspay

Number of posts : 3
Age : 42
Location : Taguig City
Registration date : 25/04/2015

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by bing1370 on Sat May 30, 2015 3:59 am

TFS. 2thumbsup 

Masubukan nga mamaya...
avatar
bing1370
CGP Apprentice
CGP Apprentice

Number of posts : 575
Age : 46
Location : Ilocos Sur/Abu Dhabi, U.A.E.
Registration date : 20/04/2010

View user profile

Back to top Go down

Re: Lot Plotting Tutorial in Autocad (Data Input using Excel)

Post by Sponsored content


Sponsored content


Back to top Go down

Page 3 of 3 Previous  1, 2, 3

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum