Tag Archives: solvers

More SciPy Solvers

Posted on December 19, 2018 by dougaj4

The xlwings Scipy spreadsheet has been updated with a new example of the xl_SolveF function, that uses the Scipy Optimize root function.  The new spreadsheet can be downloaded from: xlScipy3.zip The new example uses a python function ic_calc (included in the … Continue reading →

Posted in Excel, Link to Python, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment

xlSciPy – Python SciPy for Excel; Update with new functions

Posted on January 4, 2016 by dougaj4

The xlSciPy spreadsheet, previously described here, has been updated with new functions for integration, finding equation roots and maxima and minima, solving systems of non-linear equations, and evaluation of equations entered as text.  The new version (including full open-source VBA … Continue reading →

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

Solvers, parsers and more

Posted on July 18, 2015 by dougaj4

Links to some really useful recently discovered sites: OpenSolver for Excel OpenSolver is an Excel VBA add-in that extends Excel’s built-in Solver with more powerful solvers. It is developed and maintained by Andrew Mason and students at the Engineering Science … Continue reading →

Posted in Excel | Tagged , , , , | 3 Comments