Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Retrieving unique values from a range or array ...
- Frame Analysis with Excel
- Beam actions and deflections by Macaulay's Method
- The angle between two vectors, Python version
Recent Comments
Category Archives: Frame 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
More on cubic splines
Link to Cubic Spline Update The previous two posts used cubic splines with the “natural” end condition, that is with an end curvature of zero. To apply the cubic spline to analysis of continuous beams with different end conditions we … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Maths, Newton, UDFs, VBA
Tagged continuous beam analysis, Cubic spline, Excel, UDF, VBA
10 Comments
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
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