Category Archives: Excel

Frame4; now with added Alglib

Posted on 16/11/2012 by dougaj4

Edit 29 Nov 2012: I have now added an xls version to the download zip file.  This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Circle Limit III animation

Posted on 15/11/2012 by dougaj4

Enjoy: And papers by the artist on how to do it available at: http://bulatov.org/math/1107/ Update 16th Nov 12: Comments and more links from PM2Ring: That image is an example of a tessellation of the hyperbolic plane, in the Poincaré disc … Continue reading →

Posted in Animation, Bach, Newton | Tagged , , | Leave a comment

Using Regasm.exe

Posted on 13/11/2012 by dougaj4

If you work through the process described in the previous post Visual Studio will create two files (ALMatrixLib.tlb and ALMatrixLib.dll) that will automatically be registered so that the Excel VBA routines will be able to use them.  On the other hand if … Continue reading →

Posted in Excel, Link to dll, UDFs, VBA | Tagged , , , , , | 7 Comments

Compiled Matrix Functions for Excel

Posted on 12/11/2012 by dougaj4

This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding.  The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading →

Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 4 Comments

Links to link VBA to C#

Posted on 03/11/2012 by dougaj4

If you search the Internet for information on how to link Excel VBA to C# you will find thousands, if not millions, of links with details of how to connect to Excel from C#, but very few about going the … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , , , , | 11 Comments