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
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
- Daily Download 5: Frame Analysis
Recent Comments
Category Archives: Beam Bending
ConBeamU and Strand7 check update
Results of the continuous beam spreadsheet were last checked against Strand7 results 10 years ago. I have now updated this check with the latest version (4.19), which can be downloaded from: ConBeamU.zip The download file now includes: The Strand7 check … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units, VBA, Working with units.
1 Comment
py_UMom 1-05
Following the previous post the OptShearCap3600 function has been modified to give correct results with negative bending moments. The revised spreadsheet and Python code can be downloaded from: py_UMom.zip Typical output with negative moment input:
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete
Leave a comment
py_UMom 1.04
The py_UMom spreadsheet has been updated with further revisions to the py_OptShearCap3600 function. The new version can be downloaded from: py_UMom.zip For more information on the other functions in the spreadsheet see: py_UMom spreadsheet and OptShearCap3600 function. The changes to the … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged Design for Shear, Excel, longitudinal force due to shear, Python, PyXLL, py_UMom, RC Design Functions, Reinforced Concrete
1 Comment
py_RC Elastic 1.05 with elastic biaxial bending
The py_RC Elastic spreadsheet (last discussed here) has been updated with a new function py_Biax, providing elastic analysis of reinforced concrete sections under combined axial load and biaxial bending. The new spreadsheet and associated Python code can be downloaded from: py_RC … Continue reading
Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged biaxial bending, elastic analysis, Excel, Python, PyXLL, Reinforced Concrete, UDFs
Leave a comment
ConBeamU update
Following a comment at https://newtonexcelbach.com/2023/01/20/using-conbeamu/ I have updated the ConBeamU-Template file so that the function to select the input range works the same as in the main spreadsheet. For more details of how the spreadsheet works, see the link above, … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, UDFs, Units, VBA
Leave a comment