Hot on the heels of Version 3.04 comes Version 3.05.

A few days ago Julien asked if the Frame4 allowed for specified support deflections, to which I replied it would be added in the future. Searching Google on the topic I found:

https://newtonexcelbach.wordpress.com/2009/05/11/frame-analysis-with-excel-%E2%80%93-7-shear-deflections-and-support-displacements/

from which I discovered that it had been done already!

Download from: http://www.interactiveds.com.au/software/Frame4.zip

The new version has some small amendments to make it compatible with the Alglib solver, and adds some brief documentation. The screen shots below show example input and output, and results from Strand7 for the same problem, which are in near exact agreement.

Support displacement input

Support displacement and reaction output

Deflected shape x 200

Horizontal beam moments

Strand7 output, reactions for Node 1

### Like this:

Like Loading...

*Related*

I knew it ! Thank you !

LikeLike

Doug,

Now I have another wish! I would like to have the opportunity to apply perpendicular distributed loads, by using local coordinate systems, to my beams. Is it possible ?

Thanks,

Julien.

LikeLike

See https://newtonexcelbach.wordpress.com/2012/12/11/extending-frame4-with-on-sheet-formulas/

LikeLike

I spent lots of time before to write a frame analysis spreadsheet. I wish I had seen this post before. Thanks Doug.

However, it seems that the code does not compile. When I click on ‘Recalculate’, It can’t find ‘UCase’.

LikeLike

I’ve figured that out. It runs ok now.

LikeLike

Pingback: 3DFrame – 3D Frame analysis for Excel | Newton Excel Bach, not (just) an Excel Blog

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