Frame4.xls – Update2

It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis.  The problem turned out to be that the analysis did not have any restraint specified in the X direction, resulting in a division by zero.

I have now added a check of restraints to ensure that there is at least one node restrained in each of the X and Y directions.

The modified spreadsheet can be downloaded from

Link to the original Frame4 post: Frame Analysis with Excel – 7; Shear deflections and support displacements

This entry was posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA and tagged , , , . Bookmark the permalink.

12 Responses to Frame4.xls – Update2

  1. Pingback: Frame analysis errata |

  2. jscott says:

    Great tool. Have you thought about adding output of the member forces at intervals along the member length? This would be a nice feature to add to your program.


  3. soufi says:

    could you please implement moving load analysis in the frame4


    • dougaj4 says:

      I don’t have any plans for a moving load analysis in the near future, but one of the nice things about open-source Excel software is that it is easy to make your own addittions!


  4. metroxx says:

    Maybe it is possible to make output results of moments and shear for frame bars?
    Thank you


  5. metroxx says:

    dougaj4, Thank you for your work. It’s will be great.
    I will waiting for it.


  6. Pingback: Frame4 – with intermediate beam results | Newton Excel Bach, not (just) an Excel Blog

  7. Pingback: Frame Analysis with Excel | 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 )

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.