Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- The history of the theory of beam bending - Part 1
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Category Archives: Finite Element Analysis
Continuous beam with specified end conditions …
… and/or support displacements. The previous post in this series derived cubic splines with specified end conditions; either a specified curvature or a specified end slope. I have adapted the splinebeam function to allow input of specified end conditions (either a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
1 Comment
Update to Frame4.xls
It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect results. The code for the non-uniform load has now been fixed, and the spreadsheet can be downloaded from Frame4.zip
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, VBA
1 Comment
Continuous beam analysis with cubic splines
The last example in the previous post illustrated the use of cubic splines to find the bending moments in a continuous beam subject to prescribed lateral displacements. A similar technique can be used to find bending moments, shear forces, reactions, … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
9 Comments
Applied Mechanics of Solids
Applied Mechanics of Solids is a free text on finite element analysis by Allan F Bower, who seems to have a gift for clear explanation of the topic combined with a wry sense of humour; not a combination you see every … Continue reading
Frame Analysis with Excel – 7; Shear deflections and support displacements
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 … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
31 Comments