Category Archives: Excel

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

Excel Summit South Reminder

Posted on 29/12/2015 by dougaj4

I have just signed up for the Excel Summit South. Anyone wanting a 20% discount has until Thursday 31st December.    

Posted in Excel | Tagged , , , , | Leave a comment

More on Sums

Posted on 18/12/2015 by dougaj4

My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples.  This includes … Continue reading →

Posted in Excel | Tagged , , , , | Leave a comment

Max, Min, and Aggregate

Posted on 11/12/2015 by dougaj4

Recently I needed to find the maximum and minimum of a range of values including some #N/A values.  Searching found a variety of solutions, of which the simplest (that works in all versions) seems to be: =MAX(IF(ISNUMBER(datarange),datarange)) =MIN(IF(ISNUMBER(datarange),datarange)) The function … Continue reading →

Posted in Excel | Tagged , , , , | 5 Comments

ConBeamU 4.08

Posted on 29/11/2015 by dougaj4

The continuous beam spreadsheet has had another update to fix a problem when point loads were applied to cantilevers, and the first support position was not listed as an output point.  The new version (4.08) can be downloaded from: ConbeamU.zip … Continue reading →

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