Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Daily Download 7: Lateraly loaded pile analysis
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Downloads
- Downloads by category
- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- P-Y Curve function
Recent Comments
dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…
Tag Archives: Moving Average
Daily Download 26: Moving averages and prime numbers
Today’s downloads are the last of the maths related functions: http://interactiveds.com.au/software/MovAv.zip provides a User Defined Function (UDF) to return the moving average of a set of data, and http://www.interactiveds.com.au/software/Primes.zip is a UDF to either generate a set of prime numbers between specified … Continue reading
Moving Average Function
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
Moving averages and User Defined Array Functions
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 Array Function, Excel, Moving Average, UDF, VBA
8 Comments