Tag Archives: UDF

ConbeamU Update; defined support deflections

Posted on 03/04/2015 by dougaj4

As promised in a recent post, I have updated the ConBeamU spreadsheet to allow defined deflections to be specified at any support. The new spreadsheet (including full open-source code), can be downloaded from ConBeamU.zip In addition to the support deflections the … Continue reading →

Posted in Arrays, Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , , , | 12 Comments

Getting concrete shrinkage right

Posted on 21/03/2015 by dougaj4

At the end of last year, very quietly, the commentary to the Australian Concrete Structures Code (AS 3600) was published.  The commentary provides a wide range of explanatory and background information to the requirements in the main code, including some … Continue reading →

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

Pi day of the Century

Posted on 14/03/2015 by dougaj4

In North America, where today is 3-14-15, it is Pi day, and since there are not 31 days in April, the rest of us have to go along with that as well. Not only is it Pi day, it’s the … Continue reading →

Posted in Charts, Excel, Maths, Newton | Tagged , , , , , | 6 Comments

Continuous Beams with Specified Deflections

Posted on 26/02/2015 by dougaj4

A few weeks ago there was some discussion in a previous continuous beam post about how to analyse a continuous beam with specified deflections at the supports.  In this post I will look at three different ways of doing this … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment

Slicing Arrays with VBA

Posted on 20/02/2015 by dougaj4

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 7 Comments