Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Taming Symbols in Excel
- Using LINEST for non-linear curve fitting
- Downloads
- Writing Arrays to the worksheet - VBA function
Recent Comments
dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…
Tag Archives: numerical integration
Tanh-Sinh Quadrature V4.0
Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh method, UDF, VBA
6 Comments
Daily Download 17: Numerical Integration
Some simple numerical integration functions (using the trapezoidal rule and Simpson’s Rule) were included in the Eval2 spreadsheet, presented on Daily Download Day 15, but for purposes were better accuracy and/or higher speed are required more sophisticated methods will do a … Continue reading
Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged AlgLib, Eval function, Excel, Gauss-Kronrod, numerical integration, Tanh-Sinh method, UDF, VBA
Leave a comment
Daily Download 15: Evaluation of formulas in text
VBA has an Evaluate function that returns the numerical value of any text string representing a mathematical formula, but this is not directly available from the spreadsheet. Today’s download is a User Defined Function (UDF) to provide this functionality, together with examples … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Evaluate, evaluation of text strings, Excel, numerical integration, UDF, VBA
1 Comment
Tanh-Sinh Quadrature V3.0
I have received from Graeme Dennes another update to his Tanh-Sinh Quadrature spreadsheet, offering fast and convenient numerical integration functions. The spreadsheet can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: Tanh-Sinh Quadrature … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
5 Comments
Tanh-Sinh Quadrature V2.1
Graeme Dennes has released another update to his Tanh-Sinh Quadrature spreadsheet, which can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: In Version 2.0, the nodes and weights array data … Continue reading
Posted in Excel, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh method, UDF, VBA
2 Comments