Excel to Analytica Mappings/Engineering Functions

BESSELI(x,n)

Analytica 4.1 equivalent:

BesselI(x,Floor(n))

BESSELJ

Analytica 4.1 equivalent:

BesselJ(x,Floor(n))

BESSELK

Analytica 4.1 equivalent:

BesselK(x,Floor(n))

BESSELY

Analytica 4.1 equivalent:

BesselY(x,Floor(n))

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.