- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
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 yi 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