Excel for Chemical Engineering

 

DISTILLATION: NONREACTIVE SYSTEM USING EXCEL

This problem is intended to be an example of how Excel can be used in case of involving two units of distillation. This problem is intended to find the percentage recovery of Oxygen in the end oxygen-rich product. Percentage recovery is used when the purification of a compound is utilized. It is the ratio between the pure compound and the initial compound.

Here it is given that the air is admitted with the composition as shown in fig and admitted at 100 mol/s rates. It is required to find the oxygen recovery percentage in-stream O.

The following steps will be employed to calculate:

1.    Calculate the Degrees of Freedom to check whether the given information is enough to solve the problem and can the problem be solved. If DOF is equal to 0 then the problem can be proceeded to solve.

2.   Frame DOF for unit 1, 2 and overall indicated by the red lines.

3.   Frame the component and overall balance equations.

4.   Create a Matrices D, F using the component balance equations and determine its determinant value.

5.   If only the determinant value is approx. 0 a square matrix has an inverse.

6.   Now find the inverse which can be multiplied with matrices E and G to determine the unknowns, B, C, N, and O.

7.   Multiply the inverses with E and G to determine the unknowns.

8.   The recovery is calculated as the difference between the oxygen in N and oxygen in feed A divided by oxygen in A.


9.   It can also be calculated as the oxygen in O stream divided by the Oxygen in A.

 

 

 

 

 

 

Reference:

Stoichiometry and Process Calculations by K.V. Narayanan and B. Lakshmikutty.

Comments

  1. Lea Paige MatteoJanuary 28, 2022 at 11:26 AM

    How Mr Benjamin Lee service granted me a loan!!!

    Hello everyone, I'm Lea Paige Matteo from Zurich Switzerland and want to use this medium to express gratitude to Mr Benjamin service for fulfilling his promise by granting me a loan, I was stuck in a financial situation and needed to refinance and pay my bills as well as start up a Business. I tried seeking for loans from various loan firms both private and corporate organizations but never succeeded and most banks declined my credit request. But as God would have it, I was introduced by a friend named Lisa Rice to this funding service and undergone the due process of obtaining a loan from the company, to my greatest surprise within 5 working days just like my friend Lisa, I was also granted a loan of $216,000.00 So my advice to everyone who desires a loan, "if you must contact any firm with reference to securing a loan online with low interest rate of 1.9% rate and better repayment plans/schedule, please contact this funding service. Besides, he doesn't know that I am doing this but due to the joy in me, I'm so happy and wish to let people know more about this great company who truly gives out loans, it is my prayer that GOD should bless them more as they put smiles on peoples faces. You can contact them via email on { 247officedept@gmail.com} or Text through Whatsapp +1-989 394 3740.

    ReplyDelete

Post a Comment

Popular posts from this blog

Excel for Chemical Engineering

Image
Excel for Chemical Engineering Material balance for a non-reactive system: Material balance is based on the law of conservation of mass that states that mass can neither be created nor destroyed but can undergo phase and chemical changes. In precise,  Material Input + Material Generated = Material Output + material Accumulated in the system + Material consumed. Mass balance for a non-reactive system can be generally expressed as Input = Output + Accumulation where generation and consumption are zero. The above equation becomes Input = Output for steady-state processes where the accumulation tends to zero. Identifying the tie element, the component that enters and leaves the system without any change can be useful to solve the equations surrounding the system. Mass balance is generally carried out in 2 levels: Overall balance and Component balance. Overall balance is the material balance for the entire system under study while the component balance is carried out for an individual c...
Read more

Boiling

Image
  BOILING Evaporation is one of the major heat transfer operations for concentrating solutions by boiling off the solvent. So, boiling can be considered as the backbone for evaporation. Boiling is a phenomenon where the liquid is transitioned to its vapor phase at its boiling point, the temperature at which the vapor pressure is equal to the pressure exerted on the liquid by the surrounding atmosphere. Boiling occurs at the solid-liquid interface where the liquid in contact with a surface whose temperature is greater than the saturation temperature of the liquid itself. The substantial amount of heat/energy that is required to vaporize 1kg of a liquid is called the latent heat of vaporization. When spoken of boiling, a simple household setup of water on a pan over a stove is what we generally live up to. This is a great example to understand pool boiling, where the heating surface is submerged in a pool of liquid. Considering the above setup, now the heat flux for boiling wil...
Read more

Basics of Heat Transfer

  BASICS OF HEAT TRANSFER What is Heat transfer? We know through thermodynamics that energy can exist in many forms. One such form of energy is heat. The energy that is transferred between systems as a result of the temperature gradient is called heat. Heat transfer is the science that indicates the rate at which this heat is transferred between the systems. Imagine holding a bottle of water in a refrigerator. There is going to be energy transfer between the bottle and the cold air inside. The energy transfer takes place until the temperatures of the cold air and the water is the same. Therefore, we can conclude that heat transfer occurs until equilibrium is obtained. Heat is transferred from higher temperature to lower temperature. Here comes thermodynamics that can tell us about the amount of heat to be transferred to effect the change in the state according to the law of conservation of energy. But the amount is not everything that we need. Consider a scenario where we pur...
Read more