Lines Matching refs:Value
41 static Value TestDouble(const QString& formula, const Value& v2, int accuracy) in TestDouble()
50 Value result = f.eval(); in TestDouble()
64 static Value TestSimple(const QString& formula) in TestSimple()
78 …RINT( \"1992-12-01\"; \"1993-06-01\"; \"1993-07-01\"; 0.055; 100 ; 2; 0 ) ", Value(3.2083333333)); in testACCRINT()
80 Value(16.9444444444)); // A security is issued on 2.28.2001. in testACCRINT()
84 …CHECK_EVAL("ACCRINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 4; 0 )", Value(24.… in testACCRINT()
85 …RINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 4; 1 )", Value(24.590164)); … in testACCRINT()
86 …CHECK_EVAL("ACCRINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 4; 2 )", Value(25)… in testACCRINT()
87 …RINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 4; 3 )", Value(24.657534)); … in testACCRINT()
88 …CHECK_EVAL("ACCRINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 4; 4 )", Value(25)… in testACCRINT()
89 …CHECK_EVAL("ACCRINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 1 )", Value(24.… in testACCRINT()
90 …CHECK_EVAL("ACCRINT( \"2004-02-01\"; \"2004-04-01\"; \"2004-05-01\"; 0.1; 1000; 2 )", Value(24.… in testACCRINT()
92 …SIS.GETACCRINT( \"1992-12-01\";\"1993-06-01\";\"1993-07-01\";0.055;100;2;0)", Value(3.2083333333)); in testACCRINT()
99 CHECK_EVAL_SHORT("ACCRINTM( \"2001-04-01\"; \"2001-06-15\"; 0.1; 1000; 3 )", Value(20.5479454)); in testACCRINTM()
100 …CHECK_EVAL_SHORT("ACCRINTM( \"2004-02-01\"; \"2004-05-01\"; 0.1; 1000; 0 )", Value(24.722222)); … in testACCRINTM()
101 …CHECK_EVAL_SHORT("ACCRINTM( \"2004-02-01\"; \"2004-05-01\"; 0.1; 1000; 1 )", Value(24.590164)); … in testACCRINTM()
102 …CHECK_EVAL_SHORT("ACCRINTM( \"2004-02-01\"; \"2004-05-01\"; 0.1; 1000; 2 )", Value(25.0)); … in testACCRINTM()
103 …CHECK_EVAL_SHORT("ACCRINTM( \"2004-02-01\"; \"2004-05-01\"; 0.1; 1000; 3 )", Value(24.657534)); … in testACCRINTM()
104 …CHECK_EVAL_SHORT("ACCRINTM( \"2004-02-01\"; \"2004-05-01\"; 0.1; 1000; 4 )", Value(25.0)); … in testACCRINTM()
106 …ET.ADDIN.ANALYSIS.GETACCRINTM( \"2001-04-01\"; \"2001-06-15\"; 0.1; 1000; 3 )", Value(20.5479454)); in testACCRINTM()
113 CHECK_EVAL("AMORDEGRC( 2400; 34199; 34334; 300; 1; 0.15; 1 )" , Value(775)); in testAMORDEGRC()
116 …CHECK_EVAL("AMORDEGRC( 50000; \"2003-01-01\"; \"2003-12-31\"; 500; 1; 0.15; 1 )" , Value(11738)); … in testAMORDEGRC()
117 …CHECK_EVAL("AMORDEGRC( 50000; \"2003-01-01\"; \"2003-12-31\"; 500; 2; 0.15; 1 )" , Value(7336)); … in testAMORDEGRC()
118 …CHECK_EVAL("AMORDEGRC( 50000; \"2003-01-01\"; \"2003-12-31\"; 500; 3; 0.15; 1 )" , Value(4585)); … in testAMORDEGRC()
119 …CHECK_EVAL("AMORDEGRC( 50000; \"2003-01-01\"; \"2003-12-31\"; 500; 4; 0.15; 1 )" , Value(2866)); … in testAMORDEGRC()
123 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 1 )" , Value(228)); … in testAMORDEGRC()
124 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 8; 0.1; 1 )" , Value(26)); … in testAMORDEGRC()
125 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 9; 0.1; 1 )" , Value(19)); … in testAMORDEGRC()
126 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 10; 0.1; 1 )" , Value(15)); … in testAMORDEGRC()
127 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.25; 1 )" , Value(342)); … in testAMORDEGRC()
128 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 0 )" , Value(229)); … in testAMORDEGRC()
129 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 1 )" , Value(228)); … in testAMORDEGRC()
130 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 2 )" , Value(231)); … in testAMORDEGRC()
131 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 3 )" , Value(228)); … in testAMORDEGRC()
132 …CHECK_EVAL("AMORDEGRC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 4 )" , Value(228)); … in testAMORDEGRC()
135 …SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETAMORDEGRC(2400;34199;34334;300;1;0.15;1)", Value(775)); in testAMORDEGRC()
141 …CHECK_EVAL_SHORT("AMORLINC( 1000; \"2004-02-01\"; \"2004-12-31\"; 10; 0; 0.1; 1 )" , Value(91.2568… in testAMORLINC()
142 …CHECK_EVAL_SHORT("AMORLINC( 1000; \"2006-02-01\"; \"2006-12-31\"; 10; 0; 0.1; 3 )" , Value(91.2328… in testAMORLINC()
143 ….ADDIN.ANALYSIS.GETAMORLINC(1000;\"2004-02-01\";\"2004-12-31\";10;0;0.1;1)", Value(91.2568306011)); in testAMORLINC()
150 CHECK_EVAL_SHORT("COMPOUND(5000;0.12;4;5)", Value(9030.556173)); in testCOMPOUND()
157 CHECK_EVAL_SHORT("CONTINUOUS(1000;0.1;1)", Value(1105.17091808)); in testCONTINUOUS()
164 CHECK_EVAL_SHORT("COUPDAYBS( DATE(1997;11;9); DATE(1999;11;15); 2 )", Value(174)); in testCOUPDAYBS()
165 CHECK_EVAL_SHORT("COUPDAYBS( DATE(1997;11;9); DATE(1999;11;15); 2; 1 )", Value(178)); in testCOUPDAYBS()
166 …CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 4; 0 )", Value(60)); // US (NASD) 30/… in testCOUPDAYBS()
167 … CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 4; 1 )", Value(60)); // actual/actual in testCOUPDAYBS()
168 CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 4; 2 )", Value(60)); // actual/360 in testCOUPDAYBS()
169 CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 4; 3 )", Value(60)); // actual/365 in testCOUPDAYBS()
170 …CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 4; 4 )", Value(60)); // European 30/3… in testCOUPDAYBS()
171 CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 1 )", Value(60)); // annual in testCOUPDAYBS()
172 CHECK_EVAL_SHORT("COUPDAYBS( DATE(2004;3;1); DATE(2009;1;1); 2 )", Value(60)); // semiannual in testCOUPDAYBS()
174 …M.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCOUPDAYBS( DATE(1997;11;9); DATE(1999;11;15); 2 )", Value(174)); in testCOUPDAYBS()
181 CHECK_EVAL_SHORT("COUPDAYS( DATE(1997;11;9); DATE(1999;11;15); 2 )", Value(180)); in testCOUPDAYS()
182 CHECK_EVAL_SHORT("COUPDAYS( DATE(1997;11;9); DATE(1999;11;15); 2; 1 )", Value(184)); in testCOUPDAYS()
183 …CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 4; 0 )", Value(90)); // US (NASD) 30/3… in testCOUPDAYS()
184 … CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 4; 1 )", Value(91)); // actual/actual in testCOUPDAYS()
185 CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 4; 2 )", Value(90)); // actual/360 in testCOUPDAYS()
186 … CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 4; 3 )", Value(91.25)); // actual/365 in testCOUPDAYS()
187 …CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 4; 4 )", Value(90)); // European 30/360 in testCOUPDAYS()
188 CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 1 )", Value(360)); // annual in testCOUPDAYS()
189 CHECK_EVAL_SHORT("COUPDAYS( DATE(2004;2;1); DATE(2009;1;1); 2 )", Value(180)); // semiannual in testCOUPDAYS()
191 …OM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCOUPDAYS( DATE(1997;11;9); DATE(1999;11;15); 2 )", Value(180)); in testCOUPDAYS()
198 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(1997;5;19); DATE(1999;11;15); 2 )", Value(176)); in testCOUPDAYSNC()
199 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(1997;5;19); DATE(1999;11;15); 2; 1 )", Value(180)); in testCOUPDAYSNC()
200 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 4; 0 )", Value(60)); in testCOUPDAYSNC()
201 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 4; 1 )", Value(60)); in testCOUPDAYSNC()
202 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 4; 2 )", Value(60)); in testCOUPDAYSNC()
203 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 4; 3 )", Value(60)); in testCOUPDAYSNC()
204 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 4; 4 )", Value(60)); in testCOUPDAYSNC()
205 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 1 )", Value(330)); // annual in testCOUPDAYSNC()
206 CHECK_EVAL_SHORT("COUPDAYSNC( DATE(2004;2;1); DATE(2009;1;1); 2 )", Value(150)); // semiannual in testCOUPDAYSNC()
208 ….SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCOUPDAYSNC( DATE(1997;5;19); DATE(1999;11;15); 2 )", Value(176)); in testCOUPDAYSNC()
215 …CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2007-01-01\"; 1; 1 )=DATE(2005;01;01)", Value(true));… in testCOUPNCD()
216 …CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2007-01-01\"; 2; 1 )=DATE(2004;07;01)", Value(true));… in testCOUPNCD()
217 …CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2007-01-01\"; 4; 1 )=DATE(2004;04;01)", Value(true));… in testCOUPNCD()
218 …CHECK_EVAL_EQUAL("COUPNCD( \"2007-01-01\"; \"2007-01-01\"; 1; 1 )", Value::errorVALUE()); // settl… in testCOUPNCD()
219 … CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2009-01-01\"; 4; 0 )=DATE(2004;04;01)", Value(true)); in testCOUPNCD()
220 … CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2009-01-01\"; 4; 1 )=DATE(2004;04;01)", Value(true)); in testCOUPNCD()
221 … CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2009-01-01\"; 4; 2 )=DATE(2004;04;01)", Value(true)); in testCOUPNCD()
222 … CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2009-01-01\"; 4; 3 )=DATE(2004;04;01)", Value(true)); in testCOUPNCD()
223 … CHECK_EVAL_EQUAL("COUPNCD( \"2004-01-01\"; \"2009-01-01\"; 4; 4 )=DATE(2004;04;01)", Value(true)); in testCOUPNCD()
225 ….ADDIN.ANALYSIS.GETCOUPNCD( \"2004-01-01\"; \"2007-01-01\"; 1; 1 )=DATE(2005;01;01)", Value(true)); in testCOUPNCD()
232 CHECK_EVAL_SHORT("COUPNUM( \"2004-01-01\"; \"2007-01-01\"; 1; 1 )", Value(3)); // Annual in testCOUPNUM()
233 … CHECK_EVAL_SHORT("COUPNUM( \"2004-01-01\"; \"2007-01-01\"; 2; 1 )", Value(6)); // Semiannual in testCOUPNUM()
234 CHECK_EVAL_SHORT("COUPNUM( \"2004-01-01\"; \"2007-01-01\"; 4; 1 )", Value(12)); // Quarterly in testCOUPNUM()
235 CHECK_EVAL_SHORT("COUPNUM( \"2004-02-01\"; \"2009-01-01\"; 4; 0 )", Value(20)); // in testCOUPNUM()
236 CHECK_EVAL_SHORT("COUPNUM( \"2004-02-01\"; \"2009-01-01\"; 4; 1 )", Value(20)); // in testCOUPNUM()
237 CHECK_EVAL_SHORT("COUPNUM( \"2004-02-01\"; \"2009-01-01\"; 4; 2 )", Value(20)); // in testCOUPNUM()
238 CHECK_EVAL_SHORT("COUPNUM( \"2004-02-01\"; \"2009-01-01\"; 4; 3 )", Value(20)); // in testCOUPNUM()
239 CHECK_EVAL_SHORT("COUPNUM( \"2004-02-01\"; \"2009-01-01\"; 4; 4 )", Value(20)); // in testCOUPNUM()
240 …CHECK_EVAL_SHORT("COUPNUM( \"2004-01-01\"; \"2004-04-30\"; 12; 1 )", Value(4)); // Monthly, to… in testCOUPNUM()
241 …CHECK_EVAL_SHORT("COUPNUM( \"2004-01-01\"; \"2004-05-01\"; 12; 1 )", Value(4)); // Monthly, to… in testCOUPNUM()
243 …SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCOUPNUM(\"2004-01-01\";\"2007-01-01\";1;1)", Value(3)); in testCOUPNUM()
250 …CHECK_EVAL_EQUAL("COUPPCD( \"2004-12-31\"; \"2007-01-01\"; 1; 1 )=DATE(2004;1;1)", Value(true)); /… in testCOUPPCD()
251 …CHECK_EVAL_EQUAL("COUPPCD( \"2004-12-31\"; \"2007-01-01\"; 2; 1 )=DATE(2004;7;1)", Value(true)); /… in testCOUPPCD()
252 …CHECK_EVAL_EQUAL("COUPPCD( \"2004-12-31\"; \"2007-01-01\"; 4; 1 )=DATE(2004;10;1)", Value(true)); … in testCOUPPCD()
253 …CHECK_EVAL_EQUAL("COUPPCD( \"2007-01-01\"; \"2004-01-01\"; 1; 1 )", Value::errorVALUE()); // settl… in testCOUPPCD()
254 … CHECK_EVAL_EQUAL("COUPPCD( \"2004-02-29\"; \"2009-01-01\"; 4; 0 )=DATE(2004;01;01)", Value(true)); in testCOUPPCD()
255 … CHECK_EVAL_EQUAL("COUPPCD( \"2004-02-29\"; \"2009-01-01\"; 4; 1 )=DATE(2004;01;01)", Value(true)); in testCOUPPCD()
256 … CHECK_EVAL_EQUAL("COUPPCD( \"2004-02-29\"; \"2009-01-01\"; 4; 2 )=DATE(2004;01;01)", Value(true)); in testCOUPPCD()
257 … CHECK_EVAL_EQUAL("COUPPCD( \"2004-02-29\"; \"2009-01-01\"; 4; 3 )=DATE(2004;01;01)", Value(true)); in testCOUPPCD()
258 … CHECK_EVAL_EQUAL("COUPPCD( \"2004-02-29\"; \"2009-01-01\"; 4; 4 )=DATE(2004;01;01)", Value(true)); in testCOUPPCD()
260 …ET.ADDIN.ANALYSIS.GETCOUPPCD( \"2004-12-31\"; \"2007-01-01\"; 1; 1 )=DATE(2004;1;1)", Value(true)); in testCOUPPCD()
267 …CHECK_EVAL_SHORT("CUMIPMT( 0.06/12; 5*12; 100000; 5; 12; 0 )", Value(-3562.187023)); /… in testCUMIPMT()
268 …CHECK_EVAL_SHORT("CUMIPMT( 0.06/12; 5*12; 100000; 5; 12; 1 )", Value(-3544.464699)); /… in testCUMIPMT()
269 …CHECK_EVAL_SHORT("CUMIPMT( 0.06/12; 5*12; 100000; 0; 0; 0 )", Value(Value::errorVALUE())); /… in testCUMIPMT()
270 …CHECK_EVAL_SHORT("CUMIPMT( 0.06/12; 5*12; 100000; 5; 61; 0 )", Value(Value::errorVALUE())); /… in testCUMIPMT()
271 …CHECK_EVAL_SHORT("CUMIPMT( 0.06/12; 5*12; 100000; 15; 12; 0 )", Value(Value::errorVALUE())); /… in testCUMIPMT()
273 …T("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCUMIPMT(0.06/12;5*12;100000;5;12;0)", Value(-3562.187023)); in testCUMIPMT()
280 …CHECK_EVAL_SHORT("CUMPRINC( 0.06/12; 5*12; 100000; 5; 12; 0 )", Value(-11904.054201)); /… in testCUMPRINC()
281 …CHECK_EVAL_SHORT("CUMPRINC( 0.06/12; 5*12; 100000; 5; 12; 1 )", Value(-11844.830051)); /… in testCUMPRINC()
282 …CHECK_EVAL_SHORT("CUMPRINC( 0.06/12; 5*12; 100000; 0; 0; 0 )", Value(Value::errorVALUE())); /… in testCUMPRINC()
283 …CHECK_EVAL_SHORT("CUMPRINC( 0.06/12; 5*12; 100000; 5; 61; 0 )", Value(Value::errorVALUE())); /… in testCUMPRINC()
284 …CHECK_EVAL_SHORT("CUMPRINC( 0.06/12; 5*12; 100000;15; 12; 0 )", Value(Value::errorVALUE())); /… in testCUMPRINC()
286 …"COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETCUMPRINC(0.06/12;5*12;100000;5;12;0)", Value(-11904.054201)); in testCUMPRINC()
294 CHECK_EVAL("DB(1000000; 100000; 6; 1; 7)", Value(186083.3333333333)); in testDB()
295 CHECK_EVAL("DB(1000000; 100000; 6; 2; 7)", Value(259639.4166666667)); in testDB()
296 CHECK_EVAL("DB(1000000; 100000; 6; 3; 7)", Value(176814.4427500000)); in testDB()
297 CHECK_EVAL("DB(1000000; 100000; 6; 4; 7)", Value(120410.6355127500)); in testDB()
298 CHECK_EVAL("DB(1000000; 100000; 6; 5; 7)", Value(81999.64278418274)); in testDB()
299 CHECK_EVAL("DB(1000000; 100000; 6; 6; 7)", Value(55841.75673602846)); in testDB()
300 CHECK_EVAL("DB(1000000; 100000; 6; 7; 7)", Value(15845.09847384807)); in testDB()
303 CHECK_EVAL("DB(2500; 500; 3; 1; 6)", Value(518.750000000000)); in testDB()
304 CHECK_EVAL("DB(2500; 500; 3; 2; 6)", Value(822.218750000000)); in testDB()
305 CHECK_EVAL("DB(2500; 500; 3; 3; 6)", Value(480.997968750000)); in testDB()
306 CHECK_EVAL("DB(2500; 500; 3; 4; 6)", Value(140.691905859375)); in testDB()
309 CHECK_EVAL("DB(4000;500;4;2)", Value(963.90)); in testDB()
310 CHECK_EVAL("DB(4000;500;4;2;2)", Value(1510.65)); in testDB()
311 CHECK_EVAL("DB(4000;500;4;5)", Value(0.0)); in testDB()
312 CHECK_EVAL("DB(0;500;4;2)", Value(Value::errorNUM())); in testDB()
313 CHECK_EVAL("DB(4000;-500;4;2)", Value(Value::errorNUM())); in testDB()
314 CHECK_EVAL("DB(4000;500;0;0)", Value(Value::errorNUM())); in testDB()
315 CHECK_EVAL("DB(4000;500;2;0)", Value(Value::errorNUM())); in testDB()
323 CHECK_EVAL("DDB(2400; 300; 10*365; 1; 2)", Value(1.31506849315065)); in testDDB()
324 CHECK_EVAL("DDB(2400; 300; 10*12; 1; 2)", Value(40.0)); in testDDB()
325 CHECK_EVAL("DDB(2400; 300; 10; 1; 2)", Value(480.0)); in testDDB()
326 CHECK_EVAL("DDB(2400; 300; 10; 2; 1.5)", Value(306)); in testDDB()
327 CHECK_EVAL("DDB(2400; 300; 10; 10; 2)", Value(22.1225472000002)); in testDDB()
330 CHECK_EVAL("DDB(2500; 500; 24; 1; 2)", Value(208.333333333333)); in testDDB()
331 CHECK_EVAL("DDB(2500; 500; 24; 2; 2)", Value(190.972222222222)); in testDDB()
332 CHECK_EVAL("DDB(2500; 500; 24; 3; 2)", Value(175.057870370370)); in testDDB()
333 CHECK_EVAL("DDB(2500; 500; 24; 4; 2)", Value(160.469714506173)); in testDDB()
334 CHECK_EVAL("DDB(2500; 500; 24; 5; 2)", Value(147.097238297325)); in testDDB()
335 CHECK_EVAL("DDB(2500; 500; 24; 6; 2)", Value(134.839135105881)); in testDDB()
336 CHECK_EVAL("DDB(2500; 500; 24; 7; 2)", Value(123.602540513725)); in testDDB()
337 CHECK_EVAL("DDB(2500; 500; 24; 8; 2)", Value(113.302328804248)); in testDDB()
338 CHECK_EVAL("DDB(2500; 500; 24; 9; 2)", Value(103.860468070560)); in testDDB()
339 CHECK_EVAL("DDB(2500; 500; 24; 10; 2)", Value(95.2054290646802)); in testDDB()
340 CHECK_EVAL("DDB(2500; 500; 24; 11; 2)", Value(87.2716433092901)); in testDDB()
341 CHECK_EVAL("DDB(2500; 500; 24; 12; 2)", Value(79.9990063668494)); in testDDB()
342 CHECK_EVAL("DDB(2500; 500; 24; 13; 2)", Value(73.3324225029452)); in testDDB()
343 CHECK_EVAL("DDB(2500; 500; 24; 14; 2)", Value(67.2213872943665)); in testDDB()
344 CHECK_EVAL("DDB(2500; 500; 24; 15; 2)", Value(61.6196050198359)); in testDDB()
345 CHECK_EVAL("DDB(2500; 500; 24; 16; 2)", Value(56.4846379348497)); in testDDB()
346 CHECK_EVAL("DDB(2500; 500; 24; 17; 2)", Value(51.7775847736120)); in testDDB()
347 CHECK_EVAL("DDB(2500; 500; 24; 18; 2)", Value(47.4627860424778)); in testDDB()
348 CHECK_EVAL("DDB(2500; 500; 24; 19; 2)", Value(22.0906464672553)); in testDDB()
349 CHECK_EVAL("DDB(2500; 500; 24; 20; 2)", Value(0)); in testDDB()
350 CHECK_EVAL("DDB(2500; 500; 24; 21; 2)", Value(0)); in testDDB()
351 CHECK_EVAL("DDB(2500; 500; 24; 22; 2)", Value(0)); in testDDB()
352 CHECK_EVAL("DDB(2500; 500; 24; 23; 2)", Value(0)); in testDDB()
353 CHECK_EVAL("DDB(2500; 500; 24; 24; 2)", Value(0)); in testDDB()
356 CHECK_EVAL("DDB(4000; 500; 4; 2; 2)", Value(1000)); in testDDB()
357 CHECK_EVAL("DDB(4000; 500; 4; 2)", Value(1000)); in testDDB()
358 CHECK_EVAL("DDB(1100; 100; 5; 5; 2.3 )", Value(0)); in testDDB()
361 CHECK_EVAL("DDB(2400; 300; 10*12; 1)", Value(40.0)); in testDDB()
362 CHECK_EVAL("DDB(2400; 300; 10; 1)", Value(480.0)); in testDDB()
363 CHECK_EVAL("DDB(2500; 500; 24; 22)", Value(0)); in testDDB()
364 CHECK_EVAL("DDB(2500; 500; 24; 23)", Value(0)); in testDDB()
365 CHECK_EVAL("DDB(2500; 500; 24; 24)", Value(0)); in testDDB()
368 CHECK_EVAL("DDB(2400; 300; 10; 0.8; 20)", Value(2100)); in testDDB()
369 CHECK_EVAL("DDB(2400; 300; 10; 1.0; 20)", Value(2100)); in testDDB()
370 CHECK_EVAL("DDB(2400; 300; 10; 1.2; 20)", Value(0)); in testDDB()
373 CHECK_EVAL("DDB(2400; 300; 10; 2; 2.5)", Value(450)); in testDDB()
374 CHECK_EVAL("DDB(2400; 300; 10; 2; 1.5)", Value(306)); in testDDB()
377 CHECK_EVAL("DDB(2400; 300; 10; 6.7; 2)", Value(134.5408487904432)); in testDDB()
378 CHECK_EVAL("DDB(2400; 300; 10; 7.7; 2)", Value(107.6326790323546)); in testDDB()
392 … CHECK_EVAL_SHORT("DISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 0)", Value(0.010339)); in testDISC()
393 …CHECK_EVAL_SHORT("DISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 1)", Value(0.010333)); … in testDISC()
394 … CHECK_EVAL_SHORT("DISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 2)", Value(0.010181)); in testDISC()
395 … CHECK_EVAL_SHORT("DISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 3)", Value(0.010322)); in testDISC()
396 … CHECK_EVAL_SHORT("DISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 4)", Value(0.010333)); in testDISC()
397 … CHECK_EVAL_SHORT("DISC( DATE(2006;01;01); date(2008;01;01); 200; 100; 3)", Value(-0.500000)); in testDISC()
398 CHECK_EVAL_SHORT("DISC( DATE(2006;01;01); date(2005;07;01); 95000; 100000; 4)", Value(false)); in testDISC()
399 …T.ADDIN.ANALYSIS.GETDISC( DATE(2004;02;29); date(2009;01;01); 95000; 100000; 0)", Value(0.010339)); in testDISC()
406 CHECK_EVAL_SHORT("DOLLARDE( 1.1 ; 8)" , Value(1.125)); // in testDOLLARDE()
407 CHECK_EVAL_SHORT("DOLLARDE( 2.13;16)" , Value(2.8125)); // in testDOLLARDE()
408 CHECK_EVAL_SHORT("DOLLARDE( 2.45;16)" , Value(4.8125)); // in testDOLLARDE()
409 CHECK_EVAL_SHORT("DOLLARDE( 1.16; 8)" , Value(1.2)); // in testDOLLARDE()
412 CHECK_EVAL_SHORT("DOLLARDE( 1.1 ; 2)" , Value(1.5)); // in testDOLLARDE()
413 CHECK_EVAL_SHORT("DOLLARDE( 1.25; 5)" , Value(1.5)); // in testDOLLARDE()
414 CHECK_EVAL_SHORT("DOLLARDE( 5.08; 4)" , Value(5.2)); // in testDOLLARDE()
415 CHECK_EVAL_SHORT("DOLLARDE( 5.24; 4)" , Value(5.6)); // in testDOLLARDE()
416 CHECK_EVAL_SHORT("DOLLARDE( 100.24; 4)" , Value(100.6)); // in testDOLLARDE()
417 CHECK_EVAL_SHORT("DOLLARFR(DOLLARDE( 101.2; 4);4)", Value(101.2)); // for- and backward in testDOLLARDE()
420 CHECK_EVAL_SHORT("DOLLARDE( 1.1; 4)" , Value(1.25)); // in testDOLLARDE()
421 CHECK_EVAL_SHORT("DOLLARDE( 1.1; 3)" , Value(1.333333)); // in testDOLLARDE()
422 CHECK_EVAL_SHORT("DOLLARDE( -1.1;10)" , Value(-1.1)); // in testDOLLARDE()
423 CHECK_EVAL_SHORT("DOLLARDE( 1.0; 5)" , Value(1)); // in testDOLLARDE()
424 CHECK_EVAL_SHORT("DOLLARDE( 1.1;10)" , Value(1.1)); // in testDOLLARDE()
425 CHECK_EVAL_SHORT("DOLLARDE( 1.1; 0)" , Value::errorVALUE()); // in testDOLLARDE()
428 CHECK_EVAL_SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETDOLLARDE(1.1;8)" , Value(1.125)); in testDOLLARDE()
435 CHECK_EVAL_SHORT("DOLLARFR( 1.1 ; 9)" , Value(1.09)); // in testDOLLARFR()
436 CHECK_EVAL_SHORT("DOLLARFR( 1.1 ; 11)" , Value(1.011)); // in testDOLLARFR()
437 CHECK_EVAL_SHORT("DOLLARFR( 1.1 ; 10)" , Value(1.1)); // in testDOLLARFR()
440 CHECK_EVAL_SHORT("DOLLARFR( 1.125 ; 8)" , Value(1.1)); // in testDOLLARFR()
441 CHECK_EVAL_SHORT("DOLLARFR( 1.5 ; 2)" , Value(1.1)); // in testDOLLARFR()
442 CHECK_EVAL_SHORT("DOLLARFR( 1.5 ; 8)" , Value(1.4)); // in testDOLLARFR()
443 CHECK_EVAL_SHORT("DOLLARFR( 1.5 ; 5)" , Value(1.25)); // in testDOLLARFR()
446 CHECK_EVAL_SHORT("DOLLARFR( 1.1 ;10)" , Value(1.1)); // in testDOLLARFR()
447 CHECK_EVAL_SHORT("DOLLARFR( 1.25; 4)" , Value(1.1)); // in testDOLLARFR()
448 …CHECK_EVAL_SHORT("DOLLARFR(-1.33333; 3)" , Value(-1.099999)); // ODF specs error (1.1) must b… in testDOLLARFR()
449 CHECK_EVAL_SHORT("DOLLARFR( 1.0; 5)" , Value(1)); // in testDOLLARFR()
450 CHECK_EVAL_SHORT("DOLLARFR( 1.1; 0)" , Value::errorVALUE()); // in testDOLLARFR()
453 CHECK_EVAL_SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETDOLLARFR( 1.1 ; 9)" , Value(1.09)); in testDOLLARFR()
460 CHECK_EVAL("DURATION( 0.1; 1000; 2000 )" , Value(7.2725408973)); // in testDURATION()
462 …CHECK_EVAL_SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETDURATION( 0.1; 1000; 2000 )" , Value(7.2725… in testDURATION()
468 …CHECK_EVAL("DURATION_ADD( \"1998-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 1 )" , Value(5.993774955… in testDURATION_ADD()
475 CHECK_EVAL_SHORT("EFFECT(0.08;12)", Value(0.083)); in testEFFECT()
477 CHECK_EVAL_SHORT("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETEFFECT(0.08;12)", Value(0.083)); in testEFFECT()
484 CHECK_EVAL("EURO(\"ATS\")", Value(13.7603)); in testEURO()
485 CHECK_EVAL("EURO(\"BEF\")", Value(40.3399)); in testEURO()
486 CHECK_EVAL("EURO(\"DEM\")", Value(1.95583)); in testEURO()
487 CHECK_EVAL("EURO(\"ESP\")", Value(166.386)); in testEURO()
488 CHECK_EVAL("EURO(\"EUR\")", Value(1.0)); in testEURO()
489 CHECK_EVAL("EURO(\"FIM\")", Value(5.94573)); in testEURO()
490 CHECK_EVAL("EURO(\"FRF\")", Value(6.55957)); in testEURO()
491 CHECK_EVAL("EURO(\"GRD\")", Value(340.75)); in testEURO()
492 CHECK_EVAL("EURO(\"IEP\")", Value(0.787564)); in testEURO()
493 CHECK_EVAL("EURO(\"ITL\")", Value(1936.27)); in testEURO()
494 CHECK_EVAL("EURO(\"LUX\")", Value(40.3399)); in testEURO()
495 CHECK_EVAL("EURO(\"NLG\")", Value(2.20371)); in testEURO()
496 CHECK_EVAL("EURO(\"PTE\")", Value(200.482)); in testEURO()
499 CHECK_EVAL("EURO(\"ats\")", Value(13.7603)); in testEURO()
500 CHECK_EVAL("EURO(\"bef\")", Value(40.3399)); in testEURO()
501 CHECK_EVAL("EURO(\"dem\")", Value(1.95583)); in testEURO()
502 CHECK_EVAL("EURO(\"esp\")", Value(166.386)); in testEURO()
503 CHECK_EVAL("EURO(\"eur\")", Value(1.0)); in testEURO()
504 CHECK_EVAL("EURO(\"fim\")", Value(5.94573)); in testEURO()
505 CHECK_EVAL("EURO(\"frf\")", Value(6.55957)); in testEURO()
506 CHECK_EVAL("EURO(\"grd\")", Value(340.75)); in testEURO()
507 CHECK_EVAL("EURO(\"iep\")", Value(0.787564)); in testEURO()
508 CHECK_EVAL("EURO(\"itl\")", Value(1936.27)); in testEURO()
509 CHECK_EVAL("EURO(\"lux\")", Value(40.3399)); in testEURO()
510 CHECK_EVAL("EURO(\"nlg\")", Value(2.20371)); in testEURO()
511 CHECK_EVAL("EURO(\"pte\")", Value(200.482)); in testEURO()
514 CHECK_EVAL("EURO(\"Ats\")", Value(13.7603)); in testEURO()
515 CHECK_EVAL("EURO(\"Bef\")", Value(40.3399)); in testEURO()
516 CHECK_EVAL("EURO(\"Dem\")", Value(1.95583)); in testEURO()
517 CHECK_EVAL("EURO(\"Esp\")", Value(166.386)); in testEURO()
518 CHECK_EVAL("EURO(\"Eur\")", Value(1.0)); in testEURO()
519 CHECK_EVAL("EURO(\"Fim\")", Value(5.94573)); in testEURO()
520 CHECK_EVAL("EURO(\"Frf\")", Value(6.55957)); in testEURO()
521 CHECK_EVAL("EURO(\"GrD\")", Value(340.75)); in testEURO()
522 CHECK_EVAL("EURO(\"IeP\")", Value(0.787564)); in testEURO()
523 CHECK_EVAL("EURO(\"Itl\")", Value(1936.27)); in testEURO()
524 CHECK_EVAL("EURO(\"luX\")", Value(40.3399)); in testEURO()
525 CHECK_EVAL("EURO(\"nlG\")", Value(2.20371)); in testEURO()
526 CHECK_EVAL("EURO(\"ptE\")", Value(200.482)); in testEURO()
528 CHECK_EVAL("EURO(\"NOMANSLAND\")", Value::errorNUM()); in testEURO()
536 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"ATS\")", Value(13.7603)); in testEUROCONVERT()
537 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"BEF\")", Value(40.3399)); in testEUROCONVERT()
538 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"DEM\")", Value(1.95583)); in testEUROCONVERT()
539 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"ESP\")", Value(166.386)); in testEUROCONVERT()
540 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"EUR\")", Value(1.0)); in testEUROCONVERT()
541 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"FIM\")", Value(5.94573)); in testEUROCONVERT()
542 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"FRF\")", Value(6.55957)); in testEUROCONVERT()
543 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"GRD\")", Value(340.75)); in testEUROCONVERT()
544 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"IEP\")", Value(0.787564)); in testEUROCONVERT()
545 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"ITL\")", Value(1936.27)); in testEUROCONVERT()
546 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"LUX\")", Value(40.3399)); in testEUROCONVERT()
547 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"NLG\")", Value(2.20371)); in testEUROCONVERT()
548 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"PTE\")", Value(200.482)); in testEUROCONVERT()
551 CHECK_EVAL("EUROCONVERT(1;\"BEF\";\"bef\")", Value(1.0)); in testEUROCONVERT()
552 CHECK_EVAL("EUROCONVERT(1;\"DEM\";\"dem\")", Value(1.0)); in testEUROCONVERT()
553 CHECK_EVAL("EUROCONVERT(1;\"ESP\";\"esp\")", Value(1.0)); in testEUROCONVERT()
554 CHECK_EVAL("EUROCONVERT(1;\"EUR\";\"eur\")", Value(1.0)); in testEUROCONVERT()
555 CHECK_EVAL("EUROCONVERT(1;\"FIM\";\"fim\")", Value(1.0)); in testEUROCONVERT()
556 CHECK_EVAL("EUROCONVERT(1;\"FRF\";\"frf\")", Value(1.0)); in testEUROCONVERT()
557 CHECK_EVAL("EUROCONVERT(1;\"GRD\";\"grd\")", Value(1.0)); in testEUROCONVERT()
558 CHECK_EVAL("EUROCONVERT(1;\"IEP\";\"iep\")", Value(1.0)); in testEUROCONVERT()
559 CHECK_EVAL("EUROCONVERT(1;\"ITL\";\"itl\")", Value(1.0)); in testEUROCONVERT()
560 CHECK_EVAL("EUROCONVERT(1;\"LUX\";\"lux\")", Value(1.0)); in testEUROCONVERT()
561 CHECK_EVAL("EUROCONVERT(1;\"NLG\";\"nlg\")", Value(1.0)); in testEUROCONVERT()
562 CHECK_EVAL("EUROCONVERT(1;\"PTE\";\"pte\")", Value(1.0)); in testEUROCONVERT()
565 CHECK_EVAL("EUROCONVERT( 2; \"ATS\"; \"bef\" )", Value(2*40.3399 / 13.7603)); in testEUROCONVERT()
566 CHECK_EVAL("EUROCONVERT( 3; \"ATS\"; \"dem\" )", Value(3*1.95583 / 13.7603)); in testEUROCONVERT()
567 CHECK_EVAL("EUROCONVERT( 4; \"ATS\"; \"esp\" )", Value(4*166.386 / 13.7603)); in testEUROCONVERT()
568 CHECK_EVAL("EUROCONVERT( 5; \"ATS\"; \"eur\" )", Value(5*1 / 13.7603)); in testEUROCONVERT()
569 CHECK_EVAL("EUROCONVERT( 6; \"ATS\"; \"fim\" )", Value(6*5.94573 / 13.7603)); in testEUROCONVERT()
570 CHECK_EVAL("EUROCONVERT( 7; \"ATS\"; \"frf\" )", Value(7*6.55957 / 13.7603)); in testEUROCONVERT()
571 CHECK_EVAL("EUROCONVERT( 8; \"ATS\"; \"grd\" )", Value(8*340.75 / 13.7603)); in testEUROCONVERT()
572 CHECK_EVAL("EUROCONVERT( 9; \"ATS\"; \"iep\" )", Value(9*0.787564 / 13.7603)); in testEUROCONVERT()
573 CHECK_EVAL("EUROCONVERT( 10; \"ATS\"; \"itl\" )", Value(10*1936.27 / 13.7603)); in testEUROCONVERT()
574 CHECK_EVAL("EUROCONVERT( 11; \"ATS\"; \"lux\" )", Value(11*40.3399 / 13.7603)); in testEUROCONVERT()
575 CHECK_EVAL("EUROCONVERT( 12; \"ATS\"; \"nlg\" )", Value(12*2.20371 / 13.7603)); in testEUROCONVERT()
576 CHECK_EVAL("EUROCONVERT( 13; \"ATS\"; \"pte\" )", Value(13*200.482 / 13.7603)); in testEUROCONVERT()
577 CHECK_EVAL("EUROCONVERT( 14; \"BEF\"; \"ats\" )", Value(14*13.7603 / 40.3399)); in testEUROCONVERT()
578 CHECK_EVAL("EUROCONVERT( 15; \"BEF\"; \"dem\" )", Value(15*1.95583 / 40.3399)); in testEUROCONVERT()
579 CHECK_EVAL("EUROCONVERT( 16; \"BEF\"; \"esp\" )", Value(16*166.386 / 40.3399)); in testEUROCONVERT()
580 CHECK_EVAL("EUROCONVERT( 17; \"BEF\"; \"eur\" )", Value(17*1 / 40.3399)); in testEUROCONVERT()
581 CHECK_EVAL("EUROCONVERT( 18; \"BEF\"; \"fim\" )", Value(18*5.94573 / 40.3399)); in testEUROCONVERT()
582 CHECK_EVAL("EUROCONVERT( 19; \"BEF\"; \"frf\" )", Value(19*6.55957 / 40.3399)); in testEUROCONVERT()
583 CHECK_EVAL("EUROCONVERT( 20; \"BEF\"; \"grd\" )", Value(20*340.75 / 40.3399)); in testEUROCONVERT()
584 CHECK_EVAL("EUROCONVERT( 21; \"BEF\"; \"iep\" )", Value(21*0.787564 / 40.3399)); in testEUROCONVERT()
585 CHECK_EVAL("EUROCONVERT( 22; \"BEF\"; \"itl\" )", Value(22*1936.27 / 40.3399)); in testEUROCONVERT()
586 CHECK_EVAL("EUROCONVERT( 23; \"BEF\"; \"lux\" )", Value(23*40.3399 / 40.3399)); in testEUROCONVERT()
587 CHECK_EVAL("EUROCONVERT( 24; \"BEF\"; \"nlg\" )", Value(24*2.20371 / 40.3399)); in testEUROCONVERT()
588 CHECK_EVAL("EUROCONVERT( 25; \"BEF\"; \"pte\" )", Value(25*200.482 / 40.3399)); in testEUROCONVERT()
589 CHECK_EVAL("EUROCONVERT( 26; \"DEM\"; \"ats\" )", Value(26*13.7603 / 1.95583)); in testEUROCONVERT()
590 CHECK_EVAL("EUROCONVERT( 27; \"DEM\"; \"bef\" )", Value(27*40.3399 / 1.95583)); in testEUROCONVERT()
591 CHECK_EVAL("EUROCONVERT( 28; \"DEM\"; \"esp\" )", Value(28*166.386 / 1.95583)); in testEUROCONVERT()
592 CHECK_EVAL("EUROCONVERT( 29; \"DEM\"; \"eur\" )", Value(29*1 / 1.95583)); in testEUROCONVERT()
593 CHECK_EVAL("EUROCONVERT( 30; \"DEM\"; \"fim\" )", Value(30*5.94573 / 1.95583)); in testEUROCONVERT()
594 CHECK_EVAL("EUROCONVERT( 31; \"DEM\"; \"frf\" )", Value(31*6.55957 / 1.95583)); in testEUROCONVERT()
595 CHECK_EVAL("EUROCONVERT( 32; \"DEM\"; \"grd\" )", Value(32*340.75 / 1.95583)); in testEUROCONVERT()
596 CHECK_EVAL("EUROCONVERT( 33; \"DEM\"; \"iep\" )", Value(33*0.787564 / 1.95583)); in testEUROCONVERT()
597 CHECK_EVAL("EUROCONVERT( 34; \"DEM\"; \"itl\" )", Value(34*1936.27 / 1.95583)); in testEUROCONVERT()
598 CHECK_EVAL("EUROCONVERT( 35; \"DEM\"; \"lux\" )", Value(35*40.3399 / 1.95583)); in testEUROCONVERT()
599 CHECK_EVAL("EUROCONVERT( 36; \"DEM\"; \"nlg\" )", Value(36*2.20371 / 1.95583)); in testEUROCONVERT()
600 CHECK_EVAL("EUROCONVERT( 37; \"DEM\"; \"pte\" )", Value(37*200.482 / 1.95583)); in testEUROCONVERT()
601 CHECK_EVAL("EUROCONVERT( 38; \"ESP\"; \"ats\" )", Value(38*13.7603 / 166.386)); in testEUROCONVERT()
602 CHECK_EVAL("EUROCONVERT( 39; \"ESP\"; \"bef\" )", Value(39*40.3399 / 166.386)); in testEUROCONVERT()
603 CHECK_EVAL("EUROCONVERT( 40; \"ESP\"; \"dem\" )", Value(40*1.95583 / 166.386)); in testEUROCONVERT()
604 CHECK_EVAL("EUROCONVERT( 41; \"ESP\"; \"eur\" )", Value(41*1 / 166.386)); in testEUROCONVERT()
605 CHECK_EVAL("EUROCONVERT( 42; \"ESP\"; \"fim\" )", Value(42*5.94573 / 166.386)); in testEUROCONVERT()
606 CHECK_EVAL("EUROCONVERT( 43; \"ESP\"; \"frf\" )", Value(43*6.55957 / 166.386)); in testEUROCONVERT()
607 CHECK_EVAL("EUROCONVERT( 44; \"ESP\"; \"grd\" )", Value(44*340.75 / 166.386)); in testEUROCONVERT()
608 CHECK_EVAL("EUROCONVERT( 45; \"ESP\"; \"iep\" )", Value(45*0.787564 / 166.386)); in testEUROCONVERT()
609 CHECK_EVAL("EUROCONVERT( 46; \"ESP\"; \"itl\" )", Value(46*1936.27 / 166.386)); in testEUROCONVERT()
610 CHECK_EVAL("EUROCONVERT( 47; \"ESP\"; \"lux\" )", Value(47*40.3399 / 166.386)); in testEUROCONVERT()
611 CHECK_EVAL("EUROCONVERT( 48; \"ESP\"; \"nlg\" )", Value(48*2.20371 / 166.386)); in testEUROCONVERT()
612 CHECK_EVAL("EUROCONVERT( 49; \"ESP\"; \"pte\" )", Value(49*200.482 / 166.386)); in testEUROCONVERT()
613 CHECK_EVAL("EUROCONVERT( 50; \"EUR\"; \"ats\" )", Value(50*13.7603 / 1)); in testEUROCONVERT()
614 CHECK_EVAL("EUROCONVERT( 51; \"EUR\"; \"bef\" )", Value(51*40.3399 / 1)); in testEUROCONVERT()
615 CHECK_EVAL("EUROCONVERT( 52; \"EUR\"; \"dem\" )", Value(52*1.95583 / 1)); in testEUROCONVERT()
616 CHECK_EVAL("EUROCONVERT( 53; \"EUR\"; \"esp\" )", Value(53*166.386 / 1)); in testEUROCONVERT()
617 CHECK_EVAL("EUROCONVERT( 54; \"EUR\"; \"fim\" )", Value(54*5.94573 / 1)); in testEUROCONVERT()
618 CHECK_EVAL("EUROCONVERT( 55; \"EUR\"; \"frf\" )", Value(55*6.55957 / 1)); in testEUROCONVERT()
619 CHECK_EVAL("EUROCONVERT( 56; \"EUR\"; \"grd\" )", Value(56*340.75 / 1)); in testEUROCONVERT()
620 CHECK_EVAL("EUROCONVERT( 57; \"EUR\"; \"iep\" )", Value(57*0.787564 / 1)); in testEUROCONVERT()
621 CHECK_EVAL("EUROCONVERT( 58; \"EUR\"; \"itl\" )", Value(58*1936.27 / 1)); in testEUROCONVERT()
622 CHECK_EVAL("EUROCONVERT( 59; \"EUR\"; \"lux\" )", Value(59*40.3399 / 1)); in testEUROCONVERT()
623 CHECK_EVAL("EUROCONVERT( 60; \"EUR\"; \"nlg\" )", Value(60*2.20371 / 1)); in testEUROCONVERT()
624 CHECK_EVAL("EUROCONVERT( 61; \"EUR\"; \"pte\" )", Value(61*200.482 / 1)); in testEUROCONVERT()
625 CHECK_EVAL("EUROCONVERT( 62; \"FIM\"; \"ats\" )", Value(62*13.7603 / 5.94573)); in testEUROCONVERT()
626 CHECK_EVAL("EUROCONVERT( 63; \"FIM\"; \"bef\" )", Value(63*40.3399 / 5.94573)); in testEUROCONVERT()
627 CHECK_EVAL("EUROCONVERT( 64; \"FIM\"; \"dem\" )", Value(64*1.95583 / 5.94573)); in testEUROCONVERT()
628 CHECK_EVAL("EUROCONVERT( 65; \"FIM\"; \"esp\" )", Value(65*166.386 / 5.94573)); in testEUROCONVERT()
629 CHECK_EVAL("EUROCONVERT( 66; \"FIM\"; \"eur\" )", Value(66*1 / 5.94573)); in testEUROCONVERT()
630 CHECK_EVAL("EUROCONVERT( 67; \"FIM\"; \"frf\" )", Value(67*6.55957 / 5.94573)); in testEUROCONVERT()
631 CHECK_EVAL("EUROCONVERT( 68; \"FIM\"; \"grd\" )", Value(68*340.75 / 5.94573)); in testEUROCONVERT()
632 CHECK_EVAL("EUROCONVERT( 69; \"FIM\"; \"iep\" )", Value(69*0.787564 / 5.94573)); in testEUROCONVERT()
633 CHECK_EVAL("EUROCONVERT( 70; \"FIM\"; \"itl\" )", Value(70*1936.27 / 5.94573)); in testEUROCONVERT()
634 CHECK_EVAL("EUROCONVERT( 71; \"FIM\"; \"lux\" )", Value(71*40.3399 / 5.94573)); in testEUROCONVERT()
635 CHECK_EVAL("EUROCONVERT( 72; \"FIM\"; \"nlg\" )", Value(72*2.20371 / 5.94573)); in testEUROCONVERT()
636 CHECK_EVAL("EUROCONVERT( 73; \"FIM\"; \"pte\" )", Value(73*200.482 / 5.94573)); in testEUROCONVERT()
637 CHECK_EVAL("EUROCONVERT( 74; \"FRF\"; \"ats\" )", Value(74*13.7603 / 6.55957)); in testEUROCONVERT()
638 CHECK_EVAL("EUROCONVERT( 75; \"FRF\"; \"bef\" )", Value(75*40.3399 / 6.55957)); in testEUROCONVERT()
639 CHECK_EVAL("EUROCONVERT( 76; \"FRF\"; \"dem\" )", Value(76*1.95583 / 6.55957)); in testEUROCONVERT()
640 CHECK_EVAL("EUROCONVERT( 77; \"FRF\"; \"esp\" )", Value(77*166.386 / 6.55957)); in testEUROCONVERT()
641 CHECK_EVAL("EUROCONVERT( 78; \"FRF\"; \"eur\" )", Value(78*1 / 6.55957)); in testEUROCONVERT()
642 CHECK_EVAL("EUROCONVERT( 79; \"FRF\"; \"fim\" )", Value(79*5.94573 / 6.55957)); in testEUROCONVERT()
643 CHECK_EVAL("EUROCONVERT( 80; \"FRF\"; \"grd\" )", Value(80*340.75 / 6.55957)); in testEUROCONVERT()
644 CHECK_EVAL("EUROCONVERT( 81; \"FRF\"; \"iep\" )", Value(81*0.787564 / 6.55957)); in testEUROCONVERT()
645 CHECK_EVAL("EUROCONVERT( 82; \"FRF\"; \"itl\" )", Value(82*1936.27 / 6.55957)); in testEUROCONVERT()
646 CHECK_EVAL("EUROCONVERT( 83; \"FRF\"; \"lux\" )", Value(83*40.3399 / 6.55957)); in testEUROCONVERT()
647 CHECK_EVAL("EUROCONVERT( 84; \"FRF\"; \"nlg\" )", Value(84*2.20371 / 6.55957)); in testEUROCONVERT()
648 CHECK_EVAL("EUROCONVERT( 85; \"FRF\"; \"pte\" )", Value(85*200.482 / 6.55957)); in testEUROCONVERT()
649 CHECK_EVAL("EUROCONVERT( 86; \"GRD\"; \"ats\" )", Value(86*13.7603 / 340.75)); in testEUROCONVERT()
650 CHECK_EVAL("EUROCONVERT( 87; \"GRD\"; \"bef\" )", Value(87*40.3399 / 340.75)); in testEUROCONVERT()
651 CHECK_EVAL("EUROCONVERT( 88; \"GRD\"; \"dem\" )", Value(88*1.95583 / 340.75)); in testEUROCONVERT()
652 CHECK_EVAL("EUROCONVERT( 89; \"GRD\"; \"esp\" )", Value(89*166.386 / 340.75)); in testEUROCONVERT()
653 CHECK_EVAL("EUROCONVERT( 90; \"GRD\"; \"eur\" )", Value(90*1 / 340.75)); in testEUROCONVERT()
654 CHECK_EVAL("EUROCONVERT( 91; \"GRD\"; \"fim\" )", Value(91*5.94573 / 340.75)); in testEUROCONVERT()
655 CHECK_EVAL("EUROCONVERT( 92; \"GRD\"; \"frf\" )", Value(92*6.55957 / 340.75)); in testEUROCONVERT()
656 CHECK_EVAL("EUROCONVERT( 93; \"GRD\"; \"iep\" )", Value(93*0.787564 / 340.75)); in testEUROCONVERT()
657 CHECK_EVAL("EUROCONVERT( 94; \"GRD\"; \"itl\" )", Value(94*1936.27 / 340.75)); in testEUROCONVERT()
658 CHECK_EVAL("EUROCONVERT( 95; \"GRD\"; \"lux\" )", Value(95*40.3399 / 340.75)); in testEUROCONVERT()
659 CHECK_EVAL("EUROCONVERT( 96; \"GRD\"; \"nlg\" )", Value(96*2.20371 / 340.75)); in testEUROCONVERT()
660 CHECK_EVAL("EUROCONVERT( 97; \"GRD\"; \"pte\" )", Value(97*200.482 / 340.75)); in testEUROCONVERT()
661 CHECK_EVAL("EUROCONVERT( 98; \"IEP\"; \"ats\" )", Value(98*13.7603 / 0.787564)); in testEUROCONVERT()
662 CHECK_EVAL("EUROCONVERT( 99; \"IEP\"; \"bef\" )", Value(99*40.3399 / 0.787564)); in testEUROCONVERT()
663 CHECK_EVAL("EUROCONVERT( 100; \"IEP\"; \"dem\" )", Value(100*1.95583 / 0.787564)); in testEUROCONVERT()
664 CHECK_EVAL("EUROCONVERT( 101; \"IEP\"; \"esp\" )", Value(101*166.386 / 0.787564)); in testEUROCONVERT()
665 CHECK_EVAL("EUROCONVERT( 102; \"IEP\"; \"eur\" )", Value(102*1 / 0.787564)); in testEUROCONVERT()
666 CHECK_EVAL("EUROCONVERT( 103; \"IEP\"; \"fim\" )", Value(103*5.94573 / 0.787564)); in testEUROCONVERT()
667 CHECK_EVAL("EUROCONVERT( 104; \"IEP\"; \"frf\" )", Value(104*6.55957 / 0.787564)); in testEUROCONVERT()
668 CHECK_EVAL("EUROCONVERT( 105; \"IEP\"; \"grd\" )", Value(105*340.75 / 0.787564)); in testEUROCONVERT()
669 CHECK_EVAL("EUROCONVERT( 106; \"IEP\"; \"itl\" )", Value(106*1936.27 / 0.787564)); in testEUROCONVERT()
670 CHECK_EVAL("EUROCONVERT( 107; \"IEP\"; \"lux\" )", Value(107*40.3399 / 0.787564)); in testEUROCONVERT()
671 CHECK_EVAL("EUROCONVERT( 108; \"IEP\"; \"nlg\" )", Value(108*2.20371 / 0.787564)); in testEUROCONVERT()
672 CHECK_EVAL("EUROCONVERT( 109; \"IEP\"; \"pte\" )", Value(109*200.482 / 0.787564)); in testEUROCONVERT()
673 CHECK_EVAL("EUROCONVERT( 110; \"ITL\"; \"ats\" )", Value(110*13.7603 / 1936.27)); in testEUROCONVERT()
674 CHECK_EVAL("EUROCONVERT( 111; \"ITL\"; \"bef\" )", Value(111*40.3399 / 1936.27)); in testEUROCONVERT()
675 CHECK_EVAL("EUROCONVERT( 112; \"ITL\"; \"dem\" )", Value(112*1.95583 / 1936.27)); in testEUROCONVERT()
676 CHECK_EVAL("EUROCONVERT( 113; \"ITL\"; \"esp\" )", Value(113*166.386 / 1936.27)); in testEUROCONVERT()
677 CHECK_EVAL("EUROCONVERT( 114; \"ITL\"; \"eur\" )", Value(114*1 / 1936.27)); in testEUROCONVERT()
678 CHECK_EVAL("EUROCONVERT( 115; \"ITL\"; \"fim\" )", Value(115*5.94573 / 1936.27)); in testEUROCONVERT()
679 CHECK_EVAL("EUROCONVERT( 116; \"ITL\"; \"frf\" )", Value(116*6.55957 / 1936.27)); in testEUROCONVERT()
680 CHECK_EVAL("EUROCONVERT( 117; \"ITL\"; \"grd\" )", Value(117*340.75 / 1936.27)); in testEUROCONVERT()
681 CHECK_EVAL("EUROCONVERT( 118; \"ITL\"; \"iep\" )", Value(118*0.787564 / 1936.27)); in testEUROCONVERT()
682 CHECK_EVAL("EUROCONVERT( 119; \"ITL\"; \"lux\" )", Value(119*40.3399 / 1936.27)); in testEUROCONVERT()
683 CHECK_EVAL("EUROCONVERT( 120; \"ITL\"; \"nlg\" )", Value(120*2.20371 / 1936.27)); in testEUROCONVERT()
684 CHECK_EVAL("EUROCONVERT( 121; \"ITL\"; \"pte\" )", Value(121*200.482 / 1936.27)); in testEUROCONVERT()
685 CHECK_EVAL("EUROCONVERT( 122; \"LUX\"; \"ats\" )", Value(122*13.7603 / 40.3399)); in testEUROCONVERT()
686 CHECK_EVAL("EUROCONVERT( 123; \"LUX\"; \"bef\" )", Value(123*40.3399 / 40.3399)); in testEUROCONVERT()
687 CHECK_EVAL("EUROCONVERT( 124; \"LUX\"; \"dem\" )", Value(124*1.95583 / 40.3399)); in testEUROCONVERT()
688 CHECK_EVAL("EUROCONVERT( 125; \"LUX\"; \"esp\" )", Value(125*166.386 / 40.3399)); in testEUROCONVERT()
689 CHECK_EVAL("EUROCONVERT( 126; \"LUX\"; \"eur\" )", Value(126*1 / 40.3399)); in testEUROCONVERT()
690 CHECK_EVAL("EUROCONVERT( 127; \"LUX\"; \"fim\" )", Value(127*5.94573 / 40.3399)); in testEUROCONVERT()
691 CHECK_EVAL("EUROCONVERT( 128; \"LUX\"; \"frf\" )", Value(128*6.55957 / 40.3399)); in testEUROCONVERT()
692 CHECK_EVAL("EUROCONVERT( 129; \"LUX\"; \"grd\" )", Value(129*340.75 / 40.3399)); in testEUROCONVERT()
693 CHECK_EVAL("EUROCONVERT( 130; \"LUX\"; \"iep\" )", Value(130*0.787564 / 40.3399)); in testEUROCONVERT()
694 CHECK_EVAL("EUROCONVERT( 131; \"LUX\"; \"itl\" )", Value(131*1936.27 / 40.3399)); in testEUROCONVERT()
695 CHECK_EVAL("EUROCONVERT( 132; \"LUX\"; \"nlg\" )", Value(132*2.20371 / 40.3399)); in testEUROCONVERT()
696 CHECK_EVAL("EUROCONVERT( 133; \"LUX\"; \"pte\" )", Value(133*200.482 / 40.3399)); in testEUROCONVERT()
697 CHECK_EVAL("EUROCONVERT( 134; \"NLG\"; \"ats\" )", Value(134*13.7603 / 2.20371)); in testEUROCONVERT()
698 CHECK_EVAL("EUROCONVERT( 135; \"NLG\"; \"bef\" )", Value(135*40.3399 / 2.20371)); in testEUROCONVERT()
699 CHECK_EVAL("EUROCONVERT( 136; \"NLG\"; \"dem\" )", Value(136*1.95583 / 2.20371)); in testEUROCONVERT()
700 CHECK_EVAL("EUROCONVERT( 137; \"NLG\"; \"esp\" )", Value(137*166.386 / 2.20371)); in testEUROCONVERT()
701 CHECK_EVAL("EUROCONVERT( 138; \"NLG\"; \"eur\" )", Value(138*1 / 2.20371)); in testEUROCONVERT()
702 CHECK_EVAL("EUROCONVERT( 139; \"NLG\"; \"fim\" )", Value(139*5.94573 / 2.20371)); in testEUROCONVERT()
703 CHECK_EVAL("EUROCONVERT( 140; \"NLG\"; \"frf\" )", Value(140*6.55957 / 2.20371)); in testEUROCONVERT()
704 CHECK_EVAL("EUROCONVERT( 141; \"NLG\"; \"grd\" )", Value(141*340.75 / 2.20371)); in testEUROCONVERT()
705 CHECK_EVAL("EUROCONVERT( 142; \"NLG\"; \"iep\" )", Value(142*0.787564 / 2.20371)); in testEUROCONVERT()
706 CHECK_EVAL("EUROCONVERT( 143; \"NLG\"; \"itl\" )", Value(143*1936.27 / 2.20371)); in testEUROCONVERT()
707 CHECK_EVAL("EUROCONVERT( 144; \"NLG\"; \"lux\" )", Value(144*40.3399 / 2.20371)); in testEUROCONVERT()
708 CHECK_EVAL("EUROCONVERT( 145; \"NLG\"; \"pte\" )", Value(145*200.482 / 2.20371)); in testEUROCONVERT()
709 CHECK_EVAL("EUROCONVERT( 146; \"PTE\"; \"ats\" )", Value(146*13.7603 / 200.482)); in testEUROCONVERT()
710 CHECK_EVAL("EUROCONVERT( 147; \"PTE\"; \"bef\" )", Value(147*40.3399 / 200.482)); in testEUROCONVERT()
711 CHECK_EVAL("EUROCONVERT( 148; \"PTE\"; \"dem\" )", Value(148*1.95583 / 200.482)); in testEUROCONVERT()
712 CHECK_EVAL("EUROCONVERT( 149; \"PTE\"; \"esp\" )", Value(149*166.386 / 200.482)); in testEUROCONVERT()
713 CHECK_EVAL("EUROCONVERT( 150; \"PTE\"; \"eur\" )", Value(150*1 / 200.482)); in testEUROCONVERT()
714 CHECK_EVAL("EUROCONVERT( 151; \"PTE\"; \"fim\" )", Value(151*5.94573 / 200.482)); in testEUROCONVERT()
715 CHECK_EVAL("EUROCONVERT( 152; \"PTE\"; \"frf\" )", Value(152*6.55957 / 200.482)); in testEUROCONVERT()
716 CHECK_EVAL("EUROCONVERT( 153; \"PTE\"; \"grd\" )", Value(153*340.75 / 200.482)); in testEUROCONVERT()
717 CHECK_EVAL("EUROCONVERT( 154; \"PTE\"; \"iep\" )", Value(154*0.787564 / 200.482)); in testEUROCONVERT()
718 CHECK_EVAL("EUROCONVERT( 155; \"PTE\"; \"itl\" )", Value(155*1936.27 / 200.482)); in testEUROCONVERT()
719 CHECK_EVAL("EUROCONVERT( 156; \"PTE\"; \"lux\" )", Value(156*40.3399 / 200.482)); in testEUROCONVERT()
720 CHECK_EVAL("EUROCONVERT( 157; \"PTE\"; \"nlg\" )", Value(157*2.20371 / 200.482)); in testEUROCONVERT()
727 CHECK_EVAL("FV(10%;12;-100;100)" , Value(1824.5855390489)); // A trivial example of FV. in testFV()
734 …CHECK_EVAL_SHORT("FVSCHEDULE(1000000; {0.03; 0.04; 0.05})" , Value(1124760)); // A trivial exa… in testFVSCHEDULE()
736 …T("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETFVSCHEDULE(1000000; {0.03; 0.04; 0.05})" , Value(1124760)); in testFVSCHEDULE()
743 …CHECK_EVAL_SHORT("INTRATE( DATE(2002; 6;8); DATE(1995;10;5); 100000; 200000; 0 )" , Value::errorVA… in testINTRATE()
744 …CHECK_EVAL_SHORT("INTRATE( DATE(2002; 6;8); DATE(2002; 6;8); 100000; 200000; 0 )" , Value::errorVA… in testINTRATE()
745 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 50)" , Value::errorVA… in testINTRATE()
746 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 0 )" , Value(0.149812… in testINTRATE()
747 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000 )" , Value(0.149812… in testINTRATE()
748 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 1 )" , Value(0.149712… in testINTRATE()
749 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 2 )" , Value(0.147662… in testINTRATE()
750 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 3 )" , Value(0.149712… in testINTRATE()
751 …CHECK_EVAL_SHORT("INTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 4 )" , Value(0.149812… in testINTRATE()
753 …ANALYSIS.GETINTRATE( DATE(1995;10;5); DATE(2002; 6;8); 100000; 200000; 0 )" , Value(0.1498127341)); in testINTRATE()
760 …CHECK_EVAL_SHORT("IPMT(5%/12;10;360;100000)", Value(-412.0850243)); // An example of IP… in testIPMT()
762 …CHECK_EVAL_SHORT("IPMT(5%/12;10;360;100000;0;1)", Value(-410.3751278993)); // Payments at the … in testIPMT()
765 …_EVAL_SHORT("PPMT(5%/12;10;360;100000)+IPMT(5%/12;10;360;100000)-PMT(5%/12;360;100000)", Value(0)); in testIPMT()
772 CHECK_EVAL("ISPMT(10%/12;1 ;36;8000000)", Value(-64814.8148148148)); // in testISPMT()
773 CHECK_EVAL("ISPMT(10% ;1 ;3 ;8000000)", Value(-533333.3333333333)); // in testISPMT()
776 …CHECK_EVAL("ISPMT(5%/12;12;360;100000)", Value(-402.7777777778)); // A trivial example of … in testISPMT()
785 CHECK_EVAL("LEVEL_COUPON(1000; .13; 1; 4; .1)", Value(1095.0959633904788)); in testLEVELCOUPON()
786 CHECK_EVAL("LEVEL_COUPON(1000; .13; 2; 4; .1)", Value(1096.9481913913939)); in testLEVELCOUPON()
787 CHECK_EVAL("LEVEL_COUPON(1000; .10; 1; 10; .25)", Value(464.4245094400000)); in testLEVELCOUPON()
788 CHECK_EVAL("LEVEL_COUPON(1000; .12; 1; 10; .25)", Value(535.8345748480000)); in testLEVELCOUPON()
789 CHECK_EVAL("LEVEL_COUPON(1000; .20; 1; 10; .25)", Value(821.4748364800000)); in testLEVELCOUPON()
795 …CHECK_EVAL("MDURATION(\"2004-02-01\"; \"2004-05-31\"; 0.08; 0.09; 2; 0)" , Value(0.3189792663)); … in testMDURATION()
800 …IN.ANALYSIS.GETMDURATION(\"2004-02-01\"; \"2004-05-31\"; 0.08; 0.09; 2; 0)" , Value(0.3189792663)); in testMDURATION()
807 CHECK_EVAL("MIRR({100;200;-50;300;-200}; 5%; 6%)", Value(0.342823387842)); in testMIRR()
810 CHECK_EVAL("MIRR({-10;30;20;10;20};0.1;0.12)", Value(0.7712844619)); in testMIRR()
811 CHECK_EVAL("MIRR({-100;30;30;30;30};0.1;1)", Value(0.4564753151)); in testMIRR()
812 CHECK_EVAL("MIRR({-50;20;40;70};10/100;12/100)", Value(0.4090837902)); in testMIRR()
813 CHECK_EVAL("MIRR({-5;1;2;3;4};10/100;0.12)", Value(0.2253901556)); in testMIRR()
814 CHECK_EVAL("MIRR({1000;1100;1200;1500;1600};10%;12%)", Value(Value::errorDIV0())); in testMIRR()
821 CHECK_EVAL("NOMINAL(13.5%; 12)", Value(0.1273031669590416)); in testNOMINAL()
822 CHECK_EVAL("NOMINAL(13.5%; 12)", Value(0.1273031669590416)); in testNOMINAL()
823 CHECK_EVAL("NOMINAL(25%; 12)", Value(0.2252311814580734)); in testNOMINAL()
824 CHECK_EVAL("NOMINAL(25%; 4)", Value(0.2294850537622564)); in testNOMINAL()
825 CHECK_EVAL("NOMINAL(20%; 12)", Value(0.1837136459967743)); in testNOMINAL()
826 CHECK_EVAL("NOMINAL(10%; 12)", Value(0.0956896851468452)); in testNOMINAL()
829 CHECK_EVAL("NOMINAL(0; 12)", Value::errorVALUE()); in testNOMINAL()
832 CHECK_EVAL("NOMINAL(10%; 0)", Value::errorDIV0()); in testNOMINAL()
833 CHECK_EVAL("NOMINAL(10%; -1)", Value::errorVALUE()); in testNOMINAL()
834 CHECK_EVAL("NOMINAL(10%; -2)", Value::errorVALUE()); in testNOMINAL()
837 CHECK_EVAL("NOMINAL(8%;4)", Value(0.0777061876330940)); in testNOMINAL()
838 CHECK_EVAL("NOMINAL(12.5%;12)", Value(0.118362966638538)); in testNOMINAL()
839 CHECK_EVAL("NOMINAL(1%;2)", Value(0.00997512422417790)); in testNOMINAL()
842 … CHECK_EVAL("COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETNOMINAL(8%;4)", Value(0.0777061876330940)); in testNOMINAL()
849 …CHECK_EVAL_SHORT("NPER(5% ;-100;1000)", Value(14.2067)); // A trivial example of NPE… in testNPER()
850 …CHECK_EVAL_SHORT("NPER(5% ;-100;1000;100)", Value(15.2067)); // A trivial example of NPE… in testNPER()
851 …CHECK_EVAL_SHORT("NPER(5% ;-100;1000;100;1)", Value(14.2067)); // A trivial example of NPE… in testNPER()
852 CHECK_EVAL_SHORT("NPER(0 ;-100;1000)", Value(10.0000)); // TODO Rate can be zero. in testNPER()
853 …CHECK_EVAL_SHORT("NPER(-1%;-100;1000)", Value(9.483283066)); // TODO Rate can be negativ… in testNPER()
860 CHECK_EVAL("NPV(100%; 4; 5; 7)", Value(4.125)); in testNPV()
861 CHECK_EVAL("NPV(10%; 100; 200)", Value(256.198347107438)); in testNPV()
868 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;100;2)", Value( 90.9975570033 ) … in testODDLPRICE()
869 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;100;1;0)", Value( 90.9975570033 ) … in testODDLPRICE()
870 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;100;2;0)", Value( 90.9975570033 ) … in testODDLPRICE()
871 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;100;4;0)", Value( 90.9975570033 ) … in testODDLPRICE()
872 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;1;1)", Value( 102.5120875338 ) … in testODDLPRICE()
873 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;2;1)", Value( 102.510143853 ) )… in testODDLPRICE()
874 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;4;1)", Value( 102.509884509 ) )… in testODDLPRICE()
876 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;1;2)", Value( 102.512087534 ) )… in testODDLPRICE()
878 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;2;2)", Value( 102.510143853 ) )… in testODDLPRICE()
880 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;100;4;2)", Value( 102.509884509 ) )… in testODDLPRICE()
881 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;1000;1;3)", Value( 794.575995564 ) )… in testODDLPRICE()
883 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;1000;2;3)", Value( 794.671729071 ) )… in testODDLPRICE()
885 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;5%;1000;4;3)", Value( 794.684531308 ) )… in testODDLPRICE()
886 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;1000;1;4)", Value( 932.992137337 ) … in testODDLPRICE()
887 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;1000;2;4)", Value( 932.992137337 ) … in testODDLPRICE()
888 …LPRICE(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;1.5%;1000;4;4)", Value( 932.992137337 ) … in testODDLPRICE()
897 …DDLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;91;100 ;2 )", Value( 4.997775351/100.0… in testODDLYIELD()
898 …DDLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;91;100 ;1;0)", Value( 4.997775351/100.0… in testODDLYIELD()
899 …DDLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;91;100 ;2;0)", Value( 4.997775351/100.0… in testODDLYIELD()
900 …DDLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;91;100 ;4;0)", Value( 4.997775351/100.0… in testODDLYIELD()
903 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100 ;1;1)", Value( 1.408788601/100.0… in testODDLYIELD()
904 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100 ;2;1)", Value( 1.408379719/100.0… in testODDLYIELD()
905 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100 ;4;1)", Value( 1.408325114/100.0… in testODDLYIELD()
908 …DDLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100;1;2)", Value( 1.408788601/100.0… in testODDLYIELD()
909 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100 ;4;2)", Value( 1.408379719/100.0… in testODDLYIELD()
910 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;103;100 ;2;2)", Value( 1.408325114/100.0… in testODDLYIELD()
913 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;795;1000;1;3)", Value( 4.987800402/100.0… in testODDLYIELD()
915 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;795;1000;2;3)", Value( 4.990550494/100.0… in testODDLYIELD()
916 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);3%;795;1000;4;3)", Value( 4.990918451/100.0… in testODDLYIELD()
919 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;933;1000;1;4)", Value( 1.499836493/100.0… in testODDLYIELD()
920 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;933;1000;2;4)", Value( 1.499836493/100.0… in testODDLYIELD()
921 …DLYIELD(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);2%;933;1000;4;4)", Value( 1.499836493/100.0… in testODDLYIELD()
928 CHECK_EVAL_SHORT("PDURATION( 0.1; 10; 100 )" , Value(24.158858)); // simple use case in testPDURATION()
929 …CHECK_EVAL_SHORT("PDURATION( 0.1; 100; 10 )" , Value(-24.158858)); // currentValue > desiredVa… in testPDURATION()
930 CHECK_EVAL_SHORT("PDURATION( 0; 10; 11 )" , Value::errorVALUE()); // rate > 0 in testPDURATION()
931 CHECK_EVAL_SHORT("PDURATION( 0.1; 0; 11 )" , Value::errorVALUE()); // currentValue > 0 in testPDURATION()
932 CHECK_EVAL_SHORT("PDURATION( 0.1; 10; 0 )" , Value::errorVALUE()); // desiredValue > 0 in testPDURATION()
939 …CHECK_EVAL_SHORT("PMT(5%;12;1000)", Value(-112.8254100208)); // A trivial example of PMT. in testPMT()
940 …CHECK_EVAL_SHORT("PMT(5%;12;1000;100)", Value(-119.1079510229)); // A trivial example of PMT… in testPMT()
941 …CHECK_EVAL_SHORT("PMT(5%;12;1000;100;1)", Value(-113.4361438313)); // A trivial example of PMT… in testPMT()
942 CHECK_EVAL_SHORT("PMT(0;10;1000)", Value(-100.00000)); // TODO Rate can be zero. in testPMT()
949 CHECK_EVAL("PPMT(10%/12;1;24;2000)", Value(-75.6231860084)); // A simple test case in testPPMT()
950 CHECK_EVAL("PPMT(8%;10;10;200000)", Value(-27598.0534624214)); // A simple test case in testPPMT()
953 CHECK_EVAL("PPMT(3%;1;12;100)", Value(-7.0462085473)); // A simple test case in testPPMT()
954 … CHECK_EVAL("PPMT(8%;5;24;10000;0)", Value(-203.7735140493)); // With nPer=5 and Future=0 in testPPMT()
955 …CHECK_EVAL("PPMT(8%;10;24;10000;2000)", Value(-359.2921746011)); // With nPer=10 and Future=… in testPPMT()
956 CHECK_EVAL("PPMT(8%;10;24;10000;2000;1)", Value(-332.6779394454)); // With Type=1 in testPPMT()
959 CHECK_EVAL("PPMT(3%;1;12;100;200)", Value(-21.1386256419)); // With future value in testPPMT()
960 …CHECK_EVAL("PPMT(3%;1;12;100;200;1)", Value(-20.5229375164)); // With future value and ty… in testPPMT()
967 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5% )", Value(103.819… in testPRICEMAT()
968 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5%;1)", Value(103.824… in testPRICEMAT()
969 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5%;2)", Value(103.858… in testPRICEMAT()
970 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5%;3)", Value(103.824… in testPRICEMAT()
971 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5%;4)", Value(103.819… in testPRICEMAT()
972 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1992;12;31);DATE(1990;1;1);3%;2%;0)", Value(102.395… in testPRICEMAT()
973 …CHECK_EVAL_SHORT("PRICEMAT(DATE(1990;6;1);DATE(1992;12;31);DATE(1990;1;1);5%;3%;2)", Value(104.709… in testPRICEMAT()
975 …ALYSIS.GETPRICEMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1);6%;5% )", Value(103.819218241)); in testPRICEMAT()
983 CHECK_EVAL_SHORT("PV(10%;12;-100;100)", Value(649.5061005186)); // A trivial example of PV. in testPV()
990 CHECK_EVAL_SHORT("PV_ANNUITY(1000;0.05;5)", Value(4329.47667063)); in testPV_ANNUITY()
996 CHECK_EVAL_SHORT("RATE(4*12;-200;8000)", Value(0.00770147)); in testRATE()
1003 …CHECK_EVAL_SHORT("RECEIVED(DATE(1990;6;1);DATE(1990;12;31);10000;5%)" , Value(10300.4291845494)); … in testRECEIVED()
1005 …T.ADDIN.ANALYSIS.GETRECEIVED(DATE(1990;6;1);DATE(1990;12;31);10000;5%)" , Value(10300.4291845494)); in testRECEIVED()
1011 …CHECK_EVAL_SHORT("RRI(1;100;200)" , Value(1)); // A trivial example of R… in testRRI()
1012 … CHECK_EVAL_SHORT("RRI(12;5000;10000)" , Value(0.05946309436)); // RRI, practical example in testRRI()
1013 …CHECK_EVAL_SHORT("RRI(12;10000;5000)" , Value(-0.056125687)); // If future value is les… in testRRI()
1014 …CHECK_EVAL_SHORT("RRI(0;100;200)" , Value(Value::errorVALUE())); // N must be greater than… in testRRI()
1022 CHECK_EVAL("SLN(30000; 7500; 10)", Value(2250.0)); in testSLN()
1025 CHECK_EVAL("SLN(2500; 500; 24)", Value(83.3333333333333)); in testSLN()
1028 CHECK_EVAL("SLN(10000; 700; 10)", Value(930)); in testSLN()
1031 CHECK_EVAL("SLN(4000;500;4)", Value(875)); in testSLN()
1039 CHECK_EVAL("SYD(30000; 7500; 10; 1)", Value(4090.909090909090)); in testSYD()
1040 CHECK_EVAL("SYD(30000; 7500; 10; 10)", Value(409.0909090909090)); in testSYD()
1043 CHECK_EVAL("SYD(25000; 5000; 15; 14)", Value(333.3333333333333)); in testSYD()
1046 CHECK_EVAL("SYD(5000; 200; 5; 2)", Value(1280)); in testSYD()
1049 CHECK_EVAL("SYD(4000;500;4;2)", Value(1050)); in testSYD()
1058 CHECK_EVAL("TBILLEQ(DATE(1996;01;01);DATE(1996;02;01);5%)", Value(0.0509136560)); // in testTBILLEQ()
1059 …CHECK_EVAL("TBILLEQ(DATE(1995;12;31);DATE(1996;02;01);5%)", Value(0.0509207589)); // sp… in testTBILLEQ()
1060 …CHECK_EVAL("TBILLEQ(DATE(1995;12;31);DATE(1996;07;01);5%)", Value(0.0520091194)); // sp… in testTBILLEQ()
1061 …CHECK_EVAL("TBILLEQ(DATE(1995;12;31);DATE(1996;12;31);5%)", Value(Value::errorVALUE())); // sp… in testTBILLEQ()
1062 …CHECK_EVAL("TBILLEQ(DATE(1996;01;01);DATE(1996;06;30);5%)", Value(0.0519943020)); // sp… in testTBILLEQ()
1063 …CHECK_EVAL("TBILLEQ(DATE(1996;01;01);DATE(1996;07;01);5%)", Value(0.0520017096)); // sp… in testTBILLEQ()
1064 …CHECK_EVAL("TBILLEQ(DATE(1996;01;01);DATE(1996;12;31);5%)", Value(0.0533625731)); // sp… in testTBILLEQ()
1065 …CHECK_EVAL("TBILLEQ(DATE(1996;01;01);DATE(1997;01;01);5%)", Value(Value::errorVALUE())); // sp… in testTBILLEQ()
1066 …CHECK_EVAL("TBILLEQ(DATE(1996;07;01);DATE(1997;07;01);5%)", Value(Value::errorVALUE())); // sp… in testTBILLEQ()
1068 ….STAR.SHEET.ADDIN.ANALYSIS.GETTBILLEQ(DATE(1996;01;01);DATE(1996;02;01);5%)", Value(0.0509136560)); in testTBILLEQ()
1075 CHECK_EVAL("TBILLPRICE(DATE(1996;01;01);DATE(1996;02;01);5%)", Value(99.5694444444)); // in testTBILLPRICE()
1076 CHECK_EVAL("TBILLPRICE(DATE(1995;12;31);DATE(1996;02;01);5%)", Value(99.5555555555)); // in testTBILLPRICE()
1077 …CHECK_EVAL("TBILLPRICE(DATE(1995;12;31);DATE(1996;07;01);5%)", Value(97.4722222222)); // ODF s… in testTBILLPRICE()
1078 …CHECK_EVAL("TBILLPRICE(DATE(1995;12;31);DATE(1996;12;31);5%)", Value(94.9861111111)); // ODF s… in testTBILLPRICE()
1079 …CHECK_EVAL("TBILLPRICE(DATE(1996;01;01);DATE(1996;06;30);5%)", Value(97.5000000000)); // ODF s… in testTBILLPRICE()
1080 …CHECK_EVAL("TBILLPRICE(DATE(1996;01;01);DATE(1996;07;01);5%)", Value(97.4861111111)); // ODF s… in testTBILLPRICE()
1081 …CHECK_EVAL("TBILLPRICE(DATE(1996;01;01);DATE(1996;12;31);5%)", Value(Value::errorVALUE())); //… in testTBILLPRICE()
1082 …CHECK_EVAL("TBILLPRICE(DATE(1996;01;01);DATE(1997;01;01);5%)", Value(94.9861111111)); // ODF s… in testTBILLPRICE()
1083 …CHECK_EVAL("TBILLPRICE(DATE(1996;07;01);DATE(1997;07;01);5%)", Value(94.9861111111)); // ODF s… in testTBILLPRICE()
1085 …R.SHEET.ADDIN.ANALYSIS.GETTBILLPRICE(DATE(1996;01;01);DATE(1996;02;01);5%)", Value(99.5694444444)); in testTBILLPRICE()
1094 …CHECK_EVAL("TBILLYIELD(DATE(1996;01;01);DATE(1996;02;01);99.57)", Value(0.0501511337)); … in testTBILLYIELD()
1095 …CHECK_EVAL("TBILLYIELD(DATE(1995;12;31);DATE(1996;02;01);99.56)", Value(0.0497187626)); … in testTBILLYIELD()
1096 …CHECK_EVAL("TBILLYIELD(DATE(1995;12;31);DATE(1996;07;01);97.46)", Value(0.0515511576)); … in testTBILLYIELD()
1097 …CHECK_EVAL("TBILLYIELD(DATE(1995;12;31);DATE(1996;12;31);94.92)", Value(Value::errorVALUE())); … in testTBILLYIELD()
1098 …CHECK_EVAL("TBILLYIELD(DATE(1996;01;01);DATE(1996;06;30);97.49)", Value(0.0514924608)); … in testTBILLYIELD()
1099 …CHECK_EVAL("TBILLYIELD(DATE(1996;01;01);DATE(1996;07;01);97.47)", Value(0.0516265948)); … in testTBILLYIELD()
1100 …CHECK_EVAL("TBILLYIELD(DATE(1996;01;01);DATE(1996;12;31);94.93)", Value(Value::errorVALUE())); … in testTBILLYIELD()
1101 …CHECK_EVAL("TBILLYIELD(DATE(1996;01;01);DATE(1997;01;01);94.92)", Value(Value::errorVALUE())); … in testTBILLYIELD()
1102 …CHECK_EVAL("TBILLYIELD(DATE(1996;07;01);DATE(1997;07;01);94.93)", Value(Value::errorVALUE())); … in testTBILLYIELD()
1104 …SHEET.ADDIN.ANALYSIS.GETTBILLYIELD(DATE(1996;01;01);DATE(1996;02;01);99.57)", Value(0.0501511337)); in testTBILLYIELD()
1111 CHECK_EVAL("VDB(10000;600;10;0 ;0.875;1.5)", Value(1312.50)); in testVDB()
1112 CHECK_EVAL("VDB(10000;600;10;0.875;1.875;1.5)", Value(1303.125)); in testVDB()
1113 CHECK_EVAL("VDB(10000;600;10;1.875;2.875;1.5)", Value(1107.65625)); in testVDB()
1114 CHECK_EVAL("VDB(10000;600;10;2.875;3.875;1.5)", Value(941.5078125)); in testVDB()
1115 CHECK_EVAL("VDB(10000;600;10;3.875;4.875;1.5)", Value(800.2816406250)); in testVDB()
1116 CHECK_EVAL("VDB(10000;600;10;4.875;5.875;1.5)", Value(767.7910823171)); in testVDB()
1117 CHECK_EVAL("VDB(10000;600;10;5.875;6.875;1.5)", Value(767.410625)); in testVDB()
1118 CHECK_EVAL("VDB(10000;600;10;6.875;7.875;1.5)", Value(767.410625)); in testVDB()
1119 CHECK_EVAL("VDB(10000;600;10;7.875;8.875;1.5)", Value(767.410625)); in testVDB()
1120 CHECK_EVAL("VDB(10000;600;10;8.875;9.875;1.5)", Value(767.410625)); in testVDB()
1121 CHECK_EVAL("VDB(10000;600;10;9.875;10 ;1.5)", Value(95.9263281250)); in testVDB()
1128 …te(2000;01;01); date(2000;06;01); date(2000;12;30); date(2001;03;01)} )", Value(0.2115964)); // in testXIRR()
1129 …te(2000;01;01); date(2001;01;01)} )", Value(0.2492381)); // in testXIRR()
1130 …te(2000;01;01); date(2002;06;01); date(2004;01;01)} )", Value(0.1405418)); // in testXIRR()
1132 ….ADDIN.ANALYSIS.GETXIRR( {-20000;25000};{date(2000;01;01); date(2001;01;01)} )", Value(0.2492381)); in testXIRR()
1139 …0;3000}; {date(2005;01;01); date(2005;01;10); date(2005;01;15)})" , Value(3984.3581140636));… in testXNPV()
1142 …50;4250;3250}; {38353;38412;38655;38763})", Value(-380.3891178530));… in testXNPV()
1143 …50;4250;3250}; {38353;38412;38655;38763})", Value(-8104.7862519770))… in testXNPV()
1144 …4250;3250}; {38353;38412;38655;38763})", Value(Value::errorNUM())); … in testXNPV()
1145 …; {date(2005;01;01); date(2005;01;10); date(2005;01;15)})", Value(Value::errorNUM())); … in testXNPV()
1146 …000}; {\"fail\"; date(2005;01;10); date(2005;01;15)})", Value(Value::errorVALUE()))… in testXNPV()
1149 …NALYSIS.GETXNPV(0.09; {-10000;2750;4250;3250}; {38353;38412;38655;38763})",Value(-380.3891178530)); in testXNPV()
1156 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;12;31);941.66667;1000 )", Value(0.1061946838));… in testYIELDDISC()
1157 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;12;31);941.64384;1000; 1)", Value(0.1061972566));… in testYIELDDISC()
1158 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;12;31);940.83333;1000; 2)", Value(0.1062887575));… in testYIELDDISC()
1159 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;12;31);941.64384;1000; 3)", Value(0.1061972566));… in testYIELDDISC()
1160 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;12;31);941.94444;1000; 4)", Value(0.1061633823));… in testYIELDDISC()
1161 …CHECK_EVAL("YIELDDISC(DATE(1990;01;01);DATE(1990;12;31);97.08219;100; 1)", Value(0.0301376180));… in testYIELDDISC()
1162 …CHECK_EVAL("YIELDDISC(DATE(1990;06;01);DATE(1990;06;30);99.75833;100; 4)", Value(0.0300730914));… in testYIELDDISC()
1164 ….ANALYSIS.GETYIELDDISC(DATE(1990;06;01);DATE(1990;12;31);941.66667;1000 )", Value(0.1061946838)); in testYIELDDISC()
1171 …MAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1); 6%;103.819218241 )", Value(0.050000000)); … in testYIELDMAT()
1172 …MAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1); 6%;103.824693325;1)", Value(0.050000000)); … in testYIELDMAT()
1174 …MAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1); 6%;103.824693325;3)", Value(0.050000000)); … in testYIELDMAT()
1176 …MAT(DATE(1990;6;1);DATE(1992;12;31);DATE(1990;1;1); 3%;102.395007924;0)", Value(0.020000000)); … in testYIELDMAT()
1180 …YIELDMAT(DATE(1990;6;1);DATE(1995;12;31);DATE(1990;1;1); 6%;103.819218241 )", Value(0.050000000)); in testYIELDMAT()
1187 CHECK_EVAL("ZERO_COUPON(1000;.1;20)", Value(148.6436280241434531)); in testZEROCOUPON()
1188 CHECK_EVAL("ZERO_COUPON(1000;.2;20)", Value(26.0840533045888456)); in testZEROCOUPON()
1189 CHECK_EVAL("ZERO_COUPON(1000;.15/12;10)", Value(883.1809261539680165)); in testZEROCOUPON()
1190 CHECK_EVAL("ZERO_COUPON(1000;.25;1)", Value(800)); in testZEROCOUPON()