Category Archives: Excel

Copy and Paste as Picture

Posted on 18/10/2009 by dougaj4

If in Excel 2007 you copy a range to the clipboard and paste into Word as a picture you get the worksheet gridlines displayed, which may well not be what you want. This issue was raised at Smurf on Spreadsheets and … Continue reading →

Posted in Excel | Tagged , , | 10 Comments

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