Wastewater Worksheets and Spreadsheets for Operators

The following worksheets and spreadsheets are designed to help operators do various required calculations, such as the amount of water pond operators need to discharge for winter or summer storage and calculations needed to calibrate lift station pumps. Some of the calculations are required in your NPDES permit. Remember to keep records for at least three years.

• Pond discharge calculation worksheet (PDF Version) (wq-wwtp7-30)
• Pump calibration worksheet (PDF Version) (wq-wwtp7-31)
• Pump calibration worksheet — circular wet well (PDF Version) (wq-wwtp7-32)
• Pump calibration worksheet — rectangular wet well (PDF Version) (wq-wwtp7-33)
• Geometric mean worksheet — fecal coliform (PDF Version) (wq-wwtp7-34)
• Pump readings — in hours (third meter runs with the other two) (PDF Version) (wq-wwtp7-35)
• Pump readings — minutes (third meter runs with the other two) (PDF Version) (wq-wwtp7-36)
• Pump readings in hours (third meter independent of the other two (PDF Version) (wq-wwtp7-37)
• Pump readings in minutes (third meter independent of the other two) (PDF Version) (wq-wwtp7-38)
• Solids Retention Time (SRT) calculation worksheet (PDF Version) (wq-wwtp7-39)
• Food to mass ratio calculation worksheet (PDF Version) (wq-wwtp7-40)
• Wasting rate calculation worksheet (PDF Version) (wq-wwtp7-41)
• Dilution ratio worksheet (PDF Version) (wq-wwtp7-42)
• Desktop water balance worksheet instructions (wq-wwtp7-46)
• Desktop water balance worksheet — 2 cell (PDF Version) (wq-wwtp7-43)
• Desktop water balance worksheet — 3 cell (PDF Version) (wq-wwtp7-44)
• Desktop water balance worksheet — 4 cell (PDF Version) (wq-wwtp7-45)
• Discharge Evaluation Report (PDF Version) (wq-wwtp7-06a)