Category Archives: VBA

Reinforced Concrete Moment-Curvature – 4; Development of curvature over time

Posted on 12/02/2010 by dougaj4

The previous post in this series looked at how specified shrinkage and creep strains affect the curvature of a reinforced consrete section subject to a constant load.  In this post I will present a User Defined Function (UDF) that analyses … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , | 6 Comments

Hello World (again)

Posted on 02/02/2010 by dougaj4

Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading →

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

Good practice, best practice, or just practice?

Posted on 15/01/2010 by dougaj4

Browsing the ‘net this morning I found the “Golden Rules” listed below at Ozgrid.com The rules are described as things that “should not be optional”, which seemed to me in some cases to be going way too far, since for many … Continue reading →

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

Perfect Anniversaries

Posted on 13/01/2010 by dougaj4

The young author of  The Math Less Travelled has just celebrated his 28 birthday, noting that 28 is a perfect number.  He laments that since the next perfect number is 496, it is most unlikely that he will see another perfect … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | Leave a comment

Frame4.xls – Update2

Posted on 31/12/2009 by dougaj4

It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis.  The problem turned out to be that the analysis did not have any restraint specified in the X direction, … Continue reading →

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