Author Archives: dougaj4

The history of the theory of beam bending – Part 1

Posted on 27/02/2008 by dougaj4

The theory of the flexural strength and stiffness of beams is now attributed to Bernoulli and Euler, but developed over almost 400 years, with several twists, turns and dead ends on the way. Galileo Galilei is often credited with the first … Continue reading →

Posted in Beam Bending, Newton | Tagged , , , , , , , | 10 Comments

Worksheetfunction vs UDF

Posted on 23/02/2008 by dougaj4

The previous post provided VBA code for a number of trigonometric functions, most of which are already available in Excel.  Why bother you may say, why not just use the WorksheetFunction object?  The numbers below provide the answer: Time to … Continue reading →

Posted in Excel, UDFs | Tagged | 7 Comments

Trigonometric Functions in VBA

Posted on 23/02/2008 by dougaj4

Deep within the bowels of the Microsoft on-line help can be found: http://msdn2.microsoft.com/en-us/library/csfk8t62(VS.85).aspx which lists  the derivation of trigonometric functions not provided by VBA.  Not included in this list is ATan2(), which is strange because this is the one trigonometric … Continue reading →

Posted in Excel, Maths, UDFs | Tagged | 7 Comments

Hello World in a UDF

Posted on 21/02/2008 by dougaj4

An Excel User Defined Function (UDF) is probably the single most useful feature that remains unused by the majority of users. This post will provide a brief introduction with the obligatory “Hellow World” program, followed by something only a little … Continue reading →

Posted in Excel, UDFs | Tagged , | 4 Comments