Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litLIB: Added the BLockAverage function (Read 2059 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litLIB: Added the BLockAverage function
15.06.10 at 09:43:06
 
litLIB: Added the BLockAverage function
 
To the litLIB power functions library for Excel the BlockAverage function was added to the numerical functions section.
 
With BlockAverage average values are calculated in blocks of N values. For example BlockAverage(A1:A100,5) will calculate average values per blocks of 5 values. The first returned value is the average of A1:A5, the second returned average value is the average of A6:A10 and so on.

For more information please read:

litLIB help - BlockAverage
http://www.oraxcel.com/projects/litlib/help/blockaverage.html
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1