Recent Comments
Category Archives: UDFs
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
Complex Numbers and Solving Quartic Polynomial Equations
It was recently pointed out to me that the User Defined Function (UDF) for solving quartic polynomial equations presented in this post returned an error for some input values. In tracking down the source of the error I decided that it … Continue reading
Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Cubic, Excel, Polynomial, Quartic, UDF, VBA
3 Comments
Newton Excel Bach, not (just) an Excel Blog 