Other Wastewater Treatment Spreadsheets
This category includes spreadsheets for anaerobic digester calculations, aerobic grit chanber design, Dissolved Air Flotation design calculations, Upflow Anaerobic Sludge Blanket (UASB) wastewater treatment design calculations, subsurface wastewater disposal calculations, activated sludge solids mass balance, and phosphorus removal with an SBR process.
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, anaerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. U.S. units are used in this spreadsheet.
This Excel spreadsheet carries out an iterative solids mass balance for an activated sludge wastewater treatment system in order to determine the recycle flow rate, BOD, and TSS from a sludge thickener, anaerobic digester, and dewatering system. The calculations are based on and similar to those in an example problem in Metcalf and Eddy, Wastewater Engineering Treatment and Reuse. S.I. units are used in this spreadsheet.
This Excel spreadsheet package includes a worksheet for calculating primary sludge and thickened waste activated sludge quantities, which will be the feed to the anaerobic digester. A second worksheet is used to calculate liquid volume needed for the anaerobic digested and to determine the side water depth and diameter for a specified number of tanks. Calculations are done in U.S. units
This Excel spreadsheet package includes a worksheet for calculating primary sludge and thickened waste activated sludge quantities, which will be the feed to the anaerobic digester. A second worksheet is used to calculate liquid volume needed for the anaerobic digested and to determine the side water depth and diameter for a specified number of tanks. Calculations are done in S.I. units
This excel spreadsheet calculates the required volume per aerated grit chamber tank as well as width, length and depth of the tank and the required air flow rate, based on user inputs for design average wastewater flow rate, the number of grit chambers, the design detention time at peak hourly flow, the tank depth, the length to width ratio, and the air flow needed per ft of tank length. A table showing typical values for the design parameters is provided. Also, there is a worksheet that may be used to estimate the peaking factor for the wastewater flow rate. The calculations are in U.S. units.
This excel spreadsheet calculates the required volume per aerated grit chamber tank as well as width, length and depth of the tank and the required air flow rate, based on user inputs for design average wastewater flow rate, the number of grit chambers, the design detention time at peak hourly flow, the tank depth, the length to width ratio, and the air flow needed per ft of tank length. A table showing typical values for the design parameters is provided. Also, there is a worksheet that may be used to estimate the peaking factor for the wastewater flow rate. The calculations are in S.I. units.
This Excel spreadsheet makes dissolved air flotation design calculations based on user input information about the flow being treated and design parameters. The spreadsheet includes calculation of the required air flow and the required DAF area based on either a design hydraulic loading rate or a design solids loading rate. The calculations are in U.S. units.
This Excel spreadsheet makes dissolved air flotation design calculations based on user input information about the flow being treated and design parameters. The spreadsheet includes calculation of the required air flow and the required DAF area based on either a design hydraulic loading rate or a design solids loading rate. The calculations are in S.I. units.
This Excel speadsheet makes design calculations for an Upflow Anaerobic Sludge Blanket (UASB) wastewater treatment reactor. Based on user input information about the wastewater to be treated, biological kinetic coefficients, methane stoichiometrry constants, and reactor configuration and design parameters, the spreadsheet calculate the required reactor volume and dimensions, the sludge production rate, the methane production rate and the required alkalinity addition. Calculations are in U.S. units.
This Excel speadsheet makes design calculations for an Upflow Anaerobic Sludge Blanket (UASB) wastewater treatment reactor. Based on user input information about the wastewater to be treated, biological kinetic coefficients, methane stoichiometrry constants, and reactor configuration and design parameters, the spreadsheet calculate the required reactor volume and dimensions, the sludge production rate, the methane production rate and the required alkalinity addition. Calculations are in S.I. units.
This spreadsheet is set up to make calculations for a design of a manifold/perforated lateral low pressure wastewater distribution system. There is one worksheet for an end manifold system and one for a center manifold system. Each of the worksheets calculates the flow rate per lateral and total flow rate for a user specified preliminary manifold/lateral layout, orifice spacing and target distal head pressure. The worksheets then calculate the minimum required lateral diameter and the minimum required manifold diameter. The user is guided in the selection of the dose volume and number of doses per day. Also the pump head and flow requirements and the pump chamber volume are calculated. This spreadsheet uses U.S. units.
This spreadsheet is set up to make calculations for a design of a manifold/perforated lateral low pressure wastewater distribution system. There is one worksheet for an end manifold system and one for a center manifold system. Each of the worksheets calculates the flow rate per lateral and total flow rate for a user specified preliminary manifold/lateral layout, orifice spacing and target distal head pressure. The worksheets then calculate the minimum required lateral diameter and the minimum required manifold diameter. The user is guided in the selection of the dose volume and number of doses per day. Also the pump head and flow requirements and the pump chamber volume are calculated. This spreadsheet uses S.I. units.
Based on user input values for influent flow rate, plate angle, plate spacing, number of plates, length of plates, and design surface loading rate, this spreadsheet workseet calculates the area required for each plate, the plate width, and the module width, length and height. It also calculates the HRT between plates, the liquid velocity between plates and the Reynolds number for the flow between adjacent plates. This spreadsheet uses U.S. units.
Based on user input values for influent flow rate, plate angle, plate spacing, number of plates, length of plates, and design surface loading rate, this spreadsheet worksheet calculates the area required for each plate, the plate width, and the module width, length and height. It also calculates the HRT between plates, the liquid velocity between plates and the Reynolds number for the flow between adjacent plates. This spreadsheet uses S.I. units.
This Excel Spreadsheet calculates the head loss and pressure drop for liquid flow through a packed bed, based on user input values for the flow rate through the bed, bed dimensions, packing properties, and liquid density and viscosity. It also creates a plot of pressure drop vs flow rate through the bed for a series of user entered values for flow rate. The calculations are done using U.S. units
This Excel Spreadsheet calculates the head loss and pressure drop for liquid flow through a packed bed, based on user input values for the flow rate through the bed, bed dimensions, packing properties, and liquid density and viscosity. It also creates a plot of pressure drop vs flow rate through the bed for a series of user entered values for flow rate. The calculations are done using S.I. units
This spreadsheet calculates the head loss across bar screens, the head loss across fine screens, the estimated minimum, maximum, and average daily volume of screenings from a bar screen, and the estimated minimum, maximum, and typical daily volume of screenings from a fine screen. Calculations use U.S. units
This spreadsheet calculates the head loss across bar screens, the head loss across fine screens, the estimated minimum, maximum, and average daily volume of screenings from a bar screen, and the estimated minimum, maximum, and typical daily volume of screenings from a fine screen. Calculations use S.I. units
This spreadsheet carries out design calculations for a horizontal flow grit chamber, including calculation of the required length, width and depth of the grit chamber, based on user input values for design wastewater flowrate and several design parameters. There is a worksheet for calculation of the peaking factor based on the design average flow rate, and there is a worksheet for design of a Sutro weir for the effluent from the grit chamber. The calculations are done with U.S. units.
This spreadsheet carries out design calculations for a horizontal flow grit chamber, including calculation of the required length, width and depth of the grit chamber, based on user input values for design wastewater flowrate and several design parameters. There is a worksheet for calculation of the peaking factor based on the design average flow rate, and there is a worksheet for design of a Sutro weir for the effluent from the grit chamber. The calculations are done with S.I. units
This Excel spreadsheet workbook uses 9 worksheets to make calculations for metal precipitation from wastewater. In the first worksheet there is provision for user entry of the wastewater flowrate and the concentration of each of seven metals (zinc, nickel, chrome, copper, cadmium, lead, and iron) in the wastewater. There is also provision for user entry of the design pH and a safety factor for the calculations, as well as selection between caustic or lime as the chemical to be used for the precipitation and specification of the concentration of the caustic or lime solution being used. Each of the worksheets 2 through 8 make calculations for one of the metals. Solubility vs pH data for each of the metals is used to generate an equation for the solubility of that metal as a function of pH. Then equilibrium values are calculated for the metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. Finally, the user-specified saftery factio is applied to get design values for metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. The last worksheet provides a summary of the calculated results for each of the seven metals. Calculations are made using U.S. units
This Excel spreadsheet workbook uses 9 worksheets to make calculations for metal precipitation from wastewater. In the first worksheet there is provision for user entry of the wastewater flowrate and the concentration of each of seven metals (zinc, nickel, chrome, copper, cadmium, lead, and iron) in the wastewater. There is also provision for user entry of the design pH and a safety factor for the calculations, as well as selection between caustic or lime as the chemical to be used for the precipitation and specification of the concentration of the caustic or lime solution being used. Each of the worksheets 2 through 8 make calculations for one of the metals. Solubility vs pH data for each of the metals is used to generate an equation for the solubility of that metal as a function of pH. Then equilibrium values are calculated for the metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. Finally, the user-specified saftery factio is applied to get design values for metal removal rate, effluent metal concentration, solids production rate, and chemical usage rate. The last worksheet provides a summary of the calculated results for each of the seven metals. Calculations are made using S.I. units