Category Archives: Excel

Drawing in Excel – 2

Posted on 22/06/2008 by dougaj4

Before getting down to basics, the attached file: Animation demo Illustrates how Excel shapes can be simply animated. Screen shot: The code for the animation (having previously drawn a circle and a rectangle with no fill, and noted their names): … Continue reading →

Posted in Drawing, Excel, Newton | Tagged , , , , | 19 Comments

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

Posted on 15/06/2008 by dougaj4

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

Posted in Excel, UDFs | Tagged , , , , | 7 Comments

Drawing in Excel – 1

Posted on 01/06/2008 by dougaj4

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 →

Posted in Charts, Drawing, Excel | Tagged , , , | 6 Comments

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