Author Archives: dougaj4

Moving Average Function

Posted on 04/05/2009 by dougaj4

The previous post presented a simple moving average user defined function (UDF).  This has been extended to provide additional functionality: A weighted average may be returned; either a linear weight with a specified step value, or a using any specified weighting … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , | 1 Comment

Moving averages and User Defined Array Functions

Posted on 25/04/2009 by dougaj4

I have recently needed to work with moving averages on a large-ish data set (about 10,000 rows x 10 columns), and for reasons that I will describe in the next post, decided that a User Defined Function (UDF) would be … Continue reading →

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

More on Worksheetfunction vs UDF

Posted on 22/04/2009 by dougaj4

A recent post at Roy Maclean’s VBA Blog suggested that the difference between using a worksheetfunction call in VBA and writing a User Defined Function (UDF) to do the same job was not enough to be worth worrying about.  He tested … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Leave a comment

A very un-useful “feature”

Posted on 20/04/2009 by dougaj4

A recent post in the Engineering Spreadsheets forum at Eng-Tips draws attention to a potentially dangerous Excel “feature”. The feature is called “Extend data range formats and formulas” and can be found under Options-Advanced (click on the multi-coloured button in the … Continue reading →

Posted in Excel | Tagged , | 1 Comment

Precious

Posted on 13/04/2009 by dougaj4

“Precious” by Kerinne Jenkins has been selected for the London Independent Film Festival and the Heart of England Film Festival! In a dystopian future, two men meet in an underground tunnel for an exchange of stolen goods. Liam lives in … Continue reading →

Posted in Bach, Films | Tagged , , , | Leave a comment