Category Archives: UDFs

The hole through the middle of the Earth – filled with air

Posted on 13/08/2010 by dougaj4

Three air molecules go into a hole,  Well, I say three; could have been four or five.  Could have been nine or ten, doesn’t matter. Could have been fifteen, twenty – fifty. Round it up. Hundred. Let’s go mad, eh … Continue reading →

Posted in AlgLib, Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 4 Comments

AlgLib Complex Number Functions

Posted on 11/08/2010 by dougaj4

The AlgLib module ap.bas includes complex number functions which can be called from other VBA routines, but they cannot be used as User Defined Functions (UDFs)  because they use the user defined data type “Complex”: To  call these functions from the … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 2 Comments

Solving cubic and quartic equations with Excel

Posted on 04/08/2010 by dougaj4

Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs)  for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading →

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

The hole through the middle of the Earth – moved to the Equator

Posted on 02/08/2010 by dougaj4

Previous posts in this series assumed that the hole went from pole to pole, and ignored such complications as tidal effects and wobbles of the axis of rotation.  In this post we will examine the effect of moving the hole … Continue reading →

Posted in Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 2 Comments

Lateral pile analyis with PY curves …

Posted on 17/07/2010 by dougaj4

… and non-linear pile properties. In previous posts I have presented Excel User Defined Functions (UDFs) to analyse a laterally loaded pile, generate soil PY Curves based on the recommendations in the COM624 Manual, and determine the flexural stiffness of cracked … Continue reading →

Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 17 Comments