Excel to Analytica Mappings/Engineering Functions

BESSELI

BESSELJ

BESSELK

BESSELY

BIN2DEC

BIN2HEX

BIN2OCT

COMPLEX(re,im)

Analytica equivalent:

Complex(re,im)

To use, add the Complex Library to your model.

CONVERT

DEC2BIN

DEC2HEX

DEC2OCT

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

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

IMCONJUGATE(c)

Analytica equivalent:

Complex( Re(c), -Im(c) )

To use, add the Complex Library to your model.

IMCOS(c)

Analytica equivalent:

CCos(c)

To use, add Complex Library to your model.

IMDIV

IMEXP

IMLN

IMLOG10

IMLOG2

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

OCT2DEC

OCT2HEX