Dec 152017
 
Add-in functions for Quattro Pro v4.0. Count, average, std deviation and test for blank over a range of cells; scan a block for a specific value.
File SUMFUN.ZIP from The Programmer’s Corner in
Category Lotus and other Spreadsheets
Add-in functions for Quattro Pro v4.0. Count, average, std deviation and test for blank over a range of cells; scan a block for a specific value.
File Name File Size Zip Size Zip Type
N.QLL 4107 2357 deflated
SCAN.QLL 4288 2416 deflated
SUMFUN.DOC 1837 797 deflated

Download File SUMFUN.ZIP Here

Contents of the SUMFUN.DOC file


Here are some add in @functions that I created. I am releasing them for
the purpose of beta testing. If you have any problems or questions
concerning them, please let me know.
To load these type /T(ools) L(ibrary) L(oad)


Steve Devore

Compuserve: 71121,1717

6425 County Rd 30, #215
St. Bonifacius, MN 55375


---------------------------------------------------------------------------
N.QLL v1.0 by Steve Devore 8/3/92

N.QLL contains the following functions.

@N.ISBLANK(Block)
@N.COUNT(List)
@N.AVG(List)
@N.STD(List)

List = one or more blocks.

@N.COUNT, @N.AVG, AND @N.STD will ignore strings and blanks. If the
AVG or STD is performed on a blank range (or a range that contains only
strings), a null string is returned.

Single cell blocks must be entered as blocks; Qpro will not change a single
cell reference to a block. For example to find out if A1 is blank you must
type @N.ISBLANK(A1..A1) or @N.ISBLANK(!A1), but not @N.ISBLANK(A1).



---------------------------------------------------------------------------
SCAN.QLL v1.0 by Steve Devore 8/3/92

SCAN.QLL contains the following functions:

@SCAN.SUM(Block,ScanValue,Col)
@SCAN.COUNT(Block,ScanValue,Col)
@SCAN.AVG(Block,ScanValue,Col)
@SCAN.STD(Block,ScanValue,Col)

Block: The block to scan.
ScanValue : The value to match in the first column in the block.
Col: The column to add, count, etc.

These functions will search a given block's first column for all occurences
of ScanValue, then perform the desired operation on the cell at all the
rows that match. The Block does not need to be sorted.

If an average or standard deviation is performed on a blank range, a null
string is returned instead of ERR.
---------------------------------------------------------------------------


 December 15, 2017  Add comments

Leave a Reply