|
124.
|
|
|
@FUNCTION=BESSELI
@SYNTAX=BESSELI(x,y)
@DESCRIPTION=BESSELI function returns the Neumann, Weber or Bessel function.
@x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.
@EXAMPLES=
BESSELI(0.7,3) equals 0.007367374.
@SEEALSO=BESSELJ,BESSELK,BESSELY
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
../plugins/fn-eng/functions.c:650
|
|
125.
|
|
|
@FUNCTION=BESSELK
@SYNTAX=BESSELK(x,y)
@DESCRIPTION=BESSELK function returns the Neumann, Weber or Bessel function. @x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.
@EXAMPLES=
BESSELK(3,9) equals 397.95880.
@SEEALSO=BESSELI,BESSELJ,BESSELY
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
Located in
../plugins/fn-eng/functions.c:693
|
|
126.
|
|
|
@FUNCTION=BESSELJ
@SYNTAX=BESSELJ(x,y)
@DESCRIPTION=BESSELJ function returns the Bessel function with @x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.
@EXAMPLES=
BESSELJ(0.89,3) equals 0.013974004.
@SEEALSO=BESSELI,BESSELK,BESSELY
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=BESSELJ
@SYNTAX=BESSELJ(x;y)
@DESCRIPTION=BESSELJ funtzioak Bessel funtzioa ematen du; @x argumentuarekin ebaluatzen da. @y argumentua, berriz, Bessel funtzioaren ordena da (osoko zenbakia ez bada, trunkatu egingo da).
* @x edo @y zenbakizkoak ez badira, #BALIOA! errorea emango du.
* @y < 0 bada, #ZK! errorea emango da.
* Funtzio hau bateragarria da Excel-ekin.
@EXAMPLES=
BESSELJ(0,89;3) berdin 0,013974004.
@SEEALSO=BESSELI,BESSELK,BESSELY
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
127.
|
|
|
@FUNCTION=BESSELY
@SYNTAX=BESSELY(x,y)
@DESCRIPTION=BESSELY function returns the Neumann, Weber or Bessel function.
@x is where the function is evaluated. @y is the order of the Bessel function, if non-integer it is truncated.
* If @x or @y are not numeric a #VALUE! error is returned.
* If @y < 0 a #NUM! error is returned.
* This function is Excel compatible.
@EXAMPLES=
BESSELY(4,2) equals 0.215903595.
@SEEALSO=BESSELI,BESSELJ,BESSELK
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=BESSELY
@SYNTAX=BESSELY(x;y)
@DESCRIPTION=BESSELY funtzioak Neumann, Weber edo Bessel funtzioa ematen du.
@x argumentuarekin ebaluatzen da funtzioa. @y argumentua, berriz, Bessel funtzioaren ordena da (osoko zenbakia ez bada, trunkatu egingo da).
* @x edo @y zenbakizkoak ez badira, #BALIOA! errorea emango du.
* @y < 0 bada, #ZK! errorea emango du.
* Funtzio hau bateragarria da Excel-ekin.
@EXAMPLES=
BESSELY(4;2) berdin 0,215903595.
@SEEALSO=BESSELI,BESSELJ,BESSELK
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
128.
|
|
|
@FUNCTION=CONVERT
@SYNTAX=CONVERT(number,from_unit,to_unit)
@DESCRIPTION=CONVERT returns a conversion from one measurement system to another. For example, you can convert a weight in pounds to a weight in grams. @number is the value you want to convert, @from_unit specifies the unit of the @number, and @to_unit is the unit for the result.
@from_unit and @to_unit can be any of the following:
Weight and mass:
[tab] 'g' [tab] [tab] Gram
[tab] 'sg' [tab] [tab] Slug
[tab] 'lbm' [tab] [tab] Pound
[tab] 'u' [tab] [tab] U (atomic mass)
[tab] 'ozm' [tab] [tab] Ounce
Distance:
[tab] 'm' [tab] [tab] Meter
[tab] 'mi' [tab] [tab] Statute mile
[tab] 'Nmi' [tab] [tab] Nautical mile
[tab] 'in' [tab] [tab] Inch
[tab] 'ft' [tab] [tab] Foot
[tab] 'yd' [tab] [tab] Yard
[tab] 'ang' [tab] [tab] Angstrom
[tab] 'Pica' [tab] [tab] Pica
Time:
[tab] 'yr' [tab] [tab] Year
[tab] 'day' [tab] [tab] Day
[tab] 'hr' [tab] [tab] Hour
[tab] 'mn' [tab] [tab] Minute
[tab] 'sec' [tab] [tab] Second
Pressure:
[tab] 'Pa' [tab] [tab] Pascal
[tab] 'atm' [tab] [tab] Atmosphere
[tab] 'mmHg' [tab] mm of Mercury
Force:
[tab] 'N' [tab] [tab] Newton
[tab] 'dyn' [tab] [tab] Dyne
[tab] 'lbf' [tab] [tab] Pound force
Energy:
[tab] 'J' [tab] [tab] Joule
[tab] 'e' [tab] [tab] Erg
[tab] 'c' [tab] [tab] Thermodynamic calorie
[tab] 'cal' [tab] [tab] IT calorie
[tab] 'eV' [tab] Electron volt
[tab] 'HPh' [tab] Horsepower-hour
[tab] 'Wh' [tab] Watt-hour
[tab] 'flb' [tab] [tab] Foot-pound
[tab] 'BTU' [tab] BTU
Power:
[tab] 'HP' [tab] Horsepower
[tab] 'W' [tab] Watt
Magnetism:
[tab] 'T' [tab] [tab] Tesla
[tab] 'ga' [tab] Gauss
Temperature:
[tab] 'C' [tab] [tab] Degree Celsius
[tab] 'F' [tab] [tab] Degree Fahrenheit
[tab] 'K' [tab] [tab] Degree Kelvin
Liquid measure:
[tab] 'tsp' [tab] [tab] Teaspoon
[tab] 'tbs' [tab] [tab] Tablespoon
[tab] 'oz' [tab] [tab] Fluid ounce
[tab] 'cup' [tab] Cup
[tab] 'pt' [tab] [tab] Pint
[tab] 'qt' [tab] [tab] Quart
[tab] 'gal' [tab] [tab] Gallon
[tab] 'l' [tab] [tab] Liter
For metric units any of the following prefixes can be used:
[tab] 'Y' [tab] yotta [tab] 1E+24
[tab] 'Z' [tab] zetta [tab] 1E+21
[tab] 'E' [tab] exa [tab] 1E+18
[tab] 'P' [tab] peta [tab] 1E+15
[tab] 'T' [tab] tera [tab] [tab] 1E+12
[tab] 'G' [tab] giga [tab] 1E+09
[tab] 'M' [tab] mega [tab] 1E+06
[tab] 'k' [tab] kilo [tab] [tab] 1E+03
[tab] 'h' [tab] hecto [tab] 1E+02
[tab] 'e' [tab] deka [tab] 1E+01
[tab] 'd' [tab] deci [tab] 1E-01
[tab] 'c' [tab] centi [tab] [tab] 1E-02
[tab] 'm' [tab] milli [tab] [tab] 1E-03
[tab] 'u' [tab] micro [tab] 1E-06
[tab] 'n' [tab] nano [tab] 1E-09
[tab] 'p' [tab] pico [tab] 1E-12
[tab] 'f' [tab] femto [tab] 1E-15
[tab] 'a' [tab] atto [tab] [tab] 1E-18
[tab] 'z' [tab] zepto [tab] [tab] 1E-21
[tab] 'y' [tab] yocto [tab] [tab] 1E-24
* If @from_unit and @to_unit are different types, CONVERT returns #N/A error.
* This function is Excel compatible.
@EXAMPLES=
CONVERT(3,"lbm","g") equals 1360.7769.
CONVERT(5.8,"m","in") equals 228.3465.
CONVERT(7.9,"cal","J") equals 33.07567.
@SEEALSO=
|
|
|
[tab] represents a tab character.
Please write it exactly the same way, [tab] , in your
translation.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=CONVERT
@SYNTAX=CONVERT(zenbakia;jatorrizko_unitatea;helburuko_unitatea)
@DESCRIPTION=CONVERT funtzioak unitate-sistema batetik beste baterako bihurketa egiten du. Adibidez, libratan neurtutako pisua gramotara bihur dezake. @zenbakia bihurtu nahi duzun neurria da, @jatorrizko_unitateak @zenbakia argumentuaren unitatea zehazten du, eta @helburuko_unitateak, berriz, emaitzaren unitatea.
@jatorrizko_unitatea eta @helburuko_unitatea honako hauek izan daitezke:
Pisua eta masa:
[tab] 'g' [tab] [tab] Gramo
[tab] 'sg' [tab] [tab] Slug
[tab] 'lbm' [tab] [tab] Libra
[tab] 'u' [tab] [tab] U (masa atomikoa)
[tab] 'ozm' [tab] [tab] Ontza
Distantzia:
[tab] 'm' [tab] [tab] Metro
[tab] 'mi' [tab] [tab] Milia
[tab] 'Nmi' [tab] [tab] Itsas milia
[tab] 'in' [tab] [tab] Hazbete
[tab] 'ft' [tab] [tab] Oin
[tab] 'yd' [tab] [tab] Yarda
[tab] 'ang' [tab] [tab] Angstrom
[tab] 'Pica' [tab] [tab] Pica
Denbora:
[tab] 'yr' [tab] [tab] Urte
[tab] 'day' [tab] [tab] Egun
[tab] 'hr' [tab] [tab] Ordu
[tab] 'mn' [tab] [tab] Minutu
[tab] 'sec' [tab] [tab] Segundo
Presioa:
[tab] 'Pa' [tab] [tab] Pascal
[tab] 'atm' [tab] [tab] Atmosfera
[tab] 'mmHg' [tab] mm merkurio
Indarra:
[tab] 'N' [tab] [tab] Newton
[tab] 'dyn' [tab] [tab] Dyne
[tab] 'lbf' [tab] [tab] Libra (indarra)
Energia:
[tab] 'J' [tab] [tab] Joule
[tab] 'e' [tab] [tab] Erg
[tab] 'c' [tab] [tab] Kaloria termodinamiko
[tab] 'cal' [tab] [tab] IT kaloria
[tab] 'eV' [tab] Elektronvolt
[tab] 'HPh' [tab] Zaldi-potentzia ordu
[tab] 'Wh' [tab] Watt ordu
[tab] 'flb' [tab] [tab] Oin-libra
[tab] 'BTU' [tab] BTU
Potentzia:
[tab] 'HP' [tab] Zaldi-potentzia
[tab] 'W' [tab] Watt
Magnetismoa:
[tab] 'T' [tab] [tab] Tesla
[tab] 'ga' [tab] Gauss
Temperature:
[tab] 'C' [tab] [tab] Gradu Celsius
[tab] 'F' [tab] [tab] Gradu Fahrenheit
[tab] 'K' [tab] [tab] Gradu Kelvin
Likido unitateak:
[tab] 'tsp' [tab] [tab] Te-koilarakada
[tab] 'tbs' [tab] [tab] Mahaiko koilarakada
[tab] 'oz' [tab] [tab] Ontza fluido
[tab] 'cup' [tab] Katilukada
[tab] 'pt' [tab] [tab] Pinta
[tab] 'qt' [tab] [tab] Quart
[tab] 'gal' [tab] [tab] Gallon
[tab] 'l' [tab] [tab] Litro
Unitate metrikoekin aurrizki hauek erabili daitezke:
[tab] 'Y' [tab] yotta [tab] 1E+24
[tab] 'Z' [tab] zetta [tab] 1E+21
[tab] 'E' [tab] exa [tab] 1E+18
[tab] 'P' [tab] peta [tab] 1E+15
[tab] 'T' [tab] tera [tab] [tab] 1E+12
[tab] 'G' [tab] giga [tab] 1E+09
[tab] 'M' [tab] mega [tab] 1E+06
[tab] 'k' [tab] kilo [tab] [tab] 1E+03
[tab] 'h' [tab] hecto [tab] 1E+02
[tab] 'e' [tab] deka [tab] 1E+01
[tab] 'd' [tab] deci [tab] 1E-01
[tab] 'c' [tab] centi [tab] [tab] 1E-02
[tab] 'm' [tab] milli [tab] [tab] 1E-03
[tab] 'u' [tab] micro [tab] 1E-06
[tab] 'n' [tab] nano [tab] 1E-09
[tab] 'p' [tab] pico [tab] 1E-12
[tab] 'f' [tab] femto [tab] 1E-15
[tab] 'a' [tab] atto [tab] [tab] 1E-18
[tab] 'z' [tab] zepto [tab] [tab] 1E-21
[tab] 'y' [tab] yocto [tab] [tab] 1E-24
* @jatorrizko_unitatea eta @helburuko_unitatea mota desberdinetakoak badira, CONVERT funtzioak #E/E errorea emango du.
* Funtzio hau bateragarria da Excel-ekin.
@EXAMPLES=
CONVERT(3;"lbm";"g") berdin 1360,7769.
CONVERT(5,8;"m";"in") berdin 228,3465.
CONVERT(7,9;"cal";"J") berdin 33,07567.
@SEEALSO=
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
Located in
../plugins/fn-eng/functions.c:822
|
|
129.
|
|
|
@FUNCTION=ERF
@SYNTAX=ERF([lower limit,]upper_limit)
@DESCRIPTION=ERF returns the error function. With a single argument ERF returns the error function, defined as
[tab] erf(x) = 2/sqrt(pi)* integral from 0 to x of exp(-t*t) dt.
If two arguments are supplied, they are the lower and upper limits of the integral.
* If either @lower_limit or @upper_limit is not numeric a #VALUE! error is returned.
* This function is upward-compatible with that in Excel. (If two arguments are supplied, Excel will not allow either to be negative.)
@EXAMPLES=
ERF(0.4) equals 0.428392355.
ERF(1.6448536269515/SQRT(2)) equals 0.90.
The second example shows that a random variable with a normal distribution has a 90 percent chance of falling within approximately 1.645 standard deviations of the mean.
@SEEALSO=ERFC
|
|
|
[tab] represents a tab character.
Please write it exactly the same way, [tab] , in your
translation.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=ERF
@SYNTAX=ERF([behe-muga;]goi-muga)
@DESCRIPTION=ERF: errore-funtzioa ematen du. ERF argumentu bakar batekin errore-funtzioa ematen du, honela definituta
[tab] erf(x) = 2/sqrt(pi)* integral from 0 to x of exp(-t*t) dt.
Bi argumentu ematen badira, integralaren behe-muga eta goi-muga izango dira.
* @behe-muga edo @goi-muga argumentuetakoren bat zenbakizkoa ez bada, #BALIOA! errorea emango du.
* Funtzio honek goranzko bateragarritasuna du Excel-ekin. (Bi argumentu ematen badira, Excel-ek ez du onartuko argumentuetako bat negatiboa izatea.)
@EXAMPLES=
ERF(0,4) berdin 0,428392355.
ERF(1,6448536269515/SQRT(2)) berdin 0,90.
Bigarren adibideak erakusten dunenez, banaketa normaleko ausazko aldagai batek % 90eko probabilitatea dauka batez bestekoaren 1,645 desbiderapen estandarretan egoteko.
@SEEALSO=ERFC
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
130.
|
|
|
@FUNCTION=ERFC
@SYNTAX=ERFC(x)
@DESCRIPTION=ERFC function returns the complementary error function, defined as
[tab] 1 - erf(x).
erfc(x) is calculated more accurately than 1 - erf(x) for arguments larger than about 0.5.
* If @x is not numeric a #VALUE! error is returned.
@EXAMPLES=
ERFC(6) equals 2.15197367e-17.
@SEEALSO=ERF
|
|
|
[tab] represents a tab character.
Please write it exactly the same way, [tab] , in your
translation.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=ERFC
@SYNTAX=ERFC(x)
@DESCRIPTION=ERFC funtzioak errore osagarriaren funtzioa ematen du, honela definituta
[tab] 1 - erf(x).
erfc(x) zehaztasun handiagoarekin kalkulatzen da 1 - erf(x) baino 0,5etik gorako argumentuekin.
* @x zenbakizkoa ez bada, #BALIOA! errorea emango du.
@EXAMPLES=
ERFC(6) berdin 2,15197367e-17.
@SEEALSO=ERF
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
131.
|
|
|
@FUNCTION=DELTA
@SYNTAX=DELTA(x[,y])
@DESCRIPTION=DELTA function tests for numerical equivalence of two arguments, returning 1 in case of equality.
* @y is optional, and defaults to 0.
* If either argument is non-numeric returns a #VALUE! error.
* This function is Excel compatible.
@EXAMPLES=
DELTA(42.99,43) equals 0.
@SEEALSO=EXACT,GESTEP
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=DELTA
@SYNTAX=DELTA(x[;y])
@DESCRIPTION=DELTA funtzioak bi argumenturen zenbakizko baliokidetasuna egiaztatzen du, 1 balioa itzuliz baliokideak izanez gero.
* @y aukerakoa da, eta 0 du balio lehenetsia.
* Argumentuetako bat ez-zenbakizkoa bada, #BALIOA! errorea emango du.
* Funtzio hau bateragarria da Excel-ekin.
@EXAMPLES=
DELTA(42,99;43) berdin 0.
@SEEALSO=EXACT,GESTEP
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
132.
|
|
|
@FUNCTION=GESTEP
@SYNTAX=GESTEP(x[,y])
@DESCRIPTION=GESTEP function tests if @x is >= @y, returning 1 if it is so, and 0 otherwise. @y is optional, and defaults to 0.
* If either argument is non-numeric returns a #VALUE! error.
* This function is Excel compatible.
@EXAMPLES=
GESTEP(5,4) equals 1.
@SEEALSO=DELTA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=GESTEP
@SYNTAX=GESTEP(x[;y])
@DESCRIPTION=GESTEP funtzioak @x >= @y betetzen den egiaztatzen du, Hala bada, 1 emango du, eta 0 bestela. @y aukerakoa da, eta 0 du balio lehenetsia.
* Argumentuetako bat ez-zenbakizkoa bada, #BALIOA! errorea emango du.
* Funtzio hau bateragarria da Excel-ekin.
@EXAMPLES=
GESTEP(5;4) berdin 1.
@SEEALSO=DELTA
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|
|
133.
|
|
|
@FUNCTION=INVSUMINV
@SYNTAX=INVSUMINV(x1,x2,...)
@DESCRIPTION=INVSUMINV sum calculates the inverse of the sum of inverses.
The primary use of this is for calculating equivalent resistance for parallel resistors or equivalent capacitance of a series of capacitors.
* All arguments must be non-negative, or else a #VALUE! result is returned.
* If any argument is zero, the result is zero.
@EXAMPLES=
INVSUMINV(2000,2000) equals 1000.
@SEEALSO=HARMEAN
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=INVSUMINV
@SYNTAX=INVSUMINV(x1;x2,...)
@DESCRIPTION=INVSUMINV funtzioak alderantzizkoen baturaren alderantzizkoa
kalkulatzen du.
Funtzioa honako hauek kalkulatzeko erabiltzen da batez ere: erresistentzia paraleloen erresistentzia baliokidea, edo kondentsadoreen serie baten gaitasun baliokidea.
* Argumentu guztiek ez-negatiboak izan behar dute, eta bestela #BALIOA! errorea emango du.
* Argumenturen bat zero bada, emaitza ere zero izango da.
@EXAMPLES=
INVSUMINV(2000;2000) berdin 1000.
@SEEALSO=HARMEAN
|
|
Translated by
Iñaki Larrañaga Murgoitio
|
|
|