Engineering

BASE(n,b,length)

n: integer

b: base (2 ≤ b ≤ 36)

length: minimum length of the resulting string

BASE converts n to its string representation in base b. Leading zeroes will be added to reach the minimum length given by length.

This function is OpenFormula compatible.

DECIMAL.

BESSELI(X,α)

X: number

α: order (any non-negative number)

If x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.

This function is Excel compatible if only integer orders α are used.

BESSELJ, BESSELK, BESSELY.

BESSELJ(X,α)

X: number

α: order (any non-negative integer)

If x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.

This function is Excel compatible if only integer orders α are used.

BESSELI, BESSELK, BESSELY.

BESSELK(X,α)

X: number

α: order (any non-negative number)

If x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.

This function is Excel compatible if only integer orders α are used.

BESSELI, BESSELJ, BESSELY.

BESSELY(X,α)

X: number

α: order (any non-negative integer)

If x or α are not numeric, #VALUE! is returned. If α < 0, #NUM! is returned.

This function is Excel compatible if only integer orders α are used.

BESSELI, BESSELJ, BESSELK.

BIN2DEC(x)

x: a binary number, either as a string or as a number involving only the digits 0 and 1

This function is Excel compatible.

DEC2BIN, BIN2OCT, BIN2HEX.

BIN2HEX(x,places)

x: a binary number, either as a string or as a number involving only the digits 0 and 1

places: number of digits

If places is given, BIN2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, BIN2HEX returns #NUM!

This function is Excel compatible.

HEX2BIN, BIN2OCT, BIN2DEC.

BIN2OCT(x,places)

x: a binary number, either as a string or as a number involving only the digits 0 and 1

places: number of digits

If places is given, BIN2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, BIN2OCT returns #NUM!

This function is Excel compatible.

OCT2BIN, BIN2DEC, BIN2HEX.

CONVERT(x,from,to)

x: number

from: unit (string)

to: unit (string)

CONVERT returns a conversion from one measurement system to another. x is a value in from units that is to be converted into to units.

from and to can be any of the following:

Weight and mass:

'brton' Imperial ton

'cwt' U.S. (short) hundredweight

'g' Gram

'grain' Grain

'hweight' Imperial (long) hundredweight

'LTON' Imperial ton

'sg' Slug

'shweight' U.S. (short) hundredweight

'lbm' Pound

'lcwt' Imperial (long) hundredweight

'u' U (atomic mass)

'uk_cwt' Imperial (long) hundredweight

'uk_ton' Imperial ton

'ozm' Ounce

'stone' Stone

'ton' Ton

Distance:

'm' Meter

'mi' Statute mile

'survey_mi' U.S. survey mile

'Nmi' Nautical mile

'in' Inch

'ft' Foot

'yd' Yard

'ell' English Ell

'ang' Angstrom

'ly' Light-Year

'pc' Parsec

'parsec' Parsec

'Pica' Pica Points

'Picapt' Pica Points

'picapt' Pica Points

'pica' Pica

Time:

'yr' Year

'day' Day

'hr' Hour

'mn' Minute

'sec' Second

Pressure:

'Pa' Pascal

'psi' PSI

'atm' Atmosphere

'Pa' Pascal

'mmHg' mm of Mercury

'Torr' Torr

Force:

'N' Newton

'dyn' Dyne

'pond' Pond

'lbf' Pound force

Energy:

'J' Joule

'e' Erg

'c' Thermodynamic calorie

'cal' IT calorie

'eV' Electron volt

'HPh' Horsepower-hour

'Wh' Watt-hour

'flb' Foot-pound

'BTU' BTU

Power:

'HP' Horsepower

'PS' Pferdestärke

'W' Watt

Magnetism:

'T' Tesla

'ga' Gauss

Temperature:

'C' Degree Celsius

'F' Degree Fahrenheit

'K' Kelvin

'Rank' Degree Rankine

'Reau' Degree Réaumur

Volume (liquid measure):

'tsp' Teaspoon

'tspm' Teaspoon (modern, metric)

'tbs' Tablespoon

'oz' Fluid ounce

'cup' Cup

'pt' Pint

'us_pt' U.S. pint

'uk_pt' Imperial pint (U.K.)

'qt' Quart

'uk_qt' Imperial quart

'gal' Gallon

'uk_gal' Imperial gallon

'GRT' Registered ton

'regton' Registered ton

'MTON' Measurement ton (freight ton)

'l' Liter

'L' Liter

'lt' Liter

'ang3' Cubic Angstrom

'ang^3' Cubic Angstrom

'barrel' U.S. oil barrel (bbl)

'bushel' U.S. bushel

'ft3' Cubic feet

'ft^3' Cubic feet

'in3' Cubic inch

'in^3' Cubic inch

'ly3' Cubic light-year

'ly^3' Cubic light-year

'm3' Cubic meter

'm^3' Cubic meter

'mi3' Cubic mile

'mi^3' Cubic mile

'yd3' Cubic yard

'yd^3' Cubic yard

'Nmi3' Cubic nautical mile

'Nmi^3' Cubic nautical mile

'Picapt3' Cubic Pica

'Picapt^3' Cubic Pica

'Pica3' Cubic Pica

'Pica^3' Cubic Pica

Area:

'uk_acre' International acre

'us_acre' U.S. survey/statute acre

'ang2' Square angstrom

'ang^2' Square angstrom

'ar' Are

'ha' Hectare

'in2' Square inches

'in^2' Square inches

'ly2' Square light-year

'ly^2' Square light-year

'm2' Square meter

'm^2' Square meter

'Morgen' Morgen (North German Confederation)

'mi2' Square miles

'mi^2' Square miles

'Nmi2' Square nautical miles

'Nmi^2' Square nautical miles

'Picapt2' Square Pica

'Picapt^2' Square Pica

'Pica2' Square Pica

'Pica^2' Square Pica

'yd2' Square yards

'yd^2' Square yards

Bits and Bytes:

'bit' Bit

'byte' Byte

Speed:

'admkn' Admiralty knot

'kn' knot

'm/h' Meters per hour

'm/hr' Meters per hour

'm/s' Meters per second

'm/sec' Meters per second

'mph' Miles per hour

For metric units any of the following prefixes can be used:

'Y' yotta 1E+24

'Z' zetta 1E+21

'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' deca (deka) 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

'z' zepto 1E-21

'y' yocto 1E-24

For bits and bytes any of the following prefixes can be also be used:

'Yi' yobi 2^80

'Zi' zebi 2^70

'Ei' exbi 2^60

'Pi' pebi 2^50

'Ti' tebi 2^40

'Gi' gibi 2^30

'Mi' mebi 2^20

'ki' kibi 2^10

If from and to are different types, CONVERT returns #N/A!

This function is Excel compatible (except "picapt").

This function is OpenFormula compatible.

DEC2BIN(x,places)

x: integer (− 513 < x < 512)

places: number of digits

If places is given and x is non-negative, DEC2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2BIN returns #NUM!

If places is given and x is negative, places is ignored.

If x < − 512 or x > 511, DEC2BIN returns #NUM!

This function is Excel compatible.

This function is OpenFormula compatible.

BIN2DEC, DEC2OCT, DEC2HEX.

DEC2HEX(x,places)

x: integer

places: number of digits

If places is given, DEC2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2HEX returns #NUM!

This function is Excel compatible.

HEX2DEC, DEC2BIN, DEC2OCT.

DEC2OCT(x,places)

x: integer

places: number of digits

If places is given, DEC2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, DEC2OCT returns #NUM!

This function is Excel compatible.

OCT2DEC, DEC2BIN, DEC2HEX.

DECIMAL(x,base)

x: number in base base

base: base of x, (2 ≤ base ≤ 36)

This function is OpenFormula compatible.

BASE.

DELTA(x0,x1)

x0: number

x1: number, defaults to 0

DELTA returns 1 if x1 = x0 and 0 otherwise.

If either argument is non-numeric, #VALUE! is returned.

This function is Excel compatible.

EXACT, GESTEP.

ERF(lower,upper)

lower: lower limit of the integral, defaults to 0

upper: upper limit of the integral

ERF returns 2/sqrt(π)* integral from lower to upper of exp(-t*t) dt

This function is Excel compatible if two arguments are supplied and neither is negative.

ERFC.

ERFC(x)

x: number

ERFC returns 2/sqrt(π)* integral from x to ∞ of exp(-t*t) dt

ERF.

GESTEP(x0,x1)

x0: number

x1: number, defaults to 0

GESTEP returns 1 if x1 ≤ x0 and 0 otherwise.

If either argument is non-numeric, #VALUE! is returned.

This function is Excel compatible.

DELTA.

HEX2BIN(x,places)

x: a hexadecimal number, either as a string or as a number if no A to F are needed

places: number of digits

If places is given, HEX2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, HEX2BIN returns #NUM!

This function is Excel compatible.

BIN2HEX, HEX2OCT, HEX2DEC.

HEX2DEC(x)

x: a hexadecimal number, either as a string or as a number if no A to F are needed

This function is Excel compatible.

DEC2HEX, HEX2BIN, HEX2OCT.

HEX2OCT(x,places)

x: a hexadecimal number, either as a string or as a number if no A to F are needed

places: number of digits

If places is given, HEX2OCT pads the result with zeros to achieve exactly places digits. If this is not possible, HEX2OCT returns #NUM!

This function is Excel compatible.

OCT2HEX, HEX2BIN, HEX2DEC.

HEXREP(x)

x: number

HEXREP returns a hexadecimal string representation of x.

This is a function meant for debugging. The layout of the result may change and even depend on how Gnumeric was compiled.

INVSUMINV(x0,x1,…)

x0: non-negative number

x1: non-negative number

INVSUMINV sum calculates the reciprocal (the inverse) of the sum of reciprocals (inverses) of all its arguments.

If any of the arguments is negative, #VALUE! is returned.

If any argument is zero, the result is zero.

HARMEAN.

OCT2BIN(x,places)

x: a octal number, either as a string or as a number

places: number of digits

If places is given, OCT2BIN pads the result with zeros to achieve exactly places digits. If this is not possible, OCT2BIN returns #NUM!

This function is Excel compatible.

BIN2OCT, OCT2DEC, OCT2HEX.

OCT2DEC(x)

x: a octal number, either as a string or as a number

This function is Excel compatible.

DEC2OCT, OCT2BIN, OCT2HEX.

OCT2HEX(x,places)

x: a octal number, either as a string or as a number

places: number of digits

If places is given, OCT2HEX pads the result with zeros to achieve exactly places digits. If this is not possible, OCT2HEX returns #NUM!

This function is Excel compatible.

HEX2OCT, OCT2BIN, OCT2DEC.