Category Archives: Newton

Mohr’s Circle and Plate Stresses and Actions

Posted on 27/10/2012 by dougaj4

The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading →

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA | Tagged , , , , , , | 1 Comment

Ghost Stories

Posted on 22/10/2012 by dougaj4

The first video was directed by my daughter whilst at the Australian Film Television and Radio School last year, and weaves together stories of hard times in the early days of Sydney’s Newtown district: Plug in the headphones, switch off … Continue reading →

Posted in Bach, Excel, Films, Newton | Tagged , , , | 1 Comment

Daily Download 31: Linking to Fortran

Posted on 18/10/2012 by dougaj4

Several routines linking to Fortran dll files, produced with the Silverfrost Fortran compiler, have been provided in previous daily downloads.  Today’s files are example routines, provided with posts covering the procedures to link Excel to Fortran code.  Note that these files … Continue reading →

Posted in Computing - general, Excel, Fortran, Link to dll, UDFs, VBA | Tagged , , , , , | Leave a comment

Daily Download 28: The Hole Through the Middle of the Earth, using ODE solvers, and Three Blokes

Posted on 16/10/2012 by dougaj4

Today’s download is based on a series of posts on the “hole through the middle of the Earth”, which by devious means has been tied in with the solution of differential equations, buckling of columns, and a story by Bill … Continue reading →

Posted in Beam Bending, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Daily Download 26: Moving averages and prime numbers

Posted on 13/10/2012 by dougaj4

Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment