Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Rotating Hypercubes
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads
- 3DFrame - 3D Frame analysis for Excel
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
Recent Comments
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