Author Archives: dougaj4

Two new blogs

Two new Excel/computer related blogs that I have found recently are: Useful Gyaan (Sharing Stuff to Make life @ work easier) and MS EXCEL UNPLUGGED (which looks like a good resource on using pivot tables) In the near future I will be … Continue reading →

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

Writing an array function from VBA

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

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 …

… 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

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