Tag Archives: Excel

AlgLib Spline function update

Posted on 30/06/2010 by dougaj4

Following a question at the AlgLib Forum I have added the Hermite spline fit function to the AL-Spline-Matrix collection. The revised spreadsheet, with full open source code is available for download in 2007/20010 version and pre-2007 version. Typical output of the … Continue reading →

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

More on buckling columns

Posted on 27/06/2010 by dougaj4

Coincidentally, at about the same time as I wrote about column buckling for a column with a point load on the end, Autar Kaw at The Numerical Methods Guy was writing about buckling of columns under self weight, using the theory of … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 1 Comment

Keyboard shortcuts

Posted on 22/06/2010 by dougaj4

Having been born and raised using a different spreadsheet I’m sometimes a bit set in my ways and don’t use keyboard shortcuts as much as I could.  The trouble is there are so many of them.   I’ve just discovered a list … Continue reading →

Posted in Excel | Tagged , , | 1 Comment

SplineBeam update

Posted on 20/06/2010 by dougaj4

Previous SplineBeam post I have modified the SplineBeam spreadsheet to allow input of a single span (simply supported or with end constraints), and to optionally allow input of the position of intermediate nodes, rather than dividing each span into equal segment lengths.  This … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

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