Difference between revisions of "Manuals/calci/CONVERTCORE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div style="font-size:30px">'''CONVERTCORE (Number,FromUnit,ToUnit,DoNotTryConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)'''</div><br/> *<math>Number</math> is the v...")
 
Line 297: Line 297:
  
 
==Examples==
 
==Examples==
 +
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
!Equation
 +
! Number
 +
! Fromunit
 +
! Tounit
 +
! Result
 +
|- class="odd"
 +
|CONVERTCORE(10,"ozm","sg")
 +
| 10
 +
| ozm
 +
| sg
 +
| 0.019425668878
 +
|- class="even"
 +
| CONVERTCORE(30,"lbm","kg")
 +
| 30
 +
| lbm
 +
| kg
 +
| 13.60776929
 +
|- class="odd"
 +
| CONVERTCORE(0.5,"mi","m")
 +
| 0.5                       
 +
| mi
 +
| m
 +
| 804.6077
 +
|- class="even"
 +
| CONVERTCORE(0.002,"km","Nmi")
 +
| 0.002
 +
| km
 +
| Nmi
 +
| 0.001079
 +
|- class="odd"
 +
| CONVERTCORE(5,"ft","in")
 +
| 5
 +
| ft
 +
| in
 +
| 60
 +
|- class="even"
 +
|  CONVERTCORE(7,"yd","ang")
 +
| 7
 +
| yd
 +
| ang
 +
| 64007999999.9
 +
|- class="odd"
 +
| CONVERTCORE(5,"yd","Pica")
 +
| 5
 +
| yd
 +
| Pica
 +
| 12959.99
 +
|- class="even"
 +
| CONVERTCORE(15,"Pa","mmHg")
 +
| 15
 +
| Pa
 +
| mmHg
 +
| 0.112509
 +
|- class="odd"
 +
| CONVERTCORE(4, "yr","day")
 +
| 4
 +
| yr
 +
| day
 +
|1461
 +
|- class="even"
 +
| CONVERTCORE(1.5,"mn","sec")
 +
| 1.5
 +
| mn
 +
| sec
 +
| 90
 +
|- class="odd"
 +
| CONVERTCORE(15,"lbf","N")
 +
| 15
 +
| lbf
 +
| N
 +
|66.72333
 +
|- class="even"
 +
| CONVERTCORE(10,"BTU","J")
 +
| 10
 +
| BTU
 +
| J
 +
|10550.581
 +
|- class="odd"
 +
| CONVERTCORE(15,"W","HP")
 +
| 15
 +
| W
 +
| HP
 +
|0.020115301
 +
|- class="even"
 +
| CONVERTCORE(45,"T","ga")
 +
| 45
 +
| T
 +
| ga
 +
| 450000
 +
|- class="odd"
 +
| CONVERTCORE(90,"F","K")
 +
| 90
 +
| F
 +
| K
 +
| 305.3722222
 +
|- class="even"
 +
| CONVERTCORE(100,"oz","cup")
 +
| 100
 +
| oz
 +
| cup
 +
| 12.5
 +
|- class="odd"
 +
| CONVERTCORE(25,"pt","qt")
 +
| 45
 +
| pt
 +
| qt
 +
| 22.5
  
 +
|}
  
 
==See Also==
 
==See Also==

Revision as of 14:03, 20 March 2018

CONVERTCORE (Number,FromUnit,ToUnit,DoNotTryConvertUsingEquivalents,MatchAllOnLeft,MatchAllOnRight)


  • is the value in to change.
  • is the units for the value.
  • is the units for the result.

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"


Examples

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

See Also

References

Convert Units



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