Posts

Showing posts with the label Excel

Excel for Chemical Engineering

Image
  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...

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...