Concrete 09, the bi-annual conference of the Concrete Institute of Australia will be held from 17th to 19th September 2009 at Luna Park, Sydney. The theme of the conference is “adding value in changing climates”. The closing date for submission of abstracts is Friday 14th November 2008; just 7 days left!.
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 ULS analysis of bending, axial load and shear capacity) can be found in the spreadsheet RC Design Functions7.
Examples of the output from these functions are shown below:
Interaction Diagram generated by UMom
Estress and UMom entered as array functions
An excellent and detailed account of historical bridges in New South Wales:
Bridge Types in NSW Historical Overviews
Bridge Types of NSW - sample
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 = Selection.Value
Result = Application.CheckSpelling(Checkword)
Selection.Offset(0, 1) = Result
End Sub
Now it would be convenient to have this routine in a UDF, but the code below always returns FALSE:
Function SpellCheck(CheckRange As Variant) As Boolean
Dim Checkword As String
Checkword = CheckRange(1, 1).Value
SpellCheck = Application.CheckSpelling(Checkword)
End Function
Can anyone tell me why?
The previous post in this series included Excel User Defined Functions using closed form solutions to find the ultimate bending and axial load capacity of reinforced or prestressed concrete sections of any complex shape defined by rectangular or horizontal layers. The paper ultimate-moment-capacity1 provides the derivation of the solutions used in these functions. An extract from the paper is shown below.
