Tag Archives: UDF

Tanh-Sinh Quadrature V2.1

Posted on 27/10/2011 by dougaj4

Graeme Dennes has released another update to his Tanh-Sinh Quadrature spreadsheet, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code).  Here is Graeme’s description of the changes: In Version 2.0, the nodes and weights array data … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments

Equivalent Stress Blocks

Posted on 19/10/2011 by dougaj4

Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading →

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

Using the Strand7 API

Posted on 23/09/2011 by dougaj4

Strand7 is a general purpose Finite Element Analysis program, which has an Application Programming Interface (API), allowing external programs to interact with Strand7, including reading and writing to data files, running analyses, and reading the results.  The API is a comprehensive … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , | 7 Comments

Using Beam Design Functions

Posted on 07/09/2011 by dougaj4

“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading →

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

Spline Interpolation Alternatives

Posted on 04/09/2011 by dougaj4

A recent post at Jon Peltier’s Blog looks at an “on-sheet” method of performing linear interpolation on a set of tabular data, and the following comments include a number of alternative ways of carrying out the same process, and also some … Continue reading →

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