Chapter 15 Appendix. Spreadsheet for Example 15-6

The spreadsheet below solves Example 15-6. The spreadsheet is shown first with the formulas. To estimate D_W-NH3 from the Chapman-Enskog equation, k_BT/ε_AB was calculated on the spreadsheet, and then the value of the collision integral Ω_D was determined by a hand calculation doing a linear interpolation on Table 15-2. After the value of the collision integral was inserted into the spreadsheet, the spreadsheet was run again. The spreadsheet could be totally automated by inputting the values for collision integrals from Table 15-2 and doing the linear interpolation on the spreadsheet.

Appendix. Spreadsheet for Example 15-6

[View full size image]