Category Archives: Newton

Dancing Pendulums

Posted on 25/05/2011 by dougaj4

This animation was produced in response to a video of real pendulums performing similar tricks: Not having an animation program I thought I’d use the finite element program Strand7.  Modelling the pendulums was easy, just 15 beam elements with a … Continue reading →

Posted in Animation, Excel, Finite Element Analysis, Newton | Tagged , , , | 5 Comments

Bellows Falls Bridge

Posted on 12/05/2011 by dougaj4

Sparked by this excellent high resolution photo from the Shorpy collection, posted at Eng-Tips, and a comment that it was a three-pinned arch (coming from Wikipedia), I thought I would investigate further. Zooming in on the crown shows that there … Continue reading →

Posted in Arch structures, Historic Bridges, Newton | Tagged , , , | Leave a comment

Alternative IP and Rotations

Posted on 11/04/2011 by dougaj4

In response to the 3D Intersections and PView Function posts Lori Miller has sent me two very elegant alternative ways of achieving similar results. The first is an on-spreadsheet solution to the intersection of two lines, using the LinEst function: Note … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Excel | Tagged , , , | Leave a comment

Tanh-Sinh Quadrature V2.0

Posted on 04/04/2011 by dougaj4

I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading →

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

PView Function

Posted on 31/03/2011 by dougaj4

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 3 Comments