assay
test suite

array-longtail

65 tests · 32 with documented divergences

Test Subject Formula Category DVs
f65a1f TRANSPOSE =TRANSPOSE({1,2,3}) value 2
b41aec TRANSPOSE =TRANSPOSE({1;2;3}) value 2
4c8b50 TRANSPOSE =TRANSPOSE({1,2;3,4}) value 2
126a11 TRANSPOSE =TRANSPOSE(A1:C1) value 2
7b5682 FLATTEN =FLATTEN({1,2,3}) value
cf6cf1 FLATTEN =FLATTEN({1;2;3}) value
cdddff FLATTEN =FLATTEN({1,2;3,4}) value
09f104 FLATTEN =FLATTEN({1;2}, {3;4}) value 2
20acce TOCOL =TOCOL({1,2,3}) value
a6fdf4 TOCOL =TOCOL({1,2;3,4}, 0, FALSE) value
4f74c9 TOCOL =TOCOL({1,2;3,4}, 0, TRUE) value
6ba788 TOCOL =TOCOL(A1:A3, 1) value
1adb06 TOROW =TOROW({1;2;3}) value
924265 TOROW =TOROW({1,2;3,4}, 0, FALSE) value
a849f2 TOROW =TOROW({1,2;3,4}, 0, TRUE) value
4ddc07 TOROW =TOROW(A1:C1, 1) value
088c1b WRAPCOLS =WRAPCOLS({1,2,3,4}, 2) value
6b6d36 WRAPCOLS =WRAPCOLS({1,2,3}, 2, "x") value
b084ab WRAPCOLS =WRAPCOLS({1,2,3,4,5,6}, 3) value
1be01d WRAPCOLS =WRAPCOLS({1,2,3}, 3) value
fc9451 WRAPROWS =WRAPROWS({1,2,3,4}, 2) value
2f7375 WRAPROWS =WRAPROWS({1,2,3}, 2, "x") value
ad4538 WRAPROWS =WRAPROWS({1,2,3,4,5,6}, 3) value
180290 WRAPROWS =WRAPROWS({1,2,3}, 3) value
850891 ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4;5,6}, 2, 2) value 1
8d4e4a ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2,3;4,5,6}, 2, 2) value 1
49ea0a ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4}, 2, 2) value 1
eb3f92 ARRAY_CONSTRAIN =ARRAY_CONSTRAIN({1,2;3,4}, 1, 1) value 1
a11b03 MDETERM =MDETERM({1,0;0,1}) value 1
58d004 MDETERM =MDETERM({1,2;3,4}) value 1
4c549e MDETERM =MDETERM({1,0,0;0,1,0;0,0,1}) value 1
568f19 MDETERM =MDETERM({1,2;2,4}) value 1
f8a614 MINVERSE =MINVERSE({1,0;0,1}) value 2
b633f1 MINVERSE =MINVERSE({1,2;3,4}) value 3
089a63 MINVERSE =MINVERSE({1,2;2,4}) error-code
659fda MINVERSE =MINVERSE({1,0,0;0,1,0;0,0,1}) value 2
a97912 MMULT =MMULT({1,2;3,4}, {1,0;0,1}) value 2
612f8b MMULT =MMULT({1,2;3,4}, {5,6;7,8}) value 2
cc8a4e MMULT =MMULT({1,2,3}, {4;5;6}) value 1
92945c MMULT =MMULT({1,2}, {1,2}) value 2
8d6ea4 SUMX2MY2 =SUMX2MY2({1,2,3}, {4,5,6}) value 1
d7eeeb SUMX2MY2 =SUMX2MY2({1,2,3}, {1,2,3}) value 1
a616d1 SUMX2MY2 =SUMX2MY2({3}, {2}) value 1
0e5ea4 SUMX2PY2 =SUMX2PY2({1,2,3}, {4,5,6}) value 1
84b3d0 SUMX2PY2 =SUMX2PY2({0,0,0}, {0,0,0}) value 1
2970f2 SUMX2PY2 =SUMX2PY2({3}, {4}) value 1
56ca49 SUMXMY2 =SUMXMY2({1,2,3}, {4,5,6}) value 1
297c96 SUMXMY2 =SUMXMY2({1,2,3}, {1,2,3}) value 1
21a24e SUMXMY2 =SUMXMY2({5}, {2}) value 1
ceb68a FREQUENCY =FREQUENCY(A1:A5, B1:B2) value 2
5272bd FREQUENCY =FREQUENCY(A1:A3, B1) value 2
634b1b FREQUENCY =FREQUENCY(A1:A3, B1) value 2
5712e5 FREQUENCY =FREQUENCY({1;2;3;4;5}, {2;4}) value
668593 LINEST =LINEST({1,2,3}, {1,2,3}) value
672149 LINEST =LINEST({1,2,3,4}, {1,2,3,4}, TRUE, TRUE) value
8e79e5 LINEST =LINEST({2,4,6,8}) value
5df3a8 LOGEST =LOGEST({2,4,8,16}, {1,2,3,4}) value
443836 LOGEST =LOGEST({2,4,8,16}, {1,2,3,4}, TRUE, TRUE) value
3e81ca LOGEST =LOGEST({2,4,8,16}) value
0d581c TREND =TREND({1,2,3}, {1,2,3}, {4,5}) value
63786b TREND =TREND({2,4,6,8}) value
baea7c TREND =TREND({1,2,3,4}, {1,2,3,4}, {5;6;7}) value
5e29d5 GROWTH =GROWTH({2,4,8,16}, {1,2,3,4}, {5}) value
9dbe02 GROWTH =GROWTH({2,4,8,16}) value
ac04f1 GROWTH =GROWTH({2,4,8,16}, {1,2,3,4}, {5;6}) value