Excel Formula To Copy Multiple AutoCAD Objects to Multiple Points


This video is about an Excel formula for copying AutoCAD objects to Multiple Points When I say Multiple Points, it can be 10, 100 or even 1000. To explain Copy Command, I will start with creating a circle of radius 10 To make a copy of the circle I will use the command COPY Type in Copy in the AutoCAD Command Bar and Press the Enter Key or Space bar Now AutoCAD is prompting us to select the object or objects to be copied Select the object and press the Enter key or space bar Now we have to specify the base point I will select the center of the circle as base point so that copies of this circle will inserted in reference to this point. One more prompt, specify the second point Click anywhere in this drawing and that object which we selected will be copied to that particular point and I can make multiple copies just by clicking at different points in the drawing space IF you see the Command History, the program flow is COPY – Select the Object – Select the base point ‘Select second point’ is repeated as many times as the number of copies made If we know the Coordinates of these points in advance, we can automate this process Here in this sheet we have the X,Y Coordinates of some random points To copy an AutoCAD object to these points We have to join these Coordinates separated by a comma to join the data in the cells B2 and C2 with a comma in between,=B2&”,”&C2 Copy the formula to the adjacent cells Copy this data Back to AutoCAD For copying this circle into Multiple points Type in Copy in the command bar Select the object to be copied,
Press the Enter Key or Space Bar Select the base point Let it be the center of the circle Now we have to specify the second point Right click on the command bar Paste and the circle is copied into those points which we have in the Excel sheet using this method we can copy different AutoCAD objects like line, polyline, block or text so an example for copying multiple objects a text and a circle for that I will create a text here let it be XL n CAD Back to our Excel workbook=B2&”,”&C2 Copy the formula to the adjacent cells Copy this data back to AutoCAD Type in copy in the command bar Select the objects to be copied i.e the circle and the text select the base point let it be the center of these objects now we have to specify the second point right click on the command bar paste and the objects are copied into multiple points An example for inserting door blocks into a drawing for Commercial building This is the block which represent a door to insert this door into coordinates given in an excel sheet here we have the coordinates of the points where the doors are to be inserted The formula joining the Coordinates are written here Copy the data Back to AutoCAD Select the block Copy Command Press Enter Select the Base Point,
I will select this lower left corner as Base Point Paste the data into the command bar the blocks are copied into multiple points we use this technique extensively in Highway Engineering to create Plan & Profile drawings I will show you an example for inserting culverts into a drawing which represents Road Profile This is the block which represents a culvert and these are the lines which represent finished road levels and original ground levels here in this excel sheet I have the coordinates for the location of the culverts to insert blocks (Culverts) at these locations,
Copy the data back to AutoCAD COPY command select the block select the base point,
I will select the center of the block as base point paste the data into the command bar and the block which represent culvert is copied otherwise inserted into the locations given in the excel sheet one more example with Road Center Line these are the center line coordinates of a particular highway stretch and you can see here, there are more than 1200 points to plot these coordinates into an AutoCAD drawing, I will create a point here copy the data from the excel sheet COPY command Select the point to be copied,
Press Enter Select the base point,
Let it be the center of the point paste the data into the command bar you can see the points are being plotted

3 Comments

Add a Comment

Your email address will not be published. Required fields are marked *