Category Archives: Excel

Brent’s Method and a daft engineer’s blog

Posted on 23/12/2016 by dougaj4

Browsing links on Brent’s Method I found: Daft Engineer – Numerical Methods and Excel* which is well worth a look (plenty of stuff on statistics and Python, with the odd dash of Excel).  The link has VBA code for a … Continue reading →

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

3D Frames, axes and stiffness matrices

Posted on 09/12/2016 by dougaj4

In the course of adding provision for spring end releases to the 3DFrame spreadsheet, I have also tidied up the code for generating the structure stiffness matrix, and added some documentation to the spreadsheet.  The revised spreadsheet (version 2.02) can … Continue reading →

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

3DFrame with spring releases

Posted on 02/12/2016 by dougaj4

Following the previous post I have added similar functionality to the 3DFrame spreadsheet.  The new file can be downloaded from: 3DFrame.zip As before, see Installing C# dll files, reminder for details of installing the supplied dll files, which provide much better … Continue reading →

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA | Tagged , , , , | 8 Comments

Frame analysis with spring releases; 2D

Posted on 25/11/2016 by dougaj4

I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release.  The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading →

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

More on Lookups

Posted on 22/11/2016 by dougaj4

Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup  on a large amount of data without taking all day, but still retaining the ability to return … Continue reading →

Posted in Excel | Tagged , , | Leave a comment