| Address |
Creates a text reference as text, given specified row and column numbers.
|
| AggregateFunction |
|
| Areas |
Returns the number of areas in a reference.
|
| BaseNumberUtils |
Some utils for converting from and to any base
|
| Bin2Dec |
Implementation for Excel Bin2Dec() function.
|
| BooleanFunction |
Here are the general rules concerning Boolean functions:
Blanks are ignored (not either true or false)
Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false'
Numbers: 0 is false.
|
| CalendarFieldFunction |
Implementation of Excel functions Date parsing functions:
Date - DAY, MONTH and YEAR
Time - HOUR, MINUTE and SECOND
|
| Choose |
|
| Code |
Implementation for Excel CODE () function.
|
| Column |
|
| Columns |
Implementation for Excel COLUMNS function.
|
| Complex |
Implementation for Excel COMPLEX () function.
|
| Count |
Counts the number of cells that contain numeric data within
the list of arguments.
|
| Counta |
Counts the number of cells that contain data within the list of arguments.
|
| Countblank |
Implementation for the function COUNTBLANK
|
| Countif |
Implementation for the function COUNTIF
|
| Countif.ErrorMatcher |
|
| Countif.StringMatcher |
|
| Countifs |
Implementation for the function COUNTIFS
|
| DateFunc |
Implementation for the Excel function DATE
|
| Days360 |
Calculates the number of days between two dates based on a 360-day year
(twelve 30-day months), which is used in some accounting calculations.
|
| Dec2Bin |
Implementation for Excel Bin2Dec() function.
|
| Dec2Hex |
Implementation for Excel DELTA() function.
|
| Delta |
Implementation for Excel DELTA() function.
|
| DGet |
Implementation of the DGet function:
Finds the value of a column in an area with given conditions.
|
| DMax |
Implementation of the DMax function:
Finds the maximum value of a column in an area with given conditions.
|
| DMin |
Implementation of the DMin function:
Finds the minimum value of a column in an area with given conditions.
|
| DStarRunner |
This class performs a D* calculation.
|
| DSum |
Implementation of the DSum function:
Finds the total value of matching values in a column in an area with given conditions.
|
| EDate |
Implementation for Excel EDATE () function.
|
| EOMonth |
Implementation for the Excel EOMONTH() function.
|
| Errortype |
Implementation for the ERROR.TYPE() Excel function.
|
| Even |
|
| FactDouble |
Implementation for Excel FACTDOUBLE() function.
|
| Finance |
Implementation of the financial functions pmt, fv, ppmt, ipmt.
|
| FinanceFunction |
|
| FinanceLib |
|
| Fixed |
|
| Fixed0ArgFunction |
Convenience base class for functions that only take zero arguments.
|
| Fixed1ArgFunction |
Convenience base class for functions that must take exactly one argument.
|
| Fixed2ArgFunction |
Convenience base class for functions that must take exactly two arguments.
|
| Fixed3ArgFunction |
Convenience base class for functions that must take exactly three arguments.
|
| Fixed4ArgFunction |
Convenience base class for functions that must take exactly four arguments.
|
| Frequency |
Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical array
|
| Hex2Dec |
Implementation for Excel HEX2DEC() function.
|
| Hlookup |
Implementation of the HLOOKUP() function.
|
| Hyperlink |
Implementation of Excel HYPERLINK function.
|
| IfFunc |
Implementation for the Excel function IF
|
| Imaginary |
Implementation for Excel IMAGINARY() function.
|
| ImReal |
Implementation for Excel ImReal() function.
|
| Index |
Implementation for the Excel function INDEX
|
| Indirect |
Implementation for Excel function INDIRECT
|
| Intercept |
Implementation of Excel function INTERCEPT()
|
| IPMT |
|
| Irr |
Calculates the internal rate of return.
|
| LinearRegressionFunction |
Base class for linear regression functions.
|
| LogicalFunction |
Implementation of the various ISxxx Logical Functions, which
take a single expression argument, and return True or False.
|
| Lookup |
Implementation of Excel function LOOKUP.
|
| Match |
Implementation for the MATCH() Excel function.
|
| MatrixFunction |
|
| MatrixFunction.MutableValueCollector |
|
| MatrixFunction.OneArrayArg |
|
| MatrixFunction.TwoArrayArg |
|
| MinaMaxa |
|
| Mirr |
Calculates Modified internal rate of return.
|
| Mode |
|
| MultiOperandNumericFunction |
This is the super class for all excel function evaluator
classes that take variable number of operands, and
where the order of operands does not matter
|
| Na |
Implementation of Excel function NA()
|
| NotImplementedFunction |
This is the default implementation of a Function class.
|
| Now |
Implementation of Excel NOW() Function
|
| Npv |
Calculates the net present value of an investment by using a discount rate
and a series of future payments (negative values) and income (positive
values).
|
| NumericFunction |
|
| NumericFunction.OneArg |
|
| NumericFunction.TwoArg |
|
| Oct2Dec |
Implementation for Excel Oct2Dec() function.
|
| Odd |
|
| Offset |
Implementation for Excel function OFFSET()
|
| PPMT |
Compute the interest portion of a payment.
|
| Quotient |
Implementation for Excel QUOTIENT () function.
|
| Rank |
Returns the rank of a number in a list of numbers.
|
| Rate |
Implements the Excel Rate function
|
| Replace |
An implementation of the Excel REPLACE() function:
|
| Rept |
Implementation for Excel REPT () function.
|
| Roman |
Implementation for Excel WeekNum() function.
|
| RowFunc |
Implementation for the Excel function ROW
|
| Rows |
Implementation for Excel ROWS function.
|
| Slope |
Implementation of Excel function SLOPE()
|
| Substitute |
An implementation of the SUBSTITUTE function:
|
| Subtotal |
Implementation for the Excel function SUBTOTAL
|
| Sumif |
Implementation for the Excel function SUMIF
|
| Sumifs |
Implementation for the Excel function SUMIFS
|
| Sumproduct |
Implementation for the Excel function SUMPRODUCT
|
| Sumx2my2 |
Implementation of Excel function SUMX2MY2()
|
| Sumx2py2 |
Implementation of Excel function SUMX2PY2()
|
| Sumxmy2 |
Implementation of Excel function SUMXMY2()
|
| T |
Implementation of Excel T() function
|
| TextFunction |
|
| TimeFunc |
Implementation for the Excel function TIME
|
| Today |
Implementation of Excel TODAY() Function
|
| Trend |
Implementation for the Excel function TREND
|
| Value |
Implementation for Excel VALUE() function.
|
| Vlookup |
Implementation of the VLOOKUP() function.
|
| WeekdayFunc |
Implementation for the Excel function WEEKDAY
|
| WeekNum |
Implementation for Excel WeekNum() function.
|
| XYNumericFunction |
|