2017-01-09T17:33:47.119982696P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/63ddc8dc4ae1f3c3ee2f860c34886688b0ed2d57 0 0 82301 31979 view1 2 8 0 0 0 0 2 0 0 0 0 0 100 60 true false 4 1 0 0 0 0 2 0 0 0 0 0 100 60 true false Sheet2 1241 0 100 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ł € - € : : : : € - € € - € ( ) - $ $ ( ) $ - ( ) - $ $ ( ) $ - € ( € ) ok ERR! - - Kč - Kč - Kč - - Kč - Kč - Kč ¥€ ( € ) / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 STANDARDIZE Function Result TRUE Sheet Result Description 1 TRUE Simple STANDARDIZE formulas with local references and values Function Expected Correct FunctionString Comment -1 13.4 2 Data Day Temp (F) 1 1 TRUE =STANDARDIZE(11,10,1) -0.5 14.4 3 42 1/7/2011 89 -7.2 -7.2 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 0 15.4 4 40 2/7/2011 88 -4.96666666666667 -4.96666666666667 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 0.5 16.4 5 1.5 3/7/2011 92 -3.85 -3.85 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 1 17.4 6 4/7/2011 101 -3.18 -3.18 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 1.5 18.4 7 5/7/2011 94 -2.73333333333333 -2.73333333333333 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 2 19.4 8 6/7/2011 97 -2.41428571428571 -2.41428571428571 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 2.5 20.4 9 7/7/2011 95 -2.175 -2.175 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 3 21.4 10 -1.98888888888889 -1.98888888888889 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 3.5 22.4 11 -1.84 -1.84 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 4 23.4 12 -1.71818181818182 -1.71818181818182 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 4.5 24.4 13 -1.61666666666667 -1.61666666666667 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 5 25.4 14 -1.53076923076923 -1.53076923076923 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 5.5 26.4 15 -1.45714285714286 -1.45714285714286 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 6 27.4 16 -1.39333333333333 -1.39333333333333 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 6.5 28.4 17 -1.3375 -1.3375 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 7 29.4 18 -1.28823529411765 -1.28823529411765 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 7.5 30.4 19 -1.24444444444444 -1.24444444444444 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 8 31.4 20 -1.20526315789474 -1.20526315789474 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 8.5 32.4 21 -1.17 -1.17 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 9 33.4 22 -1.13809523809524 -1.13809523809524 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 9.5 34.4 23 -1.10909090909091 -1.10909090909091 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 10 35.4 24 -1.08260869565217 -1.08260869565217 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 10.5 36.4 25 -1.05833333333333 -1.05833333333333 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 11 37.4 26 -1.036 -1.036 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 1 -1.01538461538462 -1.01538461538462 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 0 0 TRUE {=STANDARDIZE(H1:H26,I1:I26,J1:J26)} 7.2 7.2 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 4.96666666666667 4.96666666666667 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 3.85000000000000E+000 3.85 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 3.18000000000000E+000 3.18 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 2.73333333333333E+000 2.73333333333333 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 2.41428571428571E+000 2.41428571428571 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 2.17500000000000E+000 2.175000 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.98888888888889E+000 1.988889 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.84000000000000E+000 1.840000 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.71818181818182E+000 1.718182 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.61666666666667E+000 1.616667 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.53076923076923E+000 1.530769 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.45714285714286E+000 1.457143 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.39333333333333E+000 1.393333 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.33750000000000E+000 1.337500 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.28823529411765E+000 1.288235 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.24444444444444E+000 1.24444444444444 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.20526315789474E+000 1.20526315789474 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.17000000000000E+000 1.17 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.13809523809524E+000 1.138095 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.10909090909091E+000 1.10909090909091 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.08260869565217E+000 1.08260869565217 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.05833333333333E+000 1.05833333333333 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.03600000000000E+000 1.036 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.01538461538462E+000 1.01538461538462 TRUE {=STANDARDIZE(I1:I25,H1:H25,J1:J25)} 1.33333333333333 1.333333 TRUE =STANDARDIZE(L2,L3,L4) Err:502 Err:502 TRUE =STANDARDIZE(11,10,-1) Err:511 Err:511 TRUE =STANDARDIZE(11,10) #DIV/0! #DIV/0! TRUE =STANDARDIZE(11,10,)