Recent Comments
Category Archives: Newton
ExcelPython2, Alglib and Spline-Matrix update
The ExcelPython add-in, offering easy access to Python code from Excel VBA, has had a major update to Release 2. The new version provides new features and simpler installation, but has some incompatibilities with code written for the previous version, so the … Continue reading
Posted in AlgLib, Excel, Link to Python, Maths, Newton, UDFs, VBA
Tagged AlgLib, curve fitting, Excel, ExcelPython, Matrix Functions, Python, Spline functions, UDF, VBA
4 Comments
Extending complex UDFs with simple VBA
One of the advantages of writing spreadsheet applications in the form of User Defined Functions (UDFs) is that the UDF may be used on the spreadsheet in the same way as a built-in function, allowing applications to be modified and extended … Continue reading
Using the VBA ParamArray keyword
The recently posted SolvePoly function makes use of the VBA ParamArray keyword, which allows an arbitrarily long list of arguments to be passed to another function. I have not made great use of this in the past, but since the … Continue reading
Is Hinchliffe’s Rule True? …
… is the title of a paper by Boris Peon. Here is the abstract: Hinchliffe has asserted that whenever the title of a paper is a question with a yes/no answer, the answer is always no. This paper demonstrates that … Continue reading
Numerical Integration; Tanh-Sinh Quadrature v. 4.2
The latest version (4.2) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. For more details of the background see: Faster Integration with the Tanh-Sinh Method and subsequent posts on this subject. In addition to … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double Exponential, Excel, Gauss-Kronrod, numerical integration, Romberg, Tanh-Sinh method, Tanh-Sinh Quadrature, UDF, VBA
2 Comments
Newton Excel Bach, not (just) an Excel Blog 