Recent Comments
Category Archives: UDFs
Beware of the mod
Playing with a simple VBA user defined function (UDF), inspired by a thread at Daily Dose of Excel, I was finding it was mysteriously giving the wrong answer. The task was to find the angle between the hands of an … Continue reading
Calling Add-in functions from VBA
When an Excel add-in is active any User Defined Functions (UDFs) in the add-in are available to any other open worksheet. It might be expected that the same would apply to VBA routines defined in other files, but if you … Continue reading
Tanh-Sinh Quadrature V2.0
I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh method, UDF, VBA
2 Comments
PView Function
As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading
Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA
Tagged Excel, perspective projection, PView, rotation matrix, UDF, VBA, XY chart
3 Comments
More 3D Intersections and 3D plotting function
Following the previous post, I have added several new functions connected with intersections of lines and planes, and a function to generate a perspective plot from 3D coordinates. The new functions have been added to the IP2.xls worksheet, which can … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, intersections, IP2.xls, lines, perspective view, planes, UDF, VBA
7 Comments
Newton Excel Bach, not (just) an Excel Blog 