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: Numpy
3DFrame-py; non-linear with end releases
The non-linear analysis routines in 3DFrame-py have now been updated to work with beams with end-releases at one or both ends. Updated files are at: 3DFrame-py.zip See the previous two posts for details of other software required for installation. To … Continue reading
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
Scipy Linalg functions stopped working
I recently noticed that the iterative linear algebra solvers in my pyLinAlgfuncs3.xlsb spreadsheet had stopped working. It turned out that the optional tolerance argument had been renamed ‘rtol’. Changing all the occurrences of the name in the Python code fixed … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Iterative solvers, linear algebra, linear equations solver, LU solvers, Numpy, PyPardiso, Python, PyXLL, SciPy, sparse matrices, UDFs.
Leave a comment
py_Numpy update
The py_Numpy spreadsheet, and the associated Python module have been updated. The new files are included in: py_SciPy.zip The download contains full open-source Python code and example spreadsheets for a wide range of Scipy functions, as well as the Numpy … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, get_docs function, Norm Function, Numpy, Python, Python help, PyXLL, py_Numpy, py_Scipy, SciPy
Leave a comment