Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- Writing Arrays to the worksheet - VBA function
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Contour plots with Excel and Matplotlib
- About Newton Excel Bach
- Latex Maths Text in Excel
- Converting from global to local coordinates (and vice versa)
- Installing Python and pyxll from scratch
Recent Comments
Author Archives: dougaj4
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
ShowReel …
… from my daughter Kerinne Jenkins ShowReel from Kerinne Jenkins on Vimeo. Including shots from: Precious (Short film) Culling (AFTRS Short film) Sweetness Follows (Short film) Music Videos from Sweet Teeth, The Perishers and The Former Love.
Posted in Bach, Films
Tagged AFTRS, Culling, Precious, Sweet Teeth, The Former Love, The Perishers
Leave a comment
Retrieving unique values from a range or array …
… using the Scripting Dictionary object. in a previous post I looked at using the dictionary object to count connected elements in a finite element model. This post looks at a more general (and simpler) usage to return unique values from … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged Excel, Scripting dictionary, UDF, unique items, VBA
20 Comments