diff --git a/sheets/functions/engineering.xml b/sheets/functions/engineering.xml index b9911ef9b39..7340379503c 100644 --- a/sheets/functions/engineering.xml +++ b/sheets/functions/engineering.xml @@ -1,913 +1,913 @@ Engineering BASE String Number Float Base Int MinLength Int The BASE() function converts a number from base-10 to a string value in a target base from 2 to 36. BASE(number;base;prec) BASE(128;8) returns "200" BESSELI Float Where the function is evaluated Float Order of the function Int The BESSELI() function returns the modified Bessel function In(x). BESSELI(X;N) BESSELI(0.7;3) returns 0.007367374 BESSELJ BESSELK BESSELY BESSELJ Float Where the function is evaluated Float Order of the function Int The BESSELJ() function returns the Bessel function. BESSELJ(X;N) BESSELJ(0.89;3) returns 0.013974004 BESSELI BESSELK BESSELY BESSELK Float Where the function is evaluated Float Order of the function Int The BESSELK() function returns the modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments. BESSELK(X;N) BESSELK(3;9) returns 397.95880 BESSELI BESSELJ BESSELY BESSELY Float Where the function is evaluated Float Order of the function Int The BESSELY() function returns the Bessel function, which is also called the Weber function or the Neumann function. BESSELY(X;N) BESSELY(4;2) equals 0.215903595 BESSELI BESSELJ BESSELK CONVERT Float Number Float From unit String To unit String The CONVERT() function returns a conversion from one measurement system to another. Supported mass units: g (gram), sg (pieces), lbm (pound), u (atomic mass), ozm (ounce), stone, ton, grain, pweight (pennyweight), hweight (hundredweight). Supported distance units: m (meter), in (inch), ft (feet), mi (mile), Nmi (nautical mile), ang (Angstrom), parsec, lightyear. Supported pressure units: Pa (Pascal), atm (atmosphere), mmHg (mm of Mercury), psi, Torr. Supported force units: N (Newton), dyn, pound. Supported energy units: J (Joule), e (erg), c (Thermodynamic calorie), cal (IT calorie), eV (electronvolt), HPh (Horsepower-hour), Wh (Watt-hour), flb (foot-pound), BTU. Supported power units: W (Watt), HP (horsepower), PS (Pferdestaerke). Supported magnetism units: T (Tesla), ga (Gauss). Supported temperature units: C (Celsius), F (Fahrenheit), K (Kelvin). Supported volume units: l (liter), tsp (teaspoon), tbs (tablespoon), oz (ounce liquid), cup, pt (pint), qt (quart), gal (gallon), barrel, m3 (cubic meter), mi3 (cubic mile), Nmi3 (cubic Nautical mile), in3 (cubic inch), ft3 (cubic foot), yd3 (cubic yard), GRT or regton (gross register ton). Supported area units: m2 (square meter), mi2 (square mile), Nmi2 (square Nautical mile), in2 (square inch), ft2 (square foot), yd2 (square yard), acre, ha (hectare). Supported speed units: m/s (meters per second), m/h (meters per hour), mph (miles per hour), kn (knot). For metric units any of the following prefixes can be used: E (exa, 1E+18), P (peta, 1E+15), T (tera, 1E+12), G (giga, 1E+09), M (mega, 1E+06), k (kilo, 1E+03), h (hecto, 1E+02), e (dekao, 1E+01), d (deci, 1E-01), c (centi, 1E-02), m (milli, 1E-03), u (micro, 1E-06), n (nano, 1E-09), p (pico, 1E-12), f (femto, 1E-15), a (atto, 1E-18). CONVERT(Number; From Unit; To Unit) CONVERT(32;"C";"F") equals 89.6 CONVERT(3;"lbm";"kg") equals 1.3608 CONVERT(7.9;"cal";"J") equals 33.0757 ERF Float Lower limit Float Upper limit Float The ERF() function returns the error function. With a single argument, ERF() returns the error function between 0 and that argument. ERF(Lower limit; Upper limit) ERF(0.4) equals 0.42839236 ERFC ERFC Float Lower limit Float Upper limit Float The ERFC() function returns the complementary error function. ERFC(Lower limit; Upper limit) ERFC(0.4) equals 0.57160764 ERF DEC2BIN String The value to convert Int The minimum length of the output Int - The DEC2BIN() function returns the value formatted as a binary number. + The DEC2BIN() function returns a decimal value formatted as a binary number. DEC2BIN(value) DEC2BIN(12) returns "1100" DEC2BIN(55) returns "110111" DEC2HEX String The value to convert Int The minimum length of the output Int - The DEC2HEX() function returns the value formatted as a hexadecimal number. + The DEC2HEX() function returns a decimal value formatted as a hexadecimal number. DEC2HEX(value) DEC2HEX(12) returns "c" DEC2HEX(55) returns "37" DEC2OCT String The value to convert Int The minimum length of the output Int - The DEC2OCT() function returns the value formatted as an octal number. + The DEC2OCT() function returns a decimal value formatted as an octal number. DEC2OCT(value) DEC2OCT(12) returns "14" DEC2OCT(55) returns "67" OCT2BIN String The value to convert String The minimum length of the output Int - The OCT2BIN() function returns the value formatted as a binary number. + The OCT2BIN() function returns an octal value formatted as a binary number. OCT2BIN(value) OCT2BIN("12") returns "1010" OCT2BIN("55") returns "101101" OCT2DEC Int The value to convert String - The OCT2DEC() function returns the value formatted as a decimal number. + The OCT2DEC() function returns an octal value formatted as a decimal number. OCT2DEC(value) OCT2DEC("12") returns 10 OCT2DEC("55") returns 45 OCT2HEX String The value to convert String The minimum length of the output Int - The OCT2HEX() function returns the value formatted as a hexadecimal number. + The OCT2HEX() function returns an octal value formatted as a hexadecimal number. OCT2HEX(value) OCT2HEX("12") returns "A" OCT2HEX("55") returns "2D" BIN2DEC Int The value to convert Int - The BIN2DEC() function returns the value formatted as a decimal number. + The BIN2DEC() function returns a binary value formatted as a decimal number. BIN2DEC(value) BIN2DEC("1010") returns 10 BIN2DEC("11111") returns 31 BIN2OCT String The value to convert String The minimum length of the output Int - The BIN2OCT() function returns the value formatted as an octal number. + The BIN2OCT() function returns a binary value formatted as an octal number. BIN2OCT(value) BIN2OCT("1010") returns "12" BIN2OCT("11111") returns "37" BIN2HEX String The value to convert String The minimum length of the output Int - The BIN2HEX() function returns the value formatted as a hexadecimal number. + The BIN2HEX() function returns a binary value formatted as a hexadecimal number. BIN2HEX(value) BIN2HEX("1010") returns "a" BIN2HEX("11111") returns "1f" HEX2DEC Int The value to convert String - The HEX2DEC() function returns the value formatted as a decimal number. + The HEX2DEC() function returns a hexadecimal value formatted as a decimal number. HEX2DEC(value) HEX2DEC("a") returns 10 HEX2DEC("37") returns 55 HEX2OCT String The value to convert String - The HEX2OCT() function returns the value formatted as an octal number. + The HEX2OCT() function returns a hexadecimal value formatted as an octal number. HEX2OCT(value) HEX2OCT("a") returns "12" HEX2OCT("37") returns "67" HEX2BIN String The value to convert String - The HEX2BIN() function returns the value formatted as a binary number. + The HEX2BIN() function returns a hexadecimal value formatted as a binary number. HEX2BIN(value) HEX2BIN("a") returns "1010" HEX2BIN("37") returns "110111" COMPLEX String Real coefficient Float Imaginary coefficient Float The COMPLEX(real;imag) returns a complex number of form x+yi. COMPLEX(real;imag) COMPLEX(1.2;3.4) returns "1.2+3.4i" COMPLEX(0;-1) returns "-i" IMAGINARY Double Complex number String The IMAGINARY(string) returns the imaginary coefficient of a complex. IMAGINARY(string) IMAGINARY("1.2+3.4i") returns 3.4 IMAGINARY("1.2") returns 0 IMREAL Double Complex number String The IMREAL(string) returns the real coefficient of a complex. IMREAL(string) IMREAL("1.2+3.4i") returns 1.2 IMREAL("1.2i") returns 0 IMCOS String Complex number String The IMCOS(string) returns the cosine of a complex number. IMCOS(string) IMCOS("1+i") returns "0.83373-0.988898i" IMCOS("12i") returns 81 377.4 IMCOSH String Complex number String The IMCOSH(string) returns the hyperbolic cosine of a complex number. IMCOSH(string) IMCOSH("1+i") returns "0.83373+0.988898i" IMCOSH("12i") returns 0.84358 IMCOT String Complex number String The IMCOT(string) returns the cotangent of a complex number. IMCOT(string) IMCOT("1+i") returns "0.21762-0.86801i" IMCSC String Complex number String The IMCSC(string) returns the cosecant of a complex number. IMCSC(string) IMCSC("1+i") returns "0.62151-0.30393i" IMCSCH String Complex number String The IMCSCH(string) returns the hyperbolic cosecant of a complex number. IMCSCH(string) IMCSCH("1+i") returns "0.30393-i0.62151" IMSEC String Complex number String The IMSEC(string) returns the secant of a complex number. IMSEC(string) IMSEC("1+i") returns "0.49833+i0.59108" IMSECH String Complex number String The IMSECH(string) returns the hyperbolic secant of a complex number. IMSECH(string) IMSECH("1+i") returns "0.49833-i0.59108" IMSIN String Complex number String The IMSIN(string) function returns the sine of a complex number. IMSIN(string) IMSIN("1+i") returns "1.29846+0.634964i" IMSIN("1.2") returns -0.536573 IMSINH String Complex number String The IMSINH(string) function returns the hyperbolic sine of a complex number. IMSINH(string) IMSINH("1+i") returns "0.63496+1.29846i" IMSINH("1.2") returns 1.50946 IMTAN String Complex number String The IMTAN(string) function returns the tangent of a complex number. IMTAN(string) IMTAN("1+i") returns "0.27175+1.08392i" IMTAN("1.2") returns 2.57215 IMTANH String Complex number String The IMTANH(string) function returns the hyperbolic tangent of a complex number. IMTANH(string) IMTANH("1+i") returns "1.08392+0.27175i" IMTANH("1.2") returns 0.83365 IMEXP String Complex number String The IMEXP(string) returns the exponential of a complex number. IMEXP(string) IMEXP("2-i") returns "3.99232-6.21768i" IMEXP("12i") returns "0.843854-0.536573i" IMLN String Complex number String The IMLN(string) returns the natural logarithm of a complex number. IMLN(string) IMLN("3-i") returns "1.15129-0.321751i" IMLN("12") returns 2.48491 IMLOG2 String Complex number String The IMLOG2(string) returns the base-2 logarithm of a complex number. IMLOG2(string) IMLOG2("3+4i") returns "2.321928+1.337804i" IMLOG10 String Complex number String The IMLOG10(string) returns the base-10 logarithm of a complex number. IMLOG10(string) IMLOG10("3+4i") returns "0.69897+0.402719i" IMSQRT String Complex number String The IMSQRT(string) returns the square root of a complex number. IMSQRT(string) IMSQRT("1+i") returns "1.09868+0.45509i" IMSQRT("1.2i") returns "0.774597+0.774597i" IMPOWER String Complex number String Power Int The IMPOWER(string) returns a complex number raised to a power. IMPOWER(string) IMPOWER("4-i";2) returns "15-8i" IMPOWER("1.2";2) returns 1.44 IMSUM String Complex number String Complex number String Complex number String Complex number String Complex number String The IMSUM() returns the sum of several complex numbers of form x+yi. IMSUM(value;value;...) IMSUM(1.2;"3.4+5i") returns "4.6+5i" IMSUM(1.2;"1i") returns "1.2+i" IMDIV String Complex number String Complex number String Complex number String Complex number String Complex number String The IMDIV() returns the division of several complex numbers of form x+yi. IMDIV(value;value;...) IMDIV(1.2;"3.4+5i") returns "0.111597-0.164114i" IMDIV("12+i";"12-i") returns "0.986207+0.16551i" IMSUB String Complex number String Complex number String Complex number String Complex number String Complex number String The IMSUB() returns the difference of several complex numbers of form x+yi. IMSUB(value;value;...) IMSUB(1.2;"3.4+5i") returns "-2.2-5i" IMSUB(1.2;"1i") returns "1.2-i" IMPRODUCT String Complex number String Complex number String Complex number String Complex number String Complex number String The IMPRODUCT() returns the product of several complex numbers of form x+yi. IMPRODUCT(value;value;...) IMPRODUCT(1.2;"3.4+5i") returns "4.08+6i" IMPRODUCT(1.2;"1i") returns "+1.2i" IMCONJUGATE String Complex number String The IMCONJUGATE(complex number) returns the conjugate of a complex number of form x+yi. IMCONJUGATE(complex number) IMCONJUGATE("1.2+5i") returns "1.2-5i" IMCONJUGATE("-i") returns "i" IMCONJUGATE("12") returns "12" IMARGUMENT String Complex number String The IMARGUMENT(complex number) returns the argument of a complex number of form x+yi. IMARGUMENT(complex number) IMARGUMENT("1.2+5i") returns 0.6072 IMARGUMENT("-i") returns -1.57079633 IMARGUMENT("12") returns "#Div/0" IMABS Float Complex number String The IMABS(complex number) returns the norm of a complex number of form x+yi. IMABS(complex number) IMABS("1.2+5i") returns 5.1419 IMABS("-i") returns 1 IMABS("12") returns 12 DELTA Float Floating point value Float Floating point value Float The DELTA() function returns 1 if x equals y, otherwise returns 0. y defaults to 0. DELTA(x; y) DELTA(1.2; 3.4) returns 0 DELTA(3; 3) returns 1 DELTA(1; TRUE) returns 1 GESTEP Float Floating point value Float Floating point value Float The GESTEP() function returns 1 if x greater or equals y, otherwise returns 0. y defaults to 0. GESTEP(x; y) GESTEP(1.2; 3.4) returns 0 GESTEP(3; 3) returns 1 GESTEP(0.4; TRUE) returns 0 GESTEP(4; 3) returns 1