Lot Plotting Tutorial in Autocad (Data Input using Excel)

Page 1 of 3 1, 2, 3  Next

Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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:

Lot Plotting Tutorial in Autocad (Data Input using Excel) Sample


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.

Lot Plotting Tutorial in Autocad (Data Input using Excel) Excel-2

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

Lot Plotting Tutorial in Autocad (Data Input using Excel) Cad

3. In an instant your done!!!

Lot Plotting Tutorial in Autocad (Data Input using Excel) Cad2


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.. Lot Plotting Tutorial in Autocad (Data Input using Excel) Icon_eek )
mokong
mokong
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
Archi.Karl
Archi.Karl
CGP Apprentice
CGP Apprentice

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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...
vamp_lestat
vamp_lestat
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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..
mokong
mokong
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
balongeisler
balongeisler
CGP Expert
CGP Expert

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

http://balongeisler.carbonmade.com

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
scorpion21
scorpion21
CGP Apprentice
CGP Apprentice

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
mokong
mokong
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
rangalua
rangalua
CGP Guru
CGP Guru

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

http://rangaluastudio.carbonmade.com/

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
shekahkah
shekahkah
CGP Newbie
CGP Newbie

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

Back to top Go down

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

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

Tnx bro,
effreymm
effreymm
CGP Guru
CGP Guru

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

Back to top Go down

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

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

tnx dude. thumbsup
DELL1520
DELL1520
CGP Apprentice
CGP Apprentice

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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.
ARNEL_PRO
ARNEL_PRO
CGP Apprentice
CGP Apprentice

Number of posts : 315
Age : 38
Location : makati
Registration date : 10/08/2009

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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 : 30
Location : bataan
Registration date : 23/03/2010

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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.
mammoo_03
mammoo_03
The Exhibitioner
The Exhibitioner

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

http://www.coroflot.com/archmlcm

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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 : 30
Location : forums
Registration date : 08/01/2010

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
lloydi
lloydi
CGP Newbie
CGP Newbie

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
mokong
mokong
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
lightfoot
lightfoot
CGP Apprentice
CGP Apprentice

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

http://thequickbrownfox.devianart.com

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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 : 33
Location : baguio
Registration date : 20/04/2010

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
mokong
mokong
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
quilop
quilop
CGP Newbie
CGP Newbie

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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
theomatheus
theomatheus
CGP Guru
CGP Guru

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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!
haringsolomon
haringsolomon
CGP Newbie
CGP Newbie

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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..
brianlagmay
brianlagmay
CGP Apprentice
CGP Apprentice

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

http://4dward.sosblog.com

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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..
ONCIRE
ONCIRE
CGP Apprentice
CGP Apprentice

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

Back to top Go down

Lot Plotting Tutorial in Autocad (Data Input using Excel) Empty 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

Back to top


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