Difference between revisions of "Documentation/SL/How Tos/Calc: Funkcija CONVERT ADD"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Created page with '__NOTOC__ == CONVERT_ADD == Converts a number from one measurement system to another. This function is only available if the '''Analysis AddIn''' is installed. === Syntax: ===…')
 
 
(6 intermediate revisions by 2 users not shown)
Line 2: Line 2:
  
 
== CONVERT_ADD ==
 
== CONVERT_ADD ==
Converts a number from one measurement system to another.
+
Pretvori število iz enega merskega sistema v drugega.
  
This function is only available if the '''Analysis AddIn''' is installed.
+
Ta funkcija je na voljo le, če je nameščen '''Dodatek za analizo (Analysis AddIn)'''.
  
=== Syntax: ===
+
=== Skladnja: ===
<tt>'''CONVERT_ADD(number; originalunits; newunits)'''</tt>
+
<tt>'''CONVERT_ADD(število; izvorneenote; noveenote)'''</tt>
: <tt>'''number'''</tt> is the number to be converted.
+
: <tt>'''število'''</tt> je število, ki ga želimo pretvoriti.
  
: <tt>'''originalunits'''</tt> and <tt>'''newunits'''</tt> are text representing the original and new measurement systems. These are case-sensitive, and must be selected from the table below. Units in '''bold''' accept an optional prefix as a decimal multiplier from the table below that.
+
: <tt>'''izvorneenote'''</tt> in <tt>'''noveenote'''</tt> so besedilo, ki predstavlja izvorni in novi merski sistem. Razlikujejo se glede na velike in male črke in morajo biti iz spodnje tabele. Enote v '''krepkem tisku''' omogočajo dodatno predpono kot desetiški multiplkator iz tabele pod njo.
  
 
{| 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'''
+
|'''lastnost'''||'''enote'''
 
|-
 
|-
|Weight||'''g''', sg, lbm, '''u''', ozm, stone, ton, grain, pweight, hweight, shweight, brton
+
|teža||'''g''', sg, lbm, '''u''', ozm, stone, ton, grain, pweight, hweight, shweight, brton
 
|-
 
|-
|length||'''m''', mi, Nmi, in, ft, yd, ang, Pica, ell, '''parsec''', '''lightyear''', survey_mi
+
|dolžina||'''m''', mi, Nmi, in, ft, yd, ang, Pica, ell, '''parsec''', '''lightyear''', survey_mi
 
|-
 
|-
|time||yr, day, hr, mn, '''sec''', '''s'''
+
|čas||yr, day, hr, mn, '''sec''', '''s'''
 
|-
 
|-
|pressure||'''Pa''', '''atm''', '''at''', '''mmHg''', Torr, psi
+
|pritisk||'''Pa''', '''atm''', '''at''', '''mmHg''', Torr, psi
 
|-
 
|-
|force||'''N''', '''dyn''', '''dy''', lbf, '''pond'''
+
|sila||'''N''', '''dyn''', '''dy''', lbf, '''pond'''
 
|-
 
|-
|energy||'''J''', '''e''', '''c''', '''cal''', '''eV''', '''ev''', HPh, '''Wh''', '''wh''', flb, BTU, btu
+
|energija||'''J''', '''e''', '''c''', '''cal''', '''eV''', '''ev''', HPh, '''Wh''', '''wh''', flb, BTU, btu
 
|-
 
|-
|power||'''W''', '''w''', HP, PS
+
|moč||'''W''', '''w''', HP, PS
 
|-
 
|-
|field strength||'''T''', '''ga'''
+
|jakost polja||'''T''', '''ga'''
 
|-
 
|-
|temperature||C, F, '''K''', '''kel''', Reau, Rank
+
|temperatura||C, F, '''K''', '''kel''', Reau, Rank
 
|-
 
|-
|volume||'''l''', '''L''', '''lt''', tsp, tbs, oz, cup, pt, us_pt, qt, gal, '''m3''', mi3, Nmi3, in3, ft3, yd3, ang3, Pica3,  
+
|prostornina||'''l''', '''L''', '''lt''', tsp, tbs, oz, cup, pt, us_pt, qt, gal, '''m3''', mi3, Nmi3, in3, ft3, yd3, ang3, Pica3,  
  
 
barrel, bushel, regton, Schooner, Middy, Glass
 
barrel, bushel, regton, Schooner, Middy, Glass
 
|-
 
|-
|area||'''m2''', mi2, Nmi2, in2, ft2, yd2, '''ang2''', Pica2, Morgen, '''ar''', acre, ha
+
|površina||'''m2''', mi2, Nmi2, in2, ft2, yd2, '''ang2''', Pica2, Morgen, '''ar''', acre, ha
 
|-
 
|-
|speed||'''m/s''', '''m/sec''', m/h, mph, kn, admkn
+
|hitrost||'''m/s''', '''m/sec''', m/h, mph, kn, admkn
 
|-
 
|-
|information||'''bit''', '''byte'''
+
|informacija||'''bit''', '''byte'''
 
|}
 
|}
  
: The above units may be preceded by a decimal multiplier. For example <tt>'''k'''</tt> (<i>kilo</i>) is the prefix for 10<sup>3</sup> - so <tt>'''km'''</tt> means <i>kilometres</i>. 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 <tt>'''km2'''</tt> means <i>square kilometres</i>, that is <i>10<sup>6</sup> square metres</i>. The following table lists the prefixes:
+
: Pred zgornjimi enotami je lahko desetiški multiplikator. Primer: <tt>'''k'''</tt> (<i>kilo</i>) je predpona za 10<sup>3</sup> - torej <tt>'''km'''</tt> pomeni <i>kilometre</i>. Če je enota površinska mera, je multiplikator kvadraten, če je prostorninska enota, je multiplikator kubičen. Primer: <tt>'''km2'''</tt> pomeni <i>kvadratne kilometre</i>, t.j. <i>10<sup>6</sup> kvadratnih metrov</i>. V naslednji tabeli so predpone:
  
 
{| 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>)
+
|'''predpona < 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>)
+
|'''predpona > 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>)
 
|}
 
|}
  
=== Example: ===
+
=== Primer: ===
 
<tt>'''CONVERT_ADD(120;"in";"ft")'''</tt>
 
<tt>'''CONVERT_ADD(120;"in";"ft")'''</tt>
: returns <tt>'''10'''</tt>, the number of feet in 120 inches.
+
: vrne <tt>'''10'''</tt>, število stopal v 120 palcih.
  
 
<tt>'''CONVERT_ADD(10;"yd";"cm")'''</tt>
 
<tt>'''CONVERT_ADD(10;"yd";"cm")'''</tt>
: returns <tt>'''914.4'''</tt>, that is 10 yards expressed in centimetres.
+
: vrne <tt>'''914,4'''</tt>, to je 10 jardov, izraženih v centimetrih.
  
=== Issues: ===
+
=== Znane težave: ===
* For historical reasons, many of the units do not use international standard abbreviations.
+
* Iz zgodovinskih razlogov številne enote ne uporabljajo standardiziranih mednarodnih okrajšav.
* This function is not generally compatible with other spreadsheets.
+
* Ta funkcija v splošnem ni združljiva z drugimi preglednicami.
  
  
{{Documentation/SeeAlso|
+
{{SeeAlso|EN|
* [[Documentation/How_Tos/Calc: CONVERT function|CONVERT]]
+
* [[Documentation/SL/How_Tos/Calc: Funkcija CONVERT|CONVERT]]
 +
* [[Documentation/SL/How_Tos/Calc: Matematične funkcije|Matematične funkcije]]
 +
* [[Documentation/SL/How_Tos/Calc: Funkcije po abecedi|Funkcije po abecedi]]
 +
* [[Documentation/SL/How_Tos/Calc: Funkcije po kategorijah|Funkcije po kategorijah]]}}
  
* [[Documentation/How_Tos/Calc: Mathematical functions|Mathematical functions]]
+
[[Category:Documentation/SL]]
 
+
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
+
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
+
[[Category: Documentation/Reference/Calc/Mathematical functions]]
+

Latest revision as of 09:53, 17 July 2018


CONVERT_ADD

Pretvori število iz enega merskega sistema v drugega.

Ta funkcija je na voljo le, če je nameščen Dodatek za analizo (Analysis AddIn).

Skladnja:

CONVERT_ADD(število; izvorneenote; noveenote)

število je število, ki ga želimo pretvoriti.
izvorneenote in noveenote so besedilo, ki predstavlja izvorni in novi merski sistem. Razlikujejo se glede na velike in male črke in morajo biti iz spodnje tabele. Enote v krepkem tisku omogočajo dodatno predpono kot desetiški multiplkator iz tabele pod njo.
lastnost enote
teža g, sg, lbm, u, ozm, stone, ton, grain, pweight, hweight, shweight, brton
dolžina m, mi, Nmi, in, ft, yd, ang, Pica, ell, parsec, lightyear, survey_mi
čas yr, day, hr, mn, sec, s
pritisk Pa, atm, at, mmHg, Torr, psi
sila N, dyn, dy, lbf, pond
energija J, e, c, cal, eV, ev, HPh, Wh, wh, flb, BTU, btu
moč W, w, HP, PS
jakost polja T, ga
temperatura C, F, K, kel, Reau, Rank
prostornina l, L, lt, tsp, tbs, oz, cup, pt, us_pt, qt, gal, m3, mi3, Nmi3, in3, ft3, yd3, ang3, Pica3,

barrel, bushel, regton, Schooner, Middy, Glass

površina m2, mi2, Nmi2, in2, ft2, yd2, ang2, Pica2, Morgen, ar, acre, ha
hitrost m/s, m/sec, m/h, mph, kn, admkn
informacija bit, byte
Pred zgornjimi enotami je lahko desetiški multiplikator. Primer: k (kilo) je predpona za 103 - torej km pomeni kilometre. Če je enota površinska mera, je multiplikator kvadraten, če je prostorninska enota, je multiplikator kubičen. Primer: km2 pomeni kvadratne kilometre, t.j. 106 kvadratnih metrov. V naslednji tabeli so predpone:
predpona < 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)
predpona > 1 e (101), h (102), k (103), M 106), G (109), T (1012), P (1015), E (1018), Z (1021), Y (1024)

Primer:

CONVERT_ADD(120;"in";"ft")

vrne 10, število stopal v 120 palcih.

CONVERT_ADD(10;"yd";"cm")

vrne 914,4, to je 10 jardov, izraženih v centimetrih.

Znane težave:

  • Iz zgodovinskih razlogov številne enote ne uporabljajo standardiziranih mednarodnih okrajšav.
  • Ta funkcija v splošnem ni združljiva z drugimi preglednicami.




See Also
Personal tools