Design Calculations of the TXY Data and drawing of the Equilibrium Curve (X-Y) Diagram of a Binary Distillation Column using Excel

摘要

The importance of the equilibrium (x-y) curve in the design of a binary distillation column wasexplained. The two ways to do distillation design calculations of a binary distillation column by McCabe Thielemethod were considered. One is the graphical method and other way is by using any other commercialsimulation software. The Ms Excel software that can easily be gotten and not so expensive was used in thisstudy. All the two ways were used to calculate the TXY data and draw or plot the equilibrium (x-y) curve. Thestudy showed that the TXY data obtained are the same when approximated to 2 decimal places for the two waysto do distillation design calculations of a binary distillation column by McCabe Thiele method. The equilibrium(x-y) curve is also the same in shape and size, when the same scale was used. The study also showed that thecalculation and the graphical method using hand is time and energy consuming whereas the calculations andthe plot using Ms Excel is less time and energy consuming. Another problem was observed when a similar newdesign is to be carried out. The calculations and drawing will be started all over again with the hand methodbut it was not so with MS Excel. As you input the necessary values, all other values will change as well since theformulars are already stored in the MS Excel memory.