Engineering With Python Rotating Header Image

Posts Tagged ‘spreadsheet’

Solving a Binary Batch Distillation – Problem Description

Reference: This is from E.M. Rosen and R. N. Adams, “A Review of Spreadsheet Usage in Chemical Engineering Calculations”, Computers and Chemical Engineering, Vol. 11, No. 6, pp. 723-736, but they took it from Henley and Rosen, “Materal and Energy Balance Computations”, Wiley, NY 1969 pg. 362.  Very similar to an earlier problem that we […]

Calculate a Four-Component ‘Flash’ – Problem Description

Reference: This is from E.M. Rosen and R. N. Adams, “A Review of Spreadsheet Usage in Chemical Engineering Calculations”, Computers and Chemical Engineering, Vol. 11, No. 6, pp. 723-736, but they took it from Henley and Seader, “Equilibrium Stage Separation Operations in Chemical Engineering”, Wiley, NY 1981 pg. 279. Problem Description: Rosen and Adams were […]

‘Graphical’ Evaluation to Calculate the Number of Transfer Units – Solution

Solve the Problem: Calculate the number of transfer units (Nog) Run the program and let’s see what the output shows.  It will show up in your IPython window. The answer we get is NOG = 3.52 transfer units.  Henley and Seader got 3.44 transfer units (obtained graphically) and Rosen and Adams calculated 3.73 units (with […]

‘Graphical’ Evaluation to Calculate the Number of Transfer Units – Problem Description

Reference: This is from E.M. Rosen and R. N. Adams, “A Review of Spreadsheet Usage in Chemical Engineering Calculations”, Computers and Chemical Engineering, Vol. 11, No. 6, pp. 723-736, but they took it from Henley and Seader, “Equilibrium Stage Separation Operations in Chemical Engineering”, Wiley, NY 1981 pg. 653.  I don’t have a copy of […]