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
- Filling Blanks with Go To-Special (and local help rant)
- Frame Analysis with Excel - 3, Continuous beam or frame
- Linking Excel to C - 2
- Frame Analysis with Excel – 7; Shear deflections and support displacements
Recent Comments
Category Archives: Beam Bending
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
Cubic Splines
Cubic splines are used to fit a smooth curve to a series of points with a piecewise series of cubic polynomial curves. In addition to their use in interpolation, they are of particular interest to engineers because the spline is … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged continuous beam, Cubic spline, Excel, UDF, VBA
73 Comments
Frame Analysis with Excel – 4, 2D frame analysis
Continuing from: Frame Analysis with Excel – 3, Continuous beam or frame Download Frame1.zip – the download file includes complete open source code. The continuous beam spreadsheet presented in the previous post has been modified to deal with 2D frames where any … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Uncategorized, VBA
Tagged Excel, Finite Element Analysis, Frame Analysis, VBA
20 Comments
Reinforced Concrete Section Analysis 7 – rectangular sections
Previous post The spreadsheets presented in earlier posts in this series have been simplified for use with rectangular sections with two layers of reinforcement. The functions EStress (for elastic analysis of stresses, strains and crack widths) and UMom (for the … Continue reading
Posted in Beam Bending, Concrete, Newton, UDFs
Tagged Beam Bending, Reinforced Concrete, Section Analysis, UDF, Ultimate capacity, VBA
3 Comments