Back in 2009, I posted a user defined function (UDF) to generate a catenary curve, that could be used together with the Excel Solver to generate a curve of a specified span and sag:
The revised spreadsheet can be downloaded from:
To use the spreadsheet enter the total horizontal span, the required sag at each end, and an estimate of the span from the left hand support to the low point (“XEnd1”). Then press the “Adjust A and XEnd1” button. The solver will adjust the catenary sag and the position of the low point to generate the required sag from each end. If nothing happens:
- Try adjusting the XEnd1 value, then click the left hand button, followed by the right.
- Make sure Solver is enabled.
- See the previous post