Class: PHPExcel_Calculation_Engineering
Source Location: /PHPExcel/Calculation/Engineering.php
PHPExcel_Calculation_Engineering
Author(s):
Copyright:
- Copyright (c) 2006 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
|
|
Class Details
Class Methods
static method BESSELI [line 794]
static float BESSELI(
float
$x, integer
$ord)
|
|
BESSELI Returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments Excel Function: BESSELI(x,ord)
Tags:
Parameters:
static method BESSELJ [line 848]
static float BESSELJ(
float
$x, integer
$ord)
|
|
BESSELJ Returns the Bessel function Excel Function: BESSELJ(x,ord)
Tags:
Parameters:
static method BESSELK [line 939]
static float BESSELK(
float
$x, integer
$ord)
|
|
BESSELK Returns the modified Bessel function, which is equivalent to the Bessel functions evaluated for purely imaginary arguments. Excel Function: BESSELK(x,ord)
Tags:
Parameters:
static method BESSELY [line 1028]
static float BESSELY(
float
$x, integer
$ord)
|
|
BESSELY Returns the Bessel function, which is also called the Weber function or the Neumann function. Excel Function: BESSELY(x,ord)
Tags:
Parameters:
static method BINTODEC [line 1075]
static string BINTODEC(
string
$x)
|
|
BINTODEC Return a binary value as decimal. Excel Function: BIN2DEC(x)
Tags:
Parameters:
static method BINTOHEX [line 1127]
static string BINTOHEX(
string
$x, [integer
$places = NULL])
|
|
BINTOHEX Return a binary value as hex. Excel Function: BIN2HEX(x[,places])
Tags:
Parameters:
static method BINTOOCT [line 1181]
static string BINTOOCT(
string
$x, [integer
$places = NULL])
|
|
BINTOOCT Return a binary value as octal. Excel Function: BIN2OCT(x[,places])
Tags:
Parameters:
static method COMPLEX [line 1651]
static string COMPLEX(
[float
$realNumber = 0.0], [float
$imaginary = 0.0], [string
$suffix = 'i'])
|
|
COMPLEX Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj. Excel Function: COMPLEX(realNumber,imaginary[,places])
Tags:
Parameters:
static method CONVERTUOM [line 2425]
static float CONVERTUOM(
float
$value, string
$fromUOM, string
$toUOM)
|
|
CONVERTUOM Converts a number from one measurement system to another. For example, CONVERT can translate a table of distances in miles to a table of distances in kilometers. Excel Function: CONVERT(value,fromUOM,toUOM)
Tags:
Parameters:
static method DECTOBIN [line 1239]
static string DECTOBIN(
string
$x, [integer
$places = NULL])
|
|
DECTOBIN Return a decimal value as binary. Excel Function: DEC2BIN(x[,places])
Tags:
Parameters:
static method DECTOHEX [line 1295]
static string DECTOHEX(
string
$x, [integer
$places = null])
|
|
DECTOHEX Return a decimal value as hex. Excel Function: DEC2HEX(x[,places])
Tags:
Parameters:
static method DECTOOCT [line 1349]
static string DECTOOCT(
string
$x, [integer
$places = null])
|
|
DECTOOCT Return an decimal value as octal. Excel Function: DEC2OCT(x[,places])
Tags:
Parameters:
static method DELTA [line 2203]
static int DELTA(
float
$a, [float
$b = 0])
|
|
DELTA Tests whether two values are equal. Returns 1 if number1 = number2; returns 0 otherwise. Use this function to filter a set of values. For example, by summing several DELTA functions you calculate the count of equal pairs. This function is also known as the Kronecker Delta function. Excel Function: DELTA(a[,b])
Tags:
Parameters:
static method ERF [line 2274]
static int ERF(
float
$lower, [float
$upper = null])
|
|
ERF Returns the error function integrated between lower_limit and upper_limit Excel Function: ERF(lower[,upper])
Tags:
Parameters:
static method ERFC [line 2339]
static int ERFC(
float
$x)
|
|
ERFC Returns the complementary ERF function integrated between x and infinity Excel Function: ERF(x)
Tags:
Parameters:
static method GESTEP [line 2226]
static int GESTEP(
float
$number, [float
$step = 0])
|
|
GESTEP Excel Function: GESTEP(number[,step]) Returns 1 if number >= step; returns 0 (zero) otherwise Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold.
Tags:
Parameters:
static method getConversionGroups [line 2357]
static array getConversionGroups(
)
|
|
getConversionGroups
Tags:
static method getConversionGroupUnitDetails [line 2387]
static array getConversionGroupUnitDetails(
[
$group = NULL])
|
|
getConversionGroupUnitDetails
Tags:
Parameters:
static method getConversionGroupUnits [line 2371]
static array getConversionGroupUnits(
[
$group = NULL])
|
|
getConversionGroupUnits
Tags:
Parameters:
static method getConversionMultipliers [line 2405]
static array getConversionMultipliers(
)
|
|
getConversionGroups
Tags:
static method HEXTOBIN [line 1406]
static string HEXTOBIN(
string
$x, [integer
$places = null])
|
|
HEXTOBIN Return a hex value as binary. Excel Function: HEX2BIN(x[,places])
Tags:
Parameters:
static method HEXTODEC [line 1442]
static string HEXTODEC(
string
$x)
|
|
HEXTODEC Return a hex value as decimal. Excel Function: HEX2DEC(x)
Tags:
Parameters:
static method HEXTOOCT [line 1488]
static string HEXTOOCT(
string
$x, [integer
$places = null])
|
|
HEXTOOCT Return a hex value as octal. Excel Function: HEX2OCT(x[,places])
Tags:
Parameters:
static method IMABS [line 1740]
static float IMABS(
string
$complexNumber)
|
|
IMABS Returns the absolute value (modulus) of a complex number in x + yi or x + yj text format. Excel Function: IMABS(complexNumber)
Tags:
Parameters:
static method IMAGINARY [line 1700]
static float IMAGINARY(
string
$complexNumber)
|
|
IMAGINARY Returns the imaginary coefficient of a complex number in x + yi or x + yj text format. Excel Function: IMAGINARY(complexNumber)
Tags:
Parameters:
static method IMARGUMENT [line 1761]
static float IMARGUMENT(
string
$complexNumber)
|
|
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. Excel Function: IMARGUMENT(complexNumber)
Tags:
Parameters:
static method IMCONJUGATE [line 1795]
static string IMCONJUGATE(
string
$complexNumber)
|
|
IMCONJUGATE Returns the complex conjugate of a complex number in x + yi or x + yj text format. Excel Function: IMCONJUGATE(complexNumber)
Tags:
Parameters:
static method IMCOS [line 1823]
static string|float IMCOS(
string
$complexNumber)
|
|
IMCOS Returns the cosine of a complex number in x + yi or x + yj text format. Excel Function: IMCOS(complexNumber)
Tags:
Parameters:
static method IMDIV [line 2051]
static string IMDIV(
string
$complexDividend, string
$complexDivisor)
|
|
IMDIV Returns the quotient of two complex numbers in x + yi or x + yj text format. Excel Function: IMDIV(complexDividend,complexDivisor)
Tags:
Parameters:
static method IMEXP [line 1983]
static string IMEXP(
string
$complexNumber)
|
|
IMEXP Returns the exponential of a complex number in x + yi or x + yj text format. Excel Function: IMEXP(complexNumber)
Tags:
Parameters:
static method IMLN [line 1900]
static string IMLN(
string
$complexNumber)
|
|
IMLN Returns the natural logarithm of a complex number in x + yi or x + yj text format. Excel Function: IMLN(complexNumber)
Tags:
Parameters:
static method IMLOG2 [line 1957]
static string IMLOG2(
string
$complexNumber)
|
|
IMLOG2 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. Excel Function: IMLOG2(complexNumber)
Tags:
Parameters:
static method IMLOG10 [line 1931]
static string IMLOG10(
string
$complexNumber)
|
|
IMLOG10 Returns the common logarithm (base 10) of a complex number in x + yi or x + yj text format. Excel Function: IMLOG10(complexNumber)
Tags:
Parameters:
static method IMPOWER [line 2016]
static string IMPOWER(
string
$complexNumber, float
$realNumber)
|
|
IMPOWER Returns a complex number in x + yi or x + yj text format raised to a power. Excel Function: IMPOWER(complexNumber,realNumber)
Tags:
Parameters:
static method IMPRODUCT [line 2163]
static string IMPRODUCT(
string
$complexNumber,...)
|
|
IMPRODUCT Returns the product of two or more complex numbers in x + yi or x + yj text format. Excel Function: IMPRODUCT(complexNumber[,complexNumber[,...]])
Tags:
Parameters:
static method IMREAL [line 1721]
static float IMREAL(
string
$complexNumber)
|
|
IMREAL Returns the real coefficient of a complex number in x + yi or x + yj text format. Excel Function: IMREAL(complexNumber)
Tags:
Parameters:
static method IMSIN [line 1847]
static string|float IMSIN(
string
$complexNumber)
|
|
IMSIN Returns the sine of a complex number in x + yi or x + yj text format. Excel Function: IMSIN(complexNumber)
Tags:
Parameters:
static method IMSQRT [line 1871]
static string IMSQRT(
string
$complexNumber)
|
|
IMSQRT Returns the square root of a complex number in x + yi or x + yj text format. Excel Function: IMSQRT(complexNumber)
Tags:
Parameters:
static method IMSUB [line 2095]
static string IMSUB(
string
$complexNumber1, string
$complexNumber2)
|
|
IMSUB Returns the difference of two complex numbers in x + yi or x + yj text format. Excel Function: IMSUB(complexNumber1,complexNumber2)
Tags:
Parameters:
static method IMSUM [line 2127]
static string IMSUM(
string
$complexNumber,...)
|
|
IMSUM Returns the sum of two or more complex numbers in x + yi or x + yj text format. Excel Function: IMSUM(complexNumber[,complexNumber[,...]])
Tags:
Parameters:
static method OCTTOBIN [line 1539]
static string OCTTOBIN(
string
$x, [integer
$places = null])
|
|
OCTTOBIN Return an octal value as binary. Excel Function: OCT2BIN(x[,places])
Tags:
Parameters:
static method OCTTODEC [line 1575]
static string OCTTODEC(
string
$x)
|
|
OCTTODEC Return an octal value as decimal. Excel Function: OCT2DEC(x)
Tags:
Parameters:
static method OCTTOHEX [line 1618]
static string OCTTOHEX(
string
$x, [integer
$places = null])
|
|
OCTTOHEX Return an octal value as hex. Excel Function: OCT2HEX(x[,places])
Tags:
Parameters:
static method _erfVal [line 2239]
static method _parseComplex [line 696]
static string[] _parseComplex(
string
$complexNumber)
|
|
_parseComplex Parses a complex number into its real and imaginary parts, and an I or J suffix
Tags:
Parameters:
|
|