Water Production and Pumping Model
2-Feb-09
System Storage Max Volume 2,000,000 gal
Clearwell Storage Volume Max 1,000,000 gal
Initial Clearwell volume 50,000 gal
Initial System Storage Volume 100,000 gal
Daily Usage Day 1 2,250,000 gal
Daily Usage Day 2 1,000,000 gal
Daily Usage Day 3 1,000,000 gal
Diurnal
Flow High Beginning Final
Factor, % Hourly Service Beginning Final System System
of Total System Pump Clearwell Clearwell Storage Storage
Day Hour Daily Flow Usage, gal WTP rate, gph Rate, gph Volume, gal Volume, gal Volume, gal Volume, gal
1 1 2 45,000.00 84,000 500,000 416,000 1,000,000 1,039,000
2 2 45,000.00 84,000 416,000 332,000 1,039,000 1,078,000
3 2 45,000.00 84,000 332,000 248,000 1,078,000 1,117,000
4 3 67,500.00 84,000 248,000 164,000 1,117,000 1,133,500
5 3 67,500.00 84,000 164,000 80,000 1,133,500 1,150,000
6 3 67,500.00 84,000 80,000 (4,000) 1,150,000 1,166,500
7 5 112,500.00 84,000 (4,000) (88,000) 1,166,500 1,138,000
8 7 157,500.00 168,000 84,000 (88,000) (4,000) 1,138,000 1,064,500
9 6 135,000.00 168,000 84,000 (4,000) 80,000 1,064,500 1,013,500
10 5 112,500.00 168,000 84,000 80,000 164,000 1,013,500 985,000
11 4 90,000.00 168,000 84,000 164,000 248,000 985,000 979,000
12 4 90,000.00 168,000 84,000 248,000 332,000 979,000 973,000
13 4 90,000.00 168,000 84,000 332,000 416,000 973,000 967,000
14 4 90,000.00 168,000 84,000 416,000 500,000 967,000 961,000
15 4 90,000.00 168,000 84,000 500,000 584,000 961,000 955,000
16 4 90,000.00 84,000 584,000 500,000 955,000 949,000
17 5 112,500.00 84,000 500,000 416,000 949,000 920,500
18 6 135,000.00 84,000 416,000 332,000 920,500 869,500
19 6 135,000.00 84,000 332,000 248,000 869,500 818,500
20 6 135,000.00 84,000 248,000 164,000 818,500 767,500
21 4 90,000.00 84,000 164,000 80,000 767,500 761,500
22 4 90,000.00 84,000 80,000 (4,000) 761,500 755,500
23 4 90,000.00 84,000 (4,000) (88,000) 755,500 749,500
24 3 67,500.00 84,000 (88,000) (172,000) 749,500 766,000
2 1 2 20,000.00 42,000 (172,000) (214,000) 766,000 788,000
2 2 20,000.00 42,000 (214,000) (256,000) 788,000 810,000
3 2 20,000.00 42,000 (256,000) (298,000) 810,000 832,000
4 3 30,000.00 42,000 (298,000) (340,000) 832,000 844,000
5 3 30,000.00 42,000 (340,000) (382,000) 844,000 856,000
6 3 30,000.00 42,000 (382,000) (424,000) 856,000 868,000
7 5 50,000.00 42,000 (424,000) (466,000) 868,000 860,000
8 7 70,000.00 42,000 (466,000) (508,000) 860,000 832,000
9 6 60,000.00 168,000 42,000 (508,000) (382,000) 832,000 814,000
10 5 50,000.00 168,000 42,000 (382,000) (256,000) 814,000 806,000
11 4 40,000.00 168,000 42,000 (256,000) (130,000) 806,000 808,000
12 4 40,000.00 168,000 42,000 (130,000) (4,000) 808,000 810,000
13 4 40,000.00 168,000 42,000 (4,000) 122,000 810,000 812,000
14 4 40,000.00 168,000 42,000 122,000 248,000 812,000 814,000
15 4 40,000.00 168,000 42,000 248,000 374,000 814,000 816,000
16 4 40,000.00 168,000 42,000 374,000 500,000 816,000 818,000
17 5 50,000.00 42,000 500,000 458,000 818,000 810,000
18 6 60,000.00 42,000 458,000 416,000 810,000 792,000
19 6 60,000.00 42,000 416,000 374,000 792,000 774,000
20 6 60,000.00 42,000 374,000 332,000 774,000 756,000
21 4 40,000.00 42,000 332,000 290,000 756,000 758,000
22 4 40,000.00 42,000 290,000 248,000 758,000 760,000
23 4 40,000.00 42,000 248,000 206,000 760,000 762,000
24 3 30,000.00 42,000 206,000 164,000 762,000 774,000
3 1 2 20,000.00 42,000 164,000 122,000 774,000 796,000
2 2 20,000.00 42,000 122,000 80,000 796,000 818,000
3 2 20,000.00 42,000 80,000 38,000 818,000 840,000
4 3 30,000.00 42,000 38,000 (4,000) 840,000 852,000
5 3 30,000.00 42,000 (4,000) (46,000) 852,000 864,000
6 3 30,000.00 42,000 (46,000) (88,000) 864,000 876,000
7 5 50,000.00 42,000 (88,000) (130,000) 876,000 868,000
8 7 70,000.00 42,000 (130,000) (172,000) 868,000 840,000
9 6 60,000.00 168,000 42,000 (172,000) (46,000) 840,000 822,000
10 5 50,000.00 168,000 42,000 (46,000) 80,000 822,000 814,000
11 4 40,000.00 168,000 42,000 80,000 206,000 814,000 816,000
12 4 40,000.00 168,000 42,000 206,000 332,000 816,000 818,000
13 4 40,000.00 168,000 42,000 332,000 458,000 818,000 820,000
14 4 40,000.00 168,000 42,000 458,000 584,000 820,000 822,000
15 4 40,000.00 168,000 42,000 584,000 710,000 822,000 824,000
16 4 40,000.00 168,000 42,000 710,000 836,000 824,000 826,000
17 5 50,000.00 42,000 836,000 794,000 826,000 818,000
18 6 60,000.00 42,000 794,000 752,000 818,000 800,000
19 6 60,000.00 42,000 752,000 710,000 800,000 782,000
20 6 60,000.00 42,000 710,000 668,000 782,000 764,000
21 4 40,000.00 42,000 668,000 626,000 764,000 766,000
22 4 40,000.00 42,000 626,000 584,000 766,000 768,000
23 4 40,000.00 42,000 584,000 542,000 768,000 770,000
24 3 30,000.00 42,000 542,000 500,000 770,000 782,000
300 4,032,000
Water Production and Pumping Model
Date:
System Storage Max Volume 2,000,000 gal Min System Storage Volume 300,000 gal
Clearwell Storage Volume Max 1,000,000 gal Min Clearwell Storage Volume 100,000 gal
Initial Clearwell volume 1,000,000 gal
Initial System Storage Volume 100,000 gal
Daily Usage Day 1 1,000,000 gal
Daily Usage Day 2 1,000,000 gal
Daily Usage Day 3 1,000,000 gal
Diurnal Flow
Factor, % of Desired High Actual High Beginning Final Beginning Final System 90,000
Total Daily Hourly System Service Pump Service Pump Clearwell Clearwell System Storage Storage
Hour Flow Usage, gal WTP rate, gph Rate, gph Rate, gph Volume, gal Volume, gal Volume, gal Volume, gal WTP Rate
1 2 20,000 - 60,000 60,000 1,000,000 940,000 100,000 140,000 SYSTEM STORAGE LOW 80,000
2 2 20,000 - 60,000 60,000 940,000 880,000 140,000 180,000 SYSTEM STORAGE LOW High Service
3 3 30,000 - 60,000 60,000 880,000 820,000 180,000 210,000 SYSTEM STORAGE LOW Pumping Rate
70,000
4 3 30,000 - 60,000 60,000 820,000 760,000 210,000 240,000 SYSTEM STORAGE LOW System Usage
5 3 30,000 - 60,000 60,000 760,000 700,000 240,000 270,000 SYSTEM STORAGE LOW
60,000
6 4 40,000 - 60,000 60,000 700,000 640,000 270,000 290,000 SYSTEM STORAGE LOW
7 7 70,000 - 60,000 60,000 640,000 580,000 290,000 280,000 SYSTEM STORAGE LOW
Rate (gph)
8 6 60,000 84,000 60,000 60,000 580,000 604,000 280,000 280,000 SYSTEM STORAGE LOW 50,000
9 6 60,000 84,000 60,000 60,000 604,000 628,000 280,000 280,000 SYSTEM STORAGE LOW
10 5 50,000 84,000 60,000 60,000 628,000 652,000 280,000 290,000 SYSTEM STORAGE LOW 40,000
11 4 40,000 84,000 60,000 60,000 652,000 676,000 290,000 310,000
12 4 40,000 84,000 60,000 60,000 676,000 700,000 310,000 330,000
13 6 60,000 84,000 60,000 60,000 700,000 724,000 330,000 330,000 30,000
14 4 40,000 84,000 60,000 60,000 724,000 748,000 330,000 350,000
15 4 40,000 84,000 60,000 60,000 748,000 772,000 350,000 370,000 20,000
16 5 50,000 - 60,000 60,000 772,000 712,000 370,000 380,000
17 5 50,000 - 60,000 60,000 712,000 652,000 380,000 390,000
10,000
18 4 40,000 - 60,000 60,000 652,000 592,000 390,000 410,000
19 4 40,000 - 60,000 60,000 592,000 532,000 410,000 430,000
20 4 40,000 - 60,000 60,000 532,000 472,000 430,000 450,000 -
21 4 40,000 - 60,000 60,000 472,000 412,000 450,000 470,000 0 10 20 30 40 50 60 70 80
22 4 40,000 - 60,000 60,000 412,000 352,000 470,000 490,000 Time (hrs)
23 4 40,000 - 60,000 60,000 352,000 292,000 490,000 510,000
24 3 30,000 - 60,000 60,000 292,000 232,000 510,000 540,000 1,000,000
25 2 20,000 - 60,000 60,000 232,000 172,000 540,000 580,000
26 2 20,000 - 60,000 60,000 172,000 112,000 580,000 620,000 900,000
27 3 30,000 - 60,000 12,000 112,000 100,000 620,000 602,000 CLEARWELL LOW
28 3 30,000 - 60,000 - 100,000 100,000 602,000 572,000 CLEARWELL LOW Final System Storage
800,000 Volume, gal
29 3 30,000 - 60,000 - 100,000 100,000 572,000 542,000 CLEARWELL LOW
30 4 40,000 - 60,000 - 100,000 100,000 542,000 502,000 CLEARWELL LOW Final Clearwell Volume,
700,000 gal
31 7 70,000 - 60,000 - 100,000 100,000 502,000 432,000 CLEARWELL LOW
32 6 60,000 - 60,000 - 100,000 100,000 432,000 372,000 CLEARWELL LOW Hourly System Usage, gal
33 6 60,000 84,000 60,000 60,000 100,000 124,000 372,000 372,000 600,000
Volume (gal)
34 5 50,000 84,000 60,000 60,000 124,000 148,000 372,000 382,000
35 4 40,000 84,000 60,000 60,000 148,000 172,000 382,000 402,000 500,000
36 4 40,000 84,000 60,000 60,000 172,000 196,000 402,000 422,000
37 6 60,000 84,000 60,000 60,000 196,000 220,000 422,000 422,000 400,000
38 4 40,000 84,000 60,000 60,000 220,000 244,000 422,000 442,000
39 4 40,000 84,000 60,000 60,000 244,000 268,000 442,000 462,000 300,000
40 5 50,000 84,000 60,000 60,000 268,000 292,000 462,000 472,000
41 5 50,000 - 60,000 60,000 292,000 232,000 472,000 482,000 200,000
42 4 40,000 - 60,000 60,000 232,000 172,000 482,000 502,000
43 4 40,000 - 60,000 60,000 172,000 112,000 502,000 522,000
100,000
44 4 40,000 - 60,000 12,000 112,000 100,000 522,000 494,000 CLEARWELL LOW
45 4 40,000 - 60,000 - 100,000 100,000 494,000 454,000 CLEARWELL LOW
-
46 4 40,000 - 60,000 - 100,000 100,000 454,000 414,000 CLEARWELL LOW
0 10 20 30 40 50 60 70 80
47 4 40,000 - 60,000 - 100,000 100,000 414,000 374,000 CLEARWELL LOW
48 3 30,000 - 60,000 - 100,000 100,000 374,000 344,000 CLEARWELL LOW Time (hrs)
49 2 20,000 - 60,000 - 100,000 100,000 344,000 324,000 CLEARWELL LOW
50 2 20,000 - 60,000 - 100,000 100,000 324,000 304,000 CLEARWELL LOW
51 3 30,000 - 60,000 - 100,000 100,000 304,000 274,000 CLEARWELL LOW SYSTEM STORAGE LOW
52 3 30,000 - 60,000 - 100,000 100,000 274,000 244,000 CLEARWELL LOW SYSTEM STORAGE LOW
53 3 30,000 - 60,000 - 100,000 100,000 244,000 214,000 CLEARWELL LOW SYSTEM STORAGE LOW
54 4 40,000 - 60,000 - 100,000 100,000 214,000 174,000 CLEARWELL LOW SYSTEM STORAGE LOW
55 7 70,000 - 60,000 - 100,000 100,000 174,000 104,000 CLEARWELL LOW SYSTEM STORAGE LOW
56 6 60,000 - 60,000 - 100,000 100,000 104,000 44,000 CLEARWELL LOW SYSTEM STORAGE LOW
57 6 60,000 84,000 60,000 60,000 100,000 124,000 44,000 44,000 SYSTEM STORAGE LOW
58 5 50,000 84,000 60,000 60,000 124,000 148,000 44,000 54,000 SYSTEM STORAGE LOW
59 4 40,000 84,000 60,000 60,000 148,000 172,000 54,000 74,000 SYSTEM STORAGE LOW
60 4 40,000 84,000 60,000 60,000 172,000 196,000 74,000 94,000 SYSTEM STORAGE LOW
61 6 60,000 84,000 60,000 60,000 196,000 220,000 94,000 94,000 SYSTEM STORAGE LOW
62 4 40,000 84,000 60,000 60,000 220,000 244,000 94,000 114,000 SYSTEM STORAGE LOW
63 4 40,000 84,000 60,000 60,000 244,000 268,000 114,000 134,000 SYSTEM STORAGE LOW
64 5 50,000 84,000 60,000 60,000 268,000 292,000 134,000 144,000 SYSTEM STORAGE LOW
65 5 50,000 - 60,000 60,000 292,000 232,000 144,000 154,000 SYSTEM STORAGE LOW
66 4 40,000 - 60,000 60,000 232,000 172,000 154,000 174,000 SYSTEM STORAGE LOW
67 4 40,000 - 60,000 60,000 172,000 112,000 174,000 194,000 SYSTEM STORAGE LOW
68 4 40,000 - 60,000 12,000 112,000 100,000 194,000 166,000 CLEARWELL LOW SYSTEM STORAGE LOW
69 4 40,000 - 60,000 - 100,000 100,000 166,000 126,000 CLEARWELL LOW SYSTEM STORAGE LOW
70 4 40,000 - 60,000 - 100,000 100,000 126,000 86,000 CLEARWELL LOW SYSTEM STORAGE LOW
71 4 40,000 - 60,000 - 100,000 100,000 86,000 46,000 CLEARWELL LOW SYSTEM STORAGE LOW
72 3 30,000 - 60,000 - 100,000 100,000 46,000 16,000 CLEARWELL LOW SYSTEM STORAGE LOW
300 2,016,000
90,000
WTP Rate
80,000 High Service Pumping Rate
System Usage
70,000
60,000
50,000
Rate (gph)
40,000
30,000
20,000
10,000
-
0 10 20 30 40 50 60 70 80
Time (hrs)
1,000,000
900,000
800,000
700,000
600,000
Volume (gal)
500,000
Final System Storage Volume, gal
Final Clearwell Volume, gal
400,000 Hourly System Usage, gal
300,000
200,000
100,000
-
0 10 20 30 40 50 60 70 80
Time (hrs)