Category Archives: VBA

Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Posted on November 23, 2018 by

Update 27 Nov 2018: Version 4.41 now available from the link below, with minor modifications for compatibility with Excel 2007. I recently received a new version (4.4) of the numerical integration spreadsheet by Graeme Dennes which is now available for … Continue reading →

Posted in Charts, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , , | 9 Comments

AS 3600 and RC Design Functions 8.01

Posted on November 13, 2018 by

The updated RC Design Functions spreadsheet (presented here) included an updated UMom function to find the ultimate strength of a rectangular section under combined bending and axial load; but I omitted to include the revisions to the alpha2 and Gamma … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

More iterative solvers

Posted on October 28, 2018 by

Following the recent post on using Brent’s Method solvers on an array (Iterative solvers and arrays), here is another example with an engineering related problem.  The example is included in the xlScipy3 spreadsheet, which can be downloaded from: xlScipy3.zip The depth … Continue reading →

Posted in Arrays, Beam Bending, Concrete, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings | Tagged , , , , , , , , | Leave a comment

Iterative solvers and arrays

Posted on October 21, 2018 by

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 , , , , , , , | 1 Comment

New AS 3600 and RC Design Functions 8

Posted on September 23, 2018 by

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 September 9, 2018 by

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 August 31, 2018 by

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