Tag Archives: Numpy

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

Scipy functions with Excel and pyxll

Posted on 10/12/2023 by dougaj4

Over the years, I have posted a large number of user defined functions (UDF’s) allowing Python Scipy functions (and related libraries) to be accessed from Excel. These have now been consolidated in a uniform format, using the pyxll add-in and … Continue reading →

Posted in Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , | 6 Comments

Python code updates – 3DFrame-py

Posted on 03/11/2023 by dougaj4

Recent changes to how Python treats comparing a Numpy array to an empty list have resulted in some of my functions returning errors and I am in the process of updating them. Specifically, when an optional argument to a function … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs | Tagged , , , , , , , , | 2 Comments

py_Numpy update and using Numba

Posted on 11/05/2023 by dougaj4

The py_Numpy spreadsheet presented at Calling Numpy polynomial functions from Excel has had a minor upgrade to the py_Polyfit function, which was previously returning an error message if the optional “full” argument was set to False. The new version can be … Continue reading →

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