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
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?