✦ LIBER ✦

Using spreadsheets for studying machine design problems involving optimization

✍ Scribed by Zella L. Kahn-Jetter; Paul A. Sasser

Publisher: John Wiley and Sons
Year: 1997
Tongue: English
Weight: 305 KB
Volume: 5
Category: Article
ISSN: 1061-3773
DOI: 10.1002/(sici)1099-0542(1997)5:3<199::aid-cae7>3.0.co;2-8

No coin nor oath required. For personal study only.

✦ Synopsis

Advanced machine design problems involving optimization concepts may be analyzed using spreadsheets. In this article, linear and nonlinear examples were modeled on current versions of Microsoft Excel, QuattroPro for Windows, and Lotus 1-2-3. A comparison of data entering and presentation of solutions is discussed. It is shown that although all three software packages solve the problems successfully, Excel appears to be best suited for these types of problems.