Spreadsheet: 0da6a15c-0beb-44da-b550-2934fb88c92f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31
 |  |  | POTW Name: |  |  | Spreadsheet Instructions
 |  |  | POTW Flow(MGD)= |  |  | -  Additional Pollutants can be added in cells A101 to A120
 |  |  | Non-SIU Flow(MGD)= |  |  | -  Applicable values should be entered in the Blue Heavy Bordered cells. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Potw Name=
 |  |  | 7Q10 Stream Flow(MGD)= |  |  | -  All values are required for entry |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User Flow(MGD)=
 |  |  | Average Stream Flow(MGD)= |  |  | (except "Non-SIU Flow", cells V1 through AF 120 incomplete) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User Name=
 |  |  | Stream Type(C/WS)= |  |  | -  [NAME] are discussed in the Comprehensive Guidance HWA Chapter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-SIU Allowable Concentrations
 |  | Pass-Through Loading Calculations |  |  |  |  |  |  |  |  |  |  |  |  | Maximum | Maximum |  |  |  |  | Maximum
 |  |  |  |  | Human Health | Freshwater |  |  |  |  |  |  |  |  | Allowable | Allowable |  |  |  | Industrial | Allowable |  | Non-SIU |  |  |  |  |  |  | Maximum
 |  | C | WS | Human Health | Source | Aquatic Life | Freshwater | Inhibition |  | Removal | Removal | Human Health | Fresh Screen | Inhibition | Headworks | Headworks |  | Domestic | Domestic | Allowable | Headworks | 5% of | Permit | Explosivity | Explosivity | PEL | PEL | STEL | STEL | Discharge | Maximum
Pollutant |  | Human  Health | Human Health | Streamflow | (EPA9212 | (ug/l) | Aquatic Life | Criteria | Inhibition | Rate | Rate | Loading | Loading | Loading | Loading | Loading | Domestic | Concentration | Load | Load | Loading-MAHL | MAHL | Concentration | Concentration | Concentration | Concentration | Concentration | Concentration | Concentration | Concentration | Discharge
 | Carcinogen | (ug/l) | (ug/l) | (MGD) | or NCWQC) | (EPA9212) | Source | (mg/l) | Source | (%) | Source | (#/day) | (#/day) | (#/day) | (#/day) | Criteria | BDL | (ug/l) | (#/day) | (#/day) | (#/day) | (#/day) | (mg/l) | (mg/l) | Source | (mg/l) | Source | (mg/l) | Source | (mg/l) | Source
Acenaphthene |  | 2700 | 1200 |  | FC | 17 | EPA Screen9110 |  |  | 88 | RREL-Mean
Acrylonitrile (c) | c | 0.66 | 0.059 |  | FC | 75.5 | EPA Screen9110 |  |  | 93 | RREL-Mean |  |  |  |  |  | bdl | 100 |  |  |  |  |  | 1794 | EPA Tox. Guide | 1.19 | EPA Tox. Guide | 5.95 | NC-OSHA Conv.
Benzene (c) | c | 71.4 | 1.19 |  | SS | no stdrd |  | 100 | LLG | 80 | LLG |  |  |  |  |  |  | 5.5 |  |  |  |  |  | 20 | EPA Tox. Guide | 0.14 | EPA Tox. Guide | 0.35 | NC-OSHA Conv.
[NAME] (c) | c | 4.42 | 0.254 |  | SS | no stdrd |  |  |  | 89 | RREL-Mean |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 0.03 | EPA Tox. Guide | 0.075 | NC-OSHA Conv.
Chlorobenzene(Cl. Benz) |  | 21000 | 680 |  | FC/NC WS WQS | 195 | EPA Screen9110 |  |  | 74 | RREL-Mean |  |  |  |  |  | bdl | 2.5 |  |  |  |  |  | 40 | EPA Tox. Guide | 2.31 | EPA Tox. Guide
1,2,4-Trichlorobenzene(Cl. Benz,) |  | no stdrd | no stdrd |  | FC/NC WS WQS | 44.9 | EPA Screen9110 |  |  | 52 | RREL-Mean |  |  |  |  |  |  |  |  |  |  |  |  | 197 | EPA Tox. Guide
Hexachlorobenzene (c, Cl. Benz.) | c | 0.00077 | 0.00075 |  | FC/NC WS WQS | no stdrd |  | 5 | LLG | 90 | RREL-Mean
1,2-Dichloroethane (c) | c | 99 | 0.38 |  | FC | 2000 | EPA Screen9110 |  |  | 59 | RREL-Mean |  |  |  |  |  |  | 1
1,1,1-Trichloroethane |  | no stdrd | no stdrd |  | FC | 528 | EPA Screen9110 |  |  | 85 | RREL-Mean |  |  |  |  |  |  | 1 |  |  |  |  |  | 33 | EPA Tox. Guide | 1.55 | EPA Tox. Guide | 5.91 | NC-OSHA Conv.
Hexachloroethane (c) | c | 8.85 | 1.95 |  | FC | 9.8 | EPA Screen9110 |  |  | 97 | RREL-Mean |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.093 | EPA Tox. Guide
1,1-Dichloroethane | c | no stdrd | no stdrd |  | FC | no stdrd |  |  |  | 87 | RREL-Mean |  |  |  | no criteria |  | bdl | 2.5 |  |  | no criteria | no criteria | no criteria | 128 | EPA Tox. Guide | 4.58 | EPA Tox. Guide |  |  | 4.58 | PEL
1,1,2-trichloroethane (c) | c | 42 | 0.6 |  | FC | 940 | EPA Screen9110 |  |  | 75 | RREL-Mean |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  | 1.15 | EPA Tox. Guide
Chloroethane |  | no stdrd | no stdrd |  | FC | no stdrd |  |  |  | 94.4 | RREL-Mean |  |  |  | no criteria |  | bdl | 5 |  |  | no criteria | no criteria | no criteria | 1.6 | EPA Tox. Guide | 0.42 | EPA Tox. Guide |  |  | 0.42 | PEL
[NAME] (c) | c | 470 | 5.7 |  | FC | 289 | EPA Screen9110 |  |  | 67 | LLG |  |  |  |  |  |  | 4.5 |  |  |  |  |  |  |  | 0.41 | EPA Tox. Guide
2-Chlorophenol |  | 400 | 120 |  | FC | 43.8 | EPA Screen9110 | 5 | LLG | 65 | RREL-Mean
1,2-Dichlorobenzene(Cl. Benz.) |  | 17000 | 2700 |  | FC/NC WS WQS | 15.8 | EPA Screen9110 | 5 | LLG | 81 | RREL-Mean |  |  |  |  |  |  | 4 |  |  |  |  |  | 165 | EPA Tox. Guide | 3.75 | EPA Tox. Guide | 5.625 | NC-OSHA Conv.
1,3-Dichlorobenzene(Cl. Benz.) |  | 2600 | 400 |  | FC/NC WS WQS | 50.2 | EPA Screen9110 | 5 | LLG | 85 | RREL-Mean |  |  |  |  |  |  | 1 |  |  |  |  |  | 90 | EPA Tox. Guide
1,4-Dichlorobenzene(Cl. Benz.) |  | 2600 | 400 |  | FC/NC WS WQS | 11.2 | EPA Screen9110 | 5 | LLG | 89 | RREL-Mean |  |  |  |  |  |  | 1 |  |  |  |  |  | 104 | EPA Tox. Guide | 3.55 | EPA Tox. Guide | 5.31 | NIOSH Guide
1,1-Dichloroethylene (c) | c | 3.2 | 0.057 |  | FC | 303 | EPA Screen9110 |  |  | 95 | RREL-Mean |  |  |  |  |  |  | 2
1,2-trans-Dichloroethylene |  | no stdrd | 700 |  | FC | 1350 | EPA Screen9110 |  |  | 67 | LLG |  |  |  |  |  | bdl | 5 |  |  |  |  |  | 14 | EPA Tox. Guide | 0.28 | EPA Tox. Guide
2,4-Dichlorophenol |  | 790 | 93 |  | FC | 36.5 | EPA Screen9110 | 64 | LLG | 66 | RREL-Mean
1,2-Dichloropropane |  | 39 | 0.52 |  | FC | 525 | EPA Screen9110 |  |  | 71 | RREL-Mean |  |  |  |  |  | bdl | 2.5 |  |  |  |  |  | 164 | EPA Tox. Guide | 3.62 | EPA Tox. Guide | 5.31 | NC-OSHA Conv.
1,3-Dichloropropylene | c | 1700 | 10 |  | FC | 24.4 | EPA Screen9110 |  |  | 97 | RREL-Mean |  |  |  |  |  |  |  |  |  |  |  |  | 435 | EPA Tox. Guide | 0.08 | EPA Tox. Guide
2,4-Dimethylphenol |  | 2300 | 540 |  | FC | 21.2 | EPA Screen9110 | 50 | LLG | 71 | RREL-Mean
2,4-Dinitrotoluene (c) | c | 9.1 | 0.11 |  | FC | 310 | EPA Screen9110 | 5 | LLG | 91.5 | RREL-Mean |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.21 | EPA Tox. Guide
2,6-Dinitrotoluene | c | no stdrd | no stdrd |  | FC | no stdrd |  |  |  | 53 | RREL-Mean |  |  |  | no criteria |  |  | 1 |  |  | no criteria | no criteria | no criteria |  |  | 7.21 | EPA Tox. Guide |  |  | 7.21 | PEL
Ethylbenzene |  | 29000 | 3100 |  | FC | 453 | EPA Screen9110 | 200 | LLG | 98 | RREL-Mean |  |  |  |  |  |  | 1.5 |  |  |  |  |  | 16 | EPA Tox. Guide | 1.59 | EPA Tox. Guide | 1.99 | NC-OSHA Conv.
Fluoranthene |  | 374.6 | 295.5 |  | FC | 39.8 | EPA Screen9110 |  |  | 95 | RREL-Mean |  |  |  |  |  |  | 2
[NAME] (c) | c | 1600 | 4.7 |  | FC | 1930 | EPA Screen9110 |  |  | 86 | LLG |  |  |  |  |  |  | 7 |  |  |  |  |  | 494 | EPA Tox. Guide | 2.06 | EPA Tox. Guide | 8.24 | NC-OSHA Conv.
[NAME] |  | no stdrd | no stdrd |  | FC | 5500 | EPA Screen9110 |  |  | 62 | LLG |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 0.06 | EPA Tox. Guide | 0.12 | NC-OSHA Conv.
Hexachlorobutadiene (c) | c | 49.7 | 0.445 |  | SS | no stdrd |  |  |  | 96.2 | RREL-Mean
Naphthalene |  | no stdrd | no stdrd |  | FC | 62 | EPA Screen9110 | 500 | LLG | 71 | RREL-Mean |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 2.65 | EPA Tox. Guide | 3.975 | NC-OSHA Conv.
Nitrobenzene |  | 1900 | 17 |  | FC | 270 | EPA Screen9110 | 30 | LLG | 88 | RREL-Mean |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.41 | EPA Tox. Guide
2-Nitrophenol |  | no stdrd | no stdrd |  | FC | 3500 | EPA Screen9110 |  |  | 92.1 | RREL-Mean |  |  |  |  |  | bdl | 50
4-Nitrophenol |  | no stdrd | no stdrd |  | FC | 82.8 | EPA Screen9110 |  |  | 85.6 | RREL-Mean |  |  |  |  |  | bdl | 50
2,4-Dinitrophenol |  | 14000 | 70 |  | FC | 6.2 | EPA Screen9110 |  |  | 79 | RREL-Mean
4,6-Dinitro-o-cresol |  | 765 | 13.4 |  | FC | 2.3 | EPA Screen9110 |  |  | 75 | RREL-Mean |  |  |  |  |  | bdl | 50 |  |  |  |  |  |  |  | 10.78 | EPA Tox. Guide
Phenol |  | 300 | no stdrd |  | JFS | no stdrd |  | 50 | LLG | 84 | RREL-Mean |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 1024 | EPA Tox. Guide
Bis(2-ethylhexyl) phthalate (c) | c | 5.9 | 1.8 |  | FC | 0.3 | EPA Screen9110 |  |  | 58 | LLG |  |  |  |  |  |  | 7.5
Dibutyl phthalate |  | 12000 | 2700 |  | FC | 25 | GSX NOEC |  |  | 60 | RREL-Mean |  |  |  |  |  |  | 8.5
Diethyl phthalate |  | 120000 | 23000 |  | FC | 521 | EPA Screen9110 |  |  | 57 | RREL-Mean |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  |  | 107 | EPA Tox. Guide
Dimethyl phthalate |  | 2900000 | 313000 |  | FC | 330 | EPA Screen9110 |  |  | 55 | RREL-Mean |  |  |  |  |  |  | 2
Benzo(a)anthracene (c, PAH) | c | 0.049 | 0.0044 |  | FC | no stdrd |  |  |  | 96.8 | RREL-Mean |  |  |  |  |  | bdl | 10
[NAME] (c, PAH) | c | 0.049 | 0.0044 |  | FC | no stdrd |  |  |  | 90 | RREL-Mean |  |  |  |  |  |  | 1
3,4-Benzofluoranthene (c, PAH) | c | 0.049 | 0.0044 |  | FC | no stdrd |  |  |  | 91 | RREL-Mean |  |  |  |  |  |  | 1
Benzo(k)fluoranthene (c,PAH) | c | 0.049 | 0.0044 |  | FC | no stdrd |  |  |  | 91.5 | RREL-Mean |  |  |  |  |  |  | 1
[NAME] (c, PAH) | c | 0.049 | 0.0044 |  | FC | no stdrd |  |  |  | 96.9 | RREL-Mean |  |  |  |  |  | bdl | 10
[NAME] |  | no stdrd | no stdrd |  | FC | no stdrd |  |  |  | 80 | RREL-Mean |  |  |  | no criteria |  | bdl | 10 |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria
Anthracene |  | 110000 | 9600 |  | FC | no stdrd |  | 500 | LLG | 67 | LLG |  |  |  |  |  |  | 1
[NAME] |  | 14000 | 1300 |  | FC | no stdrd |  |  |  | 58.4 | RREL-Mean
Phenanthrene |  | no stdrd | no stdrd |  | FC | no stdrd |  | 500 | LLG | 88 | RREL-Mean |  |  |  |  |  |  | 1
[NAME] |  | 11000 | 960 |  | FC | no stdrd |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] (c) | c | 8.85 | 0.8 |  | FC/SS WS | 84 | EPA Screen9110 |  |  | 80 | LLG |  |  |  |  |  |  | 4.5 |  |  |  |  |  |  |  | 0.53 | EPA Tox. Guide
[NAME]) |  | no stdrd | no stdrd |  | SS for Aqua Life | 11 | EPA Screen9110 | 200 | LLG | 93 | LLG |  |  |  |  |  |  | 6.5 |  |  |  |  |  | 17 | EPA Tox. Guide | 1.36 | EPA Tox. Guide | 2.04 | NC-OSHA Conv.
Trichloroethylene (c) | c | 92.4 | 3.08 |  | SS | no stdrd |  |  |  | 89 | LLG |  |  |  |  |  |  | 17.5 |  |  |  |  |  | 114 | EPA Tox. Guide | 0.71 | EPA Tox. Guide | 1.42 | NC-OSHA Conv.
[NAME] (c) | c | 525 | 2 |  | SS | no stdrd |  |  |  | 88 | RREL-Mean |  |  |  |  |  | bdl | 5 |  |  |  |  |  | 2.2 | EPA Tox. Guide | 0.0003 | EPA Tox. Guide | 0.0015 | NC-OSHA Conv.
Additional Organics |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no criteria
Chlorinated Benzenes | c | no stdrd | 488 |  | SS | no stdrd |  |  |  | 78.5 | Cl. B. mean |  |  |  | no criteria |  |  |  |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria
Polynuclear Aromatic Hydrocarbons(c) | c | 0.0311 | 0.0028 |  | SS | no stdrd |  |  |  | 93.2 | PAH mean
Dioxin(c) | c | 1.4e-08 | 1.3e-08 |  | SS | no stdrd |  |  |  | 45 | RREL-Mean
Polychlorinated Biphenyls(c) | c | 7.9e-05 | no stdrd |  | SS | 0.001 | NC WQS |  |  | 63.6 | RREL-Mean
Xylenes |  | no stdrd | no stdrd |  |  | no stdrd |  |  |  | 84.8 | RREL-Mean |  |  |  | no criteria |  |  |  |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria
Tetrachloroethane(1,1,2,2)(c) | c | 10.8 | 0.172 |  | SS | no stdrd |  |  |  | 84.3 | RREL-Mean |  |  |  |  |  |  | 1
Pesticides
Aldrin | c | 0.000136 | 0.000127 |  | SS | 0.002 | NC WQS
Chlordane | c | 0.000588 | 0.000575 |  | SS | 0.004 | NC WQS
DDT | c | 0.000591 | 0.000588 |  | SS | 0.001 | NC WQS |  |  | 60 | RREL-Mean
Demeton |  | no stdrd | no stdrd |  |  | 0.1 | NC WQS
Dieldrin | c | 0.000144 | 0.000135 |  | SS | 0.002 | NC WQS |  |  | 86 | RREL-Mean
Endosulfan |  | no stdrd | no stdrd |  |  | 0.05 | NC WQS |  |  | 44 | RREL-Mean
Endrin |  | no stdrd | no stdrd |  |  | 0.002 | NC WQS |  |  | 50 | RREL-Mean
Guthion |  | no stdrd | no stdrd |  |  | 0.01 | NC WQS |  |  | 74 | RREL-Mean
Heptachlor | c | 0.000214 | 0.000208 |  | SS | 0.004 | NC WQS |  |  | 76 | RREL-Mean
Lindane |  | no stdrd | no stdrd |  |  | 0.01 | NC WQS |  |  | 38 | RREL-Mean
[NAME] |  | no stdrd | no stdrd |  |  | 0.03 | NC WQS |  |  | 59.5 | RREL-Mean
Mirex |  | no stdrd | no stdrd |  |  | 0.001 | NC WQS
Parathion | c | no stdrd | no stdrd |  |  | 0.013 | NC WQS
Toxaphene | c | no stdrd | no stdrd |  |  | 0.0002 | NC WQS
2,4-D |  | no stdrd | 100 |  | SS | no stdrd |  |  |  | 37 | RREL-Mean |  |  |  | no criteria |  |  |  |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria
2,4,5-TP (Silvex) |  | no stdrd | 10 |  | SS | no stdrd |  |  |  | 43 | RREL-Mean |  |  |  | no criteria |  |  |  |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria
Gasoline
Benzene (c) | c | 71.4 | 1.19 |  | SS | no stdrd |  | 100 | LLG | 80 | LLG |  |  |  |  |  |  | 5.5 |  |  |  |  |  | 20 | EPA Tox. Guide | 0.14 | EPA Tox. Guide | 0.35 | NC-OSHA Conv.
Ethylbenzene |  | 325 | no stdrd |  | FC | 453 | EPA Screen9110 | 200 | LLG | 98 | RREL-Mean |  |  |  |  |  |  | 1.5 |  |  |  |  |  | 16 | EPA Tox. Guide | 1.59 | EPA Tox. Guide | 1.99 | NC-OSHA Conv.
Toluene |  | no stdrd | no stdrd |  | SS for Aqua Life | 11 | EPA Screen9110 | 200 | LLG | 93 | LLG |  |  |  |  |  |  | 6.5 |  |  |  |  |  | 17 | EPA Tox. Guide | 1.36 | EPA Tox. Guide | 2.04 | NC-OSHA Conv.
Xylenes |  |  |  |  |  |  |  |  |  | 84.8 | RREL-Mean
Additional Pollutants
Bromodichloromethane | c | 22 | 0.27 |  | FC | no stdrd |  |  |  | 87 | RREL-Mean |  |  |  | no criteria |  |  |  |  |  | no criteria | no criteria | no criteria |  |  |  |  |  |  | no criteria | no criteria