Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Filling Blanks with Go To-Special (and local help rant)
- Daily Download 4: Continuous Beam Analysis
- Daily Download 5: Frame Analysis
Recent Comments
Category Archives: Beam Bending
Solving non-linear equations with two or more unknowns – 1
Newton’s Method is a well known iterative solution for non-linear equations with one unknown. That is, if some value Y depends on a variable X, then we can use Newton’s Method to find X for any given value of Y. … Continue reading
Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA
Tagged Brents method, Excel, moment curvature, Newton's Method, non-linear equations, two or more unknowns, UDF, VBA
2 Comments
Reinforced Concrete Moment Curvature – Development over time
I recently noticed that in the RC Design Functions spreadsheet the TimeCurve function had stopped working. The function calculates the development of reinforced concrete section curvature over time, and was previously presented in Reinforced Concrete Moment-Curvature – 3; Restrained Shrinkage and Creep and Reinforced … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged creep, development over time, Excel, moment curvature, RC Design Functions, Reinforced Concrete, shrinkage, TimeCurve function, UDF, VBA
Leave a comment
ConBeamU 4.05 and ConBeampy 1.02
The latest update of the two continuous beam spreadsheets can be downloaded from: ConBeamU.zip ConBeampy.zip The main changes are: A problem with point loads applied exactly at a support position has been corrected A function has been added to evaluate … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, Python. Excel-Python, UDF, VBA
1 Comment
Conbeam – Python version
I have converted the continuous beam analysis spreadsheet (last presented here) to Python code, linked to Excel VBA User Defined Functions (UDFs) with ExcelPython. To run the Python version you will need an installed copy of Python, including Numpy and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, UDFs, VBA
Tagged Conbeampy, ConBeamU, continuous beam analysis, Excel, ExcelPython, Python, UDF, VBA
Leave a comment
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