Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Cubic Splines
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Daily Download 4: Continuous Beam Analysis
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
Recent Comments
Category Archives: Newton
Dynamically Defined Dancing Pendulums
Following the previous post, I have re-created the animation using a non-linear dynamic analysis inside Strand7, rather than by feeding in the positions of each ball at each time step. The input using this approach is much simpler; just set … Continue reading
Posted in Finite Element Analysis, Newton
Tagged dynamic analysis, Pendulum animation, Strand7
2 Comments
Dancing Pendulums
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 animation, API, Pendulum patterns, Strand7
5 Comments
Bellows Falls Bridge
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 3 pin arch, Bellows Bridge, historic bridge, steel arch bridge
Leave a comment
Alternative IP and Rotations
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 defined names, Hypecube, IP, perspective projection
Leave a comment
Tanh-Sinh Quadrature V2.0
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 Excel, numerical integration, Tanh-Sinh method, UDF, VBA
2 Comments