Author Archives: dougaj4

IP2 Update, ByRef and ByVal

A recent comment pointed out that the IPPlaneLine function (intersection of a 3D line with a plane) in the IP2 spreadsheet was giving incorrect results.  This has now been fixed, and the corrected spreadsheet can be downloaded from IP2.zip. The problem turned out … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Newton, UDFs, VBA | Tagged , , , , , | 1 Comment

Tanh-Sinh Quadrature V2.1

Graeme Dennes has released another update to his Tanh-Sinh Quadrature spreadsheet, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code).  Here is Graeme’s description of the changes: In Version 2.0, the nodes and weights array data … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , | 2 Comments

Equivalent Stress Blocks

Previous posts (e.g. Stress blocks in AS 3600) have presented Excel User Defined Functions (UDFs) that determine the ultimate bending strength of a reinforced concrete section with the use of a rectangular concrete stress block, with depth and stress factors … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs | Tagged , , , , , , , | 4 Comments

A Very Relaxing Post

Another Bach installment, with (possibly) a splash of Newton: Scientists discover most relaxing tune ever A British band and a group of scientists have made the most relaxing tune in the history of man, an Mp3 of which is at … Continue reading →

Posted in Bach | Tagged , , | 1 Comment

Bert Jansch

Regulars here will know my liking for the music of Bert Jansch and his contemporaries.  Bert died after a long illness last Wednesday, but leaves behind a rich legacy of music usually categorised as “folk”, but really beyond categorisation. The 1992 BBC series “Acoustic … Continue reading →

Posted in Bach | Tagged , , , , , , | 2 Comments