Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Solving non-linear equations with two or more unknowns – 3
- Beam actions and deflections by Macaulay's Method
- Taming Symbols in Excel
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Tag Archives: deflections
py_xlCBA – Supports with defined deflections
As stated in the previous post, this post will cover the calculation of beam actions and displacements when one or more supports have a defined vertical displacement, using the pyCBA beam analysis package. The Python code has been updated since … Continue reading
py_xlCBA update
Following the previous post the py_xlCBA spreadsheet and associated code have been updated. The updated files, including open-source code, can be downloaded from: py_xlCBA.zip Note that the link in the previous post was downloading the wrong file, and has just … Continue reading
Calling PyCBA from Excel
PyCBA is a Python based continuous beam analysis program. From the on-line docs: I have set up a spreadsheet based on py_Conbeam that converts the py_Conbeam input to PyCBA format, then runs the PyCBA analysis and returns the results to … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged bending moments, ConBeamU, deflections, Excel, Maximum moment, Py_CBA, Reactions, shear forces, Strand7 check, UDFs
1 Comment
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
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