- 9.0 Summary-Objectives
- 9.1 Introduction to Batch Distillation
- 9.2 Batch Distillation: Rayleigh Equation
- 9.3 Simple Binary Batch Distillation
- 9.4 Constant-Mole Batch Distillation
- 9.5 Batch Steam Distillation
- 9.6 Multistage Binary Batch Distillation
- 9.7 Multicomponent Simple Batch Distillation
- 9.8 Operating Time
- References
- Homework
- Chapter 9 Appendix A. Spreadsheet for Simple Multicomponent Batch Distillation, Constant Relative Volatility

## Chapter 9 Appendix A. Spreadsheet for Simple Multicomponent Batch Distillation, Constant Relative Volatility

The spreadsheet (Figures 9-A1 and 9-A2) does the calculations, and the VBA program (Table 9-A1) implements the counting of steps, incrementing values for the next iteration, and prints values on the spreadsheet. The calculation of the residue curve is identical to the spreadsheet in Appendix B of Chapter 8. The y_{i} values are determined from the equilibrium relationship Eq. (9-26b), and the incremental area is found from Eq. (9-28b) at every step k. The spreadsheets are written for a generic ternary system with components A, B, and C. For Example 9-3, we identify A = benzene, B = toluene, and C = cumene.

**FIGURE 9-A1** *Spreadsheet for multicomponent batch distillation with constant alpha showing numerical results*

**FIGURE 9-A2** *Spreadsheet for multicomponent batch distillation with constant alpha showing formulas*

TABLE 9-A1. *VBA program for spreadsheet in Figures 9-A1 and 9-A2*