Microsoft® Excel as an Engineering Optimization Tool 942332

Optimization techniques are powerful tools to aid in the design of complex engineering systems. While these techniques contribute directly to engineering design, they also help manage the compromise/trade-off phase inevitable in the design of today's complex automotive systems. Additionally, optimization provides the organization the opportunity and mechanism to determine its cost/design goals at the inception of the engineering process. While this paper will focus on the use of Microsoft® Excel as an engineering optimization tool, the techniques discussed apply to any spreadsheet with optimization macros and the capability to call external subroutines.


Subscribers can view annotate, and download all of SAE's content. Learn More »


Members save up to 43% off list price.
Login to see discount.
Special Offer: With TechSelect, you decide what SAE Technical Papers you need, when you need them, and how much you want to pay.