Author Archives: dougaj4

Indexing pdf content, again

Posted on 04/03/2017 by dougaj4

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

Year 9 Report

Posted on 03/03/2017 by dougaj4

Last years’ statistics for this blog are now uploaded to Onedrive. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what has been posted over the year, and what people are looking … Continue reading →

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

The meaning of = in Python

Posted on 26/02/2017 by dougaj4

In VBA, if you have an array named a and a variant named b, then the statement “b = a” creates a new array b with the same size and values as a.  If the values of either a or b are subsequently changed, the values of the … Continue reading →

Posted in Arrays, Excel, Link to Python, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , , , , | 4 Comments

ConBeamU 4.13

Posted on 22/02/2017 by dougaj4

The continuous beam analysis spreadsheet, ConBeamU, is now up to version 4.13 with some minor bug-fixes, and the addition of a non-linear option for the BeamAct functions. See ConBeamU for more details of the functions available in the spreadsheet. Download … Continue reading →

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , | 7 Comments

February Links

Posted on 16/02/2017 by dougaj4

Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources.  Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading →

Posted in Excel, Link to dll, VBA | Tagged , , , | Leave a comment