Manuals/calci/CALCITOCHECK

1) ROWS function

• The function displays #NULL error with arguments as array values.

e.g. ROWS({1,2;3,4;5,6})

Expected result: 3

Observed result: #NULL

2)PRODUCT function

• If the cells in calci have numerical as well as text and empty cells, PRODUCT function assigns '0' to text and empty cells (instead they should be ignored).

e.g. PRODUCT(A1:A5) returns '0' where A1=2,A2=4,A3=TEXT,A4= ,A5=1

Expected result: 8

Observed result: 0

• Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0

3)OR function

• If the cells in calci have numerical as well as text and empty cells, OR function assigns '0'(FALSE) to text and empty cells (instead they should be ignored).

e.g. OR(TEXT, ) returns FALSE

Expected result: #NULL

Observed result: FALSE

4)HOUR,MINUTE,SECOND

• If the hour value >24, or Minute value > 59 or Second value > 59, Calci does not automatically advance the time with respect to input times.

e.g. HOUR("25:33") displays '#ERROR' (Output can be '1')

MINUTE("12:72:20") displays '0' (Output can be '12')

SECOND("12:10:72") displays '0' (Output can be '12')

• Function with serial numbers of time as input -

TIMEVALUE("3:30") gives 0.1458333333284827 (which is correct)

If the above serial number is used as input to HOUR, MINUTE and SECOND functions, following are the observations :

• HOUR(0.1458333333284827) displays '19' (Expected Output: '3')
• MINUTE(0.1458333333284827) displays '0' (Expected Output: '30')
• SECOND(0.1458333333284827) displays '0' (correct. But displays '0' for other serial numbers too)

The output is same(i.e. 19,0,0) for any other serial numbers (e.g 0.9479166666642413 for "10:45 PM").

5)GOLDENRATIO

a)Suggestion: Argument name can be changed to 'logic_value' instead of 'smallphi'

Reason: Argument can be TRUE or FALSE or 1 or 0 for this function. 'smallphi' and 'capitalphi' are the output values obtained.

b)Calci does not give error for -

*Invalid arguments like GOLDENRATIO(7), GOLDENRATIO("ABCDEF"), GOLDENRATIO(-8)
*Multiple arguments like GOLDENRATIO(100,77)

c)Calci help displays incorrect values for smallphi and capitalphi.

• Observed result:

GOLDENRATIO(TRUE) returns 1.618033988749895

GOLDENRATIO(FALSE) returns 0.6180339887498948

• Expected result:

GOLDENRATIO(TRUE) returns 0.6180339887498948, value of capitalphi Φ

GOLDENRATIO(FALSE) returns 1.618033988749895, value of smallphi φ

d)If argument is ignored, i.e. GOLDENRATIO()

• Observed result: 0.6180339887498948, value of capitalphi Φ
• Expected result: 1.618033988749895, value of smallphi φ

Reason: smallphi is default value for Goldenratio. Capitalphi is the conjugate value.

6)HYPERLINK

• Link to specified location gets created in Calci. But document/website does not open up.

e.g.

=HYPERLINK("http://www.google.com","Click here")

7)RANDOMNUMBERGENERATION, RANDOMNUMBERGENERATIONUNIFORM, RANDOMUNIFORM

• Random number output is not displayed. Same command is displayed on space cube.

e.g. =RANDOMNUMBERGENERATION(3, 4, "Uniform", TRUE, 3, 4)

8)ANOVASINGLEFACTOR

• Function displays correct results for analysis by "COLUMNS" option. But is incorrect for "ROWS"

e.g. Consider the example on page http://wiki.zcubes.com/Manuals/calci/ANOVASINGLEFACTOR

=ANOVASINGLEFACTOR(A1:B4,0.05,"ROWS",TRUE) displays same result as with COLUMNS (which is incorrect). Only COLUMNS 1,2 are replaced with ROW 1, 2.

9)HISTOGRAM(Array, BinRange, NewTableFlag)

Propery of NewTableFlag:

• $NewTableFlag$ can be a logical value TRUE or FALSE. If omitted, Calci assumes it to be FALSE.
• If $NewTableFlag$ is TRUE, the result is displayed on new zspace sheet.

Output Observed:

For TRUE, result table in Calci shows (both on new zspace)

• Bin, Frequency columns and
• two more columns showing Bin and Frequency in descending order

For FALSE, Calci displays only Bin and Frequency columns (on new zspace).

10)MOVINGAVERAGE(Array, PeriodInterval, NewTableFlag)

• $NewTableFlag$ if TRUE, should display output on new zspace cube.
• $NewTableFlag$ if FALSE, should display output on same calci sheet of the data and command.

Observed Output:

• Output displayed on new zspace cube for both TRUE and FALSE.

11)EXPONENTIALSMOOTHING(Array, DampingFactor, NewTableFlag)

• $NewTableFlag$ if TRUE, should display output on new zspace cube.
• $NewTableFlag$ if FALSE, should display output on same calci sheet of the data and command.

Observed Output:

• Output displayed on new zspace cube for both TRUE and FALSE.

12)MATCH(lkup_val, lkup_arr, m_type) Issue: Function not recognized in ZOS, whereas works well in Calci.

ZCalci displays correct results - e.g.

• MATCH("A",{"A","B","C"},1) returns relative position of 'A' as 1.
• MATCH(44,{40,42,44},1) returns relative position of '44' as 3.

ZOS displays error.