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

ImageMagick and Excel

Posted on 17/10/2008 by dougaj4

Back from my holidays, with a hard disk full of holiday snaps, and looking for a program to extract the image data saved on the camera, and add comments.  Not liking the offerings provided with the cameras, or any of the free programs I found, I have written my own, using ImageMagick.

ImageMagick is a command line image manipulation program, which has COM+ component, allowing the program functionality to be accessed from VBA.  More details here: ImageMagick COM+ object

My image importer program can be downloded from: PastePic.zip, and screenshots are shown below.

To run the program you will need to download and install the ImageMagick software, then in the Visual Basic editor create a reference to the ImageMagickObject 1.0 Type Library, using the Tools-References menu.

The spreadsheet file has only been provided in Excel 2007 format because in earlier versions the file size becomes impracticably large with only a small number of images.

File input list

File input list

Imported thumbnails and file details

Imported thumbnails and file details

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

The Willoughby Choir in Austria

Posted on 01/10/2008 by dougaj4

The wonderful Willoughby Symphony Choir give an impromptu performance of Motzart’s Ave Verum at the Dom Cathedral in Salzburg.  Use headphones or good external speakers to get the full effect!

Posted in Bach | Tagged , , , | Leave a comment