Category Archives: UDFs

Counting non-pecked chicks

Posted on 16/06/2017 by dougaj4

Download file:  Binary Chicks.zip. This post is based on a recent discussion at Cosmic Horizons looking at numerical methods to solve the following problem: The answer to the question is straightforward: With a little thought, you should be able to realise … Continue reading →

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

Taming Symbols in Excel

Posted on 08/06/2017 by dougaj4

You can enter an ASCII character in Excel (if you know the ASCII code) by holding  down the Alt key and entering the decimal code value on the numeric key pad.  This has two problems: It doesn’t work in Excel … Continue reading →

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

Update to Glob_to_loc3 and Loc_to_glob3 functions

Posted on 30/05/2017 by dougaj4

Following a comment here I have updated the Glob_to_loc3 and Loc_to_glob3 functions to deal with some problems when the local longitudinal axis is parallel to the global Y or Z axes.  The IP2 spreadsheet, including the revised functions, can be downloaded from: … Continue reading →

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 6 Comments

Working with milliseconds in Excel

Posted on 27/05/2017 by dougaj4

Edit 3rd Jan 2026: This download is not currently available. A recent post at Eng-Tips looked for a solution to problems with working with times in Excel, when time differences are required to the nearest millisecond. The problem is that although … Continue reading →

Posted in Computing - general, Excel, UDFs, VBA | Tagged , , , , , , | 1 Comment

RCInteract and RC Design Functions 7.03

Posted on 09/04/2017 by dougaj4

Since the previous post, I have updated the notes in the RC Design Functions spreadsheet to reflect the fact that with the recent update to the Bridge Design Code (AS 5100) the reinforced concrete strength design requirements for beam bending … Continue reading →

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