Category Archives: Excel

Adding Function Categories and Descriptions

Posted on 21/05/2009 by dougaj4

User defined functions (UDF’s) are by default added to the “User Defined” category in the function list, and when a UDF is selected the words “no help available” appear, rather than a description of the function and it’s parameters.  A rather … Continue reading →

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

Some string functions

Posted on 15/05/2009 by dougaj4

It was pointed out in a comment to this post at Daily Dose of Excel that VBA has a StrReverse function that will (logically enough) reverse a string.  That’s not awfully useful to me (except maybe for Project Euler), but it … Continue reading →

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

Frame Analysis with Excel – 7; Shear deflections and support displacements

Posted on 11/05/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 6; Beam end releases and actions Download Frame4.zip – the download file includes complete open source code. Two more refinements have been added to the frame analysis spreadsheet: The stiffness matrix has been revised to … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 31 Comments

Finding square roots …

Posted on 06/05/2009 by dougaj4

… to 100 decimal places. Why would anyone want to do that? To solve Project Euler Problem 80: “It is well known that if the square root of a natural number is not an integer, then it is irrational. The … Continue reading →

Posted in Arrays, Excel, Maths, Newton, UDFs, VBA | 2 Comments

Moving Average Function

Posted on 04/05/2009 by dougaj4

The previous post presented a simple moving average user defined function (UDF).  This has been extended to provide additional functionality: A weighted average may be returned; either a linear weight with a specified step value, or a using any specified weighting … Continue reading →

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