Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Downloads
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- The angle between two vectors, Python version
- Daily Download 2: SLS design of reinforced concrete sections ...
- Continuous Beam Spreadsheet - with Units
- XLDennis, the MSDN Library, and VBA rant
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
ConbeamU Update Update
Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one. The new version number is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Strand7, UDF, VBA
4 Comments
ConbeamU Update; defined support deflections
As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading
Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged array entry, Array function entry, ConBeamU, continuous beam, defined support deflections, deflections, Excel, Macaulay's Method, UDF, VBA
12 Comments
Beams may kiss, but do not hug …
… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Simply supported beams, Solver, stacked beams, Strand7, UDF, VBA
Leave a comment
Faster Biaxial Bending
The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment
Reinforced Concrete – ULS capacity under combined axial load and biaxial bending
I have modified the ULS Design Functions spreadsheet, last presented here, to analyse sections subject to bi-axial bending, and non-symmetrical sections. The new version makes use of the routines for splitting any section defined by XY coordinates into trapezoidal layers, described … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
13 Comments