Home
Test
The test function compares each row cell by cell to a baseline row. For each cell, it compares the cell to a corresponding baseline cell according to the boolean conditions supplied as parameters. 

If the test evaluates to true, the cell is considered “true” otherwise it is “false”.  The script author has the control to dictate if a “true” value is a “passed” or “failed” status for the cell.   In addition, the number of “true” values are accumulated and if a designated value is exceeded, the entire row is considered as “true”.  This is a very sophisticated form of what is sometimes referred to as basket analysis.

Syntax:

Test,  baselineRowLabel, comparisonOperator, percentValue, thresholdOperator, threshold, thresholdPercent, boolConsecutive, boolStopAtThresholdCount, boolAsPercent, boolWantFalseColumn, falseCaption, boolWantTrueColumn, trueCaption, boolWantOverallColumn, overall_caption, boolWantCustomRange [,startSub, countSub, stepBySub, limitSub, aggregationSub, startRow, countRow, stepByRow, limitRow, startBase, countBase, stepByBase, limitBase, aggregationBase]

Parameters:

baselineRowLabel – row label of the baseline row to be used

comparisonOperator – comparison to use {LessThan, LessThanOrEqualTo, NotEqual,Equal, GreaterThanOrEqualTo, GreaterThan,  OutsideOfRange, WithinRange}

percentValue – the percentage value to use with range operators

thresholdOperator – comparison to use for the threshold (count of false cells) {LessThan, LessThanOrEqualTo, NotEqual,Equal, GreaterThanOrEqualTo, GreaterThan,  OutsideOfRange, WithinRange }

threshold – the value to use for the threshold (count of false cells)

thresholdPercent – the percentage to use with threshold range operators (not in the GUI)

boolConsecutive – stop when threshold met on consecutive cells (true) or not (false)

boolStopAtThresholdCount – stop when threshold count achieved (true) or not (false)

boolAsPercent – determines how the threshold value will be interpretted, as a percentage (true) or value (false)

boolWantFalseColumn – display the total False counts in a column (true) or not (false)

falseCaption – the text to use for False condition

boolWantTrueColumn – display the total False counts in a column (true) or not (false)

trueCaption – the text to use for True condition

boolWantOverallColumn – display the overall True/False rating column (true) or not (false)

overallCaption – the text to use as a caption for the overall rating column

boolWantCustomRange  - is a custom range desired (true) or not (false)

The following parameters are only required if a custom range is desired:

startSub, countSub, stepBySub, limitSub, aggregationSub, startRow, countRow, stepByRow, limitRow, startBase, countBase, stepByBase, limitBase, aggregationBase

Examples:

Test,rowlabel,WithinRange,15,GreaterThan,5,0,False,False,False, True,True,True,False,True,Row Rating,False

Test,1,LessThan,0,GreaterThan,7,0,False,False,False,True,no,True, yes,True,Overall,False

Test against the baseline ‘1’, to see if the cells are less than, which should be marked ‘yes’ and others marked ‘no’. Include the counts of the ‘yes’ and ‘no’ answers, as well as the overall rating (more than 7 ‘no’s) in a column labeled ‘Overall’.
 
< Prev   Next >

Reference