Tag Archives: Numpy

Scipy Functions with Excel and pyxll 8 – Statistics

Posted on January 5, 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 , , , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 7 – Linear Algebra

Posted on January 1, 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 , , , , , , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 6 – Integration

Posted on December 29, 2023 by dougaj4

The py_Integrate spreadsheet, with associated Python code in pyScipy3.py, are 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 … Continue reading →

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

Scipy Functions with Excel and pyxll 5 – Evaluate with Units

Posted on December 27, 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 , , , , , , , , , , , , , | Leave a comment

Scipy Functions with Excel and pyxll 4 – Solvers 2

Posted on December 19, 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 , , , , , , , , , | Leave a comment