Category Archives: Excel

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

Daily Download 23: Trigonometric Functions in VBA and Fortran

Posted on 09/10/2012 by dougaj4

The trigonometric functions provided in Excel omit some functions, and the functions provided in VBA are still more restricted.  Notably VBA does not provide an ATan2 function, which is required to define an angle over a full 360 degree range, based on X, … Continue reading →

Posted in Coordinate Geometry, Excel, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , | 8 Comments