Solving L-L Extraction Problems with Excel Spreadsheet


  • Wittaya Teppaitoon King Mongkut’s University of Technology Thonburi • Thailand


  This work is aimed to demonstrate the use of Excel spreadsheet for solving L-L extraction problems. The key to solving the problem successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the single‐stage extraction followed by the multistage countercurrent. With stage‐to‐stage calculation, a rigorous method of computing alternately between a phase equilibrium relationship and an operating line equation, the number of stages can be determined. A proper layout of the worksheet permits the use of “copy and paste” to extend the calculation to any N stages desired.

Author Biography

Wittaya Teppaitoon, King Mongkut’s University of Technology Thonburi • Thailand

Wittaya Teppaitoon is an associate professor of chemical engineering at King Mongkut’s University of Technology Thonburi (Thailand). He holds B.Sc. and M.Sc. degrees in chemical technology from Chulalongkorn University (Thailand), and a D.Eng. degree in chemical engineering from the Institut National Polytechnique de Toulouse (France). His research interests are in gas absorption, adsorption, and air pollution control. A registered professional engineer, he has experience in designing air pollution control systems for many industries. He is also a consultant in process development and air pollution control for many industrial firms.