Tag Archives: UDFs

Scipy Functions with Excel and pyxll 7 – Linear Algebra

Posted on 01/01/2024 by dougaj4

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 , , , , , , , , , , , | 1 Comment

Scipy Functions with Excel and pyxll 5 – Evaluate with Units

Posted on 27/12/2023 by dougaj4

The Scipy series continues with the py_EvalU spreadsheet included in the download file: py_SciPy.zip The spreadsheet and associated Python packages have had significant edits since the first post in this series, so please download the latest file. Details of the … Continue reading →

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , , , , , , | 2 Comments

Scipy Functions with Excel and pyxll 4 – Solvers 2

Posted on 19/12/2023 by dougaj4

Following the previous post I will continue to look at the py_Solvers spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll For those installing a new copy … Continue reading →

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

Scipy Functions with Excel and pyxll 3 – Solvers 1

Posted on 17/12/2023 by dougaj4

Following the the first post in this series I will move on to the py_Solvers spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found at: pyxll For those … Continue reading →

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

Scipy Functions with Excel and pyxll 2 – Interpolation

Posted on 13/12/2023 by dougaj4

Following the previous post I will now look in more detail at the functions in the py_Interpolate spreadsheet included in the download file: py_SciPy.zip Details of the required pyxll package (including download, free trial, and full documentation) can be found … Continue reading →

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