Category Archives: VBA

Daily Download 15: Evaluation of formulas in text

Posted on 01/10/2012 by dougaj4

VBA has an Evaluate function that returns the numerical value of any text string representing a mathematical formula, but this is not directly available from the spreadsheet.  Today’s download is a User Defined Function (UDF) to provide this functionality, together with examples … Continue reading →

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

Daily Download 14: Curve Fitting 1

Posted on 01/10/2012 by dougaj4

Today’s download topic covers fitting a straight line or curve to scattered data, using the “least squares” method.  Fitting a spline curve to pass exactly through a series of points will be covered in a few days. Use of the … Continue reading →

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

Daily Download 13: The ALGLIB maths library and Excel

Posted on 30/09/2012 by dougaj4

Today we move onto maths related downloads, starting with the ALGLIB maths library, which has featured here quite frequently: Original post with link to site: ALGLIB Installing AlgLib with Excel VBA Download files: http://interactiveds.com.au/software/AL-Matrix-xlsb.zip   http://interactiveds.com.au/software/AL-Matrix-xls.zip Linking AlgLib C++ to Excel … Continue reading →

Posted in AlgLib, Arrays, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 7 Comments

Daily Download 12: ImageMagick and Excel

Posted on 28/09/2012 by dougaj4

Today’s download provides a simple way of adding images to Excel from a list of file names, using the freeware program ImageMagick. See ImageMagick and Excel and ImageMagick – Update and add IrfanView link Download file:  http://www.interactiveds.com.au/software/PastePic.zip

Posted in Computing - general, Excel, VBA | Tagged , , , | 1 Comment

Daily Download 11: Perspective Projection

Posted on 27/09/2012 by dougaj4

The last of the daily downloads dealing with drawing is an extension of the drawing spreadsheet providing 3D perspective projection of wireframes defined by lists of 3D coordinates and connected points.  The spreadsheet was described in:Drawing in Excel 9 – … Continue reading →

Posted in Drawing, Excel, VBA | 1 Comment