The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel. The spreadsheet has now been updated for use with Python 3. The spreadsheet and all associated Python code can be downloaded from:
xlwSciPy3.zip
The spreadsheet requires installed copies of Python, including Numpy and Scipy, and xlwings. The easiest way to install the required packages is to install the Anaconda Python library. When the required Python packages are installed simply copy the contents of the xlwSciPy3.zip file to any convenient folder.
The functions included in the spreadsheet are indexed below:
Pingback: Scipy Statistics Functions – coding and getting help | Newton Excel Bach, not (just) an Excel Blog
Pingback: More SciPy Solvers | Newton Excel Bach, not (just) an Excel Blog