Docs For Class PHPExcel_Calculation

static void adjustDateByMonths(
[
$dateValue = 0], [
$adjustmentMonths = 0])

Tags:

access:

private

Parameters:

	$dateValue
	$adjustmentMonths

[ Top ]

static int ASCIICODE(

$characters, string
$character)

ASCIICODE

Tags:

access:

public

Parameters:

string	$character	Value
	$characters

[ Top ]

static float AVEDEV(
array
0)

AVEDEV Returns the average of the absolute deviations of data points from their mean.

AVEDEV Returns the average of the absolute deviations of data points from their mean. AVEDEV is a measure of the variability in a data set.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float AVERAGE(
array
0)

AVERAGE

AVERAGE Returns the average (arithmetic mean) of the arguments

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float AVERAGEA(
array
0)

AVERAGEA

AVERAGEA Returns the average of its arguments, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int BESSELI(
float
$x, float
$n)

BESSELI

BESSELI Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments

Tags:

access:

public

Parameters:

float	$x
float	$n

[ Top ]

static int BESSELJ(
float
$x, float
$n)

BESSELJ

BESSELJ Returns the Bessel function

Tags:

access:

public

Parameters:

float	$x
float	$n

[ Top ]

static int BESSELK(
float
$x, 
$ord, float
$n)

BESSELK Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments.

Tags:

access:

public

Parameters:

float	$x
float	$n
	$ord

[ Top ]

static void Besselk0(

$fNum)

Tags:

access:

private

Parameters:

$fNum

[ Top ]

static void Besselk1(

$fNum)

Tags:

access:

private

Parameters:

$fNum

[ Top ]

static int BESSELY(
float
$x, 
$ord, float
$n)

BESSELY Returns the Bessel function, which is also called the Weber function or the Neumann function.

Tags:

access:

public

Parameters:

float	$x
float	$n
	$ord

[ Top ]

static void Bessely0(

$fNum)

Tags:

access:

private

Parameters:

$fNum

[ Top ]

static void Bessely1(

$fNum)

Tags:

access:

private

Parameters:

$fNum

[ Top ]

static 0 beta(
p
$p, q
$q)

Beta function.

Tags:

return:	if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow
author:	Jaco van Kooten
access:	private

Parameters:

p	$p	require p>0
q	$q	require q>0

[ Top ]

static float BETADIST(
float
$value, float
$alpha, float
$beta, [
$rMin = 0], [
$rMax = 1], boolean
$cumulative)

BETADIST Returns the beta distribution.

Tags:

access:

public

Parameters:

float	$value	Value at which you want to evaluate the distribution
float	$alpha	Parameter to the distribution
float	$beta	Parameter to the distribution
boolean	$cumulative
	$rMin
	$rMax

[ Top ]

static void betaFraction(

$x, 
$p, 
$q)

Evaluates of continued fraction part of incomplete beta function.

Evaluates of continued fraction part of incomplete beta function. Based on an idea from Numerical Recipes (W.H. Press et al, 1992).

Tags:

author:	Jaco van Kooten
access:	private

Parameters:

	$x
	$p
	$q

[ Top ]

static float BETAINV(
float
$probability, float
$alpha, float
$beta, [
$rMin = 0], [
$rMax = 1], boolean
$cumulative)

BETAINV Returns the inverse of the beta distribution.

Tags:

access:

public

Parameters:

float	$probability	Probability at which you want to evaluate the distribution
float	$alpha	Parameter to the distribution
float	$beta	Parameter to the distribution
boolean	$cumulative
	$rMin
	$rMax

[ Top ]

static float BINOMDIST(
float
$value, float
$trials, float
$probability, boolean
$cumulative)

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.

BINOMDIST Returns the individual term binomial distribution probability. Use BINOMDIST in problems with 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. For example, BINOMDIST can calculate the probability that two of the next three babies born are male.

Tags:

todo:	Cumulative distribution function
access:	public

Parameters:

float	$value	Number of successes in trials
float	$trials	Number of trials
float	$probability	Probability of success on each trial
boolean	$cumulative

[ Top ]

static string BINTODEC(
string
$x)

BINTODEC Return a binary value as Decimal.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string BINTOHEX(
string
$x)

BINTOHEX Return a binary value as Hex.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string BINTOOCT(
string
$x)

BINTOOCT Return a binary value as Octal.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static float CEILING(
float
$number, [float
$significance = null])

CEILING Returns number rounded up, away from zero, to the nearest multiple of significance.

Tags:

return:	Rounded Number
access:	public

Parameters:

float	$number	Number to round
float	$significance	Significance

[ Top ]

static string CELL_ADDRESS(
row
$row, column
$column, [relativity
$relativity = 1], [sheetText
$referenceStyle = True], [
$sheetText = ''])

CELL_ADDRESS

CELL_ADDRESS Returns the straight-line depreciation of an asset for one period

Tags:

access:

public

Parameters:

row	$row	Row number to use in the cell reference
column	$column	Column number to use in the cell reference
relativity	$relativity	Flag indicating the type of reference to return
sheetText	$referenceStyle	Name of worksheet to use
	$sheetText

[ Top ]

static float CHIDIST(
float
$value, float
$degrees)

CHIDIST Returns the one-tailed probability of the chi-squared distribution.

Tags:

access:

public

Parameters:

float	$value	Value for the function
float	$degrees	degrees of freedom

[ Top ]

static float CHIINV(
float
$probability, float
$degrees)

CHIINV Returns the one-tailed probability of the chi-squared distribution.

Tags:

access:

public

Parameters:

float	$probability	Probability for the function
float	$degrees	degrees of freedom

[ Top ]

static void CHOOSE(
)

Tags:

access:

public

[ Top ]

static void COLUMN(
[
$cellAddress = Null])

Tags:

access:

public

Parameters:

$cellAddress

[ Top ]

static int COMBIN(
int
$numObjs, int
$numInSet)

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.

COMBIN Returns the number of combinations for a given number of items. Use COMBIN to determine the total possible number of groups for a given number of items.

Tags:

return:	Number of combinations
access:	public

Parameters:

int	$numObjs	Number of different objects
int	$numInSet	Number of objects in each combination

[ Top ]

static string COMPLEX(
[float
$realNumber = 0.0], [float
$imaginary = 0.0], [string
$suffix = 'i'])

COMPLEX returns a complex number of the form x + yi or x + yj.

Tags:

access:

public

Parameters:

float	$realNumber
float	$imaginary
string	$suffix

[ Top ]

static string CONCATENATE(
)

CONCATENATE

Tags:

access:

public

[ Top ]

static float CONFIDENCE(
float
$alpha, float
$stdDev, float
$size)

CONFIDENCE

CONFIDENCE Returns the confidence interval for a population mean

Tags:

access:

public

Parameters:

float	$alpha
float	$stdDev	Standard Deviation
float	$size

[ Top ]

static int COUNT(
array
0)

COUNT

COUNT Counts the number of cells that contain numbers within the list of arguments

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int COUNTA(
array
0)

COUNTA

COUNTA Counts the number of cells that are not empty within the list of arguments

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int COUNTBLANK(
array
0)

COUNTBLANK

COUNTBLANK Counts the number of empty cells within the list of arguments

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int CRITBINOM(
float
$trials, float
$probability, float
$alpha)

CRITBINOM

CRITBINOM Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value See http://support.microsoft.com/kb/828117/ for details of the algorithm used

Tags:

todo:	Warning. This implementation differs from the algorithm detailed on the MS web site in that $CumPGuessMinus1 = $CumPGuess - 1 rather than $CumPGuess - $PGuess This eliminates a potential endless loop error, but may have an adverse affect on the accuracy of the function (although all my tests have so far returned correct results).
access:	public

Parameters:

float	$trials	number of Bernoulli trials
float	$probability	probability of a success on each trial
float	$alpha	criterion value

[ Top ]

static mixed DATE(
[long
$year = 0], [long
$month = 1], [long
$day = 1])

DATE

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

Parameters:

long	$year
long	$month
long	$day

[ Top ]

static long DATEDIF(
[long
$startDate = 0], [long
$endDate = 0], [string
$unit = 'D'])

DATEDIF

Tags:

return:	Interval between the dates
access:	public

Parameters:

long	$startDate	Excel date serial value or a standard date string
long	$endDate	Excel date serial value or a standard date string
string	$unit

[ Top ]

static void dateDiff360(

$startDay, 
$startMonth, 
$startYear, 
$endDay, 
$endMonth, 
$endYear, 
$methodUS)

Tags:

access:

private

Parameters:

	$startDay
	$startMonth
	$startYear
	$endDay
	$endMonth
	$endYear
	$methodUS

[ Top ]

static mixed DATENOW(
)

DATENOW

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

[ Top ]

static mixed DATETIMENOW(
)

DATETIMENOW

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

[ Top ]

static mixed DATEVALUE(
[string
$dateValue = 1])

DATEVALUE

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

Parameters:

string

$dateValue

[ Top ]

static int DAYOFMONTH(
[long
$dateValue = 1])

DAYOFMONTH

Tags:

return:	Day
access:	public

Parameters:

long

$dateValue

Excel date serial value or a standard date string

[ Top ]

static int DAYOFWEEK(
[long
$dateValue = 1], [
$style = 1])

DAYOFWEEK

Tags:

return:	Day
access:	public

Parameters:

long	$dateValue	Excel date serial value or a standard date string
	$style

[ Top ]

static long DAYS360(
[long
$startDate = 0], [long
$endDate = 0], [boolean
$method = false])

DAYS360

Tags:

return:	PHP date/time serial
access:	public

Parameters:

long	$startDate	Excel date serial value or a standard date string
long	$endDate	Excel date serial value or a standard date string
boolean	$method	US or European Method

[ Top ]

static string DECTOBIN(
string
$x)

DECTOBIN Return an octal value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string DECTOHEX(
string
$x)

DECTOHEX Return an octal value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string DECTOOCT(
string
$x)

DECTOOCT Return an octal value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static int DELTA(
float
$a, [float
$b = 0])

DELTA Tests whether two values are equal.

DELTA Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise.

Tags:

access:

public

Parameters:

float	$a
float	$b

[ Top ]

static float DEVSQ(
array
0)

DEVSQ Returns the sum of squares of deviations of data points from their sample mean.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static string DUMMY(
)

DUMMY

Tags:

return:	#NAME?
access:	public

[ Top ]

static long EDATE(
[long
$dateValue = 1], [int
$adjustmentMonths = 0])

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).

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). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

Tags:

return:	Excel date serial value
access:	public

Parameters:

long	$dateValue	Excel date serial value or a standard date string
int	$adjustmentMonths	Number of months to adjust by

[ Top ]

static float EFFECT(
[float
$nominal_rate = 0], [int
$npery = 0])

EFFECT Returns the effective interest rate given the nominal rate and the number of compounding payments per year.

Tags:

access:

public

Parameters:

float	$nominal_rate	Nominal interest rate
int	$npery	Number of compounding payments per year

[ Top ]

static long EOMONTH(
[long
$dateValue = 1], [int
$adjustmentMonths = 0])

EOMONTH Returns the serial number for the last day of the month that is the indicated number of months before or after start_date.

EOMONTH Returns the serial number for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.

Tags:

return:	Excel date serial value
access:	public

Parameters:

long	$dateValue	Excel date serial value or a standard date string
int	$adjustmentMonths	Number of months to adjust by

[ Top ]

static int ERF(
float
$lower, [float
$upper = 0])

ERF

ERF Returns the error function integrated between lower_limit and upper_limit

Tags:

access:

public

Parameters:

float	$lower	lower bound for integrating ERF
float	$upper	upper bound for integrating ERF. If omitted, ERF integrates between zero and lower_limit

[ Top ]

static int ERFC(
float
$x)

ERFC

ERFC Returns the complementary ERF function integrated between x and infinity

Tags:

access:

public

Parameters:

float

$x

The lower bound for integrating ERF

[ Top ]

static void erfcVal(

$x)

Tags:

access:

private

Parameters:

$x

[ Top ]

static void erfVal(

$x)

Tags:

access:

private

Parameters:

$x

[ Top ]

static boolean ERROR_TYPE(
[mixed
$value = ''])

ERROR_TYPE

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static int EVEN(
float
$number)

EVEN Returns number rounded up to the nearest even integer.

Tags:

return:	Rounded Number
access:	public

Parameters:

float

$number

Number to round

[ Top ]

static float EXPONDIST(
float
$value, float
$lambda, boolean
$cumulative)

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.

EXPONDIST Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.

Tags:

access:

public

Parameters:

float	$value	Value of the function
float	$lambda	The parameter value
boolean	$cumulative

[ Top ]

static int FACT(
float
$factVal)

FACT Returns the factorial of a number.

Tags:

return:	Factorial
access:	public

Parameters:

float

$factVal

Factorial Value

[ Top ]

static int FACTDOUBLE(
float
$factVal)

FACTDOUBLE Returns the double factorial of a number.

Tags:

return:	Double Factorial
access:	public

Parameters:

float

$factVal

Factorial Value

[ Top ]

static void factors(

$value)

Tags:

access:

private

Parameters:

$value

[ Top ]

static float FISHER(
float
$value)

FISHER Returns the Fisher transformation at x. is normally distributed rather than skewed. testing on the correlation coefficient.

FISHER Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Tags:

access:

public

Parameters:

float

$value

[ Top ]

static float FISHERINV(
float
$value)

FISHERINV Returns the inverse of the Fisher transformation. analyzing correlations between ranges or arrays of data. FISHERINV(y) = x.

FISHERINV Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Tags:

access:

public

Parameters:

float

$value

[ Top ]

static array flattenArray(
array
$array)

Flatten multidemensional array

Tags:

return:	Flattened array
access:	public

Parameters:

array

$array

Array to be flattened

[ Top ]

static mixed flattenSingleValue(
[mixed
$value = ''])

Convert an array with one element to a flat value

Tags:

access:

public

Parameters:

mixed

$value

Array or flat value

[ Top ]

static float FLOOR(
float
$number, [float
$significance = null])

FLOOR Rounds number down, toward zero, to the nearest multiple of significance.

Tags:

return:	Rounded Number
access:	public

Parameters:

float	$number	Number to round
float	$significance	Significance

[ Top ]

static float FV(
[float
$rate = 0], [int
$nper = 0], [float
$pmt = 0], [float
$pv = 0], [int
$type = 0])

FV Returns the Future Value of a cash flow with constant payments and interest rate (annuities).

Tags:

access:

public

Parameters:

float	$rate	Interest rate per period
int	$nper	Number of periods
float	$pmt	Periodic payment (annuity)
float	$pv	Present Value
int	$type	Payment type: 0 = at the end of each period, 1 = at the beginning of each period

[ Top ]

static void gamma(

$data)

Tags:

access:

private

Parameters:

$data

[ Top ]

static float GAMMADIST(
float
$value, float
$a, float
$b, boolean
$cumulative)

GAMMADIST Returns the gamma distribution.

Tags:

access:

public

Parameters:

float	$value	Value at which you want to evaluate the distribution
float	$a	Parameter to the distribution
float	$b	Parameter to the distribution
boolean	$cumulative

[ Top ]

static float GAMMAINV(
float
$probability, float
$alpha, float
$beta, boolean
$cumulative)

GAMMAINV Returns the inverse of the beta distribution.

Tags:

access:

public

Parameters:

float	$probability	Probability at which you want to evaluate the distribution
float	$alpha	Parameter to the distribution
float	$beta	Parameter to the distribution
boolean	$cumulative

[ Top ]

static float GAMMALN(
float
$value)

GAMMALN Returns the natural logarithm of the gamma function.

Tags:

access:

public

Parameters:

float

$value

[ Top ]

static int GCD(
$array
0)

GCD

GCD Returns the greatest common divisor of a series of numbers

Tags:

return:	Greatest Common Divisor
access:	public

Parameters:

$array

0

Values to calculate the Greatest Common Divisor

[ Top ]

static float GEOMEAN(
array
0)

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.

GEOMEAN Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int GESTEP(
float
$number, [float
$step = 0])

GESTEP

GESTEP Returns 1 if number = step; returns 0 (zero) otherwise

Tags:

access:

public

Parameters:

float	$number
float	$step

[ Top ]

static string getCompatibilityMode(
)

Return the current Compatibility Mode

Tags:

return:	Compatibility Mode
access:	public

[ Top ]

static integer getReturnDateType(
)

Return the Return Date Format (Excel, PHP Serialized or PHP Object)

Tags:

return:	Return Date Format
access:	public

[ Top ]

static float HARMEAN(
array
0)

HARMEAN Returns the harmonic mean of a data set. arithmetic mean of reciprocals.

HARMEAN Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static string HEXTOBIN(
string
$x)

HEXTOBIN Return a hex value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string HEXTODEC(
string
$x)

HEXTODEC Return a hex value as octal.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string HEXTOOCT(
string
$x)

HEXTOOCT Return a hex value as octal.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static int HOUROFDAY(
[mixed
$timeValue = 0])

HOUROFDAY

Tags:

return:	Hour
access:	public

Parameters:

mixed

$timeValue

Excel time serial value or a standard time string

[ Top ]

static void hypGeom(

$sampleSuccesses, 
$sampleNumber, 
$populationSuccesses, 
$populationNumber)

Tags:

access:

public

Parameters:

	$sampleSuccesses
	$sampleNumber
	$populationSuccesses
	$populationNumber

[ Top ]

static float HYPGEOMDIST(
float
$sampleSuccesses, float
$sampleNumber, float
$populationSuccesses, float
$populationNumber)

HYPGEOMDIST Returns the hypergeometric distribution. sample successes, given the sample size, population successes, and population size.

HYPGEOMDIST Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size.

Tags:

access:

public

Parameters:

float	$sampleSuccesses	Number of successes in the sample
float	$sampleNumber	Size of the sample
float	$populationSuccesses	Number of successes in the population
float	$populationNumber	Population size

[ Top ]

static real IMABS(
string
$complexNumber)

IMABS Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static real IMAGINARY(
string
$complexNumber)

IMAGINARY Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMARGUMENT(
string
$complexNumber)

IMARGUMENT Returns the argument theta of a complex number, i.

IMARGUMENT Returns the argument theta of a complex number, i.e. the angle in radians from the real axis to the representation of the number in polar coordinates.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMCONJUGATE(
string
$complexNumber)

IMCONJUGATE Returns the complex conjugate of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMCOS(
string
$complexNumber)

IMCOS Returns the cosine of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static real IMDIV(
string
$complexDividend, string
$complexDivisor)

IMDIV Returns the quotient of two complex numbers in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string	$complexDividend
string	$complexDivisor

[ Top ]

static string IMEXP(
string
$complexNumber)

IMEXP Returns the exponential of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMLN(
string
$complexNumber)

IMLN Returns the natural logarithm of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMLOG2(
string
$complexNumber)

IMLOG2 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMLOG10(
string
$complexNumber)

IMLOG10 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMPOWER(
string
$complexNumber, 
$realNumber)

IMPOWER Returns a complex number in x + yi or x + yj text format raised to a power.

Tags:

access:

public

Parameters:

string	$complexNumber
	$realNumber

[ Top ]

static real IMPRODUCT(
array
0)

IMPRODUCT Returns the product of two or more complex numbers in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static real IMREAL(
string
$complexNumber)

IMREAL Returns the real coefficient of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMSIN(
string
$complexNumber)

IMSIN Returns the sine of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static string IMSQRT(
string
$complexNumber)

IMSQRT Returns the square root of a complex number in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string

$complexNumber

[ Top ]

static real IMSUB(
string
$complexNumber1, string
$complexNumber2)

IMSUB Returns the difference of two complex numbers in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

string	$complexNumber1
string	$complexNumber2

[ Top ]

static real IMSUM(
array
0)

IMSUM Returns the sum of two or more complex numbers in x + yi or x + yj text format.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static 0 incompleteBeta(
x
$x, p
$p, q
$q)

Incomplete beta function

Tags:

return:	if x<0, p<=0, q<=0 or p+q>2.55E305 and 1 if x>1 to avoid errors and over/underflow
author:	Paul Meagher The computation is based on formulas from Numerical Recipes, Chapter 6.4 (W.H. Press et al, 1992).
author:	Jaco van Kooten
access:	private

Parameters:

x	$x	require 0<=x<=1
p	$p	require p>0
q	$q	require q>0

[ Top ]

static void incompleteGamma(

$a, 
$x)

Tags:

access:

private

Parameters:

	$a
	$x

[ Top ]

static void INDEX(
range_array
$range_array, [row_num
$row_num = null], [column_num
$column_num = null])

Uses an index to choose a value from a reference or array

Uses an index to choose a value from a reference or array implemented: Return the value of a specified cell or array of cells Array form not implemented: Return a reference to specified cells Reference form

Tags:

access:

public

Parameters:

range_array	$range_array	a range of cells or an array constant
row_num	$row_num	selects the row in array from which to return a value. If row_num is omitted, column_num is required.
column_num	$column_num	selects the column in array from which to return a value. If column_num is omitted, row_num is required.

[ Top ]

static void inverse_ncdf(

$p)

*************************************************************************

************************************************************************* inverse_ncdf.php ------------------- begin : Friday, January 16, 2004 copyright : (C) 2004 Michael Nickerson email : nickersonm@yahoo.com *************************************************************************

Tags:

access:

private

Parameters:

$p

[ Top ]

static void inverse_ncdf2(

$prob)

Tags:

access:

private

Parameters:

$prob

[ Top ]

static void inverse_ncdf3(

$p)

Tags:

access:

private

Parameters:

$p

[ Top ]

static void isLeapYear(

$year)

Tags:

access:

private

Parameters:

$year

[ Top ]

static boolean IS_BLANK(
[mixed
$value = ''])

IS_BLANK

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_ERR(
[mixed
$value = ''])

IS_ERR

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_ERROR(
[mixed
$value = ''])

IS_ERROR

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_EVEN(
[mixed
$value = 0])

IS_EVEN

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_LOGICAL(
[mixed
$value = true])

IS_LOGICAL

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_NA(
[mixed
$value = ''])

IS_NA

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_NUMBER(
[mixed
$value = 0])

IS_NUMBER

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static boolean IS_TEXT(
[mixed
$value = ''])

IS_TEXT

Tags:

access:

public

Parameters:

mixed

$value

Value to check

[ Top ]

static float KURT(
array
0)

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.

KURT Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness or flatness of a distribution compared with the normal distribution. Positive kurtosis indicates a relatively peaked distribution. Negative kurtosis indicates a relatively flat distribution.

Tags:

access:

public

Parameters:

array

0

Data Series

[ Top ]

static float LARGE(
array
0, float
1)

LARGE Returns the nth largest value in a data set. select a value based on its relative standing.

LARGE Returns the nth largest value in a data set. You can use this function to select a value based on its relative standing.

Tags:

access:

public

Parameters:

array	0	of mixed Data Series
float	1	Entry in the series to return

[ Top ]

static int LCM(
$array
0)

LCM

LCM Returns the lowest common multiplier of a series of numbers

Tags:

return:	Lowest Common Multiplier
access:	public

Parameters:

$array

0

Values to calculate the Lowest Common Multiplier

[ Top ]

static string LEFT(
[string
$value = ''], [int
$chars = null])

LEFT

Tags:

access:

public

Parameters:

string	$value	Value
int	$chars	Number of characters

[ Top ]

static 0 logBeta(
p
$p, q
$q)

The natural logarithm of the beta function.

Tags:

return:	if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow
author:	Jaco van Kooten
access:	private

Parameters:

p	$p	require p>0
q	$q	require q>0

[ Top ]

static void logGamma(

$x)

Tags:

access:

private

Parameters:

$x

[ Top ]

static boolean LOGICAL_AND(
array
0)

LOGICAL_AND Returns boolean TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.

LOGICAL_AND Returns boolean TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE. Booleans arguments are treated as True or False as appropriate Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False If any argument value is a string, or a Null, it is ignored Quirk of Excel: String values passed directly to the function rather than through a cell reference e.g.=AND(1,"A",1) will return a #VALUE! error, _not_ ignoring the string. This behaviour is not replicated

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static boolean LOGICAL_FALSE(
)

LOGICAL_FALSE Returns FALSE.

Tags:

access:

public

[ Top ]

static boolean LOGICAL_OR(
array
0)

LOGICAL_OR Returns boolean TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

LOGICAL_OR Returns boolean TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE. Booleans arguments are treated as True or False as appropriate Integer or floating point arguments are treated as True, except for 0 or 0.0 which are False If any argument value is a string, or a Null, it is ignored

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static boolean LOGICAL_TRUE(
)

LOGICAL_TRUE Returns TRUE.

Tags:

access:

public

[ Top ]

static float LOGINV(

$probability, 
$mean, 
$stdDev, float
$value)

LOGINV

LOGINV Returns the inverse of the normal cumulative distribution

Tags:

todo:	Try implementing P J Acklam's refinement algorithm for greater accuracy if I can get my head round the mathematics (as described at) http://home.online.no/~pjacklam/notes/invnorm/
access:	public

Parameters:

float	$value
	$probability
	$mean
	$stdDev

[ Top ]

static float LOGNORMDIST(
float
$value, 
$mean, 
$stdDev)

LOGNORMDIST Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.

Tags:

access:

public

Parameters:

float	$value
	$mean
	$stdDev

[ Top ]

static mixed LOOKUP(
lookup_value
$lookup_value, lookup_vector
$lookup_vector, [result_vector
$result_vector = null])

LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.

Tags:

return:	The value of the found cell
access:	public

Parameters:

lookup_value	$lookup_value	The value that you want to match in lookup_array
lookup_vector	$lookup_vector	The range of cells being searched
result_vector	$result_vector	The column from which the matching value must be returned

[ Top ]

static integer MATCH(
lookup_value
$lookup_value, lookup_array
$lookup_array, [match_type
$match_type = 1])

MATCH

MATCH The MATCH function searches for a specified item in a range of cells

Tags:

return:	the relative position of the found item
access:	public

Parameters:

lookup_value	$lookup_value	The value that you want to match in lookup_array
lookup_array	$lookup_array	The range of cells being searched
match_type	$match_type	The number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered.

[ Top ]

static float MAX(
array
0)

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.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float MAXA(
array
0)

MAXA

MAXA Returns the greatest value in a list of arguments, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float MEDIAN(
array
0)

MEDIAN Returns the median of the given numbers.

MEDIAN Returns the median of the given numbers. The median is the number in the middle of a set of numbers.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static string MID(
[string
$value = ''], [int
$start = 1], [int
$chars = null])

MID

Tags:

access:

public

Parameters:

string	$value	Value
int	$start	Start character
int	$chars	Number of characters

[ Top ]

static float MIN(
array
0)

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.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float MINA(
array
0)

MINA

MINA Returns the smallest value in a list of arguments, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int MINUTEOFHOUR(
[long
$timeValue = 0])

MINUTEOFHOUR

Tags:

return:	Minute
access:	public

Parameters:

long

$timeValue

Excel time serial value or a standard time string

[ Top ]

static boolean MMULT(

$matrixData1, 
$matrixData2, mixed
$value)

MMULT

Tags:

access:

public

Parameters:

mixed	$value	Value to check
	$matrixData1
	$matrixData2

[ Top ]

static int MOD(
[int
$a = 1], [int
$b = 1])

MOD

Tags:

return:	Remainder
access:	public

Parameters:

int	$a	Dividend
int	$b	Divisor

[ Top ]

static float MODE(
array
0)

MODE

MODE Returns the most frequently occurring, or repetitive, value in an array or range of data

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static void modeCalc(

$data)

Tags:

access:

private

Parameters:

$data

[ Top ]

static int MONTHOFYEAR(
[long
$dateValue = 1])

MONTHOFYEAR

Tags:

return:	Month
access:	public

Parameters:

long

$dateValue

Excel date serial value or a standard date string

[ Top ]

static float MROUND(
float
$number, int
$multiple)

MROUND

MROUND Rounds a number to the nearest multiple of a specified value

Tags:

return:	Rounded Number
access:	public

Parameters:

float	$number	Number to round
int	$multiple	Multiple to which you want to round $number

[ Top ]

static float MULTINOMIAL(
array
0)

MULTINOMIAL Returns the ratio of the factorial of a sum of values to the product of factorials.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static string NA(
)

NA

Tags:

return:	#N/A!
access:	public

[ Top ]

static float NEGBINOMDIST(
float
$failures, float
$successes, float
$probability)

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.

NEGBINOMDIST Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.

Tags:

access:

public

Parameters:

float	$failures	Number of Failures
float	$successes	Threshold number of Successes
float	$probability	Probability of success on each trial

[ Top ]

static long NETWORKDAYS(
mixed
$startDate, mixed
$endDate, array
2)

NETWORKDAYS

Tags:

return:	Interval between the dates
access:	public

Parameters:

array	2	of mixed Optional Date Series
mixed	$startDate	Start date
mixed	$endDate	End date

[ Top ]

static float NOMINAL(
[float
$effect_rate = 0], [int
$npery = 0])

NOMINAL Returns the nominal interest rate given the effective rate and the number of compounding payments per year.

Tags:

access:

public

Parameters:

float	$effect_rate	Effective interest rate
int	$npery	Number of compounding payments per year

[ Top ]

static float NORMDIST(
float
$value, float
$mean, float
$stdDev, boolean
$cumulative)

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.

NORMDIST Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.

Tags:

access:

public

Parameters:

float	$value
float	$mean	Mean Value
float	$stdDev	Standard Deviation
boolean	$cumulative

[ Top ]

static float NORMINV(

$probability, float
$mean, float
$stdDev, float
$value)

NORMINV Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Tags:

access:

public

Parameters:

float	$value
float	$mean	Mean Value
float	$stdDev	Standard Deviation
	$probability

[ Top ]

static float NORMSDIST(
float
$value)

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.

NORMSDIST Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.

Tags:

access:

public

Parameters:

float

$value

[ Top ]

static float NORMSINV(
float
$value)

NORMSINV

NORMSINV Returns the inverse of the standard normal cumulative distribution

Tags:

access:

public

Parameters:

float

$value

[ Top ]

static float NPER(
[float
$rate = 0], [int
$pmt = 0], [float
$pv = 0], [float
$fv = 0], [int
$type = 0])

NPER Returns the number of periods for a cash flow with constant periodic payments (annuities), and interest rate.

Tags:

access:

public

Parameters:

float	$rate	Interest rate per period
int	$pmt	Periodic payment (annuity)
float	$pv	Present Value
float	$fv	Future Value
int	$type	Payment type: 0 = at the end of each period, 1 = at the beginning of each period

[ Top ]

static float NPV(
float
0, array
1)

NPV Returns the Net Present Value of a cash flow series given a discount rate.

Tags:

access:

public

Parameters:

float	0	Discount interest rate
array	1	Cash flow series

[ Top ]

static string OCTTOBIN(
string
$x)

OCTTOBIN Return an octal value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string OCTTODEC(
string
$x)

OCTTODEC Return an octal value as binary.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static string OCTTOHEX(
string
$x)

OCTTOHEX Return an octal value as hex.

Tags:

access:

public

Parameters:

string

$x

[ Top ]

static int ODD(
float
$number)

ODD Returns number rounded up to the nearest odd integer.

Tags:

return:	Rounded Number
access:	public

Parameters:

float

$number

Number to round

[ Top ]

static void OFFSET(
[
$cellAddress = Null], [
$rows = 0], [
$columns = 0], [
$height = null], [
$width = null])

Tags:

access:

public

Parameters:

	$cellAddress
	$rows
	$columns
	$height
	$width

[ Top ]

static float PERCENTILE(
array
0, float
$entry)

PERCENTILE Returns the nth percentile of values in a range.

PERCENTILE Returns the nth percentile of values in a range..

Tags:

access:

public

Parameters:

array	0	of mixed Data Series
float	$entry	Entry in the series to return

[ Top ]

static int PERMUT(
int
$numObjs, int
$numInSet)

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.

PERMUT Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.

Tags:

return:	Number of permutations
access:	public

Parameters:

int	$numObjs	Number of different objects
int	$numInSet	Number of objects in each permutation

[ Top ]

static float PMT(
[float
$rate = 0], [int
$nper = 0], [float
$pv = 0], [float
$fv = 0], [int
$type = 0])

PMT Returns the constant payment (annuity) for a cash flow with a constant interest rate.

Tags:

access:

public

Parameters:

float	$rate	Interest rate per period
int	$nper	Number of periods
float	$pv	Present Value
float	$fv	Future Value
int	$type	Payment type: 0 = at the end of each period, 1 = at the beginning of each period

[ Top ]

static float POISSON(
float
$value, float
$mean, boolean
$cumulative)

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.

POISSON Returns the Poisson distribution. A common application of 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.

Tags:

access:

public

Parameters:

float	$value
float	$mean	Mean Value
boolean	$cumulative

[ Top ]

static float POWER(
[float
$x = 0], [float
$y = 2])

POWER Computes x raised to the power y.

Tags:

access:

public

Parameters:

float	$x
float	$y

[ Top ]

static float PRODUCT(
array
0)

PRODUCT PRODUCT returns the product of all the values and cells referenced in the argument list.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float PV(
[float
$rate = 0], [int
$nper = 0], [float
$pmt = 0], [float
$fv = 0], [int
$type = 0])

PV Returns the Present Value of a cash flow with constant payments and interest rate (annuities).

Tags:

access:

public

Parameters:

float	$rate	Interest rate per period
int	$nper	Number of periods
float	$pmt	Periodic payment (annuity)
float	$fv	Future Value
int	$type	Payment type: 0 = at the end of each period, 1 = at the beginning of each period

[ Top ]

static float QUARTILE(
array
0, float
$entry)

QUARTILE Returns the quartile of a data set.

Tags:

access:

public

Parameters:

array	0	of mixed Data Series
float	$entry	Entry in the series to return

[ Top ]

static float QUOTIENT(
array
0)

QUOTIENT QUOTIENT function returns the integer portion of a division. and denominator is the divisor.

QUOTIENT QUOTIENT function returns the integer portion of a division.numerator is the divided number and denominator is the divisor.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static int RAND(
[int
$min = 0], [int
$max = 0])

RAND

Tags:

return:	Random number
access:	public

Parameters:

int	$min	Minimal value
int	$max	Maximal value

[ Top ]

static boolean RETURNSTRING(
[
$testValue = ''], mixed
$value)

RETURNSTRING

Tags:

access:

public

Parameters:

mixed	$value	Value to check
	$testValue

[ Top ]

static float REVERSE_ATAN2(
float
$x, float
$y)

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.

ATAN2 This function calculates the arc tangent of the two variables x and y. It is similar to calculating the arc tangent of y / x, except that the signs of both arguments are used to determine the quadrant of the result. Note that Excel reverses the arguments, so we need to reverse them here before calling the standard PHP atan() function

Tags:

return:	Square Root of Number * Pi
access:	public

Parameters:

float	$x	Number
float	$y	Number

[ Top ]

static string RIGHT(
[string
$value = ''], [int
$chars = null])

RIGHT

Tags:

access:

public

Parameters:

string	$value	Value
int	$chars	Number of characters

[ Top ]

static float ROUNDDOWN(
float
$number, int
$digits)

ROUNDDOWN

ROUNDDOWN Rounds a number down to a specified number of decimal places

Tags:

return:	Rounded Number
access:	public

Parameters:

float	$number	Number to round
int	$digits	Number of digits to which you want to round $number

[ Top ]

static float ROUNDUP(
float
$number, int
$digits)

ROUNDUP

ROUNDUP Rounds a number up to a specified number of decimal places

Tags:

return:	Rounded Number
access:	public

Parameters:

float	$number	Number to round
int	$digits	Number of digits to which you want to round $number

[ Top ]

static void ROW(
[
$cellAddress = Null])

Tags:

access:

public

Parameters:

$cellAddress

[ Top ]

static string SEARCHINSENSITIVE(
string
$needle, string
$haystack, [int
$offset = 1])

SEARCHINSENSITIVE

Tags:

access:

public

Parameters:

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

[ Top ]

static string SEARCHSENSITIVE(
string
$needle, string
$haystack, [int
$offset = 1])

SEARCHSENSITIVE

Tags:

access:

public

Parameters:

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

[ Top ]

static int SECONDOFMINUTE(
[long
$timeValue = 0])

SECONDOFMINUTE

Tags:

return:	Second
access:	public

Parameters:

long

$timeValue

Excel time serial value or a standard time string

[ Top ]

static float SERIESSUM(
float
$x, float
$n, float
$m, array
3)

SERIESSUM

SERIESSUM Returns the sum of a power series

Tags:

access:

public

Parameters:

float	$x	Input value to the power series
float	$n	Initial power to which you want to raise $x
float	$m	Step by which to increase $n for each term in the series
array	3	of mixed Data Series

[ Top ]

static boolean setCompatibilityMode(
string
$compatibilityMode)

Set the Compatibility Mode

Tags:

return:	(Success or Failure)
access:	public

Parameters:

string

$compatibilityMode

Compatibility Mode

[ Top ]

static boolean setReturnDateType(
integer
$returnDateType)

Set the Return Date Format (Excel, PHP Serialized or PHP Object)

Tags:

return:	Success or failure
access:	public

Parameters:

integer

$returnDateType

Return Date Format

[ Top ]

static int SIGN(
float
$number)

SIGN Determines the sign of a number. if the number is 0, and -1 if the number is negative.

SIGN Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative.

Tags:

return:	sign value
access:	public

Parameters:

float

$number

Number to round

[ Top ]

static float SKEW(
array
0)

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.

SKEW Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean. Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.

Tags:

access:

public

Parameters:

array

0

Data Series

[ Top ]

static float SLN(
cost
$cost, salvage
$salvage, life
$life)

SLN

SLN Returns the straight-line depreciation of an asset for one period

Tags:

access:

public

Parameters:

cost	$cost	Initial cost of the asset
salvage	$salvage	Value at the end of the depreciation
life	$life	Number of periods over which the asset is depreciated

[ Top ]

static float SMALL(
array
0, float
1)

SMALL Returns the nth smallest value in a data set. select a value based on its relative standing.

SMALL Returns the nth smallest value in a data set. You can use this function to select a value based on its relative standing.

Tags:

access:

public

Parameters:

array	0	of mixed Data Series
float	1	Entry in the series to return

[ Top ]

static float SQRTPI(
float
$number)

SQRTPI Returns the square root of (number * pi).

Tags:

return:	Square Root of Number * Pi
access:	public

Parameters:

float

$number

Number

[ Top ]

static float STANDARDIZE(
float
$value, float
$mean, float
$stdDev)

STANDARDIZE Returns a normalized value from a distribution characterized by mean and standard_dev.

Tags:

return:	Standardized value
access:	public

Parameters:

float	$value	Value to normalize
float	$mean	Mean Value
float	$stdDev	Standard Deviation

[ Top ]

static mixed STATEMENT_IF(
[mixed
$value = true], [mixed
$truepart = ''], [mixed
$falsepart = ''])

STATEMENT_IF

Tags:

access:

public

Parameters:

mixed	$value	Value to check
mixed	$truepart	Value when true
mixed	$falsepart	Value when false

[ Top ]

static mixed STATEMENT_IFERROR(
[mixed
$value = ''], [mixed
$errorpart = ''])

STATEMENT_IFERROR

Tags:

access:

public

Parameters:

mixed	$value	Value to check , is also value when no error
mixed	$errorpart	Value when error

[ Top ]

static float STDEV(
array
0)

STDEV Estimates standard deviation based on a sample. widely values are dispersed from the average value (the mean).

STDEV Estimates standard deviation based on a sample. The standard deviation is a measure of how widely values are dispersed from the average value (the mean).

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float STDEVA(
array
0)

STDEVA

STDEVA Estimates standard deviation based on a sample, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float STDEVP(
array
0)

STDEVP

STDEVP Calculates standard deviation based on the entire population

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float STDEVPA(
array
0)

STDEVPA

STDEVPA Calculates standard deviation based on the entire population, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float SUBTOTAL(
int
0, array
1)

SUBTOTAL Returns a subtotal in a list or database.

Tags:

access:

public

Parameters:

int	0	the number 1 to 11 that specifies which function to use in calculating subtotals within a list.
array	1	of mixed Data Series

[ Top ]

static float SUM(
array
0)

SUM SUM computes the sum of all the values and cells referenced in the argument list.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float SUMSQ(
array
0)

SUMSQ

SUMSQ Returns the sum of the squares of the arguments

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float SYD(
cost
$cost, salvage
$salvage, life
$life, period
$period)

SYD Returns the sum-of-years' digits depreciation of an asset for a specified period.

Tags:

access:

public

Parameters:

cost	$cost	Initial cost of the asset
salvage	$salvage	Value at the end of the depreciation
life	$life	Number of periods over which the asset is depreciated
period	$period	Period

[ Top ]

static float TDIST(
float
$value, float
$degrees, float
$tails)

TDIST Returns the probability of Student's T distribution.

Tags:

access:

public

Parameters:

float	$value	Value for the function
float	$degrees	degrees of freedom
float	$tails	number of tails (1 or 2)

[ Top ]

static mixed TIME(
[long
$hour = 0], [long
$minute = 0], [long
$second = 0])

TIME

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

Parameters:

long	$hour
long	$minute
long	$second

[ Top ]

static mixed TIMEVALUE(
string
$timeValue)

TIMEVALUE

Tags:

return:	Excel date/time serial value, PHP date/time serial value or PHP date/time object, depending on the value of the ReturnDateType flag
access:	public

Parameters:

string

$timeValue

[ Top ]

static float TINV(
float
$probability, float
$degrees)

TINV Returns the one-tailed probability of the chi-squared distribution.

Tags:

access:

public

Parameters:

float	$probability	Probability for the function
float	$degrees	degrees of freedom

[ Top ]

static boolean TRANSPOSE(

$matrixData, mixed
$value)

TRANSPOSE

Tags:

return:	Unlike the Excel TRANSPOSE function, which will only work on a single row or column, this function will transpose a full matrix.
access:	public

Parameters:

mixed	$value	Value to check
	$matrixData

[ Top ]

static float TRIMMEAN(
array
0, float
1)

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.

TRIMMEAN Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.

Tags:

access:

public

Parameters:

array	0	of mixed Data Series
float	1	Percentage to discard

[ Top ]

static string TRIMNONPRINTABLE(
[
$stringValue = ''], mixed
$value)

TRIMNONPRINTABLE

Tags:

access:

public

Parameters:

mixed	$value	Value to check
	$stringValue

[ Top ]

static string TRIMSPACES(
[
$stringValue = ''], mixed
$value)

TRIMSPACES

Tags:

access:

public

Parameters:

mixed	$value	Value to check
	$stringValue

[ Top ]

static float TRUNC(
[float
$value = 0], [int
$number_digits = 0])

TRUNC Truncates value to the number of fractional digits by number_digits.

Tags:

return:	Truncated value
access:	public

Parameters:

float	$value
int	$number_digits

[ Top ]

static float VARA(
array
0)

VARA

VARA Estimates variance based on a sample, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float VARFunc(
array
0)

VARFunc Estimates variance based on a sample.

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float VARP(
array
0)

VARP

VARP Calculates variance based on the entire population

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static float VARPA(
array
0)

VARPA

VARPA Calculates variance based on the entire population, including numbers, text, and logical values

Tags:

access:

public

Parameters:

array

0

of mixed Data Series

[ Top ]

static string VERSION(
)

VERSION

Tags:

return:	Version information
access:	public

[ Top ]

static mixed VLOOKUP(
lookup_value
$lookup_value, lookup_array
$lookup_array, index_number
$index_number, [not_exact_match
$not_exact_match = true])

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.

Tags:

return:	The value of the found cell
access:	public

Parameters:

lookup_value	$lookup_value	The value that you want to match in lookup_array
lookup_array	$lookup_array	The range of cells being searched
index_number	$index_number	The column number in table_array from which the matching value must be returned. The first column is 1.
not_exact_match	$not_exact_match	Determines if you are looking for an exact match based on lookup_value.

[ Top ]

static int WEEKOFYEAR(
[long
$dateValue = 1], [boolean
$method = 1])

WEEKOFYEAR

Tags:

return:	Week Number
access:	public

Parameters:

long	$dateValue	Excel date serial value or a standard date string
boolean	$method	Week begins on Sunday or Monday

[ Top ]

static float WEIBULL(
float
$value, float
$alpha, float
$beta, boolean
$cumulative)

WEIBULL Returns the Weibull distribution. analysis, such as calculating a device's mean time to failure.

WEIBULL Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.

Tags:

access:

public

Parameters:

float	$value
float	$alpha	Alpha Parameter
float	$beta	Beta Parameter
boolean	$cumulative

[ Top ]

static long WORKDAY(
mixed
$startDate, mixed
$endDays, array
2)

WORKDAY

Tags:

return:	Interval between the dates
access:	public

Parameters:

array	2	of mixed Optional Date Series
mixed	$startDate	Start date
mixed	$endDays	number of days for adjustment

[ Top ]

static int YEAR(
[long
$dateValue = 1])

YEAR

Tags:

return:	Year
access:	public

Parameters:

long

$dateValue

Excel date serial value or a standard date string

[ Top ]

static long YEARFRAC(
[long
$startDate = 0], [long
$endDate = 0], [integer
$method = 0])

YEARFRAC

Tags:

return:	PHP date/time serial
access:	public

Parameters:

long	$startDate	Excel date serial value or a standard date string
long	$endDate	Excel date serial value or a standard date string
integer	$method	Method used for the calculation

[ Top ]

static mixed _getDateValue(
string
$dateValue)

_getDateValue

Tags:

return:	Excel date/time serial value, or string if error
access:	private

Parameters:

string

$dateValue

[ Top ]

static mixed _getTimeValue(
string
$timeValue)

_getTimeValue

Tags:

return:	Excel date/time serial value, or string if error
access:	private

Parameters:

string

$timeValue

[ Top ]

void parseComplex(

$complexNumber)

Tags:

access:

public

Parameters:

$complexNumber

[ Top ]

Class: PHPExcel_Calculation_Functions

Class Overview

Author(s):

Copyright:

Variables

Constants

Methods

Class Details

Tags:

Class Variables

static $compatibilityMode = self::COMPATIBILITY_EXCEL

Tags:

static $logBetaCache_p = 0.0

Tags:

static $logBetaCache_q = 0.0

Tags:

static $logBetaCache_result = 0.0

Tags:

static $logGammaCache_result = 0.0

Tags:

static $logGammaCache_x = 0.0

Tags:

static $one_sqrtpi = 0.564189583547756287

Tags:

static $rel_error = 1E-15

Tags:

static $ReturnDateType = self::RETURNDATE_PHP_NUMERIC

Tags:

static $two_sqrtpi = 1.128379167095512574

Tags:

static $_errorCodes = array( 'null' => '#NULL!', 'divisionbyzero' => '#DIV/0!', 'value' => '#VALUE!', 'reference' => '#REF!', 'name' => '#NAME?', 'num' => '#NUM!', 'na' => '#N/A', 'gettingdata' => '#GETTING_DATA' )

Tags:

static $_invalidChars = Null

Tags:

Class Methods

static method adjustDateByMonths [line 4888]

Tags:

Parameters:

static method ASCIICODE [line 3683]

Tags:

Parameters:

static method AVEDEV [line 999]

Tags:

Parameters:

static method AVERAGE [line 777]

Tags:

Parameters:

static method AVERAGEA [line 815]

Tags:

Parameters:

static method BESSELI [line 5921]

Tags:

Parameters:

static method BESSELJ [line 5962]

Tags:

Parameters:

static method BESSELK [line 6038]

Tags:

Parameters:

static method Besselk0 [line 5997]

Tags:

Parameters:

static method Besselk1 [line 6013]

Tags:

Parameters:

static method BESSELY [line 6113]

Tags:

Parameters:

static method Bessely0 [line 6066]

Tags:

Parameters:

static method Bessely1 [line 6083]

Tags:

Parameters:

static method beta [line 2683]

Tags:

Parameters:

static method BETADIST [line 2731]

Tags:

Parameters:

static $_errorCodes = array( 'null' => '#NULL!',
'divisionbyzero' => '#DIV/0!',
'value' => '#VALUE!',
'reference' => '#REF!',
'name' => '#NAME?',
'num' => '#NUM!',
'na' => '#N/A',
'gettingdata' => '#GETTING_DATA'
)