Difference between revisions of "Manuals/calci/CONVERT"

From ZCubes Wiki
Jump to navigation Jump to search
 
(35 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<div style="font-size:30px">'''CONVERT(n,fu,tu)'''</div><br/>
+
<div style="font-size:25px">'''CONVERT (Number,FromUnit,ToUnit,DoNotConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)'''</div><br/>
−
 
+
*<math>Number</math> is the value in <math>Fromunit</math> to change.
−
*<math>n</math> is the value in <math>fu</math>.
+
*<math>Fromunit</math> is the units for the value.
−
*<math>fu</math> is the units for the value.
+
*<math>Tounit</math>is the units for the result.  
−
*<math>tu</math>is the units for the result.  
+
**CONVERT(),Converts a number from one measurement system to another
  
 
==Description==
 
==Description==
−
This function gives the  changing the one unit system to other unit system.  
+
*This function converts one unit system to another unit system.  
−
Example:To change the length in kilometer unit to standard unit meter, Here N is the value to which we want to covert from FU to TU. Also FU and TU will accept any units which we need to give in <math>" "</math>(double quotes). <br/>
+
*Example:To change the length in kilometer unit to standard unit meter.
 +
*<math>Fromunit</math> and <math>Tounit</math> will accept any units which we need to give in " "(double quotes).  
 
This function show the result as Error:
 
This function show the result as Error:
 
#when the input value are incorrect
 
#when the input value are incorrect
−
#when the FU or TU are not exist
+
#when the <math>Fromunit</math> and <math>Tounit</math> does not exist
 
#when the units are in not same groups.
 
#when the units are in not same groups.
  
 
Unit names and indications are case-sensitive.
 
Unit names and indications are case-sensitive.
 +
  
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
 
! Weight/Mass
 
! Weight/Mass
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 48: Line 50:
 
|-
 
|-
 
! Distance
 
! Distance
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 90: Line 92:
 
|-
 
|-
 
! Time
 
! Time
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 117: Line 119:
 
|-
 
|-
 
! Pressure
 
! Pressure
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 136: Line 138:
 
|-
 
|-
 
! Force
 
! Force
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 155: Line 157:
 
|-
 
|-
 
! Energy
 
! Energy
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 192: Line 194:
 
| Watt-hour  
 
| Watt-hour  
 
|  "Wh"
 
|  "Wh"
 +
 +
|-
 +
|Kilocalorie
 +
|"kcal"
 
|}
 
|}
  
Line 197: Line 203:
 
|-
 
|-
 
! Power
 
! Power
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 212: Line 218:
 
|-
 
|-
 
! Magnetism
 
! Magnetism
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 227: Line 233:
 
|-
 
|-
 
! Temperature
 
! Temperature
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 246: Line 252:
 
|-
 
|-
 
! Liquid Measure
 
! Liquid Measure
−
! Fu or Tu
+
! Fromunit or Tounit
  
 
|-
 
|-
Line 289: Line 295:
 
|}
 
|}
  
−
Example =CONVERT(1.50, "lbm", "kg") is 0.6804
+
For Example, =CONVERT(1.50, "lbm", "kg") is 0.6804
 +
 
 +
==ZOS==
 +
*The syntax to CONVERT units in ZOS is <math>CONVERT (Number,FromUnit,ToUnit,DoNotConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)</math>
 +
**<math>Number</math> is the value in <math>Fromunit</math> to change.
 +
**<math>Fromunit</math> is the units for the value.
 +
**<math>Tounit</math>is the units for the result.
 +
*For e.g.,CONVERT(10.5..12.5..0.25,"in","ft")
 +
{{#ev:youtube|lJ5-gEU4KSA|280|center|Unit Convertion}}
  
 
==Examples==
 
==Examples==
−
 
+
{| class="wikitable"
−
{| id="TABLE3" class="SpreadSheet blue"
 
 
|- class="even"
 
|- class="even"
 
!Equation  
 
!Equation  
−
| n1
+
! Number
−
| n2
+
! Fromunit
−
| n3
+
! Tounit
−
| SUM
+
! Result
 
|- class="odd"
 
|- class="odd"
 
|CONVERT(10,"ozm","sg")
 
|CONVERT(10,"ozm","sg")
Line 305: Line 318:
 
| ozm
 
| ozm
 
| sg
 
| sg
−
| 0.019425668878
+
| 0.019425668878sg
 
|- class="even"
 
|- class="even"
 
| CONVERT(30,"lbm","kg")
 
| CONVERT(30,"lbm","kg")
Line 311: Line 324:
 
| lbm
 
| lbm
 
| kg
 
| kg
−
| 13.60776929
+
| 13.60776929Kg
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(0.5,"mi","m")
 
| CONVERT(0.5,"mi","m")
Line 317: Line 330:
 
| mi
 
| mi
 
| m
 
| m
−
| 804.6077
+
| 804.6719999999999m
 
|- class="even"
 
|- class="even"
 
| CONVERT(0.002,"km","Nmi")
 
| CONVERT(0.002,"km","Nmi")
Line 323: Line 336:
 
| km
 
| km
 
| Nmi
 
| Nmi
−
| 0.001079
+
| 0.001079Nmi
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(5,"ft","in")
 
| CONVERT(5,"ft","in")
Line 329: Line 342:
 
| ft
 
| ft
 
| in
 
| in
−
| 60
+
| 60in
 
|- class="even"
 
|- class="even"
 
|  CONVERT(7,"yd","ang")
 
|  CONVERT(7,"yd","ang")
Line 335: Line 348:
 
| yd
 
| yd
 
| ang
 
| ang
−
| 64007999999.9
+
| 64007999999.9ang
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(5,"yd","Pica")
 
| CONVERT(5,"yd","Pica")
Line 341: Line 354:
 
| yd
 
| yd
 
| Pica
 
| Pica
−
| 12959.99
+
| 12959.99Pica
 
|- class="even"
 
|- class="even"
 
| CONVERT(15,"Pa","mmHg")
 
| CONVERT(15,"Pa","mmHg")
Line 347: Line 360:
 
| Pa
 
| Pa
 
| mmHg
 
| mmHg
−
| 0.112509
+
| 0.112509mmHg
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(4, "yr","day")
 
| CONVERT(4, "yr","day")
Line 353: Line 366:
 
| yr
 
| yr
 
| day
 
| day
−
|1461
+
|1461day
 
|- class="even"
 
|- class="even"
−
| CONVERT(1.5,"mn","sec")
+
| CONVERT(1.5,"min","sec")
 
| 1.5
 
| 1.5
−
| mn
+
| min
 
| sec
 
| sec
−
| 90
+
| 90sec
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(15,"lbf","N")
 
| CONVERT(15,"lbf","N")
Line 365: Line 378:
 
| lbf
 
| lbf
 
| N
 
| N
−
|66.72333
+
|66.72333N
 
|- class="even"
 
|- class="even"
 
| CONVERT(10,"BTU","J")
 
| CONVERT(10,"BTU","J")
Line 371: Line 384:
 
| BTU
 
| BTU
 
| J
 
| J
−
|10550.581
+
|10550.581J
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(15,"W","HP")
 
| CONVERT(15,"W","HP")
Line 377: Line 390:
 
| W
 
| W
 
| HP
 
| HP
−
|0.020115301
+
|0.020115301HP
 
|- class="even"
 
|- class="even"
 
| CONVERT(45,"T","ga")
 
| CONVERT(45,"T","ga")
Line 383: Line 396:
 
| T
 
| T
 
| ga
 
| ga
−
| 450000
+
| 450000ga
 
|- class="odd"
 
|- class="odd"
−
| CONVERT(90,"F","K")
+
| CONVERT(90,"degF","degK")
 
| 90
 
| 90
−
| F
+
| degF
−
| K
+
| degK
−
| 305.3722222
+
| 305.3722222degK
 
|- class="even"
 
|- class="even"
 
| CONVERT(100,"oz","cup")
 
| CONVERT(100,"oz","cup")
Line 395: Line 408:
 
| oz
 
| oz
 
| cup
 
| cup
−
| 12.5
+
| 12.5cup
 
|- class="odd"
 
|- class="odd"
 
| CONVERT(25,"pt","qt")
 
| CONVERT(25,"pt","qt")
−
| 25
+
| 45
 
| pt
 
| pt
 
| qt
 
| qt
−
| 62.5
+
| 12.5qt
  
 
|}
 
|}
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|YSWmgN-8w3o|280|center|CONVERT}}
  
 
==See also==
 
==See also==
  
−
*[[Manuals/calci/AVERAGE| AVERAGE]]
+
*[[Manuals/calci/BIN2DEC| BIN2DEC]]
−
*[[Manuals/calci/PRODUCT| PRODUCT]]
+
*[[Manuals/calci/BIN2HEX| BIN2HEX]]
 +
*[[Manuals/calci/BIN2OCT| BIN2OCT]]
  
 
==References==
 
==References==
−
[http://en.wikipedia.org/wiki/Conversion_of_units Convert Units]
+
*[http://en.wikipedia.org/wiki/Conversion_of_units Convert Units]
 +
 
 +
 
 +
 
 +
 
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 02:55, 29 September 2021

CONVERT (Number,FromUnit,ToUnit,DoNotConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)


  • is the value in to change.
  • is the units for the value.
  • is the units for the result.
    • CONVERT(),Converts a number from one measurement system to another

Description

  • This function converts one unit system to another unit system.
  • Example:To change the length in kilometer unit to standard unit meter.
  • and will accept any units which we need to give in " "(double quotes).

This function show the result as Error:

  1. when the input value are incorrect
  2. when the and does not exist
  3. when the units are in not same groups.

Unit names and indications are case-sensitive.


Weight/Mass Fromunit or Tounit
Gram "g"
Kilo gram "kg"
Slug "sg"
Pound mass "lbm"
U(atomic mass unit) "u"
Ounce mass "ozm"
Distance Fromunit or Tounit
Meter "m"
Kilometer "km"
Statute mile "mi"
Nautical mile "Nmi"
Inch "in"
yard "yd"
Foot "ft"
Angstrom "ang"
Pica(1/72 in.) "Pica"
Time Fromunit or Tounit
Year "yr"
Day "day"
Hour "hr"
Minute "mn"
Second "sec"
Pressure Fromunit or Tounit
Pascal "Pa"
Atmosphere "atm"
mm of Mercury "mmHg"
Force Fromunit or Tounit
Newton "N"
Dyne "dyn"
Pound Force "lbf"
Energy Fromunit or Tounit
Joule "J"
Erg "e"
IT calorie "cal"
Thermodynamic calorie "c"
BTU "BTU"
Electron volt "eV"
Foot pound "flb"
Horsepower hour "HPh"
Watt-hour "Wh"
Kilocalorie "kcal"
Power Fromunit or Tounit
Horse power "HP"
Watt "W"
Magnetism Fromunit or Tounit
Gauss "ga"
Tesla "T"
Temperature Fromunit or Tounit
Kelvin "K"
Degree Celsius "C"
Degree Fahrenheit "F"
Liquid Measure Fromunit or Tounit
Liter "l"
Milliliter "ml"
Gallon "gal"
Quart "qt"
U.K.pint "uk_pt"
U.S.pint "pt"
Cup "cup"
Fluid ounce "oz"
Teaspoon "tsp"
Tablespoon "tbs"

For Example, =CONVERT(1.50, "lbm", "kg") is 0.6804

ZOS

  • The syntax to CONVERT units in ZOS is
    • is the value in to change.
    • is the units for the value.
    • is the units for the result.
  • For e.g.,CONVERT(10.5..12.5..0.25,"in","ft")
Unit Convertion

Examples

Equation Number Fromunit Tounit Result
CONVERT(10,"ozm","sg") 10 ozm sg 0.019425668878sg
CONVERT(30,"lbm","kg") 30 lbm kg 13.60776929Kg
CONVERT(0.5,"mi","m") 0.5 mi m 804.6719999999999m
CONVERT(0.002,"km","Nmi") 0.002 km Nmi 0.001079Nmi
CONVERT(5,"ft","in") 5 ft in 60in
CONVERT(7,"yd","ang") 7 yd ang 64007999999.9ang
CONVERT(5,"yd","Pica") 5 yd Pica 12959.99Pica
CONVERT(15,"Pa","mmHg") 15 Pa mmHg 0.112509mmHg
CONVERT(4, "yr","day") 4 yr day 1461day
CONVERT(1.5,"min","sec") 1.5 min sec 90sec
CONVERT(15,"lbf","N") 15 lbf N 66.72333N
CONVERT(10,"BTU","J") 10 BTU J 10550.581J
CONVERT(15,"W","HP") 15 W HP 0.020115301HP
CONVERT(45,"T","ga") 45 T ga 450000ga
CONVERT(90,"degF","degK") 90 degF degK 305.3722222degK
CONVERT(100,"oz","cup") 100 oz cup 12.5cup
CONVERT(25,"pt","qt") 45 pt qt 12.5qt

Related Videos

CONVERT

See also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CONVERT&oldid=216780"