Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- RCInteract and RC Design Functions 7.03
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Tag Archives: Numerical methods
Gaussian Quadrature
The previous post on integration provided an Excel User Defined Function (UDF) to perform numerical integration using Simpson’s Rule or the Trapezoidal Rule. A third method is Gaussian Quadrature which is often much more accurate and/or quicker than Simpson’s Rule. The UDF GaussInt() … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Eval.xls, Excel, Gaussian Quadrature, Integration, Numerical methods, UDF, VBA
27 Comments