Bridges of NSW

Posted on 02/11/2008 by dougaj4

An excellent and detailed account of historical bridges in New South Wales:

Bridge Types in NSW Historical Overviews

Bridge Types of NSW - sample

Bridge Types of NSW - sample

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

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 = 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?

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

Reinforced Concrete Section Analysis – 6; Ultimate Limit State

Posted on 23/10/2008 by dougaj4

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.

Posted in Beam Bending, Concrete, Newton | Tagged , , , | 6 Comments

ELASTIC SOLUTIONS FOR SOIL AND ROCK MECHANICS

Posted on 22/10/2008 by dougaj4

Found on the Web:

Edit 26 Feb 2023:  Link no longer active
ELASTIC SOLUTIONS FOR SOIL AND ROCK MECHANICS

“Professor Harry Poulos, Emeritus Professor from the University of Sydney and a Senior Principal Consultant with Coffey & Partners, has graciously (and generously) agreed to allow USUCGER to post a PDF version of the seminal book Elastic Solutions for Soil and Rock Mechanics (co-authored with the late E.H. Davis). “

Posted in Newton | Tagged , , , | 3 Comments

ImageMagick – Update and add IrfanView link

Posted on 19/10/2008 by dougaj4

The picture indexing spreadsheet presented in the previous post has been updated:

  • Comments can now be added adjacent to the file names, and these will be copied along with the Exif data
  • The routine to copy the exif data to the spreadsheet has been modified to speed things up.
  • Select a file name from the list or from the “Pictures” sheet, and press Ctrl-S, and the picture will display full screen in IrfanView.
  • If a “l” or “r” is inserted next to the comment the picture display will be rotated.
  • Select a range of file names from the list, and they will be displayed in sequence (press “esc” twice, or Alt-F4 to move to the next picture).

Download from PastePic.zip

Notes:

  • IrfanView is a free program and may be downloaded from here: download
  • If the IrfanView executable file is installed in a directory other than “C:\Program Files\IrfanView\” then enter the full path (including i_view32.exe) in the appropriate cell on the IViewPath sheet.
  • The routine to connect to IrfanView used the ShellandWait function by Chip Pearson, which is documented here: ShellandWait
  • When a series of files are selected they may be displayed as a slide show by entering the desired length of display (in seconds) in the box “Slideshow delay”, but when the display is finished each picture file must be closed by pressing Alt-F4, or “esc” twice.  If anyone can tell me how to close IrfanView after a specified period (through the Shell command, or otherwise) please let me know.
Screen shot

Screen shot

Posted in Drawing, Excel, VBA | Tagged , , , , , | 4 Comments