Author Archives: dougaj4

More on Regular Expressions

Posted on 08/12/2014 by dougaj4

The previous post presented a User Defined Function (UDF) using regular expressions to extract all numbers, or a selected number, from any string (or a list of strings).  In this post I will look more closely at the code used to achieve … Continue reading →

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

Extracting numbers from text and regular expressions

Posted on 30/11/2014 by dougaj4

Daily Dose of Excel recently had a post on extracting a number from a specified position in a text string, using mega-in-sheet-formulas like: This reminded me of a post from earlier this year, which provided a User Defined Function (UDF) … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 4 Comments

Range tips

Posted on 17/11/2014 by dougaj4

A couple of tips on Excel ranges, coming from questions on the Eng-Tips Forum: 1. How to rotate a range: The Transpose function (or option in the Paste-Special dialog box) will swap the rows and columns of a range, but … Continue reading →

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

The Gladesville Bridge is 50

Posted on 15/11/2014 by dougaj4

The Gladesville Bridge in Sydney is much less well known than the steel arch bridge just up-river, but in many ways the methods used in its design and construction were more innovative, and at the time of its completion it … Continue reading →

Posted in Arch structures, Historic Bridges, Newton | Tagged , | Leave a comment

Durability of Concrete Structures

Posted on 07/11/2014 by dougaj4

Don’t put yourself or your concrete assets at risk. Designing and constructing for durability is one of the most important aspects of any construction program. However, requirements for concrete durability are extremely fragmented in Australia. These conflicting requirements put designers, … Continue reading →

Posted in Concrete, Newton | Tagged , , | Leave a comment