Category Archives: Excel

Reinforced Concrete Section Analysis – 3

Posted on 30/05/2008 by dougaj4

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 … Continue reading →

Posted in Beam Bending, Excel, Newton, UDFs | Tagged , , , , , , , , | 8 Comments

Worksheetfunction vs UDF – 2

Posted on 24/05/2008 by dougaj4

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 … Continue reading →

Posted in Excel, UDFs | Tagged , , | Leave a 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

Reinforced Concrete Section Analysis – 2

Posted on 15/05/2008 by dougaj4

Previous Post Pseudo-code for elastic analysis of a layered reinforced concrete section under eccentric axial load and pre-stress load:  Read data ‘For each reinforcement layer: Find area, first moment of area about top ,and depth of centroid. Find total reinforcement … Continue reading →

Posted in Beam Bending, Excel | Tagged , , | 1 Comment

Excel 2007 performance – feedback please

Posted on 06/05/2008 by dougaj4

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), … Continue reading →

Posted in Excel, UDFs | Tagged | 7 Comments