Tag Archives: VBA

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 , , , , , | 4 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

Pi day of the Century

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

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