Document ID: EPA-HQ-OW-2002-0033-0342
Agency: epa
Document Type: Supporting & Related Material
Title: 
Posted Date: 2003-04-14T04:00Z

Adjusted
counts
for
missing
data
(
revised
12_
03_
02).
xls
3/
4/
2003
Universe
of
MP&
M
Sample
Direct
Dischargers
(
sum
of
weights,
rounded)
2832
Known
Direct
Dischargers
from
PCS
used
for
counts
3242
Ratio
of
Total
to
Known
=
G1/
G2
Reach
Waterbody
Type
Population
in
Counties
Type
Original
Count
Adjusted
for
missing
data
Category
Original
Count
Adjusted
for
missing
data
Bay
180
=
B9*$
G$
4
Pop
<=
100000
1069
=
F9*$
G$
4
Great
Lake
33
=
B10*$
G$
4
100000
<
Pop
<=
500000
1323
=
F10*$
G$
4
1155
Lake
117
=
B11*$
G$
4
500000
<
Pop
<=
1000000
461
=
F11*$
G$
4
Stream
­
small
622
=
B12*$
G$
4
1000000
<
Pop
<=
2000000
316
=
F12*$
G$
4
Stream
­
medium
1733
=
B13*$
G$
4
2000000
<
Pop
<=
4000000
54
=
F13*$
G$
4
Stream
­
large
1
414
=
B14*$
G$
4
Pop
>
4000000
19
=
F14*$
G$
4
Stream
­
large
2
143
=
B15*$
G$
4
Total
Facilities
=
SUM(
B9:
B16)
=
SUM(
C9:
C16)
Total
Facilities
=
SUM(
F9:
F16)
=
SUM(
G9:
G16)

Use
1155
so
that
total
is
correct.
This
is
the
affected
category
based
on
the
facility
removed.