2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b8832ff972a4e9f3e03fd7d96882b2a78c03b3e 0 0 103829 24597 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 2 28 0 0 0 0 2 0 0 0 12 0 75 60 true false Sheet2 1241 0 75 60 false true true true 12632256 true true true true true 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 cs CZ de DE en US nl NL true true 3 1 true 1 true lgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== false 0 Kč - Kč ( ) - Kč - Kč Kč - Kč Kč - Kč Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € - € / / / / € - € Kč - Kč Kč - Kč Kč - Kč Kč - Kč - - - - - - Kč - Kč - Kč - - Kč - Kč - Kč : : : : Yes Yes No True True False On On Off ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % $ ( $ ) % % - % - - - £ - £ £ - £ % - % DM - DM DM - DM DM - DM DM - DM - - DM - DM - DM - - DM - DM - DM Ouch! - - Error detected! - Result=0 - No Errordetection / / / / ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - £ -£ £ -£ £ -£ £ -£ - - £ -£ £ - - - £ -£ £ - ￥ - ￥ DM - DM DM - DM DM - DM DM - DM DM - DM € € - tan aa zł - zł - - Kč - Kč - Kč - - Kč - Kč - Kč / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - % / / ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 HARMEAN Function Result TRUE Sheet Result Description 1 TRUE Simple HARMEAN formulas with local references and values Function Expected Correct FunctionString Comment 0 Err:502 Err:502 TRUE =HARMEAN(I1:I4) Check 5.3 0.1 5 9 0.192 0.192 TRUE =HARMEAN(I2:I5) 0.2 6 10 0.311688311688312 0.311688311688312 TRUE =HARMEAN(I3:I6) 0.3 7 11 0.421052631578947 0.421052631578947 TRUE =HARMEAN(I4:I7) 0.4 8 12 0.526645768025078 0.526645768025078 TRUE =HARMEAN(I5:I8) 0.5 0.630393996247655 0.630393996247655 TRUE =HARMEAN(I6:I9) 0.6 0.733090909090909 0.7330909090909090000 TRUE =HARMEAN(I7:I10) 0.7 0.835128417564209 0.835128417564209 TRUE =HARMEAN(I8:I11) 0.8 1.03597122302158 1.03597122302158 TRUE =HARMEAN(I9:I12) 0.9 1.35849056603774 1.35849056603774 TRUE =HARMEAN(I10:I13) 1 1.92 1.92 TRUE =HARMEAN(I11:I14) 2 3.11688311688312 3.11688311688312 TRUE =HARMEAN(I12:I15) 3 4.21052631578947 4.21052631578947 TRUE =HARMEAN(I13:I16) 4 5.26645768025078 5.26645768025078 TRUE =HARMEAN(I14:I17) 5 6.30393996247655 6.30393996247655 TRUE =HARMEAN(I15:I18) 6 7.33090909090909 7.33090909090909 TRUE =HARMEAN(I16:I19) 7 8.35128417564209 8.35128417564209 TRUE =HARMEAN(I17:I20) 8 9.3672383205204 9.3672383205204 TRUE =HARMEAN(I18:I21) 9 10.3800786369594 10.3800786369594 TRUE =HARMEAN(I19:I22) 10 11.3906405575838 11.3906405575838 TRUE =HARMEAN(I20:I23) 11 12.3994838709677 12.3994838709677 TRUE =HARMEAN(I21:I24) 12 13.4069981583794 13.4069981583794 TRUE =HARMEAN(I22:I25) 13 14.4134631248969 14.4134631248969 TRUE =HARMEAN(I23:I26) 14 15.4190848967472 15.4190848967472 TRUE =HARMEAN(I24:I27) 15 16.4240187856424 16.4240187856424 TRUE =HARMEAN(I25:I28) 16 17.4283840749415 17.4283840749415 TRUE =HARMEAN(I26:I29) 17 17.9629248197734 17.9629248197734 TRUE =HARMEAN(I27:I30) 18 18.4864864864865 18.4864864864865 TRUE =HARMEAN(I28:I31) 19 19 19 TRUE =HARMEAN(I29:I32) #NUM! #NUM! TRUE =HARMEAN(I30:I33) 37.6363636363636 37.6363636363636 TRUE =HARMEAN(23,46,69) 0.37265014140742 0.37265014140742 TRUE {=HARMEAN(I2:I5,J2:J5)} 0.37265014140742 0.37265014140742 TRUE =HARMEAN(I2:J5) 6.30393996247655 6.30393996247655 TRUE =HARMEAN({5,6,7,8}) 7.84408050652612 7.84408050652612 TRUE =HARMEAN({5,6,7,8;9,10,11,12}) 7.84408050652612 7.84408050652612 TRUE =HARMEAN(J2:K5)