Author Archives: dougaj4

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

A Sailor’s Life

Posted on 04/05/2011 by dougaj4

A Sailor’s Life was recorded by Fairport Convention in 1968 and marks the transition of the group from a pale copy of the American West Coast sound to an original and innovative re-interpreter of British folk songs.  At the time … Continue reading →

Posted in Bach | Tagged , , , , , , | 2 Comments

Showing numerical values of formulae cell references

Posted on 28/04/2011 by dougaj4

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula.  It is easy to display the formula, rather than the result, for all the … Continue reading →

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