Author Archives: dougaj4

Acer A500 Tablet Review and Total Commander

Posted on 18/05/2011 by dougaj4

Having got fed up waiting for supplies of the iPad2 to become available, I bought myself an Acer A500 Tablet about 3 weeks ago, so here are my first impressions.  Remember that I’m very much a tablet newbie, who still uses dumb phone … Continue reading →

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

Loopiest Anagram

Posted on 15/05/2011 by dougaj4

A list of clever anagrams of  Douglas Hofstadter’s “I am a Strange Loop” A Loop, Enigmas, Art;  A Gal Remaps onto “I” Loop Again, Master! But the loopiest anagram for “I Am a Strange Loop” was: Loopiest Anagram Anagrams copied from: http://reocities.com/unmark/mblog.html (scroll down … Continue reading →

Posted in Bach | Tagged , | 1 Comment

Using LinEst() on data with gaps

Posted on 14/05/2011 by dougaj4

A comment on Using LINEST for non-linear curve fitting asked if it was possible to use the function on data with gaps.  There are several options: Copy and sort the data to remove the gaps. Use the chart trendline function Use … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 40 Comments

Bellows Falls Bridge

Posted on 12/05/2011 by dougaj4

Sparked by this excellent high resolution photo from the Shorpy collection, posted at Eng-Tips, and a comment that it was a three-pinned arch (coming from Wikipedia), I thought I would investigate further. Zooming in on the crown shows that there … Continue reading →

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

Using Array Formulas

Posted on 10/05/2011 by dougaj4

Many of my User Defined Functions (UDFs) return an array of values, that requires a special procedure to make all the values visible. I have usually given a brief description of the procedure with the UDF, but for convenience for … Continue reading →

Posted in Arrays, Excel, UDFs | Tagged , , | 20 Comments