Category Archives: UDFs

The angle between two vectors, in 2D or 3D

Posted on 12/01/2013 by dougaj4

Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference.  In 3D it is not so obvious, but it can … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 9 Comments

Tanh-Sinh Quadrature V4.0

Posted on 03/01/2013 by dougaj4

Since last September Graeme Dennes has continued work on his Tanh-Sinh Quadrature spreadsheet, and has recently released Version 4.0, which can be downloaded from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. The new version includes routines … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 6 Comments

Automating chart scale limits – update

Posted on 25/11/2012 by dougaj4

I wrote about this function 2 1/2 years ago, and promptly forgot about it, but a few days ago brian provided an answer to a question that was raised shortly after it was first posted, concerning how to apply the function … Continue reading →

Posted in Charts, Excel, UDFs, VBA | Tagged , , , , | 13 Comments

Frame4; now with added Alglib

Posted on 16/11/2012 by dougaj4

Edit 29 Nov 2012: I have now added an xls version to the download zip file.  This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Using Regasm.exe

Posted on 13/11/2012 by dougaj4

If you work through the process described in the previous post Visual Studio will create two files (ALMatrixLib.tlb and ALMatrixLib.dll) that will automatically be registered so that the Excel VBA routines will be able to use them.  On the other hand if … Continue reading →

Posted in Excel, Link to dll, UDFs, VBA | Tagged , , , , , | 7 Comments