Category Archives: Computing – general

2D non-linear FEA with Excel

Posted on 23/06/2016 by dougaj4

This blog has many posts on analysis of 2D and 3D frame structures in Excel (see Frame Analysis Downloads), but this is the first on performing finite element analysis of a 2D continuum.  The file PlateMC.xlsb contains a simple example using … Continue reading →

Posted in Computing - general, Excel, Finite Element Analysis, VBA | Tagged , , , , , | 4 Comments

Why I’m going to Excel Summit South. (And why you should too).

Posted on 20/02/2016 by dougaj4

I was going to write a reminder about the Excel Summit South, but Jeff Weir beat me to it, and since his version is way more entertaining than mine was going to be, pop over and find out why Jeff … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , | 2 Comments

Opening and searching pdf files from Excel

Posted on 30/12/2015 by dougaj4

The file PdfLink.zip (free download with open source code) contains two short but useful macros for opening and searching pdf files from Excel. The first is based on code from My Engineering World. I have just added a simple interface … Continue reading →

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

A Loopy Link (and three more)

Posted on 23/08/2015 by dougaj4

For some reason Doug Glancy’s Excel Blog has escaped my attention up till now, but having a browse today, I discovered this loopy animation: which would not have been out of place in Douglas Hofstadter’s “I am a Strange Loop” I really … Continue reading →

Posted in Animation, Computing - general, Excel, Maths, Newton, VBA | Tagged , , , , , | 2 Comments

Installing Windows 10 …

Posted on 03/08/2015 by dougaj4

… did not go well. After installing over night it needed another half hour or so to “just finish off a few things”, after which it briefly displayed the desktop, followed by a message saying that it was going to … Continue reading →

Posted in Computing - general | Tagged , , , | 2 Comments