Category Archives: Excel

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

Using the AlgLib ODE (Runge-Kutta) Solver with Excel

Posted on 18/06/2010 by dougaj4

Or to be more correct, the AlgLib Cash-Karp Solver, Cash-Karp being a refinement of the Runge-Kutta method of solving ordinary differential equations. Solution of differential equations is an iterative process requiring the repeated application of the solver routine followed by evaluation of … Continue reading →

Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 8 Comments

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