Tag Archives: VBA

Reinforced Concrete Section Analysis 7 – rectangular sections

Posted on 05/11/2008 by dougaj4

Previous post The spreadsheets presented in earlier posts in this series have been simplified for use with rectangular sections with two layers of reinforcement.  The functions EStress (for elastic analysis of stresses, strains and crack widths) and UMom (for the … Continue reading →

Posted in Beam Bending, Concrete, Newton, UDFs | Tagged , , , , , | 3 Comments

A Question of Spelling

Posted on 01/11/2008 by dougaj4

The Excel VBA routine below will check the spelling of the text in the current selected cell, and return either TRUE or FALSE in the adjacent cell to the right: Sub SpellChecksub() Dim Checkword As String, Result As Boolean Checkword … Continue reading →

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

Drawing in Excel 6 – getting shape properties

Posted on 17/09/2008 by dougaj4

Previous post One of the less than useful new “features” of Excel 2007 is that its macro recorder no longer records operations on shapes, which removes the easiest way to discover the exact names of shape properties, and how to manipulate … Continue reading →

Posted in Drawing, Excel, UDFs, VBA | Tagged , , , , | 5 Comments

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

Reinforced Concrete Section Analysis – 5; Ultimate Limit State

Posted on 19/08/2008 by dougaj4

Previous posts in this series have looked at the analysis of beams where the steel stress is within the elastic range, and the concrete stress is sufficiently low that the assumption of linear elastic behaviour in compression is a reasonable approximation.  … Continue reading →

Posted in Beam Bending, Excel, UDFs | Tagged , , , , , , , | 5 Comments