Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Automating chart scale limits - update
- Frame Analysis with Excel - 3, Continuous beam or frame
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Writing Arrays to the worksheet - VBA function
Recent Comments
Category Archives: Newton
Tanh-Sinh Quadrature Update 2
I have copied the latest version of Graeme Dennes’ Tanh-Sinh Quadrature spreadsheet to my download site: Click here to download Tanh-Sinh.zip As before, the download includes full open-source code, and detailed notes by Graeme. In the new version the Gauss-Kronrod function … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
4 Comments
The structural analysis of domes: From Pantheon until Reichstag
An interesting paper with technical details of several historical domed structures, available for free download, from Dokuz Eylul University, Izmir, Turkey: The structural analysis of domes
Revision to CSpline2.xls
It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003. It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading
Posted in Drawing, Excel, Maths, UDFs, VBA
Tagged bug fix, ChartSpline function, Cubic spline
6 Comments
Stress blocks in AS 3600
The long awaited update to the Australian Standard for concrete structures (AS 3600 – 2009) provides rules for the design of structures with concrete up to a compressive strength of 100 MPa. Unfortunately there are a number of significant typographical errors … Continue reading
Tanh-Sinh Quadrature update
Graeme Dennes has been continuing work on his Tanh-Sinh Quadrature function, and recently sent me a revised version, which can be downloaded from: Tanh-Sinh.zip The main change is a new automatic tolerance adjustment feature which automatically increases the tolerance for … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
9 Comments