Category Archives: Uncategorized

Problem with file downloads

Posted on 26/07/2008 by dougaj4

There has been a problem with the web site where I host my files for downloading, with the result that any links for file download will not have been working. I have copied all the linked files to: New file … Continue reading →

Posted in Uncategorized | Leave a comment

Reinforced Concrete Section Analysis – 4

Posted on 21/06/2008 by dougaj4

Previous post The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis: For a cross section with any applied axial load at eccentricity e, measured from … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs, Uncategorized | Tagged , , , , | 1 Comment

Importing text files with VBA

Posted on 19/05/2008 by dougaj4

Importing data from other programs into an Excel spreadsheet, in the form of text files, is a frequent requirement in engineering and scientific applications.  Often the data will have been formatted to suit printed output and will require processing before … Continue reading →

Posted in Excel, UDFs, Uncategorized | Tagged , , , , | 12 Comments

Section Properties from Layers

Posted on 19/03/2008 by dougaj4

An alternative to finding the section properties of irregular polygons from the coordinates of the corners is to divide the shape into rectangular or trapezoidal layers.  The properties of the shape may then be found by simply summing the properties … Continue reading →

Posted in Maths, Newton, Uncategorized | Tagged , , , , | 1 Comment

Array resources

Posted on 06/03/2008 by dougaj4

The getarray function from the first post in this series, plus functions to transpose, count the number of dimensions, and return other information about arrays, ranges or values: http://www.interactiveds.com.au/software/getarray.zip Chip Pearson’s Functions for VBA Arrays (also have a look at … Continue reading →

Posted in Uncategorized | 3 Comments