![]() ![]() Observe that these are initial conditions of the problem, thus the chosen value may not be physically feasible, i.e do not fulfill mass balance constraints. The first step consists in annotating all the inputs of the system in the following manner (use a spreadsheet in Excel - first line and column should be the same in your spreadsheet): We want to solve such problem using the software MS Excel. Therefore, given, ,, , and, the problem of extracting the solute from water in the most profitable manner consists in maximizing L as a function of the operating conditions. Where is the solubility of the solvent in water(solvent mass / mass of water) and m is the equilibrium constant between phases. A technical analysis revealed the following constraint relations: Where Os is the solute price while in the extract, Px is the price of pure solvent. An economic analysis of the problem conducts to the following profit expression: Where Wi and W’i are solvent mass flow rates, F is water mass flow rate, xi is the solute mass per mass unit of water and yi is the solute mass per mass unit of solvent. The problem is completely described in the spreadsheet(s) and after setting it up, an add-in called Solver may be used to maximize or minimize certain characteristics of the process.įor the purpose of this post, consider the following example extracted from COQ-897 Otimização de Processos (PEQ/COPPE/UFRJ).Įxample 1.2: In the process of extraction using pure solvent, as illustrated below, one desires to find the operating condition with the best profit possible. ![]() Its functions and tools does not require the too much expertise from the user, nor programming knowledge, unless the user wants to learn advanced functionalities (VBA programming).įor optimization purposes, it is not necessary that the user possesses advanced domain of the software. It possesses a great visualization power because of its spreadsheets functionality. MS Excel is one of the most popular, widespread softwares for data analysis available in the market. Currently, there is a huge amount of such tools, and the choice of it depends on the complexity of the problem, the experience and familiarity of the engineer with the tool as well as time and money available. Most of these techniques differ in its applicability when a problem is linear or non-linear.Ī optimization problem can be solved using computational tools. How to maximize a profit or how to minimize costs of a determined process so as to make it the most profitable possible? There is a diversity of mathematical techniques which can be used to solve such problem. A common problem which many engineers face on their jobs is process optimization. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |