Manuals/calci/CALCITOCHECK

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

ROWS EXPLANATION

This will work only in CALCI as the {} notation for array is useful only in spreadsheet platforms and similar languages. In ZOS arrays are to be indicated by [] and Objects will use {} notation.

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

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

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").

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:

--see exp -- GOLDENRATIO(TRUE) returns 0.6180339887498948, value of capitalphi Φ --see exp -- 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.

GOLDENRATIO EXPLANATION

GOLDENRATIO(TRUE) returns 1.618033988749895 GOLDENRATIO(FALSE) returns 0.6180339887498948 This is correct. parameter is smallPhi is true, If so answer should be 1.61 etc. if false should be 0.6181 etc. If argument is not defined or is not false, it is considered to be true. So junk value giving smallPhi equivalent is safe. - jp

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")

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)

RANDOMNUMBERGENERATION(30, 4, "Uniform", TRUE, 3, 4)

3.195449711289257	3.2248697481118143	3.0816136938519776	3.2126745639834553	3.990793523611501	3.649687875760719	3.759418284520507	3.965467617381364	3.9545328468084335	3.3741041221655905	3.1905515757389367	3.777756262337789	3.9837128871586174	3.432979935547337	3.9010994143318385	3.7845077733509243	3.421978456666693	3.813554910942912	3.168992273742333	3.2010161119978875	3.9937344735953957	3.459437067853287	3.384454872459173	3.0950622770469636	3.1798048589844257	3.407964985817671	3.6846570973284543	3.6611867914907634	3.9072526150848716	3.2141497172415257
3.2669153639581054	3.2465451690368354	3.0314107462763786	3.88823653687723	3.6240376371424645	3.0279260887764394	3.4216481952462345	3.747306031640619	3.515739459078759	3.175762218190357	3.6369324799161404	3.7142539599444717	3.6433018636889756	3.133950341725722	3.6951540084555745	3.4156028230208904	3.240273320581764	3.4762711247894913	3.7170767160132527	3.180914681404829	3.9355433725286275	3.0196601944044232	3.3859861323144287	3.854840762214735	3.37747969920747	3.7828165935352445	3.326533603016287	3.7698845479171723	3.1485248988028616	3.0072317481972277
3.9251055871136487	3.2557102914433926	3.788066220469773	3.207987993489951	3.588850313099101	3.870454262243584	3.9496661769226193	3.4028041230048984	3.6568462373688817	3.6426883353851736	3.9649933751206845	3.2784565046895295	3.246733759297058	3.380512889707461	3.0992100907023996	3.739959954516962	3.3115603323094547	3.2317469376139343	3.5847271364182234	3.594636262860149	3.9285641501192003	3.712517147185281	3.9386905138380826	3.8844250414986163	3.1710384245961905	3.583163051167503	3.137686180183664	3.990223975619301	3.3122955770231783	3.6850603164639324
3.162752259755507	3.126228274544701	3.4762895670719445	3.242924148682505	3.0085414829663932	3.9302729363553226	3.777372183976695	3.940537365153432	3.640196947613731	3.316979159368202	3.1863948297686875	3.9217444960959256	3.964422813616693	3.0397708313539624	3.883876184700057	3.882750508841127	3.485125683248043	3.8928709470201284	3.5129915438592434	3.0280541735701263	3.621288023889065	3.5997950434684753	3.1812141358386725	3.4793242022860795	3.4653837154619396	3.982316398760304	3.9729056453797966	3.0827220352366567	3.775389570510015	3.457127903588116

Is this correct?

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.

ANOVASINGLEFACTOR([1 3;7 8; 12 5;17 18],0.05,"COLUMNS",TRUE) gave result in ZOS: ANOVASINGLEFACTOR([[1,3],[7,8],[12,5],[17,18]],0.05,"COLUMNS",TRUE)

Anova: Single Factor SUMMARY

Groups	Count	Sum	Average	Variance
Column1	2	4	2	2
Column2	2	15	7.5	0.5
Column3	2	17	8.5	24.5
Column4	2	35	17.5	0.5

ANOVA

Source of Variation	Sum of Squares	Degree of Freedom	Mean of Squares	F	Probability	F Critical
Between Groups:	247.375	3	82.45833333333333	11.993939393939394	0.018128968083516894	6.591451475716938
Within Groups:	27.5	4	6.875
Total:	274.875	7

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).

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.

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.

MATCH(lkup_val, lkup_arr, m_type)

Issue: Function does not work in ZOS if lkup_arr represented with {} brackets, whereas works with [ ].

• ZCalci works with both type of array representation {}, [] and displays correct results -

e.g.

• MATCH(44,{40,42,44},1) does not work in ZOS.
• MATCH(44,[40,42,44],1) returns relative position of '44' as 3 in ZOS.

MATCH EXPLANATION

See after new release if issue persists.