Evaluate Function - update

Previous post
The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range.
The revised worksheet can be downloaded from:
Eval.zip

Importing text files with VBA - 3

The text import file has been modified to split large files into one or more ranges.
The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the same sheet or different sheets. The modified file has been tested with a text file with [...]

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 - 2

Previous post
The text file import routines and functions presented in the previous post have been modified with the following additions:
Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space)
The SplitText function can also be used as a UDF, to split lines of text previously imported.  In [...]

Reinforced Concrete Section Analysis - 3

Previous post -1
Previous post -2
The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and prestressed members of complex cross-section, subject to combined bending and axial load.
The Excel file also includes UDFs [...]

Worksheetfunction vs UDF - 2

Previous Post
In a recent post at microsoft.public.excel.programming Charles Williams (Decision Models) found that a VBA User Defined Funcion (UDF) searching through a defined range for a specified number was very much slower than simply using .worksheetfunction.match as below:
Function VBAMatch2(arg As Double, XRange As Variant) As Long
    VBAMatch2 = Application.WorksheetFunction.Match(arg, XRange, 1)
End Function
I found this strange, [...]

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 [...]

Excel 2007 performance - feedback please

According to this post at MSDN:
http://msdn.microsoft.com/en-us/library/aa730921.aspx#office2007excelperf_ExcelPerformanceImprovements
Excel 2007 should be giving significant performance improvements on multi-core processors.
Some simple benchmarks on an Acer laptop with 2.0 GHz dual-core processor and 2 GB RAM show some improvement (over Excel 2000), albeit quite modest:

 Click on image to see full size.
In all cases with the dual core processor it was [...]

Evaluate Function

It would often be convenient to evaluate a function entered as text; for instance if we have the function for the deflection of a cantilever under point loading at the end:
F*L^3/(3*E*I)
then it would be convenient to be able to allocate different values to F, L, E and I, and calculate the value of the function, [...]

Section Properties of Defined Shapes - Spreadsheet

Download section properties spreadsheet from:
http://www.interactiveds.com.au/software/Section%20Properties03.zip
http://www.interactiveds.com.au/software/Section%20Properties07.zip

Section properties for 35 defined shapes

Section properties from coordinates

Section properties UDF

Screen shots: