Category Archives: Excel

Flipping Coin Problems

Posted on 15/09/2011 by dougaj4

At Daily Dose of Excel Dick K. looks at a VBA solution to this problem: Problem description: Take a stack of coins all heads up. Upturn the topmost coin, place back on the stack and then proceed: take the top 2 … Continue reading →

Posted in Charts, Excel, VBA | Tagged , , | 2 Comments

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

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