Frame analysis with spring releases; 2D

I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release.  The new file can be downloaded from:

See Installing C# dll files, reminder for details of installing the supplied dll files, which provide much better performance for large frames. If these are not installed the spreadsheet will default to the built in VBA solver.

The previous version allowed insertion of beam end releases with zero rotational stiffness, which resulted in additional nodes being inserted in the frame model.  This allowed the addition of springs to the model, in effect inserting additional zero length spring members, connecting the rotational freedom at released ends to the rest of the model, by inserting the following values into the frame stiffness matrix:


using the following code:

'Add hinge stiffness factors
        k = BeamA(i, 5)
        If k > 0 Then
            For j = 1 To 2
                HingeK = BeamA(i, j + 2)
                If HingeK > 0 Then
                    gj = BeamER(k, (j - 1) * 2 + 8)
                    gk = BeamER(k, (j - 1) * 2 + 9)
                    KGCA(gj, gj) = KGCA(gj, gj) + HingeK
                    KGCA(gk, gk) = KGCA(gk, gk) + HingeK
                    KGCA(gj, gk) = KGCA(gj, gk) - HingeK
                    KGCA(gk, gj) = KGCA(gk, gj) - HingeK
                End If
            Next j
        End If

The screenshot below shows the input for the spring restraints:


I have compared results from the spreadsheet with those from the FEA program Strand7, using the model shown below:


The screenshot below shows near exact agreement for both beam end actions and deflections:


The spreadsheet also allows a lot of the frame deflected shape, and plots of arch actions and/or deflections along any slected beams.

Strand7 graphical output:


Spredsheet deflected shape plot:


Spreadsheet bending moment plots:



This entry was posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA and tagged , , , , . Bookmark the permalink.

One Response to Frame analysis with spring releases; 2D

  1. Pingback: 3DFrame with spring releases | 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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

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