Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Daily Download 5: Frame Analysis
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
Recent Comments
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: Making finite element analysis go faster Making finite element analysis go faster – update and … 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