+ Reply to Thread
Results 1 to 4 of 4

Spreadsheet with Unit Conversion Factors

Hybrid View

  1. #1
    Registered User
    Join Date
    11-29-2008
    Location
    Houston
    MS-Off Ver
    Office 2003, and 2007
    Posts
    77

    Spreadsheet with Unit Conversion Factors

    I've been looking on the internet for a spreadsheet that lists the various units of measure with conversion factors to other units. I'm not looking for the formulas, just a chart.

    has anyone found anything like this?
    Last edited by DM2; 12-20-2009 at 04:36 PM.
    Regards,
    Dan
    Real world knowledge isn't dropped from a parachute in the sky but rather acquired in tiny increments from a variety of sources including panic and curiosity.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Spreadsheet with Unit Conversion Factors

    You could create one using the CONVERT function ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Spreadsheet with Unit Conversion Factors

    If you're up for bit of copying and pasting to create your own Excel version, then you might find this link useful.

    Conversion Factor Chart
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  4. #4
    Registered User
    Join Date
    11-29-2008
    Location
    Houston
    MS-Off Ver
    Office 2003, and 2007
    Posts
    77

    Re: Spreadsheet with Unit Conversion Factors

    shg,
    I did decide to create my own table using the CONVERT function as part of the calculations but still had to write a few other formulas. Interesting to note the the CONVERT uses the "l" (lower case "L") for Liters, while NIST specifies "L" (Upper case) so as not to confuse the term with the number 1.

    Palmetto,
    The site you provided was interesting but I found something similar already in EXCEL. Still, nothing I found seemed to provide all of the solutions.

    I was hoping to find either an existing spreadsheet, or an Add In that would allow me to use a consistent formula for some conversions I need to do. I did come across "Wayne Pafko's" Unit Conversion Site that seem pretty good, but the spreadsheet doesn't permit me the flexibility to do what I need (or more likely I don't know how to implement it).

    For those interested, NIST publishes "The NIST Guide for the use of the International Systems of Units" in both a Web Based Version and a PDF Version. They also publish the "United States customary system". The National Bureau of Standards (now part of NIST), publication "Weights and Measures of the United States a brief History", which is available in both a Web Based Version and a PDF Version.

    While trying to find some information on British conventions and conversions, I came across the British trade association British Weights and Measures Association. It seems that the EU is now planning to make it illegal to mark packages with the Imperial Units of Measure, which seems have have some folks in the UK upset.

    Any way thanks for your input...always appreciated.
    Last edited by DM2; 12-20-2009 at 04:40 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1