GetTabStaticFormulas: Operation

The GetTabStaticFormulas operation gets a list of system functions that can be used in formulas.

Comments

The operation results in the list of functions divided into categories. Function description and the list of input parameters will be obtained for each function.

Example

Below is the example of getting the list of system functions that can be used in formulas.

SOAP JSON C#

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<n>Mathematical</n>

<fns>

<dsc>Returns unit (absolute value) of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Real number, which absolute value should be found.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the number arccosine. The angle is determined in radians in the range from 0 to Pi.</dsc>

<prms>

<n>Value</n>

<dsc>Cosine of the required angle, which value should be in the range from -1 to 1.</dsc>

</prms>

</fns>

<fns>

<n>ACosH</n>

<dsc>Returns hyperbolic arccosine of a number. The number should be greater or equal to 1.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that is greater or equal to 1.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns arccotangent of a number. The angle is determined in radians in the range from 0 to Pi.</dsc>

<prms>

<n>Value</n>

<dsc>Cotangent of required angle.</dsc>

</prms>

</fns>

<fns>

<n>ACotH</n>

<dsc>Returns hyperbolic arccotangent of a number. The number should satisfy the condition: less than -1 or greater than 1.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that satisfies the condition: less than -1 or greater than 1.</dsc>

</prms>

</fns>

<fns>

<n>Aggregate</n>

<dsc>Returns result of aggregation with the specified method with the ability not to take into account hidden values (rows/columns) in calculation.</dsc>

<prms>

<n>Function number</n>

<dsc>Indicates which function should be used in calculation.</dsc>

</prms>

<prms>

<dsc>Named range or link, for which the function should be calculated.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns arcsine of a number. The angle is determined in radians in the range from -Pi/2 to Pi/2.</dsc>

<prms>

<n>Value</n>

<dsc>Sine of the required angle, which value should be in the range from -1 to 1.</dsc>

</prms>

</fns>

<fns>

<n>ASinH</n>

<dsc>Returns hyperbolic arcsine of a number. The number should be greater or equal to 1.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that is greater or equal to 1.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns arctangent of a number. The angle is determined in radians in the range from -Pi/2 to Pi/2.</dsc>

<prms>

<n>Value</n>

<dsc>Tangent of the required angle.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns arctangent for the specified x and y coordinates in radians in the range -Pi to Pi, excluding -Pi.</dsc>

<prms>

<dsc>X coordinate of a point.</dsc>

</prms>

<prms>

<dsc>Y coordinate of a point.</dsc>

</prms>

</fns>

<fns>

<n>ATanH</n>

<dsc>Returns hyperbolic arctangent of a number. The number should be in the range from -1 to 1 (excluding -1 and 1).</dsc>

<prms>

<n>Value</n>

<dsc>Any real number strictly in the range from -1 to 1 (excluding -1 and 1).</dsc>

</prms>

</fns>

<fns>

<n>Average</n>

<dsc>Returns the mean value for a cell array.</dsc>

<prms>

<n>Values</n>

<dsc>Cell range, for which the mean value should be determined.</dsc>

</prms>

</fns>

<fns>

<n>AverageIf</n>

<dsc>Returns the mean value for the cells that satisfy the specified condition. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>Range</n>

<dsc>Range of checked cells.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines the cells, for which the average value will be calculated.</dsc>

</prms>

<prms>

<n>Average_Range</n>

<dsc>Actual cells, for which the average value will be calculated. If Average_range is not specified, the cell specified by the Range parameter will be used.</dsc>

</prms>

</fns>

<fns>

<n>AverageIfS</n>

<dsc>Returns the average value of cells that satisfy the specified set of conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>Average_Range</n>

<dsc>Actual cells, for which the average value will be calculated.</dsc>

</prms>

<prms>

<n>Range1</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria1</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines the cells, for which the average value will be calculated.</dsc>

</prms>

<prms>

<n>Range</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines the cells, for which the average value will be calculated.</dsc>

</prms>

</fns>

<fns>

<n>Ceiling</n>

<dsc>Rounds a number to the nearest integer or to the nearest number that is multiple of the specified value.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

<prms>

<n>Precision</n>

<dsc>Multiple, to which the number should be rounded.</dsc>

</prms>

</fns>

<fns>

<n>Combin</n>

<dsc>Returns the number of combinations for the specified number of objects.</dsc>

<prms>

<n>SetSize</n>

<dsc>Number of elements (greater than 0).</dsc>

</prms>

<prms>

<n>SampleSize</n>

<dsc>Number of objects in each combination (greater than 0 and less than or equal to SetSize).</dsc>

</prms>

</fns>

<fns>

<dsc>Returns cosine of a number.</dsc>

<prms>

<n>Angle</n>

<dsc>Angle in radians, for which cosine is determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns hyperbolic cosine of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that is greater or equal to 1.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns cotangent of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Angle in radians, for which cotangent is determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns hyperbolic cotangent of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number.</dsc>

</prms>

</fns>

<fns>

<n>Count</n>

<dsc>Returns the number of elements in a cell array.</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells, for which the number of value should be determined.</dsc>

</prms>

</fns>

<fns>

<n>CountIf</n>

<dsc>Returns the number of cells that satisfy the specified condition. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>Range</n>

<dsc>Range of checked cells.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines which cells should be taken into account.</dsc>

</prms>

</fns>

<fns>

<n>CountIfS</n>

<dsc>Applies conditions to cells in several ranges and calculates the number of correspondences to all conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>Range1</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria1</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines which cells should be taken into account.</dsc>

</prms>

<prms>

<n>Range</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text, or function that determines which cells should be taken into account.</dsc>

</prms>

</fns>

<fns>

<n>Degrees</n>

<dsc>Converts radians to degrees.</dsc>

<prms>

<n>Value</n>

<dsc>Angle in radians converted to degrees.</dsc>

</prms>

</fns>

<fns>

<dsc>Rounds a number to the nearest even integer. Positive numbers are rounded up, negative numbers are rounded down.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns number exponent.</dsc>

<prms>

<n>Value</n>

<dsc>Power, to which the e value should be raised.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns number factorial.</dsc>

<prms>

<n>Value</n>

<dsc>Non-negative number, which factorial is calculated.</dsc>

</prms>

</fns>

<fns>

<n>Floor</n>

<dsc>Rounds a number to the nearest integer that is the least by module.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

<prms>

<n>Precision</n>

<dsc>Multiple, to which the number should be rounded.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the greatest common divisor.</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells, the greatest common divisor of which should be found.</dsc>

</prms>

</fns>

<fns>

<dsc>Rounds a number to the nearest least integer.</dsc>

<prms>

<n>Value</n>

<dsc>Real number rounded to the nearest least integer.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the least common multiple.</dsc>

<prms>

<n>Values</n>

<dsc>Rage of cells, the least common multiple of which is determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns natural logarithm of a number.</dsc>

<prms>

<n>Value</n>

<dsc>The number, for which natural logarithm is calculated.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the number logarithm by the specified base.</dsc>

<prms>

<n>Value</n>

<dsc>The number, for which logarithm is calculated.</dsc>

</prms>

<prms>

<dsc>Logarithm base.</dsc>

</prms>

</fns>

<fns>

<dsc> Returns base-10 logarithm of a number.</dsc>

<prms>

<n>Value</n>

<dsc>The number, for which base-10 logarithm is calculated.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the maximum number in a cell range.</dsc>

<prms>

<n>Values</n>

<dsc>Cell range, for which the maximum number should be determined.</dsc>

</prms>

</fns>

<fns>

<n>MDeterm</n>

<dsc>Returns determinant of a matrix stored in a cell array.</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells with equal number of rows and columns.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the minimum number in a cell array.</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells, for which the minimum number should be determined.</dsc>

</prms>

</fns>

<fns>

<n>MInverse</n>

<dsc>Returns inverse of matrix (matrix is stored in a cell array).</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells with equal number of rows and columns.</dsc>

</prms>

</fns>

<fns>

<n>MMult</n>

<dsc>Returns matrix product. The result is the array with the same number of rows as A1 and with the same number of columns as A2.</dsc>

<prms>

<dsc>Range of cells containing only numbers.</dsc>

</prms>

<prms>

<dsc>Range of cells containing only numbers.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the remainder of division of a number by the divisor. The result has the same sign as the dividend.</dsc>

<prms>

<n>Value</n>

<dsc>The number, which division remainder is determined.</dsc>

</prms>

<prms>

<n>Divisor</n>

<dsc>Divisor.</dsc>

</prms>

</fns>

<fns>

<n>MRound</n>

<dsc>Returns the number rounded with the required precision.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

<prms>

<n>Precision</n>

<dsc>Precision, with which a number should be rounded.</dsc>

</prms>

</fns>

<fns>

<n>Multinomial</n>

<dsc>Returns the relation of factorial of sum of values to product of factorials.</dsc>

<prms>

<n>Values</n>

<dsc>Range of cells, the multinomial coefficient for values of which is determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Rounds a number to the nearest odd integer. Positive numbers are rounded up, negative numbers are rounded down.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

</fns>

<fns>

<n>Power</n>

<dsc>Returns the result of raising a real number to the real power.</dsc>

<prms>

<n>Value</n>

<dsc>Power basis.</dsc>

</prms>

<prms>

<n>Power</n>

<dsc>Exponent of the power, to which the basis is raised.</dsc>

</prms>

</fns>

<fns>

<n>Product</n>

<dsc>Returns product of cell array values.</dsc>

<prms>

<n>Values</n>

<dsc>Range of values that contains multiplied numbers.</dsc>

</prms>

</fns>

<fns>

<n>Quotient</n>

<dsc>Returns the integer part of result of divisio with remainder. This function is used when the division remainder should be removed.</dsc>

<prms>

<n>Nominator</n>

<dsc>Dividend.</dsc>

</prms>

<prms>

<n>Denominator</n>

<dsc>Divisor that is not equal to zero.</dsc>

</prms>

</fns>

<fns>

<n>Radians</n>

<dsc>Converts degrees to radians.</dsc>

<prms>

<n>Value</n>

<dsc>Angle value in degrees that should be converted.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns uniformly distributed random numer that is equal to 0 and less than 1.</dsc>

</fns>

<fns>

<n>RandBetween</n>

<dsc>Returns random number between two s[p-specified numbers.</dsc>

<prms>

<n>TopValue</n>

<dsc>The least number returned by the RandBetween function.</dsc>

</prms>

<prms>

<n>BottomValue</n>

<dsc>The greatest number returned by the RandBetween function.</dsc>

</prms>

</fns>

<fns>

<n>Roman</n>

<dsc>Converts an Arabic number to a Roman number as text.</dsc>

<prms>

<n>Value</n>

<dsc>Converted number as an Arabic number.</dsc>

</prms>

<prms>

<dsc>Internal service parameter. Value of this parameter does not affect the final result.</dsc>

</prms>

</fns>

<fns>

<n>Round</n>

<dsc>Rounds a number to the specified number of decimal places.</dsc>

<prms>

<n>Value</n>

<dsc>Rounded value.</dsc>

</prms>

<prms>

<n>Precision</n>

<dsc>Number of decimal places, to which one should round a number. Precision > 0 - rounded to the specified number of decimal places to the right. Precision = 0 - rounded to the nearest integer. Precision < 0 - rounded to the left of the decimal point.</dsc>

</prms>

</fns>

<fns>

<n>RoundDown</n>

<dsc>Rounds the number to the nearest value that is the least by module.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that should be rounded down.</dsc>

</prms>

<prms>

<n>Precision</n>

</prms>

</fns>

<fns>

<n>RoundUp</n>

<dsc>Rounds a number to the nearest value that is the greatest by module.</dsc>

<prms>

<n>Value</n>

<dsc>Any real number that should be rounded up.</dsc>

</prms>

<prms>

<n>Precision</n>

</prms>

</fns>

<fns>

<n>SeriesSum</n>

<dsc>Returns the sum of a power series.</dsc>

<prms>

<dsc>Value of power series variable.</dsc>

</prms>

<prms>

<n>Power</n>

<dsc>Exponent of X power for the first memer of a power series.</dsc>

</prms>

<prms>

<dsc>Step, by which the exponent of the Power power is increased for each following member of a power series.</dsc>

</prms>

<prms>

<n>Coefficients</n>

<dsc>Range of cells, which values determine a set of coefficients at corresponding degrees of X.</dsc>

</prms>

</fns>

<fns>

<dsc>Determines a number sign. Returns 1 if a number is positive, zero (0) if a number is equal to 0, and -1 if a number is negative.</dsc>

<prms>

<n>Value</n>

<dsc>Real number.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns sine of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Angle in radians, for which sine is calculated.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns hyperbolic sine of a number.</dsc>

<prms>

<n>Value</n>

<dsc>Real number.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns positive value of square root.</dsc>

<prms>

<n>Value</n>

<dsc>Number, for which square root is calculated.</dsc>

</prms>

</fns>

<fns>

<n>SqrtPi</n>

<dsc>Returns square root of expression value (number * Pi).</dsc>

<prms>

<n>Value</n>

<dsc>Number that is multiplied by Pi.</dsc>

</prms>

</fns>

<fns>

<dsc>Sums up real numbers in a cell array.</dsc>

<prms>

<n>Values</n>

<dsc>Cell range, for which a total or a sum should be determined.</dsc>

</prms>

</fns>

<fns>

<n>Sumif</n>

<dsc>Sums up cells determined by the specified condition. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>Range</n>

<dsc>Range of checked cells.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text or function that determines summed up cells.</dsc>

</prms>

<prms>

<n>SumRange</n>

<dsc>Actual cells for summation. If SumRange is not specified, the cells specified by the Range</dsc> parameter will be used

</prms>

</fns>

<fns>

<n>SumIfS</n>

<dsc>Sums up cells that satisfy the specified set of conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").</dsc>

<prms>

<n>SumRange</n>

<dsc>Actual cells for summation.</dsc>

</prms>

<prms>

<n>Range1</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria1</n>

<dsc>Condition as a number, expression, link to cell, text or function that determines summed up cells.</dsc>

</prms>

<prms>

<n>Range</n>

<dsc>Range of cells checked for correspondence to the specified condition.</dsc>

</prms>

<prms>

<n>Criteria</n>

<dsc>Condition as a number, expression, link to cell, text or function that determines summed up cells.</dsc>

</prms>

</fns>

<fns>

<n>SumSq</n>

<dsc>Returns the sum of squared arguments.</dsc>

<prms>

<n>Values</n>

<dsc>Cell range, for which a sum of squares should be determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the sum of differences of squares of corresponding values in two arrays.</dsc>

<prms>

<dsc>First cell array.</dsc>

</prms>

<prms>

<dsc>Second cell array.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the sum of sums of squares of corresponding elements of two arrays.</dsc>

<prms>

<dsc>First cell array.</dsc>

</prms>

<prms>

<dsc>Second cell array.</dsc>

</prms>

</fns>

<fns>

<n>SumXMY2</n>

<dsc>Returns the sum of squares of differences of corresponding values of two arrays.</dsc>

<prms>

<dsc>First cell array.</dsc>

</prms>

<prms>

<dsc>Second cell array.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns angle tangent.</dsc>

<prms>

<n>Value</n>

<dsc>Angle in radians, for which tangent is determined.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns hyperbolic tangent.</dsc>

<prms>

<n>Value</n>

<dsc>Real number.</dsc>

</prms>

</fns>

<fns>

<n>Trunc</n>

<dsc>Truncates a number to the specified number of decimal places.</dsc>

<prms>

<n>Value</n>

<dsc>Truncated number.</dsc>

</prms>

<prms>

<n>Precision</n>

<dsc>Number of decimal places that determines truncation precision. Negative values cause truncation of integer part, zero causes truncation to an integer (0 by default)</dsc

</prms>

</fns>

<fns>

<n>RndPermutation</n>

<dsc>Returns the array that is a random permutation of another array, which elements are integers in the range from 1 to the value of the passed parameter.</dsc>

<prms>

<n>Value</n>

<dsc>Size of the required array, the greatest value in the array.</dsc>

</prms>

</fns>

<fns>

<n>RndSample</n>

<dsc>Returns the random sample of M elements from the array, which elements are integers in the range from 1 to N.</dsc>

<prms>

<dsc>Size of the sampled array.</dsc>

</prms>

<prms>

<dsc>Sample size.</dsc>

</prms>

</fns>

</cts>

<n>Links and arrays</n>

<fns>

<n>VLookUp</n>

<dsc>Searches for a value in the leftmost table column and returns value of the cell located in the same column in the specified row.</dsc>

<prms>

<n>LookupValue </n>

<dsc>Value used in search for the required value in the array – it can be a number, text, logical value, or a link to one of these types.</dsc>

</prms>

<prms>

<n>TableArray </n>

<dsc>Cell range, in which search is executed.</dsc>

</prms>

<prms>

<n>ColumnIndexNum </n>

<dsc>Number of column in the range, from which the compared value should be returned, column numbering starts from 1</dsc>

</prms>

<prms>

<n>RangeLookup </n>

<dsc>Indicates how search should be executed: true (default value) – approximate, false – exact.</dsc>

</prms>

</fns>

<fns>

<n>HLookUp</n>

<dsc>Searches for a value in the first table row and returns value of the cell located in the same column in the specified row.</dsc>

<prms>

<n>LookupValue </n>

<dsc>Value that should be found in the first table row – it can be a number, text, logical value or a link to one of these types.</dsc>

</prms>

<prms>

<n>TableArray </n>

<dsc>Cell range, in which search is executed.</dsc>

</prms>

<prms>

<n>RowIndexNum </n>

<dsc>Number of the row in the range, from which the compared value should be returned, row numbering starts from 1</dsc>

</prms>

<prms>

<n>RangeLookup </n>

<dsc>Indicates how search should be executed: true (default value) – approximate, false – exact.</dsc>

</prms>

</fns>

<fns>

<n>Match</n>

<dsc>Searches for the specified element in the cell range and returns relative position of this element in the range.</dsc>

<prms>

<n>LookupValue </n>

<dsc>Value used in search for the required value in the array – it can be a number, text, logical value, or a link to one of these types.</dsc>

</prms>

<prms>

<n>LookupArray </n>

<dsc>Cell range, in which search is executed.</dsc>

</prms>

<prms>

<n>MatchType </n>

<dsc>Indicates how the searched value is compared to values in the cell range: 1 or omitted (default value) – function finds the greatest value that is less or equal to the searched value, the cell range should be sorted ascending; 0 – function finds the first value that is equal to the searched value, the cell range may be unsorted; -1 – function finds the least value that is greater or equal to the required value, the cell range should be sorted descending.</dsc>

</prms>

</fns>

<fns>

<n>Offset</n>

<dsc>Get link to the range shifted relative to the specified link by the specified number of rows and columns.</dsc>

<prms>

<n>Range</n>

<dsc>Link to the cell or the range, from which shift is determined.</dsc>

</prms>

<prms>

<n>RowCount</n>

<dsc>The number of rows up or down, by which the output link range is shifted relative to the source link range.</dsc>

</prms>

<prms>

<n>ColumnCount</n>

<dsc>The number of columns to the left or to the right, by which the output link range is shifted relative to the source link range.</dsc>

</prms>

<prms>

<n>Height</n>

<dsc>Height of returned range in cells. Optional parameter.</dsc>

</prms>

<prms>

<n>Width</n>

<dsc>Width of returned range in cells. Optional parameter.</dsc>

</prms>

</fns>

<fns>

<n>Range</n>

<dsc>Get range by link.</dsc>

<prms>

<n>Address</n>

<dsc>Range address.</dsc>

</prms>

</fns>

<fns>

<dsc>Get range by link to cell.</dsc>

<prms>

<n>Address</n>

<dsc>Cell address.</dsc>

</prms>

</fns>

</cts>

<fns>

<dsc>Returns date by specified year, month, and day.</dsc>

<prms>

</prms>

<prms>

<n>Month</n>

<dsc>Month.</dsc>

</prms>

<prms>

</prms>

</fns>

<fns>

<n>DateValue</n>

<dsc>Converts string to date.</dsc>

<prms>

<dsc>String with date.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns day number in a month.</dsc>

<prms>

</prms>

</fns>

<fns>

<n>Edate</n>

<dsc>Adds/subtracts the specified number of months from date.</dsc>

<prms>

</prms>

<prms>

<n>Months</n>

<dsc>Number of months.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns hours as a number from 0 to 23.</dsc>

<prms>

</prms>

</fns>

<fns>

<n>Minute</n>

<dsc>Returns minutes as a number from 0 to 59.</dsc>

<prms>

</prms>

</fns>

<fns>

<n>Month</n>

<dsc>Returns month as a number from 1 (January) to 12 (December).</dsc>

<prms>

</prms>

</fns>

<fns>

<dsc>Returns the current date and time.</dsc>

</fns>

<fns>

<n>Second</n>

<dsc>Returns seconds as a number from 0 to 59.</dsc>

<prms>

</prms>

</fns>

<fns>

<dsc>Converts hours, minutes, and seconds specified as numbers to date.</dsc>

<prms>

<dsc>Hours.</dsc>

</prms>

<prms>

<n>Minute</n>

<dsc>Minutes.</dsc>

</prms>

<prms>

<n>Second</n>

<dsc>Seconds.</dsc>

</prms>

</fns>

<fns>

<n>TimeValue</n>

<dsc>Converts string value to the TimeSpan type.</dsc>

<prms>

<dsc>A string should be in the following format: <Number of days>.<Numer of hours>:<Number of minutes>:<Number of seconds>.<Number of milliseconds>.</dsc>

</prms>

</fns>

<fns>

<n>Today</n>

<dsc>Returns the current date.</dsc>

</fns>

<fns>

<n>Weekday</n>

<dsc>Returns week day number from 1 to 7 by the specified date.</dsc>

<prms>

</prms>

</fns>

<fns>

<dsc>Returns year by the specified date.</dsc>

<prms>

</prms>

</fns>

</cts>

<fns>

<n>Concatenate</n>

<dsc>Merges several strings into one.</dsc>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

<prms>

<dsc>Text1, Text2… - strings that should be merged.</dsc>

</prms>

</fns>

<fns>

<n>Exact</n>

<dsc>Check exact match of two strings (check is case-sensitive).</dsc>

<prms>

<dsc>First string.</dsc>

</prms>

<prms>

<dsc>Second string.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns position of one string in the other one. Search is case-sensitive.</dsc>

<prms>

<dsc>Text to search.</dsc>

</prms>

<prms>

<n>Within_text</n>

<dsc>String used for search.</dsc>

</prms>

<prms>

<n>Start_num</n>

<dsc>Search start position.</dsc>

</prms>

</fns>

<fns>

<n>Fixed</n>

<dsc>Rounds a number to the specified number of decimal spaces and returns the result as a string with thousands separators and without them.</dsc>

<prms>

<n>Number</n>

<dsc>The number that should be rounded and converted into text.</dsc>

</prms>

<prms>

<n>Decimals</n>

<dsc>The number of decimal places (2 by default).</dsc>

</prms>

<prms>

<n>No_commas</n>

<dsc>Do not display thousands separators in the returned value (TRUE by default).</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the specified number of characters from the beginning of the string.</dsc>

<prms>

<dsc>Source string, from which characters are obtained.</dsc>

</prms>

<prms>

<n>Num_chars</n>

<dsc>The number of characters that should be obtained (1 by default)</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the number of characters in a text string.</dsc>

<prms>

<dsc>String, which length should be calculated.</dsc>

</prms>

</fns>

<fns>

<n>Lower</n>

<dsc>Converts all string characters into lower case.</dsc>

<prms>

<dsc>String converted into lower case.</dsc>

</prms>

</fns>

<fns>

<dsc>Gets substring from the string by the specified start position and length.</dsc>

<prms>

<dsc>The string, from which substring should be obtained.</dsc>

</prms>

<prms>

<n>Start_num</n>

<dsc>Start position of substring.</dsc>

</prms>

<prms>

<n>Num_chars</n>

<dsc>Number of characters.</dsc>

</prms>

</fns>

<fns>

<n>Replace</n>

<dsc>Substitutes part of one string with another string.</dsc>

<prms>

<dsc>The string, which should be substituted.</dsc>

</prms>

<prms>

<n>Start_num</n>

<dsc>Position of character in the source string, from which to start substitution.</dsc>

</prms>

<prms>

<n>Num_chars</n>

<dsc>The number of characters in the source string that should be substituted.</dsc>

</prms>

<prms>

<dsc>Substituting string.</dsc>

</prms>

</fns>

<fns>

<dsc>Repeats the string the specified number of times.</dsc>

<prms>

<dsc>Text that should be repeated.</dsc>

</prms>

<prms>

<n>Number_times</n>

<dsc>Number of times the specified text should be repeated.</dsc>

</prms>

</fns>

<fns>

<n>Right</n>

<dsc>Returns the specified number of characters from the end of the string.</dsc>

<prms>

<dsc>Source string.</dsc>

</prms>

<prms>

<n>Num_chars</n>

<dsc>Number of characters (1 by default).</dsc>

</prms>

</fns>

<fns>

<dsc>Determines whether the value can be converted to string type. If yes,it returns text, if no, it returns an empty string.</dsc>

<prms>

<n>Value</n>

<dsc>Checked value.</dsc>

</prms>

</fns>

<fns>

<dsc>Deletes spaces at the beginning and at the end of the string.</dsc>

<prms>

<dsc>The string, in which one should delete extra spaces.</dsc>

</prms>

</fns>

<fns>

<n>Upper</n>

<dsc>Converts the string into upper case.</dsc>

<prms>

<dsc>The string that should be converted into upper case.</dsc>

</prms>

</fns>

<fns>

<n>Value</n>

<dsc>Converts the text view into a number.</dsc>

<prms>

<dsc>Text view of the number that should be converted.</dsc>

</prms>

</fns>

</cts>

<n>Work with report</n>

<fns>

<n>GetSelection</n>

<dsc>Get slice selection as a string.</dsc>

<prms>

<n>Data source</n>

<dsc>Number or identifier of data source.</dsc>

</prms>

<prms>

<n>Slice</n>

<dsc>Slice number or name.</dsc>

</prms>

<prms>

<n>Dimension</n>

<dsc>Dimension number, name, or identifier in slice.</dsc>

</prms>

<prms>

<n>Format</n>

<dsc>Format applied to get dimension element text.</dsc>

</prms>

<prms>

<n>Separator</n>

<dsc>Separator used to separate element names from each other.</dsc>

</prms>

<prms>

<n>Combine ranges</n>

<dsc>Indicates whether consecutive elements are combined into a range.</dsc>

</prms>

</fns>

<fns>

<n>GetSelectionEl</n>

<dsc>Get selected slice element.</dsc>

<prms>

<n>Data source</n>

<dsc>Number or identifier of data source.</dsc>

</prms>

<prms>

<n>Slice</n>

<dsc>Slice number or name.</dsc>

</prms>

<prms>

<n>Dimension</n>

<dsc>Dimension number, name, or identifier in slice.</dsc>

</prms>

<prms>

<n>Element number</n>

<dsc>Element number in selection, which name should be obtained (the first by default).</dsc>

</prms>

</fns>

</cts>

<n>Financial</n>

<fns>

<n>Accrint</n>

<dsc>Returns accrued interest by securities with periodic interest payments.</dsc>

<prms>

<n>Issue</n>

<dsc>Securities issuance date. The value should satisfy the constraint: Issue < Settlement.</dsc>

</prms>

<prms>

<n>FirstInterest</n>

<dsc>Date of the first payment for securities.</dsc>

</prms>

<prms>

<n>Settlement</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<dsc>Annual interest rate for securities coupons. The value should satisfy the constraint: Rate > 0.</dsc>

</prms>

<prms>

<n>NominalCost</n>

<dsc>Face value of securities. The value should satisfy the constraint: NominalCost > 0.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>AccrintM</n>

<dsc>Returns accrued intrest for securities, which interest is paid on maturity date.</dsc>

<prms>

<n>Issue</n>

<dsc>Securities issuance date. The value should satisfy the constraint: Issue < Settlement.</dsc>

</prms>

<prms>

<n>Settlement</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<dsc>Annual interest rate for securities coupons. The value should satisfy the constraint: Rate > 0.</dsc>

</prms>

<prms>

<n>NominalCost</n>

<dsc>Face value of securities. The value should satisfy the constraint: NominalCost > 0.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>AmorDegrC</n>

<dsc>Returns depreciation value for each period. This function is used for the French accounting system. If an asset is purchased in the middle of an accounting period, the proportional amount of depreciation is taken into account. This function is similar to the AmorLinC function, except for the fact that the depreciation coefficient used in calculations depends on the asset depreciation period.</dsc>

<prms>

<dsc>Asset cost.</dsc>

</prms>

<prms>

<n>PurchaseDate</n>

<dsc>Asset acquisition date.</dsc>

</prms>

<prms>

<n>FirstPeriodEnd</n>

<dsc>First period end date.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Residual cost of asset at the end of depreciation period.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period. The value should satisfy the constraint: Period > 0.</dsc>

</prms>

<prms>

<dsc>Depreciation rate. The value should satisfy the constraint: Rate > 0.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>AmorLinC</n>

<dsc>Returns depreciation value for each period. This function is used for the French accounting system. If an asset is acquired in the middle of the accounting period, uniformly distributed depreciation is taken into account.</dsc>

<prms>

<dsc>Asset cost.</dsc>

</prms>

<prms>

<n>PurchaseDate</n>

<dsc>Asset acquisition date.</dsc>

</prms>

<prms>

<n>FirstPeriodEnd</n>

<dsc>First period end date.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Residual cost of asset at the end of depreciation period.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period. The value should satisfy the constraint: Period > 0.</dsc>

</prms>

<prms>

<dsc>Depreciation rate. The value should satisfy the constraint: Rate > 0.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupDayBs</n>

<dsc>Returns the number of days from the beginning of coupon commencement till the agreement date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupDays</n>

<dsc>Returns the number of days in the coupon period that contains settlement date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupDaysNc</n>

<dsc>Returns the number of days from the settlement date to the next coupon date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupNcd</n>

<dsc>Returns the number that is the next coupon date after the settlement date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupNum</n>

<dsc>Returns the number of coupons that can be paid between the settlement date ad the maturity date rounded to the nearest integer number of coupons.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CoupPcd</n>

<dsc>Returns the number corresponding to the previous coupon date before the settlement date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>CumIpmt</n>

<dsc>Returns cumulative (running total) value of interest paid on loan between two payment periods.</dsc>

<prms>

<dsc>Interest rate.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of payment periods.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Investment cost at the moment.</dsc>

</prms>

<prms>

<n>StartPeriod</n>

<dsc>Number of the first period included in calculations. Numbering of payment periods starts from 1.</dsc>

</prms>

<prms>

<n>EndPeriod</n>

<dsc>Number of the last period included in calculations.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<n>Cumprinc</n>

<dsc>Returns cumulative (running total) amount paid in satisfaction of principal loan amount between two periods.</dsc>

<prms>

<dsc>Interest rate.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of payment periods.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Investment cost at the moment.</dsc>

</prms>

<prms>

<n>StartPeriod</n>

<dsc>Number of the first period included in calculations. Numbering of payment periods starts from 1.</dsc>

</prms>

<prms>

<n>EndPeriod</n>

<dsc>Number of the last period included in calculations.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns asset depreciation value for the specified period calculated by method of fixed margin reduction.</dsc>

<prms>

<dsc>Asset acquisition expenses.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Cost at the end of depreciation period.</dsc>

</prms>

<prms>

<dsc>Number of periods, in which asset is depreciated.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>The period, for which depreciation should be calculated. The period should be measured in the same units as Life.</dsc>

</prms>

<prms>

<n>Month</n>

<dsc>Number of months in the first year (12 by default).</dsc>

</prms>

</fns>

<fns>

<dsc>Returns asset depreciation value for the specified period, using double declining method or the other explicitly specified method.</dsc>

<prms>

<dsc>Asset acquisition expenses.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Cost at the end of depreciation period.</dsc>

</prms>

<prms>

<dsc>Number of periods, in which asset is depreciated.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>The period, for which depreciation should be calculated. The period should be measured in the same units as Life.</dsc>

</prms>

<prms>

<n>Factor</n>

<dsc>Declining balance interest rate (2 by default).</dsc>

</prms>

</fns>

<fns>

<dsc>Returns discount rate for securities.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Nominal</n>

<dsc>Price per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost of securities per $100 face value.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>DollarFr</n>

<dsc>Converts ruble price expressed as a decimal value into ruble price expressed as a fraction. The DollarFr function is used to convert decimal numbers, for example, securities cost into fractional prices.</dsc>

<prms>

<n>DecimalValue</n>

<dsc>Decimal number. The value should satisfy the constraint: DecimalValue >= 0.</dsc>

</prms>

<prms>

<n>Fraction</n>

<dsc>Integer that should be used as a denominator. The value should satisfy the constraint: Fraction <> 0.</dsc>

</prms>

</fns>

<fns>

<n>Duration</n>

<dsc>Returns the Macaulay duration for assumed $100 face value. The duration is determined as a weighted mean of net value of cash flows and is used as a measure of reaction of bonds prices to change in yield.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Coupon</n>

<dsc>Annual interest rate for securities coupons.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>mandatory argument. The number of payments for coupons in a year. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>DollarDe</n>

<dsc>Converts ruble price expressed as a fraction into ruble price expressed as a decimal value. The DollarDe function is used to convert fractional values of monetary amounts, for example, securities cost, into a decimal number.</dsc>

<prms>

<n>FractionValue</n>

<dsc>Number expressed as a fraction. The value should satisfy the constraint: FractionValue >= 0.</dsc>

</prms>

<prms>

<n>Fraction</n>

<dsc>Integer that should be used as a denominator. The value should satisfy the constraint: Fraction <> 0.</dsc>

</prms>

</fns>

<fns>

<n>Effect</n>

<dsc>Returns effective (actual) annual interest rate if nominal annual interest rate and the number of periods in a year, are set for which compound interest is accrued.</dsc>

<prms>

<n>NominalRate</n>

<dsc>Nominal annual rate. The value should satisfy the constraint: NominalRate > 0.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>The number of periods in a year, for which compound interest is accrued. The value should satisfy the constraint: PeriodCount >= 1.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns future investment value based on periodic constant payments (equal sums) and fixed interest rate.</dsc>

<prms>

<dsc>Interest rate for period.</dsc>

</prms>

<prms>

<n>PaymentCount</n>

<dsc>General number of annuity payment periods.</dsc>

</prms>

<prms>

<n>PeriodPayment</n>

<dsc>Payment made at each period.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Present value or total sum that is currently equal to a series of future payments.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<n>FvSchedule</n>

<dsc>Returns future value of the original principal amount after you apply a number (plan) of compound interest rates. The function is used to calculate future investment value with variable interest rate.</dsc>

<prms>

<n>Principal</n>

<dsc>Investment cost at the moment.</dsc>

</prms>

<prms>

<n>Schedule</n>

<dsc>Array of applied interest rates.</dsc>

</prms>

</fns>

<fns>

<n>Intrate</n>

<dsc>Returns interest rate for fully invested securities.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Investment</n>

<dsc>Volume of securities investment.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Sum that should be obtained at the moment of securities redemption.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns sum of interest payments on investment for the specified period based on the constant sums of periodic payments and constant interest rate.</dsc>

<prms>

<dsc>Interest rate for period.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period, for which it is required to find interest payments.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of annual rent payment periods.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Present value or total sum that is currently equal to a series of future payments.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or remaining balance after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns internal rate of return for a number of cash flows presented by their numeric values.</dsc>

<prms>

<n>Values</n>

<dsc>Array containing numbers, for which it is required to calculate internal rate of return.</dsc>

</prms>

<prms>

<n>Guess</n>

<dsc>The value which is assumed to be close to result of Irr.</dsc>

</prms>

</fns>

<fns>

<n>Ispmt</n>

<dsc>Calculates interest paid for the specific investment period.</dsc>

<prms>

<dsc>Interest rate for investment.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period, for which it is required to find income.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of payment periods for this investment.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Investment cost at the moment. The interest rate for a loan is a loan sum.</dsc>

</prms>

</fns>

<fns>

<n>MDuration</n>

<dsc>Returns modified Macaulay duration for securities with assumed $100 face value.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date. This date is later than the issuance date when securities were sold to a customer. The value should satisfy the constraint: Settlement < Maturity.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>CouponRate</n>

<dsc>Annual interest rate for securities coupons.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Mandatory argument. The number of payments for coupons in a year. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns internal rate of return for a number of periodic cash flows taking into account both investment raising expenses and the interest obtained from currency reinversion.</dsc>

<prms>

<n>Values</n>

<dsc>Array containing numeric values. These values are a series payments (negative values) and inpayments (positive values) made in regular time periods.</dsc>

</prms>

<prms>

<n>FinanceRate</n>

<dsc>Interest rate paid for money used in cash flows.</dsc>

</prms>

<prms>

<n>ReinvestRate</n>

<dsc>Interest rate obtained for cash flows on their reinvestment.</dsc>

</prms>

</fns>

<fns>

<n>Nominal</n>

<dsc>Returns annual nominal cost if effective (actual) rate and the number of periods in a year, for which compound interest is accrued, are set.</dsc>

<prms>

<n>EffectRate</n>

<dsc>Actual interest rate.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>The number of periods in a year, for which compound interest is accrued.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns general number of payment periods for an investment based on constant periodic payments and constant interest rate.</dsc>

<prms>

<dsc>Interest rate for period.</dsc>

</prms>

<prms>

<n>PeriodPayment</n>

<dsc>Payment made at each period; this value cannot change during the entire payment period.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Present value or total sum that is currently equal to a series of future payments.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or remaining balance after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns net present investment cost using discount rate, and also cost of future payments (negative values) and inpayments (positive values).</dsc>

<prms>

<dsc>Discount rate for one period.</dsc>

</prms>

<prms>

<n>Values</n>

<dsc>Array of arguments of income and expenses.</dsc>

</prms>

</fns>

<fns>

<n>OddfPrice</n>

<dsc>Returns price per $100 face value of securities for an odd (short or long) first period.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date (date of selling securities to a customer that is later than issuance date).</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Mandatory. The security's maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Issue</n>

<dsc>Securities issuance date.</dsc>

</prms>

<prms>

<n>FirstCouponDate</n>

<dsc>Date of the first coupon payment for securities.</dsc>

</prms>

<prms>

<dsc>Securities interest rate.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>OddfYield</n>

<dsc>Returns yield of securities with an odd (short or long) first period.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date (date of selling securities to a customer that is later than issuance date).</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Mandatory. The security's maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>Issue</n>

<dsc>Securities issuance date.</dsc>

</prms>

<prms>

<n>FirstCouponDate</n>

<dsc>Date of the first coupon payment for securities.</dsc>

</prms>

<prms>

<dsc>Securities interest rate.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Securities cost.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>OddlPrice</n>

<dsc>Returns price per $100 face value of securities for an odd (short or long) last coupon period.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date (date of selling securities to a customer that is later than issuance date).</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Mandatory. The security's maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>LastCouponDate</n>

<dsc>Date of the last coupon payment for securities.</dsc>

</prms>

<prms>

<dsc>Securities interest rate.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>OddlYield</n>

<dsc>Returns yield of securities with an odd (short or long) last period.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date (date of selling securities to a customer that is later than issuance date).</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Mandatory. The security's maturity date. This date determines securities expiration date.</dsc>

</prms>

<prms>

<n>LastCouponDate</n>

<dsc>Date of the last coupon payment for securities.</dsc>

</prms>

<prms>

<dsc>Securities interest rate.</dsc>

</prms>

<prms>

<n>Price</n>

<dsc>Securities cost.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns the sum of periodic annuity payment based on constant payment sums and fixed interest rate.</dsc>

<prms>

<dsc>Interest rate for advances.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of payments for advances.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Present value or general value that is currently equal to a series of future payments, also named as a principal value.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or residual after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns payment on the principal for an investment for a given period based on constant periodic payments and constant interest rate.</dsc>

<prms>

<dsc>Interest rate for advances.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>General number of payments for advances.</dsc>

</prms>

<prms>

<n>PresentValue</n>

<dsc>Present value or general value that is currently equal to a series of future payments, also named as a principal value.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or residual after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<n>Price</n>

<dsc>Returns price per 100$ face value of the securities which pay a periodic interest.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<dsc>Annual interest rate for securities coupons.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>PriceDisc</n>

<dsc>Returns price per $100 face value of the securities, for which a discount is made.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<n>Discount</n>

<dsc>Security discount.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>PriceMat</n>

<dsc>Returns price per $100 face value of the securities that pay interest on maturity date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<n>Issue</n>

<dsc>Securities issuance date.</dsc>

</prms>

<prms>

<dsc>Interest rate of securities yield on issuance date.</dsc>

</prms>

<prms>

<n>YieldP</n>

<dsc>Annual income for securities.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns present investment cost. The present cost is a total sum that is currently equal to a series of future payments. For example, when you borrow money, the loan sum is the present cost for a loaner.</dsc>

<prms>

<dsc>Interest rate for period.</dsc>

</prms>

<prms>

<n>PeriodCount</n>

<dsc>Total number of annuity payment periods.</dsc>

</prms>

<prms>

<n>PeriodPayment</n>

<dsc>Payment that is made each period and that does not change during the entire rent payment time.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or remaining balance after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns annuity interest rate per a period.</dsc>

<prms>

<n>PeriodCount</n>

<dsc>Total number of annuity payment periods.</dsc>

</prms>

<prms>

<n>PeriodPayment</n>

<dsc>Regular payment (once per a period), which value remains fixed during the entire annuity time. Usually, PMT consists of the principal payment and the interest payment but does not include other commissions and taxes.</dsc>

</prms>

<prms>

<n>CurrentCost</n>

<dsc>Present value or total sum that is currently equal to a series of future payments.</dsc>

</prms>

<prms>

<n>FutureValue</n>

<dsc>Required value of future cost or remaining balance after the last payment.</dsc>

</prms>

<prms>

<dsc>Select payment time: 0(zero) - at the end of the period; 1 - at the beginning of the period.</dsc>

</prms>

<prms>

<n>Guess</n>

<dsc>Assumed rate value.</dsc>

</prms>

</fns>

<fns>

<n>Received</n>

<dsc>Returns the sum obtained by the maturity date of fully asset-backed securities.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<n>Investment</n>

<dsc>Volume of securities investment.</dsc>

</prms>

<prms>

<n>Discount</n>

<dsc>Security discount.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns asset depreciation value per a period calculated with linear method.</dsc>

<prms>

<dsc>Asset acquisition expenses.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Cost at the end of depreciation period.</dsc>

</prms>

<prms>

<dsc>Number of periods, for which an asset is depreciated.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns asset depreciation value for the specified period calculated with the method of sum of (annual) numbers.</dsc>

<prms>

<dsc>Asset acquisition expenses.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Cost at the end of depreciation period.</dsc>

</prms>

<prms>

<dsc>Number of periods, for which an asset is depreciated.</dsc>

</prms>

<prms>

<n>Period</n>

<dsc>Period (should be measured in the same units as full depreciation time)</dsc>

</prms>

</fns>

<fns>

<n>TBillEq</n>

<dsc>Returns treasury bill yield that is equivalent to bond.</dsc>

<prms>

<n>Settlement</n>

<dsc>Treasury bill settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Treasury bill maturity date.</dsc>

</prms>

<prms>

<n>Discount</n>

<dsc>Treasury bill discount.</dsc>

</prms>

</fns>

<fns>

<n>TBillPrice</n>

<dsc>Returns price per $100 face value of treasury bill.</dsc>

<prms>

<n>Settlement</n>

<dsc>Treasury bill settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Treasury bill maturity date.</dsc>

</prms>

<prms>

<n>Discount</n>

<dsc>Treasury bill discount.</dsc>

</prms>

</fns>

<fns>

<n>TBillYield</n>

<dsc>Returns price per $100 face value of treasury bill.</dsc>

<prms>

<n>Settlement</n>

<dsc>Treasury bill settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Treasury bill maturity date.</dsc>

</prms>

<prms>

<n>Price</n>

<dsc>Price of treasury bill per $100 face value.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns rate of asset depreciation for any selected period or for partial periods calculated using double declining method or another specified method.</dsc>

<prms>

<dsc>Asset acquisition expenses.</dsc>

</prms>

<prms>

<n>Salvage</n>

<dsc>Cost at the end of depreciation period.</dsc>

</prms>

<prms>

<dsc>Number of periods, for which an asset is depreciated.</dsc>

</prms>

<prms>

<n>StartPeriod</n>

<dsc>Start period, for which depreciation is calculated.</dsc>

</prms>

<prms>

<n>EndPeriod</n>

<dsc>End period, for which depreciation is calculated.</dsc>

</prms>

<prms>

<n>Factor</n>

<dsc>Interest rate of declining balance.</dsc>

</prms>

<prms>

<n>NoSwitch</n>

<dsc>Logical value that determines whether linear depreciation should be used when depreciation exceeds the value calculated with the declining balance method.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns internal rate of return for not necessarily periodic cash flow schedule.</dsc>

<prms>

<n>Values</n>

<dsc>A series of cash flows corresponding to payments schedule given in date argument.</dsc>

</prms>

<prms>

<n>Dates</n>

<dsc>Payment dates schedule corresponding to a series of cash flows.</dsc>

</prms>

<prms>

<n>Guess</n>

<dsc>Assumed value of function result.</dsc>

</prms>

</fns>

<fns>

<dsc>Returns net present value for cash flows that are not necessarily periodic.</dsc>

<prms>

<dsc>Discount rate applied to cash flows.</dsc>

</prms>

<prms>

<n>Values</n>

<dsc>A series of cash flows corresponding to payments schedule given in date argument.</dsc>

</prms>

<prms>

<n>Dates</n>

<dsc>Payment dates schedule corresponding to a series of cash flows.</dsc>

</prms>

</fns>

<fns>

<n>YieldF</n>

<dsc>Returns yield of the securities that pay periodic interest. The Yield function is used to calculate yield of bonds.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<dsc>Annual interest rate for securities coupons.</dsc>

</prms>

<prms>

<n>Price</n>

<dsc>Price per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Frequency</n>

<dsc>Number of annual payments for coupons. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>YieldDisc</n>

<dsc>Returns annual yield of the securities, for which a discount is made.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<n>Price</n>

<dsc>Price per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Redemption</n>

<dsc>Redemption cost per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>YieldMat</n>

<dsc>Returns annual yield of the securities that pay interest on maturity date.</dsc>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

<prms>

<n>Maturity</n>

<dsc>Securities maturity date.</dsc>

</prms>

<prms>

<n>Issue</n>

<dsc>Securities issuance date.</dsc>

</prms>

<prms>

<dsc>Annual interest rate for securities coupons.</dsc>

</prms>

<prms>

<n>Price</n>

<dsc>Price per $100 face value of securities.</dsc>

</prms>

<prms>

<n>Basis</n>

<dsc>Used day calculation method: 0 - American. 360 days (NSAD method); 1 - Actual/actual; 2 - Actual/360 days; 3 - Actual/365 days; 4 - European 30/360 days.</dsc>

</prms>

</fns>

<fns>

<n>RedemptionYield</n>

<dsc>Yield for a security on its redemption with irregular payment periods.</dsc>

<prms>

<n>Price</n>

<dsc>Security price.</dsc>

</prms>

<prms>

<n>AccumulatedIncome</n>

<dsc>Accrued income.</dsc>

</prms>

<prms>

<n>CouponsDates</n>

<dsc>Dates of coupon payments.</dsc>

</prms>

<prms>

<n>Coupons</n>

<dsc>Interest rates for coupons.</dsc>

</prms>

<prms>

<n>PaymentsDates</n>

<dsc>Payment dates.</dsc>

</prms>

<prms>

<n>Payments</n>

<dsc>Payment values.</dsc>

</prms>

<prms>

<n>Settlement</n>

<dsc>Securities settlement date.</dsc>

</prms>

</fns>

</cts>

<n>Statistical</n>

<fns>

<n>AveDev</n>

<dsc>The method returns average of the absolute values data points deviations from average. This value is a measure of spread of data set.</dsc>

<prms>

<n>Values</n>

<dsc>Set of numbers, for which mean absolute deviation is determined.</dsc>

</prms>

</fns>

<fns>

<n>BetaDist</n>

<dsc>The method returns the integral function of beta probability density. The integral function of eta probability is usually used to study variation in percentage of any value.</dsc>

<prms>

<dsc>Value, for which the function is calculated. The value should satisfy the constraint: 1 > X > 0.</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Distribution parameter. The value should satisfy the constraint: Alpha > 0.</dsc>

</prms>

<prms>

<dsc>Distribution parameter. The value should satisfy the constraint: Beta > 0.</dsc>

</prms>

</fns>

<fns>

<n>BetaInv</n>

<dsc>The method returns the inverse function for the integral function of beta probability density. If Probability = BetaDist(x; …), then BetaInv(Probability ; …) = x.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability related with beta distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Distribution parameter. The value should satisfy the constraint: Alpha > 0.</dsc>

</prms>

<prms>

<dsc>Distribution parameter. The value should satisfy the constraint: Beta > 0.</dsc>

</prms>

</fns>

<fns>

<n>BinomDist</n>

<dsc>The method returns the single value of binomial distribution. The function is used in tasks with a fixed number of tests or trials when any trial can result only in success or failure. Trials are independent, and probability of success is constant during the entire experiment.</dsc>

<prms>

<n>Successes</n>

<dsc>Number of successful trials.</dsc>

</prms>

<prms>

<n>Trials</n>

<dsc>Number of independent trials.</dsc>

</prms>

<prms>

<n>Probability</n>

<dsc>Probability of success of each trial. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>Logical value that determines a function form. If this argument is set to True, the BinomDist function returns the integral function of distribution, that is, the probability that the number of successful trials is not less than the number of the value of the Successes argument. If this argument is set to False, the distribution function is returned, that is, the probability that the number of successful trials is strictly equal to the value of the Successes argument.</dsc>

</prms>

</fns>

<fns>

<n>ChiDist</n>

<dsc>The method returns the one-tailed probability of chi-square distribution. The χ2 distribution is related with the χ2 criterion. The χ2 criterion is used to compare assumed and observed values. The value is calculated as follows: ChiDist = P(X>x), where x - χ2 random value.</dsc>

<prms>

<dsc>The value, for which distribution should be calculated. The value should satisfy the constraint: X >= 0.</dsc>

</prms>

<prms>

<n>DegreesOfFreedom</n>

<dsc>Number of degrees of freedom. Available values are taken from the range (1; 10^10).</dsc>

</prms>

</fns>

<fns>

<n>ChiInv</n>

<dsc>The method returns the value that is inverse to the one-tailed probability of chi-square distribution. The function is used to compare assumed and observed results. If the probability = ChiDist(x; …), then ChiInv(probability; …) = x.</dsc>

<prms>

<n>Probability</n>

<dsc>The probability that is related with the χ2 (chi-square) distribution. The value should satisfy the constraint: 0 <= Probability <= 1.</dsc>

</prms>

<prms>

<n>DegreesOfFreedom</n>

<dsc>Number of degrees of freedom. Available values are taken from the range (1; 10^10).</dsc>

</prms>

</fns>

<fns>

<n>ChiTest</n>

<dsc>The method returns the value for chi-square distribution. The χ2 criterion is used to determine whether the hypothesis is justified with the experiment. The χ2 criterion first calculates the χ2 statistic and then sums up differences between actual and expected values. NOTE. ActualRange and ExpectedRange should match in size.</dsc>

<prms>

<n>ActualRange</n>

<dsc>Interval of the data that contains the observations that should be compared with expected values.</dsc>

</prms>

<prms>

<n>ExpectedRange</n>

<dsc>Data interval that contains the relation of products of row totals and column totals to the grand total.</dsc>

</prms>

</fns>

<fns>

<n>Confidence</n>

<dsc>The method returns the confidence interval for the entire population average. Confidence limit is an interval from both sides of the sample average.</dsc>

<prms>

<n>Alpha</n>

<dsc>Significance level used to calculate reliability level. The significance level is equal to 100*(1 - Alpha) percent, or, on other words, the alfa equal to 0.05 means the 95% reliability level. The value should satisfy the constraint: 0 < Alpha < 1.</dsc>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation of entire population for data interval, it is assumed to be known. The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

<prms>

<dsc>Sample size.</dsc>

</prms>

</fns>

<fns>

<n>Correl</n>

<dsc>The method returns correlation coefficient between A1 and A2. The correlation coefficient is used to determine whether two properties are linked. NOTE. A1 and A2 should have the equal number of data points.</dsc>

<prms>

<dsc>First value array.</dsc>

</prms>

<prms>

<dsc>Second value array.</dsc>

</prms>

</fns>

<fns>

<n>Covar</n>

<dsc>The method returns the covariance, that is, the average of deviation products for each pair of data points. The covariance is used to determine a link between two data sets. NOTE. A1 and A2 should have the equal number of data points.</dsc>

<prms>

<dsc>First value array.</dsc>

</prms>

<prms>

<dsc>Second value array.</dsc>

</prms>

</fns>

<fns>

<n>CritBinom</n>

<dsc>The method returns the least value, for which the integral binomial distribution is greater or equal to the specified criterion. This function is used in applications related with quality control.</dsc>

<prms>

<n>Trials</n>

<dsc>Number of Bernoulli trials. The value should satisfy the constraint: Trials >= 0.</dsc>

</prms>

<prms>

<n>Probability</n>

<dsc>Probability of success in each trial. Available values are taken from the range [0; 1].</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Criterion value. Available values are taken from the range [0; 1].</dsc>

</prms>

</fns>

<fns>

<n>DevSq</n>

<dsc>The method returns the sum of squares of data point deviations from their average.</dsc>

<prms>

<n>Values</n>

<dsc>Set of numbers, which squares of deviations are summed up.</dsc>

</prms>

</fns>

<fns>

<n>ExponDist</n>

<dsc>The method returns exponential distribution. The function is used to model time delays between events.</dsc>

<prms>

<n>Value</n>

<dsc>Function value. The value should satisfy the constraint: Value >= 0.</dsc>

</prms>

<prms>

<n>Lambda</n>

<dsc>Parameter value. The value should satisfy the constraint: Lambda > 0.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>Logical value that indicates which form of exponential function should be used. If the attribute is set to True, the ExponDist function returns the integral function of distribution. If the attribute is set to False, the function of distribution density is returned.</dsc>

</prms>

</fns>

<fns>

<n>FDist</n>

<dsc>The method returns F distribution of probability. This function can be used to determine whether two data sets have different degrees of spread of results.</dsc>

<prms>

<n>Value</n>

<dsc>Value, for which the function is calculated. The value should satisfy the constraint: Value >= 0.</dsc>

</prms>

<prms>

<n>DegOfFreedomNumer</n>

<dsc>Numerator of degrees of freedom. Available values are taken from the range [1; 10^10).</dsc>

</prms>

<prms>

<n>DegOfFreedomDenomin</n>

<dsc>Denominator of degrees of freedom. Available values are taken from the range [1; 1010).</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns the inverse value for F distribution of probabilities. If Probability = FDist(Value ;…), then FInv(Probability ;…) = Value.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability related with F distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

<n>DegreesOfFreedom1</n>

<dsc>Numerator of degrees of freedom. Available values are taken from the range [1; 10^10).</dsc>

</prms>

<prms>

<n>DegreesOfFreedom2</n>

<dsc>Denominator of degrees of freedom. Available values are taken from the range [1; 10^10).</dsc>

</prms>

</fns>

<fns>

<n>Fisher</n>

<dsc>The method returns the Fisher transformation for the Value argument. This transformation builds the function that has normal and not asymmetrical distribution. This function is used to test hypotheses using correlation coefficient.</dsc>

<prms>

<n>Value</n>

<dsc>Value that should be transformed. The value should satisfy the constraint: 1 > Value > -1.</dsc>

</prms>

</fns>

<fns>

<n>FisherInv</n>

<dsc>The method returns the inverse Fisher distribution. This distribution is used in correlation analysis between data arrays or data intervals. If y = Fisher(x), then FisherInv(y) = x.</dsc>

<prms>

<n>Value</n>

<dsc>The value, for which inverse transformation is executed.</dsc>

</prms>

</fns>

<fns>

<n>Forecast</n>

<dsc>The method calculates the future value based on existing values. NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.</dsc>

<prms>

<n>Value</n>

<dsc>Index of the point, for which value is predicted.</dsc>

</prms>

<prms>

<n>KnownYs</n>

<dsc>Dependent data array.</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Independent data array.</dsc>

</prms>

</fns>

<fns>

<n>_Frequency</n>

<dsc>The method calculates the frequency of occurrence of values in the value interval and returns the numbers array. The number of elements in the returned array is one greater than the number of elements in the BinsArray array. The additional element in the returned array contains the number of values that are greater than the maximum value in intervals.</dsc>

<prms>

<n>DataArray</n>

<dsc>Array of data, for which frequencies are calculated. If DataArray does not contain values, the Frequency function returns the array of zeroes.</dsc>

</prms>

<prms>

<n>BinsArray</n>

<dsc>Array of intervals, into which values of the DataArray argument are grouped. If BinsArray does not contain values, the Frequency function returns the number of elements in the DataArray argument.</dsc>

</prms>

</fns>

<fns>

<n>FTest</n>

<dsc>The method returns the result of the F test. The F test returns the one-tailed probability that variances of the A1 and A2 differ insignificantly. This function is used to determine whether two samples have different variances.</dsc>

<prms>

<dsc>First array. Array length should be greater or equal to two.</dsc>

</prms>

<prms>

<dsc>Second array. Array length should be greater or equal to two.</dsc>

</prms>

</fns>

<fns>

<n>GammaDist</n>

<dsc>The method returns the Gamma distribution. This function can be used to study the variables that have asymmetrical distribution. Usually, the Gamma distribution is used in the queueing theory.</dsc>

<prms>

<n>Value</n>

<dsc>The value, for which distribution should be calculated. The value should satisfy the constraint: Value >= 0.</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Distribution parameter. The value should satisfy the constraint: Alpha > 0. If Alpha = 1, the GammaDist function returns exponential distribution.</dsc>

</prms>

<prms>

<dsc>Distribution parameter. The value should satisfy the constraint: Beta > 0. If Beta = 1, the GammaDist function returns standard Gamma distribution.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>Logical value that determines function form: - True. The GammaDist function returns the integral function of distribution; - False. The GammaDist function returns the function of distribution density.</dsc>

</prms>

</fns>

<fns>

<n>GammaInv</n>

<dsc>The method returns the inverse Gamma distribution. This function is used to study the variables that probably have asymmetrical distribution. If Probability = GammaDist(x; …), then GammaInv(Probability ; …) = x.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability related with the Gamma distribution. The value should satisfy the constraint: 0 <= Probability <= 1.</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Distribution parameter. The value should satisfy the constraint: Alpha > 0.</dsc>

</prms>

<prms>

<dsc>Distribution parameter. If Beta = 1, the GammaInv function returns the standard Gamma distribution. The value should satisfy the constraint: Beta > 0.</dsc>

</prms>

</fns>

<fns>

<n>GammaLn</n>

<dsc>The method returns the natural logarithm of the Gamma function. The e number raised to the GammaLn (i) power, where i — integer that returns the same result as (i - 1)!.</dsc>

<prms>

<n>Value</n>

<dsc>The value, for which GammaLn is calculated. The value should satisfy the constraint: Value > 0.</dsc>

</prms>

</fns>

<fns>

<n>GeoMean</n>

<dsc>The method returns the geometric mean of values of array of positive numbers.</dsc>

<prms>

<n>Values</n>

<dsc>Array of data, for which the mean is calculated. Values in the array should be greater than zero.</dsc>

</prms>

</fns>

<fns>

<n>HarMean</n>

<dsc>The method returns the harmonic mean of data set. Harmonic mean is a value that is inverse to the arithmetic mean of inverse values. The harmonic mean is always less than the geometric mean that is always less then the arithmetic mean.</dsc>

<prms>

<n>Values</n>

<dsc>Set of arguments, for which the mean is calculated.</dsc>

</prms>

</fns>

<fns>

<n>HypGeomDist</n>

<dsc>The method returns the hypergeometric distribution. The method returns the probability of the specified number of successes in the sample if the following is set: sample size, number of successes in the entire population, and entire population size.</dsc>

<prms>

<n>SuccessfulTrials</n>

<dsc>Number of successful trials in the sample. The value should satisfy the constraints: - SuccessfulTrials > = 0; - SuccessfulTrials < = min(Trials, SuccessfulInPopulation); - SuccessfulTrials > = max(0, Trials-PopulationSize+SuccessfulTrials).</dsc>

</prms>

<prms>

<n>Trials</n>

<dsc>Sample size. Available values are taken from the range [0; PopulationSize].</dsc>

</prms>

<prms>

<n>SuccessfulInPopulation</n>

<dsc>The number of successful trials in the entire population. Available values are taken from the range [0; PopulationSize].</dsc>

</prms>

<prms>

<n>PopulationSize</n>

<dsc>Entire population size. The value should satisfy the constraint: PopulationSize >= 0.</dsc>

</prms>

</fns>

<fns>

<n>Intercept</n>

<dsc>The method calculates the point of intersection of the line and the Y axis, using KnownXs and KnownYs. The intersection point is located at the optimal regression line drawn through KnownXs and KnownYs. The Intercept method is used when one needs to determine a value of dependent variable if the independent variable value is set to 0 (zero). NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Dependent data set.</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Independent data set.</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns the data set kurtosis. The kurtosis characterizes the relative pointedness or smoothness in comparison to the normal distribution. A positive kurtosis indicates a relative cusped distribution. The negative kurtosis means the relatively smoothed distribution.</dsc>

<prms>

<n>Values</n>

<dsc>Data array.</dsc>

</prms>

</fns>

<fns>

<n>Large</n>

<dsc>The method returns the k-th value by size from the data set. This function enables the user to select the value by its relative position.</dsc>

<prms>

<dsc>Array of data, for which the k-th greatest value is determined. Array length should be greater than zero (0).</dsc>

</prms>

<prms>

<n>Position</n>

<dsc>Position (starting from the greatest one) in the data array. Available values are taken from the range (0; length of Data].</dsc>

</prms>

</fns>

<fns>

<n>Linest</n>

<dsc>The method calculates statistic for a series and applies the least squares method to calculate the straight line that best of all approximates existing data. The function returns the array that describes the obtained line.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Set of y values that are already known in the relation y = m * x + b . The value should satisfy the constraint: KnownYs > 0. If the KnownYs array contains one column, each column of the KnownXs array is interpreted as a single variable. If the KnownYs array contains one row, each row of the KnownXs array is interpreted as a single variable. The KnownXs array can contain one or several variable sets. If only one variable is used, KnownYs and KnownXs can have any form provided that they are equal in size. If more than one variable is used, KnownYs should be a vector (that is, an interval that is one row high and one column wide).</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Set of x values that are already known in the relation y = m * x + b .</dsc>

</prms>

<prms>

<n>HasConstant</n>

<dsc>Logical value that indicates whether the b constant should be equal to zero: - if the value is True, b is calculated normally; - if the value is False, b is assumed to be equal to 0, and values of m are selected to satisfy the equation: y=mx.</dsc>

</prms>

<prms>

<n>ReturnStatistics</n>

<dsc>Logical value that indicates whether additional regression statistic should be returned: - if the value is True, the Linest function returns additional regression statistic; - if the value is False, the Linest function returns only coefficients of m and the b constant.</dsc>

</prms>

</fns>

<fns>

<n>LogInv</n>

<dsc>The method returns the inverse function of lognormal distribution. If Probability = LogNormDist(x; …), then LogInv(Probability ; …) = x.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability related with lognormal distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation ln(x). The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

</fns>

<fns>

<n>LogNormDist</n>

<dsc>The method returns integral lognormal distribution. This function is used to analyze data that was logarithmically transformed.</dsc>

<prms>

<n>Value</n>

<dsc>Value, for which the function is calculated. The value should satisfy the constraint: Value > 0.</dsc>

</prms>

<prms>

<dsc>Mean ln(Value );</dsc>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation ln(Value). The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

</fns>

<fns>

<n>Median</n>

<dsc>The method returns the median of specified numbers. Median is a number that is the middle of a numbers set, that is, the half of the numbers have vales greater than the median, and the other half of the numbers have values less than the median.</dsc>

<prms>

<n>Values</n>

<dsc>Set of numbers, for which the median should be found.</dsc>

</prms>

</fns>

<fns>

<n>NegBinomDist</n>

<dsc>The method returns negative binomial distribution. NOTE. The following condition should be satisfied: (FailedTrials + SuccessfulTrials - 1) > 0.</dsc>

<prms>

<n>FailedTrials</n>

<dsc>Number of failed trials.</dsc>

</prms>

<prms>

<n>SuccessfulTrials</n>

<dsc>Threshold value of the number of successful trials.</dsc>

</prms>

<prms>

<n>Probability</n>

<dsc>Probability of success. Available values are taken from the range [0; 1].</dsc>

</prms>

</fns>

<fns>

<n>NormDist</n>

<dsc>The method returns the normal distribution function for the specified mean and standard deviation. If Mean = 0, StandartDeviation = 1 and Cumulative = True, the NormDist function returns the standard normal distribution (NormDist).</dsc>

<prms>

<n>Value</n>

<dsc>Value, for which distribution is executed.</dsc>

</prms>

<prms>

<dsc>Arithmetic mean of distribution.</dsc>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>Logical value that determines a function form: - if the value is True, the NormDist function returns the integral function of distribution; - if the value is False, the function of distribution density is returned.</dsc>

</prms>

</fns>

<fns>

<n>NormInv</n>

<dsc>The method returns the inverse normal distribution. If Mean = 0 and StandartDeviation = 1, the method uses standard normal distribution (NormDist).</dsc>

<prms>

<n>Probability</n>

<dsc>Probability corresponding to normal distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

<dsc>Arithmetic mean of distribution.</dsc>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

</fns>

<fns>

<n>NormsDist</n>

<dsc>The method returns standard normal integral distribution. This distribution has the mean that is equal to zero, and the standard deviation that is equal to one. This function is used instead of the table for standard normal curve.</dsc>

<prms>

<n>Value</n>

<dsc>Value, for which distribution is executed.</dsc>

</prms>

</fns>

<fns>

<n>NormsInv</n>

<dsc>The method returns the inverse value of standard normal distribution. This distribution has the mean that is equal to zero and the standard deviation that is equal to one.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability corresponding to normal distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

</fns>

<fns>

<n>Pearson</n>

<dsc>The method returns the Pearson correlation coefficient (r). NOTE. A1 and A2 should be non-empty and contain the equal number of data points.</dsc>

<prms>

<dsc>Array of independent values.</dsc>

</prms>

<prms>

<dsc>Array of dependent values.</dsc>

</prms>

</fns>

<fns>

<n>Percentile</n>

<dsc>The method returns the k-th percentile for interval values. This function is used to determine the eligibility threshold. If k is not multiple of 1/(n - 1), the Percentile function executes interpolation to determine values of the k-th percentile.</dsc>

<prms>

<dsc>Data array that determines relative position.</dsc>

</prms>

<prms>

<n>Percent</n>

<dsc>Percentile value. Available values are taken from the range [0; 1].</dsc>

</prms>

</fns>

<fns>

<n>PercentRank</n>

<dsc>The method returns the value category in the data set as percentage in the data set. If the specified Value does not correspond to none of the value of the Data argument, the PercentRank function executes interpolation and returns the correct percentage value.</dsc>

<prms>

<dsc>Data array that determines relative position.</dsc>

</prms>

<prms>

<n>Value</n>

<dsc>Value, for which percentage is determined.</dsc>

</prms>

<prms>

<n>Significance</n>

<dsc>Optional value that determines the number of meaning numbers for returned percentage value. The value should satisfy the constraint: Significance >= 1.</dsc>

</prms>

</fns>

<fns>

<n>Permut</n>

<dsc>The method returns the number of permutations for the specified number of objects. Permutations differ from the combinations, for which the internal order is not important.</dsc>

<prms>

<n>SetSize</n>

<dsc>Number that sets the number of objects. The value should satisfy the constraints: - SetSize > 0; - SetSize >= SampleSize.</dsc>

</prms>

<prms>

<n>SampleSize</n>

<dsc>Number that sets the number of objects in each permutation. The value should satisfy the constraint: SampleSize >= 0.</dsc>

</prms>

</fns>

<fns>

<n>Poisson</n>

<dsc>The method returns the Poisson distribution. The Poisson distribution is usually used to predict the number of events occurring during the specific time period.</dsc>

<prms>

<n>EventCount</n>

<dsc>Number of events. The value should satisfy the constraint: EventCount > 0.</dsc>

</prms>

<prms>

<dsc>Expected numeric value.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>Logical value that determines a form of returned distribution of probabilities: - True. The method returns the integral Poisson distribution, that is, the probability that the number of random events will be from 0 to EventCount inclusive; - False. The function of Poisson distribution density is returned, that is, the probability that the number of events will be strictly equal to EventCount.</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns the probability that the interval value is within the specified limits. If UpperLimit is not set, the probability that values in X are equal to the value of LowerLimit is returned.</dsc>

<prms>

<dsc>Interval of numeric values, with which probabilities are linked. Data array values should be greater than zero (0).</dsc>

</prms>

<prms>

<n>Probabilities</n>

<dsc>Set of probabilities corresponding to values in the X argument. Available values are taken from the range [0; 1].</dsc>

</prms>

<prms>

<n>LowerLimit</n>

<dsc>The lower limit of the value, for which probability is calculated.</dsc>

</prms>

<prms>

<n>UpperLimit</n>

<dsc>Optional upper limit of the value, foe which probability should be calculated.</dsc>

</prms>

</fns>

<fns>

<n>Quartile</n>

<dsc>The Quartile method returns the quartile of data set. The quartile is often used in sales analysis to divide the entire population into groups.</dsc>

<prms>

<dsc>Interval of numeric values, with which probabilities are linked. Data array values should be greater than zero (0).</dsc>

</prms>

<prms>

<n>Quart</n>

<dsc>The value that should be returned. Available values are taken from the range [0; 4]. If Quart is equal, then Quartile returns: 0 - Minimum value. 1 - The first quartile (25-th percentile). 2 - Median value (50-th percentile). 3 - The third quartile (75-th percentile). 4 - Maximum value.</dsc>

</prms>

</fns>

<fns>

<dsc>The Rank method returns the number rank in a numbers array. Number rank is its value relative to other values in the list. If the list is sorted, the number rank will be its position.</dsc>

<prms>

<n>Value</n>

<dsc>The number, for which a rank is determined.</dsc>

</prms>

<prms>

<dsc>Numbers array.</dsc>

</prms>

<prms>

<n>AscendingOrder</n>

<dsc>Ordering method: - True. Number rank is determined as if the array was sorted descending; - False. Number rank is determined as if the array was sorted ascending.</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns the squared Pearson correlation coefficient (r^2). NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Array of independent values.</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Array of dependent values.</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns distribution asymmetry. Asymmetry characterizes the degree of asymmetry of the distribution relative to its mean. Positive skewness indicates distribution deviation towards positive values. Negative asymmetry indicates the distribution deviation directed to negative values.</dsc>

<prms>

<n>Values</n>

<dsc>Array of arguments, for which asymmetry is calculated.</dsc>

</prms>

</fns>

<fns>

<n>Slope</n>

<dsc>The Slope method returns the slope of linear regression line. NOTE. KnownYs and KnownXs should contain the equal number of data points.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Dependent array of data points.</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Independent array of data points.</dsc>

</prms>

</fns>

<fns>

<n>Small</n>

<dsc>The method returns the k-th least value in a data set. If n is the number of data points in Data, then Small(Data; 1) is equal to the least value, and Small(Data; n) is equal to the greatest value.</dsc>

<prms>

<dsc>Data array, for which the k-th least value is determined.</dsc>

</prms>

<prms>

<n>Position</n>

<dsc>Position (starting from the least) in the array or data cell array. Available values are taken from the range (0; length of Data].</dsc>

</prms>

</fns>

<fns>

<n>Standardize</n>

<dsc>The method returns normalized value for distribution characterized with mean and standard deviation.</dsc>

<prms>

<n>Value</n>

<dsc>Normalized value.</dsc>

</prms>

<prms>

<dsc>Arithmetic mean of distribution.</dsc>

</prms>

<prms>

<n>StandartDeviation</n>

<dsc>Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0.</dsc>

</prms>

</fns>

<fns>

<n>StDev</n>

<dsc>The method assesses standard deviation based on a sample. NOTE. If data contains the entire population, then the standard deviation should be calculated using the StDevP function.</dsc>

<prms>

<n>Values</n>

<dsc>Array of data corresponding to the sample from the entire population.</dsc>

</prms>

</fns>

<fns>

<n>StDevP</n>

<dsc>The method calculates the standard deviation based on the entire population. Standard deviation is a measure of how wide data points are spread relative to their mean. The standard deviation is calculated using the "shifted" or "n" method.</dsc>

<prms>

<n>Values</n>

<dsc>Array of data that contains the entire population.</dsc>

</prms>

</fns>

<fns>

<n>SteYX</n>

<dsc>The method returns the standard error of predicted values of Y for each value of X in regression. Standard error is a measure of error of predicted value of Y for a single value of X. NOTE. KnownYs and KnownXs should contain the equal number of data points.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Array of dependent data points.</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Array of independent data points.</dsc>

</prms>

</fns>

<fns>

<n>TDist</n>

<dsc>The method returns percentage points (probability) for Student's t-distribution, where the numeric value (x) is the calculated value, for which probabilities should be calculated. The t-distribution is used to check hypotheses in small-size samples. This function can be used instead of the table of critical values of the t-distribution. TDist is calculated as follows: TDist = p( x<X ), where X is a random value corresponding to the t-distribution.</dsc>

<prms>

<n>Value</n>

<dsc>The value, for which distribution should be calculated.</dsc>

</prms>

<prms>

<n>DegreesOfFreedom</n>

<dsc>Integer that indicates the number of degrees of freedom. The value should satisfy the constraint: DegreesOfFreedom >= 1.</dsc>

</prms>

<prms>

<n>Tails</n>

<dsc>The number of returned distribution tails. Available values: - 1 - the TDist function returns the one-tailed distribution. - 2 - the TDist function returns the two-tailed distribution.</dsc>

</prms>

</fns>

<fns>

<dsc>The method returns the t-value of the Student distribution as a function of probability and number of degrees of freedom. The one-tailed t-value can be obtained if the Probability argument is replaced with 2*Probability.</dsc>

<prms>

<n>Probability</n>

<dsc>Probability corresponding to two-tailed distribution. The value should satisfy the constraint: 1 >= Probability >= 0.</dsc>

</prms>

<prms>

<n>DegreesOfFreedom</n>

<dsc>The number of degrees of freedom that characterizes the distribution. The value should satisfy the constraint: DegreesOfFreedom >= 1.</dsc>

</prms>

</fns>

<fns>

<n>Trend</n>

<dsc>The Trend method returns values according to linear trend. It approximates with a straight line (using the least squares method) the KnownYs and KnownXs arrays. It returns values of Y according to this straight line for the specified NewXs array.</dsc>

<prms>

<n>KnownYs</n>

<dsc>Set of values of Y that are already known in the relation y=mx+b. The value should satisfy the constraint: KnownYs > 0. If the KnownYs array contains one column, each column of the KnownXs array is interpreted as a single variable. If the KnownYs array contains one row, each row of the KnownXs array is interpreted as a single variable. The KnownXs array can contain one or several variable sets. If only one variable is used, KnownYs and KnownXs can have any form provided that they are equal in size. If more than one variable is used, KnownYs should be a vector (that is, an interval that is one row high and one column wide).</dsc>

</prms>

<prms>

<n>KnownXs</n>

<dsc>Set of values of X that are already known in the relation y=mx+b.</dsc>

</prms>

<prms>

<n>NewXs</n>

<dsc>New values of X, for which Trend returns corresponding values of Y. NewXs should contain a column (or a row) for each independent variable, as well as KnownXs. Therefore, if KnownYs contains one column, then KnownXs and NewXs should have the same number of columns. If KnownYs contains one row, then KnownXs and NewXs should have the same number of rows.</dsc>

</prms>

<prms>

<n>HasConstant</n>

<dsc>Logical value that indicates whether the b constant should be equal to zero: - True. b is calculated normally; - False. b is assumed to be equal to 0, and values of m are selected to satisfy the equation y=mx.</dsc>

</prms>

</fns>

<fns>

<n>TrimMean</n>

<dsc>The method returns the mean of data set contents. The function calculates the mean and removes the specified data percentage with extreme values.</dsc>

<prms>

<dsc>Array of averaged values.</dsc>

</prms>

<prms>

<n>Percent</n>

<dsc>Share of data points excluded from calculations. Available values are taken from the range [0; 1].</dsc>

</prms>

</fns>

<fns>

<n>TTest</n>

<dsc>The method returns the probability corresponding to the Student criterion. This function is used to determine the probability that two samples are taken from entire populations that have the same mean. NOTE. If the paired test type (Type=1) is used, then A1 and A2 should contain the equal number of data points.</dsc>

<prms>

<dsc>First data set.</dsc>

</prms>

<prms>

<dsc>Second data set.</dsc>

</prms>

<prms>

<n>Tails</n>

<dsc>Number of distribution tails. Available values: 1 - the TTest function uses one-tailed distribution. 2 - the TTest function uses two-tailed distibution.</dsc>

</prms>

<prms>

<dsc>Type of executed t-test: 1 - Paired. 2 - Two-sample with equal variances (homoscedastic). 3 - Two-sample with unequal variances (heteroscedastic).</dsc>

</prms>

</fns>

<fns>

<n>Dispersion</n>

<dsc>The method assesses the variance based on a sample. It is assumed that arguments are only a sample from the entire population.</dsc>

<prms>

<n>Values</n>

<dsc>Array of numeric arguments corresponding to the sample from the entire population.</dsc>

</prms>

</fns>

<fns>

<n>DispersionP</n>

<dsc>The method calculates variance for the entire population. It is assumed that arguments present the entire population.</dsc>

<prms>

<n>Values</n>

<dsc>Array of numeric arguments corresponding to the entire population.</dsc>

</prms>

</fns>

<fns>

<n>Weibull</n>

<dsc>The method returns the Weibull distribution. This distribution is used in reliability analysis, for example, to calculate the mean time between failures of any device.</dsc>

<prms>

<n>Value</n>

<dsc>The value, for which distribution should be calculated. The value should satisfy the constraint: Value >= 0.</dsc>

</prms>

<prms>

<n>Alpha</n>

<dsc>Distribution parameter. The value should satisfy the constraint: Alpha > 0. If Alpha = 1, the Weibull function returns exponential distribution.</dsc>

</prms>

<prms>

<dsc>Distribution parameter. The value should satisfy the constraint: Beta > 0. If Beta = 1, the Weibull function returns standard distribution.</dsc>

</prms>

<prms>

<n>Cumulative</n>

<dsc>It determines a function form: - True. The Weibull function returns the integral function of distribution; - False. The Weibull function returns the function of distribution density.</dsc>

</prms>

</fns>

<fns>

<n>ZTest</n>

<dsc>The method returns the two-tailed P-value of the z-test. The z-test determines a standard assessment for Value relative to the data array and returns the two-tailed probability for normal distribution. One can use this function to assess the probability that a specific observation is taken from a specific entire population.</dsc>

<prms>

<dsc>Array of data, with which Value is compared.</dsc>

</prms>

<prms>

<n>Value</n>

<dsc>Checked value.</dsc>

</prms>

<prms>

<n>Sigma</n>

<dsc>Known standard deviation of the entire population.</dsc>

</prms>

</fns>

<fns>

<dsc>The Mode method returns mode that is the most frequently occurred value in a data array. The Mode function is a measure of relative position of values. If a source data array contains all unique values (occurred once), then Mode returns NODATA (equal to 1#.QNAN).</dsc>

<prms>

<n>Sample</n>

<dsc>Data array.</dsc>

</prms>

</fns>

<fns>

<n>JarqueBeraStat</n>

<dsc>The JarqueBeraStat method returns the Jarque-Bera statistic. The Jarque-Bera test is applied to verify the hypothesis that the observed series has normal distribution.</dsc>

<prms>

<n>Sample</n>

<dsc>Data array.</dsc>

</prms>

</fns>

</cts>

<n>Logical</n>

<fns>

<dsc>Returns logical TRUE.</dsc>

</fns>

<fns>

<n>False</n>

<dsc>Returns logical FALSE.</dsc>

</fns>

<fns>

<dsc>Checks the condition.</dsc>

<prms>

<n>logical_expression</n>

<dsc>Condition.</dsc>

</prms>

<prms>

<n>ValueTrue</n>

<dsc>Value if the condition is correct.</dsc>

</prms>

<prms>

<n>ValueFalse</n>

<dsc>Value if the condition is incorrect.</dsc>

</prms>

</fns>

<fns>

<dsc>Changes logical value of its argument to an opposite one.</dsc>

<prms>

<n>Value</n>

<dsc>First argument.</dsc>

</prms>

</fns>

<fns>

<n>IsEmpty</n>

<dsc>Returns TRUE if the argument is a link to an empty cell, otherwise it returns FALSE.</dsc>

<prms>

<n>Value</n>

<dsc>First argument.</dsc>

</prms>

</fns>

<fns>

<dsc>Checks if at least argument is set to TRUE and returns TRUE or FALSE. FALSE is returned if arguments are set to FALSE.</dsc>

<prms>

<n>Logical_value</n>

<dsc>Parameter.</dsc>

</prms>

</fns>

<fns>

<dsc>Checks if all arguments are set to TRUE and returns TRUE if all arguments are set to TRUE.</dsc>

<prms>

<n>Logical_value</n>

<dsc>Parameter.</dsc>

</prms>

</fns>

</cts>

<n>Python</n>

<fns>

<n>PythonInvoke</n>

<dsc>Returns the result of executing a function in the Python language.</dsc>

<prms>

<n>ModuleName</n>

<dsc>Name of Python unit in the file system (the file with the *.py extension) or name of system unit.</dsc>

</prms>

<prms>

<n>FunctionName</n>

<dsc>Name of executed function.</dsc>

</prms>

<prms>

<n>Param</n>

<dsc>Parameters sent to function.</dsc>

</prms>

</fns>

<fns>

<n>PythonInvokeModule</n>

<dsc>Returns the result of executing a function stored in a Python unit.</dsc>

<prms>

<n>ModuleId</n>

<dsc>Identifier of Python unit in the repository.</dsc>

</prms>

<prms>

<n>FunctionName</n>

<dsc>Name of executed function.</dsc>

</prms>

<prms>

<n>Param</n>

<dsc>Parameters sent to function.</dsc>

</prms>

</fns>

</cts>

<fns>

<n>JavaInvoke</n>

<dsc>Returns the result of executing a static Java method.</dsc>

<prms>

<n>ClassName</n>

<dsc>Name of Java class in the file system (the file with the *.class extension) or system class name in the JNI signature.</dsc>

</prms>

<prms>

<n>MethodName</n>

<dsc>Name of executed method.</dsc>

</prms>

<prms>

<n>MethodSig</n>

<dsc>JNI signature of method.</dsc>

</prms>

<prms>

<n>Param</n>

<dsc>Parameter sent to method.</dsc>

</prms>

</fns>

<fns>

<n>JavaInvokeModule</n>

<dsc>Returns the result of executing a static method stored in the Java unit.</dsc>

<prms>

<n>ModuleId</n>

<dsc>Identifier of the Java unit in the repository.</dsc>

</prms>

<prms>

<n>ClassName</n>

<dsc>Class name.</dsc>

</prms>

<prms>

<n>MethodName</n>

<dsc>Name of executed method.</dsc>

</prms>

<prms>

<n>MethodSig</n>

<dsc>JNI signature of method.</dsc>

</prms>

<prms>

<n>Param</n>

<dsc>Parameter sent to method.</dsc>

</prms>

</fns>

</cts>

</GetTabStaticFormulasResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "GetTabStaticFormulas" : ""
}

JSON response:

{
 "GetTabStaticFormulasResult" : 
  {
   "cts" : 
    [
      {
       "n" : "Mathematical",
       "fns" : 
        [
          {
           "n" : "Abs",
           "dsc" : "Returns modulus (absolute value) of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Real number, which absolute value should be found."
            }
          },
          {
           "n" : "ACos",
           "dsc" : "Returns arccosine of number. Angle is determined in radians in the interval from 0 to Pi.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Cosine of required angle, which value should be in the range from -1 to 1."
            }
          },
          {
           "n" : "ACosH",
           "dsc" : "Returns hyperbolic arccosine of number. The number should be greater or equal to 1.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number that is greater or equal to 1."
            }
          },
          {
           "n" : "ACot",
           "dsc" : "Returns arccotangent of number. Angle is determined in radians in the interval from 0 to Pi.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Cotangent of required angle."
            }
          },
          {
           "n" : "ACotH",
           "dsc" : "Returns hyperbolic arccotangent of number. The number should be leas than -1 or greater than 1.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number that is less than -1 or greater than 1."
            }
          },
          {
           "n" : "Aggregate",
           "dsc" : "Returns aggregation result with the specified method with the ability not to take into account hidden values (rows\/columns) during the calculation.",
           "prms" : 
            [
              {
               "n" : "Function number",
               "dt" : "2",
               "dsc" : "Specifies which function to use during the calculation."
              },
              {
               "n" : "Link",
               "dt" : "5",
               "dsc" : "Named range or link, for which function should be calculated.",
               "ext" : "1"
              }
            ]
          },
          {
           "n" : "ASin",
           "dsc" : "Returns arcsine of number. Angle is determined in radians in the intervals from Pi\/2 to Pi\/2.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Sine of required angle, value should be in the range from -1 to 1."
            }
          },
          {
           "n" : "ASinH",
           "dsc" : "Returns hyperbolic arcsine of number. The number should be greater or equal to 1.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number that is greater or equal to 1."
            }
          },
          {
           "n" : "ATan",
           "dsc" : "Returns arctangent of number. Angle is determined in radians in the range from Pi\/2 to Pi\/2.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Tangent of required angle."
            }
          },
          {
           "n" : "ATan2",
           "dsc" : "Returns arctangent for specified coordinates x and y, in radians between -Pi and Pi, excluding -Pi.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "2",
               "dsc" : "X coordinate of point."
              },
              {
               "n" : "Y",
               "dt" : "2",
               "dsc" : "Y coordinate of point."
              }
            ]
          },
          {
           "n" : "ATanH",
           "dsc" : "Returns hyperbolic arctangent of number. The number should be in the interval from -1 to 1 (excluding -1 and 1).",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number strictly between -1 and 1 (excluding -1 and 1)."
            }
          },
          {
           "n" : "Average",
           "dsc" : "Returns average value for array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which average value should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "AverageIf",
           "dsc" : "Returns average value of cells that satisfy the specified condition. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of checked cells."
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines cells, for which average value will be calculated."
              },
              {
               "n" : "Average_Range",
               "dt" : "5",
               "dsc" : "Actual cells, for which average value will be calculated. If Average_range is not specified, cells passed by the Range parameter will be used.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "AverageIfS",
           "dsc" : "Returns average value of the cells that satisfy the specified set of conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "Average_Range",
               "dt" : "5",
               "dsc" : "Actual cells, for which average value will be calculated."
              },
              {
               "n" : "Range1",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition."
              },
              {
               "n" : "Criteria1",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines cells, for which average value will be calculated."
              },
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition.",
               "ext" : "1",
               "nf" : "2"
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines the cells, for which average number will be calculated.",
               "ext" : "1",
               "nf" : "2"
              }
            ]
          },
          {
           "n" : "Ceiling",
           "dsc" : "Rounds number to the nearest integer or the nearest number that is multiple of the specified value.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Rounded value."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Multiple, to which value should be rounded."
              }
            ]
          },
          {
           "n" : "Combin",
           "dsc" : "Returns the number of combinations for the specified number of objects.",
           "prms" : 
            [
              {
               "n" : "SetSize",
               "dt" : "2",
               "dsc" : "Number of elements (greater than 0)."
              },
              {
               "n" : "SampleSize",
               "dt" : "2",
               "dsc" : "Number of objects in each combination (greater than 0 and less or equal to SetSize)."
              }
            ]
          },
          {
           "n" : "Cos",
           "dsc" : "Returns cosine of number.",
           "prms" : 
            {
             "n" : "Angle",
             "dt" : "2",
             "dsc" : "Angle in radians, for which cosine is to be determined."
            }
          },
          {
           "n" : "CosH",
           "dsc" : "Returns hyperbolic cosine of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number that is greater or equal to 1."
            }
          },
          {
           "n" : "Cot",
           "dsc" : "Returns cotangent of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Angle in radians, for which cotangent is to be determined."
            }
          },
          {
           "n" : "CotH",
           "dsc" : "Returns hyperbolic cotangent of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Any real number."
            }
          },
          {
           "n" : "Count",
           "dsc" : "Returns the number of elements in array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which the number of values should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "CountIf",
           "dsc" : "Returns the number of cells that satisfy the specified condition. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of checked cells."
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines which cells should be taken into account."
              }
            ]
          },
          {
           "n" : "CountIfS",
           "dsc" : "Applies conditions to cells in several ranges and calculates the number of correspondences to all conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "Range1",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition."
              },
              {
               "n" : "Criteria1",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines which cells should be taken into account."
              },
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition.",
               "ext" : "1",
               "nf" : "2"
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines which cells should be taken into account.",
               "ext" : "1",
               "nf" : "2"
              }
            ]
          },
          {
           "n" : "Degrees",
           "dsc" : "Transforms radians into degrees.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Angle in radians transformed into degrees."
            }
          },
          {
           "n" : "Even",
           "dsc" : "Rounds number to the nearest even integer. Positive numbers are rounded up, negative numbers are rounded down.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Rounded value."
            }
          },
          {
           "n" : "Exp",
           "dsc" : "Returns number exponent.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Power, to which the e number should be raised."
            }
          },
          {
           "n" : "Fact",
           "dsc" : "Returns number factorial.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Non-negative number, which factorial is calculated."
            }
          },
          {
           "n" : "Floor",
           "dsc" : "Rounds number to the nearest integer that is least by module.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Rounded value."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Multiple, to which value should be rounded."
              }
            ]
          },
          {
           "n" : "Gcd",
           "dsc" : "Returns the greatest common divisor.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, the greatest common divisor of which should be found.",
             "ext" : "1"
            }
          },
          {
           "n" : "Int",
           "dsc" : "Rounds number to the nearest least integer.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Real number rounded to the nearest least integer."
            }
          },
          {
           "n" : "Lcm",
           "dsc" : "Returns the least common multiple.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which the least common multiple is determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "Ln",
           "dsc" : "Returns natural logarithm of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Number, for which natural algorithm is calculated."
            }
          },
          {
           "n" : "Log",
           "dsc" : "Returns logarithm of number by the specified base.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Number, for which logarithm is calculated."
              },
              {
               "n" : "Base",
               "dt" : "2",
               "dsc" : "Logarithm base."
              }
            ]
          },
          {
           "n" : "Log10",
           "dsc" : " Returns base-10 logarithm of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Number, for which base-10 logarithm is calculated."
            }
          },
          {
           "n" : "Max",
           "dsc" : "Returns maximum number in range of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which maximum number should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "MDeterm",
           "dsc" : "Returns determinant of matrix stored in array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells with equal number of rows and columns."
            }
          },
          {
           "n" : "Min",
           "dsc" : "Returns minimum number in array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which minimum number should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "MInverse",
           "dsc" : "Returns inverse matrix (matrix is stored in array of cells).",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells with equal number of rows and columns."
            }
          },
          {
           "n" : "MMult",
           "dsc" : "Returns matrix product. The result is an array with the same number of rows as A1 and with the same number of columns as A2.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "Range of cells containing only numbers."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Range of cells containing only numbers."
              }
            ]
          },
          {
           "n" : "Mod_",
           "dsc" : "Returns the remainder of a division of a number to divisor. The result is the same as the dividend.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Number, which division remainder is determined."
              },
              {
               "n" : "Divisor",
               "dt" : "2",
               "dsc" : "Divisor."
              }
            ]
          },
          {
           "n" : "MRound",
           "dsc" : "Returns the number rounded with the required precision.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Rounded value."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Precision, with which the number should be rounded."
              }
            ]
          },
          {
           "n" : "Multinomial",
           "dsc" : "Returns relation of factorial of sum of values to product of factorials.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which values the multinomial coefficient is determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "Odd",
           "dsc" : "Rounds number to the nearest uneven integer. Positive numbers are rounded up, negative numbers are rounded down.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Rounded value."
            }
          },
          {
           "n" : "Power",
           "dsc" : "Returns result of raising real number to real power.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Power base."
              },
              {
               "n" : "Power",
               "dt" : "2",
               "dsc" : "Indicator of the power, to which base is raised."
              }
            ]
          },
          {
           "n" : "Product",
           "dsc" : "Returns product of values of array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells containing multiplied numbers.",
             "ext" : "1"
            }
          },
          {
           "n" : "Quotient",
           "dsc" : "Returns integer potion of division with remainder. This function is used when the remainder should be taken from division.",
           "prms" : 
            [
              {
               "n" : "Nominator",
               "dt" : "2",
               "dsc" : "Dividend."
              },
              {
               "n" : "Denominator",
               "dt" : "2",
               "dsc" : "Divisor that is equal to zero."
              }
            ]
          },
          {
           "n" : "Radians",
           "dsc" : "Transforms degrees to radians.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Value of angle in degrees that should be transformed."
            }
          },
          {
           "n" : "Rand",
           "dsc" : "Returns uniformly distributed random number that is greater or equal to 0 and less than 1."
          },
          {
           "n" : "RandBetween",
           "dsc" : "Returns random number between two specified numbers.",
           "prms" : 
            [
              {
               "n" : "TopValue",
               "dt" : "2",
               "dsc" : "The least number returned by the RandBetween function."
              },
              {
               "n" : "BottomValue",
               "dt" : "2",
               "dsc" : "The greatest number returned by the RandBetween function."
              }
            ]
          },
          {
           "n" : "Roman",
           "dsc" : "Transforms Arabic number into Roman one, as text.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Transformed Arabic number."
              },
              {
               "n" : "Form",
               "dt" : "2",
               "dsc" : "Internal service parameter. Value of this parameter does not affect the final result."
              }
            ]
          },
          {
           "n" : "Round",
           "dsc" : "Rounds number to the specified number of decimal spaces.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Rounded value."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Number of decimal spaces, to which the number should be rounded. Precision > 0 - it is rounded to the specified number of decimal spaces to the right. Precision = 0 - it is rounded to the nearest integer. Precision < 0 - it is rounded to the left of the decimal point."
              }
            ]
          },
          {
           "n" : "RoundDown",
           "dsc" : "Rounds number to the nearest value that is least by module.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Any real number that should be rounded down."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Number of decimal spaces, to which the number should be rounded. Precision > 0 - it is rounded to the specified number of decimal spaces to the right. Precision = 0 - it is rounded to the nearest integer. Precision < 0 - it is rounded to the left of the decimal point."
              }
            ]
          },
          {
           "n" : "RoundUp",
           "dsc" : "Rounds number to the nearest value that is that is greatest by module.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Any real number that should be rounded up."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Number of decimal spaces, to which the number should be rounded. Precision > 0 - it is rounded to the specified number of decimal spaces to the right. Precision = 0 - it is rounded to the nearest integer. Precision < 0 - it is rounded to the left of the decimal point."
              }
            ]
          },
          {
           "n" : "SeriesSum",
           "dsc" : "Returns sum of power series.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "2",
               "dsc" : "Value of power series variable."
              },
              {
               "n" : "Power",
               "dt" : "2",
               "dsc" : "Index of the X power for the first member of the power series."
              },
              {
               "n" : "Step",
               "dt" : "2",
               "dsc" : "Step, by which the index of the Power power is increased for each next member of the power series.
              },
              {
               "n" : "Coefficients",
               "dt" : "5",
               "dsc" : "Range of cells, which values determine a set of coefficients at corresponding X powers."
              }
            ]
          },
          {
           "n" : "Sign",
           "dsc" : "Determines number sign. Returns 1 if the number is positive; returns 0 if the number is equal to 0; returns -1 if the number is negative.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Real number."
            }
          },
          {
           "n" : "Sin",
           "dsc" : "Returns sine of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Angle in radians, for which sine is calculated."
            }
          },
          {
           "n" : "SinH",
           "dsc" : "Returns hyperbolic sine of number.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Real number."
            }
          },
          {
           "n" : "Sqrt",
           "dsc" : "Returns positive value of square root.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Number, for which square root is calculated."
            }
          },
          {
           "n" : "SqrtPi",
           "dsc" : "Returns square root from expression value (number * Pi).",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Number that is multiplied by Pi."
            }
          },
          {
           "n" : "Sum",
           "dsc" : "Sums real numbers in array of cells.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which total or sum should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "Sumif",
           "dsc" : "Sums cells that are set with the specified condition.

All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of checked cells."
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines summed cells."
              },
              {
               "n" : "SumRange",
               "dt" : "5",
               "dsc" : "Actual cells for summation. If SumRange is not specified, cell that are set by the Range parameter will be used",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "SumIfS",
           "dsc" : "Sums cells that satisfy the specified set of conditions. All text conditions and conditions with logical and mathematical signs should be enclosed in double quotation marks (").",
           "prms" : 
            [
              {
               "n" : "SumRange",
               "dt" : "5",
               "dsc" : "Actual cells for summation."
              },
              {
               "n" : "Range1",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition."
              },
              {
               "n" : "Criteria1",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines summed cells."
              },
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Range of cells checked for correspondence with the specified condition.",
               "ext" : "1",
               "nf" : "2"
              },
              {
               "n" : "Criteria",
               "dt" : "5",
               "dsc" : "Condition as a number, expression, link to cell, text or function that determines summed cells.",
               "ext" : "1",
               "nf" : "2"
              }
            ]
          },
          {
           "n" : "SumSq",
           "dsc" : "Returns sum of squares of arguments.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Range of cells, for which sum of squares should be determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "SumX2MY2",
           "dsc" : "Returns sum of differences of squares of corresponding values in two arrays.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "5",
               "dsc" : "The first array of cells."
              },
              {
               "n" : "Y",
               "dt" : "5",
               "dsc" : "The second array of cells."
              }
            ]
          },
          {
           "n" : "SumX2PY2",
           "dsc" : "Returns sum of sums of squares of corresponding elements in two arrays.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "5",
               "dsc" : "The first array of cells."
              },
              {
               "n" : "Y",
               "dt" : "5",
               "dsc" : "The second array of cells."
              }
            ]
          },
          {
           "n" : "SumXMY2",
           "dsc" : "Returns sum of squares of differences of corresponding values in two arrays.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "5",
               "dsc" : "The first array of cells."
              },
              {
               "n" : "Y",
               "dt" : "5",
               "dsc" : "The second array of cells."
              }
            ]
          },
          {
           "n" : "Tan",
           "dsc" : "Returns tangent of angle.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Angle in radians, for which tangent is determined."
            }
          },
          {
           "n" : "TanH",
           "dsc" : "Returns hyperbolic tangent.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Real number."
            }
          },
          {
           "n" : "Trunc",
           "dsc" : "Truncates number to the specified number of decimal spaces.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Truncated number."
              },
              {
               "n" : "Precision",
               "dt" : "2",
               "dsc" : "Number of decimal spaces that determines truncation precision. Negative numbers cause truncation of integer part, zero causes truncation to the integer number (0 by default)",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "RndPermutation",
           "dsc" : "Returns the array that is a random relocation of another array, which elements are integer numbers from 1 to value of passed parameter.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Size of required array, the greatest value in it."
            }
          },
          {
           "n" : "RndSample",
           "dsc" : "Returns random sampling of M elements from the array, which elements are integer numbers from 1 to N.",
           "prms" : 
            [
              {
               "n" : "N",
               "dt" : "2",
               "dsc" : "Size of array used for sampling."
              },
              {
               "n" : "M",
               "dt" : "2",
               "dsc" : "Size of sampling."
              }
            ]
          }
        ]
      },
      {
       "n" : "Links and arrays",
       "fns" : 
        [
          {
           "n" : "VLookUp",
           "dsc" : "Searches for value in the leftmost table column and returns value of the cell located in the specified row and in the same column.",
           "prms" : 
            [
              {
               "n" : "LookupValue ",
               "dt" : "5",
               "dsc" : "Value used in search of the required value in array – it can be a number, text or logical value, or a link to one of these types."
              },
              {
               "n" : "TableArray ",
               "dt" : "5",
               "dsc" : "Range of cells, in which search is executed."
              },
              {
               "n" : "ColumnIndexNum ",
               "dt" : "5",
               "dsc" : "Column number in the range, from which the compared value should be returned, column numbering starts from 1"
              },
              {
               "n" : "RangeLookup ",
               "dt" : "4",
               "dsc" : "Indicates how search should be executed: true (default) – fuzzy, false – exact.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "HLookUp",
           "dsc" : "Searches for value in the first table column and returns value of the cell located in the specified row and in the same column.",
           "prms" : 
            [
              {
               "n" : "LookupValue ",
               "dt" : "5",
               "dsc" : "Value that should be found in the first table row – it can be a number, text, or logical value, or a link to one of these types."
              },
              {
               "n" : "TableArray ",
               "dt" : "5",
               "dsc" : "Range of cells, in which search is executed."
              },
              {
               "n" : "RowIndexNum ",
               "dt" : "5",
               "dsc" : "Number of the row in the range, from which the compared value should be returned, row numbering starts from 1"
              },
              {
               "n" : "RangeLookup ",
               "dt" : "4",
               "dsc" : "Indicates how search should be executed: true (default) – fuzzy, false – exact.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Match",
           "dsc" : "Searches for the specified element in the cell range and returns relative position of this element in the range.",
           "prms" : 
            [
              {
               "n" : "LookupValue ",
               "dt" : "5",
               "dsc" : "Value used in search of the required value in array – it can be a number, text or logical value, or a link to one of these types."
              },
              {
               "n" : "LookupArray ",
               "dt" : "5",
               "dsc" : "Range of cells, in which search is executed."
              },
              {
               "n" : "MatchType ",
               "dt" : "5",
               "dsc" : "Indicates how searched value is compared with values in the cell range: 1 or omitted (default value) – function finds the greatest value that is less or equal to the searched value, in this case the cell range should be sorted ascending; 0 – function finds the first value that is equal to the searched value, in this case the cell range may be unsorted; -1 – function finds the least value that is greater or equal to the searched value, in this case the cell range should be sorted descending.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Offset",
           "dsc" : "Get link to range shifted relative to the specified link to the specified number of rows and columns.",
           "prms" : 
            [
              {
               "n" : "Range",
               "dt" : "5",
               "dsc" : "Link to the cell or range, from which shift is calculated."
              },
              {
               "n" : "RowCount",
               "dt" : "2",
               "dsc" : "Number of rows up or down, for which the output link range is shifted relative to the source link range."
              },
              {
               "n" : "ColumnCount",
               "dt" : "2",
               "dsc" : "Number of columns to the left or to the right, for which the output link range is shifted relative to the source link range."
              },
              {
               "n" : "Height",
               "dt" : "2",
               "dsc" : "Height of returned range in cells. Optional parameter.",
               "o" : "1"
              },
              {
               "n" : "Width",
               "dt" : "2",
               "dsc" : "Width of returned range in cells. Optional parameter.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Range",
           "dsc" : "Get range by link.",
           "prms" : 
            {
             "n" : "Address",
             "dt" : "5",
             "dsc" : "Range address."
            }
          },
          {
           "n" : "Rng",
           "dsc" : "Get range by link to cell.",
           "prms" : 
            {
             "n" : "Address",
             "dt" : "5",
             "dsc" : "Cell address."
            }
          }
        ]
      },
      {
       "n" : "Date and time",
       "fns" : 
        [
          {
           "n" : "Date",
           "dsc" : "Returns date by the specified year, month and day.",
           "prms" : 
            [
              {
               "n" : "Year",
               "dt" : "2",
               "dsc" : "Year."
              },
              {
               "n" : "Month",
               "dt" : "2",
               "dsc" : "Month."
              },
              {
               "n" : "Day",
               "dt" : "2",
               "dsc" : "Day."
              }
            ]
          },
          {
           "n" : "DateValue",
           "dsc" : "Converts row to date.",
           "prms" : 
            {
             "n" : "Date_text",
             "dt" : "5",
             "dsc" : "Row with date."
            }
          },
          {
           "n" : "Day",
           "dsc" : "Returns number of day in month.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Edate",
           "dsc" : "Adds\/subtracts the specified number of months from date.",
           "prms" : 
            [
              {
               "n" : "Date",
               "dt" : "3",
               "dsc" : "Date."
              },
              {
               "n" : "Months",
               "dt" : "2",
               "dsc" : "Number of months."
              }
            ]
          },
          {
           "n" : "Hour",
           "dsc" : "Returns hours as a number in the range from 0 to 23.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Minute",
           "dsc" : "Returns minutes as a number in the range from 0 to 59.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Month",
           "dsc" : "Returns month as a number from 1 (January) to 12 (December).",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Now",
           "dsc" : "Returns the current date and time."
          },
          {
           "n" : "Second",
           "dsc" : "Returns seconds as a number in the range from 0 to 59.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Time",
           "dsc" : "Converts hours, minutes, and seconds specified in the number format to date.",
           "prms" : 
            [
              {
               "n" : "Hour",
               "dt" : "2",
               "dsc" : "Hours."
              },
              {
               "n" : "Minute",
               "dt" : "2",
               "dsc" : "Minutes."
              },
              {
               "n" : "Second",
               "dt" : "2",
               "dsc" : "Seconds."
              }
            ]
          },
          {
           "n" : "TimeValue",
           "dsc" : "Converts string value to the TimeSpan type.",
           "prms" : 
            {
             "n" : "Date_text",
             "dt" : "5",
             "dsc" : "String should have the following format: <Number of days>.<Number of hours>:<Number of minutes>:<Number of seconds>.<Number of milliseconds>."
            }
          },
          {
           "n" : "Today",
           "dsc" : "Returns the current date."
          },
          {
           "n" : "Weekday",
           "dsc" : "Returns week day number from 1 to 7 by the specified date.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          },
          {
           "n" : "Year",
           "dsc" : "Returns year by the specified date.",
           "prms" : 
            {
             "n" : "Date",
             "dt" : "3",
             "dsc" : "Date."
            }
          }
        ]
      },
      {
       "n" : "Text",
       "fns" : 
        [
          {
           "n" : "Concatenate",
           "dsc" : "Combines several rows into one.",
           "prms" : 
            [
              {
               "n" : "Text1",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined."
              },
              {
               "n" : "Text2",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined."
              },
              {
               "n" : "Text3",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text4",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text5",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text6",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text7",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text8",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text9",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              },
              {
               "n" : "Text10",
               "dt" : "5",
               "dsc" : "Text1, Text2… - rows to be combined.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Exact",
           "dsc" : "Check the full match of two rows (check is case-sensitive).",
           "prms" : 
            [
              {
               "n" : "Text1",
               "dt" : "5",
               "dsc" : "First row."
              },
              {
               "n" : "Text2",
               "dt" : "5",
               "dsc" : "Second row."
              }
            ]
          },
          {
           "n" : "Find",
           "dsc" : "Returns position of one row in the other. Search is case-sensitive.",
           "prms" : 
            [
              {
               "n" : "Find_text",
               "dt" : "5",
               "dsc" : "Text to find."
              },
              {
               "n" : "Within_text",
               "dt" : "5",
               "dsc" : "Row used in search."
              },
              {
               "n" : "Start_num",
               "dt" : "2",
               "dsc" : "Position, from which search starts.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Fixed",
           "dsc" : "Rounds the number to the specified number of decimal places and returns result as a string with or without thousands separators.",
           "prms" : 
            [
              {
               "n" : "Number",
               "dt" : "2",
               "dsc" : "Number that should e rounded and converted to text."
              },
              {
               "n" : "Decimals",
               "dt" : "2",
               "dsc" : "Number of decimal places (2 by default).",
               "o" : "1"
              },
              {
               "n" : "No_commas",
               "dt" : "5",
               "dsc" : "Do not display thousands separators in the returned value (TRUE by default).",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Left",
           "dsc" : "Returns the specified number of characters from the beginning of the row.",
           "prms" : 
            [
              {
               "n" : "Text",
               "dt" : "5",
               "dsc" : "Source row, from which characters are extracted."
              },
              {
               "n" : "Num_chars",
               "dt" : "2",
               "dsc" : "Number of characters that should be extracted (1 by default)",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Len",
           "dsc" : "Returns the number of characters in text row.",
           "prms" : 
            {
             "n" : "Text",
             "dt" : "5",
             "dsc" : "Row, which length should be calculated."
            }
          },
          {
           "n" : "Lower",
           "dsc" : "Converts all row characters to lower case.",
           "prms" : 
            {
             "n" : "Text",
             "dt" : "5",
             "dsc" : "Row converted to lower case."
            }
          },
          {
           "n" : "Mid",
           "dsc" : "Converts subrow from row by the specified start position and length.",
           "prms" : 
            [
              {
               "n" : "Text",
               "dt" : "5",
               "dsc" : "Row, from which subrow should be extracted."
              },
              {
               "n" : "Start_num",
               "dt" : "2",
               "dsc" : "Start position of subrow."
              },
              {
               "n" : "Num_chars",
               "dt" : "2",
               "dsc" : "Number of characters."
              }
            ]
          },
          {
           "n" : "Replace",
           "dsc" : "Replaces part of one row with other row.",
           "prms" : 
            [
              {
               "n" : "Old_text",
               "dt" : "5",
               "dsc" : "Row, in which replacement should be made."
              },
              {
               "n" : "Start_num",
               "dt" : "2",
               "dsc" : "Position of character in source row, from which replacement should be started."
              },
              {
               "n" : "Num_chars",
               "dt" : "2",
               "dsc" : "Number of characters in source row that should be replaced."
              },
              {
               "n" : "New_text",
               "dt" : "5",
               "dsc" : "Replacement row."
              }
            ]
          },
          {
           "n" : "Rept",
           "dsc" : "Repeats row the specified number of times.",
           "prms" : 
            [
              {
               "n" : "Text",
               "dt" : "5",
               "dsc" : "Text that should be repeated."
              },
              {
               "n" : "Number_times",
               "dt" : "2",
               "dsc" : "Number of times that the specified test should be repeated."
              }
            ]
          },
          {
           "n" : "Right",
           "dsc" : "Returns the specified number of characters from the end of the row.",
           "prms" : 
            [
              {
               "n" : "Text",
               "dt" : "5",
               "dsc" : "Source row."
              },
              {
               "n" : "Num_chars",
               "dt" : "2",
               "dsc" : "Number of characters (1 by default).",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "_T",
           "dsc" : "Determines whether value can be converted to string type. If yes, it returns text, if no, it returns the empty row.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "0",
             "dsc" : "Checked value."
            }
          },
          {
           "n" : "Trim",
           "dsc" : "Removes spaces at the beginning and at the end of the row.",
           "prms" : 
            {
             "n" : "Text",
             "dt" : "5",
             "dsc" : "The row, in which extra spaces should be removed."
            }
          },
          {
           "n" : "Upper",
           "dsc" : "Converts row to upper case.",
           "prms" : 
            {
             "n" : "Text",
             "dt" : "5",
             "dsc" : "The row that should be converted to upper case."
            }
          },
          {
           "n" : "Value",
           "dsc" : "Converts text view of number to number type.",
           "prms" : 
            {
             "n" : "Text",
             "dt" : "5",
             "dsc" : "Text view of number that should be converted."
            }
          }
        ]
      },
      {
       "n" : "Work with report",
       "fns" : 
        [
          {
           "n" : "GetSelection",
           "dsc" : "Get slice selection in string format.",
           "prms" : 
            [
              {
               "n" : "Data source",
               "dt" : "5",
               "dsc" : "Number or identifier of data source."
              },
              {
               "n" : "Slice",
               "dt" : "5",
               "dsc" : "Number or name of slice."
              },
              {
               "n" : "Dimension",
               "dt" : "5",
               "dsc" : "Number, name or identifier of slice dimension."
              },
              {
               "n" : "Format",
               "dt" : "1",
               "dsc" : "Format applied to get dimension element text.",
               "o" : "1"
              },
              {
               "n" : "Separator",
               "dt" : "1",
               "dsc" : "Separator used for separating elements names from each other.",
               "o" : "1"
              },
              {
               "n" : "Combine ranges",
               "dt" : "4",
               "dsc" : "Indicates whether continuous elements in range are combined.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "GetSelectionEl",
           "dsc" : "Get selected slice element.",
           "prms" : 
            [
              {
               "n" : "Data source",
               "dt" : "5",
               "dsc" : "Number or identifier of data source."
              },
              {
               "n" : "Slice",
               "dt" : "5",
               "dsc" : "Number or name of slice."
              },
              {
               "n" : "Dimension",
               "dt" : "5",
               "dsc" : "Number, name or identifier of slice dimension."
              },
              {
               "n" : "Element number",
               "dt" : "2",
               "dsc" : "Number of element in selection, which name should be obtained (the first by default).",
               "o" : "1"
              }
            ]
          }
        ]
      },
      {
       "n" : "Financial",
       "fns" : 
        [
          {
           "n" : "Accrint",
           "dsc" : "Returns accrued interest for securities with periodic interest payments.",
           "prms" : 
            [
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Securities issuance date. The value should satisfy the constraint: Issue < Settlement."
              },
              {
               "n" : "FirstInterest",
               "dt" : "3",
               "dsc" : "Date of the first payment for securities."
              },
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Annual percentage rate for securities coupons. The value should satisfy the constraint: Rate > 0."
              },
              {
               "n" : "NominalCost",
               "dt" : "2",
               "dsc" : "Face value of securities. The value should satisfy the constraint: NominalCost > 0.",
               "o" : "1"
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4.",
               "o" : "1"
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "AccrintM",
           "dsc" : "Returns accrued interest for securities that pay interest on maturity date.",
           "prms" : 
            [
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Securities issuance date. The value should satisfy the constraint: Issue < Settlement."
              },
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Annual percentage rate for securities coupons. The value should satisfy the constraint: Rate > 0."
              },
              {
               "n" : "NominalCost",
               "dt" : "2",
               "dsc" : "Face value of securities. The value should satisfy the constraint: NominalCost > 0.",
               "o" : "1"
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "AmorDegrC",
           "dsc" : "Returns depreciation value for each period. This function is used for French accounting system. If an asset is purchased in the middle of an accounting period, the proportional amount of depreciation is taken into account. This function is similar to the AmorLinC function, except for the fact that the depreciation coefficient used in calculations depends on the asset depreciation period.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset value."
              },
              {
               "n" : "PurchaseDate",
               "dt" : "3",
               "dsc" : "Date of asset acquisition."
              },
              {
               "n" : "FirstPeriodEnd",
               "dt" : "3",
               "dsc" : "Date of first period end."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Residual value of asset at the end of depreciation period."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period. The value should satisfy the constraint: Period > 0.",
               "o" : "1"
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Depreciation rate. The value should satisfy the constraint: Rate > 0.",
               "o" : "1"
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "AmorLinC",
           "dsc" : "Returns depreciation value for each period. This function is used for French accounting system. If the asset is acquired in the middle of the accounting period, prorated depreciation is taken into account.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset value."
              },
              {
               "n" : "PurchaseDate",
               "dt" : "3",
               "dsc" : "Date of asset acquisition."
              },
              {
               "n" : "FirstPeriodEnd",
               "dt" : "3",
               "dsc" : "Date of first period end."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Residual value of asset at the end of depreciation period."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period. The value should satisfy the constraint: Period > 0.",
               "o" : "1"
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Depreciation rate. The value should satisfy the constraint: Rate > 0.",
               "o" : "1"
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupDayBs",
           "dsc" : "Returns the number of days before coupon commencement until the agreement date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual securities is equal to 1; for semi-annual securities - 2; for quarterly securities - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupDays",
           "dsc" : "Returns the number of days in the coupon period containing settlement date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupDaysNc",
           "dsc" : "Returns the number of days from settlement date to the next coupon term.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupNcd",
           "dsc" : "Returns the number that is the next coupon date after the settlement date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupNum",
           "dsc" : "Returns the number of coupons that can be paid between the settlement date and the maturity date  rounded to the nearest integer number of coupons.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CoupPcd",
           "dsc" : "Returns the number corresponding to the previous coupon date before settlement date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "CumIpmt",
           "dsc" : "Returns cumulative (running total) interest value paid on the loan between two periods of payments.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of periods of payments."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Investment cost at the moment."
              },
              {
               "n" : "StartPeriod",
               "dt" : "2",
               "dsc" : " Number of the first period included into calculations. Numbering of payment periods starts from 1."
              },
              {
               "n" : "EndPeriod",
               "dt" : "2",
               "dsc" : "Number of the last period included into calculations."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Cumprinc",
           "dsc" : "Returns cumulative (running total) sum paid in satisfaction of principal loan amount between two periods.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of periods of payments."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Investment cost at the moment."
              },
              {
               "n" : "StartPeriod",
               "dt" : "2",
               "dsc" : " Number of the first period included into calculations. Numbering of payment periods starts from 1."
              },
              {
               "n" : "EndPeriod",
               "dt" : "2",
               "dsc" : "Number of the last period included into calculations."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Db",
           "dsc" : "Returns asset depreciation value for the specified period calculated by fixed margin reduction method.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset acquisition costs."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Cost at the end of depreciation period."
              },
              {
               "n" : "Life",
               "dt" : "2",
               "dsc" : "Number of periods, during which the property is depreciated."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period, for which depreciation should be calculated. The period should be in the same units as Life."
              },
              {
               "n" : "Month",
               "dt" : "2",
               "dsc" : "Number of months in the first year (12 by default).",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Ddb",
           "dsc" : "Returns asset depreciation value for the specified period using double margin reduction method or other explicitly specified method.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset acquisition costs."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Cost at the end of depreciation period."
              },
              {
               "n" : "Life",
               "dt" : "2",
               "dsc" : "Number of periods, during which the property is depreciated."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period, for which depreciation should be calculated. The period should be in the same units as Life."
              },
              {
               "n" : "Factor",
               "dt" : "2",
               "dsc" : "Interest rate of declining balance (2 by default).",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Disc",
           "dsc" : "Returns discount rate for securities.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Nominal",
               "dt" : "2",
               "dsc" : "Price for $100 face value of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption price per $100 face value of securities."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "DollarFr",
           "dsc" : "Converts dollar price expressed as a decimal value into dollar price as a fraction. The DollarFr function is used to convert decimal numbers, for example, cost of securities into fractional prices.",
           "prms" : 
            [
              {
               "n" : "DecimalValue",
               "dt" : "2",
               "dsc" : "Decimal number. The value should satisfy the constraint: DecimalValue >= 0."
              },
              {
               "n" : "Fraction",
               "dt" : "2",
               "dsc" : "Integer that should be used as a denominator. The value should satisfy the constraint: Fraction <> 0."
              }
            ]
          },
          {
           "n" : "Duration",
           "dsc" : "Returns Macaulay duration for assumed $100 face value. The duration is determined as a weighted average of present value of cash flows and is used as a measure of reaction of bonds cost to change in yield.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Coupon",
               "dt" : "2",
               "dsc" : "Annual interest rate for securities coupons."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "mandatory argument. The number of payments for coupons in a year. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "DollarDe",
           "dsc" : "Converts dollar price expressed as a fraction to dollar price expressed as a decimal value. The DollarDe function is used to convert fractional values of monetary amounts, for example, securities cost, into a decimal number.",
           "prms" : 
            [
              {
               "n" : "FractionValue",
               "dt" : "2",
               "dsc" : "Number expressed as fraction. The value should satisfy the constraint: FractionValue >= 0."
              },
              {
               "n" : "Fraction",
               "dt" : "2",
               "dsc" : "Integer that should be used as a denominator. The value should satisfy the constraint: Fraction <> 0."
              }
            ]
          },
          {
           "n" : "Effect",
           "dsc" : "Returns effective (actual) annual interest rate if there are set nominal annual interest rate and the number of year periods, for which compound interest is accrued.",
           "prms" : 
            [
              {
               "n" : "NominalRate",
               "dt" : "2",
               "dsc" : "Nominal annual rate. The value should satisfy the constraint: NominalRate > 0."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "Number of year periods, for which compound percent is accrued. The value should satisfy the constraint: PeriodCount >= 1."
              }
            ]
          },
          {
           "n" : "Fv",
           "dsc" : "It returns future investment cost based on periodic constant (sums equal in amount) payments and fixed interest rate.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for period."
              },
              {
               "n" : "PaymentCount",
               "dt" : "2",
               "dsc" : "General number of annuity payment periods."
              },
              {
               "n" : "PeriodPayment",
               "dt" : "2",
               "dsc" : "Payment for each period."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Present cost at the current moment or general sum that is currently equal to the series of future payments."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "FvSchedule",
           "dsc" : "Returns future cost of the initial main sum after applying a series (plan) of compound interest rates. The function is used to calculate the future investment cost with variable interest rate.",
           "prms" : 
            [
              {
               "n" : "Principal",
               "dt" : "2",
               "dsc" : "Investment cost at the moment."
              },
              {
               "n" : "Schedule",
               "dt" : "5",
               "dsc" : "Array of applied interest rates."
              }
            ]
          },
          {
           "n" : "Intrate",
           "dsc" : "Returns interest rate for fully invested securities.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "Investment",
               "dt" : "2",
               "dsc" : "Amount of investment in securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Sum that should be obtained a the moment of securities redemption."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Ipmt",
           "dsc" : "Returns the value of investment interest payments for the specified period based on fixed values of periodic payments and fixed interest rate.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for period."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period, for which interest payments should be found."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of annuity rent payment periods."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Present cost at the current moment or general sum that is currently equal to the series of future payments."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Irr",
           "dsc" : "Returns internal rate of return for a number of cash flows presented by their numeric values.",
           "prms" : 
            [
              {
               "n" : "Values",
               "dt" : "5",
               "dsc" : "Array with numbers, for which internal rate of return should be calculated."
              },
              {
               "n" : "Guess",
               "dt" : "2",
               "dsc" : "Value that is assumed to be close to Irr. result",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Ispmt",
           "dsc" : "Calculates interest paid over the specified investment period.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Investment interest rate."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period, for which profit should be calculated."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of payment periods for this investment."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Investment cost at the moment. Interest rate for loan is a loan value."
              }
            ]
          },
          {
           "n" : "MDuration",
           "dsc" : "Returns modified Macaulay duration for securities with assumed $100 face value",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date. This date is later than the issuance date when securities were sold to customer. The value should satisfy the constraint: Settlement < Maturity."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Securities maturity date. This date determines security validity expiration term."
              },
              {
               "n" : "CouponRate",
               "dt" : "2",
               "dsc" : "Annual interest rate for securities coupons."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Mandatory argument. The number of payments for coupons in a year. The frequency for annual payments is equal to 1, for semi-annual — 2, for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "MIrr",
           "dsc" : "Returns internal rate of return for a series of periodic cash flows taking into account investment raising costs and interest obtained from reinversion of monetary assets.",
           "prms" : 
            [
              {
               "n" : "Values",
               "dt" : "5",
               "dsc" : "Array containing numeric values. These numeric values are a series of payoffs (negative values) and inpayments (positive values) made in fixed time periods."
              },
              {
               "n" : "FinanceRate",
               "dt" : "2",
               "dsc" : "Interest rate paid in cash used in cash flows."
              },
              {
               "n" : "ReinvestRate",
               "dt" : "2",
               "dsc" : "Interest rate acquired from cash flows on their reinvestment."
              }
            ]
          },
          {
           "n" : "Nominal",
           "dsc" : "Returns nominal annual rate if there are set effective (actual) rate and the number of year periods, for which compound interest is accrued.",
           "prms" : 
            [
              {
               "n" : "EffectRate",
               "dt" : "2",
               "dsc" : "Actual interest rate."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "Number of year periods, for which compound interest is accrued."
              }
            ]
          },
          {
           "n" : "NPer",
           "dsc" : "Returns general number of payment periods for investment based on fixed periodic payments and fixed interest rate.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for period."
              },
              {
               "n" : "PeriodPayment",
               "dt" : "2",
               "dsc" : "Annual payment; value that cannot change during the entire payment period."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Present cost at the current moment or general sum that is currently equal to the series of future payments."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Npv",
           "dsc" : "Returns value of net present investment using discount rate, and also cost of future payoffs (negative values) and inpayments (positive values).",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Discount rate for one period."
              },
              {
               "n" : "Values",
               "dt" : "5",
               "dsc" : "Array of arguments that are income and expenses."
              }
            ]
          },
          {
           "n" : "OddfPrice",
           "dsc" : "Returns price per $100 face value of securities for an odd (short or long) first period.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date (securities sale date that is later than issuance date)."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Mandatory. The security's maturity date. This date determines when validity of securities expires."
              },
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Date of securities issuance."
              },
              {
               "n" : "FirstCouponDate",
               "dt" : "3",
               "dsc" : "Date of the first coupon payment for securities."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Securities interest rate."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption value of securities for $100 face value."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days."
              }
            ]
          },
          {
           "n" : "OddfYield",
           "dsc" : "Returns yield of securities with an odd (short or long) first period.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date (securities sale date that is later than issuance date)."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Mandatory. The security's maturity date. This date determines when validity of securities expires."
              },
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Date of securities issuance."
              },
              {
               "n" : "FirstCouponDate",
               "dt" : "3",
               "dsc" : "Date of the first coupon payment for securities."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Securities interest rate."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Securities cost."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption value of securities for $100 face value."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days."
              }
            ]
          },
          {
           "n" : "OddlPrice",
           "dsc" : "Returns price per $100 face value for an odd (short or long) last coupon period.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date (securities sale date that is later than issuance date)."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Mandatory. The security's maturity date. This date determines when validity of securities expires."
              },
              {
               "n" : "LastCouponDate",
               "dt" : "3",
               "dsc" : "Date of the last securities coupon payment."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Securities interest rate."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption value of securities for $100 face value."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days."
              }
            ]
          },
          {
           "n" : "OddlYield",
           "dsc" : "Returns yield of securities with an odd (short or long) last period.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date (securities sale date that is later than issuance date)."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Mandatory. The security's maturity date. This date determines when validity of securities expires."
              },
              {
               "n" : "LastCouponDate",
               "dt" : "3",
               "dsc" : "Date of the last securities coupon payment."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Securities interest rate."
              },
              {
               "n" : "Price",
               "dt" : "2",
               "dsc" : "Securities cost."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption value of securities for $100 face value."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Mandatory. The annual number of coupon payments. The frequency for annual payments is equal to 1; for semi-annual — 2; for quarterly — 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days."
              }
            ]
          },
          {
           "n" : "Pmt",
           "dsc" : "Returns sum of periodic annuity payment based on fixed payments sums and fixed interest rate.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for advances."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of payments for advances."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Present value or general sum that is currently equal to a series of future payments and is named principal sum."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Ppmt",
           "dsc" : "Returns the value of payment in satisfaction of principal sum for the specified period based on fixed periodic payments and fixed interest rate.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for advances."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of payments for advances."
              },
              {
               "n" : "PresentValue",
               "dt" : "2",
               "dsc" : "Present value or general sum that is currently equal to a series of future payments and is named principal sum."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Price",
           "dsc" : "Returns price per $100 face value of securities, for which periodic interest is paid.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Annual interest rate for securities coupons."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption price per $100. face value of securities."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual payments is equal to 1; for semi-annual payments - 2; for quarterly payments - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "PriceDisc",
           "dsc" : "Returns price per $100 face value of securities, for which discount is applied.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Discount",
               "dt" : "2",
               "dsc" : "Discount for security."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption price per $100. face value of securities."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "PriceMat",
           "dsc" : "Returns price per $100 face value of securities that pay interest on maturity date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Date of securities issuance."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate of securities return on settlement date."
              },
              {
               "n" : "YieldP",
               "dt" : "2",
               "dsc" : "Annual income of securities."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Pv",
           "dsc" : "Returns present investment cost. Present cost is a general sum that is currently equal to a series of future payments. For example, when you borrow money, the loan sum is the present cost for a loaner.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Interest rate for period."
              },
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of annuity payment periods."
              },
              {
               "n" : "PeriodPayment",
               "dt" : "2",
               "dsc" : "Payment made each period and that does not change during all the entire rent payment time."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              }
            ]
          },
          {
           "n" : "Rate",
           "dsc" : "Returns annuity interest rate for one period.",
           "prms" : 
            [
              {
               "n" : "PeriodCount",
               "dt" : "2",
               "dsc" : "General number of annuity payment periods."
              },
              {
               "n" : "PeriodPayment",
               "dt" : "2",
               "dsc" : "Periodic payment (once a period), which value is kept fixed during the entire annuity time. Usually, the payment consists of principal sum payment and interest payment but does not include other commissions or taxes."
              },
              {
               "n" : "CurrentCost",
               "dt" : "2",
               "dsc" : "Present cost at the current moment or general sum that is currently equal to the series of future payments."
              },
              {
               "n" : "FutureValue",
               "dt" : "2",
               "dsc" : "Required value of future cost or remaining balance after the last payment."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Payment time selection : 0(zero) - at the end of period; 1 - at the start of period."
              },
              {
               "n" : "Guess",
               "dt" : "2",
               "dsc" : "Assumed rate value.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Received",
           "dsc" : "Returns the sum obtained by maturity date of fully asset-backed securities.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Investment",
               "dt" : "2",
               "dsc" : "Amount of investment in securities."
              },
              {
               "n" : "Discount",
               "dt" : "2",
               "dsc" : "Discount for security."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Sln",
           "dsc" : "Returns asset depreciation value for one period calculated by linear method.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset acquisition costs."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Cost at the end of depreciation period."
              },
              {
               "n" : "Life",
               "dt" : "2",
               "dsc" : "Number of periods, for which asset is depreciated."
              }
            ]
          },
          {
           "n" : "Syd",
           "dsc" : "Returns asset depreciation value for this period calculated by the sum of (annual) numbers method.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset acquisition costs."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Cost at the end of depreciation period."
              },
              {
               "n" : "Life",
               "dt" : "2",
               "dsc" : "Number of periods, for which asset is depreciated."
              },
              {
               "n" : "Period",
               "dt" : "2",
               "dsc" : "Period (should be measured in the same units as full depreciation time)"
              }
            ]
          },
          {
           "n" : "TBillEq",
           "dsc" : "Returns bond-equivalent yield for a treasury bill.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Treasury bill settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Treasury bill maturity date."
              },
              {
               "n" : "Discount",
               "dt" : "2",
               "dsc" : "Treasury bill discount."
              }
            ]
          },
          {
           "n" : "TBillPrice",
           "dsc" : "Returns price per $100 face value for a treasury bill.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Treasury bill settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Treasury bill maturity date."
              },
              {
               "n" : "Discount",
               "dt" : "2",
               "dsc" : "Treasury bill discount."
              }
            ]
          },
          {
           "n" : "TBillYield",
           "dsc" : "Returns price per $100 face value for a treasury bill.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Treasury bill settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Treasury bill maturity date."
              },
              {
               "n" : "Price",
               "dt" : "2",
               "dsc" : "Price per $100 of a treasury bill face value of securities."
              }
            ]
          },
          {
           "n" : "Vdb",
           "dsc" : "Returns asset depreciation value for any selected period, including partial periods, using the double margin reduction method or other specified method.",
           "prms" : 
            [
              {
               "n" : "Cost",
               "dt" : "2",
               "dsc" : "Asset acquisition costs."
              },
              {
               "n" : "Salvage",
               "dt" : "2",
               "dsc" : "Cost at the end of depreciation period."
              },
              {
               "n" : "Life",
               "dt" : "2",
               "dsc" : "Number of periods, for which asset is depreciated."
              },
              {
               "n" : "StartPeriod",
               "dt" : "2",
               "dsc" : "Start period,  for which depreciation is caluclated."
              },
              {
               "n" : "EndPeriod",
               "dt" : "2",
               "dsc" : "End period, for which depreciation is calculated."
              },
              {
               "n" : "Factor",
               "dt" : "2",
               "dsc" : "Interest rate of declining balance."
              },
              {
               "n" : "NoSwitch",
               "dt" : "4",
               "dsc" : "Logical value that determines whether linear depreciation should be used when depreciation exceeds the value calculated using the declining balance method."
              }
            ]
          },
          {
           "n" : "XIrr",
           "dsc" : "Returns internal rate of return for not necessarily periodic cash flow schedule.",
           "prms" : 
            [
              {
               "n" : "Values",
               "dt" : "5",
               "dsc" : "Series of cash flows corresponding to payments schedule given in date argument."
              },
              {
               "n" : "Dates",
               "dt" : "5",
               "dsc" : "Payment dates schedule corresponding to a series of cash flows."
              },
              {
               "n" : "Guess",
               "dt" : "2",
               "dsc" : "Assumed values of function result.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "Xnpv",
           "dsc" : "Returns net present cost for not necessarily periodic cash flows.",
           "prms" : 
            [
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Discount rate applied to cash flows."
              },
              {
               "n" : "Values",
               "dt" : "5",
               "dsc" : "Series of cash flows corresponding to payments schedule given in date argument."
              },
              {
               "n" : "Dates",
               "dt" : "5",
               "dsc" : "Payment dates schedule corresponding to a series of cash flows."
              }
            ]
          },
          {
           "n" : "YieldF",
           "dsc" : "Returns yield of securities that pay periodic interest payments. The Yield function is used to calculate bond yield.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Annual interest rate for securities coupons."
              },
              {
               "n" : "Price",
               "dt" : "2",
               "dsc" : "Price for $100. face value of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption price per $100. face value of securities."
              },
              {
               "n" : "Frequency",
               "dt" : "2",
               "dsc" : "Number of annual coupon payments. The frequency for annual securities is equal to 1; for semi-annual securities - 2; for quarterly securities - 4."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "YieldDisc",
           "dsc" : "Returns annual securities yield, for which discount is applied.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Price",
               "dt" : "2",
               "dsc" : "Price for $100. face value of securities."
              },
              {
               "n" : "Redemption",
               "dt" : "2",
               "dsc" : "Redemption price per $100. face value of securities."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "YieldMat",
           "dsc" : "Returns annual securities yield that pay interest at maturity date.",
           "prms" : 
            [
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              },
              {
               "n" : "Maturity",
               "dt" : "3",
               "dsc" : "Date of maturity."
              },
              {
               "n" : "Issue",
               "dt" : "3",
               "dsc" : "Date of securities issuance."
              },
              {
               "n" : "Rate",
               "dt" : "2",
               "dsc" : "Annual interest rate for securities coupons."
              },
              {
               "n" : "Price",
               "dt" : "2",
               "dsc" : "Price for $100. face value of securities."
              },
              {
               "n" : "Basis",
               "dt" : "2",
               "dsc" : "Used method of day calculation: 0 - American. 360 days (NSAD method); 1 - Actual\/actual; 2 - Actual\/360 days; 3 - Actual\/365 days; 4 - European 30\/360 days.",
               "o" : "1"
              }
            ]
          },
          {
           "n" : "RedemptionYield",
           "dsc" : "Security yield on its redemption, with odd payment periods.",
           "prms" : 
            [
              {
               "n" : "Price",
               "dt" : "3",
               "dsc" : "Security cost."
              },
              {
               "n" : "AccumulatedIncome",
               "dt" : "3",
               "dsc" : "Accumulated income."
              },
              {
               "n" : "CouponsDates",
               "dt" : "5",
               "dsc" : "Dates of coupon payments."
              },
              {
               "n" : "Coupons",
               "dt" : "5",
               "dsc" : "Coupon interest rates."
              },
              {
               "n" : "PaymentsDates",
               "dt" : "5",
               "dsc" : "Payment dates."
              },
              {
               "n" : "Payments",
               "dt" : "5",
               "dsc" : "Payment values."
              },
              {
               "n" : "Settlement",
               "dt" : "3",
               "dsc" : "Securities settlement date."
              }
            ]
          }
        ]
      },
      {
       "n" : "Statistical",
       "fns" : 
        [
          {
           "n" : "AveDev",
           "dsc" : "The method returns average absolute value of deviations of data points from average. This value is a measure of spread of data set.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Set of numbers, for which mean absolute deviation is determined.",
             "ext" : "1"
            }
          },
          {
           "n" : "BetaDist",
           "dsc" : "The method returns integral function of beta probability density. The integral function of beta probability density is usually used to study a variation in percentage of some value.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "2",
               "dsc" : "Value, for which function is calculated. The value should satisfy the constraint: 1 > X > 0."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Alpha > 0."
              },
              {
               "n" : "Beta",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Beta > 0."
              }
            ]
          },
          {
           "n" : "BetaInv",
           "dsc" : "The method returns inverse function to integral function of beta probability density.

If Probability = BetaDist(x; …), then BetaInv(Probability ; …) = x.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Beta distribution related probability. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Alpha > 0."
              },
              {
               "n" : "Beta",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Beta > 0."
              }
            ]
          },
          {
           "n" : "BinomDist",
           "dsc" : "The method returns the single value of binomial distribution. The function is used in tasks with a fixed number of tests when each test can result only in success or failure. Tests are independent, and the probability of success is constant during the entire test time.",
           "prms" : 
            [
              {
               "n" : "Successes",
               "dt" : "2",
               "dsc" : "Number of successful tests."
              },
              {
               "n" : "Trials",
               "dt" : "2",
               "dsc" : "Number of independent tests."
              },
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability of success of each test. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Logical value that determines function form. If this argument is set to True, the BinomDist function returns the integral function of distribution, that is, the probability of that the number of successful tests is not less than the value of the Successes argument. If this argument is set to False, the distribution function is returned, that is, the probability of that the number of successful tests is exactly the same as the value of the Successes argument."
              }
            ]
          },
          {
           "n" : "ChiDist",
           "dsc" : "The method returns one-sided probability of the chi-square distribution. The χ2 distribution is related with the χ2 criterion. The χ2 criterion is used to compare assumed and observed values.

The value is calculated as follows: ChiDist = P(X>x), where x - χ2 random value.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "2",
               "dsc" : "Value, for which distribution should be calculated. The value should satisfy the constraint: X >= 0."
              },
              {
               "n" : "DegreesOfFreedom",
               "dt" : "2",
               "dsc" : "Number of degrees of freedom. Available values are taken from the range (1; 10^10)."
              }
            ]
          },
          {
           "n" : "ChiInv",
           "dsc" : "The method returns the value that is inverse to one-sided probability of the chi-square distribution. The function is used to compare expected and observed results.

If probability = ChiDist(x; …), then ChiInv(probability; …) = x.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability related with the χ2 distribution. The value should satisfy the constraint: 0 <= Probability <= 1."
              },
              {
               "n" : "DegreesOfFreedom",
               "dt" : "2",
               "dsc" : "Number of degrees of freedom. Available values are taken from the range (1; 10^10)."
              }
            ]
          },
          {
           "n" : "ChiTest",
           "dsc" : "The method returns the value for the chi-square distribution. The χ2 criterion is used to determine whether the hypothesis is justified in the test.
        
The χ2 criterion first calculates the χ2 statistic, then sums up differences between actual and expected values.

NOTE. ActualRange and ExpectedRange must match in size.",
           "prms" : 
            [
              {
               "n" : "ActualRange",
               "dt" : "5",
               "dsc" : "Data interval that contains observations that should be compared to expected values."
              },
              {
               "n" : "ExpectedRange",
               "dt" : "5",
               "dsc" : "Data interval that contains relation of product of totals by rows and columns to grand total."
              }
            ]
          },
          {
           "n" : "Confidence",
           "dsc" : "The method returns confidence interval for a population mean. Confidence interval is an interval on both sides of a population mean.",
           "prms" : 
            [
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Significance level that is used to calculate reliability level. The reliability level is equal to 100*(1 - Alpha) %, or, in other words, Alfa equal to 0.05 means 95% reliability level. The value should satisfy the constraint: 0 < Alpha < 1."
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation of population for data interval. It is assumed to be known. The value should satisfy the constraint: StandartDeviation > 0."
              },
              {
               "n" : "Size",
               "dt" : "2",
               "dsc" : "Sample size."
              }
            ]
          },
          {
           "n" : "Correl",
           "dsc" : "The method returns correlation coefficient between A1 and A2. Correlation coefficient is used to determine the existence of interrelation between two properties.

NOTE. A1 and A2 must have a different number of data points.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "First value array."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Second value array."
              }
            ]
          },
          {
           "n" : "Covar",
           "dsc" : "The method returns covariation, that is, average of deviation products for each pair of data points. Covariation is used to determine a link between two data sets.

NOTE. A1 and A2 must have a different number of data points.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "First value array."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Second value array."
              }
            ]
          },
          {
           "n" : "CritBinom",
           "dsc" : "The method returns the least value, for which integral binomial distribution is greater or equal to the specified criterion. This function is used in applications related with quality control.",
           "prms" : 
            [
              {
               "n" : "Trials",
               "dt" : "2",
               "dsc" : "Number of Bernoulli trials. The value should satisfy the constraint: Trials >= 0."
              },
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability of success in each trial. Available values are taken from the range [0; 1]."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Criterion value. Available values are taken from the range [0; 1]."
              }
            ]
          },
          {
           "n" : "DevSq",
           "dsc" : "The method returns the sum of squares of data point deviations from their mean.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Set of numbers, which squares of deviations are summed.",
             "ext" : "1"
            }
          },
          {
           "n" : "ExponDist",
           "dsc" : "The method returns exponential distribution. The function is used to model time delays between events.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Function value. The value should satisfy the constraint: Value >= 0."
              },
              {
               "n" : "Lambda",
               "dt" : "2",
               "dsc" : "Parameter value. The value should satisfy the constraint: Lambda > 0."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Logical value that specified which exponential function form should be used. If the attribute is set to True, the ExponDist function returns integral function of distribution; if this parameter is set to False, the function of distribution density is returned."
              }
            ]
          },
          {
           "n" : "FDist",
           "dsc" : "The method returns F distribution of probability. This function can be used to determine whether two data sets have different degrees of result dispersion.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which function is calculated. The value should satisfy the constraint: Value >= 0."
              },
              {
               "n" : "DegOfFreedomNumer",
               "dt" : "2",
               "dsc" : "Numerator of degrees of freedom. Available values are taken from the range [1; 10^10)."
              },
              {
               "n" : "DegOfFreedomDenomin",
               "dt" : "2",
               "dsc" : "Denominator of degrees of freedom. Available values are taken from the range [1; 1010)."
              }
            ]
          },
          {
           "n" : "FInv",
           "dsc" : "The method returns inverse value of the F distribution of probabilities.

If Probability = FDist(Value ;…), then FInv(Probability ;…) = Value.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability related with the F distribution. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "DegreesOfFreedom1",
               "dt" : "2",
               "dsc" : "Numerator of degrees of freedom. Available values are taken from the range [1; 10^10)."
              },
              {
               "n" : "DegreesOfFreedom2",
               "dt" : "2",
               "dsc" : "Denominator of degrees of freedom. Available values are taken from the range [1; 10^10)."
              }
            ]
          },
          {
           "n" : "Fisher",
           "dsc" : "The method returns the Fisher distribution for the Value argument. This distribution build a function that has a normal and not an asymmetrical distribution. This function is used to test hypotheses using correlation coefficient.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Value that should be transformed. The value should satisfy the constraint: 1 > Value > -1."
            }
          },
          {
           "n" : "FisherInv",
           "dsc" : "The method returns he reverse Fisher transformation. This transformation is used in analysis of correlation between data arrays and intervals. If y = Fisher(x), then FisherInv(y) = x.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Value, for which reverse transformation is executed."
            }
          },
          {
           "n" : "Forecast",
           "dsc" : "The method calculates future value by existing values. NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Index of the point, for which value is predicted."
              },
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Dependent data array."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Independent data array."
              }
            ]
          },
          {
           "n" : "_Frequency",
           "dsc" : "The method calculates the frequency of values appearance in the values interval and returns the array of numbers. The number of elements in the returned array is one greater than the number of elements in the BinsArray array. Additional element in the returned array contains the number of values that are greater than the maximum value in intervals.",
           "prms" : 
            [
              {
               "n" : "DataArray",
               "dt" : "5",
               "dsc" : "Data array, for which frequencies are calculated. If DataArray does not contain values, the Frequency function returns array with zeroes."
              },
              {
               "n" : "BinsArray",
               "dt" : "5",
               "dsc" : "Array of intervals, to which values of the DataArray argument are copied. If BinsArray does not contain values, the Frequency function returns the number of elements in the DataArray argument."
              }
            ]
          },
          {
           "n" : "FTest",
           "dsc" : "The method returns F test result. F test returns the one-sided probability that variances of the A1 and A2 arguments differ insignificantly. This function is used to determine whether two samples have different variances.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "First array. Array length should be greater or equal to two."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Second array. Array length should be greater or equal to two."
              }
            ]
          },
          {
           "n" : "GammaDist",
           "dsc" : "The method returns gamma distribution. This function can be used to study variables that have asymmetrical distribution. Gamma distribution is usually used in the queueing theory.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which distribution should be calculated. The value should satisfy the constraint: Value >= 0."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Alpha >0. If Alpha = 1, then the GammaDist function returns exponential distribution."
              },
              {
               "n" : "Beta",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Beta >0. If Beta = 1, then the GammaDist function returns the standard gamma distribution."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Logical value that determines function form:
          - True. The GammaDist function returns integral function of distribution;
          - False. The GammaDist function returns the function of distribution density."
              }
            ]
          },
          {
           "n" : "GammaInv",
           "dsc" : "The method returns reverse gamma distribution. This function is used to study variables that probably have asymmetrical distribution.

If Probability = GammaDist(x; …), then GammaInv(Probability ; …) = x.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability related with gamma distribution. The value should satisfy the constraint: 0 <= Probability <= 1."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Alpha >0."
              },
              {
               "n" : "Beta",
               "dt" : "2",
               "dsc" : "Distribution parameter. If Beta = 1, the GammaInv function returns standard gamma distribution. The value should satisfy the constraint: Beta >0."
              }
            ]
          },
          {
           "n" : "GammaLn",
           "dsc" : "The method returns natural logarithm of gamma function.

The e number raised to the GammaLn (i) power, where i — integer number, returns the same result as (i - 1)!.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Value, for which GammaLn is calculated. The value should satisfy the constraint: Value > 0."
            }
          },
          {
           "n" : "GeoMean",
           "dsc" : "The method returns geometric mean of values of positive numbers array.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Data array, for which the mean is calculated. Values in the array should be greater than zero.",
             "ext" : "1"
            }
          },
          {
           "n" : "HarMean",
           "dsc" : "The method returns harmonic mean of data set. Harmonic mean is a value that is inverse to arithmetic mean of inverse values. Harmonic mean is always less than the geometric mean that is always less than arithmetic mean.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Set of arguments, for which the mean is calculated.",
             "ext" : "1"
            }
          },
          {
           "n" : "HypGeomDist",
           "dsc" : "The method returns hypergeometric distribution. The method returns the probability of the specified number of successes in the population if the following is set: population size, number of successes in the entire population, and entire population size.",
           "prms" : 
            [
              {
               "n" : "SuccessfulTrials",
               "dt" : "2",
               "dsc" : "Number of successful trials in population. The value should satisfy the constraints:
          - SuccessfulTrials > = 0;
          - SuccessfulTrials < = min(Trials, SuccessfulInPopulation);
          - SuccessfulTrials > = max(0, Trials-PopulationSize+SuccessfulTrials)."
              },
              {
               "n" : "Trials",
               "dt" : "2",
               "dsc" : "Population size. Available values are taken from the range [0; PopulationSize]."
              },
              {
               "n" : "SuccessfulInPopulation",
               "dt" : "2",
               "dsc" : "Number of successful trials in the entire population. Available values are taken from the range [0; PopulationSize]."
              },
              {
               "n" : "PopulationSize",
               "dt" : "2",
               "dsc" : "Entire population size. The value should satisfy the constraint: PopulationSize >= 0."
              }
            ]
          },
          {
           "n" : "Intercept",
           "dsc" : "The method calculates point of intersection of the line and the Y axis using KnownXs and KnownYs. The intersection point is located the optimal regression line drawn through KnownXs and KnownYs. The Intercept method is used when one should determine value of dependent variable when the independent variable value is equal to zero.

NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Dependent data set."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Independent data set."
              }
            ]
          },
          {
           "n" : "Kurt",
           "dsc" : "The method returns data set kurtosis. Kurtosis characterizes relative pointedness or smoothness of distribution compared to normal distribution. A positive kurtosis indicates a relative cusped distribution. Negative kurtosis means relative smoothed distribution.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Data array."
            }
          },
          {
           "n" : "Large",
           "dsc" : "The method returns the data set value that is k-th by number. This function enables the user to select value by its relative position.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Data array, for which the k-th greatest value is determined. Array length should be greater than zero."
              },
              {
               "n" : "Position",
               "dt" : "2",
               "dsc" : "Position (starting from the greatest) in data array. Available values are taken from the range (0; Data length]."
              }
            ]
          },
          {
           "n" : "Linest",
           "dsc" : "The method calculates statistic for a series using the least squares method to calculate the straight line that in the best way approximates the existing data. The function returns the array that describes the obtained line.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Set of values that are already known in the relation y = m * x + b . The value should satisfy the constraint: KnownYs > 0. If the KnownYs array contains one column, each column of the KnownXs array is interpreted as a single variable. If the KnownYs array contains one row, each row of the KnownXs array is interpreted as a single variable. The KnownXs array can contain one or several variables sets. If only one variable is used, KnownYs and KnownXs can have any form provided that they have the same dimensionality. If more than one variable is used, KnownYs should be a vector (that is, an interval that is one row high and one column wide)."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Set of x values that are already known for the relation: y = m * x + b ."
              },
              {
               "n" : "HasConstant",
               "dt" : "4",
               "dsc" : "Logical value that indicates whether the b constant should be equal to zero:
          - when the value is True,  b is calculated in a regular way;
          - when the value is False, b is assumes to be equal to 0, and values of m are selected in a way to execute the equation: y=mx."
              },
              {
               "n" : "ReturnStatistics",
               "dt" : "4",
               "dsc" : "Logical value that indicates whether additional regression statistics should be returned:
          - when the value is True, the Linest function returns additional regression statistics;
          - when the value is False, the  Linest function returns only m coefficients and the b constant."
              }
            ]
          },
          {
           "n" : "LogInv",
           "dsc" : "The method returns the inverse function of lognormal distribution.

If Probability = LogNormDist(x; …), then LogInv(Probability ; …) = x.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability related with lognormal distribution. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Mean ln(x)."
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation ln(x). The value should satisfy the constraint: StandartDeviation > 0."
              }
            ]
          },
          {
           "n" : "LogNormDist",
           "dsc" : "The method returns integral lognormal distribution. This function is used to analyze data that was logarithmically transformed.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which function is calculated. The value should satisfy the constraint: Value > 0."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Mean ln(Value );"
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation ln(Value). The value should satisfy the constraint: StandartDeviation > 0."
              }
            ]
          },
          {
           "n" : "Median",
           "dsc" : "The method returns median of specified numbers. Median is a number that is in the middle of a numbers set, that is, half of the numbers have values that are greater than the median, and another half of the numbers have values that are less than the median.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Set of numbers, for which median should be found.",
             "ext" : "1"
            }
          },
          {
           "n" : "NegBinomDist",
           "dsc" : "The method returns negative binomial distribution.
NOTE: the following condition should be satisfied: (FailedTrials + SuccessfulTrials - 1) > 0.",
           "prms" : 
            [
              {
               "n" : "FailedTrials",
               "dt" : "2",
               "dsc" : "Number of failed trials."
              },
              {
               "n" : "SuccessfulTrials",
               "dt" : "2",
               "dsc" : "Threshold value of the number of successful trials."
              },
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability of success. Available values are taken from the range [0; 1]."
              }
            ]
          },
          {
           "n" : "NormDist",
           "dsc" : "The method returns normal function of distribution for the specified means and standard deviation.

If Mean = 0, StandartDeviation = 1 and Cumulative = True, then the NormDist function returns standard normal distribution (NormDist).",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which distribution is calculated."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Arithmetic mean of distribution."
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Logical value that determines function form:
          - when the value is True, the NormDist function returns integral function of distribution;
          - when the value is False, the function returns the function of distribution density."
              }
            ]
          },
          {
           "n" : "NormInv",
           "dsc" : "The method returns inverse normal distribution.

If Mean = 0 and StandartDeviation = 1, then the method uses standard normal distribution (NormDist).",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability corresponding to normal distribution. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Arithmetic mean of distribution."
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0."
              }
            ]
          },
          {
           "n" : "NormsDist",
           "dsc" : "The method returns standard normal integral distribution. This distribution has the mean that is equal to zero, and the standard deviation that is equal to one. This function is used instead of a tale for standard normal curve.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "2",
             "dsc" : "Value, for which distribution is calculated."
            }
          },
          {
           "n" : "NormsInv",
           "dsc" : "The method returns inverse value of standard normal distribution. This distribution has the mean that is equal to zero and the standard deviation that is equal to one.",
           "prms" : 
            {
             "n" : "Probability",
             "dt" : "2",
             "dsc" : "Probability corresponding to normal distribution. The value should satisfy the constraint: 1 >= Probability >= 0."
            }
          },
          {
           "n" : "Pearson",
           "dsc" : "The method returns the Pearson correlation coefficient (r).

NOTE. A1 and A2 should be non-empty and contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "Array of independent values."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Array of dependent values."
              }
            ]
          },
          {
           "n" : "Percentile",
           "dsc" : "The method returns the k-th percentile for interval values. This function is used to determine eligibility threshold.

If k is not multiple of 1\/(n - 1), then the Percentile function executes interpolation to determine a value of the k-th percentile.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Data array that determines relative position."
              },
              {
               "n" : "Percent",
               "dt" : "2",
               "dsc" : "Percentile value. Available values are taken from the range [0; 1]."
              }
            ]
          },
          {
           "n" : "PercentRank",
           "dsc" : "The method returns the value category in the data set as a percentage in the data set. If the specified Value does not correspond to any of values of the Data argument, the PercentRank function executes interpolation and returns correct percentage value.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Data array that determines relative position."
              },
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which percentage is determined."
              },
              {
               "n" : "Significance",
               "dt" : "2",
               "dsc" : "Optional value that determines the number of significands for the returned percentage. The value should satisfy the constraint: Significance >= 1."
              }
            ]
          },
          {
           "n" : "Permut",
           "dsc" : "The method returns the number of permutations for the specified number of objects. Permutations differ from the combinations, for which internal order is not important.",
           "prms" : 
            [
              {
               "n" : "SetSize",
               "dt" : "2",
               "dsc" : "Number that sets the number of objects. The value should satisfy the constraints:
          - SetSize > 0;
          - SetSize >= SampleSize."
              },
              {
               "n" : "SampleSize",
               "dt" : "2",
               "dsc" : "Number that sets the number of objects in each permutation. The value should satisfy the constraint: SampleSize >= 0."
              }
            ]
          },
          {
           "n" : "Poisson",
           "dsc" : "The method returns the Poisson distribution. Normal application of the Poisson distribution consists in predicting the number of events occurring for the specified time.",
           "prms" : 
            [
              {
               "n" : "EventCount",
               "dt" : "2",
               "dsc" : "Number of events. The value should satisfy the constraint: EventCount > 0."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Expected numeric value."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Logical value that determines a form of returned distribution of probabilities:
          - True. The method returns the integral Poisson distribution, that is, the probability that the number of random events will be from 0 to EventCount inclusive;
          - False. It returns the function of Poisson distribution density, that is, the probability that the number of events will be exactly EventCount."
              }
            ]
          },
          {
           "n" : "Prob",
           "dsc" : "The method returns the probability that the value in the interval is within the specified limits. If UpperLimit is not set, it returns the probability that X values are equal to the value of the LowerLimit argument.",
           "prms" : 
            [
              {
               "n" : "X",
               "dt" : "5",
               "dsc" : "Interval of numeric values, with which probabilities are related. Data array values should be greater than zero."
              },
              {
               "n" : "Probabilities",
               "dt" : "5",
               "dsc" : "Set of probabilities corresponding to values of the X argument. Available values for the set are taken from the range [0; 1]."
              },
              {
               "n" : "LowerLimit",
               "dt" : "2",
               "dsc" : "Lower limit of the value, for which probability is calculated."
              },
              {
               "n" : "UpperLimit",
               "dt" : "2",
               "dsc" : "Optional upper limit of the value, for which probability should be calculated."
              }
            ]
          },
          {
           "n" : "Quartile",
           "dsc" : "The Quartile method returns the quartile of data set. The quartile is often used in sales analysis to divide the entire population into groups.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Interval of numeric values, with which probabilities are related. Data array values should be greater than zero."
              },
              {
               "n" : "Quart",
               "dt" : "2",
               "dsc" : "Value that should be returned. Available values are taken from the range [0; 4].
          If Quart is equal, then Quartile returns:
          0 - Minimum value;
          1 - First quartile (25-th percentile);
          2 - Median value (50-th percentile);
          3 - Third quartile (75-th percentile);
          4 - Maximum value."
              }
            ]
          },
          {
           "n" : "Rank",
           "dsc" : "The Rank method returns number rank in the number array. Number rank is the number value relative to other values in the list. If the list is sorted, the number rank will be is position.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Number, for which a rank is determined."
              },
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Number array."
              },
              {
               "n" : "AscendingOrder",
               "dt" : "4",
               "dsc" : "Ranking method:
          - True. Number rank is determined as if the array was sorted descending;
          - False. Number rank is determined as if the array was sorted ascending."
              }
            ]
          },
          {
           "n" : "Rsq",
           "dsc" : "The method returns the squared Pearson correlation coefficient (r^2).

NOTE. KnownYs and KnownXs should be non-empty and contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Array of independent values."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Array of dependent values."
              }
            ]
          },
          {
           "n" : "Skew",
           "dsc" : "The method returns distribution asymmetry. Asymmetry characterizes the degree of distribution asymmetry relative to its mean. Positive skewness indicates distribution deviation towards positive values. Negative asymmetry indicates the distribution deviation in direction of negative values.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Array of arguments, for which asymmetry is calculated.",
             "ext" : "1"
            }
          },
          {
           "n" : "Slope",
           "dsc" : "The Slope method returns the slope of linear regression line. NOTE: KnownYs and KnownXs should contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Dependent array of data points."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Independent array of data points."
              }
            ]
          },
          {
           "n" : "Small",
           "dsc" : "The method returns the k-th least value in the data set. If n is the number of data points in Data, then Small(Data; 1) is equal to the least value and Small(Data; n) is equal to the greatest value.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Array of data, for which the k-th least value is determined."
              },
              {
               "n" : "Position",
               "dt" : "2",
               "dsc" : "Position (starting from the least) in array or data cell interval. Available values are taken from the range (0; Data length]."
              }
            ]
          },
          {
           "n" : "Standardize",
           "dsc" : "The method returns the normalized value for distribution characterized with mean and standard deviation.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Normalized value."
              },
              {
               "n" : "Mean",
               "dt" : "2",
               "dsc" : "Arithmetic mean of distribution."
              },
              {
               "n" : "StandartDeviation",
               "dt" : "2",
               "dsc" : "Standard deviation of distribution. The value should satisfy the constraint: StandartDeviation > 0."
              }
            ]
          },
          {
           "n" : "StDev",
           "dsc" : "The method estimates standard deviation based on sample. NOTE. If data contains the entire population, the standard deviation should be calculated using the StDevP function.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Array of data corresponding to sample from the entire population.",
             "ext" : "1"
            }
          },
          {
           "n" : "StDevP",
           "dsc" : "The method calculates standard deviation based ion the entire population. Standard deviation is a measure of how far elements values are scattered from their average. Standard deviation is calculated using the "shifted" or "n" method.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Array of data including the entire population.",
             "ext" : "1"
            }
          },
          {
           "n" : "SteYX",
           "dsc" : "The method returns the standard error of predicted Y values for X value in regression. Standard error is a measure of error of predicted Y value for a single X value.

NOTE. KnownYs and KnownXs should contains the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Array of dependent data points."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Array of independent data points."
              }
            ]
          },
          {
           "n" : "TDist",
           "dsc" : "The method returns percentage points (probability) for Student's t-distribution where the numeric value (x) is the calculated value, for which probabilities should be calculated. The t-distribution is used to check hypotheses in small samples. This function can be used instead of the table of critical value of the t-distribution.

TDist is calculated as follows: TDist = p( x<X ), where X s a random value corresponding to the t-distribution.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which distribution should be calculated."
              },
              {
               "n" : "DegreesOfFreedom",
               "dt" : "2",
               "dsc" : "Integer that specifies the number of degrees of freedom. The value should satisfy the constraint: DegreesOfFreedom >= 1."
              },
              {
               "n" : "Tails",
               "dt" : "2",
               "dsc" : "Number of returned distribution tails. Available values:
          - 1 - the TDist function returns one-tailed distribution;
          - 2 - the TDist function returns two-tailed distribution."
              }
            ]
          },
          {
           "n" : "TInv",
           "dsc" : "The method returns t-value of the Student distribution as a function of probability and number of degrees of freedom.

One-tailed t-value can be obtained on replacement of the Probability argument with the 2*Probability agument.",
           "prms" : 
            [
              {
               "n" : "Probability",
               "dt" : "2",
               "dsc" : "Probability corresponding to two-tailed distribution. The value should satisfy the constraint: 1 >= Probability >= 0."
              },
              {
               "n" : "DegreesOfFreedom",
               "dt" : "2",
               "dsc" : "Number of degrees of freedom that characterizes the distribution. The value should satisfy the constraint: DegreesOfFreedom >= 1."
              }
            ]
          },
          {
           "n" : "Trend",
           "dsc" : "The Trend method returns values according to linear trend. It approximates the KnownYs and KnownXs arrays with a straight line (using the least squares method). It returns Y values according to this line for the specified array NewXs.",
           "prms" : 
            [
              {
               "n" : "KnownYs",
               "dt" : "5",
               "dsc" : "Set of Y values that are already known in the relation: y=mx+b. The value should satisfy the constraint: KnownYs > 0. If the KnownYs array contains one column, each column of the KnownXs array is interpreted as a single variable. If the KnownYs array contains one row, each row of the KnownXs array is interpreted as a single variable. The KnownXs array can contain one or several variables sets. If only one variable is used, KnownYs and KnownXs can have any form provided that they have the same dimensionality. If more than one variable is used, KnownYs should be a vector (that is, an interval that is one row high and one column wide)."
              },
              {
               "n" : "KnownXs",
               "dt" : "5",
               "dsc" : "Set of X values that are already known for the relation: y=mx+b."
              },
              {
               "n" : "NewXs",
               "dt" : "5",
               "dsc" : "New X values, for which Trend returns corresponding Y values. NewXs should contain a column (or a row) for each independent variable as well as KnownXs. Therefore, if KnownYs contains one column, then KnownXs and NewXs should have the same number of columns. If KnownYs contains one row, then KnownXs and NewXs should have the same number of rows."
              },
              {
               "n" : "HasConstant",
               "dt" : "4",
               "dsc" : "Logical value that indicates whether the b constants should be equal to zero:
          - True. b is calculated in a regular way;
          - False. b is assumed to be equal to 0, and m values are selected in a way to satisfy the equation: y=mx."
              }
            ]
          },
          {
           "n" : "TrimMean",
           "dsc" : "The method returns the mean of the interior of data set. The function calculates the mean by discarding the specified percent of data with extreme values.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Array of averaged values."
              },
              {
               "n" : "Percent",
               "dt" : "2",
               "dsc" : "Part of data points excluded from calculations. Available values are taken from the range [0; 1]."
              }
            ]
          },
          {
           "n" : "TTest",
           "dsc" : "The method returns the probability corresponding to the Student criterion. This function is used to determine the probability that two samples are taken from entire populations with the same mean.

NOTE. If pair type of test is used (Type=1), then A1 and A2 should contain the equal number of data points.",
           "prms" : 
            [
              {
               "n" : "A1",
               "dt" : "5",
               "dsc" : "First data set."
              },
              {
               "n" : "A2",
               "dt" : "5",
               "dsc" : "Second data set."
              },
              {
               "n" : "Tails",
               "dt" : "2",
               "dsc" : "Number of distribution tails. Available values:
          1 - the TTest function uses one-tailed distribution;
          2 - the TTest function uses two-tailed distribution."
              },
              {
               "n" : "Type",
               "dt" : "2",
               "dsc" : "Type of executed t-test:
          1 - Paired.
          2 - Two-sample with equal variances (homoscedastic).
          3 - Two-sample with unequal variances (heteroscedastic)."
              }
            ]
          },
          {
           "n" : "Dispersion",
           "dsc" : "The method assesses variance by sample. It is assumed that arguments are a sample based on the entire population.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Array of numeric arguments corresponding to sample based on the entire population.",
             "ext" : "1"
            }
          },
          {
           "n" : "DispersionP",
           "dsc" : "The method calculates entire population variance. It is assumed that arguments are the entire population.",
           "prms" : 
            {
             "n" : "Values",
             "dt" : "5",
             "dsc" : "Array of numeric arguments corresponding to the entire population.",
             "ext" : "1"
            }
          },
          {
           "n" : "Weibull",
           "dsc" : "The method returns the Weibull distribution. This distribution is used in reliability analysis, for example, to calculate mean time between failures for a device.",
           "prms" : 
            [
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Value, for which distribution should be calculated. The value should satisfy the constraint: Value >= 0."
              },
              {
               "n" : "Alpha",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Alpha >  0. If Alpha = 1, the Weibull function returns exponential distribution."
              },
              {
               "n" : "Beta",
               "dt" : "2",
               "dsc" : "Distribution parameter. The value should satisfy the constraint: Beta > 0. If Beta = 1, the Weibull function returns standard distribution."
              },
              {
               "n" : "Cumulative",
               "dt" : "4",
               "dsc" : "Determines function form:
          - True. The Weibull function returns the integral function of distribution;
          - False. The Weibull function returns the distribution density function."
              }
            ]
          },
          {
           "n" : "ZTest",
           "dsc" : "The method returns the two-tailed P-value of z-test. The z-test determines a standard assessment for Value relative to data array and returns the two-tailed probability for normal distribution. This function can be used to assess the probability that the specific observation is taken from the specific entire population.",
           "prms" : 
            [
              {
               "n" : "Data",
               "dt" : "5",
               "dsc" : "Data array, with which Value is compared to."
              },
              {
               "n" : "Value",
               "dt" : "2",
               "dsc" : "Checked value."
              },
              {
               "n" : "Sigma",
               "dt" : "2",
               "dsc" : "Known standard deviation of the entire population."
              }
            ]
          },
          {
           "n" : "Mode",
           "dsc" : "The Mode method returns the mode, that is, the most frequently occurred value in data array. The Mode function is a measure of relative position of values. If the source array contains only unique values (occur once), then Mode returns NODATA (equal to 1#.QNAN).",
           "prms" : 
            {
             "n" : "Sample",
             "dt" : "5",
             "dsc" : "Data array.",
             "ext" : "1"
            }
          },
          {
           "n" : "JarqueBeraStat",
           "dsc" : "The JarqueBeraStat method returns the Jarque-Bera statistic. The Jarque-Bera test is used to check the hypothesis that an analyzed series has normal distribution.",
           "prms" : 
            {
             "n" : "Sample",
             "dt" : "5",
             "dsc" : "Data array."
            }
          }
        ]
      },
      {
       "n" : "Logical",
       "fns" : 
        [
          {
           "n" : "True",
           "dsc" : "Returns logical TRUE."
          },
          {
           "n" : "False",
           "dsc" : "Returns logical FALSE."
          },
          {
           "n" : "IIf",
           "dsc" : "Checks condition.",
           "prms" : 
            [
              {
               "n" : "logical_expression",
               "dt" : "4",
               "dsc" : "Condition."
              },
              {
               "n" : "ValueTrue",
               "dt" : "4",
               "dsc" : "Value if the condition is correct."
              },
              {
               "n" : "ValueFalse",
               "dt" : "4",
               "dsc" : "Value if the condition is incorrect."
              }
            ]
          },
          {
           "n" : "_Not",
           "dsc" : "Changes logical value of its argument to the opposite one.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "4",
             "dsc" : "First argument."
            }
          },
          {
           "n" : "IsEmpty",
           "dsc" : "Returns TRUE if the argument is a link to an empty cell, otherwise returns FALSE.",
           "prms" : 
            {
             "n" : "Value",
             "dt" : "5",
             "dsc" : "First argument."
            }
          },
          {
           "n" : "_Or",
           "dsc" : "Checks if at least one argument is set to TRUE and returns TRIUE or FALSE. The FALSE value is returned only if arguments are set to FALSE.",
           "prms" : 
            {
             "n" : "Logical_value",
             "dt" : "4",
             "dsc" : "Parameter.",
             "ext" : "1"
            }
          },
          {
           "n" : "_And",
           "dsc" : "Checks if all arguments are set to TRUE and returns TRUE if all arguments are set to TRUE.",
           "prms" : 
            {
             "n" : "Logical_value",
             "dt" : "4",
             "dsc" : "Parameter.",
             "ext" : "1"
            }
          }
        ]
      },
      {
       "n" : "Python",
       "fns" : 
        [
          {
           "n" : "PythonInvoke",
           "dsc" : "Returns the result of Python function execution.",
           "prms" : 
            [
              {
               "n" : "ModuleName",
               "dt" : "1",
               "dsc" : "Name of Python unit in the file system (the file with the *.py extension) or name of the system unit."
              },
              {
               "n" : "FunctionName",
               "dt" : "1",
               "dsc" : "Name of executed function."
              },
              {
               "n" : "Param",
               "dt" : "5",
               "dsc" : "Parameter sent to function.",
               "ext" : "1"
              }
            ]
          },
          {
           "n" : "PythonInvokeModule",
           "dsc" : "Returns the result of function stored in the Python unit.",
           "prms" : 
            [
              {
               "n" : "ModuleId",
               "dt" : "1",
               "dsc" : "Identifier of the Python unit in the repository."
              },
              {
               "n" : "FunctionName",
               "dt" : "1",
               "dsc" : "Name of executed function."
              },
              {
               "n" : "Param",
               "dt" : "5",
               "dsc" : "Parameter sent to function.",
               "ext" : "1"
              }
            ]
          }
        ]
      },
      {
       "n" : "Java",
       "fns" : 
        [
          {
           "n" : "JavaInvoke",
           "dsc" : "Returns the result of static Java method execution.",
           "prms" : 
            [
              {
               "n" : "ClassName",
               "dt" : "1",
               "dsc" : "Name of Java class in the file system (the file with the *.class extension) or name of the system class in the JNI signature."
              },
              {
               "n" : "MethodName",
               "dt" : "1",
               "dsc" : "Name of executed method."
              },
              {
               "n" : "MethodSig",
               "dt" : "1",
               "dsc" : "JNI signature of method."
              },
              {
               "n" : "Param",
               "dt" : "5",
               "dsc" : "Parameter sent to method.",
               "ext" : "1"
              }
            ]
          },
          {
           "n" : "JavaInvokeModule",
           "dsc" : "Returns the result of static method execution stored in the Java unit.",
           "prms" : 
            [
              {
               "n" : "ModuleId",
               "dt" : "1",
               "dsc" : "Identifier of Java unit in the repository."
              },
              {
               "n" : "ClassName",
               "dt" : "1",
               "dsc" : "Class name."
              },
              {
               "n" : "MethodName",
               "dt" : "1",
               "dsc" : "Name of executed method."
              },
              {
               "n" : "MethodSig",
               "dt" : "1",
               "dsc" : "JNI signature of method."
              },
              {
               "n" : "Param",
               "dt" : "5",
               "dsc" : "Parameter sent to method.",
               "ext" : "1"
              }
            ]
          }
        ]
      }
    ]
  }
}

public static GetTabStaticFormulasResult GetTabStaticFormulas()
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tGet = new GetTabStaticFormulas();
    // Get information about available functions
    var result = somClient.GetTabStaticFormulas(tGet);
    return result;
}

GetTabStaticFormulas

Syntax

Description

Comments

Example

SOAP request:

SOAP response:

JSON request:

JSON response: