Category Archives: Maths

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

Daily Download 21: Assorted Solvers

Posted on 08/10/2012 by dougaj4

Today’s download starts with some simple linear interpolation methods used to solve polynomial equations, leading on to more sophisticated methods using quadratic or inverse quadratic interpolation. Also included is a solver for differential equations using the Cash-Karp Method, which is … Continue reading →

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

Daily Download 20: Section Properties

Posted on 06/10/2012 by dougaj4

The download spreadsheets today provide functions to find section properties of shapes either defined by coordinates or selected from a list of shape types.  The section properties found are: area, first and second moments of area about the X and Y … Continue reading →

Posted in Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | Leave a comment