For our Springfield Office, 2017 is easily our biggest year for flow monitoring to date. Across seven projects, we have upwards of 70 meters in the ground and more than 20 rain gauges across southwest Missouri. TREKK’s field crews work diligently to interrogate and maintain our monitoring equipment and bring in large volumes of data. Our technicians, project managers, and clients are excited to see the data and the story that it tells.
We are often so focused on the final product, however, that we forget the journey the data goes through to be presentable to our clients.
During our first week of flow monitoring, I asked a coworker if I could help with some of the flow monitoring data. I was tasked with formatting data that would be imported into our analyzing software. We could easily spend two or three minutes formatting each file, and I realized we could save time and frustration by automating this process. This led me to start exploring Microsoft Excel macros and I was quickly able to reduce the formatting step to the click of a button. This first step grew into developing three new tools that automate, process and detect errors in the data that we collect.
Upon reflection, I realized that our motto of IMPROVING LIVES has many different applications. By working together with my coworkers, we were able to refine our process and make the job easier by eliminating some of the tedious time spent formatting and processing data. This allows for our technicians to streamline data processing and deliver quality information quickly and accurately to our project managers and to our clients. It is another way that TREKK is IMPROVING LIVES.
-Ralph Hill, Engineering Technician