Category Archives: Excel

Counting unique values from a range or array

Posted on 26/01/2013 by dougaj4

About this time last year, I posted a User Defined Function (UDF) that would return a list of unique items from a list: https://newtonexcelbach.wordpress.com/2012/01/31/retrieving-unique-values-from-a-range-or-array/ That post has recently received a few comments, and coincidentally Colin Legg at RAD Excel has … Continue reading →

Posted in Excel | Tagged , , , , | Leave a comment

New Release Alglib Library

Posted on 22/01/2013 by dougaj4

The Alglib Numerical Analysis Library has just been updated.  For full details of the changes see: http://www.alglib.net/arcnews.php#date_18_01_2013 , but the significant change for routines linking to my spreadsheets is that the sparse solver  has been significantly improved and now successfully solves problems … Continue reading →

Posted in AlgLib, Excel, Finite Element Analysis, Link to dll, Maths, Newton | Tagged , , , | Leave a comment

3DFrame – 3D Frame analysis for Excel

Posted on 22/01/2013 by dougaj4

I have now extended the Frame4 spreadsheet to deal with 3D frames.  As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 21 Comments

Extracting a hyperlink

Posted on 21/01/2013 by dougaj4

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 →

Posted in Excel, UDFs, VBA | Tagged , , , | Leave a comment

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