Premium
Using spreadsheets for studying machine design problems involving optimization
Author(s) -
KahnJetter Zella L.,
Sasser Paul A.
Publication year - 1997
Publication title -
computer applications in engineering education
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.478
H-Index - 29
eISSN - 1099-0542
pISSN - 1061-3773
DOI - 10.1002/(sici)1099-0542(1997)5:3<199::aid-cae7>3.0.co;2-8
Subject(s) - computer science , microsoft excel , software , presentation (obstetrics) , engineering drawing , programming language , industrial engineering , software engineering , operating system , engineering , medicine , radiology
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. © 1997 John Wiley & Sons, Inc. Comput Appl Eng Educ 5: 199–211, 1997