Author Archives: dougaj4

Section properties for groups of defined shapes

Posted on 12/04/2013 by dougaj4

Following a discussion at Eng-Tips, I have modified the section properties spreadsheet (presented here) so that section properties can be found for groups of defined shapes, including provision for translation and rotation of each shape, and application of different E … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , | 13 Comments

George Gently, Matty Groves, and Ebony Buckle

Posted on 07/04/2013 by dougaj4

The George Gently episode “Gently With Class” (just shown in Australia) features an excellent rendition of the traditional song “Matty Groves” sung by Ebony Buckle: The song dates from at least the 17th Century ,and is  included in the ballads … Continue reading →

Posted in Bach | Tagged , , | 6 Comments

Installing dlls on 64 bit Windows

Posted on 28/03/2013 by dougaj4

Several of the spreadsheets available here include routines linking to compiled code written in C#, C++ or Fortran, which require the installation and registration of dll files.  The procedures for doing this are significantly different on machines with 64 bit … Continue reading →

Posted in Computing - general, Excel, Link to dll, VBA | Tagged , , , | 10 Comments

3DFrame Ver 1.03 and Frame4 Ver 3.07

Posted on 17/03/2013 by dougaj4

Updated versions of my 2D and 3D frame analysis spreadsheets are now available for download from: 3DFrame.zip Frame4.zip The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , | 34 Comments

Tanh-Sinh Quadrature V4.1

Posted on 16/03/2013 by dougaj4

The latest update to the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes is now available for download from: Tanh-Sinh. As usual, the download includes full open-source code and extensive documentation. Version 4.1 Release Notes  1.   Small but useful accuracy improvements have been … Continue reading →

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