Category Archives: UDFs

Section Properties with MeshPY, including torsion and warping

Posted on 09/12/2017 by dougaj4

I recently discovered robbie van leeuwen’s structural engineering blog, which has an open-source set of Python routines for calculation of section properties, including torsion and warping constants.  The program uses the MeshPY Library for generating the finite element meshes required … Continue reading →

Posted in Beam Bending, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Strand7, UDFs, VBA, xlwings | Tagged , , , , , , , , | 11 Comments

Brent’s Method; Update and Examples

Posted on 06/12/2017 by dougaj4

Brent’s Method is a refinement of Newton’s Method for the numerical solution of any equation with one variable.  The User Defined Function (UDF) QuadBrent was described in:  The Inverse Quadratic Method 3 – Brent’s Method Following a recent question, I have … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 5 Comments

Update to AL-Spline-Matrix

Posted on 28/11/2017 by dougaj4

The AL-Spline-Matrix spreadsheet contains a large number of VBA user defined functions (UDFs) performing spline fitting and matrix operations, using the free and open source ALGLIB library. It was recently pointed out that the Excel interface code for the CSplineFitCW1da … Continue reading →

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

Composite Beam Spreadsheet Update 1.01

Posted on 04/11/2017 by dougaj4

Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top.  The output has also been … Continue reading →

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

Using Flash Fill

Posted on 14/10/2017 by dougaj4

There have been several posts here on using functions or user defined functions (UDFs) to extract text or numbers from a longer string (most recently, here), but for many purposes it is quicker and easier to use the “flash-fill” feature, … Continue reading →

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