Category Archives: PyXLL

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 – py_UMom

Posted on 18/11/2023 by dougaj4

Further to the previous post the py_UMom spreadsheet has now been updated for the latest Python and Numpy versions. The latest version can be downloaded from: py_UMom.zip In addition to the Python code changes, the example of the OptShearCap3600 function … Continue reading →

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

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