Simplify computer-aided engineering with scientific-to-engineering conversion
Edited by Bill Travis
By Alexander Bell, Infosoft International, Rego Park, NY -- EDN, September 30, 2004
The simple yet useful formula in this Design Idea enables conversion from scientific format (for example,
2.2–9), which is typical for CAE (computer-aided-engineering), double-precision output values, into "human-friendly" engineering format (for example, 2.2 nF). The engineering format is more suitable for bills of material and other electrical and electronic-engineering documents and specifications.
The formula is rather straightforward. It takes two parameters. The first is the numerical value, and the second one specifies the unit of measurement—ohms, farads, or henries, for example. Alternatively, it could be of any random text, including an empty string, "." The formula calculates the mantissa/order of magnitude and returns the text string, formatted in compliance with commonly accepted electrical-engineering practice. Listing 1 shows details of the formula. The tricky part of the formula is the conversion to a decimal type after the formula calculates the ratio of two log values (Reference 1). This step ensures the correct order-of-magnitude calculations in cases in which the mantissa of the input value is close or equal to one.
The formula is in VB; you could use it in any VB/VBA-backed software applications. In this example, the function is in a code module of an MS Excel file (Figure 1). You could also use it as an Excel Add-In (.xla) or a "pure-VB," compiled-DLL component. Click here to download a zip file containing both Listing 1 and the Excel file. The input numerical value in this formula has double-precision accuracy, and its range spans from approximately –1.79308 to +1.79308, which is sufficient for any practical engineering calculations. Note that the maximum value is even bigger than the famous "googol," which is represented by 100 digits.
| Reference |
 Check out our Best of Design Ideas section! |
-
Hello, Stuart,
A good point: it is just a typo. In the original article the value was presented in a MS Excel format as 1.79E308, which translates into 1.79*10^308.
Many Thanks for your kind attention.
Regards,
Alex Bell
Alex Bell - 2005-6-3 18:36:00 PST -
Quite useful. Hope there'll be more EE type excel macros like this in the future.
Alex Wong - 2004-17-12 12:54:00 PST -
I like this idea. However, unless my trusty HP32S II has a problem 1.79 to the 308th power is 7.56E77 and that is a lot smaller than a googol!
Stuart R. Michaels - 2004-5-10 20:36:00 PDT
