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 Frame4.zip

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

### Like this:

Like Loading...

*Related*

Pingback: Frame analysis errata | CroAxis.com

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.

LikeLike

It’s on the “to do” list (but so are many other things!)

LikeLike

could you please implement moving load analysis in the frame4

LikeLike

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!

LikeLike

Hello.

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

Thank you

LikeLike

I want to say that there will be not only results for bar ends.

LikeLike

Also I found spreadsheet called Calc4FEM (http://sourceforge.net/projects/calc4fem/). But it is developed for OpenOffice (OOo code) and didn’t work in Excel (VBA). I was tested it and everything works fine. In this spreadsheet you can define different load combinations, load types etc. But the main feature is that you can see moments, shears and deflections for bars along its length. Here is video and shown how it works: http://www.youtube.com/watch?v=UMHpvS_BN7E and guide: http://calc4fem.narod.ru/calc4fem_en_alpha06.pdf

Maybe it is possible to make the same thing in spreadsheet Frame ?

Thank you and sorry for many replies. Hope it is possible to understand what I mean.

LikeLike

metroxx – it’s on the agenda, but it will probably be a few weeks away.

LikeLike

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

I will waiting for it.

LikeLike

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

Pingback: Frame Analysis with Excel | Newton Excel Bach, not (just) an Excel Blog