1 /*************************************************************************
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
5 * Copyright 2000, 2010 Oracle and/or its affiliates.
7 * OpenOffice.org - a multi-platform office productivity suite
9 * This file is part of OpenOffice.org.
11 * OpenOffice.org is free software: you can redistribute it and/or modify
12 * it under the terms of the GNU Lesser General Public License version 3
13 * only, as published by the Free Software Foundation.
15 * OpenOffice.org is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 * GNU Lesser General Public License version 3 for more details
19 * (a copy is included in the LICENSE file that accompanied this code).
21 * You should have received a copy of the GNU Lesser General Public License
22 * version 3 along with OpenOffice.org. If not, see
23 * <http://www.openoffice.org/license.html>
24 * for a copy of the LGPLv3 License.
26 ************************************************************************/
29 #include "analysis.hrc"
32 Resource RID_ANALYSIS_FUNCTION_DESCRIPTIONS
34 Resource ANALYSIS_Workday
36 String 1 // description Workday
38 Text [ en-US ] = "Returns the serial number of the date before or after a specified number of workdays";
41 String 2 // name of parameter 1 Workday
43 Text [ en-US ] = "Start date";
46 String 3 // description of parameter 1 Workday
48 Text [ en-US ] = "The start date";
51 String 4 // name of parameter 2 Workday
53 Text [ en-US ] = "Days";
56 String 5 // description of parameter 2 Workday
58 Text [ en-US ] = "The number of workdays before or after the start date";
61 String 6 // name of parameter 3 Workday
63 Text [ en-US ] = "Holidays";
66 String 7 // description of parameter 3 Workday
68 Text [ en-US ] = "List of date values of days off (vacation, holidays, etc.)";
72 Resource ANALYSIS_Yearfrac
74 String 1 // description Yearfrac
76 Text [ en-US ] = "Returns the number of whole days between 'start date' and 'end date' as a year fraction";
79 String 2 // name of parameter 1 Yearfrac
81 Text [ en-US ] = "Start date";
84 String 3 // description of parameter 1 Yearfrac
86 Text [ en-US ] = "The start date";
89 String 4 // name of parameter 2 Yearfrac
91 Text [ en-US ] = "End date";
94 String 5 // description of parameter 2 Yearfrac
96 Text [ en-US ] = "The end date";
99 String 6 // name of parameter 3 Yearfrac
101 Text [ en-US ] = "Basis";
104 String 7 // description of parameter 3 Yearfrac
106 Text [ en-US ] = "Basis for determining the interest days";
110 Resource ANALYSIS_Edate
112 String 1 // description Edate
114 Text [ en-US ] = "Returns the serial number of the date that is a specified number of months before or after the start date";
117 String 2 // name of parameter 1 Edate
119 Text [ en-US ] = "Start date";
122 String 3 // description of parameter 1 Edate
124 Text [ en-US ] = "The start date";
127 String 4 // name of parameter 2 Edate
129 Text [ en-US ] = "Months";
132 String 5 // description of parameter 2 Edate
134 Text [ en-US ] = "Number of months before or after the start date";
138 Resource ANALYSIS_Weeknum
140 String 1 // description Weeknum_add
142 Text [ en-US ] = "Returns the number of the calendar week in which the specified date occurs.";
145 String 2 // name of parameter 1 Weeknum_add
147 Text [ en-US ] = "Date";
150 String 3 // description of parameter 1 Weeknum_add
152 Text [ en-US ] = "The date";
155 String 4 // name of parameter 2 Weeknum_add
157 Text [ en-US ] = "Return type";
160 String 5 // description of parameter 2 Weeknum_add
162 Text [ en-US ] = "A number from 1 to 3 that specifies the day with which a week begins";
166 Resource ANALYSIS_Eomonth
168 String 1 // description EoMonth
170 Text[ en-US ] = "Returns the serial number of the last day of the month that comes a certain number of months before or after the start date";
173 String 2 // name of parameter 1 EoMonth
175 Text [ en-US ] = "Start date";
178 String 3 // description of parameter 1 EoMonth
180 Text [ en-US ] = "The start date";
183 String 4 // name of parameter 2 EoMonth
185 Text [ en-US ] = "Months";
188 String 5 // description of parameter 2 EoMonth
190 Text [ en-US ] = "Number of months before or after the start date";
194 Resource ANALYSIS_Networkdays
196 String 1 // description Networkdays
198 Text [ en-US ] = "Returns the number of workdays between two dates";
201 String 2 // name of parameter 1 Networkdays
203 Text [ en-US ] = "Start date";
206 String 3 // description of parameter 1 Networkdays
208 Text [ en-US ] = "The start date";
211 String 4 // name of parameter 2 Networkdays
213 Text [ en-US ] = "End date";
216 String 5 // description of parameter 2 Networkdays
218 Text [ en-US ] = "The end date";
221 String 6 // name of parameter 3 Networkdays
223 Text [ en-US ] = "Holidays";
226 String 7 // description of parameter 3 Networkdays
228 Text [ en-US ] = "List of date values representing days off (vacation, holidays, etc.)";
232 Resource ANALYSIS_Iseven
234 String 1 // description Iseven_add
236 Text [ en-US ] = "Returns the value 'true' if the number is even";
239 String 2 // name of parameter 1 Iseven_add
241 Text [ en-US ] = "Number";
244 String 3 // description of parameter 1 Iseven_add
246 Text [ en-US ] = "The number";
250 Resource ANALYSIS_Isodd
252 String 1 // description Isodd_add
254 Text [ en-US ] = "Returns the value 'true' if the number is odd";
257 String 2 // name of parameter 1 Isodd_add
259 Text [ en-US ] = "Number";
262 String 3 // description of parameter 1 Isodd_add
264 Text [ en-US ] = "The number";
268 Resource ANALYSIS_Multinomial
270 String 1 // description Multinomial
272 Text [ en-US ] = "Returns the multinomial coefficient of a set of numbers";
275 String 2 // name of parameter 1 Multinomial
277 Text [ en-US ] = "Number(s)";
280 String 3 // description of parameter 1 Multinomial
282 Text [ en-US ] = "Number or list of numbers for which you want the multinomial coefficient";
286 Resource ANALYSIS_Seriessum
288 String 1 // description Seriessum
290 Text [ en-US ] = "Returns the sum of a power series";
293 String 2 // name of parameter 1 Seriessum
295 Text [ en-US ] = "X";
298 String 3 // description of parameter 1 Seriessum
300 Text [ en-US ] = "The independent variable of the power series";
303 String 4 // name of parameter 2 Seriessum
305 Text [ en-US ] = "N";
308 String 5 // description of parameter 2 Seriessum
310 Text [ en-US ] = "The initial power to which x is to be raised";
313 String 6 // name of parameter 3 Seriessum
315 Text [ en-US ] = "M";
318 String 7 // description of parameter 3 Seriessum
320 Text [ en-US ] = "The increment by which to increase n for each term in the series";
323 String 8 // name of parameter 4 Seriessum
325 Text [ en-US ] = "Coefficients";
328 String 9 // description of parameter 4 Seriessum
330 Text [ en-US ] = "Set of coefficients by which each successive power of the variable x is multiplied";
334 Resource ANALYSIS_Quotient
336 String 1 // description Quotient
338 Text [ en-US ] = "Returns the integer portion of a division";
341 String 2 // name of parameter 1 Quotient
343 Text [ en-US ] = "Numerator";
346 String 3 // description of parameter 1 Quotient
348 Text [ en-US ] = "The dividend";
351 String 4 // name of parameter 2 Quotient
353 Text [ en-US ] = "Denominator";
356 String 5 // description of parameter 2 Quotient
358 Text [ en-US ] = "The divisor";
362 Resource ANALYSIS_Mround
364 String 1 // description Mround
366 Text [ en-US ] = "Returns a number rounded to a specified multiple";
369 String 2 // name of parameter 1 Mround
371 Text [ en-US ] = "Number";
374 String 3 // description of parameter 1 Mround
376 Text [ en-US ] = "The number to round off";
379 String 4 // name of parameter 2 Mround
381 Text [ en-US ] = "Multiple";
384 String 5 // description of parameter 2 Mround
386 Text [ en-US ] = "The multiple to which you want to round number";
390 Resource ANALYSIS_Sqrtpi
392 String 1 // description SqrtPI
394 Text [ en-US ] = "Returns the square root of a number which has been multiplied by pi";
397 String 2 // name of parameter 1 SqrtPI
399 Text [ en-US ] = "Number";
402 String 3 // description of parameter 1 SqrtPI
404 Text [ en-US ] = "The number by which pi is multiplied";
408 Resource ANALYSIS_Randbetween
410 String 1 // description Randbetween
412 Text [ en-US ] = "Returns a random integer between the numbers you specify";
415 String 2 // name of parameter 1 Randbetween
417 Text [ en-US ] = "Bottom";
420 String 3 // description of parameter 1 Randbetween
422 Text [ en-US ] = "The smallest integer returned";
425 String 4 // name of parameter 2 Randbetween
427 Text [ en-US ] = "Top";
430 String 5 // description of parameter 2 Randbetween
432 Text [ en-US ] = "The largest integer returned";
436 Resource ANALYSIS_Gcd
438 String 1 // description Gcd_add
440 Text [ en-US ] = "Returns the greatest common divisor";
443 String 2 // name of parameter 1 Gcd_add
445 Text [ en-US ] = "Number(s)";
448 String 3 // description of parameter 1 Gcd_add
450 Text [ en-US ] = "Number or list of numbers";
454 Resource ANALYSIS_Lcm
456 String 1 // description Lcm_add
458 Text [ en-US ] = "Returns the least common multiple";
461 String 2 // name of parameter 1 Lcm_add
463 Text [ en-US ] = "Number(s)";
466 String 3 // description of parameter 1 Lcm_add
468 Text [ en-US ] = "Number or list of numbers";
472 Resource ANALYSIS_Besseli
474 String 1 // description BesselI
476 Text [ en-US ] = "Returns the modified Bessel function In(x)";
479 String 2 // name of parameter 1 BesselI
481 Text [ en-US ] = "X";
484 String 3 // description of parameter 1 BesselI
486 Text [ en-US ] = "The value at which the function is to be evaluated";
489 String 4 // name of parameter 2 BesselI
491 Text [ en-US ] = "N";
494 String 5 // description of parameter 2 BesselI
496 Text [ en-US ] = "The order of the Bessel function";
500 Resource ANALYSIS_Besselj
502 String 1 // description BesselJ
504 Text [ en-US ] = "Returns the Bessel function Jn(x)";
507 String 2 // name of parameter 1 BesselJ
509 Text [ en-US ] = "X";
512 String 3 // description of parameter 1 BesselJ
514 Text [ en-US ] = "The value at which the function is to be evaluated";
517 String 4 // name of parameter 2 BesselJ
519 Text [ en-US ] = "N";
522 String 5 // description of parameter 2 BesselJ
524 Text [ en-US ] = "The order of the Bessel function";
528 Resource ANALYSIS_Besselk
530 String 1 // description BesselK
532 Text [ en-US ] = "Returns the Bessel function Kn(x)";
535 String 2 // name of parameter 1 BesselK
537 Text [ en-US ] = "X";
540 String 3 // description of parameter 1 BesselK
542 Text [ en-US ] = "The value at which the function is to be evaluated";
545 String 4 // name of parameter 2 BesselK
547 Text [ en-US ] = "N";
550 String 5 // description of parameter 2 BesselK
552 Text [ en-US ] = "The order of the Bessel function";
556 Resource ANALYSIS_Bessely
558 String 1 // description BesselY
560 Text [ en-US ] = "Returns the Bessel function Yn(x)";
563 String 2 // name of parameter 1 BesselY
565 Text [ en-US ] = "X";
568 String 3 // description of parameter 1 BesselY
570 Text [ en-US ] = "The value at which the function is to be evaluated";
573 String 4 // name of parameter 2 BesselY
575 Text [ en-US ] = "N";
578 String 5 // description of parameter 2 BesselY
580 Text [ en-US ] = "The order of the Bessel function";
584 Resource ANALYSIS_Bin2Oct
586 String 1 // description Bin2Oct
588 Text [ en-US ] = "Converts a binary number to an octal number";
591 String 2 // name of parameter 1 Bin2Oct
593 Text [ en-US ] = "Number";
596 String 3 // description of parameter 1 Bin2Oct
598 Text [ en-US ] = "The binary number to be converted (as text)";
601 String 4 // name of parameter 2 Bin2Oct
603 Text [ en-US ] = "Places";
606 String 5 // description of parameter 2 Bin2Oct
608 Text [ en-US ] = "Number of places used";
612 Resource ANALYSIS_Bin2Dec
614 String 1 // description Bin2Dec
616 Text [ en-US ] = "Converts a binary number to a decimal number";
619 String 2 // name of parameter 1 Bin2Dec
621 Text [ en-US ] = "Number";
624 String 3 // description of parameter 1 Bin2Dec
626 Text [ en-US ] = "The binary number to be converted (as text)";
630 Resource ANALYSIS_Bin2Hex
632 String 1 // description Bin2Hex
634 Text [ en-US ] = "Converts a binary number to a hexadecimal number";
637 String 2 // name of parameter 1 Bin2Hex
639 Text [ en-US ] = "Number";
642 String 3 // description of parameter 1 Bin2Hex
644 Text [ en-US ] = "The binary number to be converted (as text)";
647 String 4 // name of parameter 2 Bin2Hex
649 Text [ en-US ] = "Places";
652 String 5 // description of parameter 2 Bin2Hex
654 Text [ en-US ] = "Number of places used.";
658 Resource ANALYSIS_Oct2Bin
660 String 1 // description Oct2Bin
662 Text [ en-US ] = "Converts an octal number to a binary number";
665 String 2 // name of parameter 1 Oct2Bin
667 Text [ en-US ] = "Number";
670 String 3 // description of parameter 1 Oct2Bin
672 Text [ en-US ] = "The octal number to be converted (as text)";
675 String 4 // name of parameter 2 Oct2Bin
677 Text [ en-US ] = "Places";
680 String 5 // description of parameter 2 Oct2Bin
682 Text [ en-US ] = "Number of places used";
686 Resource ANALYSIS_Oct2Dec
688 String 1 // description Oct2Dec
690 Text [ en-US ] = "Converts an octal number to a decimal number";
693 String 2 // name of parameter 1 Oct2Dec
695 Text [ en-US ] = "Number";
698 String 3 // description of parameter 1 Oct2Dec
700 Text [ en-US ] = "The octal number to be converted (as text)";
704 Resource ANALYSIS_Oct2Hex
706 String 1 // description Oct2Hex
708 Text [ en-US ] = "Converts an octal number to a hexadecimal number";
711 String 2 // name of parameter 1 Oct2Hex
713 Text [ en-US ] = "Number";
716 String 3 // description of parameter 1 Oct2Hex
718 Text [ en-US ] = "The octal number to be converted (as text)";
721 String 4 // name of parameter 2 Oct2Hex
723 Text [ en-US ] = "Places";
726 String 5 // description of parameter 2 Oct2Hex
728 Text [ en-US ] = "Number of places used";
732 Resource ANALYSIS_Dec2Bin
734 String 1 // description Dec2Bin
736 Text [ en-US ] = "Converts a decimal number to a binary number";
739 String 2 // name of parameter 1 Dec2Bin
741 Text [ en-US ] = "Number";
744 String 3 // description of parameter 1 Dec2Bin
746 Text [ en-US ] = "The decimal integer to be converted";
749 String 4 // name of parameter 2 Dec2Bin
751 Text [ en-US ] = "Places";
754 String 5 // description of parameter 2 Dec2Bin
756 Text [ en-US ] = "Number of places used";
760 Resource ANALYSIS_Dec2Hex
762 String 1 // description Dec2Hex
764 Text [ en-US ] = "Converts a decimal number to a hexadecimal number";
767 String 2 // name of parameter 1 Dec2Hex
769 Text [ en-US ] = "Number";
772 String 3 // description of parameter 1 Dec2Hex
774 Text [ en-US ] = "The decimal integer to be converted";
777 String 4 // name of parameter 2 Dec2Hex
779 Text [ en-US ] = "Places";
782 String 5 // description of parameter 2 Dec2Hex
784 Text [ en-US ] = "Number of places used";
788 Resource ANALYSIS_Dec2Oct
790 String 1 // description Dec2Oct
792 Text [ en-US ] = "Converts a decimal number into an octal number";
795 String 2 // name of parameter 1 Dec2Oct
797 Text [ en-US ] = "Number";
800 String 3 // description of parameter 1 Dec2Oct
802 Text [ en-US ] = "The decimal number";
805 String 4 // name of parameter 2 Dec2Oct
807 Text [ en-US ] = "Places";
810 String 5 // description of parameter 2 Dec2Oct
812 Text [ en-US ] = "Number of places used";
816 Resource ANALYSIS_Hex2Bin
818 String 1 // description Hex2Bin
820 Text [ en-US ] = "Converts a hexadecimal number to a binary number";
823 String 2 // name of parameter 1 Hex2Bin
825 Text [ en-US ] = "Number";
828 String 3 // description of parameter 1 Hex2Bin
830 Text [ en-US ] = "The hexadecimal number to be converted (as text)";
833 String 4 // name of parameter 2 Hex2Bin
835 Text [ en-US ] = "Places";
838 String 5 // description of parameter 2 Hex2Bin
840 Text [ en-US ] = "Number of places used";
844 Resource ANALYSIS_Hex2Dec
846 String 1 // description Hex2Dec
848 Text [ en-US ] = "Converts a hexadecimal number to a decimal number";
851 String 2 // name of parameter 1 Hex2Dec
853 Text [ en-US ] = "Number";
856 String 3 // description of parameter 1 Hex2Dec
858 Text [ en-US ] = "The hexadecimal number to be converted (as text)";
862 Resource ANALYSIS_Hex2Oct
864 String 1 // description Hex2Oct
866 Text [ en-US ] = "Converts a hexadecimal number to an octal number";
869 String 2 // name of parameter 1 Hex2Oct
871 Text [ en-US ] = "Number";
874 String 3 // description of parameter 1 Hex2Oct
876 Text [ en-US ] = "The hexadecimal number to be converted (as text)";
879 String 4 // name of parameter 2 Hex2Oct
881 Text [ en-US ] = "Places";
884 String 5 // description of parameter 2 Hex2Oct
886 Text [ en-US ] = "Number of places used";
890 Resource ANALYSIS_Delta
892 String 1 // description Delta
894 Text [ en-US ] = "Tests whether two values are equal";
897 String 2 // name of parameter 1 Delta
899 Text [ en-US ] = "Number 1";
902 String 3 // description of parameter 1 Delta
904 Text [ en-US ] = "The first number";
907 String 4 // name of parameter 2 Delta
909 Text [ en-US ] = "Number 2";
912 String 5 // description of parameter 2 Delta
914 Text [ en-US ] = "The second number";
918 Resource ANALYSIS_Erf
920 String 1 // description Erf
922 Text [ en-US ] = "Returns the error function";
925 String 2 // name of parameter 1 Erf
927 Text [ en-US ] = "Lower limit";
930 String 3 // description of parameter 1 Erf
932 Text [ en-US ] = "The lower limit for integration";
935 String 4 // name of parameter 2 Erf
937 Text [ en-US ] = "Upper limit";
940 String 5 // description of parameter 2 Erf
942 Text [ en-US ] = "The upper limit for integration";
946 Resource ANALYSIS_Erfc
948 String 1 // description Erfc
950 Text [ en-US ] = "Returns the complementary error function";
953 String 2 // name of parameter 1 Erfc
955 Text [ en-US ] = "Lower limit";
958 String 3 // description of parameter 1 Erfc
960 Text [ en-US ] = "The lower limit for integration";
964 Resource ANALYSIS_Gestep
966 String 1 // description GeStep
968 Text [ en-US ] = "Tests whether a number is greater than a threshold value";
971 String 2 // name of parameter 1 GeStep
973 Text [ en-US ] = "Number";
976 String 3 // description of parameter 1 GeStep
978 Text [ en-US ] = "The value to test against step";
981 String 4 // name of parameter 2 GeStep
983 Text [ en-US ] = "Step";
986 String 5 // description of parameter 2 GeStep
988 Text [ en-US ] = "The threshhold value";
992 Resource ANALYSIS_Factdouble
994 String 1 // description Factdouble
996 Text [ en-US ] = "Returns the double factorial of Number";
999 String 2 // name of parameter 1 Factdouble
1001 Text [ en-US ] = "Number";
1004 String 3 // description of parameter 1 Factdouble
1006 Text [ en-US ] = "The number";
1010 Resource ANALYSIS_Imabs
1012 String 1 // description Imabs
1014 Text [ en-US ] = "Returns the absolute value (modulus) of a complex number";
1017 String 2 // name of parameter 1 Imabs
1019 Text [ en-US ] = "Complex number";
1022 String 3 // description of parameter 1 Imabs
1024 Text [ en-US ] = "The complex number";
1028 Resource ANALYSIS_Imaginary
1030 String 1 // description Imaginary
1032 Text [ en-US ] = "Returns the imaginary coefficient of a complex number";
1035 String 2 // name of parameter 1 Imaginary
1037 Text [ en-US ] = "Complex number";
1040 String 3 // description of parameter 1 Imaginary
1042 Text [ en-US ] = "The complex number";
1046 Resource ANALYSIS_Impower
1048 String 1 // description Impower
1050 Text [ en-US ] = "Returns a complex number raised to an integer power";
1053 String 2 // name of parameter 1 Impower
1055 Text [ en-US ] = "Complex number";
1058 String 3 // description of parameter 1 Impower
1060 Text [ en-US ] = "The complex number";
1063 String 4 // name of parameter 2 Impower
1065 Text [ en-US ] = "Number";
1068 String 5 // description of parameter 2 Impower
1070 Text [ en-US ] = "Power to which the complex number is raised";
1074 Resource ANALYSIS_Imargument
1076 String 1 // description Imargument
1078 Text [ en-US ] = "Returns the argument theta, an angle expressed in radians";
1081 String 2 // name of parameter 1 Imargument
1083 Text [ en-US ] = "Complex number";
1086 String 3 // description of parameter 1 Imargument
1088 Text [ en-US ] = "A complex number";
1092 Resource ANALYSIS_Imcos
1094 String 1 // description Imcos
1096 Text [ en-US ] = "Returns the cosine of a complex number";
1099 String 2 // name of parameter 1 Imcos
1101 Text [ en-US ] = "Complex number";
1104 String 3 // description of parameter 1 Imcos
1106 Text [ en-US ] = "A complex number";
1110 Resource ANALYSIS_Imdiv
1112 String 1 // description Imdiv
1114 Text [ en-US ] = "Returns the quotient of two complex numbers";
1117 String 2 // name of parameter 1 Imdiv
1119 Text [ en-US ] = "Numerator";
1122 String 3 // description of parameter 1 Imdiv
1124 Text [ en-US ] = "The dividend";
1127 String 4 // name of parameter 2 Imdiv
1129 Text [ en-US ] = "Denominator";
1132 String 5 // description of parameter 2 Imdiv
1134 Text [ en-US ] = "The divisor";
1138 Resource ANALYSIS_Imexp
1140 String 1 // description Imexp
1142 Text [ en-US ] = "Returns the algebraic form of the exponential of a complex number";
1145 String 2 // name of parameter 1 Imexp
1147 Text [ en-US ] = "Complex number";
1150 String 3 // description of parameter 1 Imexp
1152 Text [ en-US ] = "The complex number";
1156 Resource ANALYSIS_Imconjugate
1158 String 1 // description Imconjugate
1160 Text [ en-US ] = "Returns the complex conjugate of a complex number";
1163 String 2 // name of parameter 1 Imconjugate
1165 Text [ en-US ] = "Complex number";
1168 String 3 // description of parameter 1 Imconjugate
1170 Text [ en-US ] = "The complex number";
1174 Resource ANALYSIS_Imln
1176 String 1 // description Imln
1178 Text [ en-US ] = "Returns the natural logarithm of a complex number";
1181 String 2 // name of parameter 1 Imln
1183 Text [ en-US ] = "Complex number";
1186 String 3 // description of parameter 1 Imln
1188 Text [ en-US ] = "The complex number";
1192 Resource ANALYSIS_Imlog10
1194 String 1 // description Imlog10
1196 Text [ en-US ] = "Returns the base-10 logarithm of a complex number";
1199 String 2 // name of parameter 1 Imlog10
1201 Text [ en-US ] = "Complex number";
1204 String 3 // description of parameter 1 Imlog10
1206 Text [ en-US ] = "The complex number";
1210 Resource ANALYSIS_Imlog2
1212 String 1 // description Imlog2
1214 Text [ en-US ] = "Returns the base-2 logarithm of a complex number";
1217 String 2 // name of parameter 1 Imlog2
1219 Text [ en-US ] = "Complex number";
1222 String 3 // description of parameter 1 Imlog2
1224 Text [ en-US ] = "The complex number";
1228 Resource ANALYSIS_Improduct
1230 String 1 // description Improduct
1232 Text [ en-US ] = "Returns the product of several complex numbers";
1235 String 2 // name of parameter 1 Improduct
1237 Text [ en-US ] = "Complex number";
1240 String 3 // description of parameter 1 Improduct
1242 Text [ en-US ] = "The first complex number";
1245 String 4 // name of parameter 2 Improduct
1247 Text [ en-US ] = "Complex number";
1250 String 5 // description of parameter 2 Improduct
1252 Text [ en-US ] = "Another complex number";
1256 Resource ANALYSIS_Imreal
1258 String 1 // description Imreal
1260 Text [ en-US ] = "Returns the real coefficient of a complex number";
1263 String 2 // name of parameter 1 Imreal
1265 Text [ en-US ] = "Complex number";
1268 String 3 // description of parameter 1 Imreal
1270 Text [ en-US ] = "The complex number";
1274 Resource ANALYSIS_Imsin
1276 String 1 // description Imsin
1278 Text [ en-US ] = "Returns the sine of a complex number";
1281 String 2 // name of parameter 1 Imsin
1283 Text [ en-US ] = "Complex number";
1286 String 3 // description of parameter 1 Imsin
1288 Text [ en-US ] = "The complex number";
1292 Resource ANALYSIS_Imsub
1294 String 1 // description Imsub
1296 Text [ en-US ] = "Returns the difference of two complex numbers";
1299 String 2 // name of parameter 1 Imsub
1301 Text [ en-US ] = "Complex number 1";
1304 String 3 // description of parameter 1 Imsub
1306 Text [ en-US ] = "Complex number 1";
1309 String 4 // name of parameter 2 Imsub
1311 Text [ en-US ] = "Complex number 2";
1314 String 5 // description of parameter 2 Imsub
1316 Text [ en-US ] = "Complex number 2";
1320 Resource ANALYSIS_Imsqrt
1322 String 1 // description Imsqrt
1324 Text [ en-US ] = "Returns the square root of a complex number";
1327 String 2 // name of parameter 1 Imsqrt
1329 Text [ en-US ] = "Complex number";
1332 String 3 // description of parameter 1 Imsqrt
1334 Text [ en-US ] = "The complex number";
1338 Resource ANALYSIS_Imsum
1340 String 1 // description Imsum
1342 Text [ en-US ] = "Returns the sum of complex numbers";
1345 String 2 // name of parameter 1 Imsum
1347 Text [ en-US ] = "Complex number";
1350 String 3 // description of parameter 1 Imsum
1352 Text [ en-US ] = "The complex number";
1357 Resource ANALYSIS_Complex
1359 String 1 // description Complex
1361 Text [ en-US ] = "Converts real and imaginary coefficients into a complex number";
1364 String 2 // name of parameter 1 Complex
1366 Text [ en-US ] = "Real num";
1369 String 3 // description of parameter 1 Complex
1371 Text [ en-US ] = "The real coefficient";
1374 String 4 // name of parameter 2 Complex
1376 Text [ en-US ] = "I num";
1379 String 5 // description of parameter 2 Complex
1381 Text [ en-US ] = "The imaginary coefficient";
1384 String 6 // name of parameter 3 Complex
1386 Text [ en-US ] = "Suffix";
1389 String 7 // description of parameter 3 Complex
1391 Text [ en-US ] = "The suffix";
1395 Resource ANALYSIS_Convert
1397 String 1 // description Convert_add
1399 Text [ en-US ] = "Converts a number from one measurement system to another";
1402 String 2 // name of parameter 1 Convert_add
1404 Text [ en-US ] = "Number";
1407 String 3 // description of parameter 1 Convert_add
1409 Text [ en-US ] = "The number";
1412 String 4 // name of parameter 2 Convert_add
1414 Text [ en-US ] = "From unit";
1417 String 5 // description of parameter 2 Convert_add
1419 Text [ en-US ] = "Unit of measure for number";
1422 String 6 // name of parameter 3 Convert_add
1424 Text [ en-US ] = "To unit";
1427 String 7 // description of parameter 3 Convert_add
1429 Text [ en-US ] = "Unit of measure for the result";
1433 Resource ANALYSIS_Amordegrc
1435 String 1 // description Amordegrc
1437 Text [ en-US ] = "Returns the prorated linear depreciation of an asset for each accounting period";
1440 String 2 // name of parameter 1 Amordegrc
1442 Text [ en-US ] = "Cost";
1445 String 3 // description of parameter 1 Amordegrc
1447 Text [ en-US ] = "Cost of the asset";
1450 String 4 // name of parameter 2 Amordegrc
1452 Text [ en-US ] = "Date purchased";
1455 String 5 // description of parameter 2 Amordegrc
1457 Text [ en-US ] = "Purchase date of the asset";
1460 String 6 // name of parameter 3 Amordegrc
1462 Text [ en-US ] = "First period";
1465 String 7 // description of parameter 3 Amordegrc
1467 Text [ en-US ] = "Date the first period ends";
1470 String 8 // name of parameter 4 Amordegrc
1472 Text [ en-US ] = "Salvage";
1475 String 9 // description of parameter 4 Amordegrc
1477 Text [ en-US ] = "Salvage value of an asset at the end of its life";
1480 String 10 // name of parameter 5 Amordegrc
1482 Text [ en-US ] = "Period";
1485 String 11 // description of parameter 5 Amordegrc
1487 Text [ en-US ] = "The period";
1490 String 12 // name of parameter 6 Amordegrc
1492 Text [ en-US ] = "Rate";
1495 String 13 // description of parameter 6 Amordegrc
1497 Text [ en-US ] = "The rate of depreciation";
1500 String 14 // name of parameter 7 Amordegrc
1502 Text [ en-US ] = "Basis";
1505 String 15 // description of parameter 7 Amordegrc
1507 Text [ en-US ] = "The year basis to be used";
1511 Resource ANALYSIS_Amorlinc
1513 String 1 // description Amorlinc
1515 Text [ en-US ] = "Returns the prorated linear depreciation of an asset for each accounting period";
1518 String 2 // name of parameter 1 Amorlinc
1520 Text [ en-US ] = "Cost";
1523 String 3 // description of parameter 1 Amorlinc
1525 Text [ en-US ] = "Cost of the asset";
1528 String 4 // name of parameter 2 Amorlinc
1530 Text [ en-US ] = "Date purchased";
1533 String 5 // description of parameter 2 Amorlinc
1535 Text [ en-US ] = "Purchase date of the asset";
1538 String 6 // name of parameter 3 Amorlinc
1540 Text [ en-US ] = "First period";
1543 String 7 // description of parameter 3 Amorlinc
1545 Text [ en-US ] = "The date the first period ends";
1548 String 8 // name of parameter 4 Amorlinc
1550 Text [ en-US ] = "Salvage";
1553 String 9 // description of parameter 4 Amorlinc
1555 Text [ en-US ] = "The salvage value of an asset at the end of its life";
1558 String 10 // name of parameter 5 Amorlinc
1560 Text [ en-US ] = "Period";
1563 String 11 // description of parameter 5 Amorlinc
1565 Text [ en-US ] = "The period";
1568 String 12 // name of parameter 6 Amorlinc
1570 Text [ en-US ] = "Rate";
1573 String 13 // description of parameter 6 Amorlinc
1575 Text [ en-US ] = "The rate of depreciation";
1578 String 14 // name of parameter 7 Amorlinc
1580 Text [ en-US ] = "Basis";
1583 String 15 // description of parameter 7 Amorlinc
1585 Text [ en-US ] = "The year basis to be used";
1589 Resource ANALYSIS_Accrint
1591 String 1 // description Accrint
1593 Text [ en-US ] = "Returns the accrued interest for a security that pays periodic interest";
1596 String 2 // name of parameter 1 Accrint
1598 Text [ en-US ] = "Issue";
1601 String 3 // description of parameter 1 Accrint
1603 Text [ en-US ] = "Issue date of the security";
1606 String 4 // name of parameter 2 Accrint
1608 Text [ en-US ] = "First interest";
1611 String 5 // description of parameter 2 Accrint
1613 Text [ en-US ] = "First interest date of the security";
1616 String 6 // name of parameter 3 Accrint
1618 Text [ en-US ] = "Settlement";
1621 String 7 // description of parameter 3 Accrint
1623 Text [ en-US ] = "The settlement";
1626 String 8 // name of parameter 4 Accrint
1628 Text [ en-US ] = "Rate";
1631 String 9 // description of parameter 4 Accrint
1633 Text [ en-US ] = "The rate";
1636 String 10 // name of parameter 5 Accrint
1638 Text [ en-US ] = "Par";
1641 String 11 // description of parameter 5 Accrint
1643 Text [ en-US ] = "The par value";
1646 String 12 // name of parameter 6 Accrint
1648 Text [ en-US ] = "Frequency";
1651 String 13 // description of parameter 6 Accrint
1653 Text [ en-US ] = "The frequency";
1656 String 14 // name of parameter 7 Accrint
1658 Text [ en-US ] = "Basis";
1661 String 15 // description of parameter 7 Accrint
1663 Text [ en-US ] = "The basis";
1667 Resource ANALYSIS_Accrintm
1669 String 1 // description Accrintm
1671 Text [ en-US ] = "Returns the accrued interest for a security that pays interest at maturity";
1674 String 2 // name of parameter 1 Accrintm
1676 Text [ en-US ] = "Issue";
1679 String 3 // description of parameter 1 Accrintm
1681 Text [ en-US ] = "The issue date";
1684 String 4 // name of parameter 2 Accrintm
1686 Text [ en-US ] = "Settlement";
1689 String 5 // description of parameter 2 Accrintm
1691 Text [ en-US ] = "The settlement";
1694 String 6 // name of parameter 3 Accrintm
1696 Text [ en-US ] = "Rate";
1699 String 7 // description of parameter 3 Accrintm
1701 Text [ en-US ] = "The rate";
1704 String 8 // name of parameter 4 Accrintm
1706 Text [ en-US ] = "Par";
1709 String 9 // description of parameter 4 Accrintm
1711 Text [ en-US ] = "The par value";
1714 String 10 // name of parameter 5 Accrintm
1716 Text [ en-US ] = "Basis";
1719 String 11 // description of parameter 5 Accrintm
1721 Text [ en-US ] = "The basis";
1725 Resource ANALYSIS_Received
1727 String 1 // description Received
1729 Text [ en-US ] = "Returns the amount paid out at maturity for a fully invested security";
1732 String 2 // name of parameter 1 Received
1734 Text [ en-US ] = "Settlement";
1737 String 3 // description of parameter 1 Received
1739 Text [ en-US ] = "The settlement";
1742 String 4 // name of parameter 2 Received
1744 Text [ en-US ] = "Maturity";
1747 String 5 // description of parameter 2 Received
1749 Text [ en-US ] = "The maturity";
1752 String 6 // name of parameter 3 Received
1754 Text [ en-US ] = "Investment";
1757 String 7 // description of parameter 3 Received
1759 Text [ en-US ] = "The investment";
1762 String 8 // name of parameter 4 Received
1764 Text [ en-US ] = "Discount";
1767 String 9 // description of parameter 4 Received
1769 Text [ en-US ] = "The discount";
1772 String 10 // name of parameter 5 Received
1774 Text [ en-US ] = "Basis";
1777 String 11 // description of parameter 5 Received
1779 Text [ en-US ] = "The basis";
1783 Resource ANALYSIS_Disc
1785 String 1 // description Disc
1787 Text [ en-US ] = "Returns the discount rate for a security";
1790 String 2 // name of parameter 1 Disc
1792 Text [ en-US ] = "Settlement";
1795 String 3 // description of parameter 1 Disc
1797 Text [ en-US ] = "The settlement";
1800 String 4 // name of parameter 2 Disc
1802 Text [ en-US ] = "Maturity";
1805 String 5 // description of parameter 2 Disc
1807 Text [ en-US ] = "The maturity";
1810 String 6 // name of parameter 3 Disc
1812 Text [ en-US ] = "Price";
1815 String 7 // description of parameter 3 Disc
1817 Text [ en-US ] = "The price";
1820 String 8 // name of parameter 4 Disc
1822 Text [ en-US ] = "Redemption";
1825 String 9 // description of parameter 4 Disc
1827 Text [ en-US ] = "The redemption value";
1830 String 10 // name of parameter 5 Disc
1832 Text [ en-US ] = "Basis";
1835 String 11 // description of parameter 5 Disc
1837 Text [ en-US ] = "The basis";
1841 Resource ANALYSIS_Duration
1843 String 1 // description Duration
1845 Text [ en-US ] = "Returns the annual Macaulay duration of a security with periodic interest payments";
1848 String 2 // name of parameter 1 Duration
1850 Text [ en-US ] = "Settlement";
1853 String 3 // description of parameter 1 Duration
1855 Text [ en-US ] = "The settlement";
1858 String 4 // name of parameter 2 Duration
1860 Text [ en-US ] = "Maturity";
1863 String 5 // description of parameter 2 Duration
1865 Text [ en-US ] = "The maturity";
1868 String 6 // name of parameter 3 Duration
1870 Text [ en-US ] = "Coupon";
1873 String 7 // description of parameter 3 Duration
1875 Text [ en-US ] = "The coupon rate";
1878 String 8 // name of parameter 4 Duration
1880 Text [ en-US ] = "Yield";
1883 String 9 // description of parameter 4 Duration
1885 Text [ en-US ] = "The yield";
1888 String 10 // name of parameter 5 Duration
1890 Text [ en-US ] = "Frequency";
1893 String 11 // description of parameter 5 Duration
1895 Text [ en-US ] = "The frequency";
1898 String 12 // name of parameter 6 Duration
1900 Text [ en-US ] = "Basis";
1903 String 13 // description of parameter 6 Duration
1905 Text [ en-US ] = "The basis";
1909 Resource ANALYSIS_Effect
1911 String 1 // description Effect_add
1913 Text [ en-US ] = "Returns the effective annual interest rate";
1916 String 2 // name of parameter 1 Effect_add
1918 Text [ en-US ] = "Nominal rate";
1921 String 3 // description of parameter 1 Effect_add
1923 Text [ en-US ] = "The nominal rate";
1926 String 4 // name of parameter 2 Effect_add
1928 Text [ en-US ] = "Npery";
1931 String 5 // description of parameter 2 Effect_add
1933 Text [ en-US ] = "The periods";
1937 Resource ANALYSIS_Cumprinc
1939 String 1 // description Cumprinc_add
1941 Text [ en-US ] = "Returns the cumulative principal on a loan to be paid between two periods";
1944 String 2 // name of parameter 1 Cumprinc_add
1946 Text [ en-US ] = "Rate";
1949 String 3 // description of parameter 1 Cumprinc_add
1951 Text [ en-US ] = "The rate";
1954 String 4 // name of parameter 2 Cumprinc_add
1956 Text [ en-US ] = "Nper";
1959 String 5 // description of parameter 2 Cumprinc_add
1961 Text [ en-US ] = "Number of payment periods";
1964 String 6 // name of parameter 3 Cumprinc_add
1966 Text [ en-US ] = "Pv";
1969 String 7 // description of parameter 3 Cumprinc_add
1971 Text [ en-US ] = "The present value";
1974 String 8 // name of parameter 4 Cumprinc_add
1976 Text [ en-US ] = "Start period";
1979 String 9 // description of parameter 4 Cumprinc_add
1981 Text [ en-US ] = "The start period";
1984 String 10 // name of parameter 5 Cumprinc_add
1986 Text [ en-US ] = "End period";
1989 String 11 // description of parameter 5 Cumprinc_add
1991 Text [ en-US ] = "The end period";
1994 String 12 // name of parameter 6 Cumprinc_add
1996 Text [ en-US ] = "Type";
1999 String 13 // description of parameter 6 Cumprinc_add
2001 Text [ en-US ] = "The type of maturity";
2005 Resource ANALYSIS_Cumipmt
2007 String 1 // description Cumipmt_add
2009 Text [ en-US ] = "Returns the cumulative interest to be paid between two periods";
2012 String 2 // name of parameter 1 Cumipmt_add
2014 Text [ en-US ] = "Rate";
2017 String 3 // description of parameter 1 Cumipmt_add
2019 Text [ en-US ] = "The rate";
2022 String 4 // name of parameter 2 Cumipmt_add
2024 Text [ en-US ] = "Nper";
2027 String 5 // description of parameter 2 Cumipmt_add
2029 Text [ en-US ] = "Number of payment periods";
2032 String 6 // name of parameter 3 Cumipmt_add
2034 Text [ en-US ] = "Pv";
2037 String 7 // description of parameter 3 Cumipmt_add
2039 Text [ en-US ] = "The present value";
2042 String 8 // name of parameter 4 Cumipmt_add
2044 Text [ en-US ] = "Start period";
2047 String 9 // description of parameter 4 Cumipmt_add
2049 Text [ en-US ] = "The start period";
2052 String 10 // name of parameter 5 Cumipmt_add
2054 Text [ en-US ] = "End period";
2057 String 11 // description of parameter 5 Cumipmt_add
2059 Text [ en-US ] = "The end period";
2062 String 12 // name of parameter 6 Cumipmt_add
2064 Text [ en-US ] = "Type";
2067 String 13 // description of parameter 6 Cumipmt_add
2069 Text [ en-US ] = "The type of maturity";
2073 Resource ANALYSIS_Price
2075 String 1 // description Price
2077 Text [ en-US ] = "Returns the price per 100 currency units face value of a security that pays periodic interest";
2080 String 2 // name of parameter 1 Price
2082 Text [ en-US ] = "Settlement";
2085 String 3 // description of parameter 1 Price
2087 Text [ en-US ] = "The settlement";
2090 String 4 // name of parameter 2 Price
2092 Text [ en-US ] = "Maturity";
2095 String 5 // description of parameter 2 Price
2097 Text [ en-US ] = "The maturity";
2100 String 6 // name of parameter 3 Price
2102 Text [ en-US ] = "Rate";
2105 String 7 // description of parameter 3 Price
2107 Text [ en-US ] = "The rate";
2110 String 8 // name of parameter 4 Price
2112 Text [ en-US ] = "Yield";
2115 String 9 // description of parameter 4 Price
2117 Text [ en-US ] = "The yield";
2120 String 10 // name of parameter 5 Price
2122 Text [ en-US ] = "Redemption";
2125 String 11 // description of parameter 5 Price
2127 Text [ en-US ] = "The redemption value";
2130 String 12 // name of parameter 6 Price
2132 Text [ en-US ] = "Frequency";
2135 String 13 // description of parameter 6 Price
2137 Text [ en-US ] = "The frequency";
2140 String 14 // name of parameter 7 Price
2142 Text [ en-US ] = "Basis";
2145 String 15 // description of parameter 7 Price
2147 Text [ en-US ] = "The basis";
2151 Resource ANALYSIS_Pricedisc
2153 String 1 // description Pricedisc
2155 Text [ en-US ] = "Returns the price per 100 currency units face value of a discounted security";
2158 String 2 // name of parameter 1 Pricedisc
2160 Text [ en-US ] = "Settlement";
2163 String 3 // description of parameter 1 Pricedisc
2165 Text [ en-US ] = "The settlement";
2168 String 4 // name of parameter 2 Pricedisc
2170 Text [ en-US ] = "Maturity";
2173 String 5 // description of parameter 2 Pricedisc
2175 Text [ en-US ] = "The maturity";
2178 String 6 // name of parameter 3 Pricedisc
2180 Text [ en-US ] = "Discount";
2183 String 7 // description of parameter 3 Pricedisc
2185 Text [ en-US ] = "The discount";
2188 String 8 // name of parameter 4 Pricedisc
2190 Text [ en-US ] = "Redemption";
2193 String 9 // description of parameter 4 Pricedisc
2195 Text [ en-US ] = "The redemption value";
2198 String 10 // name of parameter 5 Pricedisc
2200 Text [ en-US ] = "Basis";
2203 String 11 // description of parameter 5 Pricedisc
2205 Text [ en-US ] = "The basis";
2209 Resource ANALYSIS_Pricemat
2211 String 1 // description Pricemat
2213 Text [ en-US ] = "Returns the price per 100 currency units face value of a security that pays interest at maturity";
2216 String 2 // name of parameter 1 Pricemat
2218 Text [ en-US ] = "Settlement";
2221 String 3 // description of parameter 1 Pricemat
2223 Text [ en-US ] = "The settlement";
2226 String 4 // name of parameter 2 Pricemat
2228 Text [ en-US ] = "Maturity";
2231 String 5 // description of parameter 2 Pricemat
2233 Text [ en-US ] = "The maturity";
2236 String 6 // name of parameter 3 Pricemat
2238 Text [ en-US ] = "Issue";
2241 String 7 // description of parameter 3 Pricemat
2243 Text [ en-US ] = "The issue date";
2246 String 8 // name of parameter 4 Pricemat
2248 Text [ en-US ] = "Rate";
2251 String 9 // description of parameter 4 Pricemat
2253 Text [ en-US ] = "The rate";
2256 String 10 // name of parameter 5 Pricemat
2258 Text [ en-US ] = "Yield";
2261 String 11 // description of parameter 5 Pricemat
2263 Text [ en-US ] = "The yield";
2266 String 12 // name of parameter 6 Pricemat
2268 Text [ en-US ] = "Basis";
2271 String 13 // description of parameter 6 Pricemat
2273 Text [ en-US ] = "The basis";
2277 Resource ANALYSIS_Mduration
2279 String 1 // description Mduration
2281 Text [ en-US ] = "Returns the Macaulay modified duration for a security with an assumed par value of 100 currency units";
2284 String 2 // name of parameter 1 Mduration
2286 Text [ en-US ] = "Settlement";
2289 String 3 // description of parameter 1 Mduration
2291 Text [ en-US ] = "The settlement";
2294 String 4 // name of parameter 2 Mduration
2296 Text [ en-US ] = "Maturity";
2299 String 5 // description of parameter 2 Mduration
2301 Text [ en-US ] = "The maturity";
2304 String 6 // name of parameter 3 Mduration
2306 Text [ en-US ] = "Coupon";
2309 String 7 // description of parameter 3 Mduration
2311 Text [ en-US ] = "The coupon rate";
2314 String 8 // name of parameter 4 Mduration
2316 Text [ en-US ] = "Yield";
2319 String 9 // description of parameter 4 Mduration
2321 Text [ en-US ] = "The yield";
2324 String 10 // name of parameter 5 Mduration
2326 Text [ en-US ] = "Frequency";
2329 String 11 // description of parameter 5 Mduration
2331 Text [ en-US ] = "The frequency";
2334 String 12 // name of parameter 6 Mduration
2336 Text [ en-US ] = "Basis";
2339 String 13 // description of parameter 6 Mduration
2341 Text [ en-US ] = "The basis";
2345 Resource ANALYSIS_Nominal
2347 String 1 // description Nominal_add
2349 Text [ en-US ] = "Returns the annual nominal interest rate";
2352 String 2 // name of parameter 1 Nominal_add
2354 Text [ en-US ] = "Effective rate";
2357 String 3 // description of parameter 1 Nominal_add
2359 Text [ en-US ] = "The effective interest rate";
2362 String 4 // name of parameter 2 Nominal_add
2364 Text [ en-US ] = "Npery";
2367 String 5 // description of parameter 2 Nominal_add
2369 Text [ en-US ] = "The periods";
2373 Resource ANALYSIS_Dollarfr
2375 String 1 // description Dollarfr
2377 Text [ en-US ] = "Converts a price expressed as a decimal into a price expressed as a fraction";
2380 String 2 // name of parameter 1 Dollarfr
2382 Text [ en-US ] = "Decimal dollar";
2385 String 3 // description of parameter 1 Dollarfr
2387 Text [ en-US ] = "The decimal number";
2390 String 4 // name of parameter 2 Dollarfr
2392 Text [ en-US ] = "Fraction";
2395 String 5 // description of parameter 2 Dollarfr
2397 Text [ en-US ] = "The divisor";
2401 Resource ANALYSIS_Dollarde
2403 String 1 // description Dollarde
2405 Text [ en-US ] = "Converts a price expressed as a fraction into a price expressed as a decimal";
2408 String 2 // name of parameter 1 Dollarde
2410 Text [ en-US ] = "Fractional dollar";
2413 String 3 // description of parameter 1 Dollarde
2415 Text [ en-US ] = "The number as a fraction";
2418 String 4 // name of parameter 2 Dollarde
2420 Text [ en-US ] = "Fraction";
2423 String 5 // description of parameter 2 Dollarde
2425 Text [ en-US ] = "The divisor";
2429 Resource ANALYSIS_Yield
2431 String 1 // description Yield
2433 Text [ en-US ] = "Returns the yield on a security that pays periodic interest";
2436 String 2 // name of parameter 1 Yield
2438 Text [ en-US ] = "Settlement";
2441 String 3 // description of parameter 1 Yield
2443 Text [ en-US ] = "The settlement";
2446 String 4 // name of parameter 2 Yield
2448 Text [ en-US ] = "Maturity";
2451 String 5 // description of parameter 2 Yield
2453 Text [ en-US ] = "The maturity";
2456 String 6 // name of parameter 3 Yield
2458 Text [ en-US ] = "Rate";
2461 String 7 // description of parameter 3 Yield
2463 Text [ en-US ] = "The rate";
2466 String 8 // name of parameter 4 Yield
2468 Text [ en-US ] = "Price";
2471 String 9 // description of parameter 4 Yield
2473 Text [ en-US ] = "The price";
2476 String 10 // name of parameter 5 Yield
2478 Text [ en-US ] = "Redemption";
2481 String 11 // description of parameter 5 Yield
2483 Text [ en-US ] = "The redemption value";
2486 String 12 // name of parameter 6 Yield
2488 Text [ en-US ] = "Frequency";
2491 String 13 // description of parameter 6 Yield
2493 Text [ en-US ] = "The frequency";
2496 String 14 // name of parameter 7 Yield
2498 Text [ en-US ] = "Basis";
2501 String 15 // description of parameter 7 Yield
2503 Text [ en-US ] = "The basis";
2507 Resource ANALYSIS_Yielddisc
2509 String 1 // description Yielddisc
2511 Text [ en-US ] = "Returns the annual yield for a discounted security";
2514 String 2 // name of parameter 1 Yielddisc
2516 Text [ en-US ] = "Settlement";
2519 String 3 // description of parameter 1 Yielddisc
2521 Text [ en-US ] = "The settlement";
2524 String 4 // name of parameter 2 Yielddisc
2526 Text [ en-US ] = "Maturity";
2529 String 5 // description of parameter 2 Yielddisc
2531 Text [ en-US ] = "The maturity";
2534 String 6 // name of parameter 3 Yielddisc
2536 Text [ en-US ] = "Price";
2539 String 7 // description of parameter 3 Yielddisc
2541 Text [ en-US ] = "The price";
2544 String 8 // name of parameter 4 Yielddisc
2546 Text [ en-US ] = "Redemption";
2549 String 9 // description of parameter 4 Yielddisc
2551 Text [ en-US ] = "The redemption value";
2554 String 10 // name of parameter 5 Yielddisc
2556 Text [ en-US ] = "Basis";
2559 String 11 // description of parameter 5 Yielddisc
2561 Text [ en-US ] = "The basis";
2565 Resource ANALYSIS_Yieldmat
2567 String 1 // description Yieldmat
2569 Text [ en-US ] = "Returns the annual yield of a security that pays interest at maturity";
2572 String 2 // name of parameter 1 Yieldmat
2574 Text [ en-US ] = "Settlement";
2577 String 3 // description of parameter 1 Yieldmat
2579 Text [ en-US ] = "The settlement";
2582 String 4 // name of parameter 2 Yieldmat
2584 Text [ en-US ] = "Maturity";
2587 String 5 // description of parameter 2 Yieldmat
2589 Text [ en-US ] = "The maturity";
2592 String 6 // name of parameter 3 Yieldmat
2594 Text [ en-US ] = "Issue";
2597 String 7 // description of parameter 3 Yieldmat
2599 Text [ en-US ] = "The issue date";
2602 String 8 // name of parameter 4 Yieldmat
2604 Text [ en-US ] = "Rate";
2607 String 9 // description of parameter 4 Yieldmat
2609 Text [ en-US ] = "The rate";
2612 String 10 // name of parameter 5 Yieldmat
2614 Text [ en-US ] = "Price";
2617 String 11 // description of parameter 5 Yieldmat
2619 Text [ en-US ] = "The price";
2622 String 12 // name of parameter 6 Yieldmat
2624 Text [ en-US ] = "Basis";
2627 String 13 // description of parameter 6 Yieldmat
2629 Text [ en-US ] = "The basis";
2633 Resource ANALYSIS_Tbilleq
2635 String 1 // description Tbilleq
2637 Text [ en-US ] = "Returns the bond-equivalent yield for a treasury bill";
2640 String 2 // name of parameter 1 Tbilleq
2642 Text [ en-US ] = "Settlement";
2645 String 3 // description of parameter 1 Tbilleq
2647 Text [ en-US ] = "The settlement";
2650 String 4 // name of parameter 2 Tbilleq
2652 Text [ en-US ] = "Maturity";
2655 String 5 // description of parameter 2 Tbilleq
2657 Text [ en-US ] = "The maturity";
2660 String 6 // name of parameter 3 Tbilleq
2662 Text [ en-US ] = "Discount";
2665 String 7 // description of parameter 3 Tbilleq
2667 Text [ en-US ] = "The discount rate";
2671 Resource ANALYSIS_Tbillprice
2673 String 1 // description Tbillprice
2675 Text [ en-US ] = "Returns the price of 100 currency units face value for a treasury bill";
2678 String 2 // name of parameter 1 Tbillprice
2680 Text [ en-US ] = "Settlement";
2683 String 3 // description of parameter 1 Tbillprice
2685 Text [ en-US ] = "The settlement";
2688 String 4 // name of parameter 2 Tbillprice
2690 Text [ en-US ] = "Maturity";
2693 String 5 // description of parameter 2 Tbillprice
2695 Text [ en-US ] = "The maturity";
2698 String 6 // name of parameter 3 Tbillprice
2700 Text [ en-US ] = "Discount";
2703 String 7 // description of parameter 3 Tbillprice
2705 Text [ en-US ] = "The discount rate";
2709 Resource ANALYSIS_Tbillyield
2711 String 1 // description Tbillyield
2713 Text [ en-US ] = "Returns the yield for a treasury bill";
2716 String 2 // name of parameter 1 Tbillyield
2718 Text [ en-US ] = "Settlement";
2721 String 3 // description of parameter 1 Tbillyield
2723 Text [ en-US ] = "The settlement";
2726 String 4 // name of parameter 2 Tbillyield
2728 Text [ en-US ] = "Maturity";
2731 String 5 // description of parameter 2 Tbillyield
2733 Text [ en-US ] = "The maturity";
2736 String 6 // name of parameter 3 Tbillyield
2738 Text [ en-US ] = "Price";
2741 String 7 // description of parameter 3 Tbillyield
2743 Text [ en-US ] = "The price";
2747 Resource ANALYSIS_Oddfprice
2749 String 1 // description Oddfprice
2751 Text [ en-US ] = "Returns the price per $100 face value of a security with an odd first period";
2754 String 2 // name of parameter 1 Oddfprice
2756 Text [ en-US ] = "Settlement";
2759 String 3 // description of parameter 1 Oddfprice
2761 Text [ en-US ] = "The settlement";
2764 String 4 // name of parameter 2 Oddfprice
2766 Text [ en-US ] = "Maturity";
2769 String 5 // description of parameter 2 Oddfprice
2771 Text [ en-US ] = "The maturity";
2774 String 6 // name of parameter 3 Oddfprice
2776 Text [ en-US ] = "Issue";
2779 String 7 // description of parameter 3 Oddfprice
2781 Text [ en-US ] = "The issue date";
2784 String 8 // name of parameter 4 Oddfprice
2786 Text [ en-US ] = "First coupon";
2789 String 9 // description of parameter 4 Oddfprice
2791 Text [ en-US ] = "The first coupon date";
2794 String 10 // name of parameter 5 Oddfprice
2796 Text [ en-US ] = "Rate";
2799 String 11 // description of parameter 5 Oddfprice
2801 Text [ en-US ] = "The rate";
2804 String 12 // name of parameter 6 Oddfprice
2806 Text [ en-US ] = "Yield";
2809 String 13 // description of parameter 6 Oddfprice
2811 Text [ en-US ] = "The yield";
2814 String 14 // name of parameter 7 Oddfprice
2816 Text [ en-US ] = "Redemption";
2819 String 15 // description of parameter 7 Oddfprice
2821 Text [ en-US ] = "The redemption value";
2824 String 16 // name of parameter 8 Oddfprice
2826 Text [ en-US ] = "Frequency";
2829 String 17 // description of parameter 8 Oddfprice
2831 Text [ en-US ] = "The frequency";
2834 String 18 // name of parameter 9 Oddfprice
2836 Text [ en-US ] = "Basis";
2839 String 19 // description of parameter 9 Oddfprice
2841 Text [ en-US ] = "The basis";
2845 Resource ANALYSIS_Oddfyield
2847 String 1 // description Oddfyield
2849 Text [ en-US ] = "Returns the yield of a security with an odd first period";
2852 String 2 // name of parameter 1 Oddfyield
2854 Text [ en-US ] = "Settlement";
2857 String 3 // description of parameter 1 Oddfyield
2859 Text [ en-US ] = "The settlement";
2862 String 4 // name of parameter 2 Oddfyield
2864 Text [ en-US ] = "Maturity";
2867 String 5 // description of parameter 2 Oddfyield
2869 Text [ en-US ] = "The maturity";
2872 String 6 // name of parameter 3 Oddfyield
2874 Text [ en-US ] = "Issue";
2877 String 7 // description of parameter 3 Oddfyield
2879 Text [ en-US ] = "The issue date";
2882 String 8 // name of parameter 4 Oddfyield
2884 Text [ en-US ] = "First coupon";
2887 String 9 // description of parameter 4 Oddfyield
2889 Text [ en-US ] = "The first coupon date";
2892 String 10 // name of parameter 5 Oddfyield
2894 Text [ en-US ] = "Rate";
2897 String 11 // description of parameter 5 Oddfyield
2899 Text [ en-US ] = "The rate";
2902 String 12 // name of parameter 6 Oddfyield
2904 Text [ en-US ] = "Price";
2907 String 13 // description of parameter 6 Oddfyield
2909 Text [ en-US ] = "The price";
2912 String 14 // name of parameter 7 Oddfyield
2914 Text [ en-US ] = "Redemption";
2917 String 15 // description of parameter 7 Oddfyield
2919 Text [ en-US ] = "The redemption value";
2922 String 16 // name of parameter 8 Oddfyield
2924 Text [ en-US ] = "Frequency";
2927 String 17 // description of parameter 8 Oddfyield
2929 Text [ en-US ] = "The frequency";
2932 String 18 // name of parameter 9 Oddfyield
2934 Text [ en-US ] = "Basis";
2937 String 19 // description of parameter 9 Oddfyield
2939 Text [ en-US ] = "The basis";
2943 Resource ANALYSIS_Oddlprice
2945 String 1 // description Oddlprice
2947 Text [ en-US ] = "Returns the price per $100 face value of a security with an odd last period";
2950 String 2 // name of parameter 1 Oddlprice
2952 Text [ en-US ] = "Settlement";
2955 String 3 // description of parameter 1 Oddlprice
2957 Text [ en-US ] = "The settlement";
2960 String 4 // name of parameter 2 Oddlprice
2962 Text [ en-US ] = "Maturity";
2965 String 5 // description of parameter 2 Oddlprice
2967 Text [ en-US ] = "The maturity";
2970 String 6 // name of parameter 3 Oddlprice
2972 Text [ en-US ] = "Last interest";
2975 String 7 // description of parameter 3 Oddlprice
2977 Text [ en-US ] = "The last interest date";
2980 String 8 // name of parameter 4 Oddlprice
2982 Text [ en-US ] = "Rate";
2985 String 9 // description of parameter 4 Oddlprice
2987 Text [ en-US ] = "The rate";
2990 String 10 // name of parameter 5 Oddlprice
2992 Text [ en-US ] = "Yield";
2995 String 11 // description of parameter 5 Oddlprice
2997 Text [ en-US ] = "The yield";
3000 String 12 // name of parameter 6 Oddlprice
3002 Text [ en-US ] = "Redemption";
3005 String 13 // description of parameter 6 Oddlprice
3007 Text [ en-US ] = "The redemption value";
3010 String 14 // name of parameter 7 Oddlprice
3012 Text [ en-US ] = "Frequency";
3015 String 15 // description of parameter 7 Oddlprice
3017 Text [ en-US ] = "The frequency";
3020 String 16 // name of parameter 8 Oddlprice
3022 Text [ en-US ] = "Basis";
3025 String 17 // description of parameter 8 Oddlprice
3027 Text [ en-US ] = "The basis";
3031 Resource ANALYSIS_Oddlyield
3033 String 1 // description Oddlyield
3035 Text [ en-US ] = "Returns the yield of a security with an odd last period";
3038 String 2 // name of parameter 1 Oddlyield
3040 Text [ en-US ] = "Settlement";
3043 String 3 // description of parameter 1 Oddlyield
3045 Text [ en-US ] = "The settlement";
3048 String 4 // name of parameter 2 Oddlyield
3050 Text [ en-US ] = "Maturity";
3053 String 5 // description of parameter 2 Oddlyield
3055 Text [ en-US ] = "The maturity";
3058 String 6 // name of parameter 3 Oddlyield
3060 Text [ en-US ] = "Last interest";
3063 String 7 // description of parameter 3 Oddlyield
3065 Text [ en-US ] = "The last interest date";
3068 String 8 // name of parameter 4 Oddlyield
3070 Text [ en-US ] = "Rate";
3073 String 9 // description of parameter 4 Oddlyield
3075 Text [ en-US ] = "The rate";
3078 String 10 // name of parameter 5 Oddlyield
3080 Text [ en-US ] = "Price";
3083 String 11 // description of parameter 5 Oddlyield
3085 Text [ en-US ] = "The price";
3088 String 12 // name of parameter 6 Oddlyield
3090 Text [ en-US ] = "Redemption";
3093 String 13 // description of parameter 6 Oddlyield
3095 Text [ en-US ] = "The redemption value";
3098 String 14 // name of parameter 7 Oddlyield
3100 Text [ en-US ] = "Frequency";
3103 String 15 // description of parameter 7 Oddlyield
3105 Text [ en-US ] = "The frequency";
3108 String 16 // name of parameter 8 Oddlyield
3110 Text [ en-US ] = "Basis";
3113 String 17 // description of parameter 8 Oddlyield
3115 Text [ en-US ] = "The basis";
3119 Resource ANALYSIS_Xirr
3121 String 1 // description Xirr
3123 Text [ en-US ] = "Returns the internal rate of return for a non-periodic schedule of payments";
3126 String 2 // name of parameter 1 Xirr
3128 Text [ en-US ] = "Values";
3131 String 3 // description of parameter 1 Xirr
3133 Text [ en-US ] = "The values";
3136 String 4 // name of parameter 2 Xirr
3138 Text [ en-US ] = "Dates";
3141 String 5 // description of parameter 2 Xirr
3143 Text [ en-US ] = "The dates";
3146 String 6 // name of parameter 3 Xirr
3148 Text [ en-US ] = "Guess";
3151 String 7 // description of parameter 3 Xirr
3153 Text [ en-US ] = "The guess";
3157 Resource ANALYSIS_Xnpv
3159 String 1 // description Xnpv
3161 Text [ en-US ] = "Returns the net present value for a non-periodic schedule of payments";
3164 String 2 // name of parameter 1 Xnpv
3166 Text [ en-US ] = "Rate";
3169 String 3 // description of parameter 1 Xnpv
3171 Text [ en-US ] = "The rate";
3174 String 4 // name of parameter 2 Xnpv
3176 Text [ en-US ] = "Values";
3179 String 5 // description of parameter 2 Xnpv
3181 Text [ en-US ] = "The values";
3184 String 6 // name of parameter 3 Xnpv
3186 Text [ en-US ] = "Dates";
3189 String 7 // description of parameter 3 Xnpv
3191 Text [ en-US ] = "The dates";
3195 Resource ANALYSIS_Intrate
3197 String 1 // description Intrate
3199 Text [ en-US ] = "Returns the interest rate for a fully invested security";
3202 String 2 // name of parameter 1 Intrate
3204 Text [ en-US ] = "Settlement";
3207 String 3 // description of parameter 1 Intrate
3209 Text [ en-US ] = "The settlement";
3212 String 4 // name of parameter 2 Intrate
3214 Text [ en-US ] = "Maturity";
3217 String 5 // description of parameter 2 Intrate
3219 Text [ en-US ] = "The maturity";
3222 String 6 // name of parameter 3 Intrate
3224 Text [ en-US ] = "Investment";
3227 String 7 // description of parameter 3 Intrate
3229 Text [ en-US ] = "The investment";
3232 String 8 // name of parameter 4 Intrate
3234 Text [ en-US ] = "Redemption";
3237 String 9 // description of parameter 4 Intrate
3239 Text [ en-US ] = "The redemption value";
3242 String 10 // name of parameter 5 Intrate
3244 Text [ en-US ] = "Basis";
3247 String 11 // description of parameter 5 Intrate
3249 Text [ en-US ] = "The basis";
3253 Resource ANALYSIS_Coupncd
3255 String 1 // description Coupncd
3257 Text [ en-US ] = "Returns the first coupon date after the settlement date";
3260 String 2 // name of parameter 1 Coupncd
3262 Text [ en-US ] = "Settlement";
3265 String 3 // description of parameter 1 Coupncd
3267 Text [ en-US ] = "The settlement";
3270 String 4 // name of parameter 2 Coupncd
3272 Text [ en-US ] = "Maturity";
3275 String 5 // description of parameter 2 Coupncd
3277 Text [ en-US ] = "The maturity";
3280 String 6 // name of parameter 3 Coupncd
3282 Text [ en-US ] = "Frequency";
3285 String 7 // description of parameter 3 Coupncd
3287 Text [ en-US ] = "The frequency";
3290 String 8 // name of parameter 4 Coupncd
3292 Text [ en-US ] = "Basis";
3295 String 9 // description of parameter 4 Coupncd
3297 Text [ en-US ] = "The basis";
3301 Resource ANALYSIS_Coupdays
3303 String 1 // description Coupdays
3305 Text [ en-US ] = "Returns the number of days in the coupon period containing the settlement date";
3308 String 2 // name of parameter 1 Coupdays
3310 Text [ en-US ] = "Settlement";
3313 String 3 // description of parameter 1 Coupdays
3315 Text [ en-US ] = "The settlement";
3318 String 4 // name of parameter 2 Coupdays
3320 Text [ en-US ] = "Maturity";
3323 String 5 // description of parameter 2 Coupdays
3325 Text [ en-US ] = "The maturity";
3328 String 6 // name of parameter 3 Coupdays
3330 Text [ en-US ] = "Frequency";
3333 String 7 // description of parameter 3 Coupdays
3335 Text [ en-US ] = "The frequency";
3338 String 8 // name of parameter 4 Coupdays
3340 Text [ en-US ] = "Basis";
3343 String 9 // description of parameter 4 Coupdays
3345 Text [ en-US ] = "The basis";
3349 Resource ANALYSIS_Coupdaysnc
3351 String 1 // description Coupdaysnc
3353 Text [ en-US ] = "Returns the number of days from the settlement date to the next coupon date";
3356 String 2 // name of parameter 1 Coupdaysnc
3358 Text [ en-US ] = "Settlement";
3361 String 3 // description of parameter 1 Coupdaysnc
3363 Text [ en-US ] = "The settlement";
3366 String 4 // name of parameter 2 Coupdaysnc
3368 Text [ en-US ] = "Maturity";
3371 String 5 // description of parameter 2 Coupdaysnc
3373 Text [ en-US ] = "The maturity";
3376 String 6 // name of parameter 3 Coupdaysnc
3378 Text [ en-US ] = "Frequency";
3381 String 7 // description of parameter 3 Coupdaysnc
3383 Text [ en-US ] = "The frequency";
3386 String 8 // name of parameter 4 Coupdaysnc
3388 Text [ en-US ] = "Basis";
3391 String 9 // description of parameter 4 Coupdaysnc
3393 Text [ en-US ] = "The basis";
3397 Resource ANALYSIS_Coupdaybs
3399 String 1 // description Coupdaybs
3401 Text [ en-US ] = "Returns the number of days from the beginning of the coupon period to the settlement date";
3404 String 2 // name of parameter 1 Coupdaybs
3406 Text [ en-US ] = "Settlement";
3409 String 3 // description of parameter 1 Coupdaybs
3411 Text [ en-US ] = "The settlement";
3414 String 4 // name of parameter 2 Coupdaybs
3416 Text [ en-US ] = "Maturity";
3419 String 5 // description of parameter 2 Coupdaybs
3421 Text [ en-US ] = "The maturity";
3424 String 6 // name of parameter 3 Coupdaybs
3426 Text [ en-US ] = "Frequency";
3429 String 7 // description of parameter 3 Coupdaybs
3431 Text [ en-US ] = "The frequency";
3434 String 8 // name of parameter 4 Coupdaybs
3436 Text [ en-US ] = "Basis";
3439 String 9 // description of parameter 4 Coupdaybs
3441 Text [ en-US ] = "The basis";
3445 Resource ANALYSIS_Couppcd
3447 String 1 // description Couppcd
3449 Text [ en-US ] = "Returns the last coupon date preceding the settlement date";
3452 String 2 // name of parameter 1 Couppcd
3454 Text [ en-US ] = "Settlement";
3457 String 3 // description of parameter 1 Couppcd
3459 Text [ en-US ] = "The settlement";
3462 String 4 // name of parameter 2 Couppcd
3464 Text [ en-US ] = "Maturity";
3467 String 5 // description of parameter 2 Couppcd
3469 Text [ en-US ] = "The maturity";
3472 String 6 // name of parameter 3 Couppcd
3474 Text [ en-US ] = "Frequency";
3477 String 7 // description of parameter 3 Couppcd
3479 Text [ en-US ] = "The frequency";
3482 String 8 // name of parameter 4 Couppcd
3484 Text [ en-US ] = "Basis";
3487 String 9 // description of parameter 4 Couppcd
3489 Text [ en-US ] = "The basis";
3493 Resource ANALYSIS_Coupnum
3495 String 1 // description Coupnum
3497 Text [ en-US ] = "Returns the number of coupons payable between the settlement and maturity dates";
3500 String 2 // name of parameter 1 Coupnum
3502 Text [ en-US ] = "Settlement";
3505 String 3 // description of parameter 1 Coupnum
3507 Text [ en-US ] = "The settlement";
3510 String 4 // name of parameter 2 Coupnum
3512 Text [ en-US ] = "Maturity";
3515 String 5 // description of parameter 2 Coupnum
3517 Text [ en-US ] = "The maturity";
3520 String 6 // name of parameter 3 Coupnum
3522 Text [ en-US ] = "Frequency";
3525 String 7 // description of parameter 3 Coupnum
3527 Text [ en-US ] = "The frequency";
3530 String 8 // name of parameter 4 Coupnum
3532 Text [ en-US ] = "Basis";
3535 String 9 // description of parameter 4 Coupnum
3537 Text [ en-US ] = "The basis";
3541 Resource ANALYSIS_Fvschedule
3543 String 1 // description Fvschedule
3545 Text [ en-US ] = "Returns the future value of the initial principal after a series of compound interest rates are applied";
3548 String 2 // name of parameter 1 Fvschedule
3550 Text [ en-US ] = "Principal";
3553 String 3 // description of parameter 1 Fvschedule
3555 Text [ en-US ] = "The principal";
3558 String 4 // name of parameter 2 Fvschedule
3560 Text [ en-US ] = "Schedule";
3563 String 5 // description of parameter 2 Fvschedule
3565 Text [ en-US ] = "The schedule";