1
$\begingroup$

Is there a better, smarter way of structuring a metric vs imperial conversion table than the one below?

I.e. for a spreadsheet for calculating storage / shipping costs for products whose suppliers use different unit systems.

Thanks in advance!

Length

Metric                Imperial  1 mm                  0.03937 in 1 cm        10 mm     0.3937 in 1 m         100 cm    1.0936 yd  Imperial              Metric  1 in                  2.54 cm 1 ft        12 in     0.3048 m 1 yd        3 ft      0.9144 m 

Volume

Metric                Imperial  1 cm3                 0.0610 in3 1 dm3     1,000 cm3   0.0353 ft3 1 m3      1,000 dm3   1.3080 yd3 1 l       1 dm3       1.76 pt  Imperial              Metric  1 in3                 16.387 cm3 1 ft3     1,728 in3   0.0283 m3 1 fl oz               28.413 ml 1 pt      20 fl oz    0.5683 l  USA measure                               Metric  1 fl oz               1.0408 uk fl oz     29.574 ml 1 pint (16 fl oz)     0.8327 uk pt        0.4731 l 1 gallon              0.8327 uk gal       3.7854 l 

Mass

Metric                Imperial  1 mg                  0.0154 grain 1 g      1,000 mg     0.0353 oz 1 kg     1,000 g      2.2046 lb  Imperial              Metric  1 oz     437.5 grain  28.35 g 1 lb     16 oz        0.4536 kg 1 stone  14 lb        6.3503 kg 1 cwt    112 lb       50.802 kg 

Edit

Length:  1 m = N in / N ft / N yd Volume:  1 m3 = N in3 / N ft3 / N yd3 Weight:  1 kg = N oz / N lb 
  • 0
    Hello N$a$te! It's not deficient per se - I just got a feeling it can $b$e radically simplified, but I don't know really.2012-06-24

1 Answers 1

1

Of course, you could always add more conversions.

It is probably easier if you put the numbers in one column and the unit in another-it will simplify searching.

A table is one thing, a way of using it is another. Do you expect people to use this or some software to automatically look up entries in various units and convert to some standard (presumably metric)? I would make the right column the units you use for billing, which would only be one of each type. For example: kg, no grams. I wouldn't limit the left column to imperial, but would add 1000 g=1 kg. How do you distinguish between the US version and the Imperial version of measures, as they have the same name-you acknowledge this, but again how does the user know?

  • 0
    True indeed! I'll figure it out though. Thanks man!2012-06-24