Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Smart Indenter and Excel 2013
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Converting from global to local coordinates (and vice versa)
- Buckling of columns with varying cross section
- Fitting high order polynomials
Recent Comments
Tag Archives: Macaulay’s Method
Continuous Beams with Shear Deflections
The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
10 Comments
Continuous Beams With Spring Supports by Macaulay’s Method
Following the last post on this topic: Continuous Beams With Cantilevers by Macaulay’s Method, and by popular demand, I have now updated the continuous beam and single span analysis functions to accept spring translational and moment restraints. Also added is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, spring supports, UDF, VBA
36 Comments
Beam actions and deflections by Macaulay’s Method
Macaulay’s Method is a convenient method of applying beam slope-deflection equations to find the shear forces, bending moments, slopes and deflections of a structural beam subject to complex load conditions, including partial varying distributed loads and point loads and moments. It … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Macaulay's Method, simply supported beam, UDF, VBA
15 Comments