Category Archives: Computing – general

Indexing pdf content, again

I discovered today that my latest computer (with 64 bit Windows 10) had not been indexing the content of pdf files, which makes doing a search on local file content pretty much a waste of time.  Checking the file search settings … Continue reading

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

Running exe files from Excel

Following on from the previous post (running a compiled Fortran finite element analysis program from Excel), this post looks at the details of calling any command line routine from Excel, through VBA.  The important points that need to be addressed are: Writing … Continue reading

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, Newton, VBA | Tagged , , , , , , , | 1 Comment

Making non-linear FEA with Excel go (much) faster

The spreadsheet presented in the previous post takes about 90 seconds to complete (with the iteration limit set at 500) on my computer, and is much slower on some other systems.  The VBA code that does all the hard work is based … Continue reading

Posted in Computing - general, Excel, Finite Element Analysis, Fortran, Geotechnical Engineering, VBA | Tagged , , , , , , , | 3 Comments

2D non-linear FEA with Excel

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 , , , , , | 3 Comments

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

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

The file PdfLink.xlsb (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 , , , , , | 7 Comments

A Loopy Link (and three more)

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