Following the last post on this topic: Continuous Beams With Cantilevers by Macaulay’s Method, and by popular demand, I have now updated the continuous beam and single span analysis functions to accept spring translational and moment restraints. Also added is a new function to find the rotational stiffness of a cantilever beam with moment fixity at the opposite end (RotnK()). The new spreadsheet can be downloaded from:
The input for the revised Conbeam function can be seen in the screenshot below:
The Supports input range now has two additional (optional) columns allowing the translational and rotational stiffness of each support to be specified. These have been used to model a 3 span beam with two cantilever ends, supported on 4 columns, with 4 columns above. The rotational stiffness of the columns has been found using the RotnK function (the single column stiffness is doubled at each support because there are two columns). A Strand7 frame model of the equivalent frame is shown below.
Part of the output of the Conbeam function, compared with the Strand7 results, is shown in the table below:
It can be seen there is almost exact agreement, as is also seen in the graphical results: