Author Archives: dougaj4

Writing an array function from VBA

Posted on 09/06/2013 by dougaj4

I have covered the topic of writing VBA arrays to a spreadsheet range quite frequently here.  As a reminder, the procedure is: ReDim myarray(1 To NumArrayRows, 1 To NumArrayColumns) ‘ Fill array With Range(“MyNamedRange”) .ClearContents .Resize(NumArrayRows, NumArrayColumns).Name = “MyNamedRange” End … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Using RC Design Functions – 3

Posted on 08/06/2013 by dougaj4

In the previous post in this series I looked at the results available from the EStress function in the RC Design Functions spreadsheet.  Three associated functions are: EstressCap PLCurve TStiff EStressCap finds the maximum bending moment for a specified axial load, … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , | 1 Comment

Bridge Design, Beyond the Basics …

Posted on 03/06/2013 by dougaj4

… is the name of a series of full-day seminars that I will be presenting around Australia (together with two other bridge engineers), for the Concrete Institute of Australia, starting in Sydney next Wednesday, 12th June. Click below for details: Amongst the … Continue reading →

Posted in Arch structures, Concrete, Newton | Tagged , , , , | Leave a comment

Recently discovered (and rediscovered) links

Posted on 25/05/2013 by dougaj4

Math ∩ Programming – A place for elegant solutions (another Alfred Vachris link) About the Author My name is Jeremy Kun. I’m currently a mathematics PhD student at the University of Illinois in Chicago, and I did my undergraduate at Cal Poly … Continue reading →

Posted in Arch structures, Dome Structures, Newton | Tagged , , , , , , | Leave a comment

Using Goal Seek on a multi-column range

Posted on 20/05/2013 by dougaj4

Following a comment requesting help using my Goal Seek spreadsheet I have modified the macro to allow it to operate on a multi-column range.  The spreadsheet can be downloaded from GSeek.zip, including the solution to the problem described below. The … Continue reading →

Posted in Excel, VBA | Tagged , , , | Leave a comment