Recent Comments
Author Archives: dougaj4
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
Interactive File List
Microsoft recently introduced the facility to embed a link to a live spreadsheet stored on Windows Skydrive. This is my first attempt to use this facility. The spreadsheet below is a list of all the files published on this blog, together … Continue reading
Update to Beam1 and Beam2
It has just been pointed out that the single span beam spreadsheet presented at Frame Analysis with Excel 1 does not work for a propped cantilever. The same applies to the spreadsheet for single span sloping beams at Frame Analysis with … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton
Tagged beam analysis, Excel, Frame Analysis
3 Comments
Faster Integration with the Tanh-Sinh Method
In my previous post about numerical integration I mentioned that I would be writing about another lesser known method providing better speed and/or accuracy in many cases. The method is known as Tanh-Sinh quadrature, and has been implemented in Excel by a reader … Continue reading
Posted in Excel, Maths, Numerical integration, UDFs, VBA
Tagged Excel, Gauss-Kronrod, numerical integration, Quadrature, Romberg, Tanh-Sinh, UDF, VBA
3 Comments
