Author Archives: dougaj4

Interpolation Update

This post was prompted by a question at Eng-Tips.  The question was looking for ways to plot stress contours under a footing, which requires interpolation to find the depth where the stress is at the contour values, given stresses calculated … Continue reading →

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

The Dome of Santa Maria del Fiore in Florence

The dome of the Santa Maria del Fiore was the first dome structure of that size built since the Pantheon in Rome (126 AD) and the Hagia Sophia in Constantinople (537 AD).  Some sources say it is a little larger … Continue reading →

Posted in Dome Structures, Newton | Tagged , , , | 1 Comment

Extracting selected data with array functions.

This post is in response to a query at the Eng-tips forum asking how to extract selected data from a range, so that the three best scores for each individual could be extracted from a two column Excel table listing multiple individuals, … Continue reading →

Posted in Arrays, Excel | Tagged , | 5 Comments

What have the Romans ever done for us?

Maybe the Romans can  fairly claim the credit for spreading the aqueduct from Portugal to the Middle East, but the voussoir arch, typical of Roman aqueduct construction, did not originate with them. The first known voussoir arches were constructed by … Continue reading →

Posted in Arch structures, Bach, Historic Bridges, Newton | Tagged , , , | 1 Comment

Return of Excel – Evaluating commas

The Newton/Galileo posts here will continue with their Italian theme for some time yet, but since I am now back in Australia it’s time to give Excel a look in again. I recently (well a couple of months ago) had … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , | 6 Comments