Improve Convert function in Excel
 

I recently developed a unit converter that can handle complex strings and
biased units using Excel. It can evaluate formulas in a "free-form" way and
yet still checks to ensure that conversions are proper.

Example: Convert from "ton" * "knot^2" per "minute" to "horsepower" to
determine the power needed to bring a 12,000 ton ship from rest to 15 knots
speed in 10 minutes (neglecting drag)...

(1/2 * (mass * velocity^2)/time = power)

Go to:

http://ourworld.cs.com/MJVanVoorhis/Units/unitsX7nt.xls

and enter the values.
Enter:
"=1/2*(12000*15^2)/10" in the "from value" field,
"(ton*knot^2)/min" in the "from units" field,
"hp" in the "to units" field and
press the "convert" button.

The "from value" will be 1.35e5 and the converted value will be 726
horsepower.

If any units are inappropriate for this conversion, the spreadsheet will
provide an error message. This converter is extremely powerful and would
improve Excel. I would like to discuss ways to incorporate this proprietary
algorithm into Excel's "convert" function. The number of conversion
possibilities is endless.

Sincerely,

Mike Van Voorhis
10424 S Tarali Ct
South Jordan, UT 84095
801 641-5638


--
Mike VV