Reinforced Concrete Section Analysis - 4

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 the compression face, and depth of the neutral axis X below the compression face:
INA = QNA(X + e)
Where QNA [...]

Importing text files with VBA

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 importing into the spreadheet.  In addition to rather cumbersome procedures, the built-in Excel facilities for [...]

Section Properties from Layers

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 of each layer about a common axis.  The applicable equations for rectangular and trapezoidal layers [...]

Array resources

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 his index page, there is a huge amount of information and downloads on arrays):
http://http://www.cpearson.com/Excel/VBAArrays.htm
Alan Beban’s array functions:
http://http://home.pacbell.net/beban/
Colo’s [...]