Category Archives: Excel

Xll add-ins; are they worth the trouble?

Posted on 11/06/2010 by dougaj4

As regular readers will know, I occasionally delve into compiling code in C++, or even Fortran, as dlls and link to them with a short piece of VBA to communicate between the spreadsheet and the compiled code.  I have also … Continue reading →

Posted in Excel, Link to dll | Tagged , , , | 8 Comments

AlgLib Spline Functions

Posted on 07/06/2010 by dougaj4

Following earlier posts on cubic splines I have collected the Alglib interpolation routines, and the necessary supporting routines, and written interface functions to allow most of the 1Dspline routines to be called from the spreadsheet.  Since there is a large measure … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , | 6 Comments

P-Y Curve function

Posted on 02/06/2010 by dougaj4

The pile lateral load analysis program presented in a previous post used linear elastic spring supports to model the restraint provided by the soil.  Soil stress/strain behaviour is of course highly non-linear, and this post presents an Excel User Defined Function … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 21 Comments

New Links

Posted on 30/05/2010 by dougaj4

I have added some new links to Excel Blogs that are regularly updated with new and different content, plus one new maths blog. Bacon Bits: Delicious pieces of Excel and Access training brought to you by DataPigTechnologies.com Contextures Blog: The Contextures … Continue reading →

Posted in Excel, Maths | Tagged , , , | Leave a comment

Compiled AlgLib Matrix Functions for Excel

Posted on 27/05/2010 by dougaj4

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 , , , , , , | 18 Comments