Category Archives: Excel

Concrete ULS spreadsheet update-2

Posted on 17/07/2013 by dougaj4

The concrete ULS design spreadsheet last posted at: Concrete ULS spreadsheet update has been updated to fix a problem encountered with non-symmetrical reinforcement using the Eurocode 2 rectangular stress block. Download from ULS Design Functions. Typical input and output interaction diagram are … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 11 Comments

Concrete ULS spreadsheet update

Posted on 10/07/2013 by dougaj4

The ULS Design Functions spreadsheet has been updated with the addition of provision for the Eurocode 2 rectangular stress block.  The new spreadsheet can be downloaded from:  ULS Design Functions.zip (including full open-source code). For more details see: ULS Analysis … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

Using Index() as an array function

Posted on 23/06/2013 by dougaj4

As promised, this post looks at using the Excel built in Index() function to operate on arrays; it also provides a VBA user defined function (UDF), VBIndex, which simplifies working with arrays within VBA, and also provides improved functionality when … Continue reading →

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

Two new blogs

Posted on 17/06/2013 by dougaj4

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

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