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
- Frame Analysis with Excel - 3, Continuous beam or frame
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Writing Arrays to the worksheet - VBA function
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: continuous beam analysis
Using UDFs – Continuous Beam Example
Recently (well a month ago) a comment was left at Continuous Beams with Shear Deflections asking for a tutorial on how to use the ConBeam User Defined Function (UDF). In this post I will give detailed instructions for the ConBeam function, but similar … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, shear deflections, support reactions, UDF, VBA
Leave a comment
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
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
Continuous beam with varying stiffness
Previous Splinebeam post One of my aims in developing the splinebeam function is to carry out non-linear analysis of reinforced concrete beams, allowing for the greatly reduced flexural stiffness of reinforced concrete sections after cracking of the concrete. To that … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Maths, Newton, UDFs, VBA
Tagged bending moments, continuous beam analysis, Cubic spline, deflections, Excel, shear forces, UDF, VBA
3 Comments