Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Using LINEST for non-linear curve fitting
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- About Newton Excel Bach
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Downloads
- Daily Download 5: Frame Analysis
- Worksheetfunction.Transpose - changed behaviour in Excel 2013 and 2016
Recent Comments
Tag Archives: AlgLib
Compiled AlgLib Matrix Functions for Excel
This post describes a series of matrix functions compiled from the AlgLib library code (covered in previous posts) as a dll that can be called from Excel VBA, and used as User Defined Functions (UDFs). A spreadsheet containing the necessary VBA … Continue reading
Posted in Arrays, Excel, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, dll, Excel, Matrix Functions, UDF, VBA
18 Comments
Linking AlgLib C++ to Excel VBA
The previous post described how to install AlgLib VBA routines in Excel. It is also possible to make AlgLib c++ routines (compiled as dll’s) available from Excel, either from VBA, or using User Defined Functions (UDFs) directly from the spreadsheet. Using compiled dll … Continue reading
Posted in Excel, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, dll, eigen value, Excel, matrix inversion, UDF, VBA
4 Comments
Installing AlgLib with Excel VBA
In a previous post I linked to the AlgLib site which has an extensive range of mathematical routines available in VBA, c/c++ and pascal. I have recently been experimenting with these (in reponse to a thread at the Eng-Tips forum), and will … Continue reading
Posted in Arrays, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Eigen values, Excel, Inverse, linear algebra, Matrix, UDF, VBA
13 Comments