Category Archives: UDFs

Re-sizing Array Functions

The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading

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

ConbeamU Update Update

Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one.  The new version number is … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 3 Comments

ConbeamU Update; defined support deflections

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

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

Slicing Arrays with VBA

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