Recent Comments
Tag Archives: Excel
Charts and Charting
I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading
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
Newton Excel Bach, not (just) an Excel Blog 