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