Category Archives: UDFs

Using RC Design Functions – 2

Posted on 18/05/2013 by dougaj4

In the previous post we looked at a summary of the functions in the RC Design Functions spreadsheet, and ways of using the EStress function (download file with examples).  In this post we will look in more detail at the … Continue reading →

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

Using RC Design Functions – 1

Posted on 10/05/2013 by dougaj4

Download RC Design Functions (includes full open source code) and EStress Examples.xlsx This series of posts will cover ways of using the many functions contained in the RC Design Functions spreadsheet, starting with some general comments on using the User … Continue reading →

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

Section properties for groups of defined shapes

Posted on 12/04/2013 by dougaj4

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading →

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

Tanh-Sinh Quadrature V4.1

Posted on 16/03/2013 by dougaj4

The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes  1.   Small but useful accuracy improvements have been … Continue reading →

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 1 Comment

what Microsoft think VBA is good for …

Posted on 06/03/2013 by dougaj4

The front page of Excel for Developers now has a link entitled VBA, which takes you to: VBA for Excel developers which has a link entitled When to use VBA and why which says: There are three principal reasons to consider VBA … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 9 Comments