| | Class: PHPExcel_Calculation_EngineeringSource 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: 
 | 
 |