Author Archives: dougaj4

Using Beam Design Functions

Posted on 07/09/2011 by dougaj4

“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading →

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 12 Comments

Spline Interpolation Alternatives

Posted on 04/09/2011 by dougaj4

A recent post at Jon Peltier’s Blog looks at an “on-sheet” method of performing linear interpolation on a set of tabular data, and the following comments include a number of alternative ways of carrying out the same process, and also some … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 7 Comments

Yet more new links

Posted on 02/09/2011 by dougaj4

Cosmic Horizons is about  what’s going on within our Event Horizon, and In the Dark is a blog about the Universe, and all that surrounds it, so that just about covers everything I suppose. Have a look, they aren’t just your usual … Continue reading →

Posted in Newton | Tagged , , | Leave a comment

New Links, and an Update

Posted on 29/08/2011 by dougaj4

Some new links, mostly suggested by Al Vachris: Jan Karel Pieterse has been freely providing some of the best Excel advice on the Internet for some years now, but he has escaped inclusion on my blogroll, possibly because his site … Continue reading →

Posted in Computing - general, Excel, Javascript | Tagged | 4 Comments

Area from Vectors

Posted on 27/08/2011 by dougaj4

The previous post looked at User Defined Functions (UDFs) for working with vectors, including examples of functions to find the area of polygons defined by coordinates.  In this post the functions will be extended to find other section properties (such … Continue reading →

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 5 Comments