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

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

IMSUB

IMSUM

OCT2BIN

OCT2DEC

OCT2HEX

Comments


You are not allowed to post comments.