Back in March 2010, in response to this post with an update of the Frame4 spreadsheet: https://newtonexcelbach.wordpress.com/2009/12/31/frame4-xls-update2/ jscott (and later mettrox) asked if I had thought about adding output of the member forces at intervals along the member length, to which the response was, yes I’d thought about it.
But now I have done it, and the new version can be downloaded here: Download Frame4.zip. As usual, the file includes full open source code.
Some examples of the new output options are shown below:
Beam results for beam ends and for beams divided into 8 segments (click for full size view)
Deflected shape plot, including deflections along the beam length
Bending moment results for selected beams
Shear force results for selected beams
Y deflection results for selected beams
The spreadsheet includes verly little documentation, but the arrangement of input data is described in earlier posts in this series (search the blog for frame analysis), and if anything remains unclear, please ask.
Update 15 Sep 12: There was a bug in the routine to calculate intermediate beam actions and deflections with point loads which is now fixed: Download Frame4.zip.
Newton Excel Bach, not (just) an Excel Blog 
Hello, looks amazing from screenshots.
Take a look later.
LikeLike
Pingback: Daily Download 5: Frame Analysis | Newton Excel Bach, not (just) an Excel Blog
Hello,
Will be good if there will be possible to define different load cases.
For ULS, SLS conditions.
LikeLike
Hi metroxx – this is something I see as being easier to set up on the spreadsheet, rather than incorporating it in the code. The main area of development I’m looking at is improving analysis of non-linear material properties and second order effects.
LikeLike
Pingback: Frame Analysis with Excel | Newton Excel Bach, not (just) an Excel Blog