The goals of this assignment are to: 1. Improve your understanding of 1/1 and how flow metering data is used to quantify the infiltration and inflow components of flow. Many communities

are under regulatory demands to evaluate and reduce I/I as an important step towards minimizing sanitary sewer overflows and basement back-ups, so consultants are in need of staff to perform these studies. Develop or hone Excel skills for handling large data sets and presenting graphically appealing data. 2. 3. Practice written communication skills using a real-world problem - another good resume builder and interview handout that you can use. 4. Learning how to read a guidance document and figure out how to implement the guidance using real data. 5. Using critical thinking skills to evaluate what the data that has been collected means. The attached spreadsheet file contains sewer flow data and rainfall data for a sewershed in a City in CT. The data include flow meter and rain gauge output for 15-minute intervals over a 5+ week period during the spring of 2010. From these data, calculate the following: 1. Maximum Weekly Infiltration Rate (MGD) 2. Peak Hourly Inflow Rate (MGD) 3. Average Base Sanitary Flow Rate (MGD) Your deliverable for this assignment is a technical briefing. The target audience for the briefing is the City Council, from which your client, the Director of Public Works (DPW), is seeking funding for additional sewer system investigations. The written briefing will be provided to the Council in advance of their meeting. It will become a public document that will likely be used by the press to report on the Council meeting. Therefore, the general public is also a target audience. Your technical briefing must be factual, brief, and graphically appealing. I anticipate that it will be about 5-6 pages long, including figures and graphs. The presentation should: Describe what infiltration and inflow are and why they are of concern for the City (thus demonstrating to me that you understand the concept and that you can explain it to a non- technical audience). You may use graphics you find on the internet as long as the source is cited.