Recent Comments
Category Archives: Excel
Drawing in Excel – 1
This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to … Continue reading
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 … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs
Tagged Cubic, Plot Shapes, Polynomial, Quadratic, Quartic, Reinforced Concrete, Section Analysis, UDF, VBA
8 Comments
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 … Continue reading
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 … Continue reading
Reinforced Concrete Section Analysis – 2
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
