Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from:

As an example of the use of the new functions, in conjunction with the IP (intersection) function, I have generated an animation showing the movement of two circular bearings, relative to a rotating tri-lobed shaft.  The tri-lobe is generated using the ArcSpline function, by defining the centre, radius, start and end angles, and number of segments for each of the six arcs:

A second arc-spline is then generated at 5 mm outside the first curve, representing the path that bearings of 5mm radius would follow, running around the outside of the inner spline.  The intersection point  of this outer spline can then be found using the IP function, and circles generated at these points, using the Arc function:

Full input for the two splines and two arcs is shown below.

The animation is then generated by recalculating the angular limits and centres of the spline curves, and the coordinates of the intersection of the circles and the X axis, for a series of small angle increments:


This entry was posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA and tagged , , , , , , . Bookmark the permalink.

1 Response to Arcs and arc-splines

  1. Pingback: Arc-spline update | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.