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 VBA
Download file: http://interactiveds.com.au/software/AL-Matrixdll.zip

Compiled AlgLib Matrix Functions for Excel
Download file: http://interactiveds.com.au/software/AL-Matrixdll2.zip

ALGLIB Statistics Functions
Download file: http://interactiveds.com.au/software/AL-Stats.zip

AlgLib Complex Number Functions
Download file: http://interactiveds.com.au/software/AL-Complex.xls

AlgLib Spline Functions
2D Spline Interpolation with ALGLIB
Download files: http://interactiveds.com.au/software/AL-Spline-Matrix07.zip  http://interactiveds.com.au/software/AL-Spline-Matrix03.zip

Note that all the spreadsheets listed above link to Ver 2.6 of the ALGLIB library, which is the latest release in VBA.  At some stage I will link to later versions, which are available in C++, C#, VB.Net, and various flavours of Python, but the currently available VBA library remains a valuable resource, greatly extending the maths functionality available directly from Excel, and offering far better performance for maths intensive operations such as matrix functions.

Update Dec 2013:

Functions linking to the C# version of Alglib can be found at Compiled Matrix Functions for Excel; download file: http://www.interactiveds.com.au/software/Matrixdll-c%23.zip

For those wishing to use any of the ALGLIB routines in commercial applications, please read and observe the Licence Agreement

Matrix Functions

Matrix Functions

Statistics Functions

2D Spline Functions

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 – Perspective Projection and the download files are:

http://interactiveds.com.au/software/Plotxyz-xlsb.zip
http://interactiveds.com.au/software/Plotxyz-xls.zip

This was used to plot a Buckyball in: Drawing a Buckyball in Excel , with download file:

http://interactiveds.com.au/software/PlotBuckyBall.xlsb

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

Musical Interlude – John Martyn and Danny Thopmpson

Posted on 26/09/2012 by dougaj4

This clip was published on YouTube in June of this year and had just 300 views so far.

From Series 1 of the “Transatlantic Sessions” recorded in 1995: http://en.wikipedia.org/wiki/Transatlantic_Sessions

Posted in Bach | Tagged , , , | Leave a comment