A distillation column will be designed to separate mixture of Ethanol, Water and Dimethylformamide mixture at atmospheric pressure. The saturated liquid feed containing $2\%$ Ethanol, $44\%$ Water and balanced with Dimethylformamide is fed to the column at a flow rate of $100$kmo$\frac{l}{h}\mathrm{.}99\mathrm{.}7\%$ of the water is recovered in distillate and $99\mathrm{.}5\%$ of dimethylformamide in bottom.

Calculate:

a$)$ flow rates of top and bottom products

b$)$ top and bottom temperature of tower

c$)$ minimum number of stages for total reflux

d$)$ minimum reflux ratio and number of theoretical stages at $R=1\mathrm{.}8R_{\text{m}\text{i}\text{n}}$

e$)$ location of feed tray

Don't forget to include the Excel solution file when submitting the answers.

$($not screenshot!$)$

$\backslash$table$[[$Antoine constants,A$,$B$,$C$],[$Ethanol$,5\mathrm{.}37,1670\mathrm{.}4,-40\mathrm{.}19],[$Water$,8\mathrm{.}11,1750\mathrm{.}3,235],[$Dimethylformamide$,3\mathrm{.}93,1337\mathrm{.}7,-22\mathrm{.}65]]$

$[P_v]=mmHg,[T]=K$