Class | Description | |
---|---|---|
![]() | BuiltInFunctionBase | Base class for the built in functions. |
![]() | FormulaErrorBaseEventArgs | |
![]() | UCEventQueue | Summary description for UCEventQueue. |
![]() | UCFunctionFactory | This class manages the list of formula functions available in UltraCalc as well as methods to locate and instaniate function classes. |
![]() | UltraCalcBinaryOperatorBase | Abstract base class for binary operator functions. |
![]() | UltraCalcFunction | Base class for formula functions. |
![]() | UltraCalcFunctionAbs | Calculates a number's absolute value. |
![]() | UltraCalcFunctionACos | Returns the angle (measured in radians) having the specified value of the trigonometric cosine function. |
![]() | UltraCalcFunctionACosh | Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function. |
![]() | UltraCalcFunctionAnd | Logical-AND returns the boolean value, FALSE, if at least one argument has a value of FALSE. When all arguments are TRUE, then this function returns TRUE. |
![]() | UltraCalcFunctionASin | Returns the angle (measured in radians) having the specified value of the trigonometric sine function. |
![]() | UltraCalcFunctionASinh | Returns the angle (measured in radians) having the specified value of it's hyperbolic sine function. |
![]() | UltraCalcFunctionATan | Calculates the normalized angle (measured in radians) which has the specified tangent function value. |
![]() | UltraCalcFunctionATan2 | Calculates the angle made with the x-axis on a Cartesian coordinate plane by the specified (x, y) coordinates. |
![]() | UltraCalcFunctionATanh | Calculates the hyperbolic tangent of a specified angle measured in radians. |
![]() | UltraCalcFunctionAveDev | Returns the average deviation from the average of all numeric values. |
![]() | UltraCalcFunctionAverage | Calculates an average (arithmetic mean) for a series of numbers. |
![]() | UltraCalcFunctionBin2Dec | Returns the decimal value of a string representation of a number in a binary system. |
![]() | UltraCalcFunctionBin2Hex | Converts a string representing a binary number to a string representing the same number in the hexadecimal number system. |
![]() | UltraCalcFunctionBin2Oct | Converts a string representing a binary number to a string representing the same number in the octal number system. |
![]() | UltraCalcFunctionBinomDist | Returns the individual term binomial distribution probability. |
![]() | UltraCalcFunctionCeiling | Returns the smallest whole number greater than or equal to the given number |
![]() | UltraCalcFunctionChar | Returns the character specified by the code number from the character set for your computer. |
![]() | UltraCalcFunctionChoose | The CHOOSE function returns one of the values provided in its arguments based on the number in the first argument. |
![]() | UltraCalcFunctionCode | Gives you the numeric code corresponding the the first character in a specific text string. |
![]() | UltraCalcFunctionCombin | Returns the number of possible combinations given a set of items and a number of chosen items from that set. |
![]() | UltraCalcFunctionCombina | Returns the number of possible combinations (with repetitions) given a set of items and a number of chosen items from that set. |
![]() | UltraCalcFunctionComplex | Returns a complex number represented as a string in the format "x + yi" or "x + yj" by comining a real and imaginary number. |
![]() | UltraCalcFunctionConcat | '&' formula operator used to concatenate two strings. ("First" & "Second") |
![]() | UltraCalcFunctionConcatenate | Combines two or more text values into a single text string. |
![]() | UltraCalcFunctionConvert | Converts a value from one system of measurement to another. For example, meters to inches or hours to seconds. |
![]() | UltraCalcFunctionCos | Calculates the trigonometric cosine of a specified angle (measured in radians). |
![]() | UltraCalcFunctionCosh | Returns the angle (measured in radians) having the specified value of it's hyperbolic cosine function. |
![]() | UltraCalcFunctionCount | Counts how many cells have numeric or date/time values. |
![]() | UltraCalcFunctionCountA | Counts how many cells are not blank. |
![]() | UltraCalcFunctionCritBinom | Returns the the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
![]() | UltraCalcFunctionDate | Returns the .NET DateTime ticks number that represents a particular date |
![]() | UltraCalcFunctionDateAdd | Returns a System.DateTime value resulting from adding a specified interval to a DateTime. |
![]() | UltraCalcFunctionDateDiff | Returns a value specifying the number of time intervals between two DateTime values. |
![]() | UltraCalcFunctionDateValue | Returns the .NET DateTime of the time represented by date formated in a string |
![]() | UltraCalcFunctionDay | Returns the day of a date value |
![]() | UltraCalcFunctionDays360 | Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. |
![]() | UltraCalcFunctionDB | Calculates an asset's depreciation using the fixed declining balance (DB) method over a specified term. |
![]() | UltraCalcFunctionDBNull | Returns DBNull |
![]() | UltraCalcFunctionDDB | Calculates an asset's depreciation using the double declining balance (DDB) or another weighted factor method over a specified term. |
![]() | UltraCalcFunctionDec2Bin | Returns a string representing the specified decimal value as a binary number. |
![]() | UltraCalcFunctionDec2Hex | Returns a string representing the specified decimal value as a hexadecimal number. |
![]() | UltraCalcFunctionDec2Oct | Returns a string representing the specified decimal value as a octal number. |
![]() | UltraCalcFunctionDec2XBase | Returns a string representing the specified decimal value in the specified base number scheme. |
![]() | UltraCalcFunctionDegrees | Converts radians to degrees. |
![]() | UltraCalcFunctionDelta | Compares two numbers and returns 1 if they are equal or 0 if they are not. |
![]() | UltraCalcFunctionDescriptor | Describes a function table entry and provides methods to access information about the function's arguments. |
![]() | UltraCalcFunctionDivide | '/' Division formula operator (3/2) |
![]() | UltraCalcFunctionDollarDe | Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction. |
![]() | UltraCalcFunctionDollarFr | Converts a dollary amount expressed as a decimal into a dollar amount expressed as a fraction. |
![]() | UltraCalcFunctionEDate | Returns a date that is the specified number of months before or after the start date. |
![]() | UltraCalcFunctionEOMonth | Returns a date that is at the end of the month which is the specified number of months before or after the start date. |
![]() | UltraCalcFunctionEqual | '=' Equality formula operator (Price = 200) |
![]() | UltraCalcFunctionErrorType | When an error value is returned, the ERRORTYPE function returns a numeric value corresponding to the UltraCalcErrorCode enumeration. |
![]() | UltraCalcFunctionEven | Rounds a positive number up and a negative number down to the nearest even integer. |
![]() | UltraCalcFunctionExp | Calculates the mathematical constant, e, raised to the specified power. |
![]() | UltraCalcFunctionExpon | "^" Exponentiation formula operator (3^2) |
![]() | UltraCalcFunctionFact | Returns the factorial of a number. |
![]() | UltraCalcFunctionFactDouble | Returns the double factorial of a number. |
![]() | UltraCalcFunctionFactory | Class used to manage the stock and user defined UltraCalcFunction instances |
![]() | UltraCalcFunctionFalse | A constant function always returning the FALSE value of Boolean logic. |
![]() | UltraCalcFunctionFind | Finds one piece of text within another piece of text. |
![]() | UltraCalcFunctionFixed | Formats a numeric value rounded to a specified number of decimal places and with optional thousands separators. |
![]() | UltraCalcFunctionFloor | Calculates the next lesser whole number for a specified numeric value. |
![]() | UltraCalcFunctionFV | Calculates the future value of an annuity having fixed payments and assuming a fixed interest rate or rate of return. |
![]() | UltraCalcFunctionGcd | Returns the greatest common divisor of integer values. |
![]() | UltraCalcFunctionGE | ">=" Greater than or equal formula operator (Price >= 200) |
![]() | UltraCalcFunctionGeStep | Compares two numbers and returns 1 the first number is greater than or equal to the second or returns 0 if not. |
![]() | UltraCalcFunctionGT | ">" Greater than formula operator (Price > 200) |
![]() | UltraCalcFunctionHex2Bin | Converts a string representing an hexadecimal number to a string representing the same number in the binary number system. |
![]() | UltraCalcFunctionHex2Dec | Returns the decimal value of a string representation of a number in a hexadecimal system. |
![]() | UltraCalcFunctionHex2Oct | Converts a string representing an hexadecimal number to a string representing the same number in the octal number system. |
![]() | UltraCalcFunctionHour | Returns the hour of a time value |
![]() | UltraCalcFunctionIf | Chooses between two outcomes (or UltraCalc expressions to evaluate) based on the result of a logical test on a value or UltraCalc expression you specify. |
![]() | UltraCalcFunctionIfError | Returns one of two values depending on whether or not the first value is an error or not. |
![]() | UltraCalcFunctionImAbs | Returns the absolute value of a complex number. |
![]() | UltraCalcFunctionImaginary | Returns the imaginary coefficient of a complex number. |
![]() | UltraCalcFunctionImArgument | Returns the argument theta, and angle expressed in radians. |
![]() | UltraCalcFunctionImConjugate | Returns the conjugate of a complex number. |
![]() | UltraCalcFunctionImCos | Returns the cosine of a complex number. |
![]() | UltraCalcFunctionImDiv | Returns the quotient of two complex numbers. |
![]() | UltraCalcFunctionImExp | Returns the exponential of a complex number. |
![]() | UltraCalcFunctionImLn | Returns the natural logarithm of a complex number. |
![]() | UltraCalcFunctionImLog10 | Returns the base-10 logarithm of a complex number. |
![]() | UltraCalcFunctionImLog2 | Returns the base-2 logarithm of a complex number. |
![]() | UltraCalcFunctionImPower | Returns the complex number raised to the specified power. |
![]() | UltraCalcFunctionImProduct | Returns the product of 1 to n complex numbers. |
![]() | UltraCalcFunctionImReal | Returns the real coefficient of a complex number. |
![]() | UltraCalcFunctionImSin | Returns the sine of a complex number. |
![]() | UltraCalcFunctionImSqrt | Returns the square root of a complex number. |
![]() | UltraCalcFunctionImSub | Returns the difference between two complex numbers. |
![]() | UltraCalcFunctionImSum | Returns the sum of 1 to n complex numbers. |
![]() | UltraCalcFunctionInfo | Returns information about the current operating environment. |
![]() | UltraCalcFunctionInt | Converts a real numeric value (which may have a fractional part) into a whole number. |
![]() | UltraCalcFunctionIntRate | Calculates the interest rate yielded by a security investment redeemable at a future date, such as a zero coupon bond. |
![]() | UltraCalcFunctionIPmt | Calculates the interest portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest. |
![]() | UltraCalcFunctionIRR | Calculates an internal rate of return for a given series of cash flows represented by either positive (incoming) or negative (outgoing) numeric values. |
![]() | UltraCalcFunctionIsBlank | Returns TRUE if the specified value is blank. |
![]() | UltraCalcFunctionIsDBNull | Returns a boolean indicating if the value is DBNull. |
![]() | UltraCalcFunctionIsErr | Returns TRUE if the specified value is any error value, except #N/A! |
![]() | UltraCalcFunctionIsError | Returns TRUE if the specified value is any error value without exception. |
![]() | UltraCalcFunctionIsEven | Returns TRUE if the specified value is an even number. |
![]() | UltraCalcFunctionIsLogical | Returns TRUE if the specified value refers to a two-state logic or Boolean value. |
![]() | UltraCalcFunctionIsNa | Returns TRUE if an error value is #N/A (not applicable.) |
![]() | UltraCalcFunctionIsNonText | Returns TRUE if the specified value refers to any not-text value. |
![]() | UltraCalcFunctionIsNull | Returns a boolean indicating if the value is null (Nothing in VB). |
![]() | UltraCalcFunctionIsNumber | Returns TRUE if the specified value refers to a numeric value. |
![]() | UltraCalcFunctionIsOdd | Returns TRUE if the specified value is an odd number. |
![]() | UltraCalcFunctionIsRef | Returns TRUE if the specified value is an UltraCalc reference. |
![]() | UltraCalcFunctionIsText | Returns TRUE if the specified value refers to a text (or string) value. |
![]() | UltraCalcFunctionLcm | Returns the least common multiple of integer values. |
![]() | UltraCalcFunctionLE | "<=" Less than or equal formula operator (Price <= 200) |
![]() | UltraCalcFunctionLeft | Gets the leftmost characters from a text value, up to the specified number of characters. |
![]() | UltraCalcFunctionLen | Counts the number of characters in a text value. |
![]() | UltraCalcFunctionLn | Calculates the natural logarithm of a specified numeric value. |
![]() | UltraCalcFunctionLog | Calculates a logarithm for a specified numeric value to the specified base. |
![]() | UltraCalcFunctionLog10 | Calculates the logarithm (base 10) of a specified numeric value. |
![]() | UltraCalcFunctionLower | Converts a text value to all lowercase letters. |
![]() | UltraCalcFunctionLT | '<' Less than formula operator (Price < 200) |
![]() | UltraCalcFunctionMax | Gives you the largest numeric value out of a series. |
![]() | UltraCalcFunctionMedian | Calculates the median value of a specified list of numeric values. |
![]() | UltraCalcFunctionMid | Gets a specified number of characters from the middle of a text string, starting from a specified position in that string. |
![]() | UltraCalcFunctionMin | Gives you the smallest numeric value out of a series. |
![]() | UltraCalcFunctionMinus | '-' Subtraction formula operator (3-2) |
![]() | UltraCalcFunctionMinute | Returns the minute of a time value |
![]() | UltraCalcFunctionMod | Gets the remainder following integer division of two numbers. |
![]() | UltraCalcFunctionMonth | Returns the month of a date value |
![]() | UltraCalcFunctionMRound | Rounds a number to the nearest multiple of another number. |
![]() | UltraCalcFunctionMultinomial | Returns the multinomial of a set of numbers. |
![]() | UltraCalcFunctionMultiply | '*' Multiplication formula operator (2*3) |
![]() | UltraCalcFunctionN | Converts a value to a number. |
![]() | UltraCalcFunctionNa | Returns #N/A!, the error value representing a not applicable result. |
![]() | UltraCalcFunctionNE | "<>" Inequality formula operator (Price <> 200) |
![]() | UltraCalcFunctionNetWorkDays | Returns the total number of whole work days between the specified dates, excluding any specified holidays. |
![]() | UltraCalcFunctionNot | Logical-NOT returns the inverse boolean value of it's argument. |
![]() | UltraCalcFunctionNow | Returns a .NET DateTime ticks value of the current day and time |
![]() | UltraCalcFunctionNPer | Calculates an investment's number of payment periods when the payment frequency, amount, and interest rate are held steady. |
![]() | UltraCalcFunctionNPV | Calculates an investment's Net Present Value given it's expected rate or return and the cash flow represented as positive numeric values (income) and negative numeric values (payments). |
![]() | UltraCalcFunctionNull | Returns a null value (Nothing in VB) |
![]() | UltraCalcFunctionOct2Bin | Converts a string representing an octal number to a string representing the same number in the binary number system. |
![]() | UltraCalcFunctionOct2Dec | Returns the decimal value of a string representation of a number in a octal system. |
![]() | UltraCalcFunctionOct2Hex | Converts a string representing an octal number to a string representing the same number in the hexadecimal number system. |
![]() | UltraCalcFunctionOdd | Rounds a positive number up and a negative number down to the nearest odd integer. |
![]() | UltraCalcFunctionOr | Logical-OR returns the boolean value, TRUE, if at least one argument has a value of TRUE. When all arguments are FALSE, then this function returns FALSE. |
![]() | UltraCalcFunctionPercent | '%' Percent formula operator (20%) |
![]() | UltraCalcFunctionPi | Returns the mathematical constant for the Greek letter, pi. |
![]() | UltraCalcFunctionPlus | '+' Addition formula operator (1+2) |
![]() | UltraCalcFunctionPmt | Calculates what the payment amount should be on a loan at a fixed interest rate requiring a fixed number of payments. |
![]() | UltraCalcFunctionPower | Raises the specific number to a power. |
![]() | UltraCalcFunctionPPmt | Calculates the principal portion of a payment due on an investment or loan with periodic, fixed payments and having a fixed rate of interest. |
![]() | UltraCalcFunctionProduct | Multiplies a series of numbers to return their total product. |
![]() | UltraCalcFunctionPV | Calculates an investment's present value by discounting what a series of fixed future payments is worth at a specified interest rate. |
![]() | UltraCalcFunctionQuotient | Performs integer division on two numbers disregarding any remainder. |
![]() | UltraCalcFunctionRadians | Converts degrees to radians. |
![]() | UltraCalcFunctionRand | Generates a pseudorandom number from zero up to (but not including) one. |
![]() | UltraCalcFunctionRandBetween | Generates a pseudorandom integer between two specified numbers. |
![]() | UltraCalcFunctionRate | Calculates the per-period interest rate for a series of cash flows (an annuity). |
![]() | UltraCalcFunctionReplace | Replaces a substring of a text value with some new text. This substring is specified by giving it's starting point and it's length in characters, within the original text value. |
![]() | UltraCalcFunctionRept | Repeats text a specific number of times. |
![]() | UltraCalcFunctionRight | Gets the rightmost characters from a text value, up to the specified number of characters. |
![]() | UltraCalcFunctionRoman | Converts a number into a roman number as a string. |
![]() | UltraCalcFunctionRound | Rounds the fractional portion of a numeric value up or down to produce an integer. |
![]() | UltraCalcFunctionRoundDown | Rounds a number to down to the specified number of digits. |
![]() | UltraCalcFunctionRoundUp | Rounds a number to up to the specified number of digits. |
![]() | UltraCalcFunctionSearch | Returns the 1-based index of one string within another, searching case insensitively. |
![]() | UltraCalcFunctionSearchB | Returns the 1-based index of one string within another, searching case insensitively. |
![]() | UltraCalcFunctionSecond | Returns the second of a time value |
![]() | UltraCalcFunctionSeriesSum | Returns the sum of a power series. |
![]() | UltraCalcFunctionSign | Returns the sign of a number. (-1, 0, or 1) |
![]() | UltraCalcFunctionSin | Calculates the trigonometric sine of a specified angle (measured in radians). |
![]() | UltraCalcFunctionSinh | Calculates the hyperbolic sine of a specified angle measured in radians. |
![]() | UltraCalcFunctionSLN | Calculates what the straight-line depreciation of an asset should be per period. |
![]() | UltraCalcFunctionSqrt | Calculates the square root of a number. |
![]() | UltraCalcFunctionSqrtPi | Returns the square root of the specified number times Pi. |
![]() | UltraCalcFunctionStdev | Calculates an approximate standard deviation of a specified sampling of numeric values. |
![]() | UltraCalcFunctionSubtotal | Calculates the subtotal in one of more references. |
![]() | UltraCalcFunctionSum | Adds a series of numbers to obtain a total amount. |
![]() | UltraCalcFunctionSYD | Calculates depreciation of an asset using the sum of years' digits (SYD) calculation method. |
![]() | UltraCalcFunctionTan | Calculates the trigonometric tangent of a specified angle (measured in radians). |
![]() | UltraCalcFunctionTanh | Calculates the hyperbolic tangent of a specified angle measured in radians. |
![]() | UltraCalcFunctionText | Converts the value to text based on the specified format. |
![]() | UltraCalcFunctionTime | Returns the .NET DateTime ticks value that represents a particular time |
![]() | UltraCalcFunctionTimeValue | Returns the .Net DateTime of the time represented by time formated in a string |
![]() | UltraCalcFunctionToday | Gets the host's current date. |
![]() | UltraCalcFunctionTrim | Removes any leading or trailing spaces from a text value, and normalizes runs of whitespace within a text value. |
![]() | UltraCalcFunctionTrue | A constant function always returning the TRUE value of Boolean logic. |
![]() | UltraCalcFunctionTrunc | Truncates the fractional portion of a numeric value to produce an integer. |
![]() | UltraCalcFunctionType | Returns the underlying UltraCalc data type for the specified value. |
![]() | UltraCalcFunctionUnaryMinus | '-' Negation formula operator (-20) |
![]() | UltraCalcFunctionUnaryPlus | '+' Unary plus formula operator (+20) |
![]() | UltraCalcFunctionUpper | Converts all lowercase letters in a text string to uppercase. |
![]() | UltraCalcFunctionValue | Retrieves the numeric value of a piece of text that is supposed to represent either a number or a currency. |
![]() | UltraCalcFunctionVar | Calculates the estimated variance for a specified sampling of numeric values. |
![]() | UltraCalcFunctionWeekDay | Returns a number representing the day of the week of the specified date. |
![]() | UltraCalcFunctionWeekNum | Returns the number of the week into which the specified date falls. |
![]() | UltraCalcFunctionWorkDay | Returns a work day the specified number of days from the specified date, excluding any specified holidays. |
![]() | UltraCalcFunctionXBase2Dec | Returns the decimal value of a string representation of a number in a non-decimal number system. |
![]() | UltraCalcFunctionXBase2XBase | Converts a string representing a number in a non-decimal number system to a number in another non-decimal number system. |
![]() | UltraCalcFunctionYear | Returns the year of a date value |
![]() | UltraCalcNumberStack | Stack of UltraCalcValue instances used to evaluate formulas. |
![]() | UltraCalcReferenceCollection | Manages a collection of IUltraCalcReference objects |
![]() | UltraCalcUserDefinedFunction | Abstract base class used to extend fomula function table with user defined functions. |
![]() | UltraCalcUserDefinedFunctionFactory | This class manages the list of user defined formula functions available in UltraCalc as well as methods to locate and instaniate function classes. |