2017-01-09T17:31:32.775026899P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/63ddc8dc4ae1f3c3ee2f860c34886688b0ed2d57 0 0 82301 57162 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č ¥€ ( € ) kr - kr / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : ( ) % ( ) - ( ) - ( ) - ( ) - . . : : : . . : - - - - € - € € - € € - € € - € : : : € € - € € - € € - € € - - - - - - - : : : : : : - - : - - - - - - € € - € - - - € € - € - ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 STDEV.P Function Result TRUE Sheet Result Description 1 TRUE Simple STDEV.P formulas with local references and values Function Expected Correct FunctionString Comment 1 5 1.00E+030 Data Data 12.55 44 Day Temp (F) 2 2 TRUE =STDEV.S(2, 6, 4) 2 6 1.00E+030 Known y Known x 3 13.55 6 1/7/2011 89 4.13682584262623 4.13682584262623 TRUE =STDEV.S(F1:G14) 3 7 1.00E+030 900000002 899999998 2 6 4 1345 65 46 2/7/2011 88 58.6548849533692 58.6548849533692 TRUE =STDEV.S(I3:J101) 4 8 900000003 899999997 3 5 5 1301 15.55 5 3/7/2011 92 2.73861278752583 2.73861278752583 TRUE =STDEV.S(L3:M9) 5 9 900000004 899999996 9 11 2 1368 6 4 4/7/2011 101 1.49443411809733 1.49443411809733 TRUE =STDEV.S(O2:O11) 6 10 900000005 899999995 1 7 3 1322 6 2 5/7/2011 94 #DIV/0! #DIV/0! TRUE =STDEV.S(F1) 7 11 900000015 899999994 8 5 4 1310 8 5 6/7/2011 97 0 0 TRUE =STDEV.S(H1:H3) 8 12 900000007 899999993 7 4 5 1370 9 4 7/7/2011 95 Err:504 Err:504 TRUE =STDEV.S("red",1,2) 9 13 900000008 899999992 5 4 6 1318 45 12 27.4639157198435 27.4639157198435 TRUE =STDEV.S(P3:P12) 10 14 900000009 899999991 4 1350 63521 5 7.98668019206746 7.98668019206746 TRUE =STDEV.S(F14:G15) 11 15 900000010 899999990 7 1.30300000000000E+003 654 9 16.9407792028584 16.9407792028584 TRUE =STDEV.S(34.5, 2, 8.9, -4) 900000011 899999989 1299 2 1 900000012 899999988 5 4 14.8333358764648 900000013 899999987 27.46392 17 -1 a 1 900000014 899999986 14.8 654 2 900000015 899999985 15.8 9 654 900000016 899999984 16.8 2 900000017 899999983 17.8 29.55 654 900000018 899999982 18.8 654 2 900000019 899999981 19.8 54 65 900000020 899999980 20.8 58 6 900000021 899999979 21.8 56 321 900000022 899999978 22.8 96 5 900000023 899999977 900000024 899999976 900000025 899999975 900000026 899999974 900000027 899999960 900000028 899999972 900000029 899999971 900000030 899999970 900000031 899999969 900000032 899999968 900000033 899999967 900000034 899999966 900000035 899999965 900000036 899999964 900000037 899999963 900000038 899999962 900000039 899999961 900000040 899999960 900000041 899999959 900000042 899999958 900000043 899999957 900000044 899999956 900000045 899999955 900000046 899999954 900000047 899999953 900000048 899999952 900000049 899999951 900000050 899999950 900000051 899999949 900000052 899999948 900000053 899999947 900000054 899999946 900000055 899999945 900000056 899999944 900000057 899999943 900000058 899999942 900000059 899999941 900000060 899999940 900000061 899999939 900000062 899999938 900000063 899999937 900000064 899999936 900000065 899999935 900000066 899999934 900000067 899999933 900000068 899999932 900000069 899999931 900000070 899999930 900000071 899999929 900000072 899999928 900000073 899999927 900000074 899999926 900000075 899999925 900000076 899999924 900000077 899999923 900000078 899999922 900000079 899999921 900000080 899999920 900000081 899999919 900000082 899999918 900000083 899999917 900000084 899999916 900000085 899999915 900000086 899999914 900000087 899999913 900000088 899999912 900000089 899999911 900000090 899999910 900000091 899999909 900000092 899999908 900000093 899999907 900000094 899999906 900000095 899999905 900000096 899999904 900000097 899999903 900000098 899999902 900000099 899999901 900000100 899999900