Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- Downloads
- Writing Arrays to the worksheet - VBA function
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 2: SLS design of reinforced concrete sections ...
- Continuous Beam Spreadsheet - with Units
- The angle between two vectors, Python version
Recent Comments

Z on Downloads py_xlCBA – Sup… on py_xlCBA update 
dougaj4 on Downloads 
Z on Downloads py_xlCBA update | Ne… on Calling PyCBA from Excel 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
khoitsma on Continuous beam animations wit… 
Z on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
dougaj4 on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
Z on Reinforced concrete elastic an… 
dougaj4 on Downloads 
dougaj4 on Installing Adobe Reader non-DC…
Tag Archives: linear equations solver
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
Compiled Matrix Functions for Excel
This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding. The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading
Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, Eigen values, eigen vectors, Excel, linear equations solver, matrix determinant, Matrix Functions, matrix inverse, sparse solver, UDF, VBA
4 Comments