Recent Comments
Author Archives: dougaj4
Counting unique values from a range or array
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
New Release Alglib Library
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 AlgLib, Excel, link to dll, sparse solver
Leave a comment
3DFrame – 3D Frame analysis for Excel
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 3D frame analysis, Excel, sparse solver, Spreadsheet frame analysis, VBA
21 Comments
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
Defining beam orientation in 3D
The principal axes of a beam (or any 2D closed shape) are defined as the axes along which an applied load will not cause any deflection in the transverse direction. In mathematical terms, if the beam cross-section is defined in the … Continue reading
