Draw Mathematical Functions in AutoCAD using Excel

Draw Mathematical Functions in AutoCAD using Excel

Consider the damped sinusoid shown below. For want of a better word this is a “pretty” function that can be used to good effect in some design. I would like to be able to generate variations on this function in quick time.

1-7 Draw Mathematical Functions in AutoCAD using Excel

Instead of drawing splines onto pictures imported into AutoCAD, I am going to use Excel. I create a column for time, which will be the x axis. Then the column for y contains the formula shown below (I have added a factor “A” to denote the amplitude).

2-6 Draw Mathematical Functions in AutoCAD using Excel

Next I combine the x and y values into a coordinate using the CONCATENATE function shown below

3-5 Draw Mathematical Functions in AutoCAD using Excel

Now copy the column containing the coordinates to the clipboard and then go to AutoCAD.

Start the polyline command, click in the command line when asked for a start point and them Right Mouse Click (RMC) and paste. A polyline is drawn through all the coordinates. Enter to finish. As can be seen below the definition is a little bad, so simply decrease the time interval to one tenth what it was before.

4-5 Draw Mathematical Functions in AutoCAD using Excel

This time a much better function results

5-5 Draw Mathematical Functions in AutoCAD using Excel

As per my previous blog, for manufacturing, it may be a good idea now to edit the polyline, change it to a spline fit and then explode to change the lines into curves:

The yellow line below is the fit spline.

6-5 Draw Mathematical Functions in AutoCAD using Excel

The green line is the yellow spline copied exploded into arcs (note there is almost no difference between the two).

7-5 Draw Mathematical Functions in AutoCAD using Excel

Next I join the arcs into a polyline again so I may offset and extrude it (for something that needs to be manufactured).

8-5 Draw Mathematical Functions in AutoCAD using Excel

Have fun making pretty mathematical shapes in AutoCAD!

By | 2017-10-18T10:49:03+00:00 May 22nd, 2017|

About the Author:

After concurrently manufacturing for the Radar EW industry and reading incompletely toward Mechanical Engineering at Stellenbosch University, I realigned toward the Architectural. Today I support the AEC professions in Cape Town as an Application Engineer for a Gold Autodesk Reseller in South Africa called Micrographics. I support and facilitate training on the following software platforms: Revit (Architectural, Structural and MEP); Civil3D; AutoCAD; SANSCalc and Lumion.