Brown and Caldwell Home Page

Brown and Caldwell engineers and scientists are technical and thought leaders in the environmental sector. Meet the people who have been advancing innovation for more than 70 years.
Author      Title/Abstract      

Moving beyond Spreadsheet Spaghetti and Vintage Data - How Cincinnati MSD is Harnessing the Power of Analytics to Improve Business Results
Author: John Shinn, Jr.1*, Don Linn, P.E.1, Samuel Paske, P.E.2; 1 Cincinnati MSD, 2 Brown and Caldwell; * Email:
Date: 4/912
Preprint, AWWA/WEF Utility Management Conference 2012, January 30 – February 2, 2012, Miami, Florida

Imagine a wastewater treatment plant reducing equipment failures by 20% over 3 years (see Figure 5). At the same time, increased condition-based maintenance reduced overall maintenance labor (Figure 11). These are real results, gained in spite of significant operational challenges. MSD faces challenges that are all too familiar to most utility managers: • Aging, deteriorating infrastructure, • A large, complex operation, • Decreasing numbers of staff, and • Improving but under-utilized information systems. The City of Cincinnati’s – Metropolitan Sewer District (MSD) faces these pressures in a consent-decree-driven environment. MSD’s Wastewater Treatment Division is continually improving operational stability with process improvements, energy savings, and automation through a data-driven approach focused on asset reliability, maintainability, and availability. Key to MSD’s approach is mining the vast amount of operational data it has available in its business systems to support better decisions. To overcome “vintage data” and “spreadsheet spaghetti” (Taylor, 2011, is credited for both illustrative terms), MSD defined business-oriented performance measures, improved business processes, implemented a technology tool, and improved datasets to increase the value and insight data brings to daily decisions in three primary ways: 1. Easing information access, 2. Focusing Resources, and 3. Measuring results. The paper describes how performance measures, data analysis tools and improved practices fit into a continuously improving culture and have helped MSD embrace significant change for the better.

This library contains published materials for which copyrights may be owned by entities other than Brown and Caldwell, but which are stored for limited uses by BC employees. Technical papers authored by BC employees generally may be printed and shared electronically with clients and prospective clients outside BC. Technical papers cannot be sold, and technical papers shared outside BC must have proper attribution of the original sponsoring organization or conference where the paper was presented. This attribution is embedded in each technical paper file when it is loaded into this library. Published articles from magazines or trade journals which are stored in this library are FOR INTERNAL USE ONLY and SHOULD NOT be distributed to clients or others outside BC, without express permission of the copyright owner. For questions regarding copyrights associated with any document in this library, or questions regarding copyrights in general, contact the Legal Department.