Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Cubic Splines
- Downloads
- Writing Arrays to the worksheet - VBA function
- Daily Download 5: Frame Analysis
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Deflections and Moments in Rectangular Plates
- Filling Blanks with Go To-Special (and local help rant)
Recent Comments
Tag Archives: Second order effects
Beam geometric non-linear effects – end loads
Following the previous post, I found some errors in the Python code: These problems have now been fixed, and updated code and a revised spreadsheet have been added to the download file at: py_GeomK.zip The screenshots below show results with … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged End loads, Frame Analysis, Non-linear geometry, Python, PyXLL, Second order effects, UDF
Leave a comment
Beam geometric non-linear effects – Python version
In 2018 I posted Beam geometric non-linear effects with a VBA based spreadsheet to calculate beam actions and deflections under combined transverse and axial load, allowing for geometric non-linear effects. I have now converted the code to Python, linking to Excel … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, PyXLL, UDFs
Tagged Excel, Frame Analysis, Non-linear geometry, Python, PyXLL, Second order effects, UDFs
1 Comment
Beam geometric non-linear effects
A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Euler buckling, Excel, Frame Analysis, Non-linear geometry, Second order effects, UDF, VBA
5 Comments