Author Archives: dougaj4

What to do about YouTube comments

Posted on 17/11/2009 by dougaj4

One of the less than wonderful things about YouTube is that the comments that accompany even the finest of videos are often of such an appalling standard that to call them puerile would be an affront to children. Here is … Continue reading →

Posted in Bach, Newton | Tagged , | 2 Comments

Crab Canon on a Mobius Strip

Posted on 16/11/2009 by dougaj4

Douglas Hofstadter’s Crab Canon featured in one of my first posts on this blog.  Now here is a really neat animated version of The JS Bach Crab Canon:  

Posted in Bach | Tagged , | 2 Comments

Some New Links

Posted on 09/11/2009 by dougaj4

A couple of return links to sites that have been sending traffic my way, and are well worth a look: AJP Excel Information (Andy Pope’s site): “The intention of this site is to be a useful resource of alternative solutions … Continue reading →

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

Chart Trend Lines and the Linest Function

Posted on 03/11/2009 by dougaj4

At the Mr Excel discussion forum the output of the worksheet function Linest(), compared with chart trend lines raised a question, where it is said that in Excel 2007 the trend line gives different (and incorrect) coefficients for a polynomial curve … Continue reading →

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

Reinforced Concrete Section Analysis – with prestress

Posted on 25/10/2009 by dougaj4

The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement.  The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , , , | 3 Comments