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
- Frame Analysis with Excel 1 - Single beam
- About Newton Excel Bach
- Taming Symbols in Excel
- Downloads
- Writing Arrays to the worksheet - VBA function
- Solving non-linear equations with two or more unknowns – 3
- XLDennis, the MSDN Library, and VBA rant
Recent Comments
Tag Archives: sparse matrices
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
Scipy Functions with Excel and pyxll 7 – Linear Algebra
This post looks at linking Excel to the Scipy linear algebra functions using pyxll, and also using the PyPardiso solver. Previous posts on this topic include: The pyLinAlgfuncs3 spreadsheet, with associated Python code in pyLinalgfuncs3.py and pyScipy3.py, are included in the … Continue reading
Posted in Arrays, 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
1 Comment
Installing PyPardiso and speed of Scipy spsolve
I recently upgraded to Python 3.10, and because of some problems with my previous installation I decided to do a complete new installation using pip, which required installation of all the libraries needed for my various programs. For my linear … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
4 Comments
Making Finite Element Analysis go faster – Update and PyPardiso
The previous post on this topic looked at the performance of alternative Scipy sparse equation solvers. This post updates those results with the current Scipy version (1.7.1), with very different results. It also compares the Scipy solver performance with the … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL
Tagged Excel, PyPardiso, Python, PyXLL, SciPy, sparse matrices, sparse solvers
5 Comments
Making Finite Element Analysis go faster …
… with Numba and Scipy sparse matrix functions. As promised in the previous post in this series, I will be looking at speeding up the formation and solving of matrix functions for the analysis of structural frames, using Excel and … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, NumPy and SciPy, PyXLL
Tagged Excel, Finite Element Analysis, Iterative solvers, Numba, Numpy, Python, PyXLL, SciPy, sparse matrices
4 Comments