Difference between revisions of "Excel to Analytica Mappings/Engineering Functions"

m
Line 1: Line 1:
−
= BESSELI(x,n) =
+
 
 +
 
 +
<div style=="column-count:3;-moz-column-count:3;-webkit-column-count:3">
 +
__TOC__
 +
</div>
 +
 
 +
== BESSELI(x, n) ==
  
 
Analytica 4.1 equivalent:
 
Analytica 4.1 equivalent:
−
  [[BesselI]](x,[[Floor]](n))
+
  [[BesselI]](x, [[Floor]](n))
  
−
= BESSELJ =
+
== BESSELJ ==
  
 
Analytica 4.1 equivalent:
 
Analytica 4.1 equivalent:
−
  [[BesselJ]](x,[[Floor]](n))
+
  [[BesselJ]](x, [[Floor]](n))
  
−
= BESSELK =
+
== BESSELK ==
  
 
Analytica 4.1 equivalent:
 
Analytica 4.1 equivalent:
−
  [[BesselK]](x,[[Floor]](n))
+
  [[BesselK]](x, [[Floor]](n))
  
−
= BESSELY =
+
== BESSELY ==
  
 
Analytica 4.1 equivalent:
 
Analytica 4.1 equivalent:
−
  [[BesselY]](x,[[Floor]](n))
+
  [[BesselY]](x, [[Floor]](n))
  
−
= BIN2DEC(x) =
+
== BIN2DEC(x) ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
Line 25: Line 31:
 
  [[Bin2Dec]](x)
 
  [[Bin2Dec]](x)
  
−
= BIN2HEX(x'',places'') =
+
== BIN2HEX(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Bin2Hex]](x'',places'')
+
  [[Bin2Hex]](x'', places'')
  
−
= BIN2OCT(x'',places'') =
+
== BIN2OCT(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Bin2Oct]](x'',places'')
+
  [[Bin2Oct]](x'', places'')
  
−
= COMPLEX(re,im) =
+
== COMPLEX(re, im) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[Complex]](re,im)
+
  [[Complex]](re, im)
  
−
To use, add the Complex Library to your model.
+
To use, add the Complex Library to your model.
  
−
= CONVERT =
+
== CONVERT ==
 
Not available in Analytica.
 
Not available in Analytica.
  
−
= DEC2BIN(x'',places'') =
+
== DEC2BIN(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Dec2Bin]](x'',places'')
+
  [[Dec2Bin]](x'', places'')
  
−
= DEC2HEX(x'',places'') =
+
== DEC2HEX(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Dec2Hex]](x'',places'')
+
  [[Dec2Hex]](x'', places'')
  
−
= DEC2OCT(x'',places'') =
+
== DEC2OCT(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Dec2Oct]](x'',places'')
+
  [[Dec2Oct]](x'', places'')
  
−
= 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):
+
Analytica equivalent of GESTEP(n, s):
−
  (n >= s)
+
  (n >== s)
  
−
= HEX2BIN(x'',places'') =
+
== HEX2BIN(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Hex2Bin]](x'',places'')
+
  [[Hex2Bin]](x'', places'')
  
−
= HEX2DEC(x) =
+
== HEX2DEC(x) ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
Line 103: Line 109:
 
  [[Hex2Dec]](x)
 
  [[Hex2Dec]](x)
  
−
= HEX2OCT(x'',places'') =
+
== HEX2OCT(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Hex2Oct]](x'',places'')
+
  [[Hex2Oct]](x'', places'')
  
  
−
= IMABS(c) =
+
== IMABS(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CAbs]](c)
 
  [[CAbs]](c)
  
−
To use, add the Complex Library to your model.
+
To use, add the Complex Library to your model.
  
−
= IMAGINARY(c) =
+
== IMAGINARY(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[Im]](c)
 
  [[Im]](c)
  
−
To use, add the Complex Library to your model.
+
To use, add the Complex Library to your model.
  
−
= IMARGUMENT(c) =
+
== IMARGUMENT(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CTheta]](c)
 
  [[CTheta]](c)
  
−
To use, add Complex Library to your model.
+
To use, add Complex Library to your model.
  
−
= IMCONJUGATE(c) =
+
== IMCONJUGATE(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[Complex]]( [[Re]](c), -[[Im]](c) )
+
  [[Complex]]( [[Re]](c), -[[Im]](c) )
  
−
To use, add the Complex Library to your model.
+
To use, add the Complex Library to your model.
  
−
= IMCOS(c) =
+
== IMCOS(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  CCos(c)
 
  CCos(c)
  
−
To use, add Complex Library to your model.
+
To use, add Complex Library to your model.
  
−
= IMDIV(inumber1,inumber2) =
+
== IMDIV(inumber1, inumber2) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[CDiv]](inumber1,inumber2)
+
  [[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.
+
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) =
+
== IMEXP(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CExp]](c)
 
  [[CExp]](c)
  
−
= IMLN(c) =
+
== IMLN(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CLn(c)]]
 
  [[CLn(c)]]
  
−
To use, add Complex Library to your model.
+
To use, add Complex Library to your model.
  
−
= IMLOG10(c) =
+
== IMLOG10(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[CDiv]]([[CLn]](c),[[Complex]](ln(10),0))
+
  [[CDiv]]([[CLn]](c), [[Complex]](ln(10), 0))
  
−
= IMLOG2 =
+
== IMLOG2 ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[CDiv]]([[CLn]](c),[[Complex]](ln(2),0))
+
  [[CDiv]]([[CLn]](c), [[Complex]](ln(2), 0))
  
−
= IMPOWER(inumber,number) =
+
== IMPOWER(inumber, number) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[CPower]](inumber,number)
+
  [[CPower]](inumber, number)
  
−
''inumber'' must be a complex, defined using [[Complex]].  Do not pass a real.   
+
''inumber'' must be a complex, defined using [[Complex]].  Do not pass a real.   
  
−
To use, add the Complex Library to your model.
+
To use, add the Complex Library to your model.
  
−
= IMPRODUCT(inumber1,inumber2) =
+
== IMPRODUCT(inumber1, inumber2) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
−
  [[CMult]](inumber1,inumber2)
+
  [[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.
+
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) =
+
== IMREAL(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
Line 197: Line 203:
 
This function requires that you add the Complex Library to your model.  ''c'' is a complex number as returned from function [[Complex]].
 
This function requires that you add the Complex Library to your model.  ''c'' is a complex number as returned from function [[Complex]].
  
−
= IMSIN(c) =
+
== IMSIN(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CSin]](c)
 
  [[CSin]](c)
  
−
''c'' must be a complex number, such as returned from function [[Complex]].
+
''c'' must be a complex number, such as returned from function [[Complex]].
 
This function requires that you add Complex Library to your model.
 
This function requires that you add Complex Library to your model.
  
−
= IMSQRT(c) =
+
== IMSQRT(c) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  [[CSqrt]](c)
 
  [[CSqrt]](c)
  
−
To use, add Complex Library to your model.
+
To use, add Complex Library to your model.
  
−
= IMSUB(inumber1,inumber2) =
+
== IMSUB(inumber1, inumber2) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  inumber1 - inumber2
 
  inumber1 - inumber2
  
−
= IMSUM(inumber1,inumber12,...) =
+
== IMSUM(inumber1, inumber12, ...) ==
  
 
Analytica equivalent:
 
Analytica equivalent:
 
  inumber1 + inumber2 + ....
 
  inumber1 + inumber2 + ....
  
−
Also, if A is an array of complex numbers, indexed by I, you may use:
+
Also, if A is an array of complex numbers, indexed by I, you may use:
−
  [[Sum]](A,I)
+
  [[Sum]](A, I)
  
−
= OCT2BIN(x'',places'') =
+
== OCT2BIN(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Oct2Bin]](x'',places'')
+
  [[Oct2Bin]](x'', places'')
  
−
= OCT2DEC(x) =
+
== OCT2DEC(x) ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
Line 237: Line 243:
 
  [[Oct2Dec]](x)
 
  [[Oct2Dec]](x)
  
−
= OCT2HEX(x'',places'') =
+
== OCT2HEX(x'', places'') ==
  
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
 
Analytica 4.1 equivalent (requires the [[Base Conversion Function Library]]:
  
−
  [[Oct2Hex]](x'',places'')
+
  [[Oct2Hex]](x'', places'')

Revision as of 02:26, 6 January 2016


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

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Bin2Dec(x)

BIN2HEX(x, places)

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Bin2Hex(x, places)

BIN2OCT(x, places)

Analytica 4.1 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 4.1 equivalent (requires the Base Conversion Function Library: 

Dec2Bin(x, places)

DEC2HEX(x, places)

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Dec2Hex(x, places)

DEC2OCT(x, places)

Analytica 4.1 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 4.1 equivalent (requires the Base Conversion Function Library: 

Hex2Bin(x, places)

HEX2DEC(x)

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Hex2Dec(x)

HEX2OCT(x, places)

Analytica 4.1 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 4.1 equivalent (requires the Base Conversion Function Library: 

Oct2Bin(x, places)

OCT2DEC(x)

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Oct2Dec(x)

OCT2HEX(x, places)

Analytica 4.1 equivalent (requires the Base Conversion Function Library: 

Oct2Hex(x, places)
Comments


You are not allowed to post comments.