2016-07-24T08:15:55.362000000P0D1LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/f9f090d0d0f2b454d6c1dd14fe735e7e83fda9da 0 0 46511 12938 view1 2 8 0 0 0 0 2 0 0 0 0 0 75 60 true false 4 4 0 0 0 0 2 0 0 0 0 0 75 60 true false Sheet2 1241 0 75 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 cs CZ en US nl NL true true 3 1 true 1 true kQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= 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 ¥€ ( € ) € - € $ ($ ) € - € € - € € - € € - € - - € - € - € - - € - € - € $ ($ ) $ ($ ) $ ($ ) ( ) - $ $ ( ) $ - $ $ ( ) $ - € ( € ) \ \- \ \- \ \- \ \- \ \ - \ - - - \ \ - \ - - - - - - - $ $( ) $- ( ) - $ $( ) $- ( ) - % % % % % % % % % % € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € € - € % % % % % % / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) - : : : . . : : : . . : - - - - € - € € - € € - € € - € % % / / / / $ - $ ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 TBILLYIELD Function Result TRUE Sheet Result Description 1 TRUE Simple TBILLYIELD formulas with local references and values Function Expected Correct FunctionString Comment Data Description $6,346.99 6346.98524740594 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), 0.0914) 03/31/08 Settlement date 6346.98524740594 6346.98524740594 TRUE =TBILLYIELD(I2,I3,I4) 06/01/08 Maturity date 4970.38674033149 4970.38674033149 TRUE =TBILLYIELD(DATE(2008,7,14), DATE(2009,1,14), 0.04) #tdf 101071 9.14% Percent discount rate Err:502 error TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), ) Err:504 error TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1)) Err:502 error TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), 0) Err:502 error TRUE =TBILLYIELD(DATE(1999,8,31),DATE(1999,6,1), 0.0914) Err:502 error TRUE =TBILLYIELD(DATE(1999,3,31),, 0.0914) Err:502 error TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), -0.0914) $5,800.65 5800.64516129032 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I11) 0.1 $2,897.42 2897.41935483871 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I12) 0.2 $1,929.68 1929.67741935484 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I13) 0.3 $1,445.81 1445.8064516129 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I14) 0.4 $1,155.48 1155.48387096774 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I15) 0.5 $961.94 961.935483870968 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I16) 0.6 $823.69 823.686635944701 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I17) 0.7 $720.00 720 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I18) 0.8 $639.35 639.354838709678 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I19) 0.9 $574.84 574.838709677419 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I20) 1 $522.05 522.052785923754 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I21) 1.1 $478.06 478.064516129032 TRUE =TBILLYIELD(DATE(1999,3,31),DATE(1999,6,1), I22) 1.2 4