Recent Comments
Category Archives: UDFs
Extracting a hyperlink
Excel does not have a function to extract the address from a cell containing a hyperlink. Here is a short UDF that will do the job: The original was a one-liner posted by Rick Rosthstein on Debra Dalgleish’s Contextures Blog. I … Continue reading
The angle between two vectors, in 2D or 3D
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 3D angle, angle between two vectors, cosine rule, Excel, UDF, VBA, vectors
9 Comments
Tanh-Sinh Quadrature V4.0
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 Excel, numerical integration, Tanh-Sinh method, UDF, VBA
6 Comments
Automating chart scale limits – update
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 Excel, plot function, set chart scale, UDF, VBA
13 Comments
Frame4; now with added Alglib
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 C# matrix functions, column buckling, Excel, Frame Analysis, link to dll, VBA
24 Comments
