ABSTRACT

The reader needs to become familiar with the

following topics regarding Excel software, using the

related literature:

. Modeling and spreadsheets

. Analyzing the Solver

. Sensitivity analysis using Excel tables

. Controls and dialog boxes to input data

. Graphics to get the results

. Visual Basic as a programming language

Computer-aided design is based on computer simu-

lators, whereas computer simulators are based on

process modeling. The basic terms, such as modeling,

simulation, and design, are defined in Table 5.1. Mod-

eling is the procedure of translating the physical laws

of a process to mathematical equations to analyze or

design the process. Simulation is the appropriate soft-

ware, which predicts the real performance of a pro-

cess. It is based on mathematical modeling plus the

appropriate graphics interface in a computer environ-

ment. Design is a procedure of sizing and rating a

process in order to achieve specific goals, such as

economic production, product quality, and protection

of the environment.