Meter data testing tool, 1.0 beta

This tool is the result of a project collaboration between DTU Environment, NIRAS A/S and LEAKman partners. In case of questions or inquiries about the tool contact jkir@env.dtu.dk.

Meter data collected in water networks may contain a large proportion of anomalies that decrease the value of the data significantly. Is this also the case for you data?

To try the meter data testing tool, only an Excel file containing timestamps and observations is needed. The first column has to include timestamps and the second column observations. Download an example of a test file here.

The tool includes seven tests that can be used detect coarse anomalies in a data set. For more information on the methodologies behind the tool see here, or see the help text on the ? next to each test.

A default parameter set is proposed when a test has been selected; however, it is possible to fine-tune the parameters by selecting other values in the drop-down menu next to each test.

Select file to upload:

Rounding

To round seconds to minutes, check the box below.
Otherwise leave unchecked.

Round minutes

Tests included

Tick the boxes to include methods and parameters

You can use the default parameter values or change to the desired amount

Duplicate timestamps ?
Illegitimate format test ?
Range test ?	α 1 1.5 2 2.5 3 3.5 4 4.5 5	B 1 1.5 2 2.5 3 3.5 4 4.5 5
Rate of change test ?	λ 1 1.5 2 2.5 3 3.5 4 4.5 5
Flatliner test ?	S 1 2.0 3 4 5 6 7 8 9 10	p 5 10 15 30 45 60 120 180
Timestamp inconsistency test ?	q 5 10 15 30 45 60 120 180	r 1 2.0 3 4 5 6 7 8 9 10
Timestamp drift test ?	c1 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0	p1 1 2 3 4	p2 1 2 3 4	p3 1 2 3 4