Category Archives: VBA

Iterative solvers and arrays

Posted on 21/10/2018 by dougaj4

A recent thread at Eng-Tips was looking for a solution to the problem described  below: The solutions to this problem described below can be downloaded from: ItSolve.zip and xlScipy3.zip The ItSolve.xlsb spreadsheet contains a user defined function (UDF) to solve iterative … Continue reading →

Posted in Arrays, Charts, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , | 2 Comments

New AS 3600 and RC Design Functions 8

Posted on 23/09/2018 by dougaj4

A revised version of the Australian Concrete Structures code, AS 3600, was recently published, with many significant changes, including: Changes to ULS reduction Factors Creep and shrinkage Curvature and deflection calculations Crack width calculation and stress limits Major  changes to … Continue reading →

Posted in Concrete, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Arc-spline update

Posted on 09/09/2018 by dougaj4

The input for the first version of the Arcspline function required the coordinates of the centre of each arc, as well as the angle of the tangents at each end of the arc.  I have now added a new version with … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 7 Comments

Using Redim and 3DFrame

Posted on 31/08/2018 by dougaj4

I recently received a query about the 3DFrame spreadsheet failing to run.  The problem was that the code was trying to Redim an array that had not been previously created with a Dim statement.  This does not cause a problem … Continue reading →

Posted in Excel, Frame Analysis, VBA | Tagged , , , | 1 Comment

Using VBA Evaluate as an Array Function

Posted on 24/08/2018 by dougaj4

I recently discovered from a thread at  Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function.  As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , | 2 Comments