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
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Linking Excel to C - 2
Recent Comments
Category Archives: Beam Bending
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
Continuous Beams With Cantilevers by Macaulay’s Method
Edit 13 Apr 2014: See Continuous Beam Spreadsheet with Moving Load for the latest version, which is now called ConBeamU. I have updated the Macaulay spreadsheet (described here) to allow the analysis of continuous beams with cantilevers at one or … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Cantilever, continuous beam, Excel, Macauley's Method, UDF, VBA
12 Comments
Continuous Beam Analysis by Macaulay’s Method
The Macaulay spreadsheet now includes a ConBeam() function, analysing continuous beams with any number of segments of different stiffness, subject to any combination of distributed or point loads and moments. The spreadsheet also includes an example, together with output of … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macauley's Method, UDF, VBA
8 Comments
Beam Fixed End Actions by Macaulay’s Method
Following the previous post examples have been added to the Macaulay Spreadsheet illustrating the use of the method to find fixed end moments and reactions for a beam fixed at one or both ends, and subject to any number of … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Excel, Fixed End Moments, Macauley's Method, UDF, VBA
2 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