SolutionSupp7.xlsx

	A	B	C	D	E	F	G	H
1	This spreadsheet is to be a solution to Supplemental Problem #7. Model parameters are in GREEN.
2	Reference data are in BLUE. Solve the problem before setting up the spreadsheet. Points will be
3	deducted for double-entry of data or parameters, use of circular references, and improper use
4	of absolute and relative references. There are occasions to use iteration. This spreadsheet is
5	not one of them.
6	Name: Erik Spjut
7	Section: Solution
8
9
10
11
12
13
14
15
16
17
18
19	fA	20.00%			Split Fractions wrt Product in Column
20	XS B in Feed	30.00%			tA	0	<=Cannot be changed
21					tB	0.5
22	x	50	kmol/s		tC	1
23	fB	0.625			tI	0.5
24
25
26		ni	Process Feed	Reactor Feed	Column Feed	Bottoms/Recycle	Product
27	nA (kmol/s)	-2	100	500	400	400	0	<=Cannot be changed
28	nB (kmol/s)	-3	195	240	90	45	45
29	nC (kmol/s)	4	0	0	200	0	200
30	nI (kmol/s)	0	5	10	10	5	5
31	n (kmol/s)		300	750	700	450	250
32	xA		33.33%	66.67%	57.14%	88.89%	0.00%	<=Cannot be changed
33	xB		65.00%	32.00%	12.86%	10.00%	18.00%
34	xC		0.00%	0.00%	28.57%	0.00%	80.00%
35	xI		1.67%	1.33%	1.43%	1.11%	2.00%
36	∑xi (double check)		100.00%	100.00%	100.00%	100.00%	100.00%
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100