Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Using LINEST for non-linear curve fitting
- Biaxial bending update
- Cubic Splines
- Retrieving unique values from a range or array ...
- A catenary function
- The history of the theory of beam bending - Part 3
- Writing Arrays to the worksheet - VBA function
- Converting from global to local coordinates (and vice versa)
- Linestgap with data in rows
Recent Comments
Tag Archives: py_Conbeamu
Continuous beam animations with VBA and Python
Following a lengthy discussion at Eng-Tips I have developed several functions to generate animations of the effects of applied moving loads. The Python code and examples have been added to the py_ConBeamU.zip file which can be downloaded from: py_ConBeamU.zip Starting … Continue reading
Posted in Animation, Beam Bending, Charts, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs, VBA
Tagged animations, beam analysis, Excel, Fixed-end moments, MatPlotlib, Moving load analysis, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
1 Comment
py_ConBeamU and Strand7 check updates
Following the previous post, I have updated the py_ConBeamU spreadsheet, and the associated check against Strand7 results. The new files can be downloaded from: py_ConBeamU.zip The download file now includes: For more details of the spreadsheet and included functions see … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
1 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
py_ConBeamU
I have now converted the VBA code in the ConBeamU spreadsheet to Python, connected to Excel via pyxll. The new spreadsheet and associated Python code can be downloaded from: py_ConBeamU.zip In addition to the provided files, the pyxll application is … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged beam analysis, Excel, Fixed-end moments, Python, PyXLL, py_Conbeamu, Restrained End Moments, UDFs
4 Comments