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 793]
static float BESSELI(
float
$x, integer
$ord)
|
|
BESSELI Returns the modified Bessel function In(x), which is equivalent to the Bessel function evaluated for purely imaginary arguments Excel Function: BESSELI(x,ord)
Tags:
Parameters:
static method BESSELJ [line 845]
static float BESSELJ(
float
$x, integer
$ord)
|
|
BESSELJ Returns the Bessel function Excel Function: BESSELJ(x,ord)
Tags:
Parameters:
static method BESSELK [line 934]
static float BESSELK(
float
$x, integer
$ord)
|
|
BESSELK Returns the modified Bessel function Kn(x), which is equivalent to the Bessel functions evaluated for purely imaginary arguments. Excel Function: BESSELK(x,ord)
Tags:
Parameters:
static method BESSELY [line 1014]
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 1061]
static string BINTODEC(
string
$x)
|
|
BINTODEC Return a binary value as decimal. Excel Function: BIN2DEC(x)
Tags:
Parameters:
static method BINTOHEX [line 1113]
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 1167]
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 1637]
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 2418]
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 1225]
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 1281]
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 1335]
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 2189]
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 2265]
static float ERF(
float
$lower, [float
$upper = NULL])
|
|
ERF Returns the error function integrated between the lower and upper bound arguments. Note: In Excel 2007 or earlier, if you input a negative value for the upper or lower bound arguments, the function would return a #NUM! error. However, in Excel 2010, the function algorithm was improved, so that it can now calculate the function for both positive and negative ranges. PHPExcel follows Excel 2010 behaviour, and accepts nagative arguments. Excel Function: ERF(lower[,upper])
Tags:
Parameters:
static method ERFC [line 2329]
static float ERFC(
float
$x)
|
|
ERFC Returns the complementary ERF function integrated between x and infinity Note: In Excel 2007 or earlier, if you input a negative value for the lower bound argument, the function would return a #NUM! error. However, in Excel 2010, the function algorithm was improved, so that it can now calculate the function for both positive and negative x values. PHPExcel follows Excel 2010 behaviour, and accepts nagative arguments. Excel Function: ERFC(x)
Tags:
Parameters:
static method GESTEP [line 2212]
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 2345]
static array getConversionGroups(
)
|
|
getConversionGroups Returns a list of the different conversion groups for UOM conversions
Tags:
static method getConversionGroupUnitDetails [line 2378]
static array getConversionGroupUnitDetails(
[
$group = NULL])
|
|
getConversionGroupUnitDetails
Tags:
Parameters:
static method getConversionGroupUnits [line 2362]
static array getConversionGroupUnits(
[string
$group = NULL])
|
|
getConversionGroupUnits Returns an array of units of measure, for a specified conversion group, or for all groups
Tags:
Parameters:
static method getConversionMultipliers [line 2397]
static array getConversionMultipliers(
)
|
|
getConversionMultipliers Returns an array of the Multiplier prefixes that can be used with Units of Measure in CONVERTUOM()
Tags:
static method HEXTOBIN [line 1392]
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 1428]
static string HEXTODEC(
string
$x)
|
|
HEXTODEC Return a hex value as decimal. Excel Function: HEX2DEC(x)
Tags:
Parameters:
static method HEXTOOCT [line 1474]
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 1726]
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 1686]
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 1747]
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 1781]
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 1809]
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 2037]
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 1969]
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 1886]
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 1943]
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 1917]
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 2002]
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 2149]
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 1707]
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 1833]
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 1857]
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 2081]
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 2113]
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 1525]
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 1561]
static string OCTTODEC(
string
$x)
|
|
OCTTODEC Return an octal value as decimal. Excel Function: OCT2DEC(x)
Tags:
Parameters:
static method OCTTOHEX [line 1604]
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 2225]
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:
|
|