Excel to Analytica Mappings/Engineering Functions

BESSELI

Not available in Analytica.

BESSELJ

Not available in Analytica.

BESSELK

Not available in Analytica.

BESSELY

Not available in Analytica.

BIN2DEC

Not available in Analytica, but relatively easy to implement as a user-defined function.

BIN2HEX

Not available in Analytica, but relatively easy to implement as a user-defined function.

BIN2OCT

Not available in Analytica, but relatively easy to implement as a user-defined function.

COMPLEX(re,im)

Analytica equivalent:

Complex(re,im)

To use, add the Complex Library to your model.

CONVERT

Not available in Analytica.

DEC2BIN

Not available in Analytica, but relatively easy to implement as a user-defined function.

DEC2HEX

Not available in Analytica, but relatively easy to implement as a user-defined function.

DEC2OCT

Not available in Analytica, but relatively easy to implement as a user-defined function.

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

Not available in Analytica, but relatively easy to implement as a user-defined function.

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:

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(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:

CLn(c)

To use, add Complex Library to your model.

IMLOG10(c)

Analytica equivalent:

CDiv(CLn(c),Complex(ln(10),0))

IMLOG2

Analytica equivalent:

CDiv(CLn(c),Complex(ln(2),0))

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

Not available in Analytica, but relatively easy to implement as a user-defined function.

OCT2DEC

Not available in Analytica, but relatively easy to implement as a user-defined function.

OCT2HEX

Not available in Analytica, but relatively easy to implement as a user-defined function.