Author Archives: dougaj4

Daily Download 28: The Hole Through the Middle of the Earth, using ODE solvers, and Three Blokes

Posted on 16/10/2012 by dougaj4

Today’s download is based on a series of posts on the “hole through the middle of the Earth”, which by devious means has been tied in with the solution of differential equations, buckling of columns, and a story by Bill … Continue reading →

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Daily Download 27: Miscellaneous

Posted on 15/10/2012 by dougaj4

Just some bits and pieces that don’t really fit in anywhere else today: Get your spreadsheet to talk to you at: Newton Excel Shakespeare Download: http://www.interactiveds.com.au/software/Text2Speech.xlsb Anniversaries gives you the tools to avoid missing significant anniversaries (and also to find the value … Continue reading →

Posted in Computing - general, Excel | Tagged , , , | Leave a comment

Daily Download 26: Moving averages and prime numbers

Posted on 13/10/2012 by dougaj4

Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Daily Download 25: Vector Functions

Posted on 12/10/2012 by dougaj4

Today’s download file provides a variety of vector arithmetic functions, which can be used either from other VBA routines, or on the spreadsheet as User Defined Functions. Download file: http://interactiveds.com.au/software/VectorFunc.xlsb In addition to Dot and Cross the spreadsheet contains the following … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | Leave a comment

Daily Download 24: Units for Excel

Posted on 11/10/2012 by dougaj4

The Units4Excel spreadsheet provides: User Defined Functions (UDFs) to convert between any listed units, including compound SI units. A UDF to evaluate any function entered as text, including evaluation of input and output units. Recognition of all standard SI prefixes. An … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment