Author Archives: dougaj4

Continuous Beams with Specified Deflections

A few weeks ago there was some discussion in a previous continuous beam post about how to analyse a continuous beam with specified deflections at the supports.  In this post I will look at three different ways of doing this … Continue reading →

Posted in Excel | Tagged , , , , , | 1 Comment

7 Year Report

As in previous years, I have downloaded the statistics for this blog for the previous year, and pasted them into a worksheet. The link to each post is preserved in the spreadsheet, so it makes a convenient index to what … Continue reading →

Posted in Bach, Excel, Newton | Tagged | 2 Comments

Reducing Risk in Structural Concrete Design

The Concrete Institute of Australia is running a series of full day seminars on Structural Concrete Design for Extreme Events in each of the mainland capitals: See:  Structural Concrete Design for Extreme Events for details of dates and locations in … Continue reading →

Posted in Concrete, Newton | Tagged , , , | Leave a comment

Slicing Arrays with VBA

A recent comment asked about the most efficient way to write part of an array to the spreadsheet from VBA. This post looks at three alternative methods which have advantages in different circumstances (thanks to Lori Miller for reminding me … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , , | 7 Comments

“Davy Graham has a theory” …

… is not an official Googlewhack because it has five words and is enclosed in quotes; nonetheless this exact search in Google returns just one hit (at least it did until today): “She Moved Thru’ the Bizarre”: Davy Graham and … Continue reading →

Posted in Bach | Tagged , , | Leave a comment