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.

2 Responses to A catenary function

  1. William Phillips says:

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


  2. Pingback: Daily Download 22: Splines and Curves | 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s