Spreadsheet: 3d19932b-b7a3-427e-92da-3e411afd1b1b
Sheet: HWA

Headworks Analysis Spreadsheet
 | POTW Name:
 | Date:
 | POTW NPDES # =>
 | POTW Sludge Permit # =>
 | POTW [NAME] Permitted Flow(MGD)= |  | <=used in AT only
 | POTW Average Flow(MGD)= |  | <=used in HWA calculations
 | Uncontrollable Flow(MGD)=
 | 7Q10 Stream Flow(MGD)=
 | Stream Classification =
 | Class of Sludge generated (A, or B)
 | Sludge to Digestor Flow(MGD)= |  |  |  |  |  | [NAME] on Pass Through calc. for different POTW flows |  | Input "x" to use Design Criteria Loading
 | Sludge to Disposal Flow(MGD)=
 | %Solids to Disposal= |  |  |  |  | Design Values | Average Flow | Permitted Flow
 | Sludge Site Area(acres)= |  |  |  | WWTF Influent BOD (mg/l)
 | Sludge Site Life(yrs)= |  |  |  | WWTF Influent TSS (mg/l)
 | Age of Sludge Site(yrs)= |  |  |  | WWTF Influent NH3 (mg/l)
 |  |  |  |  | WWTF Influent Total N(mg/l)
Pass-Through Loading Calculations |  |  |  |  | WWTF Influent Total P (mg/l)
Pollutant | NPDES LIMIT (mg/l) | Plant Removal Rate (%) | Removal rate Source | [NAME] (lbs/day) | Stream Standard   (mg/l) | Stream Standard Source | Stream Standard Loading (lbs/day) | Design Criteria Loading (lbs/day) | Minimum Pass-Thru Loading (lbs/day) | Minimum Pass-Thru Basis
BOD
TSS
Ammonia
Arsenic
Cadmium
Chromium
Copper
Cyanide
Lead
Mercury
Molybdenum
Nickel
Selenium
Silver
Zinc
Total Nitrogen
Total Phos.
c
d
e
f
g
h
I
 |  |  |  |  | Average Influent  NH3 (mg/l)
 |  |  |  |  | Average Anaerobic Digester NH3 (mg/l)
Inhibition Loading Calculations |  |  |  |  |  | only enter when have ANAEROBIC digester
Pollutant | Primary       Removal Rate                     (%) | Primary    Removal Rate Source | A.S./Nit,/T.F. Inhibition Concentration (mg/l) | A.S./Nit,/T.F. Inhibition Concentration Source | [NAME] Inhibition Loading (lbs/day) | Digestor [NAME] (mg/l) | Digestor [NAME]. Source | Digestor [NAME] (lbs/day) | Minimum Inhibition Loading (lbs/day) | Minimum Inhibition Loading Source
Sludge Loading Calculations
Pollutant | Sludge Ceiling Concentration Limit (mg/kg) | Sludge Ceiling Load          (lbs/day) | Sludge Ceiling Load                           - HASL Calc. -(lbs/day) | Cumulative Sludge Rate Limit (lbs/(acre*life)) | Cumulative Sludge Loading      (lbs/day) | Class A Limits Monthly Average Rate Limit (mg/kg) | Class A Limits Monthly Avg. Loading (lbs/day) | Class A Limits Mon. Avg. Load.    - HASL Calc. -(lbs/day) | Minimum Sludge Loading (lbs/day) | Minimum Sludge Loading Sorce
 | 75 |  |  | 36 |  | 41
 | 85 |  |  | 34 |  | 39
 | 4300 |  |  | 1338 |  | 1500
 | 840 |  |  | 267 |  | 300
 | 57 |  |  | 15 |  | 17
 | 75
 | 420 |  |  | 374 |  | 420
 | 100 |  |  | 89 |  | 100
 | 7500 |  |  | 2498 |  | 2800
Maximum Allowable Headworks Loading Calculations
 | Minimum Pass Through Loading (lbs/day) | Pass Through Source | Minimum Inhibition Loading (lbs/day) | Minimum Inhibition Loading  Source | Minimum Sludge Loading (lbs/day) | Minimum Sludge Loading     Sorce |  | Maximum Allowable Headworks Loading (lbs/day) | Maximum Allowable Headworks Loading Source
Maximum Allowable Industrial Loadings Calculations
Pollutant | Maximum Allowable Headworks Loading (lbs/day) | MAHL Basis | Check to Use HASL Calcs         (x) | Uncontrollable Concentration (mg/l) | Uncontrollable Source | Uncontrollable Load (lbs/day) | Maximum Allowable Industrial Load (lbs/day) | Design vs. Pass-Thru Warning
 |  |  | N/A
 |  |  | N/A
 |  |  | N/A