Category Archives: Newton

Eval.xls and the ALGLIB integration functions.

Posted on 11/09/2010 by dougaj4

In a comment on a previous post on numerical integration I mentioned that I might implement the ALGLIB integration functions using the same technique, that is using the VBA Evaluate function to evaluate functions entered as text in the spreadsheet.  Well … Continue reading →

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

The Eden Project

Posted on 06/09/2010 by dougaj4

Continuing the Buckyball theme, The Eden Project in Cornwall, UK, is an old quarry  site converted to an environmental exhibition centre featuring three large dome structures: More details at the Galinsky site.

Posted in Newton | Tagged , , | Leave a comment

Drawing a Buckyball in Excel

Posted on 04/09/2010 by dougaj4

Since, according to Google, it is the 25th anniversary of the Buckyball, I thought I would draw one in Excel. A quick search found a list of coordinates here: Chemistry resources The problem then was, how to connect them.  The information … Continue reading →

Posted in Drawing, Excel, Maths | Tagged , | 10 Comments

Excel, ALGLIB, C# and ExcelDNA

Posted on 01/09/2010 by dougaj4

Having just responded to a comment, saying I would be focussing on Add-in Express, rather than ExcelDNA, I have just found a blog post about using the ALGLIB C# routines in Excel, with the aid of ExcelDNA: Parcell’s Posts; Tutorial: … Continue reading →

Posted in Excel, Link to dll, Maths, VBA | Tagged , , , | Leave a comment

Route Map …

Posted on 29/08/2010 by dougaj4

… so we know where we are going. I’ll be starting several, to some extent interlinked, new themes in this blog over the coming weeks.  Firstly VBA Classes.  Regular readers may have noticed that my VBA code tends to be … Continue reading →

Posted in AlgLib, Concrete, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, VBA | Tagged , , , , , | 4 Comments