Last update: 30/10/2016
1. NCE Library Calc Extension
NCE Extension for Openoffice / Libreoffice Calc provides a set of functions derived from NCE Library, directly usable in the spreadsheet to greatly simplify the construction of complicate sheets for process engineering calculations.
The easiest way to inspect extension's capabilities is to have a look at the example file.
The extension can be downloaded from Openoffice and Libreoffice extensions repositories. The most updated release is hosted on Sourceforge
Download from Libreoffice Extensions repository
2. NCE Units Calc Extension
NCE-Units Extension for Openoffice / Libreoffice Calc provides a function that converts quantities expressed in various systems of measurement to their equivalents in other systems of measurement.
NCE-Units is a part of Numerics for Chemical Engineering library derived from "Units in Java", the Java development of the amazing program "GNU Units".
The extension can be downloaded from Openoffice
and Libreoffice extensions repositories. The most updated release is hosted on Sourceforge
Download
from Libreoffice Extensions repository Syntax: NCEUNITS(value;
youHave; youWant)
value is the numerical value that has to be converted youHave is a
string representing actual measuring units youWant is a
string representing target measuring units Examples:
Basic
example, select a cell and write:
NCEUNITS(1.0; “kg”; “lb”)
returns
2.205, that is the conversion factor to convert kg to lb.
In
the following example, cell A1 contains the value to be converted,
cell B1 the original units and cell C1 the target units
NCEUNITS(A1; B1; C1)
returns 77.0, because a temperature of 25 degrees Celsius corresponds to 77.0 degrees Fahrenheit (F = C * 1.8 + 32)
NCEUNITS(A1; B2; C2)
returns 45.0, because 25 degrees Celsius correspond to 45.0 degrees Fahrenheit (F = C * 1.8)
NCEUNITS(A1; B1; C2)
returns #VALUE!, because of a conformability error: cannot convert tempC to degF
Additional help:
For further details, consult the following home pages: