## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

#### H. Spreadsheet Problems

H1. [VBA required] Using the spreadsheet in Appendix B of Chapter 4 or your own spreadsheet, solve the following problem. A methanol water mixture is being distilled in a distillation column with a total condenser and a partial reboiler. The pressure is 1.0 atm, and the reflux is returned as a saturated liquid. The feed rate is 250 kmol/h and is a saturated vapor. The feed is 40 mol% methanol. We desire a bottoms product that is 1.1 mol% methanol and a distillate product that is 99.3 mol% methanol. L/D = 4.5. Find the optimum feed stage, the total number of stages, D and B. Assume CMO is valid. Equilibrium data are available in Table 2-7. Use Excel to fit this data with a 6th-order polynomial. After solving the problem, ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required