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 ]
[ v ]
[ w ]
[ x ]
[ y ]
[ _ ]
_
- $_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_*)
- $_errorCodes
- in file Functions.php, variable PHPExcel_Calculation_Functions::$_errorCodes
List of error codes
- $_excelName
- in file Function.php, variable PHPExcel_Calculation_Function::$_excelName
Excel name
- $_formula
- in file FormulaParser.php, variable PHPExcel_Calculation_FormulaParser::$_formula
Formula
- $_functionMappings
- in file Calculation.php, variable PHPExcel_Calculation::$_functionMappings
Function mappings (from Excel to PHPExcel)
- $_instance
- in file Calculation.php, variable PHPExcel_Calculation::$_instance
Instance of this class
- $_invalidChars
- in file Functions.php, variable PHPExcel_Calculation_Functions::$_invalidChars
- $_phpExcelName
- in file Function.php, variable PHPExcel_Calculation_Function::$_phpExcelName
PHPExcel name
- $_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_*)
- $_value
- in file FormulaToken.php, variable PHPExcel_Calculation_FormulaToken::$_value
Value
- _getDateValue
- in file Functions.php, method PHPExcel_Calculation_Functions::_getDateValue()
_getDateValue
- _getTimeValue
- in file Functions.php, method PHPExcel_Calculation_Functions::_getTimeValue()
_getTimeValue
- _parseToTokens
- in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::_parseToTokens()
Parse to tokens
- __clone
- in file Calculation.php, method PHPExcel_Calculation::__clone()
__clone implementation.
- __construct
- in file Calculation.php, method PHPExcel_Calculation::__construct()
Create a new PHPExcel_Calculation
- __construct
- in file FormulaParser.php, method PHPExcel_Calculation_FormulaParser::__construct()
Create a new PHPExcel_Calculation_FormulaParser
- __construct
- in file FormulaToken.php, method PHPExcel_Calculation_FormulaToken::__construct()
Create a new PHPExcel_Calculation_FormulaToken
- __construct
- in file Function.php, method PHPExcel_Calculation_Function::__construct()
Create a new PHPExcel_Calculation_Function
top
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.
- Besselk0
- in file Functions.php, method PHPExcel_Calculation_Functions::Besselk0()
- Besselk1
- in file Functions.php, method PHPExcel_Calculation_Functions::Besselk1()
- 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.
- 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.
- BETADIST
- in file Functions.php, method PHPExcel_Calculation_Functions::BETADIST()
BETADIST
Returns the beta distribution.
- betaFraction
- in file Functions.php, method PHPExcel_Calculation_Functions::betaFraction()
Evaluates of continued fraction part of incomplete beta function.
- 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)
- 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
- 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
- COUNT
- in file Functions.php, method PHPExcel_Calculation_Functions::COUNT()
COUNT
- COUNTA
- in file Functions.php, method PHPExcel_Calculation_Functions::COUNTA()
COUNTA
- COUNTBLANK
- in file Functions.php, method PHPExcel_Calculation_Functions::COUNTBLANK()
COUNTBLANK
- CRITBINOM
- in file Functions.php, method PHPExcel_Calculation_Functions::CRITBINOM()
CRITBINOM
- Calculation.php
- procedural page Calculation.php
top
d
- DATE
- in file Functions.php, method PHPExcel_Calculation_Functions::DATE()
DATE
- DATEDIF
- in file Functions.php, method PHPExcel_Calculation_Functions::DATEDIF()
DATEDIF
- dateDiff360
- in file Functions.php, method PHPExcel_Calculation_Functions::dateDiff360()
- 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
- 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.
- 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.
- 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
- ERF
- in file Functions.php, method PHPExcel_Calculation_Functions::ERF()
ERF
- ERFC
- in file Functions.php, method PHPExcel_Calculation_Functions::ERFC()
ERFC
- erfcVal
- in file Functions.php, method PHPExcel_Calculation_Functions::erfcVal()
- erfVal
- in file Functions.php, method PHPExcel_Calculation_Functions::erfVal()
- 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
- 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.
- extractCell
- in file Calculation.php, method PHPExcel_Calculation::extractCell()
Extract cell
- extractRange
- in file Calculation.php, method PHPExcel_Calculation::extractRange()
Extract range values
top
f
- 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.
- factors
- in file Functions.php, method PHPExcel_Calculation_Functions::factors()
- 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.
- 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.
- 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
- gamma
- in file Functions.php, method PHPExcel_Calculation_Functions::gamma()
- 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
- 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 Return Date Format (Excel, PHP Serialized 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
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
- hypGeom
- in file Functions.php, method PHPExcel_Calculation_Functions::hypGeom()
- 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.
- incompleteBeta
- in file Functions.php, method PHPExcel_Calculation_Functions::incompleteBeta()
Incomplete beta function
- incompleteGamma
- in file Functions.php, method PHPExcel_Calculation_Functions::incompleteGamma()
- INDEX
- in file Functions.php, method PHPExcel_Calculation_Functions::INDEX()
Uses an index to choose a value from a reference or array
- 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()
- isImplemented
- in file Calculation.php, method PHPExcel_Calculation::isImplemented()
Is a specific function implemented?
- isLeapYear
- in file Functions.php, method PHPExcel_Calculation_Functions::isLeapYear()
- 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_NUMBER
- in file Functions.php, method PHPExcel_Calculation_Functions::IS_NUMBER()
IS_NUMBER
- 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
- $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
- 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.
- LCM
- in file Functions.php, method PHPExcel_Calculation_Functions::LCM()
LCM
- LEFT
- in file Functions.php, method PHPExcel_Calculation_Functions::LEFT()
LEFT
- 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 implemented functions
- 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()
- 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 FALSE.
- 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 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_GAMMA_X_MAX_VALUE
- in file Functions.php, constant 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.
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_VALUE
- in file Functions.php, constant MAX_VALUE
- 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
- 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
- modeCalc
- in file Functions.php, method PHPExcel_Calculation_Functions::modeCalc()
- 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
- 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
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
- parseComplex
- in file Functions.php, method PHPExcel_Calculation_Functions::parseComplex()
- PERCENTILE
- in file Functions.php, method PHPExcel_Calculation_Functions::PERCENTILE()
PERCENTILE
Returns the nth percentile of values in a range.
- 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_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
- 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.
- POWER
- in file Functions.php, method PHPExcel_Calculation_Functions::POWER()
POWER
Computes x raised to the power y.
- PRECISION
- in file Functions.php, constant PRECISION
- 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.
- 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
top
r
- $rel_error
- in file Functions.php, variable PHPExcel_Calculation_Functions::$rel_error
- $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
- 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
- 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()
top
s
- 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 (Excel, PHP Serialized 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
- 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
- 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
- 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
- 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.
- SUMSQ
- in file Functions.php, method PHPExcel_Calculation_Functions::SUMSQ()
SUMSQ
- 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
- $two_sqrtpi
- in file Functions.php, variable PHPExcel_Calculation_Functions::$two_sqrtpi
- TDIST
- in file Functions.php, method PHPExcel_Calculation_Functions::TDIST()
TDIST
Returns the probability of Student's T distribution.
- 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
- 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
top
top
x
- XMININ
- in file Functions.php, constant XMININ
top
top
|
|
