Realistic forecasts are based on a sound understanding of the present situation. In order to obtain that understanding, the available monitoring data need to be analysed. As such an analysis is often most conveniently done under MS-Excel, the preprocessing module permits the export of calculated municipal demands to Excel.
Because the historic water demands are based on quarterly billed water volumes, the quarterly volumes had to be split into monthly volumes.
After that has been done, an Excel workbook will open after a brief calculation time and show 3 worksheets named
It will be the task of the user to save this workbook as a file or to discard it.