Abstract: A method and system control a water distribution network. A database is maintained of prior states based on a residential water demand, a tank level, and an energy tariff. A current state of the water distribution network is determined. Rewards are determined and include a tank level constraint, an energy cost, and a toggle count. A query based model is used to determine a set of control points used to control a first prior state. An RL agent is trained based on the prior states and rewards. The RL agent determines a control setpoint (that changes the pump speed) that maintains the tank level, minimizes the energy cost, and complies with the toggle count. The RL agent determines time slots and selects one of the time slots. Hybrid setpoints are generated to control the water distribution network within the selected time slot.

Abstract: Exemplary embodiments provide a tool that aggregates data from multiple database sources and application programming interfaces. The tool takes the data collected from the sources and applies one or more pre-defined formulas to the data in order to execute enhanced performance calculations. The tool may receive updated data from the sources at defined intervals. Certain data may be provided in real time. The updated data and/or real time data can be used to refine the calculations and provide updated calculations.