Category Archives: Excel

Comparing floating point numbers

Posted on 07/01/2012 by dougaj4

Some of the issues raised in this post: https://newtonexcelbach.wordpress.com/2011/12/20/when-does-35-not-equal-35/ arose when writing the functions for the previous post on combining arrays.  In particular, when values from the two arrays are “equal” the function should create one entry in the combined … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 4 Comments

Combining arrays

Posted on 05/01/2012 by dougaj4

Part of the Macaulay spreasheet presented in recent posts required the formation of a list of points along a beam where the functions needed to be evaluated.  These are: The support points, the changes of cross section, and the output … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 7 Comments

Continuous Beams with Shear Deflections

Posted on 31/12/2011 by dougaj4

The Macaulay Spreadsheet has now been modified to optionally include shear deflections, as well as a new option to output support reactions, and fixes to minor bugs. The revised spreadsheet (including full open source code) can be downloaded from: Macaulay.zip … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 10 Comments

When does 35 not equal 35?

Posted on 20/12/2011 by dougaj4

… and when does 35 – 35 not equal zero? In the first case the answer is when one “35” is on an Excel spreadsheet and the other 35 is in VBA.  The question arose from the ongoing continuous beam … Continue reading →

Posted in Excel, Maths, Newton, VBA | Tagged , , , | 12 Comments

Dynamic Excel on the Cloud With Javascript!

Posted on 16/12/2011 by dougaj4

I have previously linked to a spreadsheet stored on Skydrive, but I have been disappointed that the possibilities for using live spreadsheets are greatly limited by the lack of support for VBA.  It seems that Microsoft have now decided to provide … Continue reading →

Posted in Animation, Charts, Computing - general, Excel, Javascript | Tagged , , , | 1 Comment