Excel to Analytica Mappings/Engineering Functions
BESSELI(x, n)
Analytica equivalent:
BESSELJ
Analytica equivalent:
BESSELK
Analytica equivalent:
BESSELY
Analytica equivalent:
BIN2DEC(x)
Analytica equivalent (requires the Base Conversion Function Library):
- Bin2Dec(x)
BIN2HEX(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Bin2Hex(x, places)
BIN2OCT(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Bin2Oct(x, places)
COMPLEX(re, im)
Analytica equivalent:
- Complex(re, im)
To use, add the Complex Library to your model.
CONVERT
Not available in Analytica.
DEC2BIN(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Dec2Bin(x, places)
DEC2HEX(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Dec2Hex(x, places)
DEC2OCT(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Dec2Oct(x, places)
DELTA(number1, number2)
Analytica equivalent:
- (number1 == number2)
ERF(lower_limit, upper_limit)
Analytica equivalent of Erf(lower_limit) is:
- Erf(lower_limit)
Analytica equivalent of Erf(lower_limit, upper_limit) is:
- Erf(upper_limit) - Erf(lower_limit)
ERFC(x)
Analytica equivalent:
- 1-Erf(x)
GESTEP(n, step)
Analytica equivalent of GESTEP(n):
- (n >== 0)
Analytica equivalent of GESTEP(n, s):
- (n >== s)
HEX2BIN(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Hex2Bin(x, places)
HEX2DEC(x)
Analytica equivalent (requires the Base Conversion Function Library):
- Hex2Dec(x)
HEX2OCT(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Hex2Oct(x, places)
IMABS(c)
Analytica equivalent:
- CAbs(c)
To use, add the Complex Library to your model.
IMAGINARY(c)
Analytica equivalent:
- Im(c)
To use, add the Complex Library to your model.
IMARGUMENT(c)
Analytica equivalent:
- CTheta(c)
To use, add Complex Library to your model.
IMCONJUGATE(c)
Analytica equivalent:
To use, add the Complex Library to your model.
IMCOS(c)
Analytica equivalent:
- CCos(c)
To use, add Complex Library to your model.
IMDIV(inumber1, inumber2)
Analytica equivalent:
- CDiv(inumber1, inumber2)
Both inumber1 and inumber2 must be complex numbers, as obtained from function Complex, and the result is complex. To use, add Complex Library to your model.
IMEXP(c)
Analytica equivalent:
- CExp(c)
IMLN(c)
Analytica equivalent:
To use, add Complex Library to your model.
IMLOG10(c)
Analytica equivalent:
IMLOG2
Analytica equivalent:
IMPOWER(inumber, number)
Analytica equivalent:
- CPower(inumber, number)
inumber must be a complex, defined using Complex. Do not pass a real.
To use, add the Complex Library to your model.
IMPRODUCT(inumber1, inumber2)
Analytica equivalent:
- CMult(inumber1, inumber2)
Both inumber1 and inumber2 must be complex numbers, as returned from Complex. This function requires that you add the Complex Library to your model.
IMREAL(c)
Analytica equivalent:
- Re(c)
This function requires that you add the Complex Library to your model. «c» is a complex number as returned from function Complex.
IMSIN(c)
Analytica equivalent:
- CSin(c)
«c» must be a complex number, such as returned from function Complex. This function requires that you add Complex Library to your model.
IMSQRT(c)
Analytica equivalent:
- CSqrt(c)
To use, add Complex Library to your model.
IMSUB(inumber1, inumber2)
Analytica equivalent:
- inumber1 - inumber2
IMSUM(inumber1, inumber12, ...)
Analytica equivalent:
- inumber1 + inumber2 + ....
Also, if A is an array of complex numbers, indexed by I, you may use:
- Sum(A, I)
OCT2BIN(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Oct2Bin(x, places)
OCT2DEC(x)
Analytica equivalent (requires the Base Conversion Function Library):
- Oct2Dec(x)
OCT2HEX(x, places)
Analytica equivalent (requires the Base Conversion Function Library):
- Oct2Hex(x, places)
Enable comment auto-refresher