Difference between revisions of "Documentation/How Tos/Calc: CONVERT ADD function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (talk | contribs) m (Robot: Automated text replacement %s) |
|||
| Line 14: | Line 14: | ||
{| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | ||
|- | |- | ||
| − | | | + | |property'''||units''' |
|- | |- | ||
|Weight||g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight | |Weight||g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight | ||
| Line 47: | Line 47: | ||
{| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | {| border="1" cellpadding="5" cellspacing="0" style="margin: 1em auto 1em auto" | ||
|- | |- | ||
| − | | | + | |prefix < 1'''||y (10<sup>-24</sup>), z (10<sup>-21</sup>), a (10<sup>-18</sup>), f (10<sup>-15</sup>), p (10<sup>-12</sup>), n (10<sup>-9</sup>), u (10<sup>-6</sup>), m (10<sup>-3</sup>), c (10<sup>-2</sup>), d (10<sup>-1</sup>) |
|- | |- | ||
| − | | | + | |prefix > 1'''|| e (10<sup>1</sup>), h (10<sup>2</sup>), k (10<sup>3</sup>), M 10<sup>6</sup>), G (10<sup>9</sup>), T (10<sup>12</sup>), P (10<sup>15</sup>), E (10<sup>18</sup>), Z (10<sup>21</sup>), Y (10<sup>24</sup>) |
|} | |} | ||
| Line 59: | Line 59: | ||
: returns <tt>'''914.4'''</tt>, that is 10 yards expressed in centimetres. | : returns <tt>'''914.4'''</tt>, that is 10 yards expressed in centimetres. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | + | * [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]]''' | |
| − | + | * [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]''' | |
| − | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
| − | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
=== Issues: === | === Issues: === | ||
* For historical reasons, many of the units do not use international standard abbreviations. | * For historical reasons, many of the units do not use international standard abbreviations. | ||
* This function is not generally compatible with other spreadsheets. | * This function is not generally compatible with other spreadsheets. | ||
Revision as of 13:36, 25 February 2009
CONVERT_ADD
Converts a number from one measurement system to another.
This function is only available if the Analysis AddIn is installed.
Syntax:
CONVERT_ADD(number; originalunits; newunits)
- number is the number to be converted.
- originalunits and newunits are text representing the original and new measurement systems. These are case-sensitive, and must be selected from the table below. An optional prefix indicates a decimal multiplier from the table below that.
| property | units |
| Weight | g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight |
| length | m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec |
| time | yr, day, hr, mn, sec |
| pressure | Pa, atm, mmHg, Torr, psi |
| force | N, dyn, pond |
| energy | J, e, c, cal, eV, HPh, Wh, BTU |
| power | W, HP, PS |
| field strength | T, ga |
| temperature | C, F, K, Reau, Rank |
| volume | l, tsp, tbs, oz, cup, pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3, barrel, bushel, regton, Schooner,
Middy, Glass |
| area | m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha |
| speed | m/s, m/h, mph, kn, admkn |
- The above units may be preceded by a decimal multiplier. For example k (kilo) is the prefix for 103 - so km means kilometres. If the unit is a measure of area the multiplier is squared, and if it is a measure of volume the multiplier is cubed. For example km2 means square kilometres, that is 106 square metres. The following table lists the prefixes:
| prefix < 1 | y (10-24), z (10-21), a (10-18), f (10-15), p (10-12), n (10-9), u (10-6), m (10-3), c (10-2), d (10-1) |
| prefix > 1 | e (101), h (102), k (103), M 106), G (109), T (1012), P (1015), E (1018), Z (1021), Y (1024) |
Example:
CONVERT_ADD(120;"in";"ft")
- returns 10, the number of feet in 120 inches.
CONVERT_ADD(10;"yd";"cm")
- returns 914.4, that is 10 yards expressed in centimetres.
Template:Documentation/SeeAlso
Issues:
- For historical reasons, many of the units do not use international standard abbreviations.
- This function is not generally compatible with other spreadsheets.
