Recent Comments
Tag Archives: VBA
Three UDFs
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
LatPile – Analysis of Lateral Loads on Piles
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 COM624, Excel, Laterally loaded pile, LPile, UDF, VBA
11 Comments
Approximate Solutions of Polynomial Equations
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 Cubic, Excel, Newton-Raphson Method, Polynomial, Quartic, UDA, VBA
3 Comments
Evaluating Polynomial Functions
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
Randomising a list
A list can be sorted into random order by inserting a list of random numbers in an adjacent column and sorting both columns on the random number column. A similar procedure can be carried out through a VBA subroutine, avoiding … Continue reading
