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.