range is the range of cells to be counted based on the criteria
criteriais used to determine which cells to count
Countif.StringMatcher |
|
Countifs |
Implementation for the function COUNTIFS
Syntax: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2])
|
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. |
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. |
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. |
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
Syntax :
INDEX ( reference, row_num[, column_num [, area_num]])
INDEX ( array, row_num[, column_num])
referencetypically an area reference, possibly a union of areas
arraya literal array value (currently not supported)
row_numselects the row within the array or area reference
column_numselects column within the array or area reference. default is 1
area_numused when reference is a union of areas
Indirect |
Implementation for Excel function INDIRECT
INDIRECT() returns the cell or area reference denoted by the text argument. |
Intercept |
Implementation of Excel function INTERCEPT()
Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
Syntax:
INTERCEPT(arrayX, arrayY) |
IPMT |
|
Irr |
Calculates the internal rate of return. |
LinearRegressionFunction |
Base class for linear regression functions. |
LogicalFunction |
|
Lookup |
Implementation of Excel function LOOKUP. |
Match |
Implementation for the MATCH() Excel function. |
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()
OFFSET returns an area reference that is a specified number of rows and columns from a
reference cell or area. |
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:
Replaces part of a text string based on the number of characters
you specify, with another text string. |
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()
Calculates the SLOPE of the linear regression line that is used to predict y values from x values
(http://introcs.cs.princeton.edu/java/97data/LinearRegression.java.html)
Syntax:
SLOPE(arrayX, arrayY) |
Substitute |
An implementation of the SUBSTITUTE function:
Substitutes text in a text string with new text, some number of times. |
Subtotal |
Implementation for the Excel function SUBTOTAL
Syntax :
SUBTOTAL ( functionCode, ref1, ref2 ... )
functionCode(1-11) Selects the underlying aggregate function to be used (see table below)
ref1, ref2 ...
Sumif |
Implementation for the Excel function SUMIF
Syntax :
SUMIF ( range, criteria, sum_range )
rangeThe range over which criteria is applied.
Sumifs |
Implementation for the Excel function SUMIFS
Syntax :
SUMIFS ( sum_range, criteria_range1, criteria1>,
[criteria_range2, criteria2], ...) |
Sumproduct |
Implementation for the Excel function SUMPRODUCT
Syntax :
SUMPRODUCT ( array1[, array2[, array3[, ...]]]) |
Sumx2my2 |
Implementation of Excel function SUMX2MY2()
Calculates the sum of differences of squares in two arrays of the same size. |
Sumx2py2 |
Implementation of Excel function SUMX2PY2()
Calculates the sum of squares in two arrays of the same size. |
Sumxmy2 |
Implementation of Excel function SUMXMY2()
Calculates the sum of squares of differences between two arrays of the same size. |
T |
Implementation of Excel T() function
If the argument is a text or error value it is returned unmodified. |
TextFunction |
|
TimeFunc |
Implementation for the Excel function TIME |
Today |
Implementation of Excel TODAY() Function
|
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 |
|
Copyright 2015 The Apache Software Foundation or
its licensors, as applicable.
| | |