View source for Excel to Analytica Mappings/Engineering Functions

[[Category: Excel to Analytica mappings]]

<div style="column-count:3;-moz-column-count:3;-webkit-column-count:3">
__TOC__
</div>

== BESSELI(x, n) ==

''Analytica equivalent:''
:[[BesselI]](x, [[Floor]](n))

== BESSELJ ==

''Analytica equivalent:''
:[[BesselJ]](x, [[Floor]](n))

== BESSELK ==

''Analytica equivalent:''
:[[BesselK]](x, [[Floor]](n))

== BESSELY ==

''Analytica equivalent:''
:[[BesselY]](x, [[Floor]](n))

== 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 [[Standard_libraries#Complex_Numbers|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 [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMAGINARY(c) ==

''Analytica equivalent:''
:[[Im]](c)

To use,  add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMARGUMENT(c) ==

''Analytica equivalent:''
:[[CTheta]](c)

To use,  add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMCONJUGATE(c) ==

''Analytica equivalent:''
:[[Complex]]([[Re]](c),  -[[Im]](c))

To use,  add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMCOS(c) ==

''Analytica equivalent:''
:CCos(c)

To use,  add [[Standard_libraries#Complex_Numbers|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 [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMEXP(c) ==

''Analytica equivalent:''
:[[CExp]](c)

== IMLN(c) ==

''Analytica equivalent:''
:[[CLn(c)]]

To use,  add [[Standard_libraries#Complex_Numbers|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 [[Standard_libraries#Complex_Numbers|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 [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMREAL(c) ==

''Analytica equivalent:''
:[[Re]](c)

This function requires that you add the [[Standard_libraries#Complex_Numbers|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 [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.

== IMSQRT(c) ==

''Analytica equivalent:''
:[[CSqrt]](c)

To use,  add [[Standard_libraries#Complex_Numbers|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'')

==See Also==
* [[Excel to Analytica Mappings]]
* [[Standard libraries]]