Author Archives: dougaj4

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

Seven Florence Bridges

There are seven bridges over the River Arno in the central area of Florence, of which only one (The Ponte Vecchio) is an original old structure, the remainder of the old bridges having been destroyed by the retreating German army at … Continue reading

Posted in Arch structures, Historic Bridges, Newton | Tagged , , , , , , , , | 3 Comments

A tour of Venice backstreets

The great majority of the tourists in Venice are concentrated within a stone’s throw of The Grand Canal and St Mark’s Square, but the real charm of the place is in the back streets and canals, where (apart from the … Continue reading

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