Tag Archives: Cubic Spline functions

Excel to Alglib via xlwings

Posted on August 11, 2017 by dougaj4

The Alglib library provides many valuable numerical analysis routines, but the VBA version is no longer actively maintained.  The latest versions are available in C++, C#, and Python, of which the Python version (in conjunction with xlwings) provides the easiest interface … Continue reading →

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, Numerical integration, UDFs, VBA, xlwings | Tagged , , , , , , , , , | 12 Comments

Re-sizing Array Functions

Posted on April 14, 2015 by dougaj4

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , , | 4 Comments