Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: Frame Analysis
Installing 3DFrame-py
Updated 1st Feb 2025. As mentioned in the previous post, the installation process for the 3DFrame-py spreadsheet has changed with the new version. Also there have been some significant changes to the code to fix installation problems. Updated files are … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged 3DFrame-py, Excel, Frame Analysis, Geometric non-linearity, Installing Python packages, Material non-linearity, non-linear analysis, Numba, Numpy, PyPardiso, Python, PyXLL, SciPy
4 Comments
3DFrame-py; with non-linear analysis
Exactly a year since the previous update I have revised the 3DFrame-py spreadsheet with the addition of non-linear analysis options. The new files can be downloaded from: 3DFrame-py.zip Details of file installation, and required software are at: 3DFrame-py Minor revisions … Continue reading
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
Python code updates – 3DFrame-py
Recent changes to how Python treats comparing a Numpy array to an empty list have resulted in some of my functions returning errors and I am in the process of updating them. Specifically, when an optional argument to a function … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged 3DFrame-py, Excel, Frame Analysis, Numba, Numpy, PyPardiso, Python, PyXLL, SciPy.
2 Comments