Automated Reporting Tool for Water Suppliers
The massive amounts of data from sensors, which is usually recorded in a high temporal resolution (up to every second) is challenging for data processing and visualisation. Especially if standard tools like MS EXCEL are used, which are not well suited for such tasks to data import restrictions (e.g. rows per spreadsheet limited to maximum 1 million rows in MS EXCEL 2010) or missing built-in features for data aggregation (e.g. calculating one hour median values from the raw data). In addition operational data often needs to be combined with analytical data (usually with a temporal resolution of days to weeks) for example in order to (1) assess the impact of the plant’s operation scheme (e.g. flow rate) on its performance for reducing specific substances or for (2) calculating substance loads (by multiplying substance concentrations with flow rates)
Within the AQUANES project – in order to address the above challenges for small companies or wa-ter operators – a data visualization and reporting tool was developed with the software R (www.r-project.org), which enables the user to:
-
Explore online and offline data at different temporal aggregation levels (e.g. raw data or 10 minutes median values)
-
Create automated reports not only including the raw (online/offline) data but also with more advanced calculations combining different online and/or offline data (e.g. specific en-ergy demand)
In a first step, the R reporting tool was implemented and tested for the AQUANES site Haridwar, which is used to demonstrate the functionality of the app.
The app is deployed using the free service mybinder.org.
