References. APPLIED DRINKING WATER MATH FORMULA SHEET AND CONVERSION FACTORS 12 in = 1 ft 27 cu. Wastewater flow estimation and servicing guidelines 1. 700 NORTH BELL AVENUE CARNEGIE, PA 15106-0548 PHONE (412) 279-0044 FAX (412) 279-5410 Sample Air Diffuser Calcs. Valuation - This is the value of the investment on the start date. Interactive spreadsheet to compute the geometric mean on a set of numbers to assist with completion of discharge monitoring reports (DMR) for domestic wastewater facilities. Equations displayed for easy reference. This e-book provides background information about the MBR (membrane bioreactor) wastewater treatment system and detailed discussion of process design calculations for this process. 00 psi CSM Water Resources (310) 458-8535 ext 4 Minimum Static Press at source: 57. Let your users model the calculation of key values in spreadsheets, but integrate the computations natively into your Java applications. The Public Utilities team provides drinking water and wastewater treatment service to unincorporated Hillsborough County. Calculation Sheet (Sat. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. tural class in the Rosetta database for all calculations. The templates are created in a design that will help you not only in professional work but for personal work as well such as making retiring plans or. The Headworks Analysis (HWA) calculates the flow and pollutant treatment capacity of a wastewater treatment plant (WWTP). pH of water is most important parameter of water. The spreadsheet calculations measure the wet volume per foot, the drawdown volume and the flow rate based on that information. Operators at different …. SPECIATE: SPECIATE is the EPA's repository of organic gas and particulate matter (PM) speciation profiles of air pollution sources. Velocity = At 1. The average grout loss to the formation is 3-9%. Cooling Tower Efficiency Calculation. ASCE702S is a spreadsheet program written in MS-Excel for the purpose of flat roof snow loading analysis for buildings and structures per the ASCE 7-02 Code. Some dechlorination. Tom Crouse. My JEA Utility Tracker helps you track your daily electric and water consumption and provides savings tips specific to your home. Water Softener Capacity Calculation. (Free Calculation Spreadsheet) Dede Arpendo on compressor Chemical Engineer Chemical engineering City gas Cooling tower design of shell and tube heat exchanger domestic wastewater energy audit energy audit in indonesia energy conservation. Municipal Job Listings. If the normal sewer water characteristics are unknown, please press the "typical data" button for an auto fill of the input fields. After completing this course you will be familiar with the common variations of the activated sludge process used for biological wastewater treatment and be able to make. Physical Design and Construction 7. our calculations as well. Include Archived Items : Title: Category: Modified Date: Size: Download: 2018 Ord 61 Mound Calculations Spreadsheet Excel doc ISTS At Grade Calculation spreadsheet for septic system designers. 68D10118 November 1994 prepared for the U. CETCO makes no warranty of any kind and accepts no responsibility for the results obtained through the application of this information. Wastewater Pump Station Design Spreadsheet Author: John Nichols (Brunswick County)/Mike Johnson (McKim & Creed) Description: 3-20-2009 (1st release of Approved spreadsheet) Last modified by: William L. We increase productivity by letting you focus on the real issues in your spreadsheets. Please note: Electronic Reporting of required SDWA information has not yet been approved by EPA. Note: by donating $5 or more you will be notified of any spreadsheet updates by email (unless of course you indicate not to be). ) In this section, you will perform a series of calculations that will lead you to your future water demand numbers. Operators at different …. Screen shot of the Draw Down Calculator. How to Use the Calculators: SCF. Wastewater Screening Design Calculator Water Treatment - Bar Racks and Fine Screens George Tchobanoglous, Franklin L. 5 | Policy Guidance Manual on Wastewater Management Policy Framework 4. 2 Correction Factor (0. sanitary sewer manholes which have sewer force mains discharging directly into them shall be fiberglass or poly‐ethylene lined or epoxy lined. Downloading worked solutions from our Repository gives you a head start in solving technical problems. Would you mind sharing your spreadsheet with me? My email is [email protected] Wasteload Management. This downloadable Excel file can be used by permittees to perform basic biosolids calculations such as converting from gallons to dry tons. This can aid the permittees in record keeping as well as determining results to enter onto report forms. Documents below updated January 3rd, 2020. The equations on the right show how certain results were calculated. Annual Conference Wisconsin Dells, WI October 11, 2012. To use our budget calculator, just input a design flow between 1,000 and 120,000 gpd into the box below, and the wastewater plant cost will be provided. Several control strategies are described below including application. Disclaimer: MRWA reserves the right to accept or reject any posting. Built-in operational calculations. concentration, and target effluent ammonia. The below is the example of a footing. Please note that all formulas in the operators reports and spreadsheets should be checked manually to insure proper calculations before. Wastewater Averaging Home | Wastewater Averaging FAQs | Find Your Wastewater Averaging Period Instructions: Only enter information for the cells in green (also notated by *). Demineralized Water Demand. Waste Water Treatment; Resources. American Water Works Association has the resources and tools you need to progress as a water professional. This page offers information about these programs. APPLIED WASTEWATER MATH FORMULA SHEET AND CONVERSION FACTORS 12 in = 1 ft 27 cu ft = 1 cu yd 1,000 mg = 1 gm 60 sec = 1 min 3 ft = 1yd 7. 2 The terms "tunnel" or "tunnel system" refer to the system downstream of the drop structure. Another way to help support this site it by visiting the advertiser's website at the top of the page. Spreadsheet Calculations for Appendix Author: Dave Backus Description: Uses the 8-1/2s of May 1997 Last modified by: David Backus Created Date: 2/6/1998 7:38:03 PM. Wastewater Flow Calculations There is no one unique and correct approach to the projection and calculation of sanitary sewer flows within a service area because each service area has its own unique characteristics. Scalable and flexible commercial solutions for office buildings, banks, grocery stores and more. These Excel spreadsheet bundles include process design calculations for MBBR wastewater treatment processes, MBR wastewater treatment processed, SBR wastewater treatment processes, activated sludge design calculations, and several other wastewater treatment processes. MODELING AND OPTIMIZATION OF WASTEWATER TREATMENT PROCESS WITH A DATA-DRIVEN APPROACH by Xiupeng Wei An Abstract Of a thesis submitted in partial fulfillment of the requirements for the Doctor of Philosophy degree in Industrial Engineering in the Graduate College of The University of Iowa May 2013 Thesis Supervisor: Professor Andrew Kusiak. 1 User's Manual. The original excel spreadsheet is pretty easy to use. Wastewater Contamination ongoing as wastewater overflows continue in Quebec, researchers say A new three-year study from Quebec’s Foundation Rivières has found that seven out of 10 municipalities still experience some form of contamination from local. I don’t have experience in calculating demineralized water demand for amine contactor or chemical dilution. Example SNC Calculation for Effluent Violations: Assume a facility has a daily maximum chromium limit of 2. Phosphorus Removal - Operations and Spreadsheets Wisconsin Wastewater Operators Association 45. : Project #11010 ESQ August, 1971 For sale by the Superintendent of Documents, U. Eaves Drainage gutter sizing and pipe calculator for cast and contemporary gutter types; Slotdrain surface water drainage calculator; Note: The Alumasc range of calculation tools on the Drainage software are based on BS EN 12056 and it is your responsibility to ensure that the data has been correctly interpreted. 25 fps, or greater, bottom scour begins to occur. For wastewater analysis, it opens up possibilities for many more sophisticated statistical analyses, such as modelling variability over time or allowing consumption of a drug to be simultaneously informed by concentrations of multiple DTRs. Box 1105 Richmond, VA 23218 (804) 698-4000. Spreadsheet version of the OFT – Computer-based version simplifies determination of directional setback distances. Stay Be positive, Be Happy, Build and make Beautiful our Countries. This tool calculates the energy efficiency and energy performance of water (& waste-water) pumping facilities. The average weight of one inch length of fibre, expressed in micrograms(0. Wastewater calculation Wastewater calculation. xls Spreadsheet Templates and Tools: 7: Sep 20, 2013: R: Loading Capacity of Hazardous Lithium. 01 MGD or larger flows into existing sanitary. units for a very reasonable price in our spreadsheet store. 1 cu ft [of water] = 62. The activated sludge process is very widely used for biological wastewater treatment. 00640 m 2) A = 0. Steel (structural beams, steel in concrete). 2 The terms "tunnel" or "tunnel system" refer to the system downstream of the drop structure. Feed Value Calculator Spreadsheet Calculates value of forages and concentrates using Petersen's constants; based on the price of corn, soybean meal, and average quality alfalfa hay. 746 Q h c / (3960 μ p μ m ) (1) where. Wastewater Pump Station Design Spreadsheet The Excel spreadsheet uses the input data to calculate the design value of. A readily apparent advantage of using hydraulic SRT is the elimination or reduced need. along with several worked examples illustrating the calculations. (Free Calculation Spreadsheet) Dede Arpendo on compressor Chemical Engineer Chemical engineering City gas Cooling tower design of shell and tube heat exchanger domestic wastewater energy audit energy audit in indonesia energy conservation. These equations predict that a pump that produces 100 GPM at 30 feet of head and requires 1 BHP will have an overall efficiency is 75. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. Proponents must provide the City with the expected peak wastewater flows for the proposed development. Virginia Department of Environmental Quality P. for Water Turbulance & Short Circuiting Density vs. The spreadsheet operates on Microsoft Excel 2003 or later. Friction loss refers to the loss of pressure produces in a pipe or duct flow due to the fluid's viscosity produced at the surface layer of the pipe, which is independent of the type of pipe material. You can enter up to eight flow and head points from a 60 hz performance curve and then view its operating curves from 30 to 60 hz. 4th Quarter 1996 SNC Calculations Chronic Effluent Violations SAMPLE DATED 7/5/96 8161960 9/5/96 1019196 - 11/7/96 12/7/96 1/5/97 2/7/97 3/5/97. Estimation Excel Sheet. If you’re looking for a shorter review, try our intermediate water math book or advanced wastewater book. The original excel spreadsheet is pretty easy to use. Operators at different […]. Then, select the entire spreadsheet (by clicking the box in the upper left corner that joins the column and row labels). The prediction of maximum adsorption, qm by excel (59. making this calculator quite vers. (examples are provided). Each spreadsheet is self contained and very easy to follow. Every filter is rated for a maximum pressure of operation; therefore it is very important to have an accurate measurement of maximum pressure when sizing and selecting a filter. Hand Calculations – How To and How Not To – Rev 2 File: PVE-3285, Last Updated: Sept 15, 2016, LRB. It was a $99 piece of. Tank emissions can be an extremely challenging to calculate - with a vast array of physical factors and calculations to take into account, and with EPA TANKS 4. Examples: 8:54 am (8--colon--54--space--am). Target hydraulics assumes no liability for errors in data nor in safe and/or satisfactory operation of equipment designed from this information. These spreadsheets were developed using Microsoft Excel 2007; the spreadsheets may not function as intended in previous versions of Excel. To download, simply right click on the file of your choice and choose "save target as" and choose a location on your hard drive or network to save the file. How to Use the Calculators: SCF. Activated sludge waste water treatment calculations are made easy in U. Dorn Last modified by: Bob Julian Created Date: 5/3/2000 7:09:31 PM Company: Hydro-Flo Technologies, Inc. ("Stan dard Per Capita Method" for projecting future water demands for Public/Private Water Systems serving less than 3300 people or withdrawing less than 330,000 gpd. The accurate and sensitive PID control system could treat most problem and disturbances in the normal operation of the water treatment. & Troy Casey, E. Then, type in a quantity of water use in the box provided. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required. Our NPV calculator will output: the Net Present Value, IRR, gross return, and the net cash flow over the entire period. Select the calculator you want, then press GO! Select your Calculator - then press GO! Temperature Calculator ( C to F) Tank (or clarifier) Volume Calculator Removal Efficiency (wastewater) F/M (wastewater) Ratio Calculator. APPLIED DRINKING WATER MATH FORMULA SHEET AND CONVERSION FACTORS 12 in = 1 ft 27 cu. Jerry Tyler1 January , 20002 The Wisconsin mound wastewater soil treatment system was developed in the 1970s to overcome some limitations of in-ground trench and bed units and the Nodak system (Witz, 1974). 2555 West Copans Road • Pompano Beach, Florida 33369 • 954-831-0745 • FAX 954-831-0798/0925. Total population at SLIET = 10,000. Watch the video below and learn how this type of wastewater math problem is solved. Mastering the basic Excel formulas is critical for beginners to become highly proficient in financial analysis Financial Analyst Job Description The financial analyst job description below gives a typical example of all the skills, education, and experience required to be hired for an analyst job at a bank, institution, or corporation. This Excel spreadsheet can be used to calculate the required MBBR tank volume and dimensions, based on user input media information and wastewater design flow and characteristics. Calculate required flow for metering pump based on solution strength and desired chemical residual. (Free Calculation Spreadsheet) Dede Arpendo on compressor Chemical Engineer Chemical engineering City gas Cooling tower design of shell and tube heat exchanger domestic wastewater energy audit energy audit in indonesia energy conservation. 34 lbs / gal 8. Calculations for the design of storm drain inlets. lb/gal of TSS = Solids Loading ratio of TSS per day (24 hr period): Solids Loading ratio of TSS per hour (lb): Solids Loading ratio of TSS per min (lb); CRITERIA: You must apply the following when sizing a DAF. FULL version: Soakaway Design Spreadsheet to BRE 365 (1. Madison, Wisconsin Wastewater Treatment Plant6 Hydraulic SRT uses a simple calculation which relates the waste sludge flow rate to the influent wastewater forward flow rate, the clarifier recycle ratio and the volume of aeration tanks in service. Disinfection Compliance Calculator Spreadsheet User Guide The disinfection compliance calculator spreadsheet includes four separate tabs. We use cookies to provide you with the best possible user experience. Just put in the sq. Created Date: 2/13/2006 9:43:39 PM Company: Brunswick County, NC Public Utilities Other titles. Enter the data in the non-shaded areas only. Nutrient Calculator (QuattroPro8. In order to test …. We also have Online sales of a wide range of groundwater sampling equipment including YSI 556, and Solinst Levelogger including software such as MODFLOW, RBCA Tool Kit, Hydrus, Surfer 9, and Groundwater Vistas. Learning Objectives At the conclusion of this course, the student will. The Montana Department of Environmental Quality Subdivision Program reviews divisions of land comprising less than 20 acres, as well as condominiums and recreational camping vehicle and mobile home parks, regardless of the size of the parcel where they are located. MDL Calculator Spreadsheet used to calculate initial and/or on-going MDL. View our system specifications below as well as our complete on-site services and documentation. Featuring automated design & analysis capabilities; true, energy-based HGL calculations; user definable design constraints and more. 34 lbs / gal 8. Users get familiar and versatile modelling. This can aid the permittees in record keeping as well as determining results to enter onto report forms. BOD Calculator [Excel Spreadsheet] CBOD Calculator [Excel Spreadsheet] PolyTox Calculator [Excel Spreadsheet] How to Use the Calculators: Blanks. 300(8)(b) prior to placing the system in operation. 2008: Orifice sizing to obtain desired vena-contracta pressure. I N S T R U C T I O N S. References. It is an attached growth biological wastewater treatment process. Today, we’re going to look at how to calculate the MCRT (Mean Cell Residence Time). agriculture engineering. • This calculator is applied in a case study for a 500 kWe farm-fed AD unit. These sections request information on the quality and quantity of the wastewater, chemicals used in the wastewater treatment process and the design and sizing calculations of the treatment units. The overall procedure for design of the storm water drainage system is discussed, along with the design criteria used for the storm sewer section between adjacent manholes. During this COVID-19 pandemic, Pentair global operations and supply teams are working diligently to help ensure our valued customers are getting the best possible service and delivery during this time. How The Electronic Spreadsheet Revolutionized Business At the beginning of the personal computer era, a student in Boston dreamed up the first electronic spreadsheet. Undergraduate Water & Wastewater Treatment Courses with Text & Images INTRODUCTION TO WATER & WASTWATER TREATMENT (ENV 110) - Rosa-lee Moore. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. The below is the example of a footing. Beneficial to professionals and college students alike, Engineering with the Spreadsheet is an indispensable resource for structural engineers. Disinfection Compliance Calculator Spreadsheet User Guide The disinfection compliance calculator spreadsheet includes four separate tabs. Activated sludge waste water treatment calculations are made easy in U. Please note that all formulas in the operators reports and spreadsheets should be checked manually to insure proper calculations before submitting. Weld Cost. 06 Wastewater Billing Fee. Group * Energy crops Root crops, grain, seeds Vegetables Fat, oil Animal residues Food-industry waste. 7 percent at that flow point. xls Spreadsheet Templates and Tools: 7: Sep 20, 2013: R: Loading Capacity of Hazardous Lithium. VENTURI INJECTORS. OpenFlows CulvertMaster software helps engineers design new culverts and analyze existing culvert hydraulics. units for a very reasonable price in our spreadsheet store. Background: ‘back-calculation’ of drug consumption using DTR concentrations. Design of WTP. The design engineer is encouraged to use his own initiative. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required. 2 Design of an anaerobic digester [Manohar 1999] In the present studies, design of an upflow anaerobic sludge blanket (UASB) type digester has been undertaken for treatment of SLIET waste-water. Denier (Man-Made Fibres): Weight in grams per 9000 meters of fibre. ----- DESIGN GUIDES FOR BIOLOGICAL WASTEWATER TREATMENT PROCESSES by THE CITY OF AUSTIN , TEXAS and CENTER FOR RESEARCH IN WATER RESOURCES Environmental Health E. Use our XLC add-in for Excel to display cell formulas as easily readable mathematical equations. All areas may not be covered on any one exam, nor does the outline necessarily include all topics, which may appear on an exam. Electrical tools (MS Excel Spreadsheets) This section is dedicated to tools every electrical engineer can use in daily work. Xylem's prefabricated wastewater and sewer pump stations are rated for reliability, efficiency, and ease of use. It is estimated that less than 200 gallons of wastewater flowed off of the plant site and soaked into the ground and no surface waters of the state were affected. CETCO makes no warranty of any kind and accepts no responsibility for the results obtained through the application of this information. FINANCE This sheet simplifies use of spreadsheet financial functions. All available AGA Calculations are combined into one easy-to-use DLL. The amount of air in soil depends on the size of soil particles. These sections request information on the quality and quantity of the wastewater, chemicals used in the wastewater treatment process and the design and sizing calculations of the treatment units. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. The constant (3,960) converts the product of flow and head (GPM-feet) into BHP. Then, select the entire spreadsheet (by clicking the box in the upper left corner that joins the column and row labels). take you from the examples to the EPA procedure. The larger of the two calculations must be used to balance both the annual runoff and delivered nutrients. Wastewater Executive Support. Wastewater Averaging Home | Wastewater Averaging FAQs | Find Your Wastewater Averaging Period Instructions: Only enter information for the cells in green (also notated by *). Chemical Preparation and Operating Parameters Calculator CHEMICAL PREPARATION – Enter required information in the highlighted cells below English Metric Water Volume GAL Liters Cu Meters Weight of Water LBS KG Percent Dilution % Specific Gravity of Chemical Volume of Chemical Required GAL ML Liter Weight of Chemical Required …. Other titles: API Calculations Viscosity Calcs. 310 mg/g) were very similar to MATLAB (59. Tom Crouse. All other fields have formulas that will automatically calculate the remainder of the data. Stormwater Studio was built to be intuitive, clear, and easy to use. Design of WTP. Wastewater Lagoon Seepage Testing. This check should return a value of 0% if cations and anions are perfectly in balance, although it is accepted that values between ± 10% are satisfactory for this test. Wastewater Technology Fact Sheet Sewers, Force Main DESCRIPTION Force mains are pipelines that convey wastewater under pressure from the discharge side of a pump or pneumatic ejector to a discharge point. Commercial Solutions. This spreadsheet solving the Hantush (1967) equation for ground-water mounding beneath an infiltration basin is made available to the general public as a convenience for those wishing to replicate values documented in this report or to calculate values based on user-specified site conditions. A spreadsheet tool and explanatory manual have been developed by CSIRO to help wineries establish the operating costs of current and alternative winery wastewater treatment systems. (“Stan dard Per Capita Method” for projecting future water demands for Public/Private Water Systems serving less than 3300 people or withdrawing less than 330,000 gpd. Power generated by the solar panels is used by the fridge etc with any surplus fed to the battery until the battery is 100% charged. Superiority of Mazzei injectors is due to the unique, patented design which maximizes injector efficiency, suction capacity and mixing capabilities. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. With this diameter, velocity and flow rate calculator, you can determine the exact flow rate or velocity at which water will flow through any given pipe. Find practical tips, wastewater news, industry updates and product reviews. txt Activated Sludge Waste Water Treatment Calculations with Excel. The following technical report describes the different design equations together with the design calculations for the physical and biological treatment of a municipal wastewater treatment plant. Design of WTP. biological wastewater treatment technologies Activated-sludge system The activated sludge system consists of two components, an aerator, where cells (X) consume the sewage (S), and a clarifier, where cells are then removed from the treated water. Net Positive Suction Head Calculator. I made this video to better visually explain the role of a clarifier in a wastewater treatment plant. The formulas are organized by processes and can be used to assist in daily lab work, process troubleshooting, and many other purposes. have develop a compendium of CalcEdge applications for the water and wastewater industry. Ref 1 Wastewater Engineering Treatment and Reuse, Metcalf and Eddy: 4th Edition Ref 2 Biological Wastewater Treatment, Grady,Daigger, Lim:2nd Edition Ref3 Phosphorus and Nitrogen Removal from Municipal Wastewaterm Principles and practice, 2nd edition, Richard Sedlak Calculations SECTION 1 - A-BASIN DESIGN CRITERIA DESIGN CRITERIA A-Basin Temp. Evaporation loss = 0. The soil makes the final treatment of the wastewater. This friction loss calculator employs the Hazen-Williams equation to calculate the pressure or friction loss in pipes. Revised 9/15 Basic Water Treatment Math Formulas for Surface and Well Exams These formulas are intended to serve as a general resource and are not intended to be an all‐inclusive list. JEA Water and Wastewater Standards is responsible for approval of materials and the design standards used in the construction of its water and wastewater infrastructure. 1 iPhone, iPod touch, and iPad application allows you to perform comprehensive minimum ventilation calculations for a wide variety of commercial buildings based upon Standard 62. the houes is g+1. Wastewater Technology Fact Sheet Sewers, Force Main DESCRIPTION Force mains are pipelines that convey wastewater under pressure from the discharge side of a pump or pneumatic ejector to a discharge point. Home Inventrory. We provide the resources you need to continue to learn and the tools you need to do your job well. In designing a sewer system, the designer must conduct preliminary investigations,. 608 USGPD Formula: (main_flow * residual) / (concentration). The ASHRAE 62. Using our spreadsheet may decrease the time it takes the agency to review your project. xls' Excel spreadsheet that accompanies each copy of the 62. How To Size A Pump Example 200911. Wastewater Executive Support. The Headworks Analysis (HWA) calculates the flow and pollutant treatment capacity of a wastewater treatment plant (WWTP). ----- DESIGN GUIDES FOR BIOLOGICAL WASTEWATER TREATMENT PROCESSES by THE CITY OF AUSTIN , TEXAS and CENTER FOR RESEARCH IN WATER RESOURCES Environmental Health E. Nitrate Calculator Spreadsheet Automates calculation of nitrate intake from feed and water, suggests ways to limit nitrate intake, and converts expressions of nitrate concentration. USGS Regression Spreadsheet (xls 235 kb) Inlet Spacing Analysis Spreadsheets. Can be extended with aeration. Ability to:. Calculate required flow for metering pump based on solution strength and desired chemical residual. Commercial Solutions. We use cookies to provide you with the best possible user experience. By inputting the major design criteria, you can solve for overall DAF sizing based on fluctuating solids loading. User's Manual for Spreadsheet version Step-by-step instructions for using the spreadsheet; OFT Spreadsheet (. If you continue browsing the site, you agree to the use of cookies on this website. • This calculator is applied in a case study for a 500 kWe farm-fed AD unit. Operations and Spreadsheets Wisconsin Wastewater Operators Association 46. Solving For Biochemical Oxygen Demand. Cross out anything “given” that has nothing to do with solving the problem. Cost and Energy Requirements 9. For businesses interested in combining the power of spreadsheet analysis with their process data, OSIsoft offers PI DataLink. This calculator may also be used to determine the appropriate pipe diameter required to achieve a desired velocity and flow rate. SCADACore’s Online AGA Gas Flow Calculator allows users to calculate flow through an Orifice Meter for free online. The wastewater lift station design standards include design criteria and Standard Drawings. Spreadsheet for Calculating Kfs for Constant Head Permeameters (single ponded height method) $ 49. The discharge calculator computes the effluent properties at the discharge point. TNTC Calculation. 4 lbs/ft 3. Velocity = At 1. By Ronald G. com - Perform hantush water mounding calculations online. 34 =Lbs Loading. [date, time, initials of sampler, preservation, location, sample type, wastewater flow etc. This e-book provides background information about the MBR (membrane bioreactor) wastewater treatment system and detailed discussion of process design calculations for this process. 2 m3/day Wastewater flow rate (Maximum)=106. A water balance is a very simple calculation to balance all the inputs affecting a wastewater system and all the outputs returning the hydraulic load (the water) to the hydrologic cycle. Wastewater Neutralization Calculations with an Excel Spreadsheet. Learn More. 44 m3/day Wastewater treatment plant designed flow rate : 150 m3/day 2. ; Hm = Hydraulic pressure loss network expressed in m. This NebGuide discusses recommended practices for the design and construction of lagoon systems for treatment of residential wastewater to help homeowners better understand procedures used by certified onsite professionals. Wastewater Pump Station Design Spreadsheet Author: John Nichols (Brunswick County)/Mike Johnson (McKim & Creed) Description: 3-20-2009 (1st release of Approved spreadsheet) Last modified by: William L. My JEA Utility Tracker helps you track your daily electric and water consumption and provides savings tips specific to your home. In the ideal case, the cold water temperature will be equal to the wet-bulb temperature. 2 Design of an anaerobic digester [Manohar 1999] In the present studies, design of an upflow anaerobic sludge blanket (UASB) type digester has been undertaken for treatment of SLIET waste-water. These applications are specifically tailored to the operation and troubleshooting of water and wastewater operations as well as. These sections request information on the quality and quantity of the wastewater, chemicals used in the wastewater treatment process and the design and sizing calculations of the treatment units. Includes 53 different calculations. Phosphorus Removal – Operations and Spreadsheets Wisconsin Wastewater Operators Association 45. now after seeing some site on foundation design she is worried. Pumps or compressors located in a lift station provide the energy for wastewater conveyance in force mains. Employees can track job or shift codes, break times, and remaining hours such as overtime, sick time, and vacation. The energy E in kilowatt-hours (kWh) is equal to the power P in watts (W), times the time period t in hours (hr) divided by 1000:. It is also possible to include different expanding array of configurations and various operational modifications to meet the effluent. All other fields have formulas that will automatically calculate the remainder of the data. 0 cfs of flow. & Troy Casey, E. Molly has 3 jobs listed on their profile. This procedure allows individual polymers to be compared on such criteria as floc formation, settling characteristics, and clarity. Disinfection Compliance Calculator Spreadsheet User Guide The disinfection compliance calculator spreadsheet includes four separate tabs. 2 Correction Factor (0. Disclaimer: The above estimated calculations do not include loss of material to formation, washouts, improper mixing, etc. To use the calculator, select (using the buttons below) your service type, meter size, and whether booster charges apply. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. Home Inventrory. In this section, you will find easy-to-use Excel Timesheet Templates to calculate OVERTIME. > Metropolitan has been using the USGS program to calculate saturation index (SI) for our waters. Ideally, a water softener should be sized so that it does not regenerate any more often that every three days (wastes water and salt), nor go longer than 14 days before regenerating (can cause compacting of resin, and fouling with sediment or iron). Ohio EPA's Operator Certification program has certified more than 12,000 operators, ensuring public water and wastewater systems are operated by properly trained and qualified individuals. Interactive spreadsheet to compute the geometric mean on a set of numbers to assist with completion of discharge monitoring reports (DMR) for domestic wastewater facilities. 4 lbs/ft 3 CLASS II WASTEWATER MATH FORMULAS (Also use Class I formulas and Conversion sheet) 12. Tank emissions can be an extremely challenging to calculate - with a vast array of physical factors and calculations to take into account, and with EPA TANKS 4. 00 KB: Download: BOA PC Dates and Deadlines. Hampton Roads is served by separate sanitary sewer systems which means runoff from rainfall does not flow to the wastewater collection system. This Excel spreadsheet, as well as others for wastewater treatment calculations, is available in either U. I don't have experience in calculating demineralized water demand for amine contactor or chemical dilution. Wastewater Flow Calculations There is no one unique and correct approach to the projection and calculation of sanitary sewer flows within a service area because each service area has its own unique characteristics. MnTAP partners with POTWs to alleviate concerns with wastewater loading by industrial users. Let’s calculate each component. in the first floor rcc slab roof is provided. Infiltration Rate Calculation. Description: This sizing calculation tool has been designed to assist UNHCR and WASH actors correctly size septic tanks in displaced settings taking into account numbers of users, wastewater and sewage flows, sludge and scum accumulation rates, desludging periods, liquid retention times, and average annual ambient temperatures. The velocity of the water is 3. Date: June 28, 2011. Downloading worked solutions from our Repository gives you a head start in solving technical problems. However, conventional treatment was replaced by proprietary treatment agent called a QUASIL which was found to be more effective for a wide range of pH. 3 Before treatment: 0. Stormwater Studio was built to be intuitive, clear, and easy to use. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. Biogas calculator To use our calculator, specify the group, type and quantity of raw material and click the "Calculate" button. Aerobic microbes need air to survive. The amount of air in soil depends on the size of soil particles. CHAPTER 6 Groundwater Recharge This chapter presents the standards, data, and procedures necessary to meet the groundwater recharge requirements of the NJDEP Stormwater Management Rules at N. Date Last Issued: October 8, 2008. FINANCE This sheet simplifies use of spreadsheet financial functions. 2 m3/day Wastewater flow rate (Maximum)=106. Annual Conference La Crosse, WI October 5, 2011. To do this in Excel, choose: Tools / Protection / Unprotect Sheet. These spreadsheets below will make your job much more easier, alowing you to shorten the time used for endless calculations of cables, voltage drop, various selections of circuit breakers, capacitors, cable size and so on. Using this energy calculator you may determine approximately how much energy an Apricus AP evacuated tube solar collector will produce each year. Read chart vertically until you intersect the correct curve, then read the chart horinzontally … Continue reading Fixture Counts. Regards, Jianwei March 3, 2015 at 12:16 AM. Example Calculations Evaluation for Fine Bubble Aeration System Revision Date 6/10/02 9:52 Red Valve Representative Red Valve Company, Inc. We provide the resources you need to continue to learn and the tools you need to do your job well. 1 The term "collection system" as used in this monograph generally refers to the wastewater or storm-water collection system providing flow to the drop structure. What is Net Present Value? The definition of net present value (NPV), also known as net present worth (NPW) is the net value of an expected income stream at the present moment, relative to its prospective value in the future. As is well known, by its means, suspended-growth microorganisms are applied …. Electrical Electronics Excel Calculators. 18, indicates that the wet well shall be sized so that the cycle time for each pump will not be less than five minutes or that the average cycle time will not be more than 30 minutes. 0 no longer a viable option. Note: At present, these worksheets are available for energy and water projects. • It is developed to support operators in the day-to-day and long-term unit operation. Weld Cost. 15a ncac 02t. Free Engineering Spreadsheets. Large flats were filled with seawater and natural evaporation from the sun evaporated the water and left behind dry salt. I don't have experience in calculating demineralized water demand for amine contactor or chemical dilution. Minimum operating pressure is not a requirement for all types of filters, but it is important when using an automatic, self-cleaning filter for your application. org and Google Sheets. txt Activated Sludge Waste Water Treatment Calculations with Excel. This procedure allows individual polymers to be compared on such criteria as floc formation, settling characteristics, and clarity. Our hydraulic analysis software allows piping engineers to design, analyze, and solve complex pipe networks to find flow rates, pressure losses and pump head requirements. • Writing Formulas Using: - Sum, Average, Round • Freeze Panes - Easier viewing in large spreadsheets • Creating Trend Graphs - Allows for Viewing Trends in Large Sets of Data • Examples in Excel for Each Upcoming Problem Set. Group * Energy crops Root crops, grain, seeds Vegetables Fat, oil Animal residues Food-industry waste. In some cases, it may be just a matter of keeping a record of information about software and hardware that you purchase. Spreadsheets for MBBR Process Design Calculations. Hampton Roads is served by separate sanitary sewer systems which means runoff from rainfall does not flow to the wastewater collection system. Losses are calculated on the basis of flow rates in circular pipes, the internal diameter of the pipe, the length of the pipe, and the type of pipe. Virginia Department of Environmental Quality P. Learning Objectives At the conclusion of this course, the student will. 2711 Rise Rate of Oil Droplet (gpm/ft2) -. The first is a CT-based calculator that can be used to determine whether a community is in compliance with existing CT-based disinfection requirements. 18, indicates that the wet well shall be sized so that the cycle time for each pump will not be less than five minutes or that the average cycle time will not be more than 30 minutes. 785 l = 1 gal. Traveling Gun Calibration Spreadsheet. Calculations for the design of storm drain inlets. 0 no longer a viable option. ppt: wastewater design calculation. Trip Generation, 8th Edition Spreadsheet. The advantage of computer aided design of wastewater treatment plant is an easy way to repeat the design calculations with different sets of input data and optimal size of the system may be obtained. Calculations are setup for monthly or annual payment determination, present value for monthly or annual payment series or lump sum, future value for monthly or annual payments or lump sum ,present worth of a string of uneven cash flows, and various methods for depreciation. Aerobic microbes need air to survive. Spreadsheet Advantage is an Excel add-in designed to assist users and developers of Excel spreadsheets. Includes 53 different calculations. I don’t have experience in calculating demineralized water demand for amine contactor or chemical dilution. Ideally the on-site manhole shall be located within the fenced area. Perhaps the easiest way to visualise what is meant by water balance is to think of our wastewater system as a bucket as shown in Figure WB1. CHAPTER 1 INTRODUCTION. Re: Hydro Test Safe Distance Calculation 11/18/2014 2:13 AM If you search precisely in internet, you can find an excel sheet prepared by someone to calculate the safe distance for both hydrostatic test and pneumatic test based on Lloyd's register (96-02) T-0240. USGS Regression Spreadsheet (xls 235 kb) Inlet Spacing Analysis Spreadsheets. , to have the same values [2] as the soil). Managers can then use the Excel timesheet to calculate total time for payroll. Sizing of UASB (Upflow Anaerobic Pond) for Wastewater Treatment Plant. I would like to share with you simple Excel spreadsheets that we developed for doing descriptive statistics of wastewater treatment plant performance. Wastewater Calculation Spreadsheets - download these interactive worksheets, courtesy of MPCA All Excel spreadsheets were developed by MPCA Training & Certification Unit - December 2009 *Spreadsheet Instruction Sheet - for files listed below * Pond Discharge Calculation Worksheet * Dilution Ratio Calculation Worksheet. sanitary sewer manholes which have sewer force mains discharging directly into them shall be fiberglass or poly‐ethylene lined or epoxy lined. This review is limited to sanitation facilities, including the water supply, sewage disposal, solid waste disposal, and storm. 746 Q h c / (3960 μ p μ m ) (1) where. The equation below assumes you also don't have MLVSS data so you can use your MLSS data estimating that the MLVSS is 72% of the MLSS. Estimate of Requirment of Material Excel Sheet. Other Calculators (Exit Site). Date First Issued: January. Most spreadsheets offer a large number of integrated functions (Excel has more than 400). Mage gear/dps calculations spreadsheet I know there are a lot of other similar things, but I never quite found one that suited my needs and desires, so now after working on it on and off since 2015 when I played on Nostalrius, I finally think it's ready to be released to the public. 12 Calculation. Then, type in a quantity of water use in the box provided. Soil is an important component of an on-site wastewater treatment system. WASTEWATER TREATMENT CALCULATORS, SPREADSHEETS (XLS) & COURSES. Ohio EPA's biosolids program regulates the disposal and/or beneficial use of sewage sludge and biosolids generated by non-industrial wastewater treatment plants in Ohio, as well as any sewage sludge or biosolids brought into Ohio by out-of-state, non-industrial wastewater treatment plants. Analyzing Wastewater Treatment Systems: Serving Residential and Commercial Facilities for High Strength and Hydraulic Loading. (See box on Page 3 for the basis of CT log inactivation tables. Flow Conversions: Flow, GPM = ( Q, cfs ) X ( 448. in the first floor rcc slab roof is provided. Nitrate Calculator Spreadsheet Automates calculation of nitrate intake from feed and water, suggests ways to limit nitrate intake, and converts expressions of nitrate concentration. Fink, RGF Environmental Group. Design, Use and Installation of Dosing Siphons for On-site Wastewater Treatment Systems Eric S. Madison, Wisconsin Wastewater Treatment Plant6 Hydraulic SRT uses a simple calculation which relates the waste sludge flow rate to the influent wastewater forward flow rate, the clarifier recycle ratio and the volume of aeration tanks in service. How to Use the Calculators: SCF. The calculation of cooling tower efficiency involves the Range and approach of the cooling Tower. How to Use the Calculators: GGA. This course is intended for civil engineers, chemical engineers and environmental engineers. Recall again, cooling tower makeup water = evaporation loss + drift loss + blowdown. WASTEWATER TREATMENT PLANT OPERATOR TRAINEE Page 2 EXAMPLES OF WORK : (Illustrative Only) (continued) Performs increasingly responsible duties as assigned in the operation of a wastewater treatment plant; May use computer applications such as spreadsheets, word processing, e-mail and database software; May perform incidental tasks, as needed. All spreadsheets use the XL-Viking Add-in to display and audit the calculations. Objective This blog was established to help engineers creating hydraulic profiles for sewage treatment plants. Hampton Roads is served by separate sanitary sewer systems which means runoff from rainfall does not flow to the wastewater collection system. Annual Conference Wisconsin Dells, WI October 11, 2012. Nitrate Calculator Spreadsheet Automates calculation of nitrate intake from feed and water, suggests ways to limit nitrate intake, and converts expressions of nitrate concentration. 6 Use of reclaimed water for consumption is becoming more common, particularly in the fast-growing southwest region of the U. Example calculations and examples illustrating the setup and use of an Excel spreadsheet for making activated sludge design and operational calculations are also included. Ref 1 Wastewater Engineering Treatment and Reuse, Metcalf and Eddy: 4th Edition Ref 2 Biological Wastewater Treatment, Grady,Daigger, Lim:2nd Edition Ref3 Phosphorus and Nitrogen Removal from Municipal Wastewaterm Principles and practice, 2nd edition, Richard Sedlak Calculations SECTION 1 - A-BASIN DESIGN CRITERIA DESIGN CRITERIA A-Basin Temp. This centrifugal pump curve calculator is meant to quickly calculate the different operating conditions when a centrifugal pump is sped up or slowed down. Values for A2, A3, B3, B4, D3, and D4 are all found in a table of Control Chart Constants. Trench Load - Rigid Pipe: Calculate the load on rigid pipe from trench backfill over the pipe. The design engineer is encouraged to use his own initiative. Anaerobic Digester System Enterprise Budget Calculator The Anaerobic Digester (AD) System Enterprise Budget Calculator is intended for dairy owners, AD system industry experts, and AD researchers to be able to easily calculate the economic value of investment under a variety of technology and price scenarios for an AD system. After completing this course you will be familiar with the common variations of the activated sludge process used for biological wastewater treatment and be able to make. Mounding often occurs beneath engineering structures designed to infiltrate reuse water. Ability to:. Functions may also be used in formulas, thus allowing advanced calculations. 4|Introduction to Process analysis Application of the Mass Balance analysis • In a complete-mix reactor, it will be assumed that: 1. Trick of the Trade #1: To find the length of Excavation – Be careful to fully understand what the given dimension are measuring. This app is based upon the '62MZCalc. What is Net Present Value? The definition of net present value (NPV), also known as net present worth (NPW) is the net value of an expected income stream at the present moment, relative to its prospective value in the future. 2 m3/day Wastewater flow rate (Maximum)=106. A variety of wastewater process control strategies, varying in levels of complexity, are currently utilized for process control of activated sludge in wastewater control applications. This Excel spreadsheet tool provides instructions and guidance on how to assist pharmaceutical manufacturers in calculating how to meet predicted no effect concentration values (PNECs) for active pharmaceutical ingredients (APIs) discharged in wastewater from manufacturing operations. Sheet1 2017 Olmsted Township Wastewater Bill Estimate Calculator Monthly Usage Type in usage here →,0. Other titles: Calculation Sheet (Air) Calculation Sheet (Sat. The total pipe length in this case can also include the equivalent length of valves and fittings to account for minor losses. The residential load calculation worksheet calculates the electrical demand load in accordance with Article 220 of the 2017 National Electrical Code. Also, users of all forms should check with their New York State Department of Environmental Conservation and/or local health department representatives and have these individuals approve use of such. Please note that this spreadsheet is currently in DRAFT form. Cross out anything “given” that has nothing to do with solving the problem. Architects, Engineers and other. Project description i. Can you help me improve translations, program, or host these calculators? [Hide this line]. WASTEWATER TREATMENT CALCULATORS, SPREADSHEETS (XLS) & COURSES. Sequencing batch reactors (SBRs), due to its operational flexibility and excellent process control possibilities, are being extensively used for the treatment of wastewater which nowadays is fast becoming contaminated with newer and more complex pollutants. Estimation Excel Sheet. All you need to do is enter the information in RED, and Excel will calculate the hours and pay. This subsection requires the operation of back-up or auxiliary facilities or similar systems when necessary to achieve compliance with the conditions of the NJPDES permit or where required by applicable law or regulation. Spreadsheets have long since been developed to size bioreactors and associated equipment, combined with design methods based on simple expressions developed from models for steady-state conditions, as well as kinetic and stoichiometric parameters. (Hose Volume/14. and Wastewater Operators’ Licensing Act,” N. Design Examples "Mass: pin. Sequencing batch reactors (SBRs), due to its operational flexibility and excellent process control possibilities, are being extensively used for the treatment of wastewater which nowadays is fast becoming contaminated with newer and more complex pollutants. [date, time, initials of sampler, preservation, location, sample type, wastewater flow etc. 999 by MATLAB for copper, lead and cadmium adsorption, respectively onto garden grass. be determined either with a spreadsheet or by plotting V(t) − V(0) and determining the vertical gap between its minimum and maximum values. 48 gallons 4. The spreadsheet now gives a coherent result: Using Functions in Formulas. Pump Calibration Procedure Materials Required: 1. calculator excel spreadsheet engineering calculation fault current Description By inputting some values into fields that have been indicated for you, this spreadsheet will demonstrate how you can simply calculate fault current. DO Analyzer for SOUR Measurement Oxygen Uptake Rate (OUR) is an important wastewater control parameter for activated sludge process carried out using dissolved oxygen analyzer that measures the amount of oxygen used up by the microorganisms expressed in unit time of mg/L (ppm) per hour. Data analysis with a good statistical program isn’t really difficult. MDL Calculator Spreadsheet used to calculate initial and/or on-going MDL. Please specify the largest pipe thickness of the storm sewer run being analyzed. Total Suspended Solids in Water Samples Environmental waters may contain a variety of solid or dissolved impurities. nitrification must be included in the calculation of oxygen requirements for the system. Environmental Protection Agency. 785 l = 1 gal. Hydraulic Calculations Target Hydraulics make a list here for you learn and check when you design your hydraulic system/ hydraulic power pack unit or hydraulic components. •These rules are the base of the current laws in this field TECHNICAL CALCULATION FOR PURIFING WASTE WATER FOR A SBR WASTE WATER TREATMENT PLANT Content: 1. Treatment of Municipal Wastewater. Static process design is widely used in the wastewater industry and is considered normal practice. Many companies that collect data hire spreadsheet operators. xls: wastewater design calculation. Option 2:. How to Use the Calculators: GGA. It explains what considerations are made in the calculations. : Project #11010 ESQ August, 1971 For sale by the Superintendent of Documents, U. Large flats were filled with seawater and natural evaporation from the sun evaporated the water and left behind dry salt. The average grout loss to the formation is 3-9%. calculator excel spreadsheet engineering calculation fault current Description By inputting some values into fields that have been indicated for you, this spreadsheet will demonstrate how you can simply calculate fault current. Calculation of salt in gm = 150 gm of salt per liter of resin* quantity of resin in liters. The Rent vs. hardness NCH NaCl. Phosphorus Removal - Operations and Spreadsheets Wisconsin Wastewater Operators Association 45. The inputs needed include volume of natural gas in standard cubic feet (SCF = 60°F and 14. All spreadsheets use the XL-Viking Add-in to display and audit the calculations. The design standards generally apply to wastewater lift stations pumping up to 5. The soil makes the final treatment of the wastewater. Please note: Electronic Reporting of required SDWA information has not yet been approved by EPA. Inflow and infiltration reduce the ability of sanitary sewer systems and treatment facilities to transport and treat domestic and industrial wastewater. Effective February 10, 2009 ABC Formula/Conversion Table for Wastewater Treatment, Industrial, Collection and Laboratory Exams Alkalinity, as mg CaCO3/L = Sample Volume, mL. Wastewater Executive Support. The Security Warning lets the user know that some active content from the spreadsheet has been disabled, meaning that Excel has prevented the macros in the spreadsheet from functioning. My friends new house was constructed on soft soil. Large flats were filled with seawater and natural evaporation from the sun evaporated the water and left behind dry salt. Phosphorus to be added, lbs/day = [BOD lbs/day x P/BOD (desired ratio)] – (P in wastewater, lbs). Trick of the Trade #1: To find the length of Excavation – Be careful to fully understand what the given dimension are measuring. Designers can verify the minimum pipe angle with the Pipe Angle Calculation Worksheet (xls 217 kb) The Storm Sewer Pipe Sizing Spreadsheet (xls 149 kb) spreadsheet accomplishes a storm sewer design using the rational method as described in the WSDOT Hydraulics Manual. Dilution/Concentration Options 1020 QUALITY ASSURANCE A. Wasting Rate Calculation Worksheet Subject: This form does the calculation of wasting rate in an activateed sludge treatment system Author: Minnesota Pollution Control Agency - Gene Erickson (Gail Skowronek) Keywords: Minnesota Pollution Control Agency,pond discharge,calculation Description. All you need to do is enter the information in RED, and Excel will calculate the hours and pay. Name: Email:. Design of WTP. WWTP Wastewater Characteristics： A. Sivanandan Water Plant Calculation Lime dosage requirement is most important process in Sedimentation Process, to separate the solids from liquid by gravity. Calculate rate of dose, demand and residual values in a water using this free chlorine dosage calculator tool. Here is a 30 sec example of how to use one of our Spreadsheets to find the Needham Crippling Allowable & MS. Lagoons can be round, square, or rectangular with rounded corners. Below is a sample shot of the spreadsheet. 6 Use of reclaimed water for consumption is becoming more common, particularly in the fast-growing southwest region of the U. Winery wastewater online resource kit – an easy to navigate electronic library of reports, factsheets, case studies and spreadsheet calculators. 3 Use Part II to determine a weight-based, sieve analysis for an aggregate sample requiring a washed sieve analysis. By Ronald G. It is also possible to include different expanding array of configurations and various operational modifications to meet the effluent. This friction loss calculator employs the Hazen-Williams equation to calculate the pressure or friction loss in pipes. 2 CEUs) We can offer our courses in new locations, or customer prefered locations. How To Size A Pump Example 200911. 66 * X mcf), $ 48. Design of WTP. Sedimentation is the basic process, whether water and wastewater treatment,. Advanced Design Systems 5 Nutrient R 5. Waste Water Treatment; Resources. CALCULATING THE ESTIMATED WATER FLOW DEMAND IN GALLONS PER MINUTE (G. Wastewater Flow Calculations There is no one unique and correct approach to the projection and calculation of sanitary sewer flows within a service area because each service area has its own unique characteristics. 4 mcf usage), $ - Wastewater Charge - ($68. Target hydraulics assumes no liability for errors in data nor in safe and/or satisfactory operation of equipment designed from this information. edu is a platform for academics to share research papers. ASCE702W Version:2. the houes is g+1. API sizing calculations. Friction loss in pipe is typically measured in the feet or meters head of the fluid. This video explains in (hopefully) easy to understand terms how a wastewater treatment plant operator can use state point analysis to successfully operate a clarifier. Introduction B. For property developments with no on-site land drainage system, peak dry weather flows are required. A new tool from Rockwell Automation allows users to calculate potential savings derived from variable frequency drives to power pumps. Example MBBR Wastewater Treatment Design Spreadsheet An example MBBR nitrification denitrification spreadsheet is partially shown in the two images below. Wastewater treatment by evaporation. This is calculated and collected by the receiving Water Company to recover the cost of carriage to and treatment in their treatment plants (sewage works). Wastewater Contamination ongoing as wastewater overflows continue in Quebec, researchers say A new three-year study from Quebec’s Foundation Rivières has found that seven out of 10 municipalities still experience some form of contamination from local. SUMMARY OF KEY WASTEWATER MATH FORMULAS - Continued Rectangular Horizontal-Flow Grit Chambers: IMPORTANT CONVERSIONS: 1. Feed Value Calculator Spreadsheet Calculates value of forages and concentrates using Petersen's constants; based on the price of corn, soybean meal, and average quality alfalfa hay.