Recent Comments
Category Archives: VBA
Function roots with the Inverse Quadratic Method
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 Excel, quadratic interpolation, Solve polynomial, UDF, VBA
5 Comments
Transferring data with arrays
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
Tension Stiffening
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 Excel, moment curvature, Reinforced Concrete, tension stiffening, UDF, VBA
3 Comments
The speed of loops
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
Stringing more than two words together
It has always seemed strange to me that the Excel function Concatenate(), which has such a long name, provides no additional functionality over using the & operator. The TextString function is a simple User Defined Function (UDF) which provides the … Continue reading
Newton Excel Bach, not (just) an Excel Blog 