Element index for package PHPExcel_Calculation

[ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ k ] [ l ] [ m ] [ n ] [ o ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ v ] [ w ] [ x ] [ y ] [ _ ]

_

$_binaryOperators: in file Calculation.php, variable PHPExcel_Calculation::$_binaryOperators
List of binary operators (those that expect two operands)
$_calculationCache: in file Calculation.php, variable PHPExcel_Calculation::$_calculationCache
Calculation cache
$_calculationCacheEnabled: in file Calculation.php, variable PHPExcel_Calculation::$_calculationCacheEnabled
Calculation cache enabled
$_calculationCacheExpirationTime: in file Calculation.php, variable PHPExcel_Calculation::$_calculationCacheExpirationTime
Calculation cache expiration time
$_category: in file Function.php, variable PHPExcel_Calculation_Function::$_category
Category (represented by CATEGORY_*)
$_controlFunctions: in file Calculation.php, variable PHPExcel_Calculation::$_controlFunctions
$_conversionMultipliers: in file Functions.php, variable PHPExcel_Calculation_Functions::$_conversionMultipliers
$_conversionUnits: in file Functions.php, variable PHPExcel_Calculation_Functions::$_conversionUnits
$_count: in file Calculation.php, variable PHPExcel_Token_Stack::$_count
$_errorCodes: in file Functions.php, variable PHPExcel_Calculation_Functions::$_errorCodes
List of error codes
$_ExcelConstants: in file Calculation.php, variable PHPExcel_Calculation::$_ExcelConstants
$_excelName: in file Function.php, variable PHPExcel_Calculation_Function::$_excelName
Excel name
$_formula: in file FormulaParser.php, variable PHPExcel_Calculation_FormulaParser::$_formula
Formula
$_instance: in file Calculation.php, variable PHPExcel_Calculation::$_instance
Instance of this class
$_invalidChars: in file Functions.php, variable PHPExcel_Calculation_Functions::$_invalidChars
$_logBetaCache_p: in file Functions.php, variable PHPExcel_Calculation_Functions::$_logBetaCache_p
$_logBetaCache_q: in file Functions.php, variable PHPExcel_Calculation_Functions::$_logBetaCache_q
$_logBetaCache_result: in file Functions.php, variable PHPExcel_Calculation_Functions::$_logBetaCache_result
$_logGammaCache_result: in file Functions.php, variable PHPExcel_Calculation_Functions::$_logGammaCache_result
logGamma function
$_logGammaCache_x: in file Functions.php, variable PHPExcel_Calculation_Functions::$_logGammaCache_x
$_one_sqrtpi: in file Functions.php, variable PHPExcel_Calculation_Functions::$_one_sqrtpi
$_operators: in file Calculation.php, variable PHPExcel_Calculation::$_operators
List of operators that can be used within formulae
$_PHPExcelFunctions: in file Calculation.php, variable PHPExcel_Calculation::$_PHPExcelFunctions
$_phpExcelName: in file Function.php, variable PHPExcel_Calculation_Function::$_phpExcelName
PHPExcel name
$_rel_error: in file Functions.php, variable PHPExcel_Calculation_Functions::$_rel_error
$_stack: in file Calculation.php, variable PHPExcel_Token_Stack::$_stack
$_tokens: in file FormulaParser.php, variable PHPExcel_Calculation_FormulaParser::$_tokens
Tokens
$_tokenSubType: in file FormulaToken.php, variable PHPExcel_Calculation_FormulaToken::$_tokenSubType
Token SubType (represented by TOKEN_SUBTYPE_*)
$_tokenType: in file FormulaToken.php, variable PHPExcel_Calculation_FormulaToken::$_tokenType
Token Type (represented by TOKEN_TYPE_*)
$_two_sqrtpi: in file Functions.php, variable PHPExcel_Calculation_Functions::$_two_sqrtpi
$_unitConversions: in file Functions.php, variable PHPExcel_Calculation_Functions::$_unitConversions
$_value: in file FormulaToken.php, variable PHPExcel_Calculation_FormulaToken::$_value
Value
_adjustDateByMonths: in file Functions.php, method PHPExcel_Calculation_Functions::_adjustDateByMonths()
_Besselk0: in file Functions.php, method PHPExcel_Calculation_Functions::_Besselk0()
_Besselk1: in file Functions.php, method PHPExcel_Calculation_Functions::_Besselk1()
_Bessely0: in file Functions.php, method PHPExcel_Calculation_Functions::_Bessely0()
_Bessely1: in file Functions.php, method PHPExcel_Calculation_Functions::_Bessely1()
_beta: in file Functions.php, method PHPExcel_Calculation_Functions::_beta()
Beta function.
_betaFraction: in file Functions.php, method PHPExcel_Calculation_Functions::_betaFraction()
Evaluates of continued fraction part of incomplete beta function.
_calculateFormulaValue: in file Calculation.php, method PHPExcel_Calculation::_calculateFormulaValue()
Parse a cell formula and calculate its value
_checkMatrixOperands: in file Calculation.php, method PHPExcel_Calculation::_checkMatrixOperands()
Ensure that paired matrix operands are both matrices and of the same size
_checkTrendArray: in file Functions.php, method PHPExcel_Calculation_Functions::_checkTrendArray()
_cleanComplex: in file Functions.php, method PHPExcel_Calculation_Functions::_cleanComplex()
_convertMatrixReferences: in file Calculation.php, method PHPExcel_Calculation::_convertMatrixReferences()
_dateDiff360: in file Functions.php, method PHPExcel_Calculation_Functions::_dateDiff360()
_daysPerYear: in file Functions.php, method PHPExcel_Calculation_Functions::_daysPerYear()
_erfcVal: in file Functions.php, method PHPExcel_Calculation_Functions::_erfcVal()
_erfVal: in file Functions.php, method PHPExcel_Calculation_Functions::_erfVal()
_executeBinaryComparisonOperation: in file Calculation.php, method PHPExcel_Calculation::_executeBinaryComparisonOperation()
_executeNumericBinaryOperation: in file Calculation.php, method PHPExcel_Calculation::_executeNumericBinaryOperation()
_factors: in file Functions.php, method PHPExcel_Calculation_Functions::_factors()
_gamma: in file Functions.php, method PHPExcel_Calculation_Functions::_gamma()
_getDateValue: in file Functions.php, method PHPExcel_Calculation_Functions::_getDateValue()
_getDateValue
_getMatrixDimensions: in file Calculation.php, method PHPExcel_Calculation::_getMatrixDimensions()
Read the dimensions of a matrix, and re-index it with straight numeric keys starting from row 0, column 0
_getTimeValue: in file Functions.php, method PHPExcel_Calculation_Functions::_getTimeValue()
_getTimeValue
_incompleteBeta: in file Functions.php, method PHPExcel_Calculation_Functions::_incompleteBeta()
Incomplete beta function
_incompleteGamma: in file Functions.php, method PHPExcel_Calculation_Functions::_incompleteGamma()
_interestAndPrincipal: in file Functions.php, method PHPExcel_Calculation_Functions::_interestAndPrincipal()
_inverse_ncdf: in file Functions.php, method PHPExcel_Calculation_Functions::_inverse_ncdf()
*************************************************************************
_inverse_ncdf2: in file Functions.php, method PHPExcel_Calculation_Functions::_inverse_ncdf2()
_inverse_ncdf3: in file Functions.php, method PHPExcel_Calculation_Functions::_inverse_ncdf3()
_isLeapYear: in file Functions.php, method PHPExcel_Calculation_Functions::_isLeapYear()
_logBeta: in file Functions.php, method PHPExcel_Calculation_Functions::_logBeta()
The natural logarithm of the beta function.
_logGamma: in file Functions.php, method PHPExcel_Calculation_Functions::_logGamma()
_mkMatrix: in file Calculation.php, method PHPExcel_Calculation::_mkMatrix()
_modeCalc: in file Functions.php, method PHPExcel_Calculation_Functions::_modeCalc()
_nbrConversionFormat: in file Functions.php, method PHPExcel_Calculation_Functions::_nbrConversionFormat()
_parseComplex: in file Functions.php, method PHPExcel_Calculation_Functions::_parseComplex()
_parseFormula: in file Calculation.php, method PHPExcel_Calculation::_parseFormula()
_parseToTokens: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::_parseToTokens()
Parse to tokens
_processTokenStack: in file Calculation.php, method PHPExcel_Calculation::_processTokenStack()
_raiseFormulaError: in file Calculation.php, method PHPExcel_Calculation::_raiseFormulaError()
_reindexMatrixDimensions: in file Calculation.php, method PHPExcel_Calculation::_reindexMatrixDimensions()
Re-index a matrix with straight numeric keys starting from row 0, column 0
_resizeMatricesExtend: in file Calculation.php, method PHPExcel_Calculation::_resizeMatricesExtend()
Ensure that paired matrix operands are both matrices of the same size
_resizeMatricesShrink: in file Calculation.php, method PHPExcel_Calculation::_resizeMatricesShrink()
Ensure that paired matrix operands are both matrices of the same size
_romanCut: in file Functions.php, method PHPExcel_Calculation_Functions::_romanCut()
_showTypeDetails: in file Calculation.php, method PHPExcel_Calculation::_showTypeDetails()
Format type and details of an operand for display in the log (based on operand type)
_showValue: in file Calculation.php, method PHPExcel_Calculation::_showValue()
Format details of an operand for display in the log (based on operand type)
_unwrapResult: in file Calculation.php, method PHPExcel_Calculation::_unwrapResult()
Remove quotes used as a wrapper to identify string values
_validateBinaryOperand: in file Calculation.php, method PHPExcel_Calculation::_validateBinaryOperand()
_wrapResult: in file Calculation.php, method PHPExcel_Calculation::_wrapResult()
Wrap string values in quotes
_writeDebug: in file Calculation.php, method PHPExcel_Calculation::_writeDebug()
__clone: in file Calculation.php, method PHPExcel_Calculation::__clone()
__clone implementation.
__construct: in file Calculation.php, method PHPExcel_Token_Stack::__construct()
__construct: in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__construct()
Register errorhandler
__construct: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::__construct()
Create a new PHPExcel_Calculation_FormulaParser
__construct: in file Function.php, method PHPExcel_Calculation_Function::__construct()
Create a new PHPExcel_Calculation_Function
__construct: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::__construct()
Create a new PHPExcel_Calculation_FormulaToken
__destruct: in file ExceptionHandler.php, method PHPExcel_Calculation_ExceptionHandler::__destruct()
Unregister errorhandler

top

a

ACCRINT: in file Functions.php, method PHPExcel_Calculation_Functions::ACCRINT()
ACCRINT Returns the discount rate for a security.
ACCRINTM: in file Functions.php, method PHPExcel_Calculation_Functions::ACCRINTM()
ACCRINTM Returns the discount rate for a security.
acosh: in file Functions.php, function acosh()
AMORDEGRC: in file Functions.php, method PHPExcel_Calculation_Functions::AMORDEGRC()
AMORLINC: in file Functions.php, method PHPExcel_Calculation_Functions::AMORLINC()
ASCIICODE: in file Functions.php, method PHPExcel_Calculation_Functions::ASCIICODE()
ASCIICODE
asinh: in file Functions.php, function asinh()
atanh: in file Functions.php, function atanh()
AVEDEV: in file Functions.php, method PHPExcel_Calculation_Functions::AVEDEV()
AVEDEV Returns the average of the absolute deviations of data points from their mean.
AVERAGE: in file Functions.php, method PHPExcel_Calculation_Functions::AVERAGE()
AVERAGE
AVERAGEA: in file Functions.php, method PHPExcel_Calculation_Functions::AVERAGEA()
AVERAGEA

top

b

BESSELI: in file Functions.php, method PHPExcel_Calculation_Functions::BESSELI()
BESSELI
BESSELJ: in file Functions.php, method PHPExcel_Calculation_Functions::BESSELJ()
BESSELJ
BESSELK: in file Functions.php, method PHPExcel_Calculation_Functions::BESSELK()
BESSELK Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.
BESSELY: in file Functions.php, method PHPExcel_Calculation_Functions::BESSELY()
BESSELY Returns the Bessel function, which is also called the Weber function or the Neumann function.
BETADIST: in file Functions.php, method PHPExcel_Calculation_Functions::BETADIST()
BETADIST Returns the beta distribution.
BETAINV: in file Functions.php, method PHPExcel_Calculation_Functions::BETAINV()
BETAINV Returns the inverse of the beta distribution.
BINOMDIST: in file Functions.php, method PHPExcel_Calculation_Functions::BINOMDIST()
BINOMDIST Returns the individual term binomial distribution probability. a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant throughout the experiment. babies born are male.
BINTODEC: in file Functions.php, method PHPExcel_Calculation_Functions::BINTODEC()
BINTODEC Return a binary value as Decimal.
BINTOHEX: in file Functions.php, method PHPExcel_Calculation_Functions::BINTOHEX()
BINTOHEX Return a binary value as Hex.
BINTOOCT: in file Functions.php, method PHPExcel_Calculation_Functions::BINTOOCT()
BINTOOCT Return a binary value as Octal.
BRACE_CLOSE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACE_CLOSE
BRACE_OPEN: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACE_OPEN
BRACKET_CLOSE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACKET_CLOSE
BRACKET_OPEN: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::BRACKET_OPEN

top

c

$compatibilityMode: in file Functions.php, variable PHPExcel_Calculation_Functions::$compatibilityMode
Compatibility mode to use for error checking and responses
calculate: in file Calculation.php, method PHPExcel_Calculation::calculate()
Calculate cell value (using formula from a cell ID)
calculateCellValue: in file Calculation.php, method PHPExcel_Calculation::calculateCellValue()
Calculate the value of a cell formula
calculateFormula: in file Calculation.php, method PHPExcel_Calculation::calculateFormula()
Calculate the value of a formula
CALCULATION_REGEXP_CELLREF: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF
CALCULATION_REGEXP_ERROR: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_ERROR
CALCULATION_REGEXP_FUNCTION: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_FUNCTION
CALCULATION_REGEXP_NAMEDRANGE: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE
CALCULATION_REGEXP_NUMBER: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_NUMBER
Regular Expressions
CALCULATION_REGEXP_OPENBRACE: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_OPENBRACE
CALCULATION_REGEXP_STRING: in file Calculation.php, class constant PHPExcel_Calculation::CALCULATION_REGEXP_STRING
CATEGORY_CUBE: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_CUBE
CATEGORY_DATABASE: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_DATABASE
CATEGORY_DATE_AND_TIME: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME
CATEGORY_ENGINEERING: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_ENGINEERING
CATEGORY_FINANCIAL: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_FINANCIAL
CATEGORY_INFORMATION: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_INFORMATION
CATEGORY_LOGICAL: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_LOGICAL
CATEGORY_LOOKUP_AND_REFERENCE: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE
CATEGORY_MATH_AND_TRIG: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG
CATEGORY_STATISTICAL: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_STATISTICAL
CATEGORY_TEXT_AND_DATA: in file Function.php, class constant PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA
CEILING: in file Functions.php, method PHPExcel_Calculation_Functions::CEILING()
CEILING Returns number rounded up, away from zero, to the nearest multiple of significance.
CELL_ADDRESS: in file Functions.php, method PHPExcel_Calculation_Functions::CELL_ADDRESS()
CELL_ADDRESS
CHARACTER: in file Functions.php, method PHPExcel_Calculation_Functions::CHARACTER()
CHARACTER
CHIDIST: in file Functions.php, method PHPExcel_Calculation_Functions::CHIDIST()
CHIDIST Returns the one-tailed probability of the chi-squared distribution.
CHIINV: in file Functions.php, method PHPExcel_Calculation_Functions::CHIINV()
CHIINV Returns the one-tailed probability of the chi-squared distribution.
CHOOSE: in file Functions.php, method PHPExcel_Calculation_Functions::CHOOSE()
clearCalculationCache: in file Calculation.php, method PHPExcel_Calculation::clearCalculationCache()
Clear calculation cache
COLUMN: in file Functions.php, method PHPExcel_Calculation_Functions::COLUMN()
COMBIN: in file Functions.php, method PHPExcel_Calculation_Functions::COMBIN()
COMBIN Returns the number of combinations for a given number of items. determine the total possible number of groups for a given number of items.
COMMA: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::COMMA
COMPATIBILITY_EXCEL: in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL
constants
COMPATIBILITY_GNUMERIC: in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_GNUMERIC
COMPATIBILITY_OPENOFFICE: in file Functions.php, class constant PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE
COMPLEX: in file Functions.php, method PHPExcel_Calculation_Functions::COMPLEX()
COMPLEX returns a complex number of the form x + yi or x + yj.
CONCATENATE: in file Functions.php, method PHPExcel_Calculation_Functions::CONCATENATE()
CONCATENATE
CONFIDENCE: in file Functions.php, method PHPExcel_Calculation_Functions::CONFIDENCE()
CONFIDENCE
CONVERTUOM: in file Functions.php, method PHPExcel_Calculation_Functions::CONVERTUOM()
CONVERTUOM
CORREL: in file Functions.php, method PHPExcel_Calculation_Functions::CORREL()
CORREL Returns covariance, the average of the products of deviations for each data point pair.
COUNT: in file Functions.php, method PHPExcel_Calculation_Functions::COUNT()
COUNT
count: in file Calculation.php, method PHPExcel_Token_Stack::count()
COUNTA: in file Functions.php, method PHPExcel_Calculation_Functions::COUNTA()
COUNTA
COUNTBLANK: in file Functions.php, method PHPExcel_Calculation_Functions::COUNTBLANK()
COUNTBLANK
COUNTIF: in file Functions.php, method PHPExcel_Calculation_Functions::COUNTIF()
COUNTIF
COVAR: in file Functions.php, method PHPExcel_Calculation_Functions::COVAR()
COVAR Returns covariance, the average of the products of deviations for each data point pair.
CRITBINOM: in file Functions.php, method PHPExcel_Calculation_Functions::CRITBINOM()
CRITBINOM
CUMIPMT: in file Functions.php, method PHPExcel_Calculation_Functions::CUMIPMT()
CUMIPMT Returns the cumulative interest paid on a loan between start_period and end_period.
CUMPRINC: in file Functions.php, method PHPExcel_Calculation_Functions::CUMPRINC()
CUMPRINC Returns the cumulative principal paid on a loan between start_period and end_period.
Calculation.php: procedural page Calculation.php

top

d

$debugLog: in file Calculation.php, variable PHPExcel_Calculation::$debugLog
$debugLogStack: in file Calculation.php, variable PHPExcel_Calculation::$debugLogStack
DATE: in file Functions.php, method PHPExcel_Calculation_Functions::DATE()
DATE
DATEDIF: in file Functions.php, method PHPExcel_Calculation_Functions::DATEDIF()
DATEDIF
DATENOW: in file Functions.php, method PHPExcel_Calculation_Functions::DATENOW()
DATENOW
DATETIMENOW: in file Functions.php, method PHPExcel_Calculation_Functions::DATETIMENOW()
DATETIMENOW
DATEVALUE: in file Functions.php, method PHPExcel_Calculation_Functions::DATEVALUE()
DATEVALUE
DAYOFMONTH: in file Functions.php, method PHPExcel_Calculation_Functions::DAYOFMONTH()
DAYOFMONTH
DAYOFWEEK: in file Functions.php, method PHPExcel_Calculation_Functions::DAYOFWEEK()
DAYOFWEEK
DAYS360: in file Functions.php, method PHPExcel_Calculation_Functions::DAYS360()
DAYS360
DB: in file Functions.php, method PHPExcel_Calculation_Functions::DB()
DB Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DDB: in file Functions.php, method PHPExcel_Calculation_Functions::DDB()
DDB Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
DECTOBIN: in file Functions.php, method PHPExcel_Calculation_Functions::DECTOBIN()
DECTOBIN Return an octal value as binary.
DECTOHEX: in file Functions.php, method PHPExcel_Calculation_Functions::DECTOHEX()
DECTOHEX Return an octal value as binary.
DECTOOCT: in file Functions.php, method PHPExcel_Calculation_Functions::DECTOOCT()
DECTOOCT Return an octal value as binary.
DELTA: in file Functions.php, method PHPExcel_Calculation_Functions::DELTA()
DELTA Tests whether two values are equal.
DEVSQ: in file Functions.php, method PHPExcel_Calculation_Functions::DEVSQ()
DEVSQ Returns the sum of squares of deviations of data points from their sample mean.
disableCalculationCache: in file Calculation.php, method PHPExcel_Calculation::disableCalculationCache()
Disable calculation cache
DISC: in file Functions.php, method PHPExcel_Calculation_Functions::DISC()
DISC Returns the discount rate for a security.
DOLLAR: in file Functions.php, method PHPExcel_Calculation_Functions::DOLLAR()
DOLLAR This function converts a number to text using currency format, with the decimals rounded to the specified place.
DOLLARDE: in file Functions.php, method PHPExcel_Calculation_Functions::DOLLARDE()
DOLLARDE Converts a dollar price expressed as an integer part and a fraction part into a dollar price expressed as a decimal number.
DOLLARFR: in file Functions.php, method PHPExcel_Calculation_Functions::DOLLARFR()
DOLLARFR Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
DUMMY: in file Functions.php, method PHPExcel_Calculation_Functions::DUMMY()
DUMMY

top

e

EDATE: in file Functions.php, method PHPExcel_Calculation_Functions::EDATE()
EDATE Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date).
EFFECT: in file Functions.php, method PHPExcel_Calculation_Functions::EFFECT()
EFFECT Returns the effective interest rate given the nominal rate and the number of compounding payments per year.
enableCalculationCache: in file Calculation.php, method PHPExcel_Calculation::enableCalculationCache()
Enable calculation cache
EOMONTH: in file Functions.php, method PHPExcel_Calculation_Functions::EOMONTH()
EOMONTH Returns the serial number for the last day of the month that is the indicated number of months before or after start_date.
EPS: in file Functions.php, constant EPS
EPS
ERF: in file Functions.php, method PHPExcel_Calculation_Functions::ERF()
ERF
ERFC: in file Functions.php, method PHPExcel_Calculation_Functions::ERFC()
ERFC
errorHandlerCallback: in file Exception.php, method PHPExcel_Calculation_Exception::errorHandlerCallback()
Error handler callback
ERROR_START: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::ERROR_START
ERROR_TYPE: in file Functions.php, method PHPExcel_Calculation_Functions::ERROR_TYPE()
ERROR_TYPE
EULER: in file Functions.php, constant EULER
EULER
EVEN: in file Functions.php, method PHPExcel_Calculation_Functions::EVEN()
EVEN Returns number rounded up to the nearest even integer.
EXPONDIST: in file Functions.php, method PHPExcel_Calculation_Functions::EXPONDIST()
EXPONDIST Returns the exponential distribution. such as how long an automated bank teller takes to deliver cash. use EXPONDIST to determine the probability that the process takes at most 1 minute.
extractCellRange: in file Calculation.php, method PHPExcel_Calculation::extractCellRange()
Extract range values
extractNamedRange: in file Calculation.php, method PHPExcel_Calculation::extractNamedRange()
Extract range values
Exception.php: procedural page Exception.php
ExceptionHandler.php: procedural page ExceptionHandler.php

top

f

$formulaError: in file Calculation.php, variable PHPExcel_Calculation::$formulaError
FACT: in file Functions.php, method PHPExcel_Calculation_Functions::FACT()
FACT Returns the factorial of a number.
FACTDOUBLE: in file Functions.php, method PHPExcel_Calculation_Functions::FACTDOUBLE()
FACTDOUBLE Returns the double factorial of a number.
FISHER: in file Functions.php, method PHPExcel_Calculation_Functions::FISHER()
FISHER Returns the Fisher transformation at x. is normally distributed rather than skewed. testing on the correlation coefficient.
FISHERINV: in file Functions.php, method PHPExcel_Calculation_Functions::FISHERINV()
FISHERINV Returns the inverse of the Fisher transformation. analyzing correlations between ranges or arrays of data. FISHERINV(y) = x.
FIXEDFORMAT: in file Functions.php, method PHPExcel_Calculation_Functions::FIXEDFORMAT()
FIXEDFORMAT
flattenArray: in file Functions.php, method PHPExcel_Calculation_Functions::flattenArray()
Flatten multidemensional array
flattenSingleValue: in file Functions.php, method PHPExcel_Calculation_Functions::flattenSingleValue()
Convert an array with one element to a flat value
FLOOR: in file Functions.php, method PHPExcel_Calculation_Functions::FLOOR()
FLOOR Rounds number down, toward zero, to the nearest multiple of significance.
FORECAST: in file Functions.php, method PHPExcel_Calculation_Functions::FORECAST()
FORECAST Calculates, or predicts, a future value by using existing values.
FV: in file Functions.php, method PHPExcel_Calculation_Functions::FV()
FV Returns the Future Value of a cash flow with constant payments and interest rate (annuities).
FormulaParser.php: procedural page FormulaParser.php
FormulaToken.php: procedural page FormulaToken.php
Function.php: procedural page Function.php
Functions.php: procedural page Functions.php

top

g

GAMMADIST: in file Functions.php, method PHPExcel_Calculation_Functions::GAMMADIST()
GAMMADIST Returns the gamma distribution.
GAMMAINV: in file Functions.php, method PHPExcel_Calculation_Functions::GAMMAINV()
GAMMAINV Returns the inverse of the beta distribution.
GAMMALN: in file Functions.php, method PHPExcel_Calculation_Functions::GAMMALN()
GAMMALN Returns the natural logarithm of the gamma function.
GCD: in file Functions.php, method PHPExcel_Calculation_Functions::GCD()
GCD
GEOMEAN: in file Functions.php, method PHPExcel_Calculation_Functions::GEOMEAN()
GEOMEAN Returns the geometric mean of an array or range of positive data. can use GEOMEAN to calculate average growth rate given compound interest with variable rates.
GESTEP: in file Functions.php, method PHPExcel_Calculation_Functions::GESTEP()
GESTEP
getArrayReturnType: in file Calculation.php, method PHPExcel_Calculation::getArrayReturnType()
Return the Array Return Type (Array or Value of first element in the array)
getCalculationCacheEnabled: in file Calculation.php, method PHPExcel_Calculation::getCalculationCacheEnabled()
Is calculation caching enabled?
getCalculationCacheExpirationTime: in file Calculation.php, method PHPExcel_Calculation::getCalculationCacheExpirationTime()
Get calculation cache expiration time
getCategory: in file Function.php, method PHPExcel_Calculation_Function::getCategory()
Get Category (represented by CATEGORY_*)
getCompatibilityMode: in file Functions.php, method PHPExcel_Calculation_Functions::getCompatibilityMode()
Return the current Compatibility Mode
getConversionGroups: in file Functions.php, method PHPExcel_Calculation_Functions::getConversionGroups()
getConversionGroups
getConversionGroupUnitDetails: in file Functions.php, method PHPExcel_Calculation_Functions::getConversionGroupUnitDetails()
getConversionGroupUnitDetails
getConversionGroupUnits: in file Functions.php, method PHPExcel_Calculation_Functions::getConversionGroupUnits()
getConversionGroupUnits
getConversionMultipliers: in file Functions.php, method PHPExcel_Calculation_Functions::getConversionMultipliers()
getConversionGroups
getExcelName: in file Function.php, method PHPExcel_Calculation_Function::getExcelName()
Get Excel name
getFormula: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getFormula()
Get Formula
getInstance: in file Calculation.php, method PHPExcel_Calculation::getInstance()
Get an instance of this class
getPHPExcelName: in file Function.php, method PHPExcel_Calculation_Function::getPHPExcelName()
Get PHPExcel name
getReturnDateType: in file Functions.php, method PHPExcel_Calculation_Functions::getReturnDateType()
Return the current Return Date Format for functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)
getToken: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getToken()
Get Token
getTokenCount: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getTokenCount()
Get Token count
getTokens: in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::getTokens()
Get Tokens
getTokenSubType: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getTokenSubType()
Get Token SubType (represented by TOKEN_SUBTYPE_*)
getTokenType: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getTokenType()
Get Token Type (represented by TOKEN_TYPE_*)
getValue: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::getValue()
Get Value
GROWTH: in file Functions.php, method PHPExcel_Calculation_Functions::GROWTH()
GROWTH

top

h

HARMEAN: in file Functions.php, method PHPExcel_Calculation_Functions::HARMEAN()
HARMEAN Returns the harmonic mean of a data set. arithmetic mean of reciprocals.
HEXTOBIN: in file Functions.php, method PHPExcel_Calculation_Functions::HEXTOBIN()
HEXTOBIN Return a hex value as binary.
HEXTODEC: in file Functions.php, method PHPExcel_Calculation_Functions::HEXTODEC()
HEXTODEC Return a hex value as octal.
HEXTOOCT: in file Functions.php, method PHPExcel_Calculation_Functions::HEXTOOCT()
HEXTOOCT Return a hex value as octal.
HOUROFDAY: in file Functions.php, method PHPExcel_Calculation_Functions::HOUROFDAY()
HOUROFDAY
HYPGEOMDIST: in file Functions.php, method PHPExcel_Calculation_Functions::HYPGEOMDIST()
HYPGEOMDIST Returns the hypergeometric distribution. sample successes, given the sample size, population successes, and population size.

top

i

IMABS: in file Functions.php, method PHPExcel_Calculation_Functions::IMABS()
IMABS Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.
IMAGINARY: in file Functions.php, method PHPExcel_Calculation_Functions::IMAGINARY()
IMAGINARY Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.
IMARGUMENT: in file Functions.php, method PHPExcel_Calculation_Functions::IMARGUMENT()
IMARGUMENT Returns the argument theta of a complex number, i.
IMCONJUGATE: in file Functions.php, method PHPExcel_Calculation_Functions::IMCONJUGATE()
IMCONJUGATE Returns the complex conjugate of a complex number in x + yi or x + yj text format.
IMCOS: in file Functions.php, method PHPExcel_Calculation_Functions::IMCOS()
IMCOS Returns the cosine of a complex number in x + yi or x + yj text format.
IMDIV: in file Functions.php, method PHPExcel_Calculation_Functions::IMDIV()
IMDIV Returns the quotient of two complex numbers in x + yi or x + yj text format.
IMEXP: in file Functions.php, method PHPExcel_Calculation_Functions::IMEXP()
IMEXP Returns the exponential of a complex number in x + yi or x + yj text format.
IMLN: in file Functions.php, method PHPExcel_Calculation_Functions::IMLN()
IMLN Returns the natural logarithm of a complex number in x + yi or x + yj text format.
IMLOG2: in file Functions.php, method PHPExcel_Calculation_Functions::IMLOG2()
IMLOG2 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
IMLOG10: in file Functions.php, method PHPExcel_Calculation_Functions::IMLOG10()
IMLOG10 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.
IMPOWER: in file Functions.php, method PHPExcel_Calculation_Functions::IMPOWER()
IMPOWER Returns a complex number in x + yi or x + yj text format raised to a power.
IMPRODUCT: in file Functions.php, method PHPExcel_Calculation_Functions::IMPRODUCT()
IMPRODUCT Returns the product of two or more complex numbers in x + yi or x + yj text format.
IMREAL: in file Functions.php, method PHPExcel_Calculation_Functions::IMREAL()
IMREAL Returns the real coefficient of a complex number in x + yi or x + yj text format.
IMSIN: in file Functions.php, method PHPExcel_Calculation_Functions::IMSIN()
IMSIN Returns the sine of a complex number in x + yi or x + yj text format.
IMSQRT: in file Functions.php, method PHPExcel_Calculation_Functions::IMSQRT()
IMSQRT Returns the square root of a complex number in x + yi or x + yj text format.
IMSUB: in file Functions.php, method PHPExcel_Calculation_Functions::IMSUB()
IMSUB Returns the difference of two complex numbers in x + yi or x + yj text format.
IMSUM: in file Functions.php, method PHPExcel_Calculation_Functions::IMSUM()
IMSUM Returns the sum of two or more complex numbers in x + yi or x + yj text format.
INDEX: in file Functions.php, method PHPExcel_Calculation_Functions::INDEX()
Uses an index to choose a value from a reference or array
INTERCEPT: in file Functions.php, method PHPExcel_Calculation_Functions::INTERCEPT()
INTERCEPT Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.
INTRATE: in file Functions.php, method PHPExcel_Calculation_Functions::INTRATE()
INTRATE Returns the interest rate for a fully invested security.
INTVALUE: in file Functions.php, method PHPExcel_Calculation_Functions::INTVALUE()
INTVALUE
IPMT: in file Functions.php, method PHPExcel_Calculation_Functions::IPMT()
IPMT Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
isImplemented: in file Calculation.php, method PHPExcel_Calculation::isImplemented()
Is a specific function implemented?
IS_BLANK: in file Functions.php, method PHPExcel_Calculation_Functions::IS_BLANK()
IS_BLANK
IS_ERR: in file Functions.php, method PHPExcel_Calculation_Functions::IS_ERR()
IS_ERR
IS_ERROR: in file Functions.php, method PHPExcel_Calculation_Functions::IS_ERROR()
IS_ERROR
IS_EVEN: in file Functions.php, method PHPExcel_Calculation_Functions::IS_EVEN()
IS_EVEN
IS_LOGICAL: in file Functions.php, method PHPExcel_Calculation_Functions::IS_LOGICAL()
IS_LOGICAL
IS_NA: in file Functions.php, method PHPExcel_Calculation_Functions::IS_NA()
IS_NA
IS_NONTEXT: in file Functions.php, method PHPExcel_Calculation_Functions::IS_NONTEXT()
IS_NONTEXT
IS_NUMBER: in file Functions.php, method PHPExcel_Calculation_Functions::IS_NUMBER()
IS_NUMBER
IS_ODD: in file Functions.php, method PHPExcel_Calculation_Functions::IS_ODD()
IS_ODD
IS_TEXT: in file Functions.php, method PHPExcel_Calculation_Functions::IS_TEXT()
IS_TEXT

top

k

KURT: in file Functions.php, method PHPExcel_Calculation_Functions::KURT()
KURT Returns the kurtosis of a data set. or flatness of a distribution compared with the normal distribution. kurtosis indicates a relatively peaked distribution. relatively flat distribution.

top

l

LARGE: in file Functions.php, method PHPExcel_Calculation_Functions::LARGE()
LARGE Returns the nth largest value in a data set. select a value based on its relative standing.
last: in file Calculation.php, method PHPExcel_Token_Stack::last()
LCM: in file Functions.php, method PHPExcel_Calculation_Functions::LCM()
LCM
LEFT: in file Functions.php, method PHPExcel_Calculation_Functions::LEFT()
LEFT
LINEST: in file Functions.php, method PHPExcel_Calculation_Functions::LINEST()
LINEST Calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and then returns an array that describes the line.
listFunctionNames: in file Calculation.php, method PHPExcel_Calculation::listFunctionNames()
Get a list of implemented Excel function names
listFunctions: in file Calculation.php, method PHPExcel_Calculation::listFunctions()
Get a list of all implemented functions as an array of function objects
LOGEST: in file Functions.php, method PHPExcel_Calculation_Functions::LOGEST()
LOGEST Calculates an exponential curve that best fits the X and Y data series, and then returns an array that describes the line.
LOGICAL_AND: in file Functions.php, method PHPExcel_Calculation_Functions::LOGICAL_AND()
LOGICAL_AND Returns boolean TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.
LOGICAL_FALSE: in file Functions.php, method PHPExcel_Calculation_Functions::LOGICAL_FALSE()
LOGICAL_FALSE Returns the boolean FALSE.
LOGICAL_NOT: in file Functions.php, method PHPExcel_Calculation_Functions::LOGICAL_NOT()
LOGICAL_NOT Returns the boolean inverse of the argument.
LOGICAL_OR: in file Functions.php, method PHPExcel_Calculation_Functions::LOGICAL_OR()
LOGICAL_OR Returns boolean TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
LOGICAL_TRUE: in file Functions.php, method PHPExcel_Calculation_Functions::LOGICAL_TRUE()
LOGICAL_TRUE Returns the boolean TRUE.
LOGINV: in file Functions.php, method PHPExcel_Calculation_Functions::LOGINV()
LOGINV
LOGNORMDIST: in file Functions.php, method PHPExcel_Calculation_Functions::LOGNORMDIST()
LOGNORMDIST Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
LOG_BASE: in file Functions.php, method PHPExcel_Calculation_Functions::LOG_BASE()
LOG_BASE Returns the logarithm of a number to a specified base.
LOG_GAMMA_X_MAX_VALUE: in file Functions.php, constant LOG_GAMMA_X_MAX_VALUE
LOG_GAMMA_X_MAX_VALUE
LOOKUP: in file Functions.php, method PHPExcel_Calculation_Functions::LOOKUP()
LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.
LOWERCASE: in file Functions.php, method PHPExcel_Calculation_Functions::LOWERCASE()
LOWERCASE Converts a string value to upper case.

top

m

MATCH: in file Functions.php, method PHPExcel_Calculation_Functions::MATCH()
MATCH
MAX: in file Functions.php, method PHPExcel_Calculation_Functions::MAX()
MAX MAX returns the value of the element of the values passed that has the highest value, with negative numbers considered smaller than positive numbers.
MAXA: in file Functions.php, method PHPExcel_Calculation_Functions::MAXA()
MAXA
MAX_ITERATIONS: in file Functions.php, constant MAX_ITERATIONS
MAX_ITERATIONS
MAX_VALUE: in file Functions.php, constant MAX_VALUE
MAX_VALUE
MDETERM: in file Functions.php, method PHPExcel_Calculation_Functions::MDETERM()
MDETERM
MEDIAN: in file Functions.php, method PHPExcel_Calculation_Functions::MEDIAN()
MEDIAN Returns the median of the given numbers.
MID: in file Functions.php, method PHPExcel_Calculation_Functions::MID()
MID
MIN: in file Functions.php, method PHPExcel_Calculation_Functions::MIN()
MIN MIN returns the value of the element of the values passed that has the smallest value, with negative numbers considered smaller than positive numbers.
MINA: in file Functions.php, method PHPExcel_Calculation_Functions::MINA()
MINA
MINUTEOFHOUR: in file Functions.php, method PHPExcel_Calculation_Functions::MINUTEOFHOUR()
MINUTEOFHOUR
MINVERSE: in file Functions.php, method PHPExcel_Calculation_Functions::MINVERSE()
MINVERSE
MMULT: in file Functions.php, method PHPExcel_Calculation_Functions::MMULT()
MMULT
MOD: in file Functions.php, method PHPExcel_Calculation_Functions::MOD()
MOD
MODE: in file Functions.php, method PHPExcel_Calculation_Functions::MODE()
MODE
money_format: in file Functions.php, function money_format()
MONTHOFYEAR: in file Functions.php, method PHPExcel_Calculation_Functions::MONTHOFYEAR()
MONTHOFYEAR
MROUND: in file Functions.php, method PHPExcel_Calculation_Functions::MROUND()
MROUND
MULTINOMIAL: in file Functions.php, method PHPExcel_Calculation_Functions::MULTINOMIAL()
MULTINOMIAL Returns the ratio of the factorial of a sum of values to the product of factorials.

top

n

NA: in file Functions.php, method PHPExcel_Calculation_Functions::NA()
NA
NAME: in file Functions.php, method PHPExcel_Calculation_Functions::NAME()
NAME
NaN: in file Functions.php, method PHPExcel_Calculation_Functions::NaN()
NAN
NEGBINOMDIST: in file Functions.php, method PHPExcel_Calculation_Functions::NEGBINOMDIST()
NEGBINOMDIST Returns the negative binomial distribution. there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. distribution, except that the number of successes is fixed, and the number of trials is variable.
NETWORKDAYS: in file Functions.php, method PHPExcel_Calculation_Functions::NETWORKDAYS()
NETWORKDAYS
NOMINAL: in file Functions.php, method PHPExcel_Calculation_Functions::NOMINAL()
NOMINAL Returns the nominal interest rate given the effective rate and the number of compounding payments per year.
NORMDIST: in file Functions.php, method PHPExcel_Calculation_Functions::NORMDIST()
NORMDIST Returns the normal distribution for the specified mean and standard deviation. function has a very wide range of applications in statistics, including hypothesis testing.
NORMINV: in file Functions.php, method PHPExcel_Calculation_Functions::NORMINV()
NORMINV Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDIST: in file Functions.php, method PHPExcel_Calculation_Functions::NORMSDIST()
NORMSDIST Returns the standard normal cumulative distribution function. a mean of 0 (zero) and a standard deviation of one. table of standard normal curve areas.
NORMSINV: in file Functions.php, method PHPExcel_Calculation_Functions::NORMSINV()
NORMSINV
NPER: in file Functions.php, method PHPExcel_Calculation_Functions::NPER()
NPER Returns the number of periods for a cash flow with constant periodic payments (annuities), and interest rate.
NPV: in file Functions.php, method PHPExcel_Calculation_Functions::NPV()
NPV Returns the Net Present Value of a cash flow series given a discount rate.

top

o

OCTTOBIN: in file Functions.php, method PHPExcel_Calculation_Functions::OCTTOBIN()
OCTTOBIN Return an octal value as binary.
OCTTODEC: in file Functions.php, method PHPExcel_Calculation_Functions::OCTTODEC()
OCTTODEC Return an octal value as binary.
OCTTOHEX: in file Functions.php, method PHPExcel_Calculation_Functions::OCTTOHEX()
OCTTOHEX Return an octal value as hex.
ODD: in file Functions.php, method PHPExcel_Calculation_Functions::ODD()
ODD Returns number rounded up to the nearest odd integer.
OFFSET: in file Functions.php, method PHPExcel_Calculation_Functions::OFFSET()
OPERATORS_INFIX: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_INFIX
OPERATORS_POSTFIX: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_POSTFIX
OPERATORS_SN: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::OPERATORS_SN

top

p

PAREN_CLOSE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::PAREN_CLOSE
PAREN_OPEN: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::PAREN_OPEN
parseFormula: in file Calculation.php, method PHPExcel_Calculation::parseFormula()
Validate and parse a formula string
PERCENTILE: in file Functions.php, method PHPExcel_Calculation_Functions::PERCENTILE()
PERCENTILE Returns the nth percentile of values in a range.
PERCENTRANK: in file Functions.php, method PHPExcel_Calculation_Functions::PERCENTRANK()
PERCENTRANK Returns the rank of a value in a data set as a percentage of the data set.
PERMUT: in file Functions.php, method PHPExcel_Calculation_Functions::PERMUT()
PERMUT Returns the number of permutations for a given number of objects that can be selected from number objects. events where internal order is significant. combinations, for which the internal order is not significant. for lottery-style probability calculations.
PHPExcel_Calculation: in file Calculation.php, class PHPExcel_Calculation
PHPExcel_Calculation (Singleton)
PHPExcel_Calculation_Exception: in file Exception.php, class PHPExcel_Calculation_Exception
PHPExcel_Calculation_Exception
PHPExcel_Calculation_ExceptionHandler: in file ExceptionHandler.php, class PHPExcel_Calculation_ExceptionHandler
PHPExcel_Calculation_ExceptionHandler
PHPExcel_Calculation_FormulaParser: in file FormulaParser.php, class PHPExcel_Calculation_FormulaParser
PHPExcel_Calculation_FormulaParser
PHPExcel_Calculation_FormulaToken: in file FormulaToken.php, class PHPExcel_Calculation_FormulaToken
PHPExcel_Calculation_FormulaToken
PHPExcel_Calculation_Function: in file Function.php, class PHPExcel_Calculation_Function
PHPExcel_Calculation_Function
PHPExcel_Calculation_Functions: in file Functions.php, class PHPExcel_Calculation_Functions
PHPExcel_Calculation_Functions
PHPExcel_Token_Stack: in file Calculation.php, class PHPExcel_Token_Stack
PMT: in file Functions.php, method PHPExcel_Calculation_Functions::PMT()
PMT Returns the constant payment (annuity) for a cash flow with a constant interest rate.
POISSON: in file Functions.php, method PHPExcel_Calculation_Functions::POISSON()
POISSON Returns the Poisson distribution. is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
pop: in file Calculation.php, method PHPExcel_Token_Stack::pop()
POWER: in file Functions.php, method PHPExcel_Calculation_Functions::POWER()
POWER Computes x raised to the power y.
PPMT: in file Functions.php, method PHPExcel_Calculation_Functions::PPMT()
PPMT Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
PRECISION: in file Functions.php, constant PRECISION
PRECISION
PRICEDISC: in file Functions.php, method PHPExcel_Calculation_Functions::PRICEDISC()
PRICEDISC Returns the price per $100 face value of a discounted security.
PRICEMAT: in file Functions.php, method PHPExcel_Calculation_Functions::PRICEMAT()
PRICEMAT Returns the price per $100 face value of a security that pays interest at maturity.
PRODUCT: in file Functions.php, method PHPExcel_Calculation_Functions::PRODUCT()
PRODUCT PRODUCT returns the product of all the values and cells referenced in the argument list.
PROPERCASE: in file Functions.php, method PHPExcel_Calculation_Functions::PROPERCASE()
PROPERCASE Converts a string value to upper case.
push: in file Calculation.php, method PHPExcel_Token_Stack::push()
PV: in file Functions.php, method PHPExcel_Calculation_Functions::PV()
PV Returns the Present Value of a cash flow with constant payments and interest rate (annuities).

top

q

QUARTILE: in file Functions.php, method PHPExcel_Calculation_Functions::QUARTILE()
QUARTILE Returns the quartile of a data set.
QUOTE_DOUBLE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::QUOTE_DOUBLE
QUOTE_SINGLE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::QUOTE_SINGLE
QUOTIENT: in file Functions.php, method PHPExcel_Calculation_Functions::QUOTIENT()
QUOTIENT QUOTIENT function returns the integer portion of a division. and denominator is the divisor.

top

r

$returnArrayAsType: in file Calculation.php, variable PHPExcel_Calculation::$returnArrayAsType
$ReturnDateType: in file Functions.php, variable PHPExcel_Calculation_Functions::$ReturnDateType
Data Type to use when returning date values
RAND: in file Functions.php, method PHPExcel_Calculation_Functions::RAND()
RAND
RANK: in file Functions.php, method PHPExcel_Calculation_Functions::RANK()
RANK Returns the rank of a number in a list of numbers.
RECEIVED: in file Functions.php, method PHPExcel_Calculation_Functions::RECEIVED()
RECEIVED Returns the price per $100 face value of a discounted security.
REF: in file Functions.php, method PHPExcel_Calculation_Functions::REF()
REF
REPLACE: in file Functions.php, method PHPExcel_Calculation_Functions::REPLACE()
REPLACE
RETURNDATE_EXCEL: in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_EXCEL
RETURNDATE_PHP_NUMERIC: in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_PHP_NUMERIC
RETURNDATE_PHP_OBJECT: in file Functions.php, class constant PHPExcel_Calculation_Functions::RETURNDATE_PHP_OBJECT
RETURNSTRING: in file Functions.php, method PHPExcel_Calculation_Functions::RETURNSTRING()
RETURNSTRING
RETURN_ARRAY_AS_ARRAY: in file Calculation.php, class constant PHPExcel_Calculation::RETURN_ARRAY_AS_ARRAY
RETURN_ARRAY_AS_VALUE: in file Calculation.php, class constant PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE
constants
REVERSE_ATAN2: in file Functions.php, method PHPExcel_Calculation_Functions::REVERSE_ATAN2()
ATAN2 This function calculates the arc tangent of the two variables x and y. calculating the arc tangent of y ÷ x, except that the signs of both arguments are used to determine the quadrant of the result.
RIGHT: in file Functions.php, method PHPExcel_Calculation_Functions::RIGHT()
RIGHT
ROMAN: in file Functions.php, method PHPExcel_Calculation_Functions::ROMAN()
ROUNDDOWN: in file Functions.php, method PHPExcel_Calculation_Functions::ROUNDDOWN()
ROUNDDOWN
ROUNDUP: in file Functions.php, method PHPExcel_Calculation_Functions::ROUNDUP()
ROUNDUP
ROW: in file Functions.php, method PHPExcel_Calculation_Functions::ROW()
RSQ: in file Functions.php, method PHPExcel_Calculation_Functions::RSQ()
RSQ Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.

top

s

$suppressFormulaErrors: in file Calculation.php, variable PHPExcel_Calculation::$suppressFormulaErrors
SEARCHINSENSITIVE: in file Functions.php, method PHPExcel_Calculation_Functions::SEARCHINSENSITIVE()
SEARCHINSENSITIVE
SEARCHSENSITIVE: in file Functions.php, method PHPExcel_Calculation_Functions::SEARCHSENSITIVE()
SEARCHSENSITIVE
SECONDOFMINUTE: in file Functions.php, method PHPExcel_Calculation_Functions::SECONDOFMINUTE()
SECONDOFMINUTE
SEMICOLON: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::SEMICOLON
SERIESSUM: in file Functions.php, method PHPExcel_Calculation_Functions::SERIESSUM()
SERIESSUM
setArrayReturnType: in file Calculation.php, method PHPExcel_Calculation::setArrayReturnType()
Set the Array Return Type (Array or Value of first element in the array)
setCalculationCacheEnabled: in file Calculation.php, method PHPExcel_Calculation::setCalculationCacheEnabled()
Enable/disable calculation cache
setCalculationCacheExpirationTime: in file Calculation.php, method PHPExcel_Calculation::setCalculationCacheExpirationTime()
Set calculation cache expiration time
setCategory: in file Function.php, method PHPExcel_Calculation_Function::setCategory()
Set Category (represented by CATEGORY_*)
setCompatibilityMode: in file Functions.php, method PHPExcel_Calculation_Functions::setCompatibilityMode()
Set the Compatibility Mode
setExcelName: in file Function.php, method PHPExcel_Calculation_Function::setExcelName()
Set Excel name
setPHPExcelName: in file Function.php, method PHPExcel_Calculation_Function::setPHPExcelName()
Set PHPExcel name
setReturnDateType: in file Functions.php, method PHPExcel_Calculation_Functions::setReturnDateType()
Set the Return Date Format used by functions that return a date/time (Excel, PHP Serialized Numeric or PHP Object)
setTokenSubType: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setTokenSubType()
Set Token SubType
setTokenType: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setTokenType()
Set Token Type
setValue: in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::setValue()
Set Value
SIGN: in file Functions.php, method PHPExcel_Calculation_Functions::SIGN()
SIGN Determines the sign of a number. if the number is 0, and -1 if the number is negative.
SKEW: in file Functions.php, method PHPExcel_Calculation_Functions::SKEW()
SKEW Returns the skewness of a distribution. of a distribution around its mean. asymmetric tail extending toward more positive values. distribution with an asymmetric tail extending toward more negative values.
SLN: in file Functions.php, method PHPExcel_Calculation_Functions::SLN()
SLN
SLOPE: in file Functions.php, method PHPExcel_Calculation_Functions::SLOPE()
SLOPE Returns the slope of the linear regression line through data points in known_y's and known_x's.
SMALL: in file Functions.php, method PHPExcel_Calculation_Functions::SMALL()
SMALL Returns the nth smallest value in a data set. select a value based on its relative standing.
SQRT2PI: in file Functions.php, constant SQRT2PI
SQRT2PI
SQRTPI: in file Functions.php, method PHPExcel_Calculation_Functions::SQRTPI()
SQRTPI Returns the square root of (number * pi).
STANDARDIZE: in file Functions.php, method PHPExcel_Calculation_Functions::STANDARDIZE()
STANDARDIZE Returns a normalized value from a distribution characterized by mean and standard_dev.
STATEMENT_IF: in file Functions.php, method PHPExcel_Calculation_Functions::STATEMENT_IF()
STATEMENT_IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE.
STATEMENT_IFERROR: in file Functions.php, method PHPExcel_Calculation_Functions::STATEMENT_IFERROR()
STATEMENT_IFERROR
STDEV: in file Functions.php, method PHPExcel_Calculation_Functions::STDEV()
STDEV Estimates standard deviation based on a sample. widely values are dispersed from the average value (the mean).
STDEVA: in file Functions.php, method PHPExcel_Calculation_Functions::STDEVA()
STDEVA
STDEVP: in file Functions.php, method PHPExcel_Calculation_Functions::STDEVP()
STDEVP
STDEVPA: in file Functions.php, method PHPExcel_Calculation_Functions::STDEVPA()
STDEVPA
STEYX: in file Functions.php, method PHPExcel_Calculation_Functions::STEYX()
STEYX Returns the standard error of the predicted y-value for each x in the regression.
STRINGLENGTH: in file Functions.php, method PHPExcel_Calculation_Functions::STRINGLENGTH()
STRINGLENGTH
SUBTOTAL: in file Functions.php, method PHPExcel_Calculation_Functions::SUBTOTAL()
SUBTOTAL Returns a subtotal in a list or database.
SUM: in file Functions.php, method PHPExcel_Calculation_Functions::SUM()
SUM SUM computes the sum of all the values and cells referenced in the argument list.
SUMIF: in file Functions.php, method PHPExcel_Calculation_Functions::SUMIF()
SUMIF
SUMSQ: in file Functions.php, method PHPExcel_Calculation_Functions::SUMSQ()
SUMSQ
SUMX2MY2: in file Functions.php, method PHPExcel_Calculation_Functions::SUMX2MY2()
SUMX2MY2
SUMX2PY2: in file Functions.php, method PHPExcel_Calculation_Functions::SUMX2PY2()
SUMX2PY2
SUMXMY2: in file Functions.php, method PHPExcel_Calculation_Functions::SUMXMY2()
SUMXMY2
SYD: in file Functions.php, method PHPExcel_Calculation_Functions::SYD()
SYD Returns the sum-of-years' digits depreciation of an asset for a specified period.

top

t

TBILLEQ: in file Functions.php, method PHPExcel_Calculation_Functions::TBILLEQ()
TBILLEQ Returns the bond-equivalent yield for a Treasury bill.
TBILLPRICE: in file Functions.php, method PHPExcel_Calculation_Functions::TBILLPRICE()
TBILLPRICE Returns the yield for a Treasury bill.
TBILLYIELD: in file Functions.php, method PHPExcel_Calculation_Functions::TBILLYIELD()
TBILLYIELD Returns the yield for a Treasury bill.
TDIST: in file Functions.php, method PHPExcel_Calculation_Functions::TDIST()
TDIST Returns the probability of Student's T distribution.
TEXTFORMAT: in file Functions.php, method PHPExcel_Calculation_Functions::TEXTFORMAT()
TEXTFORMAT
TIME: in file Functions.php, method PHPExcel_Calculation_Functions::TIME()
TIME
TIMEVALUE: in file Functions.php, method PHPExcel_Calculation_Functions::TIMEVALUE()
TIMEVALUE
TINV: in file Functions.php, method PHPExcel_Calculation_Functions::TINV()
TINV Returns the one-tailed probability of the chi-squared distribution.
TOKEN_SUBTYPE_CONCATENATION: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_CONCATENATION
TOKEN_SUBTYPE_ERROR: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_ERROR
TOKEN_SUBTYPE_INTERSECTION: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_INTERSECTION
TOKEN_SUBTYPE_LOGICAL: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_LOGICAL
TOKEN_SUBTYPE_MATH: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_MATH
TOKEN_SUBTYPE_NOTHING: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NOTHING
TOKEN_SUBTYPE_NUMBER: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_NUMBER
TOKEN_SUBTYPE_RANGE: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_RANGE
TOKEN_SUBTYPE_START: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_START
TOKEN_SUBTYPE_STOP: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_STOP
TOKEN_SUBTYPE_TEXT: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_TEXT
TOKEN_SUBTYPE_UNION: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_SUBTYPE_UNION
TOKEN_TYPE_ARGUMENT: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_ARGUMENT
TOKEN_TYPE_FUNCTION: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_FUNCTION
TOKEN_TYPE_NOOP: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_NOOP
TOKEN_TYPE_OPERAND: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERAND
TOKEN_TYPE_OPERATORINFIX: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORINFIX
TOKEN_TYPE_OPERATORPOSTFIX: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPOSTFIX
TOKEN_TYPE_OPERATORPREFIX: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_OPERATORPREFIX
TOKEN_TYPE_SUBEXPRESSION: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_SUBEXPRESSION
TOKEN_TYPE_UNKNOWN: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_UNKNOWN
TOKEN_TYPE_WHITESPACE: in file FormulaToken.php, class constant PHPExcel_Calculation_FormulaToken::TOKEN_TYPE_WHITESPACE
TRANSPOSE: in file Functions.php, method PHPExcel_Calculation_Functions::TRANSPOSE()
TRANSPOSE
TREND: in file Functions.php, method PHPExcel_Calculation_Functions::TREND()
TREND
TRIMMEAN: in file Functions.php, method PHPExcel_Calculation_Functions::TRIMMEAN()
TRIMMEAN Returns the mean of the interior of a data set. taken by excluding a percentage of data points from the top and bottom tails of a data set.
TRIMNONPRINTABLE: in file Functions.php, method PHPExcel_Calculation_Functions::TRIMNONPRINTABLE()
TRIMNONPRINTABLE
TRIMSPACES: in file Functions.php, method PHPExcel_Calculation_Functions::TRIMSPACES()
TRIMSPACES
TRUNC: in file Functions.php, method PHPExcel_Calculation_Functions::TRUNC()
TRUNC Truncates value to the number of fractional digits by number_digits.

top

u

UPPERCASE: in file Functions.php, method PHPExcel_Calculation_Functions::UPPERCASE()
UPPERCASE Converts a string value to upper case.

top

v

VARA: in file Functions.php, method PHPExcel_Calculation_Functions::VARA()
VARA
VARFunc: in file Functions.php, method PHPExcel_Calculation_Functions::VARFunc()
VARFunc Estimates variance based on a sample.
VARP: in file Functions.php, method PHPExcel_Calculation_Functions::VARP()
VARP
VARPA: in file Functions.php, method PHPExcel_Calculation_Functions::VARPA()
VARPA
VERSION: in file Functions.php, method PHPExcel_Calculation_Functions::VERSION()
VERSION
VLOOKUP: in file Functions.php, method PHPExcel_Calculation_Functions::VLOOKUP()
VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.

top

w

$writeDebugLog: in file Calculation.php, variable PHPExcel_Calculation::$writeDebugLog
WEEKOFYEAR: in file Functions.php, method PHPExcel_Calculation_Functions::WEEKOFYEAR()
WEEKOFYEAR
WEIBULL: in file Functions.php, method PHPExcel_Calculation_Functions::WEIBULL()
WEIBULL Returns the Weibull distribution. analysis, such as calculating a device's mean time to failure.
WHITESPACE: in file FormulaParser.php, class constant PHPExcel_Calculation_FormulaParser::WHITESPACE
WORKDAY: in file Functions.php, method PHPExcel_Calculation_Functions::WORKDAY()
WORKDAY

top

x

XMININ: in file Functions.php, constant XMININ
XMININ

top

y

YEAR: in file Functions.php, method PHPExcel_Calculation_Functions::YEAR()
YEAR
YEARFRAC: in file Functions.php, method PHPExcel_Calculation_Functions::YEARFRAC()
YEARFRAC Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). to assign to a specific term.
YIELDDISC: in file Functions.php, method PHPExcel_Calculation_Functions::YIELDDISC()
YIELDDISC Returns the annual yield of a security that pays interest at maturity.
YIELDMAT: in file Functions.php, method PHPExcel_Calculation_Functions::YIELDMAT()
YIELDMAT Returns the annual yield of a security that pays interest at maturity.

top

Documentation generated on Mon, 10 Aug 2009 08:01:08 +0200 by phpDocumentor 1.4.1