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