Category Archives: VBA

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

Daily Download 10: Excel Digitiser

Posted on 26/09/2012 by dougaj4

See How to digitise a scanned image and Digitising logarithmic scales.  This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:

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