Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |