Home > Articles

  • Print
  • + Share This
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

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

FIGURE 9-A2

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

TABLE 9-A1

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

  • + Share This
  • 🔖 Save To Your Account