Recent Comments
Category Archives: Newton
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 API, Excel, Node Functions, Strand7, UDF, VBA
5 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 animation, PM 2Ring, Pythagoras, wordless proof
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
VBA code generation on the spreadsheet
A previous post looked at using VBA to generate more VBA code. This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged API, code generation, Excel, Strand7, UDF, VBA
Leave a comment
The Switch Function (VBA and UDF)
Switch is a VBA function that operates in a similar way to the Select Case statement. The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading
Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged Excel, PY curves, Switch function, UDF, VBA
9 Comments
Newton Excel Bach, not (just) an Excel Blog 