Tag Archives: SciPy

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments

Evaluating text and Integration with Python and ALGLIB

Posted on 07/07/2014 by dougaj4

Following the previous post on evaluating mathematical functions entered as text on the spreadsheet, I have now written a spreadsheet with similar functionality using Python functions, and the Excel-Python add-in.  Also included are integration functions using the SciPy Python library, … Continue reading →

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 1 Comment

Installing Python, Scipy and Pyxll

Posted on 09/09/2013 by dougaj4

I have recently been experimenting with Pyxll, which after a few initial hiccoughs is proving to be an easy and efficient way to connect Excel to Python based scientific and maths applications, such as linear algebra routines and ODE solvers.  … Continue reading →

Posted in Excel, Link to dll, Link to Python | Tagged , , , , | 15 Comments