Tag Archives: Excel

Continuous beam analysis with cubic splines

Posted on 05/07/2009 by dougaj4

The last example in the previous post illustrated the use of cubic splines to find the bending moments in a continuous beam subject to prescribed lateral displacements.  A similar technique can be used to find bending moments, shear forces, reactions, … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 9 Comments

Cubic Splines

Posted on 02/07/2009 by dougaj4

Cubic splines are used to fit a smooth curve to a series of points with a piecewise series of cubic polynomial curves.  In addition to their use in interpolation, they are of particular interest to engineers because the spline is … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, VBA | Tagged , , , , | 73 Comments

Adding Function Categories and Descriptions

Posted on 21/05/2009 by dougaj4

User defined functions (UDF’s) are by default added to the “User Defined” category in the function list, and when a UDF is selected the words “no help available” appear, rather than a description of the function and it’s parameters.  A rather … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , | 3 Comments

Some string functions

Posted on 15/05/2009 by dougaj4

It was pointed out in a comment to this post at Daily Dose of Excel that VBA has a StrReverse function that will (logically enough) reverse a string.  That’s not awfully useful to me (except maybe for Project Euler), but it … Continue reading →

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

Frame Analysis with Excel – 7; Shear deflections and support displacements

Posted on 11/05/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 31 Comments