Tag Archives: UDF

Numerical Integration; Tanh-Sinh Quadrature v. 4.4

Posted on 23/11/2018 by dougaj4

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 13/11/2018 by dougaj4

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

Arcs and arc-splines

Posted on 17/08/2018 by dougaj4

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single  arc, or a series of arcs connected (if necessary) by straight lines.  The new version may be downloaded from: IP2.zip As an example … Continue reading →

Posted in Animation, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 1 Comment

New Tricks …

Posted on 16/08/2018 by dougaj4

… or in some cases, old but forgotten tricks. The first comes from a Quora question, asking for the most underutilised feature in Excel. When de-bugging a VBA routine you can set a break point where the code will stop: … Continue reading →

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

VBA vs Power Query vs Python

Posted on 04/08/2018 by dougaj4

A recent post at Chandoo’s Excel Forum asked for a formula to extract all pairs of digits from a number with 4 digits.  This was soon extended to dealing with longer numbers, and the examples looked at here will work with … Continue reading →

Posted in Arrays, Excel, Link to Python, UDFs, VBA, xlwings | Tagged , , , , , , , | Leave a comment