Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Finding Prime Numbers with Excel, and using Array Formulas
- Continuous Beam Spreadsheet - with Units
- Daily Download 2: SLS design of reinforced concrete sections ...
- 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…
Category Archives: Beam Bending
Elegant Solutions – Why does this balance?
From the Eng-Tips forum Why does the mechanism shown below balance when the load applied to each platform is the same, even when the lever arms from the pivot are different? It “looks wrong” but an analysis shows that the … Continue reading
Posted in Beam Bending, Newton
1 Comment
Reinforced Concrete Moment-Curvature – 1
The flexural curvature of any beam composed of material with linear elastic behaviour, subject to a bending moment, M, is given by: C = M / EI where E is the elastic modulus of the beam, and I is its … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged cracked, Curvature, deflections, Reinforced Concrete, tension stiffening
5 Comments
Reinforced Concrete Section Analysis – with prestress
The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement. The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, Curvature, EC2, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS, Ultimate capacity, VBA
3 Comments
LatPile – Analysis of Lateral Loads on Piles
This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles subject to horizontal loads, using the same approach as employed in the DOS program COM624. A spreadsheet including the UDF and an on-spreadsheet … Continue reading
Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, Laterally loaded pile, LPile, UDF, VBA
11 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