Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Deflections and Moments in Rectangular Plates
- Lateral pile analyis with PY curves ...
- Downloads
Recent Comments
Category Archives: Numerical integration
SectionProperties update
In late 2017 I posted Section Properties with MeshPY, including torsion and warping which looked at an Excel front end for Robbie van Leeuwen’s SectionProperties program, which provides facilities for calculation of section properties of complex shapes, including torsion and warping constants. … Continue reading
Posted in Charts, Excel, Finite Element Analysis, Link to Python, Newton, Numerical integration, NumPy and SciPy, PyXLL, Strand7
Tagged Excel, Python, PyXLL, Section-Properties, Torsion
1 Comment
Tanh-Sinh Quadrature v. 5.03
Following some recent comments Graeme Dennes has released the latest version the Tanh-Sinh Quadrature spreadsheet with some corrections to the test function documentation. The new file is located (as before) at: Tanh-Sinh Quadrature For more information on the last major release … Continue reading
Tanh-Sinh Quadrature update
Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Tanh-Sinh Quadrature, UDFs, VBA
Leave a comment
Numerical Integration With Tanh-Sinh Quadrature v 5.0
Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to V 5.0. The new version (including full open source code) may be downloaded from: Tanh-Sinh Quadrature Graeme’s summary of the new features in the spreadsheet: The Tanh-Sinh quadrature workbook has been … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs
13 Comments
Numerical integration with on-sheet calculations
Following a comment here I have prepared a spreadsheet that works through the Tanh-Sinh Quadrature process with on-sheet calculations. For that purpose Graeme Dennes has provided a simplified version of the code: QUAD_RODRIGUEZ_TANH_SINH for finite intervals. Translated from HP RPN … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs, VBA
10 Comments