May 12, 2014

Tip : Convert Autocad Text to Excel

The following procedure allows you to copy text from AutoCAD and paste it in excel as a text.


First copy and stack the text in a column. Go to “express tools” and select convert text to mtext. now select all the text and click enter. All the texts are now a single entity and a multiitext. 

Copy the text file and paste it in an excel sheet. The text will be in one cell and in a horizontal line.


This is how the text will appear when pasted in a excel sheet in order to arrange the text in separate rows ,go to DATA tab and click on TEXT TO COLUMNS icon and select DELIMITED option.

Tick on “Space” and then select next. Then finish

Now all text will be in separate horizontal cells (row)

Now in order to arrange the text in a column, select the entire row 1 and then select COPY.
Click on any other cell and then right click to select PASTE SPECIAL

In the dialogue box select TRANSPOSE  as shown and then OK

Repeat this procedure as required.

Note: When Text to column once selected in a cell (cell 1a) and the contents in that cell is deleted and another content is pasted in the same cell, it is not required to repeat the procedure (sorting of text in different cells) again.

Apr 20, 2014

Lisp : Barricades


           Barricades lisp helps you to create indicative Water Barrier, Concrete Barrier and Traffic cones mainly for Traffic Diversion Drawings which enhance drawing appearance.

How to use :
Download Barricades lisp click here

Load “Barricades” lisp
Type Command : 
  • WB  for Water Barriers, 
  • CB  for Concrete Barrier and 
  • TC  for traffic cones

  • Specify Barrier Width
  • Select polyline
  • Specify point on side to offset

  • New layer : Barricades and Cones
  • Line type Generation : Enabled

Tip : Add Barricades lisp to “Startup Suite” it will helps to load lisp Automatically

Similer post : Kerb Line

Jan 8, 2014

Pps : Drawing Quality

     One of the best ways to communicate one's ideas is through some form of picture or drawing. This is especially true for the engineer. An engineering drawing is a type of drawing that is technical in nature and is used to fully and clearly define and convey the process and requirements to obtain a finished product ,be it a building or bridges or roads. It is usually prepared in accordance with basic principles and standardized conventions for the layout, nomenclature, lines and symbolic representations. As these drawings follow standard conventions, engineers can use them to communicate with each other anywhere in the world. Therefore, engineering drawing is often called the universal language of engineers. Learning to create and understand these drawings is, thus, very important for all engineering students.

Here we will be looking at some important points of engineering drawings that should be followed in order to satisfy both the aesthetic as well as workability aspects.

Download Drawing Quality powerpoint presentation Click here...

May 22, 2013

Blk : Road Marking Template

Road marking template helps you to create road marking drawings, this file includes road marking blocks and lines in proper layers. The main aim to using this file is to maintain the quality of drawing and increase productivity. All marking blocks are created according to Qatar Traffic Manual.
          Click here to Download 

Copy this road marking block to a new file and EXPLODE,  then attach road xref and bind it.
match with match properties tool for line marking and copy marking blocks to drawing.
To draw  Kerb Line use LISP Kerbline.lsp  Click here

If you want to rename all layer names to your standards like “M500” to “RD_DE_M500” use RENAME command 
For more details read post Rename Click here

Similer Post : Dynamic Callout

Tip : Startup Suite

           Contains a list of applications that are loaded each time you start AutoCAD. This can be handy when you use a lisp file in daily use so that you don’t need to load it every time. The lisp files in the start up suit are loaded automatically whenever a new drawing file is opened.

Note: when you adding lisp applications to startup suite contents, add only lisp files which you need to be loaded when you start AutoCAD.