Category Archives: Arrays

Using the DMax Function …

Posted on 09/09/2009 by dougaj4

… and an alternative. In this discussion at Eng-Tips I recommended the use of the DMAX() function to extract maximum values from data grouped with different text labels.  In the process I needed to adjust the selection criterion to generate the … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 4 Comments

Extracting data from a 3D range

Posted on 26/08/2009 by dougaj4

I recently needed to extract data from a series of tables on separate worksheets, into a form suitable for plotting on an XY graph.  In Lotus 123 this would be a piece of cake, since the Lotus @INDEX function has … Continue reading →

Posted in Arrays, Excel | Tagged , , , | 3 Comments

Continuous beam with varying stiffness

Posted on 23/08/2009 by dougaj4

Previous Splinebeam post One of my aims in developing the splinebeam function is to carry out non-linear analysis of reinforced concrete beams, allowing for the greatly reduced flexural stiffness of reinforced concrete sections after cracking of the concrete.  To that … Continue reading →

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

Continuous beam with specified end conditions …

Posted on 09/08/2009 by dougaj4

… and/or support displacements. The previous post in this series derived cubic splines with specified end conditions; either a specified curvature or a specified end slope. I have adapted the splinebeam function to allow input of specified end conditions (either a … Continue reading →

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

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