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
Newton Excel Bach, not (just) an Excel Blog 
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