Recent Comments
Category Archives: UDFs
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
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
Working with FEM data and using the dictionary object
This post features an Excel User Defined Function (UDF) to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model. The … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged dictionary object, Excel, FEA data, Strand7, UDF, VBA
5 Comments
PyXLL Links
This is really just a bookmark for me and anyone else who may be interested. “PyXLL is an Excel addin that enables functions written in Python to be called in Excel.” That’s all I know, but it looks interesting, and … Continue reading
