Difference between revisions of "Excel to Analytica Mappings/Engineering Functions"
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
= BESSELI(x,n) =
+
[[Category: Excel to Analytica mappings]]
  
−
Analytica 4.1 equivalent:
+
<div style="column-count:3;-moz-column-count:3;-webkit-column-count:3">
−
[[BesselI]](x,[[Floor]](n))
+
__TOC__
 +
</div>
  
−
= BESSELJ =
+
== BESSELI(x, n) ==
  
−
Analytica 4.1 equivalent:
+
''Analytica equivalent:''
−
[[BesselJ]](x,[[Floor]](n))
+
:[[BesselI]](x, [[Floor]](n))
  
−
= BESSELK =
+
== BESSELJ ==
  
−
Analytica 4.1 equivalent:
+
''Analytica equivalent:''
−
[[BesselK]](x,[[Floor]](n))
+
:[[BesselJ]](x, [[Floor]](n))
  
−
= BESSELY =
+
== BESSELK ==
  
−
Analytica 4.1 equivalent:
+
''Analytica equivalent:''
−
[[BesselY]](x,[[Floor]](n))
+
:[[BesselK]](x, [[Floor]](n))
  
−
= BIN2DEC(x) =
+
== BESSELY ==
  
−
Analytica 4.1 equivalent (requires the [[Base Conversion Library]]:
+
''Analytica equivalent:''
 +
:[[BesselY]](x, [[Floor]](n))
  
−
[[Bin2Dec]](x)
+
== BIN2DEC(x) ==
  
−
= BIN2HEX =
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
+
:[[Bin2Dec]](x)
  
−
= BIN2OCT =
+
== BIN2HEX(x'', places'') ==
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
 
  
−
= COMPLEX(re,im) =
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
 +
:[[Bin2Hex]](x'', places'')
  
−
Analytica equivalent:
+
== BIN2OCT(x'', places'') ==
−
[[Complex]](re,im)
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
 +
:[[Bin2Oct]](x'', places'')
  
−
To use, add the Complex Library to your model.
+
== COMPLEX(re, im) ==
  
−
= CONVERT =
+
''Analytica equivalent:''
 +
:[[Complex]](re, im)
 +
 
 +
To use,  add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
 +
 
 +
== CONVERT ==
 
Not available in Analytica.
 
Not available in Analytica.
  
−
= DEC2BIN =
+
== DEC2BIN(x'', places'') ==
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
+
 
 +
''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'') ==
  
−
= DEC2HEX =
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
 
  
−
= DEC2OCT =
+
:[[Dec2Oct]](x'', places'')
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
 
  
−
= DELTA(number1,number2) =
+
== DELTA(number1, number2) ==
  
−
Analytica equivalent:
+
''Analytica equivalent:''
−
(number1 = number2)
+
:(number1 == number2)
  
−
= ERF(lower_limit'',upper_limit'') =
+
== ERF(lower_limit'', upper_limit'') ==
  
−
Analytica equivalent of Erf(lower_limit) is:
+
''Analytica equivalent of Erf(lower_limit) is:''
−
Erf(lower_limit)
+
:[[Erf]](lower_limit)
  
−
Analytica equivalent of Erf(lower_limit,upper_limit) is:
+
''Analytica equivalent of Erf(lower_limit, upper_limit) is:''
−
Erf(upper_limit) - Erf(lower_limit)
+
:[[Erf]](upper_limit) - Erf(lower_limit)
  
−
= ERFC(x) =
+
== ERFC(x) ==
  
−
Analytica equivalent:
+
''Analytica equivalent:''
−
1-Erf(x)
+
:1-[[Erf]](x)
  
−
= GESTEP(n'',step) =
+
== GESTEP(n'', step'') ==
 
   
 
   
−
Analytica equivalent of GESTEP(n):
+
''Analytica equivalent of GESTEP(n):''
−
(n >= 0)
+
:(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)
  
−
Analytica equivalent of GESTEP(n,s):
+
To use,  add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  (n >= s)
 
  
−
= HEX2BIN =
+
== IMAGINARY(c) ==
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
 
  
−
= IMABS(c) =
+
''Analytica equivalent:''
 +
:[[Im]](c)
  
−
Analytica equivalent:
+
To use, add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[CAbs]](c)
 
  
−
To use, add the Complex Library to your model.
+
== IMARGUMENT(c) ==
  
−
= IMAGINARY(c) =
+
''Analytica equivalent:''
 +
:[[CTheta]](c)
  
−
Analytica equivalent:
+
To use, add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[Im]](c)
 
  
−
To use, add the Complex Library to your model.
+
== IMCONJUGATE(c) ==
  
−
= IMARGUMENT(c) =
+
''Analytica equivalent:''
 +
:[[Complex]]([[Re]](c),  -[[Im]](c))
  
−
Analytica equivalent:
+
To use, add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[CTheta]](c)
 
  
−
To use, add Complex Library to your model.
+
== IMCOS(c) ==
  
−
= IMCONJUGATE(c) =
+
''Analytica equivalent:''
 +
:CCos(c)
  
−
Analytica equivalent:
+
To use, add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[Complex]]( [[Re]](c), -[[Im]](c) )
 
  
−
To use, add the Complex Library to your model.
+
== IMDIV(inumber1, inumber2) ==
  
−
= IMCOS(c) =
+
''Analytica equivalent:''
 +
:[[CDiv]](inumber1, inumber2)
  
−
Analytica equivalent:
+
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.
−
  CCos(c)
 
  
−
To use, add Complex Library to your model.
+
== IMEXP(c) ==
  
−
= IMDIV(inumber1,inumber2) =
+
''Analytica equivalent:''
 +
:[[CExp]](c)
  
−
Analytica equivalent:
+
== IMLN(c) ==
−
[[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.
+
''Analytica equivalent:''
 +
:[[CLn(c)]]
  
−
= IMEXP(c) =
+
To use,  add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
  
−
Analytica equivalent:
+
== IMLOG10(c) ==
−
[[CExp]](c)
 
  
−
= IMLN(c) =
+
''Analytica equivalent:''
 +
:[[CDiv]]([[CLn]](c), [[Complex]](ln(10), 0))
  
−
Analytica equivalent:
+
== IMLOG2 ==
−
[[CLn(c)]]
 
  
−
To use, add Complex Library to your model.
+
''Analytica equivalent:''
 +
:[[CDiv]]([[CLn]](c), [[Complex]](ln(2), 0))
  
−
= IMLOG10(c) =
+
== IMPOWER(inumber, number) ==
  
−
Analytica equivalent:
+
''Analytica equivalent:''
−
[[CDiv]]([[CLn]](c),[[Complex]](ln(10),0))
+
:[[CPower]](inumber, number)
  
−
= IMLOG2 =
+
''inumber'' must be a complex,  defined using [[Complex]].  Do not pass a real. 
  
−
Analytica equivalent:
+
To use, add the [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[CDiv]]([[CLn]](c),[[Complex]](ln(2),0))
 
  
−
= IMPOWER(inumber,number) =
+
== IMPRODUCT(inumber1, inumber2) ==
  
−
Analytica equivalent:
+
''Analytica equivalent:''
−
[[CPower]](inumber,number)
+
:[[CMult]](inumber1, inumber2)
  
−
''inumber'' must be a complex, defined using [[Complex]].  Do not pass a real.
+
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.
  
−
To use, add the Complex Library to your model.
+
== IMREAL(c) ==
  
−
= IMPRODUCT(inumber1,inumber2) =
+
''Analytica equivalent:''
 +
:[[Re]](c)
  
−
Analytica equivalent:
+
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]].
−
  [[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.
+
== IMSIN(c) ==
  
−
= IMREAL(c) =
+
''Analytica equivalent:''
 +
:[[CSin]](c)
  
−
Analytica equivalent:
+
«c» must be a complex number,  such as returned from function [[Complex]].
−
[[Re]](c)
+
This function requires that you add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
  
−
This function requires that you add the Complex Library to your model.  ''c'' is a complex number as returned from function [[Complex]].
+
== IMSQRT(c) ==
  
−
= IMSIN(c) =
+
''Analytica equivalent:''
 +
:[[CSqrt]](c)
  
−
Analytica equivalent:
+
To use, add [[Standard_libraries#Complex_Numbers|Complex Library]] to your model.
−
  [[CSin]](c)
 
  
−
''c'' must be a complex number, such as returned from function [[Complex]].
+
== IMSUB(inumber1, inumber2) ==
−
This function requires that you add Complex Library to your model.
 
  
−
= IMSQRT(c) =
+
''Analytica equivalent:''
 +
:inumber1 - inumber2
  
−
Analytica equivalent:
+
== IMSUM(inumber1, inumber12, ...) ==
−
[[CSqrt]](c)
 
  
−
To use, add Complex Library to your model.
+
''Analytica equivalent:''
 +
:inumber1 + inumber2 + ....
  
−
= IMSUB(inumber1,inumber2) =
+
Also,  if A is an array of complex numbers,  indexed by I,  you may use:
 +
:[[Sum]](A, I)
  
−
Analytica equivalent:
+
== OCT2BIN(x'', places'') ==
−
inumber1 - inumber2
 
  
−
= IMSUM(inumber1,inumber12,...) =
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
 +
:[[Oct2Bin]](x'', places'')
  
−
Analytica equivalent:
+
== OCT2DEC(x) ==
−
inumber1 + inumber2 + ....
 
  
−
Also, if A is an array of complex numbers, indexed by I, you may use:
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
−
[[Sum]](A,I)
+
:[[Oct2Dec]](x)
  
−
= OCT2BIN =
+
== OCT2HEX(x'', places'') ==
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
 
  
−
= OCT2DEC =
+
''Analytica equivalent'' (requires the [[Base Conversion Function Library]]):
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
+
:[[Oct2Hex]](x'', places'')
  
−
= OCT2HEX =
+
==See Also==
−
Not available in Analytica, but relatively easy to implement as a user-defined function.
+
* [[Excel to Analytica Mappings]]
 +
* [[Standard libraries]]

Latest revision as of 00:35, 16 March 2016


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

Comments


You are not allowed to post comments.