Lot Plotting Tutorial in Autocad (Data Input using Excel)

Page 1 of 3 1, 2, 3  Next

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

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 Archi.Karl on Sun Feb 14, 2010 11:41 am

TFS po. Smile Magagamit ko po to next year pg nag-Cad na kami sa school. Hehe. thumbsup
avatar
Archi.Karl
CGP Apprentice
CGP Apprentice

Number of posts : 538
Age : 24
Location : Hagonoy, Bulacan at sa Golden State of Morayta
Registration date : 08/12/2009

View user profile

Back to top Go down

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

Post by vamp_lestat on Sun Feb 14, 2010 11:44 am

galing bro.. aus to ah.. magagamit nga toh... pero i doubt namn ung 100 points para sa lot plan... hehehe...

aus aus toh.. 2thumbsup tnx for sharing...
avatar
vamp_lestat
CGP Guru
CGP Guru

Number of posts : 1930
Age : 34
Location : Davao City, Philippines
Registration date : 27/11/2008

View user profile

Back to top Go down

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

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

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

@vamp_lestat - salamat bro.. yung lupa namin 100 points, haciendero kasi.. hahaha..
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 balongeisler on Sun Feb 14, 2010 3:05 pm

laking tulong talaga ito. 2thumbsup
avatar
balongeisler
CGP Expert
CGP Expert

Number of posts : 2123
Age : 38
Location : riyadh,ksa / tagum city
Registration date : 26/04/2009

View user profile http://balongeisler.carbonmade.com

Back to top Go down

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

Post by scorpion21 on Sun Feb 14, 2010 3:14 pm

thanks mokong for sharing! thumbsup
avatar
scorpion21
CGP Apprentice
CGP Apprentice

Number of posts : 769
Age : 70
Location : PI
Registration date : 28/06/2009

View user profile

Back to top Go down

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

Post by mokong on Sun Feb 14, 2010 10:15 pm

salamat at nagustuhan niyo ang tuts ko.. na cancel kasi ang phtobucket ko kaya nag post ako ulit.. Very Happy
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 rangalua on Mon Feb 15, 2010 12:41 am

Good job, I remember doing this, for parcel & exporting to mapinfo 2thumbsup
avatar
rangalua
CGP Guru
CGP Guru

Number of posts : 1865
Age : 33
Location : Madinah, Kingdom of Saudi Arabia
Registration date : 25/07/2009

View user profile http://rangaluastudio.carbonmade.com/

Back to top Go down

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

Post by shekahkah on Mon Feb 15, 2010 2:21 am

astig to mas napadali....maraming salamat s tutorial
avatar
shekahkah
CGP Newbie
CGP Newbie

Number of posts : 45
Age : 35
Location : manila
Registration date : 27/11/2009

View user profile

Back to top Go down

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

Post by effreymm on Mon Feb 15, 2010 2:35 am

Tnx bro,
avatar
effreymm
CGP Guru
CGP Guru

Number of posts : 1617
Age : 38
Location : Sunshine City Laoag/Ilocos Norte/Doha Qatar
Registration date : 17/07/2009

View user profile

Back to top Go down

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

Post by DELL1520 on Mon Feb 15, 2010 4:45 am

tnx dude. thumbsup
avatar
DELL1520
CGP Apprentice
CGP Apprentice

Number of posts : 371
Age : 38
Location : DOH
Registration date : 16/12/2008

View user profile

Back to top Go down

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

Post by ARNEL_PRO on Mon Feb 15, 2010 5:04 am

thanks a lot sir mokong mabuhay kayo.
avatar
ARNEL_PRO
CGP Apprentice
CGP Apprentice

Number of posts : 308
Age : 35
Location : makati
Registration date : 10/08/2009

View user profile

Back to top Go down

n_n

Post by jarold12 on Wed Mar 24, 2010 2:50 am

kua pang 2007 lng pho b yan???

jarold12

Number of posts : 1
Age : 27
Location : bataan
Registration date : 23/03/2010

View user profile

Back to top Go down

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

Post by mammoo_03 on Thu Apr 01, 2010 4:42 am

maraming salamat sir, simple yet very useful.
avatar
mammoo_03
The Exhibitioner
The Exhibitioner

Number of posts : 2417
Age : 38
Location : manila, makati, dubai
Registration date : 20/09/2008

View user profile http://www.coroflot.com/archmlcm

Back to top Go down

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

Post by KC on Tue Apr 06, 2010 11:21 am

Thanks for the tutorial.

KC
CGP Newbie
CGP Newbie

Number of posts : 16
Age : 27
Location : forums
Registration date : 08/01/2010

View user profile

Back to top Go down

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

Post by lloydi on Tue Apr 06, 2010 6:39 pm

salamat master mokong laking tulong to... Very Happy
avatar
lloydi
CGP Newbie
CGP Newbie

Number of posts : 72
Age : 33
Location : Maranding, Lanao del Norte
Registration date : 06/04/2010

View user profile

Back to top Go down

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

Post by mokong on Mon Apr 12, 2010 11:17 am

thank you at nagustuhan niyo munting tutorial ko... Very Happy
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 lightfoot on Mon Apr 12, 2010 12:21 pm

useful to, thanks sir
avatar
lightfoot
CGP Apprentice
CGP Apprentice

Number of posts : 474
Age : 33
Location : Bulacan, Philippines
Registration date : 01/04/2010

View user profile http://thequickbrownfox.devianart.com

Back to top Go down

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

Post by pendong on Thu Apr 22, 2010 12:33 am

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

pendong

Number of posts : 1
Age : 30
Location : baguio
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 mokong on Thu Apr 22, 2010 12:56 am

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.. Sad pag may time ako gawan ko ng tutorial gamit ay coordinates.. pero as of now eto lng muna.. Very Happy
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 quilop on Sun May 02, 2010 11:11 pm

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

Number of posts : 57
Age : 29
Location : philippine
Registration date : 09/03/2010

View user profile

Back to top Go down

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

Post by theomatheus on Sun May 02, 2010 11:42 pm

pwde pala yun!!!!!salamat thumbsup
avatar
theomatheus
CGP Guru
CGP Guru

Number of posts : 1387
Age : 34
Location : planet obsidian panopticon
Registration date : 06/07/2009

View user profile

Back to top Go down

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

Post by haringsolomon on Thu Jun 24, 2010 1:29 pm

di ko pa natry... pero laki tulong nito sir. salamat!
avatar
haringsolomon
CGP Newbie
CGP Newbie

Number of posts : 53
Age : 39
Location : Kung saan nagmula ang mga Mangyan! Pero ang Mangyan nasa Dubai na ngayon!
Registration date : 02/06/2010

View user profile

Back to top Go down

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

Post by brianlagmay on Thu Jun 24, 2010 4:23 pm

Ang galing!thanks for the tutorial Bro..
avatar
brianlagmay
CGP Apprentice
CGP Apprentice

Number of posts : 225
Age : 39
Location : Baguio,makati city,Narvacan, Ilocos Sur
Registration date : 05/11/2009

View user profile http://4dward.sosblog.com

Back to top Go down

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

Post by ONCIRE on Fri Jun 25, 2010 6:55 am

galing.. laking tulong nito..
avatar
ONCIRE
CGP Apprentice
CGP Apprentice

Number of posts : 545
Age : 34
Location : singapore
Registration date : 04/06/2009

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 1 of 3 1, 2, 3  Next

View previous topic View next topic Back to top

- Similar topics

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