Westclintech

Getting started

XLeratorDB/Engineering Functions Documentation

FUNCTION REFERENCE - Engineering Functions FUNCTIONS

Area

ACRES

Convert area to acres.

CONVERTAREA

Convert to and from acres, hectares, square feet, square inches, square meters, square miles, or square yards.

HECTARES

Convert area to hectares.

SQFEET

Convert area to square feet.

SQINCHES

Convert area to square inches.

SQMETERS

Convert area to square meters.

SQMILES

Convert area to square miles.

SQYARDS

Convert area to square yards.

Base Conversions

BIN2DEC

Convert a binary number to a decimal.

BIN2HEX

Convert a binary number to a hexadecimal.

BIN2OCT

Convert a binary number to an octal.

DEC2BIN

Convert a decimal number to binary.

DEC2HEX

Convert a decimal number to hexadecimal.

DEC2OCT

Convert a decimal number to octal.

EBIN2DEC

Convert an unsignedpositive binary number to decimal.

HEX2BIN

Convert a hexadecimal number to binary.

HEX2DEC

Convert a hexadecimal number to decimal.

HEX2OCT

Convert a hexadecimal number to octal.

OCT2BIN

Convert an octal number to binary.

OCT2DEC

Convert an octal number to decimal.

OCT2HEX

Convert an octal number to hexadecimal.

Complex Numbers

COMPLEX

Convert real and imaginary coefficients into a complex number of the form x + yi or x + yj.

IMABS

Calculate the absolute value of a complex number in the x + yi or x + yj format.

IMADD

Return the sum of 2 complex numbers in x + yi or x + yj text format.

IMAGINARY

Return the imaginary coefficient of a complex number in the x + yi or x + yj format.

IMARGUMENT

Return theta, an angle expressed in radians.

IMCONJUGATE

Return the complex conjugate of a complex number in x + yi or x +yj format.

IMCOS

Return the cosine of a complex number in x + yi or x + yj text format.

IMDIV

Return the quotient of 2 complex numbers in x + yi or x + yj text format.

IMEXP

Return the exponential of a complex number in x + yi or x + yj text format.

IMLN

Return the natural logarithm of a complex number in x + yi or x + yj text format.

IMLOG10

Return the common (base 10) logarithm of a complex number in x + yi or x + yj text format.

IMLOG2

Return the base-2 logarithm of a complex number in x + yi or x + yj text format.

IMMULT

Return the product of 2 complex numbers in x + yi or x + yj text format.

IMPOWER

Return a complex number in x + yi or x + yj text format raised to a power.

IMPRODUCT

Return the product of a dataset containing complex numbers in x + yi or x + yj text format.

IMPRODUCT_q

Return the product of a dataset containing complex numbers in x + yi or x + yj text format.

IMREAL

Return the real coefficient of a complex number in the x + yi or x + yj format.

IMSIN

Return the sine of a complex number in x + yi or x + yj text format.

IMSQRT

Return the square root of a complex number in x + yi or x + yj text format.

IMSUB

Return the difference between 2 complex numbers in x + yi or x + yj text format.

IMSUM

Return the sum of a dataset of complex numbers in x + yi or x + yj text format.

IMSUM_q

Return the sum of a dataset of complex numbers in x + yi or x + yj text format.

Engineering

BESSELI

Calculate the modified Bessel function of the first kind Iₙ(x).

BESSELJ

Calculate the Bessel function of the first kind J±v(z).

BESSELK

Calculate the Bessel function of the first kind Kv(z).

BESSELY

Calculate the Bessel function of the second kind Yₙ(x).

DELTA

Test whether two values are equal.

ERF

Calculate the error function.

ERFC

Calculate the complementary error function.

GESTEP

Test whether a number is greater than or equal to a threshold value.

MODULO

Return the amount by which a number exceeds the largest integer multiple of the divisor that is not greater than that number.

Length

CONVERTLENGTH

Convert to and from fathoms, feet, furlongs, inches, meters, miles, nautical miles, pica, points, or yards.

FATHOMS

Convert length to fathoms.

FEET

Convert length to feet.

FURLONGS

Convert length to furlongs.

INCHES

Convert length to inches.

METERS

Convert length to meters.

MILES

Convert length to miles.

NMILES

Convert length to nautical miles.

PICA

Convert length to pica.

POINTS

Convert length to points.

YARDS

Convert length to yards.

Other

XLDB_ENGINEERING_VERSION

Get version information for the XLeratorDB / engineering library.

Speed

CONVERTSPEED

Convert to and from feet per hour, feet per minute, feet per second, inches per second, kilometers per hour, knots, miles per hour, miles per minute, miles per second, meters per second, meters per minute, or meters per hour.

FTHR

Convert speed to feet per hour.

FTMIN

Convert speed to feet per minute.

FTSEC

Convert speed to feet per second.

INSEC

Convert speed to inches per second.

KMHR

Convert speed to kilometers per hour.

KNOTS

Convert speed to knots.

MHR

Convert speed to meters per hour.

MIHR

Convert speed to miles per hour.

MIMIN

Convert speed to miles per minute.

MISEC

Convert speed to miles per second.

MMIN

Convert speed to meters per minute.

MSEC

Convert speed to meters per second.

Temperature

CELSIUS

Convert from Fahrenheit, Kelvin, or Rankine to Celsius.

CONVERTTEMP

Convert to and from Celsius, Fahrenheit, Kelvin, or Rankine.

FAHRENHEIT

Convert from Celsius, Kelvin, or Rankine to Fahrenheit.

KELVIN

Convert from Celsius, Fahrenheit, or Rankine to Kelvin.

RANKINE

Convert from Celsius, Fahrenheit, or Kelvin to Rankine.

Volume

BARRELS

Convert from volume to barrels.

BBLS

Convert from volume to bbls.

BUSHELS

Convert from volume to bushels.

CONVERTVOLUME

Convert to and from barrels (US beer barrels), bbl (oil barrel), bushels, cubic feet, cubic inches, cubic meters, cubic miles, cubic yards, cups, dry pints, dry quarts, fluid drams, fluid ounces, gallons, gills, imperial gallons, imperial gills, imperial pints, imperial quarts, liters, pecks, pints, quarts, steres, tablespoons,or teaspoons.

CUFEET

Convert from volume to cubic feet.

CUINCHES

Convert from volume to cubic inches.

CUMETERS

Convert from volume to cubic meters.

CUMILES

Convert from volume to cubic miles.

CUPS

Convert from volume to cups.

CUYARDS

Convert from volume to cubic yards.

DRYPINTS

Convert from volume to dry pints.

DRYQUARTS

Convert from volume to dry quarts.

FLDRAMS

Convert from volume to fluid drams.

FLOUNCES

Convert from volume to fluid ounces.

GALLONS

Convert from volume to gallons.

GILLS

Convert from volume to gills.

IMPGALLONS

Convert from volume to imperial gallons.

IMPGILLS

Convert from volume to imperial gills.

IMPOUNCES

Convert from volume to imperial ounces.

IMPPINTS

Convert from volume to imperial pints.

IMPQUARTS

Convert from volume to imperial quarts.

LITERS

Convert from volume to liters.

PECKS

Convert from volume to pecks.

PINTS

Convert from volume to pints.

QUARTS

Convert from volume to quarts.

STERES

Convert from volume to steres.

TABLESPOONS

Convert from volume to tablespoons.

TEASPOONS

Convert from volume to teaspoons.

Weight

CONVERTWEIGHT

Convert to and from drams, grains, grams, hundredweights, ounces, pennyweights, pounds, stones, tonnes, tons, troy pounds, or troy ounces.

CWT

Convert weigth to hundredweights.

DRAMS

Convert weight to drams.

DWT

Convert weight to pennyweights.

GRAINS

Convert weight to grains.

GRAMS

Convert weight to troy pounds.

OUNCES

Convert weight to ounces.

POUNDS

Convert weight to pounds.

STONES

Convert weight to stones.

TON

Convert weight to tons.

TONNES

Convert weight to tonnes.

TPOUNDS

Convert weight to troy pounds.

TROY

Convert weight to troy ounces.