← All packages

@searsuite/sear-plugin-formula-engineering

Host-neutral Excel-compatible engineering formulas organized by category.

Register engineering functions

interfaceEngineeringFunctionRegistrationOptions: propertyreadonly excludedNames?: readonly string[]

Function names omitted for hosts whose formula dialect does not expose them.
variableengineeringFunctions: engineeringFunctions: readonly FormulaFunction[]
functionregisterEngineeringFunctions: registerEngineeringFunctions(registry: IFunctionRegistry, options?: EngineeringFunctionRegistrationOptions): (): void

Registers engineering formulas into an editor-local registry and returns an idempotent disposer.

Bessel functions

variableBESSELI: BESSELI returns the modified Bessel function I_n(x). Example: =BESSELI(1.5,1) returns about 0.981666.
variableBESSELJ: BESSELJ returns the Bessel function J_n(x). Example: =BESSELJ(1.9,2) returns about 0.329926.
variableBESSELK: BESSELK returns the modified Bessel function K_n(x). Example: =BESSELK(1.5,1) returns about 0.277388.
variableBESSELY: BESSELY returns the Bessel function Y_n(x). Example: =BESSELY(2.5,1) returns about 0.145918.

Bitwise functions

variableBITAND: BITAND returns the bitwise AND of two 48-bit nonnegative integers. Example: =BITAND(13,25) returns 9.
variableBITLSHIFT: BITLSHIFT shifts a 48-bit integer left, or right for a negative shift. Example: =BITLSHIFT(4,2) returns 16.
variableBITOR: BITOR returns the bitwise OR of two 48-bit nonnegative integers. Example: =BITOR(23,10) returns 31.
variableBITRSHIFT: BITRSHIFT shifts a 48-bit integer right, or left for a negative shift. Example: =BITRSHIFT(16,2) returns 4.
variableBITXOR: BITXOR returns the bitwise exclusive OR of two 48-bit nonnegative integers. Example: =BITXOR(5,3) returns 6.

Comparison functions

variableDELTA: DELTA tests whether two numbers are equal. Example: =DELTA(5,4) returns 0.
variableGESTEP: GESTEP tests whether a number is at least a threshold. Example: =GESTEP(5,4) returns 1.

Complex number functions

variableCOMPLEX: COMPLEX creates Excel complex-number text from real and imaginary coefficients. Example: =COMPLEX(3,4) returns "3+4i".
variableIMABS: IMABS returns the modulus of a complex number. Example: =IMABS("3+4i") returns 5.
variableIMAGINARY: IMAGINARY returns the imaginary coefficient. Example: =IMAGINARY("3+4i") returns 4.
variableIMARGUMENT: IMARGUMENT returns a complex number's angle in radians. Example: =IMARGUMENT("3+4i") returns about 0.9273.
variableIMCONJUGATE: IMCONJUGATE returns the complex conjugate. Example: =IMCONJUGATE("3+4i") returns a 3-4i.
variableIMCOS: IMCOS returns the cosine of a complex number. Example: =IMCOS("1+i") returns a complex cosine.
variableIMCOSH: IMCOSH returns the hyperbolic cosine of a complex number. Example: =IMCOSH("1+i") returns a complex hyperbolic cosine.
variableIMCOT: IMCOT returns the cotangent of a complex number. Example: =IMCOT("1+i") returns a complex cotangent.
variableIMCOTH: IMCOTH returns the hyperbolic cotangent. Example: =IMCOTH("1+i") returns a complex value.
variableIMCSC: IMCSC returns the cosecant of a complex number. Example: =IMCSC("1+i") returns a complex cosecant.
variableIMCSCH: IMCSCH returns the hyperbolic cosecant of a complex number. Example: =IMCSCH("1+i") returns a complex hyperbolic cosecant.
variableIMDIV: IMDIV divides one complex number by another. Example: =IMDIV("3+4i","5-3i") returns their quotient.
variableIMEXP: IMEXP returns the exponential of a complex number. Example: =IMEXP("1+i") returns a complex exponential.
variableIMLN: IMLN returns the natural logarithm of a complex number. Example: =IMLN("3+4i") returns a complex logarithm.
variableIMLOG: IMLOG returns a complex logarithm in a chosen base. Example: =IMLOG("8",2) returns 3.
variableIMLOG10: IMLOG10 returns the base-10 logarithm of a complex number. Example: =IMLOG10("3+4i") returns a complex logarithm.
variableIMLOG2: IMLOG2 returns the base-2 logarithm of a complex number. Example: =IMLOG2("3+4i") returns a complex logarithm.
variableIMPOWER: IMPOWER raises a complex number to a real power. Example: =IMPOWER("2+3i",3) returns "-46+9i".
variableIMPRODUCT: IMPRODUCT multiplies complex numbers and ranges. Example: =IMPRODUCT("3+4i","5-3i") returns "27+11i".
variableIMREAL: IMREAL returns the real coefficient. Example: =IMREAL("6-9i") returns 6.
variableIMSEC: IMSEC returns the secant of a complex number. Example: =IMSEC("1+i") returns a complex secant.
variableIMSECH: IMSECH returns the hyperbolic secant of a complex number. Example: =IMSECH("1+i") returns a complex hyperbolic secant.
variableIMSIN: IMSIN returns the sine of a complex number. Example: =IMSIN("1+i") returns a complex sine.
variableIMSINH: IMSINH returns the hyperbolic sine of a complex number. Example: =IMSINH("1+i") returns a complex hyperbolic sine.
variableIMSQRT: IMSQRT returns the square root of a complex number. Example: =IMSQRT("1+i") returns a complex square root.
variableIMSUB: IMSUB subtracts the second complex number from the first. Example: =IMSUB("13+4i","5+3i") returns "8+i".
variableIMSUM: IMSUM adds complex numbers and ranges. Example: =IMSUM("3+6i","5-2i") returns "8+4i".
variableIMTAN: IMTAN returns the tangent of a complex number. Example: =IMTAN("1+i") returns a complex tangent.
variableIMTANH: IMTANH returns the hyperbolic tangent. Example: =IMTANH("1+i") returns a complex value.

Error functions

variableERF: ERF returns the error function between lower and optional upper bounds. Example: =ERF(1) returns about 0.842701.
variableERF_PRECISE: ERF.PRECISE returns the error function from zero to x. Example: =ERF.PRECISE(1) returns about 0.842701.
variableERFC: ERFC returns the complementary error function. Example: =ERFC(1) returns about 0.157299.
variableERFC_PRECISE: ERFC.PRECISE returns the precise complementary error function. Example: =ERFC.PRECISE(1) returns about 0.157299.

Number base functions

variableBIN2DEC: BIN2DEC converts binary to decimal. Example: =BIN2DEC("1100100") returns 100.
variableBIN2HEX: BIN2HEX converts binary to hexadecimal. Example: =BIN2HEX("11111011") returns FB.
variableBIN2OCT: BIN2OCT converts binary to octal. Example: =BIN2OCT("1001") returns 11.
variableDEC2BIN: DEC2BIN converts decimal to binary. Example: =DEC2BIN(9) returns 1001.
variableDEC2HEX: DEC2HEX converts decimal to hexadecimal. Example: =DEC2HEX(100) returns 64.
variableDEC2OCT: DEC2OCT converts decimal to octal. Example: =DEC2OCT(58) returns 72.
variableHEX2BIN: HEX2BIN converts hexadecimal to binary. Example: =HEX2BIN("F") returns 1111.
variableHEX2DEC: HEX2DEC converts hexadecimal to decimal. Example: =HEX2DEC("A5") returns 165.
variableHEX2OCT: HEX2OCT converts hexadecimal to octal. Example: =HEX2OCT("F") returns 17.
variableOCT2BIN: OCT2BIN converts octal to binary. Example: =OCT2BIN("3") returns 11.
variableOCT2DEC: OCT2DEC converts octal to decimal. Example: =OCT2DEC("54") returns 44.
variableOCT2HEX: OCT2HEX converts octal to hexadecimal. Example: =OCT2HEX("100") returns 40.

Unit conversion functions

variableCONVERT: CONVERT changes a number between compatible measurement units. Example: =CONVERT(1,"mi","km") returns 1.609344.