Category Archives: Newton

Frame4 Version 3.04

Posted on 05/12/2012 by dougaj4

In preparation for adding 3D functionality to the Frame4 spreadsheet I have rearranged the load input sheet, and in doing so I noticed that the fixed end reaction calculation was incorrect for cases where loads were applied to one member over … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , | 1 Comment

Frame4; now with added Alglib

Posted on 16/11/2012 by dougaj4

Edit 29 Nov 2012: I have now added an xls version to the download zip file.  This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading →

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA | Tagged , , , , , | 24 Comments

Circle Limit III animation

Posted on 15/11/2012 by dougaj4

Enjoy: And papers by the artist on how to do it available at: http://bulatov.org/math/1107/ Update 16th Nov 12: Comments and more links from PM2Ring: That image is an example of a tessellation of the hyperbolic plane, in the Poincaré disc … Continue reading →

Posted in Animation, Bach, Newton | Tagged , , | Leave a comment

Compiled Matrix Functions for Excel

Posted on 12/11/2012 by dougaj4

This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding.  The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading →

Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , , , , | 4 Comments

Polynomial Update

Posted on 30/10/2012 by dougaj4

Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , | 12 Comments