Category Archives: UDFs

Getting concrete shrinkage right

Posted on 21/03/2015 by dougaj4

At the end of last year, very quietly, the commentary to the Australian Concrete Structures Code (AS 3600) was published.  The commentary provides a wide range of explanatory and background information to the requirements in the main code, including some … Continue reading →

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

Slicing Arrays with VBA

Posted on 20/02/2015 by dougaj4

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 7 Comments

Beams may kiss, but do not hug …

Posted on 09/02/2015 by dougaj4

… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Numerical Integration; Tanh-Sinh Quadrature v. 4.3

Posted on 29/12/2014 by dougaj4

A new version (4.3) of the numerical integration spreadsheet by Graeme Dennes is now available for download from Tanh_Sinh Quadrature. The Tanh-Sinh Quadrature Version 4.3 workbook now provides a feature for the integration of integrands contained in independent (external) UDFs. … Continue reading →

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

Numpy and Scipy for Excel

Posted on 14/12/2014 by dougaj4

The Python Numpy and Scipy libraries contain a huge number of maths and science related functions.  Most of these are not directly available from Excel, but using the free ExcelPython package it is fairly easy to make the link, vastly increasing … Continue reading →

Posted in Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | 11 Comments