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
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Finding Prime Numbers with Excel, and using Array Formulas
- Linking Excel to C - 2
Recent Comments
Tag Archives: ConBeamU
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
py_ConBeamU and Strand7 check updates-2
Recent work with the py_ConBeamU spreadsheet found that it was returning incorrect results when the last support had a rotation spring restraint. In spite of the checks against Strand7 having 90 different support conditions, none of them included this one, … Continue reading
Posted in Beam Bending, Excel, Link to Python, Newton, PyXLL, Strand7, UDFs
Tagged ConBeamU, Excel, Excel Solver, Maximum deflection, Maximum moment, Strand7 check, UDFs, Units
Leave a comment
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
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
Continuous beam analysis from first principles
This post was prompted by an Eng-Tips question: Statically Indeterminant Beam Problem, asking for reactions due to a triangular distributed load on the middle span of a continuous beam with 3 equal simply supported spans. This could be simply solved … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, py_Conbeamu, Slope-deflection method
3 Comments