Author Archives: dougaj4

The Dome of Santa Maria del Fiore in Florence; new links

Posted on 01/07/2014 by dougaj4

Earlier this year the on-line edition of National Geographic posted an article on: Mystery of Florence’s Cathedral Dome May Be Solved The wording of the article owes more to journalistic hyperbole than anything else, but it includes a link to an … Continue reading →

Posted in Arch structures, Bach, Dome Structures, Newton | Tagged , , , | Leave a comment

Evaluating text – update

Posted on 28/06/2014 by dougaj4

One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check.  For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading →

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 5 Comments

Reinforced Concrete – ULS capacity under combined axial load and biaxial bending

Posted on 19/06/2014 by dougaj4

I have modified the ULS Design Functions spreadsheet, last presented here, to analyse sections subject to bi-axial bending, and non-symmetrical sections.  The new version makes use of the routines for splitting any section defined by XY coordinates into trapezoidal layers, described … Continue reading →

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

Melanie Safka

Posted on 11/06/2014 by dougaj4

Melanie Safka is touring Australia this month, which prompted me to look up some of her old songs on YouTube – I’d forgotten how good she was: And something more recent, London in 2009:      

Posted in Bach | Tagged | 1 Comment

Data Transfer to Python – Update

Posted on 08/06/2014 by dougaj4

As noted in the comments here, the main bottleneck in the Python matrix solver functions presented recently was not in the data transfer from Excel, but rather in the creation of the Numpy arrays for very long lists of short … Continue reading →

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