2016-06-25T07:16:38.437590147P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/d2e4753c3f511cfc6b2932ce60d0bc2e09296f9f 0 0 66549 253671 view1 1 7 0 0 0 0 2 0 0 0 0 0 80 60 true false 0 47 0 0 0 0 2 0 0 0 28 0 80 60 true false 18 19 0 0 0 0 2 0 0 0 0 0 80 60 true false Sheet2 1241 0 80 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn en US fr FR ru RU true true 3 1 true 1 true qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= false 0 Kč - Kč $ $( ) $- £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ Kč - Kč Kč - Kč Kč - Kč Kč - Kč € - € € - € € - € € - € - - € - € - € - - € - € - € : : : : $ ($ ) $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - Yes Yes No True True False On On Off € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - - - € - € . / € - € ⌀ $ - $ ( ) - $ $( ) $- ( ) - $ € - € . . WAHR WAHR FALSCH $ - $ € - € € - € руб. - руб. / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 FREQUENCY Function Result TRUE Sheet Result Description 1 TRUE Simple FREQUENCY formulas with local references and values Function Expected Correct FunctionString Comment 12 5 Scores Bins Value Bin1 Bin2 1 1 TRUE {=FREQUENCY(K1:K11,L1:L6)} 8 10 79 70 38 4 80 3 3 TRUE {=FREQUENCY(K1:K11,L1:L6)} 24 15 85 79 32 10 2 2 TRUE {=FREQUENCY(K1:K11,L1:L6)} 11 20 78 89 89 45 3 3 TRUE {=FREQUENCY(K1:K11,L1:L6)} 5 25 85 6 80 4 1 1 TRUE {=FREQUENCY(K1:K11,L1:L6)} 20 >25 50 29 1 1 TRUE {=FREQUENCY(K1:K11,L1:L6)} 16 81 35 1 1 TRUE {=FREQUENCY(N2:N10,O2:O4)} 9 95 99 2 2 TRUE {=FREQUENCY(N2:N10,O2:O4)} 7 88 50 4 4 TRUE {=FREQUENCY(N2:N10,O2:O4)} 16 97 41 2 2 TRUE {=FREQUENCY(N2:N10,O2:O4)} 33 88 1 1 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 8 2 2 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -8 -8 40 3 3 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -7 -6 3 6 6 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -6 -4 95 8 8 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -5 -2 2 10 10 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -4 0 96 13 13 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -3 2 25 10 10 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -2 4 67 19 19 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} -1 6 13 9 9 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 0 17 6 6 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 1 95 4 4 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 2 76 4 4 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 3 79 3 3 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 4 92 2 2 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 5 97 0 0 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 6 54 0 0 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 7 92 0 0 TRUE {=FREQUENCY(Sheet3.A1:T5,K13:K29)} 8 62 1 1 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 70 5 5 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 56 14 14 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 12 23 23 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 2 29 29 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 70 15 15 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 93 8 8 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 36 5 5 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 57 0 0 TRUE {=FREQUENCY(Sheet3.A1:T5,N13:N20)} 66 0 0 TRUE {=FREQUENCY(K40:K59,L40:L46)} Data Categ. 94 2 2 TRUE {=FREQUENCY(K40:K59,L40:L46)} 1 0 1 66 2 2 TRUE {=FREQUENCY(K40:K59,L40:L46)} 2 3 30 4 4 TRUE {=FREQUENCY(K40:K59,L40:L46)} 3 4 2 51 2 2 TRUE {=FREQUENCY(K40:K59,L40:L46)} 4 8 72 2 2 TRUE {=FREQUENCY(K40:K59,L40:L46)} 5 10 65 2 2 TRUE {=FREQUENCY(K40:K59,L40:L46)} 6 12 62 6 6 TRUE {=FREQUENCY(K40:K59,L40:L46)} 7 14 68 30 30 TRUE {=FREQUENCY(Z2:Z561,AA2:AA5)} 8 >16 77 29 29 TRUE {=FREQUENCY(Z2:Z561,AA2:AA5)} 9 48 173 173 TRUE {=FREQUENCY(Z2:Z561,AA2:AA5)} 10 38 216 216 TRUE {=FREQUENCY(Z2:Z561,AA2:AA5)} 11 70 112 112 TRUE {=FREQUENCY(Z2:Z561,AA2:AA5)} 12 36 216 216 TRUE {=FREQUENCY(Z2:Z561,AB2:AB5)} 13 13 29 29 TRUE {=FREQUENCY(Z2:Z561,AB2:AB5)} 14 0 173 173 TRUE {=FREQUENCY(Z2:Z561,AB2:AB5)} 15 99 30 30 TRUE {=FREQUENCY(Z2:Z561,AB2:AB5)} 16 33 112 112 TRUE {=FREQUENCY(Z2:Z561,AB2:AB5)} 17 69 1 1 TRUE {=FREQUENCY(K40:K59,M40:M42)} 18 44 1 1 TRUE {=FREQUENCY(K40:K59,M40:M42)} 19 11 1 1 TRUE {=FREQUENCY(K40:K59,M40:M42)} 20 93 17 17 TRUE {=FREQUENCY(K40:K59,M40:M42)} 50 20 20 TRUE =SUM(ABS(FREQUENCY(K40:K59,L40:L46))) 57 #VALUE! #VALUE! TRUE =SUM(ABS(FREQUENCY(K40:K59,L40:L46)+ABS(M40:M47))) 58 9 9 TRUE =MAX(FREQUENCY(ROW(K40:K59),(K40:K59<12)*ROW(K40:K59))) 79 22 55 38 73 19 76 50 68 36 37 80 56 72 64 86 60 94 45 0 90 92 37 20 89 89 59 12 95 18 79 90 60 89 93 83 41 7 96 25 65 91 43 55 42 6 77 45 20 41 72 92 83 52 82 93 76 71 15 23 32 68 9 59 36 10 70 83 33 6 7 1 76 70 41 90 60 60 75 28 5 71 81 18 3 61 4 85 15 21 27 38 27 51 53 26 3 17 24 37 65 81 82 58 4 86 43 51 75 16 49 9 30 94 61 64 10 82 91 4 9 86 61 66 12 49 49 73 64 57 84 77 77 58 15 21 83 52 87 85 1 52 23 98 88 12 20 89 57 67 81 32 96 57 0 79 53 23 34 69 60 40 37 22 56 64 90 81 49 97 71 85 97 45 82 35 66 37 72 90 93 50 77 89 42 18 28 51 18 13 41 22 53 97 13 85 59 57 92 43 72 65 55 62 75 93 7 4 79 70 73 80 62 53 37 18 78 77 74 19 22 78 42 47 36 7 77 98 61 14 75 72 0 75 96 35 48 14 76 63 11 19 20 18 46 38 34 67 28 22 41 70 20 89 84 73 94 92 29 47 91 50 46 14 36 14 26 50 48 9 70 74 33 17 55 63 0 88 7 70 70 25 10 60 3 0 91 31 22 67 76 18 34 87 4 34 54 81 36 26 66 29 26 89 99 35 55 56 28 13 91 78 33 92 14 89 53 10 93 80 36 37 6 25 66 9 84 77 9 26 37 14 62 76 67 22 15 0 99 54 10 68 84 40 41 63 54 21 54 69 60 42 91 47 79 6 65 67 65 55 32 86 62 32 97 37 87 18 85 98 96 67 39 46 17 75 87 0 52 90 81 62 65 36 91 46 26 56 33 95 95 31 48 60 20 94 20 21 4 81 17 63 12 4 27 77 3 64 43 57 98 37 78 19 56 88 14 63 1 46 53 53 93 23 17 28 76 90 72 42 19 52 48 8 55 30 40 91 32 71 70 56 5 0 23 25 81 89 2 74 4 66 77 96 88 70 66 30 62 75 79 59 72 20 8 47 99 84 27 74 68 3 98 38 80 50 72 8 9 15 79 84 38 42 25 70 96 67 1 53 46 24 79 61 8 30 63 52 17 -7 -3 -2 -6 -7 2 4 -3 -2 -4 -3 0 -3 -1 3 -3 -3 -4 -3 0 0 1 -2 0 5 0 -4 -2 -5 1 -2 0 -4 -3 -4 5 0 -1 4 5 -1 0 -2 -2 -4 0 -5 0 -1 0 -2 -2 -4 0 -4 -8 -2 1 6 1 -6 0 -2 2 -5 -5 -2 1 -6 0 -2 2 -5 -5 -1 -1 1 -1 -1 -1 4 3 2 1 -3 -1 1 4 3 2 3 1 -3 4 O5 yes 1 no 2 yes 3