Agreement - Technical Assistance to Update Spreadsheet - Greeley and Hansen, LLC.

Home Browse Search

Agreement for Professional Engineering Service between City of South Bend, Indiana and Greeley and Hansen LLC October 2019 The purpose of this project is to update the City's Combined Sewer Overflow (CSO) Monthly Report of Operation (MRO) form. This form will be used by the City to report monthly CSOs observed in the collection system to the Indiana Department of Environmental Management (IDEM). CSO Event. Rgpo giM Revise rainfall, overflow volume and duration calculations such that when a rainfall event is carried over to the next day, the results should report as single event in the spreadsheet summarizing overflow volume and duration on the first day of the event instead of splitting into two different events. This change will occur for all the months in the CSO MRO spreadsheet. 2. CSO 045: Update CSO 045 overflow volume and overflow duration calculations to use weir level instead of switching to rainfall data in the CSO MRO spreadsheet. 3. Overflow Events Table: Update the table to display only one overflow event on the first day whenever there is a rainfall event that gets carried over to the next day. This change will occur for all the months in the CSO MRO spreadsheet. 4. Miscellaneous Items: • CSO Reporting (Page 11): Update the table on page 11 to include the formula for the first day of the month so it can display precipitation occurred whenever there is a rainfall event. • CSO Reporting (Summary page): Update the text in summary page to read events instead of days. • CSO 045 Overflow Summary: Update CSO 045 formula to display correct overflow volume, overflow events and overflow duration in the table. CSO MRO Testing: Use May through September 2019 rainfall data and meter data for CSOs 003, 006, 022, 037, and 045 which will be provided by the City for testing the updated CSO MRO spreadsheet for accuracy. Provide a clean version of the spreadsheet after successful testing.