Author Archives: dougaj4

A Tail of Two Letters …

Posted on 14/02/2011 by dougaj4

… or the importance of being Douglas. I’m currently reading Douglas Hofstadter’s “I am a Strange Loop”, which has reminded me of two hypothetical imaginary letters that I never sent (and now never will) to Mr Hofstadter and Douglas Adams. … Continue reading →

Posted in Newton | Tagged , , , | 1 Comment

Fitting high order polynomials

Posted on 04/02/2011 by dougaj4

This post is a follow up to Using LINEST for non-linear curve fitting and the following comments from Scott Rogers and Lori Miller.  Scott found that he was getting different results from Linest and the xy chart trend line for polynomials of … Continue reading →

Posted in AlgLib, Charts, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 31 Comments

Seeing through Mingus eyes

Posted on 28/01/2011 by dougaj4

At the top of Bob Phillips’ Blog home page is a quote from Charles Mingus, the great jazz bassist, band leader and composer: “Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that’s creativity” If Bob hadn’t … Continue reading →

Posted in Bach, Computing - general, Newton | Tagged , , , | Leave a comment

New Links

Posted on 26/01/2011 by dougaj4

Two new Excel links on the list to the right, both with a tonne of good information on how to get more out of Excel: Bob Phillips writes the Excel Do, Dynamic Does blog, with a focus on business information.  The … Continue reading →

Posted in Arch structures, Excel, Historic Bridges, Newton | Tagged , , | Leave a comment

Finding all range names in a specified range

Posted on 24/01/2011 by dougaj4

Another useful little snippet from Eng-tips. There was a question regarding how to list all the range names applied to a specified cell.  Forum members electricpete and MintJulep came up with a short macro to do the job, which I have … Continue reading →

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