Author Archives: dougaj4

Function roots with the Inverse Quadratic Method

Posted on 31/03/2010 by dougaj4

An earlier post presented various methods for finding the roots of polynomial functions based on the use of linear interpolation.  It is sometimes advantageous to use a quadratic interpolation function, and methods using this approach will be presented in this and following … Continue reading →

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

Transferring data with arrays

Posted on 22/03/2010 by dougaj4

The earlier post: Transferring data within VBA looked at some important aspects of transferring data between subroutines in Excel VBA.  This post will look at arrays in particular, and some peculiarities that affect the way they work. VBA arrays are a very … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , , , , | Leave a comment

Tension Stiffening

Posted on 12/03/2010 by dougaj4

Tension Stiffening in reinforced concrete is the increase in stiffness of a cracked member due to the development of tensile stresses in the concrete between the cracks.  The main application of tension stiffening theory in design applications is in the … Continue reading →

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

The speed of loops

Posted on 07/03/2010 by dougaj4

Commenting on the Good Practice post, John Tolle pointed out that with a collection it was very much quicker to loop using a For each loop than iterating by index, using a for, next loop.  I did some simple tests on this, … Continue reading →

Posted in Arrays, Excel, VBA | Tagged , , , , , | 8 Comments

A post about everything …

Posted on 03/03/2010 by dougaj4

… according to xkcd From the top down: … and deeper down:  

Posted in Newton | Tagged , , , | 3 Comments