Recent Comments
Elastic Biaxial Bend… on Biaxial bending update 
Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… 
dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel 
Kapt Blasto on mpmath for Excel 
mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… 
th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… 
Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach 
David Graves on About Newton Excel Bach
Tag Archives: Cubic Spline functions
Excel to Alglib via xlwings
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 AlgLib, Cubic Spline functions, curve fitting, Excel, Higher order polynomials, Matrix Functions, Python, UDF, VBA, xlwings
12 Comments
Re-sizing Array Functions
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 array functions, CSpline2, Cubic Spline functions, Excel, re-size arrays, UDF, VBA
4 Comments
