A catenary function

Following on from the previous post, here is an Excel User Defined Function (UDF) to calculate the coordinates of any specified catenary, with the option of also finding the tension force at any point.

Download from: Catenary.zip

The download file includes full open source code.  To view the results of the function it must be entered as an array function, i.e.:

  1. Enter the function in the top left cell of the output range.
  2. Select the entire output range.
  3. Press F2
  4. Press Ctrl-Shift-Enter

See screen shot below for typical input and output (click on the image for a full size view):

Catenary UDF

Catenary UDF

This entry was posted in Arch structures, Excel, Maths, Newton, UDFs, VBA. Bookmark the permalink.

3 Responses to A catenary function

  1. William Phillips says:

    This great ! will need it soon. For an antenna project.

    Liked by 1 person

  2. Pingback: Daily Download 22: Splines and Curves | Newton Excel Bach, not (just) an Excel Blog

  3. Pingback: Asymmetric Catenary Function | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.