Category Archives: Maths

Solving simultaneous equations

Posted on 27/08/2008 by dougaj4

Solving a series of simultaneous equations is a task frequently required in engineering and scientific analysis.  Excel provides the tools to perform this task quickly and easily, but the procedure is not documented in the on-line help (so far as … Continue reading →

Posted in Arrays, Excel, Maths, UDFs, VBA | Tagged , , , , | 5 Comments

Evaluate Function – update

Posted on 05/07/2008 by dougaj4

Previous post The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range. The revised worksheet can be downloaded from: Eval.zip

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

Elegant proofs 2 – The area of a circle

Posted on 02/07/2008 by dougaj4

We are so familiar with the formula for the area enclosed by a circle that we tend not to think much about how it was derived, at least I don’t. The proofs of the formula are in fact many and … Continue reading →

Posted in Maths, Newton | Tagged , , , , | 4 Comments

Pythagoras, Penrose and Pov-Ray

Posted on 30/06/2008 by dougaj4

Images based on Pythagorean tiling, Penrose tiling, and projections onto the Riemann Sphere by PM2ring, a regular contributor to the ABC Self-Service Science Forum (words by the artist):  Various renderings of a Pythagorean tiling. Mostly using the 3,4,5 triangle. This … Continue reading →

Posted in Maths, Newton | Tagged , , , , | 3 Comments

Irish Graffiti

Posted on 25/06/2008 by dougaj4

On the 16th October 1843 the Irish mathematician William Hamilton was taking a walk with his wife, alongside the Royal Canal in Dublin, when the answer to a problem that he had been puzzling over came to him, and he … Continue reading →

Posted in Arch structures, Maths, Newton | Tagged , , | Leave a comment