Author Archives: dougaj4

4 Year Report

As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading →

Posted in Excel | Tagged | Leave a comment

Strand7 API GetNode functions

As promised in this post, I have written and documented Excel User Defined Functions (UDFs) to interface with all the Strand7 API functions that return node attributes or results.  These 22 functions allow node attributes and results to be read directly … Continue reading →

Posted in Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , | 5 Comments

Embedding Skydrive worksheets in WordPress

On the Download page of this blog I have a list of files available for download, in the form of an Excel spreadsheet stored on the Microsoft Skydrive site.  I recently discovered that this link had stopped working, and that the … Continue reading →

Posted in Computing - general, Excel | Tagged , , , , | 9 Comments

Animated Pythagoras

Two animatations of a “wordless” proof of Pythaoras’ Theorem provided by SSSF regular PM 2Ring. This animation is a “wordless proof” of Pythagoras’ theorem. The basic design is an interlocking pattern of coloured squares overlaid with “shadow” squares. In most … Continue reading →

Posted in Animation, Maths, Newton | Tagged , , , | 4 Comments

Elegant solutions, 192 of them

The Edge is a place where they seek: To arrive at the edge of the world’s knowledge, seek out the most complex and sophisticated minds, put them in a room together, and have them ask each other the questions they … Continue reading →

Posted in Newton | Tagged , , | Leave a comment