Page 353 - Water and wastewater engineering

A B C D E F G
1 Example 5-3 IX column dimensions
2
3 Input Data Criteria
4
5 Q 275 m 3 /d
6 Resin mass 750 kg on moist basis
7 Shipping weight 800 kg/m 3 on moist basis
3
8 SLR 400 m /d - m 2 400 and 800
9
10
11 Compute volume of media
12
13 V = 0.94 m 3
14
15 Compute diameter of column
16
17 Area = 0.69 m 2
18
19 Diameter = 0.94 m < 3.6 m for steel tank
20
21 Compute height of column
22
23 H = 1.36 m >0.9 m and <4.0 m
24
25 Check ratio
26
27 H:D = 1.46 >0.2 and < 3
28
29
30 Solver parameters
31
32 Target cell B27
33 Equal to min
34 By changing B8
35 Subject to constraints
36 B8 400
37 B8 800
38 B19 3.6
39 B23 4.0
40 B23 0.9
41 B27 3
42 B27 0.2

Solver parameters
Set target cell: B27 Solve
Equal to: Max Min value of:
By changing cells: Close
B8 Guess Options
Subject to the constraints:
B19 3.6 Add
B23 4.0
B23 0.9 Change
B27 3.0
B27 0.2 Delete FIGURE 8-7
B8 800 Reset all

B8 400 Example 8-4 spread sheet with
Help Solver dialog box.
8-22