Spreadsheet: 139019d1328037420-preparing-an-excel-spreadsheet-for-linking-need-attachments-for-clarification-spreadsheet-b
Sheet: Sheet1

DATE OF REPORT: |  | EFF | EFF | INF | EFF | EFF | EFF | EFF | EFF | EFF | EFF | INF
 |  | FLOW | PEAK | FLOW | Cl2 USED | NaHSO3 | CL2 RES  mg/L | CL2 RES  mg/L | SET SOL | DO | TURBIDITY | SUSP SOLIDS
 |  | MGD | MGD | MGD | [NAME]/Day | GAL/DAY | Total/Free | Total/Free | ML/L | MG/L | NTU | mg/L
October, 2011 |  | METERED | METERED | METERED | RECORDED | RECORDED | AM GRAB | PM GRAB | GRAB | GRAB | GRAB | 24-HR COMP
 |  | DAILY | DAILY | DAILY | DAILY | DAILY | DAILY | DAILY | 5/WEEK | MONTHLY | Every 10 Days | MONTHLY
 | DAY
REMARKS: | 1 | 3.94 | 5.5 | 4.068 | 808 | 413 | <0.1 | <0.1 | <0.1 | 9 | 1.42 | 400
 | 2 | 3.735 | 6.16 | 3.845 | 847 | 476 | <0.1 | <0.1 | <0.1 | 8.3 | 2.57 | 340
NAME OF | 3 | 3.828 | 5.72 | 3.931 | 925 | 570 | <0.1 | <0.1 | <0.1 | 8.5 | 1.99 | 197
CONTACT | 4 | 3.499 | 4.84 | 4.178 | 826 | 408 | <0.1 | <0.1 | <0.1 | 8.3 | 1.78 | 213
PERSON: | 5 | 4.352 | 6.6 | 4.611 | 963 | 458 | <0.1 | <0.1 | <0.1 | 9.1 | 2.63 | 312
 | 6 | 3.599 | 7.7 | 4.259 | 1028 | 390 | <0.1 | <0.1 | <0.1 | 8.6 | 8.47 | 267
 | 7 | 3.755 | 5.72 | 4.456 | 998 | 401 | <0.1 | <0.1 | <0.1 | 9 | 3.41 | 342
 | 8 | 4.181 | 5.72 | 4.307 | 961 | 374 | <0.1 | <0.1 | <0.1 | 8.6 | 2.05 | 389
 | 9 | 3.305 | 5.72 | 3.817 | 977 | 387 | <0.1 | <0.1 | <0.1 | 8.6 | 2.92 | 471
 | 10 | 3.607 | 5.28 | 4.157 | 775 | 361 | <0.1 | <0.1 | <0.1 | 9.1 | 4.08 | 453
 | 11 | 3.526 | 5.5 | 4.082 | 846 | 251 | <0.1 | <0.1 | <0.1 | 8.8 | 2.93 | 532
 | 12 | 3.438 | 5.28 | 4.214 | 1312 | 419 | <0.1 | <0.1 | <0.1 | 8.6 | 3.22 | 452
 | 13 | 3.422 | 5.28 | 3.973 | 921 | 364 | <0.1 | <0.1 | <0.1 | 8.2 | 2.65 | 416
 | 14 | 3.909 | 5.94 | 4.045 | 861 | 346 | <0.1 | <0.1 | <0.1 | 9.1 | 3.29 | 406
 | 15 | 4.152 | 6.16 | 3.865 | 891 | 347 | <0.1 | <0.1 | <0.1 | 9.2 | 2.79 | 282
 | 16 | 3.907 | 5.94 | 3.86 | 1013 | 368 | <0.1 | <0.1 | <0.1 | 9.3 | 3.07 | 379
 | 17 | 3.977 | 6.16 | 3.974 | 1013 | 339 | <0.1 | <0.1 | <0.1 | 8.8 | 4.89 | 374
 | 18 | 3.441 | 5.72 | 4.036 | 1106 | 438 | <0.1 | <0.1 | <0.1 | 8.3 | 3.77 | 371
 | 19 | 3.441 | 5.06 | 4.169 | 1155 | 432 | <0.1 | <0.1 | <0.1 | 8.6 | 4.39 | 416
 | 20 | 3.657 | 5.5 | 4.231 | 831 | 383 | <0.1 | <0.1 | <0.1 | 8.6 | 2.48 | 471
 | 21 | 3.661 | 7.7 | 4.232 | 822 | 319 | <0.1 | <0.1 | <0.1 | 8.8 | 3.68 | 615
 | 22 | 3.528 | 5.5 | 4 | 966 | 370 | <0.1 | <0.1 | <0.1 | 9.6 | 2.23 | 573
 | 23 | 3.231 | 4.84 | 3.837 | 931 | 409 | <0.1 | <0.1 | <0.1 | 9.3 | 1.94 | 596
 | 24 | 3.416 | 5.94 | 3.891 | 1138 | 371 | <0.1 | <0.1 | <0.1 | 8.3 | 1.91 | 519
 | 25 | 3.942 | 5.72 | 4.039 | 1504 | 376 | <0.1 | <0.1 | <0.1 | 8.8 | 5.41 | 504
 | 26 | 3.811 | 11.22 | 4.287 | 987 | 430 | <0.1 | <0.1 | <0.1 | 7.9 | 5.21 | 634
 | 27 | 3.504 | 6.16 | 4.096 | 1125 | 411 | <0.1 | <0.1 | <0.1 | 9.1 | 3.45 | 650
 | 28 | 3.768 | 5.06 | 4.214 | 1103 | 364 | <0.1 | <0.1 | <0.1 | 9.1 | 2.16 | 542
 | 29 | 3.41 | 7.7 | 3.98 | 1009 | 374 | <0.1 | <0.1 | <0.1 | 8.9 | 2.68 | 376
 | 30 | 3.497 | 5.06 | 3.89 | 973 | 468 | <0.1 | <0.1 | <0.1 | 8.7 | 3.05 | 518
 | 31 | 3.318 | 5.06 | 3.979 | 816 | 652 | <0.1 | <0.1 | <0.1 | 8.7 | 4.4 | 401
MONTHLY AVERAGE |  | 3.669580645161291 | 5.982580645161289 | 4.081387096774194 | 981.6451612903226 | 402.2258064516129 | <0.1 | <0.1 | <0.1 | 8.76774193548387 | 3.255483870967742 | 432.6129032258065
MONTHLY HIGH |  | 4.352 | 11.22 | 4.611 | 1504 | 652 | <0.1 | <0.1 | <0.1 | 9.6 | 8.47 | 650
MONTHLY LOW |  | 3.231 | 4.84 | 3.817 | 775 | 251 | <0.1 | <0.1 | <0.1 | 7.9 | 1.42 | 197
RECORDINGS/MO |  | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31 | 31
REQUIREMENT 1 |  |  |  | M-AVE 5.2 |  |  |  |  | M-AVE .100 | MIN 4.0
TIMES EXCEEDED
REQUIREMENT 2 |  |  |  |  |  |  | Not greater than 2.0 [NAME] |  | MAX .100
TIMES EXCEEDED
REQUIREMENT 3
TIMES EXCEEDED
 |  | NOTES: | The calculated BOD removal rate is 99.4%.
 |  |  | The calculated TSS  removal rate is 98.2%.