Water Works Engineers products

The SBR Flow Routing spreadsheet was developed by Water Works Engineers as a means of understanding the cycling sequence and peak flow handling for a multi-cell sequencing batch reactor installation treating a variable wastewater feed. The spreadsheet allows for up to 4 SBR cells fed sequentially, tracks flow in 15-minute time steps, and allows for specifying either a set time for each cycle or allows the fill length to vary until the cell is full. Settling and decant times are variable (in 15-minute time steps). This spreadsheet is open source shareware that we are offering to the community as a collaborative product; please read the licensing terms embedded in the spreadsheet and only use it if you agree to them. Please send us any suggested improvements, comments, or enhancements so that we may share them with others.

The WWTP Staffing Spreadsheet extracts the data and methodology presented in the 1973 EPA Publication MO-1 entitled "Estimating Staffing for Municipal Wastewater Treatment Facilities." While this publication is over 30 years old, this document is still in use for estimating or validating staffing requirements. We have recently tested it against plants varying in size from 5 mgd to 12 mgd and found the estimates close to the actual staffing levels at those plants. This spreadsheet is open source shareware that we are offering to the community as a collaborative product; please read the licensing terms embedded in the spreadsheet and only use it if you agree to them. Please send us any suggested improvements, comments, or enhancements so that we may share them with others.

The ASM1-SBR spreadsheet was developed by Water Works Engineers as a means of modeling the performance and oxygen requirements over a single cycle of an SBR. The spreadsheet is based on the IWA Activated Sludge Model 1 and models the dynamic performance of reactor using 15 time steps. For each time step, the user specifies a volume of wastewater fed and the oxygen concentration maintained during that step. This spreadsheet is open source shareware that we are offering to the community as a collaborative product; please read the licensing terms embedded in the spreadsheet and only use it if you agree to them. Please send us any suggested improvements, comments, or enhancements so that we may share them with others.