Spread Windows Forms 14.0
FarPoint.CalcEngine Assembly / FarPoint.CalcEngine Namespace
Inheritance Hierarchy
In This Topic
    FarPoint.CalcEngine Namespace
    In This Topic
    Classes
     ClassDescription
    ClassReturns the absolute value of the specified value.
    ClassReturns the accrued interest for a security that pays periodic interest.
    ClassReturns the accrued interest for a security that pays interest at maturity.
    ClassReturns the angle whose cosine is the specified value. The angle is in radians between 0 (zero) and pi.
    ClassReturns the inverse hyperbolic cosine of the specified value.
    ClassRepresents the addition operator.
    ClassCreates a cell address as text, given specified row and column numbers.
    ClassReturns the depreciation for each accounting period.
    ClassReturns the depreciation for each accounting period.
    ClassReturns true if all its arguments are true; otherwise, returns false if one or more arguments are false.
    ClassRepresents an expression with an array of constant values as the expression.
    ClassRepresents a means of creating ArrayExpression objects in environments that do not support parameterized constructors.
    ClassReturns the angle whose sine is the specified value.
    ClassReturns the inverse hyperbolic sine of a number.
    ClassReturns the arctangent of the specified x- and y-coordinates.
    ClassReturns the angle whose tangent is the specified value.
    ClassReturns the inverse hyperbolic tangent of a number.
    ClassReturns the average of the absolute deviations of the specified values from their mean.
    ClassReturns the average of the specified values.
    ClassReturns the average of the specified values.
    Class 
    Class 
    ClassReturns the Bessel function of the first kind evaluated for purely imaginary arguments.
    ClassReturns the Bessel function of the first kind.
    ClassReturns the modified Bessel function of the second kind evaluated for purely imaginary arguments.
    ClassReturns the Bessel function of the second kind.
    ClassReturns the cumulative beta distribution function.
    ClassReturns the inverse of the cumulative beta distribution function.
    ClassConverts a binary number to decimal.
    ClassConverts a binary number to hexadecimal.
    ClassConverts a binary number to octal.
    ClassRepresents an expression with a binary operator applied to a pair of operands as the expression.
    ClassRepresents a means of creating BinaryOperatorExpression objects in environments that do not support parameterized constructors.
    ClassRepresents the abstract base class for defining binary operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReturns the individual term binomial distribution probability.
    ClassRepresents an expression type with a boolean constant value as the expression.
    ClassRepresents a means of creating BooleanExpression objects in environments that do not support parameterized constructors.
    ClassRepresents an array of constants during the evaluation of a formula. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassRepresents the converting of a value to a specified data type. This is a %[LangWord]static class% and so cannot be inherited or instantiated.
    ClassRepresents calculation errors.
    ClassConverts CalcError objects to and from other data types.
    ClassRepresents a missing argument during the evaluation of a formula.
    ClassRepresents a cell or range reference during the evaluation of a formula. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassRounds a number up to the nearest multiple of a specified value.
    ClassRepresents an expression with a cell reference as the expression.
    ClassRepresents a means of creating CellExpression objects in environments that do not support parameterized constructors.
    ClassReturns the character specified by a number.
    ClassReturns the one-tailed probability of the chi-squared distribution.
    ClassReturns the inverse of the one-tailed probability of the chi-squared distribution.
    ClassReturns the test for independence from the chi-squared distribution.
    ClassReturns a value from a list of values.
    ClassRemoves all nonprintable characters from text.
    ClassReturns a numeric code to represent the first character in a text string.
    ClassReturns the column number of a reference.
    ClassReturns the number of columns in an array or reference.
    ClassReturns the number of possible combinations for a specified number of items.
    Class 
    ClassCombines multiple text strings or numbers into one text string.
    ClassRepresents the concatenation operator.
    ClassReturns the confidence interval for a population mean.
    ClassRepresents the abstract class from which all constant value expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReturns an indication of whether a number is equal to a threshold.
    ClassReturns the correlation coefficient of the two sets of data.
    ClassReturns the cosine of the specified angle.
    ClassReturns the hyperbolic cosine of the specified value.
    ClassCounts the number of number values in the arguments.
    ClassReturns the number of empty (or blank) cells in a range of cells on a sheet.
    ClassCounts the number of number values in the arguments.
    ClassCounts values based on criteria.
    Class 
    ClassReturns the number of days from the beginning of the coupon period to the settlement date.
    ClassReturns the number of days in the coupon period that contains the settlement date.
    ClassReturns the number of days from the settlement date to the next coupon date.
    ClassReturns a number that represents the next coupon date after the settlement date.
    ClassReturns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
    ClassReturns a number that represents the previous coupon date before the settlement date.
    ClassReturns the average of the products of deviations for each data point pair in two sets of numbers.
    ClassReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
    ClassReturns the cumulative interest paid on a loan between start_period and end_period.
    ClassReturns the cumulative principal paid on a loan between start_period and end_period.
    ClassReturns the number of days, months, or years betwwen two dates.
    ClassReturns the DateTime object for a particular date, specified by the year, month, and day.
    ClassReturns the DateTime object of the specified date.
    ClassReturns the average of values in a column in a list that match the specified conditions.
    ClassReturns the day number of the month (integer 1 to 31) that corresponds to the specified date.
    ClassReturns the number of days between two dates based on a 360-day year.
    ClassReturns the depreciation of an asset for a specified period using the fixed-declining balance method.
    ClassCounts the cells that are not empty in a column in a list that match the specified conditions.
    ClassCounts the cells that contain numbers in a column in a list that match the specified conditions.
    ClassReturns the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.
    ClassConverts a decimal number to binary.
    ClassConverts a decimal number to hexadecimal.
    ClassConverts a decimal number to octal.
    ClassConverts the specified value from radians to degrees.
    ClassIdentifies whether two values are equal.
    ClassReturns the sum of squares of deviations of data points from their sample mean.
    ClassExtracts a single value from a column in a list that matches the specified conditions.
    ClassReturns the discount rate for a security.
    ClassRepresents the division operator.
    ClassReturns the largest number in a column in a list that matches the specified conditions.
    ClassReturns the smallest number in a column in a list that matches the specified conditions.
    ClassConverts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
    ClassConverts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
    ClassConverts a number to text using currency format, with the decimals rounded to the specified place.
    ClassRepresents an expression with a double constant value as the expression.
    ClassRepresents a means of creating DoubleExpression objects in environments that do not support parameterized constructors.
    ClassMultiplies the values in a column in a list that match the specified conditions.
    ClassEstimates the standard deviation of a population based on a sample, using the values in a column in a list that match the specified conditions.
    ClassCalculates the standard deviation of a population based on the entire populcation, using the values in a column in a list that match the specified conditions.
    ClassAdds the values in a column in a list that match the specified conditions.
    ClassReturns the Macauley duration for an assumed par value of $100.
    ClassEstimates the variance of a population based on a sample, using the values in a column in a list that match the specified conditions.
    ClassCalculates the variance of a population based on the entire population, using the values in a column in a list that match the specified conditions.
    ClassReturns the DateTime object that is the indicated number of months before or after a specified date.
    ClassReturns the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.
    ClassReturns the DateTime object for the last day of the month (end of month) that is the indicated number of months before or after the start date.
    ClassRepresents the equals operator.
    ClassReturns the complementary error function integrated between a lower limit and infinity.
    ClassReturns the error function integrated between a lower and an upper limit.
    ClassRepresents an expression with an error constant value as the expression.
    ClassRepresents a means of creating ErrorExpression objects in environments that do not support parameterized constructors.
    ClassReturns a number corresponding to one of the error values.
    ClassConverts a currency value from one source to another.
    ClassReturns one euro as a given national currency.
    ClassRounds the specified value up to the nearest even integer.
    ClassReturns 1 (True) if two strings are the same; otherwise, 0 (False).
    ClassReturns e raised to the power of the specified value.
    ClassReturns the exponential distribution or the probability density.
    ClassRepresents the exponent operator.
    ClassRepresents the abstract class from which all expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassRepresents an expression with an external cell reference as the expression.
    ClassRepresents a means of creating ExternalCellExpression objects in environments that do not support parameterized constructors.
    ClassRepresents an expression with an external named variable as the expression.
    ClassRepresents an expression with an external range reference as the expression.
    ClassRepresents a means of creating ExternalRangeExpression objects in environments that do not support parameterized constructors.
    ClassRepresents the abstract class from which all external reference expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReturns the double factorial of a number.
    ClassReturns the factorial of the specified number.
    ClassReturns the value for logical false.
    ClassReturns the F probability distribution, to see degrees of diversity between two sets of data.
    ClassFinds one text value within another.
    ClassReturns the inverse of the F probability distribution.
    ClassReturns the Fisher transformation for a specified value.
    ClassReturns the inverse of the Fisher transformation.
    ClassRounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
    ClassRounds a number down to the nearest multiple of a specified value.
    ClassCalculates a future value using existing values.
    ClassRepresents the FarPoint category attribute.
    ClassReturns the number of possible permutations for a specified number of items.
    ClassRepresents the FTEST function.
    ClassRepresents an expression with a function applied to a list of parameters as the expression.
    ClassRepresents a means of creating FunctionExpression objects in environments that do not support parameterized constructors.
    ClassRepresents an abstract base class for defining functions. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReturns the future value of an investment based on a present value, periodic payments, and a specified interest rate.
    ClassReturns the future value of an initial principal after applying a series of compound interest rates.
    ClassReturns the gamma distribution.
    ClassReturns the inverse of the gamma cumulative distribution.
    ClassReturns the natural logarithm of the Gamma function.
    ClassReturns the greatest common divisor of two numbers.
    ClassReturns the geometric mean of a set of positive data.
    ClassReturns an indication of whether a number is equal to a threshold.
    ClassRepresents the greater than operator.
    ClassRepresents the greater than or equal operator.
    Class 
    ClassReturns the harmonic mean of a data set.
    ClassConverts a hexadecimal number to binary.
    ClassConverts a hexadecimal number to decimal.
    ClassConverts a hexadecimal number to octal.
    ClassReturns a value or the reference to a value from within an array or range.
    ClassReturns the hour that corresponds to the provided time.
    ClassReturns the hypergeometric distribution.
    Class 
    ClassReturns one of two provided values based on a logical value after performing a comparison.
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    Class 
    ClassReturns a value or the reference to a value from within an array or range.
    ClassCalculates the point at which a line intersects the y-axis by using existing x-values and y-values.
    ClassRepresents the intersect operator.
    ClassRounds a specified number down to the nearest integer.
    ClassReturns the interest rate for a fully invested security.
    ClassReturns the calculation of payment of interest on a loan.
    ClassReturns the internal rate of return for a series of cash flows represented by the numbers in values.
    ClassTests whether a value, expression, or referenced cell is empty.
    ClassTests whether a value, expression, or referenced cell has an error other than not available (#N/A).
    ClassTests whether a value, expression, or referenced cell has an error of any kind.
    ClassTests whether a value, expression, or referenced cell is even.
    ClassTests whether a value, expression, or referenced cell is a logical value.
    ClassTests whether a value, expression, or referenced cell has the not available (#N/A) error value.
    ClassTests whether a value, expression, or referenced cell has non-text data.
    ClassTests whether a value, expression, or referenced cell has numeric data.
    ClassTests whether a value, expression, or referenced cell is odd.
    Class 
    ClassTests whether a value is a cell reference.
    ClassTests whether a value, expression, or referenced cell has text data.
    ClassReturns the kurtosis of a data set.
    ClassReturns the nth largest value in a data set.
    ClassReturns the least common multiple of integers.
    ClassReturns the first (or leftmost) characters from a text value.
    ClassReturns the number of characters in a text string.
    ClassRepresents the less than operator.
    ClassRepresents the less than or equal operator.
    Class 
    ClassReturns the natural logarithm of the specified number.
    ClassReturns the logarithm base 10 of a number.
    Class 
    ClassReturns the logarithm base Y of a number X.
    ClassReturns the inverse of the lognormal cumulative distribution function of x.
    ClassReturns the cumulative natural log normal distribution of x.
    ClassReturns a value or the reference to a value from within an array or range.
    ClassConverts text to lowercase letters.
    Class 
    ClassReturns the maximum value of all arguments.
    ClassReturns the maximum value of all arguments.
    Class 
    ClassReturns the modified duration for a security with an assumed par value of $100.
    ClassReturns the number in the middle of the provided set of numbers.
    ClassReturns the requested number of characters from a text string starting at the position you specify.
    ClassReturns the minimum value of all arguments.
    ClassReturns the minimum value of all arguments.
    ClassReturns the minute corresponding to the provided time value.
    Class 
    ClassReturns the modified internal rate of return for a series of periodic cash flows.
    ClassRepresents an expression with a missing argument constant value as the expression.
    Class 
    ClassReturns the most frequently occurring value in a set of data.
    ClassReturns the remainder after the Number argument (dividend) is divided by the Divisor argument.
    ClassReturns the month corresponding to the specified date value.
    ClassReturns a number rounded to the desired multiple.
    ClassCalculates the ratio of the factorial of a sum of values to the product of factorials.
    ClassRepresents the multiplication operator.
    ClassRepresents an expression with the two values as the reference expression.
    ClassReturns the error value #N/A that means 'not available'.
    ClassRepresents an expression with a named variable as the expression.
    ClassRepresents the unary negation operator.
    ClassReturns the negative binomial distribution.
    ClassReturns the number of whole working days between start date and end date.
    ClassReturns a value converted to a number.
    ClassReturns the nominal annual interest rate for a given effective rate and number of compounding periods per year.
    ClassReturns the normal cumulative distribution for the specified mean and standard deviation.
    ClassReturns the inverse of the normal cumulative distribution for the given mean and standard deviation.
    ClassReturns the standard normal cumulative distribution function.
    ClassReturns the inverse of the standard normal cumulative distribution.
    ClassRepresents the not-equal operator.
    ClassReverses the logical value of its argument.
    ClassReturns the DateTime object of the current date and time.
    ClassReturns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate.
    ClassCalculates the net present value of an investment by using a discount rate and a series of future payments and income.
    ClassConverts a octal number to binary.
    ClassConverts a octal number to decimal.
    ClassConverts a octal number to hexadecimal.
    ClassReturns the price per $100 face value of a security having an odd (short or long) first period.
    ClassRounds the specified value up to the nearest odd integer.
    ClassReturns the yield of a security that has an odd (short or long) first period.
    ClassReturns the price per $100 face value of a security having an odd (short or long) last coupon period.
    ClassReturns the yield of a security that has an odd (short or long) last period.
    ClassReturns a reference to a range that is the specified number of rows and columns from a the specified cell or range.
    ClassRepresents the abstract base class for defining operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReturns true if any argument is true; returns false if all arguments are false.
    ClassRepresents an expression type for parentheses surrounding a specified expression.
    ClassRepresents a means of creating ParenthesesExpression objects in environments that do not support parameterized constructors.
    ClassReturns the Pearson product moment correlation coefficient.
    ClassReturns the nth percentile of values in a range.
    ClassRepresents the percentage operator.
    ClassReturns the rank of a value in a data set as a percentage of the data set.
    ClassReturns the number of possible permutations for a specified number of items.
    ClassProvides pi as 3.1415926536.
    ClassRepresents the unary plus operator.
    ClassReturns the payment amount for a loan given the present value, specified interest rate, and number of terms.
    ClassReturns the Poisson distribution.
    ClassRaises the specified number to the given power.
    ClassReturns the amount of payment of principal.
    ClassReturns the price per $100 face value of a discounted security.
    ClassReturns the price per $100 face value of a security that pays periodic interest.
    ClassReturns the price at maturity per $100 face value of a security that pays interest.
    ClassReturns the probability that values in a range are between two limits.
    ClassMultiplies all the arguments and returns the product.
    ClassCapitalizes the first letter in each word of a text string.
    ClassReturns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value.
    ClassReturns the quartile (of which quarter or 25 percent) of a data set.
    ClassReturns the integer portion of a division.
    ClassConverts the specified number from degrees to radians.
    ClassRepresents the RANDBETWEEN function.
    ClassReturns an evenly distributed random number greater than or equal to 0 and less than 1.
    ClassRepresents an expression with a range reference as the expression.
    ClassRepresents a means of creating RangeExpression objects in environments that do not support parameterized constructors.
    ClassReturns the rank of a number in a set of numbers.
    ClassReturns the interest rate per period of an annuity.
    ClassReturns the amount received at maturity for a fully invested security.
    ClassRepresents the abstract class from which all reference expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassReplaces part of a text string with a different text string.
    ClassRepeats text a specified number of times.
    ClassReturns the rightmost characters from a text value.
    Class 
    ClassRounds the specified number down to the nearest number, using the specified number of decimal places.
    ClassRounds the specified value to the nearest number, using the specified number of decimal places.
    ClassRounds the specified number up to the nearest number, using the specified number of decimal places.
    ClassReturns the row number of a reference.
    ClassReturns the number of rows in an array or reference.
    ClassRepresents the RSQ function.
    Class 
    ClassReturns the seconds (0 to 59) value for a specified time value.
    ClassReturns the sum of a power series.
    ClassReturns the sign of a number.
    ClassReturns the sine of the specified angle.
    ClassReturns the hyperbolic sine of the specified number.
    ClassReturns the skewness of a distribution.
    ClassReturns the straight-line depreciation of an asset for one period.
    ClassCalculates the slope of a linear regression.
    ClassReturns the nth smallest value in a data set.
    ClassReturns the positive square root of the specified number.
    ClassRepresents the SQRTPI function.
    ClassReturns a normalized value from a distribution characterized by mean and standard deviation.
    ClassReturns the standard deviation for a set of numbers.
    ClassReturns the standard deviation for a set of numbers.
    ClassCalculates standard deviation based on the entire population given as arguments.
    ClassCalculates standard deviation based on the entire population given as arguments.
    ClassReturns the standard error of the predicted y value for each x.
    ClassRepresents an expression with a string constant value as the expression.
    ClassSubstitutes a new string for specified characters in an existing string.
    ClassReturns a subtotal.
    ClassRepresents the subtraction operator.
    ClassSums values, cells, or blocks.
    ClassSums values based on criteria.
    Class 
    ClassMultiplies corresponding components in the given arrays, and returns the sum of those products.
    ClassReturns the sum of the squares of the arguments.
    ClassReturns the sum of the difference of the squares of two arrays.
    ClassReturns the sum of the sum of squares of corresponding values in two arrays.
    ClassReturns the sum of the difference of squares of corresponding values in two arrays.
    ClassReturns the sum-of-years' digits depreciation of an asset for a specified period.
    ClassRepresents an expression with a table reference as the expression.
    ClassReturns the tangent of the specified angle.
    ClassReturns the hyperbolic tangent of the specified number.
    ClassReturns the equivalent yield for a Treasury bill (or T-bill).
    ClassReturns the price per $100 face value for a Treasury bill (or T-bill).
    ClassReturns the yield for a Treasury bill (or T-bill).
    ClassReturns the probability for the t-distribution.
    Class 
    ClassReturns the text referred to by value.
    ClassReturns a TimeSpan object for the given hour, minute, and second.
    ClassReturns a TimeSpan object represented by a text string.
    ClassReturns the t-value of the t-distribution as a function of the probability and the degrees of freedom.
    ClassReturns the DateTime object of the current date.
    Class 
    Class 
    ClassRemoves extra spaces from a string and leaves single spaces between words.
    ClassReturns the mean of a subset of data excluding the topmost and bottommost data.
    ClassReturns the value for logical true.
    ClassRemoves the specified fractional part of the specified number.
    ClassReturns the probability associated with a t-test.
    ClassReturns the type of value.
    ClassRepresents an expression with a unary operator applied to a single operand as the expression.
    ClassRepresents a means of creating UnaryOperatorExpression objects in environments that do not support parameterized constructors.
    ClassRepresents the abstract base class for defining unary operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated.
    ClassRepresents an undefined function.
    ClassRepresents the union operator.
    ClassConverts text to uppercase.
    ClassConverts a string that represents a number to a number.
    ClassCalculates variance based on a sample of a population.
    ClassCalculates variance based on a sample of a population.
    ClassCalculates variance based on the entire population.
    ClassCalculates variance based on the entire population.
    ClassReturns the depreciation of an asset for any period you specify using the variable declining balance method.
    ClassReturns a value or the reference to a value from within an array or range.
    ClassReturns the number corresponding to the day of the week for a specified date.
    ClassReturns a number that indicates the week of the year numerically.
    ClassReturns the two-parameter Weibull distribution.
    ClassReturns a number that represents a date that is the indicated number of working days before or after start date.
    ClassReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
    ClassReturns the net present value for a schedule of cash flows that is not necessarily periodic.
    ClassReturns the year as an integer for a specified date.
    ClassReturns the year as an integer for a specified date.
    ClassReturns the annual yield for a discounted security.
    ClassReturns the yield on a security that pays periodic interest.
    ClassReturns the annual yield of a security that pays interest at maturity.
    ClassReturns the significance value of a z-test.
    Interfaces
     InterfaceDescription
    InterfaceRepresents an interface which deal with arguments of an expression.
    Enumerations
     EnumerationDescription
    EnumerationSpecifies table part where a table expression refer to.
    See Also