ChemSOF

Tips & Tricks for Chemical Engineers

Estimating Binary Interaction Parameter by Regression

Wilson equation is commonly used to predict non ideality in binary mixture vapor liquid equilibrium. This article shows how to estimate binary interaction parameters used in wilson equation from experimental data by regression in excel spreadsheet.

Determine binary interaction parameters used in wilson equation for a mixture of acetone and chloroform from T x-y experimental data available at 101.33 kPa.

Heat Loss from Insulated Pipe

Heat loss/gain takes place from a pipe carrying hotter/ colder fluid than ambient temperature. Insulation reduces the heat loss to surroundings. Heat loss depends upon number of factors like insulation thickness, ambient temperature, wind speed etc. This article shows how to calculate heat loss from an insulated pipe and a bare pipe to surroundings.

A 3" Carbon steel pipe is carrying hot oil at 180°C and insulated with 50 mm thick calcium silicate insulation. Insulation is cladded with a sheet with surace emissivity of 0.9. Ambient temperature is 28°C and wind velocity is 3.5 m/s. Calculate surface temperature and heat loss from insulated and bare pipe.

Pipe Network Analysis

Pipe Network Analysis determine the flow rates and pressure drops in the individual sections of a hydraulic network. Hardy Cross Method is the oldest and probably best known solution method for pipe networks. In this method, each loop correction is determined independently of other loops. Epp and Fowler (1970) developed a more efficient approach by simultaneously computing corrections for all loops. This article illustrates use of Simultaneous Loop Flow Adjustment Algorithm in modelling pipe network analysis in excel spreadsheet.

A water supply distribution system is shown in the figure below. All pipes are cast iron with lengths and diameters as provided in table below. Perform pipe network analysis and calculate water flow in all branches.

Binary Batch Distillation

Batch distillation is widely used in chemical processing industries when high value added, low volume chemicals must be separated. This article shows how to model and solve a multi-stage binary batch distillation problem in excel.

The 50 mol feed comprising 70% mols of A and 30% mols of B is to be distilled in the multi-stage batch distillation with 5 equilibrium stages on top of the reboiler (still pot). Reflux is returned to the column as a saturated liquid with the constant reflux ratio of 1.5. Relative volatility of A is 1.8. It is desired to reduce the mols of A in still to 10%. Determine average distillate composition, final amount of liquid in still pot and total amount of distillate collected.

A material balance is done across the column and following relationship commonly known as Rayleigh Equation is derived.

Linear Programming in Excel

Linear Programming is a widely used mathematical technique designed to help managers and engineers in planning and decision making relative to resource allocation. Linear programming (LP) model essentially consists of 3 components.

• Decision Variables
• Objective function
• Constraints