Category Archives: UDFs

Three UDFs

Posted on 05/10/2009 by dougaj4

This post is in response to recent discussions at Daily-Dose-of-Excel where many and various worksheet formulas have been suggested to carry out tasks that are (it seems to me) better done with a simple User Defined Function (UDF): Adding Every … Continue reading →

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

LatPile – Analysis of Lateral Loads on Piles

Posted on 26/09/2009 by dougaj4

This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles subject to horizontal loads, using the same approach as employed in the DOS program COM624. A spreadsheet including the UDF and an on-spreadsheet … Continue reading →

Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 11 Comments

Approximate Solutions of Polynomial Equations

Posted on 14/09/2009 by dougaj4

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel.  Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading →

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

Evaluating Polynomial Functions

Posted on 10/09/2009 by dougaj4

A polynomial function is a function of the form: a + b*x + c*x^2 + d*x^3 … and the derivative (the slope of the line at point x) of this function is given by: b + 2c*x + 3d*x^2 … … Continue reading →

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

Listing sheet names

Posted on 26/08/2009 by dougaj4

Answering my own question from the previous post, here is a short UDF that will return a list of worksheet names, starting with any chosen sheet:

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