Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Converting from global to local coordinates (and vice versa)
- Biaxial bending update
- Smart Indenter and Excel 2013
- Fitting high order polynomials
Recent Comments
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