Page 390 - Water and wastewater engineering
P. 390
SEDIMENTATION 10-7
A B C D E F G
3 Input data
4
5 Diameter 2.00E 04 m
6 Particle density 2650 kg/m 3
7 Water density 1000 kg/m 3
8 Temperature 22 °C
9 Dynamic viscosity 9.55E 04 Pa - s
10 Kinematic viscosity 9.57E 07 m 2 /s
11
12 Stokes’ settling velocity
13
14 v(s) 3.77E 02 m/s
15
16 Check Reynolds number
17
18 R 7.87E 00
19
20 Because R > 1 must use Newton’s equation and iterate
21
22 Use solver
23 Set up the equations shown below and enter the value of R from B18 as a first guess
24
25 R 5.70E 00
26
27 Calculate Newton’s drag coefficient for R between 0.5 and 10 4
28
29 C D 5.81E 00
30
31 v(s) 2.73E 02 m/s
32
33 Check the Reynolds number
34
35 R 5.70E 00
36
Solver parameters
Set target cell: B35 Solve
Equal to: Max. Min. Value of:
By changing cells: Close
B25 Options
Subject to the constraints:
B35 = B25 Add
Change Reset all
Delete Help
FIGURE 10-3
Spreadsheet solution for Example 10-1 . Note that the spreadsheet is a solution after the solver program
has been run.
