1 / 11

Unit Conversion

Unit Conversion. And the Convert Function. Issues. Converting a measurement from one unit to another. E.g. tablespoon to cup Different measurement systems, e .g . American, Metric, British, Imperial, and etc. History. C ustomary units of measure (regional) Anglo-Saxon and Roman

artie
Download Presentation

Unit Conversion

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Unit Conversion And the Convert Function

  2. Issues • Converting a measurement from one unit to another. E.g. tablespoon to cup • Different measurement systems, e.g. American, Metric, British, Imperial, and etc.

  3. History • Customary units of measure (regional) • Anglo-Saxon and Roman • English Units (based for the US system) • Metric (1799) • Imperial System (1824) • What is 1 chain? What is a stone? • International System of Units (1970s) • Example: 1 Cupcomes in many sizes.

  4. Convert Function • Convert Function in Excel can convert measurement (between the same measurement category) • =CONVERT(number,from_unit,to_unit) • =CONVERT(100, “tbs”, “cup”)Converts 100 Tablespoons in Cups. • 100: the amount (value) • “tbs”: Unit ID for Tablespoons • “cup”: Unit ID for Cups

  5. Step-by-Step

  6. Function Arguments

  7. Straight Formula Method

  8. Convert Unit ID • Weight and Mass • Gram "g" • Pound mass "lbm" • Ounce mass "ozm" • Temperature • Degree Celsius "C" • Degree Fahrenheit "F" • Liquid Measure • Teaspoon "tsp" • Tablespoon "tbs" • Fluid ounce "oz" • Cup "cup" • U.S. pint "pt" • Quart "qt" • Gallon "gal" • Liter "l"

  9. How to Enter a Fraction in Excel • If you enter 1/4 in a cell, you may get 4-Jan as in January 4th. • Excel is trying to be a smart ***. • Enter the value with 0 (zero) followed by a blank space, and then enter the value. • e. g. 01/4 (don’t forget the blank space)

  10. Challenges • Converting between different measurement categories. • E.g. From 1 Lbs of flour to cups • Find the conversion factor • Wolfram|Alpha • E.g. ask “1 lbs of flour in cups”  26 floz • *26 will give how many flozfor 1 lbs of flour • 1 floz = 1/8 cups (or 0.125) • So, =10*26*0.125will give how many cups for 10 lbs of flour.

  11. Conversion Online Tools • OnlineConversion.com • GourmetSleuth.com • Cooks.com

More Related