LOGO of Iloilo Science and Technology University

Burgos St, La Paz, Iloilo City, Iloilo, Philippines 5000 LOGO of

TITLE

__________________________________

A Report
Presented to
The Faculty of College of Engineering and Architecture
Iloilo Science and Technology University
Burgos St., La Paz, Iloilo City
__________________________________

In Partial Fulfillment
Of the Requirement for the Course
EMATH 3- Engineering Data Analysis

Submitted by:
Romel Leo B. Alojado

Submitted to:
Engr. Romel Leo B. Alojado

April 2023
INTRODUCTION

In modeling the process systems, optimizing the design of a model system is necessary. It is a tool
used to by chemical engineers to make a decision. Finding the optimum solution translates into
maximum profit, maximum savings, maximum efficiency which is dependent on factor such as the
raw materials, size of process units, and number of the process units. Nonetheless, the optimal
design of a process unit is subjected to constraints. One way to optimize the design of a process
system is to use the Microsoft Excel Solver. Optimization is one of the purpose of MS Excel
Solver. The MS Excess Solver uses fast processing power to analyze the data rapidly in finding
the solution to complicated problems. In using MS Excel Solver, determination of the optimal
design of a process system that are subjected to constraints is possible

Objectives:

The activity aims to:

● To demonstrate the use of MS Excel Solver in optimizing chemical engineering systems

METHODOLOGY

Usually the Excel Solver is not immediately available in Excel. It must be first installed and activated
to use it. To activate the Excel Solver, go to File menu on the upper left corner of Excel then select the
Options

Excel options box will appear then select the Add-Ins menu found on the left corner. After selecting the
Add-Ins, there will be a Manage box at the bottom. Select Excel Add-Ins then click Go.

The Add-ins window will appear then select the Solve Add-in box and click Ok.

RESULTS

DISCUSSION

CONCLUSION