Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Downloads
- Using LINEST for non-linear curve fitting
- Latex Maths Text in Excel
- Retrieving unique values from a range or array ...
- Spherical Geometry and Vincenty's Formulae
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Daily Download 3: ULS design of reinforced concrete sections
- Daily Download 4: Continuous Beam Analysis
- Buckling of columns with varying cross section
- Importing Text Files; Unix Format
Recent Comments
Tag Archives: SciPy
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
Listing Python modules and getting help docs from Excel
Python functions include detailed help documentation but to access this you need the full path to the function, including the names of all code modules and submodules. This post looks at how this information can be found using Excel with … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Function help, Getmembers, Numpy, Pkgutil, Python, PyXLL, SciPy
Leave a comment
Installing PyPardiso
Update 5th June 2022: The PyPardiso package may now be installed simply with pip (see Installing PyPardiso and speed of Scipy spsolve): Install the MKL library: pip install mkl Install PyPardiso: pip install pypardiso The PyPardiso package provides an interface to … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Exceel, Intel MKL library, PyPardiso, PyXLL, SciPy, Sparse matrix solver, UDFs
1 Comment
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