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 
  • 1
    I don't think there will be an objective standard for "best possible." In what ways is this table deficient for you? (Also, I removed the metric-spaces tag since that's actually something totally unrelated to the metric system.)2012-06-24
  • 0
    Hello Nate! It's not deficient per se - I just got a feeling it can be radically simplified, but I don't know really.2012-06-24

1 Answers 1