2017-02-06T16:46:42.211764694P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/326729ce54de5296cb2a673ae88d2befa3e245ef 0 0 88700 28077 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 VAR.P Function Result TRUE Sheet Result Description 1 TRUE Simple VAR.P formulas with local references and values Function Expected Correct FunctionString Comment 1 10 1 0 Data Data Data 1 Data 2 0.402599231572822 0.169946761336178 8.55266500000000E+006 3.07492200000000E+006 Strength 10 10 TRUE =VAR.P(F1:F11) 2 11 2 0 Known y Known x 1.959999998 3 6 0.194342606933787 0.553136259317398 7.48166900000000E+006 8.55681300000000E+006 1345 2.80000000000000E+001 28 TRUE =VAR.P(F1:H11) 3 12 3 0 2 6 60 4 19 0.400653343414888 0.600289918482304 2.50928400000000E+006 7.40836500000000E+006 1301 0 0 TRUE =VAR.P(I1:I11) 4 13 4 0 3 5 5 3 0.166463582077995 0.933991111814976 4.72805200000000E+006 7.07801700000000E+006 1368 14 14 TRUE =VAR.P(H1:I11) 5 14 5 0 9 11 8 2 0.087469917023554 0.263295787386596 9.49210600000000E+006 4.54303500000000E+006 1322 11573135223.6451 11573135223.6451 TRUE =VAR.P(F1:H15) 6 15 6 0 1 7 9 14 0.341886235401034 0.61026608501561 9.19008300000000E+006 7.35686900000000E+006 1310 842.16040005804 842.16040005804 TRUE =VAR.P(O2,O3) 7 16 7 0 8 5 1 4 0.946274813031778 0.417558070970699 3.18773900000000E+006 1.00558500000000E+006 1370 0.093911262626441 0.093911262626441 TRUE =VAR.P(T1:U50) 8 17 8 0 7 4 2 5 0.984649823047221 0.102857194375247 8.53267200000000E+006 6.93940000000000E+006 1318 5.77777777777778 5.77777777777778 TRUE =VAR.P({1,5,8,9,9,6,8,5,6}) 9 18 9 0 5 4 4 17 0.910959278000519 0.79397261980921 3.34187900000000E+006 4.68564200000000E+006 1350 30.25 30.25 TRUE {=VAR.P(F1:F11,G1:G11)} 10 19 10 0 5 1 0.730935096507892 0.062783702509478 4.90843300000000E+006 2.65798400000000E+006 1303 7385525259303.83 7385525259303.83 TRUE =VAR.P(W1:X50) 11 20 11 0 0.208618188742548 0.416508829686791 3.86574100000000E+006 1.50118400000000E+006 1299 6.96428571428571 6.96428571428571 TRUE =VAR.P(L2:M9) 0.731778104091063 0.001483274623752 2.76786900000000E+006 9.43757800000000E+006 215.2425 215.2425 TRUE =VAR.P(34.5, 2, 8.9, -4) 0.960519265849143 0.986836141906679 3.93831100000000E+006 6.73757500000000E+006 2.66666666666667 2.66666666666667 TRUE =VAR.P(2, 6, 4) 0.176640923600644 0.868845847435296 5.62500900000000E+006 9.87330300000000E+006 0 0 TRUE =VAR.P(5) 654654 654 1 0.47322227130644 0.174563129432499 7.26761800000000E+006 9.07961200000000E+006 #DIV/0! #DIV/0! TRUE =VAR.P() 0.111749193863943 0.84864505729638 9.43154800000000E+006 1.84777400000000E+006 678.84 678.84 TRUE =VAR.P(Z2:Z11) 0.370022197486833 0.723300355952233 3.55914100000000E+006 9.00903000000000E+006 754.266666666667 754.266666666667 TRUE =VAR.S(Z2:Z11) 0.120431510265917 0.000142202246934 5.94570300000000E+006 7.89895700000000E+006 18.25 18.25 TRUE =VAR.P(F1,F3,F5,F8,F10,G1:G4,H3:H5,H7,I2:I4,H9,H10) 0.865659103030339 0.632935213157907 7.98415600000000E+006 4.39915700000000E+006 0.541276043280959 0.001646731514484 4.43262500000000E+006 9.69408800000000E+006 0.900038912659511 0.480235474649817 8.17817400000000E+006 1.03604600000000E+006 0.08523311605677 0.822807915043086 3.22504400000000E+006 9.99444600000000E+006 0.337206659838557 0.882674962980673 6.54156800000000E+006 8.04947400000000E+006 0.854269005125389 0.445781395072117 1.10735700000000E+006 2.60248600000000E+006 0.374721442349255 0.927562230965123 6.96348900000000E+006 8.73081000000000E+006 0.114541406510398 0.590035588946193 6.07706800000000E+006 9.31099400000000E+006 0.585630424786359 0.828813797561452 6.45186100000000E+006 7.77544400000000E+006 0.490436446852982 0.573860642267391 6.21535900000000E+006 2.27232600000000E+006 0.661826125346124 0.390011037467048 1.18509400000000E+006 6.20612800000000E+006 0.90019579930231 0.012589735211805 5.46699000000000E+006 5.74995700000000E+006 0.190245887031779 0.077871951973066 6.25142800000000E+006 8.96555000000000E+006 0.079322624951601 0.592421405483037 4.40051700000000E+006 7.33836300000000E+006 0.564420772949234 0.163427012506872 3.50607400000000E+006 4.92332500000000E+006 0.53767328010872 0.434568428434432 3.42016100000000E+006 8.04694500000000E+006 0.555512311169878 0.707729241810739 8.55000400000000E+006 8.66215600000000E+006 0.738904951605946 0.544847761048004 4.02916400000000E+006 1.91334400000000E+006 0.570837055100128 0.962746524251998 7.60632300000000E+006 1.17951400000000E+006 0.806615271605551 0.073412766680121 4.72676700000000E+006 7.70504400000000E+006 0.547012639464811 0.95261645084247 3.14918300000000E+006 2.39028700000000E+006 0.111656288150698 0.807385856285691 4.82673600000000E+006 9.09768300000000E+006 0.690662265289575 0.519585096277297 7.10288600000000E+006 3.93031100000000E+006 0.19111926923506 0.682888984447345 4.54493600000000E+006 1.94888800000000E+006 0.353901885449886 0.032841254025698 9.51617000000000E+006 4.86070600000000E+006 0.375091741094366 0.15249035647139 4.54480800000000E+006 9.52838400000000E+006 0.864874634193257 0.724242072319612 8.09813100000000E+006 2.28121000000000E+006 0.052185097476468 0.078180975746363 9.89248800000000E+006 1.13269400000000E+006 0.943212330807 0.398327849339694 8.89531600000000E+006 6.20171000000000E+006 0.391606026794761 0.100461794994771 8.12422800000000E+006 1.18423500000000E+006 0.037821719190106 0.152158367680386 9.92476900000000E+006 1.54978800000000E+006 0.206768939038739 0.676331433933228 4.06547700000000E+006 7.03343800000000E+006