Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions
Download Frame4.zip - the download file includes complete open source code.
Two more refinements have been added to the frame analysis spreadsheet:
- The stiffness matrix has been revised to take account of shear deflections for members where the shear area and shear modulus are provided.
- It is now possible to apply displacements and/or rotations to supports. Fixed freedoms are specified with “F”, or enter the support deflection in the appropriate units, or rotation in radians.
In addition a plotting routine has been added to plot the frame, with or without scaled deflections.
Shown below are results for an example frames, with results from the same frames analysed in Strand7, and plots of the deflected shape (scaled by a factor of 20) from the spreadsheet and Strand7:
Frame4 output compared with Strand7; click to view full size.
Spreadsheet plot of deformed shape x 20
Strand7 deformed shape
Filed under: Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged: Excel, Finite Element Analysis, Frame Analysis, VBA
As a suggestion, you may improve your algorithm by making it working with trapezoid loads. Of course, it will be appreciated if you keep us on your news list. Thanks and best wishes.
Regards
RH
RH – it does work with trapezoidal loads, see some of the earlier posts for examples. I will also be adding more examples later, and (eventually) there should be a feature to plot applied loads.
[...] 19, 2009 by dougaj4 It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect [...]