McCabe Thiele Method for Distillation of Binary Mixtures

This app computes the number of theoretical plates,minimum reflux ratio, optimum feedplate, product recovery and flow rates for user-specified conditions. Output consists of a McCabe Thiele plot of the separation and an Output tab containg many particulars of the simulation.
Equilibrium data choices include: constant relative volatility, Raoult's law with the Antoine vapor pressure equation, experimental ethanol-water data, isopropanol-water data or user supplied experimental data. Murphree tray efficiency can also be specified.
The IPA-water data can be replaced with new data. The new data should always include 0 and 1 values for the mole fraction in the liquid and vapor with intermediate values increasing monotonically. Entries should be concentrated in region of high slope of the XY equilibrium curve. If the new data has less than 12 rows, entry of 1 in the X or Y column will signal the end of the new data. X and Y entries of the remaining rows will all change to 1. These rows will be disregarded in the computation.