Recent Comments
Category Archives: Excel
Excel, ALGLIB, C# and ExcelDNA
Having just responded to a comment, saying I would be focussing on Add-in Express, rather than ExcelDNA, I have just found a blog post about using the ALGLIB C# routines in Excel, with the aid of ExcelDNA: Parcell’s Posts; Tutorial: … Continue reading
Route Map …
… so we know where we are going. I’ll be starting several, to some extent interlinked, new themes in this blog over the coming weeks. Firstly VBA Classes. Regular readers may have noticed that my VBA code tends to be … Continue reading
Posted in AlgLib, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, VBA
Tagged Addin Express, AlgLib, Drawing in Excel, Reinforced Concrete, Strand7, VBA classes
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
ALGLIB Statistics Functions
I have recently imported all the ALGLIB statistics functions into VBA, and written interface functions where required, so that all the functions may now be used as User Defined Functions (UDFs) on the spreadsheet. A spreadsheet including full open source code … Continue reading
Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, math functions, statistics, UDF, VBA
4 Comments
