Recent Comments
Tag Archives: Excel
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
Transferring data within VBA
The use of inappropriate techniques for passing data between sub-routines and modules is probably one of the most frequent causes of error in VBA programs, but many text books provide little guidance on this subject, and what there is, is … Continue reading
Secondary axes in Excel 2007
Sometimes rarely used features in an application are so prominently placed that we become blind to them, and can’t find them when we need them. This happened to me recently with the procedure for assigning an Excel chart series to … Continue reading
