Recent Comments
Author Archives: dougaj4
Precise Angles and XNumbers
Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet. The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading
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
New Page
In an effort to make the information on this site easier to access I have collected all the “Daily Download” posts from last year onto a new page, listing each of the download posts by category. It’s called “Download by … 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
Newton Excel Bach, not (just) an Excel Blog 