﻿ FarPoint.CalcEngine Namespace | Spread Windows Forms 17
Spread Windows Forms 17
FarPoint.CalcEngine Assembly / FarPoint.CalcEngine Namespace
Inheritance Hierarchy
In This Topic
FarPoint.CalcEngine Namespace
In This Topic
Classes
ClassDescription
Returns the absolute value of the specified value.
Returns the accrued interest for a security that pays periodic interest.
Returns the accrued interest for a security that pays interest at maturity.
Returns the angle whose cosine is the specified value. The angle is in radians between 0 (zero) and pi.
Returns the inverse hyperbolic cosine of the specified value.
Represents the addition operator.
Creates a cell address as text, given specified row and column numbers.
Returns the depreciation for each accounting period.
Returns the depreciation for each accounting period.
Returns true if all its arguments are true; otherwise, returns false if one or more arguments are false.
Represents an expression with an array of constant values as the expression.
Represents a means of creating ArrayExpression objects in environments that do not support parameterized constructors.
Returns the angle whose sine is the specified value.
Returns the inverse hyperbolic sine of a number.
Returns the arctangent of the specified x- and y-coordinates.
Returns the angle whose tangent is the specified value.
Returns the inverse hyperbolic tangent of a number.
Returns the average of the absolute deviations of the specified values from their mean.
Returns the average of the specified values.
Returns the average of the specified values.

Returns the Bessel function of the first kind evaluated for purely imaginary arguments.
Returns the Bessel function of the first kind.
Returns the modified Bessel function of the second kind evaluated for purely imaginary arguments.
Returns the Bessel function of the second kind.
Returns the cumulative beta distribution function.
Returns the inverse of the cumulative beta distribution function.
Converts a binary number to decimal.
Converts a binary number to hexadecimal.
Converts a binary number to octal.
Represents an expression with a binary operator applied to a pair of operands as the expression.
Represents a means of creating BinaryOperatorExpression objects in environments that do not support parameterized constructors.
Represents the abstract base class for defining binary operators.
Returns the individual term binomial distribution probability.
Represents an expression type with a boolean constant value as the expression.
Represents a means of creating BooleanExpression objects in environments that do not support parameterized constructors.
Represents an array of constants during the evaluation of a formula.
Represents the converting of a value to a specified data type.
Represents calculation errors.
Converts CalcError objects to and from other data types.
Represents a missing argument during the evaluation of a formula.
Represents a cell or range reference during the evaluation of a formula.
Rounds a number up to the nearest multiple of a specified value.
Represents an expression with a cell reference as the expression.
Represents a means of creating CellExpression objects in environments that do not support parameterized constructors.
Returns the character specified by a number.
Returns the one-tailed probability of the chi-squared distribution.
Returns the inverse of the one-tailed probability of the chi-squared distribution.
Returns the test for independence from the chi-squared distribution.
Returns a value from a list of values.
Removes all nonprintable characters from text.
Returns a numeric code to represent the first character in a text string.
Returns the column number of a reference.
Returns the number of columns in an array or reference.
Returns the number of possible combinations for a specified number of items.

Combines multiple text strings or numbers into one text string.
Represents the concatenation operator.
Returns the confidence interval for a population mean.
Represents the abstract class from which all constant value expression types derive.
Returns an indication of whether a number is equal to a threshold.
Returns the correlation coefficient of the two sets of data.
Returns the cosine of the specified angle.
Returns the hyperbolic cosine of the specified value.
Counts the number of number values in the arguments.
Returns the number of empty (or blank) cells in a range of cells on a sheet.
Counts the number of number values in the arguments.
Counts values based on criteria.

Returns the number of days from the beginning of the coupon period to the settlement date.
Returns the number of days in the coupon period that contains the settlement date.
Returns the number of days from the settlement date to the next coupon date.
Returns a number that represents the next coupon date after the settlement date.
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
Returns a number that represents the previous coupon date before the settlement date.
Returns the average of the products of deviations for each data point pair in two sets of numbers.
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
Returns the cumulative interest paid on a loan between start_period and end_period.
Returns the cumulative principal paid on a loan between start_period and end_period.
Returns the number of days, months, or years betwwen two dates.
Returns the DateTime object for a particular date, specified by the year, month, and day.
Returns the DateTime object of the specified date.
Returns the average of values in a column in a list that match the specified conditions.
Returns the day number of the month (integer 1 to 31) that corresponds to the specified date.
Returns the number of days between two dates based on a 360-day year.
Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
Counts the cells that are not empty in a column in a list that match the specified conditions.
Counts the cells that contain numbers in a column in a list that match the specified conditions.
Returns the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.
Converts a decimal number to binary.
Converts a decimal number to hexadecimal.
Converts a decimal number to octal.
Converts the specified value from radians to degrees.
Identifies whether two values are equal.
Returns the sum of squares of deviations of data points from their sample mean.
Extracts a single value from a column in a list that matches the specified conditions.
Returns the discount rate for a security.
Represents the division operator.
Returns the largest number in a column in a list that matches the specified conditions.
Returns the smallest number in a column in a list that matches the specified conditions.
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
Converts a number to text using currency format, with the decimals rounded to the specified place.
Represents an expression with a double constant value as the expression.
Represents a means of creating DoubleExpression objects in environments that do not support parameterized constructors.
Multiplies the values in a column in a list that match the specified conditions.
Estimates the standard deviation of a population based on a sample, using the values in a column in a list that match the specified conditions.
Calculates 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.
Adds the values in a column in a list that match the specified conditions.
Returns the Macauley duration for an assumed par value of \$100.
Estimates the variance of a population based on a sample, using the values in a column in a list that match the specified conditions.
Calculates the variance of a population based on the entire population, using the values in a column in a list that match the specified conditions.
Returns the DateTime object that is the indicated number of months before or after a specified date.
Returns the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.
Returns 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.
Represents the equals operator.
Returns the complementary error function integrated between a lower limit and infinity.
Returns the error function integrated between a lower and an upper limit.
Represents an expression with an error constant value as the expression.
Represents a means of creating ErrorExpression objects in environments that do not support parameterized constructors.
Returns a number corresponding to one of the error values.
Converts a currency value from one source to another.
Returns one euro as a given national currency.
Rounds the specified value up to the nearest even integer.
Returns 1 (True) if two strings are the same; otherwise, 0 (False).
Returns e raised to the power of the specified value.
Returns the exponential distribution or the probability density.
Represents the exponent operator.
Represents the abstract class from which all expression types derive.
Represents an expression with an external cell reference as the expression.
Represents a means of creating ExternalCellExpression objects in environments that do not support parameterized constructors.
Represents an expression with an external named variable as the expression.
Represents an expression with an external range reference as the expression.
Represents a means of creating ExternalRangeExpression objects in environments that do not support parameterized constructors.
Represents the abstract class from which all external reference expression types derive.
Returns the double factorial of a number.
Returns the factorial of the specified number.
Returns the value for logical false.
Returns the F probability distribution, to see degrees of diversity between two sets of data.
Finds one text value within another.
Returns the inverse of the F probability distribution.
Returns the Fisher transformation for a specified value.
Returns the inverse of the Fisher transformation.
Rounds 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.
Rounds a number down to the nearest multiple of a specified value.
Calculates a future value using existing values.
Represents the FarPoint category attribute.
Returns the number of possible permutations for a specified number of items.
Represents the FTEST function.
Represents an expression with a function applied to a list of parameters as the expression.
Represents a means of creating FunctionExpression objects in environments that do not support parameterized constructors.
Represents an abstract base class for defining functions.
Returns the future value of an investment based on a present value, periodic payments, and a specified interest rate.
Returns the future value of an initial principal after applying a series of compound interest rates.
Returns the gamma distribution.
Returns the inverse of the gamma cumulative distribution.
Returns the natural logarithm of the Gamma function.
Returns the greatest common divisor of two numbers.
Returns the geometric mean of a set of positive data.
Returns an indication of whether a number is equal to a threshold.
Represents the greater than operator.
Represents the greater than or equal operator.

Returns the harmonic mean of a data set.
Converts a hexadecimal number to binary.
Converts a hexadecimal number to decimal.
Converts a hexadecimal number to octal.
Returns a value or the reference to a value from within an array or range.
Returns the hour that corresponds to the provided time.
Returns the hypergeometric distribution.

Returns one of two provided values based on a logical value after performing a comparison.

Returns a value or the reference to a value from within an array or range.
Calculates the point at which a line intersects the y-axis by using existing x-values and y-values.
Represents the intersect operator.
Rounds a specified number down to the nearest integer.
Returns the interest rate for a fully invested security.
Returns the calculation of payment of interest on a loan.
Returns the internal rate of return for a series of cash flows represented by the numbers in values.
Tests whether a value, expression, or referenced cell is empty.
Tests whether a value, expression, or referenced cell has an error other than not available (#N/A).
Tests whether a value, expression, or referenced cell has an error of any kind.
Tests whether a value, expression, or referenced cell is even.
Tests whether a value, expression, or referenced cell is a logical value.
Tests whether a value, expression, or referenced cell has the not available (#N/A) error value.
Tests whether a value, expression, or referenced cell has non-text data.
Tests whether a value, expression, or referenced cell has numeric data.
Tests whether a value, expression, or referenced cell is odd.

Tests whether a value is a cell reference.
Tests whether a value, expression, or referenced cell has text data.
Returns the kurtosis of a data set.
Returns the nth largest value in a data set.
Returns the least common multiple of integers.
Returns the first (or leftmost) characters from a text value.
Returns the number of characters in a text string.
Represents the less than operator.
Represents the less than or equal operator.

Returns the natural logarithm of the specified number.
Returns the logarithm base 10 of a number.

Returns the logarithm base Y of a number X.
Returns the inverse of the lognormal cumulative distribution function of x.
Returns the cumulative natural log normal distribution of x.
Returns a value or the reference to a value from within an array or range.
Converts text to lowercase letters.

Returns the maximum value of all arguments.
Returns the maximum value of all arguments.

Returns the modified duration for a security with an assumed par value of \$100.
Returns the number in the middle of the provided set of numbers.
Returns the requested number of characters from a text string starting at the position you specify.
Returns the minimum value of all arguments.
Returns the minimum value of all arguments.
Returns the minute corresponding to the provided time value.

Returns the modified internal rate of return for a series of periodic cash flows.
Represents an expression with a missing argument constant value as the expression.

Returns the most frequently occurring value in a set of data.
Returns the remainder after the Number argument (dividend) is divided by the Divisor argument.
Returns the month corresponding to the specified date value.
Returns a number rounded to the desired multiple.
Calculates the ratio of the factorial of a sum of values to the product of factorials.
Represents the multiplication operator.
Represents an expression with the two values as the reference expression.
Returns the error value #N/A that means 'not available'.
Represents an expression with a named variable as the expression.
Represents the unary negation operator.
Returns the negative binomial distribution.
Returns the number of whole working days between start date and end date.
Returns a value converted to a number.
Returns the nominal annual interest rate for a given effective rate and number of compounding periods per year.
Returns the normal cumulative distribution for the specified mean and standard deviation.
Returns the inverse of the normal cumulative distribution for the given mean and standard deviation.
Returns the standard normal cumulative distribution function.
Returns the inverse of the standard normal cumulative distribution.
Represents the not-equal operator.
Reverses the logical value of its argument.
Returns the DateTime object of the current date and time.
Returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate.
Calculates the net present value of an investment by using a discount rate and a series of future payments and income.
Converts a octal number to binary.
Converts a octal number to decimal.
Converts a octal number to hexadecimal.
Returns the price per \$100 face value of a security having an odd (short or long) first period.
Rounds the specified value up to the nearest odd integer.
Returns the yield of a security that has an odd (short or long) first period.
Returns the price per \$100 face value of a security having an odd (short or long) last coupon period.
Returns the yield of a security that has an odd (short or long) last period.
Returns a reference to a range that is the specified number of rows and columns from a the specified cell or range.
Represents the abstract base class for defining operators.
Returns true if any argument is true; returns false if all arguments are false.
Represents an expression type for parentheses surrounding a specified expression.
Represents a means of creating ParenthesesExpression objects in environments that do not support parameterized constructors.
Returns the Pearson product moment correlation coefficient.
Returns the nth percentile of values in a range.
Represents the percentage operator.
Returns the rank of a value in a data set as a percentage of the data set.
Returns the number of possible permutations for a specified number of items.
Provides pi as 3.1415926536.
Represents the unary plus operator.
Returns the payment amount for a loan given the present value, specified interest rate, and number of terms.
Returns the Poisson distribution.
Raises the specified number to the given power.
Returns the amount of payment of principal.
Returns the price per \$100 face value of a discounted security.
Returns the price per \$100 face value of a security that pays periodic interest.
Returns the price at maturity per \$100 face value of a security that pays interest.
Returns the probability that values in a range are between two limits.
Multiplies all the arguments and returns the product.
Capitalizes the first letter in each word of a text string.
Returns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value.
Returns the quartile (of which quarter or 25 percent) of a data set.
Returns the integer portion of a division.
Converts the specified number from degrees to radians.
Represents the RANDBETWEEN function.
Returns an evenly distributed random number greater than or equal to 0 and less than 1.
Represents an expression with a range reference as the expression.
Represents a means of creating RangeExpression objects in environments that do not support parameterized constructors.
Returns the rank of a number in a set of numbers.
Returns the interest rate per period of an annuity.
Returns the amount received at maturity for a fully invested security.
Represents the abstract class from which all reference expression types derive.
Replaces part of a text string with a different text string.
Repeats text a specified number of times.
Returns the rightmost characters from a text value.

Rounds the specified number down to the nearest number, using the specified number of decimal places.
Rounds the specified value to the nearest number, using the specified number of decimal places.
Rounds the specified number up to the nearest number, using the specified number of decimal places.
Returns the row number of a reference.
Returns the number of rows in an array or reference.
Represents the RSQ function.

Returns the seconds (0 to 59) value for a specified time value.
Returns the sum of a power series.
Returns the sign of a number.
Returns the sine of the specified angle.
Returns the hyperbolic sine of the specified number.
Returns the skewness of a distribution.
Returns the straight-line depreciation of an asset for one period.
Calculates the slope of a linear regression.
Returns the nth smallest value in a data set.
Returns the positive square root of the specified number.
Represents the SQRTPI function.
Returns a normalized value from a distribution characterized by mean and standard deviation.
Returns the standard deviation for a set of numbers.
Returns the standard deviation for a set of numbers.
Calculates standard deviation based on the entire population given as arguments.
Calculates standard deviation based on the entire population given as arguments.
Returns the standard error of the predicted y value for each x.
Represents an expression with a string constant value as the expression.
Substitutes a new string for specified characters in an existing string.
Returns a subtotal.
Represents the subtraction operator.
Sums values, cells, or blocks.
Sums values based on criteria.

Multiplies corresponding components in the given arrays, and returns the sum of those products.
Returns the sum of the squares of the arguments.
Returns the sum of the difference of the squares of two arrays.
Returns the sum of the sum of squares of corresponding values in two arrays.
Returns the sum of the difference of squares of corresponding values in two arrays.
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Represents an expression with a table reference as the expression.
Returns the tangent of the specified angle.
Returns the hyperbolic tangent of the specified number.
Returns the equivalent yield for a Treasury bill (or T-bill).
Returns the price per \$100 face value for a Treasury bill (or T-bill).
Returns the yield for a Treasury bill (or T-bill).
Returns the probability for the t-distribution.

Returns the text referred to by value.
Returns a TimeSpan object for the given hour, minute, and second.
Returns a TimeSpan object represented by a text string.
Returns the t-value of the t-distribution as a function of the probability and the degrees of freedom.
Returns the DateTime object of the current date.

Removes extra spaces from a string and leaves single spaces between words.
Returns the mean of a subset of data excluding the topmost and bottommost data.
Returns the value for logical true.
Removes the specified fractional part of the specified number.
Returns the probability associated with a t-test.
Returns the type of value.
Represents an expression with a unary operator applied to a single operand as the expression.
Represents a means of creating UnaryOperatorExpression objects in environments that do not support parameterized constructors.
Represents the abstract base class for defining unary operators.
Represents an undefined function.
Represents the union operator.
Converts text to uppercase.
Converts a string that represents a number to a number.
Calculates variance based on a sample of a population.
Calculates variance based on a sample of a population.
Calculates variance based on the entire population.
Calculates variance based on the entire population.
Returns the depreciation of an asset for any period you specify using the variable declining balance method.
Returns a value or the reference to a value from within an array or range.
Returns the number corresponding to the day of the week for a specified date.
Returns a number that indicates the week of the year numerically.
Returns the two-parameter Weibull distribution.
Returns a number that represents a date that is the indicated number of working days before or after start date.
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.
Returns the net present value for a schedule of cash flows that is not necessarily periodic.
Returns the year as an integer for a specified date.
Returns the year as an integer for a specified date.
Returns the annual yield for a discounted security.
Returns the yield on a security that pays periodic interest.
Returns the annual yield of a security that pays interest at maturity.
Returns the significance value of a z-test.
Interfaces
InterfaceDescription
Represents an interface which deal with arguments of an expression.
Enumerations
EnumerationDescription
Specifies table part where a table expression refer to.
See Also