From 4546efb5c9bd531992aeddf2ac1394a5fd71a7c2 Mon Sep 17 00:00:00 2001 From: Zdeněk Crhonek Date: Tue, 5 Jul 2016 06:19:36 +0200 Subject: add MIRR test case Change-Id: I7c16212b5f1832aa5d79c8e883fc5cd103f0657b Reviewed-on: https://gerrit.libreoffice.org/26925 Tested-by: Jenkins Reviewed-by: Markus Mohrhard --- sc/qa/unit/data/functions/fods/mirr.fods | 1753 ++++++++++++++++++++++++++++++ 1 file changed, 1753 insertions(+) create mode 100644 sc/qa/unit/data/functions/fods/mirr.fods (limited to 'sc') diff --git a/sc/qa/unit/data/functions/fods/mirr.fods b/sc/qa/unit/data/functions/fods/mirr.fods new file mode 100644 index 000000000000..e3bf456fc5d8 --- /dev/null +++ b/sc/qa/unit/data/functions/fods/mirr.fods @@ -0,0 +1,1753 @@ + + + + 2016-07-05T06:13:58.681960260P0D1LibreOffice/5.1.3.2$Linux_X86_64 LibreOffice_project/10m0$Build-2 + + + 0 + 0 + 36103 + 11717 + + + view1 + + + 2 + 7 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + 4 + 15 + 0 + 0 + 0 + 0 + 2 + 0 + 0 + 0 + 0 + 0 + 100 + 60 + true + + + Sheet2 + 1185 + 0 + 100 + 60 + false + true + true + true + 12632256 + true + true + true + true + false + false + false + 1270 + 1270 + 1 + 1 + true + + + + + 7 + false + false + true + true + false + false + false + 1270 + 1270 + true + true + true + true + true + true + true + false + 12632256 + false + Lexmark-E352dn + + + cs + CZ + + + + + + en + US + + + + + + nl + NL + + + + + + 3 + 1 + true + 1 + true + qQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY= + 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 + + + + + + + + + + + + + + + + + + + + + + + + + + + MIRR Function + + + + + + + + + Result + + + TRUE + + + + + + + + + Sheet + + + Result + + + Description + + + + + 1 + + + TRUE + + + Simple MIRR formulas with local references and values + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Function + + + Expected + + + Correct + + + FunctionString + + + Comment + + + -5 + + + 5 + + + -5 + + + -7500 + + + -10000 + + + + + + + + + + + + 18.74% + + + 0.1873622509 + + + TRUE + + + =MIRR(I1:I5, 0.05, 0.08) + + + + -10 + + + 10 + + + 3000 + + + 3400 + + + + + + + + + + + + 7.04% + + + 0.0703949397 + + + TRUE + + + =MIRR(J1:J4, 0.065, 0.1) + + + + -15 + + + 15 + + + 5000 + + + 6500 + + + + + + + + + + + + 7.04% + + + 0.0703949397 + + + TRUE + + + =MIRR(J1:J4, , 0.1) + + + + -8 + + + 8 + + + 1200 + + + 1000 + + + + + + + + + + + + 2.91% + + + 0.0291424666 + + + TRUE + + + =MIRR(J1:J4, 0.065, ) + + + + 4000 + + + + + + + + + + + + + 2.91% + + + 0.0291424666 + + + TRUE + + + =MIRR(J1:J4, 0.065, F6) + + + + + + + + + 7.04% + + + 0.0703949397 + + + TRUE + + + =MIRR(J1:J4, -0.065,0.1 ) + + + + + + + + + + -1.34% + + + -0.0133781775 + + + TRUE + + + =MIRR(J1:J4, 0.065, -0.1) + + + + + + + + + + + + 94.16% + + + 0.9416473767 + + + TRUE + + + =MIRR(H1:H4,0.5,0.1) + + + + + + + + + Chyba:511 + + + error + + + TRUE + + + =MIRR(, 0.065, 0.1) + + + + + + + + + + + Chyba:511 + + + error + + + TRUE + + + =MIRR(H1:H4) + + + + + + + + Chyba:511 + + + error + + + TRUE + + + =MIRR(H1:H4,0.5) + + + + + + + + #NUM! + + + error + + + TRUE + + + =MIRR(G1:G4,0.51,0.1) + + + Values shall contain at least one positive value and at least one negative value. + + + + + + + + + + + + + + + -100.00% + + + error + + + + =MIRR(F1:F4,0.51,0.1) + + + Tdf#100767 Values shall contain at least one positive value and at least one negative value. + + + + + + + + Chyba:504 + + + 0.0703949397 + + + + =MIRR({-10000;3400;6500;1000}, 0.065, 0.1) + + + Tdf#58585 + + + + + + + + + + + MIRRSummary: Returns the modified internal rate of return (IRR) of a series of periodic investmentsSyntax: MIRR( Array Values ; Number Investment ; Number ReinvestRate )Returns: PercentageConstraints: Values shall contain at least one positive value and at least one negative value.Semantics: Values is a series of periodic income (positive values) and payments (negative values) at regular intervals (Text and Empty cells are ignored). Investment is the rate of interest of the payments (negative values); ReinvestRate is the rate of interest of the reinvestment (positive values). + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + 4 + + + + + + + + + + + + \ No newline at end of file -- cgit