WaterSight - Water Balance Diagram

Product(s): WaterSight
Version(s): 10.00.
Area: Documentation

It is possible to select different type of views by clicking on the buttons located  at the top right corner:

 Water Balance Diagram (this page)
 Water Balance Series
 Water Balance Bar Chart


Displays a "Water Balance Diagram" with the volumes for their respective categories according to AWWA and IWA standards. The water balance diagram is calculated based on the explanation below. The buttons above the diagram control the zones for each the Water Balance is displayed, as well as the period selected

Zones should correspond to isolated areas of the system, surrounded by closed valves and where all inflows and outflows (if exist) must be measured. Zones can include for example DMA (District Metered Areas), pressure zones or operational zones. The configuration of the inflow and outflow sensors as well as tanks levels that may exist inside the zone are configured in the Zones configuration page (at the administration level) by the user.

Regarding the period to analyze, the list allows to select a single month or multiple months for volumes aggregation. 

System Input Volume

Integration along time of the zone flow data (final balance between all inflows, outflows and storage sensors if exist) for the specific month defined by the user. WaterSight uses advanced analytics and machine learning techniques to remove outliers and bad data. The volume is computed for each zone according with the following assumptions:

  • negative zone flow values are ignored/excluded, 
  • flow time series values covered by events categorized as meter failures (manual added by the user or automatically generated by the system and that are assigned to the sensors that enter in the zone balance) are ignored. To know more about how to assign meter failures events please see the following article, under the section "Cleaning Patterns". 
  • for gaps in data smaller than 3 hours, missing values are obtained by linear interpolation of the flow time series
  • for gaps in data bigger than 3 hours, WaterSight estimates the missing data by taking into consideration the pattern (P50) calculated for each zone
  • system Input volume is only calculated if there is at least 75% of the time flow data available for that specific month. If data available is less than 75% for that specific month, WaterSight will not compute the monthly volume and a value of zero will be displayed. 

Revenue Water and Authorized Billed Consumption

These components are automatically calculated from the billings obtained for each zone zone (based on the customer billing files and customer meters characteristics file uploaded at the Administration level). It is important to assure that customer meters information (billings and meters geolocation) is up to date, to assure reliable computations of the revenue water per zone. Ideally, this information should come from the billing system.  

Non-Revenue Water

The difference between the System Input volume and the Revenue Water.

Authorized Unbilled Consumption

This value is defined by the user in the Zones Configuration page, as a percent of billed consumption. If no value is defined by the user, WaterSight will assume zero.

Authorized Consumption

This is a calculated value. It corresponds to the sum of the Authorized Billed Consumption and the Authorized Unbilled Consumption.

Real Losses

This component is calculated based on the minimum nightly flow (MNF) of each zone. The MNF is calculated using statistical analysis, based on the percentile 5th of the zone flow time series. In the Zones Configuration page the user can define a percentage of the MNF that is due to consumption, in order to exclude the minimum nightly consumption from the real losses volume calculation. If no value is defined by the user, WaterSight will assume zero, and a conservative value will be calculated. 

To mention that real losses volumes are being calculated based on a MNF, assuming that the real losses flow (calculated by subtracting the zone MNF to the MNF consumed) obtained during the night period is constant along the day. This is assuming that pressure does not change very significantly along the day for each zone (night day factor is assumed to be 24 hours). Results must be analyzed carefully in case there are significant pressure changes along the day inside a particular zone. In this case the real losses flow can significantly change along the day (usually real losses flow is higher during the night when pressures are higher, and is lower during the day when pressures are lower).

Apparent Losses

This components corresponds to the difference between Water Losses and Real Losses.

Water Losses

Calculated as the difference between Input Volume and Authorized consumption.

Water Balance Data Reliability

Water Balance data reliability and accuracy can be significantly affected due to several factors such as:

  • Customers are not updated or not assigned to the correct zone,
  • Zones balance are not correct (definition of all input, output and storage sensors),
  • Some sensor is/got misconfigured,
  • Boundary valves between zones that are assumed to be closed, and that are in fact opened (field work validation to check the status of all zones boundary valves may be an important task),
  • Water utility is unaware of any large customer with significant consumption during the minimum nightly flow period,
  • Real losses volumes are being calculated based on a MNF, assuming that the real losses flow (calculated by subtracting the zone MNF to the MNF consumed) obtained during the night period is constant along the day. In case zones are regulated by PRV with more than one setpoint for example, results should be analyzed carefully.