Category Archives: Excel

Two Years Old Today

Posted on 21/02/2010 by dougaj4

Newton Excel Bach today completes its second year in the Blogosphere, and as last year I have downloaded the statistics for number of hits on each post, and pasted them into an Excel worksheet.  The link to each post is … Continue reading →

Posted in Excel | Leave a comment

Secondary axes in Excel 2007

Posted on 20/02/2010 by dougaj4

Sometimes rarely used features in an application are so prominently placed that we become blind to them, and can’t find them when we need them. This happened to me recently with the procedure for assigning an Excel chart series to … Continue reading →

Posted in Charts, Excel | Tagged , , | 9 Comments

Reinforced Concrete Moment-Curvature – 4; Development of curvature over time

Posted on 12/02/2010 by dougaj4

The previous post in this series looked at how specified shrinkage and creep strains affect the curvature of a reinforced consrete section subject to a constant load.  In this post I will present a User Defined Function (UDF) that analyses … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , | 6 Comments

Hello World (again)

Posted on 02/02/2010 by dougaj4

Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 2 Comments

Good practice, best practice, or just practice?

Posted on 15/01/2010 by dougaj4

Browsing the ‘net this morning I found the “Golden Rules” listed below at Ozgrid.com The rules are described as things that “should not be optional”, which seemed to me in some cases to be going way too far, since for many … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 15 Comments