Tag Archives: UDFs.

Scipy Linalg functions stopped working

Posted on 27/10/2024 by dougaj4

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 , , , , , , , , , , , | Leave a comment

py_RC Elastic update

Posted on 08/06/2024 by dougaj4

Following the previous post I have updated the py_RC Elastic spreadsheet and code to work with the new solver function, and also add new functionality. The updated files can be downloaded from: py_RC Elastic.zip For details of the pyxll app … Continue reading →

Posted in Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 8 – Statistics

Posted on 05/01/2024 by dougaj4

This post looks at linking Excel to the Scipy and Pandas statistics functions using pyxll. The py_Stats spreadsheet, with associated Python code in PythonStatsFuncs3.py and pyScipy3.py, are included in the download file: py_SciPy.zip Details of the required pyxll package (including … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, PyXLL, UDFs | Tagged , , , , , , , , | 1 Comment