Recent Comments
Tag Archives: Excel
Working with FEM data and using the dictionary object
This post features an Excel User Defined Function (UDF) to count the number of different element types (beams, plates, bricks and links) and the number of node restraints at each end of listed beams from a finite element model. The … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged dictionary object, Excel, FEA data, Strand7, UDF, VBA
5 Comments
Complex Numbers and Solving Quartic Polynomial Equations
It was recently pointed out to me that the User Defined Function (UDF) for solving quartic polynomial equations presented in this post returned an error for some input values. In tracking down the source of the error I decided that it … Continue reading
Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged complex numbers, Cubic, Excel, Polynomial, Quartic, UDF, VBA
3 Comments
Eval.xls and the ALGLIB integration functions.
In a comment on a previous post on numerical integration I mentioned that I might implement the ALGLIB integration functions using the same technique, that is using the VBA Evaluate function to evaluate functions entered as text in the spreadsheet. Well … Continue reading
Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged ALGLIB. Gauss-Kronrod, Eval.xls, Excel, UDA, VBA
4 Comments
2D Spline Interpolation with ALGLIB
I have updated the ALGLIB Spline and Matrix Function spreadsheet to include 2D interpolation of tabular data, including both linear and cubic spline interpolation. The spreadsheet including the new functions with full open source code may be downloaded from AL-Spline-Matrix03.zip … Continue reading
Depiction and Excel Webinar
Depiction is a low cost GIS program. I received an e-mail today that they are hosting a webinar on using Depiction with Excel from 10-11 AM PDT on Wed 18th August. Click here for details. Looks interesting, but it’s 3:00-4:00 … Continue reading
